I am unable to read data from tables .Please see the screen shot for table lock information .

the code means:

68 transaction rolled back due to lock timeout.

You can avoid this by setting an appropriate value for the LOCKTIMEOUT database config param, and making sure that your apps commit (to release locks).

you can check this site to learn more about db2 technology
http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp

Thepanch do you know whey it's creating super exclusive lock for even fetch operations also .

super exclusive locks  is a 'special waiter' lock, designed specifically to wait for anyone with a conflicting lock to leave while never starving new lock requests coming in.

So someone out there isn't releasing their table lock - either a connection never does commit/rollback or does only commits with hold so that the table lock is never released.

that could be happening.

Now i remember, that happens also when any table is doing index reorganization, or the db is doing manteinance job, that super exclusive lock means the DB/Table is busy and you cant do nothing, like if someone has a transaction pending with no commit, and you are triying to select from that table.

Thepanch is it not release those locks from our end .I have all admin rights available on db . My SBA is out of office .I need to start my application . But application unable to read data from tables due to super exclusive lock .

Thepanch is it not possible to release those locks from our end

Some what helpful not exactlky