Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: fixpack problem?

    when trying to execute a sql-statement via CommandCenter or via CommandLineProcessor I recieve Error
    SQL0551N "BRPT" does not have the privilege to perform operation "EXECUTE" on
    object "NULLID.SQLC2D04". SQLSTATE=42501
    since we've upgraded to command center v7.2 fix pack 11

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by toby25
    when trying to execute a sql-statement via CommandCenter or via CommandLineProcessor I recieve Error
    SQL0551N "BRPT" does not have the privilege to perform operation "EXECUTE" on
    object "NULLID.SQLC2D04". SQLSTATE=42501
    since we've upgraded to command center v7.2 fix pack 11
    Rebind your packages per the Fixpack README.

    From sqllib/bnd:
    db2 "bind @db2ubind.lst blocking all grant public"
    db2 "bind @db2cli.lst blocking all grant public"
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Sep 2003
    Posts
    63

    Exclamation

    I did execute those 2 commands but its still not working.
    I am still getting SQL0551N "user1" does not have the privilege to perform operation "EXECUTE" on
    object "NULLID.SQLC2D04". SQLSTATE=42501

    has anyone tried anything different apart from running those 2 bind commands to resolve this fixpack 11 problem with command center.

    Thanks,
    toby

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Grant EXECUTE on that package only and see what happens

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Sep 2003
    Posts
    63
    That one worked. Thanks.

Posting Permissions

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