Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-10-14  6:50:12.15.
 
Server version: WI-V3.0.3.32806 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-10-14 06:46:45.0370 | -1 | <null> |  | ::1/51101 | 447976 | 9329 | 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: | 6234.31 | 2982 | 1122175 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| customer order: creation | 468.92 | 427 | 84405 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| customer order: refuse | 38.56 | 223 | 6941 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| order to supplier: creation | 120.23 | 1914 | 21642 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| order to supplier: removal | 3.15 | 17254 | 567 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| invoice (draft): creation | 120.39 | 2694 | 21671 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| invoice (draft): removal | 42.53 | 445 | 7656 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| invoice accept: apply | 65.08 | 10015 | 11715 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| invoice accept: cancel | 19.32 | 2768 | 3477 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| customer reserve: creation | 3570.58 | 148 | 642705 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| customer reserve: removal | 1134.21 | 61 | 204158 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| realization accept: apply | 217.74 | 467 | 39194 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| realization accept: cancel | 94.13 | 133 | 16943 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| payment from customer: creation | 157.93 | 798 | 28428 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| payment from customer: removal | 15.03 | 109 | 2706 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| payment to supplier: creation | 129.52 | 515 | 23314 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| payment to supplier: removal | 9.19 | 126 | 1654 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| service: total inventory turnovers | 9.47 | 2837 | 1704 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| service: total monetary turnovers | 18.24 | 59 | 3283 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| service: refresh index statistics | 0.07 | 15661 | 12 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
 
Done for 84980 ms, from  6:52:36.39 to  6:54:01.37.  
 
| ACTION | ITRV_NO | CNT_OK_PER_MINUTE | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | ITRV_BEG | ITRV_END | 
| interval #   1, overall | 1 | 5120 | 106156 | 92155 | 14001 | 13.19 | 03:46:46 | 04:04:45 | 
| interval #   2, overall | 2 | 7183 | 141091 | 129293 | 11798 | 8.36 | 04:04:46 | 04:22:45 | 
| interval #   3, overall | 3 | 6561 | 137214 | 118092 | 19122 | 13.94 | 04:22:46 | 04:40:45 | 
| interval #   4, overall | 4 | 6686 | 139345 | 120340 | 19005 | 13.64 | 04:40:46 | 04:58:45 | 
| interval #   5, overall | 5 | 6660 | 134925 | 119887 | 15038 | 11.15 | 04:58:46 | 05:16:45 | 
| interval #   6, overall | 6 | 6426 | 133900 | 115675 | 18225 | 13.61 | 05:16:46 | 05:34:45 | 
| interval #   7, overall | 7 | 5594 | 118590 | 100698 | 17892 | 15.09 | 05:34:46 | 05:52:45 | 
| interval #   8, overall | 8 | 6460 | 135420 | 116271 | 19149 | 14.14 | 05:52:46 | 06:10:45 | 
| interval #   9, overall | 9 | 5890 | 123411 | 106014 | 17397 | 14.10 | 06:10:46 | 06:28:45 | 
| interval #  10, overall | 10 | 5764 | 114820 | 103750 | 11070 | 9.64 | 06:28:46 | 06:46:45 | 
 
Done for 226190 ms, from  6:57:33.99 to  7:01:20.18.  
 
| TEST_PHASE | MINUTE_SINCE_TEST_START | AVG_ESTIMATED | MIN_TO_AVG_RATIO | MAX_TO_AVG_RATIO | ROWS_AGGREGATED | DISTINCT_ATTACHMENTS | 
| TEST_TIME | 1 | 2599.04 | 0.2285 | 1.8614 | 2008 | 100 | 
| TEST_TIME | 2 | 3422.44 | 0.7068 | 1.2394 | 1887 | 100 | 
| TEST_TIME | 3 | 3389.56 | 0.8347 | 1.1709 | 1560 | 100 | 
| TEST_TIME | 4 | 3484.42 | 0.8616 | 1.1430 | 1810 | 100 | 
| TEST_TIME | 5 | 3644.62 | 0.8742 | 1.1550 | 1715 | 100 | 
| TEST_TIME | 6 | 3821.44 | 0.9180 | 1.0947 | 1455 | 100 | 
| TEST_TIME | 7 | 3931.30 | 0.9123 | 1.1059 | 1689 | 100 | 
| TEST_TIME | 8 | 4095.91 | 0.9289 | 1.0735 | 1519 | 100 | 
| TEST_TIME | 9 | 4221.18 | 0.9260 | 1.0840 | 1744 | 100 | 
| TEST_TIME | 10 | 4352.21 | 0.9472 | 1.0674 | 1634 | 100 | 
| TEST_TIME | 11 | 4459.17 | 0.9471 | 1.0622 | 1580 | 100 | 
| TEST_TIME | 12 | 4545.95 | 0.9551 | 1.0478 | 1432 | 100 | 
| TEST_TIME | 13 | 4584.43 | 0.9591 | 1.0365 | 1526 | 100 | 
| TEST_TIME | 14 | 4617.71 | 0.9555 | 1.0413 | 1573 | 100 | 
| TEST_TIME | 15 | 4660.07 | 0.9630 | 1.0373 | 1493 | 100 | 
| TEST_TIME | 16 | 4741.45 | 0.9557 | 1.0508 | 1926 | 100 | 
| TEST_TIME | 17 | 4916.07 | 0.9538 | 1.0510 | 2004 | 100 | 
| TEST_TIME | 18 | 5024.71 | 0.9712 | 1.0271 | 1553 | 100 | 
| TEST_TIME | 19 | 5066.18 | 0.9655 | 1.0352 | 1906 | 100 | 
| TEST_TIME | 20 | 5150.53 | 0.9680 | 1.0421 | 1776 | 32 | 
| TEST_TIME | 21 | 5252.50 | 0.9732 | 1.0277 | 1798 | 27 | 
| TEST_TIME | 22 | 5314.60 | 0.9696 | 1.0351 | 1687 | 22 | 
| TEST_TIME | 23 | 5413.52 | 0.9725 | 1.0254 | 1688 | 22 | 
| TEST_TIME | 24 | 5451.45 | 0.9758 | 1.0286 | 1611 | 17 | 
| TEST_TIME | 25 | 5498.23 | 0.9790 | 1.0234 | 1227 | 99 | 
| TEST_TIME | 26 | 5551.44 | 0.9746 | 1.0243 | 1540 | 100 | 
| TEST_TIME | 27 | 5583.73 | 0.9807 | 1.0210 | 1521 | 100 | 
| TEST_TIME | 28 | 5626.40 | 0.9770 | 1.0216 | 1361 | 100 | 
| TEST_TIME | 29 | 5666.37 | 0.9818 | 1.0165 | 1234 | 100 | 
| TEST_TIME | 30 | 5656.86 | 0.9843 | 1.0138 | 1433 | 100 | 
| TEST_TIME | 31 | 5724.03 | 0.9703 | 1.0259 | 2246 | 100 | 
| TEST_TIME | 32 | 5838.73 | 0.9751 | 1.0305 | 2057 | 100 | 
| TEST_TIME | 33 | 5974.68 | 0.9766 | 1.0188 | 1857 | 100 | 
| TEST_TIME | 34 | 6019.28 | 0.9815 | 1.0218 | 1880 | 100 | 
| TEST_TIME | 35 | 6081.66 | 0.9825 | 1.0160 | 1545 | 100 | 
| TEST_TIME | 36 | 6098.54 | 0.9855 | 1.0172 | 1753 | 100 | 
| TEST_TIME | 37 | 6159.22 | 0.9799 | 1.0195 | 1713 | 100 | 
| TEST_TIME | 38 | 6205.56 | 0.9857 | 1.0134 | 1542 | 100 | 
| TEST_TIME | 39 | 6202.02 | 0.9885 | 1.0114 | 1325 | 100 | 
| TEST_TIME | 40 | 6201.50 | 0.9862 | 1.0115 | 1589 | 100 | 
| TEST_TIME | 41 | 6187.49 | 0.9891 | 1.0104 | 1495 | 100 | 
| TEST_TIME | 42 | 6185.26 | 0.9867 | 1.0089 | 1338 | 100 | 
| TEST_TIME | 43 | 6157.42 | 0.9899 | 1.0120 | 1349 | 100 | 
| TEST_TIME | 44 | 6118.79 | 0.9952 | 1.0141 | 1198 | 100 | 
| TEST_TIME | 45 | 6099.90 | 0.9946 | 1.0057 | 1196 | 99 | 
| TEST_TIME | 46 | 6099.88 | 0.9867 | 1.0092 | 1773 | 99 | 
| TEST_TIME | 47 | 6084.95 | 0.9902 | 1.0144 | 2072 | 98 | 
| TEST_TIME | 48 | 6132.11 | 0.9875 | 1.0115 | 1761 | 100 | 
| TEST_TIME | 49 | 6159.69 | 0.9870 | 1.0088 | 1952 | 100 | 
| TEST_TIME | 50 | 6139.91 | 0.9918 | 1.0094 | 2029 | 98 | 
| TEST_TIME | 51 | 6140.09 | 0.9896 | 1.0153 | 1660 | 99 | 
| TEST_TIME | 52 | 6194.18 | 0.9888 | 1.0106 | 1686 | 100 | 
| TEST_TIME | 53 | 6220.44 | 0.9873 | 1.0118 | 1657 | 100 | 
| TEST_TIME | 54 | 6246.35 | 0.9889 | 1.0102 | 1534 | 100 | 
| TEST_TIME | 55 | 6251.12 | 0.9911 | 1.0090 | 1526 | 100 | 
| TEST_TIME | 56 | 6263.38 | 0.9891 | 1.0130 | 1293 | 100 | 
| TEST_TIME | 57 | 6291.91 | 0.9912 | 1.0064 | 1370 | 100 | 
| TEST_TIME | 58 | 6283.41 | 0.9904 | 1.0095 | 1376 | 100 | 
| TEST_TIME | 59 | 6287.86 | 0.9917 | 1.0078 | 1469 | 100 | 
| TEST_TIME | 60 | 6273.55 | 0.9933 | 1.0078 | 1297 | 100 | 
| TEST_TIME | 61 | 6244.81 | 0.9959 | 1.0071 | 1889 | 99 | 
| TEST_TIME | 62 | 6281.28 | 0.9851 | 1.0069 | 1788 | 87 | 
| TEST_TIME | 63 | 6291.75 | 0.9893 | 1.0128 | 1846 | 79 | 
| TEST_TIME | 64 | 6319.07 | 0.9927 | 1.0048 | 1703 | 99 | 
| TEST_TIME | 65 | 6288.27 | 0.9942 | 1.0084 | 1764 | 95 | 
| TEST_TIME | 66 | 6311.44 | 0.9895 | 1.0065 | 1752 | 96 | 
| TEST_TIME | 67 | 6306.27 | 0.9923 | 1.0049 | 1793 | 97 | 
| TEST_TIME | 68 | 6292.85 | 0.9924 | 1.0125 | 1350 | 93 | 
| TEST_TIME | 69 | 6324.28 | 0.9932 | 1.0083 | 1298 | 100 | 
| TEST_TIME | 70 | 6341.29 | 0.9913 | 1.0078 | 1379 | 100 | 
| TEST_TIME | 71 | 6359.91 | 0.9908 | 1.0063 | 1324 | 100 | 
| TEST_TIME | 72 | 6361.80 | 0.9921 | 1.0089 | 1402 | 100 | 
| TEST_TIME | 73 | 6377.40 | 0.9927 | 1.0072 | 1385 | 100 | 
| TEST_TIME | 74 | 6388.62 | 0.9918 | 1.0086 | 1188 | 100 | 
| TEST_TIME | 75 | 6387.38 | 0.9953 | 1.0072 | 1309 | 100 | 
| TEST_TIME | 76 | 6399.02 | 0.9921 | 1.0078 | 1981 | 100 | 
| TEST_TIME | 77 | 6416.73 | 0.9920 | 1.0079 | 2071 | 100 | 
| TEST_TIME | 78 | 6447.90 | 0.9907 | 1.0090 | 1873 | 100 | 
| TEST_TIME | 79 | 6469.47 | 0.9929 | 1.0051 | 1863 | 99 | 
| TEST_TIME | 80 | 6478.37 | 0.9911 | 1.0050 | 1604 | 93 | 
| TEST_TIME | 81 | 6468.04 | 0.9942 | 1.0066 | 1395 | 100 | 
| TEST_TIME | 82 | 6491.26 | 0.9907 | 1.0043 | 1607 | 100 | 
| TEST_TIME | 83 | 6471.65 | 0.9952 | 1.0045 | 1600 | 93 | 
| TEST_TIME | 84 | 6466.30 | 0.9934 | 1.0050 | 1507 | 97 | 
| TEST_TIME | 85 | 6443.09 | 0.9967 | 1.0051 | 1391 | 94 | 
| TEST_TIME | 86 | 6427.71 | 0.9958 | 1.0058 | 1435 | 98 | 
| TEST_TIME | 87 | 6434.33 | 0.9932 | 1.0069 | 1267 | 100 | 
| TEST_TIME | 88 | 6430.39 | 0.9961 | 1.0054 | 1292 | 100 | 
| TEST_TIME | 89 | 6416.18 | 0.9967 | 1.0027 | 1396 | 100 | 
| TEST_TIME | 90 | 6423.69 | 0.9937 | 1.0052 | 1230 | 100 | 
| TEST_TIME | 91 | 6426.44 | 0.9938 | 1.0081 | 1669 | 100 | 
| TEST_TIME | 92 | 6457.88 | 0.9924 | 1.0085 | 1881 | 100 | 
| TEST_TIME | 93 | 6483.65 | 0.9937 | 1.0067 | 1842 | 100 | 
| TEST_TIME | 94 | 6507.45 | 0.9923 | 1.0073 | 1607 | 100 | 
| TEST_TIME | 95 | 6510.65 | 0.9962 | 1.0073 | 1825 | 100 | 
| TEST_TIME | 96 | 6512.76 | 0.9964 | 1.0037 | 1543 | 99 | 
| TEST_TIME | 97 | 6493.67 | 0.9962 | 1.0029 | 1705 | 99 | 
| TEST_TIME | 98 | 6483.17 | 0.9943 | 1.0045 | 1499 | 98 | 
| TEST_TIME | 99 | 6468.16 | 0.9967 | 1.0072 | 1356 | 100 | 
| TEST_TIME | 100 | 6474.07 | 0.9962 | 1.0047 | 1388 | 100 | 
| TEST_TIME | 101 | 6450.80 | 0.9983 | 1.0027 | 1595 | 97 | 
| TEST_TIME | 102 | 6429.81 | 0.9961 | 1.0035 | 1449 | 92 | 
| TEST_TIME | 103 | 6427.51 | 0.9941 | 1.0056 | 1190 | 100 | 
| TEST_TIME | 104 | 6427.84 | 0.9960 | 1.0018 | 1170 | 100 | 
| TEST_TIME | 105 | 6417.52 | 0.9967 | 1.0024 | 1268 | 99 | 
| TEST_TIME | 106 | 6403.30 | 0.9951 | 1.0029 | 1623 | 97 | 
| TEST_TIME | 107 | 6407.05 | 0.9951 | 1.0040 | 2006 | 93 | 
| TEST_TIME | 108 | 6408.26 | 0.9945 | 1.0070 | 1627 | 96 | 
| TEST_TIME | 109 | 6427.98 | 0.9947 | 1.0037 | 1734 | 100 | 
| TEST_TIME | 110 | 6417.03 | 0.9963 | 1.0051 | 1988 | 98 | 
| TEST_TIME | 111 | 6416.84 | 0.9961 | 1.0036 | 1829 | 98 | 
| TEST_TIME | 112 | 6406.84 | 0.9962 | 1.0035 | 1750 | 96 | 
| TEST_TIME | 113 | 6403.30 | 0.9951 | 1.0033 | 1705 | 94 | 
| TEST_TIME | 114 | 6381.38 | 0.9979 | 1.0023 | 1568 | 92 | 
| TEST_TIME | 115 | 6359.69 | 0.9970 | 1.0036 | 1455 | 90 | 
| TEST_TIME | 116 | 6359.22 | 0.9973 | 1.0018 | 1421 | 97 | 
| TEST_TIME | 117 | 6330.32 | 0.9978 | 1.0029 | 1516 | 88 | 
| TEST_TIME | 118 | 6327.38 | 0.9948 | 1.0019 | 1098 | 100 | 
| TEST_TIME | 119 | 6299.25 | 0.9979 | 1.0020 | 1520 | 96 | 
| TEST_TIME | 120 | 6280.69 | 0.9966 | 1.0071 | 1292 | 98 | 
| TEST_TIME | 121 | 6303.92 | 0.9951 | 1.0036 | 1738 | 99 | 
| TEST_TIME | 122 | 6293.37 | 0.9970 | 1.0045 | 2054 | 96 | 
| TEST_TIME | 123 | 6302.61 | 0.9949 | 1.0049 | 1771 | 92 | 
| TEST_TIME | 124 | 6295.83 | 0.9979 | 1.0047 | 1767 | 95 | 
| TEST_TIME | 125 | 6296.69 | 0.9966 | 1.0063 | 1618 | 100 | 
| TEST_TIME | 126 | 6308.07 | 0.9965 | 1.0025 | 1653 | 100 | 
| TEST_TIME | 127 | 6290.61 | 0.9973 | 1.0051 | 1673 | 96 | 
| TEST_TIME | 128 | 6294.83 | 0.9965 | 1.0052 | 1475 | 100 | 
| TEST_TIME | 129 | 6305.86 | 0.9956 | 1.0045 | 1496 | 100 | 
| TEST_TIME | 130 | 6321.41 | 0.9943 | 1.0042 | 1521 | 100 | 
| TEST_TIME | 131 | 6328.05 | 0.9957 | 1.0078 | 1519 | 100 | 
| TEST_TIME | 132 | 6351.30 | 0.9965 | 1.0032 | 1468 | 100 | 
| TEST_TIME | 133 | 6335.93 | 0.9980 | 1.0014 | 1544 | 100 | 
| TEST_TIME | 134 | 6326.33 | 0.9955 | 1.0045 | 1147 | 100 | 
| TEST_TIME | 135 | 6319.20 | 0.9983 | 1.0016 | 1253 | 100 | 
| TEST_TIME | 136 | 6312.08 | 0.9954 | 1.0029 | 1568 | 100 | 
| TEST_TIME | 137 | 6310.46 | 0.9959 | 1.0030 | 1780 | 98 | 
| TEST_TIME | 138 | 6310.34 | 0.9958 | 1.0025 | 1847 | 96 | 
| TEST_TIME | 139 | 6307.22 | 0.9958 | 1.0052 | 1511 | 96 | 
| TEST_TIME | 140 | 6308.80 | 0.9978 | 1.0029 | 1836 | 96 | 
| TEST_TIME | 141 | 6312.72 | 0.9964 | 1.0042 | 1625 | 100 | 
| TEST_TIME | 142 | 6323.46 | 0.9955 | 1.0050 | 1511 | 100 | 
| TEST_TIME | 143 | 6330.73 | 0.9969 | 1.0024 | 1685 | 99 | 
| TEST_TIME | 144 | 6321.78 | 0.9969 | 1.0030 | 1534 | 99 | 
| TEST_TIME | 145 | 6310.17 | 0.9980 | 1.0034 | 1527 | 99 | 
| TEST_TIME | 146 | 6305.89 | 0.9972 | 1.0038 | 1398 | 100 | 
| TEST_TIME | 147 | 6300.34 | 0.9980 | 1.0021 | 1345 | 100 | 
| TEST_TIME | 148 | 6281.01 | 0.9984 | 1.0021 | 1485 | 94 | 
| TEST_TIME | 149 | 6274.12 | 0.9965 | 1.0036 | 1165 | 100 | 
| TEST_TIME | 150 | 6270.28 | 0.9975 | 1.0027 | 1148 | 100 | 
| TEST_TIME | 151 | 6270.90 | 0.9960 | 1.0035 | 1315 | 100 | 
| TEST_TIME | 152 | 6284.73 | 0.9948 | 1.0051 | 1775 | 100 | 
| TEST_TIME | 153 | 6296.01 | 0.9967 | 1.0026 | 1807 | 95 | 
| TEST_TIME | 154 | 6305.97 | 0.9945 | 1.0043 | 1519 | 100 | 
| TEST_TIME | 155 | 6306.66 | 0.9977 | 1.0028 | 1686 | 98 | 
| TEST_TIME | 156 | 6301.55 | 0.9972 | 1.0027 | 1653 | 90 | 
| TEST_TIME | 157 | 6302.31 | 0.9962 | 1.0030 | 1537 | 90 | 
| TEST_TIME | 158 | 6305.96 | 0.9960 | 1.0030 | 1477 | 90 | 
| TEST_TIME | 159 | 6299.38 | 0.9977 | 1.0019 | 1547 | 90 | 
| TEST_TIME | 160 | 6285.27 | 0.9979 | 1.0022 | 1314 | 91 | 
| TEST_TIME | 161 | 6284.31 | 0.9971 | 1.0015 | 1310 | 96 | 
| TEST_TIME | 162 | 6268.81 | 0.9978 | 1.0041 | 1353 | 93 | 
| TEST_TIME | 163 | 6274.69 | 0.9970 | 1.0023 | 1127 | 100 | 
| TEST_TIME | 164 | 6268.43 | 0.9983 | 1.0014 | 1264 | 99 | 
| TEST_TIME | 165 | 6248.20 | 0.9986 | 1.0035 | 1269 | 94 | 
| TEST_TIME | 166 | 6243.89 | 0.9984 | 1.0017 | 1525 | 96 | 
| TEST_TIME | 167 | 6235.44 | 0.9970 | 1.0027 | 1832 | 91 | 
| TEST_TIME | 168 | 6239.60 | 0.9961 | 1.0042 | 1633 | 88 | 
| TEST_TIME | 169 | 6249.55 | 0.9972 | 1.0025 | 1526 | 89 | 
| TEST_TIME | 170 | 6245.69 | 0.9972 | 1.0025 | 1556 | 95 | 
| TEST_TIME | 171 | 6249.83 | 0.9960 | 1.0025 | 1671 | 92 | 
| TEST_TIME | 172 | 6244.72 | 0.9975 | 1.0029 | 1449 | 88 | 
| TEST_TIME | 173 | 6246.80 | 0.9967 | 1.0025 | 1506 | 91 | 
| TEST_TIME | 174 | 6242.82 | 0.9974 | 1.0048 | 1384 | 98 | 
| TEST_TIME | 175 | 6244.53 | 0.9988 | 1.0029 | 1320 | 97 | 
| TEST_TIME | 176 | 6235.42 | 0.9986 | 1.0018 | 1387 | 96 | 
| TEST_TIME | 177 | 6223.48 | 0.9980 | 1.0020 | 1514 | 95 | 
| TEST_TIME | 178 | 6217.90 | 0.9972 | 1.0015 | 1459 | 97 | 
| TEST_TIME | 179 | 6215.12 | 0.9964 | 1.0055 | 1201 | 96 | 
| TEST_TIME | 180 | 6226.33 | 0.9981 | 1.0012 | 827 | 100 | 
 
Done for 9340 ms, from  7:01:21.60 to  7:01:30.94.  
 
 
| 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 | 72295 | 122768 | 59587 | 81648 | 42773 | 87679 | 89453 | 113970 | 42166 | 13293 | 79725 | 58070 | 106098 | 59018 | 135060 | 57970 | 180701 | 1002000 | <null> | 03:46:46 | 04:04:45 | 
| fetches per second | 2 | 41138 | 57248 | 34321 | <null> | 27439 | 40376 | 65173 | 60109 | 45374 | 109023 | 46268 | 4481 | 65887 | 9471 | 92118 | 31590 | 104042 | 132551 | <null> | 04:04:46 | 04:22:45 | 
| fetches per second | 3 | 37351 | 164850 | 47569 | <null> | 38652 | <null> | 87924 | 53588 | 8134 | 149327 | 41329 | 40535 | 42738 | 40367 | 110747 | 3838 | 24699 | 77550 | <null> | 04:22:46 | 04:40:45 | 
| fetches per second | 4 | 43233 | 63572 | 36259 | <null> | 29714 | <null> | 62566 | 8268 | 8169 | <null> | 37917 | 24036 | 65284 | 61153 | 64234 | 8881 | 177447 | 7887 | <null> | 04:40:46 | 04:58:45 | 
| fetches per second | 5 | 32232 | 34923 | 29045 | <null> | 32120 | <null> | 28111 | 99130 | 37169 | 14418 | 33396 | 44014 | 32721 | 61916 | 60163 | <null> | 14546 | 719750 | <null> | 04:58:46 | 05:16:45 | 
| fetches per second | 6 | 17853 | 46845 | 21637 | 39230 | 15804 | <null> | 52306 | 6499 | 59212 | 44317 | 26264 | 14735 | 27800 | 2025 | 23208 | 3784 | 423736 | 47214 | <null> | 05:16:46 | 05:34:45 | 
| fetches per second | 7 | 11606 | 12091 | 48375 | <null> | 4791 | <null> | 15245 | 9277 | 5961 | 3688 | 11953 | 14929 | 13628 | 3093 | 14709 | <null> | <null> | 70463 | <null> | 05:34:46 | 05:52:45 | 
| fetches per second | 8 | 12636 | 38609 | 15473 | <null> | 41292 | 90150 | 28172 | <null> | 10017 | 3947 | 25101 | 7502 | 30033 | <null> | 59378 | 51857 | 420341 | 35540 | <null> | 05:52:46 | 06:10:45 | 
| fetches per second | 9 | 16568 | 22068 | 21623 | 44219 | 15817 | 3682 | 26404 | <null> | 17426 | 8757 | 11180 | 5368 | 13813 | 6290 | 19863 | 7891 | <null> | 37001 | <null> | 06:10:46 | 06:28:45 | 
| fetches per second | 10 | 5484 | 29480 | 6797 | 4947 | 7716 | <null> | 8449 | 6076 | 17740 | 5919 | 19672 | 1684 | 24160 | 8307 | 16066 | 2479 | <null> | 20594 | <null> | 06:28:46 | 06:46:45 | 
| marks per second | 1 | 15871 | 15235 | 13126 | 15957 | 9452 | 18792 | 11322 | 20026 | 5960 | 2616 | 13021 | 9951 | 8801 | 10290 | 6146 | 9670 | 30926 | 98000 | <null> | 03:46:46 | 04:04:45 | 
| marks per second | 2 | 8829 | 7661 | 7095 | <null> | 5459 | 8041 | 7921 | 10148 | 5617 | 18272 | 7821 | 723 | 4740 | 1385 | 3898 | 8181 | 11591 | 4495 | <null> | 04:04:46 | 04:22:45 | 
| marks per second | 3 | 7696 | 23650 | 9508 | <null> | 7902 | <null> | 10552 | 7836 | 1106 | 26712 | 6532 | 6125 | 3034 | 7851 | 5805 | 536 | 1391 | 9793 | <null> | 04:22:46 | 04:40:45 | 
| marks per second | 4 | 9296 | 8400 | 7789 | <null> | 6564 | <null> | 8504 | 1340 | 714 | <null> | 5173 | 4466 | 4520 | 11384 | 4733 | 1790 | 25048 | 165 | <null> | 04:40:46 | 04:58:45 | 
| marks per second | 5 | 6651 | 4435 | 6378 | <null> | 7041 | <null> | 3266 | 14584 | 3727 | 2746 | 3042 | 6928 | 2431 | 8750 | 4284 | <null> | 1095 | 46500 | <null> | 04:58:46 | 05:16:45 | 
| marks per second | 6 | 3532 | 6529 | 4449 | 6701 | 2927 | <null> | 7613 | 964 | 7167 | 7070 | 3124 | 2205 | 1300 | 300 | 2467 | 735 | 8122 | 1085 | <null> | 05:16:46 | 05:34:45 | 
| marks per second | 7 | 2411 | 1589 | 4786 | <null> | 741 | <null> | 1329 | 1506 | 663 | 535 | 1263 | 1570 | 606 | 493 | 1306 | <null> | <null> | 1509 | <null> | 05:34:46 | 05:52:45 | 
| marks per second | 8 | 2469 | 5037 | 3174 | <null> | 8465 | 23550 | 3167 | <null> | 2204 | 572 | 4293 | 1173 | 1364 | <null> | 7208 | 7071 | 29182 | 505 | <null> | 05:52:46 | 06:10:45 | 
| marks per second | 9 | 3255 | 2536 | 4349 | 10554 | 3678 | 872 | 2956 | <null> | 2218 | 1544 | 1498 | 795 | 457 | 878 | 3113 | 1086 | <null> | 963 | <null> | 06:10:46 | 06:28:45 | 
| marks per second | 10 | 1089 | 3751 | 936 | 1066 | 1148 | <null> | 829 | 803 | 1209 | 867 | 1024 | 279 | 459 | 1622 | 1133 | 469 | <null> | 114 | <null> | 06:28:46 | 06:46:45 | 
| reads/fetches*100 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 03:46:46 | 04:04:45 | 
| reads/fetches*100 | 2 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 04:04:46 | 04:22:45 | 
| reads/fetches*100 | 3 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 04:22:46 | 04:40:45 | 
| reads/fetches*100 | 4 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 04:40:46 | 04:58:45 | 
| reads/fetches*100 | 5 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | <null> | 04:58:46 | 05:16:45 | 
| reads/fetches*100 | 6 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 05:16:46 | 05:34:45 | 
| reads/fetches*100 | 7 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | <null> | 0 | <null> | 05:34:46 | 05:52:45 | 
| reads/fetches*100 | 8 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | <null> | 05:52:46 | 06:10:45 | 
| reads/fetches*100 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 06:10:46 | 06:28:45 | 
| reads/fetches*100 | 10 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 06:28:46 | 06:46:45 | 
| writes/marks*100 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | <null> | 03:46:46 | 04:04:45 | 
| writes/marks*100 | 2 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | <null> | 04:04:46 | 04:22:45 | 
| writes/marks*100 | 3 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | <null> | 04:22:46 | 04:40:45 | 
| writes/marks*100 | 4 | 0 | 0 | 0 | <null> | 1 | <null> | 0 | 0 | 1 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | <null> | 04:40:46 | 04:58:45 | 
| writes/marks*100 | 5 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | <null> | 0 | 0 | <null> | 04:58:46 | 05:16:45 | 
| writes/marks*100 | 6 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | <null> | 05:16:46 | 05:34:45 | 
| writes/marks*100 | 7 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | <null> | <null> | 0 | <null> | 05:34:46 | 05:52:45 | 
| writes/marks*100 | 8 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 1 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | <null> | 05:52:46 | 06:10:45 | 
| writes/marks*100 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 06:10:46 | 06:28:45 | 
| writes/marks*100 | 10 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 06:28:46 | 06:46:45 | 
 
Done for 8760 ms, from  7:01:32.18 to  7:01:40.94.  
 
 
| 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 | 1964540 | 1814279 | 150261 | 7.64 | 0 | 7753 | 44 | 150261 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| doc_list_biud | 1964994 | 1814279 | 150715 | 7.66 | 0 | 6911 | 15 | 150715 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_add_invoice_to_stock | 20254 | 11715 | 8539 | 42.15 | 15 | 111072 | 10015 | 8539 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_cancel_adding_invoice | 4419 | 3477 | 942 | 21.31 | 0 | 70575 | 2768 | 942 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_cancel_client_order | 7101 | 6941 | 160 | 2.25 | 0 | 2667 | 223 | 160 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_cancel_customer_reserve | 343877 | 204158 | 139719 | 40.63 | 0 | 4805 | 61 | 139719 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_cancel_pay_from_customer | 2717 | 2706 | 11 | 0.40 | 0 | 2433 | 109 | 11 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_cancel_pay_to_supplier | 1661 | 1654 | 7 | 0.42 | 0 | 1638 | 126 | 7 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_cancel_supplier_invoice | 9745 | 7656 | 2089 | 21.43 | 0 | 7488 | 445 | 2089 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_cancel_supplier_order | 1643 | 567 | 1076 | 65.48 | 31 | 276620 | 17254 | 1076 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_cancel_write_off | 25684 | 16943 | 8741 | 34.03 | 0 | 4805 | 133 | 8741 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_client_order | 84405 | 84405 | 0 | 0.00 | 0 | 5444 | 427 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_customer_reserve | 642705 | 642705 | 0 | 0.00 | 0 | 5070 | 148 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_fill_shopping_cart | 128020 | 127718 | 302 | 0.23 | 0 | 3276 | 84 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_fill_shopping_cart_clo_res | 642705 | 642705 | 0 | 0.00 | 0 | 3416 | 12 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_get_clo_for_invoice | 11715 | 11715 | 0 | 0.00 | 0 | 4290 | 293 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_kill_cost_storno | 34098 | 24780 | 9318 | 27.32 | 0 | 2558 | 15 | 9318 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_kill_qstorno_ret_qs2qd | 722817 | 433482 | 289335 | 40.02 | 0 | 6895 | 22 | 289335 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_kill_qty_storno | 441306 | 290651 | 150655 | 34.13 | 0 | 6911 | 66 | 150655 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_lock_selected_doc | 83826 | 71881 | 11945 | 14.24 | 0 | 1419 | 6 | 11945 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_make_cost_storno | 102651 | 102651 | 0 | 0.00 | 0 | 7083 | 362 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_multiply_rows_for_pdistr | 102651 | 102651 | 0 | 0.00 | 0 | 2309 | 45 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_multiply_rows_for_qdistr | 84405 | 84405 | 0 | 0.00 | 0 | 3058 | 143 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_pay_from_customer | 28428 | 28428 | 0 | 0.00 | 0 | 7051 | 798 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_pay_to_supplier | 23314 | 23314 | 0 | 0.00 | 0 | 6490 | 515 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_payment_common | 51742 | 51742 | 0 | 0.00 | 0 | 2216 | 56 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_qd_handle_on_cancel_clo | 7098 | 6941 | 157 | 2.21 | 0 | 2652 | 94 | 157 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_qd_handle_on_invoice_upd_sts | 15954 | 15192 | 762 | 4.77 | 0 | 5319 | 308 | 762 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_qd_handle_on_reserve_upd_sts | 39194 | 39194 | 0 | 0.00 | 0 | 4524 | 42 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_reserve_write_off | 40305 | 39194 | 1111 | 2.75 | 0 | 7737 | 467 | 1111 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_supplier_invoice | 21791 | 21671 | 120 | 0.55 | 0 | 23135 | 2694 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| sp_supplier_order | 21824 | 21642 | 182 | 0.83 | 0 | 14898 | 1914 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| srv_find_qd_qs_mism | 1174714 | 1024414 | 150300 | 12.79 | 0 | 3385 | 24 | 150300 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| srv_make_invnt_saldo | 1704 | 1704 | 0 | 0.00 | 0 | 26114 | 2837 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| srv_make_money_saldo | 3283 | 3283 | 0 | 0.00 | 0 | 1420 | 59 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 2340 | 29905 | 15661 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_add_invoice_to_stock | 8539 | 8539 | 0 | 0.00 | 0 | 1903 | 81 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_cancel_adding_invoice | 749 | 749 | 0 | 0.00 | 0 | 1560 | 135 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_cancel_client_order | 160 | 160 | 0 | 0.00 | 0 | 842 | 73 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_cancel_customer_reserve | 67 | 67 | 0 | 0.00 | 0 | 764 | 54 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_cancel_pay_from_customer | 11 | 11 | 0 | 0.00 | 0 | 515 | 80 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_cancel_pay_to_supplier | 7 | 7 | 0 | 0.00 | 0 | 249 | 91 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_cancel_supplier_invoice | 694 | 694 | 0 | 0.00 | 0 | 952 | 78 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_cancel_supplier_order | 17214 | 17214 | 0 | 0.00 | 0 | 3884 | 106 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_cancel_write_off | 31 | 31 | 0 | 0.00 | 0 | 717 | 67 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_reserve_write_off | 1111 | 1111 | 0 | 0.00 | 0 | 1030 | 49 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_supplier_invoice | 120 | 120 | 0 | 0.00 | 0 | 827 | 74 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-abend:sp_supplier_order | 182 | 182 | 0 | 0.00 | 0 | 904 | 69 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_add_invoice_to_stock | 11715 | 11715 | 0 | 0.00 | 0 | 10842 | 573 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_cancel_adding_invoice | 1427 | 1427 | 0 | 0.00 | 0 | 7784 | 683 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_cancel_client_order | 6941 | 6941 | 0 | 0.00 | 0 | 1888 | 52 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_cancel_customer_reserve | 2704 | 2704 | 0 | 0.00 | 0 | 1450 | 54 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_cancel_pay_from_customer | 2706 | 2706 | 0 | 0.00 | 0 | 1358 | 39 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_cancel_pay_to_supplier | 1654 | 1654 | 0 | 0.00 | 0 | 1248 | 41 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_cancel_supplier_invoice | 962 | 962 | 0 | 0.00 | 0 | 1404 | 63 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_cancel_supplier_order | 567 | 567 | 0 | 0.00 | 0 | 30982 | 1282 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_cancel_write_off | 4011 | 4011 | 0 | 0.00 | 0 | 1622 | 55 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_client_order | 84405 | 84405 | 0 | 0.00 | 0 | 2106 | 65 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_customer_reserve | 3862 | 3862 | 0 | 0.00 | 0 | 1700 | 45 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_pay_from_customer | 28428 | 28428 | 0 | 0.00 | 0 | 1918 | 52 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_pay_to_supplier | 23314 | 23314 | 0 | 0.00 | 0 | 1513 | 48 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_reserve_write_off | 39194 | 39194 | 0 | 0.00 | 0 | 1981 | 57 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_supplier_invoice | 21671 | 21671 | 0 | 0.00 | 0 | 1607 | 58 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:sp_supplier_order | 21642 | 21642 | 0 | 0.00 | 0 | 1670 | 61 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:srv_make_invnt_saldo | 1704 | 1704 | 0 | 0.00 | 0 | 1591 | 16 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:srv_make_money_saldo | 3283 | 3283 | 0 | 0.00 | 0 | 998 | 26 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| t$perf-norm:srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 0 | 936 | 194 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_add_invoice_to_stock | 40508 | 23430 | 17078 | 42.15 | 0 | 1731 | 20 | 17078 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_all_customers | 126624 | 126624 | 0 | 0.00 | 0 | 811 | 5 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_all_suppliers | 88114 | 87510 | 604 | 0.68 | 0 | 1123 | 5 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_all_wares | 168810 | 168810 | 0 | 0.00 | 0 | 967 | 4 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_cancel_adding_invoice | 3352 | 2854 | 498 | 14.85 | 0 | 3525 | 138 | 498 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_cancel_client_order | 14202 | 13882 | 320 | 2.25 | 0 | 1576 | 6 | 320 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_cancel_customer_prepayment | 5434 | 5412 | 22 | 0.40 | 0 | 2090 | 7 | 22 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_cancel_customer_reserve | 5542 | 5408 | 134 | 2.41 | 0 | 640 | 7 | 134 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_cancel_payment_to_supplier | 3322 | 3308 | 14 | 0.42 | 0 | 593 | 7 | 14 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_cancel_supplier_invoice | 3312 | 1924 | 1388 | 41.90 | 0 | 796 | 23 | 1388 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_cancel_supplier_order | 3286 | 1134 | 2152 | 65.48 | 0 | 733 | 7 | 2152 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_cancel_write_off | 8084 | 8022 | 62 | 0.76 | 0 | 3104 | 97 | 62 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_max_id_clo_ord | 21824 | 21642 | 182 | 0.83 | 0 | 671 | 5 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_max_id_clo_res | 3862 | 3862 | 0 | 0.00 | 0 | 671 | 16 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_max_id_ord_sup | 21791 | 21671 | 120 | 0.55 | 0 | 1544 | 5 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_max_non_paid_invoice | 22872 | 22872 | 0 | 0.00 | 0 | 578 | 5 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_max_non_paid_realizn | 28428 | 28428 | 0 | 0.00 | 0 | 827 | 5 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_min_id_clo_ord | 21824 | 21642 | 182 | 0.83 | 0 | 827 | 6 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_min_id_clo_res | 3862 | 3862 | 0 | 0.00 | 0 | 624 | 8 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_min_id_ord_sup | 21791 | 21671 | 120 | 0.55 | 0 | 811 | 6 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_min_non_paid_invoice | 23314 | 23314 | 0 | 0.00 | 0 | 1326 | 8 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_min_non_paid_realizn | 28428 | 28428 | 0 | 0.00 | 0 | 1950 | 7 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_our_firm | 42186 | 42186 | 0 | 0.00 | 0 | 982 | 5 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| v_reserve_write_off | 80610 | 78388 | 2222 | 2.75 | 0 | 1825 | 7 | 2222 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| x_lock_depdocs_on_canc_invoice | 19111 | 10171 | 8940 | 46.77 | 0 | 1857 | 29 | 8940 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| x_lock_depdocs_on_canc_sup_ord | 1641 | 567 | 1074 | 65.44 | 0 | 983 | 51 | 1074 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| x_make_qstorno_1000_1200 | 21824 | 21642 | 182 | 0.83 | 0 | 14570 | 1725 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| x_make_qstorno_1200_2000 | 21791 | 21671 | 120 | 0.55 | 0 | 22261 | 2502 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| x_make_qstorno_2100_3300 | 642705 | 642705 | 0 | 0.00 | 0 | 4946 | 120 | 0 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
 
Done for 352220 ms, from  7:07:12.97 to  7:13:05.19.  
 
 
 
| FB_MNEMONA | CNT | UNIT | FB_GDSCODE | DTS_BEG | DTS_END | 
| deadlock | 98 | sp_kill_cost_storno | 335544336 | 2017-10-14 03:47 | 2017-10-14 06:42 | 
| deadlock | 84 | sp_kill_qstorno_ret_qs2qd | 335544336 | 2017-10-14 03:47 | 2017-10-14 06:46 | 
| deadlock | 10458 | sp_lock_selected_doc | 335544336 | 2017-10-14 03:46 | 2017-10-14 06:46 | 
| deadlock | 157 | sp_qd_handle_on_cancel_clo | 335544336 | 2017-10-14 03:48 | 2017-10-14 06:45 | 
| deadlock | 163 | sp_qd_handle_on_invoice_upd_sts | 335544336 | 2017-10-14 03:47 | 2017-10-14 06:45 | 
| deadlock | 691 | x_lock_depdocs_on_canc_invoice | 335544336 | 2017-10-14 03:47 | 2017-10-14 06:45 | 
| deadlock | 292 | x_lock_depdocs_on_canc_sup_ord | 335544336 | 2017-10-14 03:48 | 2017-10-14 06:45 | 
| user_exc | 182 | x_make_qstorno_1000_1200 | 335544517 | 2017-10-14 03:47 | 2017-10-14 06:46 | 
| user_exc | 120 | x_make_qstorno_1200_2000 | 335544517 | 2017-10-14 03:47 | 2017-10-14 06:39 | 
 
Done for 10550 ms, from  7:13:15.44 to  7:13:25.99.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          448510
 
MON$OLDEST_ACTIVE               448511
 
MON$OLDEST_SNAPSHOT             448511
 
MON$NEXT_TRANSACTION            448511
 
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                       836288
 
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.32806 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32806 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32806 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32806 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		448681 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	448512 
 
Oldest active		448513 
 
Oldest snapshot		448513 
 
Next transaction	448514 
 
Sequence number		0 
 
Next attachment ID	9560 
 
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.07, total records: 2205311 
 
Average version length: 47.70, total versions: 3624, 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: 15, data page slots: 23880 
 
Data pages: 23880, average fill: 73% 
 
Primary pages: 23880, secondary pages: 0, swept pages: 15041 
 
Empty pages: 5, full pages: 20758 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 5 
 
40 - 59% = 70 
 
60 - 79% = 23793 
 
80 - 99% = 7 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10764, nodes: 2205311 
 
Average node length: 19.33, total dup: 0, max dup: 0 
 
Average key length: 16.37, compression ratio: 1.65 
 
Average prefix length: 13.62, average data length: 13.38 
 
Clustering factor: 440024, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 752 
 
20 - 39% = 2523 
 
40 - 59% = 4797 
 
60 - 79% = 1270 
 
80 - 99% = 1422 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7869, nodes: 2205311 
 
Average node length: 11.64, total dup: 0, max dup: 0 
 
Average key length: 8.68, compression ratio: 1.04 
 
Average prefix length: 3.32, average data length: 5.68 
 
Clustering factor: 420897, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 3611 
 
40 - 59% = 4162 
 
60 - 79% = 90 
 
80 - 99% = 5 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 175290, depth: 3, leaf buckets: 3818, nodes: 2205311 
 
Average node length: 6.83, total dup: 1602976, max dup: 49 
 
Average key length: 3.87, compression ratio: 2.32 
 
Average prefix length: 7.40, average data length: 1.60 
 
Clustering factor: 401216, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 144 
 
20 - 39% = 1163 
 
40 - 59% = 1643 
 
60 - 79% = 330 
 
80 - 99% = 538 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.40, total records: 669596 
 
Average version length: 35.41, total versions: 1653, max versions: 3 
 
Average fragment length: 16.22, total fragments: 9, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 6, data page slots: 8480 
 
Data pages: 8480, average fill: 75% 
 
Primary pages: 8475, secondary pages: 5, swept pages: 7815 
 
Empty pages: 0, full pages: 7764 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 7 
 
40 - 59% = 33 
 
60 - 79% = 8416 
 
80 - 99% = 17 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 248067, depth: 3, leaf buckets: 2468, nodes: 669596 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.18, average data length: 5.82 
 
Clustering factor: 153262, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 1345 
 
40 - 59% = 1080 
 
60 - 79% = 35 
 
80 - 99% = 5 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 700, nodes: 669596 
 
Average node length: 4.88, total dup: 669546, max dup: 46045 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 307336, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 585 
 
60 - 79% = 92 
 
80 - 99% = 23 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 325560, depth: 3, leaf buckets: 1977, nodes: 669596 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.18, average data length: 5.82 
 
Clustering factor: 153262, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 183 
 
20 - 39% = 504 
 
40 - 59% = 708 
 
60 - 79% = 287 
 
80 - 99% = 295 
 
 
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: 63.98, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 17.12, total fragments: 378, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.63 
 
Pointer pages: 1, data page slots: 1272 
 
Data pages: 20, average fill: 33% 
 
Primary pages: 8, secondary pages: 12, swept pages: 4 
 
Empty pages: 5, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 4 
 
40 - 59% = 2 
 
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: 24.16, total records: 3576 
 
Average version length: 71.29, total versions: 2360, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 3.97 
 
Pointer pages: 2, data page slots: 1224 
 
Data pages: 312, average fill: 16% 
 
Primary pages: 310, secondary pages: 2, swept pages: 136 
 
Empty pages: 119, full pages: 2 
 
Fill distribution: 
 
0 - 19% = 202 
 
20 - 39% = 68 
 
40 - 59% = 35 
 
60 - 79% = 7 
 
80 - 99% = 0 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 21, nodes: 3576 
 
Average node length: 15.58, total dup: 78, max dup: 1 
 
Average key length: 13.42, compression ratio: 2.01 
 
Average prefix length: 16.55, average data length: 10.45 
 
Clustering factor: 2838, ratio: 0.79 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 15 
 
40 - 59% = 5 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 14.98, 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.14 
 
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: 43.90, total records: 40 
 
Average version length: 42.00, total versions: 1, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.46 
 
Pointer pages: 1, data page slots: 48 
 
Data pages: 32, average fill: 2% 
 
Primary pages: 31, secondary pages: 1, swept pages: 16 
 
Empty pages: 24, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 32 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 366727, depth: 2, leaf buckets: 1, nodes: 40 
 
Average node length: 13.93, total dup: 16, max dup: 5 
 
Average key length: 12.43, compression ratio: 1.53 
 
Average prefix length: 9.15, average data length: 9.85 
 
Clustering factor: 29, ratio: 0.72 
 
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.26, total records: 242585 
 
Average version length: 31.73, total versions: 2939, max versions: 8 
 
Average fragment length: 34.00, total fragments: 1, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.51 
 
Pointer pages: 2, data page slots: 2840 
 
Data pages: 2840, average fill: 64% 
 
Primary pages: 2826, secondary pages: 14, swept pages: 2126 
 
Empty pages: 18, full pages: 397 
 
Fill distribution: 
 
0 - 19% = 55 
 
20 - 39% = 78 
 
40 - 59% = 428 
 
60 - 79% = 2277 
 
80 - 99% = 2 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 236, nodes: 242585 
 
Average node length: 4.60, total dup: 242536, max dup: 13301 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 40434, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 27 
 
40 - 59% = 114 
 
60 - 79% = 73 
 
80 - 99% = 22 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 274, nodes: 242585 
 
Average node length: 5.54, total dup: 218816, max dup: 54 
 
Average key length: 2.95, compression ratio: 7.46 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 52713, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 18 
 
40 - 59% = 115 
 
60 - 79% = 96 
 
80 - 99% = 41 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 277, nodes: 242585 
 
Average node length: 5.54, total dup: 218816, max dup: 54 
 
Average key length: 2.95, compression ratio: 7.46 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 52757, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 16 
 
40 - 59% = 132 
 
60 - 79% = 95 
 
80 - 99% = 34 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 264, nodes: 242585 
 
Average node length: 5.33, total dup: 218816, max dup: 54 
 
Average key length: 2.74, compression ratio: 3.29 
 
Average prefix length: 8.36, average data length: 0.64 
 
Clustering factor: 52750, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 20 
 
40 - 59% = 110 
 
60 - 79% = 95 
 
80 - 99% = 38 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.97, total records: 281976 
 
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.14 
 
Pointer pages: 2, data page slots: 2416 
 
Data pages: 2416, average fill: 64% 
 
Primary pages: 2416, secondary pages: 0, swept pages: 0 
 
Empty pages: 6, full pages: 2409 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 2409 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 252525, depth: 2, leaf buckets: 228, nodes: 281976 
 
Average node length: 4.55, total dup: 281795, max dup: 2245 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.59, average data length: 0.00 
 
Clustering factor: 50477, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 99 
 
60 - 79% = 55 
 
80 - 99% = 74 
 
 
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.66, total records: 12044977 
 
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.18 
 
Pointer pages: 176, data page slots: 285720 
 
Data pages: 285720, average fill: 87% 
 
Primary pages: 285720, secondary pages: 0, swept pages: 3 
 
Empty pages: 7, full pages: 285712 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 285712 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 13564, nodes: 12044977 
 
Average node length: 5.67, total dup: 11187068, max dup: 152 
 
Average key length: 2.17, compression ratio: 3.68 
 
Average prefix length: 7.87, average data length: 0.13 
 
Clustering factor: 4278745, ratio: 0.36 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 0 
 
40 - 59% = 7463 
 
60 - 79% = 4085 
 
80 - 99% = 2004 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 11997, nodes: 12044977 
 
Average node length: 4.60, total dup: 12044973, max dup: 10933078 
 
Average key length: 1.09, compression ratio: 0.42 
 
Average prefix length: 0.46, average data length: 0.00 
 
Clustering factor: 359349, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 11993 
 
60 - 79% = 1 
 
80 - 99% = 2 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 14677, nodes: 12044977 
 
Average node length: 5.74, total dup: 11667547, max dup: 25572 
 
Average key length: 2.23, compression ratio: 4.03 
 
Average prefix length: 8.80, average data length: 0.20 
 
Clustering factor: 969533, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 2 
 
40 - 59% = 10847 
 
60 - 79% = 2128 
 
80 - 99% = 1696 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 14680, nodes: 12044977 
 
Average node length: 5.57, total dup: 12019154, max dup: 1599179 
 
Average key length: 2.07, compression ratio: 18.29 
 
Average prefix length: 37.76, average data length: 0.07 
 
Clustering factor: 6695690, ratio: 0.56 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 0 
 
40 - 59% = 12646 
 
60 - 79% = 602 
 
80 - 99% = 1414 
 
 
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.07, total records: 450958 
 
Average version length: 55.66, total versions: 1147, 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: 5368 
 
Data pages: 5368, average fill: 74% 
 
Primary pages: 5368, secondary pages: 0, swept pages: 3850 
 
Empty pages: 3, full pages: 4937 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 4 
 
40 - 59% = 25 
 
60 - 79% = 5332 
 
80 - 99% = 4 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 690811, depth: 3, leaf buckets: 579, nodes: 450958 
 
Average node length: 5.92, total dup: 380819, max dup: 1019 
 
Average key length: 3.13, compression ratio: 2.88 
 
Average prefix length: 8.03, average data length: 0.97 
 
Clustering factor: 58180, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 58 
 
40 - 59% = 307 
 
60 - 79% = 150 
 
80 - 99% = 59 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 487, nodes: 450958 
 
Average node length: 5.62, total dup: 400842, max dup: 123 
 
Average key length: 2.83, compression ratio: 3.18 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 110226, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 9 
 
40 - 59% = 212 
 
60 - 79% = 181 
 
80 - 99% = 85 
 
 
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.68, total records: 2712 
 
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.52 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 62% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 7, full pages: 32 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 32 
 
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: 43.62, total records: 5746 
 
Average version length: 72.18, total versions: 2271, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 3.12 
 
Pointer pages: 2, data page slots: 1696 
 
Data pages: 544, average fill: 15% 
 
Primary pages: 543, secondary pages: 1, swept pages: 271 
 
Empty pages: 237, full pages: 21 
 
Fill distribution: 
 
0 - 19% = 394 
 
20 - 39% = 94 
 
40 - 59% = 27 
 
60 - 79% = 25 
 
80 - 99% = 4 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 12, nodes: 5746 
 
Average node length: 6.95, total dup: 4944, max dup: 14 
 
Average key length: 4.66, compression ratio: 7.93 
 
Average prefix length: 34.47, average data length: 2.53 
 
Clustering factor: 949, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 4 
 
40 - 59% = 6 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.32, total records: 1142609 
 
Average version length: 71.69, total versions: 13571, 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: 11, data page slots: 17064 
 
Data pages: 17064, average fill: 74% 
 
Primary pages: 17064, secondary pages: 0, swept pages: 10261 
 
Empty pages: 19, full pages: 12896 
 
Fill distribution: 
 
0 - 19% = 62 
 
20 - 39% = 99 
 
40 - 59% = 676 
 
60 - 79% = 16149 
 
80 - 99% = 78 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 493925, depth: 3, leaf buckets: 1305, nodes: 1142609 
 
Average node length: 5.13, total dup: 1112690, max dup: 124 
 
Average key length: 2.19, compression ratio: 4.11 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 127060, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 100 
 
40 - 59% = 951 
 
60 - 79% = 46 
 
80 - 99% = 195 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 237611, depth: 3, leaf buckets: 1640, nodes: 1142609 
 
Average node length: 6.25, total dup: 997810, max dup: 17 
 
Average key length: 3.32, compression ratio: 11.16 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 218186, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 19 
 
20 - 39% = 165 
 
40 - 59% = 1178 
 
60 - 79% = 163 
 
80 - 99% = 115 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 41.61, total records: 49931 
 
Average version length: 71.86, total versions: 21123, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 3.27 
 
Pointer pages: 3, data page slots: 3352 
 
Data pages: 2400, average fill: 27% 
 
Primary pages: 2399, secondary pages: 1, swept pages: 901 
 
Empty pages: 616, full pages: 158 
 
Fill distribution: 
 
0 - 19% = 1165 
 
20 - 39% = 535 
 
40 - 59% = 378 
 
60 - 79% = 287 
 
80 - 99% = 35 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 97, nodes: 49931 
 
Average node length: 6.44, total dup: 43651, max dup: 73 
 
Average key length: 3.54, compression ratio: 10.45 
 
Average prefix length: 35.58, average data length: 1.42 
 
Clustering factor: 5870, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 47 
 
40 - 59% = 43 
 
60 - 79% = 5 
 
80 - 99% = 2 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.78, total records: 1738087 
 
Average version length: 71.85, total versions: 57896, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.95 
 
Pointer pages: 17, data page slots: 27040 
 
Data pages: 27032, average fill: 71% 
 
Primary pages: 27032, secondary pages: 0, swept pages: 15052 
 
Empty pages: 175, full pages: 18806 
 
Fill distribution: 
 
0 - 19% = 406 
 
20 - 39% = 800 
 
40 - 59% = 2551 
 
60 - 79% = 22279 
 
80 - 99% = 996 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 119871, depth: 3, leaf buckets: 2938, nodes: 1738087 
 
Average node length: 5.65, total dup: 1628801, max dup: 81 
 
Average key length: 2.69, compression ratio: 13.76 
 
Average prefix length: 36.37, average data length: 0.63 
 
Clustering factor: 230080, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 1523 
 
40 - 59% = 1106 
 
60 - 79% = 187 
 
80 - 99% = 109 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 4.44, total records: 9058 
 
Average version length: 71.81, total versions: 8484, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 30.60 
 
Pointer pages: 4, data page slots: 1896 
 
Data pages: 1144, average fill: 12% 
 
Primary pages: 1143, secondary pages: 1, swept pages: 528 
 
Empty pages: 682, full pages: 23 
 
Fill distribution: 
 
0 - 19% = 876 
 
20 - 39% = 143 
 
40 - 59% = 79 
 
60 - 79% = 37 
 
80 - 99% = 9 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 17, nodes: 9058 
 
Average node length: 6.34, total dup: 7963, max dup: 63 
 
Average key length: 4.07, compression ratio: 9.09 
 
Average prefix length: 35.05, average data length: 1.95 
 
Clustering factor: 1121, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 7 
 
40 - 59% = 7 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.02, total records: 2789935 
 
Average version length: 71.12, total versions: 16342, 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: 25, data page slots: 39848 
 
Data pages: 39848, average fill: 76% 
 
Primary pages: 39848, secondary pages: 0, swept pages: 30230 
 
Empty pages: 19, full pages: 35639 
 
Fill distribution: 
 
0 - 19% = 39 
 
20 - 39% = 101 
 
40 - 59% = 623 
 
60 - 79% = 38627 
 
80 - 99% = 458 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5643, nodes: 2789935 
 
Average node length: 6.87, total dup: 2258348, max dup: 14 
 
Average key length: 3.90, compression ratio: 9.49 
 
Average prefix length: 35.29, average data length: 1.71 
 
Clustering factor: 526824, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 2753 
 
40 - 59% = 2435 
 
60 - 79% = 276 
 
80 - 99% = 172 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.73, total records: 4839902 
 
Average version length: 84.38, total versions: 1752, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.62 
 
Pointer pages: 46, data page slots: 74464 
 
Data pages: 74464, average fill: 80% 
 
Primary pages: 74464, secondary pages: 0, swept pages: 27554 
 
Empty pages: 9, full pages: 73776 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 8 
 
40 - 59% = 49 
 
60 - 79% = 21601 
 
80 - 99% = 52794 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4960, nodes: 4839902 
 
Average node length: 5.16, total dup: 4729828, max dup: 128 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 773407, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 103 
 
40 - 59% = 2220 
 
60 - 79% = 2030 
 
80 - 99% = 590 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 5266, nodes: 4839902 
 
Average node length: 5.70, total dup: 4333563, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 253115, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 44 
 
20 - 39% = 179 
 
40 - 59% = 2901 
 
60 - 79% = 350 
 
80 - 99% = 1792 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5527, nodes: 4839902 
 
Average node length: 5.81, total dup: 4234602, max dup: 29 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 830185, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 29 
 
20 - 39% = 120 
 
40 - 59% = 2460 
 
60 - 79% = 2084 
 
80 - 99% = 834 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.95, total records: 2516646 
 
Average version length: 84.14, total versions: 10842, 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: 25, data page slots: 39608 
 
Data pages: 39608, average fill: 78% 
 
Primary pages: 39608, secondary pages: 0, swept pages: 29795 
 
Empty pages: 38, full pages: 36813 
 
Fill distribution: 
 
0 - 19% = 83 
 
20 - 39% = 116 
 
40 - 59% = 559 
 
60 - 79% = 17151 
 
80 - 99% = 21699 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2710, nodes: 2516646 
 
Average node length: 5.15, total dup: 2457951, max dup: 167 
 
Average key length: 2.18, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 395823, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 57 
 
40 - 59% = 1610 
 
60 - 79% = 784 
 
80 - 99% = 257 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4273, nodes: 2516646 
 
Average node length: 6.23, total dup: 2061585, max dup: 14 
 
Average key length: 3.26, compression ratio: 2.76 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 244847, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 114 
 
20 - 39% = 1683 
 
40 - 59% = 1687 
 
60 - 79% = 529 
 
80 - 99% = 260 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 3088, nodes: 2516646 
 
Average node length: 5.81, total dup: 2201516, max dup: 32 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 475827, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 72 
 
40 - 59% = 1863 
 
60 - 79% = 835 
 
80 - 99% = 297 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.66, total records: 5123503 
 
Average version length: 85.51, total versions: 12861, 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: 50, data page slots: 80016 
 
Data pages: 80016, average fill: 79% 
 
Primary pages: 80016, secondary pages: 0, swept pages: 23858 
 
Empty pages: 209, full pages: 75855 
 
Fill distribution: 
 
0 - 19% = 390 
 
20 - 39% = 519 
 
40 - 59% = 1228 
 
60 - 79% = 16813 
 
80 - 99% = 61066 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5449, nodes: 5123503 
 
Average node length: 5.04, total dup: 5093481, max dup: 743 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 749925, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 273 
 
40 - 59% = 3099 
 
60 - 79% = 1502 
 
80 - 99% = 567 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 6233, nodes: 5123503 
 
Average node length: 5.53, total dup: 4716515, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.54 
 
Average prefix length: 8.53, average data length: 0.47 
 
Clustering factor: 270393, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 100 
 
20 - 39% = 1542 
 
40 - 59% = 2619 
 
60 - 79% = 652 
 
80 - 99% = 1320 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 6103, nodes: 5123503 
 
Average node length: 5.68, total dup: 4597056, max dup: 72 
 
Average key length: 2.70, compression ratio: 3.34 
 
Average prefix length: 8.41, average data length: 0.59 
 
Clustering factor: 831984, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 266 
 
40 - 59% = 3492 
 
60 - 79% = 1690 
 
80 - 99% = 651 
 
 
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.27, total records: 3441116 
 
Average version length: 84.49, total versions: 11239, 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: 34, data page slots: 54112 
 
Data pages: 54112, average fill: 78% 
 
Primary pages: 54112, secondary pages: 0, swept pages: 40172 
 
Empty pages: 52, full pages: 50438 
 
Fill distribution: 
 
0 - 19% = 113 
 
20 - 39% = 172 
 
40 - 59% = 685 
 
60 - 79% = 21248 
 
80 - 99% = 31894 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3731, nodes: 3441116 
 
Average node length: 5.03, total dup: 3424375, max dup: 1281 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 715761, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 342 
 
40 - 59% = 2045 
 
60 - 79% = 930 
 
80 - 99% = 392 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5880, nodes: 3441116 
 
Average node length: 6.25, total dup: 2814954, max dup: 14 
 
Average key length: 3.27, compression ratio: 2.75 
 
Average prefix length: 7.91, average data length: 1.09 
 
Clustering factor: 366584, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 218 
 
20 - 39% = 2275 
 
40 - 59% = 2280 
 
60 - 79% = 716 
 
80 - 99% = 391 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 4089, nodes: 3441116 
 
Average node length: 5.59, total dup: 3138877, max dup: 78 
 
Average key length: 2.61, compression ratio: 3.45 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 757945, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 357 
 
40 - 59% = 2138 
 
60 - 79% = 1089 
 
80 - 99% = 490 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.36, total records: 657913 
 
Average version length: 69.63, total versions: 1629, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.96 
 
Pointer pages: 6, data page slots: 9080 
 
Data pages: 9080, average fill: 77% 
 
Primary pages: 9080, secondary pages: 0, swept pages: 6923 
 
Empty pages: 1, full pages: 8639 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 23 
 
40 - 59% = 86 
 
60 - 79% = 8916 
 
80 - 99% = 48 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 178139, depth: 3, leaf buckets: 781, nodes: 657913 
 
Average node length: 5.32, total dup: 619857, max dup: 119 
 
Average key length: 2.44, compression ratio: 3.69 
 
Average prefix length: 8.62, average data length: 0.38 
 
Clustering factor: 56048, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 170 
 
40 - 59% = 317 
 
60 - 79% = 202 
 
80 - 99% = 90 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 877, nodes: 657913 
 
Average node length: 5.93, total dup: 561991, max dup: 21 
 
Average key length: 3.05, compression ratio: 2.95 
 
Average prefix length: 8.10, average data length: 0.90 
 
Clustering factor: 60261, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 204 
 
40 - 59% = 353 
 
60 - 79% = 216 
 
80 - 99% = 102 
 
 
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 72680 ms, from  7:13:26.36 to  7:14:39.04. 
 
 
 
| TABLE_NAME | TOTAL_RECS | TOTAL_VERS | VERS_PERCENT | 
| AGENTS | 50 | 0 | 0.0000 | 
| BUSINESS_OPS | 19 | 0 | 0.0000 | 
| DOC_DATA | 2205311 | 3624 | 0.1643 | 
| DOC_LIST | 669596 | 1653 | 0.2468 | 
| DOC_STATES | 4 | 0 | 0.0000 | 
| FB_ERRORS | 758 | 0 | 0.0000 | 
| INVNT_SALDO | 400 | 0 | 0.0000 | 
| INVNT_TURNOVER_LOG | 3576 | 2360 | 65.9955 | 
| MONEY_SALDO | 49 | 0 | 0.0000 | 
| MONEY_TURNOVER_LOG | 40 | 1 | 2.5000 | 
| OPTYPES | 9 | 0 | 0.0000 | 
| PDISTR | 242585 | 2939 | 1.2115 | 
| PERF_ESTIMATED | 281976 | 0 | 0.0000 | 
| PERF_LOG | 12044977 | 0 | 0.0000 | 
| PSTORNED | 450958 | 1147 | 0.2543 | 
| 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 | 2712 | 0 | 0.0000 | 
| WARES | 400 | 0 | 0.0000 | 
| WARE_GROUPS | 8 | 0 | 0.0000 | 
| XQD_1000_1200 | 5746 | 2271 | 39.5231 | 
| XQD_1000_3300 | 1142609 | 13571 | 1.1877 | 
| XQD_1200_2000 | 49931 | 21123 | 42.3043 | 
| XQD_2000_3300 | 1738087 | 57896 | 3.3310 | 
| XQD_2100_3300 | 9058 | 8484 | 93.6630 | 
| XQD_3300_3400 | 2789935 | 16342 | 0.5857 | 
| XQS_1000_1200 | 4839902 | 1752 | 0.0361 | 
| XQS_1000_3300 | 2516646 | 10842 | 0.4308 | 
| XQS_1200_2000 | 5123503 | 12861 | 0.2510 | 
| XQS_2100_3300 | 3441116 | 11239 | 0.3266 | 
| XQS_3300_3400 | 657913 | 1629 | 0.2476 | 
| Z_USED_VIEWS | 29 | 0 | 0.0000 | 
 
Done for 2080 ms, from  7:14:51.19 to  7:14:53.27.  
07:14:53.35 Validation started 
 
 
07:14:53.38 Relation 140 (DOC_LIST) 
 
07:14:53.39   process pointer page    0 of    6 
 
07:14:53.50   process pointer page    1 of    6 
 
07:14:53.60   process pointer page    2 of    6 
 
07:14:53.66   process pointer page    3 of    6 
 
07:14:53.69   process pointer page    4 of    6 
 
07:14:53.74   process pointer page    5 of    6 
 
07:14:53.74 Index 1 (PK_DOC_LIST) 
 
07:14:53.97 Index 2 (DOC_LIST_ID_DESC) 
 
07:14:54.27 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:14:54.55 Relation 140 (DOC_LIST) is ok 
 
 
07:14:54.55 Relation 141 (DOC_DATA) 
 
07:14:54.55   process pointer page    0 of   15 
 
07:14:54.64   process pointer page    1 of   15 
 
07:14:54.73   process pointer page    2 of   15 
 
07:14:54.83   process pointer page    3 of   15 
 
07:14:54.89   process pointer page    4 of   15 
 
07:14:54.92   process pointer page    5 of   15 
 
07:14:55.01   process pointer page    6 of   15 
 
07:14:55.09   process pointer page    7 of   15 
 
07:14:55.19   process pointer page    8 of   15 
 
07:14:55.28   process pointer page    9 of   15 
 
07:14:55.34   process pointer page   10 of   15 
 
07:14:55.39   process pointer page   11 of   15 
 
07:14:55.45   process pointer page   12 of   15 
 
07:14:55.48   process pointer page   13 of   15 
 
07:14:55.53   process pointer page   14 of   15 
 
07:14:55.59 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:14:56.56 Index 3 (DOC_DATA_ID_DESC) 
 
07:14:57.21 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:14:57.65 Relation 141 (DOC_DATA) is ok 
 
 
07:14:57.65 Relation 147 (INVNT_SALDO) 
 
07:14:57.65   process pointer page    0 of    1 
 
07:14:57.65 Index 1 (PK_INVNT_SALDO) 
 
07:14:57.65 Relation 147 (INVNT_SALDO) is ok 
 
 
07:14:57.65 Relation 150 (PDISTR) 
 
07:14:57.65   process pointer page    0 of    2 
 
07:14:57.74   process pointer page    1 of    2 
 
07:14:57.82 Index 2 (PDISTR_SND_ID) 
 
07:14:57.90 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:14:57.98 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:14:58.06 Index 5 (PDISTR_AGENT_ID) 
 
07:14:58.13 Relation 150 (PDISTR) is ok 
 
 
07:14:58.13 Relation 151 (PSTORNED) 
 
07:14:58.13   process pointer page    0 of    4 
 
07:14:58.23   process pointer page    1 of    4 
 
07:14:58.32   process pointer page    2 of    4 
 
07:14:58.37   process pointer page    3 of    4 
 
07:14:58.37 Index 2 (PSTORNED_SND_ID) 
 
07:14:58.46 Index 3 (PSTORNED_RCV_ID) 
 
07:14:58.59 Relation 151 (PSTORNED) is ok 
 
 
07:14:58.59 Relation 156 (SEMAPHORES) 
 
07:14:58.59   process pointer page    0 of    1 
 
07:14:58.59 Index 1 (PK_SEMAPHORES) 
 
07:14:58.59 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:14:58.59 Relation 156 (SEMAPHORES) is ok 
 
 
07:14:58.59 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:14:58.59   process pointer page    0 of    2 
 
07:14:58.60   process pointer page    1 of    2 
 
07:14:58.60 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:14:58.60 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:14:58.60 Relation 160 (PERF_ESTIMATED) 
 
07:14:58.60   process pointer page    0 of    2 
 
07:14:58.70   process pointer page    1 of    2 
 
07:14:58.74 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:14:58.82 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:14:58.82 Relation 161 (PERF_ISQL_STAT) 
 
07:14:58.82   process pointer page    0 of    1 
 
07:14:58.82 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:14:58.82 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:14:58.82 Relation 162 (TRACE_STAT) 
 
07:14:58.82   process pointer page    0 of    1 
 
07:14:58.82 Relation 162 (TRACE_STAT) is ok 
 
 
07:14:58.82 Relation 163 (PERF_LOG) 
 
07:14:58.82   process pointer page    0 of  176 
 
07:14:58.88   process pointer page    1 of  176 
 
07:14:58.91   process pointer page    2 of  176 
 
07:14:58.95   process pointer page    3 of  176 
 
07:14:58.98   process pointer page    4 of  176 
 
07:14:59.01   process pointer page    5 of  176 
 
07:14:59.09   process pointer page    6 of  176 
 
07:14:59.15   process pointer page    7 of  176 
 
07:14:59.18   process pointer page    8 of  176 
 
07:14:59.26   process pointer page    9 of  176 
 
07:14:59.35   process pointer page   10 of  176 
 
07:14:59.43   process pointer page   11 of  176 
 
07:14:59.51   process pointer page   12 of  176 
 
07:14:59.60   process pointer page   13 of  176 
 
07:14:59.68   process pointer page   14 of  176 
 
07:14:59.76   process pointer page   15 of  176 
 
07:14:59.84   process pointer page   16 of  176 
 
07:14:59.91   process pointer page   17 of  176 
 
07:14:59.99   process pointer page   18 of  176 
 
07:15:00.08   process pointer page   19 of  176 
 
07:15:00.16   process pointer page   20 of  176 
 
07:15:00.24   process pointer page   21 of  176 
 
07:15:00.30   process pointer page   22 of  176 
 
07:15:00.33   process pointer page   23 of  176 
 
07:15:00.41   process pointer page   24 of  176 
 
07:15:00.49   process pointer page   25 of  176 
 
07:15:00.57   process pointer page   26 of  176 
 
07:15:00.65   process pointer page   27 of  176 
 
07:15:00.69   process pointer page   28 of  176 
 
07:15:00.72   process pointer page   29 of  176 
 
07:15:00.76   process pointer page   30 of  176 
 
07:15:00.80   process pointer page   31 of  176 
 
07:15:00.88   process pointer page   32 of  176 
 
07:15:00.96   process pointer page   33 of  176 
 
07:15:01.04   process pointer page   34 of  176 
 
07:15:01.11   process pointer page   35 of  176 
 
07:15:01.19   process pointer page   36 of  176 
 
07:15:01.24   process pointer page   37 of  176 
 
07:15:01.27   process pointer page   38 of  176 
 
07:15:01.30   process pointer page   39 of  176 
 
07:15:01.33   process pointer page   40 of  176 
 
07:15:01.36   process pointer page   41 of  176 
 
07:15:01.43   process pointer page   42 of  176 
 
07:15:01.49   process pointer page   43 of  176 
 
07:15:01.52   process pointer page   44 of  176 
 
07:15:01.55   process pointer page   45 of  176 
 
07:15:01.60   process pointer page   46 of  176 
 
07:15:01.68   process pointer page   47 of  176 
 
07:15:01.75   process pointer page   48 of  176 
 
07:15:01.83   process pointer page   49 of  176 
 
07:15:01.91   process pointer page   50 of  176 
 
07:15:01.99   process pointer page   51 of  176 
 
07:15:02.07   process pointer page   52 of  176 
 
07:15:02.14   process pointer page   53 of  176 
 
07:15:02.22   process pointer page   54 of  176 
 
07:15:02.30   process pointer page   55 of  176 
 
07:15:02.38   process pointer page   56 of  176 
 
07:15:02.46   process pointer page   57 of  176 
 
07:15:02.53   process pointer page   58 of  176 
 
07:15:02.58   process pointer page   59 of  176 
 
07:15:02.61   process pointer page   60 of  176 
 
07:15:02.69   process pointer page   61 of  176 
 
07:15:02.75   process pointer page   62 of  176 
 
07:15:02.78   process pointer page   63 of  176 
 
07:15:02.86   process pointer page   64 of  176 
 
07:15:02.94   process pointer page   65 of  176 
 
07:15:03.02   process pointer page   66 of  176 
 
07:15:03.10   process pointer page   67 of  176 
 
07:15:03.17   process pointer page   68 of  176 
 
07:15:03.25   process pointer page   69 of  176 
 
07:15:03.33   process pointer page   70 of  176 
 
07:15:03.41   process pointer page   71 of  176 
 
07:15:03.49   process pointer page   72 of  176 
 
07:15:03.56   process pointer page   73 of  176 
 
07:15:03.63   process pointer page   74 of  176 
 
07:15:03.66   process pointer page   75 of  176 
 
07:15:03.69   process pointer page   76 of  176 
 
07:15:03.72   process pointer page   77 of  176 
 
07:15:03.75   process pointer page   78 of  176 
 
07:15:03.80   process pointer page   79 of  176 
 
07:15:03.88   process pointer page   80 of  176 
 
07:15:03.97   process pointer page   81 of  176 
 
07:15:04.05   process pointer page   82 of  176 
 
07:15:04.09   process pointer page   83 of  176 
 
07:15:04.13   process pointer page   84 of  176 
 
07:15:04.20   process pointer page   85 of  176 
 
07:15:04.28   process pointer page   86 of  176 
 
07:15:04.36   process pointer page   87 of  176 
 
07:15:04.44   process pointer page   88 of  176 
 
07:15:04.52   process pointer page   89 of  176 
 
07:15:04.59   process pointer page   90 of  176 
 
07:15:04.67   process pointer page   91 of  176 
 
07:15:04.75   process pointer page   92 of  176 
 
07:15:04.83   process pointer page   93 of  176 
 
07:15:04.91   process pointer page   94 of  176 
 
07:15:04.98   process pointer page   95 of  176 
 
07:15:05.06   process pointer page   96 of  176 
 
07:15:05.15   process pointer page   97 of  176 
 
07:15:05.20   process pointer page   98 of  176 
 
07:15:05.23   process pointer page   99 of  176 
 
07:15:05.26   process pointer page  100 of  176 
 
07:15:05.31   process pointer page  101 of  176 
 
07:15:05.40   process pointer page  102 of  176 
 
07:15:05.48   process pointer page  103 of  176 
 
07:15:05.56   process pointer page  104 of  176 
 
07:15:05.64   process pointer page  105 of  176 
 
07:15:05.72   process pointer page  106 of  176 
 
07:15:05.75   process pointer page  107 of  176 
 
07:15:05.78   process pointer page  108 of  176 
 
07:15:05.81   process pointer page  109 of  176 
 
07:15:05.89   process pointer page  110 of  176 
 
07:15:05.97   process pointer page  111 of  176 
 
07:15:06.04   process pointer page  112 of  176 
 
07:15:06.12   process pointer page  113 of  176 
 
07:15:06.20   process pointer page  114 of  176 
 
07:15:06.29   process pointer page  115 of  176 
 
07:15:06.34   process pointer page  116 of  176 
 
07:15:06.37   process pointer page  117 of  176 
 
07:15:06.43   process pointer page  118 of  176 
 
07:15:06.51   process pointer page  119 of  176 
 
07:15:06.59   process pointer page  120 of  176 
 
07:15:06.65   process pointer page  121 of  176 
 
07:15:06.68   process pointer page  122 of  176 
 
07:15:06.76   process pointer page  123 of  176 
 
07:15:06.82   process pointer page  124 of  176 
 
07:15:06.86   process pointer page  125 of  176 
 
07:15:06.90   process pointer page  126 of  176 
 
07:15:06.98   process pointer page  127 of  176 
 
07:15:07.06   process pointer page  128 of  176 
 
07:15:07.14   process pointer page  129 of  176 
 
07:15:07.21   process pointer page  130 of  176 
 
07:15:07.28   process pointer page  131 of  176 
 
07:15:07.31   process pointer page  132 of  176 
 
07:15:07.35   process pointer page  133 of  176 
 
07:15:07.43   process pointer page  134 of  176 
 
07:15:07.51   process pointer page  135 of  176 
 
07:15:07.59   process pointer page  136 of  176 
 
07:15:07.67   process pointer page  137 of  176 
 
07:15:07.73   process pointer page  138 of  176 
 
07:15:07.76   process pointer page  139 of  176 
 
07:15:07.79   process pointer page  140 of  176 
 
07:15:07.82   process pointer page  141 of  176 
 
07:15:07.85   process pointer page  142 of  176 
 
07:15:07.90   process pointer page  143 of  176 
 
07:15:07.98   process pointer page  144 of  176 
 
07:15:08.06   process pointer page  145 of  176 
 
07:15:08.15   process pointer page  146 of  176 
 
07:15:08.23   process pointer page  147 of  176 
 
07:15:08.26   process pointer page  148 of  176 
 
07:15:08.29   process pointer page  149 of  176 
 
07:15:08.32   process pointer page  150 of  176 
 
07:15:08.35   process pointer page  151 of  176 
 
07:15:08.38   process pointer page  152 of  176 
 
07:15:08.42   process pointer page  153 of  176 
 
07:15:08.43   process pointer page  154 of  176 
 
07:15:08.46   process pointer page  155 of  176 
 
07:15:08.49   process pointer page  156 of  176 
 
07:15:08.52   process pointer page  157 of  176 
 
07:15:08.54   process pointer page  158 of  176 
 
07:15:08.57   process pointer page  159 of  176 
 
07:15:08.59   process pointer page  160 of  176 
 
07:15:08.62   process pointer page  161 of  176 
 
07:15:08.63   process pointer page  162 of  176 
 
07:15:08.66   process pointer page  163 of  176 
 
07:15:08.68   process pointer page  164 of  176 
 
07:15:08.71   process pointer page  165 of  176 
 
07:15:08.73   process pointer page  166 of  176 
 
07:15:08.76   process pointer page  167 of  176 
 
07:15:08.79   process pointer page  168 of  176 
 
07:15:08.81   process pointer page  169 of  176 
 
07:15:08.84   process pointer page  170 of  176 
 
07:15:08.85   process pointer page  171 of  176 
 
07:15:08.88   process pointer page  172 of  176 
 
07:15:08.90   process pointer page  173 of  176 
 
07:15:08.93   process pointer page  174 of  176 
 
07:15:08.95   process pointer page  175 of  176 
 
07:15:08.95 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:15:11.86 Index 2 (PERF_LOG_UNIT) 
 
07:15:16.62 Index 3 (PERF_LOG_TRN_DESC) 
 
07:15:18.90 Index 4 (PERF_LOG_GDSCODE) 
 
07:15:20.24 Relation 163 (PERF_LOG) is ok 
 
 
07:15:20.24 Relation 167 (V_STOPTEST) 
 
07:15:20.24 Relation 167 (V_STOPTEST) is ok 
 
 
07:15:20.24 Relation 184 (V_QDISTR_SOURCE) 
 
07:15:20.24 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:15:20.24 Relation 185 (V_QSTORNED_SOURCE) 
 
07:15:20.24 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:15:20.24 Relation 260 (XQD_1000_1200) 
 
07:15:20.26   process pointer page    0 of    2 
 
07:15:20.26   process pointer page    1 of    2 
 
07:15:20.26 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:15:20.26 Relation 260 (XQD_1000_1200) is ok 
 
 
07:15:20.26 Relation 261 (XQD_1200_2000) 
 
07:15:20.26   process pointer page    0 of    3 
 
07:15:20.27   process pointer page    1 of    3 
 
07:15:20.35   process pointer page    2 of    3 
 
07:15:20.35 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:15:20.37 Relation 261 (XQD_1200_2000) is ok 
 
 
07:15:20.37 Relation 262 (XQD_1000_3300) 
 
07:15:20.37   process pointer page    0 of   11 
 
07:15:20.46   process pointer page    1 of   11 
 
07:15:20.54   process pointer page    2 of   11 
 
07:15:20.63   process pointer page    3 of   11 
 
07:15:20.71   process pointer page    4 of   11 
 
07:15:20.80   process pointer page    5 of   11 
 
07:15:20.85   process pointer page    6 of   11 
 
07:15:20.90   process pointer page    7 of   11 
 
07:15:20.99   process pointer page    8 of   11 
 
07:15:21.07   process pointer page    9 of   11 
 
07:15:21.16   process pointer page   10 of   11 
 
07:15:21.21 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:15:21.55 Index 2 (XQD_1000_3300_DOC) 
 
07:15:21.82 Relation 262 (XQD_1000_3300) is ok 
 
 
07:15:21.82 Relation 263 (XQD_2000_3300) 
 
07:15:21.82   process pointer page    0 of   17 
 
07:15:21.85   process pointer page    1 of   17 
 
07:15:21.89   process pointer page    2 of   17 
 
07:15:21.94   process pointer page    3 of   17 
 
07:15:22.03   process pointer page    4 of   17 
 
07:15:22.13   process pointer page    5 of   17 
 
07:15:22.16   process pointer page    6 of   17 
 
07:15:22.25   process pointer page    7 of   17 
 
07:15:22.35   process pointer page    8 of   17 
 
07:15:22.44   process pointer page    9 of   17 
 
07:15:22.53   process pointer page   10 of   17 
 
07:15:22.63   process pointer page   11 of   17 
 
07:15:22.66   process pointer page   12 of   17 
 
07:15:22.69   process pointer page   13 of   17 
 
07:15:22.74   process pointer page   14 of   17 
 
07:15:22.81   process pointer page   15 of   17 
 
07:15:22.91   process pointer page   16 of   17 
 
07:15:22.97 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:15:23.44 Relation 263 (XQD_2000_3300) is ok 
 
 
07:15:23.44 Relation 264 (XQD_2100_3300) 
 
07:15:23.44   process pointer page    0 of    4 
 
07:15:23.49   process pointer page    1 of    4 
 
07:15:23.49   process pointer page    2 of    4 
 
07:15:23.49   process pointer page    3 of    4 
 
07:15:23.49 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:15:23.49 Relation 264 (XQD_2100_3300) is ok 
 
 
07:15:23.49 Relation 265 (XQD_3300_3400) 
 
07:15:23.49   process pointer page    0 of   25 
 
07:15:23.58   process pointer page    1 of   25 
 
07:15:23.67   process pointer page    2 of   25 
 
07:15:23.77   process pointer page    3 of   25 
 
07:15:23.84   process pointer page    4 of   25 
 
07:15:23.94   process pointer page    5 of   25 
 
07:15:24.03   process pointer page    6 of   25 
 
07:15:24.11   process pointer page    7 of   25 
 
07:15:24.20   process pointer page    8 of   25 
 
07:15:24.30   process pointer page    9 of   25 
 
07:15:24.37   process pointer page   10 of   25 
 
07:15:24.47   process pointer page   11 of   25 
 
07:15:24.56   process pointer page   12 of   25 
 
07:15:24.59   process pointer page   13 of   25 
 
07:15:24.64   process pointer page   14 of   25 
 
07:15:24.67   process pointer page   15 of   25 
 
07:15:24.70   process pointer page   16 of   25 
 
07:15:24.75   process pointer page   17 of   25 
 
07:15:24.84   process pointer page   18 of   25 
 
07:15:24.94   process pointer page   19 of   25 
 
07:15:25.01   process pointer page   20 of   25 
 
07:15:25.08   process pointer page   21 of   25 
 
07:15:25.12   process pointer page   22 of   25 
 
07:15:25.15   process pointer page   23 of   25 
 
07:15:25.19   process pointer page   24 of   25 
 
07:15:25.20 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:15:25.76 Relation 265 (XQD_3300_3400) is ok 
 
 
07:15:25.76 Relation 266 (XQS_1000_1200) 
 
07:15:25.76   process pointer page    0 of   46 
 
07:15:25.84   process pointer page    1 of   46 
 
07:15:25.93   process pointer page    2 of   46 
 
07:15:26.03   process pointer page    3 of   46 
 
07:15:26.12   process pointer page    4 of   46 
 
07:15:26.22   process pointer page    5 of   46 
 
07:15:26.29   process pointer page    6 of   46 
 
07:15:26.39   process pointer page    7 of   46 
 
07:15:26.48   process pointer page    8 of   46 
 
07:15:26.57   process pointer page    9 of   46 
 
07:15:26.67   process pointer page   10 of   46 
 
07:15:26.75   process pointer page   11 of   46 
 
07:15:26.84   process pointer page   12 of   46 
 
07:15:26.93   process pointer page   13 of   46 
 
07:15:27.00   process pointer page   14 of   46 
 
07:15:27.03   process pointer page   15 of   46 
 
07:15:27.06   process pointer page   16 of   46 
 
07:15:27.10   process pointer page   17 of   46 
 
07:15:27.15   process pointer page   18 of   46 
 
07:15:27.23   process pointer page   19 of   46 
 
07:15:27.32   process pointer page   20 of   46 
 
07:15:27.42   process pointer page   21 of   46 
 
07:15:27.49   process pointer page   22 of   46 
 
07:15:27.59   process pointer page   23 of   46 
 
07:15:27.65   process pointer page   24 of   46 
 
07:15:27.68   process pointer page   25 of   46 
 
07:15:27.73   process pointer page   26 of   46 
 
07:15:27.76   process pointer page   27 of   46 
 
07:15:27.84   process pointer page   28 of   46 
 
07:15:27.92   process pointer page   29 of   46 
 
07:15:28.01   process pointer page   30 of   46 
 
07:15:28.10   process pointer page   31 of   46 
 
07:15:28.18   process pointer page   32 of   46 
 
07:15:28.21   process pointer page   33 of   46 
 
07:15:28.24   process pointer page   34 of   46 
 
07:15:28.31   process pointer page   35 of   46 
 
07:15:28.40   process pointer page   36 of   46 
 
07:15:28.49   process pointer page   37 of   46 
 
07:15:28.57   process pointer page   38 of   46 
 
07:15:28.66   process pointer page   39 of   46 
 
07:15:28.74   process pointer page   40 of   46 
 
07:15:28.84   process pointer page   41 of   46 
 
07:15:28.90   process pointer page   42 of   46 
 
07:15:28.93   process pointer page   43 of   46 
 
07:15:28.96   process pointer page   44 of   46 
 
07:15:29.05   process pointer page   45 of   46 
 
07:15:29.09 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:15:29.87 Index 2 (XQS_1000_1200_SND_ID) 
 
07:15:30.79 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:15:31.29 Relation 266 (XQS_1000_1200) is ok 
 
 
07:15:31.29 Relation 267 (XQS_1200_2000) 
 
07:15:31.29   process pointer page    0 of   50 
 
07:15:31.32   process pointer page    1 of   50 
 
07:15:31.39   process pointer page    2 of   50 
 
07:15:31.47   process pointer page    3 of   50 
 
07:15:31.57   process pointer page    4 of   50 
 
07:15:31.64   process pointer page    5 of   50 
 
07:15:31.74   process pointer page    6 of   50 
 
07:15:31.83   process pointer page    7 of   50 
 
07:15:31.91   process pointer page    8 of   50 
 
07:15:32.00   process pointer page    9 of   50 
 
07:15:32.08   process pointer page   10 of   50 
 
07:15:32.11   process pointer page   11 of   50 
 
07:15:32.17   process pointer page   12 of   50 
 
07:15:32.22   process pointer page   13 of   50 
 
07:15:32.28   process pointer page   14 of   50 
 
07:15:32.35   process pointer page   15 of   50 
 
07:15:32.38   process pointer page   16 of   50 
 
07:15:32.41   process pointer page   17 of   50 
 
07:15:32.44   process pointer page   18 of   50 
 
07:15:32.49   process pointer page   19 of   50 
 
07:15:32.52   process pointer page   20 of   50 
 
07:15:32.55   process pointer page   21 of   50 
 
07:15:32.61   process pointer page   22 of   50 
 
07:15:32.67   process pointer page   23 of   50 
 
07:15:32.72   process pointer page   24 of   50 
 
07:15:32.75   process pointer page   25 of   50 
 
07:15:32.83   process pointer page   26 of   50 
 
07:15:32.89   process pointer page   27 of   50 
 
07:15:32.94   process pointer page   28 of   50 
 
07:15:32.97   process pointer page   29 of   50 
 
07:15:33.06   process pointer page   30 of   50 
 
07:15:33.17   process pointer page   31 of   50 
 
07:15:33.25   process pointer page   32 of   50 
 
07:15:33.28   process pointer page   33 of   50 
 
07:15:33.33   process pointer page   34 of   50 
 
07:15:33.36   process pointer page   35 of   50 
 
07:15:33.45   process pointer page   36 of   50 
 
07:15:33.52   process pointer page   37 of   50 
 
07:15:33.58   process pointer page   38 of   50 
 
07:15:33.64   process pointer page   39 of   50 
 
07:15:33.69   process pointer page   40 of   50 
 
07:15:33.72   process pointer page   41 of   50 
 
07:15:33.77   process pointer page   42 of   50 
 
07:15:33.84   process pointer page   43 of   50 
 
07:15:33.89   process pointer page   44 of   50 
 
07:15:33.94   process pointer page   45 of   50 
 
07:15:33.97   process pointer page   46 of   50 
 
07:15:34.02   process pointer page   47 of   50 
 
07:15:34.09   process pointer page   48 of   50 
 
07:15:34.16   process pointer page   49 of   50 
 
07:15:34.16 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:15:35.22 Index 2 (XQS_1200_2000_SND_ID) 
 
07:15:36.51 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:15:39.04 Relation 267 (XQS_1200_2000) is ok 
 
 
07:15:39.04 Relation 268 (XQS_1000_3300) 
 
07:15:39.04   process pointer page    0 of   25 
 
07:15:39.52   process pointer page    1 of   25 
 
07:15:40.01   process pointer page    2 of   25 
 
07:15:40.49   process pointer page    3 of   25 
 
07:15:40.97   process pointer page    4 of   25 
 
07:15:41.46   process pointer page    5 of   25 
 
07:15:41.92   process pointer page    6 of   25 
 
07:15:42.38   process pointer page    7 of   25 
 
07:15:42.80   process pointer page    8 of   25 
 
07:15:43.27   process pointer page    9 of   25 
 
07:15:43.78   process pointer page   10 of   25 
 
07:15:44.26   process pointer page   11 of   25 
 
07:15:44.75   process pointer page   12 of   25 
 
07:15:45.25   process pointer page   13 of   25 
 
07:15:45.72   process pointer page   14 of   25 
 
07:15:46.20   process pointer page   15 of   25 
 
07:15:46.67   process pointer page   16 of   25 
 
07:15:47.15   process pointer page   17 of   25 
 
07:15:47.62   process pointer page   18 of   25 
 
07:15:48.10   process pointer page   19 of   25 
 
07:15:48.57   process pointer page   20 of   25 
 
07:15:49.02   process pointer page   21 of   25 
 
07:15:49.51   process pointer page   22 of   25 
 
07:15:49.97   process pointer page   23 of   25 
 
07:15:50.44   process pointer page   24 of   25 
 
07:15:50.57 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:15:51.88 Index 2 (XQS_1000_3300_SND_ID) 
 
07:15:53.28 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:15:54.83 Relation 268 (XQS_1000_3300) is ok 
 
 
07:15:54.83 Relation 269 (XQS_2000_3300) 
 
07:15:54.83   process pointer page    0 of    1 
 
07:15:54.83 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:15:54.83 Index 2 (XQS_2000_3300_SND_ID) 
 
07:15:54.83 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:15:54.83 Relation 269 (XQS_2000_3300) is ok 
 
 
07:15:54.83 Relation 270 (XQS_2100_3300) 
 
07:15:54.83   process pointer page    0 of   34 
 
07:15:55.29   process pointer page    1 of   34 
 
07:15:55.81   process pointer page    2 of   34 
 
07:15:56.29   process pointer page    3 of   34 
 
07:15:56.78   process pointer page    4 of   34 
 
07:15:57.26   process pointer page    5 of   34 
 
07:15:57.74   process pointer page    6 of   34 
 
07:15:58.23   process pointer page    7 of   34 
 
07:15:58.71   process pointer page    8 of   34 
 
07:15:59.19   process pointer page    9 of   34 
 
07:15:59.68   process pointer page   10 of   34 
 
07:16:00.16   process pointer page   11 of   34 
 
07:16:00.64   process pointer page   12 of   34 
 
07:16:01.11   process pointer page   13 of   34 
 
07:16:01.60   process pointer page   14 of   34 
 
07:16:02.08   process pointer page   15 of   34 
 
07:16:02.55   process pointer page   16 of   34 
 
07:16:03.03   process pointer page   17 of   34 
 
07:16:03.50   process pointer page   18 of   34 
 
07:16:03.98   process pointer page   19 of   34 
 
07:16:04.47   process pointer page   20 of   34 
 
07:16:04.97   process pointer page   21 of   34 
 
07:16:05.34   process pointer page   22 of   34 
 
07:16:05.73   process pointer page   23 of   34 
 
07:16:06.20   process pointer page   24 of   34 
 
07:16:06.65   process pointer page   25 of   34 
 
07:16:07.09   process pointer page   26 of   34 
 
07:16:07.54   process pointer page   27 of   34 
 
07:16:07.98   process pointer page   28 of   34 
 
07:16:08.43   process pointer page   29 of   34 
 
07:16:08.87   process pointer page   30 of   34 
 
07:16:09.32   process pointer page   31 of   34 
 
07:16:09.75   process pointer page   32 of   34 
 
07:16:10.16   process pointer page   33 of   34 
 
07:16:10.21 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:16:11.95 Index 2 (XQS_2100_3300_SND_ID) 
 
07:16:14.06 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:16:16.12 Relation 270 (XQS_2100_3300) is ok 
 
 
07:16:16.12 Relation 271 (XQS_3300_3400) 
 
07:16:16.12   process pointer page    0 of    6 
 
07:16:16.49   process pointer page    1 of    6 
 
07:16:16.87   process pointer page    2 of    6 
 
07:16:17.35   process pointer page    3 of    6 
 
07:16:17.84   process pointer page    4 of    6 
 
07:16:18.29   process pointer page    5 of    6 
 
07:16:18.55 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:16:18.94 Index 2 (XQS_3300_3400_SND_ID) 
 
07:16:19.35 Relation 271 (XQS_3300_3400) is ok 
 
 
07:16:19.36 Validation finished 
 
Done for 86180 ms, from  7:14:53.28 to  7:16:19.46. 
 
 Differences between old and current firebird.log 
7:16:21.13. 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-10-14  07:16               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 Sat Oct 14 07:14:53 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Sat Oct 14 07:16:19 2017 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 401 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-10-14  7:16:28.77 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html