Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-04-06 10:58:31.57.
 
Server version: WI-T4.0.0.119 Firebird 4.0 Unstable
 
Server implementation: Firebird/Windows/AMD/Intel/x64 
 
| FB_ARCHITECTURE | DB_NAME | FORCED_WRITES | SWEEP_INT | PAGE_BUFFERS | PAGE_SIZE | 
| SuperServer 4.0.0 | D:\OLTP-EMUL\OLTP40-SMALL.FDB | ON | 0 | 786432 | 8192 | 
 
 Test configuration settings 
 
File: E:\OLTP-EMUL\src\oltp40_config.win 
 
| PARAM_NAME | PARAM_VALUE | 
| fbc | E:\FB40.TMPINSTANCE | 
| dbnm | D:\OLTP-EMUL\oltp40-small.fdb | 
| host | localhost | 
| port | 3400 | 
| usr | SYSDBA | 
| pwd | masterkey | 
| tmpdir | e:\temp\logs.oltp40 | 
| 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 | ak40 | 
| upload_report | 1 | 
 
 
 
| FINISH_STATE | DTS_END | FB_GDSCODE | FB_MNEMONA | STACK | IP | TRN_ID | ATT_ID | EXC_UNIT | 
| NORMAL: TEST_TIME EXPIRED. | 2016-04-06 10:55:58.6440 | -1 | <null> |  | ::1/53116 | 334897 | 4948 | 2 | 
 
 
 
| 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 | 
 
 
 
| 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 
 
 
 
| ACTION | AVG_TIMES_PER_MINUTE | AVG_ELAPSED_MS | SUCCESSFUL_TIMES_DONE | JOB_BEG | JOB_END | 
| *** OVERALL *** for 181 minutes: | 4965.72 | 6944 | 898795 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| customer order: creation | 395.53 | 1069 | 71196 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| customer order: refuse | 31.27 | 73 | 5598 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| order to supplier: creation | 101.40 | 7763 | 18353 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| order to supplier: removal | 2.19 | 75246 | 387 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| invoice (draft): creation | 102.70 | 11675 | 18588 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| invoice (draft): removal | 33.93 | 2435 | 6073 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| invoice accept: apply | 63.42 | 21405 | 11352 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| invoice accept: cancel | 15.45 | 4787 | 2766 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| customer reserve: creation | 2977.37 | 394 | 535926 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| customer reserve: removal | 731.96 | 130 | 131753 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| realization accept: apply | 181.53 | 336 | 32675 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| realization accept: cancel | 51.42 | 244 | 9256 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| payment from customer: creation | 133.32 | 342 | 23997 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| payment from customer: removal | 12.63 | 93 | 2274 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| payment to supplier: creation | 108.89 | 774 | 19600 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| payment to supplier: removal | 7.72 | 151 | 1389 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| service: total inventory turnovers | 19.02 | 1625 | 3424 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| service: total monetary turnovers | 23.20 | 86 | 4176 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| service: refresh index statistics | 0.07 | 3308 | 12 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
 
Done for 53890 ms, from 10:59:41.94 to 11:00:35.83.  
 
| ACTION | ITRV_NO | CNT_OK_PER_MINUTE | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | ITRV_BEG | ITRV_END | 
| interval #   1, overall | 1 | 3930 | 75831 | 70739 | 5092 | 6.71 | 07:55:59 | 08:13:59 | 
| interval #   2, overall | 2 | 4802 | 93335 | 86432 | 6903 | 7.40 | 08:14:00 | 08:32:00 | 
| interval #   3, overall | 3 | 5515 | 102725 | 99274 | 3451 | 3.36 | 08:32:01 | 08:50:01 | 
| interval #   4, overall | 4 | 5652 | 107079 | 101744 | 5335 | 4.98 | 08:50:02 | 09:08:02 | 
| interval #   5, overall | 5 | 5263 | 99753 | 94740 | 5013 | 5.03 | 09:08:03 | 09:26:03 | 
| interval #   6, overall | 6 | 5530 | 104378 | 99543 | 4835 | 4.63 | 09:26:04 | 09:44:04 | 
| interval #   7, overall | 7 | 4808 | 95976 | 86537 | 9439 | 9.83 | 09:44:05 | 10:02:05 | 
| interval #   8, overall | 8 | 4986 | 98153 | 89742 | 8411 | 8.57 | 10:02:06 | 10:20:06 | 
| interval #   9, overall | 9 | 4794 | 92366 | 86294 | 6072 | 6.57 | 10:20:07 | 10:38:07 | 
| interval #  10, overall | 10 | 4653 | 86793 | 83750 | 3043 | 3.51 | 10:38:08 | 10:56:08 | 
 
Done for 96500 ms, from 11:02:08.37 to 11:03:44.87.  
 
| TEST_PHASE | MINUTE_SINCE_TEST_START | AVG_ESTIMATED | MIN_TO_AVG_RATIO | MAX_TO_AVG_RATIO | ROWS_AGGREGATED | DISTINCT_ATTACHMENTS | 
| WARM_TIME | 1 | 1908.26 | 0.0005 | 1.8047 | 2741 | 99 | 
| WARM_TIME | 2 | 2434.85 | 0.7072 | 1.3234 | 2786 | 90 | 
| WARM_TIME | 3 | 2451.66 | 0.8764 | 1.1275 | 1775 | 64 | 
| WARM_TIME | 4 | 2272.54 | 0.9124 | 1.0942 | 1322 | 55 | 
| WARM_TIME | 5 | 2134.17 | 0.9322 | 1.0706 | 1207 | 53 | 
| WARM_TIME | 6 | 2016.34 | 0.9444 | 1.0638 | 990 | 45 | 
| WARM_TIME | 7 | 1940.11 | 0.9477 | 1.0532 | 946 | 47 | 
| WARM_TIME | 8 | 1880.61 | 0.9507 | 1.0545 | 851 | 48 | 
| WARM_TIME | 9 | 1847.36 | 0.9543 | 1.0465 | 860 | 45 | 
| WARM_TIME | 10 | 1895.59 | 0.9180 | 1.0717 | 1323 | 69 | 
| TEST_TIME | 11 | 1973.82 | 0.9357 | 1.0629 | 1359 | 76 | 
| TEST_TIME | 12 | 2046.01 | 0.9400 | 1.0640 | 1282 | 78 | 
| TEST_TIME | 13 | 2126.17 | 0.9451 | 1.0553 | 1423 | 83 | 
| TEST_TIME | 14 | 2188.08 | 0.9522 | 1.0503 | 1430 | 84 | 
| TEST_TIME | 15 | 2265.19 | 0.9474 | 1.0458 | 1442 | 87 | 
| TEST_TIME | 16 | 2363.72 | 0.9395 | 1.0534 | 1560 | 96 | 
| TEST_TIME | 17 | 2471.80 | 0.9481 | 1.0427 | 1620 | 96 | 
| TEST_TIME | 18 | 2527.62 | 0.9630 | 1.0385 | 1447 | 96 | 
| TEST_TIME | 19 | 2568.49 | 0.9681 | 1.0388 | 1476 | 97 | 
| TEST_TIME | 20 | 2631.84 | 0.9632 | 1.0345 | 1436 | 91 | 
| TEST_TIME | 21 | 2687.89 | 0.9647 | 1.0446 | 1589 | 97 | 
| TEST_TIME | 22 | 2735.36 | 0.9798 | 1.0262 | 1368 | 94 | 
| TEST_TIME | 23 | 2788.30 | 0.9629 | 1.0336 | 1554 | 98 | 
| TEST_TIME | 24 | 2867.45 | 0.9632 | 1.0371 | 1779 | 97 | 
| TEST_TIME | 25 | 2964.48 | 0.9630 | 1.0319 | 1948 | 96 | 
| TEST_TIME | 26 | 3040.73 | 0.9674 | 1.0305 | 1779 | 97 | 
| TEST_TIME | 27 | 3112.86 | 0.9694 | 1.0291 | 1767 | 96 | 
| TEST_TIME | 28 | 3175.44 | 0.9728 | 1.0307 | 1623 | 96 | 
| TEST_TIME | 29 | 3240.87 | 0.9751 | 1.0239 | 1627 | 97 | 
| TEST_TIME | 30 | 3293.55 | 0.9739 | 1.0265 | 1519 | 99 | 
| TEST_TIME | 31 | 3333.94 | 0.9813 | 1.0197 | 1485 | 97 | 
| TEST_TIME | 32 | 3368.88 | 0.9776 | 1.0203 | 1470 | 96 | 
| TEST_TIME | 33 | 3417.11 | 0.9754 | 1.0249 | 1783 | 94 | 
| TEST_TIME | 34 | 3465.93 | 0.9808 | 1.0237 | 1646 | 94 | 
| TEST_TIME | 35 | 3510.63 | 0.9818 | 1.0145 | 1533 | 96 | 
| TEST_TIME | 36 | 3527.72 | 0.9815 | 1.0221 | 1459 | 94 | 
| TEST_TIME | 37 | 3569.57 | 0.9828 | 1.0178 | 1394 | 99 | 
| TEST_TIME | 38 | 3591.77 | 0.9849 | 1.0144 | 1448 | 98 | 
| TEST_TIME | 39 | 3612.98 | 0.9826 | 1.0162 | 1498 | 92 | 
| TEST_TIME | 40 | 3659.18 | 0.9783 | 1.0196 | 1594 | 96 | 
| TEST_TIME | 41 | 3701.09 | 0.9834 | 1.0152 | 1677 | 97 | 
| TEST_TIME | 42 | 3723.55 | 0.9851 | 1.0144 | 1652 | 95 | 
| TEST_TIME | 43 | 3752.37 | 0.9832 | 1.0160 | 1516 | 94 | 
| TEST_TIME | 44 | 3785.01 | 0.9843 | 1.0156 | 1498 | 95 | 
| TEST_TIME | 45 | 3799.66 | 0.9892 | 1.0115 | 1434 | 93 | 
| TEST_TIME | 46 | 3812.96 | 0.9860 | 1.0149 | 1420 | 96 | 
| TEST_TIME | 47 | 3839.48 | 0.9865 | 1.0126 | 1354 | 94 | 
| TEST_TIME | 48 | 3866.95 | 0.9845 | 1.0127 | 1781 | 94 | 
| TEST_TIME | 49 | 3889.78 | 0.9862 | 1.0135 | 1840 | 93 | 
| TEST_TIME | 50 | 3923.19 | 0.9848 | 1.0120 | 1538 | 95 | 
| TEST_TIME | 51 | 3943.45 | 0.9871 | 1.0137 | 1606 | 94 | 
| TEST_TIME | 52 | 3981.52 | 0.9847 | 1.0160 | 1386 | 93 | 
| TEST_TIME | 53 | 4029.86 | 0.9849 | 1.0113 | 1275 | 95 | 
| TEST_TIME | 54 | 4044.79 | 0.9889 | 1.0103 | 1363 | 90 | 
| TEST_TIME | 55 | 4068.17 | 0.9862 | 1.0125 | 1421 | 96 | 
| TEST_TIME | 56 | 4095.95 | 0.9877 | 1.0105 | 1344 | 96 | 
| TEST_TIME | 57 | 4110.60 | 0.9892 | 1.0099 | 1159 | 96 | 
| TEST_TIME | 58 | 4119.53 | 0.9904 | 1.0116 | 1311 | 98 | 
| TEST_TIME | 59 | 4143.17 | 0.9888 | 1.0103 | 1299 | 96 | 
| TEST_TIME | 60 | 4159.87 | 0.9895 | 1.0105 | 1339 | 95 | 
| TEST_TIME | 61 | 4184.13 | 0.9881 | 1.0096 | 1370 | 95 | 
| TEST_TIME | 62 | 4198.63 | 0.9898 | 1.0109 | 1321 | 98 | 
| TEST_TIME | 63 | 4221.05 | 0.9896 | 1.0101 | 1931 | 98 | 
| TEST_TIME | 64 | 4241.62 | 0.9895 | 1.0116 | 1763 | 95 | 
| TEST_TIME | 65 | 4282.16 | 0.9866 | 1.0100 | 1598 | 96 | 
| TEST_TIME | 66 | 4303.37 | 0.9898 | 1.0098 | 1657 | 91 | 
| TEST_TIME | 67 | 4326.63 | 0.9894 | 1.0099 | 1511 | 95 | 
| TEST_TIME | 68 | 4344.61 | 0.9910 | 1.0094 | 1224 | 91 | 
| TEST_TIME | 69 | 4358.66 | 0.9916 | 1.0074 | 1329 | 91 | 
| TEST_TIME | 70 | 4378.35 | 0.9886 | 1.0090 | 1328 | 94 | 
| TEST_TIME | 71 | 4392.69 | 0.9915 | 1.0088 | 1382 | 92 | 
| TEST_TIME | 72 | 4403.71 | 0.9923 | 1.0082 | 1301 | 94 | 
| TEST_TIME | 73 | 4417.25 | 0.9913 | 1.0110 | 1265 | 98 | 
| TEST_TIME | 74 | 4435.44 | 0.9932 | 1.0062 | 1039 | 94 | 
| TEST_TIME | 75 | 4439.61 | 0.9918 | 1.0083 | 1131 | 94 | 
| TEST_TIME | 76 | 4462.64 | 0.9899 | 1.0098 | 1257 | 94 | 
| TEST_TIME | 77 | 4473.45 | 0.9943 | 1.0061 | 1281 | 93 | 
| TEST_TIME | 78 | 4490.39 | 0.9894 | 1.0090 | 1868 | 97 | 
| TEST_TIME | 79 | 4504.40 | 0.9931 | 1.0073 | 1755 | 94 | 
| TEST_TIME | 80 | 4515.73 | 0.9923 | 1.0068 | 1508 | 93 | 
| TEST_TIME | 81 | 4528.41 | 0.9916 | 1.0080 | 1411 | 93 | 
| TEST_TIME | 82 | 4546.81 | 0.9917 | 1.0090 | 1303 | 93 | 
| TEST_TIME | 83 | 4579.05 | 0.9899 | 1.0108 | 1380 | 96 | 
| TEST_TIME | 84 | 4603.67 | 0.9935 | 1.0051 | 1331 | 93 | 
| TEST_TIME | 85 | 4605.41 | 0.9929 | 1.0066 | 1508 | 97 | 
| TEST_TIME | 86 | 4605.84 | 0.9948 | 1.0080 | 1301 | 94 | 
| TEST_TIME | 87 | 4616.53 | 0.9941 | 1.0058 | 1283 | 93 | 
| TEST_TIME | 88 | 4621.97 | 0.9932 | 1.0061 | 1319 | 92 | 
| TEST_TIME | 89 | 4619.83 | 0.9953 | 1.0062 | 1218 | 93 | 
| TEST_TIME | 90 | 4619.98 | 0.9950 | 1.0057 | 1241 | 93 | 
| TEST_TIME | 91 | 4621.84 | 0.9943 | 1.0068 | 1262 | 97 | 
| TEST_TIME | 92 | 4629.99 | 0.9941 | 1.0047 | 1308 | 95 | 
| TEST_TIME | 93 | 4638.67 | 0.9921 | 1.0066 | 1519 | 96 | 
| TEST_TIME | 94 | 4636.35 | 0.9964 | 1.0037 | 1151 | 81 | 
| TEST_TIME | 95 | 4631.72 | 0.9941 | 1.0053 | 1174 | 87 | 
| TEST_TIME | 96 | 4642.59 | 0.9925 | 1.0063 | 1447 | 93 | 
| TEST_TIME | 97 | 4650.52 | 0.9943 | 1.0045 | 1246 | 91 | 
| TEST_TIME | 98 | 4655.33 | 0.9933 | 1.0064 | 1510 | 91 | 
| TEST_TIME | 99 | 4671.78 | 0.9928 | 1.0073 | 1437 | 97 | 
| TEST_TIME | 100 | 4689.45 | 0.9935 | 1.0060 | 1386 | 96 | 
| TEST_TIME | 101 | 4698.00 | 0.9943 | 1.0057 | 1374 | 97 | 
| TEST_TIME | 102 | 4709.84 | 0.9934 | 1.0067 | 1355 | 96 | 
| TEST_TIME | 103 | 4720.51 | 0.9948 | 1.0055 | 1305 | 96 | 
| TEST_TIME | 104 | 4727.61 | 0.9944 | 1.0051 | 1284 | 95 | 
| TEST_TIME | 105 | 4723.25 | 0.9965 | 1.0030 | 955 | 79 | 
| TEST_TIME | 106 | 4714.57 | 0.9954 | 1.0040 | 903 | 79 | 
| TEST_TIME | 107 | 4716.13 | 0.9943 | 1.0053 | 1059 | 91 | 
| TEST_TIME | 108 | 4730.86 | 0.9929 | 1.0053 | 1358 | 94 | 
| TEST_TIME | 109 | 4741.58 | 0.9938 | 1.0066 | 1517 | 93 | 
| TEST_TIME | 110 | 4758.14 | 0.9939 | 1.0071 | 1349 | 96 | 
| TEST_TIME | 111 | 4771.03 | 0.9953 | 1.0046 | 1386 | 90 | 
| TEST_TIME | 112 | 4775.58 | 0.9949 | 1.0049 | 1395 | 95 | 
| TEST_TIME | 113 | 4778.40 | 0.9954 | 1.0039 | 1383 | 93 | 
| TEST_TIME | 114 | 4790.66 | 0.9926 | 1.0061 | 1276 | 94 | 
| TEST_TIME | 115 | 4800.06 | 0.9954 | 1.0038 | 1375 | 93 | 
| TEST_TIME | 116 | 4799.45 | 0.9953 | 1.0047 | 1284 | 94 | 
| TEST_TIME | 117 | 4811.04 | 0.9937 | 1.0051 | 1329 | 96 | 
| TEST_TIME | 118 | 4810.10 | 0.9968 | 1.0034 | 1148 | 91 | 
| TEST_TIME | 119 | 4803.22 | 0.9964 | 1.0039 | 1131 | 87 | 
| TEST_TIME | 120 | 4801.58 | 0.9958 | 1.0035 | 1140 | 88 | 
| TEST_TIME | 121 | 4795.31 | 0.9965 | 1.0025 | 988 | 80 | 
| TEST_TIME | 122 | 4789.97 | 0.9954 | 1.0034 | 1019 | 79 | 
| TEST_TIME | 123 | 4790.48 | 0.9951 | 1.0047 | 1164 | 91 | 
| TEST_TIME | 124 | 4793.09 | 0.9960 | 1.0042 | 1306 | 89 | 
| TEST_TIME | 125 | 4797.68 | 0.9952 | 1.0055 | 1261 | 91 | 
| TEST_TIME | 126 | 4814.94 | 0.9939 | 1.0039 | 1011 | 94 | 
| TEST_TIME | 127 | 4811.59 | 0.9967 | 1.0041 | 1052 | 91 | 
| TEST_TIME | 128 | 4813.61 | 0.9959 | 1.0035 | 1201 | 92 | 
| TEST_TIME | 129 | 4811.76 | 0.9961 | 1.0034 | 1136 | 91 | 
| TEST_TIME | 130 | 4813.53 | 0.9954 | 1.0032 | 1326 | 93 | 
| TEST_TIME | 131 | 4807.61 | 0.9967 | 1.0036 | 1170 | 90 | 
| TEST_TIME | 132 | 4806.19 | 0.9963 | 1.0052 | 1171 | 89 | 
| TEST_TIME | 133 | 4814.87 | 0.9958 | 1.0036 | 1148 | 91 | 
| TEST_TIME | 134 | 4812.74 | 0.9965 | 1.0043 | 1104 | 92 | 
| TEST_TIME | 135 | 4811.80 | 0.9971 | 1.0021 | 1163 | 91 | 
| TEST_TIME | 136 | 4801.45 | 0.9969 | 1.0032 | 1192 | 93 | 
| TEST_TIME | 137 | 4797.03 | 0.9968 | 1.0033 | 1215 | 92 | 
| TEST_TIME | 138 | 4797.40 | 0.9960 | 1.0046 | 1433 | 93 | 
| TEST_TIME | 139 | 4805.31 | 0.9958 | 1.0037 | 1312 | 93 | 
| TEST_TIME | 140 | 4808.57 | 0.9959 | 1.0032 | 1395 | 89 | 
| TEST_TIME | 141 | 4810.32 | 0.9958 | 1.0034 | 1320 | 90 | 
| TEST_TIME | 142 | 4818.95 | 0.9947 | 1.0038 | 1300 | 90 | 
| TEST_TIME | 143 | 4823.08 | 0.9959 | 1.0029 | 1260 | 90 | 
| TEST_TIME | 144 | 4827.44 | 0.9951 | 1.0049 | 1207 | 89 | 
| TEST_TIME | 145 | 4836.69 | 0.9961 | 1.0040 | 1235 | 91 | 
| TEST_TIME | 146 | 4841.77 | 0.9960 | 1.0035 | 1173 | 93 | 
| TEST_TIME | 147 | 4842.92 | 0.9965 | 1.0031 | 1126 | 93 | 
| TEST_TIME | 148 | 4849.28 | 0.9951 | 1.0026 | 1143 | 93 | 
| TEST_TIME | 149 | 4845.49 | 0.9967 | 1.0030 | 1164 | 95 | 
| TEST_TIME | 150 | 4843.68 | 0.9967 | 1.0030 | 1166 | 93 | 
| TEST_TIME | 151 | 4838.77 | 0.9974 | 1.0032 | 1136 | 92 | 
| TEST_TIME | 152 | 4836.53 | 0.9970 | 1.0027 | 1144 | 91 | 
| TEST_TIME | 153 | 4832.28 | 0.9970 | 1.0031 | 1251 | 90 | 
| TEST_TIME | 154 | 4831.84 | 0.9967 | 1.0031 | 1306 | 95 | 
| TEST_TIME | 155 | 4832.49 | 0.9965 | 1.0032 | 1307 | 95 | 
| TEST_TIME | 156 | 4833.82 | 0.9965 | 1.0030 | 1294 | 94 | 
| TEST_TIME | 157 | 4830.73 | 0.9973 | 1.0036 | 1227 | 91 | 
| TEST_TIME | 158 | 4833.62 | 0.9968 | 1.0028 | 1147 | 91 | 
| TEST_TIME | 159 | 4835.95 | 0.9961 | 1.0031 | 1188 | 93 | 
| TEST_TIME | 160 | 4836.92 | 0.9966 | 1.0033 | 1197 | 90 | 
| TEST_TIME | 161 | 4839.94 | 0.9964 | 1.0028 | 1060 | 92 | 
| TEST_TIME | 162 | 4835.32 | 0.9976 | 1.0033 | 1008 | 90 | 
| TEST_TIME | 163 | 4835.80 | 0.9971 | 1.0023 | 1127 | 90 | 
| TEST_TIME | 164 | 4830.33 | 0.9973 | 1.0030 | 1057 | 90 | 
| TEST_TIME | 165 | 4831.24 | 0.9968 | 1.0031 | 1020 | 89 | 
| TEST_TIME | 166 | 4828.21 | 0.9977 | 1.0025 | 994 | 86 | 
| TEST_TIME | 167 | 4821.80 | 0.9978 | 1.0022 | 969 | 86 | 
| TEST_TIME | 168 | 4815.94 | 0.9974 | 1.0024 | 1120 | 85 | 
| TEST_TIME | 169 | 4821.13 | 0.9954 | 1.0043 | 1290 | 92 | 
| TEST_TIME | 170 | 4829.30 | 0.9967 | 1.0032 | 1141 | 89 | 
| TEST_TIME | 171 | 4829.31 | 0.9973 | 1.0030 | 1141 | 91 | 
| TEST_TIME | 172 | 4828.81 | 0.9973 | 1.0027 | 1100 | 94 | 
| TEST_TIME | 173 | 4824.95 | 0.9977 | 1.0024 | 1071 | 91 | 
| TEST_TIME | 174 | 4820.64 | 0.9975 | 1.0024 | 1118 | 89 | 
| TEST_TIME | 175 | 4815.85 | 0.9977 | 1.0033 | 1075 | 91 | 
| TEST_TIME | 176 | 4819.51 | 0.9969 | 1.0025 | 1055 | 91 | 
| TEST_TIME | 177 | 4818.03 | 0.9971 | 1.0031 | 1070 | 91 | 
| TEST_TIME | 178 | 4818.32 | 0.9974 | 1.0023 | 1041 | 89 | 
| TEST_TIME | 179 | 4817.04 | 0.9970 | 1.0027 | 1123 | 89 | 
| TEST_TIME | 180 | 4815.51 | 0.9975 | 1.0027 | 1005 | 90 | 
| TEST_TIME | 181 | 4815.76 | 0.9971 | 1.0023 | 1046 | 87 | 
| TEST_TIME | 182 | 4811.99 | 0.9976 | 1.0020 | 1030 | 89 | 
| TEST_TIME | 183 | 4809.21 | 0.9971 | 1.0023 | 1224 | 94 | 
| TEST_TIME | 184 | 4809.26 | 0.9968 | 1.0024 | 763 | 81 | 
| TEST_TIME | 185 | 4802.01 | 0.9985 | 1.0017 | 1004 | 75 | 
| TEST_TIME | 186 | 4802.00 | 0.9963 | 1.0038 | 1260 | 93 | 
| TEST_TIME | 187 | 4812.16 | 0.9964 | 1.0025 | 1331 | 92 | 
| TEST_TIME | 188 | 4811.84 | 0.9972 | 1.0023 | 1229 | 89 | 
| TEST_TIME | 189 | 4809.41 | 0.9975 | 1.0025 | 1127 | 87 | 
| TEST_TIME | 190 | 4816.32 | 0.9958 | 1.0039 | 1161 | 88 | 
| TEST_TIME | 191 | 4812.64 | 0.9994 | 1.0020 | 153 | 77 | 
 
Done for 10230 ms, from 11:03:47.07 to 11:03:57.30.  
 
 
| 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 | 2104 | 4583 | 5651 | <null> | 5146 | 3742 | 6087 | 3058 | 5903 | 3713 | 3229 | 4025 | 14287 | 4128 | 22868 | 3757 | 294429 | 212385 | <null> | 07:55:59 | 08:13:59 | 
| fetches per second | 2 | 1854 | 6551 | 4531 | <null> | 4397 | <null> | 5952 | 4787 | 5976 | 3174 | 5143 | 2655 | 18227 | 3646 | 17540 | <null> | 213432 | 343217 | <null> | 08:14:00 | 08:32:00 | 
| fetches per second | 3 | 1944 | 7297 | 4718 | <null> | 4969 | <null> | 6559 | 4454 | 5150 | 3742 | 4032 | 3441 | 18723 | 3749 | 23147 | 4151 | 368346 | 247044 | <null> | 08:32:01 | 08:50:01 | 
| fetches per second | 4 | 1995 | 7867 | 4253 | <null> | 4690 | 3309 | 5773 | 2895 | 7097 | <null> | 5552 | 3706 | 21963 | 4711 | 22503 | 2375 | 309020 | 197628 | <null> | 08:50:02 | 09:08:02 | 
| fetches per second | 5 | 1864 | 6463 | 4057 | <null> | 4623 | 2881 | 5738 | <null> | 5416 | 5001 | 5194 | 3253 | 27591 | 2956 | 21103 | <null> | 340138 | 225048 | <null> | 09:08:03 | 09:26:03 | 
| fetches per second | 6 | 1746 | 5833 | 5194 | <null> | 5671 | 3236 | 6179 | 4010 | <null> | 3588 | 2865 | 4054 | 36949 | 3311 | 26024 | 3438 | 380027 | 282887 | <null> | 09:26:04 | 09:44:04 | 
| fetches per second | 7 | 1668 | 5442 | 4994 | <null> | 6332 | <null> | 5987 | 3522 | 3564 | 3323 | 6131 | <null> | 32372 | 5025 | 24655 | <null> | 400596 | 351321 | <null> | 09:44:05 | 10:02:05 | 
| fetches per second | 8 | 1753 | 3946 | 5566 | 3582 | 5462 | 2749 | 7808 | 4327 | 2251 | 3810 | 3824 | 2782 | 22259 | 3894 | 28679 | 2771 | <null> | 220784 | <null> | 10:02:06 | 10:20:06 | 
| fetches per second | 9 | 1636 | 6872 | 6854 | 2976 | 7855 | 2727 | 6147 | 4049 | 5279 | 2531 | 3513 | 2703 | 22730 | <null> | 37038 | 2892 | 420520 | 284733 | <null> | 10:20:07 | 10:38:07 | 
| fetches per second | 10 | 1759 | 7574 | 6362 | <null> | 7720 | 2623 | 7132 | 3562 | 9205 | 3545 | 5162 | 3024 | 20222 | 3426 | 21639 | 2802 | 437916 | 335842 | <null> | 10:38:08 | 10:56:08 | 
| marks per second | 1 | 366 | 451 | 283 | <null> | 288 | 583 | 415 | 449 | 396 | 467 | 438 | 452 | 542 | 448 | 509 | 417 | 1246 | 525 | <null> | 07:55:59 | 08:13:59 | 
| marks per second | 2 | 323 | 635 | 272 | <null> | 269 | <null> | 385 | 523 | 352 | 409 | 896 | 361 | 541 | 437 | 476 | <null> | 1630 | 630 | <null> | 08:14:00 | 08:32:00 | 
| marks per second | 3 | 325 | 683 | 282 | <null> | 296 | <null> | 398 | 524 | 364 | 420 | 460 | 379 | 661 | 409 | 500 | 460 | 1221 | 532 | <null> | 08:32:01 | 08:50:01 | 
| marks per second | 4 | 343 | 749 | 283 | <null> | 306 | 555 | 477 | 288 | 418 | <null> | 511 | 410 | 551 | 685 | 626 | 350 | 1515 | 559 | <null> | 08:50:02 | 09:08:02 | 
| marks per second | 5 | 322 | 632 | 265 | <null> | 369 | 498 | 423 | <null> | 485 | 532 | 458 | 387 | 435 | 339 | 675 | <null> | 1113 | 631 | <null> | 09:08:03 | 09:26:03 | 
| marks per second | 6 | 299 | 575 | 267 | <null> | 288 | 524 | 395 | 451 | <null> | 444 | 368 | 446 | 429 | 404 | 487 | 408 | 949 | 857 | <null> | 09:26:04 | 09:44:04 | 
| marks per second | 7 | 288 | 552 | 223 | <null> | 301 | <null> | 352 | 422 | 309 | 521 | 370 | <null> | 394 | 583 | 473 | <null> | 1046 | 596 | <null> | 09:44:05 | 10:02:05 | 
| marks per second | 8 | 295 | 368 | 247 | 542 | 256 | 476 | 335 | 484 | 227 | 355 | 395 | 329 | 399 | 411 | 445 | 377 | <null> | 406 | <null> | 10:02:06 | 10:20:06 | 
| marks per second | 9 | 281 | 644 | 223 | 442 | 240 | 489 | 361 | 458 | 298 | 258 | 348 | 297 | 385 | <null> | 402 | 294 | 876 | 250 | <null> | 10:20:07 | 10:38:07 | 
| marks per second | 10 | 295 | 709 | 236 | <null> | 269 | 426 | 349 | 442 | 428 | 353 | 357 | 378 | 391 | 410 | 531 | 273 | 889 | 330 | <null> | 10:38:08 | 10:56:08 | 
| reads/fetches*100 | 1 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 07:55:59 | 08:13:59 | 
| reads/fetches*100 | 2 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | <null> | 08:14:00 | 08:32:00 | 
| reads/fetches*100 | 3 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 08:32:01 | 08:50:01 | 
| reads/fetches*100 | 4 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 08:50:02 | 09:08:02 | 
| reads/fetches*100 | 5 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | <null> | 09:08:03 | 09:26:03 | 
| reads/fetches*100 | 6 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 09:26:04 | 09:44:04 | 
| reads/fetches*100 | 7 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 0 | <null> | 09:44:05 | 10:02:05 | 
| reads/fetches*100 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 10:02:06 | 10:20:06 | 
| reads/fetches*100 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | <null> | 10:20:07 | 10:38:07 | 
| reads/fetches*100 | 10 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 10:38:08 | 10:56:08 | 
| writes/marks*100 | 1 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | <null> | 07:55:59 | 08:13:59 | 
| writes/marks*100 | 2 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | <null> | 6 | 0 | <null> | 08:14:00 | 08:32:00 | 
| writes/marks*100 | 3 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | <null> | 08:32:01 | 08:50:01 | 
| writes/marks*100 | 4 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | <null> | 08:50:02 | 09:08:02 | 
| writes/marks*100 | 5 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 0 | 1 | 0 | 0 | 0 | 0 | 0 | <null> | 4 | 0 | <null> | 09:08:03 | 09:26:03 | 
| writes/marks*100 | 6 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | <null> | 09:26:04 | 09:44:04 | 
| writes/marks*100 | 7 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 1 | 0 | 0 | <null> | 0 | 0 | 0 | <null> | 5 | 0 | <null> | 09:44:05 | 10:02:05 | 
| writes/marks*100 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 10:02:06 | 10:20:06 | 
| writes/marks*100 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 5 | 1 | <null> | 10:20:07 | 10:38:07 | 
| writes/marks*100 | 10 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | <null> | 10:38:08 | 10:56:08 | 
 
Done for 8400 ms, from 11:03:57.75 to 11:04:06.15.  
 
 
| 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 | 1526314 | 1477336 | 48978 | 3.20 | 0 | 13416 | 26 | 48978 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| doc_list_biud | 1526704 | 1477331 | 49373 | 3.23 | 0 | 8704 | 36 | 49373 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_add_invoice_to_stock | 16900 | 11352 | 5548 | 32.82 | 312 | 165816 | 21405 | 5548 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_cancel_adding_invoice | 3384 | 2766 | 618 | 18.26 | 15 | 131755 | 4787 | 618 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_cancel_client_order | 5865 | 5598 | 267 | 4.55 | 15 | 297 | 73 | 267 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_cancel_customer_reserve | 175972 | 131753 | 44219 | 25.12 | 0 | 2808 | 130 | 44219 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_cancel_pay_from_customer | 2312 | 2274 | 38 | 1.64 | 15 | 1388 | 93 | 38 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_cancel_pay_to_supplier | 1426 | 1389 | 37 | 2.59 | 15 | 827 | 151 | 37 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_cancel_supplier_invoice | 7339 | 6073 | 1266 | 17.25 | 0 | 8939 | 2435 | 1266 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_cancel_supplier_order | 1328 | 387 | 941 | 70.85 | 640 | 464013 | 75246 | 941 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_cancel_write_off | 12906 | 9256 | 3650 | 28.28 | 0 | 8080 | 244 | 3650 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_client_order | 71196 | 71196 | 0 | 0.00 | 46 | 3978 | 1069 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_customer_reserve | 535926 | 535926 | 0 | 0.00 | 0 | 22323 | 394 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_fill_shopping_cart | 108137 | 108137 | 0 | 0.00 | 0 | 27596 | 263 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_fill_shopping_cart_clo_res | 535926 | 535926 | 0 | 0.00 | 0 | 281 | 1 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_get_clo_for_invoice | 11355 | 11355 | 0 | 0.00 | 0 | 10280 | 1066 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_kill_cost_storno | 19727 | 15687 | 4040 | 20.47 | 0 | 7425 | 77 | 4040 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_kill_qstorno_ret_qs2qd | 371877 | 279223 | 92654 | 24.91 | 0 | 8689 | 110 | 92654 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_kill_qty_storno | 249109 | 199862 | 49247 | 19.76 | 0 | 8689 | 266 | 49247 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_lock_selected_doc | 70013 | 61371 | 8642 | 12.34 | 0 | 78 | 2 | 8642 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_make_cost_storno | 87628 | 87628 | 0 | 0.00 | 0 | 13104 | 241 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_multiply_rows_for_pdistr | 87628 | 87628 | 0 | 0.00 | 0 | 499 | 154 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_multiply_rows_for_qdistr | 71198 | 71198 | 0 | 0.00 | 0 | 3432 | 798 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_pay_from_customer | 23997 | 23997 | 0 | 0.00 | 62 | 5616 | 342 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_pay_to_supplier | 19600 | 19600 | 0 | 0.00 | 93 | 14976 | 774 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_payment_common | 43597 | 43597 | 0 | 0.00 | 0 | 9501 | 31 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_qd_handle_on_cancel_clo | 5865 | 5598 | 267 | 4.55 | 0 | 281 | 50 | 267 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_qd_handle_on_invoice_upd_sts | 14582 | 14120 | 462 | 3.16 | 0 | 7831 | 1212 | 462 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_qd_handle_on_reserve_upd_sts | 32678 | 32675 | 3 | 0.00 | 0 | 1903 | 131 | 3 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_reserve_write_off | 33685 | 32675 | 1010 | 2.99 | 78 | 10749 | 336 | 1010 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_supplier_invoice | 18588 | 18588 | 0 | 0.00 | 93 | 47284 | 11675 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| sp_supplier_order | 18353 | 18353 | 0 | 0.00 | 93 | 26536 | 7763 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| srv_find_qd_qs_mism | 863894 | 814993 | 48901 | 5.66 | 0 | 811 | 1 | 48901 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| srv_make_invnt_saldo | 3424 | 3424 | 0 | 0.00 | 156 | 70871 | 1625 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| srv_make_money_saldo | 4176 | 4176 | 0 | 0.00 | 0 | 4820 | 86 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 2122 | 4524 | 3308 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_add_invoice_to_stock | 5549 | 5549 | 0 | 0.00 | 62 | 390 | 146 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_cancel_adding_invoice | 490 | 490 | 0 | 0.00 | 63 | 2698 | 1228 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_cancel_client_order | 267 | 267 | 0 | 0.00 | 93 | 515 | 237 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_cancel_customer_reserve | 77 | 77 | 0 | 0.00 | 78 | 296 | 150 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_cancel_pay_from_customer | 38 | 38 | 0 | 0.00 | 140 | 343 | 222 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_cancel_pay_to_supplier | 37 | 37 | 0 | 0.00 | 125 | 343 | 245 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_cancel_supplier_invoice | 461 | 461 | 0 | 0.00 | 62 | 374 | 148 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_cancel_supplier_order | 6048 | 6048 | 0 | 0.00 | 31 | 3026 | 1669 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_cancel_write_off | 63 | 63 | 0 | 0.00 | 78 | 249 | 142 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-abend:sp_reserve_write_off | 1010 | 1010 | 0 | 0.00 | 62 | 343 | 147 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_add_invoice_to_stock | 11402 | 11402 | 0 | 0.00 | 343 | 44601 | 10997 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_cancel_adding_invoice | 1163 | 1163 | 0 | 0.00 | 343 | 31808 | 9167 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_cancel_client_order | 5598 | 5598 | 0 | 0.00 | 31 | 546 | 262 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_cancel_customer_reserve | 2278 | 2278 | 0 | 0.00 | 140 | 562 | 292 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_cancel_pay_from_customer | 2274 | 2274 | 0 | 0.00 | 62 | 499 | 204 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_cancel_pay_to_supplier | 1389 | 1389 | 0 | 0.00 | 93 | 422 | 201 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_cancel_supplier_invoice | 929 | 929 | 0 | 0.00 | 124 | 530 | 266 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_cancel_supplier_order | 387 | 387 | 0 | 0.00 | 312 | 402541 | 49284 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_cancel_write_off | 3328 | 3328 | 0 | 0.00 | 125 | 624 | 294 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_client_order | 71201 | 71201 | 0 | 0.00 | 109 | 780 | 351 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_customer_reserve | 3232 | 3232 | 0 | 0.00 | 62 | 671 | 200 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_pay_from_customer | 23998 | 23998 | 0 | 0.00 | 93 | 546 | 234 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_pay_to_supplier | 19601 | 19601 | 0 | 0.00 | 78 | 561 | 235 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_reserve_write_off | 32676 | 32676 | 0 | 0.00 | 109 | 702 | 322 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_supplier_invoice | 18605 | 18605 | 0 | 0.00 | 15 | 733 | 353 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:sp_supplier_order | 18358 | 18358 | 0 | 0.00 | 46 | 749 | 354 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:srv_make_invnt_saldo | 3425 | 3425 | 0 | 0.00 | 0 | 156 | 29 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:srv_make_money_saldo | 4176 | 4176 | 0 | 0.00 | 0 | 172 | 31 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| t$perf-norm:srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 1030 | 1653 | 1257 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_add_invoice_to_stock | 33800 | 22704 | 11096 | 32.82 | 0 | 110 | 5 | 11096 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_all_customers | 106388 | 106388 | 0 | 0.00 | 0 | 140 | 5 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_all_suppliers | 74074 | 74074 | 0 | 0.00 | 0 | 140 | 6 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_all_wares | 142392 | 142392 | 0 | 0.00 | 0 | 141 | 9 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_cancel_adding_invoice | 2720 | 2322 | 398 | 14.63 | 0 | 515 | 64 | 398 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_cancel_client_order | 11730 | 11196 | 534 | 4.55 | 0 | 140 | 4 | 534 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_cancel_customer_prepayment | 4624 | 4548 | 76 | 1.64 | 0 | 109 | 5 | 76 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_cancel_customer_reserve | 4710 | 4556 | 154 | 3.26 | 0 | 94 | 6 | 154 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_cancel_payment_to_supplier | 2852 | 2778 | 74 | 2.59 | 0 | 156 | 6 | 74 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_cancel_supplier_invoice | 2780 | 1858 | 922 | 33.16 | 0 | 78 | 7 | 922 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_cancel_supplier_order | 2656 | 774 | 1882 | 70.85 | 0 | 78 | 6 | 1882 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_cancel_write_off | 6782 | 6656 | 126 | 1.85 | 0 | 718 | 35 | 126 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_max_id_clo_ord | 18353 | 18353 | 0 | 0.00 | 0 | 1575 | 20 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_max_id_clo_res | 3231 | 3231 | 0 | 0.00 | 0 | 234 | 23 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_max_id_ord_sup | 18588 | 18588 | 0 | 0.00 | 0 | 3931 | 19 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_max_non_paid_invoice | 19504 | 19504 | 0 | 0.00 | 0 | 109 | 6 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_max_non_paid_realizn | 23997 | 23997 | 0 | 0.00 | 0 | 125 | 6 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_min_id_clo_ord | 18353 | 18353 | 0 | 0.00 | 0 | 1435 | 16 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_min_id_clo_res | 3231 | 3231 | 0 | 0.00 | 0 | 671 | 9 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_min_id_ord_sup | 18588 | 18588 | 0 | 0.00 | 0 | 1747 | 15 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_min_non_paid_invoice | 19600 | 19600 | 0 | 0.00 | 0 | 9438 | 22 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_min_non_paid_realizn | 23997 | 23997 | 0 | 0.00 | 0 | 531 | 5 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_our_firm | 36004 | 36004 | 0 | 0.00 | 0 | 93 | 5 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| v_reserve_write_off | 67370 | 65350 | 2020 | 2.99 | 0 | 125 | 5 | 2020 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| x_lock_depdocs_on_canc_invoice | 12593 | 7910 | 4683 | 37.18 | 0 | 562 | 10 | 4683 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| x_lock_depdocs_on_canc_sup_ord | 1324 | 387 | 937 | 70.77 | 0 | 62 | 5 | 937 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| x_make_qstorno_1000_1200 | 18353 | 18353 | 0 | 0.00 | 62 | 21357 | 7063 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| x_make_qstorno_1200_2000 | 18590 | 18590 | 0 | 0.00 | 62 | 43009 | 11047 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| x_make_qstorno_2100_3300 | 535926 | 535926 | 0 | 0.00 | 0 | 22323 | 391 | 0 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
 
Done for 176800 ms, from 11:06:47.39 to 11:09:44.19.  
 
 
 
| FB_MNEMONA | CNT | UNIT | FB_GDSCODE | DTS_BEG | DTS_END | 
| deadlock | 159 | sp_kill_cost_storno | 335544336 | 2016-04-06 07:56 | 2016-04-06 10:55 | 
| deadlock | 4 | sp_kill_qstorno_ret_qs2qd | 335544336 | 2016-04-06 08:06 | 2016-04-06 10:54 | 
| deadlock | 99 | sp_lock_selected_doc | 335544336 | 2016-04-06 08:01 | 2016-04-06 10:55 | 
| deadlock | 267 | sp_qd_handle_on_cancel_clo | 335544336 | 2016-04-06 07:56 | 2016-04-06 10:55 | 
| deadlock | 87 | sp_qd_handle_on_invoice_upd_sts | 335544336 | 2016-04-06 07:56 | 2016-04-06 10:51 | 
| deadlock | 3 | sp_qd_handle_on_reserve_upd_sts | 335544336 | 2016-04-06 07:59 | 2016-04-06 08:28 | 
| concurrent_transaction | 7086 | sp_lock_selected_doc | 335544878 | 2016-04-06 07:55 | 2016-04-06 10:56 | 
| concurrent_transaction | 478 | x_lock_depdocs_on_canc_invoice | 335544878 | 2016-04-06 07:56 | 2016-04-06 10:54 | 
| concurrent_transaction | 455 | x_lock_depdocs_on_canc_sup_ord | 335544878 | 2016-04-06 07:56 | 2016-04-06 10:55 | 
 
Done for 6030 ms, from 11:09:48.79 to 11:09:54.82.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP40-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          335473
 
MON$OLDEST_ACTIVE               335474
 
MON$OLDEST_SNAPSHOT             335474
 
MON$NEXT_TRANSACTION            335474
 
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                       730368
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-T4.0.0.119 Firebird 4.0 Unstable
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.119 Firebird 4.0 Unstable"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.119 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.119 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		335829 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	335475 
 
Oldest active		335476 
 
Oldest snapshot		335476 
 
Next transaction	335477 
 
Sequence number		0 
 
Next attachment ID	5156 
 
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\OLTP40-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: 45.90, total records: 1722123 
 
Average version length: 47.90, total versions: 49712, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.39 
 
Pointer pages: 12, data page slots: 18808 
 
Data pages: 18808, average fill: 73% 
 
Primary pages: 18808, secondary pages: 0, swept pages: 2914 
 
Empty pages: 4, full pages: 15910 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 1 
 
40 - 59% = 37 
 
60 - 79% = 18763 
 
80 - 99% = 3 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 19783, depth: 3, leaf buckets: 7706, nodes: 1722123 
 
Average node length: 20.03, total dup: 0, max dup: 0 
 
Average key length: 17.08, compression ratio: 1.58 
 
Average prefix length: 12.91, average data length: 14.09 
 
Clustering factor: 689746, ratio: 0.40 
 
Fill distribution: 
 
0 - 19% = 257 
 
20 - 39% = 312 
 
40 - 59% = 4619 
 
60 - 79% = 1830 
 
80 - 99% = 688 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 46992, depth: 3, leaf buckets: 5666, nodes: 1722123 
 
Average node length: 11.62, total dup: 0, max dup: 0 
 
Average key length: 8.68, compression ratio: 1.04 
 
Average prefix length: 3.32, average data length: 5.68 
 
Clustering factor: 631502, ratio: 0.37 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1323 
 
40 - 59% = 4342 
 
60 - 79% = 0 
 
80 - 99% = 1 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 163819, depth: 3, leaf buckets: 3070, nodes: 1722123 
 
Average node length: 7.19, total dup: 1165474, max dup: 49 
 
Average key length: 4.25, compression ratio: 2.12 
 
Average prefix length: 7.07, average data length: 1.93 
 
Clustering factor: 648768, ratio: 0.38 
 
Fill distribution: 
 
0 - 19% = 55 
 
20 - 39% = 354 
 
40 - 59% = 2337 
 
60 - 79% = 115 
 
80 - 99% = 209 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 58.43, total records: 603987 
 
Average version length: 60.81, total versions: 26087, max versions: 5 
 
Average fragment length: 8.49, total fragments: 43, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.64 
 
Pointer pages: 5, data page slots: 7624 
 
Data pages: 7624, average fill: 77% 
 
Primary pages: 7619, secondary pages: 5, swept pages: 825 
 
Empty pages: 3, full pages: 7348 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 5 
 
40 - 59% = 7 
 
60 - 79% = 6738 
 
80 - 99% = 865 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 232318, depth: 3, leaf buckets: 2114, nodes: 603987 
 
Average node length: 11.78, total dup: 0, max dup: 0 
 
Average key length: 8.92, compression ratio: 1.01 
 
Average prefix length: 3.08, average data length: 5.92 
 
Clustering factor: 171569, ratio: 0.28 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 855 
 
40 - 59% = 1259 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2964, depth: 2, leaf buckets: 721, nodes: 603987 
 
Average node length: 4.87, total dup: 603937, max dup: 46021 
 
Average key length: 2.01, compression ratio: 4.47 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 281388, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 673 
 
60 - 79% = 24 
 
80 - 99% = 24 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 250168, depth: 3, leaf buckets: 2107, nodes: 603987 
 
Average node length: 11.78, total dup: 0, max dup: 0 
 
Average key length: 8.92, compression ratio: 1.01 
 
Average prefix length: 3.08, average data length: 5.92 
 
Clustering factor: 171569, ratio: 0.28 
 
Fill distribution: 
 
0 - 19% = 79 
 
20 - 39% = 825 
 
40 - 59% = 1130 
 
60 - 79% = 1 
 
80 - 99% = 72 
 
 
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: 65.88, total records: 400 
 
Average version length: 14.83, total versions: 889287, max versions: 2341 
 
Average fragment length: 19.34, total fragments: 400, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.58 
 
Pointer pages: 3, data page slots: 4584 
 
Data pages: 4584, average fill: 78% 
 
Primary pages: 6, secondary pages: 4578, swept pages: 0 
 
Empty pages: 2, full pages: 4580 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 3363 
 
80 - 99% = 1219 
 
 
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: 1.96, total records: 207863 
 
Average version length: 71.15, total versions: 202153, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 49.00 
 
Pointer pages: 5, data page slots: 6984 
 
Data pages: 4364, average fill: 62% 
 
Primary pages: 4364, secondary pages: 0, swept pages: 154 
 
Empty pages: 345, full pages: 2728 
 
Fill distribution: 
 
0 - 19% = 1167 
 
20 - 39% = 162 
 
40 - 59% = 93 
 
60 - 79% = 637 
 
80 - 99% = 2305 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 114191, depth: 3, leaf buckets: 615, nodes: 207863 
 
Average node length: 13.89, total dup: 13101, max dup: 3 
 
Average key length: 11.19, compression ratio: 2.41 
 
Average prefix length: 18.75, average data length: 8.25 
 
Clustering factor: 179528, ratio: 0.86 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 158 
 
40 - 59% = 99 
 
60 - 79% = 190 
 
80 - 99% = 143 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 261, Index root page: 262 
 
Total formats: 1, used formats: 1 
 
Average record length: 14.98, total records: 49 
 
Average version length: 9.00, total versions: 51589, max versions: 3970 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.14 
 
Pointer pages: 1, data page slots: 184 
 
Data pages: 184, average fill: 89% 
 
Primary pages: 7, secondary pages: 177, swept pages: 0 
 
Empty pages: 6, full pages: 177 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 177 
 
 
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: 0.51, total records: 9152 
 
Average version length: 45.37, total versions: 9056, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 126.70 
 
Pointer pages: 1, data page slots: 224 
 
Data pages: 163, average fill: 56% 
 
Primary pages: 163, secondary pages: 0, swept pages: 7 
 
Empty pages: 23, full pages: 96 
 
Fill distribution: 
 
0 - 19% = 58 
 
20 - 39% = 5 
 
40 - 59% = 3 
 
60 - 79% = 9 
 
80 - 99% = 88 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 91242, depth: 2, leaf buckets: 14, nodes: 9152 
 
Average node length: 4.11, total dup: 9066, max dup: 1465 
 
Average key length: 2.13, compression ratio: 8.91 
 
Average prefix length: 18.88, average data length: 0.12 
 
Clustering factor: 3639, ratio: 0.40 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 10 
 
40 - 59% = 1 
 
60 - 79% = 2 
 
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: 22.75, total records: 635441 
 
Average version length: 42.87, total versions: 43315, max versions: 15 
 
Average fragment length: 33.33, total fragments: 3, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 2.81 
 
Pointer pages: 3, data page slots: 4632 
 
Data pages: 4632, average fill: 74% 
 
Primary pages: 4615, secondary pages: 17, swept pages: 811 
 
Empty pages: 8, full pages: 4011 
 
Fill distribution: 
 
0 - 19% = 20 
 
20 - 39% = 116 
 
40 - 59% = 283 
 
60 - 79% = 3235 
 
80 - 99% = 978 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 3600, depth: 2, leaf buckets: 321, nodes: 303894 
 
Average node length: 4.77, total dup: 303845, max dup: 17558 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 43028, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 14 
 
40 - 59% = 233 
 
60 - 79% = 56 
 
80 - 99% = 18 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4281, depth: 2, leaf buckets: 352, nodes: 303894 
 
Average node length: 5.77, total dup: 272507, max dup: 40 
 
Average key length: 3.01, compression ratio: 7.30 
 
Average prefix length: 21.09, average data length: 0.91 
 
Clustering factor: 50209, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 42 
 
40 - 59% = 130 
 
60 - 79% = 112 
 
80 - 99% = 67 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 3974, depth: 2, leaf buckets: 351, nodes: 303894 
 
Average node length: 5.77, total dup: 272507, max dup: 40 
 
Average key length: 3.01, compression ratio: 7.30 
 
Average prefix length: 21.09, average data length: 0.91 
 
Clustering factor: 50670, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 41 
 
40 - 59% = 124 
 
60 - 79% = 124 
 
80 - 99% = 61 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4313, depth: 2, leaf buckets: 373, nodes: 303894 
 
Average node length: 5.54, total dup: 272507, max dup: 40 
 
Average key length: 2.78, compression ratio: 3.23 
 
Average prefix length: 8.32, average data length: 0.68 
 
Clustering factor: 50855, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 53 
 
40 - 59% = 180 
 
60 - 79% = 102 
 
80 - 99% = 36 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.98, total records: 252183 
 
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: 2160 
 
Data pages: 2160, average fill: 64% 
 
Primary pages: 2160, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 2155 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 2155 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 221906, depth: 2, leaf buckets: 201, nodes: 252183 
 
Average node length: 4.49, total dup: 251992, max dup: 2785 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.58, average data length: 0.00 
 
Clustering factor: 57252, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 63 
 
60 - 79% = 89 
 
80 - 99% = 49 
 
 
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: 147.57, total records: 9010922 
 
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: 1439.49, compression ratio: 9.75 
 
Pointer pages: 129, data page slots: 209360 
 
Data pages: 209360, average fill: 87% 
 
Primary pages: 209360, secondary pages: 0, swept pages: 3 
 
Empty pages: 2, full pages: 209357 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 209357 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 59394, depth: 3, leaf buckets: 9117, nodes: 9010922 
 
Average node length: 5.57, total dup: 7905705, max dup: 64 
 
Average key length: 2.24, compression ratio: 3.56 
 
Average prefix length: 7.81, average data length: 0.19 
 
Clustering factor: 5993551, ratio: 0.67 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 0 
 
40 - 59% = 3407 
 
60 - 79% = 3449 
 
80 - 99% = 2246 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 154694, depth: 3, leaf buckets: 9683, nodes: 9010922 
 
Average node length: 4.37, total dup: 9010917, max dup: 8601098 
 
Average key length: 1.05, compression ratio: 0.22 
 
Average prefix length: 0.23, average data length: 0.00 
 
Clustering factor: 357333, ratio: 0.04 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 9654 
 
60 - 79% = 0 
 
80 - 99% = 28 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43359, depth: 3, leaf buckets: 10029, nodes: 9010922 
 
Average node length: 5.57, total dup: 8713451, max dup: 14896 
 
Average key length: 2.24, compression ratio: 4.01 
 
Average prefix length: 8.79, average data length: 0.21 
 
Clustering factor: 4578446, ratio: 0.51 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 1 
 
40 - 59% = 5959 
 
60 - 79% = 2338 
 
80 - 99% = 1724 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 65474, depth: 3, leaf buckets: 10543, nodes: 9010922 
 
Average node length: 5.44, total dup: 8947669, max dup: 1363119 
 
Average key length: 2.11, compression ratio: 17.80 
 
Average prefix length: 37.53, average data length: 0.11 
 
Clustering factor: 5444961, ratio: 0.60 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 2 
 
40 - 59% = 8424 
 
60 - 79% = 680 
 
80 - 99% = 1422 
 
 
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: 52.36, total records: 295183 
 
Average version length: 55.70, total versions: 13526, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.53 
 
Pointer pages: 3, data page slots: 3536 
 
Data pages: 3536, average fill: 74% 
 
Primary pages: 3536, secondary pages: 0, swept pages: 1043 
 
Empty pages: 7, full pages: 3177 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 5 
 
40 - 59% = 40 
 
60 - 79% = 3411 
 
80 - 99% = 73 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 2296, depth: 2, leaf buckets: 401, nodes: 295183 
 
Average node length: 6.06, total dup: 239765, max dup: 412 
 
Average key length: 3.39, compression ratio: 2.66 
 
Average prefix length: 7.80, average data length: 1.20 
 
Clustering factor: 29734, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 10 
 
40 - 59% = 266 
 
60 - 79% = 107 
 
80 - 99% = 14 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2211, depth: 2, leaf buckets: 301, nodes: 295183 
 
Average node length: 5.49, total dup: 263992, max dup: 351 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 63041, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 2 
 
40 - 59% = 119 
 
60 - 79% = 110 
 
80 - 99% = 70 
 
 
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: 8149, max versions: 4440 
 
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: 81% 
 
Primary pages: 4, secondary pages: 28, swept pages: 0 
 
Empty pages: 3, full pages: 28 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 28 
 
 
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.33, total records: 2527 
 
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.50 
 
Pointer pages: 1, data page slots: 32 
 
Data pages: 32, average fill: 69% 
 
Primary pages: 32, secondary pages: 0, swept pages: 0 
 
Empty pages: 2, full pages: 29 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 29 
 
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: 0.88, total records: 273102 
 
Average version length: 72.18, total versions: 269785, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 155.18 
 
Pointer pages: 6, data page slots: 9096 
 
Data pages: 4024, average fill: 88% 
 
Primary pages: 4023, secondary pages: 1, swept pages: 58 
 
Empty pages: 93, full pages: 3790 
 
Fill distribution: 
 
0 - 19% = 146 
 
20 - 39% = 45 
 
40 - 59% = 26 
 
60 - 79% = 74 
 
80 - 99% = 3733 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 117407, depth: 3, leaf buckets: 879, nodes: 273102 
 
Average node length: 6.10, total dup: 238944, max dup: 29 
 
Average key length: 3.31, compression ratio: 11.16 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 42224, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 477 
 
20 - 39% = 14 
 
40 - 59% = 357 
 
60 - 79% = 31 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (261) 
 
Primary pointer page: 708, Index root page: 709 
 
Total formats: 1, used formats: 1 
 
Average record length: 63.42, total records: 1450898 
 
Average version length: 71.48, total versions: 175817, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.14 
 
Pointer pages: 14, data page slots: 22792 
 
Data pages: 22792, average fill: 72% 
 
Primary pages: 22792, secondary pages: 0, swept pages: 4786 
 
Empty pages: 35, full pages: 15661 
 
Fill distribution: 
 
0 - 19% = 196 
 
20 - 39% = 704 
 
40 - 59% = 1859 
 
60 - 79% = 17029 
 
80 - 99% = 3004 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 181177, depth: 3, leaf buckets: 1891, nodes: 1450898 
 
Average node length: 5.16, total dup: 1410434, max dup: 133 
 
Average key length: 2.21, compression ratio: 4.07 
 
Average prefix length: 8.82, average data length: 0.18 
 
Clustering factor: 290285, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 37 
 
20 - 39% = 147 
 
40 - 59% = 1574 
 
60 - 79% = 113 
 
80 - 99% = 20 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 119803, depth: 3, leaf buckets: 2259, nodes: 1450898 
 
Average node length: 6.29, total dup: 1265552, max dup: 31 
 
Average key length: 3.34, compression ratio: 11.08 
 
Average prefix length: 35.79, average data length: 1.21 
 
Clustering factor: 371507, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 78 
 
20 - 39% = 187 
 
40 - 59% = 1667 
 
60 - 79% = 142 
 
80 - 99% = 185 
 
 
XQD_1200_2000 (260) 
 
Primary pointer page: 705, Index root page: 706 
 
Total formats: 1, used formats: 1 
 
Average record length: 5.40, total records: 565574 
 
Average version length: 71.99, total versions: 476654, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 25.19 
 
Pointer pages: 10, data page slots: 16200 
 
Data pages: 14904, average fill: 46% 
 
Primary pages: 14903, secondary pages: 1, swept pages: 3849 
 
Empty pages: 3650, full pages: 6229 
 
Fill distribution: 
 
0 - 19% = 6119 
 
20 - 39% = 1249 
 
40 - 59% = 985 
 
60 - 79% = 604 
 
80 - 99% = 5947 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 116044, depth: 3, leaf buckets: 755, nodes: 512414 
 
Average node length: 5.95, total dup: 459984, max dup: 89 
 
Average key length: 3.10, compression ratio: 11.94 
 
Average prefix length: 36.00, average data length: 1.00 
 
Clustering factor: 93397, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 189 
 
40 - 59% = 360 
 
60 - 79% = 160 
 
80 - 99% = 36 
 
 
XQD_2000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 41.95, total records: 2398433 
 
Average version length: 72.10, total versions: 628241, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 3.24 
 
Pointer pages: 23, data page slots: 36816 
 
Data pages: 36800, average fill: 67% 
 
Primary pages: 36800, secondary pages: 0, swept pages: 1176 
 
Empty pages: 103, full pages: 20179 
 
Fill distribution: 
 
0 - 19% = 460 
 
20 - 39% = 2546 
 
40 - 59% = 8574 
 
60 - 79% = 14442 
 
80 - 99% = 10778 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 108557, depth: 3, leaf buckets: 3055, nodes: 1968410 
 
Average node length: 5.65, total dup: 1845025, max dup: 99 
 
Average key length: 2.68, compression ratio: 13.78 
 
Average prefix length: 36.38, average data length: 0.62 
 
Clustering factor: 542499, ratio: 0.28 
 
Fill distribution: 
 
0 - 19% = 20 
 
20 - 39% = 1230 
 
40 - 59% = 1346 
 
60 - 79% = 266 
 
80 - 99% = 193 
 
 
XQD_2100_3300 (263) 
 
Primary pointer page: 734, Index root page: 735 
 
Total formats: 1, used formats: 1 
 
Average record length: 8.96, total records: 3309608 
 
Average version length: 69.73, total versions: 25789, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 15.18 
 
Pointer pages: 14, data page slots: 21320 
 
Data pages: 21208, average fill: 51% 
 
Primary pages: 21208, secondary pages: 0, swept pages: 4744 
 
Empty pages: 10, full pages: 19504 
 
Fill distribution: 
 
0 - 19% = 422 
 
20 - 39% = 6679 
 
40 - 59% = 4610 
 
60 - 79% = 9348 
 
80 - 99% = 149 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1530, depth: 2, leaf buckets: 75, nodes: 27282 
 
Average node length: 7.94, total dup: 20748, max dup: 34 
 
Average key length: 4.94, compression ratio: 7.49 
 
Average prefix length: 34.29, average data length: 2.71 
 
Clustering factor: 5968, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 55 
 
40 - 59% = 16 
 
60 - 79% = 3 
 
80 - 99% = 1 
 
 
XQD_3300_3400 (264) 
 
Primary pointer page: 737, Index root page: 738 
 
Total formats: 1, used formats: 1 
 
Average record length: 62.30, total records: 2494437 
 
Average version length: 71.45, total versions: 188467, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.18 
 
Pointer pages: 22, data page slots: 35128 
 
Data pages: 35128, average fill: 75% 
 
Primary pages: 35128, secondary pages: 0, swept pages: 6094 
 
Empty pages: 13, full pages: 27592 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 89 
 
40 - 59% = 1149 
 
60 - 79% = 28763 
 
80 - 99% = 5102 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 41262, depth: 3, leaf buckets: 4854, nodes: 2341637 
 
Average node length: 6.95, total dup: 1877624, max dup: 27 
 
Average key length: 3.98, compression ratio: 9.30 
 
Average prefix length: 35.22, average data length: 1.78 
 
Clustering factor: 651973, ratio: 0.28 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 2501 
 
40 - 59% = 1987 
 
60 - 79% = 199 
 
80 - 99% = 165 
 
 
XQS_1000_1200 (265) 
 
Primary pointer page: 740, Index root page: 741 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.01, total records: 3780797 
 
Average version length: 84.67, total versions: 41028, 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: 37, data page slots: 58840 
 
Data pages: 58840, average fill: 80% 
 
Primary pages: 58840, secondary pages: 0, swept pages: 24293 
 
Empty pages: 3, full pages: 57351 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 39 
 
60 - 79% = 26527 
 
80 - 99% = 32271 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54649, depth: 3, leaf buckets: 3629, nodes: 3780797 
 
Average node length: 5.16, total dup: 3693741, max dup: 133 
 
Average key length: 2.17, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 885728, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 43 
 
40 - 59% = 1270 
 
60 - 79% = 1475 
 
80 - 99% = 831 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 78654, depth: 3, leaf buckets: 5001, nodes: 3780797 
 
Average node length: 5.65, total dup: 3411855, max dup: 49 
 
Average key length: 2.67, compression ratio: 3.37 
 
Average prefix length: 8.43, average data length: 0.57 
 
Clustering factor: 606197, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 44 
 
20 - 39% = 135 
 
40 - 59% = 3961 
 
60 - 79% = 404 
 
80 - 99% = 457 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 48486, depth: 3, leaf buckets: 4108, nodes: 3780797 
 
Average node length: 5.79, total dup: 3307931, max dup: 29 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.31, average data length: 0.69 
 
Clustering factor: 935953, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 53 
 
40 - 59% = 1659 
 
60 - 79% = 1400 
 
80 - 99% = 991 
 
 
XQS_1000_3300 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.41, total records: 1639291 
 
Average version length: 83.36, total versions: 109801, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.76 
 
Pointer pages: 17, data page slots: 26232 
 
Data pages: 26232, average fill: 78% 
 
Primary pages: 26232, secondary pages: 0, swept pages: 9664 
 
Empty pages: 12, full pages: 22118 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 59 
 
40 - 59% = 742 
 
60 - 79% = 13219 
 
80 - 99% = 12190 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 75516, depth: 3, leaf buckets: 1714, nodes: 1639291 
 
Average node length: 5.13, total dup: 1602316, max dup: 221 
 
Average key length: 2.18, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 341914, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 23 
 
40 - 59% = 931 
 
60 - 79% = 576 
 
80 - 99% = 184 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 132994, depth: 3, leaf buckets: 3002, nodes: 1639291 
 
Average node length: 6.29, total dup: 1329771, max dup: 14 
 
Average key length: 3.33, compression ratio: 2.70 
 
Average prefix length: 7.86, average data length: 1.14 
 
Clustering factor: 246793, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 44 
 
20 - 39% = 1300 
 
40 - 59% = 1391 
 
60 - 79% = 241 
 
80 - 99% = 26 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 65477, depth: 3, leaf buckets: 1932, nodes: 1639291 
 
Average node length: 5.75, total dup: 1444105, max dup: 44 
 
Average key length: 2.79, compression ratio: 3.22 
 
Average prefix length: 8.32, average data length: 0.68 
 
Clustering factor: 370405, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 22 
 
40 - 59% = 1074 
 
60 - 79% = 637 
 
80 - 99% = 195 
 
 
XQS_1200_2000 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.35, total records: 4300067 
 
Average version length: 85.61, total versions: 340650, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.76 
 
Pointer pages: 43, data page slots: 69728 
 
Data pages: 69728, average fill: 78% 
 
Primary pages: 69728, secondary pages: 0, swept pages: 13174 
 
Empty pages: 3, full pages: 58917 
 
Fill distribution: 
 
0 - 19% = 77 
 
20 - 39% = 570 
 
40 - 59% = 2546 
 
60 - 79% = 31038 
 
80 - 99% = 35497 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57323, depth: 3, leaf buckets: 4639, nodes: 4300067 
 
Average node length: 5.03, total dup: 4276494, max dup: 611 
 
Average key length: 2.05, compression ratio: 4.39 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 1162469, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 260 
 
40 - 59% = 2716 
 
60 - 79% = 1303 
 
80 - 99% = 354 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 78658, depth: 3, leaf buckets: 5950, nodes: 4300067 
 
Average node length: 5.50, total dup: 3982772, max dup: 49 
 
Average key length: 2.51, compression ratio: 3.58 
 
Average prefix length: 8.56, average data length: 0.44 
 
Clustering factor: 933825, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 36 
 
20 - 39% = 1832 
 
40 - 59% = 3083 
 
60 - 79% = 466 
 
80 - 99% = 533 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49624, depth: 3, leaf buckets: 5145, nodes: 4300067 
 
Average node length: 5.59, total dup: 3917491, max dup: 141 
 
Average key length: 2.61, compression ratio: 3.45 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 1238589, ratio: 0.29 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 239 
 
40 - 59% = 3042 
 
60 - 79% = 1442 
 
80 - 99% = 415 
 
 
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: 79.09, total records: 2772576 
 
Average version length: 84.68, total versions: 154821, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.72 
 
Pointer pages: 28, data page slots: 44632 
 
Data pages: 44632, average fill: 78% 
 
Primary pages: 44632, secondary pages: 0, swept pages: 14396 
 
Empty pages: 4, full pages: 37306 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 59 
 
40 - 59% = 829 
 
60 - 79% = 24087 
 
80 - 99% = 19633 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 94870, depth: 3, leaf buckets: 2948, nodes: 2772576 
 
Average node length: 5.02, total dup: 2759007, max dup: 1557 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 733946, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 275 
 
40 - 59% = 1515 
 
60 - 79% = 752 
 
80 - 99% = 392 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 98028, depth: 3, leaf buckets: 5321, nodes: 2772576 
 
Average node length: 6.31, total dup: 2245924, max dup: 14 
 
Average key length: 3.34, compression ratio: 2.70 
 
Average prefix length: 7.85, average data length: 1.15 
 
Clustering factor: 585314, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 168 
 
20 - 39% = 2452 
 
40 - 59% = 2414 
 
60 - 79% = 227 
 
80 - 99% = 60 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 78028, depth: 3, leaf buckets: 3113, nodes: 2772576 
 
Average node length: 5.53, total dup: 2552340, max dup: 99 
 
Average key length: 2.55, compression ratio: 3.52 
 
Average prefix length: 8.52, average data length: 0.48 
 
Clustering factor: 769095, ratio: 0.28 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 168 
 
40 - 59% = 1437 
 
60 - 79% = 1083 
 
80 - 99% = 419 
 
 
XQS_3300_3400 (270) 
 
Primary pointer page: 776, Index root page: 777 
 
Total formats: 1, used formats: 1 
 
Average record length: 66.30, total records: 485176 
 
Average version length: 69.56, total versions: 20591, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.05 
 
Pointer pages: 5, data page slots: 6752 
 
Data pages: 6752, average fill: 77% 
 
Primary pages: 6752, secondary pages: 0, swept pages: 3862 
 
Empty pages: 4, full pages: 6179 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 27 
 
40 - 59% = 90 
 
60 - 79% = 6082 
 
80 - 99% = 543 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 543870, depth: 3, leaf buckets: 549, nodes: 485176 
 
Average node length: 5.37, total dup: 451373, max dup: 155 
 
Average key length: 2.54, compression ratio: 3.55 
 
Average prefix length: 8.53, average data length: 0.47 
 
Clustering factor: 45179, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 59 
 
40 - 59% = 237 
 
60 - 79% = 181 
 
80 - 99% = 70 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 393490, depth: 3, leaf buckets: 612, nodes: 485176 
 
Average node length: 5.94, total dup: 412091, max dup: 29 
 
Average key length: 3.10, compression ratio: 2.90 
 
Average prefix length: 8.05, average data length: 0.95 
 
Clustering factor: 52592, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 73 
 
40 - 59% = 265 
 
60 - 79% = 208 
 
80 - 99% = 66 
 
 
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 33010 ms, from 11:09:55.14 to 11:10:28.15. 
 
 
 
| TABLE_NAME | TOTAL_RECS | TOTAL_VERS | VERS_PERCENT | 
| AGENTS | 50 | 0 | 0.0000 | 
| BUSINESS_OPS | 19 | 0 | 0.0000 | 
| DOC_DATA | 1722123 | 49712 | 2.8866 | 
| DOC_LIST | 603987 | 26087 | 4.3191 | 
| DOC_STATES | 4 | 0 | 0.0000 | 
| FB_ERRORS | 758 | 0 | 0.0000 | 
| INVNT_SALDO | 400 | 889287 | 222321.7500 | 
| INVNT_TURNOVER_LOG | 207863 | 202153 | 97.2529 | 
| MONEY_SALDO | 49 | 51589 | 105283.6734 | 
| MONEY_TURNOVER_LOG | 9152 | 9056 | 98.9510 | 
| OPTYPES | 9 | 0 | 0.0000 | 
| PDISTR | 635441 | 43315 | 6.8165 | 
| PERF_ESTIMATED | 252183 | 0 | 0.0000 | 
| PERF_LOG | 9010922 | 0 | 0.0000 | 
| PSTORNED | 295183 | 13526 | 4.5822 | 
| RULES_FOR_PDISTR | 4 | 0 | 0.0000 | 
| RULES_FOR_QDISTR | 7 | 0 | 0.0000 | 
| SEMAPHORES | 4 | 8149 | 203725.0000 | 
| SETTINGS | 114 | 0 | 0.0000 | 
| TRACE_STAT | 2527 | 0 | 0.0000 | 
| WARES | 400 | 0 | 0.0000 | 
| WARE_GROUPS | 8 | 0 | 0.0000 | 
| XQD_1000_1200 | 273102 | 269785 | 98.7854 | 
| XQD_1000_3300 | 1450898 | 175817 | 12.1178 | 
| XQD_1200_2000 | 565574 | 476654 | 84.2779 | 
| XQD_2000_3300 | 2398433 | 628241 | 26.1938 | 
| XQD_2100_3300 | 3309608 | 25789 | 0.7792 | 
| XQD_3300_3400 | 2494437 | 188467 | 7.5554 | 
| XQS_1000_1200 | 3780797 | 41028 | 1.0851 | 
| XQS_1000_3300 | 1639291 | 109801 | 6.6980 | 
| XQS_1200_2000 | 4300067 | 340650 | 7.9219 | 
| XQS_2100_3300 | 2772576 | 154821 | 5.5840 | 
| XQS_3300_3400 | 485176 | 20591 | 4.2440 | 
| Z_USED_VIEWS | 29 | 0 | 0.0000 | 
 
Done for 2310 ms, from 11:10:37.82 to 11:10:40.13.  
11:10:40.24 Validation started 
 
 
11:10:40.27 Relation 140 (DOC_LIST) 
 
11:10:40.27   process pointer page    0 of    5 
 
11:10:40.36   process pointer page    1 of    5 
 
11:10:40.46   process pointer page    2 of    5 
 
11:10:40.52   process pointer page    3 of    5 
 
11:10:40.55   process pointer page    4 of    5 
 
11:10:40.58 Index 1 (PK_DOC_LIST) 
 
11:10:40.67 Index 2 (DOC_LIST_ID_DESC) 
 
11:10:40.77 Index 3 (FK_DOC_LIST_AGENTS) 
 
11:10:40.91 Relation 140 (DOC_LIST) is ok 
 
 
11:10:40.91 Relation 141 (DOC_DATA) 
 
11:10:40.91   process pointer page    0 of   12 
 
11:10:41.02   process pointer page    1 of   12 
 
11:10:41.11   process pointer page    2 of   12 
 
11:10:41.21   process pointer page    3 of   12 
 
11:10:41.28   process pointer page    4 of   12 
 
11:10:41.33   process pointer page    5 of   12 
 
11:10:41.36   process pointer page    6 of   12 
 
11:10:41.45   process pointer page    7 of   12 
 
11:10:41.52   process pointer page    8 of   12 
 
11:10:41.55   process pointer page    9 of   12 
 
11:10:41.60   process pointer page   10 of   12 
 
11:10:41.67   process pointer page   11 of   12 
 
11:10:41.72 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
11:10:42.33 Index 3 (DOC_DATA_ID_DESC) 
 
11:10:42.69 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
11:10:43.01 Relation 141 (DOC_DATA) is ok 
 
 
11:10:43.01 Relation 147 (INVNT_SALDO) 
 
11:10:43.01   process pointer page    0 of    3 
 
11:10:44.51   process pointer page    1 of    3 
 
11:10:44.51   process pointer page    2 of    3 
 
11:10:44.53 Index 1 (PK_INVNT_SALDO) 
 
11:10:44.53 Relation 147 (INVNT_SALDO) is ok 
 
 
11:10:44.53 Relation 150 (PDISTR) 
 
11:10:44.53   process pointer page    0 of    3 
 
11:10:44.64   process pointer page    1 of    3 
 
11:10:44.68   process pointer page    2 of    3 
 
11:10:44.79 Index 2 (PDISTR_SND_ID) 
 
11:10:44.92 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
11:10:45.03 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
11:10:45.14 Index 5 (PDISTR_AGENT_ID) 
 
11:10:45.25 Relation 150 (PDISTR) is ok 
 
 
11:10:45.25 Relation 151 (PSTORNED) 
 
11:10:45.25   process pointer page    0 of    3 
 
11:10:45.29   process pointer page    1 of    3 
 
11:10:45.34   process pointer page    2 of    3 
 
11:10:45.34 Index 2 (PSTORNED_SND_ID) 
 
11:10:45.39 Index 3 (PSTORNED_RCV_ID) 
 
11:10:45.42 Relation 151 (PSTORNED) is ok 
 
 
11:10:45.42 Relation 156 (SEMAPHORES) 
 
11:10:45.42   process pointer page    0 of    1 
 
11:10:45.42 Index 1 (PK_SEMAPHORES) 
 
11:10:45.42 Index 2 (SEMAPHORES_TASK_UNQ) 
 
11:10:45.42 Relation 156 (SEMAPHORES) is ok 
 
 
11:10:45.42 Relation 157 (INVNT_TURNOVER_LOG) 
 
11:10:45.42   process pointer page    0 of    5 
 
11:10:45.46   process pointer page    1 of    5 
 
11:10:45.53   process pointer page    2 of    5 
 
11:10:45.54   process pointer page    3 of    5 
 
11:10:45.62   process pointer page    4 of    5 
 
11:10:45.65 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
11:10:45.70 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
11:10:45.70 Relation 160 (PERF_ESTIMATED) 
 
11:10:45.70   process pointer page    0 of    2 
 
11:10:45.73   process pointer page    1 of    2 
 
11:10:45.74 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
11:10:45.76 Relation 160 (PERF_ESTIMATED) is ok 
 
 
11:10:45.76 Relation 161 (PERF_ISQL_STAT) 
 
11:10:45.76   process pointer page    0 of    1 
 
11:10:45.76 Index 1 (PERF_ISQL_STAT_TRN) 
 
11:10:45.76 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
11:10:45.76 Relation 162 (PERF_LOG) 
 
11:10:45.76   process pointer page    0 of  129 
 
11:10:45.79   process pointer page    1 of  129 
 
11:10:45.82   process pointer page    2 of  129 
 
11:10:45.84   process pointer page    3 of  129 
 
11:10:45.87   process pointer page    4 of  129 
 
11:10:45.93   process pointer page    5 of  129 
 
11:10:45.96   process pointer page    6 of  129 
 
11:10:45.99   process pointer page    7 of  129 
 
11:10:46.04   process pointer page    8 of  129 
 
11:10:46.12   process pointer page    9 of  129 
 
11:10:46.15   process pointer page   10 of  129 
 
11:10:46.18   process pointer page   11 of  129 
 
11:10:46.21   process pointer page   12 of  129 
 
11:10:46.24   process pointer page   13 of  129 
 
11:10:46.28   process pointer page   14 of  129 
 
11:10:46.31   process pointer page   15 of  129 
 
11:10:46.34   process pointer page   16 of  129 
 
11:10:46.35   process pointer page   17 of  129 
 
11:10:46.38   process pointer page   18 of  129 
 
11:10:46.42   process pointer page   19 of  129 
 
11:10:46.45   process pointer page   20 of  129 
 
11:10:46.48   process pointer page   21 of  129 
 
11:10:46.49   process pointer page   22 of  129 
 
11:10:46.52   process pointer page   23 of  129 
 
11:10:46.56   process pointer page   24 of  129 
 
11:10:46.57   process pointer page   25 of  129 
 
11:10:46.60   process pointer page   26 of  129 
 
11:10:46.63   process pointer page   27 of  129 
 
11:10:46.65   process pointer page   28 of  129 
 
11:10:46.67   process pointer page   29 of  129 
 
11:10:46.70   process pointer page   30 of  129 
 
11:10:46.71   process pointer page   31 of  129 
 
11:10:46.74   process pointer page   32 of  129 
 
11:10:46.76   process pointer page   33 of  129 
 
11:10:46.79   process pointer page   34 of  129 
 
11:10:46.81   process pointer page   35 of  129 
 
11:10:46.82   process pointer page   36 of  129 
 
11:10:46.85   process pointer page   37 of  129 
 
11:10:46.87   process pointer page   38 of  129 
 
11:10:46.90   process pointer page   39 of  129 
 
11:10:46.91   process pointer page   40 of  129 
 
11:10:46.95   process pointer page   41 of  129 
 
11:10:46.98   process pointer page   42 of  129 
 
11:10:47.01   process pointer page   43 of  129 
 
11:10:47.02   process pointer page   44 of  129 
 
11:10:47.06   process pointer page   45 of  129 
 
11:10:47.09   process pointer page   46 of  129 
 
11:10:47.15   process pointer page   47 of  129 
 
11:10:47.16   process pointer page   48 of  129 
 
11:10:47.23   process pointer page   49 of  129 
 
11:10:47.26   process pointer page   50 of  129 
 
11:10:47.29   process pointer page   51 of  129 
 
11:10:47.32   process pointer page   52 of  129 
 
11:10:47.38   process pointer page   53 of  129 
 
11:10:47.41   process pointer page   54 of  129 
 
11:10:47.48   process pointer page   55 of  129 
 
11:10:47.55   process pointer page   56 of  129 
 
11:10:47.63   process pointer page   57 of  129 
 
11:10:47.71   process pointer page   58 of  129 
 
11:10:47.79   process pointer page   59 of  129 
 
11:10:47.87   process pointer page   60 of  129 
 
11:10:47.93   process pointer page   61 of  129 
 
11:10:47.96   process pointer page   62 of  129 
 
11:10:47.99   process pointer page   63 of  129 
 
11:10:48.02   process pointer page   64 of  129 
 
11:10:48.05   process pointer page   65 of  129 
 
11:10:48.10   process pointer page   66 of  129 
 
11:10:48.18   process pointer page   67 of  129 
 
11:10:48.21   process pointer page   68 of  129 
 
11:10:48.23   process pointer page   69 of  129 
 
11:10:48.26   process pointer page   70 of  129 
 
11:10:48.29   process pointer page   71 of  129 
 
11:10:48.32   process pointer page   72 of  129 
 
11:10:48.40   process pointer page   73 of  129 
 
11:10:48.44   process pointer page   74 of  129 
 
11:10:48.47   process pointer page   75 of  129 
 
11:10:48.51   process pointer page   76 of  129 
 
11:10:48.54   process pointer page   77 of  129 
 
11:10:48.57   process pointer page   78 of  129 
 
11:10:48.60   process pointer page   79 of  129 
 
11:10:48.62   process pointer page   80 of  129 
 
11:10:48.65   process pointer page   81 of  129 
 
11:10:48.68   process pointer page   82 of  129 
 
11:10:48.69   process pointer page   83 of  129 
 
11:10:48.72   process pointer page   84 of  129 
 
11:10:48.74   process pointer page   85 of  129 
 
11:10:48.77   process pointer page   86 of  129 
 
11:10:48.79   process pointer page   87 of  129 
 
11:10:48.82   process pointer page   88 of  129 
 
11:10:48.83   process pointer page   89 of  129 
 
11:10:48.85   process pointer page   90 of  129 
 
11:10:48.88   process pointer page   91 of  129 
 
11:10:48.90   process pointer page   92 of  129 
 
11:10:48.93   process pointer page   93 of  129 
 
11:10:48.94   process pointer page   94 of  129 
 
11:10:48.96   process pointer page   95 of  129 
 
11:10:48.99   process pointer page   96 of  129 
 
11:10:49.02   process pointer page   97 of  129 
 
11:10:49.05   process pointer page   98 of  129 
 
11:10:49.07   process pointer page   99 of  129 
 
11:10:49.10   process pointer page  100 of  129 
 
11:10:49.11   process pointer page  101 of  129 
 
11:10:49.15   process pointer page  102 of  129 
 
11:10:49.18   process pointer page  103 of  129 
 
11:10:49.22   process pointer page  104 of  129 
 
11:10:49.25   process pointer page  105 of  129 
 
11:10:49.29   process pointer page  106 of  129 
 
11:10:49.32   process pointer page  107 of  129 
 
11:10:49.33   process pointer page  108 of  129 
 
11:10:49.36   process pointer page  109 of  129 
 
11:10:49.40   process pointer page  110 of  129 
 
11:10:49.43   process pointer page  111 of  129 
 
11:10:49.50   process pointer page  112 of  129 
 
11:10:49.58   process pointer page  113 of  129 
 
11:10:49.63   process pointer page  114 of  129 
 
11:10:49.66   process pointer page  115 of  129 
 
11:10:49.69   process pointer page  116 of  129 
 
11:10:49.72   process pointer page  117 of  129 
 
11:10:49.75   process pointer page  118 of  129 
 
11:10:49.79   process pointer page  119 of  129 
 
11:10:49.82   process pointer page  120 of  129 
 
11:10:49.85   process pointer page  121 of  129 
 
11:10:49.86   process pointer page  122 of  129 
 
11:10:49.89   process pointer page  123 of  129 
 
11:10:49.93   process pointer page  124 of  129 
 
11:10:49.96   process pointer page  125 of  129 
 
11:10:49.99   process pointer page  126 of  129 
 
11:10:50.05   process pointer page  127 of  129 
 
11:10:50.07   process pointer page  128 of  129 
 
11:10:50.08 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
11:10:52.70 Index 2 (PERF_LOG_UNIT) 
 
11:10:55.56 Index 3 (PERF_LOG_TRN_DESC) 
 
11:10:56.96 Index 4 (PERF_LOG_GDSCODE) 
 
11:10:57.62 Relation 162 (PERF_LOG) is ok 
 
 
11:10:57.62 Relation 166 (V_STOPTEST) 
 
11:10:57.62 Relation 166 (V_STOPTEST) is ok 
 
 
11:10:57.62 Relation 183 (V_QDISTR_SOURCE) 
 
11:10:57.62 Relation 183 (V_QDISTR_SOURCE) is ok 
 
 
11:10:57.62 Relation 184 (V_QSTORNED_SOURCE) 
 
11:10:57.62 Relation 184 (V_QSTORNED_SOURCE) is ok 
 
 
11:10:57.62 Relation 259 (XQD_1000_1200) 
 
11:10:57.62   process pointer page    0 of    6 
 
11:10:57.69   process pointer page    1 of    6 
 
11:10:57.71   process pointer page    2 of    6 
 
11:10:57.74   process pointer page    3 of    6 
 
11:10:57.74   process pointer page    4 of    6 
 
11:10:57.76   process pointer page    5 of    6 
 
11:10:57.90 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
11:10:57.99 Relation 259 (XQD_1000_1200) is ok 
 
 
11:10:57.99 Relation 260 (XQD_1200_2000) 
 
11:10:57.99   process pointer page    0 of   10 
 
11:10:58.08   process pointer page    1 of   10 
 
11:10:58.15   process pointer page    2 of   10 
 
11:10:58.21   process pointer page    3 of   10 
 
11:10:58.27   process pointer page    4 of   10 
 
11:10:58.33   process pointer page    5 of   10 
 
11:10:58.35   process pointer page    6 of   10 
 
11:10:58.38   process pointer page    7 of   10 
 
11:10:58.44   process pointer page    8 of   10 
 
11:10:58.55   process pointer page    9 of   10 
 
11:10:58.65 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
11:10:58.71 Relation 260 (XQD_1200_2000) is ok 
 
 
11:10:58.71 Relation 261 (XQD_1000_3300) 
 
11:10:58.71   process pointer page    0 of   14 
 
11:10:58.74   process pointer page    1 of   14 
 
11:10:58.79   process pointer page    2 of   14 
 
11:10:58.82   process pointer page    3 of   14 
 
11:10:58.85   process pointer page    4 of   14 
 
11:10:58.88   process pointer page    5 of   14 
 
11:10:58.91   process pointer page    6 of   14 
 
11:10:58.96   process pointer page    7 of   14 
 
11:10:59.05   process pointer page    8 of   14 
 
11:10:59.10   process pointer page    9 of   14 
 
11:10:59.15   process pointer page   10 of   14 
 
11:10:59.18   process pointer page   11 of   14 
 
11:10:59.21   process pointer page   12 of   14 
 
11:10:59.25   process pointer page   13 of   14 
 
11:10:59.35 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
11:10:59.66 Index 2 (XQD_1000_3300_DOC) 
 
11:10:59.83 Relation 261 (XQD_1000_3300) is ok 
 
 
11:10:59.83 Relation 262 (XQD_2000_3300) 
 
11:10:59.83   process pointer page    0 of   23 
 
11:10:59.88   process pointer page    1 of   23 
 
11:10:59.93   process pointer page    2 of   23 
 
11:10:59.96   process pointer page    3 of   23 
 
11:11:00.00   process pointer page    4 of   23 
 
11:11:00.05   process pointer page    5 of   23 
 
11:11:00.14   process pointer page    6 of   23 
 
11:11:00.21   process pointer page    7 of   23 
 
11:11:00.27   process pointer page    8 of   23 
 
11:11:00.32   process pointer page    9 of   23 
 
11:11:00.36   process pointer page   10 of   23 
 
11:11:00.49   process pointer page   11 of   23 
 
11:11:00.56   process pointer page   12 of   23 
 
11:11:00.67   process pointer page   13 of   23 
 
11:11:00.72   process pointer page   14 of   23 
 
11:11:00.78   process pointer page   15 of   23 
 
11:11:00.83   process pointer page   16 of   23 
 
11:11:00.89   process pointer page   17 of   23 
 
11:11:01.02   process pointer page   18 of   23 
 
11:11:01.08   process pointer page   19 of   23 
 
11:11:01.13   process pointer page   20 of   23 
 
11:11:01.17   process pointer page   21 of   23 
 
11:11:01.28   process pointer page   22 of   23 
 
11:11:01.31 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
11:11:01.70 Relation 262 (XQD_2000_3300) is ok 
 
 
11:11:01.70 Relation 263 (XQD_2100_3300) 
 
11:11:01.70   process pointer page    0 of   14 
 
11:11:01.73   process pointer page    1 of   14 
 
11:11:01.80   process pointer page    2 of   14 
 
11:11:01.84   process pointer page    3 of   14 
 
11:11:01.86   process pointer page    4 of   14 
 
11:11:01.89   process pointer page    5 of   14 
 
11:11:01.92   process pointer page    6 of   14 
 
11:11:01.95   process pointer page    7 of   14 
 
11:11:01.97   process pointer page    8 of   14 
 
11:11:02.05   process pointer page    9 of   14 
 
11:11:02.11   process pointer page   10 of   14 
 
11:11:02.19   process pointer page   11 of   14 
 
11:11:02.22   process pointer page   12 of   14 
 
11:11:02.25   process pointer page   13 of   14 
 
11:11:02.25 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
11:11:02.25 Relation 263 (XQD_2100_3300) is ok 
 
 
11:11:02.25 Relation 264 (XQD_3300_3400) 
 
11:11:02.25   process pointer page    0 of   22 
 
11:11:02.34   process pointer page    1 of   22 
 
11:11:02.41   process pointer page    2 of   22 
 
11:11:02.44   process pointer page    3 of   22 
 
11:11:02.48   process pointer page    4 of   22 
 
11:11:02.51   process pointer page    5 of   22 
 
11:11:02.56   process pointer page    6 of   22 
 
11:11:02.59   process pointer page    7 of   22 
 
11:11:02.62   process pointer page    8 of   22 
 
11:11:02.66   process pointer page    9 of   22 
 
11:11:02.69   process pointer page   10 of   22 
 
11:11:02.72   process pointer page   11 of   22 
 
11:11:02.83   process pointer page   12 of   22 
 
11:11:02.86   process pointer page   13 of   22 
 
11:11:02.97   process pointer page   14 of   22 
 
11:11:03.05   process pointer page   15 of   22 
 
11:11:03.08   process pointer page   16 of   22 
 
11:11:03.12   process pointer page   17 of   22 
 
11:11:03.17   process pointer page   18 of   22 
 
11:11:03.20   process pointer page   19 of   22 
 
11:11:03.25   process pointer page   20 of   22 
 
11:11:03.28   process pointer page   21 of   22 
 
11:11:03.29 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
11:11:03.59 Relation 264 (XQD_3300_3400) is ok 
 
 
11:11:03.59 Relation 265 (XQS_1000_1200) 
 
11:11:03.59   process pointer page    0 of   37 
 
11:11:03.61   process pointer page    1 of   37 
 
11:11:03.64   process pointer page    2 of   37 
 
11:11:03.67   process pointer page    3 of   37 
 
11:11:03.70   process pointer page    4 of   37 
 
11:11:03.75   process pointer page    5 of   37 
 
11:11:03.83   process pointer page    6 of   37 
 
11:11:03.92   process pointer page    7 of   37 
 
11:11:03.97   process pointer page    8 of   37 
 
11:11:04.00   process pointer page    9 of   37 
 
11:11:04.03   process pointer page   10 of   37 
 
11:11:04.07   process pointer page   11 of   37 
 
11:11:04.09   process pointer page   12 of   37 
 
11:11:04.12   process pointer page   13 of   37 
 
11:11:04.15   process pointer page   14 of   37 
 
11:11:04.18   process pointer page   15 of   37 
 
11:11:04.23   process pointer page   16 of   37 
 
11:11:04.29   process pointer page   17 of   37 
 
11:11:04.32   process pointer page   18 of   37 
 
11:11:04.36   process pointer page   19 of   37 
 
11:11:04.40   process pointer page   20 of   37 
 
11:11:04.45   process pointer page   21 of   37 
 
11:11:04.54   process pointer page   22 of   37 
 
11:11:04.59   process pointer page   23 of   37 
 
11:11:04.62   process pointer page   24 of   37 
 
11:11:04.67   process pointer page   25 of   37 
 
11:11:04.73   process pointer page   26 of   37 
 
11:11:04.79   process pointer page   27 of   37 
 
11:11:04.82   process pointer page   28 of   37 
 
11:11:04.85   process pointer page   29 of   37 
 
11:11:04.90   process pointer page   30 of   37 
 
11:11:04.93   process pointer page   31 of   37 
 
11:11:04.96   process pointer page   32 of   37 
 
11:11:05.00   process pointer page   33 of   37 
 
11:11:05.03   process pointer page   34 of   37 
 
11:11:05.06   process pointer page   35 of   37 
 
11:11:05.09   process pointer page   36 of   37 
 
11:11:05.09 Index 1 (XQS_1000_1200_DOC_ID) 
 
11:11:05.65 Index 2 (XQS_1000_1200_SND_ID) 
 
11:11:05.98 Index 3 (XQS_1000_1200_RCV_ID) 
 
11:11:06.34 Relation 265 (XQS_1000_1200) is ok 
 
 
11:11:06.34 Relation 266 (XQS_1200_2000) 
 
11:11:06.34   process pointer page    0 of   43 
 
11:11:06.43   process pointer page    1 of   43 
 
11:11:06.46   process pointer page    2 of   43 
 
11:11:06.54   process pointer page    3 of   43 
 
11:11:06.63   process pointer page    4 of   43 
 
11:11:06.70   process pointer page    5 of   43 
 
11:11:06.74   process pointer page    6 of   43 
 
11:11:06.85   process pointer page    7 of   43 
 
11:11:06.95   process pointer page    8 of   43 
 
11:11:07.04   process pointer page    9 of   43 
 
11:11:07.07   process pointer page   10 of   43 
 
11:11:07.12   process pointer page   11 of   43 
 
11:11:07.15   process pointer page   12 of   43 
 
11:11:07.21   process pointer page   13 of   43 
 
11:11:07.32   process pointer page   14 of   43 
 
11:11:07.43   process pointer page   15 of   43 
 
11:11:07.46   process pointer page   16 of   43 
 
11:11:07.51   process pointer page   17 of   43 
 
11:11:07.54   process pointer page   18 of   43 
 
11:11:07.58   process pointer page   19 of   43 
 
11:11:07.68   process pointer page   20 of   43 
 
11:11:07.71   process pointer page   21 of   43 
 
11:11:07.76   process pointer page   22 of   43 
 
11:11:07.80   process pointer page   23 of   43 
 
11:11:07.88   process pointer page   24 of   43 
 
11:11:07.97   process pointer page   25 of   43 
 
11:11:08.01   process pointer page   26 of   43 
 
11:11:08.05   process pointer page   27 of   43 
 
11:11:08.10   process pointer page   28 of   43 
 
11:11:08.15   process pointer page   29 of   43 
 
11:11:08.21   process pointer page   30 of   43 
 
11:11:08.26   process pointer page   31 of   43 
 
11:11:08.30   process pointer page   32 of   43 
 
11:11:08.35   process pointer page   33 of   43 
 
11:11:08.40   process pointer page   34 of   43 
 
11:11:08.43   process pointer page   35 of   43 
 
11:11:08.47   process pointer page   36 of   43 
 
11:11:08.52   process pointer page   37 of   43 
 
11:11:08.55   process pointer page   38 of   43 
 
11:11:08.58   process pointer page   39 of   43 
 
11:11:08.65   process pointer page   40 of   43 
 
11:11:08.77   process pointer page   41 of   43 
 
11:11:08.83   process pointer page   42 of   43 
 
11:11:08.86 Index 1 (XQS_1200_2000_DOC_ID) 
 
11:11:09.61 Index 2 (XQS_1200_2000_SND_ID) 
 
11:11:10.24 Index 3 (XQS_1200_2000_RCV_ID) 
 
11:11:10.77 Relation 266 (XQS_1200_2000) is ok 
 
 
11:11:10.77 Relation 267 (XQS_1000_3300) 
 
11:11:10.77   process pointer page    0 of   17 
 
11:11:10.80   process pointer page    1 of   17 
 
11:11:10.81   process pointer page    2 of   17 
 
11:11:10.85   process pointer page    3 of   17 
 
11:11:10.88   process pointer page    4 of   17 
 
11:11:10.91   process pointer page    5 of   17 
 
11:11:10.94   process pointer page    6 of   17 
 
11:11:10.95   process pointer page    7 of   17 
 
11:11:10.99   process pointer page    8 of   17 
 
11:11:11.02   process pointer page    9 of   17 
 
11:11:11.05   process pointer page   10 of   17 
 
11:11:11.08   process pointer page   11 of   17 
 
11:11:11.11   process pointer page   12 of   17 
 
11:11:11.14   process pointer page   13 of   17 
 
11:11:11.17   process pointer page   14 of   17 
 
11:11:11.22   process pointer page   15 of   17 
 
11:11:11.28   process pointer page   16 of   17 
 
11:11:11.28 Index 1 (XQS_1000_3300_DOC_ID) 
 
11:11:11.77 Index 2 (XQS_1000_3300_SND_ID) 
 
11:11:12.16 Index 3 (XQS_1000_3300_RCV_ID) 
 
11:11:12.36 Relation 267 (XQS_1000_3300) is ok 
 
 
11:11:12.36 Relation 268 (XQS_2000_3300) 
 
11:11:12.36   process pointer page    0 of    1 
 
11:11:12.36 Index 1 (XQS_2000_3300_DOC_ID) 
 
11:11:12.36 Index 2 (XQS_2000_3300_SND_ID) 
 
11:11:12.36 Index 3 (XQS_2000_3300_RCV_ID) 
 
11:11:12.36 Relation 268 (XQS_2000_3300) is ok 
 
 
11:11:12.36 Relation 269 (XQS_2100_3300) 
 
11:11:12.36   process pointer page    0 of   28 
 
11:11:12.39   process pointer page    1 of   28 
 
11:11:12.42   process pointer page    2 of   28 
 
11:11:12.47   process pointer page    3 of   28 
 
11:11:12.53   process pointer page    4 of   28 
 
11:11:12.59   process pointer page    5 of   28 
 
11:11:12.64   process pointer page    6 of   28 
 
11:11:12.67   process pointer page    7 of   28 
 
11:11:12.72   process pointer page    8 of   28 
 
11:11:12.75   process pointer page    9 of   28 
 
11:11:12.78   process pointer page   10 of   28 
 
11:11:12.81   process pointer page   11 of   28 
 
11:11:12.84   process pointer page   12 of   28 
 
11:11:12.87   process pointer page   13 of   28 
 
11:11:12.97   process pointer page   14 of   28 
 
11:11:13.06   process pointer page   15 of   28 
 
11:11:13.17   process pointer page   16 of   28 
 
11:11:13.28   process pointer page   17 of   28 
 
11:11:13.37   process pointer page   18 of   28 
 
11:11:13.45   process pointer page   19 of   28 
 
11:11:13.50   process pointer page   20 of   28 
 
11:11:13.56   process pointer page   21 of   28 
 
11:11:13.64   process pointer page   22 of   28 
 
11:11:13.73   process pointer page   23 of   28 
 
11:11:13.84   process pointer page   24 of   28 
 
11:11:13.90   process pointer page   25 of   28 
 
11:11:13.95   process pointer page   26 of   28 
 
11:11:14.00   process pointer page   27 of   28 
 
11:11:14.03 Index 1 (XQS_2100_3300_DOC_ID) 
 
11:11:14.42 Index 2 (XQS_2100_3300_SND_ID) 
 
11:11:14.92 Index 3 (XQS_2100_3300_RCV_ID) 
 
11:11:15.40 Relation 269 (XQS_2100_3300) is ok 
 
 
11:11:15.40 Relation 270 (XQS_3300_3400) 
 
11:11:15.40   process pointer page    0 of    5 
 
11:11:15.46   process pointer page    1 of    5 
 
11:11:15.53   process pointer page    2 of    5 
 
11:11:15.57   process pointer page    3 of    5 
 
11:11:15.65   process pointer page    4 of    5 
 
11:11:15.67 Index 1 (XQS_3300_3400_DOC_ID) 
 
11:11:15.76 Index 2 (XQS_3300_3400_SND_ID) 
 
11:11:15.81 Relation 270 (XQS_3300_3400) is ok 
 
 
11:11:15.81 Relation 276 (TRACE_STAT) 
 
11:11:15.81   process pointer page    0 of    1 
 
11:11:15.81 Relation 276 (TRACE_STAT) is ok 
 
 
11:11:15.81 Validation finished 
 
Done for 35660 ms, from 11:10:40.16 to 11:11:15.82. 
 
 Differences between old and current firebird.log 
11:11:16.87. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_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-04-06  11:11               509 oltp40_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Wed Apr 06 11:10:40 2016 
 
7:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Wed Apr 06 11:11:15 2016 
 
12:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 302 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.oltp40\oltp40_*.*: 
 
 
| ERRORS_CHECKING_RESULT | 
| NO_SEVERE_ERRORS_FOUND | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2016-04-06 11:11:23.29 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html