JR33469: ENHANCEMENT REQUEST FOR SYBASE ENTERPRISE STAGE: RETRY WHEN JOB FAILS DUE TO IQ CONNECTION TIMEOUT.

APAR status

• Closed as fixed if next.

Error description

• Sometimes, the customer's job fails due to Sybase IQ time out
  error in CT Lib layer as following.
  
     Item #: 2027
     Event ID: 2026
     Timestamp: 2009-05-22 09:04:20
     Type: Info
     User Name: dsadm
     Message: T02,0: subproc o/p message:
  CT-LIBRARY error:
  subproc o/p message:   ct_connect(): user api layer: internal
  Client Library error: Read from the server has timed out.
  subproc o/p message:  CT-LIBRARY error:
  subproc o/p message:   ct_connect(): network packet layer:
  internal net library error: Net-lib operation timed out
  
  This error happens at the job initialization phase, and the
  customer expects the job to retry several times before aborting
  for this error in initialization.
  

Local fix

• Increase the connection timeout in Sybase IQ side.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using Sybase Enterprise Stage connecting to Sybase IQ.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When connecting to Sybase IQ database using Sybase enterprise
  stage due to various reasons the stage may not connect to the
  database at the first attempt. Customer requests that the stage
  should retry connecting to the database before aborting.
  ****************************************************************
  RECOMMENDATION:
  Install a patch after it is released on top of 8.5 release.
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• R753 PSN

     UP