Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 10. 2016-01-17 12:58:20.93.
Common Performance Final Results
  1. Test configuration
  2. Test Finish details
  3. Test workload details
  4. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score
  2. Performance, DYNAMIC, 10 intervals
  3. Performance, per MINUTE, since launch
  4. Performance, TRACE data for ISQL #1
  5. Performance, DETAILS per units
  6. MON$-analysis, per business units
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database Statistics, full
  3. Ratio "Versions / Records" for tables
  4. Database Validation Results
  5. New in firebird.log while test was run
  6. Final processing of ISQL logs

Server and database settings

Server version: WI-V2.5.6.26963 Firebird 2.5
Server implementation: Firebird/x86-64/Windows NT
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
Classic 2.5.6 D:\OLTP-EMUL\OLTP25-SMALL.FDB ON 0 384 8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp25_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB25.TMPINSTANCE\bin\
dbnm D:\OLTP-EMUL\oltp25-small.fdb
host localhost
port 3255
usr SYSDBA
pwd masterke
tmpdir e:\temp\logs.oltp25
working_mode small_03
warm_time 10
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 0
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
upload_report 1

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2016-01-17 12:57:20.5800 -1 <null> 127.0.0.1 195631 4607 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
COMMON ENABLE_MON_QUERY 0
COMMON HALT_TEST_ON_ERRORS ,CK,
COMMON LOG_PK_VIOLATION 0
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

Index(es) for heavy-loaded table(s)

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

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 10498.46 1628 1889723 2016-01-17 09:57 2016-01-17 12:57
customer order: creation 185.93 60 33468 2016-01-17 09:57 2016-01-17 12:57
customer order: refuse 15.08 40 2715 2016-01-17 09:57 2016-01-17 12:57
order to supplier: creation 47.94 204 8629 2016-01-17 09:57 2016-01-17 12:57
order to supplier: removal 1.65 13918 286 2016-01-17 09:57 2016-01-17 12:57
invoice (draft): creation 47.44 389 8539 2016-01-17 09:57 2016-01-17 12:57
invoice (draft): removal 25.72 111 4578 2016-01-17 09:57 2016-01-17 12:57
invoice accept: apply 27.96 12777 5032 2016-01-17 09:57 2016-01-17 12:57
invoice accept: cancel 12.72 541 2277 2016-01-17 09:57 2016-01-17 12:57
customer reserve: creation 8842.84 34 1591712 2016-01-17 09:57 2016-01-17 12:57
customer reserve: removal 1011.07 18 181993 2016-01-17 09:57 2016-01-17 12:57
realization accept: apply 87.13 63 15684 2016-01-17 09:57 2016-01-17 12:57
realization accept: cancel 38.19 32 6874 2016-01-17 09:57 2016-01-17 12:57
payment from customer: creation 62.85 91 11313 2016-01-17 09:57 2016-01-17 12:57
payment from customer: removal 5.95 30 1065 2016-01-17 09:57 2016-01-17 12:57
payment to supplier: creation 51.91 105 9344 2016-01-17 09:57 2016-01-17 12:57
payment to supplier: removal 3.68 33 655 2016-01-17 09:57 2016-01-17 12:57
service: total inventory turnovers 18.70 153 3366 2016-01-17 09:57 2016-01-17 12:57
service: total monetary turnovers 12.12 4 2182 2016-01-17 09:57 2016-01-17 12:57
service: refresh index statistics 0.07 2321 11 2016-01-17 09:57 2016-01-17 12:57
Done for 67000 ms, from 12:59:41.86 to 13:00:48.86.

Performance in DYNAMIC:

ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
interval # 1, overall 1 6545 121813 117803 4010 3.29 09:57:21 10:15:21
interval # 2, overall 2 9121 171780 164171 7609 4.43 10:15:22 10:33:22
interval # 3, overall 3 10958 202835 197247 5588 2.75 10:33:23 10:51:23
interval # 4, overall 4 11663 210696 209942 754 0.36 10:51:24 11:09:24
interval # 5, overall 5 10448 195331 188055 7276 3.72 11:09:25 11:27:25
interval # 6, overall 6 13372 255127 240695 14432 5.66 11:27:26 11:45:26
interval # 7, overall 7 12511 228433 225200 3233 1.42 11:45:27 12:03:27
interval # 8, overall 8 13551 244689 243911 778 0.32 12:03:28 12:21:28
interval # 9, overall 9 10851 204887 195309 9578 4.67 12:21:29 12:39:29
interval # 10, overall 10 5966 107606 107390 216 0.20 12:39:30 12:57:30
Done for 118620 ms, from 13:02:45.12 to 13:04:43.74.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
WARM_TIME 1 3077.77 0.7924 1.1781 509 7
WARM_TIME 2 1981.22 0.9501 1.0632 87 3
WARM_TIME 3 1426.66 0.9922 1.0081 74 2
WARM_TIME 4 1235.72 0.8731 1.1568 434 7
WARM_TIME 5 1258.76 0.9086 1.0694 207 6
WARM_TIME 6 1262.59 0.8977 1.0940 357 7
WARM_TIME 7 1294.78 0.9174 1.0542 320 9
WARM_TIME 8 1349.83 0.8909 1.0880 361 9
WARM_TIME 9 1773.88 0.7360 1.2404 1511 10
WARM_TIME 10 2146.90 0.9223 1.0945 698 10
TEST_TIME 11 2202.59 0.9860 1.0231 68 6
TEST_TIME 12 2095.90 0.9969 1.0096 51 3
TEST_TIME 13 1965.94 0.9982 1.0136 38 2
TEST_TIME 14 1869.97 0.9895 1.0052 101 3
TEST_TIME 15 1845.62 0.9506 1.0697 351 9
TEST_TIME 16 2219.80 0.8338 1.1426 1331 10
TEST_TIME 17 2764.51 0.8635 1.1055 1130 10
TEST_TIME 18 3123.85 0.9240 1.0909 1054 10
TEST_TIME 19 3336.08 0.9712 1.0333 466 10
TEST_TIME 20 3556.64 0.9208 1.0678 1089 10
TEST_TIME 21 3827.56 0.9450 1.0640 998 10
TEST_TIME 22 3952.45 0.9835 1.0184 347 9
TEST_TIME 23 4050.06 0.9541 1.0394 873 10
TEST_TIME 24 4214.07 0.9573 1.0407 997 10
TEST_TIME 25 4348.76 0.9681 1.0284 534 10
TEST_TIME 26 4462.60 0.9637 1.0370 640 10
TEST_TIME 27 4689.87 0.9502 1.0597 1085 10
TEST_TIME 28 5000.11 0.9584 1.0365 731 10
TEST_TIME 29 5304.26 0.9434 1.0419 1265 10
TEST_TIME 30 5522.67 0.9673 1.0243 897 10
TEST_TIME 31 5619.37 0.9743 1.0253 676 10
TEST_TIME 32 5759.02 0.9692 1.0273 963 10
TEST_TIME 33 5861.55 0.9787 1.0210 777 10
TEST_TIME 34 5961.26 0.9744 1.0208 739 10
TEST_TIME 35 6050.78 0.9770 1.0264 978 10
TEST_TIME 36 6203.25 0.9734 1.0242 829 10
TEST_TIME 37 6315.76 0.9790 1.0161 674 10
TEST_TIME 38 6380.25 0.9793 1.0193 744 10
TEST_TIME 39 6466.41 0.9800 1.0187 832 10
TEST_TIME 40 6441.92 0.9970 1.0033 192 6
TEST_TIME 41 6516.25 0.9677 1.0299 1110 10
TEST_TIME 42 6565.40 0.9978 1.0054 255 7
TEST_TIME 43 6474.34 0.9960 1.0049 222 6
TEST_TIME 44 6389.68 0.9951 1.0069 116 7
TEST_TIME 45 6500.38 0.9678 1.0240 1075 10
TEST_TIME 46 6635.10 0.9814 1.0196 1108 10
TEST_TIME 47 6730.15 0.9845 1.0110 559 10
TEST_TIME 48 6705.01 0.9937 1.0079 480 8
TEST_TIME 49 6645.87 0.9963 1.0029 319 7
TEST_TIME 50 6577.59 0.9931 1.0073 360 9
TEST_TIME 51 6613.37 0.9822 1.0208 742 10
TEST_TIME 52 6767.61 0.9783 1.0193 808 10
TEST_TIME 53 6898.22 0.9811 1.0163 754 10
TEST_TIME 54 6925.94 0.9935 1.0040 292 10
TEST_TIME 55 6950.06 0.9832 1.0141 477 10
TEST_TIME 56 7062.57 0.9806 1.0250 929 10
TEST_TIME 57 7207.43 0.9868 1.0160 827 10
TEST_TIME 58 7356.04 0.9783 1.0150 890 10
TEST_TIME 59 7445.01 0.9859 1.0139 817 10
TEST_TIME 60 7558.89 0.9820 1.0156 567 10
TEST_TIME 61 7644.43 0.9878 1.0148 621 10
TEST_TIME 62 7746.78 0.9860 1.0098 756 10
TEST_TIME 63 7816.48 0.9850 1.0129 637 10
TEST_TIME 64 7850.46 0.9928 1.0116 682 10
TEST_TIME 65 7926.06 0.9868 1.0130 700 10
TEST_TIME 66 8010.26 0.9872 1.0105 650 10
TEST_TIME 67 8112.11 0.9829 1.0151 554 10
TEST_TIME 68 8203.30 0.9891 1.0116 598 10
TEST_TIME 69 8233.96 0.9932 1.0078 642 10
TEST_TIME 70 8252.47 0.9919 1.0090 546 10
TEST_TIME 71 8309.60 0.9880 1.0148 930 10
TEST_TIME 72 8426.97 0.9867 1.0132 749 10
TEST_TIME 73 8555.66 0.9852 1.0101 857 10
TEST_TIME 74 8629.68 0.9879 1.0122 718 10
TEST_TIME 75 8720.53 0.9883 1.0104 794 10
TEST_TIME 76 8805.87 0.9875 1.0098 878 10
TEST_TIME 77 8849.12 0.9918 1.0108 741 10
TEST_TIME 78 8915.87 0.9904 1.0090 900 10
TEST_TIME 79 8915.99 0.9963 1.0031 447 9
TEST_TIME 80 8837.95 0.9997 1.0002 37 3
TEST_TIME 81 8738.80 0.9993 1.0000 18 2
TEST_TIME 82 8641.87 0.9991 1.0019 36 3
TEST_TIME 83 8573.61 0.9984 1.0013 48 6
TEST_TIME 84 8501.24 0.9978 1.0042 202 7
TEST_TIME 85 8464.60 0.9978 1.0020 134 6
TEST_TIME 86 8458.96 0.9911 1.0077 653 9
TEST_TIME 87 8533.66 0.9874 1.0103 921 10
TEST_TIME 88 8615.99 0.9893 1.0086 1050 10
TEST_TIME 89 8687.69 0.9891 1.0083 916 10
TEST_TIME 90 8765.63 0.9883 1.0087 669 10
TEST_TIME 91 8810.40 0.9925 1.0085 745 10
TEST_TIME 92 8794.73 0.9993 1.0005 33 5
TEST_TIME 93 8731.12 0.9971 1.0015 206 6
TEST_TIME 94 8718.33 0.9923 1.0071 533 10
TEST_TIME 95 8773.80 0.9902 1.0098 773 10
TEST_TIME 96 8839.56 0.9918 1.0078 724 10
TEST_TIME 97 8879.60 0.9929 1.0072 643 10
TEST_TIME 98 8906.28 0.9940 1.0092 701 10
TEST_TIME 99 8969.21 0.9920 1.0071 677 10
TEST_TIME 100 8998.08 0.9938 1.0072 672 10
TEST_TIME 101 9031.07 0.9936 1.0049 955 10
TEST_TIME 102 9095.52 0.9880 1.0088 792 10
TEST_TIME 103 9148.98 0.9932 1.0084 872 10
TEST_TIME 104 9196.54 0.9935 1.0077 773 10
TEST_TIME 105 9241.12 0.9933 1.0074 758 10
TEST_TIME 106 9277.50 0.9940 1.0062 829 10
TEST_TIME 107 9285.56 0.9959 1.0049 834 10
TEST_TIME 108 9322.93 0.9916 1.0088 557 10
TEST_TIME 109 9380.53 0.9934 1.0068 645 10
TEST_TIME 110 9402.11 0.9953 1.0072 640 10
TEST_TIME 111 9435.20 0.9946 1.0064 657 10
TEST_TIME 112 9463.01 0.9945 1.0068 698 10
TEST_TIME 113 9499.80 0.9941 1.0052 771 10
TEST_TIME 114 9522.24 0.9940 1.0057 649 10
TEST_TIME 115 9543.63 0.9947 1.0054 566 10
TEST_TIME 116 9568.71 0.9941 1.0050 741 10
TEST_TIME 117 9608.65 0.9923 1.0077 671 10
TEST_TIME 118 9655.54 0.9943 1.0061 749 10
TEST_TIME 119 9700.98 0.9930 1.0072 715 10
TEST_TIME 120 9728.48 0.9960 1.0055 614 10
TEST_TIME 121 9762.46 0.9937 1.0047 798 10
TEST_TIME 122 9785.73 0.9941 1.0051 655 9
TEST_TIME 123 9795.56 0.9960 1.0042 759 10
TEST_TIME 124 9759.60 0.9998 1.0004 85 5
TEST_TIME 125 9716.48 0.9970 1.0025 361 8
TEST_TIME 126 9735.52 0.9934 1.0065 619 10
TEST_TIME 127 9774.19 0.9946 1.0037 774 9
TEST_TIME 128 9792.23 0.9940 1.0053 767 10
TEST_TIME 129 9809.68 0.9960 1.0038 809 10
TEST_TIME 130 9818.84 0.9951 1.0047 568 10
TEST_TIME 131 9852.72 0.9936 1.0056 872 10
TEST_TIME 132 9882.35 0.9950 1.0070 713 10
TEST_TIME 133 9945.90 0.9931 1.0059 886 10
TEST_TIME 134 9988.99 0.9941 1.0049 650 10
TEST_TIME 135 10021.04 0.9942 1.0037 489 10
TEST_TIME 136 10040.80 0.9944 1.0029 774 10
TEST_TIME 137 10048.92 0.9948 1.0050 600 10
TEST_TIME 138 10080.62 0.9945 1.0045 579 10
TEST_TIME 139 10102.30 0.9951 1.0031 766 10
TEST_TIME 140 10107.49 0.9955 1.0037 796 10
TEST_TIME 141 10102.90 0.9970 1.0033 863 10
TEST_TIME 142 10105.56 0.9960 1.0039 674 9
TEST_TIME 143 10121.85 0.9953 1.0036 680 10
TEST_TIME 144 10131.56 0.9957 1.0048 667 10
TEST_TIME 145 10152.92 0.9958 1.0045 487 10
TEST_TIME 146 10191.86 0.9939 1.0064 591 10
TEST_TIME 147 10231.28 0.9957 1.0043 914 10
TEST_TIME 148 10256.59 0.9951 1.0050 809 10
TEST_TIME 149 10305.06 0.9937 1.0053 755 10
TEST_TIME 150 10337.36 0.9955 1.0046 734 10
TEST_TIME 151 10373.16 0.9945 1.0053 753 10
TEST_TIME 152 10400.90 0.9960 1.0047 714 10
TEST_TIME 153 10418.22 0.9965 1.0043 862 10
TEST_TIME 154 10432.09 0.9964 1.0040 602 10
TEST_TIME 155 10446.53 0.9962 1.0026 520 9
TEST_TIME 156 10461.66 0.9948 1.0047 464 10
TEST_TIME 157 10474.82 0.9971 1.0033 657 10
TEST_TIME 158 10474.56 0.9970 1.0025 679 10
TEST_TIME 159 10477.44 0.9959 1.0034 666 10
TEST_TIME 160 10490.42 0.9959 1.0038 569 10
TEST_TIME 161 10505.35 0.9961 1.0031 876 10
TEST_TIME 162 10526.12 0.9950 1.0035 638 10
TEST_TIME 163 10549.20 0.9952 1.0039 709 10
TEST_TIME 164 10561.93 0.9966 1.0042 749 10
TEST_TIME 165 10580.88 0.9963 1.0040 897 10
TEST_TIME 166 10595.04 0.9966 1.0028 810 10
TEST_TIME 167 10621.17 0.9947 1.0028 750 10
TEST_TIME 168 10624.75 0.9965 1.0026 764 9
TEST_TIME 169 10617.79 0.9973 1.0019 407 10
TEST_TIME 170 10577.55 0.9998 1.0002 83 2
TEST_TIME 171 10520.42 0.9999 1.0000 84 2
TEST_TIME 172 10471.13 0.9989 1.0017 80 3
TEST_TIME 173 10429.53 0.9999 1.0000 17 1
TEST_TIME 174 10371.17 0.9998 1.0002 156 3
TEST_TIME 175 10314.23 0.9999 1.0000 8 1
TEST_TIME 176 10257.26 0.9999 1.0000 43 2
TEST_TIME 177 10201.44 1.0000 1.0000 5 1
TEST_TIME 179 10095.63 0.9995 1.0001 72 3
TEST_TIME 180 10042.12 0.9998 1.0000 16 2
TEST_TIME 181 9996.70 0.9994 1.0004 55 4
TEST_TIME 182 9953.24 0.9993 1.0008 109 6
TEST_TIME 183 9926.28 0.9986 1.0015 255 8
TEST_TIME 184 9935.72 0.9962 1.0033 657 10
TEST_TIME 185 9965.29 0.9949 1.0046 795 10
TEST_TIME 186 9987.84 0.9969 1.0046 841 10
TEST_TIME 187 10021.46 0.9959 1.0044 706 10
TEST_TIME 188 10038.59 0.9973 1.0038 784 10
TEST_TIME 189 10055.08 0.9969 1.0026 728 9
TEST_TIME 190 10049.74 0.9979 1.0017 248 10
Done for 10050 ms, from 13:04:44.28 to 13:04:54.33.

Performance from TRACE for ISQL instance #1:

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 35958 60740 51616 94606 58727 60821 88098 80661 26979 39609 44728 41268 69922 52984 222967 60499 536731 245689 <null> 09:57:21 10:15:21
fetches per second 2 31119 49926 49230 44503 60465 58230 104296 56516 24181 41292 33488 33953 63223 40088 229399 45630 436251 231559 <null> 10:15:22 10:33:22
fetches per second 3 33377 68085 56495 70028 72826 32458 163164 55203 25009 25653 41676 30856 87021 39915 236291 37786 457535 444242 4599 10:33:23 10:51:23
fetches per second 4 31691 42984 55095 64897 74179 116908 158129 51525 35500 40797 37198 28298 61880 33625 209300 30675 629268 185929 <null> 10:51:24 11:09:24
fetches per second 5 29220 49665 46745 75684 65784 61049 137014 49765 26613 35883 28755 27268 51044 27441 129862 15913 464686 217105 <null> 11:09:25 11:27:25
fetches per second 6 30296 37040 46150 95185 63217 98710 211407 59419 25631 27992 29134 21826 59448 14735 78055 27654 429035 172479 <null> 11:27:26 11:45:26
fetches per second 7 30131 35334 42857 91225 67388 53968 171029 48233 25475 34127 28259 17688 63348 27846 52902 33336 509699 191531 <null> 11:45:27 12:03:27
fetches per second 8 25100 33438 40609 35889 61787 31411 190741 45366 19503 19781 21347 17979 54393 13603 40423 21373 396260 182847 <null> 12:03:28 12:21:28
fetches per second 9 27690 27065 42508 85743 62175 <null> 198391 60312 25161 29279 21771 18086 59685 16435 48456 28425 454922 180612 <null> 12:21:29 12:39:29
fetches per second 10 38827 49584 49626 106153 75085 107238 150581 46358 29240 24901 51460 17815 79919 27369 59152 30554 410865 419738 <null> 12:39:30 12:57:30
marks per second 1 6625 6752 9072 10984 10587 9377 3552 9325 3238 5723 6726 5620 4244 5745 2595 7246 23323 16589 <null> 09:57:21 10:15:21
marks per second 2 5783 5383 8683 5337 11188 10317 3542 6383 2986 4722 5453 3989 3764 5405 2597 4559 20328 15652 <null> 10:15:22 10:33:22
marks per second 3 6169 7025 9433 6950 12393 5441 3158 5574 2574 2695 5549 3871 3457 4135 2807 3972 18446 22126 400 10:33:23 10:51:23
marks per second 4 5741 4659 9756 6818 13426 21834 3024 5222 2709 4359 4979 3505 2990 3457 2783 3745 15873 9621 <null> 10:51:24 11:09:24
marks per second 5 5257 5202 7984 8116 11240 10677 3362 5156 2802 3794 3433 3124 2962 3414 4147 1963 17953 7511 <null> 11:09:25 11:27:25
marks per second 6 5489 3945 7564 14791 10685 17467 3132 6143 2196 3233 3948 2757 2909 1544 5204 4163 15965 7854 <null> 11:27:26 11:45:26
marks per second 7 5476 3945 7168 9088 11493 9796 3544 4690 2618 3649 3950 2530 2977 2832 4617 3683 12213 11202 <null> 11:45:27 12:03:27
marks per second 8 4498 3830 6694 6592 10466 5307 3193 4491 1751 2057 3178 2082 2074 1509 3809 3158 15211 10061 <null> 12:03:28 12:21:28
marks per second 9 4991 2901 7070 9222 10472 <null> 3137 5981 1797 3140 3071 2199 2384 2070 4265 3873 13277 8631 <null> 12:21:29 12:39:29
marks per second 10 6899 6131 7571 14838 10430 22367 3330 4602 4666 2653 3072 1989 2260 3257 3704 5541 13697 6206 <null> 12:39:30 12:57:30
reads/fetches*100 1 9 7 5 2 4 4 3 2 8 8 9 8 8 7 3 6 1 2 <null> 09:57:21 10:15:21
reads/fetches*100 2 9 8 5 2 4 6 3 2 8 8 10 8 8 7 3 7 1 2 <null> 10:15:22 10:33:22
reads/fetches*100 3 9 7 5 2 4 5 2 3 7 8 11 8 8 8 3 7 1 2 1 10:33:23 10:51:23
reads/fetches*100 4 10 8 5 2 4 3 2 2 8 8 11 9 9 8 4 8 1 2 <null> 10:51:24 11:09:24
reads/fetches*100 5 10 8 5 2 5 4 2 2 8 9 12 12 9 10 6 11 1 3 <null> 11:09:25 11:27:25
reads/fetches*100 6 9 8 5 2 4 3 2 2 8 8 12 10 9 9 7 7 1 2 <null> 11:27:26 11:45:26
reads/fetches*100 7 10 9 5 1 5 4 2 3 10 8 12 11 9 9 6 8 1 3 <null> 11:45:27 12:03:27
reads/fetches*100 8 11 9 6 4 5 4 2 3 9 11 14 12 10 9 8 13 1 3 <null> 12:03:28 12:21:28
reads/fetches*100 9 11 10 6 2 5 <null> 2 2 10 11 14 11 10 12 7 9 1 2 <null> 12:21:29 12:39:29
reads/fetches*100 10 10 9 5 2 6 3 2 4 10 8 13 12 9 10 7 9 3 4 <null> 12:39:30 12:57:30
writes/marks*100 1 10 12 7 2 7 3 2 2 10 4 7 9 2 0 5 0 10 4 <null> 09:57:21 10:15:21
writes/marks*100 2 10 14 7 2 7 3 3 2 11 5 7 11 2 0 5 0 11 4 <null> 10:15:22 10:33:22
writes/marks*100 3 10 14 8 2 7 2 2 2 11 7 7 11 6 0 5 0 12 3 0 10:33:23 10:51:23
writes/marks*100 4 10 14 8 3 8 1 3 3 12 7 8 12 5 0 5 0 10 3 <null> 10:51:24 11:09:24
writes/marks*100 5 10 14 8 2 7 3 3 2 10 6 8 12 5 0 4 0 10 3 <null> 11:09:25 11:27:25
writes/marks*100 6 10 13 7 3 8 2 3 2 10 6 8 8 6 0 2 0 14 3 <null> 11:27:26 11:45:26
writes/marks*100 7 11 14 7 2 8 1 3 2 9 7 8 8 6 0 1 0 15 4 <null> 11:45:27 12:03:27
writes/marks*100 8 11 15 7 1 8 0 3 3 10 6 7 11 6 0 1 0 13 3 <null> 12:03:28 12:21:28
writes/marks*100 9 11 13 8 3 7 <null> 3 2 11 5 7 18 7 0 1 0 11 3 <null> 12:21:29 12:39:29
writes/marks*100 10 11 14 7 3 8 1 2 2 4 6 10 11 6 0 1 0 16 3 <null> 12:39:30 12:57:30
Done for 9930 ms, from 13:04:55.74 to 13:05:05.67.

Performance in DETAILS:

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 1121470 1071983 49487 4.41 0 1935 4 49487 2016-01-17 09:57 2016-01-17 12:57
doc_list_biud 1121651 1071981 49670 4.42 0 11122 4 49670 2016-01-17 09:57 2016-01-17 12:57
sp_add_invoice_to_stock 8120 5032 3088 38.02 62 892652 12777 3088 2016-01-17 09:57 2016-01-17 12:57
sp_cancel_adding_invoice 2602 2277 325 12.49 0 12231 541 325 2016-01-17 09:57 2016-01-17 12:57
sp_cancel_client_order 2855 2715 140 4.90 0 359 40 140 2016-01-17 09:57 2016-01-17 12:57
sp_cancel_customer_reserve 228582 181993 46589 20.38 0 2340 18 46589 2016-01-17 09:57 2016-01-17 12:57
sp_cancel_pay_from_customer 1069 1065 4 0.37 0 828 30 4 2016-01-17 09:57 2016-01-17 12:57
sp_cancel_pay_to_supplier 659 655 4 0.60 0 499 33 4 2016-01-17 09:57 2016-01-17 12:57
sp_cancel_supplier_invoice 5302 4578 724 13.65 0 1592 111 724 2016-01-17 09:57 2016-01-17 12:57
sp_cancel_supplier_order 565 286 279 49.38 62 166416 13918 279 2016-01-17 09:57 2016-01-17 12:57
sp_cancel_write_off 9058 6874 2184 24.11 0 1061 32 2184 2016-01-17 09:57 2016-01-17 12:57
sp_client_order 33468 33468 0 0.00 0 1575 60 0 2016-01-17 09:57 2016-01-17 12:57
sp_customer_reserve 1591712 1591712 0 0.00 0 4883 34 0 2016-01-17 09:57 2016-01-17 12:57
sp_fill_shopping_cart 50636 50636 0 0.00 0 2386 13 0 2016-01-17 09:57 2016-01-17 12:57
sp_fill_shopping_cart_clo_res 1591712 1591712 0 0.00 0 764 1 0 2016-01-17 09:57 2016-01-17 12:57
sp_get_clo_for_invoice 5032 5032 0 0.00 0 1217 137 0 2016-01-17 09:57 2016-01-17 12:57
sp_kill_cost_storno 13334 10872 2462 18.46 0 1014 7 2462 2016-01-17 09:57 2016-01-17 12:57
sp_kill_qstorno_ret_qs2qd 471496 375726 95770 20.31 0 2325 8 95770 2016-01-17 09:57 2016-01-17 12:57
sp_kill_qty_storno 269095 219441 49654 18.45 0 11122 19 49654 2016-01-17 09:57 2016-01-17 12:57
sp_lock_selected_doc 33017 29052 3965 12.00 0 187 0 3965 2016-01-17 09:57 2016-01-17 12:57
sp_make_cost_storno 41373 41373 0 0.00 0 1861 35 0 2016-01-17 09:57 2016-01-17 12:57
sp_multiply_rows_for_pdistr 41373 41373 0 0.00 0 1061 12 0 2016-01-17 09:57 2016-01-17 12:57
sp_multiply_rows_for_qdistr 33468 33468 0 0.00 0 1107 21 0 2016-01-17 09:57 2016-01-17 12:57
sp_pay_from_customer 11313 11313 0 0.00 15 1225 91 0 2016-01-17 09:57 2016-01-17 12:57
sp_pay_to_supplier 9344 9344 0 0.00 0 1884 105 0 2016-01-17 09:57 2016-01-17 12:57
sp_payment_common 20657 20657 0 0.00 0 453 20 0 2016-01-17 09:57 2016-01-17 12:57
sp_qd_handle_on_cancel_clo 2855 2715 140 4.90 0 156 12 140 2016-01-17 09:57 2016-01-17 12:57
sp_qd_handle_on_invoice_upd_sts 7623 7310 313 4.10 0 11122 111 313 2016-01-17 09:57 2016-01-17 12:57
sp_qd_handle_on_reserve_upd_sts 15684 15684 0 0.00 0 546 8 0 2016-01-17 09:57 2016-01-17 12:57
sp_reserve_write_off 15821 15684 137 0.86 0 968 63 137 2016-01-17 09:57 2016-01-17 12:57
sp_supplier_invoice 8539 8539 0 0.00 15 3088 389 0 2016-01-17 09:57 2016-01-17 12:57
sp_supplier_order 8629 8629 0 0.00 0 1856 204 0 2016-01-17 09:57 2016-01-17 12:57
srv_find_qd_qs_mism 684010 634526 49484 7.23 0 959 3 49484 2016-01-17 09:57 2016-01-17 12:57
srv_make_invnt_saldo 3366 3366 0 0.00 0 5507 153 0 2016-01-17 09:57 2016-01-17 12:57
srv_make_money_saldo 2182 2182 0 0.00 0 140 4 0 2016-01-17 09:57 2016-01-17 12:57
srv_recalc_idx_stat 11 11 0 0.00 954 3900 2321 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_add_invoice_to_stock 3088 3088 0 0.00 0 290 15 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_cancel_adding_invoice 62 62 0 0.00 0 328 82 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_cancel_client_order 140 140 0 0.00 0 125 22 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_cancel_customer_reserve 13 13 0 0.00 0 47 8 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_cancel_pay_from_customer 4 4 0 0.00 0 16 7 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_cancel_pay_to_supplier 4 4 0 0.00 0 47 23 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_cancel_supplier_invoice 267 267 0 0.00 0 140 15 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_cancel_supplier_order 5727 5727 0 0.00 0 796 71 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_cancel_write_off 13 13 0 0.00 0 78 20 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-abend:sp_reserve_write_off 137 137 0 0.00 0 218 18 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_add_invoice_to_stock 5035 5035 0 0.00 0 19516 1670 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_cancel_adding_invoice 640 640 0 0.00 0 4040 575 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_cancel_client_order 2715 2715 0 0.00 0 764 26 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_cancel_customer_reserve 1082 1082 0 0.00 0 234 26 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_cancel_pay_from_customer 1065 1065 0 0.00 0 218 20 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_cancel_pay_to_supplier 655 655 0 0.00 0 171 20 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_cancel_supplier_invoice 382 382 0 0.00 0 218 26 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_cancel_supplier_order 287 287 0 0.00 0 40606 4256 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_cancel_write_off 1512 1512 0 0.00 0 764 25 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_client_order 33468 33468 0 0.00 0 1201 30 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_customer_reserve 1573 1573 0 0.00 0 936 19 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_pay_from_customer 11313 11313 0 0.00 0 280 20 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_pay_to_supplier 9344 9344 0 0.00 0 795 21 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_reserve_write_off 15684 15684 0 0.00 0 1154 27 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_supplier_invoice 8540 8540 0 0.00 0 952 29 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:sp_supplier_order 8629 8629 0 0.00 0 749 29 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:srv_make_invnt_saldo 3366 3366 0 0.00 0 780 11 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:srv_make_money_saldo 2182 2182 0 0.00 0 546 9 0 2016-01-17 09:57 2016-01-17 12:57
t$perf-norm:srv_recalc_idx_stat 11 11 0 0.00 0 141 39 0 2016-01-17 09:57 2016-01-17 12:57
v_add_invoice_to_stock 16240 10064 6176 38.02 0 472 3 6176 2016-01-17 09:57 2016-01-17 12:57
v_all_customers 49990 49990 0 0.00 0 46 0 0 2016-01-17 09:57 2016-01-17 12:57
v_all_suppliers 37140 37140 0 0.00 0 16 0 0 2016-01-17 09:57 2016-01-17 12:57
v_all_wares 66936 66936 0 0.00 0 47 0 0 2016-01-17 09:57 2016-01-17 12:57
v_cancel_adding_invoice 1318 1278 40 3.03 0 187 13 40 2016-01-17 09:57 2016-01-17 12:57
v_cancel_client_order 5710 5430 280 4.90 0 249 1 280 2016-01-17 09:57 2016-01-17 12:57
v_cancel_customer_prepayment 2138 2130 8 0.37 0 282 1 8 2016-01-17 09:57 2016-01-17 12:57
v_cancel_customer_reserve 2190 2164 26 1.18 0 406 2 26 2016-01-17 09:57 2016-01-17 12:57
v_cancel_payment_to_supplier 1318 1310 8 0.60 0 46 1 8 2016-01-17 09:57 2016-01-17 12:57
v_cancel_supplier_invoice 1298 764 534 41.14 0 47 3 534 2016-01-17 09:57 2016-01-17 12:57
v_cancel_supplier_order 1130 572 558 49.38 0 47 1 558 2016-01-17 09:57 2016-01-17 12:57
v_cancel_write_off 3050 3024 26 0.85 0 842 9 26 2016-01-17 09:57 2016-01-17 12:57
v_max_id_clo_ord 8629 8629 0 0.00 0 78 0 0 2016-01-17 09:57 2016-01-17 12:57
v_max_id_clo_res 1573 1573 0 0.00 0 78 4 0 2016-01-17 09:57 2016-01-17 12:57
v_max_id_ord_sup 8539 8539 0 0.00 0 109 0 0 2016-01-17 09:57 2016-01-17 12:57
v_max_non_paid_invoice 7942 7942 0 0.00 0 110 1 0 2016-01-17 09:57 2016-01-17 12:57
v_max_non_paid_realizn 11313 11313 0 0.00 0 94 6 0 2016-01-17 09:57 2016-01-17 12:57
v_min_id_clo_ord 8629 8629 0 0.00 0 352 3 0 2016-01-17 09:57 2016-01-17 12:57
v_min_id_clo_res 1573 1573 0 0.00 0 31 1 0 2016-01-17 09:57 2016-01-17 12:57
v_min_id_ord_sup 8539 8539 0 0.00 0 390 3 0 2016-01-17 09:57 2016-01-17 12:57
v_min_non_paid_invoice 9344 9344 0 0.00 0 187 12 0 2016-01-17 09:57 2016-01-17 12:57
v_min_non_paid_realizn 11313 11313 0 0.00 0 327 10 0 2016-01-17 09:57 2016-01-17 12:57
v_our_firm 16946 16946 0 0.00 0 31 0 0 2016-01-17 09:57 2016-01-17 12:57
v_reserve_write_off 31642 31368 274 0.86 0 182 1 274 2016-01-17 09:57 2016-01-17 12:57
x_lock_depdocs_on_canc_invoice 8039 6465 1574 19.57 0 140 5 1574 2016-01-17 09:57 2016-01-17 12:57
x_lock_depdocs_on_canc_sup_ord 565 286 279 49.38 0 124 8 279 2016-01-17 09:57 2016-01-17 12:57
x_make_qstorno_1000_1200 8629 8629 0 0.00 0 1716 159 0 2016-01-17 09:57 2016-01-17 12:57
x_make_qstorno_1200_2000 8539 8539 0 0.00 0 3058 349 0 2016-01-17 09:57 2016-01-17 12:57
x_make_qstorno_2100_3300 1591712 1591712 0 0.00 0 4868 28 0 2016-01-17 09:57 2016-01-17 12:57
Done for 166420 ms, from 13:07:49.03 to 13:10:35.45.

Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.

Exceptions occured during test work:

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 19 sp_kill_cost_storno 335544336 2016-01-17 10:07 2016-01-17 12:36
deadlock 4 sp_kill_qstorno_ret_qs2qd 335544336 2016-01-17 10:38 2016-01-17 12:08
deadlock 91 sp_lock_selected_doc 335544336 2016-01-17 10:03 2016-01-17 12:57
deadlock 16 sp_qd_handle_on_invoice_upd_sts 335544336 2016-01-17 10:04 2016-01-17 11:55
deadlock 2 x_lock_depdocs_on_canc_invoice 335544336 2016-01-17 09:57 2016-01-17 12:53
lock_conflict 10 sp_kill_cost_storno 335544345 2016-01-17 10:12 2016-01-17 12:53
lock_conflict 1 sp_kill_qstorno_ret_qs2qd 335544345 2016-01-17 11:33 2016-01-17 11:33
lock_conflict 3432 sp_lock_selected_doc 335544345 2016-01-17 09:57 2016-01-17 12:57
lock_conflict 140 sp_qd_handle_on_cancel_clo 335544345 2016-01-17 09:58 2016-01-17 12:56
lock_conflict 10 sp_qd_handle_on_invoice_upd_sts 335544345 2016-01-17 10:01 2016-01-17 12:39
lock_conflict 37 x_lock_depdocs_on_canc_invoice 335544345 2016-01-17 09:57 2016-01-17 11:53
lock_conflict 200 x_lock_depdocs_on_canc_sup_ord 335544345 2016-01-17 10:02 2016-01-17 12:57
Done for 5850 ms, from 13:10:38.90 to 13:10:44.75.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 195805
MON$OLDEST_ACTIVE 195806
MON$OLDEST_SNAPSHOT 195806
MON$NEXT_TRANSACTION 195806
MON$PAGE_BUFFERS 384
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 2015-12-11 10:02:47.3010
MON$PAGES 675257
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26963 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26963 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26963 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26963 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2

Database statistics, full


Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 200477
Page size 8192
ODS version 11.2
Oldest transaction 195807
Oldest active 195808
Oldest snapshot 195808
Next transaction 195809
Bumped transaction 1
Sequence number 0
Next attachment ID 4659
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 33.92, total records: 1381534
Average version length: 47.37, total versions: 386641, max versions: 1
Data pages: 14889, data page slots: 14889, average fill: 78%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 10
60 - 79% = 9869
80 - 99% = 5007

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 5690, nodes: 1381534
Average data length: 14.27, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 671
20 - 39% = 2
40 - 59% = 3139
60 - 79% = 17
80 - 99% = 1861

Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 3955, nodes: 1381534
Average data length: 5.66, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 3952
60 - 79% = 1
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 1907, nodes: 1381534
Average data length: 2.03, total dup: 915183, max dup: 49
Fill distribution:
0 - 19% = 192
20 - 39% = 0
40 - 59% = 931
60 - 79% = 0
80 - 99% = 784

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 56.67, total records: 333078
Average version length: 36.80, total versions: 51326, max versions: 3
Data pages: 4196, data page slots: 4196, average fill: 80%
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 8
60 - 79% = 2884
80 - 99% = 1299

Index DOC_LIST_ID_DESC (1)
Depth: 3, leaf buckets: 1181, nodes: 333078
Average data length: 6.02, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 514
40 - 59% = 637
60 - 79% = 27
80 - 99% = 3

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 365, nodes: 333078
Average data length: 0.01, total dup: 333028, max dup: 35366
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 300
60 - 79% = 45
80 - 99% = 20

Index PK_DOC_LIST (0)
Depth: 3, leaf buckets: 948, nodes: 333078
Average data length: 6.02, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 178
20 - 39% = 174
40 - 59% = 229
60 - 79% = 134
80 - 99% = 233

DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 64.31, total records: 400
Average version length: 14.47, total versions: 222274, max versions: 1474
Data pages: 925, data page slots: 925, average fill: 94%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 921

Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 0.86, total records: 22736
Average version length: 71.25, total versions: 22462, max versions: 1
Data pages: 359, data page slots: 359, average fill: 82%
Fill distribution:
0 - 19% = 13
20 - 39% = 17
40 - 59% = 23
60 - 79% = 35
80 - 99% = 271

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 65, nodes: 22736
Average data length: 8.64, total dup: 1151, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 35
60 - 79% = 21
80 - 99% = 7

MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 15.98, total records: 49
Average version length: 9.00, total versions: 3283, max versions: 2044
Data pages: 13, data page slots: 13, average fill: 83%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 11

Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 0.48, total records: 664
Average version length: 46.50, total versions: 657, max versions: 1
Data pages: 9, data page slots: 9, average fill: 74%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 6

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 1, leaf buckets: 1, nodes: 664
Average data length: 1.24, total dup: 599, max dup: 131
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 41.92, total records: 131270
Average version length: 35.35, total versions: 9557, max versions: 8
Data pages: 1395, data page slots: 1395, average fill: 73%
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 13
60 - 79% = 1323
80 - 99% = 54

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 108, nodes: 131270
Average data length: 0.01, total dup: 131221, max dup: 8033
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 54
60 - 79% = 27
80 - 99% = 24

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 140, nodes: 131270
Average data length: 0.92, total dup: 117786, max dup: 32
Fill distribution:
0 - 19% = 1
20 - 39% = 14
40 - 59% = 61
60 - 79% = 41
80 - 99% = 23

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 144, nodes: 131270
Average data length: 0.92, total dup: 117786, max dup: 32
Fill distribution:
0 - 19% = 1
20 - 39% = 25
40 - 59% = 52
60 - 79% = 38
80 - 99% = 28

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 145, nodes: 131270
Average data length: 0.70, total dup: 117786, max dup: 32
Fill distribution:
0 - 19% = 1
20 - 39% = 25
40 - 59% = 62
60 - 79% = 41
80 - 99% = 16

PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.87, total records: 117838
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 1006, data page slots: 1006, average fill: 64%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1005
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 85, nodes: 117838
Average data length: 0.00, total dup: 117648, max dup: 1523
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 27
60 - 79% = 41
80 - 99% = 16

PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 151.56, total records: 10414604
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 247022, data page slots: 247022, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 247021

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 10870, nodes: 10414604
Average data length: 0.17, total dup: 9154059, max dup: 72
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 4465
60 - 79% = 3972
80 - 99% = 2424

Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 11522, nodes: 10414604
Average data length: 0.00, total dup: 10414599, max dup: 10016898
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11519
60 - 79% = 2
80 - 99% = 1

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 12783, nodes: 10414604
Average data length: 0.11, total dup: 10245900, max dup: 36944
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 10222
60 - 79% = 1363
80 - 99% = 1194

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 13116, nodes: 10414604
Average data length: 0.07, total dup: 10393962, max dup: 1357654
Fill distribution:
0 - 19% = 15
20 - 39% = 2
40 - 59% = 11752
60 - 79% = 348
80 - 99% = 999

PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 41.97, total records: 225809
Average version length: 57.21, total versions: 58258, max versions: 1
Data pages: 2682, data page slots: 2682, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 1
60 - 79% = 1513
80 - 99% = 1166

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 253, nodes: 225809
Average data length: 1.05, total dup: 189675, max dup: 1369
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 121
60 - 79% = 90
80 - 99% = 39

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 221, nodes: 225809
Average data length: 0.60, total dup: 205808, max dup: 85
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 81
60 - 79% = 95
80 - 99% = 44

RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 5801, max versions: 3499
Data pages: 20, data page slots: 20, average fill: 92%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20

Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 97.51, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
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: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (163)
Primary pointer page: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 59.57, total records: 11326
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 140, data page slots: 140, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 139
80 - 99% = 0

WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 4.83, total records: 19570
Average version length: 72.20, total versions: 18261, max versions: 1
Data pages: 300, data page slots: 478, average fill: 85%
Fill distribution:
0 - 19% = 1
20 - 39% = 9
40 - 59% = 13
60 - 79% = 46
80 - 99% = 231

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 24, nodes: 19570
Average data length: 1.65, total dup: 17131, max dup: 14
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 10
60 - 79% = 7
80 - 99% = 4

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 67.76, total records: 408312
Average version length: 71.71, total versions: 24679, max versions: 1
Data pages: 5785, data page slots: 5814, average fill: 78%
Fill distribution:
0 - 19% = 18
20 - 39% = 33
40 - 59% = 31
60 - 79% = 4723
80 - 99% = 980

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 375, nodes: 408312
Average data length: 0.28, total dup: 391166, max dup: 119
Fill distribution:
0 - 19% = 3
20 - 39% = 60
40 - 59% = 93
60 - 79% = 58
80 - 99% = 161

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 462, nodes: 408312
Average data length: 1.29, total dup: 352833, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 148
60 - 79% = 179
80 - 99% = 130

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 34.90, total records: 142774
Average version length: 71.92, total versions: 73578, max versions: 1
Data pages: 2037, data page slots: 2187, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 12
60 - 79% = 428
80 - 99% = 1594

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 173, nodes: 142774
Average data length: 1.57, total dup: 120128, max dup: 47
Fill distribution:
0 - 19% = 3
20 - 39% = 4
40 - 59% = 63
60 - 79% = 73
80 - 99% = 30

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 11.89, total records: 4408903
Average version length: 70.88, total versions: 3682879, max versions: 1
Data pages: 60897, data page slots: 60897, average fill: 91%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 8421
80 - 99% = 52475

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 5745, nodes: 4408903
Average data length: 0.66, total dup: 4113220, max dup: 99
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 5446
60 - 79% = 136
80 - 99% = 161

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 0.39, total records: 39020
Average version length: 72.08, total versions: 38803, max versions: 1
Data pages: 649, data page slots: 1678, average fill: 79%
Fill distribution:
0 - 19% = 26
20 - 39% = 49
40 - 59% = 58
60 - 79% = 55
80 - 99% = 461

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 47, nodes: 39020
Average data length: 0.77, total dup: 37078, max dup: 99
Fill distribution:
0 - 19% = 1
20 - 39% = 10
40 - 59% = 22
60 - 79% = 13
80 - 99% = 1

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 30.81, total records: 2748050
Average version length: 70.46, total versions: 1556238, max versions: 1
Data pages: 37767, data page slots: 37770, average fill: 87%
Fill distribution:
0 - 19% = 9
20 - 39% = 17
40 - 59% = 6
60 - 79% = 4797
80 - 99% = 32938

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 4239, nodes: 2748050
Average data length: 1.67, total dup: 2237875, max dup: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 3950
60 - 79% = 159
80 - 99% = 124

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 77.44, total records: 2276369
Average version length: 83.27, total versions: 161037, max versions: 1
Data pages: 34486, data page slots: 34486, average fill: 82%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 6316
80 - 99% = 28169

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 2509, nodes: 2276369
Average data length: 0.15, total dup: 2225381, max dup: 189
Fill distribution:
0 - 19% = 16
20 - 39% = 1
40 - 59% = 1728
60 - 79% = 661
80 - 99% = 103

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 1711, nodes: 2276369
Average data length: 0.68, total dup: 1997249, max dup: 49
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 123
60 - 79% = 5
80 - 99% = 1577

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 2812, nodes: 2276369
Average data length: 0.69, total dup: 1996704, max dup: 55
Fill distribution:
0 - 19% = 24
20 - 39% = 1
40 - 59% = 1914
60 - 79% = 737
80 - 99% = 136

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 42.49, total records: 2359208
Average version length: 82.98, total versions: 1152392, max versions: 1
Data pages: 35713, data page slots: 35713, average fill: 88%
Fill distribution:
0 - 19% = 4
20 - 39% = 14
40 - 59% = 11
60 - 79% = 1785
80 - 99% = 33899

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2189, nodes: 2359208
Average data length: 0.10, total dup: 2327410, max dup: 654
Fill distribution:
0 - 19% = 5
20 - 39% = 3
40 - 59% = 811
60 - 79% = 848
80 - 99% = 522

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2392, nodes: 2359208
Average data length: 1.12, total dup: 1922563, max dup: 14
Fill distribution:
0 - 19% = 107
20 - 39% = 0
40 - 59% = 795
60 - 79% = 1
80 - 99% = 1489

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 2369, nodes: 2359208
Average data length: 0.41, total dup: 2193469, max dup: 138
Fill distribution:
0 - 19% = 29
20 - 39% = 4
40 - 59% = 893
60 - 79% = 876
80 - 99% = 567

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 40.99, total records: 4415287
Average version length: 84.39, total versions: 2247868, max versions: 1
Data pages: 67124, data page slots: 67124, average fill: 88%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 7041
80 - 99% = 60080

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 4149, nodes: 4415287
Average data length: 0.03, total dup: 4401769, max dup: 2358
Fill distribution:
0 - 19% = 4
20 - 39% = 19
40 - 59% = 1789
60 - 79% = 1507
80 - 99% = 830

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 3425, nodes: 4415287
Average data length: 0.38, total dup: 4115299, max dup: 49
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 691
60 - 79% = 115
80 - 99% = 2615

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 4445, nodes: 4415287
Average data length: 0.35, total dup: 4139222, max dup: 307
Fill distribution:
0 - 19% = 11
20 - 39% = 11
40 - 59% = 1774
60 - 79% = 1776
80 - 99% = 873

XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 45.16, total records: 2655922
Average version length: 83.29, total versions: 1214744, max versions: 1
Data pages: 40249, data page slots: 40256, average fill: 87%
Fill distribution:
0 - 19% = 5
20 - 39% = 18
40 - 59% = 19
60 - 79% = 1991
80 - 99% = 38216

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2616, nodes: 2655922
Average data length: 0.03, total dup: 2647275, max dup: 1779
Fill distribution:
0 - 19% = 7
20 - 39% = 43
40 - 59% = 1371
60 - 79% = 728
80 - 99% = 467

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2803, nodes: 2655922
Average data length: 1.12, total dup: 2164888, max dup: 14
Fill distribution:
0 - 19% = 114
20 - 39% = 80
40 - 59% = 927
60 - 79% = 128
80 - 99% = 1554

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 2835, nodes: 2655922
Average data length: 0.39, total dup: 2476166, max dup: 111
Fill distribution:
0 - 19% = 4
20 - 39% = 27
40 - 59% = 1527
60 - 79% = 772
80 - 99% = 505

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 41.42, total records: 414790
Average version length: 68.69, total versions: 165424, max versions: 1
Data pages: 5603, data page slots: 5603, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1772
80 - 99% = 3830

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 399, nodes: 414790
Average data length: 0.38, total dup: 391500, max dup: 171
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 158
60 - 79% = 143
80 - 99% = 98

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 458, nodes: 414790
Average data length: 0.91, total dup: 354948, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 197
60 - 79% = 186
80 - 99% = 75

ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 23560 ms, from 13:10:45.40 to 13:11:08.96.

Analyzing DB stat log: obtaining values of total records and versions

TABLE_NAME TOTAL_RECS TOTAL_VERS VERS_PERCENT
AGENTS 50 0 0.0000
BUSINESS_OPS 19 0 0.0000
DOC_DATA 1381534 386641 27.9863
DOC_LIST 333078 51326 15.4096
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 222274 55568.5000
INVNT_TURNOVER_LOG 22736 22462 98.7948
MONEY_SALDO 49 3283 6700.0000
MONEY_TURNOVER_LOG 664 657 98.9457
OPTYPES 9 0 0.0000
PDISTR 131270 9557 7.2804
PERF_ESTIMATED 117838 2 0.0016
PERF_LOG 10414604 1 0.0000
PSTORNED 225809 58258 25.7996
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 5801 145025.0000
SETTINGS 114 0 0.0000
TRACE_STAT 11326 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 19570 18261 93.3111
XQD_1000_3300 408312 24679 6.0441
XQD_1200_2000 142774 73578 51.5345
XQD_2000_3300 4408903 3682879 83.5327
XQD_2100_3300 39020 38803 99.4438
XQD_3300_3400 2748050 1556238 56.6306
XQS_1000_1200 2276369 161037 7.0742
XQS_1000_3300 2359208 1152392 48.8465
XQS_1200_2000 4415287 2247868 50.9110
XQS_2100_3300 2655922 1214744 45.7371
XQS_3300_3400 414790 165424 39.8813
Z_USED_VIEWS 32 0 0.0000
Done for 2650 ms, from 13:11:18.91 to 13:11:21.56.

Database validation

13:11:21.94 Validation started

13:11:21.94 Relation 140 (DOC_LIST)
13:11:21.94 process pointer page 0 of 3
13:11:22.03 process pointer page 1 of 3
13:11:22.15 process pointer page 2 of 3
13:11:22.19 Index 1 (PK_DOC_LIST)
13:11:22.31 Index 2 (DOC_LIST_ID_DESC)
13:11:22.39 Index 3 (FK_DOC_LIST_AGENTS)
13:11:22.44 Relation 140 (DOC_LIST) is ok

13:11:22.44 Relation 141 (DOC_DATA)
13:11:22.44 process pointer page 0 of 8
13:11:22.47 process pointer page 1 of 8
13:11:22.51 process pointer page 2 of 8
13:11:22.56 process pointer page 3 of 8
13:11:22.59 process pointer page 4 of 8
13:11:22.67 process pointer page 5 of 8
13:11:22.81 process pointer page 6 of 8
13:11:22.87 process pointer page 7 of 8
13:11:22.90 Index 2 (DOC_DATA_DOC_WARE_UNQ)
13:11:23.26 Index 3 (DOC_DATA_ID_DESC)
13:11:23.56 Index 4 (FK_DOC_DATA_DOC_LIST)
13:11:23.78 Relation 141 (DOC_DATA) is ok

13:11:23.78 Relation 147 (INVNT_SALDO)
13:11:23.78 process pointer page 0 of 1
13:11:25.13 Index 1 (PK_INVNT_SALDO)
13:11:25.13 Relation 147 (INVNT_SALDO) is ok

13:11:25.13 Relation 150 (PDISTR)
13:11:25.13 process pointer page 0 of 1
13:11:25.18 Index 2 (PDISTR_SND_ID)
13:11:25.20 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
13:11:25.20 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
13:11:25.21 Index 5 (PDISTR_AGENT_ID)
13:11:25.23 Relation 150 (PDISTR) is ok

13:11:25.23 Relation 151 (PSTORNED)
13:11:25.23 process pointer page 0 of 2
13:11:25.26 process pointer page 1 of 2
13:11:25.29 Index 2 (PSTORNED_SND_ID)
13:11:25.31 Index 3 (PSTORNED_RCV_ID)
13:11:25.32 Relation 151 (PSTORNED) is ok

13:11:25.32 Relation 156 (SEMAPHORES)
13:11:25.32 process pointer page 0 of 1
13:11:25.32 Index 1 (PK_SEMAPHORES)
13:11:25.32 Index 2 (SEMAPHORES_TASK_UNQ)
13:11:25.32 Relation 156 (SEMAPHORES) is ok

13:11:25.32 Relation 157 (INVNT_TURNOVER_LOG)
13:11:25.32 process pointer page 0 of 1
13:11:25.32 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
13:11:25.34 Relation 157 (INVNT_TURNOVER_LOG) is ok

13:11:25.34 Relation 160 (PERF_ESTIMATED)
13:11:25.34 process pointer page 0 of 1
13:11:25.35 Index 1 (PERF_EST_MINUTE_SINCE_START)
13:11:25.35 Relation 160 (PERF_ESTIMATED) is ok

13:11:25.35 Relation 161 (PERF_ISQL_STAT)
13:11:25.35 process pointer page 0 of 1
13:11:25.35 Index 1 (PERF_ISQL_STAT_TRN)
13:11:25.35 Relation 161 (PERF_ISQL_STAT) is ok

13:11:25.35 Relation 162 (PERF_LOG)
13:11:25.35 process pointer page 0 of 129
13:11:25.38 process pointer page 1 of 129
13:11:25.46 process pointer page 2 of 129
13:11:25.51 process pointer page 3 of 129
13:11:25.54 process pointer page 4 of 129
13:11:25.62 process pointer page 5 of 129
13:11:25.68 process pointer page 6 of 129
13:11:25.76 process pointer page 7 of 129
13:11:25.84 process pointer page 8 of 129
13:11:25.91 process pointer page 9 of 129
13:11:25.98 process pointer page 10 of 129
13:11:26.01 process pointer page 11 of 129
13:11:26.04 process pointer page 12 of 129
13:11:26.07 process pointer page 13 of 129
13:11:26.12 process pointer page 14 of 129
13:11:26.19 process pointer page 15 of 129
13:11:26.21 process pointer page 16 of 129
13:11:26.24 process pointer page 17 of 129
13:11:26.27 process pointer page 18 of 129
13:11:26.30 process pointer page 19 of 129
13:11:26.32 process pointer page 20 of 129
13:11:26.38 process pointer page 21 of 129
13:11:26.46 process pointer page 22 of 129
13:11:26.53 process pointer page 23 of 129
13:11:26.60 process pointer page 24 of 129
13:11:26.66 process pointer page 25 of 129
13:11:26.74 process pointer page 26 of 129
13:11:26.76 process pointer page 27 of 129
13:11:26.79 process pointer page 28 of 129
13:11:26.82 process pointer page 29 of 129
13:11:26.83 process pointer page 30 of 129
13:11:26.86 process pointer page 31 of 129
13:11:26.90 process pointer page 32 of 129
13:11:26.91 process pointer page 33 of 129
13:11:26.96 process pointer page 34 of 129
13:11:27.02 process pointer page 35 of 129
13:11:27.08 process pointer page 36 of 129
13:11:27.16 process pointer page 37 of 129
13:11:27.22 process pointer page 38 of 129
13:11:27.25 process pointer page 39 of 129
13:11:27.29 process pointer page 40 of 129
13:11:27.32 process pointer page 41 of 129
13:11:27.33 process pointer page 42 of 129
13:11:27.37 process pointer page 43 of 129
13:11:27.40 process pointer page 44 of 129
13:11:27.42 process pointer page 45 of 129
13:11:27.44 process pointer page 46 of 129
13:11:27.47 process pointer page 47 of 129
13:11:27.49 process pointer page 48 of 129
13:11:27.51 process pointer page 49 of 129
13:11:27.54 process pointer page 50 of 129
13:11:27.55 process pointer page 51 of 129
13:11:27.57 process pointer page 52 of 129
13:11:27.60 process pointer page 53 of 129
13:11:27.62 process pointer page 54 of 129
13:11:27.64 process pointer page 55 of 129
13:11:27.65 process pointer page 56 of 129
13:11:27.68 process pointer page 57 of 129
13:11:27.71 process pointer page 58 of 129
13:11:27.75 process pointer page 59 of 129
13:11:27.76 process pointer page 60 of 129
13:11:27.78 process pointer page 61 of 129
13:11:27.79 process pointer page 62 of 129
13:11:27.82 process pointer page 63 of 129
13:11:27.84 process pointer page 64 of 129
13:11:27.86 process pointer page 65 of 129
13:11:27.87 process pointer page 66 of 129
13:11:27.91 process pointer page 67 of 129
13:11:27.95 process pointer page 68 of 129
13:11:28.02 process pointer page 69 of 129
13:11:28.08 process pointer page 70 of 129
13:11:28.11 process pointer page 71 of 129
13:11:28.14 process pointer page 72 of 129
13:11:28.17 process pointer page 73 of 129
13:11:28.19 process pointer page 74 of 129
13:11:28.22 process pointer page 75 of 129
13:11:28.25 process pointer page 76 of 129
13:11:28.27 process pointer page 77 of 129
13:11:28.29 process pointer page 78 of 129
13:11:28.32 process pointer page 79 of 129
13:11:28.34 process pointer page 80 of 129
13:11:28.36 process pointer page 81 of 129
13:11:28.39 process pointer page 82 of 129
13:11:28.41 process pointer page 83 of 129
13:11:28.43 process pointer page 84 of 129
13:11:28.44 process pointer page 85 of 129
13:11:28.46 process pointer page 86 of 129
13:11:28.48 process pointer page 87 of 129
13:11:28.50 process pointer page 88 of 129
13:11:28.52 process pointer page 89 of 129
13:11:28.54 process pointer page 90 of 129
13:11:28.56 process pointer page 91 of 129
13:11:28.58 process pointer page 92 of 129
13:11:28.60 process pointer page 93 of 129
13:11:28.62 process pointer page 94 of 129
13:11:28.65 process pointer page 95 of 129
13:11:28.67 process pointer page 96 of 129
13:11:28.69 process pointer page 97 of 129
13:11:28.72 process pointer page 98 of 129
13:11:28.74 process pointer page 99 of 129
13:11:28.76 process pointer page 100 of 129
13:11:28.78 process pointer page 101 of 129
13:11:28.80 process pointer page 102 of 129
13:11:28.82 process pointer page 103 of 129
13:11:28.85 process pointer page 104 of 129
13:11:28.87 process pointer page 105 of 129
13:11:28.93 process pointer page 106 of 129
13:11:29.00 process pointer page 107 of 129
13:11:29.07 process pointer page 108 of 129
13:11:29.14 process pointer page 109 of 129
13:11:29.21 process pointer page 110 of 129
13:11:29.27 process pointer page 111 of 129
13:11:29.35 process pointer page 112 of 129
13:11:29.36 process pointer page 113 of 129
13:11:29.39 process pointer page 114 of 129
13:11:29.42 process pointer page 115 of 129
13:11:29.46 process pointer page 116 of 129
13:11:29.47 process pointer page 117 of 129
13:11:29.55 process pointer page 118 of 129
13:11:29.61 process pointer page 119 of 129
13:11:29.69 process pointer page 120 of 129
13:11:29.75 process pointer page 121 of 129
13:11:29.81 process pointer page 122 of 129
13:11:29.89 process pointer page 123 of 129
13:11:29.92 process pointer page 124 of 129
13:11:29.94 process pointer page 125 of 129
13:11:29.97 process pointer page 126 of 129
13:11:30.00 process pointer page 127 of 129
13:11:30.03 process pointer page 128 of 129
13:11:30.05 Index 1 (PERF_LOG_DTS_BEG_DESC)
13:11:32.39 Index 2 (PERF_LOG_UNIT)
13:11:34.85 Index 3 (PERF_LOG_TRN_DESC)
13:11:35.84 Index 4 (PERF_LOG_GDSCODE)
13:11:36.91 Relation 162 (PERF_LOG) is ok

13:11:36.91 Relation 166 (V_STOPTEST)
13:11:36.91 Relation 166 (V_STOPTEST) is ok

13:11:36.91 Relation 183 (V_QDISTR_SOURCE)
13:11:36.91 Relation 183 (V_QDISTR_SOURCE) is ok

13:11:36.91 Relation 184 (V_QSTORNED_SOURCE)
13:11:36.91 Relation 184 (V_QSTORNED_SOURCE) is ok

13:11:36.91 Relation 258 (XQD_1000_1200)
13:11:36.91 process pointer page 0 of 1
13:11:36.94 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
13:11:36.96 Relation 258 (XQD_1000_1200) is ok

13:11:36.96 Relation 259 (XQD_1200_2000)
13:11:36.96 process pointer page 0 of 2
13:11:37.02 process pointer page 1 of 2
13:11:37.02 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
13:11:37.07 Relation 259 (XQD_1200_2000) is ok

13:11:37.07 Relation 260 (XQD_1000_3300)
13:11:37.07 process pointer page 0 of 4
13:11:37.10 process pointer page 1 of 4
13:11:37.15 process pointer page 2 of 4
13:11:37.18 process pointer page 3 of 4
13:11:37.18 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
13:11:37.24 Index 2 (XQD_1000_3300_DOC)
13:11:37.29 Relation 260 (XQD_1000_3300) is ok

13:11:37.29 Relation 261 (XQD_2000_3300)
13:11:37.29 process pointer page 0 of 32
13:11:37.33 process pointer page 1 of 32
13:11:37.40 process pointer page 2 of 32
13:11:37.43 process pointer page 3 of 32
13:11:37.47 process pointer page 4 of 32
13:11:37.54 process pointer page 5 of 32
13:11:37.60 process pointer page 6 of 32
13:11:37.66 process pointer page 7 of 32
13:11:37.83 process pointer page 8 of 32
13:11:37.93 process pointer page 9 of 32
13:11:38.10 process pointer page 10 of 32
13:11:38.19 process pointer page 11 of 32
13:11:38.25 process pointer page 12 of 32
13:11:38.30 process pointer page 13 of 32
13:11:38.36 process pointer page 14 of 32
13:11:38.41 process pointer page 15 of 32
13:11:38.46 process pointer page 16 of 32
13:11:38.50 process pointer page 17 of 32
13:11:38.53 process pointer page 18 of 32
13:11:38.58 process pointer page 19 of 32
13:11:38.63 process pointer page 20 of 32
13:11:38.66 process pointer page 21 of 32
13:11:38.71 process pointer page 22 of 32
13:11:38.75 process pointer page 23 of 32
13:11:38.78 process pointer page 24 of 32
13:11:38.85 process pointer page 25 of 32
13:11:38.99 process pointer page 26 of 32
13:11:39.06 process pointer page 27 of 32
13:11:39.14 process pointer page 28 of 32
13:11:39.27 process pointer page 29 of 32
13:11:39.31 process pointer page 30 of 32
13:11:39.36 process pointer page 31 of 32
13:11:39.39 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
13:11:40.03 Relation 261 (XQD_2000_3300) is ok

13:11:40.03 Relation 262 (XQD_2100_3300)
13:11:40.03 process pointer page 0 of 2
13:11:40.08 process pointer page 1 of 2
13:11:40.08 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
13:11:40.09 Relation 262 (XQD_2100_3300) is ok

13:11:40.09 Relation 263 (XQD_3300_3400)
13:11:40.09 process pointer page 0 of 20
13:11:40.23 process pointer page 1 of 20
13:11:40.30 process pointer page 2 of 20
13:11:40.34 process pointer page 3 of 20
13:11:40.41 process pointer page 4 of 20
13:11:40.44 process pointer page 5 of 20
13:11:40.48 process pointer page 6 of 20
13:11:40.53 process pointer page 7 of 20
13:11:40.56 process pointer page 8 of 20
13:11:40.61 process pointer page 9 of 20
13:11:40.64 process pointer page 10 of 20
13:11:40.69 process pointer page 11 of 20
13:11:40.72 process pointer page 12 of 20
13:11:40.77 process pointer page 13 of 20
13:11:40.83 process pointer page 14 of 20
13:11:40.87 process pointer page 15 of 20
13:11:40.95 process pointer page 16 of 20
13:11:41.05 process pointer page 17 of 20
13:11:41.14 process pointer page 18 of 20
13:11:41.19 process pointer page 19 of 20
13:11:41.22 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
13:11:41.76 Relation 263 (XQD_3300_3400) is ok

13:11:41.76 Relation 264 (XQS_1000_1200)
13:11:41.76 process pointer page 0 of 18
13:11:41.79 process pointer page 1 of 18
13:11:41.84 process pointer page 2 of 18
13:11:41.90 process pointer page 3 of 18
13:11:41.95 process pointer page 4 of 18
13:11:42.01 process pointer page 5 of 18
13:11:42.06 process pointer page 6 of 18
13:11:42.15 process pointer page 7 of 18
13:11:42.22 process pointer page 8 of 18
13:11:42.25 process pointer page 9 of 18
13:11:42.28 process pointer page 10 of 18
13:11:42.33 process pointer page 11 of 18
13:11:42.36 process pointer page 12 of 18
13:11:42.39 process pointer page 13 of 18
13:11:42.42 process pointer page 14 of 18
13:11:42.45 process pointer page 15 of 18
13:11:42.48 process pointer page 16 of 18
13:11:42.50 process pointer page 17 of 18
13:11:42.53 Index 1 (XQS_1000_1200_DOC_ID)
13:11:43.07 Index 2 (XQS_1000_1200_SND_ID)
13:11:43.50 Index 3 (XQS_1000_1200_RCV_ID)
13:11:43.76 Relation 264 (XQS_1000_1200) is ok

13:11:43.76 Relation 265 (XQS_1200_2000)
13:11:43.76 process pointer page 0 of 35
13:11:43.81 process pointer page 1 of 35
13:11:43.89 process pointer page 2 of 35
13:11:43.98 process pointer page 3 of 35
13:11:44.04 process pointer page 4 of 35
13:11:44.09 process pointer page 5 of 35
13:11:44.12 process pointer page 6 of 35
13:11:44.18 process pointer page 7 of 35
13:11:44.29 process pointer page 8 of 35
13:11:44.35 process pointer page 9 of 35
13:11:44.43 process pointer page 10 of 35
13:11:44.48 process pointer page 11 of 35
13:11:44.54 process pointer page 12 of 35
13:11:44.59 process pointer page 13 of 35
13:11:44.73 process pointer page 14 of 35
13:11:44.82 process pointer page 15 of 35
13:11:44.87 process pointer page 16 of 35
13:11:44.99 process pointer page 17 of 35
13:11:45.13 process pointer page 18 of 35
13:11:45.27 process pointer page 19 of 35
13:11:45.34 process pointer page 20 of 35
13:11:45.45 process pointer page 21 of 35
13:11:45.51 process pointer page 22 of 35
13:11:45.55 process pointer page 23 of 35
13:11:45.60 process pointer page 24 of 35
13:11:45.63 process pointer page 25 of 35
13:11:45.74 process pointer page 26 of 35
13:11:45.79 process pointer page 27 of 35
13:11:45.84 process pointer page 28 of 35
13:11:45.88 process pointer page 29 of 35
13:11:45.96 process pointer page 30 of 35
13:11:45.99 process pointer page 31 of 35
13:11:46.04 process pointer page 32 of 35
13:11:46.08 process pointer page 33 of 35
13:11:46.12 process pointer page 34 of 35
13:11:46.16 Index 1 (XQS_1200_2000_DOC_ID)
13:11:47.21 Index 2 (XQS_1200_2000_SND_ID)
13:11:47.86 Index 3 (XQS_1200_2000_RCV_ID)
13:11:48.44 Relation 265 (XQS_1200_2000) is ok

13:11:48.44 Relation 266 (XQS_1000_3300)
13:11:48.44 process pointer page 0 of 19
13:11:48.52 process pointer page 1 of 19
13:11:48.57 process pointer page 2 of 19
13:11:48.61 process pointer page 3 of 19
13:11:48.64 process pointer page 4 of 19
13:11:48.69 process pointer page 5 of 19
13:11:48.74 process pointer page 6 of 19
13:11:48.77 process pointer page 7 of 19
13:11:48.81 process pointer page 8 of 19
13:11:48.85 process pointer page 9 of 19
13:11:48.88 process pointer page 10 of 19
13:11:48.92 process pointer page 11 of 19
13:11:48.96 process pointer page 12 of 19
13:11:49.00 process pointer page 13 of 19
13:11:49.05 process pointer page 14 of 19
13:11:49.10 process pointer page 15 of 19
13:11:49.13 process pointer page 16 of 19
13:11:49.17 process pointer page 17 of 19
13:11:49.20 process pointer page 18 of 19
13:11:49.22 Index 1 (XQS_1000_3300_DOC_ID)
13:11:49.42 Index 2 (XQS_1000_3300_SND_ID)
13:11:49.63 Index 3 (XQS_1000_3300_RCV_ID)
13:11:49.78 Relation 266 (XQS_1000_3300) is ok

13:11:49.78 Relation 267 (XQS_2000_3300)
13:11:49.78 process pointer page 0 of 1
13:11:49.78 Index 1 (XQS_2000_3300_DOC_ID)
13:11:49.78 Index 2 (XQS_2000_3300_SND_ID)
13:11:49.78 Index 3 (XQS_2000_3300_RCV_ID)
13:11:49.78 Relation 267 (XQS_2000_3300) is ok

13:11:49.78 Relation 268 (XQS_2100_3300)
13:11:49.78 process pointer page 0 of 21
13:11:49.81 process pointer page 1 of 21
13:11:49.89 process pointer page 2 of 21
13:11:49.97 process pointer page 3 of 21
13:11:50.05 process pointer page 4 of 21
13:11:50.11 process pointer page 5 of 21
13:11:50.23 process pointer page 6 of 21
13:11:50.36 process pointer page 7 of 21
13:11:50.48 process pointer page 8 of 21
13:11:50.61 process pointer page 9 of 21
13:11:50.67 process pointer page 10 of 21
13:11:50.72 process pointer page 11 of 21
13:11:50.76 process pointer page 12 of 21
13:11:50.81 process pointer page 13 of 21
13:11:50.86 process pointer page 14 of 21
13:11:50.91 process pointer page 15 of 21
13:11:50.94 process pointer page 16 of 21
13:11:50.98 process pointer page 17 of 21
13:11:51.03 process pointer page 18 of 21
13:11:51.12 process pointer page 19 of 21
13:11:51.17 process pointer page 20 of 21
13:11:51.20 Index 1 (XQS_2100_3300_DOC_ID)
13:11:51.59 Index 2 (XQS_2100_3300_SND_ID)
13:11:51.84 Index 3 (XQS_2100_3300_RCV_ID)
13:11:52.03 Relation 268 (XQS_2100_3300) is ok

13:11:52.03 Relation 269 (XQS_3300_3400)
13:11:52.03 process pointer page 0 of 3
13:11:52.06 process pointer page 1 of 3
13:11:52.09 process pointer page 2 of 3
13:11:52.14 Index 1 (XQS_3300_3400_DOC_ID)
13:11:52.25 Index 2 (XQS_3300_3400_SND_ID)
13:11:52.37 Relation 269 (XQS_3300_3400) is ok

13:11:52.37 Relation 276 (TRACE_STAT)
13:11:52.37 process pointer page 0 of 1
13:11:52.37 Relation 276 (TRACE_STAT) is ok

13:11:52.37 Validation finished
Done for 30810 ms, from 13:11:21.58 to 13:11:52.39.

Differences between old and current firebird.log

13:11:53.53. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 5 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-01-17 13:11 309 oltp25_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

Comparison of old and new firebird.log (get messages that appeared during test):

+++ Start of comparison +++
result: files match. No new messages appeared in firebird.log during test ran.
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.oltp25


Remove 32 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.oltp25\oltp25_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-01-17 13:11:59.96 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html

Subscribe to IBSurgeon news

Subscribe