Answer / Priyal Gupta

The default page size of buffer pools in DB2 depends on the platform. On z/OS, it's 4KB (4096 bytes), while on Linux, Windows, and UNIX, it's typically 8KB (8192 bytes).

Update command

1 Answers  

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

1 Answers   IBM,

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

What is the syntax for creating a table in the db2 database?

1 Answers  

---

What is auditing?

2 Answers  

---

On which levels locks can be applied?

1 Answers  

---

What is the result of open cursor statement?

1 Answers  

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---