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

Posted on 2007-07-26
Last Modified: 2012-05-05
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
Question by:assyst
    LVL 11

    Accepted Solution

    LVL 13

    Assisted Solution

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage…
    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now