Results 1 to 11 of 11
  1. #1
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72

    Question Unanswered: DB2 Tablespace Accessing Issue

    Hi everyone,

    I am new to DB2 UDB database environment and can anyone please clarify my problem though it looks silly...

    Scenario:

    Database : DB2UDB v7.2
    Server OS : AIX 5
    Error code : SQL0290N Table space access is not allowed. SQLSTATE=55039

    Getting the same error when trying to execute any of these:

    1) drop any object, tablespace and even database itself.
    2) Insert data into tables.

    My Observation:

    1) Found the filesystem FULL (96% USED) on which the tablespace residing.
    2) No records(rows) in all the table in the database. I mean database is empty.
    3) No any other files in this filesystem's directory.

    What could be the reason for filesystem being FULL. And is this the reason for the above mentioned error code?

    Note: I am able to work with other database created with same kind of parameters with different names.

    Thanks in Advance...

  2. #2
    Join Date
    Oct 2003
    Posts
    5
    In DB2, tablespaces have a USE privilege. This must be granted to a user or group before they can access the tables in that tablespace.

    The syntax is:

    grant use of tablespace MYTBLSPC to USERNAME

    The grantor must have sufficent authority (usually DBADM) to make the grant. The grant is often made to public, so that all other users and groups inherit the privilege.

  3. #3
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72
    Hi

    Thanks for the response.
    I am trying to execute the queries with instance owner.

    ...Ram

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    This is not a security/authorization problem ... It has to do with the state of the tablespace ...

    Connect to the database and issue

    db2 list tablespaces show detail ...

    Check the status of the tablespace(s) in question ... I assume they are not in 'Normal' status ...

    Depending on the state, a corrective action is needed ...

    Please let the forum know how things go ...

    Cheers
    Sathyaram

    Originally posted by nagasurir
    Hi

    Thanks for the response.
    I am trying to execute the queries with instance owner.

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

  5. #5
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72
    Yes,

    You are absolutely right.

    The state of the tablespace is not "NORMAL". It is "QUISCEDHARE".
    But when I create the tablespace, it was Normal only. How to change the "state" here?

    Thanks Satyaram....

    ...Ram

  6. #6
    Join Date
    Nov 2010
    Posts
    21
    have you ran load on any of the tables...that may be in load pending state..

  7. #7
    Join Date
    Oct 2007
    Posts
    246
    try

    list tablespaces show detail

    @ the tablespaces which is in quiesce share mode at end you will get the tablespace id and table id, find the name of table from that

    to bring back tbs to normal mode
    quiesce tablespaces for table schemaname.tablename reset
    will bring back to normal state.

    regds
    Paul

  8. #8
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I think the OP fixed the problem about 7 years ago.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  9. #9
    Join Date
    Oct 2007
    Posts
    246
    oops didn't chk the datetime ;-)

    the no of VIEWS hit should have been indicated that

    regds
    Paul

  10. #10
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    never mind Paul.. Someone else having a similar problem will find your post useful

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

  11. #11
    Join Date
    Oct 2007
    Posts
    246
    thks man

Posting Permissions

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