Why Table Space is created same as table name

MoLong · New User Joined: 07 Feb 2007 Posts: 32 Location: Chennai

In DB2(Zos) i created a table and the table was created. I checked in SYSIBM.SYSTABLES and i saw that the table space in which this table is stored has the same name as the table name. I did not create the tablespace. Can any one explain this.

venu.mainframes · New User Joined: 12 Mar 2007 Posts: 1 Location: hyderabad

can we modify a table space name

guptae · Posted: Mon Mar 12, 2007 3:40 pm

Hi venu.mainframes,

Please read forum rules & start a new thread for this

vini_srcna · Posted: Mon Mar 12, 2007 4:57 pm

MoLong,

If you dont mention the path where your table should be placed, Then DB2 places it in the default database DSNDB04 and it allocates the table space for you as well. The tablespace name would look similar to your table name.

MoLong · New User Joined: 07 Feb 2007 Posts: 32 Location: Chennai

Hi,
When I try to create a table in the database with another userid I'm getting an error that I do not have the permission to create table on the object <my db2 database>
How do i resolve this.
Please give the command.

vini_srcna · Posted: Mon Mar 12, 2007 7:25 pm

Get in touch with DBA and get the required Database previliges.

MoLong · New User Joined: 07 Feb 2007 Posts: 32 Location: Chennai

Hi Vinay,
Don't we have previlege DSNDB04 by default?
What is the command for giving the previlege?

ML

vini_srcna · Posted: Mon Mar 12, 2007 8:16 pm

Well, It depends on the installation actually. There may be few installations where when a TSO userid is created they may grant some privileges by default.

One has to use the SQL DCL's GRANT & REVOKE in order to grant & revoke the access from the users. Its purely installation dependent.

To generalise, In DB2 No access will be granted by default. It has to be granted explcitly.

MoLong · New User Joined: 07 Feb 2007 Posts: 32 Location: Chennai

Hi Vinay,

I've been a a oracle dba.
There we give