Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 10. 2016-01-18 5:11:39.27.
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-18 05:11:05.2590 -1 <null> 127.0.0.1 185365 4578 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: 9947.71 1653 1790587 2016-01-18 02:11 2016-01-18 05:11
customer order: creation 174.87 60 31477 2016-01-18 02:11 2016-01-18 05:11
customer order: refuse 13.81 39 2486 2016-01-18 02:11 2016-01-18 05:11
order to supplier: creation 45.03 209 8106 2016-01-18 02:11 2016-01-18 05:11
order to supplier: removal 1.65 12288 295 2016-01-18 02:11 2016-01-18 05:11
invoice (draft): creation 44.48 421 8007 2016-01-18 02:11 2016-01-18 05:11
invoice (draft): removal 25.74 114 4634 2016-01-18 02:11 2016-01-18 05:11
invoice accept: apply 25.47 14865 4560 2016-01-18 02:11 2016-01-18 05:11
invoice accept: cancel 11.82 568 2115 2016-01-18 02:11 2016-01-18 05:11
customer reserve: creation 8419.34 39 1515481 2016-01-18 02:11 2016-01-18 05:11
customer reserve: removal 921.78 17 165921 2016-01-18 02:11 2016-01-18 05:11
realization accept: apply 80.65 66 14517 2016-01-18 02:11 2016-01-18 05:11
realization accept: cancel 38.64 33 6955 2016-01-18 02:11 2016-01-18 05:11
payment from customer: creation 58.98 92 10616 2016-01-18 02:11 2016-01-18 05:11
payment from customer: removal 5.76 30 1037 2016-01-18 02:11 2016-01-18 05:11
payment to supplier: creation 48.31 136 8695 2016-01-18 02:11 2016-01-18 05:11
payment to supplier: removal 3.56 32 640 2016-01-18 02:11 2016-01-18 05:11
service: total inventory turnovers 17.02 156 3064 2016-01-18 02:11 2016-01-18 05:11
service: total monetary turnovers 10.94 4 1970 2016-01-18 02:11 2016-01-18 05:11
service: refresh index statistics 0.07 2243 11 2016-01-18 02:11 2016-01-18 05:11
Done for 79540 ms, from 5:13:09.00 to 5:14:28.54.

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 7673 143758 138106 5652 3.93 02:11:06 02:29:06
interval # 2, overall 2 9407 173334 169328 4006 2.31 02:29:07 02:47:07
interval # 3, overall 3 11330 206406 203936 2470 1.20 02:47:08 03:05:08
interval # 4, overall 4 3764 67883 67743 140 0.21 03:05:09 03:23:09
interval # 5, overall 5 11615 211370 209078 2292 1.08 03:23:10 03:41:10
interval # 6, overall 6 9086 164185 163544 641 0.39 03:41:11 03:59:11
interval # 7, overall 7 9305 172016 167495 4521 2.63 03:59:12 04:17:12
interval # 8, overall 8 13090 242984 235619 7365 3.03 04:17:13 04:35:13
interval # 9, overall 9 12148 225506 218656 6850 3.04 04:35:14 04:53:14
interval # 10, overall 10 12060 225411 217082 8329 3.70 04:53:15 05:11:15
Done for 156620 ms, from 5:16:57.37 to 5:19:33.99.

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 2631.34 0.9082 1.0785 123 4
WARM_TIME 2 1626.25 0.8860 1.0579 107 3
WARM_TIME 3 1591.49 0.7209 1.1726 689 8
WARM_TIME 4 1697.54 0.8247 1.1566 938 9
WARM_TIME 5 1872.97 0.8387 1.1244 848 10
WARM_TIME 6 1826.63 0.9607 1.0477 336 5
WARM_TIME 7 1682.55 0.9750 1.0165 88 4
WARM_TIME 8 1541.09 0.9894 1.0054 85 2
WARM_TIME 9 1501.09 0.9403 1.0719 237 7
WARM_TIME 10 1843.23 0.7857 1.2277 1428 10
TEST_TIME 11 2409.25 0.8588 1.1431 835 10
TEST_TIME 12 2875.10 0.8852 1.0723 732 10
TEST_TIME 13 2905.50 0.9795 1.0316 404 9
TEST_TIME 14 3117.83 0.8927 1.0768 748 10
TEST_TIME 15 3290.72 0.9522 1.0396 787 10
TEST_TIME 16 3367.20 0.9541 1.0487 399 10
TEST_TIME 17 3466.49 0.9659 1.0517 419 10
TEST_TIME 18 3686.81 0.9354 1.0735 689 10
TEST_TIME 19 3933.73 0.9532 1.0586 838 10
TEST_TIME 20 4200.16 0.9419 1.0430 616 10
TEST_TIME 21 4477.46 0.9318 1.0517 805 10
TEST_TIME 22 4674.36 0.9616 1.0386 568 10
TEST_TIME 23 4797.57 0.9680 1.0411 856 10
TEST_TIME 24 5012.32 0.9558 1.0416 772 10
TEST_TIME 25 5288.34 0.9477 1.0439 941 10
TEST_TIME 26 5363.85 0.9944 1.0114 190 7
TEST_TIME 27 5473.71 0.9566 1.0365 739 10
TEST_TIME 28 5522.75 0.9921 1.0069 195 9
TEST_TIME 29 5454.34 0.9856 1.0101 284 9
TEST_TIME 30 5595.49 0.9518 1.0424 1131 10
TEST_TIME 31 5855.99 0.9639 1.0346 928 10
TEST_TIME 32 6068.43 0.9672 1.0371 847 10
TEST_TIME 33 6331.21 0.9640 1.0325 804 10
TEST_TIME 34 6388.08 0.9932 1.0066 202 9
TEST_TIME 35 6281.61 0.9950 1.0081 189 6
TEST_TIME 36 6293.63 0.9782 1.0254 481 10
TEST_TIME 37 6485.18 0.9683 1.0270 866 10
TEST_TIME 38 6526.93 0.9936 1.0055 288 8
TEST_TIME 39 6544.52 0.9771 1.0214 538 10
TEST_TIME 40 6688.71 0.9744 1.0280 1026 10
TEST_TIME 41 6883.83 0.9759 1.0264 724 10
TEST_TIME 42 7001.34 0.9852 1.0203 739 10
TEST_TIME 43 7165.22 0.9749 1.0148 817 10
TEST_TIME 44 7125.70 0.9974 1.0028 173 6
TEST_TIME 45 7054.63 0.9914 1.0103 282 8
TEST_TIME 46 7040.80 0.9919 1.0103 305 10
TEST_TIME 47 7028.45 0.9905 1.0131 329 10
TEST_TIME 48 7097.11 0.9824 1.0184 672 10
TEST_TIME 49 7209.37 0.9821 1.0229 817 10
TEST_TIME 50 7344.36 0.9840 1.0125 903 10
TEST_TIME 51 7406.54 0.9843 1.0161 592 10
TEST_TIME 52 7451.64 0.9909 1.0088 388 10
TEST_TIME 53 7481.12 0.9869 1.0127 635 10
TEST_TIME 54 7566.70 0.9827 1.0156 695 10
TEST_TIME 55 7588.96 0.9942 1.0045 223 10
TEST_TIME 56 7626.77 0.9817 1.0193 787 10
TEST_TIME 57 7751.86 0.9858 1.0149 1016 10
TEST_TIME 58 7846.90 0.9854 1.0146 984 10
TEST_TIME 59 7927.24 0.9873 1.0144 812 10
TEST_TIME 60 7997.78 0.9887 1.0118 855 10
TEST_TIME 61 8049.51 0.9889 1.0106 952 10
TEST_TIME 62 8117.65 0.9860 1.0130 597 10
TEST_TIME 63 8200.32 0.9869 1.0137 768 10
TEST_TIME 64 8277.23 0.9886 1.0110 707 10
TEST_TIME 65 8346.40 0.9872 1.0107 799 10
TEST_TIME 66 8382.52 0.9911 1.0126 765 10
TEST_TIME 67 8442.70 0.9904 1.0086 783 10
TEST_TIME 68 8414.66 0.9971 1.0028 307 10
TEST_TIME 69 8334.47 0.9981 1.0019 295 6
TEST_TIME 70 8244.49 0.9984 1.0010 91 5
TEST_TIME 71 8151.00 0.9995 1.0008 93 3
TEST_TIME 72 8065.18 0.9989 1.0011 17 3
TEST_TIME 73 7970.94 0.9992 1.0003 58 3
TEST_TIME 74 7870.22 0.9996 1.0001 51 2
TEST_TIME 75 7769.53 1.0000 1.0000 2 1
TEST_TIME 76 7675.50 0.9995 1.0003 23 2
TEST_TIME 77 7592.02 0.9991 1.0006 34 3
TEST_TIME 78 7506.04 0.9996 1.0008 22 2
TEST_TIME 79 7424.55 0.9990 1.0009 45 4
TEST_TIME 80 7358.58 0.9974 1.0023 255 5
TEST_TIME 81 7293.46 0.9992 1.0008 111 3
TEST_TIME 82 7307.16 0.9881 1.0106 806 10
TEST_TIME 83 7334.88 0.9946 1.0056 410 10
TEST_TIME 84 7296.82 0.9989 1.0027 186 6
TEST_TIME 85 7289.68 0.9924 1.0085 359 10
TEST_TIME 86 7351.80 0.9883 1.0138 1090 10
TEST_TIME 87 7469.34 0.9864 1.0126 852 10
TEST_TIME 88 7548.51 0.9906 1.0132 819 10
TEST_TIME 89 7605.31 0.9944 1.0057 670 10
TEST_TIME 90 7658.15 0.9878 1.0077 758 10
TEST_TIME 91 7670.35 0.9951 1.0055 361 10
TEST_TIME 92 7688.29 0.9925 1.0078 724 10
TEST_TIME 93 7762.70 0.9874 1.0101 655 10
TEST_TIME 94 7806.97 0.9936 1.0078 761 10
TEST_TIME 95 7848.79 0.9918 1.0087 662 10
TEST_TIME 96 7906.91 0.9909 1.0112 621 10
TEST_TIME 97 7983.54 0.9912 1.0073 672 10
TEST_TIME 98 8018.12 0.9928 1.0075 689 10
TEST_TIME 99 8043.07 0.9943 1.0066 629 10
TEST_TIME 100 8032.87 0.9978 1.0023 298 9
TEST_TIME 101 7982.32 0.9987 1.0012 218 7
TEST_TIME 102 7922.86 0.9994 1.0005 161 3
TEST_TIME 103 7861.19 0.9985 1.0012 128 4
TEST_TIME 104 7828.40 0.9964 1.0034 455 7
TEST_TIME 105 7811.95 0.9965 1.0031 443 7
TEST_TIME 106 7850.86 0.9887 1.0084 1141 10
TEST_TIME 107 7904.37 0.9924 1.0083 609 10
TEST_TIME 108 7957.86 0.9922 1.0099 663 10
TEST_TIME 109 8013.83 0.9936 1.0085 795 10
TEST_TIME 110 8078.20 0.9914 1.0092 737 10
TEST_TIME 111 8133.70 0.9932 1.0063 754 10
TEST_TIME 112 8156.38 0.9945 1.0060 575 10
TEST_TIME 113 8185.32 0.9935 1.0084 670 10
TEST_TIME 114 8217.07 0.9956 1.0060 743 10
TEST_TIME 115 8236.03 0.9950 1.0074 749 10
TEST_TIME 116 8274.94 0.9940 1.0046 481 10
TEST_TIME 117 8245.83 0.9997 1.0001 14 2
TEST_TIME 118 8184.77 0.9991 1.0011 57 5
TEST_TIME 119 8141.44 0.9982 1.0007 140 6
TEST_TIME 120 8103.15 0.9974 1.0027 281 8
TEST_TIME 121 8127.33 0.9915 1.0053 542 10
TEST_TIME 122 8150.48 0.9942 1.0069 868 10
TEST_TIME 123 8201.61 0.9925 1.0080 726 10
TEST_TIME 124 8252.55 0.9937 1.0050 723 10
TEST_TIME 125 8308.35 0.9902 1.0055 577 10
TEST_TIME 126 8346.81 0.9929 1.0069 569 10
TEST_TIME 127 8401.06 0.9925 1.0068 566 10
TEST_TIME 128 8434.86 0.9950 1.0046 759 10
TEST_TIME 129 8450.19 0.9950 1.0054 527 10
TEST_TIME 130 8495.19 0.9924 1.0056 631 10
TEST_TIME 131 8522.78 0.9947 1.0075 638 10
TEST_TIME 132 8534.74 0.9985 1.0012 163 7
TEST_TIME 133 8482.68 0.9997 1.0000 18 2
TEST_TIME 134 8423.32 0.9999 1.0000 11 1
TEST_TIME 135 8366.54 0.9994 1.0009 62 4
TEST_TIME 136 8318.79 0.9995 1.0006 27 3
TEST_TIME 137 8340.11 0.9908 1.0060 763 10
TEST_TIME 138 8376.53 0.9943 1.0058 805 10
TEST_TIME 139 8416.35 0.9938 1.0044 825 10
TEST_TIME 140 8451.66 0.9931 1.0047 695 10
TEST_TIME 141 8482.89 0.9939 1.0056 761 10
TEST_TIME 142 8516.06 0.9946 1.0031 747 9
TEST_TIME 143 8518.85 0.9958 1.0056 495 9
TEST_TIME 144 8555.74 0.9946 1.0043 648 10
TEST_TIME 145 8593.80 0.9930 1.0058 683 10
TEST_TIME 146 8626.24 0.9951 1.0061 689 10
TEST_TIME 147 8681.93 0.9928 1.0041 777 10
TEST_TIME 148 8707.24 0.9944 1.0047 774 10
TEST_TIME 149 8744.53 0.9937 1.0052 687 10
TEST_TIME 150 8772.54 0.9953 1.0051 724 10
TEST_TIME 151 8803.73 0.9949 1.0064 606 10
TEST_TIME 152 8848.99 0.9947 1.0046 664 10
TEST_TIME 153 8894.45 0.9935 1.0037 473 10
TEST_TIME 154 8912.09 0.9953 1.0037 725 10
TEST_TIME 155 8936.92 0.9952 1.0041 591 10
TEST_TIME 156 8954.39 0.9957 1.0035 697 10
TEST_TIME 157 8974.81 0.9948 1.0048 568 10
TEST_TIME 158 8988.08 0.9969 1.0049 476 9
TEST_TIME 159 9022.41 0.9948 1.0039 615 10
TEST_TIME 160 9050.99 0.9944 1.0045 700 10
TEST_TIME 161 9075.99 0.9955 1.0054 794 10
TEST_TIME 162 9110.65 0.9954 1.0045 719 9
TEST_TIME 163 9134.01 0.9958 1.0044 748 10
TEST_TIME 164 9160.87 0.9954 1.0034 690 10
TEST_TIME 165 9194.82 0.9936 1.0044 657 10
TEST_TIME 166 9219.04 0.9957 1.0039 856 10
TEST_TIME 167 9226.77 0.9970 1.0037 625 10
TEST_TIME 168 9224.27 0.9980 1.0006 380 7
TEST_TIME 169 9194.99 0.9978 1.0045 572 10
TEST_TIME 170 9219.32 0.9960 1.0035 770 10
TEST_TIME 171 9223.11 0.9972 1.0030 558 9
TEST_TIME 172 9231.44 0.9962 1.0043 637 10
TEST_TIME 173 9252.63 0.9962 1.0038 695 10
TEST_TIME 174 9257.39 0.9975 1.0042 678 10
TEST_TIME 175 9277.89 0.9963 1.0037 807 9
TEST_TIME 176 9303.25 0.9952 1.0043 677 10
TEST_TIME 177 9320.08 0.9969 1.0046 535 9
TEST_TIME 178 9344.13 0.9964 1.0035 714 10
TEST_TIME 179 9364.03 0.9957 1.0042 469 9
TEST_TIME 180 9405.76 0.9942 1.0042 670 10
TEST_TIME 181 9433.08 0.9957 1.0027 720 10
TEST_TIME 182 9435.31 0.9970 1.0035 701 10
TEST_TIME 183 9451.39 0.9963 1.0033 726 10
TEST_TIME 184 9459.95 0.9970 1.0035 667 10
TEST_TIME 185 9470.84 0.9969 1.0035 673 10
TEST_TIME 186 9483.69 0.9968 1.0043 557 10
TEST_TIME 187 9510.16 0.9962 1.0025 482 10
TEST_TIME 188 9514.15 0.9968 1.0032 563 10
TEST_TIME 189 9521.09 0.9972 1.0027 698 10
TEST_TIME 190 9502.73 0.9993 1.0006 81 10
Done for 12190 ms, from 5:19:35.00 to 5:19:47.19.

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 38808 45813 56254 77848 73558 49508 93341 52664 23745 42772 53590 50214 75760 66143 224277 42879 555055 333695 <null> 02:11:06 02:29:06
fetches per second 2 31960 56695 49350 68385 62752 84918 142448 67699 39409 26991 45207 37276 69706 27084 245803 47293 320905 254733 <null> 02:29:07 02:47:07
fetches per second 3 32958 48104 51192 126829 74184 105636 151923 70387 27949 32202 36017 22368 80992 54281 250987 37309 455188 256350 <null> 02:47:08 03:05:08
fetches per second 4 29975 57079 48217 33064 71772 153423 121922 75622 22006 45997 34273 25949 65988 21859 223916 15304 530830 737249 <null> 03:05:09 03:23:09
fetches per second 5 31190 36647 50608 102352 70231 92414 163700 50830 22760 36925 42022 25943 65590 23794 236479 32197 462361 225143 <null> 03:23:10 03:41:10
fetches per second 6 45635 48371 53290 61036 86361 45740 152859 57169 31206 31452 48975 29836 91287 23428 239383 50670 641185 200313 <null> 03:41:11 03:59:11
fetches per second 7 31325 40210 49673 85621 87023 <null> 175922 58186 28836 21376 42335 20257 65477 20706 188702 41205 378595 266176 <null> 03:59:12 04:17:12
fetches per second 8 27637 43619 46537 72111 66351 111739 252896 65641 22951 28540 29679 17467 62420 20650 146077 29379 393970 228363 1677 04:17:13 04:35:13
fetches per second 9 26409 29240 43015 98738 59028 111149 195414 41446 25178 25123 28246 13222 57607 25880 110100 20599 369141 182183 <null> 04:35:14 04:53:14
fetches per second 10 26874 36762 41466 65524 63679 75850 202531 52523 20896 25621 29154 17477 54801 18830 96244 25895 495697 148221 <null> 04:53:15 05:11:15
marks per second 1 7181 4537 9761 8633 13076 7678 3199 5962 2337 5205 8245 6908 4311 9536 3275 4689 24063 17259 <null> 02:11:06 02:29:06
marks per second 2 5799 5698 8807 8720 11711 12599 3653 8178 4961 3458 6612 4632 3790 3174 2526 5341 19006 17070 <null> 02:29:07 02:47:07
marks per second 3 6028 5267 9099 23094 13858 18943 3389 7545 2650 4260 5146 2892 3364 6394 2146 4249 18806 16449 <null> 02:47:08 03:05:08
marks per second 4 5531 6588 8421 3990 12873 29269 2253 7239 2636 4608 5092 2942 2474 2381 3638 1884 14630 28905 <null> 03:05:09 03:23:09
marks per second 5 5732 3658 8555 14120 12667 17075 3370 5038 2103 4375 4197 2957 2688 3578 2292 3892 16817 10708 <null> 03:23:10 03:41:10
marks per second 6 8074 5442 8861 6214 14068 9802 3233 5902 3600 3711 5046 3845 3292 2472 4210 5346 19285 10997 <null> 03:41:11 03:59:11
marks per second 7 5651 4482 8595 9558 13286 <null> 3214 5677 4145 2224 4651 2502 2799 2274 3113 6627 18403 14460 <null> 03:59:12 04:17:12
marks per second 8 5058 4579 7672 6679 11167 21483 3222 6434 1821 3163 3551 2092 2898 2137 3355 3418 14669 7997 174 04:17:13 04:35:13
marks per second 9 4743 3165 7220 10228 9882 21802 3128 4410 2771 2576 3376 1571 2647 2586 3721 2345 16846 9615 <null> 04:35:14 04:53:14
marks per second 10 4880 4274 7300 7702 10335 14844 3274 5260 1908 2797 2990 1942 1935 1949 3889 3192 13345 6961 <null> 04:53:15 05:11:15
reads/fetches*100 1 8 7 5 2 3 5 3 3 7 8 9 7 7 6 4 7 1 2 <null> 02:11:06 02:29:06
reads/fetches*100 2 9 7 4 2 4 5 2 3 7 8 10 8 8 7 3 6 1 2 <null> 02:29:07 02:47:07
reads/fetches*100 3 9 8 5 2 4 5 2 2 8 9 11 10 8 7 3 7 1 2 <null> 02:47:08 03:05:08
reads/fetches*100 4 10 7 5 3 4 2 2 2 7 8 11 11 9 8 3 9 1 1 <null> 03:05:09 03:23:09
reads/fetches*100 5 9 9 5 2 4 4 2 3 9 9 11 10 9 9 4 7 1 2 <null> 03:23:10 03:41:10
reads/fetches*100 6 9 8 5 2 5 5 2 3 8 9 12 11 9 9 4 8 1 2 <null> 03:41:11 03:59:11
reads/fetches*100 7 10 8 6 2 5 <null> 2 2 9 11 12 10 10 10 5 7 1 2 <null> 03:59:12 04:17:12
reads/fetches*100 8 10 8 5 1 5 4 1 2 8 10 12 11 10 10 6 8 1 2 4 04:17:13 04:35:13
reads/fetches*100 9 10 10 5 1 5 3 2 3 7 11 13 12 9 9 7 7 1 2 <null> 04:35:14 04:53:14
reads/fetches*100 10 10 9 5 2 5 3 2 2 7 10 13 10 10 9 8 7 1 2 <null> 04:53:15 05:11:15
writes/marks*100 1 10 13 7 3 7 1 3 3 10 5 6 10 2 0 5 0 10 4 <null> 02:11:06 02:29:06
writes/marks*100 2 10 14 7 2 6 4 3 3 9 5 7 12 2 0 5 0 10 4 <null> 02:29:07 02:47:07
writes/marks*100 3 10 14 7 2 7 2 3 2 11 6 7 11 5 1 5 0 13 2 <null> 02:47:08 03:05:08
writes/marks*100 4 10 16 7 3 8 1 3 2 9 7 7 9 6 0 5 0 15 2 <null> 03:05:09 03:23:09
writes/marks*100 5 10 15 8 2 7 3 3 2 10 6 8 11 6 0 5 0 11 2 <null> 03:23:10 03:41:10
writes/marks*100 6 11 14 7 2 8 2 3 3 8 5 9 8 8 0 4 1 12 5 <null> 03:41:11 03:59:11
writes/marks*100 7 11 13 9 3 8 <null> 3 2 13 7 8 12 7 0 5 0 12 1 <null> 03:59:12 04:17:12
writes/marks*100 8 10 15 7 2 8 1 3 2 11 6 8 10 6 0 4 0 12 2 1 04:17:13 04:35:13
writes/marks*100 9 11 13 7 2 8 4 3 2 7 6 8 10 6 1 3 0 14 3 <null> 04:35:14 04:53:14
writes/marks*100 10 11 14 7 3 8 3 3 2 8 8 8 15 7 0 4 0 14 5 <null> 04:53:15 05:11:15
Done for 11160 ms, from 5:19:48.84 to 5:20:00.00.

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 1038348 999939 38409 3.69 0 1310 4 38409 2016-01-18 02:11 2016-01-18 05:11
doc_list_biud 1038522 999939 38583 3.71 0 14586 4 38583 2016-01-18 02:11 2016-01-18 05:11
sp_add_invoice_to_stock 7577 4560 3017 39.81 47 726276 14865 3017 2016-01-18 02:11 2016-01-18 05:11
sp_cancel_adding_invoice 2352 2115 237 10.07 0 15462 568 237 2016-01-18 02:11 2016-01-18 05:11
sp_cancel_client_order 2614 2486 128 4.89 0 374 39 128 2016-01-18 02:11 2016-01-18 05:11
sp_cancel_customer_reserve 201645 165921 35724 17.71 0 2293 17 35724 2016-01-18 02:11 2016-01-18 05:11
sp_cancel_pay_from_customer 1041 1037 4 0.38 0 203 30 4 2016-01-18 02:11 2016-01-18 05:11
sp_cancel_pay_to_supplier 642 640 2 0.31 0 249 32 2 2016-01-18 02:11 2016-01-18 05:11
sp_cancel_supplier_invoice 5110 4634 476 9.31 0 920 114 476 2016-01-18 02:11 2016-01-18 05:11
sp_cancel_supplier_order 555 295 260 46.84 16 77110 12288 260 2016-01-18 02:11 2016-01-18 05:11
sp_cancel_write_off 9249 6955 2294 24.80 0 734 33 2294 2016-01-18 02:11 2016-01-18 05:11
sp_client_order 31477 31477 0 0.00 0 1326 60 0 2016-01-18 02:11 2016-01-18 05:11
sp_customer_reserve 1515481 1515481 0 0.00 0 4087 39 0 2016-01-18 02:11 2016-01-18 05:11
sp_fill_shopping_cart 47590 47590 0 0.00 0 1415 13 0 2016-01-18 02:11 2016-01-18 05:11
sp_fill_shopping_cart_clo_res 1515481 1515481 0 0.00 0 1123 1 0 2016-01-18 02:11 2016-01-18 05:11
sp_get_clo_for_invoice 4560 4560 0 0.00 0 1592 146 0 2016-01-18 02:11 2016-01-18 05:11
sp_kill_cost_storno 13226 10747 2479 18.74 0 375 7 2479 2016-01-18 02:11 2016-01-18 05:11
sp_kill_qstorno_ret_qs2qd 417661 343726 73935 17.70 0 2277 8 73935 2016-01-18 02:11 2016-01-18 05:11
sp_kill_qty_storno 240058 201483 38575 16.06 0 14586 19 38575 2016-01-18 02:11 2016-01-18 05:11
sp_lock_selected_doc 30777 26954 3823 12.42 0 147 0 3823 2016-01-18 02:11 2016-01-18 05:11
sp_make_cost_storno 38388 38388 0 0.00 0 1295 44 0 2016-01-18 02:11 2016-01-18 05:11
sp_multiply_rows_for_pdistr 38388 38388 0 0.00 0 1108 12 0 2016-01-18 02:11 2016-01-18 05:11
sp_multiply_rows_for_qdistr 31477 31477 0 0.00 0 811 21 0 2016-01-18 02:11 2016-01-18 05:11
sp_pay_from_customer 10616 10616 0 0.00 15 1388 92 0 2016-01-18 02:11 2016-01-18 05:11
sp_pay_to_supplier 8695 8695 0 0.00 16 1451 136 0 2016-01-18 02:11 2016-01-18 05:11
sp_payment_common 19311 19311 0 0.00 0 1123 19 0 2016-01-18 02:11 2016-01-18 05:11
sp_qd_handle_on_cancel_clo 2614 2486 128 4.89 0 187 12 128 2016-01-18 02:11 2016-01-18 05:11
sp_qd_handle_on_invoice_upd_sts 6888 6675 213 3.09 0 14586 120 213 2016-01-18 02:11 2016-01-18 05:11
sp_qd_handle_on_reserve_upd_sts 14517 14517 0 0.00 0 702 8 0 2016-01-18 02:11 2016-01-18 05:11
sp_reserve_write_off 14641 14517 124 0.84 0 1217 66 124 2016-01-18 02:11 2016-01-18 05:11
sp_supplier_invoice 8007 8007 0 0.00 15 2855 421 0 2016-01-18 02:11 2016-01-18 05:11
sp_supplier_order 8106 8106 0 0.00 0 1326 209 0 2016-01-18 02:11 2016-01-18 05:11
srv_find_qd_qs_mism 628635 590217 38418 6.11 0 889 3 38418 2016-01-18 02:11 2016-01-18 05:11
srv_make_invnt_saldo 3064 3064 0 0.00 0 3463 156 0 2016-01-18 02:11 2016-01-18 05:11
srv_make_money_saldo 1970 1970 0 0.00 0 109 4 0 2016-01-18 02:11 2016-01-18 05:11
srv_recalc_idx_stat 11 11 0 0.00 1341 3401 2243 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_add_invoice_to_stock 3017 3017 0 0.00 0 508 15 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_cancel_adding_invoice 90 90 0 0.00 0 218 39 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_cancel_client_order 128 128 0 0.00 0 109 18 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_cancel_customer_reserve 9 9 0 0.00 0 62 12 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_cancel_pay_from_customer 4 4 0 0.00 0 4 1 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_cancel_pay_to_supplier 2 2 0 0.00 16 16 16 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_cancel_supplier_invoice 247 247 0 0.00 0 187 14 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_cancel_supplier_order 4460 4460 0 0.00 0 452 61 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_cancel_write_off 6 6 0 0.00 0 31 7 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-abend:sp_reserve_write_off 124 124 0 0.00 0 125 17 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_add_invoice_to_stock 4569 4569 0 0.00 0 22777 1741 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_cancel_adding_invoice 580 580 0 0.00 0 5327 568 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_cancel_client_order 2486 2486 0 0.00 0 297 24 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_cancel_customer_reserve 1011 1011 0 0.00 0 187 25 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_cancel_pay_from_customer 1037 1037 0 0.00 0 203 20 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_cancel_pay_to_supplier 640 640 0 0.00 0 187 20 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_cancel_supplier_invoice 377 377 0 0.00 0 203 27 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_cancel_supplier_order 295 295 0 0.00 0 36487 3519 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_cancel_write_off 1451 1451 0 0.00 0 468 23 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_client_order 31477 31477 0 0.00 0 1311 29 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_customer_reserve 1462 1462 0 0.00 0 203 19 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_pay_from_customer 10616 10616 0 0.00 0 734 20 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_pay_to_supplier 8695 8695 0 0.00 0 952 19 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_reserve_write_off 14517 14517 0 0.00 0 624 25 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_supplier_invoice 8008 8008 0 0.00 0 1326 28 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:sp_supplier_order 8106 8106 0 0.00 0 562 28 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:srv_make_invnt_saldo 3064 3064 0 0.00 0 171 11 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:srv_make_money_saldo 1970 1970 0 0.00 0 156 8 0 2016-01-18 02:11 2016-01-18 05:11
t$perf-norm:srv_recalc_idx_stat 11 11 0 0.00 0 219 59 0 2016-01-18 02:11 2016-01-18 05:11
v_add_invoice_to_stock 15154 9120 6034 39.81 0 125 1 6034 2016-01-18 02:11 2016-01-18 05:11
v_all_customers 47228 47228 0 0.00 0 32 0 0 2016-01-18 02:11 2016-01-18 05:11
v_all_suppliers 32226 32226 0 0.00 0 31 0 0 2016-01-18 02:11 2016-01-18 05:11
v_all_wares 62954 62954 0 0.00 0 62 0 0 2016-01-18 02:11 2016-01-18 05:11
v_cancel_adding_invoice 1212 1160 52 4.29 0 172 13 52 2016-01-18 02:11 2016-01-18 05:11
v_cancel_client_order 5228 4972 256 4.89 0 327 1 256 2016-01-18 02:11 2016-01-18 05:11
v_cancel_customer_prepayment 2082 2074 8 0.38 0 47 1 8 2016-01-18 02:11 2016-01-18 05:11
v_cancel_customer_reserve 2040 2022 18 0.88 0 125 2 18 2016-01-18 02:11 2016-01-18 05:11
v_cancel_payment_to_supplier 1284 1280 4 0.31 0 46 1 4 2016-01-18 02:11 2016-01-18 05:11
v_cancel_supplier_invoice 1248 754 494 39.58 0 63 2 494 2016-01-18 02:11 2016-01-18 05:11
v_cancel_supplier_order 1110 590 520 46.84 0 21 1 520 2016-01-18 02:11 2016-01-18 05:11
v_cancel_write_off 2914 2902 12 0.41 0 141 9 12 2016-01-18 02:11 2016-01-18 05:11
v_max_id_clo_ord 8106 8106 0 0.00 0 172 0 0 2016-01-18 02:11 2016-01-18 05:11
v_max_id_clo_res 1462 1462 0 0.00 0 109 4 0 2016-01-18 02:11 2016-01-18 05:11
v_max_id_ord_sup 8007 8007 0 0.00 0 78 0 0 2016-01-18 02:11 2016-01-18 05:11
v_max_non_paid_invoice 8695 8695 0 0.00 0 78 1 0 2016-01-18 02:11 2016-01-18 05:11
v_max_non_paid_realizn 10616 10616 0 0.00 0 156 6 0 2016-01-18 02:11 2016-01-18 05:11
v_min_id_clo_ord 8106 8106 0 0.00 0 483 3 0 2016-01-18 02:11 2016-01-18 05:11
v_min_id_clo_res 1462 1462 0 0.00 0 203 1 0 2016-01-18 02:11 2016-01-18 05:11
v_min_id_ord_sup 8007 8007 0 0.00 0 266 2 0 2016-01-18 02:11 2016-01-18 05:11
v_min_non_paid_invoice 8695 8695 0 0.00 0 1123 11 0 2016-01-18 02:11 2016-01-18 05:11
v_min_non_paid_realizn 10616 10616 0 0.00 0 842 10 0 2016-01-18 02:11 2016-01-18 05:11
v_our_firm 15726 15726 0 0.00 0 16 0 0 2016-01-18 02:11 2016-01-18 05:11
v_reserve_write_off 29282 29034 248 0.84 0 374 1 248 2016-01-18 02:11 2016-01-18 05:11
x_lock_depdocs_on_canc_invoice 7496 6372 1124 14.99 0 140 5 1124 2016-01-18 02:11 2016-01-18 05:11
x_lock_depdocs_on_canc_sup_ord 555 295 260 46.84 0 141 9 260 2016-01-18 02:11 2016-01-18 05:11
x_make_qstorno_1000_1200 8106 8106 0 0.00 0 1233 163 0 2016-01-18 02:11 2016-01-18 05:11
x_make_qstorno_1200_2000 8008 8008 0 0.00 0 2808 383 0 2016-01-18 02:11 2016-01-18 05:11
x_make_qstorno_2100_3300 1515482 1515482 0 0.00 0 4071 33 0 2016-01-18 02:11 2016-01-18 05:11
Done for 207420 ms, from 5:23:31.36 to 5:26:58.78.

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 11 sp_kill_cost_storno 335544336 2016-01-18 02:12 2016-01-18 04:58
deadlock 74 sp_lock_selected_doc 335544336 2016-01-18 02:11 2016-01-18 05:06
deadlock 16 sp_qd_handle_on_invoice_upd_sts 335544336 2016-01-18 02:11 2016-01-18 04:11
deadlock 1 x_lock_depdocs_on_canc_sup_ord 335544336 2016-01-18 04:07 2016-01-18 04:07
lock_conflict 7 sp_kill_cost_storno 335544345 2016-01-18 02:24 2016-01-18 05:06
lock_conflict 3335 sp_lock_selected_doc 335544345 2016-01-18 02:11 2016-01-18 05:10
lock_conflict 128 sp_qd_handle_on_cancel_clo 335544345 2016-01-18 02:11 2016-01-18 05:10
lock_conflict 17 sp_qd_handle_on_invoice_upd_sts 335544345 2016-01-18 02:11 2016-01-18 04:50
lock_conflict 37 x_lock_depdocs_on_canc_invoice 335544345 2016-01-18 02:11 2016-01-18 05:10
lock_conflict 196 x_lock_depdocs_on_canc_sup_ord 335544345 2016-01-18 02:14 2016-01-18 05:10
Done for 6190 ms, from 5:27:01.56 to 5:27:07.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 185639
MON$OLDEST_ACTIVE 185640
MON$OLDEST_SNAPSHOT 185640
MON$NEXT_TRANSACTION 185640
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 658873
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 190278
Page size 8192
ODS version 11.2
Oldest transaction 185641
Oldest active 185642
Oldest snapshot 185642
Next transaction 185643
Bumped transaction 1
Sequence number 0
Next attachment ID 4626
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.65, total records: 1322234
Average version length: 47.35, total versions: 377747, max versions: 1
Data pages: 14250, data page slots: 14250, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 6
60 - 79% = 9366
80 - 99% = 4877

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 5443, nodes: 1322234
Average data length: 14.19, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 647
20 - 39% = 1
40 - 59% = 3013
60 - 79% = 14
80 - 99% = 1768

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

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 1825, nodes: 1322234
Average data length: 1.99, total dup: 885063, max dup: 49
Fill distribution:
0 - 19% = 170
20 - 39% = 1
40 - 59% = 932
60 - 79% = 0
80 - 99% = 722

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 57.40, total records: 313638
Average version length: 36.66, total versions: 40410, max versions: 3
Data pages: 3943, data page slots: 3943, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 1
60 - 79% = 2973
80 - 99% = 964

Index DOC_LIST_ID_DESC (1)
Depth: 3, leaf buckets: 1118, nodes: 313638
Average data length: 6.05, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 504
40 - 59% = 580
60 - 79% = 27
80 - 99% = 6

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 338, nodes: 313638
Average data length: 0.01, total dup: 313588, max dup: 33534
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 278
60 - 79% = 31
80 - 99% = 28

Index PK_DOC_LIST (0)
Depth: 3, leaf buckets: 887, nodes: 313638
Average data length: 6.05, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 149
20 - 39% = 169
40 - 59% = 218
60 - 79% = 128
80 - 99% = 223

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: 67.65, total records: 400
Average version length: 14.68, total versions: 256675, max versions: 1360
Data pages: 1046, data page slots: 1046, average fill: 96%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1045

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: 2.92, total records: 12300
Average version length: 70.76, total versions: 11796, max versions: 1
Data pages: 215, data page slots: 311, average fill: 74%
Fill distribution:
0 - 19% = 3
20 - 39% = 18
40 - 59% = 50
60 - 79% = 24
80 - 99% = 120

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 54, nodes: 12300
Average data length: 8.71, total dup: 1203, max dup: 1
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 22
60 - 79% = 2
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 14.84, total records: 49
Average version length: 9.00, total versions: 3103, max versions: 1302
Data pages: 12, data page slots: 12, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 10

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: 2.25, total records: 393
Average version length: 46.97, total versions: 374, max versions: 1
Data pages: 6, data page slots: 6, average fill: 67%
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 1, leaf buckets: 1, nodes: 393
Average data length: 2.05, total dup: 337, max dup: 69
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.98, total records: 114865
Average version length: 35.19, total versions: 7767, max versions: 12
Data pages: 1264, data page slots: 1265, average fill: 70%
Fill distribution:
0 - 19% = 9
20 - 39% = 38
40 - 59% = 33
60 - 79% = 1174
80 - 99% = 10

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 97, nodes: 114865
Average data length: 0.01, total dup: 114816, max dup: 4436
Fill distribution:
0 - 19% = 0
20 - 39% = 11
40 - 59% = 45
60 - 79% = 28
80 - 99% = 13

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 120, nodes: 114865
Average data length: 0.90, total dup: 103358, max dup: 46
Fill distribution:
0 - 19% = 0
20 - 39% = 13
40 - 59% = 48
60 - 79% = 42
80 - 99% = 17

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 114, nodes: 114865
Average data length: 0.90, total dup: 103358, max dup: 46
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 40
60 - 79% = 35
80 - 99% = 27

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 130, nodes: 114865
Average data length: 0.68, total dup: 103358, max dup: 46
Fill distribution:
0 - 19% = 2
20 - 39% = 25
40 - 59% = 57
60 - 79% = 40
80 - 99% = 6

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

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 77, nodes: 109362
Average data length: 0.00, total dup: 109171, max dup: 1427
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 24
60 - 79% = 33
80 - 99% = 20

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.53, total records: 9744709
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 231151, data page slots: 231151, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 231150

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 10158, nodes: 9744709
Average data length: 0.18, total dup: 8498878, max dup: 73
Fill distribution:
0 - 19% = 10
20 - 39% = 0
40 - 59% = 4241
60 - 79% = 3671
80 - 99% = 2236

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

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 11889, nodes: 9744709
Average data length: 0.11, total dup: 9584385, max dup: 38143
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 9543
60 - 79% = 1214
80 - 99% = 1132

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 12161, nodes: 9744709
Average data length: 0.07, total dup: 9724810, max dup: 1289178
Fill distribution:
0 - 19% = 10
20 - 39% = 2
40 - 59% = 10872
60 - 79% = 334
80 - 99% = 943

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: 43.84, total records: 196281
Average version length: 56.47, total versions: 43455, max versions: 1
Data pages: 2325, data page slots: 2325, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1426
80 - 99% = 898

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 225, nodes: 196281
Average data length: 1.23, total dup: 159408, max dup: 410
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 113
60 - 79% = 77
80 - 99% = 35

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 195, nodes: 196281
Average data length: 0.64, total dup: 177679, max dup: 175
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 86
60 - 79% = 80
80 - 99% = 29

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: 4676, max versions: 3196
Data pages: 17, data page slots: 17, average fill: 88%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 16

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.63, total records: 10638
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 132, data page slots: 132, average fill: 76%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 131
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: 2.46, total records: 8282
Average version length: 72.06, total versions: 8000, max versions: 1
Data pages: 187, data page slots: 402, average fill: 60%
Fill distribution:
0 - 19% = 34
20 - 39% = 23
40 - 59% = 22
60 - 79% = 42
80 - 99% = 66

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 14, nodes: 8282
Average data length: 2.28, total dup: 7233, max dup: 14
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 8
60 - 79% = 3
80 - 99% = 0

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 68.21, total records: 398154
Average version length: 71.29, total versions: 20879, max versions: 1
Data pages: 5577, data page slots: 5577, average fill: 79%
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 6
60 - 79% = 4786
80 - 99% = 780

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 373, nodes: 398154
Average data length: 0.27, total dup: 381723, max dup: 119
Fill distribution:
0 - 19% = 0
20 - 39% = 58
40 - 59% = 120
60 - 79% = 52
80 - 99% = 143

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 445, nodes: 398154
Average data length: 1.28, total dup: 344918, max dup: 25
Fill distribution:
0 - 19% = 4
20 - 39% = 14
40 - 59% = 109
60 - 79% = 183
80 - 99% = 135

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 41.18, total records: 107028
Average version length: 71.77, total versions: 45863, max versions: 1
Data pages: 1542, data page slots: 2096, average fill: 82%
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 35
60 - 79% = 265
80 - 99% = 1232

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 131, nodes: 107028
Average data length: 1.53, total dup: 90741, max dup: 44
Fill distribution:
0 - 19% = 1
20 - 39% = 10
40 - 59% = 56
60 - 79% = 42
80 - 99% = 22

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 10.90, total records: 4450864
Average version length: 70.96, total versions: 3778922, max versions: 1
Data pages: 61525, data page slots: 61525, average fill: 91%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7814
80 - 99% = 53709

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 5730, nodes: 4450864
Average data length: 0.64, total dup: 4163160, max dup: 99
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 5435
60 - 79% = 139
80 - 99% = 155

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 32.91, total records: 35804
Average version length: 71.73, total versions: 18780, max versions: 1
Data pages: 494, data page slots: 768, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 5
60 - 79% = 121
80 - 99% = 368

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 41, nodes: 35804
Average data length: 1.72, total dup: 30467, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 18
60 - 79% = 13
80 - 99% = 9

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 30.83, total records: 2704566
Average version length: 70.39, total versions: 1532381, max versions: 1
Data pages: 37158, data page slots: 37162, average fill: 87%
Fill distribution:
0 - 19% = 3
20 - 39% = 5
40 - 59% = 1
60 - 79% = 4709
80 - 99% = 32440

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 4120, nodes: 2704566
Average data length: 1.64, total dup: 2213715, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 3829
60 - 79% = 140
80 - 99% = 150

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 77.68, total records: 2169524
Average version length: 83.27, total versions: 146648, max versions: 1
Data pages: 32856, data page slots: 32856, average fill: 82%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6384
80 - 99% = 26471

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 2392, nodes: 2169524
Average data length: 0.15, total dup: 2120869, max dup: 186
Fill distribution:
0 - 19% = 17
20 - 39% = 0
40 - 59% = 1632
60 - 79% = 651
80 - 99% = 92

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 1635, nodes: 2169524
Average data length: 0.68, total dup: 1903976, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 133
60 - 79% = 5
80 - 99% = 1494

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 2689, nodes: 2169524
Average data length: 0.69, total dup: 1903477, max dup: 51
Fill distribution:
0 - 19% = 30
20 - 39% = 0
40 - 59% = 1798
60 - 79% = 750
80 - 99% = 111

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 41.39, total records: 2302993
Average version length: 82.69, total versions: 1157662, max versions: 1
Data pages: 34847, data page slots: 34851, average fill: 88%
Fill distribution:
0 - 19% = 3
20 - 39% = 5
40 - 59% = 3
60 - 79% = 1303
80 - 99% = 33533

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2125, nodes: 2302993
Average data length: 0.09, total dup: 2272591, max dup: 626
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 774
60 - 79% = 855
80 - 99% = 491

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2347, nodes: 2302993
Average data length: 1.09, total dup: 1884584, max dup: 14
Fill distribution:
0 - 19% = 123
20 - 39% = 0
40 - 59% = 791
60 - 79% = 1
80 - 99% = 1432

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 2336, nodes: 2302993
Average data length: 0.40, total dup: 2145587, max dup: 146
Fill distribution:
0 - 19% = 38
20 - 39% = 4
40 - 59% = 867
60 - 79% = 934
80 - 99% = 493

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 39.27, total records: 4403126
Average version length: 84.49, total versions: 2332508, max versions: 1
Data pages: 66965, data page slots: 66965, average fill: 89%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6885
80 - 99% = 60079

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 4124, nodes: 4403126
Average data length: 0.03, total dup: 4390214, max dup: 2499
Fill distribution:
0 - 19% = 8
20 - 39% = 17
40 - 59% = 1772
60 - 79% = 1464
80 - 99% = 863

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 3446, nodes: 4403126
Average data length: 0.37, total dup: 4112991, max dup: 49
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 748
60 - 79% = 110
80 - 99% = 2581

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 4419, nodes: 4403126
Average data length: 0.34, total dup: 4141109, max dup: 355
Fill distribution:
0 - 19% = 6
20 - 39% = 12
40 - 59% = 1894
60 - 79% = 1573
80 - 99% = 934

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: 44.36, total records: 2597044
Average version length: 83.05, total versions: 1215392, max versions: 1
Data pages: 39352, data page slots: 39352, average fill: 87%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 2
60 - 79% = 1476
80 - 99% = 37871

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2543, nodes: 2597044
Average data length: 0.03, total dup: 2588862, max dup: 2247
Fill distribution:
0 - 19% = 6
20 - 39% = 42
40 - 59% = 1307
60 - 79% = 726
80 - 99% = 462

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2734, nodes: 2597044
Average data length: 1.09, total dup: 2125563, max dup: 14
Fill distribution:
0 - 19% = 125
20 - 39% = 46
40 - 59% = 920
60 - 79% = 111
80 - 99% = 1532

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 2763, nodes: 2597044
Average data length: 0.38, total dup: 2427570, max dup: 143
Fill distribution:
0 - 19% = 1
20 - 39% = 22
40 - 59% = 1461
60 - 79% = 804
80 - 99% = 475

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 36.50, total records: 395426
Average version length: 68.64, total versions: 185959, max versions: 1
Data pages: 5342, data page slots: 5342, average fill: 85%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1338
80 - 99% = 4002

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 384, nodes: 395426
Average data length: 0.38, total dup: 373417, max dup: 115
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 153
60 - 79% = 144
80 - 99% = 87

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 433, nodes: 395426
Average data length: 0.91, total dup: 338690, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 173
60 - 79% = 180
80 - 99% = 79

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 16340 ms, from 5:27:08.73 to 5:27:25.07.

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 1322234 377747 28.5688
DOC_LIST 313638 40410 12.8842
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 256675 64168.7500
INVNT_TURNOVER_LOG 12300 11796 95.9024
MONEY_SALDO 49 3103 6332.6530
MONEY_TURNOVER_LOG 393 374 95.1653
OPTYPES 9 0 0.0000
PDISTR 114865 7767 6.7618
PERF_ESTIMATED 109362 2 0.0018
PERF_LOG 9744709 1 0.0000
PSTORNED 196281 43455 22.1391
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 4676 116900.0000
SETTINGS 114 0 0.0000
TRACE_STAT 10638 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 8282 8000 96.5950
XQD_1000_3300 398154 20879 5.2439
XQD_1200_2000 107028 45863 42.8514
XQD_2000_3300 4450864 3778922 84.9031
XQD_2100_3300 35804 18780 52.4522
XQD_3300_3400 2704566 1532381 56.6590
XQS_1000_1200 2169524 146648 6.7594
XQS_1000_3300 2302993 1157662 50.2677
XQS_1200_2000 4403126 2332508 52.9739
XQS_2100_3300 2597044 1215392 46.7990
XQS_3300_3400 395426 185959 47.0275
Z_USED_VIEWS 32 0 0.0000
Done for 2730 ms, from 5:27:33.88 to 5:27:36.61.

Database validation

05:27:37.03 Validation started

05:27:37.04 Relation 140 (DOC_LIST)
05:27:37.04 process pointer page 0 of 3
05:27:37.14 process pointer page 1 of 3
05:27:37.22 process pointer page 2 of 3
05:27:37.22 Index 1 (PK_DOC_LIST)
05:27:37.26 Index 2 (DOC_LIST_ID_DESC)
05:27:37.31 Index 3 (FK_DOC_LIST_AGENTS)
05:27:37.40 Relation 140 (DOC_LIST) is ok

05:27:37.40 Relation 141 (DOC_DATA)
05:27:37.40 process pointer page 0 of 8
05:27:37.47 process pointer page 1 of 8
05:27:37.53 process pointer page 2 of 8
05:27:37.59 process pointer page 3 of 8
05:27:37.64 process pointer page 4 of 8
05:27:37.72 process pointer page 5 of 8
05:27:37.81 process pointer page 6 of 8
05:27:37.86 process pointer page 7 of 8
05:27:37.87 Index 2 (DOC_DATA_DOC_WARE_UNQ)
05:27:38.18 Index 3 (DOC_DATA_ID_DESC)
05:27:38.36 Index 4 (FK_DOC_DATA_DOC_LIST)
05:27:38.48 Relation 141 (DOC_DATA) is ok

05:27:38.48 Relation 147 (INVNT_SALDO)
05:27:38.48 process pointer page 0 of 1
05:27:40.74 Index 1 (PK_INVNT_SALDO)
05:27:40.74 Relation 147 (INVNT_SALDO) is ok

05:27:40.74 Relation 150 (PDISTR)
05:27:40.74 process pointer page 0 of 1
05:27:40.82 Index 2 (PDISTR_SND_ID)
05:27:40.85 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
05:27:40.90 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
05:27:40.93 Index 5 (PDISTR_AGENT_ID)
05:27:40.96 Relation 150 (PDISTR) is ok

05:27:40.96 Relation 151 (PSTORNED)
05:27:40.96 process pointer page 0 of 2
05:27:41.09 process pointer page 1 of 2
05:27:41.12 Index 2 (PSTORNED_SND_ID)
05:27:41.16 Index 3 (PSTORNED_RCV_ID)
05:27:41.21 Relation 151 (PSTORNED) is ok

05:27:41.21 Relation 156 (SEMAPHORES)
05:27:41.21 process pointer page 0 of 1
05:27:41.21 Index 1 (PK_SEMAPHORES)
05:27:41.21 Index 2 (SEMAPHORES_TASK_UNQ)
05:27:41.21 Relation 156 (SEMAPHORES) is ok

05:27:41.21 Relation 157 (INVNT_TURNOVER_LOG)
05:27:41.21 process pointer page 0 of 1
05:27:41.23 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
05:27:41.24 Relation 157 (INVNT_TURNOVER_LOG) is ok

05:27:41.24 Relation 160 (PERF_ESTIMATED)
05:27:41.24 process pointer page 0 of 1
05:27:41.29 Index 1 (PERF_EST_MINUTE_SINCE_START)
05:27:41.30 Relation 160 (PERF_ESTIMATED) is ok

05:27:41.30 Relation 161 (PERF_ISQL_STAT)
05:27:41.30 process pointer page 0 of 1
05:27:41.30 Index 1 (PERF_ISQL_STAT_TRN)
05:27:41.30 Relation 161 (PERF_ISQL_STAT) is ok

05:27:41.30 Relation 162 (PERF_LOG)
05:27:41.30 process pointer page 0 of 121
05:27:41.35 process pointer page 1 of 121
05:27:41.38 process pointer page 2 of 121
05:27:41.41 process pointer page 3 of 121
05:27:41.44 process pointer page 4 of 121
05:27:41.51 process pointer page 5 of 121
05:27:41.55 process pointer page 6 of 121
05:27:41.58 process pointer page 7 of 121
05:27:41.62 process pointer page 8 of 121
05:27:41.65 process pointer page 9 of 121
05:27:41.66 process pointer page 10 of 121
05:27:41.69 process pointer page 11 of 121
05:27:41.72 process pointer page 12 of 121
05:27:41.79 process pointer page 13 of 121
05:27:41.85 process pointer page 14 of 121
05:27:41.93 process pointer page 15 of 121
05:27:41.99 process pointer page 16 of 121
05:27:42.07 process pointer page 17 of 121
05:27:42.10 process pointer page 18 of 121
05:27:42.13 process pointer page 19 of 121
05:27:42.18 process pointer page 20 of 121
05:27:42.21 process pointer page 21 of 121
05:27:42.24 process pointer page 22 of 121
05:27:42.32 process pointer page 23 of 121
05:27:42.36 process pointer page 24 of 121
05:27:42.38 process pointer page 25 of 121
05:27:42.41 process pointer page 26 of 121
05:27:42.44 process pointer page 27 of 121
05:27:42.47 process pointer page 28 of 121
05:27:42.49 process pointer page 29 of 121
05:27:42.52 process pointer page 30 of 121
05:27:42.57 process pointer page 31 of 121
05:27:42.63 process pointer page 32 of 121
05:27:42.69 process pointer page 33 of 121
05:27:42.72 process pointer page 34 of 121
05:27:42.77 process pointer page 35 of 121
05:27:42.80 process pointer page 36 of 121
05:27:42.83 process pointer page 37 of 121
05:27:42.88 process pointer page 38 of 121
05:27:42.94 process pointer page 39 of 121
05:27:43.02 process pointer page 40 of 121
05:27:43.08 process pointer page 41 of 121
05:27:43.16 process pointer page 42 of 121
05:27:43.22 process pointer page 43 of 121
05:27:43.28 process pointer page 44 of 121
05:27:43.32 process pointer page 45 of 121
05:27:43.33 process pointer page 46 of 121
05:27:43.36 process pointer page 47 of 121
05:27:43.41 process pointer page 48 of 121
05:27:43.47 process pointer page 49 of 121
05:27:43.55 process pointer page 50 of 121
05:27:43.61 process pointer page 51 of 121
05:27:43.69 process pointer page 52 of 121
05:27:43.75 process pointer page 53 of 121
05:27:43.83 process pointer page 54 of 121
05:27:43.89 process pointer page 55 of 121
05:27:43.97 process pointer page 56 of 121
05:27:44.03 process pointer page 57 of 121
05:27:44.10 process pointer page 58 of 121
05:27:44.17 process pointer page 59 of 121
05:27:44.24 process pointer page 60 of 121
05:27:44.31 process pointer page 61 of 121
05:27:44.36 process pointer page 62 of 121
05:27:44.38 process pointer page 63 of 121
05:27:44.45 process pointer page 64 of 121
05:27:44.50 process pointer page 65 of 121
05:27:44.52 process pointer page 66 of 121
05:27:44.56 process pointer page 67 of 121
05:27:44.64 process pointer page 68 of 121
05:27:44.70 process pointer page 69 of 121
05:27:44.77 process pointer page 70 of 121
05:27:44.84 process pointer page 71 of 121
05:27:44.91 process pointer page 72 of 121
05:27:44.99 process pointer page 73 of 121
05:27:45.05 process pointer page 74 of 121
05:27:45.08 process pointer page 75 of 121
05:27:45.09 process pointer page 76 of 121
05:27:45.13 process pointer page 77 of 121
05:27:45.19 process pointer page 78 of 121
05:27:45.25 process pointer page 79 of 121
05:27:45.33 process pointer page 80 of 121
05:27:45.39 process pointer page 81 of 121
05:27:45.47 process pointer page 82 of 121
05:27:45.50 process pointer page 83 of 121
05:27:45.53 process pointer page 84 of 121
05:27:45.55 process pointer page 85 of 121
05:27:45.58 process pointer page 86 of 121
05:27:45.64 process pointer page 87 of 121
05:27:45.72 process pointer page 88 of 121
05:27:45.78 process pointer page 89 of 121
05:27:45.84 process pointer page 90 of 121
05:27:45.92 process pointer page 91 of 121
05:27:45.98 process pointer page 92 of 121
05:27:46.06 process pointer page 93 of 121
05:27:46.12 process pointer page 94 of 121
05:27:46.20 process pointer page 95 of 121
05:27:46.26 process pointer page 96 of 121
05:27:46.34 process pointer page 97 of 121
05:27:46.40 process pointer page 98 of 121
05:27:46.48 process pointer page 99 of 121
05:27:46.55 process pointer page 100 of 121
05:27:46.62 process pointer page 101 of 121
05:27:46.69 process pointer page 102 of 121
05:27:46.75 process pointer page 103 of 121
05:27:46.78 process pointer page 104 of 121
05:27:46.83 process pointer page 105 of 121
05:27:46.86 process pointer page 106 of 121
05:27:46.89 process pointer page 107 of 121
05:27:46.97 process pointer page 108 of 121
05:27:47.03 process pointer page 109 of 121
05:27:47.11 process pointer page 110 of 121
05:27:47.17 process pointer page 111 of 121
05:27:47.20 process pointer page 112 of 121
05:27:47.23 process pointer page 113 of 121
05:27:47.26 process pointer page 114 of 121
05:27:47.28 process pointer page 115 of 121
05:27:47.31 process pointer page 116 of 121
05:27:47.34 process pointer page 117 of 121
05:27:47.37 process pointer page 118 of 121
05:27:47.42 process pointer page 119 of 121
05:27:47.48 process pointer page 120 of 121
05:27:47.51 Index 1 (PERF_LOG_DTS_BEG_DESC)
05:27:50.13 Index 2 (PERF_LOG_UNIT)
05:27:53.78 Index 3 (PERF_LOG_TRN_DESC)
05:27:56.14 Index 4 (PERF_LOG_GDSCODE)
05:27:58.07 Relation 162 (PERF_LOG) is ok

05:27:58.07 Relation 166 (V_STOPTEST)
05:27:58.07 Relation 166 (V_STOPTEST) is ok

05:27:58.07 Relation 183 (V_QDISTR_SOURCE)
05:27:58.07 Relation 183 (V_QDISTR_SOURCE) is ok

05:27:58.07 Relation 184 (V_QSTORNED_SOURCE)
05:27:58.07 Relation 184 (V_QSTORNED_SOURCE) is ok

05:27:58.07 Relation 258 (XQD_1000_1200)
05:27:58.09 process pointer page 0 of 1
05:27:58.10 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
05:27:58.12 Relation 258 (XQD_1000_1200) is ok

05:27:58.12 Relation 259 (XQD_1200_2000)
05:27:58.12 process pointer page 0 of 2
05:27:58.15 process pointer page 1 of 2
05:27:58.17 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
05:27:58.17 Relation 259 (XQD_1200_2000) is ok

05:27:58.17 Relation 260 (XQD_1000_3300)
05:27:58.17 process pointer page 0 of 3
05:27:58.21 process pointer page 1 of 3
05:27:58.26 process pointer page 2 of 3
05:27:58.34 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
05:27:58.40 Index 2 (XQD_1000_3300_DOC)
05:27:58.45 Relation 260 (XQD_1000_3300) is ok

05:27:58.45 Relation 261 (XQD_2000_3300)
05:27:58.45 process pointer page 0 of 33
05:27:58.54 process pointer page 1 of 33
05:27:58.71 process pointer page 2 of 33
05:27:58.88 process pointer page 3 of 33
05:27:58.95 process pointer page 4 of 33
05:27:59.12 process pointer page 5 of 33
05:27:59.26 process pointer page 6 of 33
05:27:59.33 process pointer page 7 of 33
05:27:59.39 process pointer page 8 of 33
05:27:59.45 process pointer page 9 of 33
05:27:59.50 process pointer page 10 of 33
05:27:59.56 process pointer page 11 of 33
05:27:59.66 process pointer page 12 of 33
05:27:59.75 process pointer page 13 of 33
05:27:59.82 process pointer page 14 of 33
05:27:59.94 process pointer page 15 of 33
05:28:00.01 process pointer page 16 of 33
05:28:00.14 process pointer page 17 of 33
05:28:00.22 process pointer page 18 of 33
05:28:00.29 process pointer page 19 of 33
05:28:00.36 process pointer page 20 of 33
05:28:00.48 process pointer page 21 of 33
05:28:00.64 process pointer page 22 of 33
05:28:00.79 process pointer page 23 of 33
05:28:00.87 process pointer page 24 of 33
05:28:01.01 process pointer page 25 of 33
05:28:01.14 process pointer page 26 of 33
05:28:01.18 process pointer page 27 of 33
05:28:01.23 process pointer page 28 of 33
05:28:01.37 process pointer page 29 of 33
05:28:01.51 process pointer page 30 of 33
05:28:01.59 process pointer page 31 of 33
05:28:01.64 process pointer page 32 of 33
05:28:01.64 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
05:28:02.53 Relation 261 (XQD_2000_3300) is ok

05:28:02.53 Relation 262 (XQD_2100_3300)
05:28:02.53 process pointer page 0 of 2
05:28:02.57 process pointer page 1 of 2
05:28:02.57 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
05:28:02.57 Relation 262 (XQD_2100_3300) is ok

05:28:02.57 Relation 263 (XQD_3300_3400)
05:28:02.59 process pointer page 0 of 20
05:28:02.67 process pointer page 1 of 20
05:28:02.73 process pointer page 2 of 20
05:28:02.79 process pointer page 3 of 20
05:28:02.84 process pointer page 4 of 20
05:28:02.95 process pointer page 5 of 20
05:28:03.01 process pointer page 6 of 20
05:28:03.06 process pointer page 7 of 20
05:28:03.17 process pointer page 8 of 20
05:28:03.26 process pointer page 9 of 20
05:28:03.38 process pointer page 10 of 20
05:28:03.54 process pointer page 11 of 20
05:28:03.59 process pointer page 12 of 20
05:28:03.65 process pointer page 13 of 20
05:28:03.70 process pointer page 14 of 20
05:28:03.73 process pointer page 15 of 20
05:28:03.87 process pointer page 16 of 20
05:28:03.99 process pointer page 17 of 20
05:28:04.05 process pointer page 18 of 20
05:28:04.10 process pointer page 19 of 20
05:28:04.12 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
05:28:04.66 Relation 263 (XQD_3300_3400) is ok

05:28:04.66 Relation 264 (XQS_1000_1200)
05:28:04.66 process pointer page 0 of 18
05:28:04.71 process pointer page 1 of 18
05:28:04.76 process pointer page 2 of 18
05:28:04.82 process pointer page 3 of 18
05:28:04.90 process pointer page 4 of 18
05:28:04.93 process pointer page 5 of 18
05:28:04.97 process pointer page 6 of 18
05:28:05.05 process pointer page 7 of 18
05:28:05.12 process pointer page 8 of 18
05:28:05.15 process pointer page 9 of 18
05:28:05.18 process pointer page 10 of 18
05:28:05.22 process pointer page 11 of 18
05:28:05.26 process pointer page 12 of 18
05:28:05.29 process pointer page 13 of 18
05:28:05.32 process pointer page 14 of 18
05:28:05.38 process pointer page 15 of 18
05:28:05.47 process pointer page 16 of 18
05:28:05.57 process pointer page 17 of 18
05:28:05.58 Index 1 (XQS_1000_1200_DOC_ID)
05:28:05.83 Index 2 (XQS_1000_1200_SND_ID)
05:28:06.25 Index 3 (XQS_1000_1200_RCV_ID)
05:28:06.43 Relation 264 (XQS_1000_1200) is ok

05:28:06.43 Relation 265 (XQS_1200_2000)
05:28:06.43 process pointer page 0 of 35
05:28:06.46 process pointer page 1 of 35
05:28:06.52 process pointer page 2 of 35
05:28:06.61 process pointer page 3 of 35
05:28:06.71 process pointer page 4 of 35
05:28:06.78 process pointer page 5 of 35
05:28:06.86 process pointer page 6 of 35
05:28:06.94 process pointer page 7 of 35
05:28:07.03 process pointer page 8 of 35
05:28:07.16 process pointer page 9 of 35
05:28:07.22 process pointer page 10 of 35
05:28:07.27 process pointer page 11 of 35
05:28:07.33 process pointer page 12 of 35
05:28:07.46 process pointer page 13 of 35
05:28:07.60 process pointer page 14 of 35
05:28:07.74 process pointer page 15 of 35
05:28:07.88 process pointer page 16 of 35
05:28:07.94 process pointer page 17 of 35
05:28:08.00 process pointer page 18 of 35
05:28:08.06 process pointer page 19 of 35
05:28:08.13 process pointer page 20 of 35
05:28:08.27 process pointer page 21 of 35
05:28:08.41 process pointer page 22 of 35
05:28:08.47 process pointer page 23 of 35
05:28:08.53 process pointer page 24 of 35
05:28:08.64 process pointer page 25 of 35
05:28:08.77 process pointer page 26 of 35
05:28:08.86 process pointer page 27 of 35
05:28:08.91 process pointer page 28 of 35
05:28:08.94 process pointer page 29 of 35
05:28:09.00 process pointer page 30 of 35
05:28:09.09 process pointer page 31 of 35
05:28:09.16 process pointer page 32 of 35
05:28:09.28 process pointer page 33 of 35
05:28:09.37 process pointer page 34 of 35
05:28:09.45 Index 1 (XQS_1200_2000_DOC_ID)
05:28:10.43 Index 2 (XQS_1200_2000_SND_ID)
05:28:11.71 Index 3 (XQS_1200_2000_RCV_ID)
05:28:12.31 Relation 265 (XQS_1200_2000) is ok

05:28:12.31 Relation 266 (XQS_1000_3300)
05:28:12.31 process pointer page 0 of 19
05:28:12.37 process pointer page 1 of 19
05:28:12.42 process pointer page 2 of 19
05:28:12.46 process pointer page 3 of 19
05:28:12.57 process pointer page 4 of 19
05:28:12.71 process pointer page 5 of 19
05:28:12.84 process pointer page 6 of 19
05:28:12.98 process pointer page 7 of 19
05:28:13.12 process pointer page 8 of 19
05:28:13.21 process pointer page 9 of 19
05:28:13.31 process pointer page 10 of 19
05:28:13.45 process pointer page 11 of 19
05:28:13.52 process pointer page 12 of 19
05:28:13.57 process pointer page 13 of 19
05:28:13.62 process pointer page 14 of 19
05:28:13.66 process pointer page 15 of 19
05:28:13.71 process pointer page 16 of 19
05:28:13.74 process pointer page 17 of 19
05:28:13.77 process pointer page 18 of 19
05:28:13.79 Index 1 (XQS_1000_3300_DOC_ID)
05:28:14.24 Index 2 (XQS_1000_3300_SND_ID)
05:28:14.91 Index 3 (XQS_1000_3300_RCV_ID)
05:28:15.11 Relation 266 (XQS_1000_3300) is ok

05:28:15.11 Relation 267 (XQS_2000_3300)
05:28:15.11 process pointer page 0 of 1
05:28:15.11 Index 1 (XQS_2000_3300_DOC_ID)
05:28:15.13 Index 2 (XQS_2000_3300_SND_ID)
05:28:15.13 Index 3 (XQS_2000_3300_RCV_ID)
05:28:15.13 Relation 267 (XQS_2000_3300) is ok

05:28:15.13 Relation 268 (XQS_2100_3300)
05:28:15.13 process pointer page 0 of 21
05:28:15.16 process pointer page 1 of 21
05:28:15.24 process pointer page 2 of 21
05:28:15.32 process pointer page 3 of 21
05:28:15.40 process pointer page 4 of 21
05:28:15.44 process pointer page 5 of 21
05:28:15.49 process pointer page 6 of 21
05:28:15.54 process pointer page 7 of 21
05:28:15.57 process pointer page 8 of 21
05:28:15.68 process pointer page 9 of 21
05:28:15.72 process pointer page 10 of 21
05:28:15.79 process pointer page 11 of 21
05:28:15.83 process pointer page 12 of 21
05:28:15.88 process pointer page 13 of 21
05:28:15.93 process pointer page 14 of 21
05:28:15.97 process pointer page 15 of 21
05:28:16.10 process pointer page 16 of 21
05:28:16.14 process pointer page 17 of 21
05:28:16.27 process pointer page 18 of 21
05:28:16.38 process pointer page 19 of 21
05:28:16.49 process pointer page 20 of 21
05:28:16.53 Index 1 (XQS_2100_3300_DOC_ID)
05:28:17.06 Index 2 (XQS_2100_3300_SND_ID)
05:28:17.55 Index 3 (XQS_2100_3300_RCV_ID)
05:28:17.91 Relation 268 (XQS_2100_3300) is ok

05:28:17.91 Relation 269 (XQS_3300_3400)
05:28:17.92 process pointer page 0 of 3
05:28:18.05 process pointer page 1 of 3
05:28:18.19 process pointer page 2 of 3
05:28:18.25 Index 1 (XQS_3300_3400_DOC_ID)
05:28:18.30 Index 2 (XQS_3300_3400_SND_ID)
05:28:18.33 Relation 269 (XQS_3300_3400) is ok

05:28:18.33 Relation 276 (TRACE_STAT)
05:28:18.33 process pointer page 0 of 1
05:28:18.33 Relation 276 (TRACE_STAT) is ok

05:28:18.33 Validation finished
Done for 41720 ms, from 5:27:36.62 to 5:28:18.34.

Differences between old and current firebird.log

5:28:19.37. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_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:
2016-01-18 05:28 492 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 +++
***** E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log
4: Server version: WI-V2.5.5.26933 Firebird 2.5
5: Server version: WI-V2.5.5.26933 Firebird 2.5
***** E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
4: Server version: WI-V2.5.5.26933 Firebird 2.5
5:
6: WIN-2BE1UI8LGDL Mon Jan 18 03:23:45 2016
7: INET/inet_error: read errno = 10054
8:
9:
10: WIN-2BE1UI8LGDL Mon Jan 18 03:23:45 2016
11: Unable to complete network request to host "WIN-2BE1UI8LGDL".
12: Error reading data from the connection.
13:
14:
*****
+++ 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-18 5:28:25.86 - 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