APAR status
Closed as program error.
Error description
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
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * users of IDS 12.10 * **************************************************************** * 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 number
IT10790
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-08-19
Closed date
2015-12-30
Last modified date
2015-12-30
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
RC10 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 December 2015