JR61901: INVALID SUBTYPE FOR CHARACTER DATA: UNKNOWN ON TABLE ORGINALLY CREATED IN DB2 6 WITH SYSIBM.SYSCOLUMNS.FOREIGNKEY BLANK

APAR status

• Closed as program error.

Error description

• "Invalid subType for character data: UNKNOWN" error from
  Db2zCcsidTypeClassifier.
  Table was originally created in Db2 6
  and so the SYSIBM.SYSCOLUMNS.FOREIGNKEY column, which normally
  contains 'S' for SBCS or 'M' for MIXED, contains a blank
  (UNKNOWN).
  

Local fix

• Workaround: Create a new table in the latest database instead
  of migrating the tables.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients who are using IBM Data            *
  * Replication CDC Db2 for z/OS remote source, and are mapping  *
  * tables that were created in Db2 version 6.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Mapping a table ends on error. The error reports "Invalid    *
  * subType for character data: UNKNOWN". This was due to a      *
  * table created in an earlier version of Db2, such as Db2 v6,  *
  * not having a FOREIGNKEY type set.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR LUW 11.4.0.2-5528 for Db2 for z/OS remote     *
  * source.                                                      *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR LUW 11.4.0.2-5528 for Db2 for z/OS remote
  source resolves the issue.
  

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

  IDR DB2ZOS REMS

• Fixed component ID

  5737C30DR

Applicable component levels