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!!!

[Mark A]

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.

[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