Hello,

I have several questions :

1. How to change the schema name of all the tables in a database without using db2move?

2. How to change the table owner for a table?

3. If db2move should be used, can it support data types such as BLOB and identity?


Thanks a lot.

I don't think you can change the qualifier for
a table. You can create a new table like the old
one with another qualifier. i.e.

create table <newschema>.<tablename> like
<oldschema>.<tablename>

And erase the original one.

The owner(creator) of a table is recorded as the qualifier
at creation time, in sysibm.systables.
You can specify a creator by explicitly qualifying the table,
but I don't think you can change it afterwards

BOW