- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How LOST UPDATE and DIRTY READ impact the processing of a COBOL-DB2 program?
The LOST UPDATE and DIRTY read issues are related to concurrency. The concurrency is defined as the ability of two or more applications to access the same table data.
The LOST UPDATE impacts the processing of COBOL-DB2 programs in the following way.
Suppose there are 2 application programs — PROG A and PROG B which are trying to access the same row of ORDERS DB2 table. PROG A and PROG B read a row from the ORDERS table with ORDER_ID = ‘Z87661’ at the same time. PROG A updates some data in this row and commits the changes. PROG B now updates the same row and commits the changes but the changes done by PROG A will be overlaid.
The DIRTY READ impacts the processing of COBOL-DB2 programs in the following way - Suppose there are 2 application programs - PROG A and PROG B - PROG A inserts a new row in ORDERS DB2 table. PROG B reads that newly inserted row from the ORDERS table. PROG A now ROLLBACK the insertion of the new row. PROG B is now having a row which does not exist in the ORDERS table.
- Related Questions & Answers
- How NON-REPEATABLE READ & PHANTOMS impact functioning of a COBOL-DB2 program?
- Impact of database downtime on the COBOL-DB2 program
- How to precompile a COBOL-DB2 program?
- What is the purpose and usage of “FOR UPDATE OF” clause in a COBOL-DB2 program
- Purpose and usage of SAVEPOINT in COBOL-DB2 program
- Implementation of restart logic in a COBOL-DB2 program
- Steps involved in compilation of a COBOL-DB2 program
- How to execute a COBOL-DB2 program PROGA of plan PLANA?
- How can you revert all the DB2 table changes done in a COBOL-DB2 program?
- Behaviour of a COBOL-DB2 program when number of locks exceed the limit
- What is the purpose and usage of SQLCODE within the SQLCA in a COBOL-DB2 program
- How to get the list of all COBOL-DB2 programs using a DB2 table TAB1?
- How to store a NULL value in a particular column of a DB2 table using COBOL-DB2 program?
- What is dirty read in a transaction(DBMS)?
- How to use SQLCA in a COBOL-DB2 program? What is the purpose of SQLCA?