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...
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.
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"