Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: Tablespace par Défaut

    Bonjour,
    Quand je créer une table sans préciser le TBS, il choisi un tbs lauis j'en veux un autre.
    Comment définir un tbs par défaut pour un utilisateur ou un schéma ?
    Merçi de votre vaide
    DB2 V7 AIX 4.3.3

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Tablespace par Défaut

    Originally posted by philio
    Bonjour,
    Quand je créer une table sans préciser le TBS, il choisi un tbs lauis j'en veux un autre.
    Comment définir un tbs par défaut pour un utilisateur ou un schéma ?
    Merçi de votre vaide
    DB2 V7 AIX 4.3.3
    Quote from the SQL reference:

    "
    IF table space IBMDEFAULTGROUP over which the user has USE privilege exists with sufficient page size
    THEN choose it
    ELSE IF a table space over which the user has USE privilege exists with sufficient page size (see below when multiple table spaces qualify)
    THEN choose it
    ELSE issue an error (SQLSTATE 42727).

    If more than one table space is identified by the ELSE IF
    condition, then choose the table space with the smallest sufficient page size over which the authorization ID of the statement has USE privilege. When more than one table space qualifies, preference is given according to who was granted the USE privilege:
    1. the authorization ID
    2. a group to which the authorization ID belongs
    3. PUBLIC

    If more than one table space still qualifies, the final choice is made by the database manager."

    P.S. How do you say RTFM in French?

  3. #3
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: Tablespace par Défaut

    Bonjour Philio.

    now in my bad english.
    the scheme is for the user. do you set the schema per default for a user with this command:

    set schema <schema>

    sorry by my english.

Posting Permissions

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