Informix - Problem description
Problem IT44076 | Status: Closed |
ONCHECK -PE ON TEMP DBSPACES CAN OCCASIONALLY REPORT ERROR:CHUNKFREE PAGES: ###, EXTEND FREE PAGES: ####. | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
When running oncheck -pe against a temp dbspace, it's possible to occasionally see errors like below: $ ifx oncheck -pe tmpdbs1 DBspace Usage Report: tmpdbs1 Owner: informix Created: 12/27/2017 Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) 5 /chunks/tmpdbs.1 2 50000 853 49147 Description Offset(p) Size(p) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 (0x500001) tmpdbs1:'informix'.TBLSpace 3 50 (0x500002) SORTTEMP:'informix'.th_tmprun_0x4769e460 53 416 (0x500003) SORTTEMP:'informix'.th_tmprun_0x4769e548 469 384 FREE 853 49147 Total Used: 853 Total Free: 49147 ERROR:Chunk free pages: 49115, Extent free pages: 49147. ERROR:Chunk used pages: 885, Extent used pages: 853. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** The messaging of the error text has been improved to help the user understand what is happening in the command execution. | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** The messaging of the error text has been improved to help the user understand what is happening in the command execution. | |
Comment | |
Fixed in Informix Server 14.10.xC11. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.06.2023 03.06.2024 03.06.2024 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |