Restricting the usage of Default Database

IBM's flagship relational database management system

Restricting the usage of Default Database

Postby jaggz » Sat Jul 09, 2011 7:36 am


In a DB2 for z/OS V8 system, if a CREATE TABLE is issued without reference to a database or a table space, a simple table space with a name derived from the table name will be created in database DSNDB04, and the table will go in that table space. Is it possible to restrict the usage of default database DSNDB04 and make the Database created by us as a default to the users whom we have granted.

User avatar
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 5 times

Re: Restricting the usage of Default Database

Postby GuyC » Wed Jul 13, 2011 2:17 pm

You can "revoke CREATETAB ON DATABASE DSNdb04 from public" but you can't make another default

You must then specify "create table in database xxxx" which will create an implicit tablespace in database xxxx
I can explain it to you, but i can not understand it for you.
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Return to DB2


  • Related topics
    Last post