PM64753: IF DB2 USES JAPANESE CCSID, SQLCODE922 IS ISSUED WHEN JCC CONNECTS TO DB2 WITH LOWER CASE IN USERID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Some Japanese codepages ( e.g. SCCSID 290) have different code
  points for lowercase letters from other EBCDIC code pages.
  If userid contains such characters, JCC connection may get
  SQLCODE922. Because DB2 converts the userid to Japanese CCSID
  code points, while RACF only supports code points in CCSID 500.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 users that use Katakana EBCDIC           *
  *                 CCSIDs.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: If DB2 Japanese Katakana CCSID is used  *
  *                      in the DECP (290, 930, 5026, 1390 or    *
  *                      8482), SQLCODE922 is issued when JCC T2 *
  *                      driver is used to connect to DB2 with   *
  *                      userid or password that contains        *
  *                      lower case charaters. This occurs when  *
  *                      using JCC driver version 3.61.84 or     *
  *                      later (JDBC 3.0) or 4.11.86 or later    *
  *                      (JDBC 4.0).                             *
  *                      SQLCODE922 may also occurs if an        *
  *                      application uses the SQL statement      *
  *                      'CONNECT TO <location> USER <userid>    *
  *                      USING <password>' to connect to DB2     *
  *                      with the above CCSIDs and lower case    *
  *                      characters in the userid or password.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During authorization checking, DB2 folds the userid and password
  string to upper case in CCSID 500. Because Japanese Katakana
  CCSIDs have different code points for their lower case
  characters, prior to this APAR the folding results may be
  incorrect causing authorization to fail.
  

Problem conclusion

• With this APAR, DB2 code checks for these Japanese Katakana
  CCSIDs and folds lower case characters in the userid and
  password to upper case correctly in these CCSIDs.
  

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:

  UK81425 UK81426 UK81427

Modules/Macros

• DSNXECNT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK81425

     UP12/09/19 P F209

• R810 PSY UK81426

     UP12/09/19 P F209

• R910 PSY UK81427

     UP12/09/19 P F209

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.