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