Results 1 to 11 of 11
  1. #1
    Join Date
    Apr 2004
    Posts
    54

    Unanswered: How to create table with partition range?

    I find this statement, but it's not correct for Udb v8:


    alter table tabella add partition by range (chiave)
    ( STARTING(MINVALUE) ENDING AT (99999999999999999) INCLUSIVE,
    STARTING(100000000000000000) ENDING AT (199999999999999999) INCLUSIVE,
    STARTING(200000000000000000) ENDING AT (299999999999999999) INCLUSIVE,
    STARTING(300000000000000000) ENDING AT (MAXVALUE)
    );


    I would to create 4 range for a table not partitioned... it's possible?
    Thank you..

    Fabio

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    No range partitioned table in V8 ..

    Allegedly, it is in V9

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Apr 2004
    Posts
    54
    Oh no!!!

    Have you idea about the date of new release?

    Thank you!
    Fabio

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    BTW, an alternative to Range Partitioning is Union All views ...

    create tabella_r1 (col1 int <check constraint for the range>,col2 int)
    create tabella_r2 (col1 int <check constraint for the range>,col2 int)

    create view tabella as
    select * from tabella_r1
    union all
    select * from tabella_r2
    etc ....

    You can, INSERT, UPDATE and DELETE using the view .. If you are using a recent fixpak, UPDATE of the 'partiioning key' is also possible ... Row movement between tables happens behind the scenes ...

    Being a view, there are limitations -
    a) Load not possible
    b) If your select query does not include the partitioing key in the predicate, in many cases, the optimizer decides to do a Union All before evaluating your predicate which obviously is a performance killer

    There are some more as well ...

    This approach is an alternative to range partitioning, but not real range partitioning

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    tentatively, end of Q3/ early Q4

    Quote Originally Posted by petitof
    Oh no!!!

    Have you idea about the date of new release?

    Thank you!
    Fabio
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Apr 2004
    Posts
    54
    I'll speak with my boss about this!!!

    Bye and Thanks very well!!

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can get a beta copy of V9 now, if you can convice IBM to let you join the beta program. Be aware, that the DB2 beta program in not informal like Microsoft and other vendor beta programs.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Marcus, Do you know when the 'public' beta starts ?

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  9. #9
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't think that DB2 usually has public betas.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  10. #10
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I remember one being avaiable under the name 'Stinger' for 8.2 ... Previously I don't remember to have had any ..

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  11. #11
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by sathyaram_s
    I remember one being avaiable under the name 'Stinger' for 8.2 ... Previously I don't remember to have had any ..

    Cheers
    Sathyaram
    You are correct, I forgot about that one. I guess it is possible that they have another one for V9, but I have not heard anything.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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