IT00683: UNDER LOAD INSTANCE IS SWAMPED WITH ASSERT WARNINGS: EXCEEDING MAX # OF PAGES

APAR status

• Closed as program error.

Error description

• Under heavy load the instance may produce a high number of
  assert warnings similar to the one below.
  
  From the online.log:
  
  01:37:30
  01:37:30  IBM Informix Dynamic Server Version 12.10.FC1 Software
  Serial Number AAA#B000000
  
  01:37:30  Assert Warning: Exceeding max # of pages (Actual 41,
  Allowed 40) that can be physically logged in a critical section
  while critical section blocking is active.
  01:37:30   Who: Session(1721, instance@domain.com 16843,
  0x5ba02fab8)
                  Thread(4647, sqlexec, 5b9ffe4d8, 1)
                  File: rsbuff.c Line: 4278
  01:37:30   Action: Please notify IBM Informix Technical Support.
  01:37:30  Raw hex dump of stack located in
  /informixdir/af.160f94a9.rawstk
  01:37:30  Stack for thread: 4647 sqlexec
  
  The stack printed in the AF files may look similar to:
  
  afstack
  afhandler
  afwarn_interface
  bfphyslogx
  buffclear
  mapfree
  ptextend
  ptbuild
  rspnbuild_sz
  fmamaddindex
  sqmgm_isaddindex
  creaidx
  aud_creaidx
  excommand
  sq_execute
  sqmain
  spawn_thread
  startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * users using large extents in 12.10                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-12.10.xC5                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-12.10.xC5
  

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