Hi,

Is it possible to define a default dbspace for tables that are created without specifying a dbspace?

If users create a table without defining a dbspace, then the table is created in the root dbspace. I would like to those tables created in a different dbspace.

Is it possible to prevent users from creating tables in the root dbspace and have it default to another dbspace?

Can this be done at a user level?

I am using IDS 9.3 - Unix

Thanks.

Hi,

The default dbspace is where the database was created. If you create a new database, the default dbspace is rootdbs, but not the tables.
Create te database in other dbspace-

Gustavo.