Answer / 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.

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---

How to find the number of rows in db2 tables?

0 Answers  

---

What is a SELECT statement?

1 Answers  

---

What is ALTER ?

3 Answers  

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

How do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

What is the use of db2 optimizer?

0 Answers  

---

Are views updatable ?

4 Answers  

---

What does the REORG Utility do?

2 Answers  

---