1. Applications Administration Guide
  2. Loading D&B Data on DB2

Loading D&B Data on DB2

DB2 installations require you to run DB2 IMPORT. You need the following SQL files:

  • imp_update_new.sql (for loading Marketing Data file into S_DNB_UPDATE table)

  • imp_sic_new.sql (required only if loading the SIC file)

  • imp_mrc_new.sql (required only if loading the MRC file)

Note: This procedure assumes that you understand how to run DB2 IMPORT. DB2 IMPORT is described in the DB2 documentation.

To load D&B data if you are using DB2

  1. Verify that the column order of your D&B file matches the column requirements in the SQL file before running the loading script.

  2. Truncate the appropriate staging tables.

    For more information, see the table that describes D&B Data to Delete and Load in the topic Loading D&B Data.

    To optimize loading performance, drop all indexes on the S_DNB_UPDATE table and re-create them after the scripts have completed by using Siebel utilities ddlexp (to back up the indexes before dropping) and ddlimp (to re-create them).

  3. Modify the SQL file as appropriate for:

    • The name of your database

    • The D&B filenames and directory location

    • The database table owner

    • The user ID and password (with loading privileges) that you are using to load the data

  4. Run DB2 IMPORT.

  5. (Optional) After running the import scripts, update the DB2 catalog statistics by executing RUNSTATS on the three tables that received the D&B data (S_DNB_MRC, S_DNB_SIC, S_DNB_UPDATE).