Insufficient space in temporary dbspaces
Posted in 2015
Topics: Storage & Space Management, Stored Procedures & SPL, Server Administration, Versions, Editions & End-of-Life
Hi,
>>>> My IDS log is reporting "Insufficient space in temporary dbspaces" and I
think I have enough space.
IDS: IBM Informix Dynamic Server Version 12.10.FC5WE
Platform: CentOS release 6.6
Spaces:
| [informix@lpsalxids ~]$ onstat -d
|
| IBM Informix Dynamic Server Version 12.10.FC5WE -- On-Line -- Up 00:32:13 --
237584 Kbytes
|
| Dbspaces
| address number flags fchunk nchunks pgsize flags owner name
| 4587a028 1 0x60001 1 1 2048 N BA informix rootdbs
| 459a6590 2 0x40001 2 1 2048 N B informix log_dbs
| 459a67c0 3 0x60001 3 1 2048 N BA informix datadbs
| 459a69f0 4 0x1040001 4 1 2048 N PBA informix ph1dbs
| 459a6c20 5 0x48001 5 1 2048 N SB informix sbspace
| 47b00028 7 0x42001 7 1 2048 N TB informix tmp1dbs
| 47b00258 8 0x42001 8 1 2048 N TB informix tmp2dbs
| 47b00488 9 0x42001 9 1 2048 N TB informix tmp3dbs
| 8 active, 2047 maximum
|
| Chunks
| address chunk/dbs offset size free bpages flags pathname
| 4587a258 1 1 0 256000 243976 PO-B-D /apl/dev/trozos/rootdbs
| 47b02028 2 2 0 256000 10187 PO-B-D /apl/dev/trozos/logdbs
| 47b03028 3 3 0 1572864 1485109 PO-B-D /apl/dev/trozos/datadbs
| 47b04028 4 4 0 250000 0 PO-BED /apl/dev/trozos/phydbs
| 47b05028 5 5 0 51200 47678 47678 POSB-D /apl/dev/trozos/sbspace
| Metadata 3469 2581 3469
| 47b06028 7 7 0 51200 51147 PO-B-- /apl/dev/trozos/tmp1dbs
| 47b07028 8 8 0 51200 51147 PO-B-- /apl/dev/trozos/tmp2dbs
| 47b08028 9 9 0 51200 51147 PO-B-- /apl/dev/trozos/tmp3dbs
| 8 active, 32766 maximum
|
| NOTE: The values in the "size" and "free" columns for DBspace chunks are
| displayed in terms of "pgsize" of the DBspace to which they belong.
|
|
| Expanded chunk capacity mode: always
>>>>>> When I create a temporary table, I can see it correctly located in the
tmp1dbs, BUT a lot of messages are written in the log file:
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 8 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 8 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 16 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 8 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 16 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 8 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 16 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 8 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 16 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 8 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 16 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 8 pages.
| 12:50:24 Session <3938> Insufficient space in temporary dbspaces:
| Creating the temporary table in the root dbspace,
| Temporary table size is 16 pages.
>>>>> I have three empty temp dbspaces, and I have found the table created in
one of these dbspaces, in spite of the log message. It says the temporary
table is created in the root dbspace, which is false.
Is this a bug?
When I remove the DBSPACETEMP parameter from onconfig, the message is no more
shown in the logfile, but the tmp table is then created in the root dbspace.
How can I avoid these messages were written in the log file?
Thanks in advance
I'm sorry. It's a bug and it's reported and open: IT08121: 'INSUFFICIENT SPACE IN TEMPORARY DBSPACES' MESSAGE IN ONLINELOG ALTHOUGH ENOUGH SPACE IS AVAILABLE FOR TEMP TABLES APAR status: OPEN
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape