Answer / sudha

authorization failure

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.

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

What happens in bind step in a db2 program?

0 Answers  

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

List down the types of triggers in the db2 database?

0 Answers  

---

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

What is RUNSTATS?

3 Answers  

---

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---