Moving platforms db2look-db2move procedures 
Author Message
 Moving platforms db2look-db2move procedures

General question about moving a database from an AIX to SUN platform. We have DB2 V6 database that has
dependencies between tables. During the creation of the db2look output I receive the declarations for the
following:

tablespace creation
table creation
triggers
view creation
table constraints
grant authorizations
udf creation statements
statistics

I've been told by sources to do the following on the new platform:

1. create the database and instance.

2. create the tables/views

3. Use db2move to get the data into the tables

4. apply table constraints, grant authorizations, udf creation and then the statistics.

Is this correct?

The reason I'm asking is applying all of the DDL and then doing the db2move leaves some of my
tables in a pending state (those having dependency on other tables). Simply, taking them and doing
a set integrity <table> immediated checked seems kind of risky.

Thanks in advance...

--

Doktor Faustus

- Nobilitas sola est atque unica virtus -
 - Virtue is the one and only nobility -

                                Cato



Tue, 14 Sep 2004 23:30:10 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. DB2MOVE problem when moving from EE to WG on Linux

2. Moving data from Intel to Alpha platform problem

3. Moving SqlServer 6.5 Backup / Dumps Between Alpha and x86 Platforms

4. Moving to a new hardware platform

5. Moving DB from NT to other Platforms

6. Cannot move database (copy) in other directories (NT Server Platform)

7. Moving a database across platforms

8. help: moving database between platforms

9. Moving from 10 to 11 across platforms

10. Moving to Linux platform

11. Copy/Move db, same platform, different server

12. R91...Can It Move Beyond A G.A. Platform???


 
Powered by phpBB® Forum Software