IT07470: DYNAMIC_LOGS CAN CREATE LOG. LOG GREATER THAN 1048575 PAGES LEADING TO LOGPOS OVERFLOW

APAR status

• Closed as program error.

Error description

• In a system down situation with "Checkpoint Record not Found in
  Logical Log.", after a rollback failure with
  "logerr('logreadlen')" it turned out the checkpoint position
  occurred twice in same log - and first one was not a checkpoint.
  
  Looking closer at this revealed two log. logs with tremendous
  sizes (> 1048575 = 0xfffff pages, which is max. addressable page
  within a log. log):
  
      Log file number                70
      Unique identifier              117908
      Log file flags                 0x5        Log file in use
      &                                         Log file has been
  backed up
      Physical location              42:2589619
      Log size                       1732608 (p)
      Number pages used              373725
      Date/Time file filled          02/28/2015 22:36:30
      Time stamp                     0x411adb04
  
      Log file number                71
      Unique identifier              117909
      Log contains last checkpoint:  Page 15156, byte 24
      Log file flags                 0x3        Log file in use
      &                                         Current log file
      Physical location              42:4322227
      Log size                       3502080 (p)
      Number pages used              1063782
      Date/Time file filled          -
      Time stamp                     -
  
  For at least the second one (#71) we're seeing this in
  online.log:
  
  02/28/15 12:32:54  Logical Recovery has reached the transaction
  cleanup phase.
  02/28/15 12:35:14  Dynamically added log file 71 to DBspace 6
  02/28/15 12:35:14  Checkpoint Completed:  duration was 0
  seconds.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL DBUSERS                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC6                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC6
  

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