dbTalk Databases Forums  

RV: Problem with dbimport

comp.databases.informix comp.databases.informix


Discuss RV: Problem with dbimport in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alejandro Mendoza
 
Posts: n/a

Default RV: Problem with dbimport - 08-25-2005 , 12:39 PM







The dbspace where the indexes are being build is already full.
The importation is being made whether in the dbspace datachunk or in
rootdbspace. You should add more chunks to that dbspace.


-----Mensaje original-----
De: owner-informix-list (AT) iiug (DOT) org [mailtowner-informix-list (AT) iiug (DOT) org]
En nombre de E
Enviado el: Jueves, 25 de Agosto de 2005 09:48 a.m.
Para: informix-list (AT) iiug (DOT) org
Asunto: Problem with dbimport

Hi

I've not used Informix for seven years now - I'm rusty - please excuse
my ignorance.

I'm trying to restore an export, pretty quickly into the process I get
the error

212 - Cannot add index.

131 - ISAM ERROR: no free disk space


As far as I can see I have plenty of space, I have my ltapedev
pointing to /dev/null and running ontape -c, so I don't believe it's
transaction log issues.

Below is my onstat -d output.

Thanks in advance
Paul



IBM Informix Dynamic Server Version 9.40.UC5TL -- On-Line -- Up 2 days
17:07:32 -- 71088 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
4760e7d8 1 0x20001 1 1 N informix
rootdbs
4760ee08 2 0x20001 2 1 N informix
physchunk
47e4c018 3 0x20001 3 4 N informix
tempchunk
47e4c168 4 0x20001 4 1 N informix
datachunk
4 active, 2047 maximum

address number flags fchunk nchunks flags owner name
4760e7d8 1 0x20001 1 1 N informix
rootdbs
4760ee08 2 0x20001 2 1 N informix
physchunk
47e4c018 3 0x20001 3 4 N informix
tempchunk
47e4c168 4 0x20001 4 1 N informix
datachunk
4 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages flags
pathname
4760e928 1 1 0 50000 12312 PO--
/u01/infchunks/rootchunk
47718d98 2 2 0 50000 49947 PO--
/u01/infchunks/physchunk
4760eaf8 3 3 0 25000 24547 PO--
/u01/infchunks/tempchunk
4760ec80 4 4 0 1000000 25819 PO--
/u01/infchunks/datachunk
47f25018 5 3 0 51200 50347 PO--
/u01/infchunks/tempchunk2
48014939 6 3 0 512000 511997 PO--
/u01/infchunks/tempchunk3
48141320 7 3 0 1012000 1011997 PO--
/u01/infchunks/tempchunk4
7 active, 2047 maximum

Expanded chunk capacity mode: disabled
sending to informix-list

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.