Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-03-15  7:58:38.99.
 
Server version: WI-T4.0.0.32397 Firebird 4.0 Unstable
 
Server implementation: Firebird/Windows/AMD/Intel/x64 
 
|  FB_ARCHITECTURE  | 
 DB_NAME  | 
 FORCED_WRITES  | 
 SWEEP_INT  | 
 PAGE_BUFFERS  | 
 PAGE_SIZE  | 
|  SuperServer 4.0.0  | 
 D:\OLTP-EMUL\OLTP40-SMALL.FDB  | 
 ON  | 
 0  | 
 786432  | 
 8192  | 
 
 Test configuration settings 
 
File: E:\OLTP-EMUL\src\oltp40_config.win 
 
|  PARAM_NAME  | 
 PARAM_VALUE  | 
|  fbc  | 
 E:\FB40.TMPINSTANCE  | 
|  dbnm  | 
 D:\OLTP-EMUL\oltp40-small.fdb  | 
|  host  | 
 localhost  | 
|  port  | 
 3400  | 
|  usr  | 
 SYSDBA  | 
|  pwd  | 
 masterkey  | 
|  tmpdir  | 
 e:\temp\logs.oltp40  | 
|  working_mode  | 
 small_03  | 
|  warm_time  | 
 10  | 
|  test_time  | 
 180  | 
|  idle_time  | 
 0  | 
|  use_mtee  | 
 0  | 
|  is_embed  | 
 0  | 
|  remove_isql_logs  | 
 if_no_severe_errors  | 
|  no_auto_undo  | 
 1  | 
|  detailed_info  | 
 0  | 
|  mon_unit_perf  | 
 0  | 
|  trc_unit_perf  | 
 1  | 
|  init_buff  | 
 32768  | 
|  create_with_fw  | 
 sync  | 
|  create_with_sweep  | 
 0  | 
|  wait_if_not_exists  | 
 0  | 
|  wait_after_create  | 
 0  | 
|  init_docs  | 
 0  | 
|  wait_for_copy  | 
 0  | 
|  create_with_debug_objects  | 
 1  | 
|  create_with_split_heavy_tabs  | 
 1  | 
|  create_with_separate_qdistr_idx  | 
 0  | 
|  create_with_compound_columns_order  | 
 most_selective_first  | 
|  make_html  | 
 1  | 
|  run_db_statistics  | 
 1  | 
|  run_db_validation  | 
 1  | 
|  file_name_with_test_params  | 
 regular  | 
|  file_name_this_host_info  | 
 ak40  | 
|  upload_report  | 
 1  | 
 
 
 
|  FINISH_STATE  | 
 DTS_END  | 
 FB_GDSCODE  | 
 FB_MNEMONA  | 
 STACK  | 
 IP  | 
 TRN_ID  | 
 ATT_ID  | 
 EXC_UNIT  | 
|  NORMAL: TEST_TIME EXPIRED.  | 
 2016-03-15 07:56:15.9060  | 
 -1  | 
 <null>  | 
   | 
 ::1/50806  | 
 347507  | 
 5010  | 
 2  | 
 
 
 
|  CATEGORY  | 
 SETTING  | 
 VAL  | 
|  COMMON  | 
 TRACED_UNITS  | 
 ,,  | 
|  COMMON  | 
 HALT_TEST_ON_ERRORS  | 
 ,CK,  | 
|  COMMON  | 
 LOG_PK_VIOLATION  | 
 0  | 
|  COMMON  | 
 QMISM_VERIFY_BITSET  | 
 1  | 
|  COMMON  | 
 RECALC_IDX_MIN_INTERVAL  | 
 15  | 
|  COMMON  | 
 ENABLE_RESERVES_WHEN_ADD_INVOICE  | 
 1  | 
|  COMMON  | 
 ORDER_FOR_OUR_FIRM_PERCENT  | 
 25  | 
|  COMMON  | 
 ENABLE_FILL_PHRASES  | 
 0  | 
|  COMMON  | 
 RANDOM_SEEK_VIA_ROWS_LIMIT  | 
 0  | 
|  COMMON  | 
 C_INVOICE_MIN_PURCHASE  | 
 1000  | 
|  COMMON  | 
 C_INVOICE_MAX_PURCHASE  | 
 2000  | 
|  COMMON  | 
 C_INVOICE_MIN_PROFIT_PRC  | 
 35  | 
|  COMMON  | 
 C_INVOICE_MAX_PROFIT_PRC  | 
 80  | 
|  COMMON  | 
 C_MIN_COST_TO_BE_SPLITTED  | 
 1000  | 
|  COMMON  | 
 C_ROWS_TO_MULTIPLY  | 
 10  | 
|  COMMON  | 
 C_PAYMENT_FROM_CLIENT_MIN_TOTAL  | 
 1000  | 
|  COMMON  | 
 C_PAYMENT_FROM_CLIENT_MAX_TOTAL  | 
 5000  | 
|  COMMON  | 
 C_PAYMENT_TO_SUPPLIER_MIN_TOTAL  | 
 2000  | 
|  COMMON  | 
 C_PAYMENT_TO_SUPPLIER_MAX_TOTAL  | 
 15000  | 
|  COMMON  | 
 BUILD_WITH_SPLIT_HEAVY_TABS  | 
 1  | 
|  COMMON  | 
 BUILD_WITH_SEPAR_QDISTR_IDX  | 
 0  | 
|  COMMON  | 
 BUILD_WITH_QD_COMPOUND_ORDR  | 
 MOST_SELECTIVE_FIRST  | 
|  COMMON  | 
 ENABLE_MON_QUERY  | 
 0  | 
|  SMALL_03  | 
 C_WARES_MAX_ID  | 
 400  | 
|  SMALL_03  | 
 C_CUSTOMER_DOC_MAX_ROWS  | 
 10  | 
|  SMALL_03  | 
 C_SUPPLIER_DOC_MAX_ROWS  | 
 50  | 
|  SMALL_03  | 
 C_CUSTOMER_DOC_MAX_QTY  | 
 15  | 
|  SMALL_03  | 
 C_SUPPLIER_DOC_MAX_QTY  | 
 50  | 
|  SMALL_03  | 
 C_NUMBER_OF_AGENTS  | 
 50  | 
 
 
 
|  TAB_NAME  | 
 IDX_NAME  | 
 IDX_KEY  | 
|  XQD_1000_1200  | 
 XQD_1000_1200_WARE_SOP_ROP_SND  | 
 WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID  | 
|  XQD_1000_3300  | 
 XQD_1000_3300_DOC  | 
 DOC_ID  | 
|  XQD_1000_3300  | 
 XQD_1000_3300_WARE_SOP_ROP_SND  | 
 WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID  | 
|  XQD_1200_2000  | 
 XQD_1200_2000_WARE_SOP_ROP_SND  | 
 WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID  | 
|  XQD_2000_3300  | 
 XQD_2000_3300_WARE_SOP_ROP_SND  | 
 WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID  | 
|  XQD_2100_3300  | 
 XQD_2100_3300_WARE_SOP_ROP_SND  | 
 WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID  | 
|  XQD_3300_3400  | 
 XQD_3300_3400_WARE_SOP_ROP_SND  | 
 WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID  | 
 
 Performance reports 
 
 
 
|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 180 minutes:  | 
 5354.86  | 
 6714  | 
 963875  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  customer order: creation  | 
 409.48  | 
 1029  | 
 73707  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  customer order: refuse  | 
 33.57  | 
 72  | 
 6042  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  order to supplier: creation  | 
 105.63  | 
 7362  | 
 19014  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  order to supplier: removal  | 
 2.36  | 
 72544  | 
 420  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  invoice (draft): creation  | 
 105.34  | 
 11339  | 
 18961  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  invoice (draft): removal  | 
 34.93  | 
 2380  | 
 6253  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  invoice accept: apply  | 
 65.24  | 
 20959  | 
 11744  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  invoice accept: cancel  | 
 16.66  | 
 4719  | 
 2998  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  customer reserve: creation  | 
 3177.13  | 
 365  | 
 571883  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  customer reserve: removal  | 
 843.93  | 
 119  | 
 151907  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  realization accept: apply  | 
 188.79  | 
 318  | 
 33982  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  realization accept: cancel  | 
 55.86  | 
 224  | 
 10054  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  payment from customer: creation  | 
 137.72  | 
 319  | 
 24789  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  payment from customer: removal  | 
 13.20  | 
 86  | 
 2376  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  payment to supplier: creation  | 
 113.25  | 
 669  | 
 20385  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  payment to supplier: removal  | 
 8.19  | 
 148  | 
 1474  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  service: total inventory turnovers  | 
 20.17  | 
 1474  | 
 3630  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  service: total monetary turnovers  | 
 23.58  | 
 75  | 
 4244  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  service: refresh index statistics  | 
 0.07  | 
 3374  | 
 12  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
 
Done for 116770 ms, from  8:01:29.10 to  8:03:25.87.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4514  | 
 86215  | 
 81246  | 
 4969  | 
 5.76  | 
 04:56:16  | 
 05:14:16  | 
|  interval #   2, overall  | 
 2  | 
 5405  | 
 102155  | 
 97285  | 
 4870  | 
 4.77  | 
 05:14:17  | 
 05:32:17  | 
|  interval #   3, overall  | 
 3  | 
 5713  | 
 106307  | 
 102840  | 
 3467  | 
 3.26  | 
 05:32:18  | 
 05:50:18  | 
|  interval #   4, overall  | 
 4  | 
 5554  | 
 106749  | 
 99968  | 
 6781  | 
 6.35  | 
 05:50:19  | 
 06:08:19  | 
|  interval #   5, overall  | 
 5  | 
 5452  | 
 104523  | 
 98142  | 
 6381  | 
 6.10  | 
 06:08:20  | 
 06:26:20  | 
|  interval #   6, overall  | 
 6  | 
 5206  | 
 102362  | 
 93704  | 
 8658  | 
 8.46  | 
 06:26:21  | 
 06:44:21  | 
|  interval #   7, overall  | 
 7  | 
 5858  | 
 109156  | 
 105441  | 
 3715  | 
 3.40  | 
 06:44:22  | 
 07:02:22  | 
|  interval #   8, overall  | 
 8  | 
 5626  | 
 107674  | 
 101262  | 
 6412  | 
 5.96  | 
 07:02:23  | 
 07:20:23  | 
|  interval #   9, overall  | 
 9  | 
 5334  | 
 100729  | 
 96008  | 
 4721  | 
 4.69  | 
 07:20:24  | 
 07:38:24  | 
|  interval #  10, overall  | 
 10  | 
 4888  | 
 93753  | 
 87979  | 
 5774  | 
 6.16  | 
 07:38:25  | 
 07:56:25  | 
 
Done for 189050 ms, from  8:06:31.80 to  8:09:40.85.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  WARM_TIME  | 
 1  | 
 5705.59  | 
 0.5827  | 
 1.3358  | 
 2293  | 
 100  | 
|  WARM_TIME  | 
 2  | 
 4484.02  | 
 0.8500  | 
 1.1607  | 
 2644  | 
 93  | 
|  WARM_TIME  | 
 3  | 
 3858.35  | 
 0.8994  | 
 1.0959  | 
 1913  | 
 75  | 
|  WARM_TIME  | 
 4  | 
 3468.09  | 
 0.9145  | 
 1.0807  | 
 1721  | 
 66  | 
|  WARM_TIME  | 
 5  | 
 3206.58  | 
 0.9351  | 
 1.0665  | 
 1503  | 
 63  | 
|  WARM_TIME  | 
 6  | 
 3066.15  | 
 0.9295  | 
 1.0719  | 
 1656  | 
 72  | 
|  WARM_TIME  | 
 7  | 
 3028.01  | 
 0.9304  | 
 1.0794  | 
 1610  | 
 80  | 
|  WARM_TIME  | 
 8  | 
 3084.55  | 
 0.9272  | 
 1.0668  | 
 1641  | 
 84  | 
|  WARM_TIME  | 
 9  | 
 3155.25  | 
 0.9270  | 
 1.0738  | 
 1869  | 
 91  | 
|  WARM_TIME  | 
 10  | 
 3237.07  | 
 0.9420  | 
 1.0597  | 
 1728  | 
 93  | 
|  TEST_TIME  | 
 11  | 
 3302.54  | 
 0.9443  | 
 1.0554  | 
 1797  | 
 96  | 
|  TEST_TIME  | 
 12  | 
 3339.36  | 
 0.9568  | 
 1.0527  | 
 1496  | 
 99  | 
|  TEST_TIME  | 
 13  | 
 3399.81  | 
 0.9545  | 
 1.0474  | 
 1615  | 
 98  | 
|  TEST_TIME  | 
 14  | 
 3465.98  | 
 0.9541  | 
 1.0424  | 
 1608  | 
 98  | 
|  TEST_TIME  | 
 15  | 
 3530.24  | 
 0.9552  | 
 1.0397  | 
 2007  | 
 97  | 
|  TEST_TIME  | 
 16  | 
 3611.95  | 
 0.9527  | 
 1.0430  | 
 1984  | 
 99  | 
|  TEST_TIME  | 
 17  | 
 3673.51  | 
 0.9653  | 
 1.0331  | 
 1656  | 
 96  | 
|  TEST_TIME  | 
 18  | 
 3685.75  | 
 0.9725  | 
 1.0279  | 
 1518  | 
 92  | 
|  TEST_TIME  | 
 19  | 
 3695.48  | 
 0.9713  | 
 1.0331  | 
 1635  | 
 90  | 
|  TEST_TIME  | 
 20  | 
 3729.95  | 
 0.9723  | 
 1.0335  | 
 1768  | 
 95  | 
|  TEST_TIME  | 
 21  | 
 3803.54  | 
 0.9653  | 
 1.0384  | 
 1911  | 
 98  | 
|  TEST_TIME  | 
 22  | 
 3879.19  | 
 0.9718  | 
 1.0279  | 
 1853  | 
 97  | 
|  TEST_TIME  | 
 23  | 
 3928.66  | 
 0.9709  | 
 1.0253  | 
 1667  | 
 98  | 
|  TEST_TIME  | 
 24  | 
 3969.72  | 
 0.9725  | 
 1.0269  | 
 1789  | 
 98  | 
|  TEST_TIME  | 
 25  | 
 4006.71  | 
 0.9767  | 
 1.0226  | 
 1598  | 
 95  | 
|  TEST_TIME  | 
 26  | 
 4012.12  | 
 0.9819  | 
 1.0204  | 
 1454  | 
 94  | 
|  TEST_TIME  | 
 27  | 
 4015.87  | 
 0.9817  | 
 1.0199  | 
 1188  | 
 94  | 
|  TEST_TIME  | 
 28  | 
 4034.69  | 
 0.9789  | 
 1.0209  | 
 1446  | 
 93  | 
|  TEST_TIME  | 
 29  | 
 4106.03  | 
 0.9686  | 
 1.0286  | 
 1758  | 
 96  | 
|  TEST_TIME  | 
 30  | 
 4184.28  | 
 0.9757  | 
 1.0240  | 
 1743  | 
 96  | 
|  TEST_TIME  | 
 31  | 
 4234.48  | 
 0.9792  | 
 1.0207  | 
 1796  | 
 96  | 
|  TEST_TIME  | 
 32  | 
 4243.19  | 
 0.9868  | 
 1.0158  | 
 1384  | 
 97  | 
|  TEST_TIME  | 
 33  | 
 4264.96  | 
 0.9800  | 
 1.0210  | 
 1578  | 
 97  | 
|  TEST_TIME  | 
 34  | 
 4302.69  | 
 0.9823  | 
 1.0182  | 
 1669  | 
 96  | 
|  TEST_TIME  | 
 35  | 
 4325.87  | 
 0.9838  | 
 1.0144  | 
 1477  | 
 97  | 
|  TEST_TIME  | 
 36  | 
 4344.21  | 
 0.9821  | 
 1.0196  | 
 1661  | 
 92  | 
|  TEST_TIME  | 
 37  | 
 4371.52  | 
 0.9859  | 
 1.0156  | 
 1561  | 
 95  | 
|  TEST_TIME  | 
 38  | 
 4397.00  | 
 0.9831  | 
 1.0161  | 
 1510  | 
 98  | 
|  TEST_TIME  | 
 39  | 
 4401.92  | 
 0.9890  | 
 1.0110  | 
 1390  | 
 96  | 
|  TEST_TIME  | 
 40  | 
 4408.13  | 
 0.9846  | 
 1.0148  | 
 1516  | 
 93  | 
|  TEST_TIME  | 
 41  | 
 4428.55  | 
 0.9855  | 
 1.0138  | 
 1307  | 
 96  | 
|  TEST_TIME  | 
 42  | 
 4439.89  | 
 0.9871  | 
 1.0136  | 
 1250  | 
 94  | 
|  TEST_TIME  | 
 43  | 
 4452.36  | 
 0.9873  | 
 1.0135  | 
 1341  | 
 97  | 
|  TEST_TIME  | 
 44  | 
 4493.30  | 
 0.9815  | 
 1.0190  | 
 1711  | 
 99  | 
|  TEST_TIME  | 
 45  | 
 4543.31  | 
 0.9854  | 
 1.0130  | 
 1639  | 
 96  | 
|  TEST_TIME  | 
 46  | 
 4570.21  | 
 0.9851  | 
 1.0104  | 
 1662  | 
 96  | 
|  TEST_TIME  | 
 47  | 
 4564.38  | 
 0.9901  | 
 1.0139  | 
 1475  | 
 91  | 
|  TEST_TIME  | 
 48  | 
 4600.82  | 
 0.9849  | 
 1.0160  | 
 1633  | 
 97  | 
|  TEST_TIME  | 
 49  | 
 4639.77  | 
 0.9869  | 
 1.0146  | 
 1641  | 
 97  | 
|  TEST_TIME  | 
 50  | 
 4675.96  | 
 0.9866  | 
 1.0153  | 
 1508  | 
 97  | 
|  TEST_TIME  | 
 51  | 
 4713.46  | 
 0.9875  | 
 1.0142  | 
 1559  | 
 97  | 
|  TEST_TIME  | 
 52  | 
 4746.44  | 
 0.9878  | 
 1.0106  | 
 1387  | 
 98  | 
|  TEST_TIME  | 
 53  | 
 4754.66  | 
 0.9898  | 
 1.0107  | 
 1574  | 
 97  | 
|  TEST_TIME  | 
 54  | 
 4766.20  | 
 0.9896  | 
 1.0090  | 
 1539  | 
 94  | 
|  TEST_TIME  | 
 55  | 
 4769.60  | 
 0.9903  | 
 1.0105  | 
 1358  | 
 96  | 
|  TEST_TIME  | 
 56  | 
 4772.01  | 
 0.9920  | 
 1.0073  | 
 1217  | 
 91  | 
|  TEST_TIME  | 
 57  | 
 4761.55  | 
 0.9918  | 
 1.0116  | 
 1224  | 
 93  | 
|  TEST_TIME  | 
 58  | 
 4767.24  | 
 0.9930  | 
 1.0057  | 
 1187  | 
 91  | 
|  TEST_TIME  | 
 59  | 
 4768.69  | 
 0.9883  | 
 1.0141  | 
 1514  | 
 96  | 
|  TEST_TIME  | 
 60  | 
 4814.04  | 
 0.9878  | 
 1.0093  | 
 1607  | 
 96  | 
|  TEST_TIME  | 
 61  | 
 4831.50  | 
 0.9892  | 
 1.0110  | 
 1664  | 
 93  | 
|  TEST_TIME  | 
 62  | 
 4848.32  | 
 0.9915  | 
 1.0094  | 
 1489  | 
 94  | 
|  TEST_TIME  | 
 63  | 
 4855.83  | 
 0.9919  | 
 1.0084  | 
 1448  | 
 95  | 
|  TEST_TIME  | 
 64  | 
 4862.01  | 
 0.9914  | 
 1.0086  | 
 1603  | 
 95  | 
|  TEST_TIME  | 
 65  | 
 4865.10  | 
 0.9924  | 
 1.0091  | 
 1425  | 
 93  | 
|  TEST_TIME  | 
 66  | 
 4867.89  | 
 0.9932  | 
 1.0066  | 
 1301  | 
 92  | 
|  TEST_TIME  | 
 67  | 
 4856.40  | 
 0.9940  | 
 1.0095  | 
 906  | 
 83  | 
|  TEST_TIME  | 
 68  | 
 4869.49  | 
 0.9920  | 
 1.0062  | 
 1215  | 
 88  | 
|  TEST_TIME  | 
 69  | 
 4865.65  | 
 0.9924  | 
 1.0077  | 
 1170  | 
 89  | 
|  TEST_TIME  | 
 70  | 
 4870.20  | 
 0.9924  | 
 1.0100  | 
 1381  | 
 93  | 
|  TEST_TIME  | 
 71  | 
 4882.82  | 
 0.9932  | 
 1.0062  | 
 1368  | 
 93  | 
|  TEST_TIME  | 
 72  | 
 4884.62  | 
 0.9918  | 
 1.0093  | 
 1309  | 
 94  | 
|  TEST_TIME  | 
 73  | 
 4889.72  | 
 0.9944  | 
 1.0051  | 
 1210  | 
 90  | 
|  TEST_TIME  | 
 74  | 
 4899.12  | 
 0.9896  | 
 1.0096  | 
 1669  | 
 95  | 
|  TEST_TIME  | 
 75  | 
 4916.95  | 
 0.9925  | 
 1.0066  | 
 1543  | 
 97  | 
|  TEST_TIME  | 
 76  | 
 4925.08  | 
 0.9917  | 
 1.0085  | 
 1588  | 
 95  | 
|  TEST_TIME  | 
 77  | 
 4945.71  | 
 0.9913  | 
 1.0103  | 
 1555  | 
 95  | 
|  TEST_TIME  | 
 78  | 
 4968.82  | 
 0.9928  | 
 1.0074  | 
 1595  | 
 95  | 
|  TEST_TIME  | 
 79  | 
 4985.57  | 
 0.9913  | 
 1.0076  | 
 1571  | 
 93  | 
|  TEST_TIME  | 
 80  | 
 5007.49  | 
 0.9906  | 
 1.0075  | 
 1545  | 
 95  | 
|  TEST_TIME  | 
 81  | 
 5016.80  | 
 0.9932  | 
 1.0066  | 
 1506  | 
 95  | 
|  TEST_TIME  | 
 82  | 
 5017.67  | 
 0.9941  | 
 1.0054  | 
 1490  | 
 94  | 
|  TEST_TIME  | 
 83  | 
 5016.02  | 
 0.9936  | 
 1.0060  | 
 1475  | 
 93  | 
|  TEST_TIME  | 
 84  | 
 5020.30  | 
 0.9932  | 
 1.0055  | 
 1366  | 
 93  | 
|  TEST_TIME  | 
 85  | 
 5019.52  | 
 0.9938  | 
 1.0059  | 
 1349  | 
 91  | 
|  TEST_TIME  | 
 86  | 
 5021.05  | 
 0.9939  | 
 1.0075  | 
 1243  | 
 95  | 
|  TEST_TIME  | 
 87  | 
 5033.48  | 
 0.9934  | 
 1.0058  | 
 1230  | 
 95  | 
|  TEST_TIME  | 
 88  | 
 5033.88  | 
 0.9943  | 
 1.0052  | 
 1204  | 
 94  | 
|  TEST_TIME  | 
 89  | 
 5038.98  | 
 0.9929  | 
 1.0052  | 
 1367  | 
 93  | 
|  TEST_TIME  | 
 90  | 
 5037.05  | 
 0.9944  | 
 1.0071  | 
 1333  | 
 91  | 
|  TEST_TIME  | 
 91  | 
 5049.00  | 
 0.9937  | 
 1.0066  | 
 1604  | 
 93  | 
|  TEST_TIME  | 
 92  | 
 5061.07  | 
 0.9933  | 
 1.0061  | 
 1514  | 
 96  | 
|  TEST_TIME  | 
 93  | 
 5069.72  | 
 0.9936  | 
 1.0069  | 
 1418  | 
 94  | 
|  TEST_TIME  | 
 94  | 
 5075.11  | 
 0.9952  | 
 1.0063  | 
 1330  | 
 94  | 
|  TEST_TIME  | 
 95  | 
 5083.36  | 
 0.9941  | 
 1.0054  | 
 1415  | 
 93  | 
|  TEST_TIME  | 
 96  | 
 5088.19  | 
 0.9940  | 
 1.0053  | 
 1471  | 
 93  | 
|  TEST_TIME  | 
 97  | 
 5088.98  | 
 0.9947  | 
 1.0057  | 
 1314  | 
 94  | 
|  TEST_TIME  | 
 98  | 
 5097.73  | 
 0.9937  | 
 1.0064  | 
 1227  | 
 95  | 
|  TEST_TIME  | 
 99  | 
 5101.21  | 
 0.9955  | 
 1.0041  | 
 1130  | 
 92  | 
|  TEST_TIME  | 
 100  | 
 5096.19  | 
 0.9950  | 
 1.0035  | 
 1077  | 
 94  | 
|  TEST_TIME  | 
 101  | 
 5081.43  | 
 0.9965  | 
 1.0033  | 
 1179  | 
 89  | 
|  TEST_TIME  | 
 102  | 
 5075.13  | 
 0.9947  | 
 1.0041  | 
 1173  | 
 88  | 
|  TEST_TIME  | 
 103  | 
 5076.53  | 
 0.9941  | 
 1.0059  | 
 1154  | 
 92  | 
|  TEST_TIME  | 
 104  | 
 5084.04  | 
 0.9948  | 
 1.0041  | 
 1380  | 
 94  | 
|  TEST_TIME  | 
 105  | 
 5080.26  | 
 0.9952  | 
 1.0049  | 
 1345  | 
 89  | 
|  TEST_TIME  | 
 106  | 
 5082.40  | 
 0.9950  | 
 1.0058  | 
 1309  | 
 90  | 
|  TEST_TIME  | 
 107  | 
 5090.20  | 
 0.9949  | 
 1.0042  | 
 1230  | 
 90  | 
|  TEST_TIME  | 
 108  | 
 5090.55  | 
 0.9948  | 
 1.0052  | 
 1323  | 
 90  | 
|  TEST_TIME  | 
 109  | 
 5094.96  | 
 0.9951  | 
 1.0043  | 
 1279  | 
 93  | 
|  TEST_TIME  | 
 110  | 
 5092.99  | 
 0.9955  | 
 1.0043  | 
 1266  | 
 94  | 
|  TEST_TIME  | 
 111  | 
 5090.99  | 
 0.9957  | 
 1.0051  | 
 1194  | 
 93  | 
|  TEST_TIME  | 
 112  | 
 5092.80  | 
 0.9957  | 
 1.0040  | 
 1293  | 
 88  | 
|  TEST_TIME  | 
 113  | 
 5091.08  | 
 0.9955  | 
 1.0048  | 
 1391  | 
 90  | 
|  TEST_TIME  | 
 114  | 
 5099.67  | 
 0.9943  | 
 1.0047  | 
 1156  | 
 91  | 
|  TEST_TIME  | 
 115  | 
 5102.25  | 
 0.9954  | 
 1.0037  | 
 1191  | 
 93  | 
|  TEST_TIME  | 
 116  | 
 5095.81  | 
 0.9963  | 
 1.0038  | 
 1136  | 
 91  | 
|  TEST_TIME  | 
 117  | 
 5093.59  | 
 0.9957  | 
 1.0043  | 
 1118  | 
 88  | 
|  TEST_TIME  | 
 118  | 
 5100.91  | 
 0.9943  | 
 1.0049  | 
 1241  | 
 92  | 
|  TEST_TIME  | 
 119  | 
 5104.16  | 
 0.9958  | 
 1.0047  | 
 1399  | 
 94  | 
|  TEST_TIME  | 
 120  | 
 5115.85  | 
 0.9941  | 
 1.0059  | 
 1567  | 
 96  | 
|  TEST_TIME  | 
 121  | 
 5129.87  | 
 0.9948  | 
 1.0048  | 
 1477  | 
 93  | 
|  TEST_TIME  | 
 122  | 
 5140.34  | 
 0.9945  | 
 1.0050  | 
 1313  | 
 96  | 
|  TEST_TIME  | 
 123  | 
 5145.08  | 
 0.9959  | 
 1.0037  | 
 1344  | 
 94  | 
|  TEST_TIME  | 
 124  | 
 5145.88  | 
 0.9955  | 
 1.0044  | 
 1468  | 
 95  | 
|  TEST_TIME  | 
 125  | 
 5156.77  | 
 0.9942  | 
 1.0045  | 
 1272  | 
 95  | 
|  TEST_TIME  | 
 126  | 
 5156.96  | 
 0.9965  | 
 1.0046  | 
 1347  | 
 95  | 
|  TEST_TIME  | 
 127  | 
 5158.01  | 
 0.9965  | 
 1.0044  | 
 1270  | 
 93  | 
|  TEST_TIME  | 
 128  | 
 5159.31  | 
 0.9964  | 
 1.0038  | 
 1290  | 
 93  | 
|  TEST_TIME  | 
 129  | 
 5157.64  | 
 0.9964  | 
 1.0039  | 
 1189  | 
 94  | 
|  TEST_TIME  | 
 130  | 
 5153.90  | 
 0.9969  | 
 1.0034  | 
 1167  | 
 84  | 
|  TEST_TIME  | 
 131  | 
 5158.09  | 
 0.9949  | 
 1.0038  | 
 1028  | 
 88  | 
|  TEST_TIME  | 
 132  | 
 5159.27  | 
 0.9960  | 
 1.0030  | 
 1185  | 
 88  | 
|  TEST_TIME  | 
 133  | 
 5153.87  | 
 0.9965  | 
 1.0034  | 
 1101  | 
 87  | 
|  TEST_TIME  | 
 134  | 
 5165.05  | 
 0.9938  | 
 1.0049  | 
 1265  | 
 94  | 
|  TEST_TIME  | 
 135  | 
 5174.91  | 
 0.9956  | 
 1.0053  | 
 1375  | 
 95  | 
|  TEST_TIME  | 
 136  | 
 5194.64  | 
 0.9941  | 
 1.0049  | 
 1456  | 
 94  | 
|  TEST_TIME  | 
 137  | 
 5202.38  | 
 0.9961  | 
 1.0045  | 
 1350  | 
 94  | 
|  TEST_TIME  | 
 138  | 
 5213.73  | 
 0.9951  | 
 1.0040  | 
 1337  | 
 95  | 
|  TEST_TIME  | 
 139  | 
 5218.14  | 
 0.9959  | 
 1.0035  | 
 1244  | 
 90  | 
|  TEST_TIME  | 
 140  | 
 5219.95  | 
 0.9960  | 
 1.0032  | 
 1380  | 
 92  | 
|  TEST_TIME  | 
 141  | 
 5216.01  | 
 0.9968  | 
 1.0029  | 
 1140  | 
 87  | 
|  TEST_TIME  | 
 142  | 
 5210.52  | 
 0.9969  | 
 1.0039  | 
 1116  | 
 86  | 
|  TEST_TIME  | 
 143  | 
 5214.28  | 
 0.9962  | 
 1.0049  | 
 1194  | 
 92  | 
|  TEST_TIME  | 
 144  | 
 5226.86  | 
 0.9956  | 
 1.0037  | 
 1213  | 
 92  | 
|  TEST_TIME  | 
 145  | 
 5227.65  | 
 0.9966  | 
 1.0048  | 
 1258  | 
 95  | 
|  TEST_TIME  | 
 146  | 
 5230.04  | 
 0.9974  | 
 1.0033  | 
 1090  | 
 91  | 
|  TEST_TIME  | 
 147  | 
 5229.24  | 
 0.9966  | 
 1.0031  | 
 1090  | 
 90  | 
|  TEST_TIME  | 
 148  | 
 5225.59  | 
 0.9970  | 
 1.0029  | 
 1085  | 
 86  | 
|  TEST_TIME  | 
 149  | 
 5231.56  | 
 0.9952  | 
 1.0037  | 
 1310  | 
 87  | 
|  TEST_TIME  | 
 150  | 
 5234.58  | 
 0.9964  | 
 1.0037  | 
 1296  | 
 87  | 
|  TEST_TIME  | 
 151  | 
 5239.94  | 
 0.9960  | 
 1.0039  | 
 1332  | 
 91  | 
|  TEST_TIME  | 
 152  | 
 5247.01  | 
 0.9960  | 
 1.0034  | 
 1354  | 
 92  | 
|  TEST_TIME  | 
 153  | 
 5248.39  | 
 0.9966  | 
 1.0039  | 
 1224  | 
 97  | 
|  TEST_TIME  | 
 154  | 
 5249.66  | 
 0.9971  | 
 1.0026  | 
 1250  | 
 92  | 
|  TEST_TIME  | 
 155  | 
 5252.39  | 
 0.9956  | 
 1.0041  | 
 1285  | 
 94  | 
|  TEST_TIME  | 
 156  | 
 5254.21  | 
 0.9973  | 
 1.0027  | 
 1265  | 
 89  | 
|  TEST_TIME  | 
 157  | 
 5245.23  | 
 0.9980  | 
 1.0025  | 
 1080  | 
 86  | 
|  TEST_TIME  | 
 158  | 
 5242.27  | 
 0.9967  | 
 1.0027  | 
 1085  | 
 88  | 
|  TEST_TIME  | 
 159  | 
 5243.07  | 
 0.9962  | 
 1.0030  | 
 1112  | 
 92  | 
|  TEST_TIME  | 
 160  | 
 5234.15  | 
 0.9985  | 
 1.0016  | 
 981  | 
 78  | 
|  TEST_TIME  | 
 161  | 
 5226.91  | 
 0.9968  | 
 1.0031  | 
 1000  | 
 85  | 
|  TEST_TIME  | 
 162  | 
 5226.51  | 
 0.9970  | 
 1.0034  | 
 1109  | 
 88  | 
|  TEST_TIME  | 
 163  | 
 5229.39  | 
 0.9967  | 
 1.0029  | 
 1044  | 
 93  | 
|  TEST_TIME  | 
 164  | 
 5230.65  | 
 0.9965  | 
 1.0038  | 
 1391  | 
 94  | 
|  TEST_TIME  | 
 165  | 
 5239.85  | 
 0.9959  | 
 1.0045  | 
 1444  | 
 94  | 
|  TEST_TIME  | 
 166  | 
 5245.64  | 
 0.9973  | 
 1.0029  | 
 1330  | 
 90  | 
|  TEST_TIME  | 
 167  | 
 5246.22  | 
 0.9968  | 
 1.0033  | 
 1340  | 
 94  | 
|  TEST_TIME  | 
 168  | 
 5248.62  | 
 0.9969  | 
 1.0027  | 
 1280  | 
 93  | 
|  TEST_TIME  | 
 169  | 
 5247.15  | 
 0.9970  | 
 1.0022  | 
 1305  | 
 88  | 
|  TEST_TIME  | 
 170  | 
 5241.49  | 
 0.9973  | 
 1.0025  | 
 1302  | 
 87  | 
|  TEST_TIME  | 
 171  | 
 5240.76  | 
 0.9968  | 
 1.0028  | 
 1196  | 
 88  | 
|  TEST_TIME  | 
 172  | 
 5241.87  | 
 0.9968  | 
 1.0035  | 
 1181  | 
 90  | 
|  TEST_TIME  | 
 173  | 
 5245.24  | 
 0.9971  | 
 1.0030  | 
 1236  | 
 92  | 
|  TEST_TIME  | 
 174  | 
 5247.20  | 
 0.9969  | 
 1.0048  | 
 1180  | 
 95  | 
|  TEST_TIME  | 
 175  | 
 5252.11  | 
 0.9981  | 
 1.0022  | 
 1106  | 
 95  | 
|  TEST_TIME  | 
 176  | 
 5248.45  | 
 0.9972  | 
 1.0024  | 
 1126  | 
 87  | 
|  TEST_TIME  | 
 177  | 
 5244.69  | 
 0.9974  | 
 1.0026  | 
 1113  | 
 87  | 
|  TEST_TIME  | 
 178  | 
 5242.21  | 
 0.9974  | 
 1.0027  | 
 1117  | 
 88  | 
|  TEST_TIME  | 
 179  | 
 5244.11  | 
 0.9968  | 
 1.0027  | 
 1344  | 
 90  | 
|  TEST_TIME  | 
 180  | 
 5240.02  | 
 0.9979  | 
 1.0022  | 
 1284  | 
 91  | 
|  TEST_TIME  | 
 181  | 
 5236.00  | 
 0.9975  | 
 1.0025  | 
 1228  | 
 90  | 
|  TEST_TIME  | 
 182  | 
 5239.67  | 
 0.9963  | 
 1.0045  | 
 1269  | 
 91  | 
|  TEST_TIME  | 
 183  | 
 5250.21  | 
 0.9970  | 
 1.0029  | 
 1218  | 
 93  | 
|  TEST_TIME  | 
 184  | 
 5248.44  | 
 0.9978  | 
 1.0039  | 
 1059  | 
 88  | 
|  TEST_TIME  | 
 185  | 
 5253.41  | 
 0.9975  | 
 1.0020  | 
 1226  | 
 90  | 
|  TEST_TIME  | 
 186  | 
 5246.04  | 
 0.9980  | 
 1.0024  | 
 1136  | 
 93  | 
|  TEST_TIME  | 
 187  | 
 5242.58  | 
 0.9977  | 
 1.0018  | 
 1188  | 
 90  | 
|  TEST_TIME  | 
 188  | 
 5236.34  | 
 0.9976  | 
 1.0023  | 
 1156  | 
 91  | 
|  TEST_TIME  | 
 189  | 
 5236.99  | 
 0.9969  | 
 1.0031  | 
 1179  | 
 88  | 
|  TEST_TIME  | 
 190  | 
 5232.60  | 
 0.9988  | 
 1.0022  | 
 529  | 
 100  | 
 
Done for 12880 ms, from  8:09:44.62 to  8:09:57.50.  
 
 
|  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  | 
 2048  | 
 7167  | 
 4956  | 
 <null>  | 
 4433  | 
 4563  | 
 5567  | 
 4990  | 
 7237  | 
 4260  | 
 3548  | 
 3871  | 
 12474  | 
 3345  | 
 12625  | 
 2760  | 
 293131  | 
 216801  | 
 <null>  | 
 04:56:16  | 
 05:14:16  | 
|  fetches per second  | 
 2  | 
 1997  | 
 7965  | 
 3948  | 
 <null>  | 
 4233  | 
 7265  | 
 6948  | 
 4894  | 
 7539  | 
 <null>  | 
 4845  | 
 3607  | 
 16215  | 
 3881  | 
 17512  | 
 3410  | 
 338498  | 
 220953  | 
 <null>  | 
 05:14:17  | 
 05:32:17  | 
|  fetches per second  | 
 3  | 
 2018  | 
 7632  | 
 4653  | 
 3908  | 
 4350  | 
 <null>  | 
 6198  | 
 4491  | 
 6225  | 
 <null>  | 
 3252  | 
 3418  | 
 19919  | 
 4963  | 
 23646  | 
 4084  | 
 350920  | 
 233541  | 
 <null>  | 
 05:32:18  | 
 05:50:18  | 
|  fetches per second  | 
 4  | 
 2051  | 
 6253  | 
 4459  | 
 4155  | 
 4592  | 
 <null>  | 
 5988  | 
 4612  | 
 5074  | 
 3761  | 
 5130  | 
 5095  | 
 22111  | 
 4371  | 
 27139  | 
 4790  | 
 283163  | 
 219593  | 
 <null>  | 
 05:50:19  | 
 06:08:19  | 
|  fetches per second  | 
 5  | 
 1795  | 
 6047  | 
 5827  | 
 <null>  | 
 6371  | 
 3830  | 
 7516  | 
 4678  | 
 4703  | 
 4426  | 
 4026  | 
 3966  | 
 19881  | 
 4295  | 
 31399  | 
 3890  | 
 472710  | 
 <null>  | 
 <null>  | 
 06:08:20  | 
 06:26:20  | 
|  fetches per second  | 
 6  | 
 1693  | 
 6028  | 
 5778  | 
 <null>  | 
 6814  | 
 2934  | 
 6620  | 
 3688  | 
 8600  | 
 3901  | 
 3818  | 
 3462  | 
 33720  | 
 2769  | 
 24518  | 
 2542  | 
 503219  | 
 265072  | 
 <null>  | 
 06:26:21  | 
 06:44:21  | 
|  fetches per second  | 
 7  | 
 2032  | 
 6437  | 
 4959  | 
 3215  | 
 5161  | 
 <null>  | 
 5989  | 
 <null>  | 
 8994  | 
 4942  | 
 4928  | 
 <null>  | 
 18391  | 
 4069  | 
 24033  | 
 6377  | 
 <null>  | 
 216233  | 
 <null>  | 
 06:44:22  | 
 07:02:22  | 
|  fetches per second  | 
 8  | 
 1813  | 
 6233  | 
 6081  | 
 <null>  | 
 6146  | 
 2855  | 
 6468  | 
 4415  | 
 11181  | 
 4124  | 
 4663  | 
 3340  | 
 28808  | 
 <null>  | 
 25485  | 
 3563  | 
 350629  | 
 257009  | 
 <null>  | 
 07:02:23  | 
 07:20:23  | 
|  fetches per second  | 
 9  | 
 1771  | 
 6282  | 
 5939  | 
 <null>  | 
 7353  | 
 3060  | 
 7424  | 
 <null>  | 
 5309  | 
 4565  | 
 4652  | 
 3527  | 
 28814  | 
 3952  | 
 18306  | 
 <null>  | 
 418463  | 
 232339  | 
 <null>  | 
 07:20:24  | 
 07:38:24  | 
|  fetches per second  | 
 10  | 
 1725  | 
 5993  | 
 6459  | 
 <null>  | 
 6540  | 
 2870  | 
 6967  | 
 3322  | 
 6913  | 
 4410  | 
 4236  | 
 2630  | 
 32763  | 
 3312  | 
 15116  | 
 <null>  | 
 425641  | 
 287698  | 
 <null>  | 
 07:38:25  | 
 07:56:25  | 
|  marks per second  | 
 1  | 
 361  | 
 661  | 
 300  | 
 <null>  | 
 290  | 
 721  | 
 444  | 
 640  | 
 427  | 
 572  | 
 465  | 
 430  | 
 551  | 
 389  | 
 479  | 
 380  | 
 1279  | 
 768  | 
 <null>  | 
 04:56:16  | 
 05:14:16  | 
|  marks per second  | 
 2  | 
 347  | 
 742  | 
 292  | 
 <null>  | 
 311  | 
 700  | 
 441  | 
 530  | 
 460  | 
 <null>  | 
 492  | 
 416  | 
 533  | 
 480  | 
 640  | 
 401  | 
 1297  | 
 719  | 
 <null>  | 
 05:14:17  | 
 05:32:17  | 
|  marks per second  | 
 3  | 
 350  | 
 719  | 
 323  | 
 559  | 
 310  | 
 <null>  | 
 454  | 
 537  | 
 389  | 
 <null>  | 
 492  | 
 379  | 
 467  | 
 521  | 
 580  | 
 454  | 
 1869  | 
 771  | 
 <null>  | 
 05:32:18  | 
 05:50:18  | 
|  marks per second  | 
 4  | 
 338  | 
 630  | 
 297  | 
 542  | 
 321  | 
 <null>  | 
 451  | 
 519  | 
 296  | 
 504  | 
 466  | 
 457  | 
 528  | 
 435  | 
 593  | 
 537  | 
 1346  | 
 1025  | 
 <null>  | 
 05:50:19  | 
 06:08:19  | 
|  marks per second  | 
 5  | 
 317  | 
 605  | 
 252  | 
 <null>  | 
 282  | 
 486  | 
 404  | 
 498  | 
 356  | 
 480  | 
 439  | 
 397  | 
 486  | 
 428  | 
 526  | 
 397  | 
 1341  | 
 <null>  | 
 <null>  | 
 06:08:20  | 
 06:26:20  | 
|  marks per second  | 
 6  | 
 297  | 
 548  | 
 259  | 
 <null>  | 
 269  | 
 479  | 
 382  | 
 419  | 
 415  | 
 390  | 
 384  | 
 360  | 
 454  | 
 336  | 
 461  | 
 342  | 
 700  | 
 315  | 
 <null>  | 
 06:26:21  | 
 06:44:21  | 
|  marks per second  | 
 7  | 
 343  | 
 607  | 
 289  | 
 532  | 
 356  | 
 <null>  | 
 432  | 
 <null>  | 
 494  | 
 566  | 
 497  | 
 <null>  | 
 403  | 
 459  | 
 707  | 
 651  | 
 <null>  | 
 560  | 
 <null>  | 
 06:44:22  | 
 07:02:22  | 
|  marks per second  | 
 8  | 
 307  | 
 580  | 
 270  | 
 <null>  | 
 286  | 
 475  | 
 395  | 
 505  | 
 360  | 
 479  | 
 423  | 
 378  | 
 494  | 
 <null>  | 
 485  | 
 388  | 
 1364  | 
 477  | 
 <null>  | 
 07:02:23  | 
 07:20:23  | 
|  marks per second  | 
 9  | 
 299  | 
 638  | 
 282  | 
 <null>  | 
 301  | 
 468  | 
 403  | 
 <null>  | 
 301  | 
 467  | 
 387  | 
 422  | 
 426  | 
 474  | 
 418  | 
 <null>  | 
 1156  | 
 481  | 
 <null>  | 
 07:20:24  | 
 07:38:24  | 
|  marks per second  | 
 10  | 
 292  | 
 602  | 
 231  | 
 <null>  | 
 251  | 
 487  | 
 399  | 
 389  | 
 356  | 
 466  | 
 381  | 
 301  | 
 406  | 
 336  | 
 401  | 
 <null>  | 
 869  | 
 290  | 
 <null>  | 
 07:38:25  | 
 07:56:25  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:56:16  | 
 05:14:16  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:14:17  | 
 05:32:17  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:32:18  | 
 05:50:18  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:50:19  | 
 06:08:19  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 06:08:20  | 
 06:26:20  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 06:26:21  | 
 06:44:21  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:44:22  | 
 07:02:22  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 07:02:23  | 
 07:20:23  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 07:20:24  | 
 07:38:24  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 07:38:25  | 
 07:56:25  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 04:56:16  | 
 05:14:16  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 5  | 
 1  | 
 <null>  | 
 05:14:17  | 
 05:32:17  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 3  | 
 0  | 
 <null>  | 
 05:32:18  | 
 05:50:18  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 4  | 
 0  | 
 <null>  | 
 05:50:19  | 
 06:08:19  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 6  | 
 <null>  | 
 <null>  | 
 06:08:20  | 
 06:26:20  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 06:26:21  | 
 06:44:21  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:44:22  | 
 07:02:22  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 1  | 
 0  | 
 0  | 
 2  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 6  | 
 0  | 
 <null>  | 
 07:02:23  | 
 07:20:23  | 
|  writes/marks*100  | 
 9  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 5  | 
 0  | 
 <null>  | 
 07:20:24  | 
 07:38:24  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 4  | 
 0  | 
 <null>  | 
 07:38:25  | 
 07:56:25  | 
 
Done for 10800 ms, from  8:09:58.87 to  8:10:09.67.  
 
 
|  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  | 
 1627169  | 
 1580274  | 
 46895  | 
 2.88  | 
 0  | 
 11872  | 
 25  | 
 46895  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  doc_list_biud  | 
 1627533  | 
 1580269  | 
 47264  | 
 2.90  | 
 0  | 
 8174  | 
 35  | 
 47264  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_add_invoice_to_stock  | 
 17642  | 
 11744  | 
 5898  | 
 33.43  | 
 297  | 
 169774  | 
 20959  | 
 5898  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_cancel_adding_invoice  | 
 3651  | 
 2998  | 
 653  | 
 17.88  | 
 78  | 
 145275  | 
 4719  | 
 653  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_cancel_client_order  | 
 6295  | 
 6042  | 
 253  | 
 4.01  | 
 15  | 
 265  | 
 72  | 
 253  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_cancel_customer_reserve  | 
 194548  | 
 151907  | 
 42641  | 
 21.91  | 
 0  | 
 2434  | 
 119  | 
 42641  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_cancel_pay_from_customer  | 
 2402  | 
 2376  | 
 26  | 
 1.08  | 
 15  | 
 1139  | 
 86  | 
 26  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_cancel_pay_to_supplier  | 
 1507  | 
 1474  | 
 33  | 
 2.18  | 
 15  | 
 795  | 
 148  | 
 33  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_cancel_supplier_invoice  | 
 7375  | 
 6253  | 
 1122  | 
 15.21  | 
 15  | 
 8565  | 
 2380  | 
 1122  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_cancel_supplier_order  | 
 1369  | 
 420  | 
 949  | 
 69.32  | 
 47  | 
 425202  | 
 72544  | 
 949  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_cancel_write_off  | 
 13334  | 
 10054  | 
 3280  | 
 24.59  | 
 0  | 
 3006  | 
 224  | 
 3280  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_client_order  | 
 73707  | 
 73707  | 
 0  | 
 0.00  | 
 46  | 
 4103  | 
 1029  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_customer_reserve  | 
 571883  | 
 571883  | 
 0  | 
 0.00  | 
 0  | 
 15415  | 
 365  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_fill_shopping_cart  | 
 111683  | 
 111683  | 
 0  | 
 0.00  | 
 0  | 
 17119  | 
 232  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_fill_shopping_cart_clo_res  | 
 571883  | 
 571883  | 
 0  | 
 0.00  | 
 0  | 
 234  | 
 1  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_get_clo_for_invoice  | 
 11744  | 
 11744  | 
 0  | 
 0.00  | 
 0  | 
 6708  | 
 1032  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_kill_cost_storno  | 
 20562  | 
 16902  | 
 3660  | 
 17.79  | 
 0  | 
 3729  | 
 76  | 
 3660  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 409559  | 
 320543  | 
 89016  | 
 21.73  | 
 0  | 
 8159  | 
 98  | 
 89016  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_kill_qty_storno  | 
 270563  | 
 223401  | 
 47162  | 
 17.43  | 
 0  | 
 8159  | 
 243  | 
 47162  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_lock_selected_doc  | 
 72732  | 
 63872  | 
 8860  | 
 12.18  | 
 0  | 
 109  | 
 2  | 
 8860  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_make_cost_storno  | 
 90905  | 
 90905  | 
 0  | 
 0.00  | 
 0  | 
 11684  | 
 242  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_multiply_rows_for_pdistr  | 
 90903  | 
 90903  | 
 0  | 
 0.00  | 
 0  | 
 655  | 
 148  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_multiply_rows_for_qdistr  | 
 73709  | 
 73709  | 
 0  | 
 0.00  | 
 0  | 
 3557  | 
 765  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_pay_from_customer  | 
 24789  | 
 24789  | 
 0  | 
 0.00  | 
 62  | 
 3307  | 
 319  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_pay_to_supplier  | 
 20385  | 
 20385  | 
 0  | 
 0.00  | 
 93  | 
 9522  | 
 669  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_payment_common  | 
 45174  | 
 45174  | 
 0  | 
 0.00  | 
 0  | 
 3432  | 
 29  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_qd_handle_on_cancel_clo  | 
 6295  | 
 6042  | 
 253  | 
 4.01  | 
 0  | 
 234  | 
 49  | 
 253  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 15208  | 
 14742  | 
 466  | 
 3.06  | 
 0  | 
 7052  | 
 1193  | 
 466  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 33982  | 
 33982  | 
 0  | 
 0.00  | 
 0  | 
 1747  | 
 121  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_reserve_write_off  | 
 34875  | 
 33982  | 
 893  | 
 2.56  | 
 46  | 
 5541  | 
 318  | 
 893  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_supplier_invoice  | 
 18961  | 
 18961  | 
 0  | 
 0.00  | 
 78  | 
 46184  | 
 11339  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  sp_supplier_order  | 
 19014  | 
 19014  | 
 0  | 
 0.00  | 
 93  | 
 23806  | 
 7362  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  srv_find_qd_qs_mism  | 
 924176  | 
 877353  | 
 46823  | 
 5.06  | 
 0  | 
 1623  | 
 1  | 
 46823  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  srv_make_invnt_saldo  | 
 3630  | 
 3630  | 
 0  | 
 0.00  | 
 187  | 
 37413  | 
 1474  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  srv_make_money_saldo  | 
 4244  | 
 4244  | 
 0  | 
 0.00  | 
 15  | 
 3978  | 
 75  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 2184  | 
 4696  | 
 3374  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 5899  | 
 5899  | 
 0  | 
 0.00  | 
 51  | 
 406  | 
 141  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 469  | 
 469  | 
 0  | 
 0.00  | 
 62  | 
 2512  | 
 1020  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_cancel_client_order  | 
 253  | 
 253  | 
 0  | 
 0.00  | 
 109  | 
 435  | 
 227  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 50  | 
 50  | 
 0  | 
 0.00  | 
 78  | 
 297  | 
 149  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 26  | 
 26  | 
 0  | 
 0.00  | 
 141  | 
 390  | 
 229  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 33  | 
 33  | 
 0  | 
 0.00  | 
 140  | 
 343  | 
 232  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 463  | 
 463  | 
 0  | 
 0.00  | 
 62  | 
 358  | 
 142  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 5903  | 
 5903  | 
 0  | 
 0.00  | 
 46  | 
 2979  | 
 1592  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_cancel_write_off  | 
 58  | 
 58  | 
 0  | 
 0.00  | 
 78  | 
 312  | 
 146  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-abend:sp_reserve_write_off  | 
 893  | 
 893  | 
 0  | 
 0.00  | 
 63  | 
 312  | 
 142  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 11771  | 
 11771  | 
 0  | 
 0.00  | 
 359  | 
 43582  | 
 10867  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1254  | 
 1254  | 
 0  | 
 0.00  | 
 343  | 
 33430  | 
 8978  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6042  | 
 6042  | 
 0  | 
 0.00  | 
 109  | 
 624  | 
 253  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2298  | 
 2298  | 
 0  | 
 0.00  | 
 46  | 
 601  | 
 283  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2376  | 
 2376  | 
 0  | 
 0.00  | 
 78  | 
 484  | 
 199  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1474  | 
 1474  | 
 0  | 
 0.00  | 
 93  | 
 390  | 
 197  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 960  | 
 960  | 
 0  | 
 0.00  | 
 109  | 
 609  | 
 253  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 421  | 
 421  | 
 0  | 
 0.00  | 
 156  | 
 400092  | 
 50946  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3323  | 
 3323  | 
 0  | 
 0.00  | 
 109  | 
 655  | 
 281  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_client_order  | 
 73714  | 
 73714  | 
 0  | 
 0.00  | 
 15  | 
 780  | 
 339  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_customer_reserve  | 
 3478  | 
 3478  | 
 0  | 
 0.00  | 
 31  | 
 578  | 
 192  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_pay_from_customer  | 
 24790  | 
 24790  | 
 0  | 
 0.00  | 
 31  | 
 546  | 
 225  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 20385  | 
 20385  | 
 0  | 
 0.00  | 
 16  | 
 624  | 
 227  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_reserve_write_off  | 
 33986  | 
 33986  | 
 0  | 
 0.00  | 
 47  | 
 707  | 
 309  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_supplier_invoice  | 
 18977  | 
 18977  | 
 0  | 
 0.00  | 
 15  | 
 748  | 
 339  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:sp_supplier_order  | 
 19037  | 
 19037  | 
 0  | 
 0.00  | 
 32  | 
 764  | 
 338  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 3631  | 
 3631  | 
 0  | 
 0.00  | 
 0  | 
 172  | 
 28  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:srv_make_money_saldo  | 
 4244  | 
 4244  | 
 0  | 
 0.00  | 
 0  | 
 172  | 
 30  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 936  | 
 1374  | 
 1187  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_add_invoice_to_stock  | 
 35284  | 
 23488  | 
 11796  | 
 33.43  | 
 0  | 
 110  | 
 6  | 
 11796  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_all_customers  | 
 110454  | 
 110454  | 
 0  | 
 0.00  | 
 0  | 
 125  | 
 5  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_all_suppliers  | 
 77517  | 
 77517  | 
 0  | 
 0.00  | 
 0  | 
 125  | 
 6  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_all_wares  | 
 147414  | 
 147414  | 
 0  | 
 0.00  | 
 0  | 
 156  | 
 9  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_cancel_adding_invoice  | 
 2980  | 
 2508  | 
 472  | 
 15.83  | 
 0  | 
 499  | 
 59  | 
 472  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_cancel_client_order  | 
 12590  | 
 12084  | 
 506  | 
 4.01  | 
 0  | 
 109  | 
 4  | 
 506  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_cancel_customer_prepayment  | 
 4804  | 
 4752  | 
 52  | 
 1.08  | 
 0  | 
 109  | 
 5  | 
 52  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_cancel_customer_reserve  | 
 4694  | 
 4594  | 
 100  | 
 2.13  | 
 0  | 
 78  | 
 6  | 
 100  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_cancel_payment_to_supplier  | 
 3014  | 
 2948  | 
 66  | 
 2.18  | 
 0  | 
 93  | 
 5  | 
 66  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_cancel_supplier_invoice  | 
 2846  | 
 1920  | 
 926  | 
 32.53  | 
 0  | 
 94  | 
 7  | 
 926  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_cancel_supplier_order  | 
 2738  | 
 840  | 
 1898  | 
 69.32  | 
 0  | 
 47  | 
 6  | 
 1898  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_cancel_write_off  | 
 6762  | 
 6646  | 
 116  | 
 1.71  | 
 0  | 
 484  | 
 31  | 
 116  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_max_id_clo_ord  | 
 19016  | 
 19016  | 
 0  | 
 0.00  | 
 0  | 
 1045  | 
 18  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_max_id_clo_res  | 
 3477  | 
 3477  | 
 0  | 
 0.00  | 
 0  | 
 296  | 
 22  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_max_id_ord_sup  | 
 18961  | 
 18961  | 
 0  | 
 0.00  | 
 0  | 
 889  | 
 17  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_max_non_paid_invoice  | 
 19602  | 
 19602  | 
 0  | 
 0.00  | 
 0  | 
 202  | 
 7  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_max_non_paid_realizn  | 
 24789  | 
 24789  | 
 0  | 
 0.00  | 
 0  | 
 156  | 
 6  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_min_id_clo_ord  | 
 19015  | 
 19015  | 
 0  | 
 0.00  | 
 0  | 
 858  | 
 13  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_min_id_clo_res  | 
 3477  | 
 3477  | 
 0  | 
 0.00  | 
 0  | 
 796  | 
 10  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_min_id_ord_sup  | 
 18961  | 
 18961  | 
 0  | 
 0.00  | 
 0  | 
 1151  | 
 14  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_min_non_paid_invoice  | 
 20385  | 
 20385  | 
 0  | 
 0.00  | 
 0  | 
 3152  | 
 16  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_min_non_paid_realizn  | 
 24789  | 
 24789  | 
 0  | 
 0.00  | 
 0  | 
 312  | 
 6  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_our_firm  | 
 36960  | 
 36960  | 
 0  | 
 0.00  | 
 0  | 
 94  | 
 5  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  v_reserve_write_off  | 
 69750  | 
 67964  | 
 1786  | 
 2.56  | 
 0  | 
 141  | 
 5  | 
 1786  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  x_lock_depdocs_on_canc_invoice  | 
 12645  | 
 8284  | 
 4361  | 
 34.48  | 
 0  | 
 577  | 
 9  | 
 4361  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1367  | 
 420  | 
 947  | 
 69.27  | 
 0  | 
 140  | 
 5  | 
 947  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  x_make_qstorno_1000_1200  | 
 19017  | 
 19017  | 
 0  | 
 0.00  | 
 47  | 
 20387  | 
 6766  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  x_make_qstorno_1200_2000  | 
 18961  | 
 18961  | 
 0  | 
 0.00  | 
 47  | 
 45482  | 
 10779  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  x_make_qstorno_2100_3300  | 
 571883  | 
 571883  | 
 0  | 
 0.00  | 
 0  | 
 15415  | 
 362  | 
 0  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
 
Done for 334520 ms, from  8:15:31.51 to  8:21:06.03.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 127  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  deadlock  | 
 6  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2016-03-15 05:01  | 
 2016-03-15 07:02  | 
|  deadlock  | 
 106  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2016-03-15 04:56  | 
 2016-03-15 07:53  | 
|  deadlock  | 
 253  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  deadlock  | 
 86  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2016-03-15 04:59  | 
 2016-03-15 07:47  | 
|  deadlock  | 
 2  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2016-03-15 05:16  | 
 2016-03-15 06:47  | 
|  concurrent_transaction  | 
 7289  | 
 sp_lock_selected_doc  | 
 335544878  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  concurrent_transaction  | 
 509  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544878  | 
 2016-03-15 04:56  | 
 2016-03-15 07:56  | 
|  concurrent_transaction  | 
 481  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544878  | 
 2016-03-15 04:56  | 
 2016-03-15 07:55  | 
 
Done for 9980 ms, from  8:21:15.65 to  8:21:25.63.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP40-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          348337
 
MON$OLDEST_ACTIVE               348338
 
MON$OLDEST_SNAPSHOT             348338
 
MON$NEXT_TRANSACTION            348338
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2015-12-11 13:07:49.8140
 
MON$PAGES                       763168
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-T4.0.0.32397 Firebird 4.0 Unstable
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.32397 Firebird 4.0 Unstable"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.32397 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.32397 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		348658 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	348339 
 
Oldest active		348340 
 
Oldest snapshot		348340 
 
Next transaction	348341 
 
Sequence number		0 
 
Next attachment ID	5203 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Dec 11, 2015 13:07:49 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file 
 
 
Analyzing database pages ... 
 
AGENTS (154) 
 
Primary pointer page: 311, Index root page: 312 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.24, total records: 50 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 344.00, compression ratio: 10.05 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 31% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_ID_DESC (2) 
 
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_OUR_FIRM (4) 
 
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 48 
 
Average key length: 2.04, compression ratio: 0.50 
 
Average prefix length: 0.96, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_SUPPLIER (3) 
 
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 45 
 
Average key length: 2.04, compression ratio: 0.53 
 
Average prefix length: 1.02, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_NAME_UNQ (1) 
 
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.92, total dup: 0, max dup: 0 
 
Average key length: 16.60, compression ratio: 0.92 
 
Average prefix length: 1.34, average data length: 13.92 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_AGENTS (0) 
 
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
BUSINESS_OPS (158) 
 
Primary pointer page: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 103.00, total records: 19 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 996.00, compression ratio: 9.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 28% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BO_UNIT_UNQ (1) 
 
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 18.00, total dup: 0, max dup: 0 
 
Average key length: 16.95, compression ratio: 1.25 
 
Average prefix length: 7.21, average data length: 14.00 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BUSINESS_OPS_RND_WGTH (2) 
 
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 4.05, total dup: 7, max dup: 3 
 
Average key length: 3.00, compression ratio: 0.75 
 
Average prefix length: 1.42, average data length: 0.84 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RDB$1 (0) 
 
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 5.26, total dup: 0, max dup: 0 
 
Average key length: 4.21, compression ratio: 0.64 
 
Average prefix length: 1.05, average data length: 1.63 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
DOC_DATA (141) 
 
Primary pointer page: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 46.04, total records: 1783624 
 
Average version length: 47.89, total versions: 44920, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.39 
 
Pointer pages: 12, data page slots: 19488 
 
Data pages: 19488, average fill: 73% 
 
Primary pages: 19488, secondary pages: 0, swept pages: 2925 
 
Empty pages: 2, full pages: 15387 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 2 
 
40 - 59% = 11 
 
60 - 79% = 19473 
 
80 - 99% = 0 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 19783, depth: 3, leaf buckets: 8193, nodes: 1783624 
 
Average node length: 20.04, total dup: 0, max dup: 0 
 
Average key length: 17.10, compression ratio: 1.58 
 
Average prefix length: 12.90, average data length: 14.10 
 
Clustering factor: 723024, ratio: 0.41 
 
Fill distribution: 
 
0 - 19% = 306 
 
20 - 39% = 473 
 
40 - 59% = 4973 
 
60 - 79% = 1771 
 
80 - 99% = 670 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 46992, depth: 3, leaf buckets: 5961, nodes: 1783624 
 
Average node length: 11.63, total dup: 0, max dup: 0 
 
Average key length: 8.69, compression ratio: 1.04 
 
Average prefix length: 3.31, average data length: 5.69 
 
Clustering factor: 672208, ratio: 0.38 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1687 
 
40 - 59% = 4273 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 153829, depth: 3, leaf buckets: 3264, nodes: 1783624 
 
Average node length: 7.20, total dup: 1204147, max dup: 49 
 
Average key length: 4.26, compression ratio: 2.11 
 
Average prefix length: 7.07, average data length: 1.93 
 
Clustering factor: 679711, ratio: 0.38 
 
Fill distribution: 
 
0 - 19% = 70 
 
20 - 39% = 506 
 
40 - 59% = 2361 
 
60 - 79% = 126 
 
80 - 99% = 201 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 58.54, total records: 630472 
 
Average version length: 60.80, total versions: 27271, max versions: 5 
 
Average fragment length: 7.36, total fragments: 70, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.64 
 
Pointer pages: 5, data page slots: 7984 
 
Data pages: 7984, average fill: 77% 
 
Primary pages: 7979, secondary pages: 5, swept pages: 738 
 
Empty pages: 3, full pages: 7587 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 7 
 
40 - 59% = 9 
 
60 - 79% = 7078 
 
80 - 99% = 883 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 228248, depth: 3, leaf buckets: 2253, nodes: 630472 
 
Average node length: 11.77, total dup: 0, max dup: 0 
 
Average key length: 8.90, compression ratio: 1.01 
 
Average prefix length: 3.09, average data length: 5.91 
 
Clustering factor: 188537, ratio: 0.30 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1100 
 
40 - 59% = 1153 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2964, depth: 2, leaf buckets: 754, nodes: 630472 
 
Average node length: 4.87, total dup: 630422, max dup: 46219 
 
Average key length: 2.01, compression ratio: 4.47 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 295638, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 706 
 
60 - 79% = 19 
 
80 - 99% = 29 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 243570, depth: 3, leaf buckets: 2251, nodes: 630472 
 
Average node length: 11.77, total dup: 0, max dup: 0 
 
Average key length: 8.90, compression ratio: 1.01 
 
Average prefix length: 3.09, average data length: 5.91 
 
Clustering factor: 188537, ratio: 0.30 
 
Fill distribution: 
 
0 - 19% = 88 
 
20 - 39% = 1041 
 
40 - 59% = 1046 
 
60 - 79% = 6 
 
80 - 99% = 70 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 269, Index root page: 270 
 
Total formats: 1, used formats: 1 
 
Average record length: 64.41, total records: 400 
 
Average version length: 14.84, total versions: 946186, max versions: 2482 
 
Average fragment length: 17.78, total fragments: 397, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.61 
 
Pointer pages: 3, data page slots: 4888 
 
Data pages: 4888, average fill: 77% 
 
Primary pages: 11, secondary pages: 4877, swept pages: 0 
 
Empty pages: 7, full pages: 4880 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 3626 
 
80 - 99% = 1254 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 281, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 262, ratio: 0.66 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 1.52, total records: 253589 
 
Average version length: 71.17, total versions: 248183, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 63.19 
 
Pointer pages: 4, data page slots: 5768 
 
Data pages: 4024, average fill: 81% 
 
Primary pages: 4023, secondary pages: 1, swept pages: 60 
 
Empty pages: 69, full pages: 3498 
 
Fill distribution: 
 
0 - 19% = 83 
 
20 - 39% = 83 
 
40 - 59% = 189 
 
60 - 79% = 716 
 
80 - 99% = 2953 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 125473, depth: 3, leaf buckets: 775, nodes: 253589 
 
Average node length: 13.92, total dup: 17084, max dup: 3 
 
Average key length: 11.13, compression ratio: 2.43 
 
Average prefix length: 18.80, average data length: 8.20 
 
Clustering factor: 221939, ratio: 0.88 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 154 
 
40 - 59% = 300 
 
60 - 79% = 220 
 
80 - 99% = 99 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 261, Index root page: 262 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.12, total records: 49 
 
Average version length: 9.01, total versions: 53906, max versions: 3985 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.12 
 
Pointer pages: 1, data page slots: 192 
 
Data pages: 192, average fill: 89% 
 
Primary pages: 7, secondary pages: 185, swept pages: 0 
 
Empty pages: 6, full pages: 185 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 185 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 272, depth: 1, leaf buckets: 1, nodes: 49 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_TURNOVER_LOG (142) 
 
Primary pointer page: 259, Index root page: 260 
 
Total formats: 1, used formats: 1 
 
Average record length: 0.24, total records: 11371 
 
Average version length: 45.33, total versions: 11314, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 265.02 
 
Pointer pages: 1, data page slots: 184 
 
Data pages: 176, average fill: 64% 
 
Primary pages: 176, secondary pages: 0, swept pages: 23 
 
Empty pages: 23, full pages: 121 
 
Fill distribution: 
 
0 - 19% = 44 
 
20 - 39% = 4 
 
40 - 59% = 2 
 
60 - 79% = 30 
 
80 - 99% = 96 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 99685, depth: 2, leaf buckets: 15, nodes: 11371 
 
Average node length: 4.04, total dup: 11288, max dup: 1513 
 
Average key length: 2.11, compression ratio: 9.01 
 
Average prefix length: 18.90, average data length: 0.10 
 
Clustering factor: 4630, ratio: 0.41 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 5 
 
40 - 59% = 7 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
MON_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 2, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_DTS (4) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG (0) 
 
Root page: 359, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (165) 
 
Primary pointer page: 364, Index root page: 365 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_DTS (4) 
 
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_GDSCODE (2) 
 
Root page: 368, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_ROWSET (1) 
 
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 22.28, total records: 680655 
 
Average version length: 42.83, total versions: 49951, max versions: 14 
 
Average fragment length: 34.00, total fragments: 1, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 2.87 
 
Pointer pages: 3, data page slots: 4896 
 
Data pages: 4896, average fill: 75% 
 
Primary pages: 4883, secondary pages: 13, swept pages: 1077 
 
Empty pages: 0, full pages: 4031 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 83 
 
40 - 59% = 119 
 
60 - 79% = 3736 
 
80 - 99% = 947 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 3600, depth: 2, leaf buckets: 352, nodes: 319136 
 
Average node length: 4.79, total dup: 319087, max dup: 20692 
 
Average key length: 2.01, compression ratio: 4.47 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 44200, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 30 
 
40 - 59% = 258 
 
60 - 79% = 45 
 
80 - 99% = 19 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4281, depth: 2, leaf buckets: 384, nodes: 319136 
 
Average node length: 5.78, total dup: 286494, max dup: 44 
 
Average key length: 3.00, compression ratio: 7.33 
 
Average prefix length: 21.10, average data length: 0.90 
 
Clustering factor: 51835, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 43 
 
40 - 59% = 175 
 
60 - 79% = 110 
 
80 - 99% = 55 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 3974, depth: 2, leaf buckets: 374, nodes: 319136 
 
Average node length: 5.78, total dup: 286494, max dup: 44 
 
Average key length: 3.00, compression ratio: 7.33 
 
Average prefix length: 21.10, average data length: 0.90 
 
Clustering factor: 52565, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 35 
 
40 - 59% = 168 
 
60 - 79% = 113 
 
80 - 99% = 58 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4313, depth: 2, leaf buckets: 362, nodes: 319136 
 
Average node length: 5.55, total dup: 286494, max dup: 44 
 
Average key length: 2.77, compression ratio: 3.24 
 
Average prefix length: 8.33, average data length: 0.67 
 
Clustering factor: 52474, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 32 
 
40 - 59% = 160 
 
60 - 79% = 118 
 
80 - 99% = 52 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.92, total records: 264748 
 
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.15 
 
Pointer pages: 2, data page slots: 2264 
 
Data pages: 2264, average fill: 64% 
 
Primary pages: 2264, secondary pages: 0, swept pages: 0 
 
Empty pages: 2, full pages: 2261 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 2261 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 98254, depth: 2, leaf buckets: 205, nodes: 264748 
 
Average node length: 4.52, total dup: 264557, max dup: 2643 
 
Average key length: 2.00, compression ratio: 1.28 
 
Average prefix length: 2.56, average data length: 0.00 
 
Clustering factor: 70086, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 44 
 
60 - 79% = 99 
 
80 - 99% = 61 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (162) 
 
Primary pointer page: 348, Index root page: 349 
 
Total formats: 2, used formats: 2 
 
Average record length: 147.73, total records: 9619613 
 
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: 1440.53, compression ratio: 9.75 
 
Pointer pages: 138, data page slots: 223696 
 
Data pages: 223696, average fill: 87% 
 
Primary pages: 223696, secondary pages: 0, swept pages: 3 
 
Empty pages: 2, full pages: 223693 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 223693 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 59394, depth: 3, leaf buckets: 9800, nodes: 9619613 
 
Average node length: 5.62, total dup: 8268690, max dup: 69 
 
Average key length: 2.25, compression ratio: 3.55 
 
Average prefix length: 7.79, average data length: 0.20 
 
Clustering factor: 6503498, ratio: 0.68 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 0 
 
40 - 59% = 3597 
 
60 - 79% = 3726 
 
80 - 99% = 2456 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 147482, depth: 3, leaf buckets: 10442, nodes: 9619613 
 
Average node length: 4.41, total dup: 9619608, max dup: 9218044 
 
Average key length: 1.04, compression ratio: 0.20 
 
Average prefix length: 0.21, average data length: 0.00 
 
Clustering factor: 371920, ratio: 0.04 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 10414 
 
60 - 79% = 1 
 
80 - 99% = 27 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43359, depth: 3, leaf buckets: 10738, nodes: 9619613 
 
Average node length: 5.61, total dup: 9309737, max dup: 12889 
 
Average key length: 2.24, compression ratio: 4.02 
 
Average prefix length: 8.79, average data length: 0.21 
 
Clustering factor: 4966122, ratio: 0.52 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 2 
 
40 - 59% = 6334 
 
60 - 79% = 2444 
 
80 - 99% = 1953 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 65474, depth: 3, leaf buckets: 11402, nodes: 9619613 
 
Average node length: 5.52, total dup: 9516249, max dup: 1435496 
 
Average key length: 2.15, compression ratio: 17.49 
 
Average prefix length: 37.51, average data length: 0.14 
 
Clustering factor: 5894838, ratio: 0.61 
 
Fill distribution: 
 
0 - 19% = 27 
 
20 - 39% = 1 
 
40 - 59% = 9002 
 
60 - 79% = 827 
 
80 - 99% = 1545 
 
 
PHRASES (145) 
 
Primary pointer page: 265, Index root page: 266 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 52.71, total records: 312293 
 
Average version length: 55.93, total versions: 12901, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.52 
 
Pointer pages: 3, data page slots: 3744 
 
Data pages: 3744, average fill: 74% 
 
Primary pages: 3744, secondary pages: 0, swept pages: 1141 
 
Empty pages: 7, full pages: 3350 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 7 
 
40 - 59% = 33 
 
60 - 79% = 3629 
 
80 - 99% = 65 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 2296, depth: 2, leaf buckets: 386, nodes: 312293 
 
Average node length: 5.99, total dup: 257615, max dup: 700 
 
Average key length: 3.29, compression ratio: 2.73 
 
Average prefix length: 7.88, average data length: 1.12 
 
Clustering factor: 34982, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 10 
 
40 - 59% = 188 
 
60 - 79% = 134 
 
80 - 99% = 45 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2211, depth: 2, leaf buckets: 337, nodes: 312293 
 
Average node length: 5.53, total dup: 278019, max dup: 280 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.27, average data length: 0.73 
 
Clustering factor: 68453, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 3 
 
40 - 59% = 151 
 
60 - 79% = 137 
 
80 - 99% = 45 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 9.00, total versions: 8544, max versions: 4575 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 32 
 
Data pages: 32, average fill: 85% 
 
Primary pages: 3, secondary pages: 29, swept pages: 0 
 
Empty pages: 2, full pages: 29 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 29 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 12.50, total dup: 0, max dup: 0 
 
Average key length: 11.00, compression ratio: 0.82 
 
Average prefix length: 0.50, average data length: 8.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index SEMAPHORES_TASK_UNQ (1) 
 
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 22.50, total dup: 0, max dup: 0 
 
Average key length: 21.00, compression ratio: 1.07 
 
Average prefix length: 4.00, average data length: 18.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SETTINGS (137) 
 
Primary pointer page: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.32, total records: 114 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1347.00, compression ratio: 13.70 
 
Pointer pages: 1, data page slots: 2 
 
Data pages: 2, average fill: 81% 
 
Primary pages: 2, secondary pages: 0, swept pages: 2 
 
Empty pages: 0, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
Index SETTINGS_MODE_CODE (0) 
 
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.07, total dup: 0, max dup: 0 
 
Average key length: 26.06, compression ratio: 1.70 
 
Average prefix length: 21.23, average data length: 23.07 
 
Clustering factor: 6, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$RAND$CALLS (136) 
 
Primary pointer page: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 2, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
 
Root page: 358, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TRACE_STAT (276) 
 
Primary pointer page: 557, Index root page: 68921 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.20, total records: 2884 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.51 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 63% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 6, full pages: 33 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 33 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 263, Index root page: 264 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.53, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.78 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 77% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 374, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 64 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 273, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 328, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 275, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 328, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400 
 
Average node length: 52.95, total dup: 0, max dup: 0 
 
Average key length: 51.92, compression ratio: 0.99 
 
Average prefix length: 2.65, average data length: 48.95 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 2 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (259) 
 
Primary pointer page: 254, Index root page: 284 
 
Total formats: 1, used formats: 1 
 
Average record length: 0.85, total records: 353435 
 
Average version length: 72.18, total versions: 349264, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 159.68 
 
Pointer pages: 5, data page slots: 7448 
 
Data pages: 5240, average fill: 88% 
 
Primary pages: 5239, secondary pages: 1, swept pages: 119 
 
Empty pages: 144, full pages: 4895 
 
Fill distribution: 
 
0 - 19% = 177 
 
20 - 39% = 82 
 
40 - 59% = 66 
 
60 - 79% = 102 
 
80 - 99% = 4813 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 172888, depth: 3, leaf buckets: 668, nodes: 353435 
 
Average node length: 6.19, total dup: 309419, max dup: 29 
 
Average key length: 3.29, compression ratio: 11.25 
 
Average prefix length: 35.83, average data length: 1.17 
 
Clustering factor: 56352, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 249 
 
20 - 39% = 19 
 
40 - 59% = 108 
 
60 - 79% = 288 
 
80 - 99% = 4 
 
 
XQD_1000_3300 (261) 
 
Primary pointer page: 708, Index root page: 709 
 
Total formats: 1, used formats: 1 
 
Average record length: 62.72, total records: 1552662 
 
Average version length: 71.63, total versions: 203543, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.17 
 
Pointer pages: 15, data page slots: 23832 
 
Data pages: 23832, average fill: 73% 
 
Primary pages: 23832, secondary pages: 0, swept pages: 3749 
 
Empty pages: 9, full pages: 16903 
 
Fill distribution: 
 
0 - 19% = 44 
 
20 - 39% = 209 
 
40 - 59% = 1509 
 
60 - 79% = 19255 
 
80 - 99% = 2815 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 185334, depth: 3, leaf buckets: 2012, nodes: 1552662 
 
Average node length: 5.16, total dup: 1509823, max dup: 130 
 
Average key length: 2.21, compression ratio: 4.07 
 
Average prefix length: 8.82, average data length: 0.18 
 
Clustering factor: 331004, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 150 
 
40 - 59% = 1701 
 
60 - 79% = 122 
 
80 - 99% = 18 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 117800, depth: 3, leaf buckets: 2447, nodes: 1552662 
 
Average node length: 6.29, total dup: 1354678, max dup: 32 
 
Average key length: 3.34, compression ratio: 11.09 
 
Average prefix length: 35.79, average data length: 1.21 
 
Clustering factor: 414413, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 63 
 
20 - 39% = 172 
 
40 - 59% = 1915 
 
60 - 79% = 164 
 
80 - 99% = 133 
 
 
XQD_1200_2000 (260) 
 
Primary pointer page: 705, Index root page: 706 
 
Total formats: 1, used formats: 1 
 
Average record length: 4.49, total records: 666528 
 
Average version length: 71.99, total versions: 576832, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 30.30 
 
Pointer pages: 8, data page slots: 12816 
 
Data pages: 12096, average fill: 67% 
 
Primary pages: 12092, secondary pages: 4, swept pages: 2151 
 
Empty pages: 873, full pages: 8034 
 
Fill distribution: 
 
0 - 19% = 2417 
 
20 - 39% = 294 
 
40 - 59% = 824 
 
60 - 79% = 1778 
 
80 - 99% = 6783 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 119949, depth: 3, leaf buckets: 850, nodes: 611484 
 
Average node length: 5.96, total dup: 552956, max dup: 124 
 
Average key length: 3.03, compression ratio: 12.22 
 
Average prefix length: 36.07, average data length: 0.93 
 
Clustering factor: 131505, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 72 
 
20 - 39% = 154 
 
40 - 59% = 283 
 
60 - 79% = 229 
 
80 - 99% = 112 
 
 
XQD_2000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.60, total records: 2551353 
 
Average version length: 72.11, total versions: 599966, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 3.19 
 
Pointer pages: 23, data page slots: 35912 
 
Data pages: 35912, average fill: 71% 
 
Primary pages: 35912, secondary pages: 0, swept pages: 1121 
 
Empty pages: 40, full pages: 22055 
 
Fill distribution: 
 
0 - 19% = 171 
 
20 - 39% = 1026 
 
40 - 59% = 6167 
 
60 - 79% = 17219 
 
80 - 99% = 11329 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 109269, depth: 3, leaf buckets: 3129, nodes: 2041867 
 
Average node length: 5.64, total dup: 1917242, max dup: 105 
 
Average key length: 2.67, compression ratio: 13.87 
 
Average prefix length: 36.39, average data length: 0.61 
 
Clustering factor: 635717, ratio: 0.31 
 
Fill distribution: 
 
0 - 19% = 28 
 
20 - 39% = 1138 
 
40 - 59% = 1480 
 
60 - 79% = 270 
 
80 - 99% = 213 
 
 
XQD_2100_3300 (263) 
 
Primary pointer page: 734, Index root page: 735 
 
Total formats: 1, used formats: 1 
 
Average record length: 8.97, total records: 3574980 
 
Average version length: 70.13, total versions: 14183, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 15.16 
 
Pointer pages: 14, data page slots: 22544 
 
Data pages: 22544, average fill: 51% 
 
Primary pages: 22544, secondary pages: 0, swept pages: 4712 
 
Empty pages: 3, full pages: 20011 
 
Fill distribution: 
 
0 - 19% = 367 
 
20 - 39% = 6714 
 
40 - 59% = 5703 
 
60 - 79% = 9740 
 
80 - 99% = 20 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1530, depth: 2, leaf buckets: 37, nodes: 14625 
 
Average node length: 8.65, total dup: 10640, max dup: 27 
 
Average key length: 5.64, compression ratio: 6.56 
 
Average prefix length: 33.63, average data length: 3.37 
 
Clustering factor: 3873, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 17 
 
40 - 59% = 13 
 
60 - 79% = 7 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (264) 
 
Primary pointer page: 737, Index root page: 738 
 
Total formats: 1, used formats: 1 
 
Average record length: 61.99, total records: 2592860 
 
Average version length: 71.49, total versions: 189670, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.19 
 
Pointer pages: 23, data page slots: 35912 
 
Data pages: 35912, average fill: 76% 
 
Primary pages: 35912, secondary pages: 0, swept pages: 6183 
 
Empty pages: 10, full pages: 30090 
 
Fill distribution: 
 
0 - 19% = 32 
 
20 - 39% = 105 
 
40 - 59% = 923 
 
60 - 79% = 28756 
 
80 - 99% = 6096 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 41262, depth: 3, leaf buckets: 5183, nodes: 2417263 
 
Average node length: 6.98, total dup: 1932092, max dup: 27 
 
Average key length: 4.01, compression ratio: 9.23 
 
Average prefix length: 35.19, average data length: 1.81 
 
Clustering factor: 675961, ratio: 0.28 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 3043 
 
40 - 59% = 1768 
 
60 - 79% = 202 
 
80 - 99% = 167 
 
 
XQS_1000_1200 (265) 
 
Primary pointer page: 740, Index root page: 741 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.78, total records: 3938950 
 
Average version length: 84.55, total versions: 50578, 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: 38, data page slots: 61152 
 
Data pages: 61152, average fill: 80% 
 
Primary pages: 61152, secondary pages: 0, swept pages: 24066 
 
Empty pages: 4, full pages: 59851 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 33 
 
60 - 79% = 26041 
 
80 - 99% = 35074 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54649, depth: 3, leaf buckets: 3797, nodes: 3938950 
 
Average node length: 5.16, total dup: 3848180, max dup: 140 
 
Average key length: 2.17, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 926404, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 59 
 
40 - 59% = 1358 
 
60 - 79% = 1501 
 
80 - 99% = 869 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 78654, depth: 3, leaf buckets: 5238, nodes: 3938950 
 
Average node length: 5.65, total dup: 3554366, max dup: 49 
 
Average key length: 2.67, compression ratio: 3.37 
 
Average prefix length: 8.43, average data length: 0.57 
 
Clustering factor: 635183, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 54 
 
20 - 39% = 149 
 
40 - 59% = 4142 
 
60 - 79% = 438 
 
80 - 99% = 455 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 48486, depth: 3, leaf buckets: 4288, nodes: 3938950 
 
Average node length: 5.80, total dup: 3446083, max dup: 29 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.31, average data length: 0.69 
 
Clustering factor: 978297, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 77 
 
40 - 59% = 1715 
 
60 - 79% = 1450 
 
80 - 99% = 1042 
 
 
XQS_1000_3300 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.81, total records: 1670215 
 
Average version length: 83.55, total versions: 100901, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.75 
 
Pointer pages: 17, data page slots: 26384 
 
Data pages: 26384, average fill: 78% 
 
Primary pages: 26384, secondary pages: 0, swept pages: 8693 
 
Empty pages: 6, full pages: 23874 
 
Fill distribution: 
 
0 - 19% = 19 
 
20 - 39% = 52 
 
40 - 59% = 403 
 
60 - 79% = 12738 
 
80 - 99% = 13172 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 75516, depth: 3, leaf buckets: 1760, nodes: 1670215 
 
Average node length: 5.13, total dup: 1632269, max dup: 203 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 355432, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 22 
 
40 - 59% = 979 
 
60 - 79% = 562 
 
80 - 99% = 197 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 116563, depth: 3, leaf buckets: 3173, nodes: 1670215 
 
Average node length: 6.31, total dup: 1351151, max dup: 14 
 
Average key length: 3.35, compression ratio: 2.69 
 
Average prefix length: 7.84, average data length: 1.16 
 
Clustering factor: 263078, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 46 
 
20 - 39% = 1594 
 
40 - 59% = 1321 
 
60 - 79% = 179 
 
80 - 99% = 33 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 65477, depth: 3, leaf buckets: 1980, nodes: 1670215 
 
Average node length: 5.76, total dup: 1470584, max dup: 58 
 
Average key length: 2.80, compression ratio: 3.21 
 
Average prefix length: 8.32, average data length: 0.68 
 
Clustering factor: 383039, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 22 
 
40 - 59% = 1127 
 
60 - 79% = 606 
 
80 - 99% = 219 
 
 
XQS_1200_2000 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.88, total records: 4456576 
 
Average version length: 85.39, total versions: 323413, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.75 
 
Pointer pages: 44, data page slots: 71040 
 
Data pages: 71032, average fill: 79% 
 
Primary pages: 71032, secondary pages: 0, swept pages: 13481 
 
Empty pages: 17, full pages: 63471 
 
Fill distribution: 
 
0 - 19% = 35 
 
20 - 39% = 206 
 
40 - 59% = 1454 
 
60 - 79% = 30664 
 
80 - 99% = 38673 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57323, depth: 3, leaf buckets: 4765, nodes: 4456576 
 
Average node length: 5.04, total dup: 4432062, max dup: 623 
 
Average key length: 2.05, compression ratio: 4.39 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 1204767, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 231 
 
40 - 59% = 2764 
 
60 - 79% = 1353 
 
80 - 99% = 412 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 78658, depth: 3, leaf buckets: 6184, nodes: 4456576 
 
Average node length: 5.49, total dup: 4132908, max dup: 49 
 
Average key length: 2.50, compression ratio: 3.59 
 
Average prefix length: 8.57, average data length: 0.43 
 
Clustering factor: 955867, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 48 
 
20 - 39% = 1913 
 
40 - 59% = 3192 
 
60 - 79% = 482 
 
80 - 99% = 549 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49624, depth: 3, leaf buckets: 5314, nodes: 4456576 
 
Average node length: 5.60, total dup: 4057140, max dup: 116 
 
Average key length: 2.61, compression ratio: 3.44 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 1279595, ratio: 0.29 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 201 
 
40 - 59% = 3218 
 
60 - 79% = 1408 
 
80 - 99% = 483 
 
 
XQS_2000_3300 (268) 
 
Primary pointer page: 757, Index root page: 758 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 760, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 762, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 761, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (269) 
 
Primary pointer page: 763, Index root page: 764 
 
Total formats: 1, used formats: 1 
 
Average record length: 78.97, total records: 2850578 
 
Average version length: 84.80, total versions: 159758, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.72 
 
Pointer pages: 28, data page slots: 45304 
 
Data pages: 45304, average fill: 79% 
 
Primary pages: 45304, secondary pages: 0, swept pages: 12777 
 
Empty pages: 6, full pages: 40656 
 
Fill distribution: 
 
0 - 19% = 28 
 
20 - 39% = 75 
 
40 - 59% = 527 
 
60 - 79% = 21729 
 
80 - 99% = 22945 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89528, depth: 3, leaf buckets: 3054, nodes: 2850578 
 
Average node length: 5.02, total dup: 2836597, max dup: 1019 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 742213, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 322 
 
40 - 59% = 1558 
 
60 - 79% = 759 
 
80 - 99% = 400 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 90221, depth: 3, leaf buckets: 5624, nodes: 2850578 
 
Average node length: 6.33, total dup: 2301217, max dup: 14 
 
Average key length: 3.36, compression ratio: 2.68 
 
Average prefix length: 7.84, average data length: 1.16 
 
Clustering factor: 612501, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 174 
 
20 - 39% = 2851 
 
40 - 59% = 2336 
 
60 - 79% = 221 
 
80 - 99% = 42 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 78028, depth: 3, leaf buckets: 3237, nodes: 2850578 
 
Average node length: 5.53, total dup: 2625497, max dup: 99 
 
Average key length: 2.55, compression ratio: 3.53 
 
Average prefix length: 8.53, average data length: 0.47 
 
Clustering factor: 779005, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 230 
 
40 - 59% = 1511 
 
60 - 79% = 1095 
 
80 - 99% = 394 
 
 
XQS_3300_3400 (270) 
 
Primary pointer page: 776, Index root page: 777 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.10, total records: 478302 
 
Average version length: 70.08, total versions: 15075, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.03 
 
Pointer pages: 5, data page slots: 6616 
 
Data pages: 6616, average fill: 77% 
 
Primary pages: 6616, secondary pages: 0, swept pages: 3411 
 
Empty pages: 0, full pages: 6308 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 21 
 
40 - 59% = 55 
 
60 - 79% = 6137 
 
80 - 99% = 399 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 569048, depth: 3, leaf buckets: 554, nodes: 478302 
 
Average node length: 5.39, total dup: 443470, max dup: 157 
 
Average key length: 2.56, compression ratio: 3.52 
 
Average prefix length: 8.51, average data length: 0.49 
 
Clustering factor: 47507, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 77 
 
40 - 59% = 237 
 
60 - 79% = 182 
 
80 - 99% = 54 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 432522, depth: 3, leaf buckets: 604, nodes: 478302 
 
Average node length: 5.95, total dup: 405630, max dup: 29 
 
Average key length: 3.11, compression ratio: 2.89 
 
Average prefix length: 8.04, average data length: 0.96 
 
Clustering factor: 54264, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 76 
 
40 - 59% = 265 
 
60 - 79% = 189 
 
80 - 99% = 73 
 
 
ZDOC_DATA (229) 
 
Primary pointer page: 632, Index root page: 633 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZDOC_LIST (228) 
 
Primary pointer page: 630, Index root page: 631 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (230) 
 
Primary pointer page: 634, Index root page: 635 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPDISTR (233) 
 
Primary pointer page: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPDISTR_ID (0) 
 
Root page: 650, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPSTORNED (234) 
 
Primary pointer page: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPSTORNED_ID (0) 
 
Root page: 651, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQDISTR (231) 
 
Primary pointer page: 636, Index root page: 637 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_ID (0) 
 
Root page: 644, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
 
Root page: 645, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQSTORNED (232) 
 
Primary pointer page: 638, Index root page: 639 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_DOC_ID (1) 
 
Root page: 647, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_ID (0) 
 
Root page: 646, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_RCV_ID (3) 
 
Root page: 649, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_SND_ID (2) 
 
Root page: 648, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_DEP_DOCS (227) 
 
Primary pointer page: 628, Index root page: 629 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (226) 
 
Primary pointer page: 625, Index root page: 626 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Z_USED_VIEWS (146) 
 
Primary pointer page: 267, Index root page: 268 
 
Total formats: 1, used formats: 1 
 
Average record length: 29.38, total records: 29 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 99.00, compression ratio: 3.37 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 16% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index Z_USED_VIEWS_UNQ (0) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 29 
 
Average node length: 15.17, total dup: 0, max dup: 0 
 
Average key length: 14.14, compression ratio: 1.44 
 
Average prefix length: 9.17, average data length: 11.17 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Done for 74500 ms, from  8:21:25.94 to  8:22:40.44. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 1783624  | 
 44920  | 
 2.5184  | 
|  DOC_LIST  | 
 630472  | 
 27271  | 
 4.3254  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 946186  | 
   236546.5000  | 
|  INVNT_TURNOVER_LOG  | 
 253589  | 
 248183  | 
 97.8682  | 
|  MONEY_SALDO  | 
 49  | 
 53906  | 
   110012.2448  | 
|  MONEY_TURNOVER_LOG  | 
 11371  | 
 11314  | 
 99.4987  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 680655  | 
 49951  | 
 7.3386  | 
|  PERF_ESTIMATED  | 
 264748  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 9619613  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 312293  | 
 12901  | 
 4.1310  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 8544  | 
   213600.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  TRACE_STAT  | 
 2884  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 353435  | 
 349264  | 
 98.8198  | 
|  XQD_1000_3300  | 
 1552662  | 
 203543  | 
 13.1092  | 
|  XQD_1200_2000  | 
 666528  | 
 576832  | 
 86.5428  | 
|  XQD_2000_3300  | 
 2551353  | 
 599966  | 
 23.5156  | 
|  XQD_2100_3300  | 
 3574980  | 
 14183  | 
 0.3967  | 
|  XQD_3300_3400  | 
 2592860  | 
 189670  | 
 7.3150  | 
|  XQS_1000_1200  | 
 3938950  | 
 50578  | 
 1.2840  | 
|  XQS_1000_3300  | 
 1670215  | 
 100901  | 
 6.0411  | 
|  XQS_1200_2000  | 
 4456576  | 
 323413  | 
 7.2569  | 
|  XQS_2100_3300  | 
 2850578  | 
 159758  | 
 5.6044  | 
|  XQS_3300_3400  | 
 478302  | 
 15075  | 
 3.1517  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2500 ms, from  8:22:52.26 to  8:22:54.76.  
08:22:54.88 Validation started 
 
 
08:22:54.90 Relation 140 (DOC_LIST) 
 
08:22:54.90   process pointer page    0 of    5 
 
08:22:55.02   process pointer page    1 of    5 
 
08:22:55.11   process pointer page    2 of    5 
 
08:22:55.18   process pointer page    3 of    5 
 
08:22:55.22   process pointer page    4 of    5 
 
08:22:55.27 Index 1 (PK_DOC_LIST) 
 
08:22:55.50 Index 2 (DOC_LIST_ID_DESC) 
 
08:22:55.79 Index 3 (FK_DOC_LIST_AGENTS) 
 
08:22:56.05 Relation 140 (DOC_LIST) is ok 
 
 
08:22:56.05 Relation 141 (DOC_DATA) 
 
08:22:56.05   process pointer page    0 of   12 
 
08:22:56.16   process pointer page    1 of   12 
 
08:22:56.27   process pointer page    2 of   12 
 
08:22:56.38   process pointer page    3 of   12 
 
08:22:56.49   process pointer page    4 of   12 
 
08:22:56.60   process pointer page    5 of   12 
 
08:22:56.71   process pointer page    6 of   12 
 
08:22:56.81   process pointer page    7 of   12 
 
08:22:56.92   process pointer page    8 of   12 
 
08:22:57.03   process pointer page    9 of   12 
 
08:22:57.16   process pointer page   10 of   12 
 
08:22:57.27   process pointer page   11 of   12 
 
08:22:57.38 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
08:22:58.36 Index 3 (DOC_DATA_ID_DESC) 
 
08:22:59.19 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
08:22:59.90 Relation 141 (DOC_DATA) is ok 
 
 
08:22:59.90 Relation 147 (INVNT_SALDO) 
 
08:22:59.90   process pointer page    0 of    3 
 
08:23:03.12   process pointer page    1 of    3 
 
08:23:03.13   process pointer page    2 of    3 
 
08:23:03.16 Index 1 (PK_INVNT_SALDO) 
 
08:23:03.16 Relation 147 (INVNT_SALDO) is ok 
 
 
08:23:03.16 Relation 150 (PDISTR) 
 
08:23:03.16   process pointer page    0 of    3 
 
08:23:03.27   process pointer page    1 of    3 
 
08:23:03.40   process pointer page    2 of    3 
 
08:23:03.55 Index 2 (PDISTR_SND_ID) 
 
08:23:03.65 Error: Index 2 is corrupt {missing entries for record 1} 
 
08:23:03.65 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
08:23:03.76 Error: Index 3 is corrupt {missing entries for record 1} 
 
08:23:03.76 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
08:23:03.85 Error: Index 4 is corrupt {missing entries for record 1} 
 
08:23:03.85 Index 5 (PDISTR_AGENT_ID) 
 
08:23:03.94 Error: Index 5 is corrupt {missing entries for record 1} 
 
08:23:03.94 Relation 150 (PDISTR) : 4 ERRORS found 
 
 
08:23:03.94 Relation 151 (PSTORNED) 
 
08:23:03.94   process pointer page    0 of    3 
 
08:23:04.05   process pointer page    1 of    3 
 
08:23:04.16   process pointer page    2 of    3 
 
08:23:04.21 Index 2 (PSTORNED_SND_ID) 
 
08:23:04.30 Index 3 (PSTORNED_RCV_ID) 
 
08:23:04.40 Relation 151 (PSTORNED) is ok 
 
 
08:23:04.40 Relation 156 (SEMAPHORES) 
 
08:23:04.40   process pointer page    0 of    1 
 
08:23:04.41 Index 1 (PK_SEMAPHORES) 
 
08:23:04.41 Index 2 (SEMAPHORES_TASK_UNQ) 
 
08:23:04.41 Relation 156 (SEMAPHORES) is ok 
 
 
08:23:04.41 Relation 157 (INVNT_TURNOVER_LOG) 
 
08:23:04.41   process pointer page    0 of    4 
 
08:23:04.63   process pointer page    1 of    4 
 
08:23:04.77   process pointer page    2 of    4 
 
08:23:04.94   process pointer page    3 of    4 
 
08:23:05.04 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
08:23:05.22 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
08:23:05.22 Relation 160 (PERF_ESTIMATED) 
 
08:23:05.22   process pointer page    0 of    2 
 
08:23:05.32   process pointer page    1 of    2 
 
08:23:05.35 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
08:23:05.44 Relation 160 (PERF_ESTIMATED) is ok 
 
 
08:23:05.44 Relation 161 (PERF_ISQL_STAT) 
 
08:23:05.44   process pointer page    0 of    1 
 
08:23:05.44 Index 1 (PERF_ISQL_STAT_TRN) 
 
08:23:05.44 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
08:23:05.44 Relation 162 (PERF_LOG) 
 
08:23:05.44   process pointer page    0 of  138 
 
08:23:05.52   process pointer page    1 of  138 
 
08:23:05.61   process pointer page    2 of  138 
 
08:23:05.69   process pointer page    3 of  138 
 
08:23:05.78   process pointer page    4 of  138 
 
08:23:05.88   process pointer page    5 of  138 
 
08:23:05.96   process pointer page    6 of  138 
 
08:23:06.05   process pointer page    7 of  138 
 
08:23:06.13   process pointer page    8 of  138 
 
08:23:06.22   process pointer page    9 of  138 
 
08:23:06.30   process pointer page   10 of  138 
 
08:23:06.38   process pointer page   11 of  138 
 
08:23:06.46   process pointer page   12 of  138 
 
08:23:06.55   process pointer page   13 of  138 
 
08:23:06.63   process pointer page   14 of  138 
 
08:23:06.71   process pointer page   15 of  138 
 
08:23:06.78   process pointer page   16 of  138 
 
08:23:06.86   process pointer page   17 of  138 
 
08:23:06.94   process pointer page   18 of  138 
 
08:23:07.02   process pointer page   19 of  138 
 
08:23:07.10   process pointer page   20 of  138 
 
08:23:07.17   process pointer page   21 of  138 
 
08:23:07.25   process pointer page   22 of  138 
 
08:23:07.33   process pointer page   23 of  138 
 
08:23:07.41   process pointer page   24 of  138 
 
08:23:07.49   process pointer page   25 of  138 
 
08:23:07.56   process pointer page   26 of  138 
 
08:23:07.64   process pointer page   27 of  138 
 
08:23:07.73   process pointer page   28 of  138 
 
08:23:07.81   process pointer page   29 of  138 
 
08:23:07.89   process pointer page   30 of  138 
 
08:23:07.97   process pointer page   31 of  138 
 
08:23:08.05   process pointer page   32 of  138 
 
08:23:08.12   process pointer page   33 of  138 
 
08:23:08.20   process pointer page   34 of  138 
 
08:23:08.28   process pointer page   35 of  138 
 
08:23:08.37   process pointer page   36 of  138 
 
08:23:08.45   process pointer page   37 of  138 
 
08:23:08.53   process pointer page   38 of  138 
 
08:23:08.61   process pointer page   39 of  138 
 
08:23:08.69   process pointer page   40 of  138 
 
08:23:08.76   process pointer page   41 of  138 
 
08:23:08.84   process pointer page   42 of  138 
 
08:23:08.94   process pointer page   43 of  138 
 
08:23:09.01   process pointer page   44 of  138 
 
08:23:09.09   process pointer page   45 of  138 
 
08:23:09.17   process pointer page   46 of  138 
 
08:23:09.25   process pointer page   47 of  138 
 
08:23:09.33   process pointer page   48 of  138 
 
08:23:09.40   process pointer page   49 of  138 
 
08:23:09.50   process pointer page   50 of  138 
 
08:23:09.58   process pointer page   51 of  138 
 
08:23:09.65   process pointer page   52 of  138 
 
08:23:09.73   process pointer page   53 of  138 
 
08:23:09.81   process pointer page   54 of  138 
 
08:23:09.89   process pointer page   55 of  138 
 
08:23:09.98   process pointer page   56 of  138 
 
08:23:10.06   process pointer page   57 of  138 
 
08:23:10.14   process pointer page   58 of  138 
 
08:23:10.22   process pointer page   59 of  138 
 
08:23:10.30   process pointer page   60 of  138 
 
08:23:10.38   process pointer page   61 of  138 
 
08:23:10.47   process pointer page   62 of  138 
 
08:23:10.55   process pointer page   63 of  138 
 
08:23:10.63   process pointer page   64 of  138 
 
08:23:10.71   process pointer page   65 of  138 
 
08:23:10.79   process pointer page   66 of  138 
 
08:23:10.88   process pointer page   67 of  138 
 
08:23:10.96   process pointer page   68 of  138 
 
08:23:11.04   process pointer page   69 of  138 
 
08:23:11.12   process pointer page   70 of  138 
 
08:23:11.20   process pointer page   71 of  138 
 
08:23:11.28   process pointer page   72 of  138 
 
08:23:11.37   process pointer page   73 of  138 
 
08:23:11.45   process pointer page   74 of  138 
 
08:23:11.52   process pointer page   75 of  138 
 
08:23:11.60   process pointer page   76 of  138 
 
08:23:11.68   process pointer page   77 of  138 
 
08:23:11.76   process pointer page   78 of  138 
 
08:23:11.84   process pointer page   79 of  138 
 
08:23:11.93   process pointer page   80 of  138 
 
08:23:12.01   process pointer page   81 of  138 
 
08:23:12.08   process pointer page   82 of  138 
 
08:23:12.16   process pointer page   83 of  138 
 
08:23:12.24   process pointer page   84 of  138 
 
08:23:12.32   process pointer page   85 of  138 
 
08:23:12.40   process pointer page   86 of  138 
 
08:23:12.49   process pointer page   87 of  138 
 
08:23:12.57   process pointer page   88 of  138 
 
08:23:12.65   process pointer page   89 of  138 
 
08:23:12.72   process pointer page   90 of  138 
 
08:23:12.80   process pointer page   91 of  138 
 
08:23:12.88   process pointer page   92 of  138 
 
08:23:12.96   process pointer page   93 of  138 
 
08:23:13.04   process pointer page   94 of  138 
 
08:23:13.11   process pointer page   95 of  138 
 
08:23:13.19   process pointer page   96 of  138 
 
08:23:13.27   process pointer page   97 of  138 
 
08:23:13.35   process pointer page   98 of  138 
 
08:23:13.43   process pointer page   99 of  138 
 
08:23:13.50   process pointer page  100 of  138 
 
08:23:13.58   process pointer page  101 of  138 
 
08:23:13.66   process pointer page  102 of  138 
 
08:23:13.74   process pointer page  103 of  138 
 
08:23:13.82   process pointer page  104 of  138 
 
08:23:13.89   process pointer page  105 of  138 
 
08:23:13.99   process pointer page  106 of  138 
 
08:23:14.07   process pointer page  107 of  138 
 
08:23:14.14   process pointer page  108 of  138 
 
08:23:14.22   process pointer page  109 of  138 
 
08:23:14.30   process pointer page  110 of  138 
 
08:23:14.38   process pointer page  111 of  138 
 
08:23:14.46   process pointer page  112 of  138 
 
08:23:14.53   process pointer page  113 of  138 
 
08:23:14.63   process pointer page  114 of  138 
 
08:23:14.71   process pointer page  115 of  138 
 
08:23:14.78   process pointer page  116 of  138 
 
08:23:14.86   process pointer page  117 of  138 
 
08:23:14.94   process pointer page  118 of  138 
 
08:23:15.02   process pointer page  119 of  138 
 
08:23:15.11   process pointer page  120 of  138 
 
08:23:15.19   process pointer page  121 of  138 
 
08:23:15.27   process pointer page  122 of  138 
 
08:23:15.35   process pointer page  123 of  138 
 
08:23:15.42   process pointer page  124 of  138 
 
08:23:15.50   process pointer page  125 of  138 
 
08:23:15.59   process pointer page  126 of  138 
 
08:23:15.67   process pointer page  127 of  138 
 
08:23:15.75   process pointer page  128 of  138 
 
08:23:15.83   process pointer page  129 of  138 
 
08:23:15.91   process pointer page  130 of  138 
 
08:23:15.98   process pointer page  131 of  138 
 
08:23:16.06   process pointer page  132 of  138 
 
08:23:16.16   process pointer page  133 of  138 
 
08:23:16.23   process pointer page  134 of  138 
 
08:23:16.31   process pointer page  135 of  138 
 
08:23:16.39   process pointer page  136 of  138 
 
08:23:16.47   process pointer page  137 of  138 
 
08:23:16.48 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
08:23:21.35 Index 2 (PERF_LOG_UNIT) 
 
08:23:27.22 Index 3 (PERF_LOG_TRN_DESC) 
 
08:23:31.51 Index 4 (PERF_LOG_GDSCODE) 
 
08:23:33.80 Relation 162 (PERF_LOG) is ok 
 
 
08:23:33.80 Relation 166 (V_STOPTEST) 
 
08:23:33.80 Relation 166 (V_STOPTEST) is ok 
 
 
08:23:33.80 Relation 183 (V_QDISTR_SOURCE) 
 
08:23:33.80 Relation 183 (V_QDISTR_SOURCE) is ok 
 
 
08:23:33.80 Relation 184 (V_QSTORNED_SOURCE) 
 
08:23:33.80 Relation 184 (V_QSTORNED_SOURCE) is ok 
 
 
08:23:33.80 Relation 259 (XQD_1000_1200) 
 
08:23:33.80   process pointer page    0 of    5 
 
08:23:33.96   process pointer page    1 of    5 
 
08:23:34.19   process pointer page    2 of    5 
 
08:23:34.44   process pointer page    3 of    5 
 
08:23:34.58   process pointer page    4 of    5 
 
08:23:34.71 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
08:23:34.83 Relation 259 (XQD_1000_1200) is ok 
 
 
08:23:34.83 Relation 260 (XQD_1200_2000) 
 
08:23:34.83   process pointer page    0 of    8 
 
08:23:34.96   process pointer page    1 of    8 
 
08:23:35.16   process pointer page    2 of    8 
 
08:23:35.36   process pointer page    3 of    8 
 
08:23:35.58   process pointer page    4 of    8 
 
08:23:35.88   process pointer page    5 of    8 
 
08:23:36.13   process pointer page    6 of    8 
 
08:23:36.37   process pointer page    7 of    8 
 
08:23:36.47 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
08:23:36.67 Error: Index 1 is corrupt {missing entries for record 512} 
 
08:23:36.67 Relation 260 (XQD_1200_2000) : 1 ERRORS found 
 
 
08:23:36.67 Relation 261 (XQD_1000_3300) 
 
08:23:36.67   process pointer page    0 of   15 
 
08:23:36.81   process pointer page    1 of   15 
 
08:23:36.92   process pointer page    2 of   15 
 
08:23:37.05   process pointer page    3 of   15 
 
08:23:37.19   process pointer page    4 of   15 
 
08:23:37.30   process pointer page    5 of   15 
 
08:23:37.44   process pointer page    6 of   15 
 
08:23:37.59   process pointer page    7 of   15 
 
08:23:37.72   process pointer page    8 of   15 
 
08:23:37.83   process pointer page    9 of   15 
 
08:23:37.93   process pointer page   10 of   15 
 
08:23:38.04   process pointer page   11 of   15 
 
08:23:38.15   process pointer page   12 of   15 
 
08:23:38.26   process pointer page   13 of   15 
 
08:23:38.40   process pointer page   14 of   15 
 
08:23:38.47 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
08:23:39.15 Index 2 (XQD_1000_3300_DOC) 
 
08:23:39.69 Relation 261 (XQD_1000_3300) is ok 
 
 
08:23:39.69 Relation 262 (XQD_2000_3300) 
 
08:23:39.69   process pointer page    0 of   23 
 
08:23:39.83   process pointer page    1 of   23 
 
08:23:39.98   process pointer page    2 of   23 
 
08:23:40.12   process pointer page    3 of   23 
 
08:23:40.26   process pointer page    4 of   23 
 
08:23:40.41   process pointer page    5 of   23 
 
08:23:40.57   process pointer page    6 of   23 
 
08:23:40.71   process pointer page    7 of   23 
 
08:23:40.87   process pointer page    8 of   23 
 
08:23:41.01   process pointer page    9 of   23 
 
08:23:41.18   process pointer page   10 of   23 
 
08:23:41.32   process pointer page   11 of   23 
 
08:23:41.46   process pointer page   12 of   23 
 
08:23:41.60   process pointer page   13 of   23 
 
08:23:41.75   process pointer page   14 of   23 
 
08:23:41.91   process pointer page   15 of   23 
 
08:23:42.05   process pointer page   16 of   23 
 
08:23:42.19   process pointer page   17 of   23 
 
08:23:42.35   process pointer page   18 of   23 
 
08:23:42.47   process pointer page   19 of   23 
 
08:23:42.61   process pointer page   20 of   23 
 
08:23:42.74   process pointer page   21 of   23 
 
08:23:42.85   process pointer page   22 of   23 
 
08:23:42.85 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
08:23:43.69 Error: Index 1 is corrupt {missing entries for record 1921} 
 
08:23:43.69 Relation 262 (XQD_2000_3300) : 1 ERRORS found 
 
 
08:23:43.69 Relation 263 (XQD_2100_3300) 
 
08:23:43.69   process pointer page    0 of   14 
 
08:23:43.77   process pointer page    1 of   14 
 
08:23:43.86   process pointer page    2 of   14 
 
08:23:43.94   process pointer page    3 of   14 
 
08:23:44.02   process pointer page    4 of   14 
 
08:23:44.09   process pointer page    5 of   14 
 
08:23:44.17   process pointer page    6 of   14 
 
08:23:44.27   process pointer page    7 of   14 
 
08:23:44.34   process pointer page    8 of   14 
 
08:23:44.42   process pointer page    9 of   14 
 
08:23:44.50   process pointer page   10 of   14 
 
08:23:44.58   process pointer page   11 of   14 
 
08:23:44.66   process pointer page   12 of   14 
 
08:23:44.75   process pointer page   13 of   14 
 
08:23:44.81 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
08:23:44.82 Error: Index 1 is corrupt {missing entries for record 1} 
 
08:23:44.82 Relation 263 (XQD_2100_3300) : 1 ERRORS found 
 
 
08:23:44.82 Relation 264 (XQD_3300_3400) 
 
08:23:44.83   process pointer page    0 of   23 
 
08:23:44.94   process pointer page    1 of   23 
 
08:23:45.06   process pointer page    2 of   23 
 
08:23:45.19   process pointer page    3 of   23 
 
08:23:45.31   process pointer page    4 of   23 
 
08:23:45.42   process pointer page    5 of   23 
 
08:23:45.54   process pointer page    6 of   23 
 
08:23:45.66   process pointer page    7 of   23 
 
08:23:45.78   process pointer page    8 of   23 
 
08:23:45.88   process pointer page    9 of   23 
 
08:23:46.01   process pointer page   10 of   23 
 
08:23:46.12   process pointer page   11 of   23 
 
08:23:46.24   process pointer page   12 of   23 
 
08:23:46.35   process pointer page   13 of   23 
 
08:23:46.47   process pointer page   14 of   23 
 
08:23:46.60   process pointer page   15 of   23 
 
08:23:46.71   process pointer page   16 of   23 
 
08:23:46.83   process pointer page   17 of   23 
 
08:23:46.96   process pointer page   18 of   23 
 
08:23:47.08   process pointer page   19 of   23 
 
08:23:47.19   process pointer page   20 of   23 
 
08:23:47.32   process pointer page   21 of   23 
 
08:23:47.43   process pointer page   22 of   23 
 
08:23:47.43 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
08:23:48.47 Error: Index 1 is corrupt {missing entries for record 1451} 
 
08:23:48.47 Relation 264 (XQD_3300_3400) : 1 ERRORS found 
 
 
08:23:48.47 Relation 265 (XQS_1000_1200) 
 
08:23:48.47   process pointer page    0 of   38 
 
08:23:48.58   process pointer page    1 of   38 
 
08:23:48.69   process pointer page    2 of   38 
 
08:23:48.78   process pointer page    3 of   38 
 
08:23:48.89   process pointer page    4 of   38 
 
08:23:49.00   process pointer page    5 of   38 
 
08:23:49.11   process pointer page    6 of   38 
 
08:23:49.20   process pointer page    7 of   38 
 
08:23:49.31   process pointer page    8 of   38 
 
08:23:49.42   process pointer page    9 of   38 
 
08:23:49.53   process pointer page   10 of   38 
 
08:23:49.64   process pointer page   11 of   38 
 
08:23:49.74   process pointer page   12 of   38 
 
08:23:49.84   process pointer page   13 of   38 
 
08:23:49.95   process pointer page   14 of   38 
 
08:23:50.06   process pointer page   15 of   38 
 
08:23:50.17   process pointer page   16 of   38 
 
08:23:50.27   process pointer page   17 of   38 
 
08:23:50.37   process pointer page   18 of   38 
 
08:23:50.48   process pointer page   19 of   38 
 
08:23:50.59   process pointer page   20 of   38 
 
08:23:50.69   process pointer page   21 of   38 
 
08:23:50.80   process pointer page   22 of   38 
 
08:23:50.91   process pointer page   23 of   38 
 
08:23:51.01   process pointer page   24 of   38 
 
08:23:51.12   process pointer page   25 of   38 
 
08:23:51.22   process pointer page   26 of   38 
 
08:23:51.33   process pointer page   27 of   38 
 
08:23:51.44   process pointer page   28 of   38 
 
08:23:51.54   process pointer page   29 of   38 
 
08:23:51.65   process pointer page   30 of   38 
 
08:23:51.75   process pointer page   31 of   38 
 
08:23:51.86   process pointer page   32 of   38 
 
08:23:51.97   process pointer page   33 of   38 
 
08:23:52.08   process pointer page   34 of   38 
 
08:23:52.18   process pointer page   35 of   38 
 
08:23:52.29   process pointer page   36 of   38 
 
08:23:52.39   process pointer page   37 of   38 
 
08:23:52.43 Index 1 (XQS_1000_1200_DOC_ID) 
 
08:23:53.67 Index 2 (XQS_1000_1200_SND_ID) 
 
08:23:54.99 Index 3 (XQS_1000_1200_RCV_ID) 
 
08:23:56.19 Relation 265 (XQS_1000_1200) is ok 
 
 
08:23:56.19 Relation 266 (XQS_1200_2000) 
 
08:23:56.19   process pointer page    0 of   44 
 
08:23:56.30   process pointer page    1 of   44 
 
08:23:56.41   process pointer page    2 of   44 
 
08:23:56.51   process pointer page    3 of   44 
 
08:23:56.61   process pointer page    4 of   44 
 
08:23:56.71   process pointer page    5 of   44 
 
08:23:56.82   process pointer page    6 of   44 
 
08:23:56.91   process pointer page    7 of   44 
 
08:23:57.02   process pointer page    8 of   44 
 
08:23:57.13   process pointer page    9 of   44 
 
08:23:57.25   process pointer page   10 of   44 
 
08:23:57.36   process pointer page   11 of   44 
 
08:23:57.47   process pointer page   12 of   44 
 
08:23:57.60   process pointer page   13 of   44 
 
08:23:57.71   process pointer page   14 of   44 
 
08:23:57.83   process pointer page   15 of   44 
 
08:23:57.94   process pointer page   16 of   44 
 
08:23:58.07   process pointer page   17 of   44 
 
08:23:58.17   process pointer page   18 of   44 
 
08:23:58.30   process pointer page   19 of   44 
 
08:23:58.41   process pointer page   20 of   44 
 
08:23:58.53   process pointer page   21 of   44 
 
08:23:58.64   process pointer page   22 of   44 
 
08:23:58.77   process pointer page   23 of   44 
 
08:23:58.89   process pointer page   24 of   44 
 
08:23:59.02   process pointer page   25 of   44 
 
08:23:59.13   process pointer page   26 of   44 
 
08:23:59.24   process pointer page   27 of   44 
 
08:23:59.36   process pointer page   28 of   44 
 
08:23:59.49   process pointer page   29 of   44 
 
08:23:59.61   process pointer page   30 of   44 
 
08:23:59.72   process pointer page   31 of   44 
 
08:23:59.84   process pointer page   32 of   44 
 
08:23:59.98   process pointer page   33 of   44 
 
08:24:00.11   process pointer page   34 of   44 
 
08:24:00.23   process pointer page   35 of   44 
 
08:24:00.34   process pointer page   36 of   44 
 
08:24:00.47   process pointer page   37 of   44 
 
08:24:00.59   process pointer page   38 of   44 
 
08:24:00.70   process pointer page   39 of   44 
 
08:24:00.84   process pointer page   40 of   44 
 
08:24:00.97   process pointer page   41 of   44 
 
08:24:01.08   process pointer page   42 of   44 
 
08:24:01.20   process pointer page   43 of   44 
 
08:24:01.26 Index 1 (XQS_1200_2000_DOC_ID) 
 
08:24:02.96 Index 2 (XQS_1200_2000_SND_ID) 
 
08:24:04.76 Index 3 (XQS_1200_2000_RCV_ID) 
 
08:24:06.24 Relation 266 (XQS_1200_2000) is ok 
 
 
08:24:06.24 Relation 267 (XQS_1000_3300) 
 
08:24:06.24   process pointer page    0 of   17 
 
08:24:06.35   process pointer page    1 of   17 
 
08:24:06.46   process pointer page    2 of   17 
 
08:24:06.58   process pointer page    3 of   17 
 
08:24:06.69   process pointer page    4 of   17 
 
08:24:06.80   process pointer page    5 of   17 
 
08:24:06.91   process pointer page    6 of   17 
 
08:24:07.02   process pointer page    7 of   17 
 
08:24:07.14   process pointer page    8 of   17 
 
08:24:07.25   process pointer page    9 of   17 
 
08:24:07.36   process pointer page   10 of   17 
 
08:24:07.49   process pointer page   11 of   17 
 
08:24:07.60   process pointer page   12 of   17 
 
08:24:07.72   process pointer page   13 of   17 
 
08:24:07.85   process pointer page   14 of   17 
 
08:24:07.96   process pointer page   15 of   17 
 
08:24:08.07   process pointer page   16 of   17 
 
08:24:08.08 Index 1 (XQS_1000_3300_DOC_ID) 
 
08:24:08.55 Index 2 (XQS_1000_3300_SND_ID) 
 
08:24:09.20 Index 3 (XQS_1000_3300_RCV_ID) 
 
08:24:09.75 Relation 267 (XQS_1000_3300) is ok 
 
 
08:24:09.75 Relation 268 (XQS_2000_3300) 
 
08:24:09.75   process pointer page    0 of    1 
 
08:24:09.75 Index 1 (XQS_2000_3300_DOC_ID) 
 
08:24:09.75 Index 2 (XQS_2000_3300_SND_ID) 
 
08:24:09.75 Index 3 (XQS_2000_3300_RCV_ID) 
 
08:24:09.75 Relation 268 (XQS_2000_3300) is ok 
 
 
08:24:09.75 Relation 269 (XQS_2100_3300) 
 
08:24:09.75   process pointer page    0 of   28 
 
08:24:09.86   process pointer page    1 of   28 
 
08:24:09.97   process pointer page    2 of   28 
 
08:24:10.08   process pointer page    3 of   28 
 
08:24:10.20   process pointer page    4 of   28 
 
08:24:10.31   process pointer page    5 of   28 
 
08:24:10.43   process pointer page    6 of   28 
 
08:24:10.54   process pointer page    7 of   28 
 
08:24:10.65   process pointer page    8 of   28 
 
08:24:10.76   process pointer page    9 of   28 
 
08:24:10.87   process pointer page   10 of   28 
 
08:24:10.97   process pointer page   11 of   28 
 
08:24:11.08   process pointer page   12 of   28 
 
08:24:11.19   process pointer page   13 of   28 
 
08:24:11.30   process pointer page   14 of   28 
 
08:24:11.43   process pointer page   15 of   28 
 
08:24:11.54   process pointer page   16 of   28 
 
08:24:11.65   process pointer page   17 of   28 
 
08:24:11.75   process pointer page   18 of   28 
 
08:24:11.88   process pointer page   19 of   28 
 
08:24:11.99   process pointer page   20 of   28 
 
08:24:12.11   process pointer page   21 of   28 
 
08:24:12.22   process pointer page   22 of   28 
 
08:24:12.33   process pointer page   23 of   28 
 
08:24:12.47   process pointer page   24 of   28 
 
08:24:12.58   process pointer page   25 of   28 
 
08:24:12.71   process pointer page   26 of   28 
 
08:24:12.82   process pointer page   27 of   28 
 
08:24:12.89 Index 1 (XQS_2100_3300_DOC_ID) 
 
08:24:13.95 Index 2 (XQS_2100_3300_SND_ID) 
 
08:24:15.06 Index 3 (XQS_2100_3300_RCV_ID) 
 
08:24:16.06 Relation 269 (XQS_2100_3300) is ok 
 
 
08:24:16.06 Relation 270 (XQS_3300_3400) 
 
08:24:16.06   process pointer page    0 of    5 
 
08:24:16.17   process pointer page    1 of    5 
 
08:24:16.28   process pointer page    2 of    5 
 
08:24:16.39   process pointer page    3 of    5 
 
08:24:16.50   process pointer page    4 of    5 
 
08:24:16.50 Index 1 (XQS_3300_3400_DOC_ID) 
 
08:24:16.64 Index 2 (XQS_3300_3400_SND_ID) 
 
08:24:16.79 Relation 270 (XQS_3300_3400) is ok 
 
 
08:24:16.79 Relation 276 (TRACE_STAT) 
 
08:24:16.79   process pointer page    0 of    1 
 
08:24:16.79 Relation 276 (TRACE_STAT) is ok 
 
 
08:24:16.79 Validation finished 
 
Done for 82020 ms, from  8:22:54.79 to  8:24:16.81. 
 
 Differences between old and current firebird.log 
8:24:17.99. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 53 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2016-03-15  08:24              1861 oltp40_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Tue Mar 15 08:22:54 2016 
 
7:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Tue Mar 15 08:23:03 2016 
 
12:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
13:          Error: Index 2 is corrupt {missing entries for record 1} in table PDISTR (150) 
 
14:   
 
15:   
 
16:  WIN-2BE1UI8LGDL Tue Mar 15 08:23:03 2016 
 
17:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
18:          Error: Index 3 is corrupt {missing entries for record 1} in table PDISTR (150) 
 
19:   
 
20:   
 
21:  WIN-2BE1UI8LGDL Tue Mar 15 08:23:03 2016 
 
22:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
23:          Error: Index 4 is corrupt {missing entries for record 1} in table PDISTR (150) 
 
24:   
 
25:   
 
26:  WIN-2BE1UI8LGDL Tue Mar 15 08:23:03 2016 
 
27:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
28:          Error: Index 5 is corrupt {missing entries for record 1} in table PDISTR (150) 
 
29:   
 
30:   
 
31:  WIN-2BE1UI8LGDL Tue Mar 15 08:23:36 2016 
 
32:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
33:          Error: Index 1 is corrupt {missing entries for record 512} in table XQD_1200_2000 (260) 
 
34:   
 
35:   
 
36:  WIN-2BE1UI8LGDL Tue Mar 15 08:23:43 2016 
 
37:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
38:          Error: Index 1 is corrupt {missing entries for record 1921} in table XQD_2000_3300 (262) 
 
39:   
 
40:   
 
41:  WIN-2BE1UI8LGDL Tue Mar 15 08:23:44 2016 
 
42:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
43:          Error: Index 1 is corrupt {missing entries for record 1} in table XQD_2100_3300 (263) 
 
44:   
 
45:   
 
46:  WIN-2BE1UI8LGDL Tue Mar 15 08:23:48 2016 
 
47:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
48:          Error: Index 1 is corrupt {missing entries for record 1451} in table XQD_3300_3400 (264) 
 
49:   
 
50:   
 
51:  WIN-2BE1UI8LGDL Tue Mar 15 08:24:16 2016 
 
52:          Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB 
 
53:          Validation finished: 8 errors, 0 warnings, 0 fixed 
 
54:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 302 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*: 
 
 
|  ERRORS_CHECKING_RESULT  | 
|  NO_SEVERE_ERRORS_FOUND  | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2016-03-15  8:24:29.31 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html