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 number
IT36073
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-03-01
Closed date
2021-05-12
Last modified date
2021-05-12
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]
Document Information
Modified date:
13 May 2021