Hi friendz,
I have copied a schema using the below command:

call sysproc.admin_copy_schema ('schema2', 'copysch', 'copyno', 'user1', 'userspace1', 'userspace2', 'COPYSCHEMA', 'COPYERROR')

I can see the table under the new schema 'copysch' and from control center can also access the data but I am not able to access data from CLP.


C:\Documents and Settings\user1>db2 select * from copysch.ACT
SQL0204N "COPYSCH.ACT" is an undefined name. SQLSTATE=42704

I suspect that the sysproc.admin_copy_schema procedure created the new schema as lowercase. If that is the case, then your queries must be like this:

Andy

Yes, the new schema is created in lower case. But the provided query does not help. I have tried things out and concluded that schema name always has to be in uppercase.
Thanks for the hint about the case sensitivity

Well, I had one more query. I can find no difference in the copymode option of " copy and copyno" in ADMIN_COPY_SCHEMA. using copy option did not took my database in backup pending state as documented. Can you help me list the difference between these two option?