Tags

, , , , , , , , , , , , , ,

Many a times your job fails with contention issues (SQLCODE -911) as DB2 table is in contention with some other process. At this time, get the database name and tablespace name of your DB2 table and execute below DB2 commands.

Follow the below steps to run the DB2 commands.
1. Go to DB2I(DB2 interactive functions).
2. Select your DB2 subsystem.
3. Go to option 7 (DB2 commands).
4. Use the below commands
-DIS DB(dbname) SPACE(tsname) LOCKS
-DIS DB(dbname) SPACE(tsname) USE LIMIT(*)

Above DB2 commands will give the status on the tablespace and also will let you know users/process accessing the tablespace.

Advertisements