JR29648: PATCH 72043 FOR DATASTAGE 7.5.* HAS NOT BEEN PORTED ACROSS TO IS 8.0.1 FIXPACK1A.

APAR status

• Closed as program error.

Error description

• Patch ecase 72043 was not ported across to 8.0.1 fixpack 1a.
  This affect any DB2 schema whic has more than 32k table.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using DB2 Enterprise Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  Connection fails when DB2 database has more than 32K tables
  
  ****************************************************************
  RECOMMENDATION:
  Apply patch for JR29648
  ****************************************************************
  

Problem conclusion

• When we try to run a PX job in DataStage with a DB2 enterprise
  stage in it, we get the following error (also comes while
  trying to view data from the stage)
  
  ##E IIS-DSEE-TNDB-00534 13:02:00(020) <DB2_UDB_Enterprise_212>
  Error Idx = 1;
  DB2Driver Embedded SQL message: SQL0304N A value cannot be
  assigned to a host variable because the value is
  not within the range of the host variable's data type.
  SQLSTATE=22003;
  sqlcode = -304;
  sqlstate = 22003
  ##E IIS-DSEE-TNDB-00000 13:02:00(021) <DB2_UDB_Enterprise_212>
  Failed to connect to database.
  
  Data Type assigned to the host variable is changed to long.
  

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:

Modules/Macros

• DB2
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP