×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Can I use Ontape to move DB from one to another server ?

Can I use Ontape to move DB from one to another server ?

Can I use Ontape to move DB from one to another server ?

(OP)
Hi there,

I have to move database from one server to another (SCOUnix, Informix 7.23).
Vendors of our Application use onload/onunload, but ONLOAD works incredibly slow (I expect the duration about 15 hours).
I intended to use ONTAPE, but I am not sure that my restore attempt will be successful, because this servers have different chunk's sizes.(And as far as I know, ONTAPE restores chosen dbspace to the same chunks)
Can anyone help me to solve this problems?
Any help or suggestions would be greately applreciated !

Michael Puzankov       

RE: Can I use Ontape to move DB from one to another server ?

Michael:

You're correct about your concerns with the chunk sizes.  That's why we use links to devices when setting up chunks.

Have you considered using dbexport, and then dbimporting on the destination?  If you're database is large, you can export to tape.

You also might consider the High Performance Loader, but if you have a lot of tables in your database, setting up the jobs could be time consuming.

Regards,

Ed
Schaefer

RE: Can I use Ontape to move DB from one to another server ?

I advise to use dbexport and dbimport to do. if not use dd and move raw logically and execute dbschema on that. IDS won't look for links make shure links should be fine.

RE: Can I use Ontape to move DB from one to another server ?

Giriraju:

I don't want to confuse this issue because it's too important.  I certainly don't recommend using dd.  dbexport/dbimport works fine, but I like to use my own extent setup, so I prefer an ontape restore if possible.

Let say my informix database is 3 chunks.  When I initialized Informix, I set them up using soft links, rdb1, rdb2, rdb3 as such:

# remove prior existing links if any.
rm /dev/rdb*

# create links for informix drives
ln -s /dev/rdsk/c0d1s0 /dev/rdb1
ln -s /dev/rdsk/c1d1s1 /dev/rdb2
ln -s /dev/rdsk/c2d1s3 /dev/rdb3

# change permissions and modes on informix drives
chown informix rdb*
chgrp informix rdb*
chmod 660 rdb*
# end script

Let's say on my destination drive, my database raw partitions are c3d1s0, c4d1s1, c5d1s1, I can execute this script and set up informix:

# remove prior existing links if any.
rm /dev/rdb*

# create links for informix drives
ln -s /dev/rdsk/c3d1s0 /dev/rdb1
ln -s /dev/rdsk/c4d1s1 /dev/rdb2
ln -s /dev/rdsk/c5d1s1 /dev/rdb3

# change permissions and modes on informix drives
chown informix rdb*
chgrp informix rdb*
chmod 660 rdb*
# end script

As long as my raw partitions on the destination machine are at least as large the original, an ontape restore should work.

Regards,

Ed
Schaefer

RE: Can I use Ontape to move DB from one to another server ?

if your architectures are exactly the same (ie same IDS, same processot arch) ontape will do,
there is a dbexport/dbimport who are accepting a directory as output (eg NFS) - remember to use -ss if you have more than on dbspace  or table > 100 rows

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close