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) | |