db2dart 로 HWM 내릴때 HWM가 내려가지 않아 질문드립니다.

DB2왕초보님 | 관리/SAP on DB2 | 2013-06-27 14:28:46

안녕하세요 

현재 db 버젼은 DB2 v9.1.0.4 를 사용하고 있으며 SAP on DB2 입니다. 

지금 현상은 HWM가 너무 높아져서 DB2DART를 사용하여 해당 오브 젝트들을 모두 reorg 해주었는데

HWM 가내려가지 않아 DB2DART를 사용하여 다시한번 내리니 아래와 같은 로그가 발생 되었습니다.

사용 스크립트 : db2dart BID /LHWM /TSI 32 /NP 0

______________________________________________________________________________         _______                    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    6000 ______________________________________________________________________________   DART (V9.1)  Report: 2013-05-29-14.26.51.813752               Database Name: BID             Report name: BID.RPT             Old report back-up: BID.BAK             Database Subdirectory: /db2/BID/db2bid/NODE0000/SQL00001             Operational Mode: Database Inspection only (INSPECT)   ______________________________________________________________________________ ------------------------------------------------------------------------------     Action option: LHWM Tablespace-ID: 32; 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:  6843804 pages, 3421902 extents (extents #0 - 3421901)     Lower highwater mark processing - phase start.      Current highwater mark:                     3421901      Desired highwater mark:                     0      Number of used extents in tablespace:       1434060      Number of free extents below original HWM:  1987842      Number of free extents below desired HWM:   0      Number of free extents below current HWM:   1987842     Final highwater mark:  Extent #3389568 (3389569 extents, 6779138 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.                        ______________________________________            The requested DB2DART processing has completed successfully!                      All operation completed without error;                    no problems were detected in the database.                      ______________________________________                           Complete DB2DART report found in: /db2/BID/db2dump/DART0000/BID.RPT       _______    D A R T    P R O C E S S I N G    C O M P L E T E    _______

 위와 같은 메세지가 나와 아래의 명령어를 사용하여 HWM를 내려보았지만

사용스크립트 : db2dart bid /tsi 32 /np 0 /rhwm

또한 HWM도 내려가지 않았으며 백업 펜딩도 걸리지 않았습니다.

위스크립트의 로그는 아래와 같습니다. 

______________________________________________________________________________           _______                    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    600 ______________________________________________________________________________   DART (V9.1)  Report: 2013-06-27-12.05.12.370250               Database Name: BID             Report name: BID.RPT             Old report back-up: BID.BAK             Database Subdirectory: /db2/BID/db2bid/NODE0000/SQL00001             Operational Mode: Database Inspection only (INSPECT)   ______________________________________________________________________________ ------------------------------------------------------------------------------   Action option: RHWM Tablespace-ID: 32   Connecting to Buffer Pool Services...   Highwater mark processing - phase start.   Reduce highwater mark processing - phase start.     The Highwater mark cannot be reduced. The index of the last SMP extent used is: (52) Reduce highwater mark processing - phase end.   Highwater mark processing - phase end.                        ______________________________________            The requested DB2DART processing has completed successfully!                      All operation completed without error;                    no problems were detected in the database.                      ______________________________________                           Complete DB2DART report found in: /db2/BID/db2dump/DART0000/BID.RPT       _______    D A R T    P R O C E S S I N G    C O M P L E T E    _______

 위와 같은 로그만 생기고 HWM가 내려가지 않습니다. 

HWM를 내릴수있는 방법을 알려주셨으면 감사하겠습니다.

감사합니다.

pajama 2013-06-27 17:17:18 저도 8버전에서 reorg 다하고 lhwm rhwm 했는데도 HWM가 내려가지 않았던 적이 있었는데.. 방법이 없더군요 테이블내렸다가 테이블스페이스 재생성, 로드하는 방법뿐...다른해결방법 있다면 저도 알고싶네요

DB2왕초보 2013-06-28 14:03:09 진자로 위와 같은상황이면 HWM를 내릴수 있는 방법 이 EXPORT/LOAD 방법 바께없는건가요.. 다른 방법으로 HWM를 내리신분들은 안계신가요??

냉정과열정사이. 2013-07-02 16:42:28 없는 듯.

냉정과열정사이. 2013-07-23 16:38:39 RESETDICTIONARY