Problem Statement: Problem Statement

Auto-instance-creation with the physical log, logical log and smart large object spaces, and 2 tempspaces all in their own separate dbspaces, along with the separately created rootdbs, will lead to less down time, fewer configuration steps, and increased ‘out-of-the-box’ experiences for all users, from the very first initial install.

At this point, all they have to do is create databases. But where?

This controls the dbspace location of user defined databases, tables, and indexes and the automatic fragmentation of tables.

• This controls the dbspace location of user defined databases, tables, and indexes and the automatic fragmentation of tables.

• If 0 (default) this is disabled:

• New databases still default created in rootdbs
• New table and indexes still default created in the same dbspace as the database
•