find default tablespace

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kw.housing - 28 Mar 2008 19:14 GMT

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?

Reply to this Message

Pierre StJ - 29 Mar 2008 01:28 GMT

> is there a way to tell the current tablespace for tables i create without IN
> clause?
[quoted text clipped - 3 lines]
>
> 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.

Reply to this Message

Joachim Klassen - 31 Mar 2008 09:14 GMT

> > is there a way to tell the current tablespace for tables i create without IN
> > clause?
[quoted text clipped - 10 lines]
> 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

Reply to this Message