Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 4. 2015-12-19 3:56:21.79.
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, DETAILS per units
  5. 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.26958 Firebird 2.5
Server implementation: Firebird/x86-64/Windows NT
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperClassic 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
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. 2015-12-19 03:56:11.4040 -1 <null> 127.0.0.1 181970 4504 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: 4160.84 828 748951 2015-12-19 00:56 2015-12-19 03:56
customer order: creation 159.10 66 28638 2015-12-19 00:56 2015-12-19 03:56
customer order: refuse 13.38 47 2409 2015-12-19 00:56 2015-12-19 03:56
order to supplier: creation 41.39 182 7451 2015-12-19 00:56 2015-12-19 03:56
order to supplier: removal 1.09 8273 195 2015-12-19 00:56 2015-12-19 03:56
invoice (draft): creation 40.52 225 7294 2015-12-19 00:56 2015-12-19 03:56
invoice (draft): removal 13.26 93 2387 2015-12-19 00:56 2015-12-19 03:56
invoice accept: apply 26.55 3831 4779 2015-12-19 00:56 2015-12-19 03:56
invoice accept: cancel 6.96 626 1245 2015-12-19 00:56 2015-12-19 03:56
customer reserve: creation 3230.67 24 581520 2015-12-19 00:56 2015-12-19 03:56
customer reserve: removal 394.20 21 70561 2015-12-19 00:56 2015-12-19 03:56
realization accept: apply 75.19 67 13535 2015-12-19 00:56 2015-12-19 03:56
realization accept: cancel 29.36 40 5284 2015-12-19 00:56 2015-12-19 03:56
payment from customer: creation 53.03 95 9545 2015-12-19 00:56 2015-12-19 03:56
payment from customer: removal 5.07 29 912 2015-12-19 00:56 2015-12-19 03:56
payment to supplier: creation 43.63 141 7853 2015-12-19 00:56 2015-12-19 03:56
payment to supplier: removal 3.27 31 588 2015-12-19 00:56 2015-12-19 03:56
service: total inventory turnovers 16.14 109 2906 2015-12-19 00:56 2015-12-19 03:56
service: total monetary turnovers 10.26 3 1837 2015-12-19 00:56 2015-12-19 03:56
service: refresh index statistics 0.07 1823 12 2015-12-19 00:56 2015-12-19 03:56
Done for 26760 ms, from 3:56:54.69 to 3:57:21.45.

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 2784 54065 50111 3954 7.31 00:56:12 01:14:12
interval # 2, overall 2 3932 77412 70776 6636 8.57 01:14:13 01:32:13
interval # 3, overall 3 4077 81288 73382 7906 9.73 01:32:14 01:50:14
interval # 4, overall 4 5108 95186 91939 3247 3.41 01:50:15 02:08:15
interval # 5, overall 5 4820 98534 86761 11773 11.95 02:08:16 02:26:16
interval # 6, overall 6 3905 86636 70290 16346 18.87 02:26:17 02:44:17
interval # 7, overall 7 3680 85747 66236 19511 22.75 02:44:18 03:02:18
interval # 8, overall 8 3805 85074 68488 16586 19.50 03:02:19 03:20:19
interval # 9, overall 9 4278 97576 77002 20574 21.09 03:20:20 03:38:20
interval # 10, overall 10 5220 105111 93966 11145 10.60 03:38:21 03:56:21
Done for 43940 ms, from 3:58:03.47 to 3:58:47.41.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED
WARM_TIME 1 2192.14 0.6705 1.1746 272
WARM_TIME 2 1338.38 0.9619 1.0706 57
WARM_TIME 3 1045.91 0.9554 1.0963 88
WARM_TIME 4 1020.20 0.8432 1.0956 386
WARM_TIME 5 1012.28 0.8894 1.0700 241
WARM_TIME 6 1010.38 0.8981 1.1045 510
WARM_TIME 7 1034.27 0.9400 1.1033 332
WARM_TIME 8 1094.19 0.9126 1.0747 472
WARM_TIME 9 1136.73 0.9210 1.0750 532
WARM_TIME 10 1204.11 0.9134 1.0847 593
TEST_TIME 11 1291.18 0.9196 1.0849 609
TEST_TIME 12 1387.95 0.9252 1.0856 678
TEST_TIME 13 1484.56 0.9369 1.0540 658
TEST_TIME 14 1534.62 0.9468 1.0655 503
TEST_TIME 15 1603.04 0.9521 1.0388 339
TEST_TIME 16 1645.84 0.9486 1.0515 441
TEST_TIME 17 1682.02 0.9684 1.0425 305
TEST_TIME 18 1707.38 0.9763 1.0208 180
TEST_TIME 19 1738.52 0.9498 1.0496 677
TEST_TIME 20 1800.68 0.9627 1.0366 517
TEST_TIME 21 1841.63 0.9653 1.0418 519
TEST_TIME 22 1905.41 0.9612 1.0493 418
TEST_TIME 23 1943.27 0.9847 1.0231 150
TEST_TIME 24 1981.58 0.9615 1.0326 458
TEST_TIME 25 2044.84 0.9607 1.0371 799
TEST_TIME 26 2111.61 0.9657 1.0307 721
TEST_TIME 27 2176.86 0.9628 1.0341 647
TEST_TIME 28 2212.69 0.9810 1.0231 446
TEST_TIME 29 2252.50 0.9703 1.0243 708
TEST_TIME 30 2269.86 0.9841 1.0201 383
TEST_TIME 31 2291.13 0.9780 1.0188 420
TEST_TIME 32 2333.45 0.9696 1.0260 614
TEST_TIME 33 2384.55 0.9736 1.0287 575
TEST_TIME 34 2432.32 0.9789 1.0228 316
TEST_TIME 35 2471.59 0.9778 1.0202 517
TEST_TIME 36 2496.60 0.9819 1.0146 542
TEST_TIME 37 2532.06 0.9754 1.0136 481
TEST_TIME 38 2548.85 0.9820 1.0198 487
TEST_TIME 39 2583.79 0.9803 1.0199 548
TEST_TIME 40 2614.88 0.9826 1.0213 675
TEST_TIME 41 2668.43 0.9764 1.0240 761
TEST_TIME 42 2738.05 0.9748 1.0201 589
TEST_TIME 43 2791.19 0.9774 1.0162 654
TEST_TIME 44 2834.43 0.9793 1.0186 534
TEST_TIME 45 2874.13 0.9822 1.0154 525
TEST_TIME 46 2902.31 0.9837 1.0144 535
TEST_TIME 47 2941.07 0.9797 1.0094 448
TEST_TIME 48 2949.18 0.9857 1.0133 512
TEST_TIME 49 2964.49 0.9875 1.0095 339
TEST_TIME 50 2972.60 0.9867 1.0099 495
TEST_TIME 51 2990.09 0.9843 1.0130 546
TEST_TIME 52 3006.63 0.9880 1.0093 458
TEST_TIME 53 3012.85 0.9883 1.0108 387
TEST_TIME 54 3020.70 0.9912 1.0083 226
TEST_TIME 55 2999.63 0.9970 1.0052 139
TEST_TIME 56 2999.94 0.9872 1.0084 235
TEST_TIME 57 3020.94 0.9838 1.0139 562
TEST_TIME 58 3070.70 0.9803 1.0138 551
TEST_TIME 59 3103.57 0.9861 1.0146 643
TEST_TIME 60 3144.93 0.9846 1.0141 458
TEST_TIME 61 3177.23 0.9876 1.0136 486
TEST_TIME 62 3212.65 0.9863 1.0106 408
TEST_TIME 63 3223.23 0.9913 1.0083 227
TEST_TIME 64 3230.34 0.9904 1.0133 528
TEST_TIME 65 3253.85 0.9905 1.0092 538
TEST_TIME 66 3284.11 0.9848 1.0096 382
TEST_TIME 67 3302.48 0.9890 1.0062 413
TEST_TIME 68 3300.20 0.9921 1.0079 278
TEST_TIME 69 3321.10 0.9871 1.0133 495
TEST_TIME 70 3354.27 0.9890 1.0102 447
TEST_TIME 71 3385.15 0.9869 1.0126 421
TEST_TIME 72 3415.16 0.9940 1.0061 266
TEST_TIME 73 3425.26 0.9894 1.0071 444
TEST_TIME 74 3442.45 0.9885 1.0118 433
TEST_TIME 75 3472.45 0.9907 1.0106 419
TEST_TIME 76 3494.36 0.9918 1.0080 351
TEST_TIME 77 3506.19 0.9916 1.0108 466
TEST_TIME 78 3537.55 0.9890 1.0079 423
TEST_TIME 79 3561.36 0.9896 1.0104 313
TEST_TIME 80 3596.82 0.9880 1.0089 433
TEST_TIME 81 3616.16 0.9911 1.0081 360
TEST_TIME 82 3639.61 0.9905 1.0090 340
TEST_TIME 83 3661.32 0.9922 1.0089 368
TEST_TIME 84 3684.96 0.9905 1.0093 384
TEST_TIME 85 3702.38 0.9929 1.0101 481
TEST_TIME 86 3733.12 0.9902 1.0079 454
TEST_TIME 87 3747.02 0.9928 1.0078 541
TEST_TIME 88 3773.51 0.9894 1.0083 474
TEST_TIME 89 3800.48 0.9900 1.0088 495
TEST_TIME 90 3810.82 0.9949 1.0066 586
TEST_TIME 91 3822.51 0.9925 1.0066 436
TEST_TIME 92 3828.77 0.9940 1.0058 452
TEST_TIME 93 3837.96 0.9926 1.0075 493
TEST_TIME 94 3846.25 0.9946 1.0051 513
TEST_TIME 95 3854.96 0.9923 1.0057 485
TEST_TIME 96 3859.95 0.9939 1.0059 489
TEST_TIME 97 3864.15 0.9945 1.0074 452
TEST_TIME 98 3866.84 0.9964 1.0050 559
TEST_TIME 99 3853.63 0.9982 1.0033 183
TEST_TIME 100 3853.52 0.9936 1.0055 631
TEST_TIME 101 3866.79 0.9921 1.0075 645
TEST_TIME 102 3878.45 0.9946 1.0057 648
TEST_TIME 103 3890.13 0.9929 1.0058 652
TEST_TIME 104 3888.91 0.9965 1.0036 352
TEST_TIME 105 3878.80 0.9971 1.0042 562
TEST_TIME 106 3882.01 0.9939 1.0037 556
TEST_TIME 107 3879.17 0.9950 1.0042 636
TEST_TIME 108 3876.04 0.9957 1.0038 546
TEST_TIME 109 3869.46 0.9962 1.0019 509
TEST_TIME 110 3854.69 0.9966 1.0023 239
TEST_TIME 111 3846.65 0.9953 1.0033 459
TEST_TIME 112 3846.55 0.9944 1.0046 596
TEST_TIME 113 3849.56 0.9950 1.0033 563
TEST_TIME 114 3841.94 0.9965 1.0036 582
TEST_TIME 115 3847.85 0.9933 1.0064 926
TEST_TIME 116 3857.18 0.9953 1.0051 609
TEST_TIME 117 3861.49 0.9954 1.0041 645
TEST_TIME 118 3861.45 0.9959 1.0049 426
TEST_TIME 119 3869.54 0.9948 1.0040 622
TEST_TIME 120 3868.51 0.9959 1.0049 659
TEST_TIME 121 3873.10 0.9954 1.0019 142
TEST_TIME 122 3869.96 0.9952 1.0029 417
TEST_TIME 123 3865.09 0.9961 1.0041 566
TEST_TIME 124 3858.46 0.9977 1.0035 551
TEST_TIME 125 3858.49 0.9954 1.0032 495
TEST_TIME 126 3859.26 0.9950 1.0034 503
TEST_TIME 127 3855.03 0.9966 1.0022 590
TEST_TIME 128 3846.32 0.9966 1.0028 475
TEST_TIME 129 3839.32 0.9968 1.0035 555
TEST_TIME 130 3843.94 0.9946 1.0047 805
TEST_TIME 131 3851.16 0.9951 1.0042 843
TEST_TIME 132 3852.94 0.9961 1.0038 767
TEST_TIME 133 3852.18 0.9966 1.0030 699
TEST_TIME 134 3847.46 0.9967 1.0029 693
TEST_TIME 135 3840.84 0.9971 1.0028 664
TEST_TIME 136 3834.09 0.9972 1.0027 717
TEST_TIME 137 3826.69 0.9973 1.0031 679
TEST_TIME 138 3820.32 0.9978 1.0037 640
TEST_TIME 139 3819.83 0.9966 1.0023 660
TEST_TIME 140 3812.56 0.9970 1.0038 761
TEST_TIME 141 3817.33 0.9955 1.0033 554
TEST_TIME 142 3818.11 0.9962 1.0033 520
TEST_TIME 143 3815.26 0.9970 1.0029 515
TEST_TIME 144 3811.19 0.9970 1.0031 565
TEST_TIME 145 3818.79 0.9942 1.0052 851
TEST_TIME 146 3828.15 0.9959 1.0044 642
TEST_TIME 147 3834.66 0.9959 1.0040 685
TEST_TIME 148 3837.05 0.9966 1.0036 659
TEST_TIME 149 3837.23 0.9968 1.0036 736
TEST_TIME 150 3837.01 0.9970 1.0026 745
TEST_TIME 151 3833.72 0.9968 1.0037 651
TEST_TIME 152 3833.79 0.9970 1.0044 543
TEST_TIME 153 3837.65 0.9969 1.0022 629
TEST_TIME 154 3830.89 0.9975 1.0033 595
TEST_TIME 155 3834.65 0.9959 1.0029 530
TEST_TIME 156 3835.11 0.9965 1.0026 620
TEST_TIME 157 3829.12 0.9978 1.0027 672
TEST_TIME 158 3827.74 0.9970 1.0024 549
TEST_TIME 159 3825.54 0.9967 1.0036 537
TEST_TIME 160 3836.48 0.9944 1.0043 776
TEST_TIME 161 3847.61 0.9952 1.0037 633
TEST_TIME 162 3855.16 0.9960 1.0045 638
TEST_TIME 163 3863.74 0.9961 1.0035 596
TEST_TIME 164 3867.65 0.9964 1.0028 573
TEST_TIME 165 3870.21 0.9963 1.0035 696
TEST_TIME 166 3874.25 0.9964 1.0029 558
TEST_TIME 167 3875.87 0.9965 1.0035 643
TEST_TIME 168 3881.45 0.9962 1.0023 554
TEST_TIME 169 3878.05 0.9973 1.0021 586
TEST_TIME 170 3874.86 0.9970 1.0029 540
TEST_TIME 171 3877.33 0.9964 1.0029 566
TEST_TIME 172 3877.16 0.9971 1.0020 643
TEST_TIME 173 3875.70 0.9966 1.0025 338
TEST_TIME 174 3874.84 0.9972 1.0032 366
TEST_TIME 175 3878.49 0.9965 1.0038 730
TEST_TIME 176 3892.67 0.9948 1.0044 749
TEST_TIME 177 3902.17 0.9963 1.0036 813
TEST_TIME 178 3909.64 0.9960 1.0042 601
TEST_TIME 179 3925.16 0.9951 1.0038 657
TEST_TIME 180 3929.12 0.9972 1.0035 684
TEST_TIME 181 3948.14 0.9932 1.0030 244
TEST_TIME 182 3953.21 0.9964 1.0048 481
TEST_TIME 183 3966.85 0.9959 1.0040 457
TEST_TIME 184 3978.38 0.9956 1.0030 582
TEST_TIME 185 3979.50 0.9973 1.0028 535
TEST_TIME 186 3977.42 0.9979 1.0045 414
TEST_TIME 187 3985.56 0.9971 1.0026 581
TEST_TIME 188 3988.55 0.9967 1.0034 472
TEST_TIME 189 3998.72 0.9955 1.0041 371
TEST_TIME 190 3999.08 0.9989 1.0007 134
Done for 7620 ms, from 3:58:47.67 to 3:58:55.29.

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 801686 686918 114768 14.31 0 2016 5 114768 2015-12-19 00:56 2015-12-19 03:56
doc_list_biud 801854 686918 114936 14.33 0 3556 3 114936 2015-12-19 00:56 2015-12-19 03:56
sp_add_invoice_to_stock 6859 4779 2080 30.32 27 95156 3831 2080 2015-12-19 00:56 2015-12-19 03:56
sp_cancel_adding_invoice 2090 1245 845 40.43 7 12298 626 845 2015-12-19 00:56 2015-12-19 03:56
sp_cancel_client_order 2468 2409 59 2.39 7 370 47 59 2015-12-19 00:56 2015-12-19 03:56
sp_cancel_customer_reserve 180408 70561 109847 60.88 1 3502 21 109847 2015-12-19 00:56 2015-12-19 03:56
sp_cancel_pay_from_customer 915 912 3 0.32 4 242 29 3 2015-12-19 00:56 2015-12-19 03:56
sp_cancel_pay_to_supplier 588 588 0 0.00 3 280 31 0 2015-12-19 00:56 2015-12-19 03:56
sp_cancel_supplier_invoice 3348 2387 961 28.70 2 703 93 961 2015-12-19 00:56 2015-12-19 03:56
sp_cancel_supplier_order 486 195 291 59.87 58 69139 8273 291 2015-12-19 00:56 2015-12-19 03:56
sp_cancel_write_off 8773 5284 3489 39.76 2 457 40 3489 2015-12-19 00:56 2015-12-19 03:56
sp_client_order 28638 28638 0 0.00 7 2203 66 0 2015-12-19 00:56 2015-12-19 03:56
sp_customer_reserve 581520 581520 0 0.00 0 3682 24 0 2015-12-19 00:56 2015-12-19 03:56
sp_fill_shopping_cart 43383 43383 0 0.00 1 2033 14 0 2015-12-19 00:56 2015-12-19 03:56
sp_fill_shopping_cart_clo_res 581520 581520 0 0.00 0 929 2 0 2015-12-19 00:56 2015-12-19 03:56
sp_get_clo_for_invoice 4779 4779 0 0.00 1 613 70 0 2015-12-19 00:56 2015-12-19 03:56
sp_kill_cost_storno 12150 8029 4121 33.91 0 273 5 4121 2015-12-19 00:56 2015-12-19 03:56
sp_kill_qstorno_ret_qs2qd 372926 148988 223938 60.04 0 3484 8 223938 2015-12-19 00:56 2015-12-19 03:56
sp_kill_qty_storno 215318 100395 114923 53.37 0 3554 19 114923 2015-12-19 00:56 2015-12-19 03:56
sp_lock_selected_doc 28318 25494 2824 9.97 0 250 1 2824 2015-12-19 00:56 2015-12-19 03:56
sp_make_cost_storno 35712 35712 0 0.00 0 560 39 0 2015-12-19 00:56 2015-12-19 03:56
sp_multiply_rows_for_pdistr 35712 35712 0 0.00 0 484 8 0 2015-12-19 00:56 2015-12-19 03:56
sp_multiply_rows_for_qdistr 28638 28638 0 0.00 0 979 20 0 2015-12-19 00:56 2015-12-19 03:56
sp_pay_from_customer 9545 9545 0 0.00 19 747 95 0 2015-12-19 00:56 2015-12-19 03:56
sp_pay_to_supplier 7853 7853 0 0.00 13 790 141 0 2015-12-19 00:56 2015-12-19 03:56
sp_payment_common 17398 17398 0 0.00 2 356 27 0 2015-12-19 00:56 2015-12-19 03:56
sp_qd_handle_on_cancel_clo 2468 2409 59 2.39 1 351 17 59 2015-12-19 00:56 2015-12-19 03:56
sp_qd_handle_on_invoice_upd_sts 6776 6024 752 11.09 1 3554 60 752 2015-12-19 00:56 2015-12-19 03:56
sp_qd_handle_on_reserve_upd_sts 13535 13535 0 0.00 0 388 12 0 2015-12-19 00:56 2015-12-19 03:56
sp_reserve_write_off 13638 13535 103 0.75 7 685 67 103 2015-12-19 00:56 2015-12-19 03:56
sp_supplier_invoice 7294 7294 0 0.00 10 2225 225 0 2015-12-19 00:56 2015-12-19 03:56
sp_supplier_order 7451 7451 0 0.00 9 2982 182 0 2015-12-19 00:56 2015-12-19 03:56
srv_find_qd_qs_mism 498963 384208 114755 22.99 0 2015 4 114755 2015-12-19 00:56 2015-12-19 03:56
srv_make_invnt_saldo 2906 2906 0 0.00 2 1207 109 0 2015-12-19 00:56 2015-12-19 03:56
srv_make_money_saldo 1837 1837 0 0.00 0 120 3 0 2015-12-19 00:56 2015-12-19 03:56
srv_recalc_idx_stat 12 12 0 0.00 930 2427 1823 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_add_invoice_to_stock 2080 2080 0 0.00 0 221 5 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_cancel_adding_invoice 259 259 0 0.00 0 194 23 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_cancel_client_order 59 59 0 0.00 1 100 9 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_cancel_customer_reserve 5 5 0 0.00 0 71 32 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_cancel_pay_from_customer 3 3 0 0.00 2 32 15 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_cancel_supplier_invoice 168 168 0 0.00 1 42 4 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_cancel_supplier_order 12882 12882 0 0.00 1 684 36 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_cancel_write_off 6 6 0 0.00 1 49 13 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-abend:sp_reserve_write_off 103 103 0 0.00 0 102 6 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_add_invoice_to_stock 4783 4783 0 0.00 1 2487 209 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_cancel_adding_invoice 472 472 0 0.00 2 962 126 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_cancel_client_order 2409 2409 0 0.00 0 386 13 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_cancel_customer_reserve 922 922 0 0.00 0 317 13 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_cancel_pay_from_customer 912 912 0 0.00 0 154 8 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_cancel_pay_to_supplier 588 588 0 0.00 0 170 8 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_cancel_supplier_invoice 372 372 0 0.00 0 209 14 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_cancel_supplier_order 195 195 0 0.00 3 3933 306 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_cancel_write_off 1310 1310 0 0.00 0 299 10 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_client_order 28638 28638 0 0.00 0 772 16 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_customer_reserve 1379 1379 0 0.00 0 243 8 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_pay_from_customer 9545 9545 0 0.00 0 801 10 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_pay_to_supplier 7853 7853 0 0.00 0 380 8 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_reserve_write_off 13535 13535 0 0.00 0 488 11 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_supplier_invoice 7294 7294 0 0.00 1 795 15 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:sp_supplier_order 7451 7451 0 0.00 1 412 15 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:srv_make_invnt_saldo 2906 2906 0 0.00 0 190 9 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:srv_make_money_saldo 1837 1837 0 0.00 0 181 4 0 2015-12-19 00:56 2015-12-19 03:56
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 3 82 23 0 2015-12-19 00:56 2015-12-19 03:56
v_add_invoice_to_stock 13718 9558 4160 30.32 0 321 2 4160 2015-12-19 00:56 2015-12-19 03:56
v_all_customers 42768 42768 0 0.00 0 13 0 0 2015-12-19 00:56 2015-12-19 03:56
v_all_suppliers 29490 29490 0 0.00 0 5 0 0 2015-12-19 00:56 2015-12-19 03:56
v_all_wares 57276 57276 0 0.00 0 15 0 0 2015-12-19 00:56 2015-12-19 03:56
v_cancel_adding_invoice 1162 944 218 18.76 0 143 13 218 2015-12-19 00:56 2015-12-19 03:56
v_cancel_client_order 4936 4818 118 2.39 0 221 2 118 2015-12-19 00:56 2015-12-19 03:56
v_cancel_customer_prepayment 1830 1824 6 0.32 0 94 1 6 2015-12-19 00:56 2015-12-19 03:56
v_cancel_customer_reserve 1854 1844 10 0.53 0 228 2 10 2015-12-19 00:56 2015-12-19 03:56
v_cancel_payment_to_supplier 1176 1176 0 0.00 0 248 2 0 2015-12-19 00:56 2015-12-19 03:56
v_cancel_supplier_invoice 1080 744 336 31.11 0 336 3 336 2015-12-19 00:56 2015-12-19 03:56
v_cancel_supplier_order 972 390 582 59.87 0 131 2 582 2015-12-19 00:56 2015-12-19 03:56
v_cancel_write_off 2632 2620 12 0.45 0 399 9 12 2015-12-19 00:56 2015-12-19 03:56
v_max_id_clo_ord 7451 7451 0 0.00 0 77 1 0 2015-12-19 00:56 2015-12-19 03:56
v_max_id_clo_res 1379 1379 0 0.00 0 436 6 0 2015-12-19 00:56 2015-12-19 03:56
v_max_id_ord_sup 7294 7294 0 0.00 0 1858 1 0 2015-12-19 00:56 2015-12-19 03:56
v_max_non_paid_invoice 7853 7853 0 0.00 0 94 2 0 2015-12-19 00:56 2015-12-19 03:56
v_max_non_paid_realizn 9545 9545 0 0.00 2 105 9 0 2015-12-19 00:56 2015-12-19 03:56
v_min_id_clo_ord 7451 7451 0 0.00 0 148 2 0 2015-12-19 00:56 2015-12-19 03:56
v_min_id_clo_res 1379 1379 0 0.00 0 85 2 0 2015-12-19 00:56 2015-12-19 03:56
v_min_id_ord_sup 7294 7294 0 0.00 0 855 2 0 2015-12-19 00:56 2015-12-19 03:56
v_min_non_paid_invoice 7853 7853 0 0.00 1 313 13 0 2015-12-19 00:56 2015-12-19 03:56
v_min_non_paid_realizn 9545 9545 0 0.00 3 241 12 0 2015-12-19 00:56 2015-12-19 03:56
v_our_firm 14508 14508 0 0.00 0 11 0 0 2015-12-19 00:56 2015-12-19 03:56
v_reserve_write_off 27276 27070 206 0.75 0 503 2 206 2015-12-19 00:56 2015-12-19 03:56
x_lock_depdocs_on_canc_invoice 6850 3260 3590 52.40 0 279 6 3590 2015-12-19 00:56 2015-12-19 03:56
x_lock_depdocs_on_canc_sup_ord 484 195 289 59.71 0 71 6 289 2015-12-19 00:56 2015-12-19 03:56
x_make_qstorno_1000_1200 7451 7451 0 0.00 5 2968 137 0 2015-12-19 00:56 2015-12-19 03:56
x_make_qstorno_1200_2000 7294 7294 0 0.00 5 1742 183 0 2015-12-19 00:56 2015-12-19 03:56
x_make_qstorno_2100_3300 581520 581520 0 0.00 0 3681 19 0 2015-12-19 00:56 2015-12-19 03:56
Done for 68600 ms, from 3:59:56.31 to 4:01:04.91.

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 17 sp_kill_cost_storno 335544336 2015-12-19 00:58 2015-12-19 03:37
deadlock 197 sp_lock_selected_doc 335544336 2015-12-19 00:59 2015-12-19 03:54
deadlock 78 sp_qd_handle_on_invoice_upd_sts 335544336 2015-12-19 01:02 2015-12-19 03:54
deadlock 3 x_lock_depdocs_on_canc_invoice 335544336 2015-12-19 01:02 2015-12-19 03:20
deadlock 1 x_lock_depdocs_on_canc_sup_ord 335544336 2015-12-19 01:07 2015-12-19 01:07
lock_conflict 3 sp_kill_cost_storno 335544345 2015-12-19 00:59 2015-12-19 02:02
lock_conflict 2169 sp_lock_selected_doc 335544345 2015-12-19 00:56 2015-12-19 03:56
lock_conflict 59 sp_qd_handle_on_cancel_clo 335544345 2015-12-19 00:56 2015-12-19 03:50
lock_conflict 34 sp_qd_handle_on_invoice_upd_sts 335544345 2015-12-19 00:57 2015-12-19 03:56
lock_conflict 215 x_lock_depdocs_on_canc_invoice 335544345 2015-12-19 00:58 2015-12-19 03:54
lock_conflict 47 x_lock_depdocs_on_canc_sup_ord 335544345 2015-12-19 01:18 2015-12-19 03:46
Done for 5120 ms, from 4:01:07.73 to 4:01:12.85.

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 182071
MON$OLDEST_ACTIVE 182072
MON$OLDEST_SNAPSHOT 182072
MON$NEXT_TRANSACTION 182072
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 478649
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26958 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26958 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26958 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26958 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 186625
Page size 8192
ODS version 11.2
Oldest transaction 182073
Oldest active 182074
Oldest snapshot 182074
Next transaction 182075
Bumped transaction 1
Sequence number 0
Next attachment ID 4541
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: 36.98, total records: 1225632
Average version length: 46.46, total versions: 252317, max versions: 1
Data pages: 12995, data page slots: 12995, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 9721
80 - 99% = 3273

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 4394, nodes: 1225632
Average data length: 13.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 527
20 - 39% = 1
40 - 59% = 1838
60 - 79% = 1
80 - 99% = 2027

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

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 1356, nodes: 1225632
Average data length: 1.63, total dup: 895821, max dup: 49
Fill distribution:
0 - 19% = 100
20 - 39% = 1
40 - 59% = 432
60 - 79% = 0
80 - 99% = 823

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 60.46, total records: 285386
Average version length: 37.76, total versions: 8799, max versions: 3
Data pages: 3558, data page slots: 3558, average fill: 78%
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3292
80 - 99% = 264

Index DOC_LIST_ID_DESC (1)
Depth: 3, leaf buckets: 983, nodes: 285386
Average data length: 6.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 330
40 - 59% = 643
60 - 79% = 10
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 306, nodes: 285386
Average data length: 0.01, total dup: 285336, max dup: 32804
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 254
60 - 79% = 38
80 - 99% = 14

Index PK_DOC_LIST (0)
Depth: 3, leaf buckets: 572, nodes: 285386
Average data length: 6.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 41
20 - 39% = 19
40 - 59% = 72
60 - 79% = 150
80 - 99% = 290

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: 63.93, total records: 400
Average version length: 14.73, total versions: 962, max versions: 11
Data pages: 14, data page slots: 14, average fill: 65%
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 8

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: 24.16, total records: 1915
Average version length: 70.19, total versions: 1256, max versions: 1
Data pages: 36, data page slots: 136, average fill: 65%
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 6
60 - 79% = 15
80 - 99% = 10

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

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

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: 30.39, total records: 82
Average version length: 46.04, total versions: 28, max versions: 1
Data pages: 1, data page slots: 1, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 1, leaf buckets: 1, nodes: 82
Average data length: 5.04, total dup: 53, max dup: 17
Fill distribution:
0 - 19% = 1
20 - 39% = 0
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: 43.33, total records: 114719
Average version length: 37.43, total versions: 2327, max versions: 4
Data pages: 1232, data page slots: 1232, average fill: 71%
Fill distribution:
0 - 19% = 8
20 - 39% = 11
40 - 59% = 30
60 - 79% = 1183
80 - 99% = 0

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 95, nodes: 114719
Average data length: 0.01, total dup: 114670, max dup: 5148
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 56
60 - 79% = 19
80 - 99% = 15

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 119, nodes: 114719
Average data length: 0.87, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 2
20 - 39% = 15
40 - 59% = 44
60 - 79% = 36
80 - 99% = 22

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 117, nodes: 114719
Average data length: 0.87, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 49
60 - 79% = 36
80 - 99% = 20

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 126, nodes: 114719
Average data length: 0.66, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 40
60 - 79% = 44
80 - 99% = 8

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

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 75, nodes: 98839
Average data length: 0.00, total dup: 98648, max dup: 925
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 26
60 - 79% = 38
80 - 99% = 11

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

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 7307, nodes: 6146181
Average data length: 0.68, total dup: 2441041, max dup: 12
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 4698
60 - 79% = 1662
80 - 99% = 943

Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 5863, nodes: 6146181
Average data length: 0.00, total dup: 6146176, max dup: 5319633
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 5395
60 - 79% = 0
80 - 99% = 468

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 7140, nodes: 6146181
Average data length: 0.16, total dup: 5996181, max dup: 29309
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 5794
60 - 79% = 738
80 - 99% = 604

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 7112, nodes: 6146181
Average data length: 0.08, total dup: 6123394, max dup: 494926
Fill distribution:
0 - 19% = 8
20 - 39% = 1
40 - 59% = 6138
60 - 79% = 423
80 - 99% = 542

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: 46.27, total records: 186205
Average version length: 55.86, total versions: 33077, max versions: 1
Data pages: 2204, data page slots: 2204, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1592
80 - 99% = 611

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 225, nodes: 186205
Average data length: 1.15, total dup: 153464, max dup: 375
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 139
60 - 79% = 76
80 - 99% = 9

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 184, nodes: 186205
Average data length: 0.64, total dup: 168705, max dup: 121
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 85
60 - 79% = 64
80 - 99% = 34

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: 17, max versions: 15
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 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

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: 8.22, total records: 1935
Average version length: 71.19, total versions: 1712, max versions: 1
Data pages: 27, data page slots: 101, average fill: 91%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 26

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

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 65.39, total records: 62723
Average version length: 71.07, total versions: 5074, max versions: 1
Data pages: 1162, data page slots: 1217, average fill: 60%
Fill distribution:
0 - 19% = 114
20 - 39% = 145
40 - 59% = 198
60 - 79% = 486
80 - 99% = 219

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 70, nodes: 62723
Average data length: 0.42, total dup: 58652, max dup: 101
Fill distribution:
0 - 19% = 0
20 - 39% = 26
40 - 59% = 24
60 - 79% = 13
80 - 99% = 7

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 96, nodes: 62723
Average data length: 1.49, total dup: 53801, max dup: 14
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 54
60 - 79% = 11
80 - 99% = 1

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 29.54, total records: 7786
Average version length: 71.18, total versions: 4556, max versions: 1
Data pages: 150, data page slots: 429, average fill: 64%
Fill distribution:
0 - 19% = 11
20 - 39% = 24
40 - 59% = 31
60 - 79% = 14
80 - 99% = 70

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 14, nodes: 7786
Average data length: 2.29, total dup: 6724, max dup: 41
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 7
60 - 79% = 2
80 - 99% = 0

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 11.03, total records: 2660595
Average version length: 69.61, total versions: 2248350, max versions: 1
Data pages: 36083, data page slots: 36083, average fill: 91%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5040
80 - 99% = 31042

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 3709, nodes: 2660595
Average data length: 0.92, total dup: 2408577, max dup: 99
Fill distribution:
0 - 19% = 3
20 - 39% = 70
40 - 59% = 3334
60 - 79% = 139
80 - 99% = 163

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 18.27, total records: 3075
Average version length: 70.99, total versions: 2286, max versions: 1
Data pages: 86, data page slots: 594, average fill: 46%
Fill distribution:
0 - 19% = 12
20 - 39% = 25
40 - 59% = 23
60 - 79% = 20
80 - 99% = 6

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 8, nodes: 3075
Average data length: 2.84, total dup: 2636, max dup: 47
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 34.31, total records: 2754981
Average version length: 69.41, total versions: 1412540, max versions: 1
Data pages: 37350, data page slots: 37350, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 7381
80 - 99% = 29966

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 4114, nodes: 2754981
Average data length: 1.51, total dup: 2301991, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 3815
60 - 79% = 149
80 - 99% = 149

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 76.39, total records: 2024595
Average version length: 81.89, total versions: 139409, max versions: 1
Data pages: 30565, data page slots: 30565, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 6172
80 - 99% = 24392

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 2240, nodes: 2024595
Average data length: 0.15, total dup: 1979164, max dup: 199
Fill distribution:
0 - 19% = 11
20 - 39% = 2
40 - 59% = 1587
60 - 79% = 550
80 - 99% = 90

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 1495, nodes: 2024595
Average data length: 0.70, total dup: 1774410, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 55
60 - 79% = 3
80 - 99% = 1435

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 2532, nodes: 2024595
Average data length: 0.71, total dup: 1775379, max dup: 41
Fill distribution:
0 - 19% = 23
20 - 39% = 0
40 - 59% = 1761
60 - 79% = 651
80 - 99% = 97

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 47.23, total records: 2369195
Average version length: 81.46, total versions: 1010592, max versions: 1
Data pages: 35697, data page slots: 35697, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1
60 - 79% = 1561
80 - 99% = 34134

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2209, nodes: 2369195
Average data length: 0.10, total dup: 2335838, max dup: 816
Fill distribution:
0 - 19% = 3
20 - 39% = 4
40 - 59% = 801
60 - 79% = 934
80 - 99% = 467

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2259, nodes: 2369195
Average data length: 1.00, total dup: 1974660, max dup: 14
Fill distribution:
0 - 19% = 66
20 - 39% = 1
40 - 59% = 669
60 - 79% = 2
80 - 99% = 1521

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 2431, nodes: 2369195
Average data length: 0.44, total dup: 2191012, max dup: 134
Fill distribution:
0 - 19% = 36
20 - 39% = 7
40 - 59% = 920
60 - 79% = 959
80 - 99% = 509

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 58.54, total records: 2794040
Average version length: 82.17, total versions: 802882, max versions: 1
Data pages: 42154, data page slots: 42154, average fill: 84%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7599
80 - 99% = 34554

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 2688, nodes: 2794040
Average data length: 0.04, total dup: 2781878, max dup: 1536
Fill distribution:
0 - 19% = 5
20 - 39% = 15
40 - 59% = 1261
60 - 79% = 950
80 - 99% = 457

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 2042, nodes: 2794040
Average data length: 0.53, total dup: 2531367, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 109
60 - 79% = 19
80 - 99% = 1913

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 2972, nodes: 2794040
Average data length: 0.51, total dup: 2543762, max dup: 273
Fill distribution:
0 - 19% = 10
20 - 39% = 15
40 - 59% = 1335
60 - 79% = 1091
80 - 99% = 521

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: 49.84, total records: 2605096
Average version length: 81.34, total versions: 1026972, max versions: 1
Data pages: 39173, data page slots: 39173, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1596
80 - 99% = 37576

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2476, nodes: 2605096
Average data length: 0.03, total dup: 2596580, max dup: 1599
Fill distribution:
0 - 19% = 4
20 - 39% = 32
40 - 59% = 1071
60 - 79% = 922
80 - 99% = 447

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2664, nodes: 2605096
Average data length: 1.01, total dup: 2167810, max dup: 14
Fill distribution:
0 - 19% = 69
20 - 39% = 34
40 - 59% = 884
60 - 79% = 82
80 - 99% = 1595

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 2702, nodes: 2605096
Average data length: 0.41, total dup: 2423929, max dup: 144
Fill distribution:
0 - 19% = 4
20 - 39% = 23
40 - 59% = 1141
60 - 79% = 1070
80 - 99% = 464

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 38.13, total records: 425620
Average version length: 68.53, total versions: 189937, max versions: 1
Data pages: 5737, data page slots: 5737, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1701
80 - 99% = 4035

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 404, nodes: 425620
Average data length: 0.33, total dup: 404790, max dup: 127
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 164
60 - 79% = 144
80 - 99% = 96

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 464, nodes: 425620
Average data length: 0.88, total dup: 365899, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 191
60 - 79% = 183
80 - 99% = 90

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 13930 ms, from 4:01:13.04 to 4:01:26.97.

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 1225632 252317 20.5866
DOC_LIST 285386 8799 3.0831
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 962 240.5000
INVNT_TURNOVER_LOG 1915 1256 65.5874
MONEY_SALDO 49 64 130.6122
MONEY_TURNOVER_LOG 82 28 34.1463
OPTYPES 9 0 0.0000
PDISTR 114719 2327 2.0284
PERF_ESTIMATED 98839 2 0.0020
PERF_LOG 6146181 1 0.0000
PSTORNED 186205 33077 17.7637
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 17 425.0000
SETTINGS 114 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 1935 1712 88.4754
XQD_1000_3300 62723 5074 8.0895
XQD_1200_2000 7786 4556 58.5152
XQD_2000_3300 2660595 2248350 84.5055
XQD_2100_3300 3075 2286 74.3414
XQD_3300_3400 2754981 1412540 51.2722
XQS_1000_1200 2024595 139409 6.8857
XQS_1000_3300 2369195 1010592 42.6555
XQS_1200_2000 2794040 802882 28.7355
XQS_2100_3300 2605096 1026972 39.4216
XQS_3300_3400 425620 189937 44.6259
Z_USED_VIEWS 32 0 0.0000
Done for 2140 ms, from 4:01:35.78 to 4:01:37.92.

Database validation

04:01:38.00 Validation started

04:01:38.00 Relation 140 (DOC_LIST)
04:01:38.00 process pointer page 0 of 2
04:01:38.03 process pointer page 1 of 2
04:01:38.06 Index 1 (PK_DOC_LIST)
04:01:38.09 Index 2 (DOC_LIST_ID_DESC)
04:01:38.12 Index 3 (FK_DOC_LIST_AGENTS)
04:01:38.15 Relation 140 (DOC_LIST) is ok

04:01:38.15 Relation 141 (DOC_DATA)
04:01:38.15 process pointer page 0 of 7
04:01:38.18 process pointer page 1 of 7
04:01:38.21 process pointer page 2 of 7
04:01:38.25 process pointer page 3 of 7
04:01:38.28 process pointer page 4 of 7
04:01:38.32 process pointer page 5 of 7
04:01:38.35 process pointer page 6 of 7
04:01:38.37 Index 2 (DOC_DATA_DOC_WARE_UNQ)
04:01:38.51 Index 3 (DOC_DATA_ID_DESC)
04:01:38.63 Index 4 (FK_DOC_DATA_DOC_LIST)
04:01:38.71 Relation 141 (DOC_DATA) is ok

04:01:38.71 Relation 147 (INVNT_SALDO)
04:01:38.71 process pointer page 0 of 1
04:01:38.71 Index 1 (PK_INVNT_SALDO)
04:01:38.71 Relation 147 (INVNT_SALDO) is ok

04:01:38.71 Relation 150 (PDISTR)
04:01:38.71 process pointer page 0 of 1
04:01:38.73 Index 2 (PDISTR_SND_ID)
04:01:38.74 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
04:01:38.75 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
04:01:38.76 Index 5 (PDISTR_AGENT_ID)
04:01:38.77 Relation 150 (PDISTR) is ok

04:01:38.77 Relation 151 (PSTORNED)
04:01:38.77 process pointer page 0 of 2
04:01:38.80 process pointer page 1 of 2
04:01:38.80 Index 2 (PSTORNED_SND_ID)
04:01:38.82 Index 3 (PSTORNED_RCV_ID)
04:01:38.83 Relation 151 (PSTORNED) is ok

04:01:38.83 Relation 156 (SEMAPHORES)
04:01:38.83 process pointer page 0 of 1
04:01:38.83 Index 1 (PK_SEMAPHORES)
04:01:38.83 Index 2 (SEMAPHORES_TASK_UNQ)
04:01:38.83 Relation 156 (SEMAPHORES) is ok

04:01:38.83 Relation 157 (INVNT_TURNOVER_LOG)
04:01:38.83 process pointer page 0 of 1
04:01:38.83 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
04:01:38.83 Relation 157 (INVNT_TURNOVER_LOG) is ok

04:01:38.83 Relation 160 (PERF_ESTIMATED)
04:01:38.83 process pointer page 0 of 1
04:01:38.84 Index 1 (PERF_EST_MINUTE_SINCE_START)
04:01:38.84 Relation 160 (PERF_ESTIMATED) is ok

04:01:38.84 Relation 161 (PERF_ISQL_STAT)
04:01:38.84 process pointer page 0 of 1
04:01:38.84 Index 1 (PERF_ISQL_STAT_TRN)
04:01:38.84 Relation 161 (PERF_ISQL_STAT) is ok

04:01:38.84 Relation 162 (PERF_LOG)
04:01:38.84 process pointer page 0 of 76
04:01:38.86 process pointer page 1 of 76
04:01:38.89 process pointer page 2 of 76
04:01:38.91 process pointer page 3 of 76
04:01:38.93 process pointer page 4 of 76
04:01:38.95 process pointer page 5 of 76
04:01:38.97 process pointer page 6 of 76
04:01:38.99 process pointer page 7 of 76
04:01:39.02 process pointer page 8 of 76
04:01:39.04 process pointer page 9 of 76
04:01:39.07 process pointer page 10 of 76
04:01:39.10 process pointer page 11 of 76
04:01:39.12 process pointer page 12 of 76
04:01:39.14 process pointer page 13 of 76
04:01:39.18 process pointer page 14 of 76
04:01:39.25 process pointer page 15 of 76
04:01:39.28 process pointer page 16 of 76
04:01:39.31 process pointer page 17 of 76
04:01:39.33 process pointer page 18 of 76
04:01:39.39 process pointer page 19 of 76
04:01:39.46 process pointer page 20 of 76
04:01:39.53 process pointer page 21 of 76
04:01:39.60 process pointer page 22 of 76
04:01:39.67 process pointer page 23 of 76
04:01:39.74 process pointer page 24 of 76
04:01:39.82 process pointer page 25 of 76
04:01:39.89 process pointer page 26 of 76
04:01:39.96 process pointer page 27 of 76
04:01:40.03 process pointer page 28 of 76
04:01:40.11 process pointer page 29 of 76
04:01:40.18 process pointer page 30 of 76
04:01:40.25 process pointer page 31 of 76
04:01:40.28 process pointer page 32 of 76
04:01:40.30 process pointer page 33 of 76
04:01:40.33 process pointer page 34 of 76
04:01:40.36 process pointer page 35 of 76
04:01:40.39 process pointer page 36 of 76
04:01:40.41 process pointer page 37 of 76
04:01:40.44 process pointer page 38 of 76
04:01:40.46 process pointer page 39 of 76
04:01:40.48 process pointer page 40 of 76
04:01:40.51 process pointer page 41 of 76
04:01:40.53 process pointer page 42 of 76
04:01:40.56 process pointer page 43 of 76
04:01:40.58 process pointer page 44 of 76
04:01:40.60 process pointer page 45 of 76
04:01:40.62 process pointer page 46 of 76
04:01:40.64 process pointer page 47 of 76
04:01:40.66 process pointer page 48 of 76
04:01:40.68 process pointer page 49 of 76
04:01:40.70 process pointer page 50 of 76
04:01:40.72 process pointer page 51 of 76
04:01:40.74 process pointer page 52 of 76
04:01:40.76 process pointer page 53 of 76
04:01:40.78 process pointer page 54 of 76
04:01:40.80 process pointer page 55 of 76
04:01:40.82 process pointer page 56 of 76
04:01:40.84 process pointer page 57 of 76
04:01:40.86 process pointer page 58 of 76
04:01:40.88 process pointer page 59 of 76
04:01:40.90 process pointer page 60 of 76
04:01:40.92 process pointer page 61 of 76
04:01:40.94 process pointer page 62 of 76
04:01:40.96 process pointer page 63 of 76
04:01:40.98 process pointer page 64 of 76
04:01:41.00 process pointer page 65 of 76
04:01:41.02 process pointer page 66 of 76
04:01:41.04 process pointer page 67 of 76
04:01:41.06 process pointer page 68 of 76
04:01:41.09 process pointer page 69 of 76
04:01:41.14 process pointer page 70 of 76
04:01:41.21 process pointer page 71 of 76
04:01:41.29 process pointer page 72 of 76
04:01:41.35 process pointer page 73 of 76
04:01:41.38 process pointer page 74 of 76
04:01:41.41 process pointer page 75 of 76
04:01:41.41 Index 1 (PERF_LOG_DTS_BEG_DESC)
04:01:42.23 Index 2 (PERF_LOG_UNIT)
04:01:43.95 Index 3 (PERF_LOG_TRN_DESC)
04:01:44.39 Index 4 (PERF_LOG_GDSCODE)
04:01:45.17 Relation 162 (PERF_LOG) is ok

04:01:45.17 Relation 166 (V_STOPTEST)
04:01:45.17 Relation 166 (V_STOPTEST) is ok

04:01:45.17 Relation 183 (V_QDISTR_SOURCE)
04:01:45.17 Relation 183 (V_QDISTR_SOURCE) is ok

04:01:45.17 Relation 184 (V_QSTORNED_SOURCE)
04:01:45.17 Relation 184 (V_QSTORNED_SOURCE) is ok

04:01:45.17 Relation 258 (XQD_1000_1200)
04:01:45.17 process pointer page 0 of 1
04:01:45.17 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
04:01:45.17 Relation 258 (XQD_1000_1200) is ok

04:01:45.17 Relation 259 (XQD_1200_2000)
04:01:45.17 process pointer page 0 of 1
04:01:45.18 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
04:01:45.18 Relation 259 (XQD_1200_2000) is ok

04:01:45.18 Relation 260 (XQD_1000_3300)
04:01:45.18 process pointer page 0 of 1
04:01:45.19 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
04:01:45.20 Index 2 (XQD_1000_3300_DOC)
04:01:45.21 Relation 260 (XQD_1000_3300) is ok

04:01:45.21 Relation 261 (XQD_2000_3300)
04:01:45.21 process pointer page 0 of 19
04:01:45.26 process pointer page 1 of 19
04:01:45.30 process pointer page 2 of 19
04:01:45.35 process pointer page 3 of 19
04:01:45.40 process pointer page 4 of 19
04:01:45.57 process pointer page 5 of 19
04:01:45.74 process pointer page 6 of 19
04:01:45.88 process pointer page 7 of 19
04:01:45.97 process pointer page 8 of 19
04:01:46.09 process pointer page 9 of 19
04:01:46.19 process pointer page 10 of 19
04:01:46.25 process pointer page 11 of 19
04:01:46.31 process pointer page 12 of 19
04:01:46.36 process pointer page 13 of 19
04:01:46.41 process pointer page 14 of 19
04:01:46.47 process pointer page 15 of 19
04:01:46.56 process pointer page 16 of 19
04:01:46.66 process pointer page 17 of 19
04:01:46.70 process pointer page 18 of 19
04:01:46.74 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
04:01:47.01 Relation 261 (XQD_2000_3300) is ok

04:01:47.01 Relation 262 (XQD_2100_3300)
04:01:47.01 process pointer page 0 of 2
04:01:47.01 process pointer page 1 of 2
04:01:47.01 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
04:01:47.02 Relation 262 (XQD_2100_3300) is ok

04:01:47.02 Relation 263 (XQD_3300_3400)
04:01:47.02 process pointer page 0 of 20
04:01:47.06 process pointer page 1 of 20
04:01:47.10 process pointer page 2 of 20
04:01:47.14 process pointer page 3 of 20
04:01:47.19 process pointer page 4 of 20
04:01:47.25 process pointer page 5 of 20
04:01:47.37 process pointer page 6 of 20
04:01:47.42 process pointer page 7 of 20
04:01:47.47 process pointer page 8 of 20
04:01:47.53 process pointer page 9 of 20
04:01:47.61 process pointer page 10 of 20
04:01:47.68 process pointer page 11 of 20
04:01:47.77 process pointer page 12 of 20
04:01:47.81 process pointer page 13 of 20
04:01:47.86 process pointer page 14 of 20
04:01:47.91 process pointer page 15 of 20
04:01:48.01 process pointer page 16 of 20
04:01:48.07 process pointer page 17 of 20
04:01:48.18 process pointer page 18 of 20
04:01:48.29 process pointer page 19 of 20
04:01:48.33 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
04:01:48.86 Relation 263 (XQD_3300_3400) is ok

04:01:48.86 Relation 264 (XQS_1000_1200)
04:01:48.86 process pointer page 0 of 16
04:01:48.89 process pointer page 1 of 16
04:01:48.98 process pointer page 2 of 16
04:01:49.03 process pointer page 3 of 16
04:01:49.06 process pointer page 4 of 16
04:01:49.10 process pointer page 5 of 16
04:01:49.13 process pointer page 6 of 16
04:01:49.17 process pointer page 7 of 16
04:01:49.20 process pointer page 8 of 16
04:01:49.23 process pointer page 9 of 16
04:01:49.27 process pointer page 10 of 16
04:01:49.30 process pointer page 11 of 16
04:01:49.32 process pointer page 12 of 16
04:01:49.35 process pointer page 13 of 16
04:01:49.37 process pointer page 14 of 16
04:01:49.40 process pointer page 15 of 16
04:01:49.43 Index 1 (XQS_1000_1200_DOC_ID)
04:01:49.71 Index 2 (XQS_1000_1200_SND_ID)
04:01:49.89 Index 3 (XQS_1000_1200_RCV_ID)
04:01:50.03 Relation 264 (XQS_1000_1200) is ok

04:01:50.03 Relation 265 (XQS_1200_2000)
04:01:50.03 process pointer page 0 of 22
04:01:50.06 process pointer page 1 of 22
04:01:50.10 process pointer page 2 of 22
04:01:50.13 process pointer page 3 of 22
04:01:50.16 process pointer page 4 of 22
04:01:50.19 process pointer page 5 of 22
04:01:50.23 process pointer page 6 of 22
04:01:50.26 process pointer page 7 of 22
04:01:50.29 process pointer page 8 of 22
04:01:50.33 process pointer page 9 of 22
04:01:50.36 process pointer page 10 of 22
04:01:50.40 process pointer page 11 of 22
04:01:50.43 process pointer page 12 of 22
04:01:50.46 process pointer page 13 of 22
04:01:50.50 process pointer page 14 of 22
04:01:50.61 process pointer page 15 of 22
04:01:50.71 process pointer page 16 of 22
04:01:50.75 process pointer page 17 of 22
04:01:50.79 process pointer page 18 of 22
04:01:50.83 process pointer page 19 of 22
04:01:50.86 process pointer page 20 of 22
04:01:50.89 process pointer page 21 of 22
04:01:50.92 Index 1 (XQS_1200_2000_DOC_ID)
04:01:51.14 Index 2 (XQS_1200_2000_SND_ID)
04:01:51.54 Index 3 (XQS_1200_2000_RCV_ID)
04:01:51.76 Relation 265 (XQS_1200_2000) is ok

04:01:51.76 Relation 266 (XQS_1000_3300)
04:01:51.76 process pointer page 0 of 19
04:01:51.79 process pointer page 1 of 19
04:01:51.83 process pointer page 2 of 19
04:01:51.87 process pointer page 3 of 19
04:01:51.90 process pointer page 4 of 19
04:01:51.94 process pointer page 5 of 19
04:01:51.98 process pointer page 6 of 19
04:01:52.07 process pointer page 7 of 19
04:01:52.17 process pointer page 8 of 19
04:01:52.22 process pointer page 9 of 19
04:01:52.26 process pointer page 10 of 19
04:01:52.31 process pointer page 11 of 19
04:01:52.34 process pointer page 12 of 19
04:01:52.38 process pointer page 13 of 19
04:01:52.41 process pointer page 14 of 19
04:01:52.45 process pointer page 15 of 19
04:01:52.48 process pointer page 16 of 19
04:01:52.51 process pointer page 17 of 19
04:01:52.54 process pointer page 18 of 19
04:01:52.55 Index 1 (XQS_1000_3300_DOC_ID)
04:01:52.73 Index 2 (XQS_1000_3300_SND_ID)
04:01:52.93 Index 3 (XQS_1000_3300_RCV_ID)
04:01:53.10 Relation 266 (XQS_1000_3300) is ok

04:01:53.10 Relation 267 (XQS_2000_3300)
04:01:53.10 process pointer page 0 of 1
04:01:53.10 Index 1 (XQS_2000_3300_DOC_ID)
04:01:53.10 Index 2 (XQS_2000_3300_SND_ID)
04:01:53.10 Index 3 (XQS_2000_3300_RCV_ID)
04:01:53.10 Relation 267 (XQS_2000_3300) is ok

04:01:53.10 Relation 268 (XQS_2100_3300)
04:01:53.10 process pointer page 0 of 21
04:01:53.13 process pointer page 1 of 21
04:01:53.20 process pointer page 2 of 21
04:01:53.33 process pointer page 3 of 21
04:01:53.39 process pointer page 4 of 21
04:01:53.45 process pointer page 5 of 21
04:01:53.50 process pointer page 6 of 21
04:01:53.54 process pointer page 7 of 21
04:01:53.58 process pointer page 8 of 21
04:01:53.62 process pointer page 9 of 21
04:01:53.66 process pointer page 10 of 21
04:01:53.69 process pointer page 11 of 21
04:01:53.72 process pointer page 12 of 21
04:01:53.75 process pointer page 13 of 21
04:01:53.78 process pointer page 14 of 21
04:01:53.81 process pointer page 15 of 21
04:01:53.83 process pointer page 16 of 21
04:01:53.86 process pointer page 17 of 21
04:01:53.89 process pointer page 18 of 21
04:01:53.92 process pointer page 19 of 21
04:01:53.95 process pointer page 20 of 21
04:01:53.96 Index 1 (XQS_2100_3300_DOC_ID)
04:01:54.19 Index 2 (XQS_2100_3300_SND_ID)
04:01:54.43 Index 3 (XQS_2100_3300_RCV_ID)
04:01:54.61 Relation 268 (XQS_2100_3300) is ok

04:01:54.61 Relation 269 (XQS_3300_3400)
04:01:54.61 process pointer page 0 of 3
04:01:54.65 process pointer page 1 of 3
04:01:54.69 process pointer page 2 of 3
04:01:54.72 Index 1 (XQS_3300_3400_DOC_ID)
04:01:54.75 Index 2 (XQS_3300_3400_SND_ID)
04:01:54.78 Relation 269 (XQS_3300_3400) is ok

04:01:54.78 Validation finished
Done for 16840 ms, from 4:01:37.94 to 4:01:54.78.

Differences between old and current firebird.log

4:01:55.06. 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:
2015-12-19 04:01 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 +++
Comparing files E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
FC: no differences encountered
+++ end of comparison +++

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


Remove 14 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.
2015-12-19 4:01:58.15 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html