Answer Posted / ashish kumar

A DB2 bind is a process that builds an access path to DB2
tables.

A BIND process establishes a relationship between an APPLICATION
PROGRAM and its RELATIONAL DATA.
A plan is an executable module containing the access path logic
produced by the Db2 optimizer. It can be composed of one or
more DBRMs and packages.
The plans are available in the Catalog table SYSIBM.SYSPLAN

DB2 Bind compiles all your sql statements(dbrm) into an
executable format.
It uses DB2 Optimizer to create the better access path.
Package is the executable access path code for the sql
statements in the DBRM

Plan contains package list which is nothing but pointers to
packages.

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3223

---

How to find the number of rows in db2 tables?

1078

---

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

2227

---

What is the picture clause of null indicator variable?

1145

---

How do I add a column in db2?

1055

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2341

---

Why cursor is used in db2?

1042

---

What is bufferpool in db2?

1059

---

What is a db2 package?

1072

---

what is utility for parm lib

2390

---

What is reorg?

1170

---

What is consistency token in db2?

1155

---

What is load replace in db2?

1005

---

What are db2 tables?

1133

---

What do you mean by cursor?

998

---