Answer Posted / hemant

see man first of all we need to know full form of sql..it
is structured query language...now why we use sql.this
question arises

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1264

---

Which component is responsible for processing sql statements and selecting access paths?

1119

---

What does runstats do in db2?

1096

---

What happens in bind step in a db2 program?

964

---

What is a page in db2?

1023

---

How many types of page locks can be held in db2?

1033

---

What are host variables in db2?

1044

---

What are the two types of logging in the db2 database? Explain them.

1063

---

What is load utility in db2?

1177

---

Mention the definition of cobol in varchar field.

1237

---

What is with ur in db2?

1297

---

When do you specify the isolation level?

1024

---

How would you find out the total number of rows in a db2 table?

1045

---

What is catalog database in db2?

1154

---

What are bind parameters in db2?

1039

---