IBM Support

JR32413: ODBC ENTERPISE STAGE CONNECTION TO SYBASE IQ USING SYBASE DRIVER DOES NOT CLEAN SYSYEM V SEMAPHORE USED,

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Using ODBC Enterpise Stage to Connect to Sybase IQ 12.7 server,
    after disconnection a system V semaphore resource is not
    cleaned. This can lead to failure of job with message
    
    "ODBC,0: Warning: LoadTable.ODBC: [Sybase][ODBC Driver][Adaptive
    Server Anywhere]Connection error: Insufficient system resources
    - failed to allocate a SYSV semaphore"
    

Local fix

  • Semaphores can be released with ipcrm command however care must
    be taken not to delete one in use.
    
    Currently customer has configured his number of semaphores high
    enough such that at their regualr weekly reboot which cleans
    up the semaphores, there are enough such that they do not run
    out.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    ODBC EE
    ****************************************************************
    PROBLEM DESCRIPTION:
    Using ODBC Enterpise Stage to Connect to Sybase IQ 12.7 server,
    after disconnection a system V semaphore resource is not
    cleaned. This can lead to failure of job with message
    ****************************************************************
    RECOMMENDATION:
    Apply the patch JR32413_linux_DS753.tar.Z., will solve the
    issue
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR32413

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    753

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-31

  • Closed date

    2009-04-15

  • Last modified date

    2009-04-15

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 April 2009