How to instruct Batch Processor to generate SET CURRENT APPLICATION COMPATIBILITY statement

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 - 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

When using Db2 Function Level M504, objects such as segmented tablespaces can no longer be created by default.
The IBM workaround is to switch to a lower APPLCOMPAT level before a create statement for a segmented tablespace by
issuing a 'SET CURRENT APPLICATION COMPATIBILITY' statement.

How to instruct Batch Processor or the Database Management for Db2 for z/OS administration tools to generate this
statement as required.

Resolution

CREATE DDL for M504 deprecated objects will automatically be generated with the required SET CURRENT APPLICATION COMPATIBILITY statement.

This will be similar to the following:

SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503';
<<deprecated object CREATE DDL statement>>
SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M504';

Additional Information

Further details on this support can be found in the relevant product documentation.

RC/Migrator new features M504 Deprecated Objects Support

RC/Query new features M504 Deprecated Objects Support

RC/Extract new features M504 Deprecated Objects Support

RC/Update new features M504 Deprecated Objects Support