IDS Forum

dbimport don't use all available dbspace

Posted By: DANILO BREMBILLA
Date: Monday, 10 October 2016, at 7:53 a.m.

Hi all,
On Linux Centos, with Informix 10.00.FC6 I've this dbspace situation

[informix@test64-001 dev]$ onstat -d

IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up 4 days 00:03:36 -- 37900 Kbytes

Dbspaces
address number flags fchunk nchunks pgsize flags owner name
45068e78 1 0x60001 1 1 2048 N B informix rootdbs
460fa5c8 2 0x60001 2 1 2048 N B informix datidbs1
460faec8 3 0x42001 3 1 2048 N TB informix sortdbs
46132498 4 0x60001 4 1 2048 N B informix datidbs2
4 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages flags pathname
45069028 1 1 0 15000 5211 PO-B /informix/dev/rootdbs
460fa760 2 2 64 512000 453406 PO-B /informix/dev/datidbs1
460fb060 3 3 0 256000 255947 PO-B /informix/dev/sortdbs
46132630 4 4 0 512000 511947 PO-B /informix/dev/datidbs2
4 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

[informix@test64-001 dev]$

I'm trying to make a dbimport of a database with the command
[informix@test64-001 dev]$ dbimport <dbname>
and the only dbspace consumed by the engine is the rootdbs that becomes completly full after few second with the error:

...
*** execute sqlobj
261 - Cannot create file for table (edp.ma_d_inv).
131 - ISAM error: no free disk space
[informix@test64-001 dev]$

So I've change the command in

[informix@test64-001 dev]$ dbimport -d datidbs1 <dbname>

The engine now use all the dbspace datidbs1 (1G) until this became full again, like onstat -d say

IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up 4 days 00:06:26 -- 46092 Kbytes

Dbspaces
address number flags fchunk nchunks pgsize flags owner name
45068e78 1 0x60001 1 1 2048 N B informix rootdbs
460fa5c8 2 0x60001 2 1 2048 N B informix datidbs1
460faec8 3 0x42001 3 1 2048 N TB informix sortdbs
46132498 4 0x60001 4 1 2048 N B informix datidbs2
4 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages flags pathname
45069028 1 1 0 15000 5211 PO-B /informix/dev/rootdbs
460fa760 2 2 64 512000 0 PO-B /informix/dev/datidbs1
460fb060 3 3 0 256000 255947 PO-B /informix/dev/sortdbs
46132630 4 4 0 512000 511947 PO-B /informix/dev/datidbs2
4 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
[informix@test64-001 dev]$

but don't use the space in the other dbspaces (datidbs2 for example)
How can i force the engine to use all the dbspaces presents and availables ?

Thank for the advice.
Danilo

Messages In This Thread

• dbimport don't use all available dbspace
  DANILO BREMBILLA -- Monday, 10 October 2016, at 7:53 a.m.
  • Re: dbimport don't use all available dbspace
    Alexandre Marini -- Monday, 10 October 2016, at 8:15 a.m.
  • Re: dbimport don't use all available dbspace
    Art Kagel -- Monday, 10 October 2016, at 8:38 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.