dbimport hangs when importing blob
Hi,
I'm an inofmix server version 9.40.FC9. I'm trying to import a database that
contains a blob. The ontat -d gives the following :
IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 03:58:01 --6565744 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
70000015ccd3490 1 0xa0001 1 1 N informix rootdbs
70000015de004f0 2 0xe0001 2 1 N B informix logdbs
70000015de00958 3 0xa0001 3 1 N informix physdbs
70000015de04028 4 0xe0001 4 2 N B informix data1dbs
70000015de04490 5 0xe0001 5 2 N B informix idx1dbs
70000015de048f8 6 0x2001 6 1 N T informix temp1dbs
70000015de08028 7 0x2001 7 1 N T informix temp2dbs
70000015dd926c8 8 0x68001 10 1 N SB informix siglob1dbs1
8 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
70000015ccd38f8 1 1 2 16368 12802 PO--
/bases/informix/pcampcam/sys/d01/rootdbs_01.dbf
70000015ddff778 2 2 2 802800 27747 PO-B
/bases/informix/pcampcam/sys/d02/logdbs_01.dbf
70000015ddff910 3 3 2 76798 12745 PO--
/bases/informix/pcampcam/sys/d03/physdbs_01.dbf
70000015ddffaa8 4 4 2 12287984 2657868 PO-B
/bases/informix/pcampcam/app/sgbcv9/dat/d01/sgb1_da_01.dbf
70000015ddffc40 5 5 2 4095984 1500360 PO-B
/bases/informix/pcampcam/app/sgbcv9/ind/d01/sgb1_ix_01.dbf
70000015ddffdd8 6 6 2 524272 524219 PO--
/bases/informix/pcampcam/sys/d04/tempdbs_01.dbf
70000015de00028 7 7 2 524272 524219 PO--
/bases/informix/pcampcam/sys/d05/tempdbs_02.dbf
70000015de001c0 8 4 2 32767984 25868769 PO-B
/bases/informix/pcampcam/app/sgbcv9/dat/d02/sgb1_da_02.dbf
70000015de00358 9 5 2 10649584 10649581 PO-B
/bases/informix/pcampcam/app/sgbcv9/ind/d02/sgb1_ix_02.dbf
70000015de04e88 10 8 0 13107200 12063916 12242119 POSB
/bases/informix/pcampcam/app/signature/dat/d01/sig1_lo_01.dbf
Metadata 865028 559809 865028
10 active, 32766 maximum
Expanded chunk capacity mode: enabled
I ran the following command 'dbimport -d dat1dbs1' and my dbimport hangs on
this statemtent :
create table "bank".bksig_blob
(
chemin decimal(11) not null ,
image "informix".blob,
taille integer
default 0 not null ,
primary key (chemin) constraint "bank".pk_bksig_blob
) PUT image in
(
siglob1dbs1
) extent size 32 next size 32 lock mode row;
Knowing I have the following entry in my onconfig.instance_name :
SBSPACENAME siglob1dbs1 # Default smartblob space name - this is where blobs
Can someone help please ?
Regards
Hi,
I've found why dbimport was hanging. I changed the onconfig file adding the
SPSPACENAME parma but I did'nt stop the engine before I launch 'dbimport'.
I've stop adn rerun the engine, then I rerun 'dbimport' and it's not hanging
no more
Regards