Upgrade Guide for DB2 UDB for z/OS > Basic Database Preparations >
Reviewing Tablespace Size
Upgrades: All upgrades. Environments: Development environment only. Certain tables require larger tablespaces in Release 7.8 to accommodate additional columns. Review the tables listed in Step 16 and verify that the page size is sufficient to accommodate new columns (some of these tables may not have existed in your schema in previous releases.) NOTE: If the S_EMPLOYEE table existed in your schema during previous releases, you must move S_EMPLOYEE to a 16-KB bufferpool before performing an upgrade because an additional column is added to this table by the upgrade. S_EMPLOYEE has no default tablespace name, because it is obsolete.
Specify an entry in the storage control file for each obsolete table and extended table that you want to move to the 1:1:1 model. The 1:1:1 model was new in Release 7.7. For more information, see Planning Your Upgrade. It is recommended that you validate the storage control file, particularly where you have schema changes. Drop all views (including custom views) on a table before you move it.
Table 16. Tables with Additional Columns
|
|
|
S_ASSET
|
H0477000 |
16 KB |
S_COLUMN
|
H0658000 |
16 KB |
S_EMPLOYEE
|
H0997000 |
16 KB |
S_CRSE_URL
|
H0738000 |
16 KB |
S_DD_TRGT_GRP
|
H0875000 |
16 KB |
S_IC_CALC_IT
|
H1158000 |
16 KB |
S_PART_RPR
|
H1523000 |
16 KB |
S_PERF_MGR_APPR
|
H1534000 |
16 KB |
S_PROD_DEFECT
|
H1626000 |
16 KB |
S_PROD_INT
|
H1639000 |
16 KB |
S_SCHMST_DBSCPT
|
H1808000 |
32 KB |
S_SRC_PAYMENT
|
H1894000 |
16 KB |
S_SRV_REQ1_FNX
|
F2689000 |
16 KB |
S_SRV_REQ1_FNXM
|
F2690000 |
16 KB |
S_TABLE
|
H1966000 |
16 KB |
S_UPG_KITWIZ
|
H2009000 |
16 KB |
Table 17 lists the EIM tables that need to be evaluated for sufficient tablespace size.
Table 17. EIM Tables with Additional Columns
|
|
|
EIM_ACCOUNT
|
H0004000 |
32 KB |
EIM_ADDR_PER
|
H0019000 |
16 KB |
EIM_AGREE_DTL
|
H0022000 |
16 KB |
EIM_AGREEMENT1
|
H0021000 |
32 KB |
EIM_ASSET_DTL
|
H0033000 |
16 KB |
EIM_BASELN_DTL
|
H0041000 |
16 KB |
EIM_CALL_LST
|
H0046000 |
32 KB |
EIM_CONSUM_DTL
|
H0064000 |
16 KB |
EIM_CONTACT
|
H0065000 |
32 KB |
EIM_CONTACT1
|
H0066000 |
32 KB |
EIM_COURSE
|
H0073000 |
32 KB |
EIM_ENTLTMPL
|
H0121000 |
16 KB |
EIM_FN_ASGNGRP
|
F2300000 |
16 KB |
EIM_FN_PAYEE1
|
F2346000 |
16 KB |
EIM_FN_PAYEE2
|
F2347000 |
16 KB |
EIM_FN_REVN1
|
F2357000 |
32 KB |
EIM_GROUP
|
H0147000 |
16 KB |
EIM_IC_INCENTV
|
H0153000 |
16 KB |
EIM_MDF_DTL
|
H0181000 |
16 KB |
EIM_ORDER
|
H0198000 |
32 KB |
EIM_ORDER1
|
H0199000 |
16 KB |
EIM_ORDER_ITEM
|
H0201000 |
32 KB |
EIM_ORDER_SHIP
|
H0203000 |
16 KB |
EIM_PAYMENT
|
H0215000 |
32 KB |
EIM_PAYMNT_DTL
|
H0216000 |
16 KB |
EIM_PDSHIP_DTL
|
H0219000 |
16 KB |
EIM_PL_ITM_DTL
|
H0228000 |
16 KB |
EIM_PRODINVLOC
|
H0249000 |
16 KB |
EIM_PRSP_CON
|
H0271000 |
32 KB |
EIM_PT_RPR_DTL
|
H0276000 |
16 KB |
EIM_QUO_IT_DTL
|
H0286000 |
16 KB |
EIM_QUOTE1
|
H0281000 |
16 KB |
EIM_QUOTE_IT
|
H0283000 |
32 KB |
EIM_SRC1
|
H0301000 |
16 KB |
EIM_SRC2
|
H0302000 |
16 KB |
EIM_SRC_DBM
|
H0303000 |
16 KB |
EIM_SRC_EVT
|
H0305000 |
32 KB |
EIM_TARGET_DTL
|
H0317000 |
16 KB |
|