Table 20. Siebel CRM z/OS Upgrade Files
|
|
Phase Transferred to Host |
|
|
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_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 |