search cancel

SQLCODE -438 in PTABDBC when updating a strategy

book

Article ID: 214981

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

Issue/Introduction

A -438 SQL error occurs when updating an RC/Migrator strategy. This occurs when selecting new objects for the strategy.

                                                                               
********************************* TOP OF DATA *********************************
DSNT408I SQLCODE = -438, ERROR:  APPLICATION RAISED ERROR WITH                 
       DIAGNOSTIC TEXT: Error in PTABDBC/$HOSTVAR "P" R15: 00000030        
         R0: 00000008 R1: 00000014                                             
DSNT411I SQLCAID    = ........ SQLCA IDENTIFIER                                
DSNT418I SQLSTATE   = 99999 SQLSTATE RETURN CODE                               
DSNT415I SQLERRP    = DSN????? SQL PROCEDURE DETECTING ERROR                   
DSNT416I SQLERRD    = 1275968  260752912  260752976  1  0  11 SQL              
         DIAGNOSTIC INFORMATION                                                
DSNT416I SQLERRD    = X'00137840'  X'0F8AC610'  X'0F8AC650'                    
         X'00000001'  X'00000000'  X'0000000B' SQL DIAGNOSTIC                  
         INFORMATION                                                           
DSNT417I SQLWARN0-5 = R,M,A,Å,L,S SQL WARNINGS                                 
DSNT417I SQLWARN6-A = T,2,.,.,.   SQL WARNINGS                                 
******************************** BOTTOM OF DATA *******************************

The user is unable to add objects to the strategy.

Environment

Release : 20.0

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

Resolution

Issue the FILES line command and ensure that the correct CDBA prefixed product libraries are listed.

If not, then review the CDBA datasets defined in the DSNAMExx CDBAPARM Parmlib member.