Answer Posted / suresh ramaiyan

As Sharath requested...

As we all know, all our programming(high level language) needs to be converted(compiled) into system-understandable(low level language) to be executed.
So, SQL statements in the COBOL programs needs to be compiled, such process is called BIND. DB2 Bind compiles all your sql statements(dbrm) into an executable format.
BIND also verifies all the information in the program with DB2 databases..
Here are the list of items happening through out BIND process (as of I know :) )
1. Syntax check of SQL query
2. Availability of Tables & columns in the database
3. It uses DB2 Optimizer to create the better access path. A clear way to read/update/delete table. like.. what are the columns are reading, which indexes needs to be used, the table space..etc.

So after BIND process finished, the Package/Plan contains exactly how to do, what we meant to do in system understandable language.

Hope it helps.. My apologies, if I confused or missed something.

What is commit in db2?

1059

---

What is copy pending and check pending in db2?

1005

---

Are view updateable?

1046

---

What is explain plan in db2?

999

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1149

---

What kind of database is db2?

1038

---

What is page size in db2?

978

---

What does db2 stand for?

1027

---

what is db2 restart?

2162

---

What are bind parameters in db2?

1048

---

What is cursor in dbms?

1072

---

What is ibm db2 client?

940

---

What is a db2 cursor?

1057

---

How to take backup of table in db2?

1079

---

What does a deadlock mean in DB2?

1169

---