PH25414: SQLCODE812 OCCURS FOR QUERY FROM JDBC CONNECTION WHILE THERE IS ONE MORE ENTRIES SPECIFIED IN PKLIST 20/05/19 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE812 occurs for query from JDBC connection while there is
  one more entries specified in pkList.
  For example:
  db2.jcc.pkList=NULLID.*,CWAS.*
  There were two entries specified in pkList, query from JDBC
  connection got following message:
  DSNT408I SQLCODE = -812, ERROR: THE SQL STATEMENT CANNOT BE
  PROCESSED
  BECAUSE A BLANK COLLECTION-ID WAS FOUND IN THE CURRENT
  PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED
  PACKAGE NAME FOR PROGRAM SYSSTAT.5359534C564C3031 USING PLAN
  DSNRRSAF
  

Local fix

• BYPASS/CIRCUMVENTION:
  specify one entry only in pkList
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 v12 for z/OS users that have                         *
  * applied APAR/PTF PH16362/UI65945 and using                   *
  * an RRSAF attachment such as SQLJ with a                      *
  * pkList longer than 255 characters.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * After applying UI65945, one of the                           *
  * COLLID can sometimes contain an                              *
  * invalid character which causes                               *
  * SQLCODE -812.                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When Db2 copies over the COLLID from pkList, it uses 255
  instead of 256 which causes 1 missing character from one of the
  COLLID moved in the pkList. This can lead to SQLCODE812 which
  interprets the COLLID with missing character as a BLANK in the
  COLLECTION ID field thus causing a mismatch during loading of
  the package.
  

Problem conclusion

• Db2 has been modified to use 256 when moving COLLID from
  pkList.
  

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:

  UI69728

Modules/Macros

• DSNTAAL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI69728

     UP20/06/04 P F006 ­

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.