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 |
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What do you need to do before you do EXPLAIN ?
What is cloudant database?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
where can we use index and subscript ? with example ?
What does runstats do in db2?
How does DB2 use multiple table indexes?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What is access path in db2?
How many buffer pools are there in DB2?
Can we declare DB2 HOST variable in COBOL COPY book?