Yes You have concept of default tablespace in db2 also. By default all the objects saved my any user are saved in USERSPACE1. If you want to change the default tabspace.

1 Revoke use of USERSPACE1 from user

DB2 REVOKE USE OF TABLESPACE USERSPACE1 FROM USER <user>

2 Grant USE OF TABLESPACE <urtablespace> to user <user>

Hope this will solve your problem

Regards,

Yogesh Kansal



Kishor Bhede <db2udbdba-ezmlmshield-x97721681.[Email address protected] wrote: Please help,

--- Kishor Bhede
wrote:

> To: "LazyDBA Discussion" <[Email address protected]
> From: "Kishor Bhede "
>
> Date: Wed, 24 Nov 2004 04:10:05 -0800 (PST)
> Subject: Default Tablespace.
>
> Hello All,
>
> Is there any concept of Default tablespace
> in
> DB2 like Oracle? And if it there how to change the
> default tablespace for specific schema like in
> Oracle
>
> "Alter user default tablespace "
>
> Thanks,
>
> Kishor
>
>
>
> __________________________________
> Do you Yahoo!?
> Meet the all-new My Yahoo! - Try it today!
> http://my.yahoo.com
>
>
>
>
>
---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>




__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





"The degree of normality in a database is inversely proportional to
that of its DBA"

---------------------------------
Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo!

DB2 & UDB email list listserv db2-l LazyDBA home page