Answer Posted / s

changes to the table are logged in a the active logs and
archived when the active logs become full. In recovery
situations the tablespace is restored using the image copy
and applies the log records from the active/archive logs to
current time.

B37 abend during spufi?

1405

---

What is dclgen (declaration generator)?

1010

---

Why do we use cursor?

1048

---

What is scrollable cursor in db2?

996

---

What is a page in db2?

980

---

Is db2 a programming language?

983

---

How to take backup of table in db2?

1021

---

What is the role of union all and union

1069

---

Is db2 a mainframe?

968

---

What is the difference between oracle and db2?

1031

---

What is consistency token in db2?

1061

---

List out the buffer pools in db2

1020

---

Can you use max on a char column?

1027

---

Outputs of explain are with matchcols = 0. What does this signify?

991

---

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

1054

---