Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Unanswered: Admin copy schema error

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by the manual

    SQL0552N
    authorization-ID does not have the privilege to perform operation operation.

    Explanation
    Authorization ID authorization-ID attempted to perform the specified operation without the proper authorization.
    ..............

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •