The portion of the database you require is in use.

chhabraravneet · New User Joined: 04 Oct 2007 Posts: 49 Location: Mumbai

I am trying to update a table, but it is giving me that "The portion of the database you require is in use"
I have logged off then and again tried to update the table. Then also it is giving me the same problem.
It is not updating even a single field either through QMF or SPUFI or FILE_AID...

Please suggest????????????

chhabraravneet · New User Joined: 04 Oct 2007 Posts: 49 Location: Mumbai

It is giving me timeout -911 in the SPUFI and
"The portion of the database you require is in use" error in the QMF.

If anybody knows whats the mistake please let me know???

Thanks.

stodolas · Posted: Tue Feb 12, 2008 6:19 pm

Have you looked up what the -911 means in the manual?

ravi17s · New User Joined: 15 Aug 2003 Posts: 57

By refering the manuals U learn a lot.....

-911,Deadlock or Timeout, may be some other transactions or Program holding the lock on the tables whihc u r trying to update.

Ur Update query will wait for the specified time to get the access and over a certain time limit db2 throws -911.

Try using -DIS DB(AAAAA) Space(AAAA) locks.....

vebs · New User Joined: 27 Oct 2007 Posts: 19 Location: UK

Ravneet,

In the SQLCA, you will get the identifiers of the object that is causing this timeout, and you can query in SYSIBM tables to know which database object is causing this timout. Pls paste the SQLCA o/p for more assistance.

pcdoctor · New User Joined: 13 Feb 2008 Posts: 1 Location: Chennai

To add to all this..This normally occurs cuz of a Check Pending status and might also be a result of violating the referential integrity between the tables..So better you can check as to wat are the other tables related to this one and ensure referential integrity is maintained..if you are correct from your side then might be the person who has used the tablespace before mite have violated the referential integrity and so all tables in that tablespace would be locked..best soln would be to contact your DBA and bring the tablespace out of this lock..

"Force to get wat u lyk, else you will be forced to lyk wat u get"