25Upgrade Files for Siebel Business Applications
Upgrade Files for Siebel Business Applications
This chapter lists the files that are used to perform a development or production upgrade to the current release of Siebel CRM, and lists the tables that are amended during PRET processing. This chapter contains the following topics:
Siebel CRM z/OS Upgrade Files
When you run the Siebel Upgrade Wizard on the midtier, it generates files that are used to perform the development and production upgrade. You then transfer these files to the z/OS host, where they are placed in staging data sets. Several upgrade files are also generated on the z/OS host.
The following table lists each of the upgrade files that are generated, the name of the file on the midtier (if applicable) and on the z/OS host, the phase of the upgrade when the file is generated, the upgrade path to which the file applies, and a brief description.
Table Siebel CRM z/OS Upgrade Files
| Midtier Filename | z/OS Filename | Phase Transferred to Host | Description | Upgrade Paths |
|---|---|---|---|---|
job0.txt |
JOB0 |
ftp_stg |
Contains REXX code and panels |
All |
SIEBEL.load.xmit |
load.xmit |
ftp_stg |
Load modules |
All |
sbllog.txt |
SBLLOG.LOADFILE |
ftp_stg |
Initial log file entries |
All |
SIEBEL.sp.dbrmlib.xmit |
sp.dbrmlib.xmit |
ftp_stg |
Dbrm modules |
All |
SIEBEL.sp.spddl.xmit |
sp.spddl.xmit |
ftp_stg |
Stored procedure DDL |
All |
job1.txt |
VSTG0000 VSTG0000 is copied into one of the following VSTG* files on the z/OS host, depending on your upgrade path: VSTG0002 VSTG0020 VSTG0021 VSTG0022 VSTG0003 VSTG0005 VSTG0006 VSTG0040 VSTG0041 VSTG0042 |
ftp_stg |
Generic install.jcl and help panels |
All |
siebin01.jcl |
VSTG0001 VSTG0001 is copied into one of the following VSTG* files on the z/OS host, depending on your upgrade path: VSTG0011 VSTG0030 VSTG0031 VSTG0032 VSTG0012 VSTG0014 VSTG0015 VSTG0050 VSTG0051 VSTG0052 |
ftp_stg |
Install.jcl specific to each upgrade path |
All |
siebproc.jcl |
VSTG0070 |
ftp_stg |
JCL PROC members |
All |
filelist.txt |
VSTG0075 |
Pause #1 |
List of files | All |
synctab.jcl |
VSTG0085 |
syncdd |
Table Synchronization | All |
syncidx.sql |
VSTG0087 |
syncdd |
Index Synchronization | All |
schema.staging.db.sql |
VSTG0090 |
ftp_stg |
Staging schema databases |
All |
schema.staging.tbsp.sql |
VSTG0091 |
ftp_stg |
Staging schema table spaces | All |
schema.staging.tbl.sql |
VSTG0092 |
ftp_stg |
Staging schema tables | All |
schema.staging.uind.sql |
VSTG0093 |
ftp_stg |
Staging schema unique indexes | All |
schema.staging.nuind.sql |
VSTG0094 |
ftp_stg |
Staging schema NPIs |
All |
schema.staging.oind.sql |
VSTG0095 |
ftp_stg |
Staging schema obsolete indexes | All |
schema.staging.grt.sql |
VSTG0096 |
ftp_stg |
Staging schema grants | All |
schema.db.sql |
VSTG0100 |
Pause#2 |
Target schema databases | All |
schema.tbsp.sql |
VSTG0101 |
Pause#2 |
Target schema table spaces |
All |
schema.tbl.sql |
VSTG0102 |
Pause#2 |
Target schema tables | All |
schema.grt.sql |
VSTG0103 |
Pause#2 |
Target schema grants |
All |
schema.uind.sql |
VSTG0104 |
Pause#2 |
Target schema unique indexes |
All |
schema.nuind.sql |
VSTG0105 |
Pause#2 |
Target schema NPIs |
All |
schema.oind.sql |
VSTG0106 |
Pause#2 |
Target schema obsolete indexes |
All |
Not applicable |
VSTG1010 This file is created on the z/OS host. It contains CREATE INDEX statements extracted from VSTG0104 and VSTG0105. |
Not applicable |
Generates index REBUILD control statements for the target environment. | All |
Not applicable |
VSTG1111 This file is dynamically built on the z/OS host. |
Not applicable |
Maintains a list of the additive changes that are applied to the staging database. This list is updated dynamically as changes are applied. | All |
Not applicable |
VSTG1112 This file is dynamically built on the z/OS host. |
Not applicable |
Contains the additive changes applied to the staging database during the preupgrade phase. | All |
scindx.sql |
VSTG0110 |
Pause#3 |
DDL for secondary indexes | All |
tmptable.sql |
VSTG0119 |
Pause#2 |
Staging. Common TMPTABLES (tmptable.ctl) |
All |
tmptable.sql |
VSTG0120 |
Pause#2 |
Target. Common TMPTABLES (tmptable.ctl) |
All |
tmptable1.sql |
VSTG0121 |
ftp_stg |
Staging. Logging for Unload jobs and TMPTBL_ADDR table (no storage.ctl file) |
All |
tmptable2.sql |
VSTG0122 |
ftp_stg |
Target. Logging for Unload jobs and TMPTBL_ADDR table (no storage.ctl file) |
All |
drop_view.sql |
VSTG0130 |
ftp_stg |
Apply drop view before Nonadditive | All |
ddlview_sql |
VSTG0131 |
ftp_stg |
Apply create view after Nonadditive | All |
siebel.translate.iconv |
VSTG0150 |
Pause #1 |
Program to convert code pages for each language |
All |
pregen.txt |
VSTG0200 |
ftp_stg |
JCL (genclobf, gentrgd, geneimd) |
All |
pret.jcl |
VSTG0210 |
Pause #1 |
PRET SQL | All |
pret_prod.jcl |
VSTG0211 |
Pause #1 |
PRET JCL | All |
pret_sia.jcl |
VSTG0220 |
Pause #1 |
PRETFINS SQL |
SIA753, SIA77, SIA78, SIA80 |
pret_sia_prod.jcl |
VSTG0221 |
Pause #1 |
PRETFINS JCL |
SIA753, SIA77, SIA78, SIA80 |
unload.ldc |
VSTG0300 |
Pause #2 |
Unload control cards | All |
load.ldc |
VSTG0310 |
Pause #2 |
Load control cards | All |
preschm.jcl |
VSTG0400 |
Pause #1 |
PRESCHM SQL | All |
preschm_prod.jcl |
VSTG0401 |
Pause #1 |
PRESCHM JCL | All |
preschm_sia.jcl |
VSTG0410 |
Pause #1 |
PRESCHMF SQL | SIA753, SIA77, SIA78, SIA80 |
preschm_sia_prod.jcl |
VSTG0411 |
Pause #1 |
PRESCHMF JCL | SIA753, SIA77, SIA78, SIA80 |
upg_iss.jcl |
VSTG0600 |
Pause #1 |
UPGISS JCL |
All |
upg_iss_prod.jcl |
VSTG0601 |
Pause #1 |
UPGISS SQL |
All |
gen_primary1.jcl |
VSTG0700 |
Pause #1 |
Gen Primary part 1 - SQL |
All |
gen_primary1_prod.jcl |
VSTG0701 |
Pause #1 |
Gen Primary part 1 - JCL |
All |
gen_primary2.jcl |
VSTG0702 |
Pause #1 |
Gen Primary part 2 - SQL |
All |
gen_primary2_prod.jcl |
VSTG0703 |
Pause #1 |
Gen Primary part 2 - JCL |
All |
gen_primary3.jcl |
VSTG0704 |
Pause #1 |
Gen Primary part 3 - SQL |
All |
gen_primary3_prod.jcl |
VSTG0705 |
Pause #1 |
Gen Primary part 3 - JCL |
All |
gen_primary4.jcl |
VSTG0706 |
Pause #1 |
Gen Primary part 4 - SQL |
All |
gen_primary4_prod.jcl |
VSTG0707 |
Pause #1 |
Gen Primary part 4 - JCL |
All |
hhmignot.sql |
VSTG0850 |
Pause #1 |
Household |
SIA753, SIA77, SIA78, SIA80 |
hhmigpop.sql |
VSTG0851 |
Pause #1 |
Household |
SIA753, SIA77, SIA78, SIA80 |
household_mig_Fins.jcl |
VSTG0852 |
Pause #1 |
Household |
SIA753, SIA77, SIA78, SIA80 |
household_mig_Fins_prod.jcl |
VSTG0853 |
Pause #1 |
Household |
SIA753, SIA77, SIA78, SIA80 |
rpt_dup_addr_rowids.sql |
VSTG0861 |
ftp_stg |
Gen Dup Addr Report SQL |
All |
rpt_dup_addr_names.sql |
VSTG0860 |
ftp_stg |
Gen Dup Addr Report SQL |
All |
schema.additive.sql |
VSTG1000 |
Pause #1 |
Staging additive changes |
All |
Not applicable |
VSTG1001 This file is a copy of VSTG1000; it is created on the z/OS host. |
Not applicable |
Target additive changes |
All |
Tables Amended During PRET Unload Processing
The unload job control cards for specific tables have been modified so that during PRET (pre-table) processing, the data in the tables is modified during the table unload process instead of being modified after the data has been loaded into the target table.
The following table lists the tables containing the data that is modified during unload processing, the macro that performs the modifications, and the relevant upgrade paths.
Table Tables Amended During PRET Unload Processing
| PRET Tables Modified During the Table Unload Process | Macro | Siebel Business Applications Paths | Siebel Industry Applications Paths |
|---|---|---|---|
S_APPL_WEB_TMPL |
PTH0062 |
Not applicable |
SIA753 |
S_APPL_WTMPL_IT |
PTH0064 |
Not applicable |
SIA753 |
S_CONTROL |
PTH0222 |
All Paths |
All Paths |
S_PCONTROL |
PTS0223 |
HOR753, HOR77 |
SIA753 |
S_FN_CRDT_RPT |
PTS0224 |
HOR753, HOR77 |
SIA753 |
S_ASGN_RULE_GRP |
PTS0225 |
HOR753, HOR77 |
SIA753 |
S_REGION |
PTS0227 |
Not applicable |
SIA753 |
S_REGION |
PTS0228 |
Not applicable |
SIA753 |
S_QTA_OBJCRT_D |
PTH0833 |
All Paths |
All Paths |
S_ETL_TIME_DAY |
PTS0313 |
Not applicable |
SIA753 |
S_ETL_TIME_DAY |
PTS0314 |
Not applicable |
SIA753 |
S_EXTDATA_TBL |
PTS0500 |
Not applicable |
SIA753 |
S_PAPL_WEB_TMPL |
PTS0505 |
Not applicable |
SIA753 |
S_NOTE_CON |
PTM0520 |
Not applicable |
SIA77 |
S_NOTE_PROD_INT |
PTM0520 |
Not applicable |
SIA77 |
S_NOTE_ACCNT |
PTM0520 |
Not applicable |
SIA77 |
S_DOCK_TXN_LOG |
PTM0010 |
All Paths |
All Paths |
S_ESCL_REQ |
PTM0010 |
All Paths |
All Paths |
DSNHLQ.SIEBEL.EXEC or in the VSTG0300 and the VSTG0310 staging data sets.
PRET Members Generated By Pretedit.txt
The Pretedit.txt file creates the partitioned data set (PDS) on the z/OS host that is used for PRET processing. The members in this PDS perform a number of tasks, for example, listing the tables that contain CLOB columns, gathering information required for key processing, and deleting rows in specific tables. Data sets are generated for each upgrade path.
The following table shows the data set members created by the Pretedit.txt file, the objects amended by these members (the SQL statement that is run is contained in the member) and the upgrade path for which these members are generated.
Table PRET Processing Members Created By the Pretedit.txt File
| PDS Member Name | PRET Object Affected | SIA Upgrade Paths |
|---|---|---|
PRETLDIN |
S_DOCK_TXN_LOG |
All |
PRETLDIN |
S_ESCL_REQ |
All |
PRETCLBF |
SQL/CLOB list, used by SBLCLOBU |
All |
PRETKEYS |
SQL/Clustering Index Key structures |
All |
Target Tables Amended During PRET Processing
The PRET upgrade jobs perform operations on the target database tables listed in the following table. You might want to back up these tables before you start the upgrade.
The following table shows the target tables amended by PRET upgrade processing, the type of amendment made, and the upgrade path affected.
Table Tables Changed During PRET Processing
| Tables Amended During PRET Processing | Type of Change Made | SIA Paths |
|---|---|---|
S_FN_CRDT_RPT |
Alter |
SIA753 |
S_REGION |
Alter |
SIA753 |