DB2 does that automatically for you.
If you have created a tablespace while logged on, it has your id as the
schema name and DB2 will use that automatically as the target residence
of your table.
If you have not created one then DB2 has created one for you when ther
db was created, it is called USERSPACE1 and that's where your table will
go if you do not specify anything.
The create table command has a parameter IN that allows you to specify
which tblspc. to use. If you don't use the parm. then the command will
behave as explained above.
HTH, Pierre.
Pattnayak wrote:
Hi,
when i am trying to create a table in Db2, and specifies the
tablespace as default,it gives an error saying "There is no default
tablespace".Can anybody please help me out to assign a tablespace as a
default one.
Thanks
Pattnayak
--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.