スケーラブルデータベースサーバ HiRDB Version 8 コマンドリファレンス(Windows(R)用)
再編成時期予測機能の実行結果は,-eオプション及び-mオプションの指定値によって変わります。オプションと出力情報の関係を次の表に示します。
表15-8 オプションと出力情報の関係(再編成時期予測機能)
-eオプション | -mオプション | DBメンテナンス予定日の情報 | メンテナンス方法の情報 | 各解析項目別情報 |
---|---|---|---|---|
1(予測レベル1) | あり | ○ | ○ | − |
なし | ○ | − | − | |
2(予測レベル2) | × | ○ | ○ | ○ |
監視期間内にセグメント使用率が基準値を超えるRDエリアを,DBメンテナンス予定日が早い順に出力します。
pddbst vv-rr ***** Rdarea resource forecast ***** yyyy/mm/dd hh:mm:ss No Date RdareaName ResKind ---------- ----------- -------------------------------- ---------- 1 2005/05/31 "RDUSER01" Segment 2 2005/06/01 "RDUSER12" Segment 3 2005/06/03 "rd0002" Segment 4 2005/06/04 "lobrdarea701" Segment 5 2005/06/11 "RDUSER02" Segment ---------- ----------- -------------------------------- ---------- |
監視期間内にセグメント使用率が基準値を超えるRDエリアを,DBメンテナンス予定日が早い順に出力します。このとき,メンテナンス方法も出力します。また,予測レベル2の場合は,解析項目別情報でメンテナンス要と判断された表,インデクスのうち,RDエリアのメンテナンスに影響のあるものも出力します。
pddbst vv-rr ***** Maintenance Information ***** yyyy/mm/dd hh:mm:ss No : 1 Rdarea Name : "RDUSER01" Method : Segment : 42560 -------------------------------------------------------------------------------------- Reclaim Reorganize Type Name Date ------------- ------------ ---- ------------------------------------------- ---------- 28089 * 9363 T "k1234567"."table01" 2005/05/31 0 12342 * T "k1234567"."table02" 2005/05/31 851 7235 * I "k1234567"."index01" 2005/05/31 3 -10 T "k1234567"."table10" 2005/05/31 ====================================================================================== No : 2 Rdarea Name : "RDUSER12" Method : Segment : 32985 -------------------------------------------------------------------------------------- Reclaim Reorganize Type Name Date ------------- ------------ ---- ------------------------------------------- ---------- 3628 23749 * T "k1234567"."table01" 2005/06/01 1319 5937 * T "k1234567"."table03" 2005/06/01 1649 * 3628 I "k1234567"."index01" 2005/06/01 2638 * 989 T "k1234567"."table11" 2005/06/01 ====================================================================================== No : 3 Rdarea Name : "rd0002" Method : Expand Segment : 1523 -------------------------------------------------------------------------------------- Reclaim Reorganize Type Name Date ------------- ------------ ---- ------------------------------------------- ---------- 228 1035 T "k1234567"."table01" 2005/06/03 0 121 T "k1234567"."table03" 2005/06/03 30 60 I "k1234567"."index07" 2005/06/03 ====================================================================================== No : 4 Rdarea Name : "lobrdarea701" Method : Segment : 2498 -------------------------------------------------------------------------------------- Reclaim Reorganize Type Name Date ------------- ------------ ---- ------------------------------------------- ---------- 0 2764 * L "k1234567"."table701" 2005/06/04 ====================================================================================== No : 5 Rdarea Name : "RDUSER02" Method : Expand Segment : 31854 -------------------------------------------------------------------------------------- Reclaim Reorganize Type Name Date ------------- ------------ ---- ------------------------------------------- ---------- 3503 23934 T "k1234567"."table21" 2005/06/11 1592 3503 I "k1234567"."index22" 2005/06/11 2548 955 T "k1234567"."table23" 2005/06/11 ====================================================================================== |
pddbst VV-RR ***** Maintenance Information ***** yyyy/mm/dd hh:mm:ss No : 1 Rdarea Name : "RDUSER01" Method : Segment : 42560 -------------------------------------------------------------------------------------- Reclaim Reorganize Type Name Date ------------- ------------ ---- ------------------------------------------- ---------- 3 10 * T "k1234567"."table10" [2] 2005/05/16 28089 * 9363 T "k1234567"."table01" 2005/05/31 0 12342 * T "k1234567"."table02" 2005/05/31 851 7535 * I "k1234567"."index01" 2005/05/31 3 [1] -10 * T "k1234567"."table11" 2005/05/31 3 [1] -300 * T "k1234567"."table12" 2005/05/31 ====================================================================================== No : 2 Rdarea Name : "rd0002" Method : Expand [3] Segment : 1523 -------------------------------------------------------------------------------------- Reclaim Reorganize Type Name Date ------------- ------------ ---- ------------------------------------------- ---------- 228 [3] 1035 * T "k1234567"."table01" 2005/06/03 0 [3] 121 * T "k1234567"."table03" 2005/06/03 30 [3] 60 * I "k1234567"."index07" 2005/06/03 3 [3] -300 * T "k1234567"."table22" 2005/06/03 ====================================================================================== |
監視期間内にセグメント使用率が基準値を超えるRDエリア,表,及びインデクスを,DBメンテナンス予定日が早い順に出力します。このとき,メンテナンス方法も出力します。また,メンテナンス方法の情報に出力されたリソースについても,詳細情報を出力します。
pddbst VV-RR ***** Analysis Item Data ***** yyyy/mm/dd hh:mm:ss No : 1 Date : 2005/05/25 Method : Reclaim Type : T Name : "k1234567"."table01" ("RDUSER01") StateDate : 2005/05/19 00:10:32 ------------------------------------------------------------------------------------ Information Value Method Date ---------------------------------------- ----------- -------------------- ---------- Empty Page Ratio 40 ( 50) * Reclaim pages 2005/05/25 Unused Page Ratio (30) 20 ( 30) Used Segment for Cluster 40 ( 50) Unused Page Differ From PCTFREE (10,10) 50 ( 75) ==================================================================================== No : 2 Date : 2005/05/31 Method : Type : R Name : "RDUSER01" StateDate : 2005/05/19 00:10:32 ------------------------------------------------------------------------------------ Information Value Method Date ---------------------------------------- ----------- -------------------- ---------- Used Segment Ratio (0,10) 40 ( 80) 2005/05/31 ==================================================================================== No : 3 Date : 2005/06/01 Method : Reorganize Type : T* Name : "k1234567"."table10" ("RDUSER01") StateDate : 2005/05/19 00:10:32 ------------------------------------------------------------------------------------ Information Value Method Date ---------------------------------------- ----------- -------------------- ---------- Empty Page Ratio 25 ( 50) Reclaim pages 2005/08/10 Unused Page Ratio (30) 25 ( 30) * Reorganize 2005/06/01 Used Segment for Cluster 40 ( 50) Unused Page Differ From PCTFREE (10,10) 60 ( 75) ==================================================================================== No : 4 Date : 2005/06/03 Method : Expand Type : R Name : "rd0002" StateDate : 2005/05/19 00:10:32 ------------------------------------------------------------------------------------ Information Value Method Date ---------------------------------------- ----------- -------------------- ---------- Used Segment Ratio (0,10) 78 ( 95) Expand 2005/06/03 ==================================================================================== No : 5 Date : 2005/06/04 Method : Reclaim Type : I Name : "k1234567"."index07" ("rd0002") StateDate : 2005/05/19 00:10:32 ------------------------------------------------------------------------------------ Information Value Method Date ---------------------------------------- ----------- -------------------- ---------- Empty Page Ratio 38 ( 50) Reclaim 2005/06/04 Unused Page Ratio (30) 20 ( 30) Unused Page Differ From PCTFREE (10,10) 70 ( 75) Delete RowID Ratio 23 ( 30) ReclaimPx 2005/06/07 ==================================================================================== No : 6 Date : 2005/06/04 Method : Reorganize Type : L Name : "k77a777"."table707" ("lobrdarea701") StateDate : 2005/05/19 00:10:32 ------------------------------------------------------------------------------------ Information Value Method Date ---------------------------------------- ----------- -------------------- ---------- Used Segment for LOB Columns (0,10) 70 ( 80) * Reorganize 2005/06/04 ==================================================================================== No : 7 Date : 2005/06/06 Method : Expand Type : R Name : "RDUSER12" StateDate : 2005/05/19 00:10:32 ------------------------------------------------------------------------------------ Information Value Method Date ---------------------------------------- ----------- -------------------- ---------- Used Segment Ratio (0,10) 70 ( 80) * Expand 2005/07/01 ==================================================================================== : |
All Rights Reserved. Copyright (C) 2006, 2016, Hitachi, Ltd.