• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 916
  • Last Modified:

table space quiesced exclusively ..load pending ,Table space access denied

Hi ,

I am getting following error in DB2 ver 7-
table space quiesced exclusively ..load pending ,Table space access denied

When i tried to load some sql and it interrupted during load. Now table got locked. How can i recover from this situation.

IBM DB2 ver 7
2 Solutions
link is good, usual long winded way of saying:
terminate the load!
if your load is 'interrupted' during processing, db2 has no way of knowing what you intended. So, it puts the tablespace in quiesce mode, which means no further transactions can take place for any table in the quiesced tablespace.
Fortunately, the load by default is logged, unless you specify otherwise. So, db2 can rollback all the transactions until the point of quiesce and 'clear' the tablespace. Thats why for all the users who like to load with nolog option, if the load gets 'interrupted', your only option is to restore the db.
To 'clear' the tablespace, use the exact same load command that you you interrupted, except replace the insert into clause with terminate into

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now