Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

    Unanswered: to reorg 1 partition

    Currenty I am implementing table-partitioning for my client (v9.5.2a on win2003-64) for some tables.
    One big table contains mutation(history) and I give it 1 dedicated partition/tablespace a year.
    Nice to mention:
    - each tablespace get ist own dedicated compress-dictionary
    Code:
    2009-02-09-08.51.39.802000+000 E296878442F561     LEVEL: Warning
    PID     : 3108                 TID  : 1508        PROC : db2syscs.exe
    INSTANCE:                      NODE : 000         DB   :     
    APPHDL  : 0-10734              APPID: *LOCAL.xxx.090205112818
    AUTHID  : ADMIND.....
    EDUID   : 1508                 EDUNAME: db2lfrm0
    FUNCTION: DB2 UDB, database utilities, sqluDoPhysicalConsistencyPt, probe:1943
    MESSAGE : ADM5592I  A compression dictionary was built and inserted into object 
              "4" in tablespace "65" via "LOAD" processing.
    
    2009-02-09-08.51.39.817000+000 E296879005F561     LEVEL: Warning
    PID     : 3108                 TID  : 1508        PROC : db2syscs.exe
    INSTANCE:                      NODE : 000         DB   :    
    APPHDL  : 0-10734              APPID: *LOCAL.xxx.090205112818
    AUTHID  : ADMIND....
    EDUID   : 1508                 EDUNAME: db2lfrm0
    FUNCTION: DB2 UDB, database utilities, sqluDoPhysicalConsistencyPt, probe:1943
    MESSAGE : ADM5592I  A compression dictionary was built and inserted into object 
              "4" in tablespace "66" via "LOAD" processing.
    - using "db2top" you monitor very nice which "partition" is access right now.

    Question:
    It would be nice to reorg only the 2009 part of my table. I could "rollout" to a separate table, reorg that and roll back in again, but during that time I do not have a consistent table available. Is there a better way (coming)?

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    Does not db2 9.5 automatically build the data dictionary after some data is loaded(a few mb)and compress subsequent records? it eliminates the need to reorg for compression.
    mota

Posting Permissions

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