If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > dbimport error 212 & 130

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-24-07, 05:10
jifpri ahmad jifpri ahmad is offline
Registered User
 
Join Date: May 2007
Posts: 1
dbimport error 212 & 130

Hi guy, pls help me

my dbimport stop and display error 212 - cannot add index, and error 130 - ISAM ERROR : No such DBSPACE

After that, i create 1 more chunk size 20000000,drop database,make dbimport again, but the error still come out...
create 1 more chunk again but the error still happen, until no more space on my disk01...

any sugestion?

TQ
Reply With Quote
  #2 (permalink)  
Old 05-24-07, 07:21
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
Check the script ( *.sql ) , find the create index with problem... take look on "IN" clause...
Probably the dbspace specified there not exists...

finderr -130
-130 ISAM error: no such dbspace.

This code indicates one of two problems. The most likely problem is
that this operation specifies a dbspace by name (for example, in the IN
clause of a CREATE TABLE statement or in the DBSPACETEMP environment
variable setting), but that name has not been defined. You can run the
tbstat or onstat utility with the -d option to see the names of defined
dbspaces. Ask the database server administrator about creating a new dbspace.

If the operation does not explicitly name a dbspace, or if the name is
correct, the problem might be more serious. The error might reflect
corruption of reserved pages in the root dbspace. Use the tbcheck or
oncheck utility with the -cr option to check for this condition.
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On