IT36073: ONTAPE LEVEL 0 DOES NOT ARCHIVE TEMP (IMPLICIT OR EXPLICIT) PARTITIONS ON DBSPACES AFTER RESTORE DIFFERENT ERRORS ON MAPPAGES

APAR status

• Closed as program error.

Error description

• An ontape level 0 does NOT archive temporary (implicit
  _temptable or explicit) partitions on dbspaces, so the resstore
  will leave those pages with whatever was previously in there
  leading to future mappages issues as we can't find the bit map
  page for that partition.
  i.e.
  estimate_compression task running on a restored might fail with:
  
  11:11:35  bfcheck: bad page: pg_flags 0x8890 != type 0x4
  
  00:31:12  IBM Informix Dynamic Server Version 14.10.FC5WE
  
  00:31:12  Assert Failed: Page Check Error in mappage:bad bitmap
  page
  00:31:12   Who: Session(58, informix@, 0, 0x50f0c878)
          Thread(94, dbWorker7, 50ed3328, 1)
          File: rsdebug.c Line: 992
  00:31:12   Results: Possible inconsistencies in
  'testcases':"informix"._temptable'
  00:31:12   Action: Run 'oncheck -cD 3149102'
  00:31:12  SHM Globals and Master Pool/Master Block Adresses:
  
  
  00:31:12  Raw hex dump of stack located in
  /u2/dump/af.4463620.rawstk
  00:31:12  Stack for thread: 94 dbWorker7
  
   base: 0x0000000052aa1000
    len:   135168
     pc: 0x00000000014a5f2d
    tos: 0x0000000052abd870
  state: running
     vp: 1
  
  afstack
  afhandler
  affail_interface
  bffail
  mappages
  pstread
  rsread
  fmread
  readidx_new
  gettupl
  scan_next
  next_row.part.7
  ordered_group_by_next
  filltem
  scan_open
  materialize_viewtmp
  materialize_viewtmp
  materialize_viewtmp
  prepselect
  doinsert
  aud_doinsert
  excommand
  sq_execute_workhorse
  sq_execute
  mi_exec
  ph_execute
  do_sensor
  db_sch_worker
  udrlm_clang_execute_internal
  udrlm_clang_execute
  udrlm_exec_routine
  udr_execute
  dbsched_start_udr
  th_init_initgls
  startup
  
  oncheck -pe shows:
  
  testcases:'informix'.tab1
  591080        8 0x0030005f        2
  testcases:'informix'.cv2_seq_idx
  591088      337 0x003000f7       12
  testcases:'informix'._temptable
  591425        8 0x00300d8c        1
  testcases:'informix'._temptable
  591433        8 0x00300d8d        1
  FREE
  591441       16
  testcases:'informix'.cl2_seq_idx
  591457        4 0x003000d8        6
  testcases:'informix'.tab2
  591461        8 0x0030016a        2
  

Local fix

Problem summary

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

Problem conclusion

• Fixed in Informix Server 12.10.xC15 and 14.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