What is sqlcode -922 ?
Answers were Sorted based on User's Feedback
Answer / kanagaraj
Yes correct. In this case plan is exist but your racf
doesn't have privilage to access that plan.
It will be reslove by below command
grant execute planname to PUBLIC
you need to execute this command under creator of the plan
because plan owner have the full access.
Is This Answer Correct ? | 15 Yes | 2 No |
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is runstats utility in db2?
What is coalesce in db2?
What is a DB2 plan?
How to execute stored procedures?
What is load replace in db2?
Mention the various locks that are available in db2.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is a root page?
Explain various types of locks in db2?
What is a db2 schema?
What is the difference between static and dynamic SQL?