IBM Support

IT32162: AN ONSTAT -G SES OR ONSTAT -G SQL CAN LOOP PRINTING MANY "(" CHARACTERS RESULTING IN A LARGE ASSERTION FILE BEING CREATED

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

  • The instance that was running at the time was reporting some
    memory corruption problems which resulted in an AF to be
    generated.
    
    While producing the "onstat -g ses 0" section of the AF, the
    report ended up in a loop and printed many indented "("
    characters resulting a very large file to be created which might
    fill the file system.  You will see something like the following
    towards the end of the session report ...
    
    sqscb info
    scb              sqscb            optofc   pdqpriority
    optcompind  directives
    70000006864a098  70000004d16d028  0        0           2
    1
    
    Sess       SQL            Current            Iso Lock       SQL
    ISAM F.E.
    Id         Stmt type      Database           Lvl Mode       ERR
    ERR  Vers  Explain
    8546                      DBNAME             DR  Wait       0
    0    4.10  Off
    
    Stored procedure stack :
    
       context            proc-counter       opcode name
    
    ----------------------------------------------------------------
    --
       0x070000003f290058 0x7000000924cac38+0x0050 CURSOR
    DBNAME:sp_name
    
    Current SQL statement (134) in procedure DBNAME:sp_name
       proc-counter 0x7000000924cac38 opcode CURSOR
    
    (
      (
        (
          (
    
    And now all you see are many indented ( characters being printed
    and this also means that the other parts of the assert file are
    not reported.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4.  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 12.10.xC15 (when available) or    *
    * 14.10.xC4.                                                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32162

  • 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

    2020-03-12

  • Closed date

    2020-12-14

  • Last modified date

    2020-12-14

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
15 December 2020