kiddstar
asked on
How to Transfer db2--> db2 across platform (win 2000 --> linux red hat) ?
i have the db2 installed inside my windows 2000 and linux red hat 7.2. And now i want to move the database inside the windows 2000 to linux red hat, i try using backup restore, it cannot work. So, my friend suggest me using db2move as the following show--
1. using cmd "db2move sample export" in win 2000
2. copy the whole exported files into linux server
3. using cmd "db2move sample import " in linux
after that i open 1 of the .msg file and see, it show
SQL3104N The Export utility is beginning to export data to file "tab1.ixf".
SQL3105N The Export utility has finished exporting "252" rows.
SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date
"20020905", and time "152327".
SQL3050W Conversions on the data will be made between the IXF file code page
"1252" and the application code page "819".
SQL3153N The T record in the PC/IXF file has name "tab1.ixf", qualifier "",
and source " ".
SQL3109N The utility is beginning to load data from file "tab1.ixf".
SQL3110N The utility has completed processing. "252" rows were read from the
input file.
SQL3221W ...Begin COMMIT WORK. Input Record Count = "252".
SQL3222W ...COMMIT of any database changes was successful.
SQL3149N "252" rows were processed from the input file. "252" rows were
successfully inserted into the table. "0" rows were rejected.
--------------------------
after that i open the database and see, inside still is an empty database
Can any expert help me?
thank you very much.
1. using cmd "db2move sample export" in win 2000
2. copy the whole exported files into linux server
3. using cmd "db2move sample import " in linux
after that i open 1 of the .msg file and see, it show
SQL3104N The Export utility is beginning to export data to file "tab1.ixf".
SQL3105N The Export utility has finished exporting "252" rows.
SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date
"20020905", and time "152327".
SQL3050W Conversions on the data will be made between the IXF file code page
"1252" and the application code page "819".
SQL3153N The T record in the PC/IXF file has name "tab1.ixf", qualifier "",
and source " ".
SQL3109N The utility is beginning to load data from file "tab1.ixf".
SQL3110N The utility has completed processing. "252" rows were read from the
input file.
SQL3221W ...Begin COMMIT WORK. Input Record Count = "252".
SQL3222W ...COMMIT of any database changes was successful.
SQL3149N "252" rows were processed from the input file. "252" rows were
successfully inserted into the table. "0" rows were rejected.
--------------------------
after that i open the database and see, inside still is an empty database
Can any expert help me?
thank you very much.
Sorry about that, I thought I hit comment.
ASKER
actually i had found the answer already.
the different owner of the db will influece the process of db2move
the different owner of the db will influece the process of db2move
ASKER
my problem now is , i don't know how to close this question after i found the answer, so sorry for making trouble. Can any body tell me how to close this question? thanks :P
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BACKUP DATABASE database-alias [USER username [USING password]]
[TABLESPACE (tblspace-name [ {,tblspace-name} ... ])] [ONLINE] [USE ADSM
[OPEN num-sess SESSIONS]] | TO dir/dev [ {,dir/dev} ... ] | LOAD lib-name
[OPEN num-sess SESSIONS]] [WITH num-buff BUFFERS] [BUFFER buffer-size]
[PARALLELISM n] [WITHOUT PROMPTING]
Then
RESTORE DATABASE source-database-alias { restore-options | CONTINUE | ABORT }
restore-options:
[USER username [USING password]]
[{TABLESPACE ONLINE |
TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |
HISTORY FILE [ONLINE]}] [{USE ADSM
[OPEN num-sess SESSIONS] | FROM dir/dev [ {,dir/dev} ... ] | LOAD shared-lib
[OPEN num-sess SESSIONS]}] [TAKEN AT date-time] [TO target-directory]
[INTO target-database-alias] [NEWLOGPATH directory]
[WITH num-buff BUFFERS] [BUFFER buffer-size]
[DLREPORT file-name] [REPLACE EXISTING] [REDIRECT] [PARALLELISM n]
[WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]
and it failed, (what was wrong? what happened?)...
You might want to try this (unfortunately for each table)
Export to <filename> of del select * from <schema.tablename>
then...
Import from <filename> of del insert into <schema.tablename>
But you will have to do this once for each table you have
and assuming you recreate the tables in the new db. Most definately not the answer you were looking for. But if you're waiting for something to work, at least you don't need to recreate the data :)
Sorry,