Results 1 to 4 of 4

Thread: strange problem

  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: strange problem

    I work with db2v7.2 Aix

    I created a database with 5 SMS tablespaces (3 default and 2 extra).
    when I create new table it is located to tablespace 4 instead of 3 (userspace1) why, could you please help me

    Thanks

  2. #2
    Join Date
    Dec 2002
    Posts
    134

    Re: strange problem

    from the docs:


    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:

    the authorization ID
    a group to which the authorization ID belongs
    PUBLIC
    If more than one table space still qualifies, the final choice is made by the database manager.

    Determination of the table space may change when:

    table spaces are dropped or created
    USE privileges are granted or revoked

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Re: strange problem

    Originally posted by chuzhoi
    from the docs:


    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:

    the authorization ID
    a group to which the authorization ID belongs
    PUBLIC
    If more than one table space still qualifies, the final choice is made by the database manager.

    Determination of the table space may change when:

    table spaces are dropped or created
    USE privileges are granted or revoked

    Thank you for your quick response,
    pagesize in all tablespaces is 4K , reguarding your answer I can get result, database manager will decide the location of new table.
    Thanks again

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    You have to specify the in tablespace option to place the table in a particular tablespace. I think if you don't specify that, and all tablespaces have the same pagesize, and the user creating the tables has use of all tbsp, then the table will be created in the tbsp first created. I read that somewhere after the fact but cannot remember where.

Posting Permissions

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