Re: DBIMPORT Error
If you are UNIX based look at "DF". Seem as if you could be running into
"TEMP" space problems. Bottom line check where your "TEMP" DBSPACE is
being used. Quick command do onstat -dr 10 in another session while it is
doing the dbexport.
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Thu, 30 May 1996, Vikram wrote:
} First of all, let me thank all of you who responded to my earlier
} email. It helped a lot.
}
} But now I am stuck with a different error after about
} 50 tables are created.
}
} I have a dbexport of a database xyz which was taken as :
}
} dbexport xyz
}
} Informix as well as the 'xyz' application are maintained on
} another disk - disk2 (not root)
}
} However when I do the dbimport as :
}
} dbimport xyz
}
} the script runs well - it creates the database xyz and about 50
} tables (loads them with data as well) but then gives an error
} while creating an index for one of the tables as :
}
} /: write failed, file system is full
} *** execute sqlobj
} 212 - Cannot add index.
}
} 28 - No space left on device
}
} Please advise as to what parameters need to set/changed inorder to
} overcome this problem ( I had increased the dbspace and tried also
} but it failed again )
}
} Also, I was wondering why it is looking for space on / rather than on
} disk2 ??
}
} Thanks in advance
}