What will you face SQLCODE 911?
At the time of deadlock or timeout you will face SQLCODE -911.
Where is SQL error code in DB2?
The error diagnostic containing the SQL Return Code is held in the field SQLCODE within the Db2 SQLCA block.
What is the error code for deadlock in DB2?
The current unit of work was the victim in a deadlock, or experienced a timeout, and had to be rolled back. The reason code indicated whether a deadlock or timeout occurred.
What is cursor in Db2?
Db2 has a mechanism called a cursor . Using a cursor is like keeping your finger on a particular line of text on a printed page. In Db2, an application program uses a cursor to point to one or more rows in a set of rows that are retrieved from a table.
How is data physically stored in Db2?
DB2 physically stores the data in VSAM files (LDS). The same can be found out by typing the command ‘DS’ in front of the table name in BMC.
What is SQL error in DB2?
SQL Error Code is used on a day to day basis for the diagnosis of programming failures as a result of SQL calls by DB2 computer programs. An important feature of DB2 programs is the error processing. The error diagnostic containing the SQL Error Code are held in the field SQLCODE within the DB2 SQLCA block.
What is 911 Db2 error?
-911 THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON reason-code , TYPE OF RESOURCE resource-type , AND RESOURCE NAME resource-name.
What causes deadlock in Db2?
A deadlock occurs when two or more application processes each hold locks on resources that the others need and without which they cannot proceed. After a preset time interval, Db2 can roll back the current unit of work for one of the processes or request a process to terminate.
What is Rowset in DB2?
ROWSET processing is a group of rows for the result set of a query that is returned by a single FETCH statement. You can control the number of rows you want to fetch and return by specifying rowset limit in your program.