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