IC92213: VALUES IN THE SYSMASTER:SYSRSTCB.IOWAITTIME COLUMN CAN BE INCORRECT

APAR status

• Closed as program error.

Error description

• When you run a query against the sysmaster:sysrstcb table to
  analyze the wait statistics of a particular thread, you can see
  the values in the iowaittime are not correct, for example for a
  session which lasts less then a second a much higher time is
  reported in iowaittime:
  
  An example of such a query:
  
  select --+ORDERED
  sc.sid,
  rs.iowaittime,
  tc.cpu_time
  from
  sysmaster:sysscblst sc,
  sysmaster:sysrstcb rs,
  sysmaster:systcblst tc
  where
  sc.sid    = DBINFO('sessionid')
  and sc.address = rs.scb
  and rs.tid = tc.tid;
  
  $ time dbaccess sysmaster query.sql
  
  Database selected.
          sid     iowaittime       cpu_time
           35     11.96113511364   0.005598801548
  
  1 row(s) retrieved.
  Database closed.
  
  real    0m0.115s
  user    0m0.020s
  sys     0m0.028s
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC8                                      *
  *                                                              *
  * Upgrade to IDS 11.70.*C8 when available                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC8
  

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

• RA10 PSN

     UP

• RA10 PSY

     UP

• RB10 PSN

     UP

• RB10 PSY

     UP

• RB50 PSN

     UP

• RB50 PSY

     UP

• RB70 PSN

     UP

• RB70 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP