var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table space access is not allowed
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.
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.
Table space access is not allowed
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.
DB2 Universal Database
Was there a restore operation performed?
Have you Googled "ROLLFORWARD_PENDING"?
Last edited by meehange; 04-15-12 at 21:06.
I fixed the Issue by using 'Rollforward' command.