Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-11-30 6:58:46.96.
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.2.32641 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 3.0.2 D:\OLTP-EMUL\OLTP30-SMALL.FDB ON 0 786432 8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB30.TMPINSTANCE
dbnm D:\OLTP-EMUL\oltp30-small.fdb
host localhost
port 3333
usr SYSDBA
pwd masterkey
tmpdir e:\temp\logs.oltp30
working_mode small_03
warm_time 10
test_time 180
idle_time 0
use_mtee 0
is_embed 0
remove_isql_logs if_no_severe_errors
no_auto_undo 1
detailed_info 0
mon_unit_perf 0
trc_unit_perf 1
init_buff 32768
create_with_fw sync
create_with_sweep 0
wait_if_not_exists 0
wait_after_create 0
init_docs 0
wait_for_copy 0
create_with_debug_objects 1
create_with_split_heavy_tabs 1
create_with_separate_qdistr_idx 0
create_with_compound_columns_order most_selective_first
make_html 1
run_db_statistics 1
run_db_validation 1
file_name_with_test_params regular
file_name_this_host_info ak30
upload_report 1
max_snapshots_to_store 180
replace_instance 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-11-30 06:55:54.9190 -1 <null> ::1/54828 307224 4900 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 181 minutes: 4510.52 7538 816405 2016-11-30 03:55 2016-11-30 06:56
customer order: creation 357.72 1169 64389 2016-11-30 03:55 2016-11-30 06:56
customer order: refuse 27.86 86 5015 2016-11-30 03:55 2016-11-30 06:56
order to supplier: creation 91.55 8264 16479 2016-11-30 03:55 2016-11-30 06:56
order to supplier: removal 2.04 80634 365 2016-11-30 03:55 2016-11-30 06:56
invoice (draft): creation 92.36 12091 16717 2016-11-30 03:55 2016-11-30 06:56
invoice (draft): removal 28.66 2576 5131 2016-11-30 03:55 2016-11-30 06:56
invoice accept: apply 58.01 24875 10441 2016-11-30 03:55 2016-11-30 06:56
invoice accept: cancel 13.82 6040 2473 2016-11-30 03:55 2016-11-30 06:56
customer reserve: creation 2700.18 469 486033 2016-11-30 03:55 2016-11-30 06:56
customer reserve: removal 675.28 170 120876 2016-11-30 03:55 2016-11-30 06:56
realization accept: apply 166.00 385 29880 2016-11-30 03:55 2016-11-30 06:56
realization accept: cancel 48.86 280 8795 2016-11-30 03:55 2016-11-30 06:56
payment from customer: creation 120.66 336 21718 2016-11-30 03:55 2016-11-30 06:56
payment from customer: removal 11.44 118 2047 2016-11-30 03:55 2016-11-30 06:56
payment to supplier: creation 98.43 730 17717 2016-11-30 03:55 2016-11-30 06:56
payment to supplier: removal 7.11 173 1272 2016-11-30 03:55 2016-11-30 06:56
service: total inventory turnovers 18.88 1407 3398 2016-11-30 03:55 2016-11-30 06:56
service: total monetary turnovers 20.37 60 3647 2016-11-30 03:55 2016-11-30 06:56
service: refresh index statistics 0.07 3358 12 2016-11-30 03:55 2016-11-30 06:56
Done for 58130 ms, from 6:59:54.17 to 7:00:52.30.

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 2971 57367 53478 3889 6.78 03:55:55 04:13:55
interval # 2, overall 2 4383 84283 78886 5397 6.40 04:13:56 04:31:56
interval # 3, overall 3 4603 86518 82848 3670 4.24 04:31:57 04:49:57
interval # 4, overall 4 5007 97208 90132 7076 7.28 04:49:58 05:07:58
interval # 5, overall 5 4605 89992 82885 7107 7.90 05:07:59 05:25:59
interval # 6, overall 6 5052 96335 90944 5391 5.60 05:26:00 05:44:00
interval # 7, overall 7 4767 90214 85809 4405 4.88 05:44:01 06:02:01
interval # 8, overall 8 4626 85680 83272 2408 2.81 06:02:02 06:20:02
interval # 9, overall 9 4974 93377 89539 3838 4.11 06:20:03 06:38:03
interval # 10, overall 10 4367 81482 78612 2870 3.52 06:38:04 06:56:04
Done for 84660 ms, from 7:02:14.63 to 7:03:39.29.

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 1524.81 0.0006 1.9615 1979 100
WARM_TIME 2 2191.70 0.6825 1.3272 2767 99
WARM_TIME 3 2308.47 0.8402 1.1466 2030 83
WARM_TIME 4 2213.08 0.8971 1.1051 1636 68
WARM_TIME 5 2112.54 0.9262 1.0756 1344 54
WARM_TIME 6 2005.14 0.9444 1.0558 1063 50
WARM_TIME 7 1898.07 0.9561 1.0474 938 45
WARM_TIME 8 1811.03 0.9606 1.0371 693 41
WARM_TIME 9 1726.89 0.9668 1.0282 694 38
WARM_TIME 10 1657.27 0.9643 1.0404 733 43
TEST_TIME 11 1623.54 0.9655 1.0390 832 42
TEST_TIME 12 1593.57 0.9704 1.0330 664 48
TEST_TIME 13 1577.61 0.9632 1.0403 778 47
TEST_TIME 14 1603.62 0.9504 1.0521 926 64
TEST_TIME 15 1640.71 0.9598 1.0438 983 62
TEST_TIME 16 1698.32 0.9454 1.0455 1056 78
TEST_TIME 17 1731.89 0.9650 1.0360 1071 72
TEST_TIME 18 1757.12 0.9644 1.0405 1170 79
TEST_TIME 19 1814.15 0.9548 1.0498 1306 87
TEST_TIME 20 1904.26 0.9502 1.0518 1189 94
TEST_TIME 21 1973.94 0.9666 1.0338 1138 84
TEST_TIME 22 2031.21 0.9590 1.0396 1491 93
TEST_TIME 23 2112.03 0.9564 1.0379 1488 92
TEST_TIME 24 2208.36 0.9513 1.0394 1673 97
TEST_TIME 25 2269.49 0.9710 1.0235 1333 89
TEST_TIME 26 2326.49 0.9600 1.0368 1574 97
TEST_TIME 27 2390.08 0.9718 1.0325 1513 98
TEST_TIME 28 2469.20 0.9637 1.0326 1505 98
TEST_TIME 29 2546.44 0.9668 1.0333 1621 98
TEST_TIME 30 2599.59 0.9785 1.0260 1342 96
TEST_TIME 31 2644.81 0.9759 1.0248 1443 96
TEST_TIME 32 2693.79 0.9747 1.0254 1380 96
TEST_TIME 33 2729.18 0.9814 1.0178 1245 92
TEST_TIME 34 2758.58 0.9774 1.0227 1285 95
TEST_TIME 35 2790.91 0.9820 1.0203 1324 96
TEST_TIME 36 2834.75 0.9766 1.0259 1613 97
TEST_TIME 37 2883.96 0.9811 1.0231 1399 98
TEST_TIME 38 2912.21 0.9866 1.0148 1181 87
TEST_TIME 39 2932.67 0.9819 1.0184 1251 95
TEST_TIME 40 2983.26 0.9765 1.0200 1413 96
TEST_TIME 41 3035.97 0.9779 1.0225 1523 94
TEST_TIME 42 3098.46 0.9784 1.0188 1413 93
TEST_TIME 43 3129.38 0.9853 1.0131 1281 94
TEST_TIME 44 3146.22 0.9848 1.0143 1265 94
TEST_TIME 45 3172.81 0.9840 1.0208 1372 96
TEST_TIME 46 3214.58 0.9857 1.0148 1333 96
TEST_TIME 47 3233.89 0.9873 1.0123 1234 95
TEST_TIME 48 3248.38 0.9868 1.0132 1253 93
TEST_TIME 49 3272.33 0.9852 1.0112 1168 93
TEST_TIME 50 3274.29 0.9904 1.0107 1094 88
TEST_TIME 51 3301.76 0.9826 1.0174 1562 98
TEST_TIME 52 3346.11 0.9846 1.0158 1534 97
TEST_TIME 53 3392.93 0.9829 1.0153 1511 96
TEST_TIME 54 3406.04 0.9926 1.0085 1227 87
TEST_TIME 55 3411.55 0.9885 1.0136 1274 92
TEST_TIME 56 3440.87 0.9871 1.0139 1401 98
TEST_TIME 57 3460.49 0.9905 1.0101 1039 93
TEST_TIME 58 3485.80 0.9855 1.0135 1307 96
TEST_TIME 59 3509.89 0.9895 1.0116 1188 93
TEST_TIME 60 3540.32 0.9862 1.0116 1265 92
TEST_TIME 61 3557.70 0.9902 1.0094 1151 93
TEST_TIME 62 3571.87 0.9892 1.0097 1117 93
TEST_TIME 63 3591.09 0.9883 1.0098 1216 93
TEST_TIME 64 3603.61 0.9906 1.0078 1140 97
TEST_TIME 65 3611.14 0.9904 1.0106 1101 91
TEST_TIME 66 3642.79 0.9866 1.0120 1483 96
TEST_TIME 67 3676.85 0.9877 1.0117 1294 98
TEST_TIME 68 3710.44 0.9878 1.0138 1467 97
TEST_TIME 69 3737.46 0.9919 1.0082 1160 96
TEST_TIME 70 3747.65 0.9911 1.0093 1312 92
TEST_TIME 71 3767.10 0.9900 1.0109 1292 97
TEST_TIME 72 3786.94 0.9916 1.0068 1259 90
TEST_TIME 73 3793.25 0.9914 1.0089 1314 93
TEST_TIME 74 3808.83 0.9912 1.0086 1247 95
TEST_TIME 75 3817.01 0.9931 1.0075 1181 91
TEST_TIME 76 3828.09 0.9913 1.0086 1207 95
TEST_TIME 77 3835.19 0.9936 1.0069 1201 90
TEST_TIME 78 3844.11 0.9916 1.0085 1213 92
TEST_TIME 79 3862.16 0.9911 1.0074 1229 93
TEST_TIME 80 3872.22 0.9923 1.0079 1046 95
TEST_TIME 81 3885.66 0.9921 1.0084 1372 94
TEST_TIME 82 3902.99 0.9917 1.0085 1312 92
TEST_TIME 83 3921.04 0.9917 1.0082 1353 91
TEST_TIME 84 3932.03 0.9934 1.0054 1284 90
TEST_TIME 85 3935.27 0.9928 1.0066 1207 94
TEST_TIME 86 3936.17 0.9950 1.0055 992 81
TEST_TIME 87 3946.23 0.9914 1.0074 1151 89
TEST_TIME 88 3957.44 0.9931 1.0066 1320 94
TEST_TIME 89 3964.56 0.9935 1.0059 1154 94
TEST_TIME 90 3959.80 0.9959 1.0051 1016 86
TEST_TIME 91 3962.58 0.9933 1.0058 1114 89
TEST_TIME 92 3970.66 0.9928 1.0057 1118 91
TEST_TIME 93 3970.00 0.9950 1.0053 1096 93
TEST_TIME 94 3966.36 0.9955 1.0046 1053 87
TEST_TIME 95 3961.21 0.9953 1.0049 1172 89
TEST_TIME 96 3965.12 0.9935 1.0070 1291 92
TEST_TIME 97 3983.25 0.9921 1.0066 1301 94
TEST_TIME 98 3996.19 0.9931 1.0066 1282 96
TEST_TIME 99 4015.01 0.9918 1.0048 1198 93
TEST_TIME 100 4023.02 0.9928 1.0067 1480 96
TEST_TIME 101 4034.38 0.9939 1.0068 1234 96
TEST_TIME 102 4042.21 0.9950 1.0043 1212 88
TEST_TIME 103 4041.13 0.9948 1.0044 954 82
TEST_TIME 104 4045.44 0.9937 1.0064 1193 91
TEST_TIME 105 4054.98 0.9944 1.0073 1190 90
TEST_TIME 106 4068.45 0.9945 1.0050 1086 88
TEST_TIME 107 4079.03 0.9930 1.0066 1088 92
TEST_TIME 108 4084.56 0.9960 1.0048 1034 90
TEST_TIME 109 4083.82 0.9958 1.0044 1025 86
TEST_TIME 110 4083.69 0.9953 1.0038 966 83
TEST_TIME 111 4092.74 0.9926 1.0071 1349 97
TEST_TIME 112 4107.10 0.9946 1.0050 1411 93
TEST_TIME 113 4117.64 0.9936 1.0059 1311 91
TEST_TIME 114 4124.61 0.9954 1.0065 1370 92
TEST_TIME 115 4141.76 0.9937 1.0061 1216 95
TEST_TIME 116 4146.75 0.9962 1.0040 1172 95
TEST_TIME 117 4147.50 0.9953 1.0051 1373 97
TEST_TIME 118 4151.73 0.9956 1.0040 1196 91
TEST_TIME 119 4154.31 0.9950 1.0043 1192 89
TEST_TIME 120 4157.70 0.9951 1.0054 1121 92
TEST_TIME 121 4161.24 0.9963 1.0053 1100 90
TEST_TIME 122 4166.93 0.9957 1.0039 1107 88
TEST_TIME 123 4167.03 0.9957 1.0037 1142 89
TEST_TIME 124 4172.46 0.9943 1.0043 1176 90
TEST_TIME 125 4177.85 0.9950 1.0052 1128 93
TEST_TIME 126 4182.80 0.9960 1.0046 1283 91
TEST_TIME 127 4199.62 0.9927 1.0052 1105 93
TEST_TIME 128 4213.43 0.9941 1.0066 1304 97
TEST_TIME 129 4230.00 0.9952 1.0045 1200 96
TEST_TIME 130 4233.70 0.9959 1.0049 1370 94
TEST_TIME 131 4237.25 0.9964 1.0032 1134 92
TEST_TIME 132 4233.62 0.9964 1.0036 1200 91
TEST_TIME 133 4233.01 0.9962 1.0038 1201 92
TEST_TIME 134 4232.22 0.9965 1.0034 1189 91
TEST_TIME 135 4234.75 0.9954 1.0045 1127 91
TEST_TIME 136 4242.80 0.9952 1.0051 1057 92
TEST_TIME 137 4250.94 0.9958 1.0035 1087 92
TEST_TIME 138 4249.44 0.9966 1.0047 1040 94
TEST_TIME 139 4253.48 0.9965 1.0040 961 91
TEST_TIME 140 4254.65 0.9966 1.0028 956 92
TEST_TIME 141 4252.97 0.9961 1.0041 1216 94
TEST_TIME 142 4262.80 0.9947 1.0041 1089 89
TEST_TIME 143 4266.18 0.9963 1.0040 1146 90
TEST_TIME 144 4270.44 0.9961 1.0040 1137 93
TEST_TIME 145 4278.06 0.9953 1.0037 1088 96
TEST_TIME 146 4278.84 0.9967 1.0033 976 91
TEST_TIME 147 4277.47 0.9968 1.0035 1137 93
TEST_TIME 148 4279.95 0.9961 1.0032 1158 91
TEST_TIME 149 4279.84 0.9965 1.0034 1338 92
TEST_TIME 150 4278.73 0.9970 1.0029 1021 87
TEST_TIME 151 4274.08 0.9973 1.0025 997 83
TEST_TIME 152 4267.94 0.9974 1.0029 924 83
TEST_TIME 153 4261.94 0.9978 1.0023 897 78
TEST_TIME 154 4260.46 0.9961 1.0050 985 85
TEST_TIME 155 4272.22 0.9957 1.0032 979 90
TEST_TIME 156 4278.64 0.9952 1.0040 1263 91
TEST_TIME 157 4289.45 0.9951 1.0047 1149 87
TEST_TIME 158 4309.27 0.9938 1.0038 1336 92
TEST_TIME 159 4314.81 0.9962 1.0037 1143 90
TEST_TIME 160 4328.91 0.9942 1.0049 1228 93
TEST_TIME 161 4334.96 0.9973 1.0025 1072 92
TEST_TIME 162 4334.08 0.9965 1.0036 1116 91
TEST_TIME 163 4335.81 0.9971 1.0026 1109 89
TEST_TIME 164 4335.70 0.9966 1.0030 1126 89
TEST_TIME 165 4342.36 0.9955 1.0036 1004 95
TEST_TIME 166 4351.59 0.9954 1.0041 909 94
TEST_TIME 167 4354.84 0.9974 1.0028 1101 90
TEST_TIME 168 4351.40 0.9976 1.0025 1059 89
TEST_TIME 169 4349.72 0.9970 1.0028 1202 89
TEST_TIME 170 4346.58 0.9976 1.0024 1028 84
TEST_TIME 171 4342.31 0.9975 1.0029 1184 90
TEST_TIME 172 4348.28 0.9957 1.0050 1190 89
TEST_TIME 173 4358.59 0.9968 1.0032 1235 92
TEST_TIME 174 4359.65 0.9972 1.0029 1134 89
TEST_TIME 175 4362.81 0.9964 1.0031 1322 91
TEST_TIME 176 4361.53 0.9977 1.0023 1081 89
TEST_TIME 177 4362.98 0.9963 1.0029 1056 94
TEST_TIME 178 4360.80 0.9978 1.0023 1082 93
TEST_TIME 179 4364.14 0.9960 1.0032 1074 92
TEST_TIME 180 4363.50 0.9978 1.0021 1057 90
TEST_TIME 181 4361.75 0.9970 1.0031 1062 94
TEST_TIME 182 4369.53 0.9958 1.0032 983 93
TEST_TIME 183 4369.56 0.9977 1.0026 871 89
TEST_TIME 184 4366.26 0.9979 1.0020 943 84
TEST_TIME 185 4364.74 0.9970 1.0025 946 89
TEST_TIME 186 4362.23 0.9977 1.0025 1151 88
TEST_TIME 187 4364.55 0.9966 1.0027 1320 93
TEST_TIME 188 4363.12 0.9976 1.0030 1070 90
TEST_TIME 189 4367.79 0.9967 1.0042 1060 93
TEST_TIME 190 4373.92 0.9975 1.0040 1017 91
TEST_TIME 191 4370.55 0.9995 1.0010 17 17
Done for 9050 ms, from 7:03:40.23 to 7:03:49.28.

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 1745 5763 3046 <null> 3199 <null> 4607 2611 4809 2979 2841 2120 8429 3124 13503 2342 234194 200745 <null> 03:55:55 04:13:55
fetches per second 2 1531 4374 2064 2927 2271 <null> 5014 3293 13615 2175 2561 2559 10243 <null> 16274 2058 208966 140430 <null> 04:13:56 04:31:56
fetches per second 3 1417 4081 2337 3015 2509 <null> 5381 2296 2624 2879 2812 2446 14476 1685 19167 <null> 177242 139450 <null> 04:31:57 04:49:57
fetches per second 4 1387 3387 2591 <null> 2833 2258 6317 2957 3380 2895 3575 2760 15934 2133 21349 3918 320829 301926 <null> 04:49:58 05:07:58
fetches per second 5 1322 3530 3150 <null> 3085 <null> 7773 2858 7978 2171 3269 2600 24600 2361 20745 2127 270461 211953 <null> 05:07:59 05:25:59
fetches per second 6 1464 4023 2347 <null> 2722 2027 5862 <null> 6629 3403 7193 1556 24542 1210 12756 <null> 235498 170800 <null> 05:26:00 05:44:00
fetches per second 7 1344 4091 2607 2535 3376 1101 6712 3220 6683 4856 4940 1981 24393 1568 16663 1826 <null> 198270 <null> 05:44:01 06:02:01
fetches per second 8 1276 3255 2992 2810 3518 1693 7183 <null> 14541 2458 2600 1419 20649 1912 13336 2559 298955 179150 <null> 06:02:02 06:20:02
fetches per second 9 1377 3191 2749 <null> 3540 <null> 6937 2944 9655 2131 4010 2041 16639 2118 16903 2701 303380 185521 <null> 06:20:03 06:38:03
fetches per second 10 1388 3808 3367 2456 3453 <null> 9136 3134 72064 2072 2094 1698 19322 1837 29192 <null> <null> 279551 <null> 06:38:04 06:56:04
marks per second 1 354 831 263 <null> 257 <null> 380 425 317 517 432 356 468 485 478 330 1451 600 <null> 03:55:55 04:13:55
marks per second 2 306 560 231 410 313 <null> 350 450 441 420 423 443 407 <null> 437 416 1355 763 <null> 04:13:56 04:31:56
marks per second 3 278 456 251 416 258 <null> 354 354 280 393 410 339 406 223 448 <null> 1474 540 <null> 04:31:57 04:49:57
marks per second 4 277 436 244 <null> 285 493 336 429 230 381 420 388 410 328 474 715 1193 1229 <null> 04:49:58 05:07:58
marks per second 5 262 411 248 <null> 251 <null> 378 436 243 354 449 392 344 393 409 341 1160 570 <null> 05:07:59 05:25:59
marks per second 6 280 542 242 <null> 274 461 337 <null> 519 485 385 206 333 225 427 <null> 1553 945 <null> 05:26:00 05:44:00
marks per second 7 269 514 242 396 261 192 334 426 238 700 378 302 379 242 449 251 <null> 902 <null> 05:44:01 06:02:01
marks per second 8 251 407 213 385 267 373 274 <null> 425 383 302 215 311 278 327 368 1074 704 <null> 06:02:02 06:20:02
marks per second 9 271 377 223 <null> 295 <null> 323 387 319 354 317 278 347 304 373 497 1001 422 <null> 06:20:03 06:38:03
marks per second 10 267 514 231 328 233 <null> 360 417 551 329 289 260 349 288 485 <null> <null> 411 <null> 06:38:04 06:56:04
reads/fetches*100 1 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 03:55:55 04:13:55
reads/fetches*100 2 0 0 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 04:13:56 04:31:56
reads/fetches*100 3 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 04:31:57 04:49:57
reads/fetches*100 4 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:49:58 05:07:58
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:07:59 05:25:59
reads/fetches*100 6 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 05:26:00 05:44:00
reads/fetches*100 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 05:44:01 06:02:01
reads/fetches*100 8 0 0 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 06:02:02 06:20:02
reads/fetches*100 9 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 06:20:03 06:38:03
reads/fetches*100 10 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 <null> <null> 0 <null> 06:38:04 06:56:04
writes/marks*100 1 0 0 0 <null> 0 <null> 0 0 0 1 0 0 0 0 0 0 4 0 <null> 03:55:55 04:13:55
writes/marks*100 2 0 0 0 0 0 <null> 0 0 1 0 0 1 0 <null> 0 0 3 0 <null> 04:13:56 04:31:56
writes/marks*100 3 0 0 0 0 0 <null> 0 0 0 1 0 0 0 0 0 <null> 4 0 <null> 04:31:57 04:49:57
writes/marks*100 4 0 0 0 <null> 0 0 0 0 0 1 0 0 0 2 0 0 3 0 <null> 04:49:58 05:07:58
writes/marks*100 5 0 0 0 <null> 0 <null> 0 0 0 1 0 0 0 0 0 0 3 0 <null> 05:07:59 05:25:59
writes/marks*100 6 0 1 0 <null> 0 0 0 <null> 1 0 0 0 1 0 0 <null> 5 0 <null> 05:26:00 05:44:00
writes/marks*100 7 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 <null> 0 <null> 05:44:01 06:02:01
writes/marks*100 8 0 0 0 0 0 0 0 <null> 1 1 0 0 0 2 0 0 4 0 <null> 06:02:02 06:20:02
writes/marks*100 9 2 0 0 <null> 0 <null> 0 0 1 1 0 0 0 0 0 0 2 0 <null> 06:20:03 06:38:03
writes/marks*100 10 1 0 0 0 0 <null> 0 0 1 0 0 1 0 0 0 <null> <null> 0 <null> 06:38:04 06:56:04
Done for 7610 ms, from 7:03:49.97 to 7:03:57.58.

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 1377508 1339209 38299 2.78 0 26809 27 38299 2016-11-30 03:55 2016-11-30 06:56
doc_list_biud 1377885 1339208 38677 2.80 0 9818 48 38677 2016-11-30 03:55 2016-11-30 06:56
sp_add_invoice_to_stock 15553 10441 5112 32.86 248 299042 24875 5112 2016-11-30 03:55 2016-11-30 06:56
sp_cancel_adding_invoice 3086 2473 613 19.86 61 155027 6040 613 2016-11-30 03:55 2016-11-30 06:56
sp_cancel_client_order 5258 5015 243 4.62 15 607 86 243 2016-11-30 03:55 2016-11-30 06:56
sp_cancel_customer_reserve 155750 120876 34874 22.39 1 3621 170 34874 2016-11-30 03:55 2016-11-30 06:56
sp_cancel_pay_from_customer 2071 2047 24 1.15 12 1607 118 24 2016-11-30 03:55 2016-11-30 06:56
sp_cancel_pay_to_supplier 1304 1272 32 2.45 15 1261 173 32 2016-11-30 03:55 2016-11-30 06:56
sp_cancel_supplier_invoice 6103 5131 972 15.92 19 10142 2576 972 2016-11-30 03:55 2016-11-30 06:56
sp_cancel_supplier_order 1158 365 793 68.48 406 605705 80634 793 2016-11-30 03:55 2016-11-30 06:56
sp_cancel_write_off 11376 8795 2581 22.68 4 11359 280 2581 2016-11-30 03:55 2016-11-30 06:56
sp_client_order 64389 64389 0 0.00 55 4476 1169 0 2016-11-30 03:55 2016-11-30 06:56
sp_customer_reserve 486033 486033 0 0.00 1 27419 469 0 2016-11-30 03:55 2016-11-30 06:56
sp_fill_shopping_cart 97585 97585 0 0.00 1 14595 250 0 2016-11-30 03:55 2016-11-30 06:56
sp_fill_shopping_cart_clo_res 486033 486033 0 0.00 0 692 1 0 2016-11-30 03:55 2016-11-30 06:56
sp_get_clo_for_invoice 10443 10443 0 0.00 5 6903 1117 0 2016-11-30 03:55 2016-11-30 06:56
sp_kill_cost_storno 17487 14587 2900 16.58 0 10599 87 2900 2016-11-30 03:55 2016-11-30 06:56
sp_kill_qstorno_ret_qs2qd 328754 256043 72711 22.11 0 9796 128 72711 2016-11-30 03:55 2016-11-30 06:56
sp_kill_qty_storno 221549 182976 38573 17.41 0 9808 351 38573 2016-11-30 03:55 2016-11-30 06:56
sp_lock_selected_doc 63672 55937 7735 12.14 0 112 3 7735 2016-11-30 03:55 2016-11-30 06:56
sp_make_cost_storno 79758 79758 0 0.00 0 26535 245 0 2016-11-30 03:55 2016-11-30 06:56
sp_multiply_rows_for_pdistr 79757 79757 0 0.00 1 883 167 0 2016-11-30 03:55 2016-11-30 06:56
sp_multiply_rows_for_qdistr 64389 64389 0 0.00 4 3794 862 0 2016-11-30 03:55 2016-11-30 06:56
sp_pay_from_customer 21718 21718 0 0.00 41 7240 336 0 2016-11-30 03:55 2016-11-30 06:56
sp_pay_to_supplier 17717 17717 0 0.00 98 9758 730 0 2016-11-30 03:55 2016-11-30 06:56
sp_payment_common 39435 39435 0 0.00 5 4254 34 0 2016-11-30 03:55 2016-11-30 06:56
sp_qd_handle_on_cancel_clo 5258 5015 243 4.62 4 454 60 243 2016-11-30 03:55 2016-11-30 06:56
sp_qd_handle_on_invoice_upd_sts 13356 12914 442 3.30 5 9674 2002 442 2016-11-30 03:55 2016-11-30 06:56
sp_qd_handle_on_reserve_upd_sts 29884 29880 4 0.01 2 2413 152 4 2016-11-30 03:55 2016-11-30 06:56
sp_reserve_write_off 30687 29880 807 2.62 30 26931 385 807 2016-11-30 03:55 2016-11-30 06:56
sp_supplier_invoice 16717 16717 0 0.00 89 49226 12091 0 2016-11-30 03:55 2016-11-30 06:56
sp_supplier_order 16479 16479 0 0.00 96 28107 8264 0 2016-11-30 03:55 2016-11-30 06:56
srv_find_qd_qs_mism 778037 739741 38296 4.92 0 974 1 38296 2016-11-30 03:55 2016-11-30 06:56
srv_make_invnt_saldo 3398 3398 0 0.00 149 48280 1407 0 2016-11-30 03:55 2016-11-30 06:56
srv_make_money_saldo 3647 3647 0 0.00 9 5758 60 0 2016-11-30 03:55 2016-11-30 06:56
srv_recalc_idx_stat 12 12 0 0.00 2417 4567 3358 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_add_invoice_to_stock 5112 5112 0 0.00 21 612 162 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_cancel_adding_invoice 575 575 0 0.00 39 3213 1287 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_cancel_client_order 243 243 0 0.00 99 620 248 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_cancel_customer_reserve 48 48 0 0.00 71 490 162 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_cancel_pay_from_customer 24 24 0 0.00 150 330 247 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_cancel_pay_to_supplier 32 32 0 0.00 120 536 265 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_cancel_supplier_invoice 389 389 0 0.00 48 501 167 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_cancel_supplier_order 4675 4675 0 0.00 72 3749 1749 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_cancel_write_off 65 65 0 0.00 69 434 168 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-abend:sp_reserve_write_off 807 807 0 0.00 53 777 162 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_add_invoice_to_stock 10509 10509 0 0.00 285 59779 11419 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_cancel_adding_invoice 1054 1054 0 0.00 308 42104 9961 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_cancel_client_order 5015 5015 0 0.00 8 1042 288 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_cancel_customer_reserve 2083 2083 0 0.00 70 910 316 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_cancel_pay_from_customer 2047 2047 0 0.00 31 779 225 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_cancel_pay_to_supplier 1272 1272 0 0.00 21 981 223 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_cancel_supplier_invoice 813 813 0 0.00 94 883 285 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_cancel_supplier_order 365 365 0 0.00 163 443042 50135 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_cancel_write_off 2967 2967 0 0.00 5 1004 321 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_client_order 64392 64392 0 0.00 2 1308 378 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_customer_reserve 2986 2986 0 0.00 6 888 221 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_pay_from_customer 21718 21718 0 0.00 6 947 257 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_pay_to_supplier 17717 17717 0 0.00 7 947 253 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_reserve_write_off 29882 29882 0 0.00 10 1141 346 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_supplier_invoice 16722 16722 0 0.00 6 1270 381 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:sp_supplier_order 16487 16487 0 0.00 6 1258 378 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:srv_make_invnt_saldo 3398 3398 0 0.00 3 238 32 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:srv_make_money_saldo 3647 3647 0 0.00 2 339 36 0 2016-11-30 03:55 2016-11-30 06:56
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 1105 1768 1393 0 2016-11-30 03:55 2016-11-30 06:56
v_add_invoice_to_stock 31106 20882 10224 32.86 1 174 6 10224 2016-11-30 03:55 2016-11-30 06:56
v_all_customers 96452 96452 0 0.00 0 246 6 0 2016-11-30 03:55 2016-11-30 06:56
v_all_suppliers 67210 67210 0 0.00 1 237 8 0 2016-11-30 03:55 2016-11-30 06:56
v_all_wares 128778 128778 0 0.00 0 252 11 0 2016-11-30 03:55 2016-11-30 06:56
v_cancel_adding_invoice 2550 2108 442 17.33 1 584 55 442 2016-11-30 03:55 2016-11-30 06:56
v_cancel_client_order 10516 10030 486 4.62 1 152 6 486 2016-11-30 03:55 2016-11-30 06:56
v_cancel_customer_prepayment 4142 4094 48 1.15 1 105 6 48 2016-11-30 03:55 2016-11-30 06:56
v_cancel_customer_reserve 4262 4166 96 2.25 1 116 7 96 2016-11-30 03:55 2016-11-30 06:56
v_cancel_payment_to_supplier 2608 2544 64 2.45 1 165 7 64 2016-11-30 03:55 2016-11-30 06:56
v_cancel_supplier_invoice 2404 1626 778 32.36 0 90 8 778 2016-11-30 03:55 2016-11-30 06:56
v_cancel_supplier_order 2316 730 1586 68.48 1 72 7 1586 2016-11-30 03:55 2016-11-30 06:56
v_cancel_write_off 6064 5934 130 2.14 1 465 33 130 2016-11-30 03:55 2016-11-30 06:56
v_max_id_clo_ord 16479 16479 0 0.00 1 1518 20 0 2016-11-30 03:55 2016-11-30 06:56
v_max_id_clo_res 2986 2986 0 0.00 3 351 27 0 2016-11-30 03:55 2016-11-30 06:56
v_max_id_ord_sup 16717 16717 0 0.00 1 478 17 0 2016-11-30 03:55 2016-11-30 06:56
v_max_non_paid_invoice 17308 17308 0 0.00 0 4233 10 0 2016-11-30 03:55 2016-11-30 06:56
v_max_non_paid_realizn 21718 21718 0 0.00 1 168 8 0 2016-11-30 03:55 2016-11-30 06:56
v_min_id_clo_ord 16479 16479 0 0.00 2 763 13 0 2016-11-30 03:55 2016-11-30 06:56
v_min_id_clo_res 2986 2986 0 0.00 2 2170 14 0 2016-11-30 03:55 2016-11-30 06:56
v_min_id_ord_sup 16717 16717 0 0.00 1 1309 14 0 2016-11-30 03:55 2016-11-30 06:56
v_min_non_paid_invoice 17717 17717 0 0.00 1 3099 24 0 2016-11-30 03:55 2016-11-30 06:56
v_min_non_paid_realizn 21718 21718 0 0.00 0 410 8 0 2016-11-30 03:55 2016-11-30 06:56
v_our_firm 32326 32326 0 0.00 1 194 7 0 2016-11-30 03:55 2016-11-30 06:56
v_reserve_write_off 61374 59760 1614 2.62 0 186 6 1614 2016-11-30 03:55 2016-11-30 06:56
x_lock_depdocs_on_canc_invoice 10469 6791 3678 35.13 0 791 9 3678 2016-11-30 03:55 2016-11-30 06:56
x_lock_depdocs_on_canc_sup_ord 1156 365 791 68.42 0 39 4 791 2016-11-30 03:55 2016-11-30 06:56
x_make_qstorno_1000_1200 16480 16480 0 0.00 56 22684 7617 0 2016-11-30 03:55 2016-11-30 06:56
x_make_qstorno_1200_2000 16717 16717 0 0.00 59 48392 11511 0 2016-11-30 03:55 2016-11-30 06:56
x_make_qstorno_2100_3300 486033 486033 0 0.00 0 27394 467 0 2016-11-30 03:55 2016-11-30 06:56
Done for 164360 ms, from 7:06:37.62 to 7:09:21.98.

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 119 sp_kill_cost_storno 335544336 2016-11-30 03:56 2016-11-30 06:52
deadlock 6 sp_kill_qstorno_ret_qs2qd 335544336 2016-11-30 04:10 2016-11-30 06:52
deadlock 80 sp_lock_selected_doc 335544336 2016-11-30 04:05 2016-11-30 06:53
deadlock 243 sp_qd_handle_on_cancel_clo 335544336 2016-11-30 03:59 2016-11-30 06:55
deadlock 88 sp_qd_handle_on_invoice_upd_sts 335544336 2016-11-30 03:56 2016-11-30 06:48
deadlock 4 sp_qd_handle_on_reserve_upd_sts 335544336 2016-11-30 04:04 2016-11-30 04:12
concurrent_transaction 6368 sp_lock_selected_doc 335544878 2016-11-30 03:55 2016-11-30 06:55
concurrent_transaction 433 x_lock_depdocs_on_canc_invoice 335544878 2016-11-30 03:55 2016-11-30 06:55
concurrent_transaction 392 x_lock_depdocs_on_canc_sup_ord 335544878 2016-11-30 03:56 2016-11-30 06:55
Done for 5390 ms, from 7:09:25.94 to 7:09:31.33.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 309316
MON$OLDEST_ACTIVE 309317
MON$OLDEST_SNAPSHOT 309317
MON$NEXT_TRANSACTION 309317
MON$PAGE_BUFFERS 786432
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 648416
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.2.32641 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.2.32641 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.2.32641 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.2.32641 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
on disk structure version 12.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 309569
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 309318
Oldest active 309319
Oldest snapshot 309319
Next transaction 309320
Sequence number 0
Next attachment ID 5075
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
*END*


Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.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: 46.65, total records: 1565871
Average version length: 47.85, total versions: 19240, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.37
Pointer pages: 11, data page slots: 17304
Data pages: 17304, average fill: 72%
Primary pages: 17304, secondary pages: 0, swept pages: 8233
Empty pages: 1, full pages: 8660
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 58
60 - 79% = 17244
80 - 99% = 1

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 6967, nodes: 1565871
Average node length: 19.91, total dup: 0, max dup: 0
Average key length: 16.97, compression ratio: 1.59
Average prefix length: 13.02, average data length: 13.98
Clustering factor: 612798, ratio: 0.39
Fill distribution:
0 - 19% = 237
20 - 39% = 270
40 - 59% = 4204
60 - 79% = 1596
80 - 99% = 660

Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 5425, nodes: 1565871
Average node length: 11.62, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.31, average data length: 5.69
Clustering factor: 558656, ratio: 0.36
Fill distribution:
0 - 19% = 0
20 - 39% = 2145
40 - 59% = 3279
60 - 79% = 1
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 53804, depth: 3, leaf buckets: 2799, nodes: 1565871
Average node length: 7.13, total dup: 1074406, max dup: 49
Average key length: 4.19, compression ratio: 2.15
Average prefix length: 7.12, average data length: 1.88
Clustering factor: 575586, ratio: 0.37
Fill distribution:
0 - 19% = 48
20 - 39% = 412
40 - 59% = 2033
60 - 79% = 99
80 - 99% = 207

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 59.27, total records: 537095
Average version length: 37.88, total versions: 16457, max versions: 5
Average fragment length: 6.07, total fragments: 68, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.62
Pointer pages: 5, data page slots: 6976
Data pages: 6976, average fill: 74%
Primary pages: 6972, secondary pages: 4, swept pages: 3647
Empty pages: 7, full pages: 4856
Fill distribution:
0 - 19% = 12
20 - 39% = 3
40 - 59% = 72
60 - 79% = 6588
80 - 99% = 301

Index DOC_LIST_ID_DESC (1)
Root page: 223650, depth: 3, leaf buckets: 1986, nodes: 537095
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.94, compression ratio: 1.01
Average prefix length: 3.06, average data length: 5.94
Clustering factor: 149142, ratio: 0.28
Fill distribution:
0 - 19% = 0
20 - 39% = 1094
40 - 59% = 892
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 587, nodes: 537095
Average node length: 4.85, total dup: 537045, max dup: 41012
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 253948, ratio: 0.47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 529
60 - 79% = 39
80 - 99% = 18

Index PK_DOC_LIST (0)
Root page: 242873, depth: 3, leaf buckets: 1890, nodes: 537095
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.94, compression ratio: 1.01
Average prefix length: 3.06, average data length: 5.94
Clustering factor: 149142, ratio: 0.28
Fill distribution:
0 - 19% = 77
20 - 39% = 805
40 - 59% = 933
60 - 79% = 4
80 - 99% = 71

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: 66.36, total records: 400
Average version length: 14.70, total versions: 831259, max versions: 2197
Average fragment length: 19.77, total fragments: 398, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.57
Pointer pages: 3, data page slots: 4272
Data pages: 4272, average fill: 78%
Primary pages: 10, secondary pages: 4262, swept pages: 0
Empty pages: 6, full pages: 4264
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3166
80 - 99% = 1100

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: 5.50, total records: 72951
Average version length: 71.12, total versions: 67319, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 17.45
Pointer pages: 3, data page slots: 4776
Data pages: 4056, average fill: 27%
Primary pages: 4055, secondary pages: 1, swept pages: 124
Empty pages: 134, full pages: 418
Fill distribution:
0 - 19% = 2568
20 - 39% = 397
40 - 59% = 268
60 - 79% = 751
80 - 99% = 72

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 120108, depth: 3, leaf buckets: 388, nodes: 72951
Average node length: 14.33, total dup: 3738, max dup: 2
Average key length: 11.46, compression ratio: 2.36
Average prefix length: 18.49, average data length: 8.51
Clustering factor: 66362, ratio: 0.91
Fill distribution:
0 - 19% = 3
20 - 39% = 343
40 - 59% = 38
60 - 79% = 4
80 - 99% = 0

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

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: 1.34, total records: 2536
Average version length: 45.53, total versions: 2467, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 47.74
Pointer pages: 1, data page slots: 160
Data pages: 159, average fill: 20%
Primary pages: 156, secondary pages: 3, swept pages: 10
Empty pages: 18, full pages: 22
Fill distribution:
0 - 19% = 128
20 - 39% = 4
40 - 59% = 3
60 - 79% = 10
80 - 99% = 14

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 93826, depth: 2, leaf buckets: 4, nodes: 2536
Average node length: 4.24, total dup: 2464, max dup: 326
Average key length: 2.39, compression ratio: 7.96
Average prefix length: 18.64, average data length: 0.36
Clustering factor: 1233, ratio: 0.49
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 2
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: 37.32, total records: 261653
Average version length: 30.91, total versions: 51184, max versions: 26
Average fragment length: 33.39, total fragments: 44, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.71
Pointer pages: 3, data page slots: 3632
Data pages: 3624, average fill: 59%
Primary pages: 3572, secondary pages: 52, swept pages: 1237
Empty pages: 47, full pages: 616
Fill distribution:
0 - 19% = 137
20 - 39% = 371
40 - 59% = 1096
60 - 79% = 1804
80 - 99% = 216

Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 243, nodes: 261653
Average node length: 4.66, total dup: 261604, max dup: 11686
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 37744, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 19
40 - 59% = 78
60 - 79% = 114
80 - 99% = 31

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 305, nodes: 261653
Average node length: 5.64, total dup: 235168, max dup: 44
Average key length: 2.99, compression ratio: 7.35
Average prefix length: 21.11, average data length: 0.89
Clustering factor: 44925, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 138
60 - 79% = 87
80 - 99% = 50

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 311, nodes: 261653
Average node length: 5.64, total dup: 235168, max dup: 44
Average key length: 2.99, compression ratio: 7.35
Average prefix length: 21.11, average data length: 0.89
Clustering factor: 45400, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 39
40 - 59% = 128
60 - 79% = 102
80 - 99% = 41

Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 321, nodes: 261653
Average node length: 5.42, total dup: 235168, max dup: 44
Average key length: 2.77, compression ratio: 3.25
Average prefix length: 8.33, average data length: 0.67
Clustering factor: 45137, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 47
40 - 59% = 174
60 - 79% = 79
80 - 99% = 21

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.99, total records: 228552
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.14
Pointer pages: 2, data page slots: 1960
Data pages: 1960, average fill: 64%
Primary pages: 1960, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 1953
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1953
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 44842, depth: 2, leaf buckets: 183, nodes: 228552
Average node length: 4.44, total dup: 228361, max dup: 2766
Average key length: 2.00, compression ratio: 1.30
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 82732, ratio: 0.36
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 52
60 - 79% = 88
80 - 99% = 42

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.48, total records: 8184938
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: 1437.82, compression ratio: 9.68
Pointer pages: 117, data page slots: 190512
Data pages: 190512, average fill: 87%
Primary pages: 190512, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 190505
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 190505

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 9017, nodes: 8184938
Average node length: 5.96, total dup: 3467324, max dup: 13
Average key length: 2.70, compression ratio: 2.96
Average prefix length: 7.35, average data length: 0.64
Clustering factor: 6338285, ratio: 0.77
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 3529
60 - 79% = 3508
80 - 99% = 1974

Index PERF_LOG_GDSCODE (3)
Root page: 88516, depth: 3, leaf buckets: 7691, nodes: 8184938
Average node length: 4.30, total dup: 8184933, max dup: 7862874
Average key length: 1.04, compression ratio: 0.19
Average prefix length: 0.20, average data length: 0.00
Clustering factor: 313351, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 7667
60 - 79% = 0
80 - 99% = 24

Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 8919, nodes: 8184938
Average node length: 5.51, total dup: 7910264, max dup: 14141
Average key length: 2.25, compression ratio: 4.00
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 4004695, ratio: 0.49
Fill distribution:
0 - 19% = 8
20 - 39% = 1
40 - 59% = 5225
60 - 79% = 2091
80 - 99% = 1594

Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 9192, nodes: 8184938
Average node length: 5.50, total dup: 8026089, max dup: 931958
Average key length: 2.24, compression ratio: 16.83
Average prefix length: 37.42, average data length: 0.22
Clustering factor: 5849377, ratio: 0.71
Fill distribution:
0 - 19% = 36
20 - 39% = 5
40 - 59% = 6472
60 - 79% = 1427
80 - 99% = 1252

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: 53.57, total records: 291728
Average version length: 55.45, total versions: 6729, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.49
Pointer pages: 3, data page slots: 3568
Data pages: 3568, average fill: 73%
Primary pages: 3568, secondary pages: 0, swept pages: 1973
Empty pages: 6, full pages: 2593
Fill distribution:
0 - 19% = 14
20 - 39% = 17
40 - 59% = 106
60 - 79% = 3405
80 - 99% = 26

Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 380, nodes: 291728
Average node length: 5.93, total dup: 242362, max dup: 585
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 29700, ratio: 0.10
Fill distribution:
0 - 19% = 8
20 - 39% = 12
40 - 59% = 222
60 - 79% = 111
80 - 99% = 27

Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 303, nodes: 291728
Average node length: 5.52, total dup: 259650, max dup: 275
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.27, average data length: 0.73
Clustering factor: 61978, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 125
60 - 79% = 108
80 - 99% = 68

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: 9.00, total versions: 7535, max versions: 3904
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: 32
Data pages: 32, average fill: 75%
Primary pages: 7, secondary pages: 25, swept pages: 0
Empty pages: 6, full pages: 25
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 26

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: 54.26, total records: 2382
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.51
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 65%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 27
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1
60 - 79% = 27
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: 2.95, total records: 76138
Average version length: 72.17, total versions: 73037, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 46.09
Pointer pages: 5, data page slots: 5856
Data pages: 1942, average fill: 52%
Primary pages: 1938, secondary pages: 4, swept pages: 529
Empty pages: 549, full pages: 945
Fill distribution:
0 - 19% = 715
20 - 39% = 140
40 - 59% = 110
60 - 79% = 72
80 - 99% = 905

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 118465, depth: 3, leaf buckets: 172, nodes: 76138
Average node length: 6.17, total dup: 66218, max dup: 14
Average key length: 3.44, compression ratio: 10.74
Average prefix length: 35.68, average data length: 1.32
Clustering factor: 12452, ratio: 0.16
Fill distribution:
0 - 19% = 28
20 - 39% = 75
40 - 59% = 54
60 - 79% = 14
80 - 99% = 1

XQD_1000_3300 (261)
Primary pointer page: 708, Index root page: 709
Total formats: 1, used formats: 1
Average record length: 67.26, total records: 1274671
Average version length: 71.57, total versions: 86763, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.02
Pointer pages: 13, data page slots: 20632
Data pages: 20632, average fill: 69%
Primary pages: 20632, secondary pages: 0, swept pages: 7481
Empty pages: 6, full pages: 10230
Fill distribution:
0 - 19% = 59
20 - 39% = 414
40 - 59% = 2803
60 - 79% = 17001
80 - 99% = 355

Index XQD_1000_3300_DOC (1)
Root page: 186719, depth: 3, leaf buckets: 1667, nodes: 1274671
Average node length: 5.16, total dup: 1239940, max dup: 121
Average key length: 2.21, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 263804, ratio: 0.21
Fill distribution:
0 - 19% = 26
20 - 39% = 138
40 - 59% = 1394
60 - 79% = 102
80 - 99% = 7

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 117870, depth: 3, leaf buckets: 1892, nodes: 1274671
Average node length: 6.29, total dup: 1111204, max dup: 29
Average key length: 3.34, compression ratio: 11.08
Average prefix length: 35.79, average data length: 1.21
Clustering factor: 332963, ratio: 0.26
Fill distribution:
0 - 19% = 34
20 - 39% = 176
40 - 59% = 1425
60 - 79% = 164
80 - 99% = 93

XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 7.92, total records: 230550
Average version length: 71.89, total versions: 205203, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 17.17
Pointer pages: 8, data page slots: 11368
Data pages: 6336, average fill: 49%
Primary pages: 6334, secondary pages: 2, swept pages: 839
Empty pages: 955, full pages: 1812
Fill distribution:
0 - 19% = 1315
20 - 39% = 1274
40 - 59% = 1352
60 - 79% = 928
80 - 99% = 1467

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 117684, depth: 3, leaf buckets: 424, nodes: 230550
Average node length: 6.09, total dup: 204323, max dup: 75
Average key length: 3.26, compression ratio: 11.37
Average prefix length: 35.86, average data length: 1.14
Clustering factor: 54021, ratio: 0.23
Fill distribution:
0 - 19% = 3
20 - 39% = 184
40 - 59% = 220
60 - 79% = 14
80 - 99% = 3

XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 59.40, total records: 1538822
Average version length: 72.04, total versions: 272527, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.29
Pointer pages: 18, data page slots: 28864
Data pages: 28863, average fill: 62%
Primary pages: 28863, secondary pages: 0, swept pages: 7626
Empty pages: 171, full pages: 8042
Fill distribution:
0 - 19% = 502
20 - 39% = 2094
40 - 59% = 9072
60 - 79% = 14562
80 - 99% = 2633

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 108071, depth: 3, leaf buckets: 2450, nodes: 1538822
Average node length: 5.65, total dup: 1442185, max dup: 99
Average key length: 2.69, compression ratio: 13.77
Average prefix length: 36.37, average data length: 0.63
Clustering factor: 490042, ratio: 0.32
Fill distribution:
0 - 19% = 16
20 - 39% = 1026
40 - 59% = 1063
60 - 79% = 255
80 - 99% = 90

XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 1.95, total records: 94094
Average version length: 71.93, total versions: 91457, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 69.68
Pointer pages: 6, data page slots: 8368
Data pages: 4824, average fill: 27%
Primary pages: 4821, secondary pages: 3, swept pages: 1929
Empty pages: 2196, full pages: 507
Fill distribution:
0 - 19% = 2658
20 - 39% = 513
40 - 59% = 645
60 - 79% = 768
80 - 99% = 240

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 93439, depth: 3, leaf buckets: 174, nodes: 94094
Average node length: 5.78, total dup: 86892, max dup: 99
Average key length: 2.96, compression ratio: 12.49
Average prefix length: 36.11, average data length: 0.89
Clustering factor: 14287, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 102
40 - 59% = 61
60 - 79% = 10
80 - 99% = 1

XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 68.22, total records: 2037661
Average version length: 71.30, total versions: 91798, 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: 19, data page slots: 30592
Data pages: 30592, average fill: 73%
Primary pages: 30592, secondary pages: 0, swept pages: 14051
Empty pages: 16, full pages: 19787
Fill distribution:
0 - 19% = 55
20 - 39% = 106
40 - 59% = 1521
60 - 79% = 27080
80 - 99% = 1830

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4153, nodes: 2037661
Average node length: 6.96, total dup: 1630866, max dup: 27
Average key length: 4.00, compression ratio: 9.26
Average prefix length: 35.20, average data length: 1.80
Clustering factor: 585908, ratio: 0.29
Fill distribution:
0 - 19% = 5
20 - 39% = 2148
40 - 59% = 1664
60 - 79% = 206
80 - 99% = 130

XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 82.94, total records: 3494697
Average version length: 84.51, total versions: 36429, 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: 34, data page slots: 54312
Data pages: 54312, average fill: 80%
Primary pages: 54312, secondary pages: 0, swept pages: 22385
Empty pages: 6, full pages: 53118
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 28
60 - 79% = 24407
80 - 99% = 29871

Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3384, nodes: 3494697
Average node length: 5.15, total dup: 3414272, max dup: 142
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 802937, ratio: 0.23
Fill distribution:
0 - 19% = 10
20 - 39% = 37
40 - 59% = 1278
60 - 79% = 1290
80 - 99% = 769

Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 4584, nodes: 3494697
Average node length: 5.65, total dup: 3152671, max dup: 49
Average key length: 2.67, compression ratio: 3.37
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 538745, ratio: 0.15
Fill distribution:
0 - 19% = 58
20 - 39% = 91
40 - 59% = 3614
60 - 79% = 362
80 - 99% = 459

Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 3847, nodes: 3494697
Average node length: 5.79, total dup: 3058113, max dup: 29
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 849139, ratio: 0.24
Fill distribution:
0 - 19% = 2
20 - 39% = 67
40 - 59% = 1677
60 - 79% = 1214
80 - 99% = 887

XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 78.55, total records: 1483432
Average version length: 83.29, total versions: 75621, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.73
Pointer pages: 15, data page slots: 23528
Data pages: 23528, average fill: 78%
Primary pages: 23528, secondary pages: 0, swept pages: 9459
Empty pages: 13, full pages: 20736
Fill distribution:
0 - 19% = 37
20 - 39% = 54
40 - 59% = 590
60 - 79% = 11400
80 - 99% = 11447

Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1570, nodes: 1483432
Average node length: 5.13, total dup: 1449462, max dup: 213
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 305975, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 24
40 - 59% = 878
60 - 79% = 512
80 - 99% = 155

Index XQS_1000_3300_RCV_ID (2)
Root page: 135973, depth: 3, leaf buckets: 2776, nodes: 1483432
Average node length: 6.28, total dup: 1203496, max dup: 14
Average key length: 3.33, compression ratio: 2.70
Average prefix length: 7.86, average data length: 1.14
Clustering factor: 225972, ratio: 0.15
Fill distribution:
0 - 19% = 59
20 - 39% = 1310
40 - 59% = 1177
60 - 79% = 199
80 - 99% = 31

Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1777, nodes: 1483432
Average node length: 5.76, total dup: 1304574, max dup: 44
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 332183, ratio: 0.22
Fill distribution:
0 - 19% = 6
20 - 39% = 18
40 - 59% = 1031
60 - 79% = 547
80 - 99% = 175

XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 77.97, total records: 3942934
Average version length: 85.47, total versions: 278970, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.74
Pointer pages: 39, data page slots: 62408
Data pages: 62408, average fill: 79%
Primary pages: 62408, secondary pages: 0, swept pages: 11854
Empty pages: 11, full pages: 57543
Fill distribution:
0 - 19% = 15
20 - 39% = 118
40 - 59% = 1196
60 - 79% = 25368
80 - 99% = 35711

Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4250, nodes: 3942934
Average node length: 5.03, total dup: 3921310, max dup: 770
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1032552, ratio: 0.26
Fill distribution:
0 - 19% = 3
20 - 39% = 238
40 - 59% = 2529
60 - 79% = 1096
80 - 99% = 384

Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 5357, nodes: 3942934
Average node length: 5.50, total dup: 3647776, max dup: 49
Average key length: 2.52, compression ratio: 3.57
Average prefix length: 8.56, average data length: 0.44
Clustering factor: 824469, ratio: 0.21
Fill distribution:
0 - 19% = 40
20 - 39% = 1516
40 - 59% = 2833
60 - 79% = 434
80 - 99% = 534

Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 4739, nodes: 3942934
Average node length: 5.60, total dup: 3588427, max dup: 140
Average key length: 2.62, compression ratio: 3.44
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 1105880, ratio: 0.28
Fill distribution:
0 - 19% = 6
20 - 39% = 194
40 - 59% = 2983
60 - 79% = 1128
80 - 99% = 428

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: 81.73, total records: 2449416
Average version length: 84.32, total versions: 54384, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.66
Pointer pages: 25, data page slots: 40088
Data pages: 40088, average fill: 76%
Primary pages: 40088, secondary pages: 0, swept pages: 24163
Empty pages: 14, full pages: 30015
Fill distribution:
0 - 19% = 63
20 - 39% = 89
40 - 59% = 1396
60 - 79% = 25189
80 - 99% = 13351

Index XQS_2100_3300_DOC_ID (0)
Root page: 95529, depth: 3, leaf buckets: 2671, nodes: 2449416
Average node length: 5.02, total dup: 2436799, max dup: 1158
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 664607, ratio: 0.27
Fill distribution:
0 - 19% = 19
20 - 39% = 317
40 - 59% = 1364
60 - 79% = 660
80 - 99% = 311

Index XQS_2100_3300_RCV_ID (2)
Root page: 98595, depth: 3, leaf buckets: 4895, nodes: 2449416
Average node length: 6.31, total dup: 1983402, max dup: 14
Average key length: 3.34, compression ratio: 2.70
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 530155, ratio: 0.22
Fill distribution:
0 - 19% = 187
20 - 39% = 2629
40 - 59% = 1804
60 - 79% = 229
80 - 99% = 46

Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 2863, nodes: 2449416
Average node length: 5.55, total dup: 2246137, max dup: 99
Average key length: 2.58, compression ratio: 3.49
Average prefix length: 8.50, average data length: 0.50
Clustering factor: 694123, ratio: 0.28
Fill distribution:
0 - 19% = 4
20 - 39% = 269
40 - 59% = 1362
60 - 79% = 904
80 - 99% = 324

XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 67.57, total records: 460143
Average version length: 69.45, total versions: 10974, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.01
Pointer pages: 4, data page slots: 6472
Data pages: 6472, average fill: 76%
Primary pages: 6472, secondary pages: 0, swept pages: 4418
Empty pages: 2, full pages: 5676
Fill distribution:
0 - 19% = 17
20 - 39% = 50
40 - 59% = 161
60 - 79% = 5983
80 - 99% = 261

Index XQS_3300_3400_DOC_ID (0)
Root page: 543765, depth: 3, leaf buckets: 529, nodes: 460143
Average node length: 5.34, total dup: 429486, max dup: 123
Average key length: 2.51, compression ratio: 3.58
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 42406, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 66
40 - 59% = 253
60 - 79% = 147
80 - 99% = 63

Index XQS_3300_3400_SND_ID (1)
Root page: 334545, depth: 3, leaf buckets: 598, nodes: 460143
Average node length: 5.93, total dup: 391197, max dup: 29
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.05, average data length: 0.95
Clustering factor: 49467, ratio: 0.11
Fill distribution:
0 - 19% = 3
20 - 39% = 77
40 - 59% = 281
60 - 79% = 188
80 - 99% = 49

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 32520 ms, from 7:09:31.62 to 7:10:04.14.

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 1565871 19240 1.2287
DOC_LIST 537095 16457 3.0640
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 831259 207814.7500
INVNT_TURNOVER_LOG 72951 67319 92.2797
MONEY_SALDO 49 47362 96657.1428
MONEY_TURNOVER_LOG 2536 2467 97.2791
OPTYPES 9 0 0.0000
PDISTR 261653 51184 19.5617
PERF_ESTIMATED 228552 0 0.0000
PERF_LOG 8184938 0 0.0000
PSTORNED 291728 6729 2.3066
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 7535 188375.0000
SETTINGS 114 0 0.0000
TRACE_STAT 2382 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 76138 73037 95.9271
XQD_1000_3300 1274671 86763 6.8066
XQD_1200_2000 230550 205203 89.0058
XQD_2000_3300 1538822 272527 17.7101
XQD_2100_3300 94094 91457 97.1974
XQD_3300_3400 2037661 91798 4.5050
XQS_1000_1200 3494697 36429 1.0424
XQS_1000_3300 1483432 75621 5.0977
XQS_1200_2000 3942934 278970 7.0751
XQS_2100_3300 2449416 54384 2.2202
XQS_3300_3400 460143 10974 2.3849
Z_USED_VIEWS 29 0 0.0000
Done for 2480 ms, from 7:10:13.44 to 7:10:15.92.

Database validation

07:10:16.02 Validation started

07:10:16.03 Relation 140 (DOC_LIST)
07:10:16.03 process pointer page 0 of 5
07:10:16.10 process pointer page 1 of 5
07:10:16.19 process pointer page 2 of 5
07:10:16.29 process pointer page 3 of 5
07:10:16.39 process pointer page 4 of 5
07:10:16.42 Index 1 (PK_DOC_LIST)
07:10:16.67 Index 2 (DOC_LIST_ID_DESC)
07:10:16.82 Index 3 (FK_DOC_LIST_AGENTS)
07:10:16.91 Relation 140 (DOC_LIST) is ok

07:10:16.91 Relation 141 (DOC_DATA)
07:10:16.91 process pointer page 0 of 11
07:10:16.95 process pointer page 1 of 11
07:10:16.98 process pointer page 2 of 11
07:10:17.02 process pointer page 3 of 11
07:10:17.05 process pointer page 4 of 11
07:10:17.09 process pointer page 5 of 11
07:10:17.12 process pointer page 6 of 11
07:10:17.15 process pointer page 7 of 11
07:10:17.19 process pointer page 8 of 11
07:10:17.21 process pointer page 9 of 11
07:10:17.24 process pointer page 10 of 11
07:10:17.26 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:10:17.63 Index 3 (DOC_DATA_ID_DESC)
07:10:18.16 Index 4 (FK_DOC_DATA_DOC_LIST)
07:10:18.45 Relation 141 (DOC_DATA) is ok

07:10:18.45 Relation 147 (INVNT_SALDO)
07:10:18.45 process pointer page 0 of 3
07:10:20.07 process pointer page 1 of 3
07:10:20.08 process pointer page 2 of 3
07:10:20.08 Index 1 (PK_INVNT_SALDO)
07:10:20.08 Relation 147 (INVNT_SALDO) is ok

07:10:20.08 Relation 150 (PDISTR)
07:10:20.08 process pointer page 0 of 3
07:10:20.12 process pointer page 1 of 3
07:10:20.16 process pointer page 2 of 3
07:10:20.17 Index 2 (PDISTR_SND_ID)
07:10:20.20 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:10:20.22 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:10:20.25 Index 5 (PDISTR_AGENT_ID)
07:10:20.27 Relation 150 (PDISTR) is ok

07:10:20.27 Relation 151 (PSTORNED)
07:10:20.27 process pointer page 0 of 3
07:10:20.30 process pointer page 1 of 3
07:10:20.34 process pointer page 2 of 3
07:10:20.34 Index 2 (PSTORNED_SND_ID)
07:10:20.38 Index 3 (PSTORNED_RCV_ID)
07:10:20.41 Relation 151 (PSTORNED) is ok

07:10:20.41 Relation 156 (SEMAPHORES)
07:10:20.41 process pointer page 0 of 1
07:10:20.42 Index 1 (PK_SEMAPHORES)
07:10:20.42 Index 2 (SEMAPHORES_TASK_UNQ)
07:10:20.42 Relation 156 (SEMAPHORES) is ok

07:10:20.42 Relation 157 (INVNT_TURNOVER_LOG)
07:10:20.42 process pointer page 0 of 3
07:10:20.44 process pointer page 1 of 3
07:10:20.50 process pointer page 2 of 3
07:10:20.62 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:10:20.68 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:10:20.68 Relation 160 (PERF_ESTIMATED)
07:10:20.68 process pointer page 0 of 2
07:10:20.77 process pointer page 1 of 2
07:10:20.79 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:10:20.88 Relation 160 (PERF_ESTIMATED) is ok

07:10:20.88 Relation 161 (PERF_ISQL_STAT)
07:10:20.88 process pointer page 0 of 1
07:10:20.88 Index 1 (PERF_ISQL_STAT_TRN)
07:10:20.88 Relation 161 (PERF_ISQL_STAT) is ok

07:10:20.88 Relation 162 (PERF_LOG)
07:10:20.88 process pointer page 0 of 117
07:10:20.96 process pointer page 1 of 117
07:10:21.04 process pointer page 2 of 117
07:10:21.12 process pointer page 3 of 117
07:10:21.20 process pointer page 4 of 117
07:10:21.27 process pointer page 5 of 117
07:10:21.31 process pointer page 6 of 117
07:10:21.35 process pointer page 7 of 117
07:10:21.39 process pointer page 8 of 117
07:10:21.42 process pointer page 9 of 117
07:10:21.45 process pointer page 10 of 117
07:10:21.48 process pointer page 11 of 117
07:10:21.52 process pointer page 12 of 117
07:10:21.55 process pointer page 13 of 117
07:10:21.58 process pointer page 14 of 117
07:10:21.61 process pointer page 15 of 117
07:10:21.63 process pointer page 16 of 117
07:10:21.66 process pointer page 17 of 117
07:10:21.69 process pointer page 18 of 117
07:10:21.71 process pointer page 19 of 117
07:10:21.74 process pointer page 20 of 117
07:10:21.76 process pointer page 21 of 117
07:10:21.79 process pointer page 22 of 117
07:10:21.81 process pointer page 23 of 117
07:10:21.84 process pointer page 24 of 117
07:10:21.87 process pointer page 25 of 117
07:10:21.90 process pointer page 26 of 117
07:10:21.96 process pointer page 27 of 117
07:10:22.04 process pointer page 28 of 117
07:10:22.12 process pointer page 29 of 117
07:10:22.20 process pointer page 30 of 117
07:10:22.28 process pointer page 31 of 117
07:10:22.35 process pointer page 32 of 117
07:10:22.43 process pointer page 33 of 117
07:10:22.51 process pointer page 34 of 117
07:10:22.59 process pointer page 35 of 117
07:10:22.67 process pointer page 36 of 117
07:10:22.74 process pointer page 37 of 117
07:10:22.82 process pointer page 38 of 117
07:10:22.90 process pointer page 39 of 117
07:10:22.98 process pointer page 40 of 117
07:10:23.06 process pointer page 41 of 117
07:10:23.14 process pointer page 42 of 117
07:10:23.21 process pointer page 43 of 117
07:10:23.29 process pointer page 44 of 117
07:10:23.37 process pointer page 45 of 117
07:10:23.46 process pointer page 46 of 117
07:10:23.54 process pointer page 47 of 117
07:10:23.62 process pointer page 48 of 117
07:10:23.70 process pointer page 49 of 117
07:10:23.77 process pointer page 50 of 117
07:10:23.85 process pointer page 51 of 117
07:10:23.93 process pointer page 52 of 117
07:10:24.01 process pointer page 53 of 117
07:10:24.09 process pointer page 54 of 117
07:10:24.17 process pointer page 55 of 117
07:10:24.25 process pointer page 56 of 117
07:10:24.33 process pointer page 57 of 117
07:10:24.41 process pointer page 58 of 117
07:10:24.47 process pointer page 59 of 117
07:10:24.50 process pointer page 60 of 117
07:10:24.54 process pointer page 61 of 117
07:10:24.57 process pointer page 62 of 117
07:10:24.60 process pointer page 63 of 117
07:10:24.63 process pointer page 64 of 117
07:10:24.66 process pointer page 65 of 117
07:10:24.69 process pointer page 66 of 117
07:10:24.72 process pointer page 67 of 117
07:10:24.75 process pointer page 68 of 117
07:10:24.79 process pointer page 69 of 117
07:10:24.82 process pointer page 70 of 117
07:10:24.86 process pointer page 71 of 117
07:10:24.89 process pointer page 72 of 117
07:10:24.92 process pointer page 73 of 117
07:10:24.95 process pointer page 74 of 117
07:10:24.98 process pointer page 75 of 117
07:10:25.01 process pointer page 76 of 117
07:10:25.04 process pointer page 77 of 117
07:10:25.07 process pointer page 78 of 117
07:10:25.10 process pointer page 79 of 117
07:10:25.12 process pointer page 80 of 117
07:10:25.15 process pointer page 81 of 117
07:10:25.17 process pointer page 82 of 117
07:10:25.20 process pointer page 83 of 117
07:10:25.23 process pointer page 84 of 117
07:10:25.25 process pointer page 85 of 117
07:10:25.27 process pointer page 86 of 117
07:10:25.30 process pointer page 87 of 117
07:10:25.37 process pointer page 88 of 117
07:10:25.46 process pointer page 89 of 117
07:10:25.54 process pointer page 90 of 117
07:10:25.58 process pointer page 91 of 117
07:10:25.61 process pointer page 92 of 117
07:10:25.64 process pointer page 93 of 117
07:10:25.68 process pointer page 94 of 117
07:10:25.71 process pointer page 95 of 117
07:10:25.73 process pointer page 96 of 117
07:10:25.76 process pointer page 97 of 117
07:10:25.79 process pointer page 98 of 117
07:10:25.81 process pointer page 99 of 117
07:10:25.84 process pointer page 100 of 117
07:10:25.87 process pointer page 101 of 117
07:10:25.89 process pointer page 102 of 117
07:10:25.91 process pointer page 103 of 117
07:10:25.94 process pointer page 104 of 117
07:10:25.96 process pointer page 105 of 117
07:10:25.98 process pointer page 106 of 117
07:10:26.00 process pointer page 107 of 117
07:10:26.03 process pointer page 108 of 117
07:10:26.08 process pointer page 109 of 117
07:10:26.13 process pointer page 110 of 117
07:10:26.16 process pointer page 111 of 117
07:10:26.23 process pointer page 112 of 117
07:10:26.31 process pointer page 113 of 117
07:10:26.39 process pointer page 114 of 117
07:10:26.47 process pointer page 115 of 117
07:10:26.55 process pointer page 116 of 117
07:10:26.60 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:10:28.96 Index 2 (PERF_LOG_UNIT)
07:10:33.02 Index 3 (PERF_LOG_TRN_DESC)
07:10:34.26 Index 4 (PERF_LOG_GDSCODE)
07:10:35.01 Relation 162 (PERF_LOG) is ok

07:10:35.01 Relation 166 (V_STOPTEST)
07:10:35.01 Relation 166 (V_STOPTEST) is ok

07:10:35.01 Relation 183 (V_QDISTR_SOURCE)
07:10:35.01 Relation 183 (V_QDISTR_SOURCE) is ok

07:10:35.01 Relation 184 (V_QSTORNED_SOURCE)
07:10:35.01 Relation 184 (V_QSTORNED_SOURCE) is ok

07:10:35.01 Relation 259 (XQD_1000_1200)
07:10:35.01 process pointer page 0 of 5
07:10:35.03 process pointer page 1 of 5
07:10:35.03 process pointer page 2 of 5
07:10:35.07 process pointer page 3 of 5
07:10:35.08 process pointer page 4 of 5
07:10:35.08 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:10:35.09 Relation 259 (XQD_1000_1200) is ok

07:10:35.09 Relation 260 (XQD_1200_2000)
07:10:35.09 process pointer page 0 of 8
07:10:35.13 process pointer page 1 of 8
07:10:35.15 process pointer page 2 of 8
07:10:35.15 process pointer page 3 of 8
07:10:35.20 process pointer page 4 of 8
07:10:35.23 process pointer page 5 of 8
07:10:35.24 process pointer page 6 of 8
07:10:35.27 process pointer page 7 of 8
07:10:35.30 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:10:35.39 Relation 260 (XQD_1200_2000) is ok

07:10:35.39 Relation 261 (XQD_1000_3300)
07:10:35.39 process pointer page 0 of 13
07:10:35.49 process pointer page 1 of 13
07:10:35.59 process pointer page 2 of 13
07:10:35.69 process pointer page 3 of 13
07:10:35.79 process pointer page 4 of 13
07:10:35.88 process pointer page 5 of 13
07:10:36.00 process pointer page 6 of 13
07:10:36.09 process pointer page 7 of 13
07:10:36.14 process pointer page 8 of 13
07:10:36.18 process pointer page 9 of 13
07:10:36.22 process pointer page 10 of 13
07:10:36.26 process pointer page 11 of 13
07:10:36.29 process pointer page 12 of 13
07:10:36.32 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:10:36.59 Index 2 (XQD_1000_3300_DOC)
07:10:36.78 Relation 261 (XQD_1000_3300) is ok

07:10:36.78 Relation 262 (XQD_2000_3300)
07:10:36.78 process pointer page 0 of 18
07:10:36.82 process pointer page 1 of 18
07:10:36.85 process pointer page 2 of 18
07:10:36.89 process pointer page 3 of 18
07:10:36.93 process pointer page 4 of 18
07:10:36.96 process pointer page 5 of 18
07:10:37.00 process pointer page 6 of 18
07:10:37.10 process pointer page 7 of 18
07:10:37.22 process pointer page 8 of 18
07:10:37.34 process pointer page 9 of 18
07:10:37.48 process pointer page 10 of 18
07:10:37.55 process pointer page 11 of 18
07:10:37.60 process pointer page 12 of 18
07:10:37.65 process pointer page 13 of 18
07:10:37.69 process pointer page 14 of 18
07:10:37.74 process pointer page 15 of 18
07:10:37.78 process pointer page 16 of 18
07:10:37.81 process pointer page 17 of 18
07:10:37.84 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:10:38.30 Relation 262 (XQD_2000_3300) is ok

07:10:38.30 Relation 263 (XQD_2100_3300)
07:10:38.30 process pointer page 0 of 6
07:10:38.33 process pointer page 1 of 6
07:10:38.34 process pointer page 2 of 6
07:10:38.36 process pointer page 3 of 6
07:10:38.52 process pointer page 4 of 6
07:10:38.55 process pointer page 5 of 6
07:10:38.56 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:10:38.60 Relation 263 (XQD_2100_3300) is ok

07:10:38.60 Relation 264 (XQD_3300_3400)
07:10:38.60 process pointer page 0 of 19
07:10:38.69 process pointer page 1 of 19
07:10:38.79 process pointer page 2 of 19
07:10:38.89 process pointer page 3 of 19
07:10:38.98 process pointer page 4 of 19
07:10:39.08 process pointer page 5 of 19
07:10:39.16 process pointer page 6 of 19
07:10:39.20 process pointer page 7 of 19
07:10:39.29 process pointer page 8 of 19
07:10:39.38 process pointer page 9 of 19
07:10:39.47 process pointer page 10 of 19
07:10:39.51 process pointer page 11 of 19
07:10:39.54 process pointer page 12 of 19
07:10:39.58 process pointer page 13 of 19
07:10:39.62 process pointer page 14 of 19
07:10:39.65 process pointer page 15 of 19
07:10:39.68 process pointer page 16 of 19
07:10:39.72 process pointer page 17 of 19
07:10:39.76 process pointer page 18 of 19
07:10:39.79 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:10:40.19 Relation 264 (XQD_3300_3400) is ok

07:10:40.19 Relation 265 (XQS_1000_1200)
07:10:40.19 process pointer page 0 of 34
07:10:40.21 process pointer page 1 of 34
07:10:40.25 process pointer page 2 of 34
07:10:40.32 process pointer page 3 of 34
07:10:40.41 process pointer page 4 of 34
07:10:40.50 process pointer page 5 of 34
07:10:40.60 process pointer page 6 of 34
07:10:40.69 process pointer page 7 of 34
07:10:40.78 process pointer page 8 of 34
07:10:40.87 process pointer page 9 of 34
07:10:40.96 process pointer page 10 of 34
07:10:41.06 process pointer page 11 of 34
07:10:41.15 process pointer page 12 of 34
07:10:41.25 process pointer page 13 of 34
07:10:41.29 process pointer page 14 of 34
07:10:41.33 process pointer page 15 of 34
07:10:41.37 process pointer page 16 of 34
07:10:41.41 process pointer page 17 of 34
07:10:41.44 process pointer page 18 of 34
07:10:41.47 process pointer page 19 of 34
07:10:41.51 process pointer page 20 of 34
07:10:41.54 process pointer page 21 of 34
07:10:41.57 process pointer page 22 of 34
07:10:41.60 process pointer page 23 of 34
07:10:41.63 process pointer page 24 of 34
07:10:41.66 process pointer page 25 of 34
07:10:41.68 process pointer page 26 of 34
07:10:41.71 process pointer page 27 of 34
07:10:41.74 process pointer page 28 of 34
07:10:41.76 process pointer page 29 of 34
07:10:41.79 process pointer page 30 of 34
07:10:41.82 process pointer page 31 of 34
07:10:41.85 process pointer page 32 of 34
07:10:41.88 process pointer page 33 of 34
07:10:41.89 Index 1 (XQS_1000_1200_DOC_ID)
07:10:42.19 Index 2 (XQS_1000_1200_SND_ID)
07:10:42.95 Index 3 (XQS_1000_1200_RCV_ID)
07:10:43.63 Relation 265 (XQS_1000_1200) is ok

07:10:43.63 Relation 266 (XQS_1200_2000)
07:10:43.63 process pointer page 0 of 39
07:10:43.68 process pointer page 1 of 39
07:10:43.72 process pointer page 2 of 39
07:10:43.75 process pointer page 3 of 39
07:10:43.79 process pointer page 4 of 39
07:10:43.83 process pointer page 5 of 39
07:10:43.87 process pointer page 6 of 39
07:10:43.90 process pointer page 7 of 39
07:10:43.93 process pointer page 8 of 39
07:10:43.97 process pointer page 9 of 39
07:10:44.00 process pointer page 10 of 39
07:10:44.09 process pointer page 11 of 39
07:10:44.18 process pointer page 12 of 39
07:10:44.28 process pointer page 13 of 39
07:10:44.38 process pointer page 14 of 39
07:10:44.49 process pointer page 15 of 39
07:10:44.59 process pointer page 16 of 39
07:10:44.69 process pointer page 17 of 39
07:10:44.79 process pointer page 18 of 39
07:10:44.89 process pointer page 19 of 39
07:10:44.97 process pointer page 20 of 39
07:10:45.02 process pointer page 21 of 39
07:10:45.06 process pointer page 22 of 39
07:10:45.10 process pointer page 23 of 39
07:10:45.18 process pointer page 24 of 39
07:10:45.22 process pointer page 25 of 39
07:10:45.26 process pointer page 26 of 39
07:10:45.31 process pointer page 27 of 39
07:10:45.35 process pointer page 28 of 39
07:10:45.39 process pointer page 29 of 39
07:10:45.43 process pointer page 30 of 39
07:10:45.46 process pointer page 31 of 39
07:10:45.50 process pointer page 32 of 39
07:10:45.54 process pointer page 33 of 39
07:10:45.57 process pointer page 34 of 39
07:10:45.63 process pointer page 35 of 39
07:10:45.74 process pointer page 36 of 39
07:10:45.85 process pointer page 37 of 39
07:10:45.94 process pointer page 38 of 39
07:10:45.97 Index 1 (XQS_1200_2000_DOC_ID)
07:10:47.26 Index 2 (XQS_1200_2000_SND_ID)
07:10:47.78 Index 3 (XQS_1200_2000_RCV_ID)
07:10:48.29 Relation 266 (XQS_1200_2000) is ok

07:10:48.29 Relation 267 (XQS_1000_3300)
07:10:48.29 process pointer page 0 of 15
07:10:48.39 process pointer page 1 of 15
07:10:48.44 process pointer page 2 of 15
07:10:48.48 process pointer page 3 of 15
07:10:48.52 process pointer page 4 of 15
07:10:48.55 process pointer page 5 of 15
07:10:48.64 process pointer page 6 of 15
07:10:48.74 process pointer page 7 of 15
07:10:48.84 process pointer page 8 of 15
07:10:48.93 process pointer page 9 of 15
07:10:49.03 process pointer page 10 of 15
07:10:49.13 process pointer page 11 of 15
07:10:49.22 process pointer page 12 of 15
07:10:49.33 process pointer page 13 of 15
07:10:49.43 process pointer page 14 of 15
07:10:49.48 Index 1 (XQS_1000_3300_DOC_ID)
07:10:49.80 Index 2 (XQS_1000_3300_SND_ID)
07:10:50.14 Index 3 (XQS_1000_3300_RCV_ID)
07:10:50.31 Relation 267 (XQS_1000_3300) is ok

07:10:50.32 Relation 268 (XQS_2000_3300)
07:10:50.32 process pointer page 0 of 1
07:10:50.32 Index 1 (XQS_2000_3300_DOC_ID)
07:10:50.32 Index 2 (XQS_2000_3300_SND_ID)
07:10:50.32 Index 3 (XQS_2000_3300_RCV_ID)
07:10:50.32 Relation 268 (XQS_2000_3300) is ok

07:10:50.32 Relation 269 (XQS_2100_3300)
07:10:50.32 process pointer page 0 of 25
07:10:50.41 process pointer page 1 of 25
07:10:50.50 process pointer page 2 of 25
07:10:50.59 process pointer page 3 of 25
07:10:50.68 process pointer page 4 of 25
07:10:50.78 process pointer page 5 of 25
07:10:50.87 process pointer page 6 of 25
07:10:50.96 process pointer page 7 of 25
07:10:51.06 process pointer page 8 of 25
07:10:51.16 process pointer page 9 of 25
07:10:51.19 process pointer page 10 of 25
07:10:51.23 process pointer page 11 of 25
07:10:51.27 process pointer page 12 of 25
07:10:51.31 process pointer page 13 of 25
07:10:51.34 process pointer page 14 of 25
07:10:51.37 process pointer page 15 of 25
07:10:51.41 process pointer page 16 of 25
07:10:51.44 process pointer page 17 of 25
07:10:51.47 process pointer page 18 of 25
07:10:51.50 process pointer page 19 of 25
07:10:51.53 process pointer page 20 of 25
07:10:51.56 process pointer page 21 of 25
07:10:51.59 process pointer page 22 of 25
07:10:51.62 process pointer page 23 of 25
07:10:51.65 process pointer page 24 of 25
07:10:51.67 Index 1 (XQS_2100_3300_DOC_ID)
07:10:51.92 Index 2 (XQS_2100_3300_SND_ID)
07:10:52.77 Index 3 (XQS_2100_3300_RCV_ID)
07:10:53.07 Relation 269 (XQS_2100_3300) is ok

07:10:53.07 Relation 270 (XQS_3300_3400)
07:10:53.07 process pointer page 0 of 4
07:10:53.10 process pointer page 1 of 4
07:10:53.13 process pointer page 2 of 4
07:10:53.16 process pointer page 3 of 4
07:10:53.18 Index 1 (XQS_3300_3400_DOC_ID)
07:10:53.22 Index 2 (XQS_3300_3400_SND_ID)
07:10:53.26 Relation 270 (XQS_3300_3400) is ok

07:10:53.26 Relation 276 (TRACE_STAT)
07:10:53.26 process pointer page 0 of 1
07:10:53.26 Relation 276 (TRACE_STAT) is ok

07:10:53.26 Validation finished
Done for 37330 ms, from 7:10:15.94 to 7:10:53.27.

Differences between old and current firebird.log

7:10:54.31. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-11-30 07:10 504 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 +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed Nov 30 07:10:16 2016
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed Nov 30 07:10:53 2016
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


Remove 401 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.oltp30\oltp30_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-11-30 7:11:00.34 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html