Hello,

I am a n00b here. So, question how do I change the schema of a database? Currently, I login to windows as administrator and I want to change the schema to admin. I have also added the admin user to my windows users group. I beleive admin also belongs to the db2admin group..

Thanks!

What do you mean to change the schema of a database?

Andy

owner/creator?

There are two new system supplied stored procs to do this

ADMIN_COPY_SCHEMA
ADMIN_DROP_SCHEMA

You can search the doc or google to get input parms. The only problem I found is that it does not reset the sequences or identity columns to the same value as the old schema.