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.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the picture clause of null indicator variable?
How does a cursor work?
Mention data types used in db2 ?
what is the sqlcode -501
How do I delete a table in database?
How do I import data from excel to db2?
What is isolation level in db2?
What is the purpose of using commit?
What is the maximum number of columns in a db2 table?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is clone table?
What action db2 takes when a program aborts in the middle of a transaction?
How to find the maximum value in a column in the db2 database?
How do I connect my db2 database to ibm?
What is scrollable cursor in db2?