Answer / s

QUIESE is used to establish a consistency point for the
named tablespaces. It issues a drain lock to disallow any
further processing and allows the currently executing UOW
to commit. Writes all the changed pages from the buffer to
DASD. The RBA is noted in the SYSCOPY.

Answer / sunil1405

Its an utility to flush all the buffers

Explain what a plan is?

3 Answers   CTS,

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

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....

1 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

Compare a subselect to a join?

1 Answers  

---

How to retrieve rows from a db2 table in embedded sql?

0 Answers  

---

What are packages in db2?

0 Answers  

---

How does DB2 determine what lock-size to use?

2 Answers  

---

Explain the EXPLAIN statement?

1 Answers  

---

Is it possible using max on a char column?

0 Answers  

---