|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 180 minutes:  | 
 5386.04  | 
 2193  | 
 969488  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  customer order: creation  | 
 391.26  | 
 476  | 
 70426  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  customer order: refuse  | 
 32.25  | 
 239  | 
 5805  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  order to supplier: creation  | 
 101.24  | 
 1897  | 
 18224  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  order to supplier: removal  | 
 2.72  | 
 14305  | 
 490  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  invoice (draft): creation  | 
 101.86  | 
 2660  | 
 18335  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  invoice (draft): removal  | 
 38.99  | 
 278  | 
 7019  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  invoice accept: apply  | 
 57.37  | 
 8785  | 
 10326  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  invoice accept: cancel  | 
 17.78  | 
 1815  | 
 3201  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  customer reserve: creation  | 
 3059.71  | 
 133  | 
 550748  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  customer reserve: removal  | 
 1038.68  | 
 45  | 
 186962  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  realization accept: apply  | 
 180.70  | 
 504  | 
 32526  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  realization accept: cancel  | 
 81.91  | 
 131  | 
 14743  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  payment from customer: creation  | 
 131.34  | 
 717  | 
 23642  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  payment from customer: removal  | 
 12.41  | 
 162  | 
 2222  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  payment to supplier: creation  | 
 107.28  | 
 461  | 
 19311  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  payment to supplier: removal  | 
 7.52  | 
 167  | 
 1346  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  service: total inventory turnovers  | 
 9.82  | 
 1795  | 
 1768  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  service: total monetary turnovers  | 
 13.23  | 
 71  | 
 2382  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  service: refresh index statistics  | 
 0.07  | 
 7026  | 
 12  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
 
Done for 75580 ms, from  6:48:25.24 to  6:49:40.82.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 3971  | 
 83503  | 
 71476  | 
 12027  | 
 14.40  | 
 03:46:29  | 
 04:04:29  | 
|  interval #   2, overall  | 
 2  | 
 4904  | 
 103792  | 
 88279  | 
 15513  | 
 14.95  | 
 04:04:30  | 
 04:22:30  | 
|  interval #   3, overall  | 
 3  | 
 5824  | 
 116771  | 
 104829  | 
 11942  | 
 10.23  | 
 04:22:31  | 
 04:40:31  | 
|  interval #   4, overall  | 
 4  | 
 5507  | 
 116892  | 
 99117  | 
 17775  | 
 15.21  | 
 04:40:32  | 
 04:58:32  | 
|  interval #   5, overall  | 
 5  | 
 5423  | 
 114306  | 
 97616  | 
 16690  | 
 14.60  | 
 04:58:33  | 
 05:16:33  | 
|  interval #   6, overall  | 
 6  | 
 5484  | 
 118678  | 
 98704  | 
 19974  | 
 16.83  | 
 05:16:34  | 
 05:34:34  | 
|  interval #   7, overall  | 
 7  | 
 5688  | 
 117988  | 
 102380  | 
 15608  | 
 13.23  | 
 05:34:35  | 
 05:52:35  | 
|  interval #   8, overall  | 
 8  | 
 5585  | 
 115261  | 
 100529  | 
 14732  | 
 12.78  | 
 05:52:36  | 
 06:10:36  | 
|  interval #   9, overall  | 
 9  | 
 5573  | 
 119562  | 
 100314  | 
 19248  | 
 16.10  | 
 06:10:37  | 
 06:28:37  | 
|  interval #  10, overall  | 
 10  | 
 5902  | 
 120374  | 
 106244  | 
 14130  | 
 11.74  | 
 06:28:38  | 
 06:46:38  | 
 
Done for 125000 ms, from  6:51:41.71 to  6:53:46.71.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 2500.31  | 
 0.3283  | 
 1.5430  | 
 1737  | 
 100  | 
|  TEST_TIME  | 
 2  | 
 2685.28  | 
 0.7302  | 
 1.3516  | 
 1544  | 
 100  | 
|  TEST_TIME  | 
 3  | 
 2906.36  | 
 0.8327  | 
 1.2112  | 
 1616  | 
 100  | 
|  TEST_TIME  | 
 4  | 
 3011.36  | 
 0.8767  | 
 1.1059  | 
 1384  | 
 100  | 
|  TEST_TIME  | 
 5  | 
 3001.87  | 
 0.8882  | 
 1.0739  | 
 1132  | 
 100  | 
|  TEST_TIME  | 
 6  | 
 2884.45  | 
 0.9315  | 
 1.0854  | 
 1257  | 
 100  | 
|  TEST_TIME  | 
 7  | 
 2934.94  | 
 0.9190  | 
 1.0657  | 
 1049  | 
 100  | 
|  TEST_TIME  | 
 8  | 
 2955.13  | 
 0.9262  | 
 1.0623  | 
 1285  | 
 100  | 
|  TEST_TIME  | 
 9  | 
 2988.99  | 
 0.9335  | 
 1.0592  | 
 1369  | 
 100  | 
|  TEST_TIME  | 
 10  | 
 3084.69  | 
 0.9258  | 
 1.0776  | 
 1776  | 
 100  | 
|  TEST_TIME  | 
 11  | 
 3242.67  | 
 0.9319  | 
 1.0820  | 
 1691  | 
 100  | 
|  TEST_TIME  | 
 12  | 
 3438.28  | 
 0.9365  | 
 1.0542  | 
 1508  | 
 100  | 
|  TEST_TIME  | 
 13  | 
 3556.69  | 
 0.9407  | 
 1.0586  | 
 1420  | 
 100  | 
|  TEST_TIME  | 
 14  | 
 3687.11  | 
 0.9483  | 
 1.0518  | 
 1853  | 
 100  | 
|  TEST_TIME  | 
 15  | 
 3783.90  | 
 0.9565  | 
 1.0427  | 
 1664  | 
 100  | 
|  TEST_TIME  | 
 16  | 
 3861.60  | 
 0.9579  | 
 1.0415  | 
 1587  | 
 100  | 
|  TEST_TIME  | 
 17  | 
 3934.45  | 
 0.9622  | 
 1.0303  | 
 1284  | 
 100  | 
|  TEST_TIME  | 
 18  | 
 3970.04  | 
 0.9644  | 
 1.0355  | 
 1474  | 
 100  | 
|  TEST_TIME  | 
 19  | 
 4029.49  | 
 0.9665  | 
 1.0314  | 
 1404  | 
 100  | 
|  TEST_TIME  | 
 20  | 
 4038.54  | 
 0.9776  | 
 1.0229  | 
 1370  | 
 100  | 
|  TEST_TIME  | 
 21  | 
 4025.04  | 
 0.9795  | 
 1.0215  | 
 1470  | 
 99  | 
|  TEST_TIME  | 
 22  | 
 4025.32  | 
 0.9750  | 
 1.0295  | 
 1266  | 
 31  | 
|  TEST_TIME  | 
 23  | 
 4056.17  | 
 0.9773  | 
 1.0150  | 
 1012  | 
 42  | 
|  TEST_TIME  | 
 24  | 
 3998.39  | 
 0.9868  | 
 1.0102  | 
 1084  | 
 73  | 
|  TEST_TIME  | 
 25  | 
 4043.46  | 
 0.9759  | 
 1.0238  | 
 1545  | 
 99  | 
|  TEST_TIME  | 
 26  | 
 4122.58  | 
 0.9660  | 
 1.0325  | 
 1640  | 
 100  | 
|  TEST_TIME  | 
 27  | 
 4207.73  | 
 0.9746  | 
 1.0246  | 
 1766  | 
 100  | 
|  TEST_TIME  | 
 28  | 
 4279.37  | 
 0.9715  | 
 1.0211  | 
 1677  | 
 100  | 
|  TEST_TIME  | 
 29  | 
 4322.43  | 
 0.9808  | 
 1.0196  | 
 1576  | 
 100  | 
|  TEST_TIME  | 
 30  | 
 4354.36  | 
 0.9784  | 
 1.0188  | 
 1395  | 
 100  | 
|  TEST_TIME  | 
 31  | 
 4343.21  | 
 0.9885  | 
 1.0249  | 
 1576  | 
 100  | 
|  TEST_TIME  | 
 32  | 
 4391.11  | 
 0.9820  | 
 1.0141  | 
 1347  | 
 100  | 
|  TEST_TIME  | 
 33  | 
 4397.00  | 
 0.9821  | 
 1.0175  | 
 1288  | 
 100  | 
|  TEST_TIME  | 
 34  | 
 4407.20  | 
 0.9853  | 
 1.0178  | 
 1234  | 
 100  | 
|  TEST_TIME  | 
 35  | 
 4430.06  | 
 0.9836  | 
 1.0134  | 
 1191  | 
 100  | 
|  TEST_TIME  | 
 36  | 
 4427.11  | 
 0.9859  | 
 1.0171  | 
 1155  | 
 100  | 
|  TEST_TIME  | 
 37  | 
 4452.35  | 
 0.9841  | 
 1.0174  | 
 1084  | 
 100  | 
|  TEST_TIME  | 
 38  | 
 4467.71  | 
 0.9872  | 
 1.0246  | 
 1062  | 
 100  | 
|  TEST_TIME  | 
 39  | 
 4523.77  | 
 0.9860  | 
 1.0123  | 
 1094  | 
 100  | 
|  TEST_TIME  | 
 40  | 
 4539.55  | 
 0.9845  | 
 1.0175  | 
 1210  | 
 100  | 
|  TEST_TIME  | 
 41  | 
 4598.69  | 
 0.9808  | 
 1.0223  | 
 1509  | 
 100  | 
|  TEST_TIME  | 
 42  | 
 4666.52  | 
 0.9835  | 
 1.0188  | 
 1896  | 
 100  | 
|  TEST_TIME  | 
 43  | 
 4715.15  | 
 0.9851  | 
 1.0156  | 
 1515  | 
 100  | 
|  TEST_TIME  | 
 44  | 
 4750.00  | 
 0.9854  | 
 1.0126  | 
 1439  | 
 100  | 
|  TEST_TIME  | 
 45  | 
 4755.61  | 
 0.9890  | 
 1.0121  | 
 1566  | 
 100  | 
|  TEST_TIME  | 
 46  | 
 4756.25  | 
 0.9899  | 
 1.0133  | 
 1266  | 
 100  | 
|  TEST_TIME  | 
 47  | 
 4784.67  | 
 0.9858  | 
 1.0093  | 
 1333  | 
 100  | 
|  TEST_TIME  | 
 48  | 
 4792.26  | 
 0.9867  | 
 1.0146  | 
 1322  | 
 98  | 
|  TEST_TIME  | 
 49  | 
 4816.93  | 
 0.9888  | 
 1.0172  | 
 1089  | 
 100  | 
|  TEST_TIME  | 
 50  | 
 4855.27  | 
 0.9889  | 
 1.0124  | 
 1225  | 
 100  | 
|  TEST_TIME  | 
 51  | 
 4871.31  | 
 0.9895  | 
 1.0083  | 
 1200  | 
 100  | 
|  TEST_TIME  | 
 52  | 
 4857.77  | 
 0.9917  | 
 1.0196  | 
 1108  | 
 100  | 
|  TEST_TIME  | 
 53  | 
 4898.56  | 
 0.9921  | 
 1.0100  | 
 914  | 
 100  | 
|  TEST_TIME  | 
 54  | 
 4895.68  | 
 0.9919  | 
 1.0071  | 
 1022  | 
 100  | 
|  TEST_TIME  | 
 55  | 
 4900.16  | 
 0.9881  | 
 1.0124  | 
 1486  | 
 100  | 
|  TEST_TIME  | 
 56  | 
 4913.97  | 
 0.9916  | 
 1.0152  | 
 1972  | 
 100  | 
|  TEST_TIME  | 
 57  | 
 4941.66  | 
 0.9918  | 
 1.0146  | 
 1719  | 
 100  | 
|  TEST_TIME  | 
 58  | 
 4989.06  | 
 0.9877  | 
 1.0109  | 
 1476  | 
 100  | 
|  TEST_TIME  | 
 59  | 
 5001.60  | 
 0.9913  | 
 1.0054  | 
 1596  | 
 99  | 
|  TEST_TIME  | 
 60  | 
 5013.94  | 
 0.9863  | 
 1.0103  | 
 1324  | 
 100  | 
|  TEST_TIME  | 
 61  | 
 5027.52  | 
 0.9910  | 
 1.0119  | 
 1352  | 
 100  | 
|  TEST_TIME  | 
 62  | 
 5059.66  | 
 0.9893  | 
 1.0108  | 
 1445  | 
 100  | 
|  TEST_TIME  | 
 63  | 
 5076.04  | 
 0.9916  | 
 1.0084  | 
 1162  | 
 100  | 
|  TEST_TIME  | 
 64  | 
 5087.94  | 
 0.9903  | 
 1.0075  | 
 1302  | 
 100  | 
|  TEST_TIME  | 
 65  | 
 5076.34  | 
 0.9947  | 
 1.0045  | 
 1298  | 
 98  | 
|  TEST_TIME  | 
 66  | 
 5064.74  | 
 0.9915  | 
 1.0072  | 
 1119  | 
 100  | 
|  TEST_TIME  | 
 67  | 
 5057.78  | 
 0.9937  | 
 1.0049  | 
 1254  | 
 100  | 
|  TEST_TIME  | 
 68  | 
 5031.34  | 
 0.9953  | 
 1.0088  | 
 950  | 
 99  | 
|  TEST_TIME  | 
 69  | 
 5037.40  | 
 0.9930  | 
 1.0064  | 
 1074  | 
 100  | 
|  TEST_TIME  | 
 70  | 
 5034.22  | 
 0.9929  | 
 1.0083  | 
 1144  | 
 100  | 
|  TEST_TIME  | 
 71  | 
 5033.13  | 
 0.9944  | 
 1.0090  | 
 1799  | 
 100  | 
|  TEST_TIME  | 
 72  | 
 5032.43  | 
 0.9951  | 
 1.0136  | 
 1751  | 
 99  | 
|  TEST_TIME  | 
 73  | 
 5072.51  | 
 0.9918  | 
 1.0095  | 
 1405  | 
 100  | 
|  TEST_TIME  | 
 74  | 
 5102.64  | 
 0.9900  | 
 1.0091  | 
 1358  | 
 100  | 
|  TEST_TIME  | 
 75  | 
 5120.93  | 
 0.9923  | 
 1.0070  | 
 1351  | 
 100  | 
|  TEST_TIME  | 
 76  | 
 5133.75  | 
 0.9913  | 
 1.0072  | 
 1307  | 
 100  | 
|  TEST_TIME  | 
 77  | 
 5138.09  | 
 0.9933  | 
 1.0038  | 
 1541  | 
 100  | 
|  TEST_TIME  | 
 78  | 
 5114.85  | 
 0.9954  | 
 1.0045  | 
 1496  | 
 92  | 
|  TEST_TIME  | 
 79  | 
 5133.45  | 
 0.9882  | 
 1.0050  | 
 1204  | 
 100  | 
|  TEST_TIME  | 
 80  | 
 5134.81  | 
 0.9931  | 
 1.0045  | 
 1040  | 
 99  | 
|  TEST_TIME  | 
 81  | 
 5129.68  | 
 0.9934  | 
 1.0065  | 
 1120  | 
 100  | 
|  TEST_TIME  | 
 82  | 
 5138.77  | 
 0.9928  | 
 1.0066  | 
 978  | 
 100  | 
|  TEST_TIME  | 
 83  | 
 5140.86  | 
 0.9941  | 
 1.0037  | 
 958  | 
 100  | 
|  TEST_TIME  | 
 84  | 
 5124.18  | 
 0.9949  | 
 1.0068  | 
 1089  | 
 100  | 
|  TEST_TIME  | 
 85  | 
 5136.74  | 
 0.9926  | 
 1.0089  | 
 1515  | 
 100  | 
|  TEST_TIME  | 
 86  | 
 5157.56  | 
 0.9931  | 
 1.0037  | 
 1612  | 
 100  | 
|  TEST_TIME  | 
 87  | 
 5131.70  | 
 0.9972  | 
 1.0025  | 
 1294  | 
 85  | 
|  TEST_TIME  | 
 88  | 
 5109.77  | 
 0.9954  | 
 1.0072  | 
 1410  | 
 88  | 
|  TEST_TIME  | 
 89  | 
 5122.11  | 
 0.9935  | 
 1.0066  | 
 1430  | 
 100  | 
|  TEST_TIME  | 
 90  | 
 5116.27  | 
 0.9966  | 
 1.0074  | 
 1462  | 
 98  | 
|  TEST_TIME  | 
 91  | 
 5117.90  | 
 0.9961  | 
 1.0054  | 
 1414  | 
 97  | 
|  TEST_TIME  | 
 92  | 
 5119.46  | 
 0.9954  | 
 1.0032  | 
 1518  | 
 98  | 
|  TEST_TIME  | 
 93  | 
 5122.65  | 
 0.9938  | 
 1.0028  | 
 1356  | 
 100  | 
|  TEST_TIME  | 
 94  | 
 5119.20  | 
 0.9928  | 
 1.0064  | 
 1108  | 
 99  | 
|  TEST_TIME  | 
 95  | 
 5127.43  | 
 0.9943  | 
 1.0072  | 
 1283  | 
 100  | 
|  TEST_TIME  | 
 96  | 
 5128.91  | 
 0.9964  | 
 1.0048  | 
 1326  | 
 100  | 
|  TEST_TIME  | 
 97  | 
 5136.26  | 
 0.9930  | 
 1.0047  | 
 1143  | 
 100  | 
|  TEST_TIME  | 
 98  | 
 5127.48  | 
 0.9961  | 
 1.0050  | 
 1109  | 
 100  | 
|  TEST_TIME  | 
 99  | 
 5123.23  | 
 0.9957  | 
 1.0053  | 
 1077  | 
 100  | 
|  TEST_TIME  | 
 100  | 
 5122.72  | 
 0.9953  | 
 1.0070  | 
 1587  | 
 100  | 
|  TEST_TIME  | 
 101  | 
 5125.48  | 
 0.9965  | 
 1.0051  | 
 1724  | 
 99  | 
|  TEST_TIME  | 
 102  | 
 5136.06  | 
 0.9933  | 
 1.0040  | 
 1724  | 
 99  | 
|  TEST_TIME  | 
 103  | 
 5141.78  | 
 0.9931  | 
 1.0036  | 
 1622  | 
 98  | 
|  TEST_TIME  | 
 104  | 
 5146.43  | 
 0.9930  | 
 1.0067  | 
 1337  | 
 100  | 
|  TEST_TIME  | 
 105  | 
 5153.71  | 
 0.9957  | 
 1.0116  | 
 1330  | 
 100  | 
|  TEST_TIME  | 
 106  | 
 5182.55  | 
 0.9965  | 
 1.0046  | 
 1067  | 
 100  | 
|  TEST_TIME  | 
 107  | 
 5192.75  | 
 0.9932  | 
 1.0047  | 
 1221  | 
 100  | 
|  TEST_TIME  | 
 108  | 
 5184.30  | 
 0.9970  | 
 1.0027  | 
 1353  | 
 100  | 
|  TEST_TIME  | 
 109  | 
 5179.22  | 
 0.9945  | 
 1.0048  | 
 1139  | 
 100  | 
|  TEST_TIME  | 
 110  | 
 5177.56  | 
 0.9960  | 
 1.0045  | 
 1200  | 
 100  | 
|  TEST_TIME  | 
 111  | 
 5178.99  | 
 0.9952  | 
 1.0052  | 
 1066  | 
 100  | 
|  TEST_TIME  | 
 112  | 
 5181.18  | 
 0.9958  | 
 1.0047  | 
 1023  | 
 100  | 
|  TEST_TIME  | 
 113  | 
 5182.00  | 
 0.9956  | 
 1.0043  | 
 973  | 
 100  | 
|  TEST_TIME  | 
 114  | 
 5173.50  | 
 0.9971  | 
 1.0036  | 
 1115  | 
 100  | 
|  TEST_TIME  | 
 115  | 
 5172.21  | 
 0.9952  | 
 1.0032  | 
 1512  | 
 100  | 
|  TEST_TIME  | 
 116  | 
 5188.61  | 
 0.9914  | 
 1.0047  | 
 1369  | 
 100  | 
|  TEST_TIME  | 
 117  | 
 5191.65  | 
 0.9955  | 
 1.0058  | 
 1412  | 
 100  | 
|  TEST_TIME  | 
 118  | 
 5202.01  | 
 0.9953  | 
 1.0055  | 
 1442  | 
 100  | 
|  TEST_TIME  | 
 119  | 
 5208.79  | 
 0.9957  | 
 1.0042  | 
 1148  | 
 100  | 
|  TEST_TIME  | 
 120  | 
 5202.21  | 
 0.9971  | 
 1.0026  | 
 1601  | 
 100  | 
|  TEST_TIME  | 
 121  | 
 5202.09  | 
 0.9943  | 
 1.0044  | 
 1364  | 
 99  | 
|  TEST_TIME  | 
 122  | 
 5213.48  | 
 0.9941  | 
 1.0067  | 
 1263  | 
 100  | 
|  TEST_TIME  | 
 123  | 
 5230.72  | 
 0.9952  | 
 1.0070  | 
 1058  | 
 100  | 
|  TEST_TIME  | 
 124  | 
 5252.38  | 
 0.9948  | 
 1.0034  | 
 1092  | 
 100  | 
|  TEST_TIME  | 
 125  | 
 5248.82  | 
 0.9969  | 
 1.0029  | 
 1258  | 
 100  | 
|  TEST_TIME  | 
 126  | 
 5246.03  | 
 0.9955  | 
 1.0054  | 
 1042  | 
 98  | 
|  TEST_TIME  | 
 127  | 
 5259.46  | 
 0.9951  | 
 1.0032  | 
 1016  | 
 99  | 
|  TEST_TIME  | 
 128  | 
 5244.58  | 
 0.9982  | 
 1.0022  | 
 1176  | 
 94  | 
|  TEST_TIME  | 
 129  | 
 5248.13  | 
 0.9938  | 
 1.0028  | 
 840  | 
 100  | 
|  TEST_TIME  | 
 130  | 
 5256.10  | 
 0.9936  | 
 1.0041  | 
 1345  | 
 100  | 
|  TEST_TIME  | 
 131  | 
 5268.05  | 
 0.9943  | 
 1.0046  | 
 1458  | 
 100  | 
|  TEST_TIME  | 
 132  | 
 5286.85  | 
 0.9935  | 
 1.0043  | 
 1551  | 
 100  | 
|  TEST_TIME  | 
 133  | 
 5297.34  | 
 0.9948  | 
 1.0025  | 
 1614  | 
 100  | 
|  TEST_TIME  | 
 134  | 
 5292.08  | 
 0.9960  | 
 1.0028  | 
 1537  | 
 99  | 
|  TEST_TIME  | 
 135  | 
 5295.26  | 
 0.9948  | 
 1.0036  | 
 1151  | 
 100  | 
|  TEST_TIME  | 
 136  | 
 5289.02  | 
 0.9974  | 
 1.0065  | 
 1273  | 
 100  | 
|  TEST_TIME  | 
 137  | 
 5308.09  | 
 0.9955  | 
 1.0038  | 
 1150  | 
 100  | 
|  TEST_TIME  | 
 138  | 
 5303.78  | 
 0.9973  | 
 1.0041  | 
 1178  | 
 100  | 
|  TEST_TIME  | 
 139  | 
 5312.94  | 
 0.9952  | 
 1.0040  | 
 1131  | 
 100  | 
|  TEST_TIME  | 
 140  | 
 5313.16  | 
 0.9968  | 
 1.0021  | 
 1343  | 
 100  | 
|  TEST_TIME  | 
 141  | 
 5304.88  | 
 0.9966  | 
 1.0032  | 
 1185  | 
 99  | 
|  TEST_TIME  | 
 142  | 
 5308.57  | 
 0.9955  | 
 1.0030  | 
 999  | 
 99  | 
|  TEST_TIME  | 
 143  | 
 5297.26  | 
 0.9981  | 
 1.0045  | 
 1158  | 
 100  | 
|  TEST_TIME  | 
 144  | 
 5292.28  | 
 0.9984  | 
 1.0054  | 
 1058  | 
 99  | 
|  TEST_TIME  | 
 145  | 
 5300.68  | 
 0.9969  | 
 1.0039  | 
 1271  | 
 100  | 
|  TEST_TIME  | 
 146  | 
 5317.43  | 
 0.9941  | 
 1.0047  | 
 1410  | 
 100  | 
|  TEST_TIME  | 
 147  | 
 5324.26  | 
 0.9966  | 
 1.0026  | 
 1476  | 
 100  | 
|  TEST_TIME  | 
 148  | 
 5317.25  | 
 0.9971  | 
 1.0033  | 
 1590  | 
 98  | 
|  TEST_TIME  | 
 149  | 
 5330.08  | 
 0.9941  | 
 1.0043  | 
 1231  | 
 97  | 
|  TEST_TIME  | 
 150  | 
 5340.24  | 
 0.9961  | 
 1.0022  | 
 1362  | 
 100  | 
|  TEST_TIME  | 
 151  | 
 5329.57  | 
 0.9975  | 
 1.0024  | 
 1459  | 
 99  | 
|  TEST_TIME  | 
 152  | 
 5325.57  | 
 0.9966  | 
 1.0034  | 
 1483  | 
 96  | 
|  TEST_TIME  | 
 153  | 
 5321.80  | 
 0.9975  | 
 1.0050  | 
 1250  | 
 97  | 
|  TEST_TIME  | 
 154  | 
 5324.65  | 
 0.9979  | 
 1.0019  | 
 1226  | 
 100  | 
|  TEST_TIME  | 
 155  | 
 5313.01  | 
 0.9976  | 
 1.0025  | 
 1155  | 
 94  | 
|  TEST_TIME  | 
 156  | 
 5315.05  | 
 0.9957  | 
 1.0049  | 
 929  | 
 100  | 
|  TEST_TIME  | 
 157  | 
 5323.43  | 
 0.9969  | 
 1.0026  | 
 1078  | 
 100  | 
|  TEST_TIME  | 
 158  | 
 5312.32  | 
 0.9983  | 
 1.0016  | 
 1253  | 
 98  | 
|  TEST_TIME  | 
 159  | 
 5303.85  | 
 0.9969  | 
 1.0039  | 
 1067  | 
 98  | 
|  TEST_TIME  | 
 160  | 
 5310.24  | 
 0.9964  | 
 1.0019  | 
 1428  | 
 100  | 
|  TEST_TIME  | 
 161  | 
 5309.51  | 
 0.9959  | 
 1.0051  | 
 1462  | 
 100  | 
|  TEST_TIME  | 
 162  | 
 5314.86  | 
 0.9979  | 
 1.0026  | 
 1445  | 
 97  | 
|  TEST_TIME  | 
 163  | 
 5318.87  | 
 0.9957  | 
 1.0035  | 
 1229  | 
 96  | 
|  TEST_TIME  | 
 164  | 
 5327.35  | 
 0.9958  | 
 1.0055  | 
 1401  | 
 100  | 
|  TEST_TIME  | 
 165  | 
 5337.65  | 
 0.9975  | 
 1.0016  | 
 1241  | 
 100  | 
|  TEST_TIME  | 
 166  | 
 5327.87  | 
 0.9974  | 
 1.0028  | 
 1094  | 
 93  | 
|  TEST_TIME  | 
 167  | 
 5326.64  | 
 0.9971  | 
 1.0031  | 
 857  | 
 99  | 
|  TEST_TIME  | 
 168  | 
 5335.74  | 
 0.9976  | 
 1.0016  | 
 856  | 
 100  | 
|  TEST_TIME  | 
 169  | 
 5327.04  | 
 0.9973  | 
 1.0044  | 
 997  | 
 100  | 
|  TEST_TIME  | 
 170  | 
 5329.99  | 
 0.9981  | 
 1.0026  | 
 1182  | 
 100  | 
|  TEST_TIME  | 
 171  | 
 5333.08  | 
 0.9961  | 
 1.0024  | 
 965  | 
 100  | 
|  TEST_TIME  | 
 172  | 
 5324.82  | 
 0.9981  | 
 1.0019  | 
 867  | 
 100  | 
|  TEST_TIME  | 
 173  | 
 5322.79  | 
 0.9965  | 
 1.0031  | 
 1003  | 
 99  | 
|  TEST_TIME  | 
 174  | 
 5331.58  | 
 0.9964  | 
 1.0032  | 
 927  | 
 100  | 
|  TEST_TIME  | 
 175  | 
 5340.16  | 
 0.9958  | 
 1.0045  | 
 1337  | 
 100  | 
|  TEST_TIME  | 
 176  | 
 5355.89  | 
 0.9959  | 
 1.0050  | 
 1089  | 
 100  | 
|  TEST_TIME  | 
 177  | 
 5366.33  | 
 0.9974  | 
 1.0013  | 
 1339  | 
 99  | 
|  TEST_TIME  | 
 178  | 
 5370.55  | 
 0.9949  | 
 1.0019  | 
 1231  | 
 100  | 
|  TEST_TIME  | 
 179  | 
 5377.03  | 
 0.9951  | 
 1.0050  | 
 1084  | 
 100  | 
|  TEST_TIME  | 
 180  | 
 5381.25  | 
 0.9986  | 
 1.0008  | 
 757  | 
 100  | 
 
Done for 8970 ms, from  6:53:47.43 to  6:53:56.40.  
 
 
|  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  | 
 84091  | 
 95166  | 
 90216  | 
 61093  | 
 80358  | 
 <null>  | 
 115374  | 
 96444  | 
 54380  | 
 37626  | 
 81028  | 
 57505  | 
 107451  | 
 <null>  | 
 178540  | 
 65125  | 
 102306  | 
 331026  | 
 402  | 
 03:46:29  | 
 04:04:29  | 
|  fetches per second  | 
 2  | 
 23981  | 
 8432  | 
 31201  | 
 63126  | 
 18362  | 
 72560  | 
 68007  | 
 77200  | 
 1701  | 
 19650  | 
 27529  | 
 20387  | 
 42472  | 
 49173  | 
 23912  | 
 68522  | 
 111362  | 
 41776  | 
 <null>  | 
 04:04:30  | 
 04:22:30  | 
|  fetches per second  | 
 3  | 
 56084  | 
 76048  | 
 45782  | 
 109889  | 
 48900  | 
 <null>  | 
 72529  | 
 <null>  | 
 69464  | 
 9654  | 
 24605  | 
 <null>  | 
 95792  | 
 109527  | 
 66146  | 
 <null>  | 
 92417  | 
 95864  | 
 <null>  | 
 04:22:31  | 
 04:40:31  | 
|  fetches per second  | 
 4  | 
 20425  | 
 67873  | 
 16620  | 
 <null>  | 
 25627  | 
 50358  | 
 57024  | 
 53157  | 
 21089  | 
 7801  | 
 21717  | 
 57828  | 
 57552  | 
 34942  | 
 21123  | 
 <null>  | 
 35272  | 
 268155  | 
 <null>  | 
 04:40:32  | 
 04:58:32  | 
|  fetches per second  | 
 5  | 
 27570  | 
 18076  | 
 34619  | 
 <null>  | 
 14235  | 
 <null>  | 
 67993  | 
 3217  | 
 40893  | 
 <null>  | 
 19270  | 
 11869  | 
 47427  | 
 2247  | 
 51897  | 
 1197  | 
 27579  | 
 <null>  | 
 <null>  | 
 04:58:33  | 
 05:16:33  | 
|  fetches per second  | 
 6  | 
 18759  | 
 124029  | 
 29407  | 
 <null>  | 
 21753  | 
 <null>  | 
 57835  | 
 <null>  | 
 5795  | 
 4613  | 
 15687  | 
 13018  | 
 37423  | 
 20481  | 
 32636  | 
 <null>  | 
 69817  | 
 <null>  | 
 <null>  | 
 05:16:34  | 
 05:34:34  | 
|  fetches per second  | 
 7  | 
 24145  | 
 5012  | 
 21358  | 
 49983  | 
 22690  | 
 <null>  | 
 28744  | 
 94725  | 
 53918  | 
 33350  | 
 36602  | 
 13887  | 
 31016  | 
 46921  | 
 79731  | 
 <null>  | 
 9909  | 
 <null>  | 
 <null>  | 
 05:34:35  | 
 05:52:35  | 
|  fetches per second  | 
 8  | 
 22217  | 
 64284  | 
 35046  | 
 62352  | 
 16086  | 
 15154  | 
 30725  | 
 34758  | 
 4148  | 
 <null>  | 
 30667  | 
 33811  | 
 19367  | 
 2410  | 
 58311  | 
 <null>  | 
 <null>  | 
 10984  | 
 <null>  | 
 05:52:36  | 
 06:10:36  | 
|  fetches per second  | 
 9  | 
 11166  | 
 44842  | 
 3148  | 
 <null>  | 
 12651  | 
 <null>  | 
 32845  | 
 <null>  | 
 8150  | 
 <null>  | 
 16310  | 
 24067  | 
 31073  | 
 17449  | 
 37715  | 
 4321  | 
 <null>  | 
 283227  | 
 <null>  | 
 06:10:37  | 
 06:28:37  | 
|  fetches per second  | 
 10  | 
 17901  | 
 65772  | 
 28993  | 
 <null>  | 
 14348  | 
 43149  | 
 32245  | 
 4040  | 
 40230  | 
 <null>  | 
 38241  | 
 1442  | 
 61228  | 
 2509  | 
 38814  | 
 <null>  | 
 22235  | 
 158720  | 
 <null>  | 
 06:28:38  | 
 06:46:38  | 
|  marks per second  | 
 1  | 
 18385  | 
 12226  | 
 19962  | 
 8497  | 
 18013  | 
 <null>  | 
 12568  | 
 16096  | 
 6292  | 
 8440  | 
 13355  | 
 11148  | 
 9701  | 
 <null>  | 
 8683  | 
 14250  | 
 12033  | 
 34481  | 
 54  | 
 03:46:29  | 
 04:04:29  | 
|  marks per second  | 
 2  | 
 5036  | 
 882  | 
 6654  | 
 9488  | 
 3981  | 
 18750  | 
 8548  | 
 11021  | 
 258  | 
 3350  | 
 5048  | 
 3041  | 
 2561  | 
 7261  | 
 1850  | 
 8984  | 
 24445  | 
 2459  | 
 <null>  | 
 04:04:30  | 
 04:22:30  | 
|  marks per second  | 
 3  | 
 11647  | 
 10071  | 
 10337  | 
 17151  | 
 10476  | 
 <null>  | 
 10830  | 
 <null>  | 
 12678  | 
 1386  | 
 2909  | 
 <null>  | 
 7391  | 
 14586  | 
 7989  | 
 <null>  | 
 10862  | 
 13459  | 
 <null>  | 
 04:22:31  | 
 04:40:31  | 
|  marks per second  | 
 4  | 
 4293  | 
 9093  | 
 3533  | 
 <null>  | 
 5437  | 
 12583  | 
 8064  | 
 9626  | 
 3202  | 
 1198  | 
 3751  | 
 8932  | 
 2691  | 
 5220  | 
 3448  | 
 <null>  | 
 5078  | 
 30469  | 
 <null>  | 
 04:40:32  | 
 04:58:32  | 
|  marks per second  | 
 5  | 
 5868  | 
 2366  | 
 7274  | 
 <null>  | 
 2824  | 
 <null>  | 
 9644  | 
 517  | 
 4306  | 
 <null>  | 
 3635  | 
 2005  | 
 2365  | 
 374  | 
 5514  | 
 272  | 
 2153  | 
 <null>  | 
 <null>  | 
 04:58:33  | 
 05:16:33  | 
|  marks per second  | 
 6  | 
 3625  | 
 12489  | 
 5747  | 
 <null>  | 
 4669  | 
 <null>  | 
 6544  | 
 <null>  | 
 509  | 
 769  | 
 2924  | 
 2183  | 
 1891  | 
 3189  | 
 4002  | 
 <null>  | 
 9984  | 
 <null>  | 
 <null>  | 
 05:16:34  | 
 05:34:34  | 
|  marks per second  | 
 7  | 
 4725  | 
 492  | 
 4356  | 
 10559  | 
 4638  | 
 <null>  | 
 3445  | 
 13188  | 
 6514  | 
 5194  | 
 5420  | 
 1817  | 
 1518  | 
 7891  | 
 8107  | 
 <null>  | 
 684  | 
 <null>  | 
 <null>  | 
 05:34:35  | 
 05:52:35  | 
|  marks per second  | 
 8  | 
 4615  | 
 8110  | 
 8170  | 
 8676  | 
 3188  | 
 3632  | 
 3863  | 
 4920  | 
 1071  | 
 <null>  | 
 5187  | 
 4585  | 
 2494  | 
 330  | 
 8321  | 
 <null>  | 
 <null>  | 
 456  | 
 <null>  | 
 05:52:36  | 
 06:10:36  | 
|  marks per second  | 
 9  | 
 2313  | 
 5723  | 
 571  | 
 <null>  | 
 2183  | 
 <null>  | 
 3789  | 
 <null>  | 
 755  | 
 <null>  | 
 1757  | 
 2680  | 
 980  | 
 2515  | 
 4230  | 
 602  | 
 <null>  | 
 29980  | 
 <null>  | 
 06:10:37  | 
 06:28:37  | 
|  marks per second  | 
 10  | 
 3618  | 
 8529  | 
 6165  | 
 <null>  | 
 2773  | 
 10830  | 
 4208  | 
 670  | 
 5370  | 
 <null>  | 
 3016  | 
 211  | 
 2128  | 
 485  | 
 6371  | 
 <null>  | 
 5518  | 
 7960  | 
 <null>  | 
 06:28:38  | 
 06:46:38  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 03:46:29  | 
 04:04:29  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:04:30  | 
 04:22:30  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:22:31  | 
 04:40:31  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:40:32  | 
 04:58:32  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 04:58:33  | 
 05:16:33  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 <null>  | 
 05:16:34  | 
 05:34:34  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 <null>  | 
 05:34:35  | 
 05:52:35  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 05:52:36  | 
 06:10:36  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:10:37  | 
 06:28:37  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 06:28:38  | 
 06:46:38  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 9  | 
 0  | 
 0  | 
 03:46:29  | 
 04:04:29  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 04:04:30  | 
 04:22:30  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 5  | 
 0  | 
 <null>  | 
 04:22:31  | 
 04:40:31  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 3  | 
 0  | 
 <null>  | 
 04:40:32  | 
 04:58:32  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 <null>  | 
 <null>  | 
 04:58:33  | 
 05:16:33  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 <null>  | 
 <null>  | 
 05:16:34  | 
 05:34:34  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 <null>  | 
 05:34:35  | 
 05:52:35  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 05:52:36  | 
 06:10:36  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 2  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:10:37  | 
 06:28:37  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 2  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 <null>  | 
 06:28:38  | 
 06:46:38  | 
 
Done for 7730 ms, from  6:53:56.98 to  6:54:04.71.  
 
 
|  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  | 
 1710903  | 
 1563089  | 
 147814  | 
 8.63  | 
 0  | 
 10780  | 
 35  | 
 147814  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  doc_list_biud  | 
 1711325  | 
 1563089  | 
 148236  | 
 8.66  | 
 0  | 
 8643  | 
 13  | 
 148236  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_add_invoice_to_stock  | 
 16776  | 
 10326  | 
 6450  | 
 38.44  | 
 0  | 
 161959  | 
 8785  | 
 6450  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_cancel_adding_invoice  | 
 4208  | 
 3201  | 
 1007  | 
 23.93  | 
 0  | 
 71355  | 
 1815  | 
 1007  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_cancel_client_order  | 
 5922  | 
 5805  | 
 117  | 
 1.97  | 
 0  | 
 4882  | 
 239  | 
 117  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_cancel_customer_reserve  | 
 324823  | 
 186962  | 
 137861  | 
 42.44  | 
 0  | 
 5367  | 
 45  | 
 137861  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_cancel_pay_from_customer  | 
 2234  | 
 2222  | 
 12  | 
 0.53  | 
 0  | 
 2621  | 
 162  | 
 12  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_cancel_pay_to_supplier  | 
 1352  | 
 1346  | 
 6  | 
 0.44  | 
 0  | 
 1966  | 
 167  | 
 6  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_cancel_supplier_invoice  | 
 8991  | 
 7019  | 
 1972  | 
 21.93  | 
 0  | 
 9313  | 
 278  | 
 1972  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_cancel_supplier_order  | 
 1375  | 
 490  | 
 885  | 
 64.36  | 
 16  | 
 155111  | 
 14305  | 
 885  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_cancel_write_off  | 
 22709  | 
 14743  | 
 7966  | 
 35.07  | 
 0  | 
 3339  | 
 131  | 
 7966  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_client_order  | 
 70426  | 
 70426  | 
 0  | 
 0.00  | 
 0  | 
 7285  | 
 476  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_customer_reserve  | 
 550748  | 
 550748  | 
 0  | 
 0.00  | 
 0  | 
 7769  | 
 133  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_fill_shopping_cart  | 
 107259  | 
 106985  | 
 274  | 
 0.25  | 
 0  | 
 3183  | 
 88  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_fill_shopping_cart_clo_res  | 
 550748  | 
 550748  | 
 0  | 
 0.00  | 
 0  | 
 3916  | 
 8  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_get_clo_for_invoice  | 
 10326  | 
 10326  | 
 0  | 
 0.00  | 
 0  | 
 5211  | 
 233  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_kill_cost_storno  | 
 30143  | 
 21512  | 
 8631  | 
 28.63  | 
 0  | 
 8081  | 
 28  | 
 8631  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 681083  | 
 396176  | 
 284907  | 
 41.83  | 
 0  | 
 8627  | 
 17  | 
 284907  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_kill_qty_storno  | 
 409227  | 
 261072  | 
 148155  | 
 36.20  | 
 0  | 
 8627  | 
 58  | 
 148155  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_lock_selected_doc  | 
 69498  | 
 60164  | 
 9334  | 
 13.43  | 
 0  | 
 2418  | 
 7  | 
 9334  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_make_cost_storno  | 
 85805  | 
 85805  | 
 0  | 
 0.00  | 
 0  | 
 9126  | 
 279  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_multiply_rows_for_pdistr  | 
 85805  | 
 85805  | 
 0  | 
 0.00  | 
 0  | 
 2901  | 
 82  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_multiply_rows_for_qdistr  | 
 70426  | 
 70426  | 
 0  | 
 0.00  | 
 0  | 
 5382  | 
 161  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_pay_from_customer  | 
 23642  | 
 23642  | 
 0  | 
 0.00  | 
 0  | 
 10296  | 
 717  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_pay_to_supplier  | 
 19311  | 
 19311  | 
 0  | 
 0.00  | 
 0  | 
 8409  | 
 461  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_payment_common  | 
 42953  | 
 42953  | 
 0  | 
 0.00  | 
 0  | 
 4337  | 
 65  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_qd_handle_on_cancel_clo  | 
 5916  | 
 5805  | 
 111  | 
 1.87  | 
 0  | 
 4805  | 
 111  | 
 111  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 14368  | 
 13527  | 
 841  | 
 5.85  | 
 0  | 
 6333  | 
 290  | 
 841  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 32526  | 
 32526  | 
 0  | 
 0.00  | 
 0  | 
 3900  | 
 60  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_reserve_write_off  | 
 33615  | 
 32526  | 
 1089  | 
 3.23  | 
 0  | 
 13431  | 
 504  | 
 1089  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_supplier_invoice  | 
 18438  | 
 18335  | 
 103  | 
 0.55  | 
 0  | 
 38470  | 
 2660  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  sp_supplier_order  | 
 18395  | 
 18224  | 
 171  | 
 0.92  | 
 0  | 
 17878  | 
 1897  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  srv_find_qd_qs_mism  | 
 1036652  | 
 888820  | 
 147832  | 
 14.26  | 
 0  | 
 3370  | 
 18  | 
 147832  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  srv_make_invnt_saldo  | 
 1768  | 
 1768  | 
 0  | 
 0.00  | 
 0  | 
 22043  | 
 1795  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  srv_make_money_saldo  | 
 2382  | 
 2382  | 
 0  | 
 0.00  | 
 0  | 
 3526  | 
 71  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 2262  | 
 14679  | 
 7026  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 6450  | 
 6450  | 
 0  | 
 0.00  | 
 0  | 
 2792  | 
 134  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 613  | 
 613  | 
 0  | 
 0.00  | 
 0  | 
 2745  | 
 178  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_cancel_client_order  | 
 117  | 
 117  | 
 0  | 
 0.00  | 
 0  | 
 1201  | 
 130  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 59  | 
 59  | 
 0  | 
 0.00  | 
 0  | 
 1622  | 
 66  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 188  | 
 35  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 6  | 
 6  | 
 0  | 
 0.00  | 
 0  | 
 78  | 
 20  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 486  | 
 486  | 
 0  | 
 0.00  | 
 0  | 
 1264  | 
 133  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 16846  | 
 16846  | 
 0  | 
 0.00  | 
 0  | 
 5273  | 
 92  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_cancel_write_off  | 
 17  | 
 17  | 
 0  | 
 0.00  | 
 0  | 
 1435  | 
 232  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1089  | 
 1089  | 
 0  | 
 0.00  | 
 0  | 
 1950  | 
 87  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_supplier_invoice  | 
 103  | 
 103  | 
 0  | 
 0.00  | 
 0  | 
 1029  | 
 99  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-abend:sp_supplier_order  | 
 171  | 
 171  | 
 0  | 
 0.00  | 
 0  | 
 1155  | 
 101  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 10326  | 
 10326  | 
 0  | 
 0.00  | 
 0  | 
 15397  | 
 528  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1166  | 
 1166  | 
 0  | 
 0.00  | 
 0  | 
 12058  | 
 607  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_cancel_client_order  | 
 5805  | 
 5805  | 
 0  | 
 0.00  | 
 0  | 
 2839  | 
 103  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2224  | 
 2224  | 
 0  | 
 0.00  | 
 0  | 
 2200  | 
 99  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2222  | 
 2222  | 
 0  | 
 0.00  | 
 0  | 
 2793  | 
 71  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1346  | 
 1346  | 
 0  | 
 0.00  | 
 0  | 
 1950  | 
 78  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 844  | 
 844  | 
 0  | 
 0.00  | 
 0  | 
 2777  | 
 105  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 490  | 
 490  | 
 0  | 
 0.00  | 
 0  | 
 34242  | 
 1599  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3215  | 
 3215  | 
 0  | 
 0.00  | 
 0  | 
 2324  | 
 101  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_client_order  | 
 70426  | 
 70426  | 
 0  | 
 0.00  | 
 0  | 
 3744  | 
 115  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_customer_reserve  | 
 3355  | 
 3355  | 
 0  | 
 0.00  | 
 0  | 
 1919  | 
 80  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_pay_from_customer  | 
 23642  | 
 23642  | 
 0  | 
 0.00  | 
 0  | 
 2933  | 
 104  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 19311  | 
 19311  | 
 0  | 
 0.00  | 
 0  | 
 2559  | 
 89  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_reserve_write_off  | 
 32526  | 
 32526  | 
 0  | 
 0.00  | 
 0  | 
 3448  | 
 113  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_supplier_invoice  | 
 18335  | 
 18335  | 
 0  | 
 0.00  | 
 0  | 
 3245  | 
 92  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:sp_supplier_order  | 
 18224  | 
 18224  | 
 0  | 
 0.00  | 
 0  | 
 3573  | 
 97  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1768  | 
 1768  | 
 0  | 
 0.00  | 
 0  | 
 968  | 
 43  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:srv_make_money_saldo  | 
 2382  | 
 2382  | 
 0  | 
 0.00  | 
 0  | 
 1217  | 
 48  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 109  | 
 33  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_add_invoice_to_stock  | 
 33552  | 
 20652  | 
 12900  | 
 38.44  | 
 0  | 
 2293  | 
 18  | 
 12900  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_all_customers  | 
 105818  | 
 105818  | 
 0  | 
 0.00  | 
 0  | 
 1154  | 
 5  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_all_suppliers  | 
 74288  | 
 73740  | 
 548  | 
 0.73  | 
 0  | 
 858  | 
 6  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_all_wares  | 
 140852  | 
 140852  | 
 0  | 
 0.00  | 
 0  | 
 1029  | 
 4  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_cancel_adding_invoice  | 
 2758  | 
 2332  | 
 426  | 
 15.44  | 
 0  | 
 2262  | 
 109  | 
 426  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_cancel_client_order  | 
 11844  | 
 11610  | 
 234  | 
 1.97  | 
 0  | 
 1404  | 
 8  | 
 234  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_cancel_customer_prepayment  | 
 4468  | 
 4444  | 
 24  | 
 0.53  | 
 0  | 
 1638  | 
 9  | 
 24  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_cancel_customer_reserve  | 
 4566  | 
 4448  | 
 118  | 
 2.58  | 
 0  | 
 967  | 
 10  | 
 118  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_cancel_payment_to_supplier  | 
 2704  | 
 2692  | 
 12  | 
 0.44  | 
 0  | 
 811  | 
 8  | 
 12  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_cancel_supplier_invoice  | 
 2660  | 
 1688  | 
 972  | 
 36.54  | 
 0  | 
 765  | 
 16  | 
 972  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_cancel_supplier_order  | 
 2750  | 
 980  | 
 1770  | 
 64.36  | 
 0  | 
 811  | 
 10  | 
 1770  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_cancel_write_off  | 
 6464  | 
 6430  | 
 34  | 
 0.52  | 
 0  | 
 3104  | 
 82  | 
 34  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_max_id_clo_ord  | 
 18395  | 
 18224  | 
 171  | 
 0.92  | 
 0  | 
 812  | 
 5  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_max_id_clo_res  | 
 3355  | 
 3355  | 
 0  | 
 0.00  | 
 0  | 
 1654  | 
 20  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_max_id_ord_sup  | 
 18438  | 
 18335  | 
 103  | 
 0.55  | 
 0  | 
 749  | 
 5  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_max_non_paid_invoice  | 
 19000  | 
 19000  | 
 0  | 
 0.00  | 
 0  | 
 1810  | 
 6  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_max_non_paid_realizn  | 
 23642  | 
 23642  | 
 0  | 
 0.00  | 
 0  | 
 764  | 
 6  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_min_id_clo_ord  | 
 18395  | 
 18224  | 
 171  | 
 0.92  | 
 0  | 
 1918  | 
 9  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_min_id_clo_res  | 
 3355  | 
 3355  | 
 0  | 
 0.00  | 
 0  | 
 2871  | 
 12  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_min_id_ord_sup  | 
 18438  | 
 18335  | 
 103  | 
 0.55  | 
 0  | 
 1513  | 
 8  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_min_non_paid_invoice  | 
 19311  | 
 19311  | 
 0  | 
 0.00  | 
 0  | 
 1482  | 
 13  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_min_non_paid_realizn  | 
 23642  | 
 23642  | 
 0  | 
 0.00  | 
 0  | 
 1809  | 
 12  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_our_firm  | 
 35034  | 
 35034  | 
 0  | 
 0.00  | 
 0  | 
 1014  | 
 6  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  v_reserve_write_off  | 
 67230  | 
 65052  | 
 2178  | 
 3.23  | 
 0  | 
 2262  | 
 10  | 
 2178  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  x_lock_depdocs_on_canc_invoice  | 
 17948  | 
 9376  | 
 8572  | 
 47.76  | 
 0  | 
 3479  | 
 19  | 
 8572  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1373  | 
 490  | 
 883  | 
 64.31  | 
 0  | 
 1139  | 
 54  | 
 883  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  x_make_qstorno_1000_1200  | 
 18395  | 
 18224  | 
 171  | 
 0.92  | 
 0  | 
 17612  | 
 1690  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  x_make_qstorno_1200_2000  | 
 18438  | 
 18335  | 
 103  | 
 0.55  | 
 0  | 
 36473  | 
 2449  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  x_make_qstorno_2100_3300  | 
 550748  | 
 550748  | 
 0  | 
 0.00  | 
 0  | 
 7597  | 
 112  | 
 0  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
 
Done for 183040 ms, from  6:56:59.48 to  7:00:02.52.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 87  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2018-04-23 03:48  | 
 2018-04-23 06:44  | 
|  deadlock  | 
 90  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2018-04-23 03:52  | 
 2018-04-23 06:45  | 
|  deadlock  | 
 8117  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  deadlock  | 
 111  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2018-04-23 03:47  | 
 2018-04-23 06:43  | 
|  deadlock  | 
 156  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2018-04-23 03:47  | 
 2018-04-23 06:44  | 
|  deadlock  | 
 547  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2018-04-23 03:46  | 
 2018-04-23 06:46  | 
|  deadlock  | 
 222  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2018-04-23 03:51  | 
 2018-04-23 06:45  | 
|  user_exc  | 
 171  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2018-04-23 03:46  | 
 2018-04-23 06:42  | 
|  user_exc  | 
 103  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2018-04-23 03:47  | 
 2018-04-23 06:42  | 
 
Done for 7550 ms, from  7:00:08.01 to  7:00:15.56.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          398327
 
MON$OLDEST_ACTIVE               398328
 
MON$OLDEST_SNAPSHOT             398328
 
MON$NEXT_TRANSACTION            398328
 
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                       737952
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.4.32961 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.4.32961 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.4.32961 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.4.32961 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Gstat execution time Mon Apr 23 07:00:16 2018 
 
 
Database header page information: 
 
Flags			0 
 
Generation		398479 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	398329 
 
Oldest active		398330 
 
Oldest snapshot		398330 
 
Next transaction	398331 
 
Sequence number		0 
 
Next attachment ID	9389 
 
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: 46.97, total records: 1943181 
 
Average version length: 47.54, total versions: 1982, 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: 13, data page slots: 20936 
 
Data pages: 20936, average fill: 73% 
 
Primary pages: 20936, secondary pages: 0, swept pages: 12162 
 
Empty pages: 5, full pages: 19337 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 4 
 
40 - 59% = 59 
 
60 - 79% = 20861 
 
80 - 99% = 6 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 9275, nodes: 1943181 
 
Average node length: 19.22, total dup: 0, max dup: 0 
 
Average key length: 16.27, compression ratio: 1.66 
 
Average prefix length: 13.72, average data length: 13.28 
 
Clustering factor: 355995, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 653 
 
20 - 39% = 2248 
 
40 - 59% = 3854 
 
60 - 79% = 976 
 
80 - 99% = 1544 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 6982, nodes: 1943181 
 
Average node length: 11.66, total dup: 0, max dup: 0 
 
Average key length: 8.71, compression ratio: 1.03 
 
Average prefix length: 3.28, average data length: 5.72 
 
Clustering factor: 342683, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 3245 
 
40 - 59% = 3642 
 
60 - 79% = 89 
 
80 - 99% = 6 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 174089, depth: 3, leaf buckets: 3282, nodes: 1943181 
 
Average node length: 6.77, total dup: 1429730, max dup: 49 
 
Average key length: 3.82, compression ratio: 2.36 
 
Average prefix length: 7.44, average data length: 1.56 
 
Clustering factor: 321237, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 125 
 
20 - 39% = 1059 
 
40 - 59% = 1249 
 
60 - 79% = 283 
 
80 - 99% = 566 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.37, total records: 572962 
 
Average version length: 36.31, total versions: 589, max versions: 3 
 
Average fragment length: 32.71, total fragments: 14, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 5, data page slots: 7248 
 
Data pages: 7248, average fill: 75% 
 
Primary pages: 7239, secondary pages: 9, swept pages: 6498 
 
Empty pages: 5, full pages: 6878 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 5 
 
40 - 59% = 22 
 
60 - 79% = 7197 
 
80 - 99% = 9 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 248655, depth: 3, leaf buckets: 2113, nodes: 572962 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.84, compression ratio: 1.02 
 
Average prefix length: 3.15, average data length: 5.85 
 
Clustering factor: 130700, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1181 
 
40 - 59% = 890 
 
60 - 79% = 35 
 
80 - 99% = 7 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 594, nodes: 572962 
 
Average node length: 4.86, total dup: 572912, max dup: 39964 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 259997, ratio: 0.45 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 500 
 
60 - 79% = 70 
 
80 - 99% = 24 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 332023, depth: 3, leaf buckets: 1638, nodes: 572962 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.84, compression ratio: 1.02 
 
Average prefix length: 3.16, average data length: 5.84 
 
Clustering factor: 130700, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 113 
 
20 - 39% = 499 
 
40 - 59% = 488 
 
60 - 79% = 257 
 
80 - 99% = 281 
 
 
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: 64.33, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 17.75, total fragments: 351, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.62 
 
Pointer pages: 1, data page slots: 200 
 
Data pages: 20, average fill: 33% 
 
Primary pages: 4, secondary pages: 16, swept pages: 4 
 
Empty pages: 3, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 7 
 
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: 50.61, total records: 1126 
 
Average version length: 71.25, total versions: 323, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 1.90 
 
Pointer pages: 1, data page slots: 184 
 
Data pages: 120, average fill: 12% 
 
Primary pages: 119, secondary pages: 1, swept pages: 76 
 
Empty pages: 70, full pages: 2 
 
Fill distribution: 
 
0 - 19% = 91 
 
20 - 39% = 19 
 
40 - 59% = 6 
 
60 - 79% = 3 
 
80 - 99% = 1 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 8, nodes: 1126 
 
Average node length: 18.78, total dup: 9, max dup: 1 
 
Average key length: 16.77, compression ratio: 1.61 
 
Average prefix length: 13.21, average data length: 13.79 
 
Clustering factor: 962, ratio: 0.85 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 6 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.04, total records: 49 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.13 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 20% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 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: 44.72, total records: 60 
 
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: 64.00, compression ratio: 1.43 
 
Pointer pages: 1, data page slots: 32 
 
Data pages: 18, average fill: 4% 
 
Primary pages: 16, secondary pages: 2, swept pages: 15 
 
Empty pages: 7, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 404166, depth: 2, leaf buckets: 1, nodes: 60 
 
Average node length: 11.85, total dup: 30, max dup: 10 
 
Average key length: 10.25, compression ratio: 1.85 
 
Average prefix length: 11.23, average data length: 7.77 
 
Clustering factor: 43, ratio: 0.72 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
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.49, total records: 201464 
 
Average version length: 28.61, total versions: 603, max versions: 7 
 
Average fragment length: 33.50, total fragments: 2, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.51 
 
Pointer pages: 2, data page slots: 2144 
 
Data pages: 2144, average fill: 70% 
 
Primary pages: 2141, secondary pages: 3, swept pages: 1591 
 
Empty pages: 8, full pages: 1198 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 24 
 
40 - 59% = 116 
 
60 - 79% = 1986 
 
80 - 99% = 2 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 192, nodes: 201464 
 
Average node length: 4.48, total dup: 201415, max dup: 7345 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 37804, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 13 
 
40 - 59% = 98 
 
60 - 79% = 69 
 
80 - 99% = 11 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 213, nodes: 201464 
 
Average node length: 5.43, total dup: 181461, max dup: 46 
 
Average key length: 2.96, compression ratio: 7.44 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 50902, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 18 
 
40 - 59% = 62 
 
60 - 79% = 84 
 
80 - 99% = 47 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 217, nodes: 201464 
 
Average node length: 5.43, total dup: 181461, max dup: 46 
 
Average key length: 2.96, compression ratio: 7.43 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 51010, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 12 
 
40 - 59% = 87 
 
60 - 79% = 82 
 
80 - 99% = 36 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 208, nodes: 201464 
 
Average node length: 5.21, total dup: 181461, max dup: 46 
 
Average key length: 2.75, compression ratio: 3.28 
 
Average prefix length: 8.35, average data length: 0.65 
 
Clustering factor: 51062, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 19 
 
40 - 59% = 81 
 
60 - 79% = 63 
 
80 - 99% = 44 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.98, total records: 235200 
 
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: 2016 
 
Data pages: 2016, average fill: 64% 
 
Primary pages: 2016, secondary pages: 0, swept pages: 0 
 
Empty pages: 6, full pages: 2009 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 2009 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 712015, depth: 2, leaf buckets: 184, nodes: 235200 
 
Average node length: 4.46, total dup: 235019, max dup: 1971 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.58, average data length: 0.00 
 
Clustering factor: 24111, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1 
 
40 - 59% = 54 
 
60 - 79% = 72 
 
80 - 99% = 56 
 
 
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.42, total records: 10693688 
 
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.20 
 
Pointer pages: 156, data page slots: 253432 
 
Data pages: 253432, average fill: 87% 
 
Primary pages: 253432, secondary pages: 0, swept pages: 3 
 
Empty pages: 2, full pages: 253429 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 253429 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 12282, nodes: 10693688 
 
Average node length: 5.62, total dup: 9873862, max dup: 148 
 
Average key length: 2.18, compression ratio: 3.66 
 
Average prefix length: 7.86, average data length: 0.14 
 
Clustering factor: 2971373, ratio: 0.28 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 7565 
 
60 - 79% = 3053 
 
80 - 99% = 1660 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 10525, nodes: 10693688 
 
Average node length: 4.54, total dup: 10693684, max dup: 9610368 
 
Average key length: 1.10, compression ratio: 0.46 
 
Average prefix length: 0.51, average data length: 0.00 
 
Clustering factor: 310820, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 10521 
 
60 - 79% = 1 
 
80 - 99% = 2 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 13078, nodes: 10693688 
 
Average node length: 5.67, total dup: 10361465, max dup: 27646 
 
Average key length: 2.23, compression ratio: 4.03 
 
Average prefix length: 8.80, average data length: 0.20 
 
Clustering factor: 817423, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 2 
 
40 - 59% = 10019 
 
60 - 79% = 1753 
 
80 - 99% = 1304 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 12798, nodes: 10693688 
 
Average node length: 5.51, total dup: 10666710, max dup: 1534254 
 
Average key length: 2.07, compression ratio: 18.27 
 
Average prefix length: 37.79, average data length: 0.07 
 
Clustering factor: 5462917, ratio: 0.51 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 1 
 
40 - 59% = 10894 
 
60 - 79% = 556 
 
80 - 99% = 1331 
 
 
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: 55.02, total records: 418011 
 
Average version length: 55.88, total versions: 515, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.45 
 
Pointer pages: 4, data page slots: 4968 
 
Data pages: 4968, average fill: 74% 
 
Primary pages: 4968, secondary pages: 0, swept pages: 3586 
 
Empty pages: 8, full pages: 4659 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 4 
 
40 - 59% = 25 
 
60 - 79% = 4924 
 
80 - 99% = 0 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 640125, depth: 3, leaf buckets: 541, nodes: 418011 
 
Average node length: 5.88, total dup: 354360, max dup: 471 
 
Average key length: 3.10, compression ratio: 2.90 
 
Average prefix length: 8.05, average data length: 0.95 
 
Clustering factor: 53405, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 44 
 
40 - 59% = 302 
 
60 - 79% = 134 
 
80 - 99% = 55 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 447, nodes: 418011 
 
Average node length: 5.60, total dup: 371928, max dup: 105 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.29, average data length: 0.71 
 
Clustering factor: 102477, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 7 
 
40 - 59% = 180 
 
60 - 79% = 174 
 
80 - 99% = 84 
 
 
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.81, total records: 2479 
 
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: 71% 
 
Primary pages: 32, secondary pages: 0, swept pages: 0 
 
Empty pages: 2, full pages: 29 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 30 
 
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: 49.46, total records: 7089 
 
Average version length: 72.17, total versions: 2233, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.75 
 
Pointer pages: 2, data page slots: 464 
 
Data pages: 240, average fill: 36% 
 
Primary pages: 239, secondary pages: 1, swept pages: 148 
 
Empty pages: 50, full pages: 48 
 
Fill distribution: 
 
0 - 19% = 106 
 
20 - 39% = 31 
 
40 - 59% = 29 
 
60 - 79% = 57 
 
80 - 99% = 17 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 16, nodes: 7089 
 
Average node length: 6.52, total dup: 6157, max dup: 14 
 
Average key length: 4.57, compression ratio: 8.10 
 
Average prefix length: 34.56, average data length: 2.44 
 
Clustering factor: 1271, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 10 
 
40 - 59% = 5 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.97, total records: 864402 
 
Average version length: 71.79, total versions: 2491, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.89 
 
Pointer pages: 8, data page slots: 12672 
 
Data pages: 12656, average fill: 75% 
 
Primary pages: 12656, secondary pages: 0, swept pages: 7871 
 
Empty pages: 32, full pages: 11075 
 
Fill distribution: 
 
0 - 19% = 53 
 
20 - 39% = 89 
 
40 - 59% = 337 
 
60 - 79% = 12157 
 
80 - 99% = 20 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 455478, depth: 3, leaf buckets: 961, nodes: 864402 
 
Average node length: 5.11, total dup: 840983, max dup: 126 
 
Average key length: 2.20, compression ratio: 4.09 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 104090, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 103 
 
40 - 59% = 638 
 
60 - 79% = 43 
 
80 - 99% = 171 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 258537, depth: 3, leaf buckets: 1223, nodes: 864402 
 
Average node length: 6.23, total dup: 754544, max dup: 21 
 
Average key length: 3.32, compression ratio: 11.15 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 172417, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 141 
 
40 - 59% = 782 
 
60 - 79% = 153 
 
80 - 99% = 126 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 59.55, total records: 32779 
 
Average version length: 71.92, total versions: 5720, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.28 
 
Pointer pages: 2, data page slots: 2240 
 
Data pages: 1624, average fill: 24% 
 
Primary pages: 1622, secondary pages: 2, swept pages: 1026 
 
Empty pages: 478, full pages: 108 
 
Fill distribution: 
 
0 - 19% = 933 
 
20 - 39% = 267 
 
40 - 59% = 184 
 
60 - 79% = 211 
 
80 - 99% = 29 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 63, nodes: 32779 
 
Average node length: 5.79, total dup: 28793, max dup: 49 
 
Average key length: 3.57, compression ratio: 10.36 
 
Average prefix length: 35.55, average data length: 1.45 
 
Clustering factor: 4175, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 32 
 
40 - 59% = 28 
 
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.85, total records: 1445051 
 
Average version length: 71.46, total versions: 26634, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.92 
 
Pointer pages: 14, data page slots: 21520 
 
Data pages: 21520, average fill: 74% 
 
Primary pages: 21520, secondary pages: 0, swept pages: 10583 
 
Empty pages: 82, full pages: 17837 
 
Fill distribution: 
 
0 - 19% = 200 
 
20 - 39% = 423 
 
40 - 59% = 1175 
 
60 - 79% = 19200 
 
80 - 99% = 522 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 195084, depth: 3, leaf buckets: 2178, nodes: 1445051 
 
Average node length: 5.58, total dup: 1361988, max dup: 49 
 
Average key length: 2.63, compression ratio: 14.07 
 
Average prefix length: 36.43, average data length: 0.57 
 
Clustering factor: 166387, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 889 
 
40 - 59% = 907 
 
60 - 79% = 233 
 
80 - 99% = 143 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 28.91, total records: 1174 
 
Average version length: 71.67, total versions: 695, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 4.70 
 
Pointer pages: 3, data page slots: 688 
 
Data pages: 320, average fill: 5% 
 
Primary pages: 319, secondary pages: 1, swept pages: 233 
 
Empty pages: 219, full pages: 6 
 
Fill distribution: 
 
0 - 19% = 299 
 
20 - 39% = 13 
 
40 - 59% = 2 
 
60 - 79% = 3 
 
80 - 99% = 3 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 3, nodes: 1174 
 
Average node length: 8.73, total dup: 965, max dup: 35 
 
Average key length: 6.76, compression ratio: 5.47 
 
Average prefix length: 32.42, average data length: 4.58 
 
Clustering factor: 184, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 2 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.97, total records: 2431138 
 
Average version length: 70.76, total versions: 12639, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.92 
 
Pointer pages: 21, data page slots: 34248 
 
Data pages: 34200, average fill: 77% 
 
Primary pages: 34200, secondary pages: 0, swept pages: 23678 
 
Empty pages: 13, full pages: 33019 
 
Fill distribution: 
 
0 - 19% = 26 
 
20 - 39% = 32 
 
40 - 59% = 168 
 
60 - 79% = 33595 
 
80 - 99% = 379 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5017, nodes: 2431138 
 
Average node length: 6.85, total dup: 1973687, max dup: 25 
 
Average key length: 3.88, compression ratio: 9.53 
 
Average prefix length: 35.31, average data length: 1.69 
 
Clustering factor: 426197, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 2816 
 
40 - 59% = 1762 
 
60 - 79% = 251 
 
80 - 99% = 186 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.38, total records: 4265756 
 
Average version length: 83.80, total versions: 918, 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: 41, data page slots: 65392 
 
Data pages: 65392, average fill: 80% 
 
Primary pages: 65392, secondary pages: 0, swept pages: 23349 
 
Empty pages: 4, full pages: 65208 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 1 
 
40 - 59% = 15 
 
60 - 79% = 19174 
 
80 - 99% = 46197 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4387, nodes: 4265756 
 
Average node length: 5.15, total dup: 4168633, max dup: 128 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 664086, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 65 
 
40 - 59% = 2008 
 
60 - 79% = 1818 
 
80 - 99% = 473 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 4457, nodes: 4265756 
 
Average node length: 5.70, total dup: 3814835, max dup: 49 
 
Average key length: 2.72, compression ratio: 3.31 
 
Average prefix length: 8.38, average data length: 0.62 
 
Clustering factor: 194615, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 32 
 
20 - 39% = 119 
 
40 - 59% = 2253 
 
60 - 79% = 279 
 
80 - 99% = 1774 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 4884, nodes: 4265756 
 
Average node length: 5.81, total dup: 3732226, max dup: 19 
 
Average key length: 2.83, compression ratio: 3.18 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 716453, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 19 
 
20 - 39% = 86 
 
40 - 59% = 2211 
 
60 - 79% = 1880 
 
80 - 99% = 688 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.76, total records: 2354402 
 
Average version length: 83.40, total versions: 8041, 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: 36720 
 
Data pages: 36720, average fill: 79% 
 
Primary pages: 36720, secondary pages: 0, swept pages: 26473 
 
Empty pages: 24, full pages: 35137 
 
Fill distribution: 
 
0 - 19% = 60 
 
20 - 39% = 102 
 
40 - 59% = 379 
 
60 - 79% = 14575 
 
80 - 99% = 21604 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2523, nodes: 2354402 
 
Average node length: 5.15, total dup: 2299306, max dup: 161 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 351207, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 45 
 
40 - 59% = 1505 
 
60 - 79% = 727 
 
80 - 99% = 245 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 3897, nodes: 2354402 
 
Average node length: 6.21, total dup: 1936196, max dup: 14 
 
Average key length: 3.24, compression ratio: 2.78 
 
Average prefix length: 7.94, average data length: 1.06 
 
Clustering factor: 205875, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 97 
 
20 - 39% = 1540 
 
40 - 59% = 1447 
 
60 - 79% = 521 
 
80 - 99% = 292 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 2880, nodes: 2354402 
 
Average node length: 5.82, total dup: 2058934, max dup: 29 
 
Average key length: 2.85, compression ratio: 3.16 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 428483, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 19 
 
20 - 39% = 52 
 
40 - 59% = 1753 
 
60 - 79% = 782 
 
80 - 99% = 274 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.42, total records: 4493524 
 
Average version length: 84.76, total versions: 7208, 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: 43, data page slots: 69512 
 
Data pages: 69304, average fill: 80% 
 
Primary pages: 69304, secondary pages: 0, swept pages: 17634 
 
Empty pages: 124, full pages: 67480 
 
Fill distribution: 
 
0 - 19% = 185 
 
20 - 39% = 185 
 
40 - 59% = 519 
 
60 - 79% = 13989 
 
80 - 99% = 54426 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 4709, nodes: 4493524 
 
Average node length: 5.04, total dup: 4466851, max dup: 720 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 638031, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 174 
 
40 - 59% = 2663 
 
60 - 79% = 1356 
 
80 - 99% = 510 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 5344, nodes: 4493524 
 
Average node length: 5.54, total dup: 4133416, max dup: 49 
 
Average key length: 2.55, compression ratio: 3.53 
 
Average prefix length: 8.53, average data length: 0.47 
 
Clustering factor: 197533, ratio: 0.04 
 
Fill distribution: 
 
0 - 19% = 94 
 
20 - 39% = 1413 
 
40 - 59% = 1978 
 
60 - 79% = 522 
 
80 - 99% = 1337 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 5278, nodes: 4493524 
 
Average node length: 5.69, total dup: 4026285, max dup: 93 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 713891, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 164 
 
40 - 59% = 2963 
 
60 - 79% = 1538 
 
80 - 99% = 609 
 
 
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.06, total records: 3073927 
 
Average version length: 83.43, total versions: 6507, 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: 30, data page slots: 48344 
 
Data pages: 48336, average fill: 78% 
 
Primary pages: 48336, secondary pages: 0, swept pages: 34727 
 
Empty pages: 56, full pages: 44813 
 
Fill distribution: 
 
0 - 19% = 118 
 
20 - 39% = 227 
 
40 - 59% = 944 
 
60 - 79% = 17896 
 
80 - 99% = 29151 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3341, nodes: 3073927 
 
Average node length: 5.02, total dup: 3058290, max dup: 1226 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 613110, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 359 
 
40 - 59% = 1771 
 
60 - 79% = 823 
 
80 - 99% = 376 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5119, nodes: 3073927 
 
Average node length: 6.22, total dup: 2525374, max dup: 14 
 
Average key length: 3.24, compression ratio: 2.77 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 290308, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 146 
 
20 - 39% = 2121 
 
40 - 59% = 1748 
 
60 - 79% = 700 
 
80 - 99% = 404 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 3677, nodes: 3073927 
 
Average node length: 5.61, total dup: 2794873, max dup: 54 
 
Average key length: 2.63, compression ratio: 3.42 
 
Average prefix length: 8.46, average data length: 0.54 
 
Clustering factor: 653098, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 366 
 
40 - 59% = 1844 
 
60 - 79% = 1023 
 
80 - 99% = 426 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.23, total records: 650507 
 
Average version length: 69.28, total versions: 1586, 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: 9152 
 
Data pages: 9152, average fill: 75% 
 
Primary pages: 9152, secondary pages: 0, swept pages: 7341 
 
Empty pages: 10, full pages: 8283 
 
Fill distribution: 
 
0 - 19% = 54 
 
20 - 39% = 132 
 
40 - 59% = 256 
 
60 - 79% = 8674 
 
80 - 99% = 36 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 174572, depth: 3, leaf buckets: 789, nodes: 650507 
 
Average node length: 5.28, total dup: 616949, max dup: 120 
 
Average key length: 2.39, compression ratio: 3.76 
 
Average prefix length: 8.66, average data length: 0.34 
 
Clustering factor: 50561, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 200 
 
40 - 59% = 318 
 
60 - 79% = 178 
 
80 - 99% = 90 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 888, nodes: 650507 
 
Average node length: 5.90, total dup: 558114, max dup: 14 
 
Average key length: 3.02, compression ratio: 2.98 
 
Average prefix length: 8.12, average data length: 0.88 
 
Clustering factor: 52751, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 223 
 
40 - 59% = 347 
 
60 - 79% = 239 
 
80 - 99% = 76 
 
 
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 
 
 
Gstat completion time Mon Apr 23 07:02:24 2018 
 
 
Done for 128440 ms, from  7:00:15.93 to  7:02:24.37. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 1943181  | 
 1982  | 
 0.1019  | 
|  DOC_LIST  | 
 572962  | 
 589  | 
 0.1027  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 1126  | 
 323  | 
 28.6856  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 60  | 
 0  | 
 0.0000  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 201464  | 
 603  | 
 0.2993  | 
|  PERF_ESTIMATED  | 
 235200  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 10693688  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 418011  | 
 515  | 
 0.1232  | 
|  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  | 
 2479  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 7089  | 
 2233  | 
 31.4995  | 
|  XQD_1000_3300  | 
 864402  | 
 2491  | 
 0.2881  | 
|  XQD_1200_2000  | 
 32779  | 
 5720  | 
 17.4501  | 
|  XQD_2000_3300  | 
 1445051  | 
 26634  | 
 1.8431  | 
|  XQD_2100_3300  | 
 1174  | 
 695  | 
 59.1993  | 
|  XQD_3300_3400  | 
 2431138  | 
 12639  | 
 0.5198  | 
|  XQS_1000_1200  | 
 4265756  | 
 918  | 
 0.0215  | 
|  XQS_1000_3300  | 
 2354402  | 
 8041  | 
 0.3415  | 
|  XQS_1200_2000  | 
 4493524  | 
 7208  | 
 0.1604  | 
|  XQS_2100_3300  | 
 3073927  | 
 6507  | 
 0.2116  | 
|  XQS_3300_3400  | 
 650507  | 
 1586  | 
 0.2438  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 1660 ms, from  7:02:31.18 to  7:02:32.84.  
07:02:32.92 Validation started 
 
 
07:02:32.95 Relation 140 (DOC_LIST) 
 
07:02:32.95   process pointer page    0 of    5 
 
07:02:32.99   process pointer page    1 of    5 
 
07:02:33.02   process pointer page    2 of    5 
 
07:02:33.07   process pointer page    3 of    5 
 
07:02:33.12   process pointer page    4 of    5 
 
07:02:33.13 Index 1 (PK_DOC_LIST) 
 
07:02:33.20 Index 2 (DOC_LIST_ID_DESC) 
 
07:02:33.27 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:02:33.32 Relation 140 (DOC_LIST) is ok 
 
 
07:02:33.32 Relation 141 (DOC_DATA) 
 
07:02:33.32   process pointer page    0 of   13 
 
07:02:33.35   process pointer page    1 of   13 
 
07:02:33.38   process pointer page    2 of   13 
 
07:02:33.41   process pointer page    3 of   13 
 
07:02:33.45   process pointer page    4 of   13 
 
07:02:33.46   process pointer page    5 of   13 
 
07:02:33.49   process pointer page    6 of   13 
 
07:02:33.52   process pointer page    7 of   13 
 
07:02:33.56   process pointer page    8 of   13 
 
07:02:33.59   process pointer page    9 of   13 
 
07:02:33.60   process pointer page   10 of   13 
 
07:02:33.63   process pointer page   11 of   13 
 
07:02:33.66   process pointer page   12 of   13 
 
07:02:33.68 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:02:34.27 Index 3 (DOC_DATA_ID_DESC) 
 
07:02:34.79 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:02:35.05 Relation 141 (DOC_DATA) is ok 
 
 
07:02:35.05 Relation 147 (INVNT_SALDO) 
 
07:02:35.05   process pointer page    0 of    1 
 
07:02:35.05 Index 1 (PK_INVNT_SALDO) 
 
07:02:35.05 Relation 147 (INVNT_SALDO) is ok 
 
 
07:02:35.05 Relation 150 (PDISTR) 
 
07:02:35.05   process pointer page    0 of    2 
 
07:02:35.15   process pointer page    1 of    2 
 
07:02:35.18 Index 2 (PDISTR_SND_ID) 
 
07:02:35.24 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:02:35.27 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:02:35.29 Index 5 (PDISTR_AGENT_ID) 
 
07:02:35.32 Relation 150 (PDISTR) is ok 
 
 
07:02:35.32 Relation 151 (PSTORNED) 
 
07:02:35.32   process pointer page    0 of    4 
 
07:02:35.35   process pointer page    1 of    4 
 
07:02:35.40   process pointer page    2 of    4 
 
07:02:35.43   process pointer page    3 of    4 
 
07:02:35.43 Index 2 (PSTORNED_SND_ID) 
 
07:02:35.47 Index 3 (PSTORNED_RCV_ID) 
 
07:02:35.51 Relation 151 (PSTORNED) is ok 
 
 
07:02:35.51 Relation 156 (SEMAPHORES) 
 
07:02:35.51   process pointer page    0 of    1 
 
07:02:35.51 Index 1 (PK_SEMAPHORES) 
 
07:02:35.51 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:02:35.51 Relation 156 (SEMAPHORES) is ok 
 
 
07:02:35.51 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:02:35.51   process pointer page    0 of    1 
 
07:02:35.51 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:02:35.51 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:02:35.51 Relation 160 (PERF_ESTIMATED) 
 
07:02:35.51   process pointer page    0 of    2 
 
07:02:35.54   process pointer page    1 of    2 
 
07:02:35.55 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:02:35.57 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:02:35.57 Relation 161 (PERF_ISQL_STAT) 
 
07:02:35.57   process pointer page    0 of    1 
 
07:02:35.57 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:02:35.57 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:02:35.57 Relation 162 (TRACE_STAT) 
 
07:02:35.57   process pointer page    0 of    1 
 
07:02:35.57 Relation 162 (TRACE_STAT) is ok 
 
 
07:02:35.57 Relation 163 (PERF_LOG) 
 
07:02:35.57   process pointer page    0 of  156 
 
07:02:35.60   process pointer page    1 of  156 
 
07:02:35.63   process pointer page    2 of  156 
 
07:02:35.72   process pointer page    3 of  156 
 
07:02:35.80   process pointer page    4 of  156 
 
07:02:35.88   process pointer page    5 of  156 
 
07:02:35.93   process pointer page    6 of  156 
 
07:02:35.97   process pointer page    7 of  156 
 
07:02:36.05   process pointer page    8 of  156 
 
07:02:36.14   process pointer page    9 of  156 
 
07:02:36.22   process pointer page   10 of  156 
 
07:02:36.30   process pointer page   11 of  156 
 
07:02:36.39   process pointer page   12 of  156 
 
07:02:36.46   process pointer page   13 of  156 
 
07:02:36.49   process pointer page   14 of  156 
 
07:02:36.52   process pointer page   15 of  156 
 
07:02:36.55   process pointer page   16 of  156 
 
07:02:36.60   process pointer page   17 of  156 
 
07:02:36.61   process pointer page   18 of  156 
 
07:02:36.64   process pointer page   19 of  156 
 
07:02:36.68   process pointer page   20 of  156 
 
07:02:36.69   process pointer page   21 of  156 
 
07:02:36.72   process pointer page   22 of  156 
 
07:02:36.75   process pointer page   23 of  156 
 
07:02:36.77   process pointer page   24 of  156 
 
07:02:36.83   process pointer page   25 of  156 
 
07:02:36.89   process pointer page   26 of  156 
 
07:02:36.96   process pointer page   27 of  156 
 
07:02:36.99   process pointer page   28 of  156 
 
07:02:37.02   process pointer page   29 of  156 
 
07:02:37.05   process pointer page   30 of  156 
 
07:02:37.08   process pointer page   31 of  156 
 
07:02:37.10   process pointer page   32 of  156 
 
07:02:37.14   process pointer page   33 of  156 
 
07:02:37.22   process pointer page   34 of  156 
 
07:02:37.30   process pointer page   35 of  156 
 
07:02:37.36   process pointer page   36 of  156 
 
07:02:37.39   process pointer page   37 of  156 
 
07:02:37.42   process pointer page   38 of  156 
 
07:02:37.46   process pointer page   39 of  156 
 
07:02:37.49   process pointer page   40 of  156 
 
07:02:37.52   process pointer page   41 of  156 
 
07:02:37.55   process pointer page   42 of  156 
 
07:02:37.58   process pointer page   43 of  156 
 
07:02:37.61   process pointer page   44 of  156 
 
07:02:37.64   process pointer page   45 of  156 
 
07:02:37.67   process pointer page   46 of  156 
 
07:02:37.70   process pointer page   47 of  156 
 
07:02:37.74   process pointer page   48 of  156 
 
07:02:37.77   process pointer page   49 of  156 
 
07:02:37.80   process pointer page   50 of  156 
 
07:02:37.83   process pointer page   51 of  156 
 
07:02:37.85   process pointer page   52 of  156 
 
07:02:37.88   process pointer page   53 of  156 
 
07:02:37.89   process pointer page   54 of  156 
 
07:02:37.92   process pointer page   55 of  156 
 
07:02:37.94   process pointer page   56 of  156 
 
07:02:37.97   process pointer page   57 of  156 
 
07:02:37.99   process pointer page   58 of  156 
 
07:02:38.02   process pointer page   59 of  156 
 
07:02:38.05   process pointer page   60 of  156 
 
07:02:38.08   process pointer page   61 of  156 
 
07:02:38.14   process pointer page   62 of  156 
 
07:02:38.22   process pointer page   63 of  156 
 
07:02:38.30   process pointer page   64 of  156 
 
07:02:38.38   process pointer page   65 of  156 
 
07:02:38.47   process pointer page   66 of  156 
 
07:02:38.50   process pointer page   67 of  156 
 
07:02:38.53   process pointer page   68 of  156 
 
07:02:38.56   process pointer page   69 of  156 
 
07:02:38.59   process pointer page   70 of  156 
 
07:02:38.63   process pointer page   71 of  156 
 
07:02:38.70   process pointer page   72 of  156 
 
07:02:38.75   process pointer page   73 of  156 
 
07:02:38.78   process pointer page   74 of  156 
 
07:02:38.81   process pointer page   75 of  156 
 
07:02:38.84   process pointer page   76 of  156 
 
07:02:38.87   process pointer page   77 of  156 
 
07:02:38.91   process pointer page   78 of  156 
 
07:02:38.94   process pointer page   79 of  156 
 
07:02:38.97   process pointer page   80 of  156 
 
07:02:39.00   process pointer page   81 of  156 
 
07:02:39.03   process pointer page   82 of  156 
 
07:02:39.05   process pointer page   83 of  156 
 
07:02:39.08   process pointer page   84 of  156 
 
07:02:39.09   process pointer page   85 of  156 
 
07:02:39.11   process pointer page   86 of  156 
 
07:02:39.14   process pointer page   87 of  156 
 
07:02:39.16   process pointer page   88 of  156 
 
07:02:39.19   process pointer page   89 of  156 
 
07:02:39.22   process pointer page   90 of  156 
 
07:02:39.25   process pointer page   91 of  156 
 
07:02:39.28   process pointer page   92 of  156 
 
07:02:39.34   process pointer page   93 of  156 
 
07:02:39.37   process pointer page   94 of  156 
 
07:02:39.42   process pointer page   95 of  156 
 
07:02:39.48   process pointer page   96 of  156 
 
07:02:39.51   process pointer page   97 of  156 
 
07:02:39.55   process pointer page   98 of  156 
 
07:02:39.58   process pointer page   99 of  156 
 
07:02:39.65   process pointer page  100 of  156 
 
07:02:39.70   process pointer page  101 of  156 
 
07:02:39.73   process pointer page  102 of  156 
 
07:02:39.76   process pointer page  103 of  156 
 
07:02:39.80   process pointer page  104 of  156 
 
07:02:39.83   process pointer page  105 of  156 
 
07:02:39.86   process pointer page  106 of  156 
 
07:02:39.87   process pointer page  107 of  156 
 
07:02:39.90   process pointer page  108 of  156 
 
07:02:39.94   process pointer page  109 of  156 
 
07:02:39.97   process pointer page  110 of  156 
 
07:02:40.00   process pointer page  111 of  156 
 
07:02:40.03   process pointer page  112 of  156 
 
07:02:40.06   process pointer page  113 of  156 
 
07:02:40.09   process pointer page  114 of  156 
 
07:02:40.12   process pointer page  115 of  156 
 
07:02:40.15   process pointer page  116 of  156 
 
07:02:40.19   process pointer page  117 of  156 
 
07:02:40.22   process pointer page  118 of  156 
 
07:02:40.25   process pointer page  119 of  156 
 
07:02:40.26   process pointer page  120 of  156 
 
07:02:40.29   process pointer page  121 of  156 
 
07:02:40.31   process pointer page  122 of  156 
 
07:02:40.34   process pointer page  123 of  156 
 
07:02:40.36   process pointer page  124 of  156 
 
07:02:40.39   process pointer page  125 of  156 
 
07:02:40.40   process pointer page  126 of  156 
 
07:02:40.43   process pointer page  127 of  156 
 
07:02:40.45   process pointer page  128 of  156 
 
07:02:40.48   process pointer page  129 of  156 
 
07:02:40.51   process pointer page  130 of  156 
 
07:02:40.56   process pointer page  131 of  156 
 
07:02:40.61   process pointer page  132 of  156 
 
07:02:40.64   process pointer page  133 of  156 
 
07:02:40.72   process pointer page  134 of  156 
 
07:02:40.79   process pointer page  135 of  156 
 
07:02:40.89   process pointer page  136 of  156 
 
07:02:40.97   process pointer page  137 of  156 
 
07:02:41.01   process pointer page  138 of  156 
 
07:02:41.04   process pointer page  139 of  156 
 
07:02:41.07   process pointer page  140 of  156 
 
07:02:41.11   process pointer page  141 of  156 
 
07:02:41.14   process pointer page  142 of  156 
 
07:02:41.17   process pointer page  143 of  156 
 
07:02:41.18   process pointer page  144 of  156 
 
07:02:41.21   process pointer page  145 of  156 
 
07:02:41.25   process pointer page  146 of  156 
 
07:02:41.28   process pointer page  147 of  156 
 
07:02:41.29   process pointer page  148 of  156 
 
07:02:41.34   process pointer page  149 of  156 
 
07:02:41.37   process pointer page  150 of  156 
 
07:02:41.39   process pointer page  151 of  156 
 
07:02:41.42   process pointer page  152 of  156 
 
07:02:41.45   process pointer page  153 of  156 
 
07:02:41.48   process pointer page  154 of  156 
 
07:02:41.50   process pointer page  155 of  156 
 
07:02:41.51 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:02:43.12 Index 2 (PERF_LOG_UNIT) 
 
07:02:45.35 Index 3 (PERF_LOG_TRN_DESC) 
 
07:02:46.99 Index 4 (PERF_LOG_GDSCODE) 
 
07:02:47.69 Relation 163 (PERF_LOG) is ok 
 
 
07:02:47.69 Relation 167 (V_STOPTEST) 
 
07:02:47.69 Relation 167 (V_STOPTEST) is ok 
 
 
07:02:47.69 Relation 184 (V_QDISTR_SOURCE) 
 
07:02:47.69 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:02:47.69 Relation 185 (V_QSTORNED_SOURCE) 
 
07:02:47.69 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:02:47.69 Relation 260 (XQD_1000_1200) 
 
07:02:47.69   process pointer page    0 of    2 
 
07:02:47.69   process pointer page    1 of    2 
 
07:02:47.69 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:02:47.70 Relation 260 (XQD_1000_1200) is ok 
 
 
07:02:47.70 Relation 261 (XQD_1200_2000) 
 
07:02:47.70   process pointer page    0 of    2 
 
07:02:47.72   process pointer page    1 of    2 
 
07:02:47.72 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:02:47.74 Relation 261 (XQD_1200_2000) is ok 
 
 
07:02:47.74 Relation 262 (XQD_1000_3300) 
 
07:02:47.74   process pointer page    0 of    8 
 
07:02:47.77   process pointer page    1 of    8 
 
07:02:47.83   process pointer page    2 of    8 
 
07:02:47.91   process pointer page    3 of    8 
 
07:02:48.00   process pointer page    4 of    8 
 
07:02:48.08   process pointer page    5 of    8 
 
07:02:48.17   process pointer page    6 of    8 
 
07:02:48.27   process pointer page    7 of    8 
 
07:02:48.30 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:02:48.42 Index 2 (XQD_1000_3300_DOC) 
 
07:02:48.55 Relation 262 (XQD_1000_3300) is ok 
 
 
07:02:48.55 Relation 263 (XQD_2000_3300) 
 
07:02:48.55   process pointer page    0 of   14 
 
07:02:48.59   process pointer page    1 of   14 
 
07:02:48.62   process pointer page    2 of   14 
 
07:02:48.66   process pointer page    3 of   14 
 
07:02:48.70   process pointer page    4 of   14 
 
07:02:48.73   process pointer page    5 of   14 
 
07:02:48.75   process pointer page    6 of   14 
 
07:02:48.78   process pointer page    7 of   14 
 
07:02:48.81   process pointer page    8 of   14 
 
07:02:48.84   process pointer page    9 of   14 
 
07:02:48.87   process pointer page   10 of   14 
 
07:02:48.94   process pointer page   11 of   14 
 
07:02:49.03   process pointer page   12 of   14 
 
07:02:49.12   process pointer page   13 of   14 
 
07:02:49.14 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:02:49.61 Relation 263 (XQD_2000_3300) is ok 
 
 
07:02:49.61 Relation 264 (XQD_2100_3300) 
 
07:02:49.61   process pointer page    0 of    3 
 
07:02:49.61   process pointer page    1 of    3 
 
07:02:49.61   process pointer page    2 of    3 
 
07:02:49.61 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:02:49.61 Relation 264 (XQD_2100_3300) is ok 
 
 
07:02:49.61 Relation 265 (XQD_3300_3400) 
 
07:02:49.61   process pointer page    0 of   21 
 
07:02:49.64   process pointer page    1 of   21 
 
07:02:49.67   process pointer page    2 of   21 
 
07:02:49.72   process pointer page    3 of   21 
 
07:02:49.75   process pointer page    4 of   21 
 
07:02:49.78   process pointer page    5 of   21 
 
07:02:49.81   process pointer page    6 of   21 
 
07:02:49.84   process pointer page    7 of   21 
 
07:02:49.87   process pointer page    8 of   21 
 
07:02:49.90   process pointer page    9 of   21 
 
07:02:49.94   process pointer page   10 of   21 
 
07:02:49.97   process pointer page   11 of   21 
 
07:02:50.00   process pointer page   12 of   21 
 
07:02:50.03   process pointer page   13 of   21 
 
07:02:50.06   process pointer page   14 of   21 
 
07:02:50.09   process pointer page   15 of   21 
 
07:02:50.11   process pointer page   16 of   21 
 
07:02:50.14   process pointer page   17 of   21 
 
07:02:50.17   process pointer page   18 of   21 
 
07:02:50.18   process pointer page   19 of   21 
 
07:02:50.22   process pointer page   20 of   21 
 
07:02:50.25 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:02:50.65 Relation 265 (XQD_3300_3400) is ok 
 
 
07:02:50.65 Relation 266 (XQS_1000_1200) 
 
07:02:50.65   process pointer page    0 of   41 
 
07:02:50.70   process pointer page    1 of   41 
 
07:02:50.73   process pointer page    2 of   41 
 
07:02:50.81   process pointer page    3 of   41 
 
07:02:50.84   process pointer page    4 of   41 
 
07:02:50.87   process pointer page    5 of   41 
 
07:02:50.90   process pointer page    6 of   41 
 
07:02:50.93   process pointer page    7 of   41 
 
07:02:50.96   process pointer page    8 of   41 
 
07:02:51.00   process pointer page    9 of   41 
 
07:02:51.03   process pointer page   10 of   41 
 
07:02:51.06   process pointer page   11 of   41 
 
07:02:51.09   process pointer page   12 of   41 
 
07:02:51.12   process pointer page   13 of   41 
 
07:02:51.14   process pointer page   14 of   41 
 
07:02:51.17   process pointer page   15 of   41 
 
07:02:51.20   process pointer page   16 of   41 
 
07:02:51.23   process pointer page   17 of   41 
 
07:02:51.25   process pointer page   18 of   41 
 
07:02:51.28   process pointer page   19 of   41 
 
07:02:51.31   process pointer page   20 of   41 
 
07:02:51.34   process pointer page   21 of   41 
 
07:02:51.37   process pointer page   22 of   41 
 
07:02:51.39   process pointer page   23 of   41 
 
07:02:51.42   process pointer page   24 of   41 
 
07:02:51.45   process pointer page   25 of   41 
 
07:02:51.46   process pointer page   26 of   41 
 
07:02:51.50   process pointer page   27 of   41 
 
07:02:51.51   process pointer page   28 of   41 
 
07:02:51.54   process pointer page   29 of   41 
 
07:02:51.57   process pointer page   30 of   41 
 
07:02:51.67   process pointer page   31 of   41 
 
07:02:51.70   process pointer page   32 of   41 
 
07:02:51.74   process pointer page   33 of   41 
 
07:02:51.84   process pointer page   34 of   41 
 
07:02:51.87   process pointer page   35 of   41 
 
07:02:51.93   process pointer page   36 of   41 
 
07:02:51.98   process pointer page   37 of   41 
 
07:02:52.01   process pointer page   38 of   41 
 
07:02:52.07   process pointer page   39 of   41 
 
07:02:52.13   process pointer page   40 of   41 
 
07:02:52.13 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:02:52.62 Index 2 (XQS_1000_1200_SND_ID) 
 
07:02:52.98 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:02:53.45 Relation 266 (XQS_1000_1200) is ok 
 
 
07:02:53.45 Relation 267 (XQS_1200_2000) 
 
07:02:53.46   process pointer page    0 of   43 
 
07:02:53.48   process pointer page    1 of   43 
 
07:02:53.51   process pointer page    2 of   43 
 
07:02:53.54   process pointer page    3 of   43 
 
07:02:53.57   process pointer page    4 of   43 
 
07:02:53.60   process pointer page    5 of   43 
 
07:02:53.65   process pointer page    6 of   43 
 
07:02:53.74   process pointer page    7 of   43 
 
07:02:53.77   process pointer page    8 of   43 
 
07:02:53.82   process pointer page    9 of   43 
 
07:02:53.85   process pointer page   10 of   43 
 
07:02:53.90   process pointer page   11 of   43 
 
07:02:53.93   process pointer page   12 of   43 
 
07:02:53.96   process pointer page   13 of   43 
 
07:02:53.98   process pointer page   14 of   43 
 
07:02:54.02   process pointer page   15 of   43 
 
07:02:54.05   process pointer page   16 of   43 
 
07:02:54.12   process pointer page   17 of   43 
 
07:02:54.16   process pointer page   18 of   43 
 
07:02:54.21   process pointer page   19 of   43 
 
07:02:54.24   process pointer page   20 of   43 
 
07:02:54.27   process pointer page   21 of   43 
 
07:02:54.30   process pointer page   22 of   43 
 
07:02:54.33   process pointer page   23 of   43 
 
07:02:54.37   process pointer page   24 of   43 
 
07:02:54.40   process pointer page   25 of   43 
 
07:02:54.44   process pointer page   26 of   43 
 
07:02:54.46   process pointer page   27 of   43 
 
07:02:54.49   process pointer page   28 of   43 
 
07:02:54.52   process pointer page   29 of   43 
 
07:02:54.55   process pointer page   30 of   43 
 
07:02:54.58   process pointer page   31 of   43 
 
07:02:54.60   process pointer page   32 of   43 
 
07:02:54.63   process pointer page   33 of   43 
 
07:02:54.66   process pointer page   34 of   43 
 
07:02:54.68   process pointer page   35 of   43 
 
07:02:54.71   process pointer page   36 of   43 
 
07:02:54.74   process pointer page   37 of   43 
 
07:02:54.76   process pointer page   38 of   43 
 
07:02:54.79   process pointer page   39 of   43 
 
07:02:54.82   process pointer page   40 of   43 
 
07:02:54.85   process pointer page   41 of   43 
 
07:02:54.90   process pointer page   42 of   43 
 
07:02:54.91 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:02:55.99 Index 2 (XQS_1200_2000_SND_ID) 
 
07:02:56.44 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:02:57.06 Relation 267 (XQS_1200_2000) is ok 
 
 
07:02:57.06 Relation 268 (XQS_1000_3300) 
 
07:02:57.06   process pointer page    0 of   23 
 
07:02:57.11   process pointer page    1 of   23 
 
07:02:57.14   process pointer page    2 of   23 
 
07:02:57.17   process pointer page    3 of   23 
 
07:02:57.20   process pointer page    4 of   23 
 
07:02:57.25   process pointer page    5 of   23 
 
07:02:57.35   process pointer page    6 of   23 
 
07:02:57.38   process pointer page    7 of   23 
 
07:02:57.42   process pointer page    8 of   23 
 
07:02:57.45   process pointer page    9 of   23 
 
07:02:57.50   process pointer page   10 of   23 
 
07:02:57.53   process pointer page   11 of   23 
 
07:02:57.56   process pointer page   12 of   23 
 
07:02:57.59   process pointer page   13 of   23 
 
07:02:57.63   process pointer page   14 of   23 
 
07:02:57.64   process pointer page   15 of   23 
 
07:02:57.67   process pointer page   16 of   23 
 
07:02:57.77   process pointer page   17 of   23 
 
07:02:57.86   process pointer page   18 of   23 
 
07:02:57.91   process pointer page   19 of   23 
 
07:02:57.94   process pointer page   20 of   23 
 
07:02:57.97   process pointer page   21 of   23 
 
07:02:58.02   process pointer page   22 of   23 
 
07:02:58.03 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:02:58.31 Index 2 (XQS_1000_3300_SND_ID) 
 
07:02:58.69 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:02:59.26 Relation 268 (XQS_1000_3300) is ok 
 
 
07:02:59.26 Relation 269 (XQS_2000_3300) 
 
07:02:59.26   process pointer page    0 of    1 
 
07:02:59.26 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:02:59.26 Index 2 (XQS_2000_3300_SND_ID) 
 
07:02:59.26 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:02:59.26 Relation 269 (XQS_2000_3300) is ok 
 
 
07:02:59.26 Relation 270 (XQS_2100_3300) 
 
07:02:59.26   process pointer page    0 of   30 
 
07:02:59.30   process pointer page    1 of   30 
 
07:02:59.33   process pointer page    2 of   30 
 
07:02:59.36   process pointer page    3 of   30 
 
07:02:59.39   process pointer page    4 of   30 
 
07:02:59.42   process pointer page    5 of   30 
 
07:02:59.45   process pointer page    6 of   30 
 
07:02:59.48   process pointer page    7 of   30 
 
07:02:59.51   process pointer page    8 of   30 
 
07:02:59.56   process pointer page    9 of   30 
 
07:02:59.61   process pointer page   10 of   30 
 
07:02:59.65   process pointer page   11 of   30 
 
07:02:59.69   process pointer page   12 of   30 
 
07:02:59.72   process pointer page   13 of   30 
 
07:02:59.75   process pointer page   14 of   30 
 
07:02:59.78   process pointer page   15 of   30 
 
07:02:59.81   process pointer page   16 of   30 
 
07:02:59.84   process pointer page   17 of   30 
 
07:02:59.86   process pointer page   18 of   30 
 
07:02:59.89   process pointer page   19 of   30 
 
07:02:59.92   process pointer page   20 of   30 
 
07:02:59.97   process pointer page   21 of   30 
 
07:03:00.00   process pointer page   22 of   30 
 
07:03:00.03   process pointer page   23 of   30 
 
07:03:00.06   process pointer page   24 of   30 
 
07:03:00.09   process pointer page   25 of   30 
 
07:03:00.12   process pointer page   26 of   30 
 
07:03:00.15   process pointer page   27 of   30 
 
07:03:00.18   process pointer page   28 of   30 
 
07:03:00.22   process pointer page   29 of   30 
 
07:03:00.23 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:03:00.51 Index 2 (XQS_2100_3300_SND_ID) 
 
07:03:01.04 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:03:01.62 Relation 270 (XQS_2100_3300) is ok 
 
 
07:03:01.62 Relation 271 (XQS_3300_3400) 
 
07:03:01.62   process pointer page    0 of    6 
 
07:03:01.65   process pointer page    1 of    6 
 
07:03:01.70   process pointer page    2 of    6 
 
07:03:01.73   process pointer page    3 of    6 
 
07:03:01.84   process pointer page    4 of    6 
 
07:03:01.87   process pointer page    5 of    6 
 
07:03:01.90 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:03:01.98 Index 2 (XQS_3300_3400_SND_ID) 
 
07:03:02.09 Relation 271 (XQS_3300_3400) is ok 
 
 
07:03:02.09 Validation finished 
 
Done for 29230 ms, from  7:02:32.87 to  7:03:02.10. 
 
 Differences between old and current firebird.log 
7:03:03.23. 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:
 
2018-04-23  07:03               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 Mon Apr 23 07:02:32 2018 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Mon Apr 23 07:03:02 2018 
 
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. 
 
2018-04-23  7:03:07.59 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html