IBM Mainframe Forum

Hi,

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.

Regards,
Jags

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