- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- How to restart an aborted dbimport of an Informix ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 03:40 AM
тАО08-06-2003 03:40 AM
I try to dbimport an Informix DB (IDS 7.30). For some reason it aborts after having imported some tables.
How is the syntax to continue this aborted job? I want to skip the table which caused the abort. May be I have to modify the .sql-file
Many thanks
Juerg
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 04:37 AM
тАО08-06-2003 04:37 AM
Solutiono start from scratch by "drop database xxxx" or "drop table yyy" then restart the import without the troublesome table (commet it out in the *.sql file)
OR
o Keep work to now & comment out the previously loaded tables & troubled table.
My preference is for the first. The table that you are having problems with can be done individually by using the appropriate SQL (moist of which is in the *.sql file) & dbaccess/isql
regards
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 04:46 AM
тАО08-06-2003 04:46 AM
Re: How to restart an aborted dbimport of an Informix Database?
This is because the first thing a dbimport does is to create the database - if it alrady exists it aborts immediately.
I suggest you fix the error which made it stop.
Your other option for completing the load is to dbaccess the rest of the CREATE TABLE statements in the .sql file, then dbload all the remaining tables one by one. I suggest you do that without logging, then create the indexes, then the triggers, stored procs, views and synonyms, then update statistics etc. This option is normally only reasonable if it aborts right near the end of a large import.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 04:56 AM
тАО08-06-2003 04:56 AM
Re: How to restart an aborted dbimport of an Informix Database?
I'm fairly sure you can comment out the CREATE DATABASE stuff & it should run. If not, then it will fail with whatever error & you will be no further forward/backwards than you were, so no harm in trying (other than the risk of editing the .sql file incorrectly!)
I said, the "drop database xxx" option is my prefered route.
Juerg, if you supply the .sql & say what table went wrong Steve (or me) may be able to help.
Regards
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 05:39 AM
тАО08-06-2003 05:39 AM
Re: How to restart an aborted dbimport of an Informix Database?
You should find out the reason why it aborted.
Of course you can edit the .sql file and comment out the import of the problem table . The frop the database from dbaccess and restart the dbimport.
What was the error message you got from your dbimport.
Regards
Rainer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 05:46 AM
тАО08-06-2003 05:46 AM
Re: How to restart an aborted dbimport of an Informix Database?
There is a statement with the datbase name - but that line is already commented out between {}s. I tried deleting this line, but still dbimport tries to create the database.
I tested interrupting a dbimport, deleting the database line, then re-running it. dbimport failed, it said cannot create database - duplicate value for record with unique key i.e. sysmaster:sysdatabases.
You have to drop the database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 07:34 AM
тАО08-06-2003 07:34 AM
Re: How to restart an aborted dbimport of an Informix Database?
Tim