How to convert simple tablespaces in the Database Management Solutions for Db2 for z/OS database PTDB to a supported tablespace type
search cancel

How to convert simple tablespaces in the Database Management Solutions for Db2 for z/OS database PTDB to a supported tablespace type

book

Article ID: 56582

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Db2 tablespaces created within the Database Management for Db2 tools database (default PTDB) from many releases in the past may have been
created as simple which is no longer a  preferred tablespace type.  The IBM DB2 Report 11 may flag tablespaces within the Db2 tools database with the following message:

= Each table space listed below is a simple table space, meaning that =
= it is neither partitioned nor segmented. Although DB2 V11 can use =
= existing simple table spaces and allows you to alter data, update =
= data, or retrieve data from them, it does not allow you to create =
= them. If you accidentally drop a simple table space in V11, you =
= will be unable to recreate it. Therefore, before migrating to V11, =
= convert each table space listed below to a preferred type of table =
= space

Resolution

Starting with the Database Management Solutions for DB2 for z/OS r18 release, a new compare option (TS_SEGSIZE_RULE Y) may be manually
specified in the ssid0000 Post Install Compare JCL within the COMPRT and DDLCOMP steps as follows:

//APRMFILE DD *
TRGSSID ssid
BPRULE N
TS_SEGSIZE_RULE Y

The TS_SEGSIZE_RULE Y inclusion will honor the tablespace Compare SEGSIZE rule and convert any simple tablespaces to the defined tablespaces type within the DDL.  
Manually add the TS_SEGSIZE_RULE Y to the //APRMFILE DD for both the COMPRT and DDLCOMP steps.  Execute the ssid0000 and ssid0001 Post Install jobs to convert
the simple tablespaces.  We recommend executing a RUNSTATS against the PTDB objects before executing the ssid0000 job to ensure that the compare process can appropriately
size the output datasets. 

The Batch Processor tablespace PTDB.PTITSBP2 / table PTI.BPLOG_0203 must be manually converted with an ALTER TABLESPACE dbname.tsname MAXPARTITIONS 1;
followed by an IBM Reorg to convert to Partition By Growth.