how to copy a db2 database over to another machine ?
Posted on 2007-10-01
I have windows machine with a db2 database (let's say database name is "OrgiDB"), i need to duplicate a schema (let's say schema name is "OrgiSchema") over to AIX machine. This AIX machine already has db2 in it. I used the db2move command using the COPY mode as the following :
db2move OrgiDB COPY -sn OrgiSchema -u OrgiSchema -p OrgiSchema -co TARGET_DB CopiedDB USER CopiedSchema USING CopiedSchema SCHEMA_MAP ((OrgiSchema,CopiedSchema))
But it is not working well. I managed to copy the DDL (i.e table, trigger, seq , etc ) over , however it is load the data not using from the windows machine, but from the AIX machine. It so happens that i have another schema in the AIX machine using a same database name ( i.e. database name is "Diff" and has an existing schema "OrgiSchema" ). I decided to remove the OrgiDB database and now it is giving me a lot of problems. One of it is that it is complaining it can find OrgiDB on the AIX machine ....
Can anyone help me with this ? I need a full solution with instrution also on increase heap size (i.e. MON and AP etc ..).