IC98193: TIMESERIES RELATED UDRS ALLOCATE A LOT OF MEMORY WHEN CALLED REPEATEDLY FROM CURSOR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • If your timeseries application calls the TimeSeries UDRs like
    PutElem() or Transpose() repeatedly from inside a cursor, you
    may see the memory allocated by the session's pool is steadily
    growing. If you run 'onstat -g afr <sid>' to see the list of
    allocated memory fragments, you will notice very high number of
    'ralloc' fragments allocated in sqopvti.c or ddutil.c files:
    
    30c3a0a00        1024       ralloc       3995   sqopvti.c:2083
    30bc61000        1024       ralloc       3995   sqopvti.c:2083
    30bc61400        1024       ralloc       3995   sqopvti.c:2083
    30bc61a00        1024       ralloc       3995   sqopvti.c:2083
    30bc65000        1024       ralloc       3995   sqopvti.c:2083
    30bc65400        1024       ralloc       3995   sqopvti.c:2083
    30bc65a00        1024       ralloc       3995   sqopvti.c:2083
    
    or
    
    4d352400         1024       ralloc       3763   ddutil.c:15619
    4d352800         1024       ralloc       3763   ddutil.c:15619
    4d352c00         1024       ralloc       3763   ddutil.c:15619
    4d353000         1024       ralloc       3763   ddutil.c:15619
    4d353400         1024       ralloc       3763   ddutil.c:15619
    4d353800         1024       ralloc       3763   ddutil.c:15619
    4d353c00         1024       ralloc       3763   ddutil.c:15619
    4d354000         1024       ralloc       3763   ddutil.c:15619
    4d354400         1024       ralloc       3763   ddutil.c:15619
    4d354800         1024       ralloc       3763   ddutil.c:15619
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * queries using table functions or casts within udrs           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 12.10.xC3 or earlier PID if available             *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC98193

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-12-06

  • Closed date

    2014-05-08

  • Last modified date

    2014-05-08

  • 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

  • RA10 PSN

       UP

  • RA10 PSY

       UP

  • RB10 PSN

       UP

  • RB10 PSY

       UP

  • RC10 PSN

       UP

  • RC10 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Servers

Software version:

C10

Reference #:

IC98193

Modified date:

2014-05-08

Translate my page

Machine Translation

Content navigation