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

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 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