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

Key Members in a Mainframe-Centric Upgrade


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
Describes

@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

@UPGTYPE

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

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