Answer Posted / deepthy

-911 and -913 are the sqlcodes for deadlock. But DB2 attempts
to roll back the SQL for one of the application
processes. If the
ROLLBACK is successful, that application receives
SQLCODE -911. If the
ROLLBACK fails, and the application does not abend,
the application
receives SQLCODE -913.

How do you select a row using indexes in db2?

1135

---

What is a db2 package?

1053

---

Explain the function of data manager.

1044

---

How to check sequence on a table in db2?

1060

---

Is db2 a database?

967

---

How to find the number of rows in db2 tables?

1070

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1105

---

What are the rules for db2 programming?

1087

---

What is image copy in db2?

1016

---

What is null value in db2?

1024

---

what is the role of the cursor in db2?

1066

---

Name the various locking levels available?

1091

---

What is the physical storage length of the data types date, time, and timestamp?

1086

---

What is bind in db2?

1042

---

What does runstats do in db2?

1116

---