Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

The portion of the database you require is in use.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
chhabraravneet

New User


Joined: 04 Oct 2007
Posts: 49
Location: Mumbai

PostPosted: Tue Feb 12, 2008 3:58 pm    Post subject: The portion of the database you require is in use.
Reply with quote

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????????????
Back to top
View user's profile Send private message

chhabraravneet

New User


Joined: 04 Oct 2007
Posts: 49
Location: Mumbai

PostPosted: Tue Feb 12, 2008 4:04 pm    Post subject: More INFO :
Reply with quote

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.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Tue Feb 12, 2008 6:19 pm    Post subject:
Reply with quote

Have you looked up what the -911 means in the manual?
Back to top
View user's profile Send private message
ravi17s
Warnings : 1

New User


Joined: 15 Aug 2003
Posts: 57

PostPosted: Fri Feb 15, 2008 2:40 pm    Post subject: Reply to: The portion of the database you require is in use.
Reply with quote

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.....
Back to top
View user's profile Send private message
vebs

New User


Joined: 27 Oct 2007
Posts: 19
Location: UK

PostPosted: Sun Feb 17, 2008 1:22 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
pcdoctor
Currently Banned

New User


Joined: 13 Feb 2008
Posts: 1
Location: Chennai

PostPosted: Sun Feb 17, 2008 8:36 pm    Post subject: Reply to: The portion of the database you require is in use.
Reply with quote

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"
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Require help in DB2 Query Shruti Takkar DB2 3 Wed Aug 03, 2016 10:57 pm
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us