Siebel Database Upgrade Guide for DB2 for z/OS > How the Siebel Database Upgrade Works > Job Flow of a Production Database Upgrade >

Key Members in the DSNHLQ.SIEBEL.EXEC


Members in the DSNHLQ.SIEBEL.EXEC contain useful information that you can refer to when performing your development and production upgrade. These key members are listed in Table 6.

Table 6. Key Members in the DSNHLQ.SIEBEL.EXEC
Member Name
Description

@JOBPRFX

Shows details of the job prefixes chosen for the upgrade.

@LASTJOB

Lists the job name of the last job for each step of the upgrade, for example:

  • PRESCHM:S003562Z
  • PRESCHF: S006463Z

@STGTAR

Lists details of the staging and target environments.

@TBOSTG

Provides staging tableowner details.

@TBOTAR

Provides target tableowner details.

@UPGPATH

Lists the upgrade path and the upgrade status, that is, the last step executed, for example:

PAUSE=4 STEP=98- TARGET UPGISS DATA MIGRATION COMPLETE - UPGISS

@UPGFLOW

Contains details of all the steps in the upgrade.

@UPGTYPE

Shows the type of upgrade being run, for example, SIA 7.5.3

Siebel Database Upgrade Guide for DB2 for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.