1. Database Upgrade Guide for DB2 for z/OS
  2. Post Installation Database Update Report

Post Installation Database Update Report

A report called PostInstallDBSetup_<Timestamp>.html is automatically generated after you run the PostInstallDBSetup utility. This report is in HTML format, is located in siebsrvr\log\PostInstallDBSetup_<Timestamp>.html, and provides information about the update including the following:

  • The objects that are delivered out-of-the-box.

  • The seed, schema, and manifest data that was imported as part of the database update process for a monthly update.

  • Any area or step where the PostInstallDBSetup utility fails.

To review the Post Installation Database Update Report

  1. Go to the following location on your local drive: siebsrvr\log\PostInstallDBSetup_xxxxxxxxx

  2. Double click PostInstallDBSetup_<Timestamp>.html to open the report you want to view, where <Timestamp> represents the date and time that the report was generated and is in the following format: YYYY-MM-DD_HR-MIN-SEC.

  3. In the Report console that opens:

    • Click Upgrade Summary to review summary information about all the steps that were run as part of the Post Installation Database Update process. Summary information is available for the following: Parameters, Initialization, WSRanking, SeedSchemaManifest Upgrade, and WorkflowUpgrade. Subcategories that appear under SeedSchemaManifest Upgrade include the following:

      • Initialization. Shows summary information related to initialization tasks and the status of each step (Completed/Failed/Error) in the process. Initialization tasks include validation of parameters, customer's database version, and database connectivity.

      • Schema. Shows summary information related to schema import and the status of each step (Completed/Failed/Error) in the process.

      • Manifest. Shows summary information related to schema and data import and the status of each step (Completed/Failed/Error) in the process.

      • Seed. Shows summary information related to data import and the status of each step (Completed/Failed/Error) in the process.

    • Click Schema to review the names of the tables and columns that were updated out-of-the-box.

    • Click Manifest to review the basic user key information for all S_UI* tables.

    • Click Seed to review all the tables (and user key information) for which seed data was released.

    • Click Troubleshoot to review and troubleshoot errors that occur during Post Installation Database Update.