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

Products

• RC Compare for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• RC/Extract for DB2 for z/OS
• RC/Migrator for DB2 for z/OS
• RC/Merger for DB2 for z/OS
• RC/Query for DB2 for z/OS
• RC/Update 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.

Environment

Release: 20.0
Component: RBP
Db2: FL M504 and above

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