How to increase TableSpace's Pagesize for created db

[billytcj]

Hi all,
i got this error from my application. I found that my current in used tablespace only have 4kb. For sure I did assign right for user "EXPRESS" to acess the mentioned tablespace (Userspace1).

I guess to solve the following problem is to increase the pagesize of the tablespace, but i got no idea how to do it?
If cannot increase its size, what should i do to ensure the new created new have specific tablespace pagesize?


~~~~ ERROR ~~~~

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0286N A default table space could not be found with a page size of at least "4096" that authorization ID "EXPRESS" is authorized to use. SQLSTATE=42727

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown
Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown
Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown
Source)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(Unknown Source
)

 

[sathyarams]

You have missed to mention what statement in your application failed ....

I guess it is either a CREATE TABLE or DECLARE GLOBAL TEMP TABLE Statement ...

In the former case, have you granted USE privilege on Userspace1 to the user ..

In the latter case, the user needs this permission on User temp space ...

BTW, to check these permissions, you can select from syscat.tablespaceauth ...

If this doesn't solve your problem, you may try to post your piece of code causing this error and the tablespaceauth of the tablespaces #

HTH
Sathyaram



More DB2 questions answered at

http://www.dbforums.com/f8

 

[billytcj]

Thanks again sir, u are right! i am in the progress of creating "DECLARE GLOBAL TEMP TABLE" in DB2 8.1. To solve this problem, just need to create a tablespace (using type User temporary). And before use it assign mentioned user to have right to access it. Then it will work already!!!