PM30094: MSGDSNT408I SQLCODE = -525, ERROR IN PGM: ARY#OBEX STMT: 01548

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Following error encountered when trying to explode an object
  profile.
  This can occur when profile consist of RI tables.
  ARY801E Pgm: ARY#OBEX Stmt: 01548 Type: FETCH
  DSNT408I SQLCODE = -525, ERROR: THE SQL STATEMENT CANNOT BE
  EXECUTED BECAUSEIT WAS IN ERROR AT BIND TIME FOR SECTION = 15
  PACKAGE = RS22D91A.ARYCF220.ARY#OBEX CONSISTENCY TOKEN =
  X'18D7239C06CD9286'
  DSNT418I SQLSTATE = 51015 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXERT SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = -230 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD = X'FFFFFF1A' X'00000000' X'00000000'
  X'FFFFFFFF'
  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

• Work around for this problem is by NOT setting  the 'Process RI'
  field to 'Yes' but instead, manually adding the RI objects to
  the object profile.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Following error encountered when        *
  *                      trying to explode an object profile.    *
  *                      This can occur when profile consist of  *
  *                      RI tables.                              *
  *                      ARY801E Pgm: ARY#OBEX Stmt: 01548       *
  *                      Type: FETCH                             *
  *                      DSNT408I SQLCODE = -525, ERROR: THE     *
  *                      SQL STATEMENT CANNOT BE EXECUTED        *
  *                      BECAUSEIT WAS IN ERROR AT BIND TIME     *
  *                      FOR SECTION = 15                        *
  *                      PACKAGE = RS22D91A.ARYCF220.ARY#OBEX    *
  *                      CONSISTENCY TOKEN = X'18D7239C06CD9286' *
  *                      DSNT418I SQLSTATE = 51015 SQLSTATE      *
  *                      RETURN CODE                             *
  *                      DSNT415I SQLERRP = DSNXERT SQL          *
  *                      PROCEDURE DETECTING ERROR               *
  *                      DSNT416I SQLERRD = -230 0 0 -1 0 0 SQL  *
  *                      DIAGNOSTIC INFORMATION                  *
  *                      DSNT416I SQLERRD = X'FFFFFF1A'          *
  *                      X'00000000' X'00000000' X'FFFFFFFF'     *
  *                      X'00000000' X'00000000' SQL             *
  *                      DIAGNOSTIC INFORMATION                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK65019

Modules/Macros

• ARY#OBEX ARYBINDX ARYBIND8 ARYBIND9
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R220 PSY UK65019

     UP11/02/24 P F102

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.