find default tablespace

[kw.housing]

is there a way to tell the current tablespace for tables i create without IN
clause?

i know i can do that by create a table and select its tablespaceid from
syscat

any better solutions?

[Pierre StJ]

On Mar 28, 2:14*pm, "kw.housing" <[e-mail]:

is there a way to tell the current tablespace for tables i create without IN
clause?

i know i can do that by create a table and select its tablespaceid from
syscat

any better solutions?

Yes. The default tablespace is:
A) The first tablespace your id has created.
B) If A) does not exist then it is the first tablespace where you have
the USE priviloege.
C) If neither A) nor B) exist then it is USERSPACE1
Regards, Pierre.

[Joachim Klassen]

On 29 Mrz., 02:28, Pierre StJ <[e-mail]:

On Mar 28, 2:14 pm, "kw.housing" <[e-mail]:

is there a way to tell the current tablespace for tables i create without IN
clause?

i know i can do that by create a table and select its tablespaceid from
syscat

any better solutions?

Yes. The default tablespace is:
A) The first tablespace your id has created.
B) If A) does not exist then it is the first tablespace where you have
the USE priviloege.
C) If neither A) nor B) exist then it is USERSPACE1
Regards, Pierre.

IIRC correctly:

if a tablespace called IBMDEFAULTGROUP exists (with appropriate USE
privileges) DB2 will choose that one first.

HTH
Joachim