What is sqlcode -922 ?

Answers were Sorted based on User's Feedback



What is sqlcode -922 ?..

Answer / sudha

authorization failure

Is This Answer Correct ?    25 Yes 0 No

What is sqlcode -922 ?..

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

Post New Answer

More DB2 Interview Questions

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  


What is runstats utility in db2?

0 Answers  


What is coalesce in db2?

0 Answers  


What is a DB2 plan?

8 Answers  


How to execute stored procedures?

0 Answers  






What is load replace in db2?

0 Answers  


Mention the various locks that are available in db2.

0 Answers  


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?

0 Answers  


What is a root page?

1 Answers  


Explain various types of locks in db2?

0 Answers  


What is a db2 schema?

0 Answers  


What is the difference between static and dynamic SQL?

1 Answers  


Categories