search cancel

SQLCODE -713 occurs for SET CURRENT APPLICATION COMPATIBILITY using DDL file generated by RC/Migrator

book

Article ID: 214987

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

A -713 SQL error occurs when executing a DDL file generated by the analysis of an
RC/Migrator for Db2 for z/OS (RCM) strategy.

The problem occurs after an upgrade to the Db2 Function Level.

 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M505';                
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                                                 

The Post Install upgrade tasks have been completed, including updating the SSIDVERF and SSIDVERC
parameters in the SETUPxx Parmlib member and executing the Bind task.

 

Environment

Release : 20.0
Component : RCM

Cause

The -713 error is a result of not performing the post upgrade tasks in the correct order.

Resolution

The update to the SETUPxx member within hlq.CDBAPARM must be completed before the Post Install Bind task is executed.
Update the SSIDVERF and SSIDVERC parameters in the SETUPxx member and then rerun the Bind task. 

Additional Information

Refer to the Upgrade to new Db2 Release and Function Levels documentation.