Results 1 to 4 of 4

Thread: Tablespace woes

  1. #1
    Join Date
    Nov 2003
    Posts
    17

    Unanswered: Tablespace woes

    Hi,

    I am getting the following error:

    SQL0290N Table space access is not allowed. SQLSTATE=55039

    I list tablespaces and find that one is in Quiesce:
    - Detailed explanation: Quiesced: SHARE

    So in control centre I go to right-click on one of the tables in the offending tablespace, select Quiesce, and Quiesce reset. I then try and update / insert the table and then other tables and I get the same error.

    So, I try in command centre, enter the following for a different table in the same tablespace:
    - QUIESCE TABLESPACES FOR TABLE schema.table RESET

    Try and update / insert on this table and it fails, check the list tablespaces and find it is still: Detailed explanation: Quiesced: SHARE

    I am doing something wrong here or have I missed something out. Is there a direct command you can issue which will alter the tablespace state - i.e. Alter/Update tablespace tablespacename.

    I'll wait for any replies before tinkering anymore because i think thats what got me into this situation in the first place!

    Richard

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Tablespace woes

    I would do a quiesce reset on all tables in the tablespace

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2003
    Posts
    17

    Re: Tablespace woes

    Yep, I tried that but no sucess, however I did each table individually. Is it possible to actually say - 'quiesce reset all tables in tablespace' in one sql statement?

    Its not a major problem now as I backup each evening and was able to recreate the db from last night's backup. Just more out of curiosity now as to why I couldn't change the state - I am going to hang on to that db for a little while and see if there is anything else that can be done.

    Cheers
    Richard



    Originally posted by sathyaram_s
    I would do a quiesce reset on all tables in the tablespace

    Cheers
    Sathyaram

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    The quiesce reset must be done by the id which quiesced the table in the first place. However, if another id tries to quiesce (in any manner) that table before the original user releases the quiesce, then it is very hard to get that quiesce released. In a partitioned environment, it is preferable to try and quiesce reset from the node from which the initial quiesce request was made. It is kind of sensitive.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •