|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 180 minutes:  | 
 5946.03  | 
 3540  | 
 1070286  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  customer order: creation  | 
 443.99  | 
 546  | 
 79919  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  customer order: refuse  | 
 35.97  | 
 282  | 
 6475  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  order to supplier: creation  | 
 113.54  | 
 2374  | 
 20437  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  order to supplier: removal  | 
 2.86  | 
 23446  | 
 514  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  invoice (draft): creation  | 
 114.19  | 
 3360  | 
 20555  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  invoice (draft): removal  | 
 39.18  | 
 514  | 
 7053  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  invoice accept: apply  | 
 65.13  | 
 13138  | 
 11723  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  invoice accept: cancel  | 
 18.76  | 
 2885  | 
 3377  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  customer reserve: creation  | 
 3415.08  | 
 209  | 
 614714  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  customer reserve: removal  | 
 1084.31  | 
 70  | 
 195176  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  realization accept: apply  | 
 203.74  | 
 635  | 
 36674  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  realization accept: cancel  | 
 91.93  | 
 172  | 
 16547  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  payment from customer: creation  | 
 148.53  | 
 954  | 
 26735  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  payment from customer: removal  | 
 13.93  | 
 157  | 
 2508  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  payment to supplier: creation  | 
 120.89  | 
 589  | 
 21760  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  payment to supplier: removal  | 
 8.24  | 
 170  | 
 1484  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  service: total inventory turnovers  | 
 8.48  | 
 3423  | 
 1526  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  service: total monetary turnovers  | 
 17.21  | 
 77  | 
 3097  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  service: refresh index statistics  | 
 0.07  | 
 14261  | 
 12  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
 
Done for 81710 ms, from  6:48:58.24 to  6:50:19.95.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4879  | 
 99214  | 
 87827  | 
 11387  | 
 11.48  | 
 03:46:46  | 
 04:04:46  | 
|  interval #   2, overall  | 
 2  | 
 5733  | 
 115899  | 
 103197  | 
 12702  | 
 10.96  | 
 04:04:47  | 
 04:22:47  | 
|  interval #   3, overall  | 
 3  | 
 5544  | 
 111242  | 
 99787  | 
 11455  | 
 10.30  | 
 04:22:48  | 
 04:40:48  | 
|  interval #   4, overall  | 
 4  | 
 5841  | 
 116021  | 
 105130  | 
 10891  | 
 9.39  | 
 04:40:49  | 
 04:58:49  | 
|  interval #   5, overall  | 
 5  | 
 6288  | 
 128173  | 
 113184  | 
 14989  | 
 11.69  | 
 04:58:50  | 
 05:16:50  | 
|  interval #   6, overall  | 
 6  | 
 6618  | 
 137492  | 
 119116  | 
 18376  | 
 13.37  | 
 05:16:51  | 
 05:34:51  | 
|  interval #   7, overall  | 
 7  | 
 6405  | 
 133934  | 
 115281  | 
 18653  | 
 13.93  | 
 05:34:52  | 
 05:52:52  | 
|  interval #   8, overall  | 
 8  | 
 6371  | 
 127146  | 
 114686  | 
 12460  | 
 9.80  | 
 05:52:53  | 
 06:10:53  | 
|  interval #   9, overall  | 
 9  | 
 6103  | 
 120606  | 
 109852  | 
 10754  | 
 8.92  | 
 06:10:54  | 
 06:28:54  | 
|  interval #  10, overall  | 
 10  | 
 5679  | 
 118766  | 
 102226  | 
 16540  | 
 13.93  | 
 06:28:55  | 
 06:46:55  | 
 
Done for 219220 ms, from  6:53:47.52 to  6:57:26.74.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 2664.47  | 
 0.4004  | 
 1.8371  | 
 1957  | 
 43  | 
|  TEST_TIME  | 
 2  | 
 3386.35  | 
 0.7231  | 
 1.2895  | 
 1771  | 
 44  | 
|  TEST_TIME  | 
 3  | 
 3600.66  | 
 0.8085  | 
 1.2057  | 
 1659  | 
 47  | 
|  TEST_TIME  | 
 4  | 
 3627.73  | 
 0.8977  | 
 1.1549  | 
 1483  | 
 99  | 
|  TEST_TIME  | 
 5  | 
 3691.49  | 
 0.9080  | 
 1.0909  | 
 1433  | 
 100  | 
|  TEST_TIME  | 
 6  | 
 3629.13  | 
 0.9251  | 
 1.0893  | 
 1410  | 
 100  | 
|  TEST_TIME  | 
 7  | 
 3701.79  | 
 0.9154  | 
 1.0870  | 
 1780  | 
 100  | 
|  TEST_TIME  | 
 8  | 
 3852.21  | 
 0.9140  | 
 1.0773  | 
 1794  | 
 100  | 
|  TEST_TIME  | 
 9  | 
 3945.90  | 
 0.9349  | 
 1.0634  | 
 1708  | 
 100  | 
|  TEST_TIME  | 
 10  | 
 3967.80  | 
 0.9518  | 
 1.0580  | 
 1695  | 
 100  | 
|  TEST_TIME  | 
 11  | 
 4051.79  | 
 0.9419  | 
 1.0586  | 
 1592  | 
 100  | 
|  TEST_TIME  | 
 12  | 
 4074.08  | 
 0.9651  | 
 1.0479  | 
 1419  | 
 100  | 
|  TEST_TIME  | 
 13  | 
 4152.63  | 
 0.9490  | 
 1.0547  | 
 1397  | 
 100  | 
|  TEST_TIME  | 
 14  | 
 4215.56  | 
 0.9648  | 
 1.0251  | 
 1597  | 
 99  | 
|  TEST_TIME  | 
 15  | 
 4253.11  | 
 0.9501  | 
 1.0434  | 
 1637  | 
 100  | 
|  TEST_TIME  | 
 16  | 
 4404.56  | 
 0.9446  | 
 1.0646  | 
 2054  | 
 100  | 
|  TEST_TIME  | 
 17  | 
 4627.30  | 
 0.9539  | 
 1.0463  | 
 2010  | 
 100  | 
|  TEST_TIME  | 
 18  | 
 4777.87  | 
 0.9570  | 
 1.0422  | 
 1712  | 
 100  | 
|  TEST_TIME  | 
 19  | 
 4901.90  | 
 0.9623  | 
 1.0378  | 
 1720  | 
 100  | 
|  TEST_TIME  | 
 20  | 
 4976.51  | 
 0.9712  | 
 1.0238  | 
 1689  | 
 100  | 
|  TEST_TIME  | 
 21  | 
 5005.18  | 
 0.9696  | 
 1.0205  | 
 1483  | 
 100  | 
|  TEST_TIME  | 
 22  | 
 4979.73  | 
 0.9791  | 
 1.0173  | 
 1613  | 
 99  | 
|  TEST_TIME  | 
 23  | 
 4980.95  | 
 0.9728  | 
 1.0261  | 
 1276  | 
 100  | 
|  TEST_TIME  | 
 24  | 
 4987.99  | 
 0.9820  | 
 1.0133  | 
 1509  | 
 100  | 
|  TEST_TIME  | 
 25  | 
 4940.00  | 
 0.9823  | 
 1.0165  | 
 1626  | 
 100  | 
|  TEST_TIME  | 
 26  | 
 4960.77  | 
 0.9733  | 
 1.0268  | 
 1184  | 
 100  | 
|  TEST_TIME  | 
 27  | 
 5003.91  | 
 0.9803  | 
 1.0159  | 
 1334  | 
 100  | 
|  TEST_TIME  | 
 28  | 
 5009.26  | 
 0.9786  | 
 1.0162  | 
 1227  | 
 100  | 
|  TEST_TIME  | 
 29  | 
 5038.21  | 
 0.9755  | 
 1.0234  | 
 1074  | 
 100  | 
|  TEST_TIME  | 
 30  | 
 5094.91  | 
 0.9783  | 
 1.0232  | 
 1745  | 
 100  | 
|  TEST_TIME  | 
 31  | 
 5127.68  | 
 0.9838  | 
 1.0133  | 
 2045  | 
 100  | 
|  TEST_TIME  | 
 32  | 
 5140.37  | 
 0.9792  | 
 1.0293  | 
 1564  | 
 100  | 
|  TEST_TIME  | 
 33  | 
 5220.58  | 
 0.9831  | 
 1.0195  | 
 1501  | 
 100  | 
|  TEST_TIME  | 
 34  | 
 5222.42  | 
 0.9895  | 
 1.0131  | 
 1942  | 
 99  | 
|  TEST_TIME  | 
 35  | 
 5209.45  | 
 0.9866  | 
 1.0196  | 
 1706  | 
 96  | 
|  TEST_TIME  | 
 36  | 
 5249.00  | 
 0.9838  | 
 1.0194  | 
 1492  | 
 99  | 
|  TEST_TIME  | 
 37  | 
 5292.75  | 
 0.9837  | 
 1.0149  | 
 1271  | 
 100  | 
|  TEST_TIME  | 
 38  | 
 5300.64  | 
 0.9871  | 
 1.0093  | 
 1677  | 
 100  | 
|  TEST_TIME  | 
 39  | 
 5280.70  | 
 0.9871  | 
 1.0196  | 
 1415  | 
 100  | 
|  TEST_TIME  | 
 40  | 
 5315.12  | 
 0.9876  | 
 1.0101  | 
 1360  | 
 100  | 
|  TEST_TIME  | 
 41  | 
 5307.45  | 
 0.9869  | 
 1.0140  | 
 1355  | 
 100  | 
|  TEST_TIME  | 
 42  | 
 5314.47  | 
 0.9886  | 
 1.0109  | 
 1374  | 
 100  | 
|  TEST_TIME  | 
 43  | 
 5294.62  | 
 0.9911  | 
 1.0115  | 
 1290  | 
 100  | 
|  TEST_TIME  | 
 44  | 
 5278.03  | 
 0.9916  | 
 1.0111  | 
 1280  | 
 100  | 
|  TEST_TIME  | 
 45  | 
 5277.92  | 
 0.9887  | 
 1.0147  | 
 1632  | 
 100  | 
|  TEST_TIME  | 
 46  | 
 5285.08  | 
 0.9913  | 
 1.0075  | 
 1759  | 
 97  | 
|  TEST_TIME  | 
 47  | 
 5298.39  | 
 0.9836  | 
 1.0084  | 
 1625  | 
 100  | 
|  TEST_TIME  | 
 48  | 
 5286.83  | 
 0.9896  | 
 1.0088  | 
 1627  | 
 100  | 
|  TEST_TIME  | 
 49  | 
 5284.56  | 
 0.9887  | 
 1.0116  | 
 1887  | 
 98  | 
|  TEST_TIME  | 
 50  | 
 5309.52  | 
 0.9867  | 
 1.0107  | 
 1613  | 
 99  | 
|  TEST_TIME  | 
 51  | 
 5320.50  | 
 0.9888  | 
 1.0185  | 
 1492  | 
 100  | 
|  TEST_TIME  | 
 52  | 
 5353.18  | 
 0.9930  | 
 1.0061  | 
 1141  | 
 100  | 
|  TEST_TIME  | 
 53  | 
 5348.72  | 
 0.9916  | 
 1.0097  | 
 1330  | 
 99  | 
|  TEST_TIME  | 
 54  | 
 5346.24  | 
 0.9945  | 
 1.0068  | 
 1531  | 
 98  | 
|  TEST_TIME  | 
 55  | 
 5323.97  | 
 0.9927  | 
 1.0156  | 
 1317  | 
 99  | 
|  TEST_TIME  | 
 56  | 
 5350.62  | 
 0.9925  | 
 1.0098  | 
 1336  | 
 100  | 
|  TEST_TIME  | 
 57  | 
 5353.37  | 
 0.9921  | 
 1.0092  | 
 1437  | 
 100  | 
|  TEST_TIME  | 
 58  | 
 5395.63  | 
 0.9841  | 
 1.0099  | 
 1345  | 
 100  | 
|  TEST_TIME  | 
 59  | 
 5390.51  | 
 0.9938  | 
 1.0038  | 
 1436  | 
 100  | 
|  TEST_TIME  | 
 60  | 
 5370.21  | 
 0.9908  | 
 1.0090  | 
 1638  | 
 98  | 
|  TEST_TIME  | 
 61  | 
 5385.02  | 
 0.9898  | 
 1.0089  | 
 1849  | 
 99  | 
|  TEST_TIME  | 
 62  | 
 5416.27  | 
 0.9869  | 
 1.0079  | 
 2002  | 
 100  | 
|  TEST_TIME  | 
 63  | 
 5422.80  | 
 0.9908  | 
 1.0113  | 
 1919  | 
 100  | 
|  TEST_TIME  | 
 64  | 
 5452.44  | 
 0.9909  | 
 1.0102  | 
 1715  | 
 100  | 
|  TEST_TIME  | 
 65  | 
 5458.20  | 
 0.9936  | 
 1.0111  | 
 1820  | 
 100  | 
|  TEST_TIME  | 
 66  | 
 5467.26  | 
 0.9942  | 
 1.0055  | 
 1690  | 
 97  | 
|  TEST_TIME  | 
 67  | 
 5466.40  | 
 0.9907  | 
 1.0068  | 
 1527  | 
 99  | 
|  TEST_TIME  | 
 68  | 
 5470.23  | 
 0.9913  | 
 1.0096  | 
 1473  | 
 100  | 
|  TEST_TIME  | 
 69  | 
 5487.92  | 
 0.9920  | 
 1.0054  | 
 1580  | 
 100  | 
|  TEST_TIME  | 
 70  | 
 5479.43  | 
 0.9928  | 
 1.0060  | 
 1481  | 
 98  | 
|  TEST_TIME  | 
 71  | 
 5469.02  | 
 0.9937  | 
 1.0070  | 
 1539  | 
 97  | 
|  TEST_TIME  | 
 72  | 
 5479.52  | 
 0.9911  | 
 1.0037  | 
 1492  | 
 100  | 
|  TEST_TIME  | 
 73  | 
 5446.88  | 
 0.9959  | 
 1.0050  | 
 1323  | 
 99  | 
|  TEST_TIME  | 
 74  | 
 5432.42  | 
 0.9941  | 
 1.0086  | 
 1223  | 
 99  | 
|  TEST_TIME  | 
 75  | 
 5457.20  | 
 0.9906  | 
 1.0094  | 
 2028  | 
 100  | 
|  TEST_TIME  | 
 76  | 
 5484.84  | 
 0.9911  | 
 1.0065  | 
 2089  | 
 100  | 
|  TEST_TIME  | 
 77  | 
 5505.10  | 
 0.9898  | 
 1.0100  | 
 1542  | 
 99  | 
|  TEST_TIME  | 
 78  | 
 5518.53  | 
 0.9946  | 
 1.0050  | 
 1484  | 
 92  | 
|  TEST_TIME  | 
 79  | 
 5506.43  | 
 0.9945  | 
 1.0063  | 
 1413  | 
 94  | 
|  TEST_TIME  | 
 80  | 
 5533.27  | 
 0.9940  | 
 1.0051  | 
 1278  | 
 97  | 
|  TEST_TIME  | 
 81  | 
 5543.38  | 
 0.9931  | 
 1.0103  | 
 1494  | 
 100  | 
|  TEST_TIME  | 
 82  | 
 5573.18  | 
 0.9927  | 
 1.0072  | 
 1532  | 
 100  | 
|  TEST_TIME  | 
 83  | 
 5585.44  | 
 0.9929  | 
 1.0031  | 
 1528  | 
 100  | 
|  TEST_TIME  | 
 84  | 
 5565.79  | 
 0.9947  | 
 1.0057  | 
 1404  | 
 97  | 
|  TEST_TIME  | 
 85  | 
 5565.36  | 
 0.9939  | 
 1.0072  | 
 1296  | 
 99  | 
|  TEST_TIME  | 
 86  | 
 5575.24  | 
 0.9937  | 
 1.0061  | 
 1302  | 
 100  | 
|  TEST_TIME  | 
 87  | 
 5585.08  | 
 0.9933  | 
 1.0081  | 
 1280  | 
 100  | 
|  TEST_TIME  | 
 88  | 
 5612.56  | 
 0.9918  | 
 1.0055  | 
 1158  | 
 100  | 
|  TEST_TIME  | 
 89  | 
 5596.70  | 
 0.9970  | 
 1.0096  | 
 1218  | 
 100  | 
|  TEST_TIME  | 
 90  | 
 5621.32  | 
 0.9940  | 
 1.0051  | 
 1974  | 
 100  | 
|  TEST_TIME  | 
 91  | 
 5638.56  | 
 0.9910  | 
 1.0086  | 
 1680  | 
 97  | 
|  TEST_TIME  | 
 92  | 
 5687.48  | 
 0.9910  | 
 1.0046  | 
 1590  | 
 100  | 
|  TEST_TIME  | 
 93  | 
 5705.90  | 
 0.9928  | 
 1.0048  | 
 1934  | 
 100  | 
|  TEST_TIME  | 
 94  | 
 5708.15  | 
 0.9937  | 
 1.0066  | 
 1655  | 
 100  | 
|  TEST_TIME  | 
 95  | 
 5705.23  | 
 0.9965  | 
 1.0080  | 
 1580  | 
 100  | 
|  TEST_TIME  | 
 96  | 
 5720.89  | 
 0.9948  | 
 1.0082  | 
 1290  | 
 100  | 
|  TEST_TIME  | 
 97  | 
 5736.90  | 
 0.9950  | 
 1.0052  | 
 1316  | 
 100  | 
|  TEST_TIME  | 
 98  | 
 5719.29  | 
 0.9980  | 
 1.0024  | 
 1432  | 
 96  | 
|  TEST_TIME  | 
 99  | 
 5700.29  | 
 0.9956  | 
 1.0080  | 
 1068  | 
 98  | 
|  TEST_TIME  | 
 100  | 
 5714.73  | 
 0.9954  | 
 1.0027  | 
 1404  | 
 100  | 
|  TEST_TIME  | 
 101  | 
 5701.95  | 
 0.9950  | 
 1.0075  | 
 1284  | 
 99  | 
|  TEST_TIME  | 
 102  | 
 5707.19  | 
 0.9970  | 
 1.0018  | 
 1347  | 
 100  | 
|  TEST_TIME  | 
 103  | 
 5707.74  | 
 0.9920  | 
 1.0055  | 
 959  | 
 100  | 
|  TEST_TIME  | 
 104  | 
 5711.69  | 
 0.9953  | 
 1.0078  | 
 1247  | 
 100  | 
|  TEST_TIME  | 
 105  | 
 5742.73  | 
 0.9928  | 
 1.0078  | 
 1703  | 
 100  | 
|  TEST_TIME  | 
 106  | 
 5758.67  | 
 0.9955  | 
 1.0067  | 
 1861  | 
 99  | 
|  TEST_TIME  | 
 107  | 
 5771.48  | 
 0.9959  | 
 1.0048  | 
 1851  | 
 99  | 
|  TEST_TIME  | 
 108  | 
 5778.14  | 
 0.9944  | 
 1.0076  | 
 1600  | 
 96  | 
|  TEST_TIME  | 
 109  | 
 5789.22  | 
 0.9964  | 
 1.0039  | 
 1579  | 
 98  | 
|  TEST_TIME  | 
 110  | 
 5783.54  | 
 0.9958  | 
 1.0060  | 
 1391  | 
 100  | 
|  TEST_TIME  | 
 111  | 
 5789.78  | 
 0.9959  | 
 1.0055  | 
 1490  | 
 100  | 
|  TEST_TIME  | 
 112  | 
 5799.47  | 
 0.9948  | 
 1.0071  | 
 1433  | 
 100  | 
|  TEST_TIME  | 
 113  | 
 5820.34  | 
 0.9947  | 
 1.0044  | 
 1400  | 
 99  | 
|  TEST_TIME  | 
 114  | 
 5809.45  | 
 0.9975  | 
 1.0035  | 
 1417  | 
 97  | 
|  TEST_TIME  | 
 115  | 
 5822.90  | 
 0.9925  | 
 1.0051  | 
 975  | 
 100  | 
|  TEST_TIME  | 
 116  | 
 5828.50  | 
 0.9954  | 
 1.0023  | 
 1226  | 
 100  | 
|  TEST_TIME  | 
 117  | 
 5830.71  | 
 0.9933  | 
 1.0052  | 
 1103  | 
 99  | 
|  TEST_TIME  | 
 118  | 
 5822.99  | 
 0.9980  | 
 1.0026  | 
 1169  | 
 100  | 
|  TEST_TIME  | 
 119  | 
 5824.52  | 
 0.9963  | 
 1.0036  | 
 1131  | 
 100  | 
|  TEST_TIME  | 
 120  | 
 5831.10  | 
 0.9944  | 
 1.0048  | 
 1665  | 
 100  | 
|  TEST_TIME  | 
 121  | 
 5845.05  | 
 0.9941  | 
 1.0050  | 
 1886  | 
 100  | 
|  TEST_TIME  | 
 122  | 
 5850.51  | 
 0.9959  | 
 1.0055  | 
 1869  | 
 100  | 
|  TEST_TIME  | 
 123  | 
 5862.61  | 
 0.9953  | 
 1.0062  | 
 1567  | 
 96  | 
|  TEST_TIME  | 
 124  | 
 5868.07  | 
 0.9972  | 
 1.0062  | 
 1583  | 
 98  | 
|  TEST_TIME  | 
 125  | 
 5872.87  | 
 0.9974  | 
 1.0027  | 
 1664  | 
 98  | 
|  TEST_TIME  | 
 126  | 
 5880.41  | 
 0.9935  | 
 1.0016  | 
 1311  | 
 99  | 
|  TEST_TIME  | 
 127  | 
 5869.60  | 
 0.9956  | 
 1.0042  | 
 1209  | 
 95  | 
|  TEST_TIME  | 
 128  | 
 5874.94  | 
 0.9955  | 
 1.0044  | 
 1492  | 
 98  | 
|  TEST_TIME  | 
 129  | 
 5885.87  | 
 0.9956  | 
 1.0036  | 
 1362  | 
 98  | 
|  TEST_TIME  | 
 130  | 
 5876.09  | 
 0.9975  | 
 1.0037  | 
 1249  | 
 95  | 
|  TEST_TIME  | 
 131  | 
 5896.93  | 
 0.9925  | 
 1.0031  | 
 1084  | 
 100  | 
|  TEST_TIME  | 
 132  | 
 5889.78  | 
 0.9967  | 
 1.0042  | 
 1316  | 
 98  | 
|  TEST_TIME  | 
 133  | 
 5896.88  | 
 0.9954  | 
 1.0039  | 
 1136  | 
 100  | 
|  TEST_TIME  | 
 134  | 
 5912.94  | 
 0.9939  | 
 1.0036  | 
 1114  | 
 100  | 
|  TEST_TIME  | 
 135  | 
 5920.93  | 
 0.9948  | 
 1.0037  | 
 1656  | 
 98  | 
|  TEST_TIME  | 
 136  | 
 5908.94  | 
 0.9983  | 
 1.0017  | 
 1251  | 
 79  | 
|  TEST_TIME  | 
 137  | 
 5893.26  | 
 0.9971  | 
 1.0031  | 
 1293  | 
 80  | 
|  TEST_TIME  | 
 138  | 
 5894.76  | 
 0.9955  | 
 1.0034  | 
 1574  | 
 85  | 
|  TEST_TIME  | 
 139  | 
 5905.15  | 
 0.9944  | 
 1.0049  | 
 1511  | 
 99  | 
|  TEST_TIME  | 
 140  | 
 5925.44  | 
 0.9947  | 
 1.0048  | 
 1413  | 
 100  | 
|  TEST_TIME  | 
 141  | 
 5929.73  | 
 0.9970  | 
 1.0022  | 
 1396  | 
 99  | 
|  TEST_TIME  | 
 142  | 
 5925.88  | 
 0.9958  | 
 1.0032  | 
 1650  | 
 99  | 
|  TEST_TIME  | 
 143  | 
 5937.85  | 
 0.9942  | 
 1.0025  | 
 1398  | 
 98  | 
|  TEST_TIME  | 
 144  | 
 5929.82  | 
 0.9969  | 
 1.0031  | 
 1446  | 
 96  | 
|  TEST_TIME  | 
 145  | 
 5939.53  | 
 0.9950  | 
 1.0021  | 
 1350  | 
 100  | 
|  TEST_TIME  | 
 146  | 
 5936.52  | 
 0.9958  | 
 1.0026  | 
 1276  | 
 100  | 
|  TEST_TIME  | 
 147  | 
 5940.31  | 
 0.9952  | 
 1.0030  | 
 1272  | 
 100  | 
|  TEST_TIME  | 
 148  | 
 5930.96  | 
 0.9978  | 
 1.0021  | 
 1424  | 
 100  | 
|  TEST_TIME  | 
 149  | 
 5921.19  | 
 0.9970  | 
 1.0036  | 
 1298  | 
 97  | 
|  TEST_TIME  | 
 150  | 
 5932.37  | 
 0.9963  | 
 1.0029  | 
 1769  | 
 100  | 
|  TEST_TIME  | 
 151  | 
 5951.58  | 
 0.9932  | 
 1.0027  | 
 1613  | 
 98  | 
|  TEST_TIME  | 
 152  | 
 5943.39  | 
 0.9975  | 
 1.0027  | 
 1492  | 
 87  | 
|  TEST_TIME  | 
 153  | 
 5954.08  | 
 0.9944  | 
 1.0030  | 
 1431  | 
 96  | 
|  TEST_TIME  | 
 154  | 
 5960.67  | 
 0.9953  | 
 1.0027  | 
 1356  | 
 96  | 
|  TEST_TIME  | 
 155  | 
 5956.16  | 
 0.9970  | 
 1.0020  | 
 1181  | 
 79  | 
|  TEST_TIME  | 
 156  | 
 5953.23  | 
 0.9961  | 
 1.0020  | 
 1166  | 
 93  | 
|  TEST_TIME  | 
 157  | 
 5950.99  | 
 0.9980  | 
 1.0019  | 
 1466  | 
 98  | 
|  TEST_TIME  | 
 158  | 
 5960.91  | 
 0.9955  | 
 1.0031  | 
 1308  | 
 100  | 
|  TEST_TIME  | 
 159  | 
 5960.18  | 
 0.9984  | 
 1.0021  | 
 1345  | 
 95  | 
|  TEST_TIME  | 
 160  | 
 5962.35  | 
 0.9955  | 
 1.0028  | 
 1201  | 
 100  | 
|  TEST_TIME  | 
 161  | 
 5960.95  | 
 0.9968  | 
 1.0021  | 
 1194  | 
 99  | 
|  TEST_TIME  | 
 162  | 
 5949.88  | 
 0.9978  | 
 1.0044  | 
 1192  | 
 97  | 
|  TEST_TIME  | 
 163  | 
 5950.37  | 
 0.9982  | 
 1.0036  | 
 1099  | 
 100  | 
|  TEST_TIME  | 
 164  | 
 5951.37  | 
 0.9979  | 
 1.0030  | 
 1191  | 
 99  | 
|  TEST_TIME  | 
 165  | 
 5962.83  | 
 0.9950  | 
 1.0049  | 
 1605  | 
 100  | 
|  TEST_TIME  | 
 166  | 
 5967.32  | 
 0.9981  | 
 1.0018  | 
 1859  | 
 99  | 
|  TEST_TIME  | 
 167  | 
 5967.17  | 
 0.9958  | 
 1.0030  | 
 1462  | 
 95  | 
|  TEST_TIME  | 
 168  | 
 5967.44  | 
 0.9970  | 
 1.0026  | 
 1767  | 
 94  | 
|  TEST_TIME  | 
 169  | 
 5964.65  | 
 0.9971  | 
 1.0024  | 
 1643  | 
 92  | 
|  TEST_TIME  | 
 170  | 
 5962.80  | 
 0.9969  | 
 1.0042  | 
 1348  | 
 90  | 
|  TEST_TIME  | 
 171  | 
 5988.56  | 
 0.9941  | 
 1.0015  | 
 1119  | 
 97  | 
|  TEST_TIME  | 
 172  | 
 5971.21  | 
 0.9986  | 
 1.0018  | 
 1103  | 
 93  | 
|  TEST_TIME  | 
 173  | 
 5958.84  | 
 0.9981  | 
 1.0033  | 
 1391  | 
 96  | 
|  TEST_TIME  | 
 174  | 
 5960.55  | 
 0.9973  | 
 1.0040  | 
 1345  | 
 100  | 
|  TEST_TIME  | 
 175  | 
 5959.86  | 
 0.9983  | 
 1.0016  | 
 1410  | 
 98  | 
|  TEST_TIME  | 
 176  | 
 5952.50  | 
 0.9971  | 
 1.0037  | 
 1135  | 
 99  | 
|  TEST_TIME  | 
 177  | 
 5962.55  | 
 0.9964  | 
 1.0030  | 
 1193  | 
 100  | 
|  TEST_TIME  | 
 178  | 
 5957.57  | 
 0.9982  | 
 1.0016  | 
 1240  | 
 100  | 
|  TEST_TIME  | 
 179  | 
 5955.60  | 
 0.9964  | 
 1.0011  | 
 1169  | 
 98  | 
|  TEST_TIME  | 
 180  | 
 5934.10  | 
 0.9991  | 
 1.0020  | 
 903  | 
 97  | 
 
Done for 9710 ms, from  6:57:28.26 to  6:57:37.97.  
 
 
|  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  | 
 56560  | 
 29260  | 
 60039  | 
 92331  | 
 49036  | 
 24340  | 
 71306  | 
 77247  | 
 33955  | 
 57954  | 
 63717  | 
 74789  | 
 78139  | 
 59539  | 
 149994  | 
 <null>  | 
 <null>  | 
 66964  | 
 <null>  | 
 03:46:46  | 
 04:04:46  | 
|  fetches per second  | 
 2  | 
 32511  | 
 93346  | 
 33964  | 
 <null>  | 
 29901  | 
 80558  | 
 51348  | 
 69705  | 
 70340  | 
 74169  | 
 52932  | 
 40998  | 
 31112  | 
 <null>  | 
 74286  | 
 31541  | 
 148445  | 
 472550  | 
 <null>  | 
 04:04:47  | 
 04:22:47  | 
|  fetches per second  | 
 3  | 
 5163  | 
 34302  | 
 12781  | 
 9317  | 
 14352  | 
 13979  | 
 22827  | 
 71630  | 
 11148  | 
 3531  | 
 21008  | 
 2193  | 
 11331  | 
 40519  | 
 24767  | 
 <null>  | 
 91882  | 
 208380  | 
 <null>  | 
 04:22:48  | 
 04:40:48  | 
|  fetches per second  | 
 4  | 
 20156  | 
 42910  | 
 14722  | 
 <null>  | 
 14059  | 
 43176  | 
 36545  | 
 <null>  | 
 21820  | 
 108917  | 
 19455  | 
 2045  | 
 68586  | 
 4807  | 
 38243  | 
 2867  | 
 299343  | 
 457867  | 
 <null>  | 
 04:40:49  | 
 04:58:49  | 
|  fetches per second  | 
 5  | 
 20188  | 
 37734  | 
 27682  | 
 <null>  | 
 19800  | 
 4870  | 
 53275  | 
 45786  | 
 70607  | 
 29552  | 
 19121  | 
 2004  | 
 22321  | 
 81041  | 
 65622  | 
 42523  | 
 63124  | 
 355947  | 
 <null>  | 
 04:58:50  | 
 05:16:50  | 
|  fetches per second  | 
 6  | 
 16364  | 
 2530  | 
 18013  | 
 <null>  | 
 26318  | 
 <null>  | 
 31233  | 
 7830  | 
 78289  | 
 1909  | 
 19880  | 
 1444  | 
 17194  | 
 23080  | 
 35742  | 
 67567  | 
 12697  | 
 12464  | 
 <null>  | 
 05:16:51  | 
 05:34:51  | 
|  fetches per second  | 
 7  | 
 13506  | 
 13655  | 
 14573  | 
 <null>  | 
 18249  | 
 1752  | 
 22061  | 
 3949  | 
 6860  | 
 2687  | 
 26920  | 
 15261  | 
 21090  | 
 66850  | 
 60610  | 
 4393  | 
 30381  | 
 268239  | 
 <null>  | 
 05:34:52  | 
 05:52:52  | 
|  fetches per second  | 
 8  | 
 5434  | 
 27075  | 
 8580  | 
 9620  | 
 9123  | 
 91641  | 
 26724  | 
 16708  | 
 1550  | 
 2517  | 
 14007  | 
 3807  | 
 8684  | 
 15221  | 
 17068  | 
 1314  | 
 20829  | 
 3115  | 
 <null>  | 
 05:52:53  | 
 06:10:53  | 
|  fetches per second  | 
 9  | 
 7245  | 
 6417  | 
 5400  | 
 <null>  | 
 7916  | 
 <null>  | 
 30779  | 
 6557  | 
 8331  | 
 16291  | 
 23846  | 
 588  | 
 9043  | 
 9169  | 
 22156  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 06:10:54  | 
 06:28:54  | 
|  fetches per second  | 
 10  | 
 9381  | 
 8483  | 
 16217  | 
 127962  | 
 12048  | 
 <null>  | 
 45762  | 
 11962  | 
 2501  | 
 14293  | 
 10843  | 
 10581  | 
 26773  | 
 5966  | 
 11443  | 
 <null>  | 
 <null>  | 
 20687  | 
 <null>  | 
 06:28:55  | 
 06:46:55  | 
|  marks per second  | 
 1  | 
 12393  | 
 3963  | 
 13106  | 
 16379  | 
 10845  | 
 5645  | 
 9574  | 
 13724  | 
 2921  | 
 11311  | 
 10531  | 
 12766  | 
 6291  | 
 10724  | 
 5868  | 
 <null>  | 
 <null>  | 
 5547  | 
 <null>  | 
 03:46:46  | 
 04:04:46  | 
|  marks per second  | 
 2  | 
 6812  | 
 11320  | 
 7423  | 
 <null>  | 
 6466  | 
 20021  | 
 6670  | 
 10626  | 
 14388  | 
 10990  | 
 7340  | 
 6613  | 
 2873  | 
 <null>  | 
 3187  | 
 4583  | 
 21483  | 
 56533  | 
 <null>  | 
 04:04:47  | 
 04:22:47  | 
|  marks per second  | 
 3  | 
 1124  | 
 4465  | 
 2539  | 
 1879  | 
 2336  | 
 2962  | 
 2818  | 
 13382  | 
 1748  | 
 693  | 
 2795  | 
 336  | 
 628  | 
 6480  | 
 2151  | 
 <null>  | 
 7995  | 
 10762  | 
 <null>  | 
 04:22:48  | 
 04:40:48  | 
|  marks per second  | 
 4  | 
 4051  | 
 5584  | 
 2796  | 
 <null>  | 
 2940  | 
 10975  | 
 4659  | 
 <null>  | 
 1677  | 
 18215  | 
 1738  | 
 343  | 
 3031  | 
 801  | 
 3674  | 
 537  | 
 7407  | 
 26176  | 
 <null>  | 
 04:40:49  | 
 04:58:49  | 
|  marks per second  | 
 5  | 
 4191  | 
 4895  | 
 6034  | 
 <null>  | 
 4300  | 
 1084  | 
 6699  | 
 8355  | 
 6713  | 
 4588  | 
 2872  | 
 373  | 
 1186  | 
 12416  | 
 7583  | 
 8514  | 
 2127  | 
 25443  | 
 <null>  | 
 04:58:50  | 
 05:16:50  | 
|  marks per second  | 
 6  | 
 3402  | 
 317  | 
 3603  | 
 <null>  | 
 5461  | 
 <null>  | 
 3577  | 
 1057  | 
 10964  | 
 259  | 
 1702  | 
 246  | 
 798  | 
 2816  | 
 3479  | 
 9138  | 
 304  | 
 489  | 
 <null>  | 
 05:16:51  | 
 05:34:51  | 
|  marks per second  | 
 7  | 
 2742  | 
 1830  | 
 2543  | 
 <null>  | 
 3447  | 
 419  | 
 2458  | 
 570  | 
 540  | 
 480  | 
 2934  | 
 2685  | 
 1156  | 
 11180  | 
 5904  | 
 350  | 
 7094  | 
 14936  | 
 <null>  | 
 05:34:52  | 
 05:52:52  | 
|  marks per second  | 
 8  | 
 1120  | 
 3354  | 
 1663  | 
 1430  | 
 1990  | 
 21796  | 
 2691  | 
 2498  | 
 202  | 
 376  | 
 2000  | 
 600  | 
 282  | 
 2304  | 
 1356  | 
 189  | 
 741  | 
 69  | 
 <null>  | 
 05:52:53  | 
 06:10:53  | 
|  marks per second  | 
 9  | 
 1456  | 
 803  | 
 880  | 
 <null>  | 
 1424  | 
 <null>  | 
 3569  | 
 892  | 
 1384  | 
 2461  | 
 4013  | 
 81  | 
 440  | 
 1419  | 
 2266  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 06:10:54  | 
 06:28:54  | 
|  marks per second  | 
 10  | 
 1911  | 
 1083  | 
 2693  | 
 21026  | 
 2007  | 
 <null>  | 
 5631  | 
 1699  | 
 251  | 
 3206  | 
 1268  | 
 1698  | 
 853  | 
 801  | 
 1451  | 
 <null>  | 
 <null>  | 
 304  | 
 <null>  | 
 06:28:55  | 
 06:46:55  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 03:46:46  | 
 04:04:46  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:04:47  | 
 04:22:47  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:22:48  | 
 04:40:48  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:40:49  | 
 04:58:49  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:58:50  | 
 05:16:50  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:16:51  | 
 05:34:51  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:34:52  | 
 05:52:52  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:52:53  | 
 06:10:53  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 06:10:54  | 
 06:28:54  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 06:28:55  | 
 06:46:55  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 03:46:46  | 
 04:04:46  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:04:47  | 
 04:22:47  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 1  | 
 <null>  | 
 04:22:48  | 
 04:40:48  | 
|  writes/marks*100  | 
 4  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 4  | 
 0  | 
 <null>  | 
 04:40:49  | 
 04:58:49  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 3  | 
 0  | 
 <null>  | 
 04:58:50  | 
 05:16:50  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 05:16:51  | 
 05:34:51  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 2  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 3  | 
 0  | 
 <null>  | 
 05:34:52  | 
 05:52:52  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 3  | 
 0  | 
 <null>  | 
 05:52:53  | 
 06:10:53  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 06:10:54  | 
 06:28:54  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 06:28:55  | 
 06:46:55  | 
 
Done for 9130 ms, from  6:57:39.04 to  6:57:48.17.  
 
 
|  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  | 
 1860711  | 
 1733350  | 
 127361  | 
 6.84  | 
 0  | 
 7987  | 
 52  | 
 126619  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  doc_list_biud  | 
 1861058  | 
 1733350  | 
 127708  | 
 6.86  | 
 0  | 
 6771  | 
 18  | 
 127003  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_add_invoice_to_stock  | 
 19210  | 
 11723  | 
 7487  | 
 38.97  | 
 15  | 
 227215  | 
 13138  | 
 7475  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_cancel_adding_invoice  | 
 4276  | 
 3377  | 
 899  | 
 21.02  | 
 0  | 
 59452  | 
 2885  | 
 899  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_cancel_client_order  | 
 6612  | 
 6475  | 
 137  | 
 2.07  | 
 0  | 
 3448  | 
 282  | 
 137  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_cancel_customer_reserve  | 
 312232  | 
 195176  | 
 117056  | 
 37.49  | 
 0  | 
 4243  | 
 70  | 
 117056  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_cancel_pay_from_customer  | 
 2524  | 
 2508  | 
 16  | 
 0.63  | 
 0  | 
 2044  | 
 157  | 
 16  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_cancel_pay_to_supplier  | 
 1493  | 
 1484  | 
 9  | 
 0.60  | 
 0  | 
 2325  | 
 170  | 
 9  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_cancel_supplier_invoice  | 
 9283  | 
 7053  | 
 2230  | 
 24.02  | 
 0  | 
 7566  | 
 514  | 
 2230  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_cancel_supplier_order  | 
 1538  | 
 514  | 
 1024  | 
 66.57  | 
 32  | 
 238103  | 
 23446  | 
 1024  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_cancel_write_off  | 
 24013  | 
 16547  | 
 7466  | 
 31.09  | 
 0  | 
 3994  | 
 172  | 
 7466  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_client_order  | 
 79919  | 
 79919  | 
 0  | 
 0.00  | 
 0  | 
 4851  | 
 546  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_customer_reserve  | 
 615098  | 
 614714  | 
 384  | 
 0.06  | 
 0  | 
 7566  | 
 209  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_fill_shopping_cart  | 
 121188  | 
 120911  | 
 277  | 
 0.22  | 
 0  | 
 2870  | 
 105  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_fill_shopping_cart_clo_res  | 
 615104  | 
 614714  | 
 390  | 
 0.06  | 
 0  | 
 1872  | 
 14  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_get_clo_for_invoice  | 
 11735  | 
 11723  | 
 12  | 
 0.10  | 
 0  | 
 4461  | 
 336  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_kill_cost_storno  | 
 31977  | 
 23916  | 
 8061  | 
 25.20  | 
 0  | 
 3791  | 
 25  | 
 8061  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 657442  | 
 414466  | 
 242976  | 
 36.95  | 
 0  | 
 6646  | 
 27  | 
 242976  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_kill_qty_storno  | 
 404480  | 
 277539  | 
 126941  | 
 31.38  | 
 0  | 
 6739  | 
 82  | 
 126929  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_lock_selected_doc  | 
 78796  | 
 67973  | 
 10823  | 
 13.73  | 
 0  | 
 1731  | 
 8  | 
 10811  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_make_cost_storno  | 
 96904  | 
 96892  | 
 12  | 
 0.01  | 
 0  | 
 7316  | 
 434  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_multiply_rows_for_pdistr  | 
 96904  | 
 96892  | 
 12  | 
 0.01  | 
 0  | 
 2216  | 
 66  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_multiply_rows_for_qdistr  | 
 79919  | 
 79919  | 
 0  | 
 0.00  | 
 0  | 
 2917  | 
 182  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_pay_from_customer  | 
 26735  | 
 26735  | 
 0  | 
 0.00  | 
 15  | 
 7347  | 
 954  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_pay_to_supplier  | 
 21760  | 
 21760  | 
 0  | 
 0.00  | 
 0  | 
 6536  | 
 589  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_payment_common  | 
 48495  | 
 48495  | 
 0  | 
 0.00  | 
 0  | 
 3073  | 
 69  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_qd_handle_on_cancel_clo  | 
 6607  | 
 6475  | 
 132  | 
 1.99  | 
 0  | 
 2418  | 
 124  | 
 132  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 15855  | 
 15100  | 
 755  | 
 4.76  | 
 0  | 
 6193  | 
 387  | 
 743  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 36674  | 
 36674  | 
 0  | 
 0.00  | 
 0  | 
 4040  | 
 60  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_reserve_write_off  | 
 37896  | 
 36674  | 
 1222  | 
 3.22  | 
 0  | 
 8954  | 
 635  | 
 1222  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_supplier_invoice  | 
 20676  | 
 20555  | 
 121  | 
 0.58  | 
 0  | 
 32494  | 
 3360  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  sp_supplier_order  | 
 20593  | 
 20437  | 
 156  | 
 0.75  | 
 0  | 
 13993  | 
 2374  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  srv_find_qd_qs_mism  | 
 1106135  | 
 979201  | 
 126934  | 
 11.47  | 
 0  | 
 5850  | 
 29  | 
 126557  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  srv_make_invnt_saldo  | 
 1526  | 
 1526  | 
 0  | 
 0.00  | 
 31  | 
 22947  | 
 3423  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  srv_make_money_saldo  | 
 3097  | 
 3097  | 
 0  | 
 0.00  | 
 0  | 
 2777  | 
 77  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 1997  | 
 36349  | 
 14261  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 7530  | 
 7530  | 
 0  | 
 0.00  | 
 0  | 
 2543  | 
 120  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 669  | 
 669  | 
 0  | 
 0.00  | 
 0  | 
 2839  | 
 198  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_cancel_client_order  | 
 137  | 
 137  | 
 0  | 
 0.00  | 
 0  | 
 2684  | 
 113  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 76  | 
 76  | 
 0  | 
 0.00  | 
 0  | 
 921  | 
 95  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 16  | 
 16  | 
 0  | 
 0.00  | 
 0  | 
 749  | 
 96  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 9  | 
 9  | 
 0  | 
 0.00  | 
 0  | 
 686  | 
 155  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 610  | 
 610  | 
 0  | 
 0.00  | 
 0  | 
 1513  | 
 116  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 14563  | 
 14563  | 
 0  | 
 0.00  | 
 0  | 
 3588  | 
 118  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_cancel_write_off  | 
 27  | 
 27  | 
 0  | 
 0.00  | 
 0  | 
 983  | 
 159  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1222  | 
 1222  | 
 0  | 
 0.00  | 
 0  | 
 1514  | 
 74  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_supplier_invoice  | 
 121  | 
 121  | 
 0  | 
 0.00  | 
 0  | 
 764  | 
 96  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-abend:sp_supplier_order  | 
 156  | 
 156  | 
 0  | 
 0.00  | 
 0  | 
 1030  | 
 114  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 11723  | 
 11723  | 
 0  | 
 0.00  | 
 0  | 
 13884  | 
 661  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1325  | 
 1325  | 
 0  | 
 0.00  | 
 0  | 
 11014  | 
 853  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6475  | 
 6475  | 
 0  | 
 0.00  | 
 0  | 
 2059  | 
 82  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2582  | 
 2582  | 
 0  | 
 0.00  | 
 0  | 
 1981  | 
 82  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2508  | 
 2508  | 
 0  | 
 0.00  | 
 0  | 
 2153  | 
 65  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1484  | 
 1484  | 
 0  | 
 0.00  | 
 0  | 
 1248  | 
 58  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 926  | 
 926  | 
 0  | 
 0.00  | 
 0  | 
 1762  | 
 87  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 514  | 
 514  | 
 0  | 
 0.00  | 
 0  | 
 29188  | 
 1867  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3762  | 
 3762  | 
 0  | 
 0.00  | 
 0  | 
 1716  | 
 82  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_client_order  | 
 79919  | 
 79919  | 
 0  | 
 0.00  | 
 0  | 
 3245  | 
 99  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_customer_reserve  | 
 3700  | 
 3700  | 
 0  | 
 0.00  | 
 0  | 
 2933  | 
 68  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_pay_from_customer  | 
 26735  | 
 26735  | 
 0  | 
 0.00  | 
 0  | 
 2652  | 
 89  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 21760  | 
 21760  | 
 0  | 
 0.00  | 
 0  | 
 2543  | 
 75  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_reserve_write_off  | 
 36674  | 
 36674  | 
 0  | 
 0.00  | 
 0  | 
 2621  | 
 94  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_supplier_invoice  | 
 20555  | 
 20555  | 
 0  | 
 0.00  | 
 0  | 
 3198  | 
 88  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:sp_supplier_order  | 
 20437  | 
 20437  | 
 0  | 
 0.00  | 
 0  | 
 3089  | 
 87  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1526  | 
 1526  | 
 0  | 
 0.00  | 
 0  | 
 1123  | 
 36  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:srv_make_money_saldo  | 
 3097  | 
 3097  | 
 0  | 
 0.00  | 
 0  | 
 920  | 
 34  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 1529  | 
 275  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_add_invoice_to_stock  | 
 38420  | 
 23446  | 
 14974  | 
 38.97  | 
 0  | 
 1731  | 
 21  | 
 14950  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_all_customers  | 
 120252  | 
 120252  | 
 0  | 
 0.00  | 
 0  | 
 905  | 
 6  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_all_suppliers  | 
 82866  | 
 82312  | 
 554  | 
 0.66  | 
 0  | 
 2371  | 
 6  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_all_wares  | 
 159838  | 
 159838  | 
 0  | 
 0.00  | 
 0  | 
 1466  | 
 5  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_cancel_adding_invoice  | 
 3080  | 
 2650  | 
 430  | 
 13.96  | 
 0  | 
 3791  | 
 153  | 
 430  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_cancel_client_order  | 
 13224  | 
 12950  | 
 274  | 
 2.07  | 
 0  | 
 1435  | 
 7  | 
 274  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_cancel_customer_prepayment  | 
 5048  | 
 5016  | 
 32  | 
 0.63  | 
 0  | 
 795  | 
 9  | 
 32  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_cancel_customer_reserve  | 
 5316  | 
 5164  | 
 152  | 
 2.85  | 
 0  | 
 1092  | 
 11  | 
 152  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_cancel_payment_to_supplier  | 
 2986  | 
 2968  | 
 18  | 
 0.60  | 
 0  | 
 718  | 
 10  | 
 18  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_cancel_supplier_invoice  | 
 3072  | 
 1852  | 
 1220  | 
 39.71  | 
 0  | 
 1482  | 
 23  | 
 1220  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_cancel_supplier_order  | 
 3076  | 
 1028  | 
 2048  | 
 66.57  | 
 0  | 
 344  | 
 11  | 
 2048  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_cancel_write_off  | 
 7578  | 
 7524  | 
 54  | 
 0.71  | 
 0  | 
 2714  | 
 112  | 
 54  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_max_id_clo_ord  | 
 20593  | 
 20437  | 
 156  | 
 0.75  | 
 0  | 
 858  | 
 6  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_max_id_clo_res  | 
 3700  | 
 3700  | 
 0  | 
 0.00  | 
 0  | 
 1342  | 
 20  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_max_id_ord_sup  | 
 20676  | 
 20555  | 
 121  | 
 0.58  | 
 0  | 
 968  | 
 6  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_max_non_paid_invoice  | 
 21596  | 
 21596  | 
 0  | 
 0.00  | 
 0  | 
 780  | 
 7  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_max_non_paid_realizn  | 
 26735  | 
 26735  | 
 0  | 
 0.00  | 
 0  | 
 1045  | 
 7  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_min_id_clo_ord  | 
 20593  | 
 20437  | 
 156  | 
 0.75  | 
 0  | 
 2199  | 
 9  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_min_id_clo_res  | 
 3700  | 
 3700  | 
 0  | 
 0.00  | 
 0  | 
 1123  | 
 9  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_min_id_ord_sup  | 
 20676  | 
 20555  | 
 121  | 
 0.58  | 
 0  | 
 2028  | 
 9  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_min_non_paid_invoice  | 
 21760  | 
 21760  | 
 0  | 
 0.00  | 
 0  | 
 2418  | 
 10  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_min_non_paid_realizn  | 
 26735  | 
 26735  | 
 0  | 
 0.00  | 
 0  | 
 1170  | 
 10  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_our_firm  | 
 39586  | 
 39586  | 
 0  | 
 0.00  | 
 0  | 
 655  | 
 6  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  v_reserve_write_off  | 
 75792  | 
 73348  | 
 2444  | 
 3.22  | 
 0  | 
 1950  | 
 9  | 
 2444  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  x_lock_depdocs_on_canc_invoice  | 
 18176  | 
 9504  | 
 8672  | 
 47.71  | 
 0  | 
 1935  | 
 38  | 
 8672  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1538  | 
 514  | 
 1024  | 
 66.57  | 
 0  | 
 1467  | 
 75  | 
 1024  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  x_make_qstorno_1000_1200  | 
 20593  | 
 20437  | 
 156  | 
 0.75  | 
 0  | 
 12261  | 
 2143  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  x_make_qstorno_1200_2000  | 
 20676  | 
 20555  | 
 121  | 
 0.58  | 
 0  | 
 32214  | 
 3119  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  x_make_qstorno_2100_3300  | 
 615104  | 
 614714  | 
 390  | 
 0.06  | 
 0  | 
 7442  | 
 177  | 
 0  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
 
Done for 324560 ms, from  7:03:04.96 to  7:08:29.52.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 96  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2017-08-18 03:47  | 
 2017-08-18 06:43  | 
|  deadlock  | 
 93  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2017-08-18 03:48  | 
 2017-08-18 06:38  | 
|  deadlock  | 
 9432  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  deadlock  | 
 132  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2017-08-18 03:47  | 
 2017-08-18 06:46  | 
|  deadlock  | 
 158  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2017-08-18 03:47  | 
 2017-08-18 06:44  | 
|  deadlock  | 
 654  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2017-08-18 03:46  | 
 2017-08-18 06:46  | 
|  deadlock  | 
 239  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2017-08-18 03:56  | 
 2017-08-18 06:43  | 
|  user_exc  | 
 156  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2017-08-18 03:47  | 
 2017-08-18 06:45  | 
|  user_exc  | 
 121  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2017-08-18 03:46  | 
 2017-08-18 06:45  | 
|  user_exc  | 
 12  | 
 x_make_qstorno_2100_3300  | 
 335544517  | 
 2017-08-18 06:46  | 
 2017-08-18 06:46  | 
 
Done for 9930 ms, from  7:08:37.08 to  7:08:47.01.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          428344
 
MON$OLDEST_ACTIVE               428345
 
MON$OLDEST_SNAPSHOT             428345
 
MON$NEXT_TRANSACTION            428345
 
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:12:20.4040
 
MON$PAGES                       803520
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.3.32798 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32798 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		428531 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	428346 
 
Oldest active		428347 
 
Oldest snapshot		428347 
 
Next transaction	428348 
 
Sequence number		0 
 
Next attachment ID	9500 
 
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:12:20 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file 
 
 
Analyzing database pages ... 
 
AGENTS (154) 
 
Primary pointer page: 311, Index root page: 312 
 
Total formats: 1, used formats: 1 
 
Average record length: 33.58, 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.24 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 31% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_ID_DESC (2) 
 
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_OUR_FIRM (4) 
 
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 48 
 
Average key length: 2.04, compression ratio: 0.50 
 
Average prefix length: 0.96, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_SUPPLIER (3) 
 
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 44 
 
Average key length: 2.04, compression ratio: 0.54 
 
Average prefix length: 1.04, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_NAME_UNQ (1) 
 
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.16, total dup: 0, max dup: 0 
 
Average key length: 15.86, compression ratio: 0.92 
 
Average prefix length: 1.44, average data length: 13.16 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_AGENTS (0) 
 
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
BUSINESS_OPS (158) 
 
Primary pointer page: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 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: 336, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 18.00, total dup: 0, max dup: 0 
 
Average key length: 16.95, compression ratio: 1.25 
 
Average prefix length: 7.21, average data length: 14.00 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BUSINESS_OPS_RND_WGTH (2) 
 
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 4.05, total dup: 7, max dup: 3 
 
Average key length: 3.00, compression ratio: 0.75 
 
Average prefix length: 1.42, average data length: 0.84 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RDB$1 (0) 
 
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 5.26, total dup: 0, max dup: 0 
 
Average key length: 4.21, compression ratio: 0.64 
 
Average prefix length: 1.05, average data length: 1.63 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
DOC_DATA (141) 
 
Primary pointer page: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.07, total records: 2123257 
 
Average version length: 47.80, total versions: 2986, 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: 23008 
 
Data pages: 23008, average fill: 73% 
 
Primary pages: 23008, secondary pages: 0, swept pages: 13642 
 
Empty pages: 2, full pages: 19715 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 13 
 
40 - 59% = 102 
 
60 - 79% = 22889 
 
80 - 99% = 1 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10333, nodes: 2123257 
 
Average node length: 19.33, total dup: 0, max dup: 0 
 
Average key length: 16.38, compression ratio: 1.65 
 
Average prefix length: 13.62, average data length: 13.38 
 
Clustering factor: 478038, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 668 
 
20 - 39% = 2246 
 
40 - 59% = 4969 
 
60 - 79% = 1103 
 
80 - 99% = 1347 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7623, nodes: 2123257 
 
Average node length: 11.65, total dup: 0, max dup: 0 
 
Average key length: 8.70, compression ratio: 1.03 
 
Average prefix length: 3.30, average data length: 5.70 
 
Clustering factor: 450041, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 3587 
 
40 - 59% = 3958 
 
60 - 79% = 74 
 
80 - 99% = 4 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 175842, depth: 3, leaf buckets: 3788, nodes: 2123257 
 
Average node length: 6.83, total dup: 1543630, max dup: 49 
 
Average key length: 3.88, compression ratio: 2.32 
 
Average prefix length: 7.40, average data length: 1.60 
 
Clustering factor: 438567, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 152 
 
20 - 39% = 1232 
 
40 - 59% = 1679 
 
60 - 79% = 227 
 
80 - 99% = 498 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.36, total records: 644060 
 
Average version length: 35.36, total versions: 1265, max versions: 3 
 
Average fragment length: 39.50, total fragments: 4, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 5, data page slots: 8152 
 
Data pages: 8152, average fill: 75% 
 
Primary pages: 8149, secondary pages: 3, swept pages: 7507 
 
Empty pages: 0, full pages: 7555 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 9 
 
40 - 59% = 28 
 
60 - 79% = 8077 
 
80 - 99% = 33 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 239201, depth: 3, leaf buckets: 2417, nodes: 644060 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.83, compression ratio: 1.02 
 
Average prefix length: 3.17, average data length: 5.83 
 
Clustering factor: 166952, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1422 
 
40 - 59% = 968 
 
60 - 79% = 24 
 
80 - 99% = 3 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 674, nodes: 644060 
 
Average node length: 4.87, total dup: 644010, max dup: 44279 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 293888, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 572 
 
60 - 79% = 81 
 
80 - 99% = 21 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 316809, depth: 3, leaf buckets: 1971, nodes: 644060 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.82, compression ratio: 1.02 
 
Average prefix length: 3.17, average data length: 5.83 
 
Clustering factor: 166952, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 117 
 
20 - 39% = 701 
 
40 - 59% = 694 
 
60 - 79% = 204 
 
80 - 99% = 255 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 270, Index root page: 271 
 
Total formats: 1, used formats: 1 
 
Average record length: 66.71, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 19.60, total fragments: 389, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.56 
 
Pointer pages: 1, data page slots: 1200 
 
Data pages: 20, average fill: 33% 
 
Primary pages: 7, secondary pages: 13, swept pages: 4 
 
Empty pages: 6, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 6 
 
40 - 59% = 1 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 282, 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: 292, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 20.37, total records: 9282 
 
Average version length: 70.65, total versions: 6616, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 4.71 
 
Pointer pages: 1, data page slots: 544 
 
Data pages: 544, average fill: 24% 
 
Primary pages: 543, secondary pages: 1, swept pages: 258 
 
Empty pages: 74, full pages: 26 
 
Fill distribution: 
 
0 - 19% = 313 
 
20 - 39% = 107 
 
40 - 59% = 62 
 
60 - 79% = 55 
 
80 - 99% = 7 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 38, nodes: 9282 
 
Average node length: 13.28, total dup: 1497, max dup: 1 
 
Average key length: 11.29, compression ratio: 2.39 
 
Average prefix length: 18.54, average data length: 8.46 
 
Clustering factor: 7359, ratio: 0.79 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 21 
 
40 - 59% = 12 
 
60 - 79% = 5 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.08, total records: 49 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.12 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 20% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 273, 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: 260, Index root page: 261 
 
Total formats: 1, used formats: 1 
 
Average record length: 9.81, total records: 576 
 
Average version length: 45.85, total versions: 456, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 6.52 
 
Pointer pages: 1, data page slots: 48 
 
Data pages: 40, average fill: 16% 
 
Primary pages: 39, secondary pages: 1, swept pages: 11 
 
Empty pages: 18, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 29 
 
20 - 39% = 6 
 
40 - 59% = 2 
 
60 - 79% = 2 
 
80 - 99% = 1 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 334544, depth: 2, leaf buckets: 1, nodes: 576 
 
Average node length: 4.91, total dup: 510, max dup: 47 
 
Average key length: 3.60, compression ratio: 5.27 
 
Average prefix length: 17.51, average data length: 1.49 
 
Clustering factor: 325, ratio: 0.56 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (165) 
 
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 MON_LOG_DTS (4) 
 
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_GDSCODE (2) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
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 PK_MON_LOG (0) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (166) 
 
Primary pointer page: 366, Index root page: 367 
 
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: 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_GDSCODE (2) 
 
Root page: 371, 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: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
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 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.19, total records: 208913 
 
Average version length: 29.23, total versions: 4094, max versions: 10 
 
Average fragment length: 34.00, total fragments: 1, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.52 
 
Pointer pages: 2, data page slots: 2352 
 
Data pages: 2352, average fill: 67% 
 
Primary pages: 2341, secondary pages: 11, swept pages: 1735 
 
Empty pages: 15, full pages: 685 
 
Fill distribution: 
 
0 - 19% = 36 
 
20 - 39% = 93 
 
40 - 59% = 184 
 
60 - 79% = 2024 
 
80 - 99% = 15 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 195, nodes: 208913 
 
Average node length: 4.51, total dup: 208864, max dup: 9259 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 35017, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 14 
 
40 - 59% = 89 
 
60 - 79% = 78 
 
80 - 99% = 14 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 233, nodes: 208913 
 
Average node length: 5.48, total dup: 187862, max dup: 106 
 
Average key length: 2.98, compression ratio: 7.39 
 
Average prefix length: 21.12, average data length: 0.88 
 
Clustering factor: 45204, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 22 
 
40 - 59% = 84 
 
60 - 79% = 93 
 
80 - 99% = 32 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 223, nodes: 208913 
 
Average node length: 5.48, total dup: 187862, max dup: 106 
 
Average key length: 2.98, compression ratio: 7.39 
 
Average prefix length: 21.12, average data length: 0.88 
 
Clustering factor: 45380, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 10 
 
40 - 59% = 85 
 
60 - 79% = 87 
 
80 - 99% = 41 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 220, nodes: 208913 
 
Average node length: 5.26, total dup: 187862, max dup: 106 
 
Average key length: 2.76, compression ratio: 3.26 
 
Average prefix length: 8.34, average data length: 0.66 
 
Clustering factor: 45386, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 17 
 
40 - 59% = 88 
 
60 - 79% = 76 
 
80 - 99% = 38 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.97, total records: 265731 
 
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: 2272 
 
Data pages: 2272, average fill: 64% 
 
Primary pages: 2272, secondary pages: 0, swept pages: 0 
 
Empty pages: 2, full pages: 2269 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 2269 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 61129, depth: 2, leaf buckets: 212, nodes: 265731 
 
Average node length: 4.52, total dup: 265550, max dup: 2088 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.58, average data length: 0.00 
 
Clustering factor: 25505, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 77 
 
60 - 79% = 77 
 
80 - 99% = 58 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 1, used formats: 1 
 
Average record length: 151.67, total records: 11432446 
 
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.18 
 
Pointer pages: 167, data page slots: 271160 
 
Data pages: 271160, average fill: 87% 
 
Primary pages: 271160, secondary pages: 0, swept pages: 3 
 
Empty pages: 3, full pages: 271156 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 271156 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 12639, nodes: 11432446 
 
Average node length: 5.65, total dup: 10582411, max dup: 167 
 
Average key length: 2.18, compression ratio: 3.67 
 
Average prefix length: 7.86, average data length: 0.13 
 
Clustering factor: 4409628, ratio: 0.39 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 0 
 
40 - 59% = 6586 
 
60 - 79% = 3908 
 
80 - 99% = 2134 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 11296, nodes: 11432446 
 
Average node length: 4.56, total dup: 11432442, max dup: 10488690 
 
Average key length: 1.08, compression ratio: 0.38 
 
Average prefix length: 0.41, average data length: 0.00 
 
Clustering factor: 337251, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 11289 
 
60 - 79% = 3 
 
80 - 99% = 3 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 13717, nodes: 11432446 
 
Average node length: 5.71, total dup: 11070651, max dup: 20547 
 
Average key length: 2.23, compression ratio: 4.03 
 
Average prefix length: 8.80, average data length: 0.20 
 
Clustering factor: 1004776, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 9849 
 
60 - 79% = 2114 
 
80 - 99% = 1750 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 13838, nodes: 11432446 
 
Average node length: 5.55, total dup: 11404043, max dup: 1487691 
 
Average key length: 2.07, compression ratio: 18.24 
 
Average prefix length: 37.72, average data length: 0.07 
 
Clustering factor: 6560013, ratio: 0.57 
 
Fill distribution: 
 
0 - 19% = 19 
 
20 - 39% = 2 
 
40 - 59% = 11849 
 
60 - 79% = 615 
 
80 - 99% = 1353 
 
 
PHRASES (145) 
 
Primary pointer page: 266, Index root page: 267 
 
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: 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 
 
 
Index PHRASES_NAME (2) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.98, total records: 464016 
 
Average version length: 55.93, total versions: 1179, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.46 
 
Pointer pages: 4, data page slots: 5536 
 
Data pages: 5536, average fill: 74% 
 
Primary pages: 5536, secondary pages: 0, swept pages: 3749 
 
Empty pages: 9, full pages: 5014 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 9 
 
40 - 59% = 28 
 
60 - 79% = 5480 
 
80 - 99% = 1 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 603912, depth: 3, leaf buckets: 589, nodes: 464016 
 
Average node length: 5.89, total dup: 393939, max dup: 690 
 
Average key length: 3.10, compression ratio: 2.91 
 
Average prefix length: 8.05, average data length: 0.95 
 
Clustering factor: 61685, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 29 
 
40 - 59% = 323 
 
60 - 79% = 168 
 
80 - 99% = 61 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 494, nodes: 464016 
 
Average node length: 5.61, total dup: 413515, max dup: 105 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 113883, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 5 
 
40 - 59% = 204 
 
60 - 79% = 193 
 
80 - 99% = 92 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 3% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 12.50, total dup: 0, max dup: 0 
 
Average key length: 11.00, compression ratio: 0.82 
 
Average prefix length: 0.50, average data length: 8.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index SEMAPHORES_TASK_UNQ (1) 
 
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 22.50, total dup: 0, max dup: 0 
 
Average key length: 21.00, compression ratio: 1.07 
 
Average prefix length: 4.00, average data length: 18.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SETTINGS (137) 
 
Primary pointer page: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.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: 238, 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: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
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: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TRACE_STAT (162) 
 
Primary pointer page: 347, Index root page: 348 
 
Total formats: 1, used formats: 1 
 
Average record length: 57.85, total records: 2396 
 
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: 32 
 
Data pages: 32, average fill: 69% 
 
Primary pages: 32, secondary pages: 0, swept pages: 0 
 
Empty pages: 3, full pages: 28 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 29 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 264, Index root page: 265 
 
Total formats: 1, used formats: 1 
 
Average record length: 78.23, 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.73 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 78% 
 
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: 377, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 67 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 274, 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: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 276, 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: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400 
 
Average node length: 52.86, total dup: 0, max dup: 0 
 
Average key length: 51.84, compression ratio: 1.00 
 
Average prefix length: 2.73, average data length: 48.86 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (260) 
 
Primary pointer page: 292, Index root page: 295 
 
Total formats: 1, used formats: 1 
 
Average record length: 20.93, total records: 11046 
 
Average version length: 72.14, total versions: 7840, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 6.50 
 
Pointer pages: 2, data page slots: 912 
 
Data pages: 544, average fill: 27% 
 
Primary pages: 543, secondary pages: 1, swept pages: 262 
 
Empty pages: 182, full pages: 64 
 
Fill distribution: 
 
0 - 19% = 285 
 
20 - 39% = 89 
 
40 - 59% = 67 
 
60 - 79% = 69 
 
80 - 99% = 34 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 25, nodes: 11046 
 
Average node length: 6.30, total dup: 9514, max dup: 14 
 
Average key length: 4.28, compression ratio: 8.64 
 
Average prefix length: 34.85, average data length: 2.15 
 
Clustering factor: 1793, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 17 
 
40 - 59% = 5 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.72, total records: 1173096 
 
Average version length: 70.84, total versions: 6913, 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: 11, data page slots: 17112 
 
Data pages: 17088, average fill: 75% 
 
Primary pages: 17088, secondary pages: 0, swept pages: 10436 
 
Empty pages: 13, full pages: 14901 
 
Fill distribution: 
 
0 - 19% = 33 
 
20 - 39% = 53 
 
40 - 59% = 311 
 
60 - 79% = 16598 
 
80 - 99% = 93 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 366424, depth: 3, leaf buckets: 1346, nodes: 1173096 
 
Average node length: 5.13, total dup: 1142330, max dup: 123 
 
Average key length: 2.19, compression ratio: 4.10 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 139962, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 84 
 
40 - 59% = 985 
 
60 - 79% = 60 
 
80 - 99% = 192 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 245746, depth: 3, leaf buckets: 1665, nodes: 1173096 
 
Average node length: 6.26, total dup: 1024321, max dup: 27 
 
Average key length: 3.32, compression ratio: 11.15 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 231255, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 144 
 
40 - 59% = 1213 
 
60 - 79% = 136 
 
80 - 99% = 154 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 30.14, total records: 38316 
 
Average version length: 71.80, total versions: 22235, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 4.51 
 
Pointer pages: 3, data page slots: 2160 
 
Data pages: 1265, average fill: 38% 
 
Primary pages: 1264, secondary pages: 1, swept pages: 593 
 
Empty pages: 252, full pages: 280 
 
Fill distribution: 
 
0 - 19% = 462 
 
20 - 39% = 213 
 
40 - 59% = 195 
 
60 - 79% = 277 
 
80 - 99% = 118 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 88, nodes: 38316 
 
Average node length: 6.45, total dup: 33277, max dup: 45 
 
Average key length: 3.69, compression ratio: 10.02 
 
Average prefix length: 35.44, average data length: 1.56 
 
Clustering factor: 4508, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 63 
 
40 - 59% = 24 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.37, total records: 1606206 
 
Average version length: 71.69, total versions: 40362, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.93 
 
Pointer pages: 16, data page slots: 24752 
 
Data pages: 24720, average fill: 72% 
 
Primary pages: 24720, secondary pages: 0, swept pages: 13960 
 
Empty pages: 226, full pages: 18402 
 
Fill distribution: 
 
0 - 19% = 417 
 
20 - 39% = 714 
 
40 - 59% = 2013 
 
60 - 79% = 20695 
 
80 - 99% = 881 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 187908, depth: 3, leaf buckets: 2469, nodes: 1606206 
 
Average node length: 5.63, total dup: 1507110, max dup: 49 
 
Average key length: 2.67, compression ratio: 13.84 
 
Average prefix length: 36.39, average data length: 0.61 
 
Clustering factor: 223863, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 963 
 
40 - 59% = 1152 
 
60 - 79% = 200 
 
80 - 99% = 143 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 43.38, total records: 16546 
 
Average version length: 69.58, total versions: 6244, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 3.13 
 
Pointer pages: 3, data page slots: 1640 
 
Data pages: 1016, average fill: 21% 
 
Primary pages: 1015, secondary pages: 1, swept pages: 598 
 
Empty pages: 372, full pages: 58 
 
Fill distribution: 
 
0 - 19% = 641 
 
20 - 39% = 145 
 
40 - 59% = 113 
 
60 - 79% = 91 
 
80 - 99% = 26 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 50, nodes: 16546 
 
Average node length: 8.06, total dup: 12150, max dup: 31 
 
Average key length: 5.44, compression ratio: 6.80 
 
Average prefix length: 33.82, average data length: 3.18 
 
Clustering factor: 3222, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 39 
 
40 - 59% = 11 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.02, total records: 2736673 
 
Average version length: 71.27, total versions: 18309, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.91 
 
Pointer pages: 25, data page slots: 39216 
 
Data pages: 39216, average fill: 76% 
 
Primary pages: 39216, secondary pages: 0, swept pages: 28617 
 
Empty pages: 5, full pages: 34984 
 
Fill distribution: 
 
0 - 19% = 67 
 
20 - 39% = 103 
 
40 - 59% = 653 
 
60 - 79% = 37920 
 
80 - 99% = 473 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5676, nodes: 2736673 
 
Average node length: 6.87, total dup: 2219410, max dup: 14 
 
Average key length: 3.90, compression ratio: 9.50 
 
Average prefix length: 35.29, average data length: 1.71 
 
Clustering factor: 531642, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 3076 
 
40 - 59% = 2167 
 
60 - 79% = 275 
 
80 - 99% = 149 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.66, total records: 4654967 
 
Average version length: 84.65, total versions: 1957, 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: 44, data page slots: 71552 
 
Data pages: 71552, average fill: 80% 
 
Primary pages: 71552, secondary pages: 0, swept pages: 27013 
 
Empty pages: 8, full pages: 71155 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 7 
 
40 - 59% = 25 
 
60 - 79% = 21180 
 
80 - 99% = 50331 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4745, nodes: 4654967 
 
Average node length: 5.15, total dup: 4548890, max dup: 123 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 753658, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 79 
 
40 - 59% = 2081 
 
60 - 79% = 1954 
 
80 - 99% = 607 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 5235, nodes: 4654967 
 
Average node length: 5.69, total dup: 4170127, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 263616, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 43 
 
20 - 39% = 169 
 
40 - 59% = 3141 
 
60 - 79% = 333 
 
80 - 99% = 1549 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5276, nodes: 4654967 
 
Average node length: 5.81, total dup: 4072644, max dup: 29 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 808487, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 28 
 
20 - 39% = 105 
 
40 - 59% = 2278 
 
60 - 79% = 2028 
 
80 - 99% = 837 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.85, total records: 2360128 
 
Average version length: 83.84, total versions: 11038, 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: 23, data page slots: 37416 
 
Data pages: 37416, average fill: 78% 
 
Primary pages: 37416, secondary pages: 0, swept pages: 27747 
 
Empty pages: 46, full pages: 33720 
 
Fill distribution: 
 
0 - 19% = 110 
 
20 - 39% = 192 
 
40 - 59% = 840 
 
60 - 79% = 16206 
 
80 - 99% = 20068 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2560, nodes: 2360128 
 
Average node length: 5.15, total dup: 2304790, max dup: 175 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 371908, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 54 
 
40 - 59% = 1546 
 
60 - 79% = 731 
 
80 - 99% = 227 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4198, nodes: 2360128 
 
Average node length: 6.23, total dup: 1936426, max dup: 14 
 
Average key length: 3.25, compression ratio: 2.77 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 247889, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 111 
 
20 - 39% = 1858 
 
40 - 59% = 1623 
 
60 - 79% = 405 
 
80 - 99% = 201 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 2927, nodes: 2360128 
 
Average node length: 5.81, total dup: 2064187, max dup: 44 
 
Average key length: 2.84, compression ratio: 3.16 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 445041, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 65 
 
40 - 59% = 1805 
 
60 - 79% = 789 
 
80 - 99% = 244 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.58, total records: 4932731 
 
Average version length: 85.04, total versions: 14698, 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: 48, data page slots: 76832 
 
Data pages: 76800, average fill: 79% 
 
Primary pages: 76800, secondary pages: 0, swept pages: 21702 
 
Empty pages: 156, full pages: 73378 
 
Fill distribution: 
 
0 - 19% = 277 
 
20 - 39% = 393 
 
40 - 59% = 1073 
 
60 - 79% = 16617 
 
80 - 99% = 58440 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5265, nodes: 4932731 
 
Average node length: 5.04, total dup: 4903838, max dup: 682 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 730274, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 265 
 
40 - 59% = 3060 
 
60 - 79% = 1421 
 
80 - 99% = 515 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 6087, nodes: 4932731 
 
Average node length: 5.54, total dup: 4538122, max dup: 49 
 
Average key length: 2.55, compression ratio: 3.53 
 
Average prefix length: 8.53, average data length: 0.47 
 
Clustering factor: 284495, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 93 
 
20 - 39% = 1598 
 
40 - 59% = 2529 
 
60 - 79% = 630 
 
80 - 99% = 1237 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 5927, nodes: 4932731 
 
Average node length: 5.68, total dup: 4428868, max dup: 73 
 
Average key length: 2.70, compression ratio: 3.34 
 
Average prefix length: 8.41, average data length: 0.59 
 
Clustering factor: 810470, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 223 
 
40 - 59% = 3579 
 
60 - 79% = 1547 
 
80 - 99% = 572 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 761, Index root page: 762 
 
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: 763, 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: 765, 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: 764, 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: 767, Index root page: 776 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.29, total records: 3353614 
 
Average version length: 84.26, total versions: 11727, 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: 33, data page slots: 53104 
 
Data pages: 53096, average fill: 78% 
 
Primary pages: 53096, secondary pages: 0, swept pages: 39160 
 
Empty pages: 49, full pages: 48362 
 
Fill distribution: 
 
0 - 19% = 114 
 
20 - 39% = 212 
 
40 - 59% = 947 
 
60 - 79% = 22540 
 
80 - 99% = 29283 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3680, nodes: 3353614 
 
Average node length: 5.03, total dup: 3336665, max dup: 1169 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 718655, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 391 
 
40 - 59% = 2021 
 
60 - 79% = 855 
 
80 - 99% = 392 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 6043, nodes: 3353614 
 
Average node length: 6.24, total dup: 2746988, max dup: 14 
 
Average key length: 3.26, compression ratio: 2.76 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 394688, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 187 
 
20 - 39% = 2786 
 
40 - 59% = 2240 
 
60 - 79% = 539 
 
80 - 99% = 291 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 3976, nodes: 3353614 
 
Average node length: 5.60, total dup: 3055325, max dup: 80 
 
Average key length: 2.62, compression ratio: 3.44 
 
Average prefix length: 8.47, average data length: 0.53 
 
Clustering factor: 758439, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 344 
 
40 - 59% = 2041 
 
60 - 79% = 1126 
 
80 - 99% = 457 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.32, total records: 625046 
 
Average version length: 69.97, total versions: 1523, 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: 8800 
 
Data pages: 8800, average fill: 75% 
 
Primary pages: 8800, secondary pages: 0, swept pages: 6804 
 
Empty pages: 8, full pages: 7853 
 
Fill distribution: 
 
0 - 19% = 45 
 
20 - 39% = 99 
 
40 - 59% = 232 
 
60 - 79% = 8381 
 
80 - 99% = 43 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 176227, depth: 3, leaf buckets: 768, nodes: 625046 
 
Average node length: 5.31, total dup: 589101, max dup: 119 
 
Average key length: 2.44, compression ratio: 3.69 
 
Average prefix length: 8.62, average data length: 0.38 
 
Clustering factor: 53803, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 188 
 
40 - 59% = 323 
 
60 - 79% = 173 
 
80 - 99% = 79 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 863, nodes: 625046 
 
Average node length: 5.92, total dup: 534133, max dup: 21 
 
Average key length: 3.05, compression ratio: 2.95 
 
Average prefix length: 8.10, average data length: 0.90 
 
Clustering factor: 57627, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 210 
 
40 - 59% = 387 
 
60 - 79% = 178 
 
80 - 99% = 86 
 
 
ZDOC_DATA (230) 
 
Primary pointer page: 644, Index root page: 645 
 
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: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (231) 
 
Primary pointer page: 646, Index root page: 647 
 
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: 652, Index root page: 653 
 
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: 662, 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: 654, Index root page: 655 
 
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: 663, 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: 648, Index root page: 649 
 
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: 656, 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: 657, 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: 650, Index root page: 651 
 
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: 659, 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: 658, 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: 661, 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: 660, 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: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (227) 
 
Primary pointer page: 614, Index root page: 615 
 
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: 268, Index root page: 269 
 
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: 281, 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 162230 ms, from  7:08:47.30 to  7:11:29.53. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2123257  | 
 2986  | 
 0.1406  | 
|  DOC_LIST  | 
 644060  | 
 1265  | 
 0.1964  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 9282  | 
 6616  | 
 71.2777  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 576  | 
 456  | 
 79.1666  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 208913  | 
 4094  | 
 1.9596  | 
|  PERF_ESTIMATED  | 
 265731  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 11432446  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 464016  | 
 1179  | 
 0.2540  | 
|  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  | 
 2396  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 11046  | 
 7840  | 
 70.9759  | 
|  XQD_1000_3300  | 
 1173096  | 
 6913  | 
 0.5892  | 
|  XQD_1200_2000  | 
 38316  | 
 22235  | 
 58.0305  | 
|  XQD_2000_3300  | 
 1606206  | 
 40362  | 
 2.5128  | 
|  XQD_2100_3300  | 
 16546  | 
 6244  | 
 37.7372  | 
|  XQD_3300_3400  | 
 2736673  | 
 18309  | 
 0.6690  | 
|  XQS_1000_1200  | 
 4654967  | 
 1957  | 
 0.0420  | 
|  XQS_1000_3300  | 
 2360128  | 
 11038  | 
 0.4676  | 
|  XQS_1200_2000  | 
 4932731  | 
 14698  | 
 0.2979  | 
|  XQS_2100_3300  | 
 3353614  | 
 11727  | 
 0.3496  | 
|  XQS_3300_3400  | 
 625046  | 
 1523  | 
 0.2436  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 1570 ms, from  7:11:42.34 to  7:11:43.91.  
07:11:44.04 Validation started 
 
 
07:11:44.05 Relation 140 (DOC_LIST) 
 
07:11:44.05   process pointer page    0 of    5 
 
07:11:44.16   process pointer page    1 of    5 
 
07:11:44.27   process pointer page    2 of    5 
 
07:11:44.32   process pointer page    3 of    5 
 
07:11:44.36   process pointer page    4 of    5 
 
07:11:44.41 Index 1 (PK_DOC_LIST) 
 
07:11:44.61 Index 2 (DOC_LIST_ID_DESC) 
 
07:11:44.85 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:11:44.94 Relation 140 (DOC_LIST) is ok 
 
 
07:11:44.94 Relation 141 (DOC_DATA) 
 
07:11:44.94   process pointer page    0 of   15 
 
07:11:44.99   process pointer page    1 of   15 
 
07:11:45.08   process pointer page    2 of   15 
 
07:11:45.17   process pointer page    3 of   15 
 
07:11:45.27   process pointer page    4 of   15 
 
07:11:45.35   process pointer page    5 of   15 
 
07:11:45.39   process pointer page    6 of   15 
 
07:11:45.44   process pointer page    7 of   15 
 
07:11:45.47   process pointer page    8 of   15 
 
07:11:45.56   process pointer page    9 of   15 
 
07:11:45.66   process pointer page   10 of   15 
 
07:11:45.75   process pointer page   11 of   15 
 
07:11:45.83   process pointer page   12 of   15 
 
07:11:45.92   process pointer page   13 of   15 
 
07:11:46.02   process pointer page   14 of   15 
 
07:11:46.02 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:11:46.95 Index 3 (DOC_DATA_ID_DESC) 
 
07:11:47.65 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:11:48.19 Relation 141 (DOC_DATA) is ok 
 
 
07:11:48.19 Relation 147 (INVNT_SALDO) 
 
07:11:48.19   process pointer page    0 of    1 
 
07:11:48.19 Index 1 (PK_INVNT_SALDO) 
 
07:11:48.19 Relation 147 (INVNT_SALDO) is ok 
 
 
07:11:48.19 Relation 150 (PDISTR) 
 
07:11:48.19   process pointer page    0 of    2 
 
07:11:48.28   process pointer page    1 of    2 
 
07:11:48.33 Index 2 (PDISTR_SND_ID) 
 
07:11:48.39 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:11:48.43 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:11:48.45 Index 5 (PDISTR_AGENT_ID) 
 
07:11:48.48 Relation 150 (PDISTR) is ok 
 
 
07:11:48.48 Relation 151 (PSTORNED) 
 
07:11:48.48   process pointer page    0 of    4 
 
07:11:48.51   process pointer page    1 of    4 
 
07:11:48.56   process pointer page    2 of    4 
 
07:11:48.62   process pointer page    3 of    4 
 
07:11:48.65 Index 2 (PSTORNED_SND_ID) 
 
07:11:48.79 Index 3 (PSTORNED_RCV_ID) 
 
07:11:48.84 Relation 151 (PSTORNED) is ok 
 
 
07:11:48.84 Relation 156 (SEMAPHORES) 
 
07:11:48.84   process pointer page    0 of    1 
 
07:11:48.84 Index 1 (PK_SEMAPHORES) 
 
07:11:48.84 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:11:48.84 Relation 156 (SEMAPHORES) is ok 
 
 
07:11:48.84 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:11:48.84   process pointer page    0 of    1 
 
07:11:48.86 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:11:48.86 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:11:48.86 Relation 160 (PERF_ESTIMATED) 
 
07:11:48.86   process pointer page    0 of    2 
 
07:11:48.89   process pointer page    1 of    2 
 
07:11:48.90 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:11:48.93 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:11:48.93 Relation 161 (PERF_ISQL_STAT) 
 
07:11:48.93   process pointer page    0 of    1 
 
07:11:48.93 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:11:48.93 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:11:48.93 Relation 162 (TRACE_STAT) 
 
07:11:48.93   process pointer page    0 of    1 
 
07:11:48.93 Relation 162 (TRACE_STAT) is ok 
 
 
07:11:48.93 Relation 163 (PERF_LOG) 
 
07:11:48.93   process pointer page    0 of  167 
 
07:11:48.95   process pointer page    1 of  167 
 
07:11:49.04   process pointer page    2 of  167 
 
07:11:49.12   process pointer page    3 of  167 
 
07:11:49.20   process pointer page    4 of  167 
 
07:11:49.28   process pointer page    5 of  167 
 
07:11:49.36   process pointer page    6 of  167 
 
07:11:49.45   process pointer page    7 of  167 
 
07:11:49.53   process pointer page    8 of  167 
 
07:11:49.56   process pointer page    9 of  167 
 
07:11:49.62   process pointer page   10 of  167 
 
07:11:49.70   process pointer page   11 of  167 
 
07:11:49.78   process pointer page   12 of  167 
 
07:11:49.84   process pointer page   13 of  167 
 
07:11:49.87   process pointer page   14 of  167 
 
07:11:49.90   process pointer page   15 of  167 
 
07:11:49.93   process pointer page   16 of  167 
 
07:11:49.96   process pointer page   17 of  167 
 
07:11:49.99   process pointer page   18 of  167 
 
07:11:50.03   process pointer page   19 of  167 
 
07:11:50.06   process pointer page   20 of  167 
 
07:11:50.10   process pointer page   21 of  167 
 
07:11:50.18   process pointer page   22 of  167 
 
07:11:50.26   process pointer page   23 of  167 
 
07:11:50.29   process pointer page   24 of  167 
 
07:11:50.35   process pointer page   25 of  167 
 
07:11:50.43   process pointer page   26 of  167 
 
07:11:50.51   process pointer page   27 of  167 
 
07:11:50.59   process pointer page   28 of  167 
 
07:11:50.68   process pointer page   29 of  167 
 
07:11:50.76   process pointer page   30 of  167 
 
07:11:50.84   process pointer page   31 of  167 
 
07:11:50.92   process pointer page   32 of  167 
 
07:11:50.99   process pointer page   33 of  167 
 
07:11:51.07   process pointer page   34 of  167 
 
07:11:51.15   process pointer page   35 of  167 
 
07:11:51.23   process pointer page   36 of  167 
 
07:11:51.29   process pointer page   37 of  167 
 
07:11:51.32   process pointer page   38 of  167 
 
07:11:51.35   process pointer page   39 of  167 
 
07:11:51.38   process pointer page   40 of  167 
 
07:11:51.41   process pointer page   41 of  167 
 
07:11:51.49   process pointer page   42 of  167 
 
07:11:51.57   process pointer page   43 of  167 
 
07:11:51.66   process pointer page   44 of  167 
 
07:11:51.74   process pointer page   45 of  167 
 
07:11:51.82   process pointer page   46 of  167 
 
07:11:51.90   process pointer page   47 of  167 
 
07:11:51.98   process pointer page   48 of  167 
 
07:11:52.05   process pointer page   49 of  167 
 
07:11:52.13   process pointer page   50 of  167 
 
07:11:52.21   process pointer page   51 of  167 
 
07:11:52.29   process pointer page   52 of  167 
 
07:11:52.37   process pointer page   53 of  167 
 
07:11:52.44   process pointer page   54 of  167 
 
07:11:52.54   process pointer page   55 of  167 
 
07:11:52.62   process pointer page   56 of  167 
 
07:11:52.69   process pointer page   57 of  167 
 
07:11:52.77   process pointer page   58 of  167 
 
07:11:52.83   process pointer page   59 of  167 
 
07:11:52.87   process pointer page   60 of  167 
 
07:11:52.90   process pointer page   61 of  167 
 
07:11:52.93   process pointer page   62 of  167 
 
07:11:52.96   process pointer page   63 of  167 
 
07:11:52.99   process pointer page   64 of  167 
 
07:11:53.02   process pointer page   65 of  167 
 
07:11:53.05   process pointer page   66 of  167 
 
07:11:53.08   process pointer page   67 of  167 
 
07:11:53.10   process pointer page   68 of  167 
 
07:11:53.13   process pointer page   69 of  167 
 
07:11:53.16   process pointer page   70 of  167 
 
07:11:53.18   process pointer page   71 of  167 
 
07:11:53.21   process pointer page   72 of  167 
 
07:11:53.22   process pointer page   73 of  167 
 
07:11:53.26   process pointer page   74 of  167 
 
07:11:53.27   process pointer page   75 of  167 
 
07:11:53.30   process pointer page   76 of  167 
 
07:11:53.33   process pointer page   77 of  167 
 
07:11:53.35   process pointer page   78 of  167 
 
07:11:53.38   process pointer page   79 of  167 
 
07:11:53.40   process pointer page   80 of  167 
 
07:11:53.43   process pointer page   81 of  167 
 
07:11:53.46   process pointer page   82 of  167 
 
07:11:53.52   process pointer page   83 of  167 
 
07:11:53.54   process pointer page   84 of  167 
 
07:11:53.60   process pointer page   85 of  167 
 
07:11:53.63   process pointer page   86 of  167 
 
07:11:53.68   process pointer page   87 of  167 
 
07:11:53.71   process pointer page   88 of  167 
 
07:11:53.77   process pointer page   89 of  167 
 
07:11:53.83   process pointer page   90 of  167 
 
07:11:53.88   process pointer page   91 of  167 
 
07:11:53.96   process pointer page   92 of  167 
 
07:11:54.04   process pointer page   93 of  167 
 
07:11:54.11   process pointer page   94 of  167 
 
07:11:54.19   process pointer page   95 of  167 
 
07:11:54.24   process pointer page   96 of  167 
 
07:11:54.28   process pointer page   97 of  167 
 
07:11:54.36   process pointer page   98 of  167 
 
07:11:54.43   process pointer page   99 of  167 
 
07:11:54.47   process pointer page  100 of  167 
 
07:11:54.50   process pointer page  101 of  167 
 
07:11:54.53   process pointer page  102 of  167 
 
07:11:54.57   process pointer page  103 of  167 
 
07:11:54.64   process pointer page  104 of  167 
 
07:11:54.74   process pointer page  105 of  167 
 
07:11:54.83   process pointer page  106 of  167 
 
07:11:54.91   process pointer page  107 of  167 
 
07:11:54.97   process pointer page  108 of  167 
 
07:11:55.00   process pointer page  109 of  167 
 
07:11:55.06   process pointer page  110 of  167 
 
07:11:55.10   process pointer page  111 of  167 
 
07:11:55.13   process pointer page  112 of  167 
 
07:11:55.16   process pointer page  113 of  167 
 
07:11:55.19   process pointer page  114 of  167 
 
07:11:55.25   process pointer page  115 of  167 
 
07:11:55.31   process pointer page  116 of  167 
 
07:11:55.35   process pointer page  117 of  167 
 
07:11:55.38   process pointer page  118 of  167 
 
07:11:55.41   process pointer page  119 of  167 
 
07:11:55.44   process pointer page  120 of  167 
 
07:11:55.47   process pointer page  121 of  167 
 
07:11:55.50   process pointer page  122 of  167 
 
07:11:55.53   process pointer page  123 of  167 
 
07:11:55.56   process pointer page  124 of  167 
 
07:11:55.60   process pointer page  125 of  167 
 
07:11:55.61   process pointer page  126 of  167 
 
07:11:55.64   process pointer page  127 of  167 
 
07:11:55.66   process pointer page  128 of  167 
 
07:11:55.70   process pointer page  129 of  167 
 
07:11:55.75   process pointer page  130 of  167 
 
07:11:55.84   process pointer page  131 of  167 
 
07:11:55.92   process pointer page  132 of  167 
 
07:11:55.97   process pointer page  133 of  167 
 
07:11:56.02   process pointer page  134 of  167 
 
07:11:56.05   process pointer page  135 of  167 
 
07:11:56.08   process pointer page  136 of  167 
 
07:11:56.11   process pointer page  137 of  167 
 
07:11:56.17   process pointer page  138 of  167 
 
07:11:56.23   process pointer page  139 of  167 
 
07:11:56.27   process pointer page  140 of  167 
 
07:11:56.33   process pointer page  141 of  167 
 
07:11:56.36   process pointer page  142 of  167 
 
07:11:56.39   process pointer page  143 of  167 
 
07:11:56.42   process pointer page  144 of  167 
 
07:11:56.45   process pointer page  145 of  167 
 
07:11:56.53   process pointer page  146 of  167 
 
07:11:56.61   process pointer page  147 of  167 
 
07:11:56.69   process pointer page  148 of  167 
 
07:11:56.77   process pointer page  149 of  167 
 
07:11:56.86   process pointer page  150 of  167 
 
07:11:56.94   process pointer page  151 of  167 
 
07:11:57.01   process pointer page  152 of  167 
 
07:11:57.05   process pointer page  153 of  167 
 
07:11:57.08   process pointer page  154 of  167 
 
07:11:57.16   process pointer page  155 of  167 
 
07:11:57.23   process pointer page  156 of  167 
 
07:11:57.33   process pointer page  157 of  167 
 
07:11:57.40   process pointer page  158 of  167 
 
07:11:57.48   process pointer page  159 of  167 
 
07:11:57.56   process pointer page  160 of  167 
 
07:11:57.62   process pointer page  161 of  167 
 
07:11:57.65   process pointer page  162 of  167 
 
07:11:57.69   process pointer page  163 of  167 
 
07:11:57.72   process pointer page  164 of  167 
 
07:11:57.75   process pointer page  165 of  167 
 
07:11:57.79   process pointer page  166 of  167 
 
07:11:57.79 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:12:00.88 Index 2 (PERF_LOG_UNIT) 
 
07:12:04.46 Index 3 (PERF_LOG_TRN_DESC) 
 
07:12:05.88 Index 4 (PERF_LOG_GDSCODE) 
 
07:12:08.11 Relation 163 (PERF_LOG) is ok 
 
 
07:12:08.11 Relation 167 (V_STOPTEST) 
 
07:12:08.11 Relation 167 (V_STOPTEST) is ok 
 
 
07:12:08.11 Relation 184 (V_QDISTR_SOURCE) 
 
07:12:08.11 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:12:08.11 Relation 185 (V_QSTORNED_SOURCE) 
 
07:12:08.11 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:12:08.11 Relation 260 (XQD_1000_1200) 
 
07:12:08.12   process pointer page    0 of    2 
 
07:12:08.12   process pointer page    1 of    2 
 
07:12:08.12 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:12:08.14 Relation 260 (XQD_1000_1200) is ok 
 
 
07:12:08.14 Relation 261 (XQD_1200_2000) 
 
07:12:08.14   process pointer page    0 of    3 
 
07:12:08.14   process pointer page    1 of    3 
 
07:12:08.17   process pointer page    2 of    3 
 
07:12:08.17 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:12:08.17 Relation 261 (XQD_1200_2000) is ok 
 
 
07:12:08.17 Relation 262 (XQD_1000_3300) 
 
07:12:08.17   process pointer page    0 of   11 
 
07:12:08.20   process pointer page    1 of   11 
 
07:12:08.25   process pointer page    2 of   11 
 
07:12:08.28   process pointer page    3 of   11 
 
07:12:08.31   process pointer page    4 of   11 
 
07:12:08.34   process pointer page    5 of   11 
 
07:12:08.37   process pointer page    6 of   11 
 
07:12:08.40   process pointer page    7 of   11 
 
07:12:08.45   process pointer page    8 of   11 
 
07:12:08.53   process pointer page    9 of   11 
 
07:12:08.62   process pointer page   10 of   11 
 
07:12:08.64 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:12:09.04 Index 2 (XQD_1000_3300_DOC) 
 
07:12:09.39 Relation 262 (XQD_1000_3300) is ok 
 
 
07:12:09.39 Relation 263 (XQD_2000_3300) 
 
07:12:09.39   process pointer page    0 of   16 
 
07:12:09.48   process pointer page    1 of   16 
 
07:12:09.57   process pointer page    2 of   16 
 
07:12:09.67   process pointer page    3 of   16 
 
07:12:09.76   process pointer page    4 of   16 
 
07:12:09.85   process pointer page    5 of   16 
 
07:12:09.95   process pointer page    6 of   16 
 
07:12:10.04   process pointer page    7 of   16 
 
07:12:10.09   process pointer page    8 of   16 
 
07:12:10.13   process pointer page    9 of   16 
 
07:12:10.17   process pointer page   10 of   16 
 
07:12:10.26   process pointer page   11 of   16 
 
07:12:10.31   process pointer page   12 of   16 
 
07:12:10.37   process pointer page   13 of   16 
 
07:12:10.40   process pointer page   14 of   16 
 
07:12:10.46   process pointer page   15 of   16 
 
07:12:10.48 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:12:11.04 Relation 263 (XQD_2000_3300) is ok 
 
 
07:12:11.04 Relation 264 (XQD_2100_3300) 
 
07:12:11.04   process pointer page    0 of    3 
 
07:12:11.07   process pointer page    1 of    3 
 
07:12:11.09   process pointer page    2 of    3 
 
07:12:11.09 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:12:11.10 Relation 264 (XQD_2100_3300) is ok 
 
 
07:12:11.10 Relation 265 (XQD_3300_3400) 
 
07:12:11.10   process pointer page    0 of   25 
 
07:12:11.18   process pointer page    1 of   25 
 
07:12:11.27   process pointer page    2 of   25 
 
07:12:11.30   process pointer page    3 of   25 
 
07:12:11.38   process pointer page    4 of   25 
 
07:12:11.48   process pointer page    5 of   25 
 
07:12:11.57   process pointer page    6 of   25 
 
07:12:11.65   process pointer page    7 of   25 
 
07:12:11.74   process pointer page    8 of   25 
 
07:12:11.83   process pointer page    9 of   25 
 
07:12:11.91   process pointer page   10 of   25 
 
07:12:12.01   process pointer page   11 of   25 
 
07:12:12.10   process pointer page   12 of   25 
 
07:12:12.18   process pointer page   13 of   25 
 
07:12:12.27   process pointer page   14 of   25 
 
07:12:12.33   process pointer page   15 of   25 
 
07:12:12.37   process pointer page   16 of   25 
 
07:12:12.41   process pointer page   17 of   25 
 
07:12:12.44   process pointer page   18 of   25 
 
07:12:12.49   process pointer page   19 of   25 
 
07:12:12.58   process pointer page   20 of   25 
 
07:12:12.66   process pointer page   21 of   25 
 
07:12:12.72   process pointer page   22 of   25 
 
07:12:12.77   process pointer page   23 of   25 
 
07:12:12.80   process pointer page   24 of   25 
 
07:12:12.80 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:12:13.46 Relation 265 (XQD_3300_3400) is ok 
 
 
07:12:13.46 Relation 266 (XQS_1000_1200) 
 
07:12:13.46   process pointer page    0 of   44 
 
07:12:13.55   process pointer page    1 of   44 
 
07:12:13.63   process pointer page    2 of   44 
 
07:12:13.72   process pointer page    3 of   44 
 
07:12:13.82   process pointer page    4 of   44 
 
07:12:13.85   process pointer page    5 of   44 
 
07:12:13.88   process pointer page    6 of   44 
 
07:12:13.91   process pointer page    7 of   44 
 
07:12:14.00   process pointer page    8 of   44 
 
07:12:14.10   process pointer page    9 of   44 
 
07:12:14.19   process pointer page   10 of   44 
 
07:12:14.27   process pointer page   11 of   44 
 
07:12:14.33   process pointer page   12 of   44 
 
07:12:14.36   process pointer page   13 of   44 
 
07:12:14.46   process pointer page   14 of   44 
 
07:12:14.53   process pointer page   15 of   44 
 
07:12:14.63   process pointer page   16 of   44 
 
07:12:14.66   process pointer page   17 of   44 
 
07:12:14.69   process pointer page   18 of   44 
 
07:12:14.72   process pointer page   19 of   44 
 
07:12:14.77   process pointer page   20 of   44 
 
07:12:14.80   process pointer page   21 of   44 
 
07:12:14.83   process pointer page   22 of   44 
 
07:12:14.88   process pointer page   23 of   44 
 
07:12:14.91   process pointer page   24 of   44 
 
07:12:14.94   process pointer page   25 of   44 
 
07:12:14.97   process pointer page   26 of   44 
 
07:12:15.00   process pointer page   27 of   44 
 
07:12:15.03   process pointer page   28 of   44 
 
07:12:15.06   process pointer page   29 of   44 
 
07:12:15.10   process pointer page   30 of   44 
 
07:12:15.13   process pointer page   31 of   44 
 
07:12:15.16   process pointer page   32 of   44 
 
07:12:15.19   process pointer page   33 of   44 
 
07:12:15.22   process pointer page   34 of   44 
 
07:12:15.25   process pointer page   35 of   44 
 
07:12:15.27   process pointer page   36 of   44 
 
07:12:15.30   process pointer page   37 of   44 
 
07:12:15.33   process pointer page   38 of   44 
 
07:12:15.36   process pointer page   39 of   44 
 
07:12:15.38   process pointer page   40 of   44 
 
07:12:15.41   process pointer page   41 of   44 
 
07:12:15.44   process pointer page   42 of   44 
 
07:12:15.45   process pointer page   43 of   44 
 
07:12:15.49 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:12:16.37 Index 2 (XQS_1000_1200_SND_ID) 
 
07:12:17.29 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:12:17.98 Relation 266 (XQS_1000_1200) is ok 
 
 
07:12:17.98 Relation 267 (XQS_1200_2000) 
 
07:12:17.98   process pointer page    0 of   48 
 
07:12:18.04   process pointer page    1 of   48 
 
07:12:18.07   process pointer page    2 of   48 
 
07:12:18.17   process pointer page    3 of   48 
 
07:12:18.20   process pointer page    4 of   48 
 
07:12:18.28   process pointer page    5 of   48 
 
07:12:18.36   process pointer page    6 of   48 
 
07:12:18.45   process pointer page    7 of   48 
 
07:12:18.53   process pointer page    8 of   48 
 
07:12:18.62   process pointer page    9 of   48 
 
07:12:18.71   process pointer page   10 of   48 
 
07:12:18.79   process pointer page   11 of   48 
 
07:12:18.87   process pointer page   12 of   48 
 
07:12:18.90   process pointer page   13 of   48 
 
07:12:18.95   process pointer page   14 of   48 
 
07:12:18.98   process pointer page   15 of   48 
 
07:12:19.01   process pointer page   16 of   48 
 
07:12:19.09   process pointer page   17 of   48 
 
07:12:19.18   process pointer page   18 of   48 
 
07:12:19.28   process pointer page   19 of   48 
 
07:12:19.35   process pointer page   20 of   48 
 
07:12:19.45   process pointer page   21 of   48 
 
07:12:19.53   process pointer page   22 of   48 
 
07:12:19.57   process pointer page   23 of   48 
 
07:12:19.68   process pointer page   24 of   48 
 
07:12:19.78   process pointer page   25 of   48 
 
07:12:19.88   process pointer page   26 of   48 
 
07:12:19.99   process pointer page   27 of   48 
 
07:12:20.09   process pointer page   28 of   48 
 
07:12:20.20   process pointer page   29 of   48 
 
07:12:20.24   process pointer page   30 of   48 
 
07:12:20.29   process pointer page   31 of   48 
 
07:12:20.32   process pointer page   32 of   48 
 
07:12:20.37   process pointer page   33 of   48 
 
07:12:20.40   process pointer page   34 of   48 
 
07:12:20.43   process pointer page   35 of   48 
 
07:12:20.46   process pointer page   36 of   48 
 
07:12:20.56   process pointer page   37 of   48 
 
07:12:20.60   process pointer page   38 of   48 
 
07:12:20.66   process pointer page   39 of   48 
 
07:12:20.71   process pointer page   40 of   48 
 
07:12:20.79   process pointer page   41 of   48 
 
07:12:20.85   process pointer page   42 of   48 
 
07:12:20.88   process pointer page   43 of   48 
 
07:12:20.91   process pointer page   44 of   48 
 
07:12:20.96   process pointer page   45 of   48 
 
07:12:21.04   process pointer page   46 of   48 
 
07:12:21.15   process pointer page   47 of   48 
 
07:12:21.16 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:12:22.44 Index 2 (XQS_1200_2000_SND_ID) 
 
07:12:23.74 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:12:25.98 Relation 267 (XQS_1200_2000) is ok 
 
 
07:12:25.98 Relation 268 (XQS_1000_3300) 
 
07:12:25.98   process pointer page    0 of   23 
 
07:12:26.41   process pointer page    1 of   23 
 
07:12:26.81   process pointer page    2 of   23 
 
07:12:27.28   process pointer page    3 of   23 
 
07:12:27.75   process pointer page    4 of   23 
 
07:12:28.21   process pointer page    5 of   23 
 
07:12:28.71   process pointer page    6 of   23 
 
07:12:29.18   process pointer page    7 of   23 
 
07:12:29.67   process pointer page    8 of   23 
 
07:12:30.13   process pointer page    9 of   23 
 
07:12:30.62   process pointer page   10 of   23 
 
07:12:31.09   process pointer page   11 of   23 
 
07:12:31.55   process pointer page   12 of   23 
 
07:12:32.02   process pointer page   13 of   23 
 
07:12:32.47   process pointer page   14 of   23 
 
07:12:32.94   process pointer page   15 of   23 
 
07:12:33.39   process pointer page   16 of   23 
 
07:12:33.86   process pointer page   17 of   23 
 
07:12:34.31   process pointer page   18 of   23 
 
07:12:34.78   process pointer page   19 of   23 
 
07:12:35.23   process pointer page   20 of   23 
 
07:12:35.70   process pointer page   21 of   23 
 
07:12:36.16   process pointer page   22 of   23 
 
07:12:36.58 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:12:37.57 Index 2 (XQS_1000_3300_SND_ID) 
 
07:12:39.06 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:12:40.65 Relation 268 (XQS_1000_3300) is ok 
 
 
07:12:40.65 Relation 269 (XQS_2000_3300) 
 
07:12:40.65   process pointer page    0 of    1 
 
07:12:40.65 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:12:40.65 Index 2 (XQS_2000_3300_SND_ID) 
 
07:12:40.65 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:12:40.65 Relation 269 (XQS_2000_3300) is ok 
 
 
07:12:40.65 Relation 270 (XQS_2100_3300) 
 
07:12:40.65   process pointer page    0 of   33 
 
07:12:41.12   process pointer page    1 of   33 
 
07:12:41.58   process pointer page    2 of   33 
 
07:12:42.05   process pointer page    3 of   33 
 
07:12:42.54   process pointer page    4 of   33 
 
07:12:42.99   process pointer page    5 of   33 
 
07:12:43.47   process pointer page    6 of   33 
 
07:12:43.94   process pointer page    7 of   33 
 
07:12:44.42   process pointer page    8 of   33 
 
07:12:44.89   process pointer page    9 of   33 
 
07:12:45.36   process pointer page   10 of   33 
 
07:12:45.83   process pointer page   11 of   33 
 
07:12:46.30   process pointer page   12 of   33 
 
07:12:46.76   process pointer page   13 of   33 
 
07:12:47.23   process pointer page   14 of   33 
 
07:12:47.70   process pointer page   15 of   33 
 
07:12:48.17   process pointer page   16 of   33 
 
07:12:48.64   process pointer page   17 of   33 
 
07:12:49.12   process pointer page   18 of   33 
 
07:12:49.60   process pointer page   19 of   33 
 
07:12:50.02   process pointer page   20 of   33 
 
07:12:50.49   process pointer page   21 of   33 
 
07:12:50.99   process pointer page   22 of   33 
 
07:12:51.44   process pointer page   23 of   33 
 
07:12:51.91   process pointer page   24 of   33 
 
07:12:52.35   process pointer page   25 of   33 
 
07:12:52.80   process pointer page   26 of   33 
 
07:12:53.25   process pointer page   27 of   33 
 
07:12:53.71   process pointer page   28 of   33 
 
07:12:54.16   process pointer page   29 of   33 
 
07:12:54.61   process pointer page   30 of   33 
 
07:12:55.05   process pointer page   31 of   33 
 
07:12:55.47   process pointer page   32 of   33 
 
07:12:55.67 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:12:57.73 Index 2 (XQS_2100_3300_SND_ID) 
 
07:12:59.59 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:13:01.65 Relation 270 (XQS_2100_3300) is ok 
 
 
07:13:01.65 Relation 271 (XQS_3300_3400) 
 
07:13:01.65   process pointer page    0 of    6 
 
07:13:02.13   process pointer page    1 of    6 
 
07:13:02.58   process pointer page    2 of    6 
 
07:13:03.05   process pointer page    3 of    6 
 
07:13:03.50   process pointer page    4 of    6 
 
07:13:03.94   process pointer page    5 of    6 
 
07:13:04.13 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:13:04.47 Index 2 (XQS_3300_3400_SND_ID) 
 
07:13:04.84 Relation 271 (XQS_3300_3400) is ok 
 
 
07:13:04.88 Validation finished 
 
Done for 81030 ms, from  7:11:43.94 to  7:13:04.97. 
 
 Differences between old and current firebird.log 
7:13:06.48. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2017-08-18  07:13               471 oltp30_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Fri Aug 18 07:11:44 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Fri Aug 18 07:13:04 2017 
 
12:          Database: D:\OLTP-EMUL\OLTP30-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.oltp30\oltp30_*.*: 
 
 
|  ERRORS_CHECKING_RESULT  | 
|  NO_SEVERE_ERRORS_FOUND  | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2017-08-18  7:13:14.38 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html