Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-08-22  6:50:36.74.
 
Server version: WI-V3.0.3.32798 Firebird 3.0
 
Server implementation: Firebird/Windows/AMD/Intel/x64 
 
| FB_ARCHITECTURE | DB_NAME | FORCED_WRITES | SWEEP_INT | PAGE_BUFFERS | PAGE_SIZE | 
| SuperServer 3.0.3 | D:\OLTP-EMUL\OLTP30-SMALL.FDB | ON | 0 | 786432 | 8192 | 
 
 Test configuration settings 
 
File: E:\OLTP-EMUL\src\oltp30_config.win 
 
| PARAM_NAME | PARAM_VALUE | 
| fbc | E:\FB30.TMPINSTANCE | 
| dbnm | D:\OLTP-EMUL\oltp30-small.fdb | 
| host | localhost | 
| port | 3333 | 
| usr | SYSDBA | 
| pwd | masterkey | 
| tmpdir | e:\temp\logs.oltp30 | 
| working_mode | small_03 | 
| warm_time | 0 | 
| test_time | 180 | 
| idle_time | 0 | 
| use_mtee | 0 | 
| is_embed | 0 | 
| remove_isql_logs | if_no_severe_errors | 
| no_auto_undo | 1 | 
| detailed_info | 0 | 
| mon_unit_perf | 0 | 
| trc_unit_perf | 1 | 
| init_buff | 32768 | 
| create_with_fw | sync | 
| create_with_sweep | 0 | 
| wait_if_not_exists | 0 | 
| wait_after_create | 0 | 
| init_docs | 100000 | 
| wait_for_copy | 0 | 
| create_with_debug_objects | 1 | 
| create_with_split_heavy_tabs | 1 | 
| create_with_separate_qdistr_idx | 0 | 
| create_with_compound_columns_order | most_selective_first | 
| make_html | 1 | 
| run_db_statistics | 1 | 
| run_db_validation | 1 | 
| file_name_with_test_params | regular | 
| file_name_this_host_info | cpu_8x3Ghz_ram_16gb | 
| upload_report | 1 | 
| max_snapshots_to_store | 720 | 
| replace_instance | 1 | 
| etalon_dbnm | E:\OLTP-EMUL\oltp30-docs_100000-fw__ON.fdb | 
| used_in_replication | 0 | 
 
 
 
| FINISH_STATE | DTS_END | FB_GDSCODE | FB_MNEMONA | STACK | IP | TRN_ID | ATT_ID | EXC_UNIT | 
| NORMAL: TEST_TIME EXPIRED. | 2017-08-22 06:47:05.8340 | -1 | <null> |  | ::1/51742 | 419021 | 9259 | 2 | 
 
 
 
| CATEGORY | SETTING | VAL | 
| COMMON | TRACED_UNITS | ,, | 
| COMMON | ENABLE_MON_QUERY | 0 | 
| COMMON | HALT_TEST_ON_ERRORS | ,CK, | 
| COMMON | QMISM_VERIFY_BITSET | 1 | 
| COMMON | RECALC_IDX_MIN_INTERVAL | 15 | 
| COMMON | ENABLE_RESERVES_WHEN_ADD_INVOICE | 1 | 
| COMMON | ORDER_FOR_OUR_FIRM_PERCENT | 25 | 
| COMMON | ENABLE_FILL_PHRASES | 0 | 
| COMMON | RANDOM_SEEK_VIA_ROWS_LIMIT | 0 | 
| COMMON | C_INVOICE_MIN_PURCHASE | 1000 | 
| COMMON | C_INVOICE_MAX_PURCHASE | 2000 | 
| COMMON | C_INVOICE_MIN_PROFIT_PRC | 35 | 
| COMMON | C_INVOICE_MAX_PROFIT_PRC | 80 | 
| COMMON | C_MIN_COST_TO_BE_SPLITTED | 1000 | 
| COMMON | C_ROWS_TO_MULTIPLY | 10 | 
| COMMON | C_PAYMENT_FROM_CLIENT_MIN_TOTAL | 1000 | 
| COMMON | C_PAYMENT_FROM_CLIENT_MAX_TOTAL | 5000 | 
| COMMON | C_PAYMENT_TO_SUPPLIER_MIN_TOTAL | 2000 | 
| COMMON | C_PAYMENT_TO_SUPPLIER_MAX_TOTAL | 15000 | 
| COMMON | BUILD_WITH_SPLIT_HEAVY_TABS | 1 | 
| COMMON | BUILD_WITH_SEPAR_QDISTR_IDX | 0 | 
| COMMON | BUILD_WITH_QD_COMPOUND_ORDR | MOST_SELECTIVE_FIRST | 
| SMALL_03 | C_WARES_MAX_ID | 400 | 
| SMALL_03 | C_CUSTOMER_DOC_MAX_ROWS | 10 | 
| SMALL_03 | C_SUPPLIER_DOC_MAX_ROWS | 50 | 
| SMALL_03 | C_CUSTOMER_DOC_MAX_QTY | 15 | 
| SMALL_03 | C_SUPPLIER_DOC_MAX_QTY | 50 | 
| SMALL_03 | C_NUMBER_OF_AGENTS | 50 | 
 
 
 
| TAB_NAME | IDX_NAME | IDX_KEY | 
| XQD_1000_1200 | XQD_1000_1200_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID | 
| XQD_1000_3300 | XQD_1000_3300_DOC | DOC_ID | 
| XQD_1000_3300 | XQD_1000_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID | 
| XQD_1200_2000 | XQD_1200_2000_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID | 
| XQD_2000_3300 | XQD_2000_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID | 
| XQD_2100_3300 | XQD_2100_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID | 
| XQD_3300_3400 | XQD_3300_3400_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID | 
 
 Performance reports 
 
 
 
| ACTION | AVG_TIMES_PER_MINUTE | AVG_ELAPSED_MS | SUCCESSFUL_TIMES_DONE | JOB_BEG | JOB_END | 
| *** OVERALL *** for 180 minutes: | 5917.97 | 2991 | 1065235 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| customer order: creation | 428.76 | 453 | 77177 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| customer order: refuse | 35.40 | 222 | 6372 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| order to supplier: creation | 109.26 | 1947 | 19667 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| order to supplier: removal | 2.97 | 17187 | 532 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| invoice (draft): creation | 110.13 | 2953 | 19824 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| invoice (draft): removal | 42.57 | 393 | 7662 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| invoice accept: apply | 60.75 | 10422 | 10875 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| invoice accept: cancel | 18.22 | 2556 | 3261 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| customer reserve: creation | 3381.66 | 151 | 608698 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| customer reserve: removal | 1140.25 | 55 | 204104 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| realization accept: apply | 197.48 | 506 | 35546 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| realization accept: cancel | 88.96 | 137 | 16012 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| payment from customer: creation | 143.71 | 823 | 25868 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| payment from customer: removal | 13.42 | 132 | 2415 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| payment to supplier: creation | 118.27 | 726 | 21288 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| payment to supplier: removal | 8.18 | 128 | 1465 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| service: total inventory turnovers | 9.19 | 2555 | 1654 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| service: total monetary turnovers | 15.57 | 66 | 2803 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| service: refresh index statistics | 0.07 | 15415 | 12 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
 
Done for 82270 ms, from  6:53:00.67 to  6:54:22.94.  
 
| ACTION | ITRV_NO | CNT_OK_PER_MINUTE | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | ITRV_BEG | ITRV_END | 
| interval #   1, overall | 1 | 4267 | 90394 | 76809 | 13585 | 15.03 | 03:47:06 | 04:05:06 | 
| interval #   2, overall | 2 | 6224 | 125751 | 112039 | 13712 | 10.90 | 04:05:07 | 04:23:07 | 
| interval #   3, overall | 3 | 6249 | 127521 | 112484 | 15037 | 11.79 | 04:23:08 | 04:41:08 | 
| interval #   4, overall | 4 | 5698 | 114900 | 102566 | 12334 | 10.73 | 04:41:09 | 04:59:09 | 
| interval #   5, overall | 5 | 6099 | 123916 | 109780 | 14136 | 11.41 | 04:59:10 | 05:17:10 | 
| interval #   6, overall | 6 | 6017 | 120757 | 108303 | 12454 | 10.31 | 05:17:11 | 05:35:11 | 
| interval #   7, overall | 7 | 5948 | 123851 | 107064 | 16787 | 13.55 | 05:35:12 | 05:53:12 | 
| interval #   8, overall | 8 | 6128 | 121174 | 110303 | 10871 | 8.97 | 05:53:13 | 06:11:13 | 
| interval #   9, overall | 9 | 6673 | 133594 | 120106 | 13488 | 10.10 | 06:11:14 | 06:29:14 | 
| interval #  10, overall | 10 | 5877 | 116271 | 105781 | 10490 | 9.02 | 06:29:15 | 06:47:15 | 
 
Done for 222310 ms, from  6:58:09.60 to  7:01:51.91.  
 
| TEST_PHASE | MINUTE_SINCE_TEST_START | AVG_ESTIMATED | MIN_TO_AVG_RATIO | MAX_TO_AVG_RATIO | ROWS_AGGREGATED | DISTINCT_ATTACHMENTS | 
| TEST_TIME | 1 | 3943.90 | 0.5489 | 1.4440 | 1961 | 99 | 
| TEST_TIME | 2 | 3812.47 | 0.7472 | 1.2646 | 2039 | 99 | 
| TEST_TIME | 3 | 3869.28 | 0.8308 | 1.1352 | 2055 | 99 | 
| TEST_TIME | 4 | 3694.00 | 0.8919 | 1.1474 | 1626 | 99 | 
| TEST_TIME | 5 | 3739.44 | 0.9069 | 1.0961 | 1506 | 99 | 
| TEST_TIME | 6 | 3730.31 | 0.9156 | 1.1044 | 1156 | 99 | 
| TEST_TIME | 7 | 3819.33 | 0.9246 | 1.0786 | 1729 | 99 | 
| TEST_TIME | 8 | 3901.08 | 0.9242 | 1.0704 | 1628 | 99 | 
| TEST_TIME | 9 | 3984.02 | 0.9318 | 1.0622 | 1739 | 99 | 
| TEST_TIME | 10 | 4091.66 | 0.9316 | 1.0690 | 1535 | 99 | 
| TEST_TIME | 11 | 4172.43 | 0.9530 | 1.0558 | 1516 | 99 | 
| TEST_TIME | 12 | 4251.68 | 0.9498 | 1.0511 | 1553 | 99 | 
| TEST_TIME | 13 | 4275.37 | 0.9649 | 1.0355 | 1636 | 99 | 
| TEST_TIME | 14 | 4297.77 | 0.9577 | 1.0445 | 1477 | 99 | 
| TEST_TIME | 15 | 4270.40 | 0.9811 | 1.0161 | 1532 | 96 | 
| TEST_TIME | 16 | 4215.06 | 0.9652 | 1.0523 | 1699 | 97 | 
| TEST_TIME | 17 | 4359.89 | 0.9575 | 1.0232 | 1639 | 99 | 
| TEST_TIME | 18 | 4297.85 | 0.9804 | 1.0400 | 1246 | 96 | 
| TEST_TIME | 19 | 4348.53 | 0.9753 | 1.0318 | 1548 | 99 | 
| TEST_TIME | 20 | 4325.26 | 0.9855 | 1.0528 | 1490 | 98 | 
| TEST_TIME | 21 | 4447.62 | 0.9751 | 1.0335 | 1469 | 99 | 
| TEST_TIME | 22 | 4547.25 | 0.9649 | 1.0331 | 1674 | 99 | 
| TEST_TIME | 23 | 4602.92 | 0.9763 | 1.0263 | 1130 | 99 | 
| TEST_TIME | 24 | 4657.31 | 0.9720 | 1.0320 | 1643 | 99 | 
| TEST_TIME | 25 | 4723.65 | 0.9768 | 1.0274 | 1569 | 99 | 
| TEST_TIME | 26 | 4774.52 | 0.9774 | 1.0285 | 1399 | 99 | 
| TEST_TIME | 27 | 4823.50 | 0.9807 | 1.0199 | 1343 | 99 | 
| TEST_TIME | 28 | 4829.97 | 0.9822 | 1.0178 | 1416 | 99 | 
| TEST_TIME | 29 | 4831.39 | 0.9826 | 1.0194 | 1303 | 99 | 
| TEST_TIME | 30 | 4889.48 | 0.9737 | 1.0257 | 1891 | 99 | 
| TEST_TIME | 31 | 5005.60 | 0.9696 | 1.0267 | 1940 | 99 | 
| TEST_TIME | 32 | 5104.96 | 0.9759 | 1.0280 | 1884 | 99 | 
| TEST_TIME | 33 | 5194.17 | 0.9797 | 1.0213 | 1862 | 99 | 
| TEST_TIME | 34 | 5268.88 | 0.9772 | 1.0201 | 1759 | 99 | 
| TEST_TIME | 35 | 5273.69 | 0.9901 | 1.0104 | 1695 | 99 | 
| TEST_TIME | 36 | 5284.05 | 0.9804 | 1.0170 | 1172 | 99 | 
| TEST_TIME | 37 | 5274.78 | 0.9913 | 1.0067 | 1374 | 99 | 
| TEST_TIME | 38 | 5216.00 | 0.9913 | 1.0180 | 1103 | 99 | 
| TEST_TIME | 39 | 5221.44 | 0.9908 | 1.0139 | 1278 | 99 | 
| TEST_TIME | 40 | 5221.06 | 0.9886 | 1.0138 | 1286 | 99 | 
| TEST_TIME | 41 | 5215.47 | 0.9902 | 1.0070 | 1447 | 98 | 
| TEST_TIME | 42 | 5192.35 | 0.9874 | 1.0114 | 1374 | 99 | 
| TEST_TIME | 43 | 5200.22 | 0.9864 | 1.0135 | 1219 | 99 | 
| TEST_TIME | 44 | 5216.07 | 0.9875 | 1.0114 | 1236 | 99 | 
| TEST_TIME | 45 | 5246.24 | 0.9843 | 1.0147 | 2203 | 99 | 
| TEST_TIME | 46 | 5285.53 | 0.9852 | 1.0136 | 1729 | 99 | 
| TEST_TIME | 47 | 5322.52 | 0.9851 | 1.0175 | 1668 | 99 | 
| TEST_TIME | 48 | 5407.21 | 0.9813 | 1.0168 | 1793 | 99 | 
| TEST_TIME | 49 | 5448.17 | 0.9886 | 1.0132 | 1659 | 99 | 
| TEST_TIME | 50 | 5495.53 | 0.9849 | 1.0131 | 1596 | 99 | 
| TEST_TIME | 51 | 5532.58 | 0.9866 | 1.0216 | 1571 | 99 | 
| TEST_TIME | 52 | 5608.87 | 0.9884 | 1.0126 | 1264 | 99 | 
| TEST_TIME | 53 | 5622.20 | 0.9912 | 1.0072 | 1236 | 99 | 
| TEST_TIME | 54 | 5612.96 | 0.9902 | 1.0107 | 1131 | 99 | 
| TEST_TIME | 55 | 5611.58 | 0.9926 | 1.0055 | 1306 | 98 | 
| TEST_TIME | 56 | 5566.00 | 0.9956 | 1.0094 | 1237 | 97 | 
| TEST_TIME | 57 | 5547.90 | 0.9949 | 1.0083 | 1176 | 99 | 
| TEST_TIME | 58 | 5540.41 | 0.9928 | 1.0069 | 1008 | 99 | 
| TEST_TIME | 59 | 5532.06 | 0.9914 | 1.0071 | 1155 | 99 | 
| TEST_TIME | 60 | 5529.53 | 0.9908 | 1.0114 | 1567 | 99 | 
| TEST_TIME | 61 | 5532.07 | 0.9944 | 1.0150 | 1775 | 98 | 
| TEST_TIME | 62 | 5563.45 | 0.9930 | 1.0064 | 2078 | 98 | 
| TEST_TIME | 63 | 5561.36 | 0.9908 | 1.0044 | 1479 | 99 | 
| TEST_TIME | 64 | 5558.52 | 0.9893 | 1.0077 | 1511 | 98 | 
| TEST_TIME | 65 | 5548.50 | 0.9940 | 1.0071 | 1762 | 96 | 
| TEST_TIME | 66 | 5560.80 | 0.9896 | 1.0085 | 1440 | 98 | 
| TEST_TIME | 67 | 5574.08 | 0.9911 | 1.0064 | 1311 | 99 | 
| TEST_TIME | 68 | 5581.54 | 0.9903 | 1.0080 | 1373 | 99 | 
| TEST_TIME | 69 | 5590.93 | 0.9917 | 1.0121 | 1512 | 99 | 
| TEST_TIME | 70 | 5623.26 | 0.9919 | 1.0069 | 1541 | 99 | 
| TEST_TIME | 71 | 5619.30 | 0.9934 | 1.0051 | 1492 | 99 | 
| TEST_TIME | 72 | 5622.27 | 0.9906 | 1.0073 | 1234 | 99 | 
| TEST_TIME | 73 | 5628.41 | 0.9924 | 1.0050 | 1208 | 98 | 
| TEST_TIME | 74 | 5600.64 | 0.9964 | 1.0073 | 1138 | 99 | 
| TEST_TIME | 75 | 5599.79 | 0.9941 | 1.0055 | 1644 | 99 | 
| TEST_TIME | 76 | 5604.69 | 0.9914 | 1.0084 | 1470 | 99 | 
| TEST_TIME | 77 | 5640.47 | 0.9890 | 1.0054 | 1614 | 99 | 
| TEST_TIME | 78 | 5626.02 | 0.9950 | 1.0100 | 1546 | 97 | 
| TEST_TIME | 79 | 5642.87 | 0.9943 | 1.0039 | 1658 | 99 | 
| TEST_TIME | 80 | 5666.15 | 0.9909 | 1.0051 | 1378 | 99 | 
| TEST_TIME | 81 | 5666.72 | 0.9926 | 1.0086 | 1418 | 99 | 
| TEST_TIME | 82 | 5672.51 | 0.9953 | 1.0094 | 1470 | 99 | 
| TEST_TIME | 83 | 5681.50 | 0.9956 | 1.0037 | 1712 | 98 | 
| TEST_TIME | 84 | 5674.80 | 0.9929 | 1.0089 | 1386 | 99 | 
| TEST_TIME | 85 | 5707.50 | 0.9913 | 1.0080 | 1135 | 99 | 
| TEST_TIME | 86 | 5721.89 | 0.9938 | 1.0052 | 1083 | 99 | 
| TEST_TIME | 87 | 5720.89 | 0.9939 | 1.0064 | 1292 | 99 | 
| TEST_TIME | 88 | 5723.97 | 0.9945 | 1.0061 | 1131 | 99 | 
| TEST_TIME | 89 | 5733.15 | 0.9932 | 1.0049 | 931 | 99 | 
| TEST_TIME | 90 | 5735.17 | 0.9934 | 1.0041 | 1828 | 99 | 
| TEST_TIME | 91 | 5726.04 | 0.9947 | 1.0081 | 1735 | 95 | 
| TEST_TIME | 92 | 5743.00 | 0.9942 | 1.0104 | 1573 | 98 | 
| TEST_TIME | 93 | 5777.43 | 0.9936 | 1.0053 | 1650 | 99 | 
| TEST_TIME | 94 | 5783.17 | 0.9936 | 1.0073 | 1669 | 99 | 
| TEST_TIME | 95 | 5791.37 | 0.9953 | 1.0058 | 1434 | 99 | 
| TEST_TIME | 96 | 5784.32 | 0.9965 | 1.0046 | 1201 | 98 | 
| TEST_TIME | 97 | 5780.56 | 0.9949 | 1.0044 | 1389 | 99 | 
| TEST_TIME | 98 | 5778.93 | 0.9944 | 1.0054 | 1260 | 99 | 
| TEST_TIME | 99 | 5799.83 | 0.9920 | 1.0047 | 1186 | 99 | 
| TEST_TIME | 100 | 5806.11 | 0.9935 | 1.0063 | 1028 | 99 | 
| TEST_TIME | 101 | 5807.09 | 0.9962 | 1.0025 | 1309 | 99 | 
| TEST_TIME | 102 | 5776.38 | 0.9979 | 1.0022 | 1206 | 95 | 
| TEST_TIME | 103 | 5769.94 | 0.9935 | 1.0035 | 1121 | 99 | 
| TEST_TIME | 104 | 5749.00 | 0.9975 | 1.0038 | 1180 | 98 | 
| TEST_TIME | 105 | 5733.46 | 0.9969 | 1.0034 | 1305 | 97 | 
| TEST_TIME | 106 | 5750.69 | 0.9913 | 1.0040 | 1965 | 99 | 
| TEST_TIME | 107 | 5752.37 | 0.9943 | 1.0063 | 1793 | 98 | 
| TEST_TIME | 108 | 5775.54 | 0.9930 | 1.0066 | 1502 | 99 | 
| TEST_TIME | 109 | 5796.05 | 0.9940 | 1.0056 | 1892 | 99 | 
| TEST_TIME | 110 | 5808.46 | 0.9943 | 1.0052 | 1513 | 99 | 
| TEST_TIME | 111 | 5814.97 | 0.9950 | 1.0050 | 1466 | 99 | 
| TEST_TIME | 112 | 5827.98 | 0.9938 | 1.0040 | 1457 | 99 | 
| TEST_TIME | 113 | 5819.61 | 0.9966 | 1.0031 | 1443 | 98 | 
| TEST_TIME | 114 | 5806.13 | 0.9966 | 1.0036 | 1378 | 94 | 
| TEST_TIME | 115 | 5798.58 | 0.9961 | 1.0031 | 1060 | 90 | 
| TEST_TIME | 116 | 5806.16 | 0.9982 | 1.0029 | 1295 | 93 | 
| TEST_TIME | 117 | 5806.88 | 0.9942 | 1.0060 | 866 | 97 | 
| TEST_TIME | 118 | 5805.15 | 0.9978 | 1.0051 | 1008 | 99 | 
| TEST_TIME | 119 | 5799.98 | 0.9975 | 1.0030 | 1108 | 99 | 
| TEST_TIME | 120 | 5793.00 | 0.9958 | 1.0054 | 1625 | 99 | 
| TEST_TIME | 121 | 5794.72 | 0.9968 | 1.0031 | 1835 | 98 | 
| TEST_TIME | 122 | 5799.86 | 0.9940 | 1.0023 | 1616 | 98 | 
| TEST_TIME | 123 | 5795.76 | 0.9948 | 1.0029 | 1629 | 98 | 
| TEST_TIME | 124 | 5798.63 | 0.9944 | 1.0033 | 1532 | 93 | 
| TEST_TIME | 125 | 5798.93 | 0.9952 | 1.0024 | 1613 | 96 | 
| TEST_TIME | 126 | 5788.68 | 0.9962 | 1.0035 | 1476 | 94 | 
| TEST_TIME | 127 | 5783.21 | 0.9965 | 1.0034 | 1382 | 92 | 
| TEST_TIME | 128 | 5787.90 | 0.9947 | 1.0028 | 1201 | 96 | 
| TEST_TIME | 129 | 5769.83 | 0.9981 | 1.0026 | 1295 | 96 | 
| TEST_TIME | 130 | 5785.05 | 0.9951 | 1.0020 | 1394 | 98 | 
| TEST_TIME | 131 | 5771.02 | 0.9968 | 1.0054 | 1215 | 98 | 
| TEST_TIME | 132 | 5801.63 | 0.9925 | 1.0039 | 1144 | 99 | 
| TEST_TIME | 133 | 5804.31 | 0.9959 | 1.0038 | 1206 | 99 | 
| TEST_TIME | 134 | 5811.16 | 0.9952 | 1.0049 | 1112 | 99 | 
| TEST_TIME | 135 | 5821.66 | 0.9957 | 1.0028 | 1814 | 98 | 
| TEST_TIME | 136 | 5834.40 | 0.9933 | 1.0051 | 1533 | 99 | 
| TEST_TIME | 137 | 5850.38 | 0.9953 | 1.0042 | 1681 | 99 | 
| TEST_TIME | 138 | 5850.16 | 0.9971 | 1.0029 | 1459 | 97 | 
| TEST_TIME | 139 | 5858.83 | 0.9943 | 1.0028 | 1463 | 94 | 
| TEST_TIME | 140 | 5861.64 | 0.9953 | 1.0022 | 1273 | 97 | 
| TEST_TIME | 141 | 5855.14 | 0.9962 | 1.0031 | 1224 | 95 | 
| TEST_TIME | 142 | 5842.19 | 0.9983 | 1.0028 | 1242 | 96 | 
| TEST_TIME | 143 | 5831.44 | 0.9977 | 1.0025 | 1500 | 95 | 
| TEST_TIME | 144 | 5825.31 | 0.9966 | 1.0034 | 1372 | 95 | 
| TEST_TIME | 145 | 5819.40 | 0.9975 | 1.0026 | 1316 | 88 | 
| TEST_TIME | 146 | 5816.57 | 0.9962 | 1.0032 | 1283 | 92 | 
| TEST_TIME | 147 | 5821.91 | 0.9955 | 1.0039 | 1045 | 99 | 
| TEST_TIME | 148 | 5829.22 | 0.9959 | 1.0029 | 1075 | 98 | 
| TEST_TIME | 149 | 5822.33 | 0.9974 | 1.0047 | 1191 | 99 | 
| TEST_TIME | 150 | 5838.12 | 0.9953 | 1.0056 | 1634 | 99 | 
| TEST_TIME | 151 | 5861.62 | 0.9950 | 1.0057 | 1506 | 99 | 
| TEST_TIME | 152 | 5886.10 | 0.9951 | 1.0044 | 1465 | 99 | 
| TEST_TIME | 153 | 5897.98 | 0.9958 | 1.0057 | 1394 | 99 | 
| TEST_TIME | 154 | 5921.41 | 0.9953 | 1.0057 | 1449 | 99 | 
| TEST_TIME | 155 | 5940.53 | 0.9960 | 1.0032 | 1279 | 99 | 
| TEST_TIME | 156 | 5953.77 | 0.9945 | 1.0046 | 1259 | 99 | 
| TEST_TIME | 157 | 5960.99 | 0.9970 | 1.0035 | 1332 | 99 | 
| TEST_TIME | 158 | 5955.75 | 0.9980 | 1.0018 | 1438 | 97 | 
| TEST_TIME | 159 | 5937.99 | 0.9984 | 1.0015 | 1325 | 88 | 
| TEST_TIME | 160 | 5925.71 | 0.9973 | 1.0023 | 1171 | 95 | 
| TEST_TIME | 161 | 5913.74 | 0.9981 | 1.0017 | 1149 | 88 | 
| TEST_TIME | 162 | 5924.28 | 0.9972 | 1.0022 | 1083 | 99 | 
| TEST_TIME | 163 | 5924.01 | 0.9961 | 1.0019 | 985 | 99 | 
| TEST_TIME | 164 | 5904.27 | 0.9991 | 1.0017 | 1109 | 96 | 
| TEST_TIME | 165 | 5897.74 | 0.9967 | 1.0044 | 1082 | 98 | 
| TEST_TIME | 166 | 5899.66 | 0.9981 | 1.0041 | 1653 | 92 | 
| TEST_TIME | 167 | 5913.83 | 0.9957 | 1.0039 | 1567 | 91 | 
| TEST_TIME | 168 | 5916.69 | 0.9974 | 1.0052 | 1093 | 96 | 
| TEST_TIME | 169 | 5934.27 | 0.9963 | 1.0047 | 1210 | 99 | 
| TEST_TIME | 170 | 5941.42 | 0.9975 | 1.0020 | 1506 | 99 | 
| TEST_TIME | 171 | 5930.09 | 0.9980 | 1.0024 | 1470 | 92 | 
| TEST_TIME | 172 | 5930.83 | 0.9964 | 1.0030 | 1363 | 97 | 
| TEST_TIME | 173 | 5925.19 | 0.9982 | 1.0027 | 1436 | 91 | 
| TEST_TIME | 174 | 5933.43 | 0.9955 | 1.0015 | 1157 | 98 | 
| TEST_TIME | 175 | 5926.96 | 0.9981 | 1.0018 | 1253 | 99 | 
| TEST_TIME | 176 | 5915.91 | 0.9980 | 1.0033 | 1241 | 98 | 
| TEST_TIME | 177 | 5925.98 | 0.9959 | 1.0022 | 1309 | 99 | 
| TEST_TIME | 178 | 5919.63 | 0.9977 | 1.0019 | 1244 | 99 | 
| TEST_TIME | 179 | 5905.42 | 0.9987 | 1.0069 | 1135 | 99 | 
| TEST_TIME | 180 | 5917.43 | 0.9992 | 1.0000 | 181 | 98 | 
 
Done for 10240 ms, from  7:01:52.86 to  7:02:03.10.  
 
 
| TRACED_DATA | ITRV_NO | SP_CLIENT_ORDER | SP_CANCEL_CLIENT_ORDER | SP_SUPPLIER_ORDER | SP_CANCEL_SUPPLIER_ORDER | SP_SUPPLIER_INVOICE | SP_CANCEL_SUPPLIER_INVOICE | SP_ADD_INVOICE_TO_STOCK | SP_CANCEL_ADDING_INVOICE | SP_CUSTOMER_RESERVE | SP_CANCEL_CUSTOMER_RESERVE | SP_RESERVE_WRITE_OFF | SP_CANCEL_WRITE_OFF | SP_PAY_FROM_CUSTOMER | SP_CANCEL_PAY_FROM_CUSTOMER | SP_PAY_TO_SUPPLIER | SP_CANCEL_PAY_TO_SUPPLIER | SRV_MAKE_INVNT_SALDO | SRV_MAKE_MONEY_SALDO | SRV_RECALC_IDX_STAT | ITRV_BEG | ITRV_END | 
| fetches per second | 1 | 75079 | 73513 | 51591 | 90393 | 60442 | 25547 | 69631 | <null> | 65668 | 119105 | 68710 | 26594 | 97270 | 55153 | 160319 | 62923 | 15170 | 463498 | <null> | 03:47:06 | 04:05:06 | 
| fetches per second | 2 | 65405 | 118215 | 51032 | <null> | 46846 | 50249 | 64848 | 63858 | 76981 | 5403 | 68153 | 31031 | 75842 | 45069 | 166072 | 82725 | 183879 | 281075 | <null> | 04:05:07 | 04:23:07 | 
| fetches per second | 3 | 49644 | 56443 | 34197 | 50867 | 50986 | <null> | 64587 | 105718 | 31961 | 83000 | 71265 | 52709 | 54457 | 57584 | 90115 | <null> | <null> | <null> | <null> | 04:23:08 | 04:41:08 | 
| fetches per second | 4 | 29544 | 4574 | 11696 | 7083 | 20566 | <null> | 56064 | 142581 | 673 | 123241 | 33157 | 41711 | 19319 | 514 | 62287 | 26216 | 16246 | 16584 | <null> | 04:41:09 | 04:59:09 | 
| fetches per second | 5 | 33706 | 78836 | 25079 | 83424 | 18105 | 49188 | 40523 | 38725 | 22009 | 119475 | 35197 | 1299 | 42797 | <null> | 82426 | 195500 | 97630 | 9734 | <null> | 04:59:10 | 05:17:10 | 
| fetches per second | 6 | 12046 | 2200 | 17166 | <null> | 6679 | <null> | 29253 | <null> | 11721 | 2887 | 15492 | 1493 | 30172 | 4856 | 8994 | 10714 | 11506 | 161472 | <null> | 05:17:11 | 05:35:11 | 
| fetches per second | 7 | 28516 | 22244 | 35194 | <null> | 24424 | 4070 | 40789 | <null> | 47281 | 34442 | 19955 | 21152 | 27427 | 3967 | 80302 | <null> | 76129 | 262302 | <null> | 05:35:12 | 05:53:12 | 
| fetches per second | 8 | 15689 | 12168 | 16976 | <null> | 11536 | <null> | 26635 | 46153 | 3378 | <null> | 22158 | 2027 | 31618 | 14418 | 43668 | 1304 | <null> | 19160 | <null> | 05:53:13 | 06:11:13 | 
| fetches per second | 9 | 34446 | 111177 | 35427 | <null> | 20306 | 8557 | 54672 | 16327 | 98025 | 5091 | 44494 | 13701 | 31255 | 53652 | 73980 | 79583 | <null> | 58648 | <null> | 06:11:14 | 06:29:14 | 
| fetches per second | 10 | 19919 | 6529 | 8928 | <null> | 9142 | 24102 | 6442 | <null> | 15469 | 2600 | 6495 | 3774 | 5619 | 1135 | 28494 | <null> | 35042 | 151695 | <null> | 06:29:15 | 06:47:15 | 
| marks per second | 1 | 16434 | 8628 | 11314 | 17514 | 12707 | 5067 | 9153 | <null> | 9486 | 21783 | 11632 | 4594 | 9407 | 7461 | 8379 | 10538 | 2902 | 47540 | <null> | 03:47:06 | 04:05:06 | 
| marks per second | 2 | 13740 | 15975 | 11349 | <null> | 10375 | 10954 | 8415 | 9495 | 8906 | 948 | 9501 | 5380 | 8436 | 9012 | 9693 | 20693 | 14958 | 24236 | <null> | 04:05:07 | 04:23:07 | 
| marks per second | 3 | 10584 | 6664 | 7217 | 7372 | 11018 | <null> | 7273 | 18521 | 3477 | 12142 | 9954 | 8185 | 2938 | 12667 | 4912 | <null> | <null> | <null> | <null> | 04:23:08 | 04:41:08 | 
| marks per second | 4 | 5811 | 574 | 2702 | 1034 | 4678 | <null> | 6956 | 19352 | 96 | 23434 | 3974 | 6608 | 1243 | 61 | 2427 | 4329 | 1318 | 331 | <null> | 04:41:09 | 04:59:09 | 
| marks per second | 5 | 6816 | 9258 | 5515 | 14591 | 4056 | 13370 | 5054 | 5181 | 3490 | 17050 | 5827 | 196 | 2180 | <null> | 4028 | 30250 | 6738 | 486 | <null> | 04:59:10 | 05:17:10 | 
| marks per second | 6 | 2318 | 270 | 3655 | <null> | 1260 | <null> | 2429 | <null> | 2043 | 485 | 1785 | 202 | 1439 | 686 | 339 | 1571 | 796 | 5290 | <null> | 05:17:11 | 05:35:11 | 
| marks per second | 7 | 6037 | 2757 | 7695 | <null> | 4968 | 1090 | 4639 | <null> | 7896 | 5258 | 2457 | 2876 | 1203 | 889 | 5646 | <null> | 12512 | 15422 | <null> | 05:35:12 | 05:53:12 | 
| marks per second | 8 | 3017 | 1305 | 3598 | <null> | 2289 | <null> | 3053 | 7290 | 528 | <null> | 2932 | 382 | 1249 | 2060 | 3236 | 180 | <null> | 351 | <null> | 05:53:13 | 06:11:13 | 
| marks per second | 9 | 6995 | 11955 | 6299 | <null> | 4301 | 2041 | 5426 | 2260 | 12750 | 923 | 4528 | 2078 | 1723 | 9491 | 9253 | 15833 | <null> | 689 | <null> | 06:11:14 | 06:29:14 | 
| marks per second | 10 | 4085 | 871 | 1319 | <null> | 1747 | 5799 | 739 | <null> | 2033 | 399 | 743 | 529 | 205 | 175 | 2614 | <null> | 1223 | 5631 | <null> | 06:29:15 | 06:47:15 | 
| reads/fetches*100 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 03:47:06 | 04:05:06 | 
| reads/fetches*100 | 2 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 04:05:07 | 04:23:07 | 
| reads/fetches*100 | 3 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | <null> | <null> | <null> | 04:23:08 | 04:41:08 | 
| reads/fetches*100 | 4 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 04:41:09 | 04:59:09 | 
| reads/fetches*100 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | <null> | 04:59:10 | 05:17:10 | 
| reads/fetches*100 | 6 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 05:17:11 | 05:35:11 | 
| reads/fetches*100 | 7 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | <null> | 05:35:12 | 05:53:12 | 
| reads/fetches*100 | 8 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 05:53:13 | 06:11:13 | 
| reads/fetches*100 | 9 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 06:11:14 | 06:29:14 | 
| reads/fetches*100 | 10 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | <null> | 06:29:15 | 06:47:15 | 
| writes/marks*100 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 03:47:06 | 04:05:06 | 
| writes/marks*100 | 2 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 04:05:07 | 04:23:07 | 
| writes/marks*100 | 3 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | <null> | <null> | <null> | <null> | 04:23:08 | 04:41:08 | 
| writes/marks*100 | 4 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | <null> | 04:41:09 | 04:59:09 | 
| writes/marks*100 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | <null> | 04:59:10 | 05:17:10 | 
| writes/marks*100 | 6 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | <null> | 05:17:11 | 05:35:11 | 
| writes/marks*100 | 7 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 1 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 1 | 0 | <null> | 05:35:12 | 05:53:12 | 
| writes/marks*100 | 8 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 1 | 1 | <null> | 1 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 05:53:13 | 06:11:13 | 
| writes/marks*100 | 9 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 06:11:14 | 06:29:14 | 
| writes/marks*100 | 10 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 1 | 0 | 0 | 0 | 0 | 0 | 3 | <null> | 5 | 0 | <null> | 06:29:15 | 06:47:15 | 
 
Done for 9160 ms, from  7:02:04.03 to  7:02:13.19.  
 
 
| UNIT | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | OK_MIN_MS | OK_MAX_MS | OK_AVG_MS | CNT_LK_CONFL | JOB_BEG | JOB_END | 
| doc_list_aiud | 1836451 | 1715104 | 121347 | 6.60 | 0 | 13712 | 45 | 121347 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| doc_list_biud | 1836880 | 1715104 | 121776 | 6.62 | 0 | 11419 | 15 | 121776 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_add_invoice_to_stock | 18783 | 10875 | 7908 | 42.10 | 15 | 136921 | 10422 | 7908 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_cancel_adding_invoice | 4081 | 3261 | 820 | 20.09 | 0 | 70138 | 2556 | 820 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_cancel_client_order | 6517 | 6372 | 145 | 2.22 | 0 | 2917 | 222 | 145 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_cancel_customer_reserve | 315603 | 204104 | 111499 | 35.32 | 0 | 6599 | 55 | 111499 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_cancel_pay_from_customer | 2431 | 2415 | 16 | 0.65 | 0 | 3510 | 132 | 16 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_cancel_pay_to_supplier | 1466 | 1465 | 1 | 0.06 | 0 | 2043 | 128 | 1 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_cancel_supplier_invoice | 9778 | 7662 | 2116 | 21.64 | 0 | 12277 | 393 | 2116 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_cancel_supplier_order | 1443 | 532 | 911 | 63.13 | 15 | 207512 | 17187 | 911 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_cancel_write_off | 24047 | 16012 | 8035 | 33.41 | 0 | 4477 | 137 | 8035 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_client_order | 77177 | 77177 | 0 | 0.00 | 0 | 5601 | 453 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_customer_reserve | 608698 | 608698 | 0 | 0.00 | 0 | 7176 | 151 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_fill_shopping_cart | 116937 | 116668 | 269 | 0.23 | 0 | 6833 | 89 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_fill_shopping_cart_clo_res | 608698 | 608698 | 0 | 0.00 | 0 | 2886 | 11 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_get_clo_for_invoice | 10875 | 10875 | 0 | 0.00 | 0 | 7145 | 309 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_kill_cost_storno | 31694 | 23153 | 8541 | 26.94 | 0 | 3479 | 20 | 8541 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_kill_qstorno_ret_qs2qd | 664688 | 432414 | 232274 | 34.94 | 0 | 11201 | 21 | 232274 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_kill_qty_storno | 406038 | 284364 | 121674 | 29.96 | 0 | 11388 | 65 | 121674 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_lock_selected_doc | 76404 | 65279 | 11125 | 14.56 | 0 | 1887 | 7 | 11125 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_make_cost_storno | 93577 | 93577 | 0 | 0.00 | 0 | 13572 | 410 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_multiply_rows_for_pdistr | 93577 | 93577 | 0 | 0.00 | 0 | 3260 | 57 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_multiply_rows_for_qdistr | 77177 | 77177 | 0 | 0.00 | 0 | 4197 | 150 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_pay_from_customer | 25868 | 25868 | 0 | 0.00 | 0 | 13993 | 823 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_pay_to_supplier | 21288 | 21288 | 0 | 0.00 | 0 | 8143 | 726 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_payment_common | 47156 | 47156 | 0 | 0.00 | 0 | 4665 | 59 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_qd_handle_on_cancel_clo | 6513 | 6372 | 141 | 2.16 | 0 | 2793 | 97 | 141 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_qd_handle_on_invoice_upd_sts | 14810 | 14136 | 674 | 4.55 | 0 | 9251 | 336 | 674 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_qd_handle_on_reserve_upd_sts | 35546 | 35546 | 0 | 0.00 | 0 | 7707 | 49 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_reserve_write_off | 36720 | 35546 | 1174 | 3.19 | 0 | 9719 | 506 | 1174 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_supplier_invoice | 19917 | 19824 | 93 | 0.46 | 0 | 29452 | 2953 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| sp_supplier_order | 19843 | 19667 | 176 | 0.88 | 0 | 14602 | 1947 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| srv_find_qd_qs_mism | 1095585 | 974216 | 121369 | 11.07 | 0 | 5569 | 23 | 121369 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| srv_make_invnt_saldo | 1654 | 1654 | 0 | 0.00 | 31 | 23900 | 2555 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| srv_make_money_saldo | 2803 | 2803 | 0 | 0.00 | 0 | 2542 | 66 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 2652 | 37721 | 15415 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_add_invoice_to_stock | 7908 | 7908 | 0 | 0.00 | 0 | 2075 | 98 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_cancel_adding_invoice | 741 | 741 | 0 | 0.00 | 0 | 2590 | 184 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_cancel_client_order | 145 | 145 | 0 | 0.00 | 0 | 1170 | 101 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_cancel_customer_reserve | 74 | 74 | 0 | 0.00 | 0 | 436 | 29 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_cancel_pay_from_customer | 16 | 16 | 0 | 0.00 | 0 | 390 | 55 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_cancel_pay_to_supplier | 1 | 1 | 0 | 0.00 | 0 | 0 | 0 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_cancel_supplier_invoice | 668 | 668 | 0 | 0.00 | 0 | 1607 | 94 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_cancel_supplier_order | 13795 | 13795 | 0 | 0.00 | 0 | 4259 | 84 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_cancel_write_off | 20 | 20 | 0 | 0.00 | 0 | 484 | 79 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_reserve_write_off | 1174 | 1174 | 0 | 0.00 | 0 | 1606 | 62 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_supplier_invoice | 93 | 93 | 0 | 0.00 | 0 | 1544 | 122 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-abend:sp_supplier_order | 176 | 176 | 0 | 0.00 | 0 | 1669 | 96 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_add_invoice_to_stock | 10875 | 10875 | 0 | 0.00 | 0 | 19734 | 556 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_cancel_adding_invoice | 1210 | 1210 | 0 | 0.00 | 0 | 13354 | 780 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_cancel_client_order | 6372 | 6372 | 0 | 0.00 | 0 | 2277 | 61 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_cancel_customer_reserve | 2406 | 2406 | 0 | 0.00 | 0 | 2044 | 66 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_cancel_pay_from_customer | 2415 | 2415 | 0 | 0.00 | 0 | 1607 | 52 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_cancel_pay_to_supplier | 1465 | 1465 | 0 | 0.00 | 0 | 2668 | 53 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_cancel_supplier_invoice | 874 | 874 | 0 | 0.00 | 0 | 2356 | 77 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_cancel_supplier_order | 532 | 532 | 0 | 0.00 | 0 | 45957 | 1678 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_cancel_write_off | 3584 | 3584 | 0 | 0.00 | 0 | 2028 | 69 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_client_order | 77177 | 77177 | 0 | 0.00 | 0 | 3510 | 74 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_customer_reserve | 3587 | 3587 | 0 | 0.00 | 0 | 2855 | 54 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_pay_from_customer | 25868 | 25868 | 0 | 0.00 | 0 | 2855 | 68 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_pay_to_supplier | 21288 | 21288 | 0 | 0.00 | 0 | 2902 | 62 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_reserve_write_off | 35546 | 35546 | 0 | 0.00 | 0 | 3510 | 71 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_supplier_invoice | 19824 | 19824 | 0 | 0.00 | 0 | 2496 | 65 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:sp_supplier_order | 19667 | 19667 | 0 | 0.00 | 0 | 3712 | 68 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:srv_make_invnt_saldo | 1654 | 1654 | 0 | 0.00 | 0 | 811 | 28 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:srv_make_money_saldo | 2803 | 2803 | 0 | 0.00 | 0 | 1170 | 29 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| t$perf-norm:srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 0 | 265 | 83 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_add_invoice_to_stock | 37566 | 21750 | 15816 | 42.10 | 0 | 1263 | 16 | 15816 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_all_customers | 115664 | 115664 | 0 | 0.00 | 0 | 1950 | 5 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_all_suppliers | 79808 | 79270 | 538 | 0.67 | 0 | 1467 | 5 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_all_wares | 154354 | 154354 | 0 | 0.00 | 0 | 1029 | 4 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_cancel_adding_invoice | 2836 | 2420 | 416 | 14.66 | 0 | 3307 | 133 | 416 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_cancel_client_order | 13034 | 12744 | 290 | 2.22 | 0 | 1732 | 6 | 290 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_cancel_customer_prepayment | 4862 | 4830 | 32 | 0.65 | 0 | 1061 | 7 | 32 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_cancel_customer_reserve | 4960 | 4812 | 148 | 2.98 | 0 | 1045 | 9 | 148 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_cancel_payment_to_supplier | 2932 | 2930 | 2 | 0.06 | 0 | 842 | 8 | 2 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_cancel_supplier_invoice | 3084 | 1748 | 1336 | 43.32 | 0 | 890 | 16 | 1336 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_cancel_supplier_order | 2886 | 1064 | 1822 | 63.13 | 0 | 843 | 9 | 1822 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_cancel_write_off | 7208 | 7168 | 40 | 0.55 | 0 | 3666 | 98 | 40 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_max_id_clo_ord | 19843 | 19667 | 176 | 0.88 | 0 | 780 | 5 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_max_id_clo_res | 3587 | 3587 | 0 | 0.00 | 0 | 2106 | 19 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_max_id_ord_sup | 19917 | 19824 | 93 | 0.46 | 0 | 1139 | 5 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_max_non_paid_invoice | 21144 | 21144 | 0 | 0.00 | 0 | 1030 | 5 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_max_non_paid_realizn | 25868 | 25868 | 0 | 0.00 | 0 | 1264 | 5 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_min_id_clo_ord | 19843 | 19667 | 176 | 0.88 | 0 | 1591 | 7 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_min_id_clo_res | 3587 | 3587 | 0 | 0.00 | 0 | 873 | 9 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_min_id_ord_sup | 19917 | 19824 | 93 | 0.46 | 0 | 2449 | 9 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_min_non_paid_invoice | 21288 | 21288 | 0 | 0.00 | 0 | 3214 | 11 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_min_non_paid_realizn | 25868 | 25868 | 0 | 0.00 | 0 | 1840 | 9 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_our_firm | 38690 | 38690 | 0 | 0.00 | 0 | 733 | 5 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| v_reserve_write_off | 73440 | 71092 | 2348 | 3.19 | 0 | 2262 | 8 | 2348 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| x_lock_depdocs_on_canc_invoice | 17594 | 10049 | 7545 | 42.88 | 0 | 1388 | 26 | 7545 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| x_lock_depdocs_on_canc_sup_ord | 1442 | 532 | 910 | 63.10 | 0 | 795 | 47 | 910 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| x_make_qstorno_1000_1200 | 19843 | 19667 | 176 | 0.88 | 0 | 14024 | 1754 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| x_make_qstorno_1200_2000 | 19917 | 19824 | 93 | 0.46 | 0 | 29406 | 2747 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| x_make_qstorno_2100_3300 | 608698 | 608698 | 0 | 0.00 | 0 | 6614 | 125 | 0 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
 
Done for 304690 ms, from  7:07:17.88 to  7:12:22.57.  
 
 
 
| FB_MNEMONA | CNT | UNIT | FB_GDSCODE | DTS_BEG | DTS_END | 
| deadlock | 104 | sp_kill_cost_storno | 335544336 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| deadlock | 60 | sp_kill_qstorno_ret_qs2qd | 335544336 | 2017-08-22 03:47 | 2017-08-22 06:42 | 
| deadlock | 9848 | sp_lock_selected_doc | 335544336 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| deadlock | 141 | sp_qd_handle_on_cancel_clo | 335544336 | 2017-08-22 03:48 | 2017-08-22 06:47 | 
| deadlock | 161 | sp_qd_handle_on_invoice_upd_sts | 335544336 | 2017-08-22 03:47 | 2017-08-22 06:44 | 
| deadlock | 557 | x_lock_depdocs_on_canc_invoice | 335544336 | 2017-08-22 03:47 | 2017-08-22 06:47 | 
| deadlock | 250 | x_lock_depdocs_on_canc_sup_ord | 335544336 | 2017-08-22 03:48 | 2017-08-22 06:46 | 
| user_exc | 176 | x_make_qstorno_1000_1200 | 335544517 | 2017-08-22 03:47 | 2017-08-22 06:46 | 
| user_exc | 93 | x_make_qstorno_1200_2000 | 335544517 | 2017-08-22 03:47 | 2017-08-22 06:45 | 
 
Done for 8700 ms, from  7:12:29.83 to  7:12:38.53.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          419483
 
MON$OLDEST_ACTIVE               419484
 
MON$OLDEST_SNAPSHOT             419484
 
MON$NEXT_TRANSACTION            419484
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2017-01-11 15:12:20.4040
 
MON$PAGES                       787104
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.3.32798 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32798 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		419631 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	419485 
 
Oldest active		419486 
 
Oldest snapshot		419486 
 
Next transaction	419487 
 
Sequence number		0 
 
Next attachment ID	9464 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Jan 11, 2017 15:12:20 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file 
 
 
Analyzing database pages ... 
 
AGENTS (154) 
 
Primary pointer page: 311, Index root page: 312 
 
Total formats: 1, used formats: 1 
 
Average record length: 33.58, total records: 50 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 344.00, compression ratio: 10.24 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 31% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_ID_DESC (2) 
 
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_OUR_FIRM (4) 
 
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 48 
 
Average key length: 2.04, compression ratio: 0.50 
 
Average prefix length: 0.96, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_SUPPLIER (3) 
 
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 44 
 
Average key length: 2.04, compression ratio: 0.54 
 
Average prefix length: 1.04, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_NAME_UNQ (1) 
 
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.16, total dup: 0, max dup: 0 
 
Average key length: 15.86, compression ratio: 0.92 
 
Average prefix length: 1.44, average data length: 13.16 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_AGENTS (0) 
 
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
BUSINESS_OPS (158) 
 
Primary pointer page: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 107.00, total records: 19 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1236.00, compression ratio: 11.55 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 29% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BO_UNIT_UNQ (1) 
 
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 18.00, total dup: 0, max dup: 0 
 
Average key length: 16.95, compression ratio: 1.25 
 
Average prefix length: 7.21, average data length: 14.00 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BUSINESS_OPS_RND_WGTH (2) 
 
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 4.05, total dup: 7, max dup: 3 
 
Average key length: 3.00, compression ratio: 0.75 
 
Average prefix length: 1.42, average data length: 0.84 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RDB$1 (0) 
 
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 5.26, total dup: 0, max dup: 0 
 
Average key length: 4.21, compression ratio: 0.64 
 
Average prefix length: 1.05, average data length: 1.63 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
DOC_DATA (141) 
 
Primary pointer page: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.06, total records: 2061369 
 
Average version length: 47.73, total versions: 1990, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.36 
 
Pointer pages: 14, data page slots: 22328 
 
Data pages: 22328, average fill: 73% 
 
Primary pages: 22328, secondary pages: 0, swept pages: 13706 
 
Empty pages: 5, full pages: 18900 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 3 
 
40 - 59% = 97 
 
60 - 79% = 22221 
 
80 - 99% = 2 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 9975, nodes: 2061369 
 
Average node length: 19.30, total dup: 0, max dup: 0 
 
Average key length: 16.35, compression ratio: 1.65 
 
Average prefix length: 13.65, average data length: 13.35 
 
Clustering factor: 401184, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 696 
 
20 - 39% = 2318 
 
40 - 59% = 4428 
 
60 - 79% = 1029 
 
80 - 99% = 1504 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7412, nodes: 2061369 
 
Average node length: 11.65, total dup: 0, max dup: 0 
 
Average key length: 8.70, compression ratio: 1.03 
 
Average prefix length: 3.30, average data length: 5.70 
 
Clustering factor: 383413, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 3511 
 
40 - 59% = 3804 
 
60 - 79% = 85 
 
80 - 99% = 11 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 174473, depth: 3, leaf buckets: 3599, nodes: 2061369 
 
Average node length: 6.81, total dup: 1503642, max dup: 49 
 
Average key length: 3.86, compression ratio: 2.33 
 
Average prefix length: 7.41, average data length: 1.59 
 
Clustering factor: 365045, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 162 
 
20 - 39% = 1201 
 
40 - 59% = 1406 
 
60 - 79% = 286 
 
80 - 99% = 544 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.42, total records: 621057 
 
Average version length: 35.95, total versions: 442, max versions: 2 
 
Average fragment length: 20.44, total fragments: 9, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 5, data page slots: 7872 
 
Data pages: 7872, average fill: 75% 
 
Primary pages: 7867, secondary pages: 5, swept pages: 7222 
 
Empty pages: 4, full pages: 7261 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 10 
 
40 - 59% = 35 
 
60 - 79% = 7803 
 
80 - 99% = 11 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 250231, depth: 3, leaf buckets: 2290, nodes: 621057 
 
Average node length: 11.70, total dup: 0, max dup: 0 
 
Average key length: 8.83, compression ratio: 1.02 
 
Average prefix length: 3.16, average data length: 5.84 
 
Clustering factor: 144343, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1284 
 
40 - 59% = 956 
 
60 - 79% = 44 
 
80 - 99% = 5 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 654, nodes: 621057 
 
Average node length: 4.87, total dup: 621007, max dup: 41806 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 283509, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 564 
 
60 - 79% = 70 
 
80 - 99% = 20 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 325990, depth: 3, leaf buckets: 1794, nodes: 621057 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.83, compression ratio: 1.02 
 
Average prefix length: 3.16, average data length: 5.84 
 
Clustering factor: 144343, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 123 
 
20 - 39% = 571 
 
40 - 59% = 529 
 
60 - 79% = 272 
 
80 - 99% = 299 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 270, Index root page: 271 
 
Total formats: 1, used formats: 1 
 
Average record length: 62.26, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 15.64, total fragments: 357, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.67 
 
Pointer pages: 1, data page slots: 584 
 
Data pages: 28, average fill: 22% 
 
Primary pages: 4, secondary pages: 24, swept pages: 4 
 
Empty pages: 12, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 6 
 
40 - 59% = 1 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 292, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 61.88, total records: 9738 
 
Average version length: 70.82, total versions: 1270, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 1.55 
 
Pointer pages: 2, data page slots: 1096 
 
Data pages: 432, average fill: 27% 
 
Primary pages: 431, secondary pages: 1, swept pages: 373 
 
Empty pages: 46, full pages: 12 
 
Fill distribution: 
 
0 - 19% = 216 
 
20 - 39% = 79 
 
40 - 59% = 94 
 
60 - 79% = 37 
 
80 - 99% = 6 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 44, nodes: 9738 
 
Average node length: 13.41, total dup: 1229, max dup: 1 
 
Average key length: 11.43, compression ratio: 2.36 
 
Average prefix length: 18.43, average data length: 8.57 
 
Clustering factor: 6715, ratio: 0.69 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 31 
 
40 - 59% = 8 
 
60 - 79% = 5 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.04, total records: 49 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.13 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 20% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_TURNOVER_LOG (142) 
 
Primary pointer page: 260, Index root page: 261 
 
Total formats: 1, used formats: 1 
 
Average record length: 46.00, total records: 60 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.39 
 
Pointer pages: 1, data page slots: 24 
 
Data pages: 24, average fill: 3% 
 
Primary pages: 22, secondary pages: 2, swept pages: 15 
 
Empty pages: 16, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 234082, depth: 2, leaf buckets: 1, nodes: 60 
 
Average node length: 13.00, total dup: 26, max dup: 8 
 
Average key length: 11.37, compression ratio: 1.67 
 
Average prefix length: 10.18, average data length: 8.82 
 
Clustering factor: 37, ratio: 0.62 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (165) 
 
Primary pointer page: 354, Index root page: 355 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_DTS (4) 
 
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG (0) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (166) 
 
Primary pointer page: 366, Index root page: 367 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_DTS (4) 
 
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_GDSCODE (2) 
 
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_ROWSET (1) 
 
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.36, total records: 189877 
 
Average version length: 32.01, total versions: 1558, max versions: 10 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.51 
 
Pointer pages: 2, data page slots: 2208 
 
Data pages: 2208, average fill: 64% 
 
Primary pages: 2199, secondary pages: 9, swept pages: 1761 
 
Empty pages: 23, full pages: 512 
 
Fill distribution: 
 
0 - 19% = 57 
 
20 - 39% = 110 
 
40 - 59% = 234 
 
60 - 79% = 1806 
 
80 - 99% = 1 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 176, nodes: 189877 
 
Average node length: 4.46, total dup: 189828, max dup: 10211 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 32397, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 16 
 
40 - 59% = 78 
 
60 - 79% = 66 
 
80 - 99% = 16 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 199, nodes: 189877 
 
Average node length: 5.41, total dup: 171093, max dup: 51 
 
Average key length: 2.96, compression ratio: 7.44 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 42655, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 12 
 
40 - 59% = 79 
 
60 - 79% = 64 
 
80 - 99% = 43 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 210, nodes: 189877 
 
Average node length: 5.41, total dup: 171093, max dup: 51 
 
Average key length: 2.96, compression ratio: 7.43 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 42703, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 11 
 
40 - 59% = 88 
 
60 - 79% = 82 
 
80 - 99% = 26 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 204, nodes: 189877 
 
Average node length: 5.20, total dup: 171093, max dup: 51 
 
Average key length: 2.74, compression ratio: 3.28 
 
Average prefix length: 8.35, average data length: 0.65 
 
Clustering factor: 42740, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 17 
 
40 - 59% = 90 
 
60 - 79% = 65 
 
80 - 99% = 29 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.94, total records: 257311 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 1.15 
 
Pointer pages: 2, data page slots: 2200 
 
Data pages: 2200, average fill: 64% 
 
Primary pages: 2200, secondary pages: 0, swept pages: 0 
 
Empty pages: 2, full pages: 2197 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 2197 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 167028, depth: 2, leaf buckets: 199, nodes: 257311 
 
Average node length: 4.50, total dup: 257130, max dup: 2202 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.58, average data length: 0.00 
 
Clustering factor: 44091, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 63 
 
60 - 79% = 64 
 
80 - 99% = 72 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 1, used formats: 1 
 
Average record length: 151.48, total records: 11302519 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1696.00, compression ratio: 11.20 
 
Pointer pages: 165, data page slots: 267912 
 
Data pages: 267912, average fill: 87% 
 
Primary pages: 267912, secondary pages: 0, swept pages: 3 
 
Empty pages: 3, full pages: 267908 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 267908 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 12763, nodes: 11302519 
 
Average node length: 5.65, total dup: 10455686, max dup: 140 
 
Average key length: 2.18, compression ratio: 3.67 
 
Average prefix length: 7.86, average data length: 0.13 
 
Clustering factor: 3703979, ratio: 0.33 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 7173 
 
60 - 79% = 3737 
 
80 - 99% = 1847 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 11145, nodes: 11302519 
 
Average node length: 4.55, total dup: 11302515, max dup: 10398347 
 
Average key length: 1.08, compression ratio: 0.37 
 
Average prefix length: 0.40, average data length: 0.00 
 
Clustering factor: 323925, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 11141 
 
60 - 79% = 2 
 
80 - 99% = 2 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 13739, nodes: 11302519 
 
Average node length: 5.70, total dup: 10948985, max dup: 21344 
 
Average key length: 2.23, compression ratio: 4.03 
 
Average prefix length: 8.80, average data length: 0.20 
 
Clustering factor: 863394, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 10238 
 
60 - 79% = 1938 
 
80 - 99% = 1560 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 12997, nodes: 11302519 
 
Average node length: 5.54, total dup: 11274312, max dup: 1552663 
 
Average key length: 2.07, compression ratio: 18.27 
 
Average prefix length: 37.74, average data length: 0.07 
 
Clustering factor: 6096767, ratio: 0.54 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 3 
 
40 - 59% = 10361 
 
60 - 79% = 536 
 
80 - 99% = 2084 
 
 
PHRASES (145) 
 
Primary pointer page: 266, Index root page: 267 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 55.05, total records: 434630 
 
Average version length: 55.67, total versions: 563, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.45 
 
Pointer pages: 4, data page slots: 5184 
 
Data pages: 5184, average fill: 74% 
 
Primary pages: 5184, secondary pages: 0, swept pages: 3772 
 
Empty pages: 5, full pages: 4588 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 4 
 
40 - 59% = 37 
 
60 - 79% = 5137 
 
80 - 99% = 0 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 631482, depth: 3, leaf buckets: 584, nodes: 434630 
 
Average node length: 5.95, total dup: 365057, max dup: 580 
 
Average key length: 3.16, compression ratio: 2.85 
 
Average prefix length: 8.00, average data length: 1.00 
 
Clustering factor: 57059, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 35 
 
40 - 59% = 374 
 
60 - 79% = 129 
 
80 - 99% = 37 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 478, nodes: 434630 
 
Average node length: 5.59, total dup: 387608, max dup: 114 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 107999, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 11 
 
40 - 59% = 225 
 
60 - 79% = 163 
 
80 - 99% = 77 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 3% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 12.50, total dup: 0, max dup: 0 
 
Average key length: 11.00, compression ratio: 0.82 
 
Average prefix length: 0.50, average data length: 8.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index SEMAPHORES_TASK_UNQ (1) 
 
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 22.50, total dup: 0, max dup: 0 
 
Average key length: 21.00, compression ratio: 1.07 
 
Average prefix length: 4.00, average data length: 18.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SETTINGS (137) 
 
Primary pointer page: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.31, total records: 114 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1347.00, compression ratio: 13.70 
 
Pointer pages: 1, data page slots: 2 
 
Data pages: 2, average fill: 80% 
 
Primary pages: 2, secondary pages: 0, swept pages: 2 
 
Empty pages: 0, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
Index SETTINGS_MODE_CODE (0) 
 
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.11, total dup: 0, max dup: 0 
 
Average key length: 26.10, compression ratio: 1.70 
 
Average prefix length: 21.18, average data length: 23.11 
 
Clustering factor: 6, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$RAND$CALLS (136) 
 
Primary pointer page: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
 
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TRACE_STAT (162) 
 
Primary pointer page: 347, Index root page: 348 
 
Total formats: 1, used formats: 1 
 
Average record length: 57.53, total records: 2317 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 6.54 
 
Pointer pages: 1, data page slots: 32 
 
Data pages: 32, average fill: 66% 
 
Primary pages: 32, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 27 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 28 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 264, Index root page: 265 
 
Total formats: 1, used formats: 1 
 
Average record length: 78.23, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.73 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 78% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 67 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400 
 
Average node length: 52.86, total dup: 0, max dup: 0 
 
Average key length: 51.84, compression ratio: 1.00 
 
Average prefix length: 2.73, average data length: 48.86 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (260) 
 
Primary pointer page: 292, Index root page: 295 
 
Total formats: 1, used formats: 1 
 
Average record length: 53.52, total records: 6335 
 
Average version length: 72.22, total versions: 1634, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.54 
 
Pointer pages: 2, data page slots: 1432 
 
Data pages: 416, average fill: 19% 
 
Primary pages: 415, secondary pages: 1, swept pages: 310 
 
Empty pages: 213, full pages: 57 
 
Fill distribution: 
 
0 - 19% = 295 
 
20 - 39% = 38 
 
40 - 59% = 19 
 
60 - 79% = 25 
 
80 - 99% = 39 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 15, nodes: 6335 
 
Average node length: 6.74, total dup: 5445, max dup: 14 
 
Average key length: 4.76, compression ratio: 7.77 
 
Average prefix length: 34.38, average data length: 2.62 
 
Clustering factor: 1066, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 10 
 
40 - 59% = 3 
 
60 - 79% = 0 
 
80 - 99% = 1 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.88, total records: 974281 
 
Average version length: 71.82, total versions: 3764, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.89 
 
Pointer pages: 9, data page slots: 14616 
 
Data pages: 14584, average fill: 73% 
 
Primary pages: 14584, secondary pages: 0, swept pages: 9060 
 
Empty pages: 62, full pages: 11398 
 
Fill distribution: 
 
0 - 19% = 100 
 
20 - 39% = 185 
 
40 - 59% = 737 
 
60 - 79% = 13503 
 
80 - 99% = 59 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 458711, depth: 3, leaf buckets: 1104, nodes: 974281 
 
Average node length: 5.13, total dup: 947636, max dup: 125 
 
Average key length: 2.20, compression ratio: 4.09 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 108283, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 59 
 
40 - 59% = 804 
 
60 - 79% = 59 
 
80 - 99% = 165 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 246906, depth: 3, leaf buckets: 1375, nodes: 974281 
 
Average node length: 6.25, total dup: 850332, max dup: 19 
 
Average key length: 3.32, compression ratio: 11.14 
 
Average prefix length: 35.80, average data length: 1.20 
 
Clustering factor: 185824, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 31 
 
20 - 39% = 152 
 
40 - 59% = 879 
 
60 - 79% = 172 
 
80 - 99% = 141 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 64.24, total records: 40910 
 
Average version length: 72.12, total versions: 4220, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.12 
 
Pointer pages: 3, data page slots: 1960 
 
Data pages: 1072, average fill: 43% 
 
Primary pages: 1070, secondary pages: 2, swept pages: 742 
 
Empty pages: 250, full pages: 362 
 
Fill distribution: 
 
0 - 19% = 398 
 
20 - 39% = 86 
 
40 - 59% = 103 
 
60 - 79% = 446 
 
80 - 99% = 39 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 85, nodes: 40910 
 
Average node length: 6.14, total dup: 34876, max dup: 47 
 
Average key length: 3.84, compression ratio: 9.63 
 
Average prefix length: 35.30, average data length: 1.70 
 
Clustering factor: 4101, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 50 
 
40 - 59% = 33 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.33, total records: 1525652 
 
Average version length: 71.65, total versions: 39248, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.93 
 
Pointer pages: 15, data page slots: 24152 
 
Data pages: 24136, average fill: 70% 
 
Primary pages: 24135, secondary pages: 1, swept pages: 13896 
 
Empty pages: 294, full pages: 16560 
 
Fill distribution: 
 
0 - 19% = 610 
 
20 - 39% = 962 
 
40 - 59% = 2589 
 
60 - 79% = 19161 
 
80 - 99% = 814 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 138780, depth: 3, leaf buckets: 2416, nodes: 1525652 
 
Average node length: 5.60, total dup: 1436052, max dup: 49 
 
Average key length: 2.64, compression ratio: 14.00 
 
Average prefix length: 36.41, average data length: 0.59 
 
Clustering factor: 201787, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 1167 
 
40 - 59% = 908 
 
60 - 79% = 187 
 
80 - 99% = 140 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.00, total records: 6302 
 
Average version length: 71.18, total versions: 2095, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.89 
 
Pointer pages: 3, data page slots: 1688 
 
Data pages: 688, average fill: 12% 
 
Primary pages: 687, secondary pages: 1, swept pages: 585 
 
Empty pages: 364, full pages: 13 
 
Fill distribution: 
 
0 - 19% = 546 
 
20 - 39% = 77 
 
40 - 59% = 31 
 
60 - 79% = 24 
 
80 - 99% = 10 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 17, nodes: 6302 
 
Average node length: 8.53, total dup: 4615, max dup: 35 
 
Average key length: 6.36, compression ratio: 5.82 
 
Average prefix length: 32.90, average data length: 4.10 
 
Clustering factor: 1287, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 6 
 
40 - 59% = 9 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.14, total records: 2629095 
 
Average version length: 70.95, total versions: 11283, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.91 
 
Pointer pages: 24, data page slots: 37624 
 
Data pages: 37624, average fill: 76% 
 
Primary pages: 37624, secondary pages: 0, swept pages: 27674 
 
Empty pages: 31, full pages: 33365 
 
Fill distribution: 
 
0 - 19% = 71 
 
20 - 39% = 94 
 
40 - 59% = 605 
 
60 - 79% = 36558 
 
80 - 99% = 296 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5523, nodes: 2629095 
 
Average node length: 6.86, total dup: 2133311, max dup: 14 
 
Average key length: 3.88, compression ratio: 9.53 
 
Average prefix length: 35.30, average data length: 1.70 
 
Clustering factor: 482838, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 3275 
 
40 - 59% = 1831 
 
60 - 79% = 238 
 
80 - 99% = 174 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.61, total records: 4530454 
 
Average version length: 84.30, total versions: 1438, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 43, data page slots: 69568 
 
Data pages: 69568, average fill: 80% 
 
Primary pages: 69568, secondary pages: 0, swept pages: 26097 
 
Empty pages: 0, full pages: 69327 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 2 
 
40 - 59% = 21 
 
60 - 79% = 20585 
 
80 - 99% = 48959 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4636, nodes: 4530454 
 
Average node length: 5.15, total dup: 4427142, max dup: 125 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 718548, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 70 
 
40 - 59% = 2094 
 
60 - 79% = 1905 
 
80 - 99% = 543 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 4823, nodes: 4530454 
 
Average node length: 5.70, total dup: 4054641, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 223764, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 36 
 
20 - 39% = 148 
 
40 - 59% = 2541 
 
60 - 79% = 296 
 
80 - 99% = 1802 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5178, nodes: 4530454 
 
Average node length: 5.81, total dup: 3963225, max dup: 27 
 
Average key length: 2.83, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 772749, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 74 
 
40 - 59% = 2377 
 
60 - 79% = 1948 
 
80 - 99% = 757 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.04, total records: 2444084 
 
Average version length: 84.12, total versions: 6971, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.64 
 
Pointer pages: 24, data page slots: 38368 
 
Data pages: 38368, average fill: 78% 
 
Primary pages: 38368, secondary pages: 0, swept pages: 27816 
 
Empty pages: 43, full pages: 35948 
 
Fill distribution: 
 
0 - 19% = 93 
 
20 - 39% = 128 
 
40 - 59% = 554 
 
60 - 79% = 15897 
 
80 - 99% = 21696 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2632, nodes: 2444084 
 
Average node length: 5.15, total dup: 2386602, max dup: 153 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 374761, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 48 
 
40 - 59% = 1585 
 
60 - 79% = 719 
 
80 - 99% = 275 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4087, nodes: 2444084 
 
Average node length: 6.22, total dup: 2008011, max dup: 14 
 
Average key length: 3.24, compression ratio: 2.77 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 228224, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 102 
 
20 - 39% = 1679 
 
40 - 59% = 1474 
 
60 - 79% = 540 
 
80 - 99% = 292 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 2983, nodes: 2444084 
 
Average node length: 5.82, total dup: 2136841, max dup: 29 
 
Average key length: 2.85, compression ratio: 3.16 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 451789, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 48 
 
40 - 59% = 1818 
 
60 - 79% = 812 
 
80 - 99% = 292 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.47, total records: 4779375 
 
Average version length: 85.15, total versions: 16446, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 46, data page slots: 74832 
 
Data pages: 74608, average fill: 79% 
 
Primary pages: 74608, secondary pages: 0, swept pages: 21858 
 
Empty pages: 456, full pages: 71151 
 
Fill distribution: 
 
0 - 19% = 586 
 
20 - 39% = 339 
 
40 - 59% = 932 
 
60 - 79% = 15988 
 
80 - 99% = 56763 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5072, nodes: 4779375 
 
Average node length: 5.04, total dup: 4751279, max dup: 695 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 720216, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 228 
 
40 - 59% = 2911 
 
60 - 79% = 1423 
 
80 - 99% = 506 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 5776, nodes: 4779375 
 
Average node length: 5.53, total dup: 4403711, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.54 
 
Average prefix length: 8.54, average data length: 0.46 
 
Clustering factor: 257513, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 89 
 
20 - 39% = 1506 
 
40 - 59% = 2245 
 
60 - 79% = 651 
 
80 - 99% = 1285 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 5708, nodes: 4779375 
 
Average node length: 5.69, total dup: 4285908, max dup: 74 
 
Average key length: 2.70, compression ratio: 3.33 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 797280, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 188 
 
40 - 59% = 3381 
 
60 - 79% = 1558 
 
80 - 99% = 578 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 761, Index root page: 762 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (270) 
 
Primary pointer page: 767, Index root page: 776 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.00, total records: 3291008 
 
Average version length: 85.41, total versions: 18690, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.64 
 
Pointer pages: 32, data page slots: 51312 
 
Data pages: 51312, average fill: 79% 
 
Primary pages: 51312, secondary pages: 0, swept pages: 34466 
 
Empty pages: 37, full pages: 49310 
 
Fill distribution: 
 
0 - 19% = 62 
 
20 - 39% = 112 
 
40 - 59% = 394 
 
60 - 79% = 18817 
 
80 - 99% = 31927 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3539, nodes: 3291008 
 
Average node length: 5.02, total dup: 3274875, max dup: 1300 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 665987, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 333 
 
40 - 59% = 1873 
 
60 - 79% = 877 
 
80 - 99% = 431 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5600, nodes: 3291008 
 
Average node length: 6.23, total dup: 2699944, max dup: 14 
 
Average key length: 3.25, compression ratio: 2.77 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 343161, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 190 
 
20 - 39% = 2393 
 
40 - 59% = 1914 
 
60 - 79% = 673 
 
80 - 99% = 430 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 3889, nodes: 3291008 
 
Average node length: 5.59, total dup: 3002023, max dup: 69 
 
Average key length: 2.61, compression ratio: 3.45 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 708421, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 374 
 
40 - 59% = 1935 
 
60 - 79% = 1066 
 
80 - 99% = 493 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.10, total records: 657697 
 
Average version length: 70.33, total versions: 3191, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.97 
 
Pointer pages: 6, data page slots: 9064 
 
Data pages: 9064, average fill: 77% 
 
Primary pages: 9064, secondary pages: 0, swept pages: 6495 
 
Empty pages: 6, full pages: 8762 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 26 
 
40 - 59% = 73 
 
60 - 79% = 8857 
 
80 - 99% = 94 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 173718, depth: 3, leaf buckets: 780, nodes: 657697 
 
Average node length: 5.29, total dup: 622171, max dup: 115 
 
Average key length: 2.41, compression ratio: 3.73 
 
Average prefix length: 8.64, average data length: 0.36 
 
Clustering factor: 53299, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 167 
 
40 - 59% = 322 
 
60 - 79% = 205 
 
80 - 99% = 84 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 890, nodes: 657697 
 
Average node length: 5.91, total dup: 563451, max dup: 29 
 
Average key length: 3.03, compression ratio: 2.97 
 
Average prefix length: 8.11, average data length: 0.89 
 
Clustering factor: 56163, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 219 
 
40 - 59% = 362 
 
60 - 79% = 202 
 
80 - 99% = 104 
 
 
ZDOC_DATA (230) 
 
Primary pointer page: 644, Index root page: 645 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZDOC_LIST (229) 
 
Primary pointer page: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (231) 
 
Primary pointer page: 646, Index root page: 647 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPDISTR (234) 
 
Primary pointer page: 652, Index root page: 653 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPDISTR_ID (0) 
 
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPSTORNED (235) 
 
Primary pointer page: 654, Index root page: 655 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPSTORNED_ID (0) 
 
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQDISTR (232) 
 
Primary pointer page: 648, Index root page: 649 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_ID (0) 
 
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
 
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQSTORNED (233) 
 
Primary pointer page: 650, Index root page: 651 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_DOC_ID (1) 
 
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_ID (0) 
 
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_RCV_ID (3) 
 
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_SND_ID (2) 
 
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_DEP_DOCS (228) 
 
Primary pointer page: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (227) 
 
Primary pointer page: 614, Index root page: 615 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Z_USED_VIEWS (146) 
 
Primary pointer page: 268, Index root page: 269 
 
Total formats: 1, used formats: 1 
 
Average record length: 29.38, total records: 29 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 99.00, compression ratio: 3.37 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 16% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index Z_USED_VIEWS_UNQ (0) 
 
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29 
 
Average node length: 15.17, total dup: 0, max dup: 0 
 
Average key length: 14.14, compression ratio: 1.44 
 
Average prefix length: 9.17, average data length: 11.17 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Done for 68720 ms, from  7:12:38.92 to  7:13:47.64. 
 
 
 
| TABLE_NAME | TOTAL_RECS | TOTAL_VERS | VERS_PERCENT | 
| AGENTS | 50 | 0 | 0.0000 | 
| BUSINESS_OPS | 19 | 0 | 0.0000 | 
| DOC_DATA | 2061369 | 1990 | 0.0965 | 
| DOC_LIST | 621057 | 442 | 0.0711 | 
| DOC_STATES | 4 | 0 | 0.0000 | 
| FB_ERRORS | 758 | 0 | 0.0000 | 
| INVNT_SALDO | 400 | 0 | 0.0000 | 
| INVNT_TURNOVER_LOG | 9738 | 1270 | 13.0416 | 
| MONEY_SALDO | 49 | 0 | 0.0000 | 
| MONEY_TURNOVER_LOG | 60 | 0 | 0.0000 | 
| OPTYPES | 9 | 0 | 0.0000 | 
| PDISTR | 189877 | 1558 | 0.8205 | 
| PERF_ESTIMATED | 257311 | 0 | 0.0000 | 
| PERF_LOG | 11302519 | 0 | 0.0000 | 
| PSTORNED | 434630 | 563 | 0.1295 | 
| RULES_FOR_PDISTR | 4 | 0 | 0.0000 | 
| RULES_FOR_QDISTR | 7 | 0 | 0.0000 | 
| SEMAPHORES | 4 | 0 | 0.0000 | 
| SETTINGS | 114 | 0 | 0.0000 | 
| TRACE_STAT | 2317 | 0 | 0.0000 | 
| WARES | 400 | 0 | 0.0000 | 
| WARE_GROUPS | 8 | 0 | 0.0000 | 
| XQD_1000_1200 | 6335 | 1634 | 25.7932 | 
| XQD_1000_3300 | 974281 | 3764 | 0.3863 | 
| XQD_1200_2000 | 40910 | 4220 | 10.3153 | 
| XQD_2000_3300 | 1525652 | 39248 | 2.5725 | 
| XQD_2100_3300 | 6302 | 2095 | 33.2434 | 
| XQD_3300_3400 | 2629095 | 11283 | 0.4291 | 
| XQS_1000_1200 | 4530454 | 1438 | 0.0317 | 
| XQS_1000_3300 | 2444084 | 6971 | 0.2852 | 
| XQS_1200_2000 | 4779375 | 16446 | 0.3441 | 
| XQS_2100_3300 | 3291008 | 18690 | 0.5679 | 
| XQS_3300_3400 | 657697 | 3191 | 0.4851 | 
| Z_USED_VIEWS | 29 | 0 | 0.0000 | 
 
Done for 2260 ms, from  7:13:58.72 to  7:14:00.98.  
07:14:01.06 Validation started 
 
 
07:14:01.09 Relation 140 (DOC_LIST) 
 
07:14:01.09   process pointer page    0 of    5 
 
07:14:01.20   process pointer page    1 of    5 
 
07:14:01.29   process pointer page    2 of    5 
 
07:14:01.40   process pointer page    3 of    5 
 
07:14:01.46   process pointer page    4 of    5 
 
07:14:01.49 Index 1 (PK_DOC_LIST) 
 
07:14:01.62 Index 2 (DOC_LIST_ID_DESC) 
 
07:14:01.78 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:14:02.02 Relation 140 (DOC_LIST) is ok 
 
 
07:14:02.02 Relation 141 (DOC_DATA) 
 
07:14:02.02   process pointer page    0 of   14 
 
07:14:02.09   process pointer page    1 of   14 
 
07:14:02.13   process pointer page    2 of   14 
 
07:14:02.17   process pointer page    3 of   14 
 
07:14:02.20   process pointer page    4 of   14 
 
07:14:02.23   process pointer page    5 of   14 
 
07:14:02.26   process pointer page    6 of   14 
 
07:14:02.29   process pointer page    7 of   14 
 
07:14:02.32   process pointer page    8 of   14 
 
07:14:02.35   process pointer page    9 of   14 
 
07:14:02.38   process pointer page   10 of   14 
 
07:14:02.41   process pointer page   11 of   14 
 
07:14:02.45   process pointer page   12 of   14 
 
07:14:02.46   process pointer page   13 of   14 
 
07:14:02.49 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:14:03.23 Index 3 (DOC_DATA_ID_DESC) 
 
07:14:03.63 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:14:04.21 Relation 141 (DOC_DATA) is ok 
 
 
07:14:04.21 Relation 147 (INVNT_SALDO) 
 
07:14:04.21   process pointer page    0 of    1 
 
07:14:04.21 Index 1 (PK_INVNT_SALDO) 
 
07:14:04.21 Relation 147 (INVNT_SALDO) is ok 
 
 
07:14:04.21 Relation 150 (PDISTR) 
 
07:14:04.21   process pointer page    0 of    2 
 
07:14:04.26   process pointer page    1 of    2 
 
07:14:04.26 Index 2 (PDISTR_SND_ID) 
 
07:14:04.30 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:14:04.36 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:14:04.43 Index 5 (PDISTR_AGENT_ID) 
 
07:14:04.47 Relation 150 (PDISTR) is ok 
 
 
07:14:04.47 Relation 151 (PSTORNED) 
 
07:14:04.47   process pointer page    0 of    4 
 
07:14:04.57   process pointer page    1 of    4 
 
07:14:04.66   process pointer page    2 of    4 
 
07:14:04.71   process pointer page    3 of    4 
 
07:14:04.71 Index 2 (PSTORNED_SND_ID) 
 
07:14:04.77 Index 3 (PSTORNED_RCV_ID) 
 
07:14:04.90 Relation 151 (PSTORNED) is ok 
 
 
07:14:04.90 Relation 156 (SEMAPHORES) 
 
07:14:04.90   process pointer page    0 of    1 
 
07:14:04.90 Index 1 (PK_SEMAPHORES) 
 
07:14:04.90 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:14:04.90 Relation 156 (SEMAPHORES) is ok 
 
 
07:14:04.90 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:14:04.90   process pointer page    0 of    2 
 
07:14:04.91   process pointer page    1 of    2 
 
07:14:04.91 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:14:04.91 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:14:04.91 Relation 160 (PERF_ESTIMATED) 
 
07:14:04.91   process pointer page    0 of    2 
 
07:14:05.00   process pointer page    1 of    2 
 
07:14:05.04 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:14:05.11 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:14:05.11 Relation 161 (PERF_ISQL_STAT) 
 
07:14:05.11   process pointer page    0 of    1 
 
07:14:05.11 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:14:05.11 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:14:05.11 Relation 162 (TRACE_STAT) 
 
07:14:05.11   process pointer page    0 of    1 
 
07:14:05.11 Relation 162 (TRACE_STAT) is ok 
 
 
07:14:05.11 Relation 163 (PERF_LOG) 
 
07:14:05.11   process pointer page    0 of  165 
 
07:14:05.19   process pointer page    1 of  165 
 
07:14:05.29   process pointer page    2 of  165 
 
07:14:05.32   process pointer page    3 of  165 
 
07:14:05.35   process pointer page    4 of  165 
 
07:14:05.38   process pointer page    5 of  165 
 
07:14:05.41   process pointer page    6 of  165 
 
07:14:05.44   process pointer page    7 of  165 
 
07:14:05.47   process pointer page    8 of  165 
 
07:14:05.49   process pointer page    9 of  165 
 
07:14:05.52   process pointer page   10 of  165 
 
07:14:05.60   process pointer page   11 of  165 
 
07:14:05.64   process pointer page   12 of  165 
 
07:14:05.68   process pointer page   13 of  165 
 
07:14:05.72   process pointer page   14 of  165 
 
07:14:05.75   process pointer page   15 of  165 
 
07:14:05.78   process pointer page   16 of  165 
 
07:14:05.86   process pointer page   17 of  165 
 
07:14:05.94   process pointer page   18 of  165 
 
07:14:06.02   process pointer page   19 of  165 
 
07:14:06.11   process pointer page   20 of  165 
 
07:14:06.19   process pointer page   21 of  165 
 
07:14:06.24   process pointer page   22 of  165 
 
07:14:06.27   process pointer page   23 of  165 
 
07:14:06.35   process pointer page   24 of  165 
 
07:14:06.42   process pointer page   25 of  165 
 
07:14:06.52   process pointer page   26 of  165 
 
07:14:06.60   process pointer page   27 of  165 
 
07:14:06.63   process pointer page   28 of  165 
 
07:14:06.66   process pointer page   29 of  165 
 
07:14:06.69   process pointer page   30 of  165 
 
07:14:06.77   process pointer page   31 of  165 
 
07:14:06.80   process pointer page   32 of  165 
 
07:14:06.83   process pointer page   33 of  165 
 
07:14:06.91   process pointer page   34 of  165 
 
07:14:07.00   process pointer page   35 of  165 
 
07:14:07.08   process pointer page   36 of  165 
 
07:14:07.16   process pointer page   37 of  165 
 
07:14:07.24   process pointer page   38 of  165 
 
07:14:07.31   process pointer page   39 of  165 
 
07:14:07.36   process pointer page   40 of  165 
 
07:14:07.39   process pointer page   41 of  165 
 
07:14:07.42   process pointer page   42 of  165 
 
07:14:07.45   process pointer page   43 of  165 
 
07:14:07.48   process pointer page   44 of  165 
 
07:14:07.50   process pointer page   45 of  165 
 
07:14:07.56   process pointer page   46 of  165 
 
07:14:07.64   process pointer page   47 of  165 
 
07:14:07.69   process pointer page   48 of  165 
 
07:14:07.73   process pointer page   49 of  165 
 
07:14:07.77   process pointer page   50 of  165 
 
07:14:07.80   process pointer page   51 of  165 
 
07:14:07.83   process pointer page   52 of  165 
 
07:14:07.86   process pointer page   53 of  165 
 
07:14:07.87   process pointer page   54 of  165 
 
07:14:07.91   process pointer page   55 of  165 
 
07:14:07.94   process pointer page   56 of  165 
 
07:14:07.95   process pointer page   57 of  165 
 
07:14:07.98   process pointer page   58 of  165 
 
07:14:08.02   process pointer page   59 of  165 
 
07:14:08.05   process pointer page   60 of  165 
 
07:14:08.12   process pointer page   61 of  165 
 
07:14:08.20   process pointer page   62 of  165 
 
07:14:08.25   process pointer page   63 of  165 
 
07:14:08.28   process pointer page   64 of  165 
 
07:14:08.31   process pointer page   65 of  165 
 
07:14:08.34   process pointer page   66 of  165 
 
07:14:08.37   process pointer page   67 of  165 
 
07:14:08.41   process pointer page   68 of  165 
 
07:14:08.44   process pointer page   69 of  165 
 
07:14:08.45   process pointer page   70 of  165 
 
07:14:08.48   process pointer page   71 of  165 
 
07:14:08.51   process pointer page   72 of  165 
 
07:14:08.55   process pointer page   73 of  165 
 
07:14:08.58   process pointer page   74 of  165 
 
07:14:08.61   process pointer page   75 of  165 
 
07:14:08.64   process pointer page   76 of  165 
 
07:14:08.72   process pointer page   77 of  165 
 
07:14:08.80   process pointer page   78 of  165 
 
07:14:08.87   process pointer page   79 of  165 
 
07:14:08.97   process pointer page   80 of  165 
 
07:14:09.04   process pointer page   81 of  165 
 
07:14:09.08   process pointer page   82 of  165 
 
07:14:09.11   process pointer page   83 of  165 
 
07:14:09.14   process pointer page   84 of  165 
 
07:14:09.17   process pointer page   85 of  165 
 
07:14:09.20   process pointer page   86 of  165 
 
07:14:09.23   process pointer page   87 of  165 
 
07:14:09.28   process pointer page   88 of  165 
 
07:14:09.33   process pointer page   89 of  165 
 
07:14:09.36   process pointer page   90 of  165 
 
07:14:09.40   process pointer page   91 of  165 
 
07:14:09.43   process pointer page   92 of  165 
 
07:14:09.47   process pointer page   93 of  165 
 
07:14:09.50   process pointer page   94 of  165 
 
07:14:09.53   process pointer page   95 of  165 
 
07:14:09.56   process pointer page   96 of  165 
 
07:14:09.58   process pointer page   97 of  165 
 
07:14:09.62   process pointer page   98 of  165 
 
07:14:09.65   process pointer page   99 of  165 
 
07:14:09.68   process pointer page  100 of  165 
 
07:14:09.72   process pointer page  101 of  165 
 
07:14:09.75   process pointer page  102 of  165 
 
07:14:09.78   process pointer page  103 of  165 
 
07:14:09.79   process pointer page  104 of  165 
 
07:14:09.82   process pointer page  105 of  165 
 
07:14:09.86   process pointer page  106 of  165 
 
07:14:09.89   process pointer page  107 of  165 
 
07:14:09.92   process pointer page  108 of  165 
 
07:14:09.98   process pointer page  109 of  165 
 
07:14:10.01   process pointer page  110 of  165 
 
07:14:10.07   process pointer page  111 of  165 
 
07:14:10.15   process pointer page  112 of  165 
 
07:14:10.20   process pointer page  113 of  165 
 
07:14:10.23   process pointer page  114 of  165 
 
07:14:10.26   process pointer page  115 of  165 
 
07:14:10.29   process pointer page  116 of  165 
 
07:14:10.32   process pointer page  117 of  165 
 
07:14:10.36   process pointer page  118 of  165 
 
07:14:10.39   process pointer page  119 of  165 
 
07:14:10.40   process pointer page  120 of  165 
 
07:14:10.43   process pointer page  121 of  165 
 
07:14:10.46   process pointer page  122 of  165 
 
07:14:10.50   process pointer page  123 of  165 
 
07:14:10.51   process pointer page  124 of  165 
 
07:14:10.54   process pointer page  125 of  165 
 
07:14:10.57   process pointer page  126 of  165 
 
07:14:10.60   process pointer page  127 of  165 
 
07:14:10.65   process pointer page  128 of  165 
 
07:14:10.70   process pointer page  129 of  165 
 
07:14:10.73   process pointer page  130 of  165 
 
07:14:10.76   process pointer page  131 of  165 
 
07:14:10.79   process pointer page  132 of  165 
 
07:14:10.82   process pointer page  133 of  165 
 
07:14:10.85   process pointer page  134 of  165 
 
07:14:10.89   process pointer page  135 of  165 
 
07:14:10.92   process pointer page  136 of  165 
 
07:14:10.95   process pointer page  137 of  165 
 
07:14:10.98   process pointer page  138 of  165 
 
07:14:11.03   process pointer page  139 of  165 
 
07:14:11.12   process pointer page  140 of  165 
 
07:14:11.20   process pointer page  141 of  165 
 
07:14:11.28   process pointer page  142 of  165 
 
07:14:11.34   process pointer page  143 of  165 
 
07:14:11.37   process pointer page  144 of  165 
 
07:14:11.40   process pointer page  145 of  165 
 
07:14:11.43   process pointer page  146 of  165 
 
07:14:11.46   process pointer page  147 of  165 
 
07:14:11.49   process pointer page  148 of  165 
 
07:14:11.53   process pointer page  149 of  165 
 
07:14:11.54   process pointer page  150 of  165 
 
07:14:11.57   process pointer page  151 of  165 
 
07:14:11.65   process pointer page  152 of  165 
 
07:14:11.73   process pointer page  153 of  165 
 
07:14:11.81   process pointer page  154 of  165 
 
07:14:11.85   process pointer page  155 of  165 
 
07:14:11.88   process pointer page  156 of  165 
 
07:14:11.92   process pointer page  157 of  165 
 
07:14:11.95   process pointer page  158 of  165 
 
07:14:11.98   process pointer page  159 of  165 
 
07:14:12.01   process pointer page  160 of  165 
 
07:14:12.04   process pointer page  161 of  165 
 
07:14:12.07   process pointer page  162 of  165 
 
07:14:12.09   process pointer page  163 of  165 
 
07:14:12.13   process pointer page  164 of  165 
 
07:14:12.13 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:14:14.79 Index 2 (PERF_LOG_UNIT) 
 
07:14:17.67 Index 3 (PERF_LOG_TRN_DESC) 
 
07:14:19.48 Index 4 (PERF_LOG_GDSCODE) 
 
07:14:20.68 Relation 163 (PERF_LOG) is ok 
 
 
07:14:20.68 Relation 167 (V_STOPTEST) 
 
07:14:20.68 Relation 167 (V_STOPTEST) is ok 
 
 
07:14:20.68 Relation 184 (V_QDISTR_SOURCE) 
 
07:14:20.68 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:14:20.68 Relation 185 (V_QSTORNED_SOURCE) 
 
07:14:20.68 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:14:20.68 Relation 260 (XQD_1000_1200) 
 
07:14:20.68   process pointer page    0 of    2 
 
07:14:20.70   process pointer page    1 of    2 
 
07:14:20.70 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:14:20.70 Relation 260 (XQD_1000_1200) is ok 
 
 
07:14:20.70 Relation 261 (XQD_1200_2000) 
 
07:14:20.70   process pointer page    0 of    3 
 
07:14:20.71   process pointer page    1 of    3 
 
07:14:20.71   process pointer page    2 of    3 
 
07:14:20.71 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:14:20.73 Relation 261 (XQD_1200_2000) is ok 
 
 
07:14:20.73 Relation 262 (XQD_1000_3300) 
 
07:14:20.73   process pointer page    0 of    9 
 
07:14:20.79   process pointer page    1 of    9 
 
07:14:20.85   process pointer page    2 of    9 
 
07:14:20.89   process pointer page    3 of    9 
 
07:14:20.93   process pointer page    4 of    9 
 
07:14:20.96   process pointer page    5 of    9 
 
07:14:20.99   process pointer page    6 of    9 
 
07:14:21.09   process pointer page    7 of    9 
 
07:14:21.12   process pointer page    8 of    9 
 
07:14:21.18 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:14:21.48 Index 2 (XQD_1000_3300_DOC) 
 
07:14:21.59 Relation 262 (XQD_1000_3300) is ok 
 
 
07:14:21.59 Relation 263 (XQD_2000_3300) 
 
07:14:21.59   process pointer page    0 of   15 
 
07:14:21.62   process pointer page    1 of   15 
 
07:14:21.65   process pointer page    2 of   15 
 
07:14:21.67   process pointer page    3 of   15 
 
07:14:21.71   process pointer page    4 of   15 
 
07:14:21.76   process pointer page    5 of   15 
 
07:14:21.84   process pointer page    6 of   15 
 
07:14:21.87   process pointer page    7 of   15 
 
07:14:21.95   process pointer page    8 of   15 
 
07:14:21.98   process pointer page    9 of   15 
 
07:14:22.04   process pointer page   10 of   15 
 
07:14:22.07   process pointer page   11 of   15 
 
07:14:22.10   process pointer page   12 of   15 
 
07:14:22.15   process pointer page   13 of   15 
 
07:14:22.24   process pointer page   14 of   15 
 
07:14:22.30 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:14:22.59 Relation 263 (XQD_2000_3300) is ok 
 
 
07:14:22.59 Relation 264 (XQD_2100_3300) 
 
07:14:22.59   process pointer page    0 of    3 
 
07:14:22.60   process pointer page    1 of    3 
 
07:14:22.60   process pointer page    2 of    3 
 
07:14:22.60 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:14:22.60 Relation 264 (XQD_2100_3300) is ok 
 
 
07:14:22.60 Relation 265 (XQD_3300_3400) 
 
07:14:22.60   process pointer page    0 of   24 
 
07:14:22.69   process pointer page    1 of   24 
 
07:14:22.79   process pointer page    2 of   24 
 
07:14:22.87   process pointer page    3 of   24 
 
07:14:22.96   process pointer page    4 of   24 
 
07:14:23.04   process pointer page    5 of   24 
 
07:14:23.07   process pointer page    6 of   24 
 
07:14:23.10   process pointer page    7 of   24 
 
07:14:23.15   process pointer page    8 of   24 
 
07:14:23.18   process pointer page    9 of   24 
 
07:14:23.24   process pointer page   10 of   24 
 
07:14:23.33   process pointer page   11 of   24 
 
07:14:23.41   process pointer page   12 of   24 
 
07:14:23.51   process pointer page   13 of   24 
 
07:14:23.58   process pointer page   14 of   24 
 
07:14:23.65   process pointer page   15 of   24 
 
07:14:23.69   process pointer page   16 of   24 
 
07:14:23.72   process pointer page   17 of   24 
 
07:14:23.79   process pointer page   18 of   24 
 
07:14:23.88   process pointer page   19 of   24 
 
07:14:23.94   process pointer page   20 of   24 
 
07:14:23.97   process pointer page   21 of   24 
 
07:14:24.01   process pointer page   22 of   24 
 
07:14:24.05   process pointer page   23 of   24 
 
07:14:24.05 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:14:24.57 Relation 265 (XQD_3300_3400) is ok 
 
 
07:14:24.57 Relation 266 (XQS_1000_1200) 
 
07:14:24.58   process pointer page    0 of   43 
 
07:14:24.60   process pointer page    1 of   43 
 
07:14:24.63   process pointer page    2 of   43 
 
07:14:24.66   process pointer page    3 of   43 
 
07:14:24.69   process pointer page    4 of   43 
 
07:14:24.72   process pointer page    5 of   43 
 
07:14:24.80   process pointer page    6 of   43 
 
07:14:24.89   process pointer page    7 of   43 
 
07:14:24.99   process pointer page    8 of   43 
 
07:14:25.05   process pointer page    9 of   43 
 
07:14:25.08   process pointer page   10 of   43 
 
07:14:25.11   process pointer page   11 of   43 
 
07:14:25.18   process pointer page   12 of   43 
 
07:14:25.25   process pointer page   13 of   43 
 
07:14:25.35   process pointer page   14 of   43 
 
07:14:25.44   process pointer page   15 of   43 
 
07:14:25.47   process pointer page   16 of   43 
 
07:14:25.50   process pointer page   17 of   43 
 
07:14:25.53   process pointer page   18 of   43 
 
07:14:25.57   process pointer page   19 of   43 
 
07:14:25.61   process pointer page   20 of   43 
 
07:14:25.63   process pointer page   21 of   43 
 
07:14:25.66   process pointer page   22 of   43 
 
07:14:25.69   process pointer page   23 of   43 
 
07:14:25.72   process pointer page   24 of   43 
 
07:14:25.75   process pointer page   25 of   43 
 
07:14:25.78   process pointer page   26 of   43 
 
07:14:25.81   process pointer page   27 of   43 
 
07:14:25.86   process pointer page   28 of   43 
 
07:14:25.94   process pointer page   29 of   43 
 
07:14:26.03   process pointer page   30 of   43 
 
07:14:26.06   process pointer page   31 of   43 
 
07:14:26.10   process pointer page   32 of   43 
 
07:14:26.13   process pointer page   33 of   43 
 
07:14:26.22   process pointer page   34 of   43 
 
07:14:26.28   process pointer page   35 of   43 
 
07:14:26.31   process pointer page   36 of   43 
 
07:14:26.36   process pointer page   37 of   43 
 
07:14:26.39   process pointer page   38 of   43 
 
07:14:26.42   process pointer page   39 of   43 
 
07:14:26.45   process pointer page   40 of   43 
 
07:14:26.49   process pointer page   41 of   43 
 
07:14:26.52   process pointer page   42 of   43 
 
07:14:26.53 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:14:27.42 Index 2 (XQS_1000_1200_SND_ID) 
 
07:14:28.48 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:14:29.28 Relation 266 (XQS_1000_1200) is ok 
 
 
07:14:29.28 Relation 267 (XQS_1200_2000) 
 
07:14:29.28   process pointer page    0 of   46 
 
07:14:29.31   process pointer page    1 of   46 
 
07:14:29.36   process pointer page    2 of   46 
 
07:14:29.45   process pointer page    3 of   46 
 
07:14:29.54   process pointer page    4 of   46 
 
07:14:29.62   process pointer page    5 of   46 
 
07:14:29.71   process pointer page    6 of   46 
 
07:14:29.81   process pointer page    7 of   46 
 
07:14:29.90   process pointer page    8 of   46 
 
07:14:30.00   process pointer page    9 of   46 
 
07:14:30.09   process pointer page   10 of   46 
 
07:14:30.20   process pointer page   11 of   46 
 
07:14:30.31   process pointer page   12 of   46 
 
07:14:30.40   process pointer page   13 of   46 
 
07:14:30.51   process pointer page   14 of   46 
 
07:14:30.60   process pointer page   15 of   46 
 
07:14:30.71   process pointer page   16 of   46 
 
07:14:30.82   process pointer page   17 of   46 
 
07:14:30.93   process pointer page   18 of   46 
 
07:14:31.03   process pointer page   19 of   46 
 
07:14:31.13   process pointer page   20 of   46 
 
07:14:31.21   process pointer page   21 of   46 
 
07:14:31.27   process pointer page   22 of   46 
 
07:14:31.35   process pointer page   23 of   46 
 
07:14:31.38   process pointer page   24 of   46 
 
07:14:31.43   process pointer page   25 of   46 
 
07:14:31.46   process pointer page   26 of   46 
 
07:14:31.51   process pointer page   27 of   46 
 
07:14:31.54   process pointer page   28 of   46 
 
07:14:31.57   process pointer page   29 of   46 
 
07:14:31.62   process pointer page   30 of   46 
 
07:14:31.65   process pointer page   31 of   46 
 
07:14:31.71   process pointer page   32 of   46 
 
07:14:31.74   process pointer page   33 of   46 
 
07:14:31.77   process pointer page   34 of   46 
 
07:14:31.82   process pointer page   35 of   46 
 
07:14:31.85   process pointer page   36 of   46 
 
07:14:31.88   process pointer page   37 of   46 
 
07:14:31.90   process pointer page   38 of   46 
 
07:14:31.95   process pointer page   39 of   46 
 
07:14:31.96   process pointer page   40 of   46 
 
07:14:31.99   process pointer page   41 of   46 
 
07:14:32.02   process pointer page   42 of   46 
 
07:14:32.05   process pointer page   43 of   46 
 
07:14:32.10   process pointer page   44 of   46 
 
07:14:32.16   process pointer page   45 of   46 
 
07:14:32.26 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:14:33.51 Index 2 (XQS_1200_2000_SND_ID) 
 
07:14:34.96 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:14:36.14 Relation 267 (XQS_1200_2000) is ok 
 
 
07:14:36.14 Relation 268 (XQS_1000_3300) 
 
07:14:36.14   process pointer page    0 of   24 
 
07:14:36.64   process pointer page    1 of   24 
 
07:14:37.12   process pointer page    2 of   24 
 
07:14:37.61   process pointer page    3 of   24 
 
07:14:38.09   process pointer page    4 of   24 
 
07:14:38.59   process pointer page    5 of   24 
 
07:14:39.07   process pointer page    6 of   24 
 
07:14:39.56   process pointer page    7 of   24 
 
07:14:39.93   process pointer page    8 of   24 
 
07:14:40.29   process pointer page    9 of   24 
 
07:14:40.65   process pointer page   10 of   24 
 
07:14:41.04   process pointer page   11 of   24 
 
07:14:41.41   process pointer page   12 of   24 
 
07:14:41.76   process pointer page   13 of   24 
 
07:14:42.13   process pointer page   14 of   24 
 
07:14:42.49   process pointer page   15 of   24 
 
07:14:42.87   process pointer page   16 of   24 
 
07:14:43.22   process pointer page   17 of   24 
 
07:14:43.58   process pointer page   18 of   24 
 
07:14:43.99   process pointer page   19 of   24 
 
07:14:44.36   process pointer page   20 of   24 
 
07:14:44.74   process pointer page   21 of   24 
 
07:14:45.13   process pointer page   22 of   24 
 
07:14:45.52   process pointer page   23 of   24 
 
07:14:45.74 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:14:47.09 Index 2 (XQS_1000_3300_SND_ID) 
 
07:14:48.59 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:14:49.98 Relation 268 (XQS_1000_3300) is ok 
 
 
07:14:49.98 Relation 269 (XQS_2000_3300) 
 
07:14:49.98   process pointer page    0 of    1 
 
07:14:49.98 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:14:49.98 Index 2 (XQS_2000_3300_SND_ID) 
 
07:14:49.98 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:14:49.98 Relation 269 (XQS_2000_3300) is ok 
 
 
07:14:49.98 Relation 270 (XQS_2100_3300) 
 
07:14:49.98   process pointer page    0 of   32 
 
07:14:50.45   process pointer page    1 of   32 
 
07:14:50.93   process pointer page    2 of   32 
 
07:14:51.41   process pointer page    3 of   32 
 
07:14:51.90   process pointer page    4 of   32 
 
07:14:52.38   process pointer page    5 of   32 
 
07:14:52.87   process pointer page    6 of   32 
 
07:14:53.36   process pointer page    7 of   32 
 
07:14:53.83   process pointer page    8 of   32 
 
07:14:54.27   process pointer page    9 of   32 
 
07:14:54.68   process pointer page   10 of   32 
 
07:14:54.97   process pointer page   11 of   32 
 
07:14:55.33   process pointer page   12 of   32 
 
07:14:55.67   process pointer page   13 of   32 
 
07:14:56.13   process pointer page   14 of   32 
 
07:14:56.53   process pointer page   15 of   32 
 
07:14:56.95   process pointer page   16 of   32 
 
07:14:57.36   process pointer page   17 of   32 
 
07:14:57.72   process pointer page   18 of   32 
 
07:14:58.11   process pointer page   19 of   32 
 
07:14:58.54   process pointer page   20 of   32 
 
07:14:58.95   process pointer page   21 of   32 
 
07:14:59.34   process pointer page   22 of   32 
 
07:14:59.73   process pointer page   23 of   32 
 
07:15:00.12   process pointer page   24 of   32 
 
07:15:00.53   process pointer page   25 of   32 
 
07:15:00.92   process pointer page   26 of   32 
 
07:15:01.34   process pointer page   27 of   32 
 
07:15:01.77   process pointer page   28 of   32 
 
07:15:02.16   process pointer page   29 of   32 
 
07:15:02.58   process pointer page   30 of   32 
 
07:15:02.96   process pointer page   31 of   32 
 
07:15:03.11 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:15:04.69 Index 2 (XQS_2100_3300_SND_ID) 
 
07:15:06.33 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:15:08.26 Relation 270 (XQS_2100_3300) is ok 
 
 
07:15:08.26 Relation 271 (XQS_3300_3400) 
 
07:15:08.26   process pointer page    0 of    6 
 
07:15:08.75   process pointer page    1 of    6 
 
07:15:09.23   process pointer page    2 of    6 
 
07:15:09.71   process pointer page    3 of    6 
 
07:15:10.18   process pointer page    4 of    6 
 
07:15:10.63   process pointer page    5 of    6 
 
07:15:10.87 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:15:11.24 Index 2 (XQS_3300_3400_SND_ID) 
 
07:15:11.65 Relation 271 (XQS_3300_3400) is ok 
 
 
07:15:11.66 Validation finished 
 
Done for 70820 ms, from  7:14:01.00 to  7:15:11.82. 
 
 Differences between old and current firebird.log 
7:15:13.64. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2017-08-22  07:15               471 oltp30_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Tue Aug 22 07:14:01 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Tue Aug 22 07:15:11 2017 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 397 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*: 
 
 
| ERRORS_CHECKING_RESULT | 
| NO_SEVERE_ERRORS_FOUND | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2017-08-22  7:15:20.99 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html