LexBuild

Deploy New Data

LexBuild was designed to restore any snap shoot data. This feature can be used to restore latest data to testing LexBuild system for simulation test and generate annual LEXICON. The procedures are described as follows:

  1. Remove illegal lexRecords:

    Sometimes, empty lexRecords are generated and insert into database because users double click on the approval items before the SQL execution is completed. Make sure remove all these illegal lexRecords before generate them into backup files.
    delete from LEX_RECORD where eui = 'E0000000'

  2. Copy latest data from LB:
    • Source: lexBuild:/$BACKUP_DIR/Routine/LexBuild/YYYY/MM_DD_YY
    • Target: lexlx1:/$LEXBUILD_DIR/data/DbTables/Tables

  3. Remove file suffix (time stamp):
    • Program: $LEXBUILD_DIR/Tools/LoadDb/removeSuffix all $LEXBUILD_DIR/data/DbTables/Tables MM_DD_YY_hh:mm

  4. Delete data from DB tables
    • Program: $LEXBUILD_DIR/Tools/LoadDb/DbScript
      1
      1
      6 (drop not delete => faster & cleaner)
      11
      

  5. Create tables in DB tables
    • Program: $LEXBUILD_DIR/Tools/LoadDb/DbScript
      1
      1
      1
      11
      

  6. Load data into DB tables
    • Program: $LEXBUILD_DIR/Tools/LoadDb/DbScript
      1
      1
      2
      11