I'm not entirely certain but I don't even think you need to revoke the
userspace1, it seems as if, by db2 internal selection routine, the first
user tablespace created after userspace1 (syscat.tablespaces.create_time)
will be the default.





"yogesh kansal " <db2udbdba-ezmlmshield-x64523974.[Email address protected]

11/25/2004 01:07 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Re: Fwd: Default Tablespace.







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!


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




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