Hi,

I am using DB2 8.1 on solaris.

I am confused abt the difference between -tc and -sn parameters of db2move command.

to my understanding -sn is for schema names and -tc is for table creator.

doubt : what is the diff between table creator and schem name, Is table creator not the schema owner?

Thx in Adv

Mohd

If user db2inst1 does a "create table test.department ..." then the schema is test and the creator (or definer) is db2inst1.

If user db2inst1 does a "create table department ...", then the schema and creator are the same (db2inst1).

Thx marcus.