470,591 Members | 2,005 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

Migrating a Windows DB2 8.1 to DB2 8.1 database system on AIX 5.3

Ric
Do someone know how to migrate/copy a Windows DB2 8.1 data base to DB2
8.1 database system on AIX 5.3. Found some migrate doc on the web but
these handle mirgrations across db systems.

Thx in adwance!!!

Oct 19 '06 #1
2 1656
Ric wrote:
Do someone know how to migrate/copy a Windows DB2 8.1 data base to DB2
8.1 database system on AIX 5.3. Found some migrate doc on the web but
these handle mirgrations across db systems.

Thx in adwance!!!
Use db2look to extract the DDL, and then make changes to run on Windows
(TS container file names and paths will need a change).

Then use db2move (export and then load) to move the data.

You cannont use backup and restore to move from DB2 Windows to DB2 UNIX.

Oct 19 '06 #2
Ric
" Use db2look to extract the DDL, and then make changes to run on
Windows
(TS container file names and paths will need a change)."
You mean "to run on UNIX" I suppose.
Thx for the info but I am a DB2 dummy and it would be great to have it
steps by steps.
Are this the steps you was talking about (the database I want to move
has the name TEST)?:

1. On Windows:
D:\db2look -d TEST -e -o TEST_Schema.ddl -l
2. Now modifying TS container file names and paths in "TEST_Schema.ddl"
and copy "TEST_Schema.ddl" to AIX.
3. On AIX using db2inst1 user:
- (/home/db2inst1) $ create a TESTDB
- (/home/db2inst1) $ connect to TEST
- (/home/db2inst1) $ db2 -tvf /depot/TEST/Schema/TEST_Schema.ddl
4. On AIX System via db2cc catalog TEST from Windowssystem
5. On AIX Connect to the Windows TEST and
- (/home/db2inst1) $ db2move TEST -u db2inst1 -p passdb2inst1
- (/home/db2inst1) $ db2 terminate
6. connect to the AIX TEST db
- (/home/db2inst1) $ connect to TEST
- (/home/db2inst1) $ db2move TEST load

7. Finished and ready to use
Thx again,
Ric

Oct 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Shai Levi | last post: by
11 posts views Thread by Neil | last post: by
34 posts views Thread by subramanian100in | last post: by
reply views Thread by rAinDeEr | last post: by
1 post views Thread by SÝren Alexandersen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.