Table 56. Production Upgrade Files
|
|
|
|
|
|
job0.txt |
JOB0 |
Prep |
iebupdte |
REXX code and panels |
All |
job1.txt |
VSTG0002 VSTG0020 VSTG0021 VSTG0022 VSTG0003 VSTG0005 VSTG0006 VSTG0040 VSTG0041 |
Prep |
iebupdte |
Generic install.jcl and help panels |
All |
siebin01.jcl |
VSTG0011 VSTG0030 VSTG0031 VSTG0032 VSTG0012 VSTG0014 VSTG0015 VSTG0050 VSTG0051 |
Prep |
iebupdte |
Install.jcl specific to each upgrade path |
All |
siebproc.jcl |
VSTG0070 |
Prep |
iebupdte |
JCL PROC members |
All |
filelist.txt |
VSTG0075 |
|
|
List of files |
All |
dedup.jcl |
VSTG0080 |
Maintenance |
SQL |
ITM/Dedup Remote conflict_id process |
All |
dedup_prod.jcl |
VSTG0081 |
Maintenance |
JCL |
ITM/Dedup Remote conflict_id process |
All |
schema.db.sql |
VSTG0100 |
|
DDL |
Schema databases |
All |
schema.tbsp.sql |
VSTG0101 |
|
DDL |
Schema table spaces |
All |
schema.tbl.sql |
VSTG0102 |
|
DDL |
Schema tables |
All |
schema.grt.sql |
VSTG0103 |
|
DDL |
Schema grants |
All |
schema.uind.sql |
VSTG0104 |
|
DDL |
Non-obsolete and unique index |
All |
schema.nuind.sql |
VSTG0105 |
|
DDL |
Non-obsolete and non-unique index |
All |
schema.oind.sql |
VSTG0106 |
|
DDL |
Obsolete indexes |
All |
scindx.sql |
VSTG0110 |
|
DDL |
File is split into: Drops, EIM, Pre/Post Gen_Primary DDL and Indexes rebuilds |
All |
tmptable.sql |
VSTG0120 |
|
DDL |
Common TMPTABLES (tmptable.ctl) |
All |
tmptable1.sql |
VSTG0121 |
|
DDL |
Source table logging for Unload jobs (no storage.ctl file) |
All |
tmptable2.sql |
VSTG0122 |
|
DDL |
Target table logging for Unload jobs (no storage.ctl file) |
All |
ddlviews.sql |
VSTG0130 |
|
DDL |
|
All |
infdrops.sql |
VSTG0140 |
|
SQL |
Interface/EIM Drops - part of pretftp |
|
siebel.translate.iconv |
VSTG0150 |
|
binary |
Program to convert code pages for each language |
All |
pretedit.txt |
VSTG0200 |
DM-Prep |
JCL (pretldin, pretclob) |
PRET JCL |
All |
pret.jcl |
VSTG0210 |
DM-Prep |
SQL |
PRET SQL |
All |
pret_prod.jcl |
VSTG0211 |
DM-Prep |
JCL |
PRET JCL |
All |
pret_sia.jcl |
VSTG0220 |
DM-Prep |
SQL |
PRET SQL |
SIA621, SIA704, SIA752, SIA77 |
pret_prod_sia.jcl |
VSTG0221 |
DM-Prep |
JCL |
PRET JCL |
SIA621, SIA704, SIA752, SIA77 |
unload.ldc |
VSTG0300 |
DDLIMP |
LDC |
Unload control cards |
All |
load.ldc |
VSTG0310 |
DDLIMP |
LDC |
Load control cards |
All |
preschm.jcl |
VSTG0400 |
DM-Horz |
SQL |
PRESCHM SQL |
All |
preschm_prod.jcl |
VSTG0401 |
DM-Horz |
JCL |
PRESCHM JCL |
All |
preschm.ldc |
VSTG0402 |
DM-Horz |
LDC |
Load control cards for PRESCHM |
SIA621 |
preschm_sia.jcl |
VSTG0410 |
DM-SIA |
SQL |
PRESCHM SQL |
SIA621, SIA704, SIA752, SIA77 |
preschm_sia_prod.jcl |
VSTG0411 |
DM-SIA |
JCL |
PRESCHM JCL |
SIA621, SIA704, SIA752, SIA77 |
preschm_sia.ldc |
VSTG0412 |
DM-SIA |
LDC |
|
|
prod_confirgurator.jcl |
VSTG0500 |
DM-Horz |
SQL |
Prod Configurator SQL |
SIA621 |
prod_confirgurator_prod.jcl |
VSTG0501 |
DM-Horz |
JCL |
Prod Configurator JCL |
SIA621 |
prod_confirgurator.ldc |
VSTG0502 |
DM-Horz |
LDC |
|
SIA621 |
prod_confirgurator_sia.jcl |
VSTG0510 |
DM-SIA |
SQL |
Prod Configurator SQL |
SIA621, SIA704 |
prod_confirgurator_sia_prod.jcl |
VSTG0511 |
DM-SIA |
JCL |
Prod Configurator JCL |
SIA621, SIA704 |
prod_confirgurator_sia.ldc |
VSTG0512 |
DM-SIA |
LDC |
|
SIA621, SIA704 |
upg_iss.jcl |
VSTG0600 |
DM |
JCL |
UPGISS JCL |
All |
upg_iss_prod.jcl |
VSTG0601 |
DM |
SQL |
UPGISS SQL |
All |
upg_iss.ldc |
VSTG0602 |
DM |
LDC |
|
All |
gen_primary1.jcl |
VSTG0700 |
DM |
SQL |
Gen primary part 1 - SQL |
All |
gen_primary1_prod.jcl |
VSTG0701 |
DM |
JCL |
Gen primary part 1 - JCL |
All |
gen_primary2.jcl |
VSTG0702 |
DM |
SQL |
Gen primary part 2 - SQL |
All |
gen_primary2_prod.jcl |
VSTG0703 |
DM |
JCL |
Gen primary part 2 - JCL |
All |
gen_primary3.jcl |
VSTG0704 |
DM |
SQL |
Gen primary part 3 - SQL |
All |
gen_primary3_prod.jcl |
VSTG0705 |
DM |
JCL |
Gen primary part 3 - JCL |
All |
gen_primary4.jcl |
VSTG0706 |
DM |
SQL |
Gen primary part 4 - SQL |
All |
gen_primary4_prod.jcl |
VSTG0707 |
DM |
JCL |
Gen primary part 4 - JCL |
All |
echannel_merge_contact.sql |
VSTG0800 |
DM |
SQL |
eChannel |
SIA621 |
echannel_merge_org_int.sql |
VSTG0801 |
DM |
SQL |
eChannel |
SIA621 |
echannelAccountDivMatch_fins.sql |
Mid-tier |
DM |
SQL |
eChannel |
SIA621 |
echannelEmpContactMatch_fins.sql |
Mid-tier |
DM |
SQL |
eChannel |
SIA621 |
hhmignot.sql |
Mid-tier |
DM |
SQL |
Household |
SIA621, SIA704, SIA752, SIA77 |
hhmigpop.sql |
Mid-tier |
DM |
SQL |
Household |
SIA621, SIA704, SIA752, SIA77 |
Household_Mig_Fins.jcl |
VSTG0852 |
DM |
SQL |
Household |
SIA621, SIA704, SIA752, SIA77 |
Household_Mig_Fins_prod.jcl |
VSTG0853 |
DM |
JCL |
Household |
SIA621, SIA704, SIA752, SIA77 |
Household_Mig_Fins_prod.ldc |
VSTG0854 |
DM |
LDC |
Household |
SIA621, SIA704, SIA752, SIA77 |
rpt_dup_addr_rowids.sql |
Mid-tier |
DM |
SQL |
Gen Dup Addr Report SQL |
SIA621, SIA704, SIA752, SIA77 |
rpt_dup_addr_names.sql |
VSTG0860 |
DM |
SQL |
Gen Dup Addr Report SQL |
All |