INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

The index repack on a fragmented table succeeds but writes 
assert failure files: 
 
Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns 
blocked 1, Plog used 18432, Llog used 42859 
 
Assert Warning: Repack has attempted 1000 times to repack index 
ak_46989:"informix".miscari#ix_cont_fisa 
IBM Informix Dynamic Server Version 12.10.FC5W1 
Who: Session(36, informix@, 0, 0x44c3f0e0) 
                Thread(150, repack.2, 44bfb1e8, 1) 
                File: rsidxreorg.c Line: 1578 
 Results: Unable to complete repack of index because its too 
volatile. 
Action: Try running the repack operation when index is being 
updated less frequently. 
stack trace for pid 23044 written to 
/opt/informix/12.10.FC5W1/tmp/af.47e5ee2 
See Also: /opt/informix/12.10.FC5W1/tmp/af.47e5ee2 
Repack has attempted 1000 times to repack index 
ak_46989:"informix".miscari#ix_cont_fisa 
SCHAPI Repack succeeded for index 
'ak_46989:informix.ix_cont_fisa' partnum 400003. 
SCHAPI Shrink for ak_46989:informix.ix_cont_fisa started 
SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum 
200003 succeeded. 
SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum 
300003 succeeded. 
SCHAPI Shrink for table 'ak_46989:informix.ix_cont_fisa' partnum 
400003 succeeded. 
SCHAPI index repack shrink  ak_46989:informix.ix_cont_fisa 
succeeded 
 
 (oninit) afstack 
 (oninit) afhandler 
 (oninit) afwarn_interface 
 (oninit) rsidxrepack 
 (oninit) fmrepack_idxfrag 
 (oninit) startup

**************************************************************** 
* USERS AFFECTED:                                              * 
* users of IDS 12.10                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************

Problem Fixed In IBM Informix Server 12.10.xC6

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.08.2015
30.12.2015
30.12.2015

12.10.xC6