Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: Drop container

  1. #1
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Exclamation Unanswered: Drop container

    hi,

    DB2 8R3, in windows 2000 SP4.

    I drop a container of a tablaspace (DMS). This tablespace have four cotainer:

    1 of 10 GB a tree of 5 GB.

    When I drop a container:
    ----------------------------------------------------------
    db2 => ALTER TABLESPACE TBATTRIB DROP ( FILE 'F:\DB2INST1\cont04attrib' )

    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL20170N There is not enough space in the table space "TBATTRIB" for the
    specified action. SQLSTATE=57059
    ----------------------------------------------------------

    The tablespace
    ----------------------------------------------------------
    Tablespace ID = 5
    Name = TBATTRIB
    Type = Database managed space
    Contents = Any data
    State = 0x0000
    Detailed explanation:
    Normal
    Total pages = 6400000
    Useable pages = 6399936
    Used pages = 267728
    Free pages = 6132208
    High water mark (pages) = 6144016
    Page size (bytes) = 4096
    Extent size (pages) = 16
    Prefetch size (pages) = 8
    Number of containers = 4
    Minimum recovery time = 2003-11-17-19.14.47.000000
    ---------------------------------------------------------

    The High water mark be in 6144016, but, only 267728 page be used.

    I run the command:
    db2dart dwcorp /tsi 5 /np 0 /lhwm

    But the water mak no change.

    Any idea?
    TIA.
    Abel.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Drop container

    Correct me if I am wrong ...

    The LHWM option in the db2dart gives suggestions on how to reduce the HWM .. It doesn't do the job for you ...

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

  3. #3
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: Drop container

    Hi sathyaram_s,

    you are right, the db2dart no change parameters, but, how change the HWM? Is this possible.

    Thanks.
    Abel.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Drop container

    One option is the REORG Command

    There are other options, I think ... But sorry, can't recall

    Cheers
    Sathyaram

    Originally posted by achiola
    Hi sathyaram_s,

    you are right, the db2dart no change parameters, but, how change the HWM? Is this possible.

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

  5. #5
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: Drop container

    Hi and tanks.

    reorg all tables of the tablespace?

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Drop container

    I think you db2dart with lhwm should be able to give the info about which table is holding the HWM ...


    REORG the most transient table in the tablespace and check the HWM ... Continue this until the HWM becomes acceptably small ..

    Or, you can take this opportunity to REORG all tables



    Sathyaram

    Originally posted by achiola
    Hi and tanks.

    reorg all tables of the tablespace?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: Drop container

    Hi,
    I reorg all tables of the tablespace, but, the hwm not change.

    I run the command:

    reorg <nombre de tabla>

    and the command db2dart:

    db2dart <dbname> /tsi 5 /np 0 /lhwm

    ---------------------------------------------------------------------



    __________________________________________________ ____________________________
    _______ DART _______
    D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o o l
    IBM DB2 NT
    __________________________________________________ ____________________________
    DART (V8.1.0) Report:
    11/18/03 15:06:17 SA Eastern Standard Time
    Database Name: DWCORP
    Report name: DWCORP.RPT
    Old report back-up: DWCORP.BAK
    Database Subdirectory: F:\DB2INST1\NODE0000\SQL00001
    Operational Mode: Database Inspection Only (INSPECT)
    __________________________________________________ ____________________________
    ------------------------------------------------------------------------------
    Action option: LHWM
    Tablespace-ID: 5; Desired Highwater Mark (Number-pages): 0
    Connecting to Buffer Pool Services...

    Highwater mark processing - phase start.
    NOTES: All highwater mark values and/or object sizes listed below are
    given in extents and not pages (unless explicitly stated).
    The object ID and object type are shown for each extent listed.
    Extents marked with an asterisk (*) hold the first page of an
    object and these extents can only be moved by dropping and
    recreating that object.
    Extents marked as belonging to objects with ID equal to 65534 or
    65535 are SMP extents or object table extents and they are not
    movable.
    After following a step and before continuing on to the next one,
    disconnect and reconnect to the database.
    Highwater Mark: 6144016 pages, 384001 extents (extents #0 - 384000)
    Lower highwater mark processing - phase start.
    Current highwater mark: 384000
    Desired highwater mark: 0
    Number of used extents in tablespace: 15685
    Number of free extents below original HWM: 368316
    Number of free extents below desired HWM: 0
    Number of free extents below current HWM: 368316
    Final highwater mark: Extent #384000 (384001 extents, 6144016 pages).
    ** This cannot be lowered further as it holds an SMP extent which is
    not movable.


    Lower highwater mark processing - phase end.

    Highwater mark processing - phase end.



    ---------------------------------------------------------------------

    Any idea?
    TIA
    Abel

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Drop container

    The db2dart output has the answer :


    ** This cannot be lowered further as it holds an SMP extent which is
    not movable.


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

  9. #9
    Join Date
    Dec 2003
    Location
    IST,TURKEY
    Posts
    5

    Re: Drop container

    Hi,
    I have the same unresizable container problem:
    "This cannot be lowered further as it holds an SMP extent which is
    not movable."

    I wonder if you found a solution.
    The only solution I found is dropping the tablespace;



    Originally posted by achiola
    Hi,
    I reorg all tables of the tablespace, but, the hwm not change.

    I run the command:

    reorg <nombre de tabla>

    and the command db2dart:

    db2dart <dbname> /tsi 5 /np 0 /lhwm

    ---------------------------------------------------------------------



    __________________________________________________ ____________________________
    _______ DART _______
    D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o o l
    IBM DB2 NT
    __________________________________________________ ____________________________
    DART (V8.1.0) Report:
    11/18/03 15:06:17 SA Eastern Standard Time
    Database Name: DWCORP
    Report name: DWCORP.RPT
    Old report back-up: DWCORP.BAK
    Database Subdirectory: F:\DB2INST1\NODE0000\SQL00001
    Operational Mode: Database Inspection Only (INSPECT)
    __________________________________________________ ____________________________
    ------------------------------------------------------------------------------
    Action option: LHWM
    Tablespace-ID: 5; Desired Highwater Mark (Number-pages): 0
    Connecting to Buffer Pool Services...

    Highwater mark processing - phase start.
    NOTES: All highwater mark values and/or object sizes listed below are
    given in extents and not pages (unless explicitly stated).
    The object ID and object type are shown for each extent listed.
    Extents marked with an asterisk (*) hold the first page of an
    object and these extents can only be moved by dropping and
    recreating that object.
    Extents marked as belonging to objects with ID equal to 65534 or
    65535 are SMP extents or object table extents and they are not
    movable.
    After following a step and before continuing on to the next one,
    disconnect and reconnect to the database.
    Highwater Mark: 6144016 pages, 384001 extents (extents #0 - 384000)
    Lower highwater mark processing - phase start.
    Current highwater mark: 384000
    Desired highwater mark: 0
    Number of used extents in tablespace: 15685
    Number of free extents below original HWM: 368316
    Number of free extents below desired HWM: 0
    Number of free extents below current HWM: 368316
    Final highwater mark: Extent #384000 (384001 extents, 6144016 pages).
    ** This cannot be lowered further as it holds an SMP extent which is
    not movable.


    Lower highwater mark processing - phase end.

    Highwater mark processing - phase end.



    ---------------------------------------------------------------------

    Any idea?
    TIA
    Abel

  10. #10
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: Drop container

    Hi fsengonul,

    I can't low the HWM, but, I think move all data to other TB and delete this TB with all your container.

    do you understand why don't low this mark? I no.

    Thank
    Abel.

  11. #11
    Join Date
    Dec 2003
    Location
    IST,TURKEY
    Posts
    5

    Unhappy Re: Drop container

    Thanks,
    If I found an answer, I will inform you.

  12. #12
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: Drop container

    fsengonul

    please, read this document:

    http://www-1.ibm.com/support/docview...id=swg21006299

    and tell me.
    Abel.

  13. #13
    Join Date
    Dec 2003
    Location
    IST,TURKEY
    Posts
    5

    Re: Drop container

    Sorry for late reply.
    But I couldn't reach that document.The link seems to be broken.
    Could you send me the document via email,please?
    ferhat.sengonul@isbank.com.tr
    thanks

    http://www-1.ibm.com/support/docview...id=swg21006299

  14. #14
    Join Date
    Dec 2003
    Location
    IST,TURKEY
    Posts
    5

    Re: Drop container

    The link is up now,I will read the document,
    Thanks

  15. #15
    Join Date
    Dec 2003
    Location
    IST,TURKEY
    Posts
    5

    Smile Re: Drop container

    Hi,
    On my previous tries ; I was using db2dart while db2 was running.
    This time, following the document, I first stopped db2 and then send the db2dart utility.And it worked
    Thanks

Posting Permissions

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