Interested to Buy Any Domain ? << Click Here >> for more details...
What is QUIESCE?
- 2 Answers
- 13065 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
QUIESE is used to establish a consistency point for the
named tablespaces. It issues a drain lock to disallow any
further processing and allows the currently executing UOW
to commit. Writes all the changed pages from the buffer to
DASD. The RBA is noted in the SYSCOPY.
| Is This Answer Correct ? | 9 Yes | 0 No |
How do you prepare a COBOL + DB2 program from coading till execution ?
What is the advantage in De-normalizing tables in DB2?
The only place of VSAM KSDS in DB2 is?
How many databases are there?
Which components manage deadlocks in db2?
In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)
What are foreign keys in db2?
What is read-only cursor?
How to compare data between two tables in db2?
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?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the difference between plan and package in db2?
COBOL 
