Answer Posted / yuvaevergreen

>>Explain can be used to improve the performance of queries.
>>Explain command populates three tables
PLAN_TABLE,DSN_STATEMNT_TABLE,DSN_FUNCTION_TABLE. These
tables contains various info about the queries which can be
used for improving the performance.
>>Step1:PLAN_TABLE must be created.
>>Step2:Use explain sql or explain option in Bind to
populate the tables.
>>For example,explain plan set queryno=01 for select empname
from employee;
This would populate plan and statement table.Assigned
queryno would be 01.
>>Alternately EXPLAIN(YES) in BIND option.
>>Only select,insert,update,select for update,delete, delete
current of cursor,update current of cursor can be used in
explain.

What are host variables in db2?

1072

---

What is db2 stogroup?

1161

---

What is null value in db2?

1026

---

List down the data types in the db2 database.

1124

---

Explain in detail about buffer manager and its functionalities?

1067

---

What does a deadlock mean in DB2?

1169

---

How does a cursor work?

992

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2070

---

Which component is responsible for db2 startup and shutdown?

1036

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1061

---

What do you mean by commit and rollback?

1046

---

What is dclgen in db2?

1150

---

What is the difference between cursor and select statement?

1106

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1737

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1077

---