Answer Posted / girish kumar

805- Token not found.
806- LOad module not found.
S013-18- Member not found.
502 - cursor not closed.
922- Authorization failed.
818 - Time stamp mismatch.
811 - Cursor not declared.
911- Dead lock
305 - Null indicator not defined.
311 - Length is not given for Var char.
S322 - Time out error.
S122 - Job canceled by the operator.
S222 - Operator cancel the job and doesn't request for dump
200 - Host variables not created.
204 - Table already crated.
551 - ID has no privileges to access the table.
803 - Index violation.

What is bufferpool in db2?

1049

---

Explain the function of data manager.

1044

---

What is bind in db2?

1036

---

What is the use of runstats in db2?

1102

---

What is the purpose of using commit?

1095

---

Describe major components of db2?

1089

---

Is db2 free?

1092

---

Before you give the explain statement, what are the prerogatives?

1028

---

What is the maximum size of a char data type in db2?

1010

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1044

---

What is a db2 collection?

1034

---

What is the role of union all and union

1121

---

What are the 2 sqlcodes that are returned?

1185

---

Is the primary key a clustered index?

1141

---

Explain the function done by data manager?

1274

---