SQL CODE -713 USING SET CURRENT APPLICATION COMPATIBILITY

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

DB2 12 subsystems are at level FL505.

During post-install tailoring, the 'Bind Product Packages and Plans' task rebinds all packages with APPCOMPAT V12R1M500.

When RC/Migrator has to create deprecated objects, SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'; is generated.

But with packages bound with APPCOMPAT V12R1M500 receive this error in the batch processor :

 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503';
 DSNT408I SQLCODE = -713, ERROR:  THE REPLACEMENT VALUE FOR CURRENT
          APPLICATION COMPATIBILITY IS INVALID
 DSNT418I SQLSTATE   = 42815 SQLSTATE RETURN CODE
 DSNT415I SQLERRP    = DSNXOSPR SQL PROCEDURE DETECTING ERROR
 DSNT416I SQLERRD    = -100  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
 DSNT416I SQLERRD    = X'FFFFFF9C'  X'00000000'  X'00000000'
          X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC
          INFORMATION
 BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED.
RETCODE =     8

Rebind package with APPLCOMPAT V12R1M505 bypass this problem

 

Environment

Release : 20.0

Component : CA RC/Migrator for DB2 for z/OS

Resolution

Re executed the bind job it and it works