Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    16

    Unanswered: DB2 Tablespace Access

    I got the the error of table space access when issuing a query.
    "SQL0290N Table space access is not allowed. SQLSTATE=55039"

    Does anyone have any idea of how to solve this error or get around this error? I guess it might be related to the user privilege. Since I am using the local DB2 server and has the system administrator privilege, it should not happen. Not sure if what might has caused the privilege problem like conflict with other software installation. How to verify the privilege of my db2 account? Thanks!

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

    Re: DB2 Tablespace Access

    Check the status of the tablespace in question using the command

    db2 list tablespaces show detail

    Take action accordingly .... Also have a look at db2diag.log for any messages

    HTH

    Cheers

    Sathyaram


    Originally posted by alex_db
    I got the the error of table space access when issuing a query.
    "SQL0290N Table space access is not allowed. SQLSTATE=55039"

    Does anyone have any idea of how to solve this error or get around this error? I guess it might be related to the user privilege. Since I am using the local DB2 server and has the system administrator privilege, it should not happen. Not sure if what might has caused the privilege problem like conflict with other software installation. How to verify the privilege of my db2 account? Thanks!

  3. #3
    Join Date
    Jun 2005
    Posts
    4
    useless reply - you cannot start the database to run the command "list tablespaces show detail"

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ostryjak
    you cannot start the database
    Cannot start the database? Why not?
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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