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...

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.

Hi

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

...Ram

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

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

have you ran load on any of the tables...that may be in load pending state..

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

I think the OP fixed the problem about 7 years ago.

oops didn't chk the datetime ;-)

the no of VIEWS hit should have been indicated that

regds
Paul

never mind Paul.. Someone else having a similar problem will find your post useful

Cheers
Sathyaram

thks man