When installing maintenance on Database Management for Db2 r19 why are many of the Tablespaces in the PTDB Database now created with DEFINE NO

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

After applying Database Management for Db2 for z/OS maintenance on release r19 and executing the Post Install tasks, 'Compare DB2 Objects' and 'Create Required DB2 Objects',
the tasks have generated DDL to create many of the PTDB Tablespaces as DEFINE NO.

Resolution

PTF RO85232 is responsible for implementing these changes on r19 along with a number of coreqs for the other product FMIDs.
Several new parameters have been added to the Post Install panel INSEDSE6, 'Edit Parmlib Member SETUP TS/IX Options'.

DEFINE (TS and IX).......> (YES or NO)
CLOSE (TS and IX).......> (YES or NO)
COMPRESS Tablespace........> (YES or NO)


The DEFINE parameter defaults to NO.

The Holddata for PTF RO85232 instructs that the following Post Install tasks be performed after applying this maintenance.

1. Compare DB2 Objects
2. Create Required DB2 Objects
3. Bind Product Packages and Plans

It is recommended when performing these tasks that the task JCL be regenerated through the panels to pick up any changes such as these new parameters.