Hi,

When i try to do a Schema copy using ADMIN_COPY_SCHEMA i am getting an error which is mentioned below.

C:\Program Files\IBM\SQLLIB\BIN>db2 "call admin_copy_schema('DB2ADMIN','V','COPYNO','DB2ADMI N','USERSPACE1','USERSPACE1','DB2ADMIN','EMPLOYEE' )"

SQL0443N Routine "ADMIN_COPY_SCHEMA" (specific name "*CHEMA") has returned an error SQLSTATE with diagnostic text "Creation of target schema failed sqlcode:-552". SQLSTATE=38000

Can anyone help me in fixing this issue?

Thanks in advance.

Regards,
Vinod

..............