Answer Posted / ashish
Deadlock issue you get when suppose same table is being used
by many applications. The first solution is you should wait
for a while til other users use it. or you can get the
utility thread kill by Database Administrators.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How is a typical db2 batch pgm executed?
What is dbrm? What it contains? When it will be created?
What language is db2 written in?
Define db2 and its databases?
What is a system catalog table in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What does reorg do in db2?
Mention the different locking levels that are available in db2.
How to take backup of table in db2?
What is the difference between cursor stability and repeatable read isolation levels?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How to check last update on table in db2?
What is buffer pool in the db2 database?
What is drop table?
If I have a view which is a join of two or more tables, can this view be updateable?