Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    1

    Unanswered: create table default dbspace

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •