IT16408: DYNAMIC SQL SNAPSHOT MAY FAIL WITH SQL1224N WHEN CLIENT AND SERVER USE DIFFERENT CODEPAGE

DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as fixed if next.

Error description

• When the codepages used in the client and the server are
  different (e.g. database:943, client:1208), dynamic sql snapshot
  may fail with SQL1224N.
  
  This failure occurs because the snapshot output buffer is found
  to be too small during codepage conversion of char strings in
  the snapshot output (because the converted char strings take
  up more space in the client codepage compared to the database
  codepage).
  

Local fix

• Use the same codepage in client/database.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users using dynamic sql snapshot                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 next release.                                 *
  ****************************************************************
  

Problem conclusion

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:

  IT21704

Fix information

Applicable component levels

• RA50 PSN

     UP