JR34006: DATA RIGHT TRUNCATION OCCURS WRITING TO A DB2 TABLE USING DB2 9.5 CLIENTS

APAR status

• Closed as program error.

Error description

• User is writing to a DB2 table. The table contains the column
  name USER_ID_DES. When data is written, the job generates the
  warning 'SetJobRoles_3..Transformer_102: At row 1, link
  "ConfigUserRoles_Update_Lnk"
  DSTAGE-DB2CLI-0103`:`Row rejected.
  DBMS.CODE=-99999, SQLSTATE=22001, [IBM][CLI Driver] CLI0109E
  String
  data right truncation. SQLSTATE=2200'
  

Local fix

• Do not use a column named 'USER_ID_DES'
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  AIX, DB2 plugin, with user defined sql.
  ****************************************************************
  PROBLEM DESCRIPTION:
  IS81 DB2 API job generates 'string data right truncation'
  warning,
  ****************************************************************
  RECOMMENDATION:
  Install patch: patch_JR34006
  ****************************************************************
  

Problem conclusion

• Fixed, when user has userdefined SQL command to update.
  

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:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP