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 > trouble with onload

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-26-02, 17:55
amiguez amiguez is offline
Registered User
 
Join Date: Jun 2002
Posts: 2
Exclamation trouble with onload


I'm having trouble with the utilities onload/onunload...
I've made some table's backups with onunload, then I drop the tables and when I try to restore'em with the onload it recover the tables but with some differences. I.E. No triggers, additional constraints are created and mixed catalog tables.
I'm using version 7.30 of Informix Online.
Could anyone help me with this problem? Any ideas of alternatives to fast table backup?
Thanks.
Reply With Quote
  #2 (permalink)  
Old 07-01-02, 13:58
dananio dananio is offline
Registered User
 
Join Date: Mar 2002
Posts: 112
re

I think we have to go back to fundamental concept for this operation ,what does the database table compose from ?, they're from schema+data , to get schema : dbschema , to get data : onpload,sql unload ... I think these're simple way but you can do fast and very well if you have 2 these thing you can create the table in many DBMS
Reply With Quote
  #3 (permalink)  
Old 07-01-02, 14:47
amiguez amiguez is offline
Registered User
 
Join Date: Jun 2002
Posts: 2
too slow

thanks for your answer, but I'm already doing the job with a dbschema+sql(unload+load) and that's not a fast solution, at least for big tables (more than 1000000 registers), so I'm trying to find a better and faster solution...
Any other ideas?
Reply With Quote
  #4 (permalink)  
Old 07-09-02, 13:03
dananio dananio is offline
Registered User
 
Join Date: Mar 2002
Posts: 112
re

in Unload progress you can use another tools for do this such as onpload or onunload to get data think it's better way than use sql unload . In the use of sql unload you can use "set pdqpriority xxx" to spend resource for improve unload performance but in easy way I recommended use the right tools for right jobs is very well
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