On Aug 12, 8:53 am, "Mark A" <nob...@nowhere.com> wrote:
> "Serge Rielau" <srie...@ca.ibm.com> wrote in message
>
> news:5i7dogF3nqcfoU1@mid.individual.net...
>
> > Mark I added the -td option to db2look myself in DB2 V7.2 to support SQL
> > functions. If you don't use it db2look will actually append a -- to each
> > line with a semicolon at least for triggers and functions.
> > (That should be changed to --#SET TERMINATOR)
>
> > Cheers
> > Serge
>
> Thanks for that tip. I never noticed that in the doc.

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