IBM Support

SQL0290N Table space access is not allowed, may be thrown while trying to connect to database.

Troubleshooting


Problem

Trying to connect to database, may sometime hit with "SQL0290N Table space access is not allowed", even though tablespace containers path are accessible and exists and container permissions are correct.

Symptom

Following error may be thrown in this case:

$ db2 connect to sample    

SQL0290N Table space access is not allowed. SQLSTATE=55039

Cause

Any of the following could be the reason:
1) Database's file system not mounted.

2) root file system is full.

Diagnosing The Problem

Check the following:
1) Check db2diag.log file to see if there are any error messages stating something like database's path and files are not accessible.

2) "df" command to check if root file system is full.

For Example : $df


3) Run "lsvg -l rootvg" command to check if database's file system are in closed/sync state

For Example : $lsvg -l rootvg

Resolving The Problem

Mount database's file system and enlarge root file system size then retry operation again.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Tablespaces","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21608111

Page Feedback