Upgrade Guide for DB2 UDB for z/OS > Production Upgrade Files Generated by the Upgrade Wizard >
Tables Amended During PRET Unload Processing
The unload job control cards for specific source tables have been modified so that during PRET (pre-table) processing, the data in the tables is modified during the table unload process instead of being modified after the data has been loaded into the target table. Table 57 lists the source tables containing the data that is modified during unload processing, the macro that performs the modifications, and the relevant upgrade paths.
Table 57. Tables Containing Data Modified During the PRET Table Unload Process
PRET Tables Modified During the Table Unload Process |
|
|
|
S_APPL_WEB_TMPL |
PTH0062 |
HOR704 |
SIA704, SIA752 |
S_APPL_WTMPL_IT |
PTH0064 |
HOR704 |
SIA704, SIA752 |
S_POSTN_CON |
PTS0100 |
n/a |
SIA704 (FINS704 only) |
S_CONTROL |
PTH0222 |
All |
All |
S_PCONTROL |
PTS0223 |
HOR752, HOR77 |
SIA752 |
S_FN_CRDT_RPT |
PTS0224 |
HOR752, HOR77 |
SIA752 |
S_ASGN_RULE_GRP |
PTS0225 |
HOR752, HOR77 |
SIA752 |
S_REGION |
PTS0227 |
n/a |
SIA 704 (FINS704 only), SIA752 |
S_REGION |
PTS0228 |
n/a |
SIA752 |
S_ENTLMNT_ITEM_FEE |
PTS0270 PTS0271 |
n/a |
SIS704 |
S_CURRCLM_PER |
PTH0289 |
HOR621 |
SIA621, SIS63 |
S_EVT_ACT |
PTH0405 |
HOR621 |
SIA621, SIS63 |
S_QTA_OBJCRT |
PTH0832 |
HOR621 |
SIA621, SIS63 |
S_QTA_OBJCRT_D |
PTH0833 |
All |
All |
S_WF_PROC_FLOW |
PTH1003 |
HOR621, HOR704 |
SIA621, SIS63, SIA704 |
S_WF_STEP |
PTH1006 |
HOR621, HOR704 |
SIA621, SIS63, SIA704 |
S_ASSET_POSTN |
PTS0301 PTS0302 PTS0303 PTS0304 |
n/a |
SIS 704 only |
S_ETL_TIME_DAY |
PTS0313 PTS0314 |
n/a |
SIA752 |
S_DD_MEAS_ATTR |
PTS0350 |
n/a |
SIS63 |
S_UPG_KIT_IARG |
PTS0360 PTS0361 |
HOR704, HOR752, HOR77 |
SIA704(SIS + FINS), SIA752, SIA77 |
S_CON_ADDR |
PTM0410 |
n/a |
SIA621, SIS63, SIA704 |
S_EXTDATA_TBL |
PTS0500 |
n/a |
SIA752 |
S_PAPL_WEB_TMPL |
PTS0505 |
n/a |
SIA752 |
S_NOTE_CON |
PTM0520 |
n/a |
SIA77 |
S_NOTE_PROD_INT |
PTM0520 |
n/a |
SIA77 |
S_NOTE_ACCNT |
PTM0520 |
n/a |
SIA77 |
S_DOCK_TXN_LOG |
PTM0010 |
All Paths |
All Paths |
S_ESCL_REQ |
PTM0010 |
All Paths |
All Paths |
NOTE: Unload and load jobs on tables that contain CLOB data are processed by the PTMCLOBx macros. These macros adjust the unload and load job control cards to handle any CLOB data in a table. The PTMCLOBx macros can be found in the DSNHLQ.SIEBEL.EXEC or in the VSTG0300 staging data set.
|