JR61878: DB2 CONNECTOR WITH PARAMETRIZED ALTERNATE CONDUCTOR SETTINGS FAILS TO QUERY DATABASE CONFIGURATION

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• DB2 Connector with parametrized Alternate conductor settings
  fails to query database configuration when main and alternate
  Database/Location properties are configured with different
  names and Alternate conductor settings is disabled by parameter
  value.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2 Connector users using parameters to control Alternate
  conductor settings
  ****************************************************************
  PROBLEM DESCRIPTION:
  The use of a parameter to control Alternate conductor settings
  implies the need to set the alternate Database/Location property
  value. When preparing input data for db2CfgGet to query the
  database configuration the DB2 Connector uses the alternate
  database name without checking whether Alternate conductor
  settings is enabled.
  As a consequence incorrect database name may be used in the
  db2CfgGet call, if the main and alternate Database/Location
  names differ, resulting in job failure with following error
  message:
  An error occurred while preparing the table partitioning
  information.
  The method db2CfgGet returned reason code 0, SQLCODE -1,013.
  The SQLCODE may vary between -1,013, if the alternate database
  name cannot be found in the DB2 client's database catalog, and
  -30,082 otherwise.
  ****************************************************************
  RECOMMENDATION
  apply patch for JR61878
  ****************************************************************
  

Problem conclusion

• DB2 Connector routine checking the database configuration has
  been updated to pick the database name depending on the state
  Alternate conductor settings state.
  

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

• RB71 PSY

     UP