Tests

Generated by E:\OLTP-HQBIRD\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 10. 2016-05-31 23:14:18.02.
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-V3.0.1.32525 Firebird 3.0 HQbird
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 3.0.1 D:\OLTP-EMUL\OLTP30-SMALL-HQBIRD.FDB ON 0 50000 8192

Test configuration settings

File: E:\OLTP-HQBIRD\src\oltp30_config.win
PARAM_NAME PARAM_VALUE
fbc E:\Firebird3hqbird
dbnm D:\OLTP-EMUL\oltp30-small-hqbird.fdb
host localhost
port 3063
usr SYSDBA
pwd masterkey
tmpdir E:\OLTP-BIRD\tmp
working_mode small_03
warm_time 10
test_time 20
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
file_name_this_host_info ak30
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-05-31 23:14:06.9790 -1 <null> ::1/59497 392926 5451 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
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
COMMON ENABLE_MON_QUERY 0
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 20 minutes: 7994.65 3285 159893 2016-05-31 22:54 2016-05-31 23:14
customer order: creation 296.20 50 5924 2016-05-31 22:54 2016-05-31 23:14
customer order: refuse 25.45 50 509 2016-05-31 22:54 2016-05-31 23:14
order to supplier: creation 74.35 274 1487 2016-05-31 22:54 2016-05-31 23:14
order to supplier: removal 3.11 24501 59 2016-05-31 22:54 2016-05-31 23:14
invoice (draft): creation 77.20 876 1544 2016-05-31 22:54 2016-05-31 23:14
invoice (draft): removal 69.32 380 1317 2016-05-31 22:54 2016-05-31 23:14
invoice accept: apply 55.20 2752 1104 2016-05-31 22:54 2016-05-31 23:14
invoice accept: cancel 35.32 422 671 2016-05-31 22:54 2016-05-31 23:14
customer reserve: creation 4380.80 26 87616 2016-05-31 22:54 2016-05-31 23:14
customer reserve: removal 2651.42 17 50377 2016-05-31 22:54 2016-05-31 23:14
realization accept: apply 139.80 86 2796 2016-05-31 22:54 2016-05-31 23:14
realization accept: cancel 87.80 29 1756 2016-05-31 22:54 2016-05-31 23:14
payment from customer: creation 95.30 157 1906 2016-05-31 22:54 2016-05-31 23:14
payment from customer: removal 9.35 19 187 2016-05-31 22:54 2016-05-31 23:14
payment to supplier: creation 82.25 34 1645 2016-05-31 22:54 2016-05-31 23:14
payment to supplier: removal 6.84 21 130 2016-05-31 22:54 2016-05-31 23:14
service: total inventory turnovers 25.45 319 509 2016-05-31 22:54 2016-05-31 23:14
service: total monetary turnovers 17.75 11 355 2016-05-31 22:54 2016-05-31 23:14
service: refresh index statistics 1.00 32396 1 2016-05-31 22:54 2016-05-31 23:14
Done for 12870 ms, from 23:14:40.97 to 23:14:53.84.

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 7470 16087 14940 1147 7.13 22:54:07 22:56:07
interval # 2, overall 2 10129 20838 20257 581 2.79 22:56:08 22:58:08
interval # 3, overall 3 6442 13948 12884 1064 7.63 22:58:09 23:00:09
interval # 4, overall 4 7074 14318 14148 170 1.19 23:00:10 23:02:10
interval # 5, overall 5 5495 14556 10990 3566 24.50 23:02:11 23:04:11
interval # 6, overall 6 8122 16278 16243 35 0.22 23:04:12 23:06:12
interval # 7, overall 7 8052 16126 16104 22 0.14 23:06:13 23:08:13
interval # 8, overall 8 6224 12494 12447 47 0.38 23:08:14 23:10:14
interval # 9, overall 9 11623 23906 23245 661 2.76 23:10:15 23:12:15
interval # 10, overall 10 9318 19622 18635 987 5.03 23:12:16 23:14:16
Done for 28910 ms, from 23:15:20.41 to 23:15:49.32.

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 15857.47 0.7457 1.3156 1556 10
WARM_TIME 2 12723.65 0.8198 1.1628 1382 10
WARM_TIME 3 11832.01 0.8336 1.1799 1177 10
WARM_TIME 4 11669.85 0.8972 1.1122 1375 10
WARM_TIME 5 11640.12 0.8920 1.0692 1372 10
WARM_TIME 6 11168.01 0.9286 1.0697 1221 10
WARM_TIME 7 10925.32 0.9373 1.0626 1158 10
WARM_TIME 8 10696.31 0.9497 1.0540 1140 10
WARM_TIME 9 10553.28 0.9496 1.0558 1125 10
WARM_TIME 10 10410.89 0.9632 1.0418 1084 9
TEST_TIME 11 10207.66 0.9660 1.0303 1120 10
TEST_TIME 12 9939.66 0.9699 1.0295 1059 10
TEST_TIME 13 9760.74 0.9678 1.0486 831 10
TEST_TIME 14 9913.35 0.9587 1.0259 833 10
TEST_TIME 15 9746.35 0.9739 1.0227 939 10
TEST_TIME 16 9540.93 0.9794 1.0276 973 10
TEST_TIME 17 9385.98 0.9837 1.0166 1119 9
TEST_TIME 18 9194.64 0.9801 1.0136 900 10
TEST_TIME 19 9002.79 0.9807 1.0178 889 10
TEST_TIME 20 8848.58 0.9841 1.0248 949 9
TEST_TIME 21 8826.15 0.9785 1.0160 944 9
TEST_TIME 22 8752.61 0.9780 1.0185 693 10
TEST_TIME 23 8771.49 0.9733 1.0167 833 10
TEST_TIME 24 8688.48 0.9837 1.0135 734 10
TEST_TIME 25 8586.47 0.9845 1.0137 967 10
TEST_TIME 26 8575.20 0.9760 1.0224 1200 10
TEST_TIME 27 8694.18 0.9711 1.0223 1327 10
TEST_TIME 28 8754.82 0.9790 1.0137 1078 10
TEST_TIME 29 8767.74 0.9773 1.0169 1156 9
TEST_TIME 30 8668.33 0.9942 1.0081 101 10
Done for 3630 ms, from 23:15:49.84 to 23:15:53.47.

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 61119 72445 54601 <null> 67158 45779 85704 59974 96146 22310 57383 19315 101661 67066 100168 108000 449479 660984 <null> 22:54:07 22:56:07
fetches per second 2 56928 105939 44282 73212 58529 <null> 85605 62082 151272 <null> 43587 <null> 76176 64912 120210 101331 331050 587428 <null> 22:56:08 22:58:08
fetches per second 3 50312 46287 47116 <null> 59514 46769 77212 82492 54045 48450 57008 26157 105056 75083 86146 63968 456025 520661 <null> 22:58:09 23:00:09
fetches per second 4 53997 61511 60736 42336 67332 <null> 89393 <null> 21340 48485 51247 19649 111528 62277 219689 <null> 383093 573923 <null> 23:00:10 23:02:10
fetches per second 5 52450 48577 43021 <null> 51452 28181 81039 <null> 83182 82796 55064 17632 93729 46247 107688 61523 303612 25660 <null> 23:02:11 23:04:11
fetches per second 6 52096 37720 47258 56406 56371 <null> 75334 45115 36209 71586 37812 23558 86089 75040 167110 86200 379991 <null> <null> 23:04:12 23:06:12
fetches per second 7 57834 19348 56633 52895 47982 18293 80169 64355 212400 90904 82109 18301 113711 51739 106409 <null> 701539 548125 <null> 23:06:13 23:08:13
fetches per second 8 64716 61999 60647 <null> 65419 <null> 88341 73700 112062 48068 65896 24001 99727 66538 87844 <null> 408538 367642 <null> 23:08:14 23:10:14
fetches per second 9 63165 77873 47273 58738 60169 <null> 109007 86907 96947 63950 74839 29553 108360 <null> 174714 131053 432627 632431 <null> 23:10:15 23:12:15
fetches per second 10 57235 66861 58606 82885 54225 <null> 110304 <null> 88573 71347 60553 23957 101919 97364 156951 74470 297068 604538 <null> 23:12:16 23:14:16
marks per second 1 10393 7027 8319 <null> 7388 7372 6524 5460 3901 2578 7332 1850 2483 7200 10463 9200 9163 23107 <null> 22:54:07 22:56:07
marks per second 2 9871 9185 7493 6757 7712 <null> 5236 5739 7818 <null> 4999 <null> 1435 8487 10657 12150 9418 17964 <null> 22:56:08 22:58:08
marks per second 3 8697 4434 7317 <null> 7417 7413 5476 7830 4728 5734 4218 2980 2962 7116 7889 8298 6460 6050 <null> 22:58:09 23:00:09
marks per second 4 8857 5663 8377 5262 7217 <null> 6107 <null> 1840 4685 6179 2182 1921 5833 6667 <null> 8453 9858 <null> 23:00:10 23:02:10
marks per second 5 8860 4614 6836 <null> 7045 3946 5818 <null> 4585 8747 6951 1663 3023 4646 7660 7904 37445 5077 <null> 23:02:11 23:04:11
marks per second 6 8671 3524 6606 6496 7164 <null> 4627 4048 1093 8793 5771 2123 1757 7930 10315 10866 5382 <null> <null> 23:04:12 23:06:12
marks per second 7 9646 1871 8761 4774 5683 2864 5356 5875 8200 10095 4609 1720 2756 5608 8450 <null> 5219 8321 <null> 23:06:13 23:08:13
marks per second 8 10810 5808 9730 <null> 7374 <null> 7089 7032 5250 5107 4244 2715 3468 6156 8103 <null> 5456 8840 <null> 23:08:14 23:10:14
marks per second 9 10833 6928 7409 5282 7626 <null> 6779 8225 7619 6193 5845 3438 1606 <null> 12455 17383 5504 10272 <null> 23:10:15 23:12:15
marks per second 10 9507 6210 8166 9994 5623 <null> 6810 <null> 4883 6478 5692 2436 1435 9848 8267 9000 6019 12292 <null> 23:12:16 23:14:16
reads/fetches*100 1 0 1 0 <null> 0 1 0 1 0 1 1 1 0 1 0 0 0 0 <null> 22:54:07 22:56:07
reads/fetches*100 2 0 1 0 0 0 <null> 0 0 1 <null> 1 <null> 0 1 0 1 0 0 <null> 22:56:08 22:58:08
reads/fetches*100 3 0 1 0 <null> 0 1 0 0 0 1 1 1 0 1 0 1 0 0 <null> 22:58:09 23:00:09
reads/fetches*100 4 0 1 0 1 0 <null> 0 <null> 1 1 1 1 0 0 0 <null> 0 0 <null> 23:00:10 23:02:10
reads/fetches*100 5 0 1 0 <null> 0 1 0 <null> 1 1 1 1 0 0 0 1 0 0 <null> 23:02:11 23:04:11
reads/fetches*100 6 0 1 0 0 0 <null> 0 0 0 1 1 1 0 1 0 0 0 <null> <null> 23:04:12 23:06:12
reads/fetches*100 7 0 1 0 0 0 1 0 0 0 1 1 0 0 1 0 <null> 0 0 <null> 23:06:13 23:08:13
reads/fetches*100 8 0 1 0 <null> 0 <null> 0 0 0 1 1 1 0 1 0 <null> 0 0 <null> 23:08:14 23:10:14
reads/fetches*100 9 0 1 0 0 0 <null> 0 0 0 1 1 1 0 <null> 0 1 0 0 <null> 23:10:15 23:12:15
reads/fetches*100 10 0 1 0 0 0 <null> 0 <null> 0 1 1 1 0 1 0 0 0 0 <null> 23:12:16 23:14:16
writes/marks*100 1 0 0 0 <null> 0 0 0 0 1 1 0 0 0 0 0 0 3 2 <null> 22:54:07 22:56:07
writes/marks*100 2 0 0 0 0 0 <null> 0 1 1 <null> 0 <null> 0 0 0 0 4 0 <null> 22:56:08 22:58:08
writes/marks*100 3 0 0 0 <null> 0 0 0 1 0 0 3 0 0 0 0 0 5 0 <null> 22:58:09 23:00:09
writes/marks*100 4 0 0 0 0 0 <null> 0 <null> 1 0 0 0 0 0 0 <null> 2 0 <null> 23:00:10 23:02:10
writes/marks*100 5 0 0 0 <null> 0 0 0 <null> 1 1 0 0 1 0 0 2 3 9 <null> 23:02:11 23:04:11
writes/marks*100 6 0 0 0 0 0 <null> 0 0 1 0 0 0 0 0 0 0 2 <null> <null> 23:04:12 23:06:12
writes/marks*100 7 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 <null> 4 0 <null> 23:06:13 23:08:13
writes/marks*100 8 0 0 1 <null> 0 <null> 0 0 0 2 0 1 0 0 0 <null> 4 1 <null> 23:08:14 23:10:14
writes/marks*100 9 0 0 0 0 0 <null> 0 0 1 0 0 0 0 <null> 0 0 4 0 <null> 23:10:15 23:12:15
writes/marks*100 10 0 0 0 0 0 <null> 0 <null> 1 1 1 0 0 0 0 0 3 0 <null> 23:12:16 23:14:16
Done for 9580 ms, from 23:15:54.13 to 23:16:03.71.

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 255242 247376 7866 3.08 0 1092 4 7866 2016-05-31 22:54 2016-05-31 23:14
doc_list_biud 255257 247375 7882 3.08 0 1919 6 7882 2016-05-31 22:54 2016-05-31 23:14
sp_add_invoice_to_stock 1412 1104 308 21.81 62 13463 2752 308 2016-05-31 22:54 2016-05-31 23:14
sp_cancel_adding_invoice 742 671 71 9.56 15 9832 422 71 2016-05-31 22:54 2016-05-31 23:14
sp_cancel_client_order 520 509 11 2.11 0 390 50 11 2016-05-31 22:54 2016-05-31 23:14
sp_cancel_customer_reserve 57822 50377 7445 12.87 0 483 17 7445 2016-05-31 22:54 2016-05-31 23:14
sp_cancel_pay_from_customer 187 187 0 0.00 0 172 19 0 2016-05-31 22:54 2016-05-31 23:14
sp_cancel_pay_to_supplier 130 130 0 0.00 0 161 21 0 2016-05-31 22:54 2016-05-31 23:14
sp_cancel_supplier_invoice 1454 1317 137 9.42 0 3104 380 137 2016-05-31 22:54 2016-05-31 23:14
sp_cancel_supplier_order 102 59 43 42.15 16 75006 24501 43 2016-05-31 22:54 2016-05-31 23:14
sp_cancel_write_off 2009 1756 253 12.59 0 266 29 253 2016-05-31 22:54 2016-05-31 23:14
sp_client_order 5924 5924 0 0.00 0 281 50 0 2016-05-31 22:54 2016-05-31 23:14
sp_customer_reserve 87616 87616 0 0.00 0 499 26 0 2016-05-31 22:54 2016-05-31 23:14
sp_fill_shopping_cart 8955 8955 0 0.00 0 2028 25 0 2016-05-31 22:54 2016-05-31 23:14
sp_fill_shopping_cart_clo_res 87616 87616 0 0.00 0 484 4 0 2016-05-31 22:54 2016-05-31 23:14
sp_get_clo_for_invoice 1105 1105 0 0.00 0 1326 146 0 2016-05-31 22:54 2016-05-31 23:14
sp_kill_cost_storno 3056 2744 312 10.20 0 375 6 312 2016-05-31 22:54 2016-05-31 23:14
sp_kill_qstorno_ret_qs2qd 119134 103887 15247 12.79 0 1919 8 15247 2016-05-31 22:54 2016-05-31 23:14
sp_kill_qty_storno 66473 58592 7881 11.85 0 1919 21 7881 2016-05-31 22:54 2016-05-31 23:14
sp_lock_selected_doc 5847 5438 409 6.99 0 63 1 409 2016-05-31 22:54 2016-05-31 23:14
sp_make_cost_storno 7453 7453 0 0.00 0 1076 58 0 2016-05-31 22:54 2016-05-31 23:14
sp_multiply_rows_for_pdistr 7453 7453 0 0.00 0 171 5 0 2016-05-31 22:54 2016-05-31 23:14
sp_multiply_rows_for_qdistr 5925 5925 0 0.00 0 234 19 0 2016-05-31 22:54 2016-05-31 23:14
sp_pay_from_customer 1906 1906 0 0.00 31 1139 157 0 2016-05-31 22:54 2016-05-31 23:14
sp_pay_to_supplier 1645 1645 0 0.00 0 328 34 0 2016-05-31 22:54 2016-05-31 23:14
sp_payment_common 3551 3551 0 0.00 0 188 18 0 2016-05-31 22:54 2016-05-31 23:14
sp_qd_handle_on_cancel_clo 520 509 11 2.11 0 374 30 11 2016-05-31 22:54 2016-05-31 23:14
sp_qd_handle_on_invoice_upd_sts 1845 1776 69 3.73 0 795 135 69 2016-05-31 22:54 2016-05-31 23:14
sp_qd_handle_on_reserve_upd_sts 2797 2797 0 0.00 0 187 8 0 2016-05-31 22:54 2016-05-31 23:14
sp_reserve_write_off 2808 2796 12 0.42 0 960 86 12 2016-05-31 22:54 2016-05-31 23:14
sp_supplier_invoice 1544 1544 0 0.00 0 3510 876 0 2016-05-31 22:54 2016-05-31 23:14
sp_supplier_order 1487 1487 0 0.00 0 2059 274 0 2016-05-31 22:54 2016-05-31 23:14
srv_find_qd_qs_mism 158920 151051 7869 4.95 0 280 2 7869 2016-05-31 22:54 2016-05-31 23:14
srv_make_invnt_saldo 509 509 0 0.00 0 10531 319 0 2016-05-31 22:54 2016-05-31 23:14
srv_make_money_saldo 355 355 0 0.00 0 171 11 0 2016-05-31 22:54 2016-05-31 23:14
srv_recalc_idx_stat 1 1 0 0.00 32396 32396 32396 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-abend:sp_add_invoice_to_stock 308 308 0 0.00 0 78 4 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-abend:sp_cancel_adding_invoice 4 4 0 0.00 0 109 31 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-abend:sp_cancel_client_order 11 11 0 0.00 0 62 12 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-abend:sp_cancel_customer_reserve 3 3 0 0.00 0 0 0 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-abend:sp_cancel_supplier_invoice 26 26 0 0.00 0 16 5 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-abend:sp_cancel_supplier_order 1098 1098 0 0.00 0 234 44 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-abend:sp_cancel_write_off 3 3 0 0.00 0 15 5 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-abend:sp_reserve_write_off 12 12 0 0.00 0 16 3 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_add_invoice_to_stock 1105 1105 0 0.00 0 1326 242 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_cancel_adding_invoice 102 102 0 0.00 0 874 193 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_cancel_client_order 509 509 0 0.00 0 109 5 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_cancel_customer_reserve 187 187 0 0.00 0 187 5 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_cancel_pay_from_customer 187 187 0 0.00 0 31 3 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_cancel_pay_to_supplier 130 130 0 0.00 0 31 5 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_cancel_supplier_invoice 96 96 0 0.00 0 31 6 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_cancel_supplier_order 60 60 0 0.00 0 7597 2226 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_cancel_write_off 266 266 0 0.00 0 78 5 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_client_order 5925 5925 0 0.00 0 141 5 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_customer_reserve 264 264 0 0.00 0 63 3 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_pay_from_customer 1906 1906 0 0.00 0 141 4 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_pay_to_supplier 1645 1645 0 0.00 0 94 4 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_reserve_write_off 2797 2797 0 0.00 0 159 5 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_supplier_invoice 1545 1545 0 0.00 0 141 6 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:sp_supplier_order 1487 1487 0 0.00 0 125 6 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:srv_make_invnt_saldo 509 509 0 0.00 0 46 0 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:srv_make_money_saldo 355 355 0 0.00 0 16 0 0 2016-05-31 22:54 2016-05-31 23:14
t$perf-norm:srv_recalc_idx_stat 1 1 0 0.00 21 21 21 0 2016-05-31 22:54 2016-05-31 23:14
v_add_invoice_to_stock 2824 2208 616 21.81 0 47 1 616 2016-05-31 22:54 2016-05-31 23:14
v_all_customers 8898 8898 0 0.00 0 78 0 0 2016-05-31 22:54 2016-05-31 23:14
v_all_suppliers 7526 7526 0 0.00 0 63 0 0 2016-05-31 22:54 2016-05-31 23:14
v_all_wares 11849 11849 0 0.00 0 47 0 0 2016-05-31 22:54 2016-05-31 23:14
v_cancel_adding_invoice 210 204 6 2.85 0 452 47 6 2016-05-31 22:54 2016-05-31 23:14
v_cancel_client_order 1040 1018 22 2.11 0 78 1 22 2016-05-31 22:54 2016-05-31 23:14
v_cancel_customer_prepayment 374 374 0 0.00 0 16 0 0 2016-05-31 22:54 2016-05-31 23:14
v_cancel_customer_reserve 380 374 6 1.57 0 16 0 6 2016-05-31 22:54 2016-05-31 23:14
v_cancel_payment_to_supplier 260 260 0 0.00 0 54 1 0 2016-05-31 22:54 2016-05-31 23:14
v_cancel_supplier_invoice 244 192 52 21.31 0 31 2 52 2016-05-31 22:54 2016-05-31 23:14
v_cancel_supplier_order 204 118 86 42.15 0 16 1 86 2016-05-31 22:54 2016-05-31 23:14
v_cancel_write_off 538 532 6 1.11 0 234 27 6 2016-05-31 22:54 2016-05-31 23:14
v_max_id_clo_ord 1487 1487 0 0.00 0 94 1 0 2016-05-31 22:54 2016-05-31 23:14
v_max_id_clo_res 264 264 0 0.00 0 20 1 0 2016-05-31 22:54 2016-05-31 23:14
v_max_id_ord_sup 1544 1544 0 0.00 0 109 1 0 2016-05-31 22:54 2016-05-31 23:14
v_max_non_paid_invoice 913 913 0 0.00 0 47 1 0 2016-05-31 22:54 2016-05-31 23:14
v_max_non_paid_realizn 1906 1906 0 0.00 0 47 0 0 2016-05-31 22:54 2016-05-31 23:14
v_min_id_clo_ord 1487 1487 0 0.00 0 125 2 0 2016-05-31 22:54 2016-05-31 23:14
v_min_id_clo_res 264 264 0 0.00 0 16 1 0 2016-05-31 22:54 2016-05-31 23:14
v_min_id_ord_sup 1544 1544 0 0.00 0 31 1 0 2016-05-31 22:54 2016-05-31 23:14
v_min_non_paid_invoice 1645 1645 0 0.00 0 93 2 0 2016-05-31 22:54 2016-05-31 23:14
v_min_non_paid_realizn 1906 1906 0 0.00 0 47 1 0 2016-05-31 22:54 2016-05-31 23:14
v_our_firm 2950 2950 0 0.00 0 32 0 0 2016-05-31 22:54 2016-05-31 23:14
v_reserve_write_off 5617 5593 24 0.42 0 47 1 24 2016-05-31 22:54 2016-05-31 23:14
x_lock_depdocs_on_canc_invoice 2314 1877 437 18.88 0 636 27 437 2016-05-31 22:54 2016-05-31 23:14
x_lock_depdocs_on_canc_sup_ord 102 59 43 42.15 0 328 38 43 2016-05-31 22:54 2016-05-31 23:14
x_make_qstorno_1000_1200 1487 1487 0 0.00 0 889 181 0 2016-05-31 22:54 2016-05-31 23:14
x_make_qstorno_1200_2000 1544 1544 0 0.00 0 3463 836 0 2016-05-31 22:54 2016-05-31 23:14
x_make_qstorno_2100_3300 87616 87616 0 0.00 0 390 19 0 2016-05-31 22:54 2016-05-31 23:14
Done for 55180 ms, from 23:16:50.64 to 23:17:45.82.

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 3 sp_kill_cost_storno 335544336 2016-05-31 22:54 2016-05-31 23:03
deadlock 1 sp_kill_qstorno_ret_qs2qd 335544336 2016-05-31 23:04 2016-05-31 23:04
deadlock 104 sp_lock_selected_doc 335544336 2016-05-31 22:54 2016-05-31 23:14
deadlock 11 sp_qd_handle_on_cancel_clo 335544336 2016-05-31 22:54 2016-05-31 23:11
deadlock 6 sp_qd_handle_on_invoice_upd_sts 335544336 2016-05-31 22:54 2016-05-31 23:12
concurrent_transaction 249 sp_lock_selected_doc 335544878 2016-05-31 22:54 2016-05-31 23:14
concurrent_transaction 17 x_lock_depdocs_on_canc_invoice 335544878 2016-05-31 22:54 2016-05-31 23:13
concurrent_transaction 19 x_lock_depdocs_on_canc_sup_ord 335544878 2016-05-31 23:00 2016-05-31 23:13
Done for 3200 ms, from 23:17:47.10 to 23:17:50.30.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL-HQBIRD.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 393192
MON$OLDEST_ACTIVE 393193
MON$OLDEST_SNAPSHOT 393193
MON$NEXT_TRANSACTION 393193
MON$PAGE_BUFFERS 50000
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 13:07:49.8140
MON$PAGES 828736
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.1.32525 Firebird 3.0 HQbird
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.1.32525 Firebird 3.0 HQbird"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.1.32525 Firebird 3.0 HQbird/tcp (WIN-2BE1UI8LGDL)/P13:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.1.32525 Firebird 3.0 HQbird/tcp (WIN-2BE1UI8LGDL)/P13:C"
on disk structure version 12.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL-HQBIRD.FDB"
Database header page information:
Flags 0
Generation 393574
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 393194
Oldest active 393195
Oldest snapshot 393195
Next transaction 393196
Sequence number 0
Next attachment ID 5500
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
Attributes force write

Variable header data:
Sweep interval: 0
Database GUID: {C6030EA7-C78E-4EC3-E4A8-168B04487CE5}
*END*


Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL-HQBIRD.FDB is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 34.24, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.05
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.31, total records: 1945027
Average version length: 47.55, total versions: 3294, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.35
Pointer pages: 13, data page slots: 21192
Data pages: 21192, average fill: 73%
Primary pages: 21192, secondary pages: 0, swept pages: 12064
Empty pages: 7, full pages: 17514
Fill distribution:
0 - 19% = 9
20 - 39% = 4
40 - 59% = 58
60 - 79% = 21120
80 - 99% = 1

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 10318, nodes: 1945027
Average node length: 20.01, total dup: 0, max dup: 0
Average key length: 17.06, compression ratio: 1.58
Average prefix length: 12.94, average data length: 14.06
Clustering factor: 714866, ratio: 0.37
Fill distribution:
0 - 19% = 423
20 - 39% = 2524
40 - 59% = 6021
60 - 79% = 521
80 - 99% = 829

Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 7157, nodes: 1945027
Average node length: 11.55, total dup: 0, max dup: 0
Average key length: 8.60, compression ratio: 1.05
Average prefix length: 3.40, average data length: 5.60
Clustering factor: 653591, ratio: 0.34
Fill distribution:
0 - 19% = 0
20 - 39% = 4525
40 - 59% = 2620
60 - 79% = 11
80 - 99% = 1

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 61309, depth: 3, leaf buckets: 4044, nodes: 1945027
Average node length: 7.19, total dup: 1316880, max dup: 49
Average key length: 4.24, compression ratio: 2.12
Average prefix length: 7.08, average data length: 1.92
Clustering factor: 661328, ratio: 0.34
Fill distribution:
0 - 19% = 93
20 - 39% = 1977
40 - 59% = 1619
60 - 79% = 81
80 - 99% = 274

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.31, total records: 688707
Average version length: 36.19, total versions: 2266, max versions: 3
Average fragment length: 9.53, total fragments: 38, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8752
Data pages: 8752, average fill: 75%
Primary pages: 8744, secondary pages: 8, swept pages: 7278
Empty pages: 2, full pages: 7916
Fill distribution:
0 - 19% = 12
20 - 39% = 8
40 - 59% = 33
60 - 79% = 8676
80 - 99% = 23

Index DOC_LIST_ID_DESC (1)
Root page: 234500, depth: 3, leaf buckets: 2760, nodes: 688707
Average node length: 11.76, total dup: 0, max dup: 0
Average key length: 8.89, compression ratio: 1.01
Average prefix length: 3.11, average data length: 5.89
Clustering factor: 204186, ratio: 0.30
Fill distribution:
0 - 19% = 0
20 - 39% = 2033
40 - 59% = 696
60 - 79% = 30
80 - 99% = 1

Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 830, nodes: 688707
Average node length: 4.89, total dup: 688657, max dup: 49951
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 324332, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 765
60 - 79% = 43
80 - 99% = 20

Index PK_DOC_LIST (0)
Root page: 259491, depth: 3, leaf buckets: 2477, nodes: 688707
Average node length: 11.76, total dup: 0, max dup: 0
Average key length: 8.89, compression ratio: 1.01
Average prefix length: 3.11, average data length: 5.89
Clustering factor: 204186, ratio: 0.30
Fill distribution:
0 - 19% = 88
20 - 39% = 1771
40 - 59% = 242
60 - 79% = 133
80 - 99% = 243

DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 1
Average record length: 64.56, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.00, total fragments: 356, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.61
Pointer pages: 3, data page slots: 280
Data pages: 28, average fill: 24%
Primary pages: 9, secondary pages: 19, swept pages: 4
Empty pages: 10, full pages: 3
Fill distribution:
0 - 19% = 19
20 - 39% = 2
40 - 59% = 3
60 - 79% = 1
80 - 99% = 3

Index PK_INVNT_SALDO (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 262, ratio: 0.66
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 38.82, total records: 11554
Average version length: 71.13, total versions: 5264, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 2.47
Pointer pages: 4, data page slots: 592
Data pages: 592, average fill: 26%
Primary pages: 592, secondary pages: 0, swept pages: 396
Empty pages: 17, full pages: 14
Fill distribution:
0 - 19% = 343
20 - 39% = 83
40 - 59% = 114
60 - 79% = 49
80 - 99% = 3

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 997, depth: 2, leaf buckets: 50, nodes: 11554
Average node length: 13.50, total dup: 902, max dup: 1
Average key length: 11.50, compression ratio: 2.35
Average prefix length: 18.42, average data length: 8.58
Clustering factor: 7763, ratio: 0.67
Fill distribution:
0 - 19% = 0
20 - 39% = 30
40 - 59% = 17
60 - 79% = 2
80 - 99% = 1

MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.06, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.12
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MONEY_SALDO (0)
Root page: 272, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 259, Index root page: 260
Total formats: 1, used formats: 1
Average record length: 15.40, total records: 376
Average version length: 46.22, total versions: 254, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 4.16
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 24%
Primary pages: 16, secondary pages: 0, swept pages: 8
Empty pages: 3, full pages: 2
Fill distribution:
0 - 19% = 9
20 - 39% = 3
40 - 59% = 2
60 - 79% = 1
80 - 99% = 1

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 98347, depth: 2, leaf buckets: 1, nodes: 376
Average node length: 5.72, total dup: 316, max dup: 51
Average key length: 4.37, compression ratio: 4.35
Average prefix length: 16.79, average data length: 2.21
Clustering factor: 196, ratio: 0.52
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Root page: 359, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (165)
Primary pointer page: 364, Index root page: 365
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 368, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.15, total records: 274922
Average version length: 31.64, total versions: 1568, max versions: 7
Average fragment length: 33.17, total fragments: 29, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 3, data page slots: 3832
Data pages: 3832, average fill: 54%
Primary pages: 3783, secondary pages: 49, swept pages: 3141
Empty pages: 73, full pages: 1242
Fill distribution:
0 - 19% = 516
20 - 39% = 644
40 - 59% = 288
60 - 79% = 2380
80 - 99% = 4

Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 253, nodes: 274922
Average node length: 4.62, total dup: 274873, max dup: 12765
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 41060, ratio: 0.15
Fill distribution:
0 - 19% = 2
20 - 39% = 20
40 - 59% = 97
60 - 79% = 94
80 - 99% = 40

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 330, nodes: 274922
Average node length: 5.57, total dup: 248106, max dup: 123
Average key length: 2.96, compression ratio: 7.43
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 50109, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 167
60 - 79% = 98
80 - 99% = 33

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 319, nodes: 274922
Average node length: 5.57, total dup: 248106, max dup: 123
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 50176, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 36
40 - 59% = 125
60 - 79% = 115
80 - 99% = 42

Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 329, nodes: 274922
Average node length: 5.36, total dup: 248106, max dup: 123
Average key length: 2.75, compression ratio: 3.28
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 50214, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 52
40 - 59% = 156
60 - 79% = 92
80 - 99% = 28

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.58, total records: 32598
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.16
Pointer pages: 2, data page slots: 280
Data pages: 280, average fill: 64%
Primary pages: 280, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 276
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 1
60 - 79% = 276
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 441264, depth: 2, leaf buckets: 25, nodes: 32598
Average node length: 3.97, total dup: 32567, max dup: 1555
Average key length: 2.00, compression ratio: 0.96
Average prefix length: 1.91, average data length: 0.00
Clustering factor: 1313, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 14
60 - 79% = 8
80 - 99% = 3

PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (162)
Primary pointer page: 348, Index root page: 349
Total formats: 2, used formats: 2
Average record length: 148.26, total records: 12688815
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1444.27, compression ratio: 9.74
Pointer pages: 182, data page slots: 295984
Data pages: 295984, average fill: 87%
Primary pages: 295984, secondary pages: 0, swept pages: 11
Empty pages: 1, full pages: 295982
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 295982

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 13308, nodes: 12688815
Average node length: 5.74, total dup: 11285878, max dup: 92
Average key length: 2.22, compression ratio: 3.60
Average prefix length: 7.82, average data length: 0.17
Clustering factor: 6614430, ratio: 0.52
Fill distribution:
0 - 19% = 17
20 - 39% = 0
40 - 59% = 4916
60 - 79% = 5261
80 - 99% = 3114

Index PERF_LOG_GDSCODE (3)
Root page: 97350, depth: 3, leaf buckets: 14228, nodes: 12688815
Average node length: 4.56, total dup: 12688810, max dup: 12237003
Average key length: 1.04, compression ratio: 0.17
Average prefix length: 0.18, average data length: 0.00
Clustering factor: 421853, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 14197
60 - 79% = 1
80 - 99% = 29

Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 14901, nodes: 12688815
Average node length: 5.73, total dup: 12336835, max dup: 20860
Average key length: 2.21, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 4471910, ratio: 0.35
Fill distribution:
0 - 19% = 7
20 - 39% = 2
40 - 59% = 9649
60 - 79% = 3006
80 - 99% = 2237

Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 15630, nodes: 12688815
Average node length: 5.64, total dup: 12594183, max dup: 1940499
Average key length: 2.12, compression ratio: 17.79
Average prefix length: 37.64, average data length: 0.11
Clustering factor: 7007922, ratio: 0.55
Fill distribution:
0 - 19% = 25
20 - 39% = 3
40 - 59% = 12871
60 - 79% = 821
80 - 99% = 1910

PHRASES (145)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.77, total records: 357508
Average version length: 55.69, total versions: 2684, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 3, data page slots: 4256
Data pages: 4256, average fill: 74%
Primary pages: 4256, secondary pages: 0, swept pages: 2606
Empty pages: 6, full pages: 4037
Fill distribution:
0 - 19% = 8
20 - 39% = 4
40 - 59% = 20
60 - 79% = 4207
80 - 99% = 17

Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 478, nodes: 357508
Average node length: 5.94, total dup: 299216, max dup: 956
Average key length: 3.21, compression ratio: 2.81
Average prefix length: 7.96, average data length: 1.04
Clustering factor: 41118, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 46
40 - 59% = 281
60 - 79% = 120
80 - 99% = 30

Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 390, nodes: 357508
Average node length: 5.55, total dup: 319120, max dup: 344
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 78312, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 169
60 - 79% = 157
80 - 99% = 54

RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 81%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.07, total dup: 0, max dup: 0
Average key length: 26.06, compression ratio: 1.70
Average prefix length: 21.23, average data length: 23.07
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 358, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (276)
Primary pointer page: 557, Index root page: 68921
Total formats: 1, used formats: 1
Average record length: 56.38, total records: 3120
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.41
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 70%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 37
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 37
80 - 99% = 0

WARES (144)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 77.53, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.78
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 64
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Root page: 273, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 275, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 52.95, total dup: 0, max dup: 0
Average key length: 51.92, compression ratio: 0.99
Average prefix length: 2.65, average data length: 48.95
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2

WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (259)
Primary pointer page: 254, Index root page: 284
Total formats: 1, used formats: 1
Average record length: 28.63, total records: 2671
Average version length: 72.17, total versions: 1612, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.75
Pointer pages: 5, data page slots: 464
Data pages: 168, average fill: 21%
Primary pages: 168, secondary pages: 0, swept pages: 89
Empty pages: 71, full pages: 4
Fill distribution:
0 - 19% = 91
20 - 39% = 41
40 - 59% = 24
60 - 79% = 12
80 - 99% = 0

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1235, depth: 2, leaf buckets: 8, nodes: 2671
Average node length: 7.28, total dup: 2317, max dup: 14
Average key length: 5.43, compression ratio: 6.82
Average prefix length: 33.70, average data length: 3.30
Clustering factor: 392, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

XQD_1000_3300 (261)
Primary pointer page: 708, Index root page: 709
Total formats: 1, used formats: 1
Average record length: 71.48, total records: 1267349
Average version length: 71.74, total versions: 12275, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 14, data page slots: 21792
Data pages: 21680, average fill: 65%
Primary pages: 21680, secondary pages: 0, swept pages: 15716
Empty pages: 183, full pages: 11707
Fill distribution:
0 - 19% = 1296
20 - 39% = 1395
40 - 59% = 2442
60 - 79% = 16502
80 - 99% = 45

Index XQD_1000_3300_DOC (1)
Root page: 193515, depth: 3, leaf buckets: 1361, nodes: 1267349
Average node length: 5.15, total dup: 1232413, max dup: 121
Average key length: 2.21, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 197210, ratio: 0.16
Fill distribution:
0 - 19% = 15
20 - 39% = 195
40 - 59% = 737
60 - 79% = 60
80 - 99% = 354

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 120714, depth: 3, leaf buckets: 1937, nodes: 1267349
Average node length: 6.27, total dup: 1106315, max dup: 27
Average key length: 3.32, compression ratio: 11.13
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 291076, ratio: 0.23
Fill distribution:
0 - 19% = 25
20 - 39% = 190
40 - 59% = 1416
60 - 79% = 170
80 - 99% = 136

XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 58.71, total records: 175851
Average version length: 71.84, total versions: 32642, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.32
Pointer pages: 8, data page slots: 4952
Data pages: 3784, average fill: 54%
Primary pages: 3784, secondary pages: 0, swept pages: 2008
Empty pages: 197, full pages: 959
Fill distribution:
0 - 19% = 459
20 - 39% = 512
40 - 59% = 882
60 - 79% = 1688
80 - 99% = 243

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 443375, depth: 3, leaf buckets: 292, nodes: 175851
Average node length: 6.15, total dup: 151343, max dup: 49
Average key length: 3.50, compression ratio: 10.57
Average prefix length: 35.64, average data length: 1.36
Clustering factor: 26728, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 105
40 - 59% = 137
60 - 79% = 45
80 - 99% = 4

XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 69.64, total records: 1686746
Average version length: 71.81, total versions: 59638, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.95
Pointer pages: 21, data page slots: 33536
Data pages: 32080, average fill: 59%
Primary pages: 32079, secondary pages: 1, swept pages: 21891
Empty pages: 1078, full pages: 18045
Fill distribution:
0 - 19% = 4282
20 - 39% = 4271
40 - 59% = 2839
60 - 79% = 19812
80 - 99% = 876

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 106879, depth: 3, leaf buckets: 2574, nodes: 1686746
Average node length: 5.49, total dup: 1605750, max dup: 49
Average key length: 2.53, compression ratio: 14.61
Average prefix length: 36.51, average data length: 0.49
Clustering factor: 236001, ratio: 0.14
Fill distribution:
0 - 19% = 15
20 - 39% = 1125
40 - 59% = 973
60 - 79% = 326
80 - 99% = 135

XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 16.40, total records: 3245
Average version length: 72.08, total versions: 2496, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 8.29
Pointer pages: 6, data page slots: 1224
Data pages: 552, average fill: 8%
Primary pages: 552, secondary pages: 0, swept pages: 490
Empty pages: 396, full pages: 39
Fill distribution:
0 - 19% = 500
20 - 39% = 9
40 - 59% = 3
60 - 79% = 16
80 - 99% = 24

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 9, nodes: 3245
Average node length: 6.93, total dup: 2864, max dup: 49
Average key length: 4.93, compression ratio: 7.51
Average prefix length: 34.19, average data length: 2.81
Clustering factor: 368, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 3
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 71.22, total records: 2504656
Average version length: 70.59, total versions: 15485, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 23, data page slots: 35960
Data pages: 35960, average fill: 76%
Primary pages: 35960, secondary pages: 0, swept pages: 24616
Empty pages: 10, full pages: 32545
Fill distribution:
0 - 19% = 18
20 - 39% = 74
40 - 59% = 389
60 - 79% = 35202
80 - 99% = 277

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 5430, nodes: 2504656
Average node length: 6.96, total dup: 2000267, max dup: 24
Average key length: 3.99, compression ratio: 9.28
Average prefix length: 35.21, average data length: 1.79
Clustering factor: 618282, ratio: 0.25
Fill distribution:
0 - 19% = 8
20 - 39% = 3150
40 - 59% = 1757
60 - 79% = 323
80 - 99% = 192

XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.69, total records: 4452072
Average version length: 84.39, total versions: 30508, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 43, data page slots: 69176
Data pages: 69176, average fill: 80%
Primary pages: 69176, secondary pages: 0, swept pages: 29481
Empty pages: 11, full pages: 68852
Fill distribution:
0 - 19% = 11
20 - 39% = 1
40 - 59% = 17
60 - 79% = 28204
80 - 99% = 40943

Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 4472, nodes: 4452072
Average node length: 5.16, total dup: 4349784, max dup: 126
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 963058, ratio: 0.22
Fill distribution:
0 - 19% = 11
20 - 39% = 71
40 - 59% = 1957
60 - 79% = 1701
80 - 99% = 732

Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 5607, nodes: 4452072
Average node length: 5.67, total dup: 3998354, max dup: 49
Average key length: 2.68, compression ratio: 3.35
Average prefix length: 8.42, average data length: 0.58
Clustering factor: 595339, ratio: 0.13
Fill distribution:
0 - 19% = 39
20 - 39% = 289
40 - 59% = 3970
60 - 79% = 370
80 - 99% = 939

Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 5039, nodes: 4452072
Average node length: 5.79, total dup: 3895413, max dup: 29
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 1023696, ratio: 0.23
Fill distribution:
0 - 19% = 6
20 - 39% = 78
40 - 59% = 2339
60 - 79% = 1739
80 - 99% = 877

XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.15, total records: 2080894
Average version length: 82.54, total versions: 16290, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 21, data page slots: 32768
Data pages: 32768, average fill: 79%
Primary pages: 32768, secondary pages: 0, swept pages: 20451
Empty pages: 16, full pages: 30704
Fill distribution:
0 - 19% = 28
20 - 39% = 63
40 - 59% = 326
60 - 79% = 14812
80 - 99% = 17539

Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 2251, nodes: 2080894
Average node length: 5.15, total dup: 2031079, max dup: 170
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 439742, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 53
40 - 59% = 1312
60 - 79% = 668
80 - 99% = 218

Index XQS_1000_3300_RCV_ID (2)
Root page: 122787, depth: 3, leaf buckets: 3590, nodes: 2080894
Average node length: 6.31, total dup: 1676610, max dup: 14
Average key length: 3.34, compression ratio: 2.69
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 266832, ratio: 0.13
Fill distribution:
0 - 19% = 82
20 - 39% = 1795
40 - 59% = 926
60 - 79% = 418
80 - 99% = 369

Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 2522, nodes: 2080894
Average node length: 5.79, total dup: 1820601, max dup: 35
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 474113, ratio: 0.23
Fill distribution:
0 - 19% = 5
20 - 39% = 44
40 - 59% = 1478
60 - 79% = 764
80 - 99% = 231

XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.60, total records: 4640197
Average version length: 84.96, total versions: 41357, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 45, data page slots: 73392
Data pages: 73384, average fill: 79%
Primary pages: 73384, secondary pages: 0, swept pages: 36266
Empty pages: 34, full pages: 68234
Fill distribution:
0 - 19% = 58
20 - 39% = 157
40 - 59% = 809
60 - 79% = 31808
80 - 99% = 40552

Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 5331, nodes: 4640197
Average node length: 5.04, total dup: 4612750, max dup: 610
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1148448, ratio: 0.25
Fill distribution:
0 - 19% = 4
20 - 39% = 603
40 - 59% = 3254
60 - 79% = 1189
80 - 99% = 281

Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 6232, nodes: 4640197
Average node length: 5.44, total dup: 4334068, max dup: 49
Average key length: 2.45, compression ratio: 3.67
Average prefix length: 8.62, average data length: 0.38
Clustering factor: 722040, ratio: 0.16
Fill distribution:
0 - 19% = 88
20 - 39% = 2361
40 - 59% = 2278
60 - 79% = 641
80 - 99% = 864

Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 5984, nodes: 4640197
Average node length: 5.65, total dup: 4181780, max dup: 85
Average key length: 2.66, compression ratio: 3.38
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 1204892, ratio: 0.26
Fill distribution:
0 - 19% = 8
20 - 39% = 572
40 - 59% = 3831
60 - 79% = 1252
80 - 99% = 321

XQS_2000_3300 (268)
Primary pointer page: 757, Index root page: 758
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_DOC_ID (0)
Root page: 760, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Root page: 762, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Root page: 761, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (269)
Primary pointer page: 763, Index root page: 764
Total formats: 1, used formats: 1
Average record length: 83.77, total records: 2984636
Average version length: 83.26, total versions: 13653, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 29, data page slots: 47224
Data pages: 47224, average fill: 79%
Primary pages: 47224, secondary pages: 0, swept pages: 31411
Empty pages: 20, full pages: 44311
Fill distribution:
0 - 19% = 32
20 - 39% = 73
40 - 59% = 345
60 - 79% = 23791
80 - 99% = 22983

Index XQS_2100_3300_DOC_ID (0)
Root page: 89428, depth: 3, leaf buckets: 3371, nodes: 2984636
Average node length: 5.02, total dup: 2970582, max dup: 1443
Average key length: 2.04, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 678459, ratio: 0.23
Fill distribution:
0 - 19% = 35
20 - 39% = 542
40 - 59% = 1686
60 - 79% = 744
80 - 99% = 364

Index XQS_2100_3300_RCV_ID (2)
Root page: 92816, depth: 3, leaf buckets: 5673, nodes: 2984636
Average node length: 6.32, total dup: 2407823, max dup: 14
Average key length: 3.34, compression ratio: 2.69
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 539437, ratio: 0.18
Fill distribution:
0 - 19% = 159
20 - 39% = 3561
40 - 59% = 987
60 - 79% = 513
80 - 99% = 453

Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3719, nodes: 2984636
Average node length: 5.50, total dup: 2757743, max dup: 71
Average key length: 2.53, compression ratio: 3.56
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 721286, ratio: 0.24
Fill distribution:
0 - 19% = 12
20 - 39% = 629
40 - 59% = 1807
60 - 79% = 967
80 - 99% = 304

XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 68.27, total records: 489468
Average version length: 69.01, total versions: 7656, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.99
Pointer pages: 5, data page slots: 6752
Data pages: 6752, average fill: 77%
Primary pages: 6752, secondary pages: 0, swept pages: 4806
Empty pages: 2, full pages: 6590
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 18
60 - 79% = 6562
80 - 99% = 169

Index XQS_3300_3400_DOC_ID (0)
Root page: 544714, depth: 3, leaf buckets: 573, nodes: 489468
Average node length: 5.39, total dup: 454205, max dup: 161
Average key length: 2.55, compression ratio: 3.52
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 48979, ratio: 0.10
Fill distribution:
0 - 19% = 3
20 - 39% = 62
40 - 59% = 272
60 - 79% = 192
80 - 99% = 44

Index XQS_3300_3400_SND_ID (1)
Root page: 358794, depth: 3, leaf buckets: 631, nodes: 489468
Average node length: 5.94, total dup: 415507, max dup: 29
Average key length: 3.11, compression ratio: 2.90
Average prefix length: 8.04, average data length: 0.96
Clustering factor: 54940, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 71
40 - 59% = 299
60 - 79% = 208
80 - 99% = 53

ZDOC_DATA (229)
Primary pointer page: 632, Index root page: 633
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (228)
Primary pointer page: 630, Index root page: 631
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (230)
Primary pointer page: 634, Index root page: 635
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (233)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Root page: 650, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (234)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Root page: 651, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (231)
Primary pointer page: 636, Index root page: 637
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Root page: 644, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 645, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (232)
Primary pointer page: 638, Index root page: 639
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Root page: 647, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Root page: 646, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Root page: 649, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Root page: 648, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (227)
Primary pointer page: 628, Index root page: 629
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (226)
Primary pointer page: 625, Index root page: 626
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Z_USED_VIEWS (146)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 36840 ms, from 23:17:50.90 to 23:18:27.74.

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 1945027 3294 0.1693
DOC_LIST 688707 2266 0.3290
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 11554 5264 45.5599
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 376 254 67.5531
OPTYPES 9 0 0.0000
PDISTR 274922 1568 0.5703
PERF_ESTIMATED 32598 0 0.0000
PERF_LOG 12688815 0 0.0000
PSTORNED 357508 2684 0.7507
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 0 0.0000
SETTINGS 114 0 0.0000
TRACE_STAT 3120 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 2671 1612 60.3519
XQD_1000_3300 1267349 12275 0.9685
XQD_1200_2000 175851 32642 18.5623
XQD_2000_3300 1686746 59638 3.5356
XQD_2100_3300 3245 2496 76.9183
XQD_3300_3400 2504656 15485 0.6182
XQS_1000_1200 4452072 30508 0.6852
XQS_1000_3300 2080894 16290 0.7828
XQS_1200_2000 4640197 41357 0.8912
XQS_2100_3300 2984636 13653 0.4574
XQS_3300_3400 489468 7656 1.5641
Z_USED_VIEWS 29 0 0.0000
Done for 2810 ms, from 23:18:38.56 to 23:18:41.37.

Database validation

23:18:41.50 Validation started

23:18:41.50 Relation 140 (DOC_LIST)
23:18:41.50 process pointer page 0 of 6
23:18:41.60 process pointer page 1 of 6
23:18:41.70 process pointer page 2 of 6
23:18:41.81 process pointer page 3 of 6
23:18:41.90 process pointer page 4 of 6
23:18:42.01 process pointer page 5 of 6
23:18:42.04 Index 1 (PK_DOC_LIST)
23:18:42.35 Index 2 (DOC_LIST_ID_DESC)
23:18:42.68 Index 3 (FK_DOC_LIST_AGENTS)
23:18:42.98 Relation 140 (DOC_LIST) is ok

23:18:42.98 Relation 141 (DOC_DATA)
23:18:42.98 process pointer page 0 of 13
23:18:43.07 process pointer page 1 of 13
23:18:43.18 process pointer page 2 of 13
23:18:43.29 process pointer page 3 of 13
23:18:43.38 process pointer page 4 of 13
23:18:43.49 process pointer page 5 of 13
23:18:43.59 process pointer page 6 of 13
23:18:43.68 process pointer page 7 of 13
23:18:43.79 process pointer page 8 of 13
23:18:43.88 process pointer page 9 of 13
23:18:43.99 process pointer page 10 of 13
23:18:44.08 process pointer page 11 of 13
23:18:44.18 process pointer page 12 of 13
23:18:44.29 Index 2 (DOC_DATA_DOC_WARE_UNQ)
23:18:45.43 Index 3 (DOC_DATA_ID_DESC)
23:18:46.33 Index 4 (FK_DOC_DATA_DOC_LIST)
23:18:47.10 Relation 141 (DOC_DATA) is ok

23:18:47.10 Relation 147 (INVNT_SALDO)
23:18:47.10 process pointer page 0 of 3
23:18:47.10 process pointer page 1 of 3
23:18:47.10 process pointer page 2 of 3
23:18:47.10 Index 1 (PK_INVNT_SALDO)
23:18:47.10 Relation 147 (INVNT_SALDO) is ok

23:18:47.10 Relation 150 (PDISTR)
23:18:47.10 process pointer page 0 of 3
23:18:47.19 process pointer page 1 of 3
23:18:47.28 process pointer page 2 of 3
23:18:47.30 Index 2 (PDISTR_SND_ID)
23:18:47.39 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
23:18:47.49 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
23:18:47.58 Index 5 (PDISTR_AGENT_ID)
23:18:47.66 Relation 150 (PDISTR) is ok

23:18:47.66 Relation 151 (PSTORNED)
23:18:47.66 process pointer page 0 of 3
23:18:47.75 process pointer page 1 of 3
23:18:47.84 process pointer page 2 of 3
23:18:47.91 Index 2 (PSTORNED_SND_ID)
23:18:48.02 Index 3 (PSTORNED_RCV_ID)
23:18:48.13 Relation 151 (PSTORNED) is ok

23:18:48.13 Relation 156 (SEMAPHORES)
23:18:48.13 process pointer page 0 of 1
23:18:48.13 Index 1 (PK_SEMAPHORES)
23:18:48.13 Index 2 (SEMAPHORES_TASK_UNQ)
23:18:48.13 Relation 156 (SEMAPHORES) is ok

23:18:48.13 Relation 157 (INVNT_TURNOVER_LOG)
23:18:48.13 process pointer page 0 of 4
23:18:48.14 process pointer page 1 of 4
23:18:48.14 process pointer page 2 of 4
23:18:48.14 process pointer page 3 of 4
23:18:48.14 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
23:18:48.16 Relation 157 (INVNT_TURNOVER_LOG) is ok

23:18:48.16 Relation 160 (PERF_ESTIMATED)
23:18:48.16 process pointer page 0 of 2
23:18:48.17 process pointer page 1 of 2
23:18:48.17 Index 1 (PERF_EST_MINUTE_SINCE_START)
23:18:48.17 Relation 160 (PERF_ESTIMATED) is ok

23:18:48.17 Relation 161 (PERF_ISQL_STAT)
23:18:48.19 process pointer page 0 of 1
23:18:48.19 Index 1 (PERF_ISQL_STAT_TRN)
23:18:48.19 Relation 161 (PERF_ISQL_STAT) is ok

23:18:48.19 Relation 162 (PERF_LOG)
23:18:48.19 process pointer page 0 of 182
23:18:48.27 process pointer page 1 of 182
23:18:48.34 process pointer page 2 of 182
23:18:48.42 process pointer page 3 of 182
23:18:48.50 process pointer page 4 of 182
23:18:48.58 process pointer page 5 of 182
23:18:48.66 process pointer page 6 of 182
23:18:48.73 process pointer page 7 of 182
23:18:48.81 process pointer page 8 of 182
23:18:48.89 process pointer page 9 of 182
23:18:48.97 process pointer page 10 of 182
23:18:49.05 process pointer page 11 of 182
23:18:49.11 process pointer page 12 of 182
23:18:49.19 process pointer page 13 of 182
23:18:49.25 process pointer page 14 of 182
23:18:49.33 process pointer page 15 of 182
23:18:49.39 process pointer page 16 of 182
23:18:49.47 process pointer page 17 of 182
23:18:49.53 process pointer page 18 of 182
23:18:49.61 process pointer page 19 of 182
23:18:49.67 process pointer page 20 of 182
23:18:49.75 process pointer page 21 of 182
23:18:49.81 process pointer page 22 of 182
23:18:49.89 process pointer page 23 of 182
23:18:49.95 process pointer page 24 of 182
23:18:50.03 process pointer page 25 of 182
23:18:50.09 process pointer page 26 of 182
23:18:50.17 process pointer page 27 of 182
23:18:50.25 process pointer page 28 of 182
23:18:50.31 process pointer page 29 of 182
23:18:50.37 process pointer page 30 of 182
23:18:50.45 process pointer page 31 of 182
23:18:50.51 process pointer page 32 of 182
23:18:50.59 process pointer page 33 of 182
23:18:50.65 process pointer page 34 of 182
23:18:50.73 process pointer page 35 of 182
23:18:50.79 process pointer page 36 of 182
23:18:50.87 process pointer page 37 of 182
23:18:50.93 process pointer page 38 of 182
23:18:51.01 process pointer page 39 of 182
23:18:51.07 process pointer page 40 of 182
23:18:51.15 process pointer page 41 of 182
23:18:51.21 process pointer page 42 of 182
23:18:51.29 process pointer page 43 of 182
23:18:51.35 process pointer page 44 of 182
23:18:51.43 process pointer page 45 of 182
23:18:51.49 process pointer page 46 of 182
23:18:51.57 process pointer page 47 of 182
23:18:51.64 process pointer page 48 of 182
23:18:51.71 process pointer page 49 of 182
23:18:51.78 process pointer page 50 of 182
23:18:51.85 process pointer page 51 of 182
23:18:51.92 process pointer page 52 of 182
23:18:51.99 process pointer page 53 of 182
23:18:52.06 process pointer page 54 of 182
23:18:52.13 process pointer page 55 of 182
23:18:52.20 process pointer page 56 of 182
23:18:52.27 process pointer page 57 of 182
23:18:52.34 process pointer page 58 of 182
23:18:52.42 process pointer page 59 of 182
23:18:52.48 process pointer page 60 of 182
23:18:52.56 process pointer page 61 of 182
23:18:52.63 process pointer page 62 of 182
23:18:52.70 process pointer page 63 of 182
23:18:52.77 process pointer page 64 of 182
23:18:52.84 process pointer page 65 of 182
23:18:52.91 process pointer page 66 of 182
23:18:52.98 process pointer page 67 of 182
23:18:53.05 process pointer page 68 of 182
23:18:53.12 process pointer page 69 of 182
23:18:53.20 process pointer page 70 of 182
23:18:53.27 process pointer page 71 of 182
23:18:53.34 process pointer page 72 of 182
23:18:53.41 process pointer page 73 of 182
23:18:53.48 process pointer page 74 of 182
23:18:53.55 process pointer page 75 of 182
23:18:53.62 process pointer page 76 of 182
23:18:53.69 process pointer page 77 of 182
23:18:53.76 process pointer page 78 of 182
23:18:53.83 process pointer page 79 of 182
23:18:53.90 process pointer page 80 of 182
23:18:53.98 process pointer page 81 of 182
23:18:54.04 process pointer page 82 of 182
23:18:54.12 process pointer page 83 of 182
23:18:54.18 process pointer page 84 of 182
23:18:54.24 process pointer page 85 of 182
23:18:54.32 process pointer page 86 of 182
23:18:54.38 process pointer page 87 of 182
23:18:54.46 process pointer page 88 of 182
23:18:54.52 process pointer page 89 of 182
23:18:54.60 process pointer page 90 of 182
23:18:54.66 process pointer page 91 of 182
23:18:54.74 process pointer page 92 of 182
23:18:54.80 process pointer page 93 of 182
23:18:54.88 process pointer page 94 of 182
23:18:54.94 process pointer page 95 of 182
23:18:55.02 process pointer page 96 of 182
23:18:55.08 process pointer page 97 of 182
23:18:55.16 process pointer page 98 of 182
23:18:55.24 process pointer page 99 of 182
23:18:55.30 process pointer page 100 of 182
23:18:55.38 process pointer page 101 of 182
23:18:55.44 process pointer page 102 of 182
23:18:55.52 process pointer page 103 of 182
23:18:55.58 process pointer page 104 of 182
23:18:55.66 process pointer page 105 of 182
23:18:55.72 process pointer page 106 of 182
23:18:55.80 process pointer page 107 of 182
23:18:55.88 process pointer page 108 of 182
23:18:55.94 process pointer page 109 of 182
23:18:56.02 process pointer page 110 of 182
23:18:56.08 process pointer page 111 of 182
23:18:56.16 process pointer page 112 of 182
23:18:56.22 process pointer page 113 of 182
23:18:56.30 process pointer page 114 of 182
23:18:56.36 process pointer page 115 of 182
23:18:56.44 process pointer page 116 of 182
23:18:56.50 process pointer page 117 of 182
23:18:56.58 process pointer page 118 of 182
23:18:56.66 process pointer page 119 of 182
23:18:56.72 process pointer page 120 of 182
23:18:56.80 process pointer page 121 of 182
23:18:56.86 process pointer page 122 of 182
23:18:56.94 process pointer page 123 of 182
23:18:57.00 process pointer page 124 of 182
23:18:57.08 process pointer page 125 of 182
23:18:57.16 process pointer page 126 of 182
23:18:57.24 process pointer page 127 of 182
23:18:57.30 process pointer page 128 of 182
23:18:57.38 process pointer page 129 of 182
23:18:57.45 process pointer page 130 of 182
23:18:57.52 process pointer page 131 of 182
23:18:57.59 process pointer page 132 of 182
23:18:57.67 process pointer page 133 of 182
23:18:57.73 process pointer page 134 of 182
23:18:57.81 process pointer page 135 of 182
23:18:57.89 process pointer page 136 of 182
23:18:57.95 process pointer page 137 of 182
23:18:58.03 process pointer page 138 of 182
23:18:58.11 process pointer page 139 of 182
23:18:58.17 process pointer page 140 of 182
23:18:58.25 process pointer page 141 of 182
23:18:58.33 process pointer page 142 of 182
23:18:58.39 process pointer page 143 of 182
23:18:58.47 process pointer page 144 of 182
23:18:58.55 process pointer page 145 of 182
23:18:58.61 process pointer page 146 of 182
23:18:58.69 process pointer page 147 of 182
23:18:58.76 process pointer page 148 of 182
23:18:58.83 process pointer page 149 of 182
23:18:58.90 process pointer page 150 of 182
23:18:58.98 process pointer page 151 of 182
23:18:59.05 process pointer page 152 of 182
23:18:59.12 process pointer page 153 of 182
23:18:59.19 process pointer page 154 of 182
23:18:59.26 process pointer page 155 of 182
23:18:59.34 process pointer page 156 of 182
23:18:59.40 process pointer page 157 of 182
23:18:59.48 process pointer page 158 of 182
23:18:59.56 process pointer page 159 of 182
23:18:59.62 process pointer page 160 of 182
23:18:59.70 process pointer page 161 of 182
23:18:59.78 process pointer page 162 of 182
23:18:59.84 process pointer page 163 of 182
23:18:59.92 process pointer page 164 of 182
23:19:00.00 process pointer page 165 of 182
23:19:00.06 process pointer page 166 of 182
23:19:00.14 process pointer page 167 of 182
23:19:00.22 process pointer page 168 of 182
23:19:00.28 process pointer page 169 of 182
23:19:00.36 process pointer page 170 of 182
23:19:00.43 process pointer page 171 of 182
23:19:00.50 process pointer page 172 of 182
23:19:00.57 process pointer page 173 of 182
23:19:00.65 process pointer page 174 of 182
23:19:00.71 process pointer page 175 of 182
23:19:00.79 process pointer page 176 of 182
23:19:00.87 process pointer page 177 of 182
23:19:00.95 process pointer page 178 of 182
23:19:01.01 process pointer page 179 of 182
23:19:01.09 process pointer page 180 of 182
23:19:01.17 process pointer page 181 of 182
23:19:01.18 Index 1 (PERF_LOG_DTS_BEG_DESC)
23:19:07.02 Index 2 (PERF_LOG_UNIT)
23:19:14.22 Index 3 (PERF_LOG_TRN_DESC)
23:19:19.07 Index 4 (PERF_LOG_GDSCODE)
23:19:22.02 Relation 162 (PERF_LOG) is ok

23:19:22.02 Relation 166 (V_STOPTEST)
23:19:22.02 Relation 166 (V_STOPTEST) is ok

23:19:22.02 Relation 183 (V_QDISTR_SOURCE)
23:19:22.02 Relation 183 (V_QDISTR_SOURCE) is ok

23:19:22.02 Relation 184 (V_QSTORNED_SOURCE)
23:19:22.02 Relation 184 (V_QSTORNED_SOURCE) is ok

23:19:22.02 Relation 259 (XQD_1000_1200)
23:19:22.04 process pointer page 0 of 5
23:19:22.04 process pointer page 1 of 5
23:19:22.04 process pointer page 2 of 5
23:19:22.04 process pointer page 3 of 5
23:19:22.04 process pointer page 4 of 5
23:19:22.04 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
23:19:22.05 Relation 259 (XQD_1000_1200) is ok

23:19:22.05 Relation 260 (XQD_1200_2000)
23:19:22.05 process pointer page 0 of 8
23:19:22.14 process pointer page 1 of 8
23:19:22.25 process pointer page 2 of 8
23:19:22.27 process pointer page 3 of 8
23:19:22.27 process pointer page 4 of 8
23:19:22.27 process pointer page 5 of 8
23:19:22.27 process pointer page 6 of 8
23:19:22.27 process pointer page 7 of 8
23:19:22.27 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
23:19:22.33 Relation 260 (XQD_1200_2000) is ok

23:19:22.33 Relation 261 (XQD_1000_3300)
23:19:22.33 process pointer page 0 of 14
23:19:22.43 process pointer page 1 of 14
23:19:22.50 process pointer page 2 of 14
23:19:22.60 process pointer page 3 of 14
23:19:22.69 process pointer page 4 of 14
23:19:22.77 process pointer page 5 of 14
23:19:22.86 process pointer page 6 of 14
23:19:22.96 process pointer page 7 of 14
23:19:23.05 process pointer page 8 of 14
23:19:23.11 process pointer page 9 of 14
23:19:23.17 process pointer page 10 of 14
23:19:23.25 process pointer page 11 of 14
23:19:23.33 process pointer page 12 of 14
23:19:23.42 process pointer page 13 of 14
23:19:23.44 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
23:19:23.97 Index 2 (XQD_1000_3300_DOC)
23:19:24.38 Relation 261 (XQD_1000_3300) is ok

23:19:24.38 Relation 262 (XQD_2000_3300)
23:19:24.38 process pointer page 0 of 21
23:19:24.47 process pointer page 1 of 21
23:19:24.56 process pointer page 2 of 21
23:19:24.66 process pointer page 3 of 21
23:19:24.75 process pointer page 4 of 21
23:19:24.84 process pointer page 5 of 21
23:19:24.94 process pointer page 6 of 21
23:19:25.03 process pointer page 7 of 21
23:19:25.12 process pointer page 8 of 21
23:19:25.22 process pointer page 9 of 21
23:19:25.31 process pointer page 10 of 21
23:19:25.41 process pointer page 11 of 21
23:19:25.48 process pointer page 12 of 21
23:19:25.58 process pointer page 13 of 21
23:19:25.67 process pointer page 14 of 21
23:19:25.73 process pointer page 15 of 21
23:19:25.76 process pointer page 16 of 21
23:19:25.83 process pointer page 17 of 21
23:19:25.87 process pointer page 18 of 21
23:19:25.94 process pointer page 19 of 21
23:19:26.00 process pointer page 20 of 21
23:19:26.03 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
23:19:26.62 Relation 262 (XQD_2000_3300) is ok

23:19:26.62 Relation 263 (XQD_2100_3300)
23:19:26.62 process pointer page 0 of 6
23:19:26.65 process pointer page 1 of 6
23:19:26.65 process pointer page 2 of 6
23:19:26.65 process pointer page 3 of 6
23:19:26.65 process pointer page 4 of 6
23:19:26.65 process pointer page 5 of 6
23:19:26.65 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
23:19:26.65 Relation 263 (XQD_2100_3300) is ok

23:19:26.65 Relation 264 (XQD_3300_3400)
23:19:26.65 process pointer page 0 of 23
23:19:26.75 process pointer page 1 of 23
23:19:26.84 process pointer page 2 of 23
23:19:26.93 process pointer page 3 of 23
23:19:27.01 process pointer page 4 of 23
23:19:27.11 process pointer page 5 of 23
23:19:27.20 process pointer page 6 of 23
23:19:27.29 process pointer page 7 of 23
23:19:27.39 process pointer page 8 of 23
23:19:27.48 process pointer page 9 of 23
23:19:27.56 process pointer page 10 of 23
23:19:27.65 process pointer page 11 of 23
23:19:27.75 process pointer page 12 of 23
23:19:27.84 process pointer page 13 of 23
23:19:27.92 process pointer page 14 of 23
23:19:28.01 process pointer page 15 of 23
23:19:28.10 process pointer page 16 of 23
23:19:28.20 process pointer page 17 of 23
23:19:28.29 process pointer page 18 of 23
23:19:28.38 process pointer page 19 of 23
23:19:28.48 process pointer page 20 of 23
23:19:28.56 process pointer page 21 of 23
23:19:28.65 process pointer page 22 of 23
23:19:28.65 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
23:19:29.77 Relation 264 (XQD_3300_3400) is ok

23:19:29.77 Relation 265 (XQS_1000_1200)
23:19:29.77 process pointer page 0 of 43
23:19:29.87 process pointer page 1 of 43
23:19:29.96 process pointer page 2 of 43
23:19:30.04 process pointer page 3 of 43
23:19:30.13 process pointer page 4 of 43
23:19:30.23 process pointer page 5 of 43
23:19:30.32 process pointer page 6 of 43
23:19:30.41 process pointer page 7 of 43
23:19:30.51 process pointer page 8 of 43
23:19:30.60 process pointer page 9 of 43
23:19:30.69 process pointer page 10 of 43
23:19:30.77 process pointer page 11 of 43
23:19:30.87 process pointer page 12 of 43
23:19:30.96 process pointer page 13 of 43
23:19:31.05 process pointer page 14 of 43
23:19:31.15 process pointer page 15 of 43
23:19:31.24 process pointer page 16 of 43
23:19:31.33 process pointer page 17 of 43
23:19:31.43 process pointer page 18 of 43
23:19:31.50 process pointer page 19 of 43
23:19:31.60 process pointer page 20 of 43
23:19:31.69 process pointer page 21 of 43
23:19:31.79 process pointer page 22 of 43
23:19:31.88 process pointer page 23 of 43
23:19:31.96 process pointer page 24 of 43
23:19:32.05 process pointer page 25 of 43
23:19:32.14 process pointer page 26 of 43
23:19:32.24 process pointer page 27 of 43
23:19:32.33 process pointer page 28 of 43
23:19:32.41 process pointer page 29 of 43
23:19:32.50 process pointer page 30 of 43
23:19:32.60 process pointer page 31 of 43
23:19:32.69 process pointer page 32 of 43
23:19:32.78 process pointer page 33 of 43
23:19:32.88 process pointer page 34 of 43
23:19:32.97 process pointer page 35 of 43
23:19:33.06 process pointer page 36 of 43
23:19:33.16 process pointer page 37 of 43
23:19:33.25 process pointer page 38 of 43
23:19:33.35 process pointer page 39 of 43
23:19:33.44 process pointer page 40 of 43
23:19:33.53 process pointer page 41 of 43
23:19:33.63 process pointer page 42 of 43
23:19:33.66 Index 1 (XQS_1000_1200_DOC_ID)
23:19:35.09 Index 2 (XQS_1000_1200_SND_ID)
23:19:36.56 Index 3 (XQS_1000_1200_RCV_ID)
23:19:37.84 Relation 265 (XQS_1000_1200) is ok

23:19:37.84 Relation 266 (XQS_1200_2000)
23:19:37.84 process pointer page 0 of 45
23:19:37.95 process pointer page 1 of 45
23:19:38.04 process pointer page 2 of 45
23:19:38.14 process pointer page 3 of 45
23:19:38.24 process pointer page 4 of 45
23:19:38.32 process pointer page 5 of 45
23:19:38.42 process pointer page 6 of 45
23:19:38.51 process pointer page 7 of 45
23:19:38.60 process pointer page 8 of 45
23:19:38.70 process pointer page 9 of 45
23:19:38.79 process pointer page 10 of 45
23:19:38.88 process pointer page 11 of 45
23:19:38.98 process pointer page 12 of 45
23:19:39.07 process pointer page 13 of 45
23:19:39.17 process pointer page 14 of 45
23:19:39.26 process pointer page 15 of 45
23:19:39.35 process pointer page 16 of 45
23:19:39.45 process pointer page 17 of 45
23:19:39.54 process pointer page 18 of 45
23:19:39.63 process pointer page 19 of 45
23:19:39.73 process pointer page 20 of 45
23:19:39.81 process pointer page 21 of 45
23:19:39.90 process pointer page 22 of 45
23:19:39.99 process pointer page 23 of 45
23:19:40.09 process pointer page 24 of 45
23:19:40.18 process pointer page 25 of 45
23:19:40.27 process pointer page 26 of 45
23:19:40.37 process pointer page 27 of 45
23:19:40.46 process pointer page 28 of 45
23:19:40.55 process pointer page 29 of 45
23:19:40.65 process pointer page 30 of 45
23:19:40.74 process pointer page 31 of 45
23:19:40.82 process pointer page 32 of 45
23:19:40.91 process pointer page 33 of 45
23:19:41.02 process pointer page 34 of 45
23:19:41.10 process pointer page 35 of 45
23:19:41.21 process pointer page 36 of 45
23:19:41.30 process pointer page 37 of 45
23:19:41.40 process pointer page 38 of 45
23:19:41.49 process pointer page 39 of 45
23:19:41.58 process pointer page 40 of 45
23:19:41.66 process pointer page 41 of 45
23:19:41.76 process pointer page 42 of 45
23:19:41.85 process pointer page 43 of 45
23:19:41.94 process pointer page 44 of 45
23:19:42.04 Index 1 (XQS_1200_2000_DOC_ID)
23:19:43.88 Index 2 (XQS_1200_2000_SND_ID)
23:19:45.81 Index 3 (XQS_1200_2000_RCV_ID)
23:19:47.22 Relation 266 (XQS_1200_2000) is ok

23:19:47.22 Relation 267 (XQS_1000_3300)
23:19:47.22 process pointer page 0 of 21
23:19:47.31 process pointer page 1 of 21
23:19:47.40 process pointer page 2 of 21
23:19:47.50 process pointer page 3 of 21
23:19:47.59 process pointer page 4 of 21
23:19:47.68 process pointer page 5 of 21
23:19:47.76 process pointer page 6 of 21
23:19:47.85 process pointer page 7 of 21
23:19:47.95 process pointer page 8 of 21
23:19:48.04 process pointer page 9 of 21
23:19:48.14 process pointer page 10 of 21
23:19:48.21 process pointer page 11 of 21
23:19:48.31 process pointer page 12 of 21
23:19:48.40 process pointer page 13 of 21
23:19:48.48 process pointer page 14 of 21
23:19:48.57 process pointer page 15 of 21
23:19:48.67 process pointer page 16 of 21
23:19:48.76 process pointer page 17 of 21
23:19:48.85 process pointer page 18 of 21
23:19:48.95 process pointer page 19 of 21
23:19:49.02 process pointer page 20 of 21
23:19:49.04 Index 1 (XQS_1000_3300_DOC_ID)
23:19:49.84 Index 2 (XQS_1000_3300_SND_ID)
23:19:50.68 Index 3 (XQS_1000_3300_RCV_ID)
23:19:51.32 Relation 267 (XQS_1000_3300) is ok

23:19:51.32 Relation 268 (XQS_2000_3300)
23:19:51.32 process pointer page 0 of 1
23:19:51.32 Index 1 (XQS_2000_3300_DOC_ID)
23:19:51.32 Index 2 (XQS_2000_3300_SND_ID)
23:19:51.32 Index 3 (XQS_2000_3300_RCV_ID)
23:19:51.32 Relation 268 (XQS_2000_3300) is ok

23:19:51.32 Relation 269 (XQS_2100_3300)
23:19:51.32 process pointer page 0 of 29
23:19:51.41 process pointer page 1 of 29
23:19:51.51 process pointer page 2 of 29
23:19:51.60 process pointer page 3 of 29
23:19:51.69 process pointer page 4 of 29
23:19:51.79 process pointer page 5 of 29
23:19:51.88 process pointer page 6 of 29
23:19:51.97 process pointer page 7 of 29
23:19:52.05 process pointer page 8 of 29
23:19:52.14 process pointer page 9 of 29
23:19:52.24 process pointer page 10 of 29
23:19:52.33 process pointer page 11 of 29
23:19:52.43 process pointer page 12 of 29
23:19:52.52 process pointer page 13 of 29
23:19:52.61 process pointer page 14 of 29
23:19:52.69 process pointer page 15 of 29
23:19:52.78 process pointer page 16 of 29
23:19:52.88 process pointer page 17 of 29
23:19:52.97 process pointer page 18 of 29
23:19:53.05 process pointer page 19 of 29
23:19:53.14 process pointer page 20 of 29
23:19:53.24 process pointer page 21 of 29
23:19:53.33 process pointer page 22 of 29
23:19:53.42 process pointer page 23 of 29
23:19:53.50 process pointer page 24 of 29
23:19:53.60 process pointer page 25 of 29
23:19:53.69 process pointer page 26 of 29
23:19:53.78 process pointer page 27 of 29
23:19:53.88 process pointer page 28 of 29
23:19:53.95 Index 1 (XQS_2100_3300_DOC_ID)
23:19:55.03 Index 2 (XQS_2100_3300_SND_ID)
23:19:56.14 Index 3 (XQS_2100_3300_RCV_ID)
23:19:57.14 Relation 269 (XQS_2100_3300) is ok

23:19:57.14 Relation 270 (XQS_3300_3400)
23:19:57.14 process pointer page 0 of 5
23:19:57.23 process pointer page 1 of 5
23:19:57.32 process pointer page 2 of 5
23:19:57.42 process pointer page 3 of 5
23:19:57.50 process pointer page 4 of 5
23:19:57.51 Index 1 (XQS_3300_3400_DOC_ID)
23:19:57.65 Index 2 (XQS_3300_3400_SND_ID)
23:19:57.81 Relation 270 (XQS_3300_3400) is ok

23:19:57.81 Relation 276 (TRACE_STAT)
23:19:57.81 process pointer page 0 of 1
23:19:57.81 Relation 276 (TRACE_STAT) is ok

23:19:57.81 Validation finished
Done for 76540 ms, from 23:18:41.39 to 23:19:57.93.

Differences between old and current firebird.log

23:19:59.54. Got:
STDOUT: ---------- E:\OLTP-BIRD\TMP\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 25 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-05-31 23:19 756 oltp30_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:\OLTP-BIRD\TMP\oltp30_fb_log_when_test_started.log
***** E:\OLTP-BIRD\TMP\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
17:
18: WIN-2BE1UI8LGDL Tue May 31 23:18:41 2016
19: Database: D:\OLTP-EMUL\OLTP30-SMALL-HQBIRD.FDB
20: Validation started
21:
22:
23: WIN-2BE1UI8LGDL Tue May 31 23:19:57 2016
24: Database: D:\OLTP-EMUL\OLTP30-SMALL-HQBIRD.FDB
25: Validation finished: 0 errors, 0 warnings, 0 fixed
26:
*****
+++ End of comparison +++

Final processing ISQL logs in E:\OLTP-BIRD\tmp


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:\OLTP-BIRD\tmp\oltp30_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-05-31 23:20:02.55 - end of report, text file: E:\OLTP-BIRD\tmp\oltp30.report.txt, html: E:\OLTP-BIRD\tmp\oltp30.report.html