G
George Potemkin
Guest
Here is an example of chain rebuilt for large db with timing (and dbanalys timing for comparison): OpenEdge Release 11.5.1 as of Wed May 6 19:00:27 EDT 2015 08:38:38 Scanning /test/testdb3/largedb3_7.d1 From dbkey 250281920 to dbkey 64 08:38:55 Scan of Table Area extent 1 10% complete 17 secs = 00:00:17 08:39:12 Scan of Table Area extent 1 20% complete 17 secs = 00:00:17 08:39:25 Scan of Table Area extent 1 30% complete 13 secs = 00:00:13 09:03:34 Scan of Table Area extent 1 40% complete 1449 secs = 00:24:09 09:23:19 Scan of Table Area extent 1 50% complete 1185 secs = 00:19:45 09:56:32 Scan of Table Area extent 1 60% complete 1993 secs = 00:33:13 10:28:41 Scan of Table Area extent 1 70% complete 1929 secs = 00:32:09 11:07:19 Scan of Table Area extent 1 80% complete 2318 secs = 00:38:38 11:45:58 Scan of Table Area extent 1 90% complete 2319 secs = 00:38:39 12:24:24 Scan of Table Area extent 1 100% complete 2306 secs = 00:38:26 13546 secs = 03:45:46 Rebuilt RM chain with 0 blocks on master object Rebuilt free chain with 505 blocks on master object Rebuilt lock chain with 0 blocks on master object 12:51:52 ./dbrpr: warning: forked pid 24371 appears in running job 0 13:27:50 Rebuilt RM chain with 2045948 blocks on table 1, partition 0. 3806 secs = 01:03:26 Rebuilt free chain with 0 blocks on table 1, partition 0. Rebuilt index delete chain with 0 blocks on index 1, partition 0. Rebuilt RM chain with 0 blocks on table 13, partition 0. Rebuilt free chain with 507 blocks on index 13, partition 0. Rebuilt index delete chain with 0 blocks on index 13, partition 0. 13:34:43 Rebuilt RM chain with 1025 blocks on table 1, partition 1. 413 secs = 00:06:53 Rebuilt free chain with 0 blocks on table 1, partition 1. Rebuilt index delete chain with 0 blocks on index 1, partition 1. 13:51:49 Rebuilt RM chain with 1130 blocks on table 1, partition 2. 1026 secs = 00:17:06 Rebuilt free chain with 0 blocks on table 1, partition 2. Rebuilt index delete chain with 0 blocks on index 1, partition 2. 14:09:55 Rebuilt RM chain with 343 blocks on table 1, partition 3. 1086 secs = 00:18:06 Rebuilt free chain with 0 blocks on table 1, partition 3. Rebuilt index delete chain with 0 blocks on index 1, partition 3. 14:28:10 Rebuilt RM chain with 1018 blocks on table 1, partition 4. 1095 secs = 00:18:15 Rebuilt free chain with 0 blocks on table 1, partition 4. Rebuilt index delete chain with 0 blocks on index 1, partition 4. 14:37:53 Rebuilt RM chain with 1079 blocks on table 1, partition 5. 583 secs = 00:09:43 Rebuilt free chain with 0 blocks on table 1, partition 5. Rebuilt index delete chain with 0 blocks on index 1, partition 5. 14:38:51 Rebuilt RM chain with 1082 blocks on table 1, partition 6. 58 secs = 00:00:58 Rebuilt free chain with 0 blocks on table 1, partition 6. Rebuilt index delete chain with 0 blocks on index 1, partition 6. 14:39:28 Rebuilt RM chain with 1095 blocks on table 1, partition 8. 37 secs = 00:00:37 Rebuilt free chain with 0 blocks on table 1, partition 8. Rebuilt index delete chain with 0 blocks on index 1, partition 8. 14:40:42 Rebuilt RM chain with 1076 blocks on table 1, partition 9. 74 secs = 00:01:14 Rebuilt free chain with 0 blocks on table 1, partition 9. Rebuilt index delete chain with 0 blocks on index 1, partition 9. 14:42:11 Rebuilt RM chain with 1149 blocks on table 1, partition 10. 89 secs = 00:01:29 Rebuilt free chain with 0 blocks on table 1, partition 10. Rebuilt index delete chain with 0 blocks on index 1, partition 10. 14:44:43 Rebuilt RM chain with 982 blocks on table 1, partition 11. 152 secs = 00:02:32 Rebuilt free chain with 0 blocks on table 1, partition 11. Rebuilt index delete chain with 0 blocks on index 1, partition 11. 8419 secs = 02:20:19 [2015/09/09@08:38:39.011+0300] P-24372 T-1 I DBUTIL (451) Database Repair session begin for root on batch. [2015/09/09@08:38:39.041+0300] P-24372 T-1 I DBUTIL (61) Backward scan [2015/09/09@14:44:44.761+0300] P-24372 T-1 I DBUTIL (334) Database Repair session end. 21965 secs = 06:06:05 Wed Sep 9 14:57:57 2015 [2015/09/09@14:57:57.030+0300] P-7808 T-1 I DBANALYS : (451) Dbanalys session begin for root on /dev/pts/2. [2015/09/09@14:57:57.052+0300] P-7808 T-1 I DBANALYS : (7129) Usr 0 set name to root. [2015/09/09@15:09:50.661+0300] P-7808 T-1 I DBANALYS : (334) Dbanalys session end. 713 secs = 00:11:53
Continue reading...
Continue reading...
