get health snapshot for db on proddb91 show detail Database Health Snapshot Snapshot timestamp = 01/28/2009 20:13:04.883337 Database name = PRODDB91 Database path = C:\DB2_01\NODE0000\SQL00003\ Input database alias = PRODDB91 Operating system running at database server= NT Location of the database = Local Database highest severity alert state = Attention Health Indicators: Indicator Name = db.db_op_status Value = 0 Evaluation timestamp = 01/28/2009 20:08:22.875000 Alert state = Normal Formula = 0 History Entry "1": Value = 0 Evaluation timestamp = 01/28/2009 20:03:22.843000 Alert state = Normal Formula = 0 History Entry "2": Value = 0 Evaluation timestamp = 01/28/2009 19:58:22.281000 Alert state = Normal Formula = 0 History Entry "3": Value = 0 Evaluation timestamp = 01/28/2009 19:53:23.093000 Alert state = Normal Formula = 0 History Entry "4": Value = 0 Evaluation timestamp = 01/28/2009 19:48:22.265000 Alert state = Normal Formula = 0 History Entry "5": Value = 0 Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = 0 History Entry "6": Value = 0 Evaluation timestamp = 01/28/2009 19:38:22.281000 Alert state = Normal Formula = 0 History Entry "7": Value = 0 Evaluation timestamp = 01/28/2009 19:33:23.218000 Alert state = Normal Formula = 0 History Entry "8": Value = 0 Evaluation timestamp = 01/28/2009 19:28:22.687000 Alert state = Normal Formula = 0 History Entry "9": Value = 0 Evaluation timestamp = 01/28/2009 19:23:22.593000 Alert state = Normal Formula = 0 Indicator Name = db.spilled_sorts Value = 0 Unit = % Evaluation timestamp = 01/28/2009 20:07:22.578000 Alert state = Normal Formula = (((0 - 0) / ((20 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "1": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 20:01:22.328000 Alert state = Normal Formula = (((0 - 0) / ((20 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "2": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:55:22.968000 Alert state = Normal Formula = (((0 - 0) / ((20 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "3": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:49:22.593000 Alert state = Normal Formula = (((0 - 0) / ((20 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "4": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = (((0 - 0) / ((19 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "5": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:37:22.984000 Alert state = Normal Formula = (((0 - 0) / ((19 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "6": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:31:22.687000 Alert state = Normal Formula = (((0 - 0) / ((19 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "7": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:25:22.390000 Alert state = Normal Formula = (((0 - 0) / ((19 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "8": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:19:22.109000 Alert state = Normal Formula = (((0 - 0) / ((19 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" History Entry "9": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:13:22.328000 Alert state = Normal Formula = (((0 - 0) / ((19 - 19) + 1)) * 100) Additional information = The sort heap (sortheap) database configuration parameter is set to "57". The high watermark for private sort memory is "59". The high watermark for shared sort memory is "0" Indicator Name = db.log_util Value = 0 Unit = % Evaluation timestamp = 01/28/2009 20:03:22.843000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "1": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:53:23.093000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "2": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "3": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:33:23.218000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "4": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:23:22.593000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "5": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:13:22.328000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "6": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 19:03:22.703000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "7": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 18:53:23.031000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "8": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 18:43:22.750000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". History Entry "9": Value = 0 Unit = % Evaluation timestamp = 01/28/2009 18:33:23.093000 Alert state = Normal Formula = ((1770918 / (1770918 + 1319414682)) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084". The application with the oldest transaction is "37". Indicator Name = db.log_fs_util Value = 68 Unit = % Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = ((68291772416 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "1": Value = 68 Unit = % Evaluation timestamp = 01/28/2009 19:13:22.328000 Alert state = Normal Formula = ((68288958464 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "2": Value = 68 Unit = % Evaluation timestamp = 01/28/2009 18:43:22.750000 Alert state = Normal Formula = ((68287995904 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "3": Value = 68 Unit = % Evaluation timestamp = 01/28/2009 18:13:23.203000 Alert state = Normal Formula = ((68285288448 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "4": Value = 68 Unit = % Evaluation timestamp = 01/28/2009 17:43:22.625000 Alert state = Normal Formula = ((68284125184 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "5": Value = 69 Unit = % Evaluation timestamp = 01/28/2009 17:13:23.015000 Alert state = Normal Formula = ((68459978752 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "6": Value = 69 Unit = % Evaluation timestamp = 01/28/2009 16:43:22.406000 Alert state = Normal Formula = ((68459323392 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "7": Value = 69 Unit = % Evaluation timestamp = 01/28/2009 16:13:22.921000 Alert state = Normal Formula = ((68428992512 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "8": Value = 68 Unit = % Evaluation timestamp = 01/28/2009 15:43:22.281000 Alert state = Normal Formula = ((68324061184 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". History Entry "9": Value = 68 Unit = % Evaluation timestamp = 01/28/2009 15:13:22.343000 Alert state = Normal Formula = ((68292116480 / 99764387840) * 100) Additional information = The following are the related database configuration parameter settings: logprimary is "5", logsecond is "100", and logfilsiz is "3084", blk_log_dsk_ful is "NO", userexit is "NO", logarchmeth1 is "OFF" and logarchmeth2 is "OFF". Indicator Name = db.deadlock_rate Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 20:08:22.875000 Alert state = Normal Formula = (0 - 0) History Entry "1": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 20:03:22.843000 Alert state = Normal Formula = (0 - 0) History Entry "2": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 19:58:22.281000 Alert state = Normal Formula = (0 - 0) History Entry "3": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 19:53:23.093000 Alert state = Normal Formula = (0 - 0) History Entry "4": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 19:48:22.265000 Alert state = Normal Formula = (0 - 0) History Entry "5": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = (0 - 0) History Entry "6": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 19:38:22.281000 Alert state = Normal Formula = (0 - 0) History Entry "7": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 19:33:23.218000 Alert state = Normal Formula = (0 - 0) History Entry "8": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 19:28:22.687000 Alert state = Normal Formula = (0 - 0) History Entry "9": Value = 0 Unit = Deadlocks per hour Evaluation timestamp = 01/28/2009 19:23:22.593000 Alert state = Normal Formula = (0 - 0) Indicator Name = db.lock_escal_rate Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 20:08:22.875000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "1": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 20:03:22.843000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "2": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 19:58:22.281000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "3": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 19:53:23.093000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "4": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 19:48:22.265000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "5": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "6": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 19:38:22.281000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "7": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 19:33:23.218000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "8": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 19:28:22.687000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". History Entry "9": Value = 0 Unit = Lock escalations per hour Evaluation timestamp = 01/28/2009 19:23:22.593000 Alert state = Normal Formula = (0 - 0) Additional information = There is "5520" bytes of lock list memory in use. The maximum lock list storage (locklist) database configuration parameter is set to "736". Indicator Name = db.pkgcache_hitratio Value = 99 Unit = % Evaluation timestamp = 01/28/2009 19:58:22.281000 Alert state = Normal Formula = ((1 - (65 / 5618)) * 100) History Entry "1": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = ((1 - (65 / 5563)) * 100) History Entry "2": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 19:28:22.687000 Alert state = Normal Formula = ((1 - (65 / 5526)) * 100) History Entry "3": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 19:13:22.328000 Alert state = Normal Formula = ((1 - (65 / 5487)) * 100) History Entry "4": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 18:58:22.187000 Alert state = Normal Formula = ((1 - (65 / 5449)) * 100) History Entry "5": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 18:43:22.750000 Alert state = Normal Formula = ((1 - (65 / 5410)) * 100) History Entry "6": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 18:28:22.609000 Alert state = Normal Formula = ((1 - (65 / 5371)) * 100) History Entry "7": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 18:13:23.203000 Alert state = Normal Formula = ((1 - (63 / 4936)) * 100) History Entry "8": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 17:58:22.078000 Alert state = Normal Formula = ((1 - (63 / 4898)) * 100) History Entry "9": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 17:43:22.625000 Alert state = Normal Formula = ((1 - (63 / 4844)) * 100) Indicator Name = db.catcache_hitratio Value = 99 Unit = % Evaluation timestamp = 01/28/2009 19:58:22.281000 Alert state = Normal Formula = ((1 - (26 / 4599)) * 100) History Entry "1": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = ((1 - (26 / 4509)) * 100) History Entry "2": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 19:28:22.687000 Alert state = Normal Formula = ((1 - (26 / 4435)) * 100) History Entry "3": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 19:13:22.328000 Alert state = Normal Formula = ((1 - (26 / 4357)) * 100) History Entry "4": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 18:58:22.187000 Alert state = Normal Formula = ((1 - (26 / 4283)) * 100) History Entry "5": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 18:43:22.750000 Alert state = Normal Formula = ((1 - (26 / 4205)) * 100) History Entry "6": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 18:28:22.609000 Alert state = Normal Formula = ((1 - (26 / 4131)) * 100) History Entry "7": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 18:13:23.203000 Alert state = Normal Formula = ((1 - (26 / 4039)) * 100) History Entry "8": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 17:58:22.078000 Alert state = Normal Formula = ((1 - (26 / 3965)) * 100) History Entry "9": Value = 99 Unit = % Evaluation timestamp = 01/28/2009 17:43:22.625000 Alert state = Normal Formula = ((1 - (26 / 3875)) * 100) Indicator Name = db.db_heap_util Value = 33 Unit = % Evaluation timestamp = 01/28/2009 20:08:22.875000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "1": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 20:03:22.843000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "2": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 19:58:22.281000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "3": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 19:53:23.093000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "4": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 19:48:22.265000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "5": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "6": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 19:38:22.281000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "7": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 19:33:23.218000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "8": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 19:28:22.687000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) History Entry "9": Value = 33 Unit = % Evaluation timestamp = 01/28/2009 19:23:22.593000 Alert state = Normal Formula = ((4980736 / 15204352) * 100) Indicator Name = db.tb_reorg_req Value = 1 Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Attention Additional information = The scope setting in the reorganization policy is "TABSCHEMA NOT LIKE 'SYS%'". Automatic reorganization (AUTO_REORG) for this database is set to "OFF". The longest estimated reorganization time is "N/A". Collection: Name = "DB2V82"."ADVISE_INDEX" Detail = REORG TABLE State = Attention Evaluation timestamp = 01/26/2009 15:12:13.000000 Collection History Entry "0": State = Attention Evaluation timestamp = 01/26/2009 02:55:34.000000 Collection History Entry "1": State = Attention Evaluation timestamp = 01/25/2009 18:55:37.000000 Collection History Entry "2": State = Attention Evaluation timestamp = 01/21/2009 01:53:24.000000 Collection History Entry "3": State = Attention Evaluation timestamp = 01/20/2009 00:10:10.000000 Collection History Entry "4": State = Attention Evaluation timestamp = 01/09/2009 14:12:51.000000 Collection History Entry "5": State = Attention Evaluation timestamp = 01/05/2009 23:23:54.000000 Collection History Entry "6": State = Attention Evaluation timestamp = 01/05/2009 21:24:07.000000 Collection History Entry "7": State = Attention Evaluation timestamp = 12/15/2008 12:14:12.000000 Collection History Entry "8": State = Attention Evaluation timestamp = 10/07/2008 21:03:29.000000 Collection: Name = "DB2V82"."ADVISE_MQT" Detail = REORG INDEXES CLEANUP ONLY PAGES State = Attention Evaluation timestamp = 01/26/2009 15:12:13.000000 Collection History Entry "0": State = Attention Evaluation timestamp = 01/26/2009 02:55:34.000000 Collection History Entry "1": State = Attention Evaluation timestamp = 01/25/2009 18:55:37.000000 Collection History Entry "2": State = Attention Evaluation timestamp = 01/21/2009 01:53:24.000000 Collection History Entry "3": State = Attention Evaluation timestamp = 01/20/2009 00:10:10.000000 Collection History Entry "4": State = Attention Evaluation timestamp = 01/09/2009 14:12:51.000000 Collection History Entry "5": State = Attention Evaluation timestamp = 01/05/2009 23:23:54.000000 Collection History Entry "6": State = Attention Evaluation timestamp = 01/05/2009 21:24:08.000000 Collection History Entry "7": State = Attention Evaluation timestamp = 12/15/2008 12:14:12.000000 Collection History Entry "8": State = Attention Evaluation timestamp = 10/07/2008 21:03:29.000000 History Entry "1": Value = 1 Evaluation timestamp = 01/28/2009 17:43:22.625000 Alert state = Attention Additional information = The scope setting in the reorganization policy is "TABSCHEMA NOT LIKE 'SYS%'". Automatic reorganization (AUTO_REORG) for this database is set to "OFF". The longest estimated reorganization time is "N/A". History Entry "2": Value = 1 Evaluation timestamp = 01/28/2009 15:43:22.281000 Alert state = Attention Additional information = The scope setting in the reorganization policy is "TABSCHEMA NOT LIKE 'SYS%'". Automatic reorganization (AUTO_REORG) for this database is set to "OFF". The longest estimated reorganization time is "N/A". History Entry "3": Value = 1 Evaluation timestamp = 01/28/2009 13:43:22.468000 Alert state = Attention Additional information = The scope setting in the reorganization policy is "TABSCHEMA NOT LIKE 'SYS%'". Automatic reorganization (AUTO_REORG) for this database is set to "OFF". The longest estimated reorganization time is "N/A". History Entry "4": Value = 1 Evaluation timestamp = 01/28/2009 13:38:13.484000 Alert state = Attention Additional information = The scope setting in the reorganization policy is "TABSCHEMA NOT LIKE 'SYS%'". Automatic reorganization (AUTO_REORG) for this database is set to "OFF". The longest estimated reorganization time is "N/A". History Entry "5": Value = 1 Evaluation timestamp = 01/28/2009 09:43:22.859000 Alert state = Attention Additional information = The scope setting in the reorganization policy is "TABSCHEMA NOT LIKE 'SYS%'". Automatic reorganization (AUTO_REORG) for this database is set to "OFF". The longest estimated reorganization time is "N/A". History Entry "6": Value = 1 Evaluation timestamp = 01/28/2009 07:43:22.296000 Alert state = Attention Additional information = The scope setting in the reorganization policy is "TABSCHEMA NOT LIKE 'SYS%'". Automatic reorganization (AUTO_REORG) for this database is set to "OFF". The longest estimated reorganization time is "N/A". History Entry "7": Value = 1 Evaluation timestamp = 01/28/2009 05:43:23.000000 Alert state = Attention Additional information = The scope setting in the reorganization policy is "TABSCHEMA NOT LIKE 'SYS%'". Automatic reorganization (AUTO_REORG) for this database is set to "OFF". The longest estimated reorganization time is "N/A". Indicator Name = db.db_backup_req Value = 1 Evaluation timestamp = 01/28/2009 19:43:22.781000 Alert state = Attention Additional information = The last successful backup was taken at "20081222190903". The log space consumed since this last backup has been "N/A" 4KB pages. Automation for database backup is set to "OFF". The last automated backup returned with SQLCODE = "N/A". The longest estimated backup time is "N/A". History Entry "1": Value = 1 Evaluation timestamp = 01/28/2009 17:43:22.625000 Alert state = Attention Additional information = The last successful backup was taken at "20081222190903". The log space consumed since this last backup has been "N/A" 4KB pages. Automation for database backup is set to "OFF". The last automated backup returned with SQLCODE = "N/A". The longest estimated backup time is "N/A". History Entry "2": Value = 1 Evaluation timestamp = 01/28/2009 15:43:22.281000 Alert state = Attention Additional information = The last successful backup was taken at "20081222190903". The log space consumed since this last backup has been "N/A" 4KB pages. Automation for database backup is set to "OFF". The last automated backup returned with SQLCODE = "N/A". The longest estimated backup time is "N/A". History Entry "3": Value = 1 Evaluation timestamp = 01/28/2009 13:43:22.468000 Alert state = Attention Additional information = The last successful backup was taken at "20081222190903". The log space consumed since this last backup has been "N/A" 4KB pages. Automation for database backup is set to "OFF". The last automated backup returned with SQLCODE = "N/A". The longest estimated backup time is "N/A". History Entry "4": Value = 1 Evaluation timestamp = 01/28/2009 13:38:13.484000 Alert state = Attention Additional information = The last successful backup was taken at "20081222190903". The log space consumed since this last backup has been "N/A" 4KB pages. Automation for database backup is set to "OFF". The last automated backup returned with SQLCODE = "N/A". The longest estimated backup time is "N/A". History Entry "5": Value = 1 Evaluation timestamp = 01/28/2009 09:43:22.859000 Alert state = Attention Additional information = The last successful backup was taken at "20081222190903". The log space consumed since this last backup has been "N/A" 4KB pages. Automation for database backup is set to "OFF". The last automated backup returned with SQLCODE = "N/A". The longest estimated backup time is "N/A". History Entry "6": Value = 1 Evaluation timestamp = 01/28/2009 07:43:22.296000 Alert state = Attention Additional information = The last successful backup was taken at "20081222190903". The log space consumed since this last backup has been "N/A" 4KB pages. Automation for database backup is set to "OFF". The last automated backup returned with SQLCODE = "N/A". The longest estimated backup time is "N/A". History Entry "7": Value = 1 Evaluation timestamp = 01/28/2009 05:43:23.000000 Alert state = Attention Additional information = The last successful backup was taken at "20081222190903". The log space consumed since this last backup has been "N/A" 4KB pages. Automation for database backup is set to "OFF". The last automated backup returned with SQLCODE = "N/A". The longest estimated backup time is "N/A". Indicator Name = db.tb_runstats_req Value = 0 Evaluation timestamp = 01/28/2009 18:18:22.687000 Alert state = Normal Additional information = The scope is "N\A". Automatic statistics collection (AUTO_RUNSTATS) is set to "ON". History Entry "1": Value = 0 Evaluation timestamp = 01/28/2009 16:13:22.921000 Alert state = Normal Additional information = The scope is "N\A". Automatic statistics collection (AUTO_RUNSTATS) is set to "ON". History Entry "2": Value = 0 Evaluation timestamp = 01/28/2009 14:08:22.625000 Alert state = Normal Additional information = The scope is "N\A". Automatic statistics collection (AUTO_RUNSTATS) is set to "ON". History Entry "3": Value = 0 Evaluation timestamp = 01/28/2009 13:38:13.484000 Alert state = Normal Additional information = The scope is "N\A". Automatic statistics collection (AUTO_RUNSTATS) is set to "ON". History Entry "4": Value = 0 Evaluation timestamp = 01/28/2009 09:58:22.437000 Alert state = Normal Additional information = The scope is "N\A". Automatic statistics collection (AUTO_RUNSTATS) is set to "ON". History Entry "5": Value = 0 Evaluation timestamp = 01/28/2009 07:53:22.562000 Alert state = Normal Additional information = The scope is "N\A". Automatic statistics collection (AUTO_RUNSTATS) is set to "ON". History Entry "6": Value = 0 Evaluation timestamp = 01/28/2009 05:48:22.703000 Alert state = Normal Additional information = The scope is "N\A". Automatic statistics collection (AUTO_RUNSTATS) is set to "ON".