In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by rollback?
Which component is responsible for db2 startup and shutdown?
Explain packages.
What is explain plan in db2?
How to check sequence on a table in db2?
When the like statement is used?
What is difference between *omit and *nopass?
Which catalog table stores referential constraints?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What is isolation level in db2?