home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT36073 Status: Closed

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

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem 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
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).                                  *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* 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).                                  *
****************************************************************
Comment
Fixed in Informix Server 12.10.xC15 and 14.10.xC6.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
01.03.2021
12.05.2021
12.05.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)