Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    12

    Unanswered: Table space access is not allowed

    Hi All,

    Environment: Windows 2003 Server sp2, db2 9.5

    Error: SQL0290N Table space access is not allowed. SQLSTATE=55039

    I faced the following above error from today. Kindly help me.

    Detail:
    db2 windows services are running.
    When I connect to db2 command line editor, I am unable to execute any SQL statements to see any table results.

  2. #2
    Join Date
    Apr 2012
    Posts
    12

    Table space access is not allowed

    Hi All,

    I have also noticed the table space statuses through the following command 'SELECT TBSP_STATE FROM SYSIBMADM.SNAPTBSP_PART', and I found 'ROLLFORWARD_PENDING' status for MAXDATA table space.

    Kindly help me How to fix it? So that MAXDATA table space should come back with 'NORMAL' status.

  3. #3
    Join Date
    Jul 2004
    Posts
    306
    DB2 Universal Database

    Was there a restore operation performed?
    Have you Googled "ROLLFORWARD_PENDING"?
    Last edited by meehange; 04-15-12 at 21:06.

  4. #4
    Join Date
    Apr 2012
    Posts
    12
    I fixed the Issue by using 'Rollforward' command.

    Thanks.

Posting Permissions

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