Tests

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

Server and database settings

Server version: WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215
Server implementation: Firebird/x86-64/Windows NT
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperClassic 2.5.5 D:\OLTP-HQBIRD\OLTP25-SMALL.FDB ON 0 1024 8192

Test configuration settings

File: E:\OLTP-HQBIRD\src\oltp25_config.win
PARAM_NAME PARAM_VALUE
fbc C:\Firebird\fb25hqbird\bin
dbnm D:\OLTP-HQBIRD\oltp25-small.fdb
host localhost
port 3049
usr SYSDBA
pwd masterke
tmpdir e:\temp\logs.hqbird.oltp25
working_mode small_03
warm_time 10
test_time 30
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 ak25
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-04-06 19:25:28.1990 -1 <null> 127.0.0.1 106943 4538 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
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
COMMON HALT_TEST_ON_ERRORS ,CK,
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 30 minutes: 6245.63 1970 187369 2016-04-06 18:55 2016-04-06 19:25
customer order: creation 114.40 62 3432 2016-04-06 18:55 2016-04-06 19:25
customer order: refuse 9.63 31 289 2016-04-06 18:55 2016-04-06 19:25
order to supplier: creation 29.37 216 881 2016-04-06 18:55 2016-04-06 19:25
order to supplier: removal 1.66 14836 48 2016-04-06 18:55 2016-04-06 19:25
invoice (draft): creation 29.03 374 871 2016-04-06 18:55 2016-04-06 19:25
invoice (draft): removal 18.97 89 569 2016-04-06 18:55 2016-04-06 19:25
invoice accept: apply 21.43 18849 643 2016-04-06 18:55 2016-04-06 19:25
invoice accept: cancel 7.57 673 227 2016-04-06 18:55 2016-04-06 19:25
customer reserve: creation 5430.70 71 162921 2016-04-06 18:55 2016-04-06 19:25
customer reserve: removal 397.90 54 11937 2016-04-06 18:55 2016-04-06 19:25
realization accept: apply 54.00 59 1620 2016-04-06 18:55 2016-04-06 19:25
realization accept: cancel 39.62 29 1149 2016-04-06 18:55 2016-04-06 19:25
payment from customer: creation 37.90 82 1137 2016-04-06 18:55 2016-04-06 19:25
payment from customer: removal 3.83 19 115 2016-04-06 18:55 2016-04-06 19:25
payment to supplier: creation 30.77 121 923 2016-04-06 18:55 2016-04-06 19:25
payment to supplier: removal 2.28 27 66 2016-04-06 18:55 2016-04-06 19:25
service: total inventory turnovers 11.13 192 334 2016-04-06 18:55 2016-04-06 19:25
service: total monetary turnovers 6.83 5 205 2016-04-06 18:55 2016-04-06 19:25
service: refresh index statistics 0.13 1648 2 2016-04-06 18:55 2016-04-06 19:25
Done for 6760 ms, from 19:26:50.77 to 19:26:57.53.

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 2791 9303 8372 931 10.01 18:55:29 18:58:29
interval # 2, overall 2 3466 10425 10397 28 0.27 18:58:30 19:01:30
interval # 3, overall 3 1255 3774 3765 9 0.24 19:01:31 19:04:31
interval # 4, overall 4 6051 18168 18152 16 0.09 19:04:32 19:07:32
interval # 5, overall 5 15432 46334 46296 38 0.08 19:07:33 19:10:33
interval # 6, overall 6 1411 4446 4233 213 4.79 19:10:34 19:13:34
interval # 7, overall 7 961 3129 2884 245 7.83 19:13:35 19:16:35
interval # 8, overall 8 6165 19589 18496 1093 5.58 19:16:36 19:19:36
interval # 9, overall 9 10899 32938 32696 242 0.73 19:19:37 19:22:37
interval # 10, overall 10 14026 42112 42078 34 0.08 19:22:38 19:25:38
Done for 10550 ms, from 19:27:06.57 to 19:27:17.12.

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 7330.04 0.0241 2.1982 954 10
WARM_TIME 2 8472.81 0.9509 1.0618 265 8
WARM_TIME 3 6160.43 0.9912 1.0359 102 3
WARM_TIME 4 6052.18 0.7908 1.2186 564 10
WARM_TIME 5 7289.72 0.8094 1.1499 849 10
WARM_TIME 6 7931.21 0.8808 1.1743 1220 10
WARM_TIME 7 8560.34 0.9397 1.0449 476 10
WARM_TIME 8 8078.47 0.9708 1.0406 359 8
WARM_TIME 9 7779.90 0.9621 1.0486 321 9
WARM_TIME 10 7644.92 0.9613 1.0246 399 9
TEST_TIME 11 7193.09 0.9900 1.0084 87 3
TEST_TIME 12 6749.64 0.9852 1.0132 103 7
TEST_TIME 13 6678.10 0.9494 1.0328 486 10
TEST_TIME 14 6483.16 0.9879 1.0082 196 7
TEST_TIME 15 6224.77 0.9800 1.0142 273 9
TEST_TIME 16 5983.68 0.9906 1.0057 70 5
TEST_TIME 17 5693.12 0.9949 1.0035 66 4
TEST_TIME 18 5403.03 0.9987 1.0005 79 3
TEST_TIME 19 5231.23 0.9817 1.0181 293 10
TEST_TIME 20 5078.31 0.9968 1.0059 118 5
TEST_TIME 21 5033.59 0.9698 1.0319 319 10
TEST_TIME 22 5310.95 0.9335 1.0665 930 10
TEST_TIME 23 5734.70 0.9447 1.0472 687 10
TEST_TIME 24 6053.84 0.9507 1.0547 797 10
TEST_TIME 25 6422.75 0.9544 1.0446 887 10
TEST_TIME 26 6457.17 0.9991 1.0003 64 2
TEST_TIME 27 6226.14 0.9990 1.0014 38 4
TEST_TIME 28 6028.65 0.9987 1.0003 39 2
TEST_TIME 29 5854.62 0.9945 1.0048 193 7
TEST_TIME 30 5699.68 0.9979 1.0012 42 2
TEST_TIME 31 5565.15 0.9941 1.0036 292 10
TEST_TIME 32 5443.98 0.9949 1.0058 178 6
TEST_TIME 33 5342.66 0.9952 1.0146 135 7
TEST_TIME 34 5569.99 0.9448 1.0364 836 10
TEST_TIME 35 5860.70 0.9568 1.0408 968 10
TEST_TIME 36 6026.79 0.9840 1.0125 524 10
TEST_TIME 37 5988.13 0.9915 1.0060 183 8
TEST_TIME 38 6083.36 0.9642 1.0375 704 10
TEST_TIME 39 6381.39 0.9637 1.0286 1146 10
TEST_TIME 40 6513.99 0.9824 1.0198 477 10
Done for 3400 ms, from 19:27:17.42 to 19:27:20.82.

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 33090 <null> <null> 37234 <null> 89600 26505 <null> <null> <null> 51448 <null> 41366 <null> <null> <null> 490259 <null> <null> 18:55:29 18:58:29
fetches per second 2 57872 89563 74739 230208 138345 <null> 50771 45092 25595 19857 61535 <null> 132002 <null> 194953 <null> <null> <null> <null> 18:58:30 19:01:30
fetches per second 3 56621 92375 67930 46556 23363 <null> 17255 <null> 12029 <null> 60327 53338 76420 44916 60553 <null> 770540 495515 <null> 19:01:31 19:04:31
fetches per second 4 29128 <null> 66550 <null> 90889 59894 124701 73470 23264 46416 60145 <null> 86303 37843 201478 <null> 426807 351345 <null> 19:04:32 19:07:32
fetches per second 5 25986 30850 38364 <null> 82655 <null> 389345 78483 16518 <null> 40270 17201 73403 18649 129404 14983 352333 156343 <null> 19:07:33 19:10:33
fetches per second 6 48498 67517 22627 <null> <null> <null> 340383 <null> <null> <null> 56138 <null> 115750 <null> 167739 <null> 364169 <null> <null> 19:10:34 19:13:34
fetches per second 7 41901 96769 49476 40083 67195 <null> 34532 54116 <null> 31816 50450 <null> 62509 <null> 132638 <null> 794831 339708 <null> 19:13:35 19:16:35
fetches per second 8 44515 <null> 137898 146828 116122 <null> 76651 49024 60115 <null> 98589 37450 100988 <null> 147595 <null> <null> 164460 <null> 19:16:36 19:19:36
fetches per second 9 34503 61598 49505 <null> 81339 60355 189334 <null> 34420 32736 52214 30611 70649 42120 158700 18390 544318 504705 <null> 19:19:37 19:22:37
fetches per second 10 27388 29727 42000 <null> 66594 <null> 212895 <null> 44681 35325 31745 19033 61557 37093 162454 <null> 356309 243365 <null> 19:22:38 19:25:38
marks per second 1 5891 <null> <null> 3729 <null> 14914 1236 <null> <null> <null> 3065 <null> 2163 <null> <null> <null> 82789 <null> <null> 18:55:29 18:58:29
marks per second 2 10534 8153 13178 43049 27299 <null> 2315 4650 3063 2168 9050 <null> 5201 <null> 4516 <null> <null> <null> <null> 18:58:30 19:01:30
marks per second 3 10426 8984 11328 4831 3465 <null> 814 <null> 1179 <null> 4813 9239 2779 3916 1105 <null> 8035 17401 <null> 19:01:31 19:04:31
marks per second 4 5346 <null> 11762 <null> 17951 10410 3457 7383 4011 4868 6568 <null> 4450 4562 2804 <null> 10996 16225 <null> 19:04:32 19:07:32
marks per second 5 4828 4305 6948 <null> 15301 <null> 3962 8010 1375 <null> 5393 1894 2380 2263 2254 1896 16811 5064 <null> 19:07:33 19:10:33
marks per second 6 9198 6907 4006 <null> <null> <null> 3258 <null> <null> <null> 7886 <null> 3910 <null> 5191 <null> 9735 <null> <null> 19:10:34 19:13:34
marks per second 7 7131 10692 7724 5191 10723 <null> 1014 5778 <null> 4383 7312 <null> 2009 <null> 2993 <null> 19705 9738 <null> 19:13:35 19:16:35
marks per second 8 8048 <null> 26753 16468 21666 <null> 5669 4888 8091 <null> 14813 4050 4054 <null> 5227 <null> <null> 10716 <null> 19:16:36 19:19:36
marks per second 9 6346 6503 8667 <null> 14517 10873 3808 <null> 2888 3416 10602 3832 3363 5080 2836 2000 36017 25987 <null> 19:19:37 19:22:37
marks per second 10 5097 2886 7197 <null> 11857 <null> 4617 <null> 3907 4037 4862 1933 2914 5375 3960 <null> 14467 6972 <null> 19:22:38 19:25:38
reads/fetches*100 1 4 <null> <null> 2 <null> 3 4 <null> <null> <null> 8 <null> 6 <null> <null> <null> 0 <null> <null> 18:55:29 18:58:29
reads/fetches*100 2 5 5 3 1 2 <null> 3 2 5 4 6 <null> 6 <null> 4 <null> <null> <null> <null> 18:58:30 19:01:30
reads/fetches*100 3 4 4 3 4 3 <null> 3 <null> 7 <null> 8 3 8 6 4 <null> 0 1 <null> 19:01:31 19:04:31
reads/fetches*100 4 7 <null> 4 <null> 3 4 2 3 5 5 7 <null> 7 8 4 <null> 1 1 <null> 19:04:32 19:07:32
reads/fetches*100 5 7 6 5 <null> 3 <null> 1 2 6 <null> 8 10 7 4 4 5 1 2 <null> 19:07:33 19:10:33
reads/fetches*100 6 7 3 3 <null> <null> <null> 3 <null> <null> <null> 6 <null> 2 <null> 3 <null> 1 <null> <null> 19:10:34 19:13:34
reads/fetches*100 7 3 5 1 2 2 <null> 2 1 <null> 3 5 <null> 5 <null> 4 <null> 0 0 <null> 19:13:35 19:16:35
reads/fetches*100 8 6 <null> 2 1 3 <null> 3 1 4 <null> 6 5 4 <null> 4 <null> <null> 1 <null> 19:16:36 19:19:36
reads/fetches*100 9 7 6 4 <null> 4 2 2 <null> 4 6 8 7 7 5 4 5 0 1 <null> 19:19:37 19:22:37
reads/fetches*100 10 7 7 4 <null> 4 <null> 2 <null> 5 5 8 4 8 5 4 <null> 1 2 <null> 19:22:38 19:25:38
writes/marks*100 1 12 <null> <null> 1 <null> 1 3 <null> <null> <null> 6 <null> 0 <null> <null> <null> 2 <null> <null> 18:55:29 18:58:29
writes/marks*100 2 12 14 10 2 7 <null> 2 0 6 7 7 <null> 0 <null> 0 <null> <null> <null> <null> 18:58:30 19:01:30
writes/marks*100 3 12 13 8 1 8 <null> 1 <null> 2 <null> 5 5 0 0 0 <null> 14 1 <null> 19:01:31 19:04:31
writes/marks*100 4 11 <null> 7 <null> 6 1 2 2 3 8 5 <null> 0 0 0 <null> 15 0 <null> 19:04:32 19:07:32
writes/marks*100 5 10 13 7 <null> 7 <null> 2 1 6 <null> 7 9 0 0 0 0 10 2 <null> 19:07:33 19:10:33
writes/marks*100 6 12 13 8 <null> <null> <null> 1 <null> <null> <null> 6 <null> 0 <null> 0 <null> 17 <null> <null> 19:10:34 19:13:34
writes/marks*100 7 13 13 5 2 9 <null> 1 1 <null> 5 8 <null> 0 <null> 0 <null> 12 0 <null> 19:13:35 19:16:35
writes/marks*100 8 11 <null> 9 2 7 <null> 2 0 8 <null> 5 10 0 <null> 0 <null> <null> 10 <null> 19:16:36 19:19:36
writes/marks*100 9 10 13 7 <null> 7 1 2 <null> 17 7 6 9 0 0 0 0 10 0 <null> 19:19:37 19:22:37
writes/marks*100 10 10 15 6 <null> 7 <null> 2 <null> 8 6 7 11 0 0 0 <null> 9 2 <null> 19:22:38 19:25:38
Done for 7880 ms, from 19:27:21.16 to 19:27:29.04.

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
<null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null>
Done for 950 ms, from 19:27:41.11 to 19:27:42.06.

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
<null> <null> <null> <null> <null> <null>
Done for 650 ms, from 19:27:42.19 to 19:27:42.84.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-HQBIRD\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 100509
MON$OLDEST_ACTIVE 107209
MON$OLDEST_SNAPSHOT 107088
MON$NEXT_TRANSACTION 107344
MON$PAGE_BUFFERS 1024
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 10:02:47.3010
MON$PAGES 235324
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.5.26952 Firebird 2.5 HQbird #20160215/tcp (WIN-2BE1UI8LGDL)/P12
on disk structure version 11.2

Database statistics, full


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

Variable header data:
Sweep interval: 0
Database GUID: {9DE52B4C-5F48-45BB-FC86-E1F63A260D94}
*END*


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

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

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

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

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

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

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

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

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

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

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

DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 40.42, total records: 623127
Average version length: 46.49, total versions: 79197, max versions: 1
Data pages: 6588, data page slots: 6588, average fill: 76%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5839
80 - 99% = 748

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 2243, nodes: 623125
Average data length: 12.53, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 221
20 - 39% = 33
40 - 59% = 1120
60 - 79% = 58
80 - 99% = 811

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

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 703, nodes: 623132
Average data length: 1.24, total dup: 498680, max dup: 49
Fill distribution:
0 - 19% = 33
20 - 39% = 14
40 - 59% = 349
60 - 79% = 1
80 - 99% = 306

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 57.51, total records: 126515
Average version length: 36.04, total versions: 13080, max versions: 3
Data pages: 1576, data page slots: 1576, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1242
80 - 99% = 333

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

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 114, nodes: 126474
Average data length: 0.01, total dup: 126424, max dup: 20666
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 78
60 - 79% = 20
80 - 99% = 16

Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 288, nodes: 126515
Average data length: 6.19, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 29
20 - 39% = 24
40 - 59% = 91
60 - 79% = 16
80 - 99% = 128

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

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

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

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

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

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

INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 63.53, total records: 400
Average version length: 16.50, total versions: 1504, max versions: 76
Data pages: 106, data page slots: 107, average fill: 20%
Fill distribution:
0 - 19% = 96
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 25.89, total records: 4641
Average version length: 68.99, total versions: 2900, max versions: 1
Data pages: 80, data page slots: 349, average fill: 70%
Fill distribution:
0 - 19% = 6
20 - 39% = 11
40 - 59% = 5
60 - 79% = 22
80 - 99% = 36

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

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

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 9.62, total records: 205
Average version length: 45.32, total versions: 163, max versions: 1
Data pages: 3, data page slots: 3, average fill: 65%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 2

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

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

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

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

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

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

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

MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 58
Average version length: 56.93, total versions: 58, max versions: 1
Data pages: 1, data page slots: 1, average fill: 65%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 40.15, total records: 76261
Average version length: 32.73, total versions: 6770, max versions: 7
Data pages: 1370, data page slots: 1405, average fill: 44%
Fill distribution:
0 - 19% = 277
20 - 39% = 469
40 - 59% = 92
60 - 79% = 526
80 - 99% = 6

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 73, nodes: 76262
Average data length: 0.01, total dup: 76213, max dup: 5387
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 37
60 - 79% = 10
80 - 99% = 8

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 93, nodes: 76264
Average data length: 0.88, total dup: 68784, max dup: 39
Fill distribution:
0 - 19% = 1
20 - 39% = 23
40 - 59% = 42
60 - 79% = 22
80 - 99% = 5

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 96, nodes: 76264
Average data length: 0.89, total dup: 68784, max dup: 39
Fill distribution:
0 - 19% = 0
20 - 39% = 30
40 - 59% = 47
60 - 79% = 11
80 - 99% = 8

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 100, nodes: 76264
Average data length: 0.67, total dup: 68784, max dup: 39
Fill distribution:
0 - 19% = 1
20 - 39% = 43
40 - 59% = 32
60 - 79% = 20
80 - 99% = 4

PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 0.00, total records: 16808
Average version length: 27.94, total versions: 16808, max versions: 1
Data pages: 145, data page slots: 311, average fill: 88%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 143

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 28, nodes: 16808
Average data length: 0.00, total dup: 16767, max dup: 1219
Fill distribution:
0 - 19% = 10
20 - 39% = 8
40 - 59% = 7
60 - 79% = 3
80 - 99% = 0

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

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

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

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 2704, nodes: 2478604
Average data length: 0.38, total dup: 1804766, max dup: 66
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1615
60 - 79% = 664
80 - 99% = 423

Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 2463, nodes: 2478632
Average data length: 0.00, total dup: 2478627, max dup: 2400131
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2461
60 - 79% = 2
80 - 99% = 0

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 2855, nodes: 2478632
Average data length: 0.23, total dup: 2390525, max dup: 7743
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2235
60 - 79% = 329
80 - 99% = 291

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 2822, nodes: 2478669
Average data length: 0.23, total dup: 2426654, max dup: 259675
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 2232
60 - 79% = 268
80 - 99% = 318

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 48.46, total records: 111074
Average version length: 54.92, total versions: 13085, max versions: 1
Data pages: 1299, data page slots: 1299, average fill: 77%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1119
80 - 99% = 179

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 134, nodes: 111074
Average data length: 1.10, total dup: 92672, max dup: 427
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 108
60 - 79% = 20
80 - 99% = 4

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 100, nodes: 111074
Average data length: 0.64, total dup: 100691, max dup: 90
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 36
60 - 79% = 43
80 - 99% = 21

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 3.11, total records: 3467
Average version length: 71.09, total versions: 3316, max versions: 1
Data pages: 48, data page slots: 197, average fill: 92%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 47

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

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 66.10, total records: 207035
Average version length: 69.78, total versions: 12263, max versions: 1
Data pages: 3171, data page slots: 3592, average fill: 72%
Fill distribution:
0 - 19% = 116
20 - 39% = 202
40 - 59% = 214
60 - 79% = 1822
80 - 99% = 817

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 223, nodes: 206371
Average data length: 0.26, total dup: 198543, max dup: 106
Fill distribution:
0 - 19% = 0
20 - 39% = 63
40 - 59% = 89
60 - 79% = 15
80 - 99% = 56

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 306, nodes: 206877
Average data length: 1.32, total dup: 179450, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 76
40 - 59% = 141
60 - 79% = 70
80 - 99% = 19

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 40.42, total records: 26447
Average version length: 70.29, total versions: 11305, max versions: 1
Data pages: 487, data page slots: 927, average fill: 64%
Fill distribution:
0 - 19% = 19
20 - 39% = 53
40 - 59% = 118
60 - 79% = 112
80 - 99% = 185

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 38, nodes: 26447
Average data length: 1.74, total dup: 22677, max dup: 45
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 13
60 - 79% = 10
80 - 99% = 3

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 14.76, total records: 1536014
Average version length: 68.92, total versions: 1213865, max versions: 1
Data pages: 20746, data page slots: 20746, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3770
80 - 99% = 16975

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1994, nodes: 1536014
Average data length: 0.94, total dup: 1388057, max dup: 99
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1715
60 - 79% = 143
80 - 99% = 135

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 40.23, total records: 11447
Average version length: 69.80, total versions: 4899, max versions: 1
Data pages: 159, data page slots: 1280, average fill: 83%
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 2
60 - 79% = 41
80 - 99% = 113

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 13, nodes: 11420
Average data length: 2.17, total dup: 9839, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 9
80 - 99% = 2

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 35.94, total records: 1157311
Average version length: 68.88, total versions: 561498, max versions: 1
Data pages: 15639, data page slots: 15639, average fill: 86%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3054
80 - 99% = 12583

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1649, nodes: 1156430
Average data length: 1.43, total dup: 982184, max dup: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 1347
60 - 79% = 162
80 - 99% = 137

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 77.42, total records: 1199719
Average version length: 81.17, total versions: 52709, max versions: 1
Data pages: 17953, data page slots: 17953, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6362
80 - 99% = 11590

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 1322, nodes: 1199719
Average data length: 0.15, total dup: 1172803, max dup: 172
Fill distribution:
0 - 19% = 10
20 - 39% = 0
40 - 59% = 932
60 - 79% = 327
80 - 99% = 53

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 940, nodes: 1199719
Average data length: 0.70, total dup: 1055719, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 139
60 - 79% = 22
80 - 99% = 778

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1488, nodes: 1199719
Average data length: 0.73, total dup: 1051769, max dup: 44
Fill distribution:
0 - 19% = 11
20 - 39% = 0
40 - 59% = 1021
60 - 79% = 390
80 - 99% = 66

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 55.35, total records: 992377
Average version length: 80.74, total versions: 314753, max versions: 1
Data pages: 14808, data page slots: 14808, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1
60 - 79% = 2548
80 - 99% = 12258

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 884, nodes: 991873
Average data length: 0.12, total dup: 974708, max dup: 494
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 276
60 - 79% = 348
80 - 99% = 259

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 936, nodes: 992455
Average data length: 0.92, total dup: 843744, max dup: 14
Fill distribution:
0 - 19% = 31
20 - 39% = 11
40 - 59% = 296
60 - 79% = 4
80 - 99% = 594

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 1014, nodes: 991880
Average data length: 0.55, total dup: 902249, max dup: 83
Fill distribution:
0 - 19% = 33
20 - 39% = 0
40 - 59% = 312
60 - 79% = 404
80 - 99% = 265

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 61.67, total records: 1536373
Average version length: 82.17, total versions: 367492, max versions: 1
Data pages: 23014, data page slots: 23014, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7271
80 - 99% = 15742

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 1527, nodes: 1536373
Average data length: 0.04, total dup: 1529113, max dup: 1468
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 868
60 - 79% = 467
80 - 99% = 187

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 1154, nodes: 1536373
Average data length: 0.56, total dup: 1387786, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 132
60 - 79% = 21
80 - 99% = 1000

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 1689, nodes: 1536373
Average data length: 0.55, total dup: 1393314, max dup: 211
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 902
60 - 79% = 534
80 - 99% = 247

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

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

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

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

XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 57.99, total records: 1186116
Average version length: 80.92, total versions: 339284, max versions: 1
Data pages: 17735, data page slots: 17735, average fill: 84%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2794
80 - 99% = 14940

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 1090, nodes: 1184891
Average data length: 0.04, total dup: 1179590, max dup: 1163
Fill distribution:
0 - 19% = 2
20 - 39% = 12
40 - 59% = 439
60 - 79% = 374
80 - 99% = 263

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 1230, nodes: 1186335
Average data length: 0.93, total dup: 1007611, max dup: 14
Fill distribution:
0 - 19% = 37
20 - 39% = 45
40 - 59% = 504
60 - 79% = 14
80 - 99% = 630

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 1215, nodes: 1184544
Average data length: 0.53, total dup: 1079987, max dup: 101
Fill distribution:
0 - 19% = 2
20 - 39% = 8
40 - 59% = 465
60 - 79% = 449
80 - 99% = 291

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 46.66, total records: 372590
Average version length: 68.46, total versions: 118782, max versions: 1
Data pages: 5018, data page slots: 5018, average fill: 83%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2370
80 - 99% = 2647

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 344, nodes: 372590
Average data length: 0.23, total dup: 360041, max dup: 213
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 129
60 - 79% = 135
80 - 99% = 80

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 396, nodes: 372590
Average data length: 0.83, total dup: 323776, max dup: 44
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 150
60 - 79% = 163
80 - 99% = 83

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Z_USED_VIEWS (146)
Primary pointer page: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

Done for 2900 ms, from 19:27:43.08 to 19:27:45.98.

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 623127 79197 12.7096
DOC_LIST 126515 13080 10.3386
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 1504 376.0000
INVNT_TURNOVER_LOG 4641 2900 62.4865
MONEY_SALDO 49 88 179.5918
MONEY_TURNOVER_LOG 205 163 79.5121
MON_LOG_TABLE_STATS 58 58 100.0000
OPTYPES 9 0 0.0000
PDISTR 76261 6770 8.8774
PERF_ESTIMATED 16808 16808 100.0000
PERF_LOG 2478604 3 0.0001
PSTORNED 111074 13085 11.7804
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 8 200.0000
SETTINGS 114 0 0.0000
TRACE_STAT 3078 3078 100.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 3467 3316 95.6446
XQD_1000_3300 207035 12263 5.9231
XQD_1200_2000 26447 11305 42.7458
XQD_2000_3300 1536014 1213865 79.0269
XQD_2100_3300 11447 4899 42.7972
XQD_3300_3400 1157311 561498 48.5174
XQS_1000_1200 1199719 52709 4.3934
XQS_1000_3300 992377 314753 31.7170
XQS_1200_2000 1536373 367492 23.9194
XQS_2100_3300 1186116 339284 28.6046
XQS_3300_3400 372590 118782 31.8800
Z_USED_VIEWS 32 0 0.0000
Done for 2050 ms, from 19:27:51.08 to 19:27:53.13.

Database validation

19:27:53.24 Validation started

19:27:53.24 Relation 140 (DOC_LIST)
19:27:54.01 Acquire relation lock failed
19:27:54.01 Relation 140 (DOC_LIST) : 1 ERRORS found

19:27:54.01 Relation 141 (DOC_DATA)
19:27:55.01 Acquire relation lock failed
19:27:55.01 Relation 141 (DOC_DATA) : 1 ERRORS found

19:27:55.01 Relation 147 (INVNT_SALDO)
19:27:55.01 process pointer page 0 of 1
19:27:55.01 Index 1 (PK_INVNT_SALDO)
19:27:55.01 Relation 147 (INVNT_SALDO) is ok

19:27:55.01 Relation 150 (PDISTR)
19:27:56.11 Acquire relation lock failed
19:27:56.11 Relation 150 (PDISTR) : 1 ERRORS found

19:27:56.11 Relation 151 (PSTORNED)
19:27:57.00 Acquire relation lock failed
19:27:57.00 Relation 151 (PSTORNED) : 1 ERRORS found

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

19:27:57.00 Relation 157 (INVNT_TURNOVER_LOG)
19:27:58.01 Acquire relation lock failed
19:27:58.01 Relation 157 (INVNT_TURNOVER_LOG) : 1 ERRORS found

19:27:58.01 Relation 160 (PERF_ESTIMATED)
19:27:58.01 process pointer page 0 of 1
19:27:58.03 Index 1 (PERF_EST_MINUTE_SINCE_START)
19:27:58.03 Relation 160 (PERF_ESTIMATED) is ok

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

19:27:58.03 Relation 162 (PERF_LOG)
19:27:58.82 process pointer page 0 of 31
19:27:58.87 process pointer page 1 of 31
19:27:58.92 process pointer page 2 of 31
19:27:58.95 process pointer page 3 of 31
19:27:58.99 process pointer page 4 of 31
19:27:59.02 process pointer page 5 of 31
19:27:59.07 process pointer page 6 of 31
19:27:59.12 process pointer page 7 of 31
19:27:59.16 process pointer page 8 of 31
19:27:59.20 process pointer page 9 of 31
19:27:59.24 process pointer page 10 of 31
19:27:59.29 process pointer page 11 of 31
19:27:59.32 process pointer page 12 of 31
19:27:59.35 process pointer page 13 of 31
19:27:59.40 process pointer page 14 of 31
19:27:59.43 process pointer page 15 of 31
19:27:59.48 process pointer page 16 of 31
19:27:59.52 process pointer page 17 of 31
19:27:59.55 process pointer page 18 of 31
19:27:59.59 process pointer page 19 of 31
19:27:59.63 process pointer page 20 of 31
19:27:59.66 process pointer page 21 of 31
19:27:59.71 process pointer page 22 of 31
19:27:59.74 process pointer page 23 of 31
19:27:59.79 process pointer page 24 of 31
19:28:00.51 process pointer page 25 of 31
19:28:01.43 process pointer page 26 of 31
19:28:02.08 process pointer page 27 of 31
19:28:02.91 process pointer page 28 of 31
19:28:03.69 process pointer page 29 of 31
19:28:04.47 process pointer page 30 of 31
19:28:04.72 Index 1 (PERF_LOG_DTS_BEG_DESC)
19:28:05.00 Index 2 (PERF_LOG_UNIT)
19:28:05.45 Index 3 (PERF_LOG_TRN_DESC)
19:28:05.70 Index 4 (PERF_LOG_GDSCODE)
19:28:05.94 Relation 162 (PERF_LOG) is ok

19:28:05.94 Relation 166 (V_STOPTEST)
19:28:05.94 Relation 166 (V_STOPTEST) is ok

19:28:05.94 Relation 183 (V_QDISTR_SOURCE)
19:28:05.94 Relation 183 (V_QDISTR_SOURCE) is ok

19:28:05.94 Relation 184 (V_QSTORNED_SOURCE)
19:28:05.94 Relation 184 (V_QSTORNED_SOURCE) is ok

19:28:05.94 Relation 258 (XQD_1000_1200)
19:28:05.94 process pointer page 0 of 2
19:28:05.94 process pointer page 1 of 2
19:28:05.94 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
19:28:05.95 Relation 258 (XQD_1000_1200) is ok

19:28:05.95 Relation 259 (XQD_1200_2000)
19:28:06.04 Acquire relation lock failed
19:28:06.04 Relation 259 (XQD_1200_2000) : 1 ERRORS found

19:28:06.04 Relation 260 (XQD_1000_3300)
19:28:07.00 Acquire relation lock failed
19:28:07.00 Relation 260 (XQD_1000_3300) : 1 ERRORS found

19:28:07.00 Relation 261 (XQD_2000_3300)
19:28:08.01 Acquire relation lock failed
19:28:08.01 Relation 261 (XQD_2000_3300) : 1 ERRORS found

19:28:08.01 Relation 262 (XQD_2100_3300)
19:28:09.04 Acquire relation lock failed
19:28:09.04 Relation 262 (XQD_2100_3300) : 1 ERRORS found

19:28:09.04 Relation 263 (XQD_3300_3400)
19:28:10.01 Acquire relation lock failed
19:28:10.01 Relation 263 (XQD_3300_3400) : 1 ERRORS found

19:28:10.01 Relation 264 (XQS_1000_1200)
19:28:10.01 process pointer page 0 of 10
19:28:10.05 process pointer page 1 of 10
19:28:10.10 process pointer page 2 of 10
19:28:10.15 process pointer page 3 of 10
19:28:10.19 process pointer page 4 of 10
19:28:10.24 process pointer page 5 of 10
19:28:10.29 process pointer page 6 of 10
19:28:10.33 process pointer page 7 of 10
19:28:10.40 process pointer page 8 of 10
19:28:10.86 process pointer page 9 of 10
19:28:11.43 Index 1 (XQS_1000_1200_DOC_ID)
19:28:11.55 Index 2 (XQS_1000_1200_SND_ID)
19:28:11.68 Index 3 (XQS_1000_1200_RCV_ID)
19:28:11.77 Relation 264 (XQS_1000_1200) is ok

19:28:11.77 Relation 265 (XQS_1200_2000)
19:28:11.83 process pointer page 0 of 13
19:28:11.88 process pointer page 1 of 13
19:28:11.93 process pointer page 2 of 13
19:28:11.97 process pointer page 3 of 13
19:28:12.00 process pointer page 4 of 13
19:28:12.05 process pointer page 5 of 13
19:28:12.11 process pointer page 6 of 13
19:28:12.16 process pointer page 7 of 13
19:28:12.22 process pointer page 8 of 13
19:28:12.30 process pointer page 9 of 13
19:28:12.38 process pointer page 10 of 13
19:28:12.64 process pointer page 11 of 13
19:28:13.88 process pointer page 12 of 13
19:28:13.94 Index 1 (XQS_1200_2000_DOC_ID)
19:28:14.08 Index 2 (XQS_1200_2000_SND_ID)
19:28:14.23 Index 3 (XQS_1200_2000_RCV_ID)
19:28:14.36 Relation 265 (XQS_1200_2000) is ok

19:28:14.36 Relation 266 (XQS_1000_3300)
19:28:15.37 Acquire relation lock failed
19:28:15.37 Relation 266 (XQS_1000_3300) : 1 ERRORS found

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

19:28:15.37 Relation 268 (XQS_2100_3300)
19:28:16.39 Acquire relation lock failed
19:28:16.39 Relation 268 (XQS_2100_3300) : 1 ERRORS found

19:28:16.39 Relation 269 (XQS_3300_3400)
19:28:16.39 process pointer page 0 of 3
19:28:16.43 process pointer page 1 of 3
19:28:16.50 process pointer page 2 of 3
19:28:16.64 Index 1 (XQS_3300_3400_DOC_ID)
19:28:16.67 Index 2 (XQS_3300_3400_SND_ID)
19:28:16.78 Relation 269 (XQS_3300_3400) is ok

19:28:16.78 Relation 276 (TRACE_STAT)
19:28:16.78 process pointer page 0 of 1
19:28:16.78 Relation 276 (TRACE_STAT) is ok

19:28:16.78 Validation finished
Done for 23620 ms, from 19:27:53.17 to 19:28:16.79.

Differences between old and current firebird.log

19:28:17.10. Got:
STDOUT: ---------- E:\TEMP\LOGS.HQBIRD.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 2 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-04-06 19:28 87 oltp25_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

+++ Start of comparison +++
***** E:\TEMP\LOGS.HQBIRD.OLTP25\oltp25_fb_log_when_test_started.log
***** E:\TEMP\LOGS.HQBIRD.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
1: operating system directive fopen failed
2: -The system cannot find the file specified.
*****
+++ End of comparison +++

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


Remove 31 logs of every ISQL session if there were no serious errors.

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.hqbird.oltp25\oltp25_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-04-06 19:28:17.85 - end of report, text file: e:\temp\logs.hqbird.oltp25\oltp25.report.txt, html: e:\temp\logs.hqbird.oltp25\oltp25.report.html

Subscribe to IBSurgeon news

Subscribe