Answer / shyam

In the Plans or packages which has the Static SQL's,
Authorization check is done based on the VALIDATE parameter
in BIND control card ..If VALIDATE(BIND), Authorization
check is done during the BIND time. If VALIDATE(RUN),
Authorization check is done during the run time.

For the plans or packages having Dynamic SQL's ,
Authorization check is done during the run time.

Shyam

What are union and union all?

1 Answers  

---

Which component is responsible for db2 startup and shutdown?

1 Answers  

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What do you mean by rollback?

1 Answers  

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

3 Answers  

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

How to find schema of a table in db2?

1 Answers  

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

where will u check for sqlcode ?

2 Answers   TCS,

---

Explain about mirror activator disk mirroring?

1 Answers  

---

What is null value in db2?

1 Answers  

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---