JR31846: TERDADATA CONNECTOR DOES NOT RECONNECT IF TERADATA REPORTS RDBMS CODE 8018: THE SESSION ID IS ILLEGAL.

APAR status

• Closed as program error.

Error description

• Teradata Connector (after reconnect enhancement JR29550 has
  been applied) still does not reconnect if Teradata reports
  RDBMS code 8018: The session id is illegal.
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  TDCC users using RECONNECT feature
  ****************************************************************
  PROBLEM DESCRIPTION:
  Reconnect feature is origally implemented for 8055 error only.
  In certain scenarios TD-DBS is returning 8018 insted of 8055.
  ****************************************************************
  RECOMMENDATION:
  Install the patch.
  This fix is included in Information Server 81 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• The RECONNECT logic is extended to support 8018 error as well.
  Code fix completed & patch provided.
  

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

• R801 PSN

     UP