Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    hyderabad
    Posts
    10

    Unanswered: unable to drop table

    hi

    when i am trying to drop a table it is giving me a error saying

    SQL0290N Table space access is not allowed. SQLSTATE=55039

    what is the meaning of this error message . this table is located on a tablespace by name tsddept and the user is having privileges on this tablespace but why is this error coming and there by not allowing me to drop the table.


    DB2V8
    WINDOWS2000

    bye
    ramakrishna

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

    Re: unable to drop table

    There could me many reasons ...
    were you doing a LOAD on the table or another table in the tablespace ?

    Have a look at the output of

    db2 list tablespaces
    or

    use the control centre to check the tablespace state details

    Cheers
    Sathyaram

    Originally posted by ramakrishna
    hi

    when i am trying to drop a table it is giving me a error saying

    SQL0290N Table space access is not allowed. SQLSTATE=55039

    what is the meaning of this error message . this table is located on a tablespace by name tsddept and the user is having privileges on this tablespace but why is this error coming and there by not allowing me to drop the table.


    DB2V8
    WINDOWS2000

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

Posting Permissions

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