PI92871: ARY BIND MAY RECEIVE SQLCODE -203 FOR ARY@BAKO ON DB2 V12

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ARY BIND may receive SQLCODE -203 for ARY@BAKO on DB2 V12:
  DSNX200I  !ssid BIND SQL ERROR
             USING userid AUTHORITY
             PLAN=(NOT APPLICABLE)
             DBRM=ARY@BAKO
             STATEMENT=1242
             SQLCODE=-203
             SQLSTATE=42702
             TOKENS=VCATNAME
             CSECT NAME=DSNXORSO
             RDS CODE=-500
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Recovery Expert z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: ARY BIND may receive SQLCODE -203 for   *
  *                      ARY@BAKO on DB2 V12:                    *
  *                      DSNX200I  !ssid BIND SQL ERROR          *
  *                                 USING userid AUTHORITY       *
  *                                 PLAN=(NOT APPLICABLE)        *
  *                                 DBRM=ARY@BAKO                *
  *                                 STATEMENT=1242               *
  *                                 SQLCODE=-203                 *
  *                                 SQLSTATE=42702               *
  *                                 TOKENS=VCATNAME              *
  *                                 CSECT NAME=DSNXORSO          *
  *                                 RDS CODE=-500                *
  ****************************************************************
  * 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:

Modules/Macros

•    ARYGUIW
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R320 PSY UI54327

     UP18/03/22 P F803

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.