|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 180 minutes:  | 
 6220.93  | 
 3735  | 
 1119767  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  customer order: creation  | 
 475.09  | 
 537  | 
 85516  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  customer order: refuse  | 
 38.88  | 
 276  | 
 6999  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  order to supplier: creation  | 
 120.26  | 
 2376  | 
 21646  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  order to supplier: removal  | 
 3.03  | 
 24200  | 
 543  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  invoice (draft): creation  | 
 122.04  | 
 3520  | 
 21967  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  invoice (draft): removal  | 
 42.41  | 
 563  | 
 7633  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  invoice accept: apply  | 
 67.92  | 
 13372  | 
 12225  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  invoice accept: cancel  | 
 19.36  | 
 3324  | 
 3484  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  customer reserve: creation  | 
 3570.46  | 
 210  | 
 642682  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  customer reserve: removal  | 
 1103.54  | 
 79  | 
 198637  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  realization accept: apply  | 
 223.44  | 
 568  | 
 40219  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  realization accept: cancel  | 
 91.44  | 
 171  | 
 16459  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  payment from customer: creation  | 
 157.39  | 
 967  | 
 28330  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  payment from customer: removal  | 
 14.32  | 
 152  | 
 2577  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  payment to supplier: creation  | 
 130.91  | 
 688  | 
 23564  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  payment to supplier: removal  | 
 9.56  | 
 148  | 
 1720  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  service: total inventory turnovers  | 
 9.91  | 
 3196  | 
 1784  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  service: total monetary turnovers  | 
 20.94  | 
 63  | 
 3770  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  service: refresh index statistics  | 
 0.07  | 
 16558  | 
 12  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
 
Done for 138810 ms, from 11:23:35.65 to 11:25:54.46.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 5513  | 
 116107  | 
 99241  | 
 16866  | 
 14.53  | 
 08:18:32  | 
 08:36:32  | 
|  interval #   2, overall  | 
 2  | 
 6485  | 
 129242  | 
 116724  | 
 12518  | 
 9.69  | 
 08:36:33  | 
 08:54:33  | 
|  interval #   3, overall  | 
 3  | 
 6034  | 
 121649  | 
 108608  | 
 13041  | 
 10.72  | 
 08:54:34  | 
 09:12:34  | 
|  interval #   4, overall  | 
 4  | 
 5726  | 
 118685  | 
 103061  | 
 15624  | 
 13.16  | 
 09:12:35  | 
 09:30:35  | 
|  interval #   5, overall  | 
 5  | 
 6176  | 
 129027  | 
 111175  | 
 17852  | 
 13.84  | 
 09:30:36  | 
 09:48:36  | 
|  interval #   6, overall  | 
 6  | 
 6303  | 
 128522  | 
 113447  | 
 15075  | 
 11.73  | 
 09:48:37  | 
 10:06:37  | 
|  interval #   7, overall  | 
 7  | 
 6412  | 
 133455  | 
 115416  | 
 18039  | 
 13.52  | 
 10:06:38  | 
 10:24:38  | 
|  interval #   8, overall  | 
 8  | 
 6451  | 
 127371  | 
 116118  | 
 11253  | 
 8.83  | 
 10:24:39  | 
 10:42:39  | 
|  interval #   9, overall  | 
 9  | 
 6820  | 
 135257  | 
 122763  | 
 12494  | 
 9.24  | 
 10:42:40  | 
 11:00:40  | 
|  interval #  10, overall  | 
 10  | 
 6290  | 
 126933  | 
 113214  | 
 13719  | 
 10.81  | 
 11:00:41  | 
 11:18:41  | 
 
Done for 236960 ms, from 11:29:59.92 to 11:33:56.88.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 4036.14  | 
 0.4591  | 
 1.7060  | 
 2148  | 
 12  | 
|  TEST_TIME  | 
 2  | 
 4459.50  | 
 0.7721  | 
 1.1819  | 
 1709  | 
 17  | 
|  TEST_TIME  | 
 3  | 
 4121.29  | 
 0.8527  | 
 1.1663  | 
 1500  | 
 15  | 
|  TEST_TIME  | 
 4  | 
 4078.43  | 
 0.8840  | 
 1.1308  | 
 1138  | 
 18  | 
|  TEST_TIME  | 
 5  | 
 4124.25  | 
 0.9006  | 
 1.0735  | 
 1243  | 
 18  | 
|  TEST_TIME  | 
 6  | 
 4039.37  | 
 0.9134  | 
 1.0889  | 
 1275  | 
 18  | 
|  TEST_TIME  | 
 7  | 
 4108.96  | 
 0.9176  | 
 1.0889  | 
 1449  | 
 18  | 
|  TEST_TIME  | 
 8  | 
 4254.18  | 
 0.9202  | 
 1.1179  | 
 1681  | 
 17  | 
|  TEST_TIME  | 
 9  | 
 4466.83  | 
 0.9480  | 
 1.0489  | 
 1294  | 
 21  | 
|  TEST_TIME  | 
 10  | 
 4593.46  | 
 0.9180  | 
 1.0877  | 
 2345  | 
 24  | 
|  TEST_TIME  | 
 11  | 
 4824.07  | 
 0.9428  | 
 1.0530  | 
 1526  | 
 100  | 
|  TEST_TIME  | 
 12  | 
 5000.05  | 
 0.9313  | 
 1.0686  | 
 2222  | 
 100  | 
|  TEST_TIME  | 
 13  | 
 5194.84  | 
 0.9495  | 
 1.0487  | 
 2062  | 
 100  | 
|  TEST_TIME  | 
 14  | 
 5304.69  | 
 0.9537  | 
 1.0422  | 
 1876  | 
 100  | 
|  TEST_TIME  | 
 15  | 
 5404.90  | 
 0.9548  | 
 1.0400  | 
 2045  | 
 100  | 
|  TEST_TIME  | 
 16  | 
 5448.88  | 
 0.9671  | 
 1.0381  | 
 1768  | 
 100  | 
|  TEST_TIME  | 
 17  | 
 5514.81  | 
 0.9656  | 
 1.0325  | 
 1658  | 
 100  | 
|  TEST_TIME  | 
 18  | 
 5527.13  | 
 0.9730  | 
 1.0308  | 
 1230  | 
 100  | 
|  TEST_TIME  | 
 19  | 
 5533.62  | 
 0.9754  | 
 1.0173  | 
 1638  | 
 100  | 
|  TEST_TIME  | 
 20  | 
 5513.61  | 
 0.9700  | 
 1.0309  | 
 1573  | 
 100  | 
|  TEST_TIME  | 
 21  | 
 5575.24  | 
 0.9711  | 
 1.0351  | 
 1570  | 
 100  | 
|  TEST_TIME  | 
 22  | 
 5665.03  | 
 0.9724  | 
 1.0243  | 
 1521  | 
 100  | 
|  TEST_TIME  | 
 23  | 
 5659.09  | 
 0.9808  | 
 1.0167  | 
 1237  | 
 100  | 
|  TEST_TIME  | 
 24  | 
 5687.85  | 
 0.9696  | 
 1.0327  | 
 2313  | 
 100  | 
|  TEST_TIME  | 
 25  | 
 5837.31  | 
 0.9660  | 
 1.0339  | 
 2186  | 
 100  | 
|  TEST_TIME  | 
 26  | 
 5893.12  | 
 0.9848  | 
 1.0163  | 
 2170  | 
 100  | 
|  TEST_TIME  | 
 27  | 
 5942.85  | 
 0.9705  | 
 1.0155  | 
 1804  | 
 100  | 
|  TEST_TIME  | 
 28  | 
 5892.20  | 
 0.9876  | 
 1.0146  | 
 1784  | 
 93  | 
|  TEST_TIME  | 
 29  | 
 5920.08  | 
 0.9750  | 
 1.0184  | 
 1698  | 
 99  | 
|  TEST_TIME  | 
 30  | 
 5927.45  | 
 0.9833  | 
 1.0115  | 
 1538  | 
 99  | 
|  TEST_TIME  | 
 31  | 
 5876.64  | 
 0.9873  | 
 1.0148  | 
 1745  | 
 97  | 
|  TEST_TIME  | 
 32  | 
 5886.40  | 
 0.9814  | 
 1.0220  | 
 1603  | 
 100  | 
|  TEST_TIME  | 
 33  | 
 5923.74  | 
 0.9848  | 
 1.0170  | 
 1546  | 
 100  | 
|  TEST_TIME  | 
 34  | 
 5935.91  | 
 0.9851  | 
 1.0173  | 
 1604  | 
 100  | 
|  TEST_TIME  | 
 35  | 
 5966.07  | 
 0.9833  | 
 1.0201  | 
 1496  | 
 100  | 
|  TEST_TIME  | 
 36  | 
 5986.07  | 
 0.9885  | 
 1.0121  | 
 1400  | 
 100  | 
|  TEST_TIME  | 
 37  | 
 6010.85  | 
 0.9807  | 
 1.0118  | 
 1447  | 
 100  | 
|  TEST_TIME  | 
 38  | 
 6007.02  | 
 0.9858  | 
 1.0121  | 
 1411  | 
 100  | 
|  TEST_TIME  | 
 39  | 
 5994.99  | 
 0.9881  | 
 1.0054  | 
 1993  | 
 100  | 
|  TEST_TIME  | 
 40  | 
 5909.75  | 
 0.9944  | 
 1.0056  | 
 1527  | 
 73  | 
|  TEST_TIME  | 
 41  | 
 5904.76  | 
 0.9819  | 
 1.0111  | 
 1007  | 
 96  | 
|  TEST_TIME  | 
 42  | 
 5888.06  | 
 0.9899  | 
 1.0097  | 
 2117  | 
 98  | 
|  TEST_TIME  | 
 43  | 
 5911.54  | 
 0.9827  | 
 1.0147  | 
 2094  | 
 99  | 
|  TEST_TIME  | 
 44  | 
 5922.27  | 
 0.9899  | 
 1.0128  | 
 1754  | 
 100  | 
|  TEST_TIME  | 
 45  | 
 5929.70  | 
 0.9892  | 
 1.0130  | 
 1833  | 
 100  | 
|  TEST_TIME  | 
 46  | 
 5919.42  | 
 0.9927  | 
 1.0135  | 
 1810  | 
 100  | 
|  TEST_TIME  | 
 47  | 
 5946.61  | 
 0.9875  | 
 1.0120  | 
 1617  | 
 100  | 
|  TEST_TIME  | 
 48  | 
 5985.45  | 
 0.9854  | 
 1.0116  | 
 1768  | 
 100  | 
|  TEST_TIME  | 
 49  | 
 5967.16  | 
 0.9940  | 
 1.0108  | 
 1634  | 
 99  | 
|  TEST_TIME  | 
 50  | 
 5953.43  | 
 0.9929  | 
 1.0141  | 
 1522  | 
 99  | 
|  TEST_TIME  | 
 51  | 
 5947.21  | 
 0.9957  | 
 1.0107  | 
 1499  | 
 99  | 
|  TEST_TIME  | 
 52  | 
 5976.05  | 
 0.9865  | 
 1.0124  | 
 1340  | 
 100  | 
|  TEST_TIME  | 
 53  | 
 5993.56  | 
 0.9905  | 
 1.0101  | 
 1421  | 
 100  | 
|  TEST_TIME  | 
 54  | 
 6001.94  | 
 0.9900  | 
 1.0071  | 
 2348  | 
 100  | 
|  TEST_TIME  | 
 55  | 
 5990.87  | 
 0.9906  | 
 1.0094  | 
 2358  | 
 99  | 
|  TEST_TIME  | 
 56  | 
 6013.01  | 
 0.9877  | 
 1.0149  | 
 1949  | 
 99  | 
|  TEST_TIME  | 
 57  | 
 6021.62  | 
 0.9956  | 
 1.0083  | 
 2066  | 
 97  | 
|  TEST_TIME  | 
 58  | 
 6048.43  | 
 0.9865  | 
 1.0097  | 
 1857  | 
 100  | 
|  TEST_TIME  | 
 59  | 
 6045.76  | 
 0.9930  | 
 1.0089  | 
 1999  | 
 97  | 
|  TEST_TIME  | 
 60  | 
 6033.60  | 
 0.9941  | 
 1.0074  | 
 1789  | 
 95  | 
|  TEST_TIME  | 
 61  | 
 6042.14  | 
 0.9917  | 
 1.0062  | 
 1647  | 
 100  | 
|  TEST_TIME  | 
 62  | 
 6011.68  | 
 0.9950  | 
 1.0065  | 
 1814  | 
 96  | 
|  TEST_TIME  | 
 63  | 
 5992.75  | 
 0.9937  | 
 1.0067  | 
 1758  | 
 87  | 
|  TEST_TIME  | 
 64  | 
 6002.53  | 
 0.9954  | 
 1.0036  | 
 1318  | 
 100  | 
|  TEST_TIME  | 
 65  | 
 5946.21  | 
 0.9975  | 
 1.0028  | 
 1504  | 
 93  | 
|  TEST_TIME  | 
 66  | 
 5894.89  | 
 0.9962  | 
 1.0053  | 
 1462  | 
 86  | 
|  TEST_TIME  | 
 67  | 
 5902.15  | 
 0.9891  | 
 1.0098  | 
 1137  | 
 100  | 
|  TEST_TIME  | 
 68  | 
 5906.76  | 
 0.9942  | 
 1.0043  | 
 1493  | 
 100  | 
|  TEST_TIME  | 
 69  | 
 5902.38  | 
 0.9905  | 
 1.0086  | 
 1969  | 
 100  | 
|  TEST_TIME  | 
 70  | 
 5900.11  | 
 0.9946  | 
 1.0106  | 
 2281  | 
 96  | 
|  TEST_TIME  | 
 71  | 
 5918.20  | 
 0.9933  | 
 1.0085  | 
 1993  | 
 98  | 
|  TEST_TIME  | 
 72  | 
 5919.77  | 
 0.9942  | 
 1.0061  | 
 1969  | 
 97  | 
|  TEST_TIME  | 
 73  | 
 5915.07  | 
 0.9931  | 
 1.0063  | 
 1612  | 
 98  | 
|  TEST_TIME  | 
 74  | 
 5917.45  | 
 0.9923  | 
 1.0079  | 
 1707  | 
 100  | 
|  TEST_TIME  | 
 75  | 
 5942.64  | 
 0.9903  | 
 1.0086  | 
 1702  | 
 100  | 
|  TEST_TIME  | 
 76  | 
 5972.81  | 
 0.9903  | 
 1.0063  | 
 1460  | 
 100  | 
|  TEST_TIME  | 
 77  | 
 5978.08  | 
 0.9923  | 
 1.0045  | 
 1593  | 
 100  | 
|  TEST_TIME  | 
 78  | 
 5952.71  | 
 0.9959  | 
 1.0041  | 
 1624  | 
 91  | 
|  TEST_TIME  | 
 79  | 
 5942.31  | 
 0.9931  | 
 1.0090  | 
 1506  | 
 100  | 
|  TEST_TIME  | 
 80  | 
 5943.15  | 
 0.9963  | 
 1.0085  | 
 1445  | 
 99  | 
|  TEST_TIME  | 
 81  | 
 5934.67  | 
 0.9974  | 
 1.0029  | 
 1528  | 
 97  | 
|  TEST_TIME  | 
 82  | 
 5914.03  | 
 0.9942  | 
 1.0087  | 
 1252  | 
 99  | 
|  TEST_TIME  | 
 83  | 
 5911.96  | 
 0.9969  | 
 1.0059  | 
 1262  | 
 99  | 
|  TEST_TIME  | 
 84  | 
 5912.46  | 
 0.9940  | 
 1.0053  | 
 1935  | 
 100  | 
|  TEST_TIME  | 
 85  | 
 5932.97  | 
 0.9940  | 
 1.0059  | 
 1936  | 
 100  | 
|  TEST_TIME  | 
 86  | 
 5935.66  | 
 0.9937  | 
 1.0050  | 
 1705  | 
 99  | 
|  TEST_TIME  | 
 87  | 
 5935.28  | 
 0.9935  | 
 1.0078  | 
 1399  | 
 99  | 
|  TEST_TIME  | 
 88  | 
 5948.12  | 
 0.9944  | 
 1.0050  | 
 2073  | 
 99  | 
|  TEST_TIME  | 
 89  | 
 5959.99  | 
 0.9917  | 
 1.0073  | 
 1583  | 
 100  | 
|  TEST_TIME  | 
 90  | 
 5961.28  | 
 0.9959  | 
 1.0049  | 
 1730  | 
 96  | 
|  TEST_TIME  | 
 91  | 
 5949.49  | 
 0.9958  | 
 1.0082  | 
 1472  | 
 95  | 
|  TEST_TIME  | 
 92  | 
 5966.15  | 
 0.9944  | 
 1.0043  | 
 1432  | 
 100  | 
|  TEST_TIME  | 
 93  | 
 5963.68  | 
 0.9939  | 
 1.0047  | 
 1582  | 
 100  | 
|  TEST_TIME  | 
 94  | 
 5972.61  | 
 0.9925  | 
 1.0060  | 
 1541  | 
 100  | 
|  TEST_TIME  | 
 95  | 
 5964.30  | 
 0.9968  | 
 1.0025  | 
 1447  | 
 99  | 
|  TEST_TIME  | 
 96  | 
 5933.68  | 
 0.9972  | 
 1.0071  | 
 1202  | 
 83  | 
|  TEST_TIME  | 
 97  | 
 5947.29  | 
 0.9962  | 
 1.0036  | 
 1437  | 
 99  | 
|  TEST_TIME  | 
 98  | 
 5931.55  | 
 0.9960  | 
 1.0058  | 
 1312  | 
 98  | 
|  TEST_TIME  | 
 99  | 
 5968.31  | 
 0.9896  | 
 1.0068  | 
 1653  | 
 100  | 
|  TEST_TIME  | 
 100  | 
 5990.51  | 
 0.9930  | 
 1.0044  | 
 2405  | 
 100  | 
|  TEST_TIME  | 
 101  | 
 5997.37  | 
 0.9933  | 
 1.0065  | 
 1875  | 
 99  | 
|  TEST_TIME  | 
 102  | 
 6002.72  | 
 0.9957  | 
 1.0051  | 
 2005  | 
 100  | 
|  TEST_TIME  | 
 103  | 
 6001.72  | 
 0.9955  | 
 1.0071  | 
 1837  | 
 98  | 
|  TEST_TIME  | 
 104  | 
 6018.23  | 
 0.9947  | 
 1.0038  | 
 1654  | 
 95  | 
|  TEST_TIME  | 
 105  | 
 6031.81  | 
 0.9928  | 
 1.0018  | 
 1322  | 
 98  | 
|  TEST_TIME  | 
 106  | 
 6005.60  | 
 0.9967  | 
 1.0044  | 
 1505  | 
 92  | 
|  TEST_TIME  | 
 107  | 
 6032.43  | 
 0.9906  | 
 1.0056  | 
 1247  | 
 99  | 
|  TEST_TIME  | 
 108  | 
 6031.21  | 
 0.9965  | 
 1.0025  | 
 1537  | 
 100  | 
|  TEST_TIME  | 
 109  | 
 6037.47  | 
 0.9923  | 
 1.0061  | 
 1333  | 
 100  | 
|  TEST_TIME  | 
 110  | 
 6041.63  | 
 0.9963  | 
 1.0031  | 
 1415  | 
 100  | 
|  TEST_TIME  | 
 111  | 
 6038.32  | 
 0.9947  | 
 1.0076  | 
 1332  | 
 100  | 
|  TEST_TIME  | 
 112  | 
 6056.51  | 
 0.9957  | 
 1.0037  | 
 1123  | 
 100  | 
|  TEST_TIME  | 
 113  | 
 6052.79  | 
 0.9954  | 
 1.0052  | 
 1278  | 
 100  | 
|  TEST_TIME  | 
 114  | 
 6060.01  | 
 0.9952  | 
 1.0050  | 
 1526  | 
 100  | 
|  TEST_TIME  | 
 115  | 
 6058.62  | 
 0.9965  | 
 1.0051  | 
 1725  | 
 99  | 
|  TEST_TIME  | 
 116  | 
 6064.21  | 
 0.9955  | 
 1.0035  | 
 2103  | 
 99  | 
|  TEST_TIME  | 
 117  | 
 6061.01  | 
 0.9954  | 
 1.0064  | 
 1763  | 
 95  | 
|  TEST_TIME  | 
 118  | 
 6075.08  | 
 0.9956  | 
 1.0050  | 
 1525  | 
 100  | 
|  TEST_TIME  | 
 119  | 
 6076.16  | 
 0.9963  | 
 1.0055  | 
 1617  | 
 100  | 
|  TEST_TIME  | 
 120  | 
 6097.01  | 
 0.9937  | 
 1.0036  | 
 1625  | 
 100  | 
|  TEST_TIME  | 
 121  | 
 6086.91  | 
 0.9970  | 
 1.0031  | 
 1584  | 
 94  | 
|  TEST_TIME  | 
 122  | 
 6085.57  | 
 0.9951  | 
 1.0039  | 
 1480  | 
 97  | 
|  TEST_TIME  | 
 123  | 
 6088.88  | 
 0.9952  | 
 1.0030  | 
 1563  | 
 98  | 
|  TEST_TIME  | 
 124  | 
 6087.01  | 
 0.9952  | 
 1.0027  | 
 1404  | 
 100  | 
|  TEST_TIME  | 
 125  | 
 6076.83  | 
 0.9963  | 
 1.0026  | 
 1500  | 
 98  | 
|  TEST_TIME  | 
 126  | 
 6072.36  | 
 0.9953  | 
 1.0044  | 
 1250  | 
 98  | 
|  TEST_TIME  | 
 127  | 
 6068.44  | 
 0.9971  | 
 1.0026  | 
 1318  | 
 98  | 
|  TEST_TIME  | 
 128  | 
 6055.01  | 
 0.9969  | 
 1.0026  | 
 1269  | 
 88  | 
|  TEST_TIME  | 
 129  | 
 6058.76  | 
 0.9942  | 
 1.0049  | 
 1396  | 
 97  | 
|  TEST_TIME  | 
 130  | 
 6084.82  | 
 0.9930  | 
 1.0031  | 
 1565  | 
 99  | 
|  TEST_TIME  | 
 131  | 
 6086.04  | 
 0.9952  | 
 1.0035  | 
 1940  | 
 97  | 
|  TEST_TIME  | 
 132  | 
 6087.60  | 
 0.9956  | 
 1.0042  | 
 1865  | 
 93  | 
|  TEST_TIME  | 
 133  | 
 6100.68  | 
 0.9945  | 
 1.0048  | 
 1281  | 
 100  | 
|  TEST_TIME  | 
 134  | 
 6104.89  | 
 0.9966  | 
 1.0042  | 
 1553  | 
 98  | 
|  TEST_TIME  | 
 135  | 
 6099.91  | 
 0.9976  | 
 1.0056  | 
 1390  | 
 98  | 
|  TEST_TIME  | 
 136  | 
 6106.70  | 
 0.9971  | 
 1.0031  | 
 1594  | 
 97  | 
|  TEST_TIME  | 
 137  | 
 6112.46  | 
 0.9948  | 
 1.0041  | 
 1367  | 
 92  | 
|  TEST_TIME  | 
 138  | 
 6117.95  | 
 0.9960  | 
 1.0026  | 
 1405  | 
 96  | 
|  TEST_TIME  | 
 139  | 
 6112.56  | 
 0.9963  | 
 1.0037  | 
 1535  | 
 95  | 
|  TEST_TIME  | 
 140  | 
 6106.70  | 
 0.9975  | 
 1.0026  | 
 1326  | 
 89  | 
|  TEST_TIME  | 
 141  | 
 6115.68  | 
 0.9940  | 
 1.0030  | 
 1164  | 
 100  | 
|  TEST_TIME  | 
 142  | 
 6126.64  | 
 0.9941  | 
 1.0057  | 
 1008  | 
 100  | 
|  TEST_TIME  | 
 143  | 
 6137.31  | 
 0.9969  | 
 1.0040  | 
 1160  | 
 100  | 
|  TEST_TIME  | 
 144  | 
 6128.66  | 
 0.9984  | 
 1.0022  | 
 1432  | 
 96  | 
|  TEST_TIME  | 
 145  | 
 6122.88  | 
 0.9962  | 
 1.0072  | 
 1825  | 
 98  | 
|  TEST_TIME  | 
 146  | 
 6144.14  | 
 0.9968  | 
 1.0032  | 
 1959  | 
 99  | 
|  TEST_TIME  | 
 147  | 
 6146.35  | 
 0.9960  | 
 1.0034  | 
 1778  | 
 95  | 
|  TEST_TIME  | 
 148  | 
 6147.34  | 
 0.9964  | 
 1.0036  | 
 1721  | 
 92  | 
|  TEST_TIME  | 
 149  | 
 6151.19  | 
 0.9962  | 
 1.0050  | 
 1457  | 
 96  | 
|  TEST_TIME  | 
 150  | 
 6182.70  | 
 0.9933  | 
 1.0050  | 
 1145  | 
 100  | 
|  TEST_TIME  | 
 151  | 
 6186.53  | 
 0.9978  | 
 1.0014  | 
 1431  | 
 100  | 
|  TEST_TIME  | 
 152  | 
 6173.88  | 
 0.9968  | 
 1.0041  | 
 1344  | 
 91  | 
|  TEST_TIME  | 
 153  | 
 6171.88  | 
 0.9978  | 
 1.0026  | 
 1372  | 
 86  | 
|  TEST_TIME  | 
 154  | 
 6165.29  | 
 0.9971  | 
 1.0027  | 
 1354  | 
 87  | 
|  TEST_TIME  | 
 155  | 
 6172.56  | 
 0.9950  | 
 1.0036  | 
 1115  | 
 99  | 
|  TEST_TIME  | 
 156  | 
 6168.99  | 
 0.9977  | 
 1.0021  | 
 1432  | 
 98  | 
|  TEST_TIME  | 
 157  | 
 6159.13  | 
 0.9973  | 
 1.0024  | 
 1255  | 
 91  | 
|  TEST_TIME  | 
 158  | 
 6151.29  | 
 0.9973  | 
 1.0047  | 
 1166  | 
 92  | 
|  TEST_TIME  | 
 159  | 
 6156.42  | 
 0.9975  | 
 1.0033  | 
 1043  | 
 82  | 
|  TEST_TIME  | 
 160  | 
 6171.09  | 
 0.9950  | 
 1.0044  | 
 1589  | 
 93  | 
|  TEST_TIME  | 
 161  | 
 6185.40  | 
 0.9959  | 
 1.0038  | 
 1672  | 
 93  | 
|  TEST_TIME  | 
 162  | 
 6191.79  | 
 0.9966  | 
 1.0051  | 
 1752  | 
 87  | 
|  TEST_TIME  | 
 163  | 
 6201.46  | 
 0.9973  | 
 1.0027  | 
 1683  | 
 76  | 
|  TEST_TIME  | 
 164  | 
 6206.00  | 
 0.9959  | 
 1.0029  | 
 1257  | 
 83  | 
|  TEST_TIME  | 
 165  | 
 6212.77  | 
 0.9958  | 
 1.0026  | 
 1300  | 
 85  | 
|  TEST_TIME  | 
 166  | 
 6206.07  | 
 0.9977  | 
 1.0031  | 
 1411  | 
 80  | 
|  TEST_TIME  | 
 167  | 
 6225.93  | 
 0.9952  | 
 1.0027  | 
 1088  | 
 100  | 
|  TEST_TIME  | 
 168  | 
 6215.69  | 
 0.9983  | 
 1.0032  | 
 1392  | 
 94  | 
|  TEST_TIME  | 
 169  | 
 6227.46  | 
 0.9955  | 
 1.0013  | 
 1077  | 
 91  | 
|  TEST_TIME  | 
 170  | 
 6222.00  | 
 0.9963  | 
 1.0040  | 
 1152  | 
 93  | 
|  TEST_TIME  | 
 171  | 
 6235.04  | 
 0.9961  | 
 1.0021  | 
 1167  | 
 100  | 
|  TEST_TIME  | 
 172  | 
 6220.20  | 
 0.9987  | 
 1.0017  | 
 1295  | 
 92  | 
|  TEST_TIME  | 
 173  | 
 6210.83  | 
 0.9975  | 
 1.0029  | 
 1145  | 
 91  | 
|  TEST_TIME  | 
 174  | 
 6220.46  | 
 0.9956  | 
 1.0026  | 
 1687  | 
 93  | 
|  TEST_TIME  | 
 175  | 
 6218.40  | 
 0.9972  | 
 1.0032  | 
 1968  | 
 92  | 
|  TEST_TIME  | 
 176  | 
 6232.67  | 
 0.9952  | 
 1.0035  | 
 1580  | 
 90  | 
|  TEST_TIME  | 
 177  | 
 6238.61  | 
 0.9968  | 
 1.0026  | 
 1402  | 
 92  | 
|  TEST_TIME  | 
 178  | 
 6237.34  | 
 0.9971  | 
 1.0041  | 
 1254  | 
 90  | 
|  TEST_TIME  | 
 179  | 
 6235.65  | 
 0.9988  | 
 1.0018  | 
 1217  | 
 92  | 
|  TEST_TIME  | 
 180  | 
 6216.61  | 
 0.9993  | 
 1.0006  | 
 763  | 
 87  | 
 
Done for 11300 ms, from 11:33:58.84 to 11:34:10.14.  
 
 
|  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  | 
 60857  | 
 79540  | 
 61729  | 
 <null>  | 
 55676  | 
 <null>  | 
 71150  | 
 63297  | 
 64226  | 
 54155  | 
 69642  | 
 71180  | 
 90420  | 
 56021  | 
 113671  | 
 136825  | 
 337134  | 
 502694  | 
 <null>  | 
 08:18:32  | 
 08:36:32  | 
|  fetches per second  | 
 2  | 
 48301  | 
 20241  | 
 28695  | 
 <null>  | 
 44319  | 
 199261  | 
 53512  | 
 28996  | 
 32942  | 
 67147  | 
 66011  | 
 5190  | 
 111353  | 
 91030  | 
 102798  | 
 36190  | 
 169217  | 
 126289  | 
 <null>  | 
 08:36:33  | 
 08:54:33  | 
|  fetches per second  | 
 3  | 
 27232  | 
 58262  | 
 30933  | 
 <null>  | 
 32196  | 
 30750  | 
 49569  | 
 37589  | 
 34046  | 
 32358  | 
 33828  | 
 23673  | 
 40554  | 
 4547  | 
 47449  | 
 7145  | 
 <null>  | 
 105587  | 
 <null>  | 
 08:54:34  | 
 09:12:34  | 
|  fetches per second  | 
 4  | 
 6881  | 
 28917  | 
 5307  | 
 <null>  | 
 11364  | 
 4260  | 
 13090  | 
 <null>  | 
 1020  | 
 16445  | 
 10869  | 
 47885  | 
 7605  | 
 <null>  | 
 14449  | 
 2325  | 
 8118  | 
 44680  | 
 <null>  | 
 09:12:35  | 
 09:30:35  | 
|  fetches per second  | 
 5  | 
 10220  | 
 9810  | 
 4745  | 
 <null>  | 
 27090  | 
 34344  | 
 19283  | 
 5281  | 
 2367  | 
 5114  | 
 10016  | 
 9857  | 
 17380  | 
 2587  | 
 12182  | 
 15368  | 
 17018  | 
 36394  | 
 <null>  | 
 09:30:36  | 
 09:48:36  | 
|  fetches per second  | 
 6  | 
 8848  | 
 15920  | 
 6336  | 
 <null>  | 
 12555  | 
 <null>  | 
 32611  | 
 5703  | 
 6156  | 
 2795  | 
 26239  | 
 2519  | 
 38867  | 
 11205  | 
 44672  | 
 50785  | 
 65308  | 
 72187  | 
 <null>  | 
 09:48:37  | 
 10:06:37  | 
|  fetches per second  | 
 7  | 
 9861  | 
 61342  | 
 20006  | 
 <null>  | 
 12051  | 
 2655  | 
 28503  | 
 17199  | 
 <null>  | 
 5050  | 
 17385  | 
 43339  | 
 29396  | 
 3820  | 
 11549  | 
 4906  | 
 <null>  | 
 46142  | 
 <null>  | 
 10:06:38  | 
 10:24:38  | 
|  fetches per second  | 
 8  | 
 5011  | 
 16875  | 
 2782  | 
 45107  | 
 6698  | 
 <null>  | 
 17456  | 
 3967  | 
 5390  | 
 <null>  | 
 11863  | 
 1914  | 
 12851  | 
 4625  | 
 5193  | 
 3657  | 
 <null>  | 
 223766  | 
 <null>  | 
 10:24:39  | 
 10:42:39  | 
|  fetches per second  | 
 9  | 
 9113  | 
 2780  | 
 8344  | 
 18854  | 
 15029  | 
 <null>  | 
 9205  | 
 5458  | 
 4266  | 
 3885  | 
 12921  | 
 2357  | 
 21117  | 
 5101  | 
 5172  | 
 2336  | 
 <null>  | 
 77163  | 
 <null>  | 
 10:42:40  | 
 11:00:40  | 
|  fetches per second  | 
 10  | 
 8031  | 
 5065  | 
 8261  | 
 <null>  | 
 11621  | 
 <null>  | 
 15804  | 
 5855  | 
 2380  | 
 <null>  | 
 6107  | 
 17256  | 
 14941  | 
 3518  | 
 14474  | 
 21552  | 
 <null>  | 
 131191  | 
 <null>  | 
 11:00:41  | 
 11:18:41  | 
|  marks per second  | 
 1  | 
 14009  | 
 11072  | 
 13085  | 
 <null>  | 
 11963  | 
 <null>  | 
 8853  | 
 13917  | 
 7779  | 
 11103  | 
 13717  | 
 13226  | 
 8444  | 
 9650  | 
 5448  | 
 20888  | 
 10409  | 
 34740  | 
 <null>  | 
 08:18:32  | 
 08:36:32  | 
|  marks per second  | 
 2  | 
 10607  | 
 3039  | 
 6317  | 
 <null>  | 
 9653  | 
 50214  | 
 7830  | 
 5484  | 
 4690  | 
 11675  | 
 12011  | 
 895  | 
 9834  | 
 13805  | 
 7182  | 
 5714  | 
 17469  | 
 8275  | 
 <null>  | 
 08:36:33  | 
 08:54:33  | 
|  marks per second  | 
 3  | 
 6091  | 
 7513  | 
 6750  | 
 <null>  | 
 7239  | 
 6740  | 
 7507  | 
 7036  | 
 5553  | 
 7235  | 
 4424  | 
 3788  | 
 3325  | 
 1003  | 
 3755  | 
 1354  | 
 <null>  | 
 7113  | 
 <null>  | 
 08:54:34  | 
 09:12:34  | 
|  marks per second  | 
 4  | 
 1336  | 
 3660  | 
 960  | 
 <null>  | 
 2328  | 
 776  | 
 1901  | 
 <null>  | 
 160  | 
 3624  | 
 1863  | 
 10224  | 
 517  | 
 <null>  | 
 846  | 
 350  | 
 724  | 
 856  | 
 <null>  | 
 09:12:35  | 
 09:30:35  | 
|  marks per second  | 
 5  | 
 2205  | 
 1257  | 
 843  | 
 <null>  | 
 5197  | 
 8209  | 
 2602  | 
 918  | 
 378  | 
 810  | 
 1551  | 
 1580  | 
 1113  | 
 553  | 
 1125  | 
 2417  | 
 2745  | 
 784  | 
 <null>  | 
 09:30:36  | 
 09:48:36  | 
|  marks per second  | 
 6  | 
 1975  | 
 2394  | 
 1201  | 
 <null>  | 
 2498  | 
 <null>  | 
 4807  | 
 958  | 
 917  | 
 458  | 
 2478  | 
 435  | 
 2493  | 
 1764  | 
 4290  | 
 7285  | 
 9011  | 
 4740  | 
 <null>  | 
 09:48:37  | 
 10:06:37  | 
|  marks per second  | 
 7  | 
 2190  | 
 7828  | 
 3677  | 
 <null>  | 
 2140  | 
 555  | 
 4078  | 
 2943  | 
 <null>  | 
 780  | 
 1810  | 
 6308  | 
 1295  | 
 652  | 
 1804  | 
 930  | 
 <null>  | 
 1247  | 
 <null>  | 
 10:06:38  | 
 10:24:38  | 
|  marks per second  | 
 8  | 
 1013  | 
 2166  | 
 452  | 
 7823  | 
 978  | 
 <null>  | 
 2628  | 
 645  | 
 770  | 
 <null>  | 
 1366  | 
 297  | 
 566  | 
 750  | 
 571  | 
 596  | 
 <null>  | 
 1951  | 
 <null>  | 
 10:24:39  | 
 10:42:39  | 
|  marks per second  | 
 9  | 
 1962  | 
 362  | 
 1727  | 
 3221  | 
 2674  | 
 <null>  | 
 1057  | 
 883  | 
 588  | 
 625  | 
 1981  | 
 376  | 
 822  | 
 989  | 
 526  | 
 355  | 
 <null>  | 
 1368  | 
 <null>  | 
 10:42:40  | 
 11:00:40  | 
|  marks per second  | 
 10  | 
 1770  | 
 712  | 
 1387  | 
 <null>  | 
 2074  | 
 <null>  | 
 1958  | 
 957  | 
 353  | 
 <null>  | 
 911  | 
 2986  | 
 521  | 
 555  | 
 2448  | 
 3299  | 
 <null>  | 
 1705  | 
 <null>  | 
 11:00:41  | 
 11:18:41  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 08:18:32  | 
 08:36:32  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 08:36:33  | 
 08:54:33  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 08:54:34  | 
 09:12:34  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 09:12:35  | 
 09:30:35  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 09:30:36  | 
 09:48:36  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 09:48:37  | 
 10:06:37  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 10:06:38  | 
 10:24:38  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 10:24:39  | 
 10:42:39  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 10:42:40  | 
 11:00:40  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 11:00:41  | 
 11:18:41  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 4  | 
 0  | 
 <null>  | 
 08:18:32  | 
 08:36:32  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 5  | 
 0  | 
 <null>  | 
 08:36:33  | 
 08:54:33  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 1  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 08:54:34  | 
 09:12:34  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 09:12:35  | 
 09:30:35  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 09:30:36  | 
 09:48:36  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 09:48:37  | 
 10:06:37  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 10:06:38  | 
 10:24:38  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 10:24:39  | 
 10:42:39  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 10:42:40  | 
 11:00:40  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 11:00:41  | 
 11:18:41  | 
 
Done for 10480 ms, from 11:34:11.46 to 11:34:21.94.  
 
 
|  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  | 
 1948284  | 
 1813316  | 
 134968  | 
 6.92  | 
 0  | 
 30093  | 
 56  | 
 134518  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  doc_list_biud  | 
 1948742  | 
 1813316  | 
 135426  | 
 6.94  | 
 0  | 
 28329  | 
 20  | 
 134990  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_add_invoice_to_stock  | 
 20488  | 
 12225  | 
 8263  | 
 40.33  | 
 15  | 
 208385  | 
 13372  | 
 8259  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_cancel_adding_invoice  | 
 4507  | 
 3484  | 
 1023  | 
 22.69  | 
 0  | 
 86410  | 
 3324  | 
 1023  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_cancel_client_order  | 
 7152  | 
 6999  | 
 153  | 
 2.13  | 
 0  | 
 2652  | 
 276  | 
 153  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_cancel_customer_reserve  | 
 322204  | 
 198637  | 
 123567  | 
 38.35  | 
 0  | 
 19376  | 
 79  | 
 123567  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_cancel_pay_from_customer  | 
 2599  | 
 2577  | 
 22  | 
 0.84  | 
 0  | 
 15538  | 
 152  | 
 22  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_cancel_pay_to_supplier  | 
 1724  | 
 1720  | 
 4  | 
 0.23  | 
 0  | 
 1528  | 
 148  | 
 4  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_cancel_supplier_invoice  | 
 10060  | 
 7633  | 
 2427  | 
 24.12  | 
 0  | 
 10277  | 
 563  | 
 2427  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_cancel_supplier_order  | 
 1713  | 
 543  | 
 1170  | 
 68.30  | 
 31  | 
 257018  | 
 24200  | 
 1170  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_cancel_write_off  | 
 25210  | 
 16459  | 
 8751  | 
 34.71  | 
 0  | 
 18970  | 
 171  | 
 8751  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_client_order  | 
 85516  | 
 85516  | 
 0  | 
 0.00  | 
 0  | 
 21591  | 
 537  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_customer_reserve  | 
 642912  | 
 642682  | 
 230  | 
 0.03  | 
 0  | 
 19968  | 
 210  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_fill_shopping_cart  | 
 129403  | 
 129129  | 
 274  | 
 0.21  | 
 0  | 
 12230  | 
 105  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_fill_shopping_cart_clo_res  | 
 642912  | 
 642682  | 
 230  | 
 0.03  | 
 0  | 
 11872  | 
 16  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_get_clo_for_invoice  | 
 12229  | 
 12225  | 
 4  | 
 0.03  | 
 0  | 
 10811  | 
 368  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_kill_cost_storno  | 
 33649  | 
 24240  | 
 9409  | 
 27.96  | 
 0  | 
 2184  | 
 19  | 
 9409  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 679295  | 
 421909  | 
 257386  | 
 37.89  | 
 0  | 
 15023  | 
 29  | 
 257386  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_kill_qty_storno  | 
 421089  | 
 286199  | 
 134890  | 
 32.03  | 
 0  | 
 28314  | 
 87  | 
 134886  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_lock_selected_doc  | 
 84678  | 
 73409  | 
 11269  | 
 13.30  | 
 0  | 
 1123  | 
 8  | 
 11265  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_make_cost_storno  | 
 104342  | 
 104338  | 
 4  | 
 0.00  | 
 0  | 
 30062  | 
 446  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_multiply_rows_for_pdistr  | 
 104342  | 
 104338  | 
 4  | 
 0.00  | 
 0  | 
 2698  | 
 55  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_multiply_rows_for_qdistr  | 
 85516  | 
 85516  | 
 0  | 
 0.00  | 
 0  | 
 16473  | 
 181  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_pay_from_customer  | 
 28330  | 
 28330  | 
 0  | 
 0.00  | 
 0  | 
 30201  | 
 967  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_pay_to_supplier  | 
 23564  | 
 23564  | 
 0  | 
 0.00  | 
 0  | 
 5788  | 
 688  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_payment_common  | 
 51894  | 
 51894  | 
 0  | 
 0.00  | 
 0  | 
 2918  | 
 63  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_qd_handle_on_cancel_clo  | 
 7145  | 
 6999  | 
 146  | 
 2.04  | 
 0  | 
 1919  | 
 120  | 
 146  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 16525  | 
 15709  | 
 816  | 
 4.93  | 
 0  | 
 28298  | 
 406  | 
 812  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 40219  | 
 40219  | 
 0  | 
 0.00  | 
 0  | 
 2964  | 
 55  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_reserve_write_off  | 
 40816  | 
 40219  | 
 597  | 
 1.46  | 
 0  | 
 30123  | 
 568  | 
 597  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_supplier_invoice  | 
 22084  | 
 21967  | 
 117  | 
 0.52  | 
 0  | 
 38626  | 
 3520  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  sp_supplier_order  | 
 21803  | 
 21646  | 
 157  | 
 0.72  | 
 0  | 
 20686  | 
 2376  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  srv_find_qd_qs_mism  | 
 1156375  | 
 1021662  | 
 134713  | 
 11.64  | 
 0  | 
 23150  | 
 32  | 
 134485  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  srv_make_invnt_saldo  | 
 1784  | 
 1784  | 
 0  | 
 0.00  | 
 0  | 
 32963  | 
 3196  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  srv_make_money_saldo  | 
 3770  | 
 3770  | 
 0  | 
 0.00  | 
 0  | 
 2418  | 
 63  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 1997  | 
 44179  | 
 16558  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 8290  | 
 8290  | 
 0  | 
 0.00  | 
 0  | 
 10093  | 
 100  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 782  | 
 782  | 
 0  | 
 0.00  | 
 0  | 
 2340  | 
 186  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_cancel_client_order  | 
 153  | 
 153  | 
 0  | 
 0.00  | 
 0  | 
 1185  | 
 122  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 37  | 
 37  | 
 0  | 
 0.00  | 
 0  | 
 733  | 
 92  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 22  | 
 22  | 
 0  | 
 0.00  | 
 0  | 
 359  | 
 84  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 4  | 
 4  | 
 0  | 
 0.00  | 
 0  | 
 125  | 
 54  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 718  | 
 718  | 
 0  | 
 0.00  | 
 0  | 
 1700  | 
 94  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 15547  | 
 15547  | 
 0  | 
 0.00  | 
 0  | 
 2948  | 
 133  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_cancel_write_off  | 
 27  | 
 27  | 
 0  | 
 0.00  | 
 0  | 
 234  | 
 66  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_reserve_write_off  | 
 597  | 
 597  | 
 0  | 
 0.00  | 
 0  | 
 1435  | 
 85  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_supplier_invoice  | 
 117  | 
 117  | 
 0  | 
 0.00  | 
 0  | 
 999  | 
 127  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-abend:sp_supplier_order  | 
 157  | 
 157  | 
 0  | 
 0.00  | 
 0  | 
 827  | 
 75  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 12225  | 
 12225  | 
 0  | 
 0.00  | 
 0  | 
 15428  | 
 704  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1455  | 
 1455  | 
 0  | 
 0.00  | 
 0  | 
 15912  | 
 764  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6999  | 
 6999  | 
 0  | 
 0.00  | 
 0  | 
 1950  | 
 69  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2779  | 
 2779  | 
 0  | 
 0.00  | 
 0  | 
 2028  | 
 70  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2577  | 
 2577  | 
 0  | 
 0.00  | 
 0  | 
 1857  | 
 55  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1720  | 
 1720  | 
 0  | 
 0.00  | 
 0  | 
 1341  | 
 47  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 1026  | 
 1026  | 
 0  | 
 0.00  | 
 0  | 
 1326  | 
 86  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 543  | 
 543  | 
 0  | 
 0.00  | 
 0  | 
 84209  | 
 2122  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3866  | 
 3866  | 
 0  | 
 0.00  | 
 0  | 
 2044  | 
 71  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_client_order  | 
 85516  | 
 85516  | 
 0  | 
 0.00  | 
 0  | 
 8580  | 
 81  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_customer_reserve  | 
 4065  | 
 4065  | 
 0  | 
 0.00  | 
 0  | 
 1778  | 
 57  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_pay_from_customer  | 
 28330  | 
 28330  | 
 0  | 
 0.00  | 
 0  | 
 2480  | 
 72  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 23564  | 
 23564  | 
 0  | 
 0.00  | 
 0  | 
 2277  | 
 66  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_reserve_write_off  | 
 40219  | 
 40219  | 
 0  | 
 0.00  | 
 0  | 
 10811  | 
 77  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_supplier_invoice  | 
 21967  | 
 21967  | 
 0  | 
 0.00  | 
 0  | 
 1981  | 
 75  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:sp_supplier_order  | 
 21646  | 
 21646  | 
 0  | 
 0.00  | 
 0  | 
 1935  | 
 78  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1784  | 
 1784  | 
 0  | 
 0.00  | 
 0  | 
 1029  | 
 26  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:srv_make_money_saldo  | 
 3770  | 
 3770  | 
 0  | 
 0.00  | 
 0  | 
 1154  | 
 25  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 359  | 
 68  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_add_invoice_to_stock  | 
 40976  | 
 24450  | 
 16526  | 
 40.33  | 
 0  | 
 13962  | 
 70  | 
 16518  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_all_customers  | 
 128254  | 
 128254  | 
 0  | 
 0.00  | 
 0  | 
 749  | 
 6  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_all_suppliers  | 
 88408  | 
 87860  | 
 548  | 
 0.61  | 
 0  | 
 921  | 
 6  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_all_wares  | 
 171032  | 
 171032  | 
 0  | 
 0.00  | 
 0  | 
 1295  | 
 5  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_cancel_adding_invoice  | 
 3466  | 
 2910  | 
 556  | 
 16.04  | 
 0  | 
 3432  | 
 179  | 
 556  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_cancel_client_order  | 
 14304  | 
 13998  | 
 306  | 
 2.13  | 
 0  | 
 874  | 
 7  | 
 306  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_cancel_customer_prepayment  | 
 5198  | 
 5154  | 
 44  | 
 0.84  | 
 0  | 
 15459  | 
 12  | 
 44  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_cancel_customer_reserve  | 
 5632  | 
 5558  | 
 74  | 
 1.31  | 
 0  | 
 874  | 
 10  | 
 74  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_cancel_payment_to_supplier  | 
 3448  | 
 3440  | 
 8  | 
 0.23  | 
 0  | 
 968  | 
 10  | 
 8  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_cancel_supplier_invoice  | 
 3488  | 
 2052  | 
 1436  | 
 41.16  | 
 0  | 
 1124  | 
 68  | 
 1436  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_cancel_supplier_order  | 
 3426  | 
 1086  | 
 2340  | 
 68.30  | 
 0  | 
 1014  | 
 11  | 
 2340  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_cancel_write_off  | 
 7786  | 
 7732  | 
 54  | 
 0.69  | 
 0  | 
 2325  | 
 113  | 
 54  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_max_id_clo_ord  | 
 21803  | 
 21646  | 
 157  | 
 0.72  | 
 0  | 
 1092  | 
 6  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_max_id_clo_res  | 
 4065  | 
 4065  | 
 0  | 
 0.00  | 
 0  | 
 983  | 
 19  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_max_id_ord_sup  | 
 22084  | 
 21967  | 
 117  | 
 0.52  | 
 0  | 
 1123  | 
 6  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_max_non_paid_invoice  | 
 23247  | 
 23247  | 
 0  | 
 0.00  | 
 0  | 
 421  | 
 6  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_max_non_paid_realizn  | 
 28330  | 
 28330  | 
 0  | 
 0.00  | 
 0  | 
 967  | 
 6  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_min_id_clo_ord  | 
 21803  | 
 21646  | 
 157  | 
 0.72  | 
 0  | 
 5054  | 
 8  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_min_id_clo_res  | 
 4065  | 
 4065  | 
 0  | 
 0.00  | 
 0  | 
 1123  | 
 9  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_min_id_ord_sup  | 
 22084  | 
 21967  | 
 117  | 
 0.52  | 
 0  | 
 1185  | 
 8  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_min_non_paid_invoice  | 
 23564  | 
 23564  | 
 0  | 
 0.00  | 
 0  | 
 936  | 
 7  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_min_non_paid_realizn  | 
 28330  | 
 28330  | 
 0  | 
 0.00  | 
 0  | 
 437  | 
 6  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_our_firm  | 
 42778  | 
 42778  | 
 0  | 
 0.00  | 
 0  | 
 811  | 
 6  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  v_reserve_write_off  | 
 81632  | 
 80438  | 
 1194  | 
 1.46  | 
 0  | 
 2870  | 
 9  | 
 1194  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  x_lock_depdocs_on_canc_invoice  | 
 19298  | 
 10091  | 
 9207  | 
 47.70  | 
 0  | 
 1872  | 
 38  | 
 9207  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1712  | 
 543  | 
 1169  | 
 68.28  | 
 0  | 
 1435  | 
 62  | 
 1169  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  x_make_qstorno_1000_1200  | 
 21803  | 
 21646  | 
 157  | 
 0.72  | 
 0  | 
 20390  | 
 2145  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  x_make_qstorno_1200_2000  | 
 22084  | 
 21967  | 
 117  | 
 0.52  | 
 0  | 
 38064  | 
 3282  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  x_make_qstorno_2100_3300  | 
 642915  | 
 642682  | 
 233  | 
 0.03  | 
 0  | 
 19937  | 
 175  | 
 0  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
 
Done for 452830 ms, from 11:41:38.16 to 11:49:10.99.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 100  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2017-04-12 08:18  | 
 2017-04-12 11:17  | 
|  deadlock  | 
 106  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2017-04-12 08:22  | 
 2017-04-12 11:16  | 
|  deadlock  | 
 1794  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  deadlock  | 
 146  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2017-04-12 08:20  | 
 2017-04-12 11:15  | 
|  deadlock  | 
 170  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2017-04-12 08:18  | 
 2017-04-12 11:17  | 
|  deadlock  | 
 45  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2017-04-12 08:24  | 
 2017-04-12 11:01  | 
|  deadlock  | 
 9  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2017-04-12 08:34  | 
 2017-04-12 10:53  | 
|  user_exc  | 
 157  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2017-04-12 08:21  | 
 2017-04-12 11:15  | 
|  user_exc  | 
 117  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2017-04-12 08:19  | 
 2017-04-12 11:13  | 
|  user_exc  | 
 4  | 
 x_make_qstorno_2100_3300  | 
 335544517  | 
 2017-04-12 11:18  | 
 2017-04-12 11:18  | 
|  concurrent_transaction  | 
 7870  | 
 sp_lock_selected_doc  | 
 335544878  | 
 2017-04-12 08:18  | 
 2017-04-12 11:18  | 
|  concurrent_transaction  | 
 704  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544878  | 
 2017-04-12 08:19  | 
 2017-04-12 11:18  | 
|  concurrent_transaction  | 
 318  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544878  | 
 2017-04-12 08:20  | 
 2017-04-12 11:17  | 
 
Done for 13290 ms, from 11:49:22.10 to 11:49:35.39.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP40-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   13
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          447737
 
MON$OLDEST_ACTIVE               447738
 
MON$OLDEST_SNAPSHOT             447738
 
MON$NEXT_TRANSACTION            447738
 
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               2017-01-11 15:15:54.2050
 
MON$PAGES                       869088
 
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.585 Firebird 4.0 Unstable
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.585 Firebird 4.0 Unstable"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.585 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.585 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
 
on disk structure version 13.0 
 
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		447798 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		13.0 
 
Oldest transaction	447739 
 
Oldest active		447740 
 
Oldest snapshot		447740 
 
Next transaction	447741 
 
Sequence number		0 
 
Next attachment ID	9403 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Jan 11, 2017 15:15:54 
 
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: 314, Index root page: 315 
 
Total formats: 1, used formats: 1 
 
Average record length: 33.50, 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.27 
 
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: 325, 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: 327, 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: 326, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 43 
 
Average key length: 2.04, compression ratio: 0.55 
 
Average prefix length: 1.06, 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: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.32, total dup: 0, max dup: 0 
 
Average key length: 15.94, compression ratio: 0.91 
 
Average prefix length: 1.20, average data length: 13.32 
 
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: 323, 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: 335, Index root page: 336 
 
Total formats: 1, used formats: 1 
 
Average record length: 107.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: 1236.00, compression ratio: 11.55 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 29% 
 
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: 339, 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: 340, 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: 338, 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: 254, Index root page: 255 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.16, total records: 2205174 
 
Average version length: 47.66, total versions: 3008, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.36 
 
Pointer pages: 15, data page slots: 23968 
 
Data pages: 23968, average fill: 72% 
 
Primary pages: 23968, secondary pages: 0, swept pages: 14576 
 
Empty pages: 2, full pages: 19674 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 11 
 
40 - 59% = 108 
 
60 - 79% = 23845 
 
80 - 99% = 1 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26714, depth: 3, leaf buckets: 10773, nodes: 2205174 
 
Average node length: 19.37, total dup: 0, max dup: 0 
 
Average key length: 16.41, compression ratio: 1.65 
 
Average prefix length: 13.59, average data length: 13.41 
 
Clustering factor: 510205, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 712 
 
20 - 39% = 2246 
 
40 - 59% = 5357 
 
60 - 79% = 1119 
 
80 - 99% = 1339 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 46473, depth: 3, leaf buckets: 7897, nodes: 2205174 
 
Average node length: 11.63, 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: 477492, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 3703 
 
40 - 59% = 4122 
 
60 - 79% = 63 
 
80 - 99% = 8 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 174878, depth: 3, leaf buckets: 3937, nodes: 2205174 
 
Average node length: 6.85, total dup: 1595538, max dup: 49 
 
Average key length: 3.89, compression ratio: 2.31 
 
Average prefix length: 7.38, average data length: 1.62 
 
Clustering factor: 469948, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 141 
 
20 - 39% = 1292 
 
40 - 59% = 1775 
 
60 - 79% = 233 
 
80 - 99% = 496 
 
 
DOC_LIST (140) 
 
Primary pointer page: 249, Index root page: 250 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.42, total records: 677280 
 
Average version length: 61.30, total versions: 1026, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 6, data page slots: 8600 
 
Data pages: 8600, average fill: 75% 
 
Primary pages: 8598, secondary pages: 2, swept pages: 7870 
 
Empty pages: 4, full pages: 7636 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 11 
 
40 - 59% = 41 
 
60 - 79% = 8517 
 
80 - 99% = 26 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 251363, depth: 3, leaf buckets: 2511, nodes: 677280 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.19, average data length: 5.81 
 
Clustering factor: 170400, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1421 
 
40 - 59% = 1051 
 
60 - 79% = 35 
 
80 - 99% = 4 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2940, depth: 2, leaf buckets: 717, nodes: 677280 
 
Average node length: 4.88, total dup: 677230, max dup: 35877 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 308029, ratio: 0.45 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 606 
 
60 - 79% = 96 
 
80 - 99% = 15 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 320717, depth: 3, leaf buckets: 2131, nodes: 677280 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.80, compression ratio: 1.02 
 
Average prefix length: 3.19, average data length: 5.81 
 
Clustering factor: 170400, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 148 
 
20 - 39% = 724 
 
40 - 59% = 830 
 
60 - 79% = 190 
 
80 - 99% = 239 
 
 
DOC_STATES (153) 
 
Primary pointer page: 312, Index root page: 313 
 
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: 321, 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: 322, 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: 320, 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: 341, Index root page: 342 
 
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: 343, 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: 273, Index root page: 274 
 
Total formats: 1, used formats: 1 
 
Average record length: 66.25, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 18.60, total fragments: 382, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.57 
 
Pointer pages: 1, data page slots: 1208 
 
Data pages: 20, average fill: 32% 
 
Primary pages: 6, secondary pages: 14, swept pages: 4 
 
Empty pages: 8, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 5 
 
40 - 59% = 2 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 285, 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: 303, ratio: 0.76 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 333, Index root page: 334 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.12, total records: 4482 
 
Average version length: 71.18, total versions: 2775, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 3.54 
 
Pointer pages: 2, data page slots: 1048 
 
Data pages: 496, average fill: 14% 
 
Primary pages: 496, secondary pages: 0, swept pages: 222 
 
Empty pages: 83, full pages: 6 
 
Fill distribution: 
 
0 - 19% = 353 
 
20 - 39% = 108 
 
40 - 59% = 26 
 
60 - 79% = 5 
 
80 - 99% = 4 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1481, depth: 2, leaf buckets: 21, nodes: 4482 
 
Average node length: 15.20, total dup: 152, max dup: 1 
 
Average key length: 13.20, compression ratio: 2.05 
 
Average prefix length: 16.76, average data length: 10.24 
 
Clustering factor: 4175, ratio: 0.93 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 11 
 
40 - 59% = 6 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 265, Index root page: 266 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.02, total records: 49 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.13 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 20% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 276, 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: 263, Index root page: 264 
 
Total formats: 1, used formats: 1 
 
Average record length: 36.30, total records: 167 
 
Average version length: 48.42, total versions: 33, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.76 
 
Pointer pages: 1, data page slots: 56 
 
Data pages: 32, average fill: 7% 
 
Primary pages: 31, secondary pages: 1, swept pages: 23 
 
Empty pages: 16, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 29 
 
20 - 39% = 2 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 301505, depth: 2, leaf buckets: 1, nodes: 167 
 
Average node length: 8.31, total dup: 121, max dup: 20 
 
Average key length: 6.30, compression ratio: 3.02 
 
Average prefix length: 14.97, average data length: 4.03 
 
Clustering factor: 96, ratio: 0.57 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (165) 
 
Primary pointer page: 356, Index root page: 357 
 
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_DTS (4) 
 
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_GDSCODE (2) 
 
Root page: 365, 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: 364, 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: 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 
 
 
Index PK_MON_LOG (0) 
 
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 
 
 
MON_LOG_TABLE_STATS (166) 
 
Primary pointer page: 369, Index root page: 370 
 
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: 376, 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: 374, 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: 373, 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: 375, 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: 372, 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: 241, Index root page: 242 
 
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: 244, 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: 243, 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: 296, Index root page: 297 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.82, total records: 840228 
 
Average version length: 42.77, total versions: 1694, max versions: 5 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 3.40 
 
Pointer pages: 4, data page slots: 5136 
 
Data pages: 5136, average fill: 73% 
 
Primary pages: 5127, secondary pages: 9, swept pages: 4680 
 
Empty pages: 9, full pages: 4244 
 
Fill distribution: 
 
0 - 19% = 29 
 
20 - 39% = 112 
 
40 - 59% = 211 
 
60 - 79% = 4390 
 
80 - 99% = 394 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 3976, depth: 2, leaf buckets: 269, nodes: 247577 
 
Average node length: 4.91, total dup: 247528, max dup: 11180 
 
Average key length: 2.01, compression ratio: 4.47 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 35152, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 31 
 
40 - 59% = 162 
 
60 - 79% = 60 
 
80 - 99% = 16 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 3600, depth: 2, leaf buckets: 283, nodes: 247577 
 
Average node length: 5.86, total dup: 223022, max dup: 54 
 
Average key length: 2.96, compression ratio: 7.43 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 39402, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 17 
 
40 - 59% = 108 
 
60 - 79% = 102 
 
80 - 99% = 54 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 3602, depth: 2, leaf buckets: 280, nodes: 247577 
 
Average node length: 5.86, total dup: 223022, max dup: 54 
 
Average key length: 2.96, compression ratio: 7.44 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 39452, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 14 
 
40 - 59% = 104 
 
60 - 79% = 107 
 
80 - 99% = 55 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 3001, depth: 2, leaf buckets: 287, nodes: 247577 
 
Average node length: 5.64, total dup: 223022, max dup: 54 
 
Average key length: 2.74, compression ratio: 3.28 
 
Average prefix length: 8.35, average data length: 0.65 
 
Clustering factor: 39552, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 13 
 
40 - 59% = 143 
 
60 - 79% = 84 
 
80 - 99% = 42 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.95, total records: 284804 
 
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: 2440 
 
Data pages: 2440, average fill: 64% 
 
Primary pages: 2440, secondary pages: 0, swept pages: 0 
 
Empty pages: 6, full pages: 2433 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 2433 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 201886, depth: 2, leaf buckets: 233, nodes: 284804 
 
Average node length: 4.55, total dup: 284623, max dup: 2404 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.57, average data length: 0.00 
 
Clustering factor: 63408, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 102 
 
60 - 79% = 69 
 
80 - 99% = 61 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 347, Index root page: 348 
 
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: 349, 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 (163) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 1, used formats: 1 
 
Average record length: 151.81, total records: 11919489 
 
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: 1696.00, compression ratio: 11.17 
 
Pointer pages: 174, data page slots: 282864 
 
Data pages: 282864, average fill: 87% 
 
Primary pages: 282864, secondary pages: 0, swept pages: 3 
 
Empty pages: 3, full pages: 282860 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 282860 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 61748, depth: 3, leaf buckets: 13230, nodes: 11919489 
 
Average node length: 5.68, total dup: 11029366, max dup: 161 
 
Average key length: 2.18, compression ratio: 3.66 
 
Average prefix length: 7.86, average data length: 0.13 
 
Clustering factor: 4980804, ratio: 0.42 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 0 
 
40 - 59% = 6793 
 
60 - 79% = 4282 
 
80 - 99% = 2148 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163282, depth: 3, leaf buckets: 11818, nodes: 11919489 
 
Average node length: 4.58, total dup: 11919484, max dup: 10918905 
 
Average key length: 1.08, compression ratio: 0.39 
 
Average prefix length: 0.42, average data length: 0.00 
 
Clustering factor: 359998, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 11789 
 
60 - 79% = 2 
 
80 - 99% = 27 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 42827, depth: 3, leaf buckets: 14302, nodes: 11919489 
 
Average node length: 5.73, total dup: 11541040, max dup: 20143 
 
Average key length: 2.24, compression ratio: 4.03 
 
Average prefix length: 8.80, average data length: 0.20 
 
Clustering factor: 1079677, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 2 
 
40 - 59% = 10192 
 
60 - 79% = 2228 
 
80 - 99% = 1878 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77433, depth: 3, leaf buckets: 14523, nodes: 11919489 
 
Average node length: 5.57, total dup: 11886740, max dup: 1484591 
 
Average key length: 2.07, compression ratio: 18.22 
 
Average prefix length: 37.72, average data length: 0.07 
 
Clustering factor: 7080012, ratio: 0.59 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 1 
 
40 - 59% = 12510 
 
60 - 79% = 592 
 
80 - 99% = 1405 
 
 
PHRASES (145) 
 
Primary pointer page: 269, Index root page: 270 
 
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: 283, 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: 282, 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: 281, 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: 280, 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: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.99, total records: 441542 
 
Average version length: 55.68, total versions: 1083, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.45 
 
Pointer pages: 4, data page slots: 5304 
 
Data pages: 5304, average fill: 74% 
 
Primary pages: 5304, secondary pages: 0, swept pages: 4138 
 
Empty pages: 4, full pages: 4424 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 7 
 
40 - 59% = 59 
 
60 - 79% = 5227 
 
80 - 99% = 3 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 640941, depth: 3, leaf buckets: 602, nodes: 441542 
 
Average node length: 5.97, total dup: 369474, max dup: 735 
 
Average key length: 3.18, compression ratio: 2.83 
 
Average prefix length: 7.98, average data length: 1.02 
 
Clustering factor: 56247, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 29 
 
40 - 59% = 398 
 
60 - 79% = 140 
 
80 - 99% = 27 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2643, depth: 2, leaf buckets: 466, nodes: 441542 
 
Average node length: 5.59, total dup: 394084, max dup: 112 
 
Average key length: 2.80, compression ratio: 3.21 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 106426, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 6 
 
40 - 59% = 189 
 
60 - 79% = 180 
 
80 - 99% = 90 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 305, Index root page: 306 
 
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: 310, 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: 245, Index root page: 246 
 
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: 248, 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: 247, 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: 318, Index root page: 319 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 3% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 330, 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: 331, 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: 238, Index root page: 239 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.31, 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: 80% 
 
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: 240, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.11, total dup: 0, max dup: 0 
 
Average key length: 26.10, compression ratio: 1.70 
 
Average prefix length: 21.18, average data length: 23.11 
 
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: 236, Index root page: 237 
 
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: 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$DEP_DOCS (129) 
 
Primary pointer page: 216, Index root page: 217 
 
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: 218, 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: 226, Index root page: 227 
 
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: 229, 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: 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$MON_LOG_TABLE_STATS (134) 
 
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$PERF_LOG (164) 
 
Primary pointer page: 354, Index root page: 355 
 
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$PERF_LOG_UNIT_TRN_DTS_END (0) 
 
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 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 224, Index root page: 225 
 
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: 219, Index root page: 220 
 
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: 222, 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: 221, 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: 211, Index root page: 212 
 
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: 215, 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 (162) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 1, used formats: 1 
 
Average record length: 57.86, total records: 2982 
 
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: 6.50 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 68% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 3, full pages: 36 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 36 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 267, Index root page: 268 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.71, 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.77 
 
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: 380, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 65 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 47, 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: 277, 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: 333, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 279, 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: 333, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400 
 
Average node length: 52.81, total dup: 0, max dup: 0 
 
Average key length: 51.79, compression ratio: 1.00 
 
Average prefix length: 2.72, average data length: 48.81 
 
Clustering factor: 342, ratio: 0.85 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 316, Index root page: 317 
 
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: 328, 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: 329, 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 (260) 
 
Primary pointer page: 298, Index root page: 307 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.01, total records: 8868 
 
Average version length: 72.25, total versions: 3706, 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: 2, data page slots: 1496 
 
Data pages: 641, average fill: 18% 
 
Primary pages: 640, secondary pages: 1, swept pages: 429 
 
Empty pages: 276, full pages: 44 
 
Fill distribution: 
 
0 - 19% = 430 
 
20 - 39% = 98 
 
40 - 59% = 50 
 
60 - 79% = 56 
 
80 - 99% = 7 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1583, depth: 2, leaf buckets: 18, nodes: 8868 
 
Average node length: 6.47, total dup: 7688, max dup: 14 
 
Average key length: 4.37, compression ratio: 8.48 
 
Average prefix length: 34.77, average data length: 2.23 
 
Clustering factor: 1458, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 11 
 
40 - 59% = 4 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 782, Index root page: 783 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.45, total records: 1276104 
 
Average version length: 71.95, total versions: 12775, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.90 
 
Pointer pages: 12, data page slots: 19472 
 
Data pages: 19424, average fill: 72% 
 
Primary pages: 19424, secondary pages: 0, swept pages: 12216 
 
Empty pages: 75, full pages: 14577 
 
Fill distribution: 
 
0 - 19% = 245 
 
20 - 39% = 321 
 
40 - 59% = 1138 
 
60 - 79% = 17605 
 
80 - 99% = 115 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 391077, depth: 3, leaf buckets: 1493, nodes: 1276104 
 
Average node length: 5.13, total dup: 1243320, max dup: 121 
 
Average key length: 2.19, compression ratio: 4.11 
 
Average prefix length: 8.84, average data length: 0.16 
 
Clustering factor: 151591, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 93 
 
40 - 59% = 1148 
 
60 - 79% = 58 
 
80 - 99% = 176 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 237889, depth: 3, leaf buckets: 1875, nodes: 1276104 
 
Average node length: 6.26, total dup: 1114784, max dup: 23 
 
Average key length: 3.32, compression ratio: 11.16 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 250197, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 180 
 
40 - 59% = 1461 
 
60 - 79% = 137 
 
80 - 99% = 81 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 777, Index root page: 778 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.89, total records: 86757 
 
Average version length: 71.78, total versions: 3215, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 8.56 
 
Pointer pages: 4, data page slots: 4960 
 
Data pages: 4520, average fill: 10% 
 
Primary pages: 4517, secondary pages: 3, swept pages: 3801 
 
Empty pages: 1221, full pages: 59 
 
Fill distribution: 
 
0 - 19% = 3883 
 
20 - 39% = 407 
 
40 - 59% = 136 
 
60 - 79% = 76 
 
80 - 99% = 18 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1052, depth: 2, leaf buckets: 27, nodes: 13141 
 
Average node length: 6.49, total dup: 11670, max dup: 49 
 
Average key length: 3.82, compression ratio: 9.69 
 
Average prefix length: 35.29, average data length: 1.71 
 
Clustering factor: 1653, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 14 
 
40 - 59% = 9 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 786, Index root page: 787 
 
Total formats: 1, used formats: 1 
 
Average record length: 53.67, total records: 2441755 
 
Average version length: 71.67, total versions: 44766, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.53 
 
Pointer pages: 21, data page slots: 32744 
 
Data pages: 32728, average fill: 67% 
 
Primary pages: 32728, secondary pages: 0, swept pages: 17963 
 
Empty pages: 212, full pages: 23143 
 
Fill distribution: 
 
0 - 19% = 474 
 
20 - 39% = 3439 
 
40 - 59% = 4038 
 
60 - 79% = 22104 
 
80 - 99% = 2673 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 188113, depth: 3, leaf buckets: 2778, nodes: 1777104 
 
Average node length: 5.64, total dup: 1669457, max dup: 71 
 
Average key length: 2.66, compression ratio: 13.90 
 
Average prefix length: 36.40, average data length: 0.60 
 
Clustering factor: 242389, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 1200 
 
40 - 59% = 1136 
 
60 - 79% = 288 
 
80 - 99% = 142 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 789, Index root page: 790 
 
Total formats: 1, used formats: 1 
 
Average record length: 9.04, total records: 3952143 
 
Average version length: 69.82, total versions: 1741, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 15.05 
 
Pointer pages: 16, data page slots: 24888 
 
Data pages: 24744, average fill: 51% 
 
Primary pages: 24744, secondary pages: 0, swept pages: 9184 
 
Empty pages: 47, full pages: 23518 
 
Fill distribution: 
 
0 - 19% = 272 
 
20 - 39% = 7482 
 
40 - 59% = 6473 
 
60 - 79% = 10457 
 
80 - 99% = 60 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1684, depth: 2, leaf buckets: 14, nodes: 4456 
 
Average node length: 9.89, total dup: 3190, max dup: 38 
 
Average key length: 6.88, compression ratio: 5.37 
 
Average prefix length: 32.40, average data length: 4.60 
 
Clustering factor: 996, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 8 
 
40 - 59% = 5 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 801, Index root page: 802 
 
Total formats: 1, used formats: 1 
 
Average record length: 62.69, total records: 3199324 
 
Average version length: 71.20, total versions: 16974, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.17 
 
Pointer pages: 26, data page slots: 41824 
 
Data pages: 41824, average fill: 75% 
 
Primary pages: 41824, secondary pages: 0, swept pages: 30423 
 
Empty pages: 22, full pages: 36609 
 
Fill distribution: 
 
0 - 19% = 62 
 
20 - 39% = 301 
 
40 - 59% = 1094 
 
60 - 79% = 38211 
 
80 - 99% = 2156 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 37222, depth: 3, leaf buckets: 5721, nodes: 2763886 
 
Average node length: 6.90, total dup: 2232779, max dup: 16 
 
Average key length: 3.92, compression ratio: 9.44 
 
Average prefix length: 35.27, average data length: 1.73 
 
Clustering factor: 548861, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 2998 
 
40 - 59% = 2299 
 
60 - 79% = 256 
 
80 - 99% = 158 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 805, Index root page: 806 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.90, total records: 4845545 
 
Average version length: 84.46, total versions: 1755, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.62 
 
Pointer pages: 46, data page slots: 74624 
 
Data pages: 74624, average fill: 80% 
 
Primary pages: 74624, secondary pages: 0, swept pages: 28721 
 
Empty pages: 10, full pages: 73986 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 8 
 
40 - 59% = 28 
 
60 - 79% = 21966 
 
80 - 99% = 52608 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 55157, depth: 3, leaf buckets: 4927, nodes: 4845545 
 
Average node length: 5.16, total dup: 4735120, max dup: 124 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 790335, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 118 
 
40 - 59% = 2174 
 
60 - 79% = 1926 
 
80 - 99% = 691 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 83992, depth: 3, leaf buckets: 5553, nodes: 4845545 
 
Average node length: 5.69, total dup: 4341995, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.33 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 285855, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 45 
 
20 - 39% = 193 
 
40 - 59% = 3487 
 
60 - 79% = 333 
 
80 - 99% = 1495 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 48960, depth: 3, leaf buckets: 5493, nodes: 4845545 
 
Average node length: 5.81, total dup: 4239664, max dup: 26 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 847153, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 28 
 
20 - 39% = 125 
 
40 - 59% = 2433 
 
60 - 79% = 1970 
 
80 - 99% = 937 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 815, Index root page: 816 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.01, total records: 2379877 
 
Average version length: 83.66, total versions: 11667, 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: 24, data page slots: 37744 
 
Data pages: 37744, average fill: 78% 
 
Primary pages: 37744, secondary pages: 0, swept pages: 28272 
 
Empty pages: 36, full pages: 34330 
 
Fill distribution: 
 
0 - 19% = 105 
 
20 - 39% = 216 
 
40 - 59% = 721 
 
60 - 79% = 17117 
 
80 - 99% = 19585 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 76716, depth: 3, leaf buckets: 2552, nodes: 2379877 
 
Average node length: 5.15, total dup: 2324038, max dup: 173 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 388528, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 44 
 
40 - 59% = 1505 
 
60 - 79% = 745 
 
80 - 99% = 255 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 110552, depth: 3, leaf buckets: 4192, nodes: 2379877 
 
Average node length: 6.24, total dup: 1946962, max dup: 14 
 
Average key length: 3.27, compression ratio: 2.75 
 
Average prefix length: 7.91, average data length: 1.09 
 
Clustering factor: 255412, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 121 
 
20 - 39% = 1791 
 
40 - 59% = 1625 
 
60 - 79% = 449 
 
80 - 99% = 206 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 66178, depth: 3, leaf buckets: 2912, nodes: 2379877 
 
Average node length: 5.81, total dup: 2081481, max dup: 36 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 460747, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 60 
 
40 - 59% = 1765 
 
60 - 79% = 812 
 
80 - 99% = 262 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 810, Index root page: 811 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.71, total records: 5159625 
 
Average version length: 85.29, total versions: 20071, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.62 
 
Pointer pages: 50, data page slots: 80632 
 
Data pages: 80600, average fill: 79% 
 
Primary pages: 80600, secondary pages: 0, swept pages: 25325 
 
Empty pages: 141, full pages: 76421 
 
Fill distribution: 
 
0 - 19% = 225 
 
20 - 39% = 377 
 
40 - 59% = 1209 
 
60 - 79% = 19128 
 
80 - 99% = 59661 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 58219, depth: 3, leaf buckets: 5517, nodes: 5159625 
 
Average node length: 5.04, total dup: 5129724, max dup: 669 
 
Average key length: 2.05, compression ratio: 4.39 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 789365, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 295 
 
40 - 59% = 3235 
 
60 - 79% = 1449 
 
80 - 99% = 532 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 84200, depth: 3, leaf buckets: 6463, nodes: 5159625 
 
Average node length: 5.53, total dup: 4751543, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.54 
 
Average prefix length: 8.54, average data length: 0.46 
 
Clustering factor: 328389, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 81 
 
20 - 39% = 1769 
 
40 - 59% = 2768 
 
60 - 79% = 618 
 
80 - 99% = 1227 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 50796, depth: 3, leaf buckets: 6210, nodes: 5159625 
 
Average node length: 5.68, total dup: 4633748, max dup: 87 
 
Average key length: 2.69, compression ratio: 3.34 
 
Average prefix length: 8.41, average data length: 0.59 
 
Clustering factor: 872872, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 253 
 
40 - 59% = 3702 
 
60 - 79% = 1655 
 
80 - 99% = 595 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 821, Index root page: 822 
 
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: 823, 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: 825, 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: 824, 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 (270) 
 
Primary pointer page: 826, Index root page: 827 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.42, total records: 3417513 
 
Average version length: 83.95, total versions: 13012, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 34, data page slots: 54152 
 
Data pages: 54152, average fill: 78% 
 
Primary pages: 54152, secondary pages: 0, swept pages: 39314 
 
Empty pages: 32, full pages: 49456 
 
Fill distribution: 
 
0 - 19% = 106 
 
20 - 39% = 241 
 
40 - 59% = 880 
 
60 - 79% = 23494 
 
80 - 99% = 29431 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 92352, depth: 3, leaf buckets: 3706, nodes: 3417513 
 
Average node length: 5.03, total dup: 3400346, max dup: 1211 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 746937, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 367 
 
40 - 59% = 2021 
 
60 - 79% = 888 
 
80 - 99% = 416 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 110525, depth: 3, leaf buckets: 6121, nodes: 3417513 
 
Average node length: 6.26, total dup: 2790669, max dup: 14 
 
Average key length: 3.28, compression ratio: 2.74 
 
Average prefix length: 7.90, average data length: 1.10 
 
Clustering factor: 417099, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 219 
 
20 - 39% = 2693 
 
40 - 59% = 2276 
 
60 - 79% = 620 
 
80 - 99% = 313 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77842, depth: 3, leaf buckets: 4044, nodes: 3417513 
 
Average node length: 5.60, total dup: 3113676, max dup: 81 
 
Average key length: 2.62, compression ratio: 3.44 
 
Average prefix length: 8.47, average data length: 0.53 
 
Clustering factor: 788203, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 356 
 
40 - 59% = 2058 
 
60 - 79% = 1097 
 
80 - 99% = 520 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 831, Index root page: 832 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.31, total records: 659530 
 
Average version length: 69.48, total versions: 1941, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.96 
 
Pointer pages: 6, data page slots: 9248 
 
Data pages: 9248, average fill: 76% 
 
Primary pages: 9248, secondary pages: 0, swept pages: 7267 
 
Empty pages: 10, full pages: 8477 
 
Fill distribution: 
 
0 - 19% = 35 
 
20 - 39% = 91 
 
40 - 59% = 229 
 
60 - 79% = 8850 
 
80 - 99% = 43 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 248310, depth: 3, leaf buckets: 788, nodes: 659530 
 
Average node length: 5.34, total dup: 620235, max dup: 113 
 
Average key length: 2.45, compression ratio: 3.67 
 
Average prefix length: 8.61, average data length: 0.39 
 
Clustering factor: 57301, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 138 
 
40 - 59% = 349 
 
60 - 79% = 212 
 
80 - 99% = 82 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 163039, depth: 3, leaf buckets: 873, nodes: 659530 
 
Average node length: 5.94, total dup: 562632, max dup: 21 
 
Average key length: 3.06, compression ratio: 2.94 
 
Average prefix length: 8.09, average data length: 0.91 
 
Clustering factor: 63377, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 175 
 
40 - 59% = 362 
 
60 - 79% = 229 
 
80 - 99% = 104 
 
 
ZDOC_DATA (230) 
 
Primary pointer page: 674, Index root page: 675 
 
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 (229) 
 
Primary pointer page: 672, Index root page: 673 
 
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 (231) 
 
Primary pointer page: 676, Index root page: 677 
 
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 (234) 
 
Primary pointer page: 682, Index root page: 683 
 
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: 692, 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 (235) 
 
Primary pointer page: 684, Index root page: 685 
 
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: 693, 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 (232) 
 
Primary pointer page: 678, Index root page: 679 
 
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: 686, 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: 687, 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 (233) 
 
Primary pointer page: 680, Index root page: 681 
 
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: 689, 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: 688, 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: 691, 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: 690, 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 (228) 
 
Primary pointer page: 622, Index root page: 623 
 
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 (227) 
 
Primary pointer page: 620, Index root page: 621 
 
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: 271, Index root page: 272 
 
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: 284, 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 90310 ms, from 11:49:35.93 to 11:51:06.24. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2205174  | 
 3008  | 
 0.1364  | 
|  DOC_LIST  | 
 677280  | 
 1026  | 
 0.1514  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 4482  | 
 2775  | 
 61.9143  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 167  | 
 33  | 
 19.7604  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 840228  | 
 1694  | 
 0.2016  | 
|  PERF_ESTIMATED  | 
 284804  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 11919489  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 441542  | 
 1083  | 
 0.2452  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 0  | 
 0.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  TRACE_STAT  | 
 2982  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 8868  | 
 3706  | 
 41.7907  | 
|  XQD_1000_3300  | 
 1276104  | 
 12775  | 
 1.0010  | 
|  XQD_1200_2000  | 
 86757  | 
 3215  | 
 3.7057  | 
|  XQD_2000_3300  | 
 2441755  | 
 44766  | 
 1.8333  | 
|  XQD_2100_3300  | 
 3952143  | 
 1741  | 
 0.0440  | 
|  XQD_3300_3400  | 
 3199324  | 
 16974  | 
 0.5305  | 
|  XQS_1000_1200  | 
 4845545  | 
 1755  | 
 0.0362  | 
|  XQS_1000_3300  | 
 2379877  | 
 11667  | 
 0.4902  | 
|  XQS_1200_2000  | 
 5159625  | 
 20071  | 
 0.3890  | 
|  XQS_2100_3300  | 
 3417513  | 
 13012  | 
 0.3807  | 
|  XQS_3300_3400  | 
 659530  | 
 1941  | 
 0.2943  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2210 ms, from 11:51:17.90 to 11:51:20.11.  
11:51:20.21 Validation started 
 
 
11:51:20.22 Relation 140 (DOC_LIST) 
 
11:51:20.22   process pointer page    0 of    6 
 
11:51:20.31   process pointer page    1 of    6 
 
11:51:20.36   process pointer page    2 of    6 
 
11:51:20.41   process pointer page    3 of    6 
 
11:51:20.46   process pointer page    4 of    6 
 
11:51:20.50   process pointer page    5 of    6 
 
11:51:20.52 Index 1 (PK_DOC_LIST) 
 
11:51:20.75 Index 2 (DOC_LIST_ID_DESC) 
 
11:51:21.05 Index 3 (FK_DOC_LIST_AGENTS) 
 
11:51:21.28 Relation 140 (DOC_LIST) is ok 
 
 
11:51:21.28 Relation 141 (DOC_DATA) 
 
11:51:21.28   process pointer page    0 of   15 
 
11:51:21.33   process pointer page    1 of   15 
 
11:51:21.38   process pointer page    2 of   15 
 
11:51:21.42   process pointer page    3 of   15 
 
11:51:21.45   process pointer page    4 of   15 
 
11:51:21.55   process pointer page    5 of   15 
 
11:51:21.66   process pointer page    6 of   15 
 
11:51:21.77   process pointer page    7 of   15 
 
11:51:21.87   process pointer page    8 of   15 
 
11:51:21.98   process pointer page    9 of   15 
 
11:51:22.09   process pointer page   10 of   15 
 
11:51:22.20   process pointer page   11 of   15 
 
11:51:22.31   process pointer page   12 of   15 
 
11:51:22.42   process pointer page   13 of   15 
 
11:51:22.53   process pointer page   14 of   15 
 
11:51:22.61 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
11:51:23.73 Index 3 (DOC_DATA_ID_DESC) 
 
11:51:24.67 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
11:51:25.43 Relation 141 (DOC_DATA) is ok 
 
 
11:51:25.43 Relation 147 (INVNT_SALDO) 
 
11:51:25.45   process pointer page    0 of    1 
 
11:51:25.45 Index 1 (PK_INVNT_SALDO) 
 
11:51:25.45 Relation 147 (INVNT_SALDO) is ok 
 
 
11:51:25.45 Relation 150 (PDISTR) 
 
11:51:25.45   process pointer page    0 of    4 
 
11:51:25.53   process pointer page    1 of    4 
 
11:51:25.63   process pointer page    2 of    4 
 
11:51:25.74   process pointer page    3 of    4 
 
11:51:25.74 Index 2 (PDISTR_SND_ID) 
 
11:51:25.84 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
11:51:25.95 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
11:51:26.04 Index 5 (PDISTR_AGENT_ID) 
 
11:51:26.12 Relation 150 (PDISTR) is ok 
 
 
11:51:26.12 Relation 151 (PSTORNED) 
 
11:51:26.12   process pointer page    0 of    4 
 
11:51:26.23   process pointer page    1 of    4 
 
11:51:26.34   process pointer page    2 of    4 
 
11:51:26.45   process pointer page    3 of    4 
 
11:51:26.48 Index 2 (PSTORNED_SND_ID) 
 
11:51:26.63 Index 3 (PSTORNED_RCV_ID) 
 
11:51:26.76 Relation 151 (PSTORNED) is ok 
 
 
11:51:26.76 Relation 156 (SEMAPHORES) 
 
11:51:26.76   process pointer page    0 of    1 
 
11:51:26.76 Index 1 (PK_SEMAPHORES) 
 
11:51:26.76 Index 2 (SEMAPHORES_TASK_UNQ) 
 
11:51:26.76 Relation 156 (SEMAPHORES) is ok 
 
 
11:51:26.76 Relation 157 (INVNT_TURNOVER_LOG) 
 
11:51:26.76   process pointer page    0 of    2 
 
11:51:26.79   process pointer page    1 of    2 
 
11:51:26.79 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
11:51:26.79 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
11:51:26.79 Relation 160 (PERF_ESTIMATED) 
 
11:51:26.79   process pointer page    0 of    2 
 
11:51:26.90   process pointer page    1 of    2 
 
11:51:26.96 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
11:51:27.05 Relation 160 (PERF_ESTIMATED) is ok 
 
 
11:51:27.05 Relation 161 (PERF_ISQL_STAT) 
 
11:51:27.05   process pointer page    0 of    1 
 
11:51:27.05 Index 1 (PERF_ISQL_STAT_TRN) 
 
11:51:27.05 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
11:51:27.05 Relation 162 (TRACE_STAT) 
 
11:51:27.05   process pointer page    0 of    1 
 
11:51:27.05 Relation 162 (TRACE_STAT) is ok 
 
 
11:51:27.05 Relation 163 (PERF_LOG) 
 
11:51:27.05   process pointer page    0 of  174 
 
11:51:27.15   process pointer page    1 of  174 
 
11:51:27.24   process pointer page    2 of  174 
 
11:51:27.33   process pointer page    3 of  174 
 
11:51:27.43   process pointer page    4 of  174 
 
11:51:27.52   process pointer page    5 of  174 
 
11:51:27.62   process pointer page    6 of  174 
 
11:51:27.71   process pointer page    7 of  174 
 
11:51:27.80   process pointer page    8 of  174 
 
11:51:27.90   process pointer page    9 of  174 
 
11:51:27.99   process pointer page   10 of  174 
 
11:51:28.08   process pointer page   11 of  174 
 
11:51:28.18   process pointer page   12 of  174 
 
11:51:28.27   process pointer page   13 of  174 
 
11:51:28.36   process pointer page   14 of  174 
 
11:51:28.46   process pointer page   15 of  174 
 
11:51:28.55   process pointer page   16 of  174 
 
11:51:28.65   process pointer page   17 of  174 
 
11:51:28.74   process pointer page   18 of  174 
 
11:51:28.83   process pointer page   19 of  174 
 
11:51:28.93   process pointer page   20 of  174 
 
11:51:29.00   process pointer page   21 of  174 
 
11:51:29.10   process pointer page   22 of  174 
 
11:51:29.19   process pointer page   23 of  174 
 
11:51:29.28   process pointer page   24 of  174 
 
11:51:29.38   process pointer page   25 of  174 
 
11:51:29.47   process pointer page   26 of  174 
 
11:51:29.53   process pointer page   27 of  174 
 
11:51:29.58   process pointer page   28 of  174 
 
11:51:29.67   process pointer page   29 of  174 
 
11:51:29.77   process pointer page   30 of  174 
 
11:51:29.86   process pointer page   31 of  174 
 
11:51:29.96   process pointer page   32 of  174 
 
11:51:30.00   process pointer page   33 of  174 
 
11:51:30.03   process pointer page   34 of  174 
 
11:51:30.10   process pointer page   35 of  174 
 
11:51:30.19   process pointer page   36 of  174 
 
11:51:30.27   process pointer page   37 of  174 
 
11:51:30.36   process pointer page   38 of  174 
 
11:51:30.45   process pointer page   39 of  174 
 
11:51:30.55   process pointer page   40 of  174 
 
11:51:30.64   process pointer page   41 of  174 
 
11:51:30.74   process pointer page   42 of  174 
 
11:51:30.83   process pointer page   43 of  174 
 
11:51:30.92   process pointer page   44 of  174 
 
11:51:31.02   process pointer page   45 of  174 
 
11:51:31.11   process pointer page   46 of  174 
 
11:51:31.20   process pointer page   47 of  174 
 
11:51:31.30   process pointer page   48 of  174 
 
11:51:31.39   process pointer page   49 of  174 
 
11:51:31.47   process pointer page   50 of  174 
 
11:51:31.56   process pointer page   51 of  174 
 
11:51:31.66   process pointer page   52 of  174 
 
11:51:31.75   process pointer page   53 of  174 
 
11:51:31.84   process pointer page   54 of  174 
 
11:51:31.94   process pointer page   55 of  174 
 
11:51:32.03   process pointer page   56 of  174 
 
11:51:32.12   process pointer page   57 of  174 
 
11:51:32.22   process pointer page   58 of  174 
 
11:51:32.30   process pointer page   59 of  174 
 
11:51:32.39   process pointer page   60 of  174 
 
11:51:32.48   process pointer page   61 of  174 
 
11:51:32.58   process pointer page   62 of  174 
 
11:51:32.67   process pointer page   63 of  174 
 
11:51:32.76   process pointer page   64 of  174 
 
11:51:32.86   process pointer page   65 of  174 
 
11:51:32.94   process pointer page   66 of  174 
 
11:51:33.03   process pointer page   67 of  174 
 
11:51:33.12   process pointer page   68 of  174 
 
11:51:33.22   process pointer page   69 of  174 
 
11:51:33.31   process pointer page   70 of  174 
 
11:51:33.40   process pointer page   71 of  174 
 
11:51:33.50   process pointer page   72 of  174 
 
11:51:33.59   process pointer page   73 of  174 
 
11:51:33.67   process pointer page   74 of  174 
 
11:51:33.76   process pointer page   75 of  174 
 
11:51:33.86   process pointer page   76 of  174 
 
11:51:33.95   process pointer page   77 of  174 
 
11:51:34.04   process pointer page   78 of  174 
 
11:51:34.12   process pointer page   79 of  174 
 
11:51:34.21   process pointer page   80 of  174 
 
11:51:34.31   process pointer page   81 of  174 
 
11:51:34.40   process pointer page   82 of  174 
 
11:51:34.50   process pointer page   83 of  174 
 
11:51:34.59   process pointer page   84 of  174 
 
11:51:34.68   process pointer page   85 of  174 
 
11:51:34.78   process pointer page   86 of  174 
 
11:51:34.87   process pointer page   87 of  174 
 
11:51:34.95   process pointer page   88 of  174 
 
11:51:35.04   process pointer page   89 of  174 
 
11:51:35.13   process pointer page   90 of  174 
 
11:51:35.23   process pointer page   91 of  174 
 
11:51:35.32   process pointer page   92 of  174 
 
11:51:35.42   process pointer page   93 of  174 
 
11:51:35.51   process pointer page   94 of  174 
 
11:51:35.60   process pointer page   95 of  174 
 
11:51:35.70   process pointer page   96 of  174 
 
11:51:35.79   process pointer page   97 of  174 
 
11:51:35.88   process pointer page   98 of  174 
 
11:51:35.98   process pointer page   99 of  174 
 
11:51:36.07   process pointer page  100 of  174 
 
11:51:36.16   process pointer page  101 of  174 
 
11:51:36.26   process pointer page  102 of  174 
 
11:51:36.35   process pointer page  103 of  174 
 
11:51:36.45   process pointer page  104 of  174 
 
11:51:36.54   process pointer page  105 of  174 
 
11:51:36.63   process pointer page  106 of  174 
 
11:51:36.73   process pointer page  107 of  174 
 
11:51:36.82   process pointer page  108 of  174 
 
11:51:36.91   process pointer page  109 of  174 
 
11:51:37.01   process pointer page  110 of  174 
 
11:51:37.08   process pointer page  111 of  174 
 
11:51:37.18   process pointer page  112 of  174 
 
11:51:37.27   process pointer page  113 of  174 
 
11:51:37.37   process pointer page  114 of  174 
 
11:51:37.46   process pointer page  115 of  174 
 
11:51:37.55   process pointer page  116 of  174 
 
11:51:37.65   process pointer page  117 of  174 
 
11:51:37.74   process pointer page  118 of  174 
 
11:51:37.83   process pointer page  119 of  174 
 
11:51:37.93   process pointer page  120 of  174 
 
11:51:38.02   process pointer page  121 of  174 
 
11:51:38.11   process pointer page  122 of  174 
 
11:51:38.21   process pointer page  123 of  174 
 
11:51:38.30   process pointer page  124 of  174 
 
11:51:38.40   process pointer page  125 of  174 
 
11:51:38.49   process pointer page  126 of  174 
 
11:51:38.57   process pointer page  127 of  174 
 
11:51:38.66   process pointer page  128 of  174 
 
11:51:38.75   process pointer page  129 of  174 
 
11:51:38.85   process pointer page  130 of  174 
 
11:51:38.94   process pointer page  131 of  174 
 
11:51:39.03   process pointer page  132 of  174 
 
11:51:39.13   process pointer page  133 of  174 
 
11:51:39.22   process pointer page  134 of  174 
 
11:51:39.32   process pointer page  135 of  174 
 
11:51:39.41   process pointer page  136 of  174 
 
11:51:39.50   process pointer page  137 of  174 
 
11:51:39.60   process pointer page  138 of  174 
 
11:51:39.69   process pointer page  139 of  174 
 
11:51:39.78   process pointer page  140 of  174 
 
11:51:39.88   process pointer page  141 of  174 
 
11:51:39.97   process pointer page  142 of  174 
 
11:51:40.06   process pointer page  143 of  174 
 
11:51:40.16   process pointer page  144 of  174 
 
11:51:40.25   process pointer page  145 of  174 
 
11:51:40.35   process pointer page  146 of  174 
 
11:51:40.44   process pointer page  147 of  174 
 
11:51:40.53   process pointer page  148 of  174 
 
11:51:40.63   process pointer page  149 of  174 
 
11:51:40.72   process pointer page  150 of  174 
 
11:51:40.83   process pointer page  151 of  174 
 
11:51:40.89   process pointer page  152 of  174 
 
11:51:40.92   process pointer page  153 of  174 
 
11:51:40.97   process pointer page  154 of  174 
 
11:51:41.00   process pointer page  155 of  174 
 
11:51:41.03   process pointer page  156 of  174 
 
11:51:41.11   process pointer page  157 of  174 
 
11:51:41.17   process pointer page  158 of  174 
 
11:51:41.20   process pointer page  159 of  174 
 
11:51:41.30   process pointer page  160 of  174 
 
11:51:41.39   process pointer page  161 of  174 
 
11:51:41.47   process pointer page  162 of  174 
 
11:51:41.56   process pointer page  163 of  174 
 
11:51:41.59   process pointer page  164 of  174 
 
11:51:41.69   process pointer page  165 of  174 
 
11:51:41.78   process pointer page  166 of  174 
 
11:51:41.87   process pointer page  167 of  174 
 
11:51:41.97   process pointer page  168 of  174 
 
11:51:42.06   process pointer page  169 of  174 
 
11:51:42.15   process pointer page  170 of  174 
 
11:51:42.25   process pointer page  171 of  174 
 
11:51:42.34   process pointer page  172 of  174 
 
11:51:42.44   process pointer page  173 of  174 
 
11:51:42.47 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
11:51:47.29 Index 2 (PERF_LOG_UNIT) 
 
11:51:53.81 Index 3 (PERF_LOG_TRN_DESC) 
 
11:51:57.13 Index 4 (PERF_LOG_GDSCODE) 
 
11:52:00.00 Relation 163 (PERF_LOG) is ok 
 
 
11:52:00.00 Relation 167 (V_STOPTEST) 
 
11:52:00.00 Relation 167 (V_STOPTEST) is ok 
 
 
11:52:00.00 Relation 184 (V_QDISTR_SOURCE) 
 
11:52:00.00 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
11:52:00.00 Relation 185 (V_QSTORNED_SOURCE) 
 
11:52:00.00 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
11:52:00.00 Relation 260 (XQD_1000_1200) 
 
11:52:00.02   process pointer page    0 of    2 
 
11:52:00.03   process pointer page    1 of    2 
 
11:52:00.05 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
11:52:00.05 Relation 260 (XQD_1000_1200) is ok 
 
 
11:52:00.05 Relation 261 (XQD_1200_2000) 
 
11:52:00.05   process pointer page    0 of    4 
 
11:52:00.11   process pointer page    1 of    4 
 
11:52:00.17   process pointer page    2 of    4 
 
11:52:00.20   process pointer page    3 of    4 
 
11:52:00.20 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
11:52:00.22 Relation 261 (XQD_1200_2000) is ok 
 
 
11:52:00.22 Relation 262 (XQD_1000_3300) 
 
11:52:00.22   process pointer page    0 of   12 
 
11:52:00.31   process pointer page    1 of   12 
 
11:52:00.42   process pointer page    2 of   12 
 
11:52:00.53   process pointer page    3 of   12 
 
11:52:00.63   process pointer page    4 of   12 
 
11:52:00.73   process pointer page    5 of   12 
 
11:52:00.84   process pointer page    6 of   12 
 
11:52:00.94   process pointer page    7 of   12 
 
11:52:01.05   process pointer page    8 of   12 
 
11:52:01.16   process pointer page    9 of   12 
 
11:52:01.25   process pointer page   10 of   12 
 
11:52:01.36   process pointer page   11 of   12 
 
11:52:01.44 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
11:52:01.94 Index 2 (XQD_1000_3300_DOC) 
 
11:52:02.33 Relation 262 (XQD_1000_3300) is ok 
 
 
11:52:02.33 Relation 263 (XQD_2000_3300) 
 
11:52:02.33   process pointer page    0 of   21 
 
11:52:02.42   process pointer page    1 of   21 
 
11:52:02.53   process pointer page    2 of   21 
 
11:52:02.62   process pointer page    3 of   21 
 
11:52:02.72   process pointer page    4 of   21 
 
11:52:02.82   process pointer page    5 of   21 
 
11:52:02.93   process pointer page    6 of   21 
 
11:52:03.04   process pointer page    7 of   21 
 
11:52:03.15   process pointer page    8 of   21 
 
11:52:03.20   process pointer page    9 of   21 
 
11:52:03.25   process pointer page   10 of   21 
 
11:52:03.32   process pointer page   11 of   21 
 
11:52:03.42   process pointer page   12 of   21 
 
11:52:03.53   process pointer page   13 of   21 
 
11:52:03.62   process pointer page   14 of   21 
 
11:52:03.73   process pointer page   15 of   21 
 
11:52:03.82   process pointer page   16 of   21 
 
11:52:03.89   process pointer page   17 of   21 
 
11:52:03.93   process pointer page   18 of   21 
 
11:52:03.98   process pointer page   19 of   21 
 
11:52:04.09   process pointer page   20 of   21 
 
11:52:04.09 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
11:52:04.76 Relation 263 (XQD_2000_3300) is ok 
 
 
11:52:04.76 Relation 264 (XQD_2100_3300) 
 
11:52:04.76   process pointer page    0 of   16 
 
11:52:04.84   process pointer page    1 of   16 
 
11:52:04.90   process pointer page    2 of   16 
 
11:52:04.98   process pointer page    3 of   16 
 
11:52:05.04   process pointer page    4 of   16 
 
11:52:05.10   process pointer page    5 of   16 
 
11:52:05.18   process pointer page    6 of   16 
 
11:52:05.24   process pointer page    7 of   16 
 
11:52:05.32   process pointer page    8 of   16 
 
11:52:05.38   process pointer page    9 of   16 
 
11:52:05.46   process pointer page   10 of   16 
 
11:52:05.52   process pointer page   11 of   16 
 
11:52:05.59   process pointer page   12 of   16 
 
11:52:05.68   process pointer page   13 of   16 
 
11:52:05.76   process pointer page   14 of   16 
 
11:52:05.84   process pointer page   15 of   16 
 
11:52:05.85 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
11:52:05.85 Relation 264 (XQD_2100_3300) is ok 
 
 
11:52:05.85 Relation 265 (XQD_3300_3400) 
 
11:52:05.85   process pointer page    0 of   26 
 
11:52:05.98   process pointer page    1 of   26 
 
11:52:06.10   process pointer page    2 of   26 
 
11:52:06.21   process pointer page    3 of   26 
 
11:52:06.33   process pointer page    4 of   26 
 
11:52:06.46   process pointer page    5 of   26 
 
11:52:06.58   process pointer page    6 of   26 
 
11:52:06.69   process pointer page    7 of   26 
 
11:52:06.82   process pointer page    8 of   26 
 
11:52:06.94   process pointer page    9 of   26 
 
11:52:07.07   process pointer page   10 of   26 
 
11:52:07.18   process pointer page   11 of   26 
 
11:52:07.30   process pointer page   12 of   26 
 
11:52:07.43   process pointer page   13 of   26 
 
11:52:07.55   process pointer page   14 of   26 
 
11:52:07.66   process pointer page   15 of   26 
 
11:52:07.79   process pointer page   16 of   26 
 
11:52:07.91   process pointer page   17 of   26 
 
11:52:08.04   process pointer page   18 of   26 
 
11:52:08.14   process pointer page   19 of   26 
 
11:52:08.27   process pointer page   20 of   26 
 
11:52:08.39   process pointer page   21 of   26 
 
11:52:08.67   process pointer page   22 of   26 
 
11:52:08.97   process pointer page   23 of   26 
 
11:52:09.38   process pointer page   24 of   26 
 
11:52:09.69   process pointer page   25 of   26 
 
11:52:09.91 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
11:52:11.83 Relation 265 (XQD_3300_3400) is ok 
 
 
11:52:11.83 Relation 266 (XQS_1000_1200) 
 
11:52:11.83   process pointer page    0 of   46 
 
11:52:12.15   process pointer page    1 of   46 
 
11:52:12.45   process pointer page    2 of   46 
 
11:52:12.73   process pointer page    3 of   46 
 
11:52:13.03   process pointer page    4 of   46 
 
11:52:13.34   process pointer page    5 of   46 
 
11:52:13.64   process pointer page    6 of   46 
 
11:52:13.93   process pointer page    7 of   46 
 
11:52:14.24   process pointer page    8 of   46 
 
11:52:14.52   process pointer page    9 of   46 
 
11:52:14.84   process pointer page   10 of   46 
 
11:52:15.12   process pointer page   11 of   46 
 
11:52:15.45   process pointer page   12 of   46 
 
11:52:15.76   process pointer page   13 of   46 
 
11:52:16.05   process pointer page   14 of   46 
 
11:52:16.37   process pointer page   15 of   46 
 
11:52:16.66   process pointer page   16 of   46 
 
11:52:16.96   process pointer page   17 of   46 
 
11:52:17.30   process pointer page   18 of   46 
 
11:52:17.63   process pointer page   19 of   46 
 
11:52:17.96   process pointer page   20 of   46 
 
11:52:18.32   process pointer page   21 of   46 
 
11:52:18.67   process pointer page   22 of   46 
 
11:52:19.02   process pointer page   23 of   46 
 
11:52:19.38   process pointer page   24 of   46 
 
11:52:19.75   process pointer page   25 of   46 
 
11:52:20.09   process pointer page   26 of   46 
 
11:52:20.45   process pointer page   27 of   46 
 
11:52:20.81   process pointer page   28 of   46 
 
11:52:21.17   process pointer page   29 of   46 
 
11:52:21.53   process pointer page   30 of   46 
 
11:52:21.89   process pointer page   31 of   46 
 
11:52:22.25   process pointer page   32 of   46 
 
11:52:22.59   process pointer page   33 of   46 
 
11:52:22.95   process pointer page   34 of   46 
 
11:52:23.32   process pointer page   35 of   46 
 
11:52:23.68   process pointer page   36 of   46 
 
11:52:24.06   process pointer page   37 of   46 
 
11:52:24.42   process pointer page   38 of   46 
 
11:52:24.77   process pointer page   39 of   46 
 
11:52:25.15   process pointer page   40 of   46 
 
11:52:25.51   process pointer page   41 of   46 
 
11:52:25.90   process pointer page   42 of   46 
 
11:52:26.24   process pointer page   43 of   46 
 
11:52:26.60   process pointer page   44 of   46 
 
11:52:26.96   process pointer page   45 of   46 
 
11:52:27.21 Index 1 (XQS_1000_1200_DOC_ID) 
 
11:52:29.58 Index 2 (XQS_1000_1200_SND_ID) 
 
11:52:32.11 Index 3 (XQS_1000_1200_RCV_ID) 
 
11:52:34.35 Relation 266 (XQS_1000_1200) is ok 
 
 
11:52:34.35 Relation 267 (XQS_1200_2000) 
 
11:52:34.35   process pointer page    0 of   50 
 
11:52:34.76   process pointer page    1 of   50 
 
11:52:35.13   process pointer page    2 of   50 
 
11:52:35.54   process pointer page    3 of   50 
 
11:52:35.93   process pointer page    4 of   50 
 
11:52:36.32   process pointer page    5 of   50 
 
11:52:36.69   process pointer page    6 of   50 
 
11:52:37.10   process pointer page    7 of   50 
 
11:52:37.49   process pointer page    8 of   50 
 
11:52:37.89   process pointer page    9 of   50 
 
11:52:38.28   process pointer page   10 of   50 
 
11:52:38.69   process pointer page   11 of   50 
 
11:52:39.11   process pointer page   12 of   50 
 
11:52:39.55   process pointer page   13 of   50 
 
11:52:40.03   process pointer page   14 of   50 
 
11:52:40.51   process pointer page   15 of   50 
 
11:52:40.98   process pointer page   16 of   50 
 
11:52:41.47   process pointer page   17 of   50 
 
11:52:41.92   process pointer page   18 of   50 
 
11:52:42.39   process pointer page   19 of   50 
 
11:52:42.85   process pointer page   20 of   50 
 
11:52:43.32   process pointer page   21 of   50 
 
11:52:43.77   process pointer page   22 of   50 
 
11:52:44.21   process pointer page   23 of   50 
 
11:52:44.65   process pointer page   24 of   50 
 
11:52:45.10   process pointer page   25 of   50 
 
11:52:45.54   process pointer page   26 of   50 
 
11:52:45.99   process pointer page   27 of   50 
 
11:52:46.44   process pointer page   28 of   50 
 
11:52:46.88   process pointer page   29 of   50 
 
11:52:47.32   process pointer page   30 of   50 
 
11:52:47.77   process pointer page   31 of   50 
 
11:52:48.17   process pointer page   32 of   50 
 
11:52:48.66   process pointer page   33 of   50 
 
11:52:49.11   process pointer page   34 of   50 
 
11:52:49.55   process pointer page   35 of   50 
 
11:52:50.00   process pointer page   36 of   50 
 
11:52:50.44   process pointer page   37 of   50 
 
11:52:50.87   process pointer page   38 of   50 
 
11:52:51.31   process pointer page   39 of   50 
 
11:52:51.76   process pointer page   40 of   50 
 
11:52:52.18   process pointer page   41 of   50 
 
11:52:52.65   process pointer page   42 of   50 
 
11:52:53.10   process pointer page   43 of   50 
 
11:52:53.54   process pointer page   44 of   50 
 
11:52:53.99   process pointer page   45 of   50 
 
11:52:54.43   process pointer page   46 of   50 
 
11:52:54.87   process pointer page   47 of   50 
 
11:52:55.27   process pointer page   48 of   50 
 
11:52:55.69   process pointer page   49 of   50 
 
11:52:55.82 Index 1 (XQS_1200_2000_DOC_ID) 
 
11:52:58.67 Index 2 (XQS_1200_2000_SND_ID) 
 
11:53:01.56 Index 3 (XQS_1200_2000_RCV_ID) 
 
11:53:04.27 Relation 267 (XQS_1200_2000) is ok 
 
 
11:53:04.29 Relation 268 (XQS_1000_3300) 
 
11:53:04.29   process pointer page    0 of   24 
 
11:53:04.76   process pointer page    1 of   24 
 
11:53:05.24   process pointer page    2 of   24 
 
11:53:05.69   process pointer page    3 of   24 
 
11:53:06.16   process pointer page    4 of   24 
 
11:53:06.64   process pointer page    5 of   24 
 
11:53:07.16   process pointer page    6 of   24 
 
11:53:07.66   process pointer page    7 of   24 
 
11:53:08.17   process pointer page    8 of   24 
 
11:53:08.67   process pointer page    9 of   24 
 
11:53:09.17   process pointer page   10 of   24 
 
11:53:09.66   process pointer page   11 of   24 
 
11:53:10.14   process pointer page   12 of   24 
 
11:53:10.61   process pointer page   13 of   24 
 
11:53:11.09   process pointer page   14 of   24 
 
11:53:11.57   process pointer page   15 of   24 
 
11:53:12.01   process pointer page   16 of   24 
 
11:53:12.43   process pointer page   17 of   24 
 
11:53:12.85   process pointer page   18 of   24 
 
11:53:13.24   process pointer page   19 of   24 
 
11:53:13.66   process pointer page   20 of   24 
 
11:53:14.10   process pointer page   21 of   24 
 
11:53:14.54   process pointer page   22 of   24 
 
11:53:14.88   process pointer page   23 of   24 
 
11:53:14.91 Index 1 (XQS_1000_3300_DOC_ID) 
 
11:53:16.32 Index 2 (XQS_1000_3300_SND_ID) 
 
11:53:17.83 Index 3 (XQS_1000_3300_RCV_ID) 
 
11:53:19.48 Relation 268 (XQS_1000_3300) is ok 
 
 
11:53:19.48 Relation 269 (XQS_2000_3300) 
 
11:53:19.48   process pointer page    0 of    1 
 
11:53:19.48 Index 1 (XQS_2000_3300_DOC_ID) 
 
11:53:19.48 Index 2 (XQS_2000_3300_SND_ID) 
 
11:53:19.48 Index 3 (XQS_2000_3300_RCV_ID) 
 
11:53:19.48 Relation 269 (XQS_2000_3300) is ok 
 
 
11:53:19.48 Relation 270 (XQS_2100_3300) 
 
11:53:19.48   process pointer page    0 of   34 
 
11:53:19.95   process pointer page    1 of   34 
 
11:53:20.40   process pointer page    2 of   34 
 
11:53:20.87   process pointer page    3 of   34 
 
11:53:21.34   process pointer page    4 of   34 
 
11:53:21.81   process pointer page    5 of   34 
 
11:53:22.24   process pointer page    6 of   34 
 
11:53:22.70   process pointer page    7 of   34 
 
11:53:23.15   process pointer page    8 of   34 
 
11:53:23.57   process pointer page    9 of   34 
 
11:53:24.04   process pointer page   10 of   34 
 
11:53:24.49   process pointer page   11 of   34 
 
11:53:24.94   process pointer page   12 of   34 
 
11:53:25.41   process pointer page   13 of   34 
 
11:53:25.86   process pointer page   14 of   34 
 
11:53:26.30   process pointer page   15 of   34 
 
11:53:26.74   process pointer page   16 of   34 
 
11:53:27.19   process pointer page   17 of   34 
 
11:53:27.64   process pointer page   18 of   34 
 
11:53:28.09   process pointer page   19 of   34 
 
11:53:28.52   process pointer page   20 of   34 
 
11:53:28.94   process pointer page   21 of   34 
 
11:53:29.37   process pointer page   22 of   34 
 
11:53:29.81   process pointer page   23 of   34 
 
11:53:30.23   process pointer page   24 of   34 
 
11:53:30.67   process pointer page   25 of   34 
 
11:53:31.11   process pointer page   26 of   34 
 
11:53:31.54   process pointer page   27 of   34 
 
11:53:31.96   process pointer page   28 of   34 
 
11:53:32.40   process pointer page   29 of   34 
 
11:53:32.82   process pointer page   30 of   34 
 
11:53:33.20   process pointer page   31 of   34 
 
11:53:33.48   process pointer page   32 of   34 
 
11:53:33.76   process pointer page   33 of   34 
 
11:53:33.79 Index 1 (XQS_2100_3300_DOC_ID) 
 
11:53:35.79 Index 2 (XQS_2100_3300_SND_ID) 
 
11:53:37.97 Index 3 (XQS_2100_3300_RCV_ID) 
 
11:53:40.25 Relation 270 (XQS_2100_3300) is ok 
 
 
11:53:40.25 Relation 271 (XQS_3300_3400) 
 
11:53:40.25   process pointer page    0 of    6 
 
11:53:40.70   process pointer page    1 of    6 
 
11:53:41.12   process pointer page    2 of    6 
 
11:53:41.56   process pointer page    3 of    6 
 
11:53:41.98   process pointer page    4 of    6 
 
11:53:42.42   process pointer page    5 of    6 
 
11:53:42.70 Index 1 (XQS_3300_3400_DOC_ID) 
 
11:53:43.04 Index 2 (XQS_3300_3400_SND_ID) 
 
11:53:43.41 Relation 271 (XQS_3300_3400) is ok 
 
 
11:53:43.45 Validation finished 
 
Done for 143440 ms, from 11:51:20.13 to 11:53:43.57. 
 
 Differences between old and current firebird.log 
11:53:45.57. 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:
 
2017-04-12  11:53               478 oltp40_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
***** 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 12 11:51:20 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Wed Apr 12 11:53:43 2017 
 
12:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 401 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*: 
 
 
|  ERRORS_CHECKING_RESULT  | 
|  NO_SEVERE_ERRORS_FOUND  | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2017-04-12 11:53:57.33 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html