SQL0286N A default table space could not be found

07 July,2010 by Jack Vamvas


SQL0286N A default table space could not be found with a page size of at least "4096" that authorization ID "user1" is authorized to use. SQLSTATE=42727

This was after a DECLARE GLOBAL TEMPORARY TABLE type of statement
I had a look at the users permissions.They were


CREATE SCHEMA user1 ;
grant connect on database to user user1;
grant ALTERIN,CREATEIN,DROPIN on schema user1 to user user1;

The next test step was to create a tablespace for temprary tables and give USE permissions to "user1".
This solved the problem

 

CREATE USER TEMPORARY TABLESPACE usr_tbsp MANAGED BY AUTOMATIC

--and issue permissions :

GRANT USE OF TABLESPACE usr_tbsp TO USER user1

 Related Posts

SQL0293N Error accessing a table space container. SQLSTATE=57048 and LinuxSheild

DB2 USERSPACE1 is full

DMS Container Space Full

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL0286N A default table space could not be found

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright