Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2004
    Posts
    306

    Unanswered: Viper2, Alter reduce and HWM

    Hey all,

    On reading Chris Eaton's blog on Viper 2 and the Reduce option in Alter Tablespace and reading the manuals I'm a bit confused.

    Does the reduce option perform the lower High Water Mark actions that we used to have to perform with db2dart when it's used on existing DMS tablespaces, and if so...why can't I get it to work? :P

    Anyone?

  2. #2
    Join Date
    Jul 2004
    Posts
    306
    by the by db2dart has this to say
    Code:
    Highwater Mark:  11776008 pages, 1472001 extents (extents #0 - 1472000)
    
    
    Lower highwater mark processing - phase start.
         Current highwater mark:                     1472000
         Desired highwater mark:                     0
         Number of used extents in tablespace:       597408
         Number of free extents below original HWM:  874593
         Number of free extents below desired HWM:   0
         Number of free extents below current HWM:   874593
    
    
    Final highwater mark:  Extent #1472000 (1472001 extents, 11776008 pages).
    
    ** The highwater mark is held by a SMP extent which can be removed by
       ALTER TABLESPACE REDUCE command.
    Yet when I try an "alter tablespace <name> reduce" I get a syntax error and when I try "alter tablespace <name> reduce (all 100m)" I get told there's not enough space with the reason code "1" message.
    Last edited by meehange; 03-28-08 at 02:57. Reason: adding detail

  3. #3
    Join Date
    Jul 2004
    Posts
    306
    Nobody have ideas?

  4. #4
    Join Date
    Jul 2004
    Posts
    306
    Still trying to figure this one out :/

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Is your database partitioned?
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Jul 2004
    Posts
    306
    Nope, nice and simple :P

Posting Permissions

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