PH04548: AFTER APPLYING PI72309/UI47398, SQLCODE805 CAN OCCUR FOR DSNCLIF4 DUE TO MISSING ++HOLD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying PI72309/UI47398, sqlcode805 can occur for
  DSNCLIF4 due to missing ++HOLD
  

Local fix

• Bind DSNCLIF4
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of Db2 12 for z/OS                                 *
  * ODBC/CLI driver who have applied                             *
  * APAR PI72309 (PTF UI47398).                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * After applying APAR PI72309                                  *
  * (PTF UI47398), a SQLCODE805 can result                       *
  * for DSNCLIF4 due to a missing ++HOLD                         *
  * that specifies a needed action.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  APAR PI72309 modifies part DSNCLIF4, so its PTF UI47398
  should have included a ++HOLD in order to notify all users
  that a rebind package for DSNCLIF4 is needed after applying
  PTF UI47398. The PTF UI47398 is missing the ++HOLD
  due to a mis-matched FMID. An SQLCODE805 can result if the
  user does not  rebind the DSNCLIF4 package after applying the
  PTF UI47398.
  

Problem conclusion

• A ++HOLD is included to inform all users to
  rebind the package for DSNCLIF4 after applying
  PI72309/UI47398.
  
  After applying the PTF, all users need to rebind the
  DSNCLIF4 package as the sample command listed below:
  
    BIND PACKAGE (<location-name>.DSNAOCLI) MEMBER(DSNCLIF4)
         ACTION(ADD) ENCODING(EBCDIC)
  
    where <location-name> is the location of the DBMS where
    the package binds and where the description of the
    package resides.
  
  Also, refer to the prolog of the CLI sample bind job DSNTIJCL
  in your SDSNSAMP data set for specific instructions on how to
  customize the BIND command for binding the DBRMs/packages and
  the application plan at your site.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI60194

Modules/Macros

• DSNAOG17 DSNAOC0L DSNAOC08 DSNAOC17 DSNAOG08 DSNAOC1L DSNAOC03
  DSNAOC02 DSNAOG1L DSNAOTRC DSNAOG02 DSNAOG03 DSNAOSDK DSN@LIF4
  DSNAOCLI DSNAOG0L
  

Fix information

• Fixed component name

  DB2 ODBC/JDBC/S

• Fixed component ID

  5740XYR02

Applicable component levels

• RC17 PSY UI60194

     UP18/12/22 P F812 ¢

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.