Viper2, Alter reduce and HWM

meehange · #1 (**permalink**) 03-27-08, 20:26

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?

meehange · #2 (**permalink**) 03-28-08, 01:54

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.

meehange · #3 (**permalink**) 03-31-08, 20:10

Nobody have ideas?

meehange · #4 (**permalink**) 05-06-08, 02:07

Still trying to figure this one out :/

n_i · #5 (**permalink**) 05-06-08, 07:20

Is your database partitioned?

meehange · #6 (**permalink**) 05-07-08, 02:55

Nope, nice and simple :P

Internet Services

Web Development

Digital Marketing

Consumer Tech