IBM Support

IT28352: DBACCESS TAKES A VERY LONG TIME BEFORE RETURNING ERROR CODE 25588

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • consider a system out of shared memory connections.
    In this case dbaccess will just appear to hang in the "select
    database" menu and it will take quite some time to return the
    error 25588.
    
    this is the stack of dbaccess,
    
    (gdb) where
    #0  0x00007f1d31c51040 in __nanosleep_nocancel () from
    /lib64/libc.so.6
    #1  0x00007f1d31c50ef4 in sleep () from /lib64/libc.so.6
    #2  0x00000000004b7338 in net_sm_init ()
    #3  0x00000000004b8479 in connshm ()
    #4  0x00000000004d4200 in tlConnect ()
    #5  0x00000000004d13aa in slSQIreq ()
    #6  0x00000000004ca183 in pfConReq ()
    #7  0x00000000004c145c in cmReqSync ()
    #8  0x00000000004c262f in cmConReq ()
    #9  0x00000000004ad19e in ASF_Call ()
    #10 0x000000000047a487 in asf_connectEx ()
    #11 0x000000000047cd92 in _asf_dblist ()
    #12 0x00000000004879cd in sqgetdbs ()
    #13 0x00000000004319e1 in choosedb ()
    #14 0x0000000000453cbd in selectdb ()
    #15 0x000000000045180c in infmenu ()
    #16 0x000000000042e557 in main ()
    
    On Linux it takes about 20 mins to return this error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IDS prior to 12.10.xC13.                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * dbaccess takes a very long time before returning error code  *
    * 25588.                                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Fixed in IDS 12.10.xC13.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28352

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-03-07

  • Closed date

    2019-09-26

  • Last modified date

    2019-09-26

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
26 September 2019