Upgrade Guide for DB2 UDB for z/OS > How the Upgrade Works > Job Flow of a Production Database (Mainframe-Centric) 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 mainframe-centric upgrade. These key members are listed in Table 10.

Table 10. 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

@SRCTAR

Lists details of the source and target environments, for example:

  • SOURCE: HOSTNAME=QA02 DB2SYS=Q2F1 TABLEOWNER=CQ2F1001
  • TARGET: HOSTNAME=QA02 DB2SYS=Q2F1 TABLEOWNER=CQ2F1900

@TBOSRC

Provides source tableowner details.

@TBOTAR

Provides target tableowner details.

@UPGPATH

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

PATHID=2 STEP=4 - NEW SIEBEL GP INDEX REBUILD JOBS GENERATED

@UPGTYPE

Shows the type of upgrade being run, for example, SIA753.

Upgrade Guide for DB2 UDB for z/OS