Answer Posted / sudipta

first ckeck the ststus of the table by using the query:-

load query table <tab_name>;

load query table <tab_name> set all immidiate unchecked;

after the command execute all pending state will be removed

Mention the location where the output received from explain statement is stored.

1053

---

What is db2 purescale?

942

---

What is db2 plan table?

992

---

What is runstats utility in db2?

961

---

How do I add a column to a table in db2?

1048

---

What is db2 command?

962

---

Is ibm db2 open source?

1012

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2166

---

Which are the db2 tools to protect integrity of the database?

1070

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8991

---

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?

8132

---

Highlight all the advantages that are attached to a package.

1071

---

What is explain in db2?

958

---

What is db2 connect?

1008

---

What is the meaning concurrency in the db2 database?

1055

---