Debug issue "SET CLIENT DEBUGINFO" error

Toad for IBM DB2
1

This error happens in our SIC environment but not in our DEV environment.

Steps:

  1. Set the dilimeter.
  2. Find the procedure.
  3. Right click on it and click “Alter Procedure…”
  4. Right click on it and click “Compile SQL Procedure with Debugging“
  5. Right click on it and click “Debug”
  6. Debugger Start Parameters dialog pops up.
  7. Enter the parameter.
  8. Click the “OK” button

BAM!!! Get this error:

ERROR [42501] [IBM][DB2/NT64] SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "FACTSDB ". Operation: "SET CLIENT DEBUGINFO". Object: "FACTSSIC".

We don’t get this error in the “FACTSDEV” database.