On Aug 14, 11:44 am, "Mark A" <nob...@nowhere.com> wrote:
> "Rahul B" <rahul.babb...@gmail.com> wrote in message
>
> news:1187067418.500478.35040@m37g2000prh.googlegro ups.com...
>
>
>
> > Hi,
>
> > Can we take a dump/backup of a schema with the following db2move
> > command.
>
> > db2move <DB_NAME> export -tc <SCHEMA_NAME>
>
> > It gives the ixfs of all the tables and db2look for the other db
> > objects.
>
> > Since you didn't suggest it, i assume that this will miss something.
>
> > What could be the problem with taking a dump like this.
>
> > Thanks again
>
> > Rahul
>
> Importing an IXF when the table does not already exist on the target will
> create the new table and PK, but will not create referential constraints and
> foreign key definitions. There are probably some other column or table
> attributes that are also not automatically created on a new table with IXF
> files , but I don't know them off-hand.
>
> The best procedure is do the db2look on the schema, create the new schema on
> the target, then do a db2 move on the data. However, I prefer to strip the
> FK's out of the db2look output into a separate file and run them after the
> db2move import/load in order to avoid check pending issues.

Thanks Mark.

I agree that should be the way.

Rahul