What is a recovery log?
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.
Is This Answer Correct ? | 4 Yes | 0 No |
What is page size in db2?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
When do you specify the isolation level?
Explain the function done by data manager?
What does DML stand for and what are some examples of it?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
List down the data types in the db2 database.
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
How to execute stored procedures?
What kind of database is db2?