Upgrade Guide for DB2 UDB for z/OS and OS/390 > Basic Database Preparations >
Reviewing Tablespace Size
Upgrades: All upgrades. Environments: Development environment only. Certain tables require larger tablespaces in Release 7.7 to accommodate additional columns. Review each table listed in Table 11 and verify that the page size is sufficient to accommodate new columns. NOTE: It is recommended that you validate the storage control file particularly where you have schema changes.
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. NOTE: 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.
Drop all views (including custom views) on a table before you move it.
Table 11. 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 |
NOTE: Certain tables listed in Table 11 may not have existed in the schema during previous releases.
Table 12 lists the EIM tables that need to be evaluated for sufficient tablespace size.
Table 12. 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 |
|