Bookshelf Home | Contents | Index | PDF     

Upgrade Guide for DB2 UDB for z/OS > Production Upgrade Files Generated by the Upgrade Wizard >

Siebel 7.8 Upgrade Files

When you run the Siebel Upgrade Wizard on the midtier, it generates the files that are used to perform the 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. Table 56 lists each of the production upgrade files generated on the midtier, the staging data set name assigned to the file when it is transferred to the z/OS host, the phase of the upgrade when the file is generated, the file type, and a brief description. The upgrade path the file applies to is also listed.

Table 56. Production Upgrade Files
Midtier File Name
Staging Data Set Name
Phase
File Type
Description
Applicable Upgrade Paths

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
    
Upgrade Guide for DB2 UDB for z/OS