Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-12-03  6:49:08.73.
 
Server version: WI-V3.0.3.32848 Firebird 3.0
 
Server implementation: Firebird/Windows/AMD/Intel/x64 
 
|  FB_ARCHITECTURE  | 
 DB_NAME  | 
 FORCED_WRITES  | 
 SWEEP_INT  | 
 PAGE_BUFFERS  | 
 PAGE_SIZE  | 
|  SuperServer 3.0.3  | 
 D:\OLTP-EMUL\OLTP30-SMALL.FDB  | 
 ON  | 
 0  | 
 786432  | 
 8192  | 
 
 Test configuration settings 
 
File: E:\OLTP-EMUL\src\oltp30_config.win 
 
|  PARAM_NAME  | 
 PARAM_VALUE  | 
|  fbc  | 
 E:\FB30.TMPINSTANCE  | 
|  dbnm  | 
 D:\OLTP-EMUL\oltp30-small.fdb  | 
|  host  | 
 localhost  | 
|  port  | 
 3333  | 
|  usr  | 
 SYSDBA  | 
|  pwd  | 
 masterkey  | 
|  tmpdir  | 
 e:\temp\logs.oltp30  | 
|  working_mode  | 
 small_03  | 
|  warm_time  | 
 0  | 
|  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  | 
 100000  | 
|  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  | 
 cpu_8x3Ghz_ram_16gb  | 
|  upload_report  | 
 1  | 
|  max_snapshots_to_store  | 
 720  | 
|  replace_instance  | 
 1  | 
|  etalon_dbnm  | 
 E:\OLTP-EMUL\oltp30-docs_100000-fw__ON.fdb  | 
|  used_in_replication  | 
 0  | 
 
 
 
|  FINISH_STATE  | 
 DTS_END  | 
 FB_GDSCODE  | 
 FB_MNEMONA  | 
 STACK  | 
 IP  | 
 TRN_ID  | 
 ATT_ID  | 
 EXC_UNIT  | 
|  NORMAL: TEST_TIME EXPIRED.  | 
 2017-12-03 06:46:39.4410  | 
 -1  | 
 <null>  | 
   | 
 ::1/54192  | 
 448151  | 
 9398  | 
 2  | 
 
 
 
|  CATEGORY  | 
 SETTING  | 
 VAL  | 
|  COMMON  | 
 TRACED_UNITS  | 
 ,,  | 
|  COMMON  | 
 ENABLE_MON_QUERY  | 
 0  | 
|  COMMON  | 
 HALT_TEST_ON_ERRORS  | 
 ,CK,  | 
|  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  | 
|  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:  | 
 6975.27  | 
 1333  | 
 1255549  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  customer order: creation  | 
 465.42  | 
 205  | 
 83776  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  customer order: refuse  | 
 37.60  | 
 106  | 
 6768  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  order to supplier: creation  | 
 119.39  | 
 810  | 
 21491  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  order to supplier: removal  | 
 3.27  | 
 9225  | 
 589  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  invoice (draft): creation  | 
 119.00  | 
 1170  | 
 21420  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  invoice (draft): removal  | 
 47.08  | 
 173  | 
 8474  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  invoice accept: apply  | 
 69.14  | 
 4144  | 
 12446  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  invoice accept: cancel  | 
 22.98  | 
 962  | 
 4114  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  customer reserve: creation  | 
 3975.12  | 
 58  | 
 715522  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  customer reserve: removal  | 
 1466.48  | 
 23  | 
 263967  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  realization accept: apply  | 
 213.53  | 
 248  | 
 38436  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  realization accept: cancel  | 
 105.38  | 
 64  | 
 18968  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  payment from customer: creation  | 
 153.92  | 
 360  | 
 27705  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  payment from customer: removal  | 
 14.64  | 
 59  | 
 2635  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  payment to supplier: creation  | 
 128.15  | 
 257  | 
 23067  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  payment to supplier: removal  | 
 9.34  | 
 64  | 
 1663  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  service: total inventory turnovers  | 
 11.66  | 
 991  | 
 2098  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  service: total monetary turnovers  | 
 13.32  | 
 35  | 
 2398  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  service: refresh index statistics  | 
 0.07  | 
 6368  | 
 12  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
 
Done for 82200 ms, from  6:51:14.51 to  6:52:36.71.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 5145  | 
 107126  | 
 92614  | 
 14512  | 
 13.55  | 
 03:46:40  | 
 04:04:40  | 
|  interval #   2, overall  | 
 2  | 
 6697  | 
 136478  | 
 120550  | 
 15928  | 
 11.67  | 
 04:04:41  | 
 04:22:41  | 
|  interval #   3, overall  | 
 3  | 
 6996  | 
 144001  | 
 125933  | 
 18068  | 
 12.55  | 
 04:22:42  | 
 04:40:42  | 
|  interval #   4, overall  | 
 4  | 
 6690  | 
 146475  | 
 120418  | 
 26057  | 
 17.79  | 
 04:40:43  | 
 04:58:43  | 
|  interval #   5, overall  | 
 5  | 
 7309  | 
 155826  | 
 131560  | 
 24266  | 
 15.57  | 
 04:58:44  | 
 05:16:44  | 
|  interval #   6, overall  | 
 6  | 
 7834  | 
 166292  | 
 141016  | 
 25276  | 
 15.20  | 
 05:16:45  | 
 05:34:45  | 
|  interval #   7, overall  | 
 7  | 
 7620  | 
 160114  | 
 137168  | 
 22946  | 
 14.33  | 
 05:34:46  | 
 05:52:46  | 
|  interval #   8, overall  | 
 8  | 
 7489  | 
 155253  | 
 134805  | 
 20448  | 
 13.17  | 
 05:52:47  | 
 06:10:47  | 
|  interval #   9, overall  | 
 9  | 
 6962  | 
 147901  | 
 125319  | 
 22582  | 
 15.27  | 
 06:10:48  | 
 06:28:48  | 
|  interval #  10, overall  | 
 10  | 
 7009  | 
 148963  | 
 126166  | 
 22797  | 
 15.30  | 
 06:28:49  | 
 06:46:49  | 
 
Done for 229070 ms, from  6:56:15.34 to  7:00:04.41.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 2358.05  | 
 0.0979  | 
 1.7281  | 
 1860  | 
 99  | 
|  TEST_TIME  | 
 2  | 
 2932.20  | 
 0.6948  | 
 1.3414  | 
 1780  | 
 99  | 
|  TEST_TIME  | 
 3  | 
 3330.46  | 
 0.7875  | 
 1.1982  | 
 1411  | 
 99  | 
|  TEST_TIME  | 
 4  | 
 3581.15  | 
 0.8359  | 
 1.1347  | 
 1853  | 
 99  | 
|  TEST_TIME  | 
 5  | 
 3655.42  | 
 0.8895  | 
 1.1267  | 
 1725  | 
 99  | 
|  TEST_TIME  | 
 6  | 
 3820.25  | 
 0.8985  | 
 1.0882  | 
 1672  | 
 99  | 
|  TEST_TIME  | 
 7  | 
 3929.66  | 
 0.9099  | 
 1.0934  | 
 1971  | 
 99  | 
|  TEST_TIME  | 
 8  | 
 4195.18  | 
 0.8966  | 
 1.0832  | 
 1953  | 
 99  | 
|  TEST_TIME  | 
 9  | 
 4333.24  | 
 0.9323  | 
 1.0806  | 
 1766  | 
 99  | 
|  TEST_TIME  | 
 10  | 
 4561.95  | 
 0.9238  | 
 1.0701  | 
 1830  | 
 99  | 
|  TEST_TIME  | 
 11  | 
 4730.36  | 
 0.9398  | 
 1.0625  | 
 1778  | 
 99  | 
|  TEST_TIME  | 
 12  | 
 4835.12  | 
 0.9534  | 
 1.0564  | 
 1692  | 
 99  | 
|  TEST_TIME  | 
 13  | 
 4939.53  | 
 0.9546  | 
 1.0403  | 
 1649  | 
 99  | 
|  TEST_TIME  | 
 14  | 
 4959.15  | 
 0.9623  | 
 1.0180  | 
 1656  | 
 99  | 
|  TEST_TIME  | 
 15  | 
 4948.25  | 
 0.9523  | 
 1.0390  | 
 1549  | 
 99  | 
|  TEST_TIME  | 
 16  | 
 5020.83  | 
 0.9600  | 
 1.0442  | 
 2206  | 
 99  | 
|  TEST_TIME  | 
 17  | 
 5116.58  | 
 0.9646  | 
 1.0235  | 
 1669  | 
 99  | 
|  TEST_TIME  | 
 18  | 
 5094.35  | 
 0.9708  | 
 1.0323  | 
 1757  | 
 99  | 
|  TEST_TIME  | 
 19  | 
 5180.52  | 
 0.9617  | 
 1.0414  | 
 2213  | 
 99  | 
|  TEST_TIME  | 
 20  | 
 5333.86  | 
 0.9618  | 
 1.0324  | 
 1990  | 
 99  | 
|  TEST_TIME  | 
 21  | 
 5425.42  | 
 0.9666  | 
 1.0330  | 
 1878  | 
 99  | 
|  TEST_TIME  | 
 22  | 
 5521.85  | 
 0.9688  | 
 1.0356  | 
 1905  | 
 99  | 
|  TEST_TIME  | 
 23  | 
 5617.55  | 
 0.9737  | 
 1.0262  | 
 1804  | 
 99  | 
|  TEST_TIME  | 
 24  | 
 5670.96  | 
 0.9742  | 
 1.0286  | 
 1603  | 
 99  | 
|  TEST_TIME  | 
 25  | 
 5733.01  | 
 0.9768  | 
 1.0217  | 
 1391  | 
 99  | 
|  TEST_TIME  | 
 26  | 
 5762.80  | 
 0.9773  | 
 1.0238  | 
 1523  | 
 99  | 
|  TEST_TIME  | 
 27  | 
 5787.12  | 
 0.9818  | 
 1.0203  | 
 1485  | 
 99  | 
|  TEST_TIME  | 
 28  | 
 5795.06  | 
 0.9826  | 
 1.0158  | 
 1408  | 
 99  | 
|  TEST_TIME  | 
 29  | 
 5798.78  | 
 0.9801  | 
 1.0215  | 
 1420  | 
 99  | 
|  TEST_TIME  | 
 30  | 
 5837.03  | 
 0.9810  | 
 1.0182  | 
 1269  | 
 99  | 
|  TEST_TIME  | 
 31  | 
 5886.54  | 
 0.9771  | 
 1.0193  | 
 2199  | 
 99  | 
|  TEST_TIME  | 
 32  | 
 5899.95  | 
 0.9852  | 
 1.0172  | 
 2058  | 
 96  | 
|  TEST_TIME  | 
 33  | 
 5981.54  | 
 0.9729  | 
 1.0177  | 
 1274  | 
 99  | 
|  TEST_TIME  | 
 34  | 
 5989.59  | 
 0.9865  | 
 1.0191  | 
 1555  | 
 99  | 
|  TEST_TIME  | 
 35  | 
 5968.38  | 
 0.9935  | 
 1.0060  | 
 1146  | 
 98  | 
|  TEST_TIME  | 
 36  | 
 5898.25  | 
 0.9902  | 
 1.0055  | 
 1254  | 
 99  | 
|  TEST_TIME  | 
 37  | 
 5848.50  | 
 0.9866  | 
 1.0152  | 
 1353  | 
 99  | 
|  TEST_TIME  | 
 38  | 
 5879.05  | 
 0.9834  | 
 1.0146  | 
 1535  | 
 99  | 
|  TEST_TIME  | 
 39  | 
 5892.54  | 
 0.9863  | 
 1.0111  | 
 1615  | 
 99  | 
|  TEST_TIME  | 
 40  | 
 5898.53  | 
 0.9848  | 
 1.0144  | 
 1349  | 
 99  | 
|  TEST_TIME  | 
 41  | 
 5915.62  | 
 0.9868  | 
 1.0116  | 
 1364  | 
 99  | 
|  TEST_TIME  | 
 42  | 
 5952.28  | 
 0.9814  | 
 1.0115  | 
 1264  | 
 99  | 
|  TEST_TIME  | 
 43  | 
 5952.78  | 
 0.9879  | 
 1.0113  | 
 1144  | 
 99  | 
|  TEST_TIME  | 
 44  | 
 5954.19  | 
 0.9885  | 
 1.0141  | 
 1247  | 
 99  | 
|  TEST_TIME  | 
 45  | 
 5976.37  | 
 0.9885  | 
 1.0102  | 
 1519  | 
 99  | 
|  TEST_TIME  | 
 46  | 
 6016.36  | 
 0.9817  | 
 1.0210  | 
 2337  | 
 99  | 
|  TEST_TIME  | 
 47  | 
 6105.14  | 
 0.9847  | 
 1.0177  | 
 2127  | 
 99  | 
|  TEST_TIME  | 
 48  | 
 6180.62  | 
 0.9844  | 
 1.0139  | 
 2185  | 
 99  | 
|  TEST_TIME  | 
 49  | 
 6226.36  | 
 0.9859  | 
 1.0116  | 
 2058  | 
 99  | 
|  TEST_TIME  | 
 50  | 
 6255.84  | 
 0.9869  | 
 1.0156  | 
 2076  | 
 99  | 
|  TEST_TIME  | 
 51  | 
 6301.04  | 
 0.9885  | 
 1.0063  | 
 1723  | 
 99  | 
|  TEST_TIME  | 
 52  | 
 6265.03  | 
 0.9927  | 
 1.0131  | 
 1584  | 
 98  | 
|  TEST_TIME  | 
 53  | 
 6265.58  | 
 0.9947  | 
 1.0096  | 
 1348  | 
 99  | 
|  TEST_TIME  | 
 54  | 
 6259.90  | 
 0.9918  | 
 1.0071  | 
 1329  | 
 99  | 
|  TEST_TIME  | 
 55  | 
 6250.58  | 
 0.9902  | 
 1.0067  | 
 1447  | 
 99  | 
|  TEST_TIME  | 
 56  | 
 6261.02  | 
 0.9871  | 
 1.0068  | 
 1315  | 
 99  | 
|  TEST_TIME  | 
 57  | 
 6250.33  | 
 0.9914  | 
 1.0089  | 
 1345  | 
 99  | 
|  TEST_TIME  | 
 58  | 
 6245.66  | 
 0.9922  | 
 1.0070  | 
 1569  | 
 99  | 
|  TEST_TIME  | 
 59  | 
 6231.96  | 
 0.9921  | 
 1.0071  | 
 1210  | 
 99  | 
|  TEST_TIME  | 
 60  | 
 6216.79  | 
 0.9927  | 
 1.0085  | 
 1314  | 
 99  | 
|  TEST_TIME  | 
 61  | 
 6236.66  | 
 0.9888  | 
 1.0118  | 
 2114  | 
 99  | 
|  TEST_TIME  | 
 62  | 
 6286.60  | 
 0.9879  | 
 1.0124  | 
 2206  | 
 99  | 
|  TEST_TIME  | 
 63  | 
 6329.05  | 
 0.9897  | 
 1.0103  | 
 2021  | 
 99  | 
|  TEST_TIME  | 
 64  | 
 6357.70  | 
 0.9900  | 
 1.0105  | 
 2036  | 
 99  | 
|  TEST_TIME  | 
 65  | 
 6381.43  | 
 0.9913  | 
 1.0093  | 
 1760  | 
 99  | 
|  TEST_TIME  | 
 66  | 
 6402.40  | 
 0.9912  | 
 1.0118  | 
 1726  | 
 99  | 
|  TEST_TIME  | 
 67  | 
 6429.61  | 
 0.9925  | 
 1.0077  | 
 1371  | 
 99  | 
|  TEST_TIME  | 
 68  | 
 6432.32  | 
 0.9925  | 
 1.0093  | 
 1475  | 
 99  | 
|  TEST_TIME  | 
 69  | 
 6435.49  | 
 0.9942  | 
 1.0037  | 
 1608  | 
 99  | 
|  TEST_TIME  | 
 70  | 
 6405.21  | 
 0.9940  | 
 1.0054  | 
 1345  | 
 98  | 
|  TEST_TIME  | 
 71  | 
 6397.31  | 
 0.9925  | 
 1.0024  | 
 896  | 
 98  | 
|  TEST_TIME  | 
 72  | 
 6368.80  | 
 0.9954  | 
 1.0036  | 
 932  | 
 99  | 
|  TEST_TIME  | 
 73  | 
 6344.18  | 
 0.9937  | 
 1.0057  | 
 1173  | 
 99  | 
|  TEST_TIME  | 
 74  | 
 6328.09  | 
 0.9946  | 
 1.0085  | 
 1127  | 
 99  | 
|  TEST_TIME  | 
 75  | 
 6325.91  | 
 0.9955  | 
 1.0088  | 
 1162  | 
 99  | 
|  TEST_TIME  | 
 76  | 
 6357.05  | 
 0.9907  | 
 1.0074  | 
 1738  | 
 99  | 
|  TEST_TIME  | 
 77  | 
 6392.30  | 
 0.9914  | 
 1.0096  | 
 2095  | 
 99  | 
|  TEST_TIME  | 
 78  | 
 6428.33  | 
 0.9911  | 
 1.0109  | 
 1919  | 
 99  | 
|  TEST_TIME  | 
 79  | 
 6473.82  | 
 0.9911  | 
 1.0069  | 
 1849  | 
 99  | 
|  TEST_TIME  | 
 80  | 
 6494.59  | 
 0.9912  | 
 1.0083  | 
 1710  | 
 99  | 
|  TEST_TIME  | 
 81  | 
 6503.72  | 
 0.9945  | 
 1.0071  | 
 1667  | 
 99  | 
|  TEST_TIME  | 
 82  | 
 6515.84  | 
 0.9929  | 
 1.0098  | 
 1500  | 
 99  | 
|  TEST_TIME  | 
 83  | 
 6550.12  | 
 0.9924  | 
 1.0074  | 
 1386  | 
 99  | 
|  TEST_TIME  | 
 84  | 
 6570.86  | 
 0.9923  | 
 1.0087  | 
 1380  | 
 99  | 
|  TEST_TIME  | 
 85  | 
 6579.91  | 
 0.9958  | 
 1.0052  | 
 1280  | 
 98  | 
|  TEST_TIME  | 
 86  | 
 6570.90  | 
 0.9948  | 
 1.0056  | 
 1325  | 
 99  | 
|  TEST_TIME  | 
 87  | 
 6557.83  | 
 0.9960  | 
 1.0041  | 
 1222  | 
 99  | 
|  TEST_TIME  | 
 88  | 
 6541.16  | 
 0.9953  | 
 1.0055  | 
 1356  | 
 99  | 
|  TEST_TIME  | 
 89  | 
 6545.30  | 
 0.9936  | 
 1.0059  | 
 1264  | 
 99  | 
|  TEST_TIME  | 
 90  | 
 6546.81  | 
 0.9945  | 
 1.0046  | 
 1205  | 
 99  | 
|  TEST_TIME  | 
 91  | 
 6532.37  | 
 0.9958  | 
 1.0068  | 
 1505  | 
 99  | 
|  TEST_TIME  | 
 92  | 
 6545.97  | 
 0.9939  | 
 1.0059  | 
 1964  | 
 99  | 
|  TEST_TIME  | 
 93  | 
 6569.75  | 
 0.9915  | 
 1.0059  | 
 1627  | 
 99  | 
|  TEST_TIME  | 
 94  | 
 6574.22  | 
 0.9945  | 
 1.0054  | 
 1766  | 
 99  | 
|  TEST_TIME  | 
 95  | 
 6576.58  | 
 0.9947  | 
 1.0061  | 
 1904  | 
 99  | 
|  TEST_TIME  | 
 96  | 
 6597.39  | 
 0.9925  | 
 1.0062  | 
 1753  | 
 99  | 
|  TEST_TIME  | 
 97  | 
 6617.62  | 
 0.9928  | 
 1.0081  | 
 1558  | 
 99  | 
|  TEST_TIME  | 
 98  | 
 6638.98  | 
 0.9946  | 
 1.0055  | 
 1738  | 
 99  | 
|  TEST_TIME  | 
 99  | 
 6653.11  | 
 0.9932  | 
 1.0063  | 
 1417  | 
 99  | 
|  TEST_TIME  | 
 100  | 
 6667.16  | 
 0.9941  | 
 1.0052  | 
 1471  | 
 99  | 
|  TEST_TIME  | 
 101  | 
 6663.27  | 
 0.9959  | 
 1.0044  | 
 1544  | 
 99  | 
|  TEST_TIME  | 
 102  | 
 6669.07  | 
 0.9937  | 
 1.0071  | 
 1319  | 
 99  | 
|  TEST_TIME  | 
 103  | 
 6680.50  | 
 0.9956  | 
 1.0044  | 
 1376  | 
 99  | 
|  TEST_TIME  | 
 104  | 
 6677.89  | 
 0.9951  | 
 1.0064  | 
 1307  | 
 99  | 
|  TEST_TIME  | 
 105  | 
 6685.87  | 
 0.9956  | 
 1.0055  | 
 1239  | 
 99  | 
|  TEST_TIME  | 
 106  | 
 6707.65  | 
 0.9928  | 
 1.0088  | 
 1851  | 
 99  | 
|  TEST_TIME  | 
 107  | 
 6744.75  | 
 0.9939  | 
 1.0071  | 
 1624  | 
 99  | 
|  TEST_TIME  | 
 108  | 
 6763.13  | 
 0.9950  | 
 1.0030  | 
 1815  | 
 99  | 
|  TEST_TIME  | 
 109  | 
 6742.54  | 
 0.9969  | 
 1.0044  | 
 1863  | 
 93  | 
|  TEST_TIME  | 
 110  | 
 6755.07  | 
 0.9934  | 
 1.0057  | 
 1401  | 
 98  | 
|  TEST_TIME  | 
 111  | 
 6752.96  | 
 0.9969  | 
 1.0019  | 
 1528  | 
 99  | 
|  TEST_TIME  | 
 112  | 
 6745.48  | 
 0.9941  | 
 1.0036  | 
 1151  | 
 99  | 
|  TEST_TIME  | 
 113  | 
 6756.20  | 
 0.9957  | 
 1.0048  | 
 1332  | 
 99  | 
|  TEST_TIME  | 
 114  | 
 6771.06  | 
 0.9950  | 
 1.0040  | 
 1441  | 
 99  | 
|  TEST_TIME  | 
 115  | 
 6768.67  | 
 0.9956  | 
 1.0038  | 
 1542  | 
 99  | 
|  TEST_TIME  | 
 116  | 
 6761.71  | 
 0.9963  | 
 1.0038  | 
 1219  | 
 99  | 
|  TEST_TIME  | 
 117  | 
 6765.22  | 
 0.9947  | 
 1.0036  | 
 1235  | 
 99  | 
|  TEST_TIME  | 
 118  | 
 6759.53  | 
 0.9960  | 
 1.0040  | 
 1307  | 
 99  | 
|  TEST_TIME  | 
 119  | 
 6755.75  | 
 0.9962  | 
 1.0035  | 
 1282  | 
 99  | 
|  TEST_TIME  | 
 120  | 
 6749.48  | 
 0.9961  | 
 1.0030  | 
 1245  | 
 99  | 
|  TEST_TIME  | 
 121  | 
 6753.58  | 
 0.9941  | 
 1.0055  | 
 1909  | 
 99  | 
|  TEST_TIME  | 
 122  | 
 6786.00  | 
 0.9925  | 
 1.0048  | 
 1958  | 
 99  | 
|  TEST_TIME  | 
 123  | 
 6802.14  | 
 0.9943  | 
 1.0069  | 
 1750  | 
 99  | 
|  TEST_TIME  | 
 124  | 
 6826.69  | 
 0.9952  | 
 1.0075  | 
 1639  | 
 99  | 
|  TEST_TIME  | 
 125  | 
 6853.02  | 
 0.9956  | 
 1.0052  | 
 1584  | 
 99  | 
|  TEST_TIME  | 
 126  | 
 6879.00  | 
 0.9935  | 
 1.0052  | 
 1528  | 
 99  | 
|  TEST_TIME  | 
 127  | 
 6890.59  | 
 0.9956  | 
 1.0051  | 
 1487  | 
 99  | 
|  TEST_TIME  | 
 128  | 
 6898.67  | 
 0.9961  | 
 1.0030  | 
 1497  | 
 99  | 
|  TEST_TIME  | 
 129  | 
 6895.97  | 
 0.9956  | 
 1.0029  | 
 1358  | 
 99  | 
|  TEST_TIME  | 
 130  | 
 6886.64  | 
 0.9965  | 
 1.0031  | 
 1194  | 
 99  | 
|  TEST_TIME  | 
 131  | 
 6877.85  | 
 0.9968  | 
 1.0031  | 
 1204  | 
 99  | 
|  TEST_TIME  | 
 132  | 
 6868.68  | 
 0.9968  | 
 1.0026  | 
 1210  | 
 98  | 
|  TEST_TIME  | 
 133  | 
 6860.44  | 
 0.9962  | 
 1.0030  | 
 1036  | 
 99  | 
|  TEST_TIME  | 
 134  | 
 6857.04  | 
 0.9960  | 
 1.0032  | 
 1140  | 
 99  | 
|  TEST_TIME  | 
 135  | 
 6844.67  | 
 0.9975  | 
 1.0027  | 
 1093  | 
 99  | 
|  TEST_TIME  | 
 136  | 
 6838.16  | 
 0.9963  | 
 1.0049  | 
 1939  | 
 99  | 
|  TEST_TIME  | 
 137  | 
 6866.37  | 
 0.9935  | 
 1.0041  | 
 2037  | 
 99  | 
|  TEST_TIME  | 
 138  | 
 6881.31  | 
 0.9947  | 
 1.0046  | 
 1914  | 
 99  | 
|  TEST_TIME  | 
 139  | 
 6880.39  | 
 0.9975  | 
 1.0056  | 
 1837  | 
 99  | 
|  TEST_TIME  | 
 140  | 
 6888.89  | 
 0.9972  | 
 1.0043  | 
 1762  | 
 99  | 
|  TEST_TIME  | 
 141  | 
 6896.54  | 
 0.9961  | 
 1.0057  | 
 1562  | 
 99  | 
|  TEST_TIME  | 
 142  | 
 6915.13  | 
 0.9959  | 
 1.0064  | 
 1520  | 
 99  | 
|  TEST_TIME  | 
 143  | 
 6936.44  | 
 0.9963  | 
 1.0048  | 
 1443  | 
 99  | 
|  TEST_TIME  | 
 144  | 
 6947.98  | 
 0.9962  | 
 1.0049  | 
 1459  | 
 99  | 
|  TEST_TIME  | 
 145  | 
 6955.75  | 
 0.9969  | 
 1.0026  | 
 1411  | 
 99  | 
|  TEST_TIME  | 
 146  | 
 6958.92  | 
 0.9953  | 
 1.0036  | 
 1346  | 
 99  | 
|  TEST_TIME  | 
 147  | 
 6972.03  | 
 0.9950  | 
 1.0035  | 
 1287  | 
 99  | 
|  TEST_TIME  | 
 148  | 
 6970.45  | 
 0.9970  | 
 1.0026  | 
 1331  | 
 99  | 
|  TEST_TIME  | 
 149  | 
 6950.98  | 
 0.9987  | 
 1.0009  | 
 1408  | 
 98  | 
|  TEST_TIME  | 
 150  | 
 6930.26  | 
 0.9972  | 
 1.0027  | 
 1125  | 
 95  | 
|  TEST_TIME  | 
 151  | 
 6939.43  | 
 0.9948  | 
 1.0035  | 
 1302  | 
 99  | 
|  TEST_TIME  | 
 152  | 
 6946.76  | 
 0.9958  | 
 1.0039  | 
 1434  | 
 99  | 
|  TEST_TIME  | 
 153  | 
 6944.62  | 
 0.9977  | 
 1.0027  | 
 1749  | 
 89  | 
|  TEST_TIME  | 
 154  | 
 6945.82  | 
 0.9960  | 
 1.0040  | 
 1707  | 
 75  | 
|  TEST_TIME  | 
 155  | 
 6954.64  | 
 0.9964  | 
 1.0035  | 
 1523  | 
 60  | 
|  TEST_TIME  | 
 156  | 
 6952.93  | 
 0.9973  | 
 1.0024  | 
 1003  | 
 82  | 
|  TEST_TIME  | 
 157  | 
 6946.23  | 
 0.9970  | 
 1.0039  | 
 1420  | 
 99  | 
|  TEST_TIME  | 
 158  | 
 6947.56  | 
 0.9973  | 
 1.0026  | 
 1567  | 
 99  | 
|  TEST_TIME  | 
 159  | 
 6951.36  | 
 0.9958  | 
 1.0041  | 
 1369  | 
 99  | 
|  TEST_TIME  | 
 160  | 
 6953.94  | 
 0.9975  | 
 1.0025  | 
 1247  | 
 99  | 
|  TEST_TIME  | 
 161  | 
 6952.01  | 
 0.9966  | 
 1.0026  | 
 1294  | 
 99  | 
|  TEST_TIME  | 
 162  | 
 6948.19  | 
 0.9970  | 
 1.0043  | 
 1319  | 
 99  | 
|  TEST_TIME  | 
 163  | 
 6955.42  | 
 0.9971  | 
 1.0027  | 
 1196  | 
 99  | 
|  TEST_TIME  | 
 164  | 
 6955.92  | 
 0.9966  | 
 1.0036  | 
 1198  | 
 99  | 
|  TEST_TIME  | 
 165  | 
 6958.14  | 
 0.9972  | 
 1.0041  | 
 1227  | 
 99  | 
|  TEST_TIME  | 
 166  | 
 6972.07  | 
 0.9961  | 
 1.0041  | 
 1675  | 
 99  | 
|  TEST_TIME  | 
 167  | 
 6985.71  | 
 0.9962  | 
 1.0042  | 
 1699  | 
 99  | 
|  TEST_TIME  | 
 168  | 
 6994.17  | 
 0.9970  | 
 1.0032  | 
 1562  | 
 99  | 
|  TEST_TIME  | 
 169  | 
 7010.73  | 
 0.9949  | 
 1.0026  | 
 1362  | 
 99  | 
|  TEST_TIME  | 
 170  | 
 7011.70  | 
 0.9967  | 
 1.0032  | 
 1446  | 
 99  | 
|  TEST_TIME  | 
 171  | 
 7013.34  | 
 0.9971  | 
 1.0029  | 
 1437  | 
 99  | 
|  TEST_TIME  | 
 172  | 
 7018.22  | 
 0.9963  | 
 1.0011  | 
 1478  | 
 96  | 
|  TEST_TIME  | 
 173  | 
 7013.88  | 
 0.9959  | 
 1.0023  | 
 1126  | 
 98  | 
|  TEST_TIME  | 
 174  | 
 7013.49  | 
 0.9966  | 
 1.0023  | 
 1327  | 
 99  | 
|  TEST_TIME  | 
 175  | 
 7007.38  | 
 0.9974  | 
 1.0022  | 
 1362  | 
 99  | 
|  TEST_TIME  | 
 176  | 
 6991.34  | 
 0.9988  | 
 1.0017  | 
 1311  | 
 91  | 
|  TEST_TIME  | 
 177  | 
 6975.96  | 
 0.9982  | 
 1.0046  | 
 1092  | 
 97  | 
|  TEST_TIME  | 
 178  | 
 6985.34  | 
 0.9976  | 
 1.0017  | 
 1084  | 
 98  | 
|  TEST_TIME  | 
 179  | 
 6977.31  | 
 0.9972  | 
 1.0022  | 
 1064  | 
 99  | 
|  TEST_TIME  | 
 180  | 
 6964.15  | 
 0.9985  | 
 1.0015  | 
 732  | 
 99  | 
 
Done for 10330 ms, from  7:00:05.13 to  7:00:15.46.  
 
 
|  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  | 
 68222  | 
 89246  | 
 55483  | 
 114476  | 
 70114  | 
 71392  | 
 62194  | 
 78403  | 
 64893  | 
 20561  | 
 104989  | 
 71885  | 
 88216  | 
 94262  | 
 134745  | 
 53558  | 
 121162  | 
 398875  | 
 <null>  | 
 03:46:40  | 
 04:04:40  | 
|  fetches per second  | 
 2  | 
 62029  | 
 108367  | 
 54644  | 
 91876  | 
 68263  | 
 90614  | 
 77595  | 
 4728  | 
 73319  | 
 104981  | 
 56752  | 
 47140  | 
 98315  | 
 144193  | 
 154920  | 
 <null>  | 
 143183  | 
 324948  | 
 <null>  | 
 04:04:41  | 
 04:22:41  | 
|  fetches per second  | 
 3  | 
 60413  | 
 93851  | 
 42523  | 
 <null>  | 
 48938  | 
 112376  | 
 82687  | 
 86679  | 
 39020  | 
 <null>  | 
 69736  | 
 41976  | 
 125262  | 
 <null>  | 
 126276  | 
 6406  | 
 172630  | 
 579055  | 
 <null>  | 
 04:22:42  | 
 04:40:42  | 
|  fetches per second  | 
 4  | 
 58506  | 
 70737  | 
 39647  | 
 <null>  | 
 48393  | 
 3746  | 
 92128  | 
 102088  | 
 103748  | 
 75358  | 
 79802  | 
 102190  | 
 96293  | 
 109085  | 
 124380  | 
 <null>  | 
 103326  | 
 425742  | 
 <null>  | 
 04:40:43  | 
 04:58:43  | 
|  fetches per second  | 
 5  | 
 58908  | 
 117531  | 
 60993  | 
 <null>  | 
 40196  | 
 59623  | 
 77549  | 
 <null>  | 
 52739  | 
 94764  | 
 104416  | 
 74390  | 
 100426  | 
 <null>  | 
 155501  | 
 112423  | 
 292786  | 
 324392  | 
 <null>  | 
 04:58:44  | 
 05:16:44  | 
|  fetches per second  | 
 6  | 
 65773  | 
 72214  | 
 31978  | 
 83505  | 
 73004  | 
 56686  | 
 92818  | 
 121412  | 
 22181  | 
 4853  | 
 67641  | 
 31547  | 
 100211  | 
 180428  | 
 120803  | 
 22392  | 
 <null>  | 
 450194  | 
 <null>  | 
 05:16:45  | 
 05:34:45  | 
|  fetches per second  | 
 7  | 
 51608  | 
 78178  | 
 33795  | 
 <null>  | 
 50737  | 
 57492  | 
 67516  | 
 <null>  | 
 63738  | 
 154866  | 
 59260  | 
 24130  | 
 69814  | 
 75845  | 
 115381  | 
 <null>  | 
 189333  | 
 124587  | 
 <null>  | 
 05:34:46  | 
 05:52:46  | 
|  fetches per second  | 
 8  | 
 48946  | 
 116878  | 
 47338  | 
 6440  | 
 49380  | 
 68545  | 
 78746  | 
 66381  | 
 69679  | 
 42733  | 
 67216  | 
 19249  | 
 89638  | 
 95131  | 
 54781  | 
 <null>  | 
 110751  | 
 226272  | 
 <null>  | 
 05:52:47  | 
 06:10:47  | 
|  fetches per second  | 
 9  | 
 40808  | 
 54227  | 
 37037  | 
 <null>  | 
 51964  | 
 5648  | 
 44372  | 
 <null>  | 
 5632  | 
 2486  | 
 62506  | 
 9116  | 
 80768  | 
 <null>  | 
 114369  | 
 19072  | 
 <null>  | 
 36165  | 
 <null>  | 
 06:10:48  | 
 06:28:48  | 
|  fetches per second  | 
 10  | 
 39494  | 
 120127  | 
 35987  | 
 25199  | 
 43513  | 
 54349  | 
 49110  | 
 <null>  | 
 42192  | 
 63972  | 
 70059  | 
 45294  | 
 70244  | 
 95626  | 
 85759  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 06:28:49  | 
 06:46:49  | 
|  marks per second  | 
 1  | 
 14556  | 
 11452  | 
 12322  | 
 20653  | 
 15851  | 
 13156  | 
 8266  | 
 14937  | 
 6376  | 
 4450  | 
 15020  | 
 11741  | 
 7313  | 
 18492  | 
 5586  | 
 7607  | 
 16593  | 
 58375  | 
 <null>  | 
 03:46:40  | 
 04:04:40  | 
|  marks per second  | 
 2  | 
 12361  | 
 14296  | 
 11656  | 
 17533  | 
 15596  | 
 20526  | 
 9924  | 
 790  | 
 11888  | 
 16634  | 
 9008  | 
 7730  | 
 7782  | 
 26952  | 
 7084  | 
 <null>  | 
 16396  | 
 13875  | 
 <null>  | 
 04:04:41  | 
 04:22:41  | 
|  marks per second  | 
 3  | 
 12657  | 
 11559  | 
 9448  | 
 <null>  | 
 10940  | 
 28173  | 
 9359  | 
 13441  | 
 5483  | 
 <null>  | 
 9184  | 
 6739  | 
 7584  | 
 <null>  | 
 7009  | 
 1073  | 
 21303  | 
 56805  | 
 <null>  | 
 04:22:42  | 
 04:40:42  | 
|  marks per second  | 
 4  | 
 11794  | 
 9967  | 
 8439  | 
 <null>  | 
 10680  | 
 790  | 
 11275  | 
 14739  | 
 13016  | 
 12292  | 
 9163  | 
 28150  | 
 5247  | 
 25144  | 
 9598  | 
 <null>  | 
 18431  | 
 27491  | 
 <null>  | 
 04:40:43  | 
 04:58:43  | 
|  marks per second  | 
 5  | 
 12577  | 
 14727  | 
 13388  | 
 <null>  | 
 8876  | 
 13053  | 
 9915  | 
 <null>  | 
 6850  | 
 20257  | 
 14292  | 
 10205  | 
 5534  | 
 <null>  | 
 10950  | 
 22430  | 
 13017  | 
 20700  | 
 <null>  | 
 04:58:44  | 
 05:16:44  | 
|  marks per second  | 
 6  | 
 13587  | 
 9996  | 
 7186  | 
 13120  | 
 14841  | 
 14156  | 
 11863  | 
 16930  | 
 2795  | 
 896  | 
 8278  | 
 4904  | 
 4840  | 
 15857  | 
 14059  | 
 5156  | 
 <null>  | 
 39098  | 
 <null>  | 
 05:16:45  | 
 05:34:45  | 
|  marks per second  | 
 7  | 
 10575  | 
 8288  | 
 7110  | 
 <null>  | 
 10738  | 
 13367  | 
 8511  | 
 <null>  | 
 6142  | 
 22750  | 
 6954  | 
 4141  | 
 3213  | 
 13921  | 
 13402  | 
 <null>  | 
 25966  | 
 2495  | 
 <null>  | 
 05:34:46  | 
 05:52:46  | 
|  marks per second  | 
 8  | 
 10335  | 
 16564  | 
 10323  | 
 1245  | 
 11027  | 
 13853  | 
 9979  | 
 9682  | 
 9626  | 
 6432  | 
 8285  | 
 2978  | 
 3633  | 
 20102  | 
 9123  | 
 <null>  | 
 8717  | 
 20680  | 
 <null>  | 
 05:52:47  | 
 06:10:47  | 
|  marks per second  | 
 9  | 
 8634  | 
 6202  | 
 7823  | 
 <null>  | 
 11202  | 
 1138  | 
 4912  | 
 <null>  | 
 695  | 
 408  | 
 6537  | 
 1400  | 
 3927  | 
 <null>  | 
 16095  | 
 2826  | 
 <null>  | 
 1959  | 
 <null>  | 
 06:10:48  | 
 06:28:48  | 
|  marks per second  | 
 10  | 
 8358  | 
 14337  | 
 7775  | 
 4993  | 
 9439  | 
 14575  | 
 5748  | 
 <null>  | 
 3195  | 
 9500  | 
 5571  | 
 8684  | 
 3190  | 
 14054  | 
 13601  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 06:28:49  | 
 06:46:49  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 03:46:40  | 
 04:04:40  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:04:41  | 
 04:22:41  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:22:42  | 
 04:40:42  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:40:43  | 
 04:58:43  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:58:44  | 
 05:16:44  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:16:45  | 
 05:34:45  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 05:34:46  | 
 05:52:46  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 05:52:47  | 
 06:10:47  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:10:48  | 
 06:28:48  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 06:28:49  | 
 06:46:49  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 10  | 
 0  | 
 <null>  | 
 03:46:40  | 
 04:04:40  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 <null>  | 
 04:04:41  | 
 04:22:41  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 04:22:42  | 
 04:40:42  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 2  | 
 0  | 
 <null>  | 
 04:40:43  | 
 04:58:43  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 04:58:44  | 
 05:16:44  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:16:45  | 
 05:34:45  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 2  | 
 <null>  | 
 05:34:46  | 
 05:52:46  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 3  | 
 0  | 
 <null>  | 
 05:52:47  | 
 06:10:47  | 
|  writes/marks*100  | 
 9  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 <null>  | 
 06:10:48  | 
 06:28:48  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 06:28:49  | 
 06:46:49  | 
 
Done for 9420 ms, from  7:00:16.41 to  7:00:25.83.  
 
 
|  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  | 
 2219104  | 
 2017526  | 
 201578  | 
 9.08  | 
 0  | 
 7082  | 
 17  | 
 201578  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  doc_list_biud  | 
 2219554  | 
 2017526  | 
 202028  | 
 9.10  | 
 0  | 
 5725  | 
 6  | 
 202028  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_add_invoice_to_stock  | 
 20053  | 
 12446  | 
 7607  | 
 37.93  | 
 15  | 
 98920  | 
 4144  | 
 7607  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_cancel_adding_invoice  | 
 5351  | 
 4114  | 
 1237  | 
 23.11  | 
 0  | 
 38751  | 
 962  | 
 1237  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_cancel_client_order  | 
 6907  | 
 6768  | 
 139  | 
 2.01  | 
 0  | 
 3479  | 
 106  | 
 139  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_cancel_customer_reserve  | 
 454707  | 
 263967  | 
 190740  | 
 41.94  | 
 0  | 
 3276  | 
 23  | 
 190740  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_cancel_pay_from_customer  | 
 2643  | 
 2635  | 
 8  | 
 0.30  | 
 0  | 
 1654  | 
 59  | 
 8  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_cancel_pay_to_supplier  | 
 1670  | 
 1663  | 
 7  | 
 0.41  | 
 0  | 
 2278  | 
 64  | 
 7  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_cancel_supplier_invoice  | 
 10953  | 
 8474  | 
 2479  | 
 22.63  | 
 0  | 
 6723  | 
 173  | 
 2479  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_cancel_supplier_order  | 
 1589  | 
 589  | 
 1000  | 
 62.93  | 
 16  | 
 134005  | 
 9225  | 
 1000  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_cancel_write_off  | 
 27196  | 
 18968  | 
 8228  | 
 30.25  | 
 0  | 
 4228  | 
 64  | 
 8228  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_client_order  | 
 83776  | 
 83776  | 
 0  | 
 0.00  | 
 0  | 
 5569  | 
 205  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_customer_reserve  | 
 715522  | 
 715522  | 
 0  | 
 0.00  | 
 0  | 
 5319  | 
 58  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_fill_shopping_cart  | 
 127013  | 
 126687  | 
 326  | 
 0.25  | 
 0  | 
 5101  | 
 41  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_fill_shopping_cart_clo_res  | 
 715522  | 
 715522  | 
 0  | 
 0.00  | 
 0  | 
 1435  | 
 4  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_get_clo_for_invoice  | 
 12446  | 
 12446  | 
 0  | 
 0.00  | 
 0  | 
 4134  | 
 128  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_kill_cost_storno  | 
 36493  | 
 27380  | 
 9113  | 
 24.97  | 
 0  | 
 1748  | 
 9  | 
 9113  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 947230  | 
 555965  | 
 391265  | 
 41.30  | 
 0  | 
 5523  | 
 8  | 
 391265  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_kill_qty_storno  | 
 555716  | 
 353762  | 
 201954  | 
 36.34  | 
 0  | 
 5709  | 
 27  | 
 201954  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_lock_selected_doc  | 
 82307  | 
 71521  | 
 10786  | 
 13.10  | 
 0  | 
 1045  | 
 3  | 
 10786  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_make_cost_storno  | 
 101654  | 
 101654  | 
 0  | 
 0.00  | 
 0  | 
 5850  | 
 166  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_multiply_rows_for_pdistr  | 
 101654  | 
 101654  | 
 0  | 
 0.00  | 
 0  | 
 2621  | 
 27  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_multiply_rows_for_qdistr  | 
 83776  | 
 83776  | 
 0  | 
 0.00  | 
 0  | 
 3167  | 
 68  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_pay_from_customer  | 
 27705  | 
 27705  | 
 0  | 
 0.00  | 
 0  | 
 7581  | 
 360  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_pay_to_supplier  | 
 23067  | 
 23067  | 
 0  | 
 0.00  | 
 0  | 
 5819  | 
 257  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_payment_common  | 
 50772  | 
 50772  | 
 0  | 
 0.00  | 
 0  | 
 1747  | 
 30  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_qd_handle_on_cancel_clo  | 
 6902  | 
 6768  | 
 134  | 
 1.94  | 
 0  | 
 2824  | 
 47  | 
 134  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 17651  | 
 16560  | 
 1091  | 
 6.18  | 
 0  | 
 5709  | 
 149  | 
 1091  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 38436  | 
 38436  | 
 0  | 
 0.00  | 
 0  | 
 3261  | 
 23  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_reserve_write_off  | 
 39545  | 
 38436  | 
 1109  | 
 2.80  | 
 0  | 
 5834  | 
 248  | 
 1109  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_supplier_invoice  | 
 21548  | 
 21420  | 
 128  | 
 0.59  | 
 0  | 
 22651  | 
 1170  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  sp_supplier_order  | 
 21689  | 
 21491  | 
 198  | 
 0.91  | 
 0  | 
 12916  | 
 810  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  srv_find_qd_qs_mism  | 
 1359668  | 
 1158109  | 
 201559  | 
 14.82  | 
 0  | 
 4181  | 
 8  | 
 201559  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  srv_make_invnt_saldo  | 
 2098  | 
 2098  | 
 0  | 
 0.00  | 
 15  | 
 17113  | 
 991  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  srv_make_money_saldo  | 
 2398  | 
 2398  | 
 0  | 
 0.00  | 
 0  | 
 2387  | 
 35  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 2012  | 
 34398  | 
 6368  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 7607  | 
 7607  | 
 0  | 
 0.00  | 
 0  | 
 1809  | 
 39  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 612  | 
 612  | 
 0  | 
 0.00  | 
 0  | 
 1248  | 
 64  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_cancel_client_order  | 
 139  | 
 139  | 
 0  | 
 0.00  | 
 0  | 
 1497  | 
 57  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 82  | 
 82  | 
 0  | 
 0.00  | 
 0  | 
 328  | 
 17  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 8  | 
 8  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 2  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 7  | 
 7  | 
 0  | 
 0.00  | 
 0  | 
 453  | 
 93  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 595  | 
 595  | 
 0  | 
 0.00  | 
 0  | 
 858  | 
 39  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 22941  | 
 22941  | 
 0  | 
 0.00  | 
 0  | 
 2995  | 
 36  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_cancel_write_off  | 
 26  | 
 26  | 
 0  | 
 0.00  | 
 0  | 
 250  | 
 19  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1109  | 
 1109  | 
 0  | 
 0.00  | 
 0  | 
 2090  | 
 28  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_supplier_invoice  | 
 128  | 
 128  | 
 0  | 
 0.00  | 
 0  | 
 312  | 
 20  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-abend:sp_supplier_order  | 
 198  | 
 198  | 
 0  | 
 0.00  | 
 0  | 
 1045  | 
 39  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 12446  | 
 12446  | 
 0  | 
 0.00  | 
 0  | 
 10233  | 
 259  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1410  | 
 1410  | 
 0  | 
 0.00  | 
 0  | 
 6927  | 
 275  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6768  | 
 6768  | 
 0  | 
 0.00  | 
 0  | 
 2278  | 
 31  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2668  | 
 2668  | 
 0  | 
 0.00  | 
 0  | 
 2262  | 
 32  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2635  | 
 2635  | 
 0  | 
 0.00  | 
 0  | 
 2387  | 
 23  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1663  | 
 1663  | 
 0  | 
 0.00  | 
 0  | 
 1372  | 
 25  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 1007  | 
 1007  | 
 0  | 
 0.00  | 
 0  | 
 1216  | 
 26  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 589  | 
 589  | 
 0  | 
 0.00  | 
 0  | 
 34539  | 
 985  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3899  | 
 3899  | 
 0  | 
 0.00  | 
 0  | 
 1872  | 
 33  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_client_order  | 
 83776  | 
 83776  | 
 0  | 
 0.00  | 
 0  | 
 2637  | 
 35  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_customer_reserve  | 
 3968  | 
 3968  | 
 0  | 
 0.00  | 
 0  | 
 2324  | 
 25  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_pay_from_customer  | 
 27705  | 
 27705  | 
 0  | 
 0.00  | 
 0  | 
 1981  | 
 30  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 23067  | 
 23067  | 
 0  | 
 0.00  | 
 0  | 
 2262  | 
 27  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_reserve_write_off  | 
 38436  | 
 38436  | 
 0  | 
 0.00  | 
 0  | 
 2450  | 
 34  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_supplier_invoice  | 
 21420  | 
 21420  | 
 0  | 
 0.00  | 
 0  | 
 2278  | 
 29  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:sp_supplier_order  | 
 21491  | 
 21491  | 
 0  | 
 0.00  | 
 0  | 
 2528  | 
 28  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 2098  | 
 2098  | 
 0  | 
 0.00  | 
 0  | 
 920  | 
 9  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:srv_make_money_saldo  | 
 2398  | 
 2398  | 
 0  | 
 0.00  | 
 0  | 
 858  | 
 14  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 156  | 
 19  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_add_invoice_to_stock  | 
 40106  | 
 24892  | 
 15214  | 
 37.93  | 
 0  | 
 1592  | 
 6  | 
 15214  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_all_customers  | 
 125560  | 
 125560  | 
 0  | 
 0.00  | 
 0  | 
 858  | 
 2  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_all_suppliers  | 
 87370  | 
 86718  | 
 652  | 
 0.74  | 
 0  | 
 1248  | 
 2  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_all_wares  | 
 167552  | 
 167552  | 
 0  | 
 0.00  | 
 0  | 
 593  | 
 2  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_cancel_adding_invoice  | 
 3246  | 
 2820  | 
 426  | 
 13.12  | 
 0  | 
 2402  | 
 62  | 
 426  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_cancel_client_order  | 
 13814  | 
 13536  | 
 278  | 
 2.01  | 
 0  | 
 1107  | 
 3  | 
 278  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_cancel_customer_prepayment  | 
 5286  | 
 5270  | 
 16  | 
 0.30  | 
 0  | 
 499  | 
 3  | 
 16  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_cancel_customer_reserve  | 
 5500  | 
 5336  | 
 164  | 
 2.98  | 
 0  | 
 453  | 
 3  | 
 164  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_cancel_payment_to_supplier  | 
 3340  | 
 3326  | 
 14  | 
 0.41  | 
 0  | 
 1342  | 
 4  | 
 14  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_cancel_supplier_invoice  | 
 3204  | 
 2014  | 
 1190  | 
 37.14  | 
 0  | 
 999  | 
 7  | 
 1190  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_cancel_supplier_order  | 
 3178  | 
 1178  | 
 2000  | 
 62.93  | 
 0  | 
 327  | 
 4  | 
 2000  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_cancel_write_off  | 
 7850  | 
 7798  | 
 52  | 
 0.66  | 
 0  | 
 3416  | 
 50  | 
 52  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_max_id_clo_ord  | 
 21689  | 
 21491  | 
 198  | 
 0.91  | 
 0  | 
 515  | 
 2  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_max_id_clo_res  | 
 3968  | 
 3968  | 
 0  | 
 0.00  | 
 0  | 
 624  | 
 7  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_max_id_ord_sup  | 
 21548  | 
 21420  | 
 128  | 
 0.59  | 
 0  | 
 671  | 
 2  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_max_non_paid_invoice  | 
 22619  | 
 22619  | 
 0  | 
 0.00  | 
 0  | 
 484  | 
 3  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_max_non_paid_realizn  | 
 27705  | 
 27705  | 
 0  | 
 0.00  | 
 0  | 
 686  | 
 3  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_min_id_clo_ord  | 
 21689  | 
 21491  | 
 198  | 
 0.91  | 
 0  | 
 749  | 
 3  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_min_id_clo_res  | 
 3968  | 
 3968  | 
 0  | 
 0.00  | 
 0  | 
 1201  | 
 5  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_min_id_ord_sup  | 
 21548  | 
 21420  | 
 128  | 
 0.59  | 
 0  | 
 843  | 
 3  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_min_non_paid_invoice  | 
 23067  | 
 23067  | 
 0  | 
 0.00  | 
 0  | 
 1513  | 
 5  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_min_non_paid_realizn  | 
 27705  | 
 27705  | 
 0  | 
 0.00  | 
 0  | 
 1591  | 
 4  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_our_firm  | 
 41992  | 
 41992  | 
 0  | 
 0.00  | 
 0  | 
 749  | 
 3  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  v_reserve_write_off  | 
 79090  | 
 76872  | 
 2218  | 
 2.80  | 
 0  | 
 1373  | 
 4  | 
 2218  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  x_lock_depdocs_on_canc_invoice  | 
 22254  | 
 11581  | 
 10673  | 
 47.95  | 
 0  | 
 1513  | 
 13  | 
 10673  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1589  | 
 589  | 
 1000  | 
 62.93  | 
 0  | 
 811  | 
 25  | 
 1000  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  x_make_qstorno_1000_1200  | 
 21689  | 
 21491  | 
 198  | 
 0.91  | 
 0  | 
 12277  | 
 716  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  x_make_qstorno_1200_2000  | 
 21548  | 
 21420  | 
 128  | 
 0.59  | 
 0  | 
 22199  | 
 1073  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  x_make_qstorno_2100_3300  | 
 715522  | 
 715522  | 
 0  | 
 0.00  | 
 0  | 
 5304  | 
 49  | 
 0  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
 
Done for 316850 ms, from  7:05:34.90 to  7:10:51.75.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 80  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2017-12-03 03:47  | 
 2017-12-03 06:43  | 
|  deadlock  | 
 83  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2017-12-03 03:47  | 
 2017-12-03 06:45  | 
|  deadlock  | 
 9436  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  deadlock  | 
 134  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2017-12-03 03:47  | 
 2017-12-03 06:45  | 
|  deadlock  | 
 205  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2017-12-03 03:47  | 
 2017-12-03 06:46  | 
|  deadlock  | 
 635  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2017-12-03 03:46  | 
 2017-12-03 06:46  | 
|  deadlock  | 
 206  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2017-12-03 03:49  | 
 2017-12-03 06:45  | 
|  user_exc  | 
 198  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2017-12-03 03:47  | 
 2017-12-03 06:46  | 
|  user_exc  | 
 128  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2017-12-03 03:47  | 
 2017-12-03 06:46  | 
 
Done for 9150 ms, from  7:10:59.22 to  7:11:08.37.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          448961
 
MON$OLDEST_ACTIVE               448962
 
MON$OLDEST_SNAPSHOT             448962
 
MON$NEXT_TRANSACTION            448962
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2017-01-11 15:12:20.4040
 
MON$PAGES                       869088
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.3.32848 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32848 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32848 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32848 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Gstat execution time Sun Dec 03 07:11:08 2017 
 
 
Database header page information: 
 
Flags			0 
 
Generation		449095 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	448963 
 
Oldest active		448964 
 
Oldest snapshot		448964 
 
Next transaction	448965 
 
Sequence number		0 
 
Next attachment ID	9563 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Jan 11, 2017 15:12:20 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file 
 
 
Analyzing database pages ... 
 
AGENTS (154) 
 
Primary pointer page: 311, Index root page: 312 
 
Total formats: 1, used formats: 1 
 
Average record length: 33.58, total records: 50 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 344.00, compression ratio: 10.24 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 31% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_ID_DESC (2) 
 
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_OUR_FIRM (4) 
 
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 48 
 
Average key length: 2.04, compression ratio: 0.50 
 
Average prefix length: 0.96, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_SUPPLIER (3) 
 
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 44 
 
Average key length: 2.04, compression ratio: 0.54 
 
Average prefix length: 1.04, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_NAME_UNQ (1) 
 
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.16, total dup: 0, max dup: 0 
 
Average key length: 15.86, compression ratio: 0.92 
 
Average prefix length: 1.44, average data length: 13.16 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_AGENTS (0) 
 
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
BUSINESS_OPS (158) 
 
Primary pointer page: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 107.00, total records: 19 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1236.00, compression ratio: 11.55 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 29% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BO_UNIT_UNQ (1) 
 
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 18.00, total dup: 0, max dup: 0 
 
Average key length: 16.95, compression ratio: 1.25 
 
Average prefix length: 7.21, average data length: 14.00 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BUSINESS_OPS_RND_WGTH (2) 
 
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 4.05, total dup: 7, max dup: 3 
 
Average key length: 3.00, compression ratio: 0.75 
 
Average prefix length: 1.42, average data length: 0.84 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RDB$1 (0) 
 
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 5.26, total dup: 0, max dup: 0 
 
Average key length: 4.21, compression ratio: 0.64 
 
Average prefix length: 1.05, average data length: 1.63 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
DOC_DATA (141) 
 
Primary pointer page: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.14, total records: 2199699 
 
Average version length: 47.94, total versions: 1692, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.36 
 
Pointer pages: 15, data page slots: 23800 
 
Data pages: 23800, average fill: 73% 
 
Primary pages: 23800, secondary pages: 0, swept pages: 14999 
 
Empty pages: 0, full pages: 22074 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 16 
 
40 - 59% = 98 
 
60 - 79% = 23677 
 
80 - 99% = 8 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10882, nodes: 2199699 
 
Average node length: 19.38, total dup: 0, max dup: 0 
 
Average key length: 16.42, compression ratio: 1.64 
 
Average prefix length: 13.57, average data length: 13.43 
 
Clustering factor: 350397, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 916 
 
20 - 39% = 2942 
 
40 - 59% = 4094 
 
60 - 79% = 1174 
 
80 - 99% = 1756 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7903, nodes: 2199699 
 
Average node length: 11.63, total dup: 0, max dup: 0 
 
Average key length: 8.67, compression ratio: 1.04 
 
Average prefix length: 3.32, average data length: 5.68 
 
Clustering factor: 348316, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 3820 
 
40 - 59% = 3926 
 
60 - 79% = 139 
 
80 - 99% = 15 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 176500, depth: 3, leaf buckets: 3741, nodes: 2199699 
 
Average node length: 6.86, total dup: 1588368, max dup: 49 
 
Average key length: 3.90, compression ratio: 2.31 
 
Average prefix length: 7.37, average data length: 1.63 
 
Clustering factor: 314112, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 158 
 
20 - 39% = 1273 
 
40 - 59% = 1225 
 
60 - 79% = 448 
 
80 - 99% = 637 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.47, total records: 678304 
 
Average version length: 35.56, total versions: 1016, max versions: 3 
 
Average fragment length: 40.70, total fragments: 20, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 6, data page slots: 8584 
 
Data pages: 8584, average fill: 75% 
 
Primary pages: 8576, secondary pages: 8, swept pages: 7976 
 
Empty pages: 6, full pages: 8215 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 11 
 
40 - 59% = 32 
 
60 - 79% = 8505 
 
80 - 99% = 18 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 248327, depth: 3, leaf buckets: 2477, nodes: 678304 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.80, compression ratio: 1.02 
 
Average prefix length: 3.19, average data length: 5.81 
 
Clustering factor: 155405, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1314 
 
40 - 59% = 1094 
 
60 - 79% = 66 
 
80 - 99% = 3 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 708, nodes: 678304 
 
Average node length: 4.88, total dup: 678254, max dup: 44684 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 311634, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 587 
 
60 - 79% = 94 
 
80 - 99% = 27 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 332643, depth: 3, leaf buckets: 1730, nodes: 678304 
 
Average node length: 11.67, total dup: 0, max dup: 0 
 
Average key length: 8.80, compression ratio: 1.02 
 
Average prefix length: 3.20, average data length: 5.80 
 
Clustering factor: 155405, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 97 
 
20 - 39% = 352 
 
40 - 59% = 508 
 
60 - 79% = 397 
 
80 - 99% = 376 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 270, Index root page: 271 
 
Total formats: 1, used formats: 1 
 
Average record length: 64.91, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 18.27, total fragments: 355, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.60 
 
Pointer pages: 1, data page slots: 176 
 
Data pages: 92, average fill: 8% 
 
Primary pages: 4, secondary pages: 88, swept pages: 4 
 
Empty pages: 68, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 76 
 
20 - 39% = 12 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 292, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 59.87, total records: 1426 
 
Average version length: 71.15, total versions: 227, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 1.60 
 
Pointer pages: 1, data page slots: 832 
 
Data pages: 160, average fill: 11% 
 
Primary pages: 159, secondary pages: 1, swept pages: 110 
 
Empty pages: 94, full pages: 2 
 
Fill distribution: 
 
0 - 19% = 129 
 
20 - 39% = 17 
 
40 - 59% = 7 
 
60 - 79% = 6 
 
80 - 99% = 1 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 8, nodes: 1426 
 
Average node length: 17.70, total dup: 0, max dup: 0 
 
Average key length: 15.71, compression ratio: 1.72 
 
Average prefix length: 14.28, average data length: 12.72 
 
Clustering factor: 1097, ratio: 0.77 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 4 
 
40 - 59% = 3 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.04, total records: 49 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.13 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 20% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_TURNOVER_LOG (142) 
 
Primary pointer page: 260, Index root page: 261 
 
Total formats: 1, used formats: 1 
 
Average record length: 26.13, total records: 308 
 
Average version length: 44.66, total versions: 133, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 2.45 
 
Pointer pages: 1, data page slots: 32 
 
Data pages: 24, average fill: 12% 
 
Primary pages: 23, secondary pages: 1, swept pages: 8 
 
Empty pages: 15, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 20 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 715742, depth: 2, leaf buckets: 1, nodes: 308 
 
Average node length: 6.10, total dup: 247, max dup: 59 
 
Average key length: 4.81, compression ratio: 3.95 
 
Average prefix length: 16.38, average data length: 2.62 
 
Clustering factor: 139, ratio: 0.45 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (165) 
 
Primary pointer page: 354, Index root page: 355 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_DTS (4) 
 
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG (0) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (166) 
 
Primary pointer page: 366, Index root page: 367 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_DTS (4) 
 
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_GDSCODE (2) 
 
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_ROWSET (1) 
 
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.58, total records: 180043 
 
Average version length: 30.99, total versions: 814, max versions: 6 
 
Average fragment length: 33.00, total fragments: 1, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.50 
 
Pointer pages: 2, data page slots: 2016 
 
Data pages: 2016, average fill: 66% 
 
Primary pages: 2007, secondary pages: 9, swept pages: 1596 
 
Empty pages: 15, full pages: 635 
 
Fill distribution: 
 
0 - 19% = 34 
 
20 - 39% = 69 
 
40 - 59% = 154 
 
60 - 79% = 1757 
 
80 - 99% = 2 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 170, nodes: 180043 
 
Average node length: 4.43, total dup: 179994, max dup: 9611 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 32851, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 12 
 
40 - 59% = 100 
 
60 - 79% = 45 
 
80 - 99% = 12 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 193, nodes: 180043 
 
Average node length: 5.36, total dup: 162405, max dup: 44 
 
Average key length: 2.94, compression ratio: 7.47 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 45582, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 25 
 
40 - 59% = 68 
 
60 - 79% = 57 
 
80 - 99% = 43 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 193, nodes: 180043 
 
Average node length: 5.36, total dup: 162405, max dup: 44 
 
Average key length: 2.94, compression ratio: 7.47 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 45614, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 14 
 
40 - 59% = 81 
 
60 - 79% = 67 
 
80 - 99% = 30 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 185, nodes: 180043 
 
Average node length: 5.15, total dup: 162405, max dup: 44 
 
Average key length: 2.73, compression ratio: 3.29 
 
Average prefix length: 8.36, average data length: 0.64 
 
Clustering factor: 45652, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 10 
 
40 - 59% = 76 
 
60 - 79% = 72 
 
80 - 99% = 26 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.98, total records: 275151 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 1.14 
 
Pointer pages: 2, data page slots: 2352 
 
Data pages: 2352, average fill: 64% 
 
Primary pages: 2352, secondary pages: 0, swept pages: 0 
 
Empty pages: 1, full pages: 2350 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 2350 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 477709, depth: 2, leaf buckets: 225, nodes: 275151 
 
Average node length: 4.53, total dup: 274970, max dup: 2336 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.57, average data length: 0.00 
 
Clustering factor: 37751, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 86 
 
60 - 79% = 82 
 
80 - 99% = 56 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 1, used formats: 1 
 
Average record length: 151.86, total records: 13400565 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1696.00, compression ratio: 11.17 
 
Pointer pages: 196, data page slots: 318408 
 
Data pages: 318408, average fill: 87% 
 
Primary pages: 318408, secondary pages: 0, swept pages: 3 
 
Empty pages: 6, full pages: 318401 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 318401 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 15723, nodes: 13400565 
 
Average node length: 5.71, total dup: 12557263, max dup: 159 
 
Average key length: 2.15, compression ratio: 3.71 
 
Average prefix length: 7.88, average data length: 0.11 
 
Clustering factor: 2721998, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 9862 
 
60 - 79% = 3870 
 
80 - 99% = 1985 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 13541, nodes: 13400565 
 
Average node length: 4.66, total dup: 13400561, max dup: 11932938 
 
Average key length: 1.11, compression ratio: 0.49 
 
Average prefix length: 0.55, average data length: 0.00 
 
Clustering factor: 383109, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 13537 
 
60 - 79% = 1 
 
80 - 99% = 2 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 16815, nodes: 13400565 
 
Average node length: 5.76, total dup: 13027016, max dup: 26927 
 
Average key length: 2.21, compression ratio: 4.08 
 
Average prefix length: 8.82, average data length: 0.18 
 
Clustering factor: 797416, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1 
 
40 - 59% = 13287 
 
60 - 79% = 2028 
 
80 - 99% = 1498 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 16419, nodes: 13400565 
 
Average node length: 5.62, total dup: 13379814, max dup: 2064528 
 
Average key length: 2.06, compression ratio: 18.38 
 
Average prefix length: 37.86, average data length: 0.06 
 
Clustering factor: 6108914, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 1 
 
40 - 59% = 14306 
 
60 - 79% = 411 
 
80 - 99% = 1689 
 
 
PHRASES (145) 
 
Primary pointer page: 266, Index root page: 267 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 55.23, total records: 469869 
 
Average version length: 56.23, total versions: 261, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.45 
 
Pointer pages: 4, data page slots: 5584 
 
Data pages: 5584, average fill: 75% 
 
Primary pages: 5584, secondary pages: 0, swept pages: 4037 
 
Empty pages: 3, full pages: 5253 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 3 
 
40 - 59% = 17 
 
60 - 79% = 5560 
 
80 - 99% = 0 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 433562, depth: 3, leaf buckets: 608, nodes: 469869 
 
Average node length: 5.92, total dup: 397264, max dup: 825 
 
Average key length: 3.12, compression ratio: 2.88 
 
Average prefix length: 8.03, average data length: 0.97 
 
Clustering factor: 65959, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 47 
 
40 - 59% = 313 
 
60 - 79% = 175 
 
80 - 99% = 62 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 846778, depth: 3, leaf buckets: 510, nodes: 469869 
 
Average node length: 5.62, total dup: 418042, max dup: 105 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.29, average data length: 0.71 
 
Clustering factor: 123605, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 12 
 
40 - 59% = 199 
 
60 - 79% = 211 
 
80 - 99% = 86 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 3% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 12.50, total dup: 0, max dup: 0 
 
Average key length: 11.00, compression ratio: 0.82 
 
Average prefix length: 0.50, average data length: 8.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index SEMAPHORES_TASK_UNQ (1) 
 
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 22.50, total dup: 0, max dup: 0 
 
Average key length: 21.00, compression ratio: 1.07 
 
Average prefix length: 4.00, average data length: 18.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SETTINGS (137) 
 
Primary pointer page: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.31, total records: 114 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1347.00, compression ratio: 13.70 
 
Pointer pages: 1, data page slots: 2 
 
Data pages: 2, average fill: 80% 
 
Primary pages: 2, secondary pages: 0, swept pages: 2 
 
Empty pages: 0, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
Index SETTINGS_MODE_CODE (0) 
 
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.11, total dup: 0, max dup: 0 
 
Average key length: 26.10, compression ratio: 1.70 
 
Average prefix length: 21.18, average data length: 23.11 
 
Clustering factor: 6, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$RAND$CALLS (136) 
 
Primary pointer page: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
 
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TRACE_STAT (162) 
 
Primary pointer page: 347, Index root page: 348 
 
Total formats: 1, used formats: 1 
 
Average record length: 57.50, total records: 2697 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 6.54 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 61% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 7, full pages: 32 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 32 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 264, Index root page: 265 
 
Total formats: 1, used formats: 1 
 
Average record length: 78.23, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.73 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 78% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 67 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400 
 
Average node length: 52.86, total dup: 0, max dup: 0 
 
Average key length: 51.84, compression ratio: 1.00 
 
Average prefix length: 2.73, average data length: 48.86 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (260) 
 
Primary pointer page: 292, Index root page: 295 
 
Total formats: 1, used formats: 1 
 
Average record length: 53.89, total records: 4655 
 
Average version length: 72.25, total versions: 1180, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.52 
 
Pointer pages: 1, data page slots: 952 
 
Data pages: 320, average fill: 19% 
 
Primary pages: 319, secondary pages: 1, swept pages: 193 
 
Empty pages: 130, full pages: 10 
 
Fill distribution: 
 
0 - 19% = 207 
 
20 - 39% = 56 
 
40 - 59% = 30 
 
60 - 79% = 22 
 
80 - 99% = 5 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 10, nodes: 4655 
 
Average node length: 6.74, total dup: 4045, max dup: 14 
 
Average key length: 4.80, compression ratio: 7.70 
 
Average prefix length: 34.33, average data length: 2.67 
 
Clustering factor: 750, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 6 
 
40 - 59% = 4 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.98, total records: 856190 
 
Average version length: 71.93, total versions: 2385, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.89 
 
Pointer pages: 8, data page slots: 13048 
 
Data pages: 13040, average fill: 72% 
 
Primary pages: 13040, secondary pages: 0, swept pages: 8831 
 
Empty pages: 33, full pages: 8641 
 
Fill distribution: 
 
0 - 19% = 87 
 
20 - 39% = 128 
 
40 - 59% = 815 
 
60 - 79% = 11997 
 
80 - 99% = 13 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 306723, depth: 3, leaf buckets: 838, nodes: 856190 
 
Average node length: 5.11, total dup: 833395, max dup: 119 
 
Average key length: 2.19, compression ratio: 4.10 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 95350, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 53 
 
40 - 59% = 423 
 
60 - 79% = 55 
 
80 - 99% = 286 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 242302, depth: 3, leaf buckets: 1230, nodes: 856190 
 
Average node length: 6.23, total dup: 748218, max dup: 14 
 
Average key length: 3.31, compression ratio: 11.18 
 
Average prefix length: 35.82, average data length: 1.18 
 
Clustering factor: 168300, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 191 
 
40 - 59% = 758 
 
60 - 79% = 149 
 
80 - 99% = 116 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.58, total records: 14416 
 
Average version length: 72.00, total versions: 4867, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.86 
 
Pointer pages: 2, data page slots: 1928 
 
Data pages: 960, average fill: 19% 
 
Primary pages: 960, secondary pages: 0, swept pages: 479 
 
Empty pages: 422, full pages: 72 
 
Fill distribution: 
 
0 - 19% = 642 
 
20 - 39% = 139 
 
40 - 59% = 74 
 
60 - 79% = 79 
 
80 - 99% = 26 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 32, nodes: 14416 
 
Average node length: 6.27, total dup: 12556, max dup: 40 
 
Average key length: 3.99, compression ratio: 9.27 
 
Average prefix length: 35.13, average data length: 1.87 
 
Clustering factor: 1713, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 23 
 
40 - 59% = 9 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.27, total records: 1643815 
 
Average version length: 71.57, total versions: 20882, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.91 
 
Pointer pages: 16, data page slots: 25008 
 
Data pages: 24928, average fill: 72% 
 
Primary pages: 24928, secondary pages: 0, swept pages: 11774 
 
Empty pages: 553, full pages: 20606 
 
Fill distribution: 
 
0 - 19% = 771 
 
20 - 39% = 610 
 
40 - 59% = 1307 
 
60 - 79% = 21843 
 
80 - 99% = 397 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 201379, depth: 3, leaf buckets: 2496, nodes: 1643815 
 
Average node length: 5.58, total dup: 1549743, max dup: 49 
 
Average key length: 2.63, compression ratio: 14.09 
 
Average prefix length: 36.43, average data length: 0.57 
 
Clustering factor: 162810, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 966 
 
40 - 59% = 1157 
 
60 - 79% = 212 
 
80 - 99% = 151 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 11.82, total records: 3210 
 
Average version length: 71.97, total versions: 2673, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 11.51 
 
Pointer pages: 3, data page slots: 1560 
 
Data pages: 336, average fill: 13% 
 
Primary pages: 336, secondary pages: 0, swept pages: 162 
 
Empty pages: 177, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 251 
 
20 - 39% = 44 
 
40 - 59% = 22 
 
60 - 79% = 14 
 
80 - 99% = 5 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 8, nodes: 3210 
 
Average node length: 6.58, total dup: 2861, max dup: 46 
 
Average key length: 4.63, compression ratio: 7.99 
 
Average prefix length: 34.48, average data length: 2.52 
 
Clustering factor: 385, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 5 
 
40 - 59% = 1 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.37, total records: 2887415 
 
Average version length: 71.12, total versions: 7847, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.91 
 
Pointer pages: 26, data page slots: 40880 
 
Data pages: 40880, average fill: 77% 
 
Primary pages: 40880, secondary pages: 0, swept pages: 30569 
 
Empty pages: 24, full pages: 38461 
 
Fill distribution: 
 
0 - 19% = 50 
 
20 - 39% = 69 
 
40 - 59% = 457 
 
60 - 79% = 40089 
 
80 - 99% = 215 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5845, nodes: 2887415 
 
Average node length: 6.88, total dup: 2333467, max dup: 14 
 
Average key length: 3.90, compression ratio: 9.48 
 
Average prefix length: 35.29, average data length: 1.71 
 
Clustering factor: 462893, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 2995 
 
40 - 59% = 2261 
 
60 - 79% = 351 
 
80 - 99% = 227 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.73, total records: 4806406 
 
Average version length: 84.17, total versions: 493, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.62 
 
Pointer pages: 46, data page slots: 73864 
 
Data pages: 73864, average fill: 80% 
 
Primary pages: 73864, secondary pages: 0, swept pages: 27584 
 
Empty pages: 9, full pages: 73534 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 1 
 
40 - 59% = 19 
 
60 - 79% = 20989 
 
80 - 99% = 52843 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4982, nodes: 4806406 
 
Average node length: 5.16, total dup: 4696943, max dup: 130 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 733396, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 86 
 
40 - 59% = 2298 
 
60 - 79% = 2106 
 
80 - 99% = 467 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 4607, nodes: 4806406 
 
Average node length: 5.70, total dup: 4299344, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 171182, ratio: 0.04 
 
Fill distribution: 
 
0 - 19% = 40 
 
20 - 39% = 110 
 
40 - 59% = 1717 
 
60 - 79% = 282 
 
80 - 99% = 2458 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5505, nodes: 4806406 
 
Average node length: 5.81, total dup: 4205611, max dup: 29 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 788636, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 97 
 
40 - 59% = 2396 
 
60 - 79% = 2318 
 
80 - 99% = 673 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.52, total records: 2764046 
 
Average version length: 83.81, total versions: 4086, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 27, data page slots: 43120 
 
Data pages: 43120, average fill: 79% 
 
Primary pages: 43120, secondary pages: 0, swept pages: 31608 
 
Empty pages: 47, full pages: 41787 
 
Fill distribution: 
 
0 - 19% = 102 
 
20 - 39% = 89 
 
40 - 59% = 289 
 
60 - 79% = 14848 
 
80 - 99% = 27792 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2921, nodes: 2764046 
 
Average node length: 5.15, total dup: 2699339, max dup: 154 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 439440, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 53 
 
40 - 59% = 1620 
 
60 - 79% = 936 
 
80 - 99% = 307 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4270, nodes: 2764046 
 
Average node length: 6.25, total dup: 2255274, max dup: 14 
 
Average key length: 3.28, compression ratio: 2.75 
 
Average prefix length: 7.91, average data length: 1.09 
 
Clustering factor: 221556, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 108 
 
20 - 39% = 1375 
 
40 - 59% = 1581 
 
60 - 79% = 707 
 
80 - 99% = 499 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 3331, nodes: 2764046 
 
Average node length: 5.81, total dup: 2416956, max dup: 32 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.29, average data length: 0.71 
 
Clustering factor: 529215, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 53 
 
40 - 59% = 1953 
 
60 - 79% = 954 
 
80 - 99% = 356 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.82, total records: 5096602 
 
Average version length: 85.26, total versions: 5719, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.62 
 
Pointer pages: 49, data page slots: 78624 
 
Data pages: 78568, average fill: 80% 
 
Primary pages: 78568, secondary pages: 0, swept pages: 17984 
 
Empty pages: 287, full pages: 77171 
 
Fill distribution: 
 
0 - 19% = 354 
 
20 - 39% = 182 
 
40 - 59% = 384 
 
60 - 79% = 11939 
 
80 - 99% = 65709 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5232, nodes: 5096602 
 
Average node length: 5.04, total dup: 5066758, max dup: 680 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 722803, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 163 
 
40 - 59% = 2801 
 
60 - 79% = 1572 
 
80 - 99% = 691 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 5721, nodes: 5096602 
 
Average node length: 5.51, total dup: 4703465, max dup: 49 
 
Average key length: 2.53, compression ratio: 3.56 
 
Average prefix length: 8.55, average data length: 0.45 
 
Clustering factor: 175202, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 102 
 
20 - 39% = 1256 
 
40 - 59% = 2001 
 
60 - 79% = 688 
 
80 - 99% = 1674 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 5925, nodes: 5096602 
 
Average node length: 5.69, total dup: 4569136, max dup: 78 
 
Average key length: 2.70, compression ratio: 3.33 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 800050, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 146 
 
40 - 59% = 3331 
 
60 - 79% = 1701 
 
80 - 99% = 744 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 761, Index root page: 762 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (270) 
 
Primary pointer page: 767, Index root page: 776 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.67, total records: 3470951 
 
Average version length: 83.20, total versions: 3538, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 34, data page slots: 54072 
 
Data pages: 54072, average fill: 79% 
 
Primary pages: 54072, secondary pages: 0, swept pages: 38649 
 
Empty pages: 47, full pages: 52190 
 
Fill distribution: 
 
0 - 19% = 93 
 
20 - 39% = 131 
 
40 - 59% = 425 
 
60 - 79% = 16094 
 
80 - 99% = 37329 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3787, nodes: 3470951 
 
Average node length: 5.03, total dup: 3454185, max dup: 1264 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 637093, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 437 
 
40 - 59% = 1999 
 
60 - 79% = 909 
 
80 - 99% = 424 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5338, nodes: 3470951 
 
Average node length: 6.26, total dup: 2831406, max dup: 14 
 
Average key length: 3.28, compression ratio: 2.74 
 
Average prefix length: 7.90, average data length: 1.10 
 
Clustering factor: 300311, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 153 
 
20 - 39% = 1728 
 
40 - 59% = 1929 
 
60 - 79% = 831 
 
80 - 99% = 697 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 4181, nodes: 3470951 
 
Average node length: 5.58, total dup: 3170373, max dup: 55 
 
Average key length: 2.60, compression ratio: 3.46 
 
Average prefix length: 8.49, average data length: 0.51 
 
Clustering factor: 685969, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 443 
 
40 - 59% = 2187 
 
60 - 79% = 1061 
 
80 - 99% = 476 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.50, total records: 588378 
 
Average version length: 69.22, total versions: 533, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.96 
 
Pointer pages: 5, data page slots: 8096 
 
Data pages: 8096, average fill: 77% 
 
Primary pages: 8096, secondary pages: 0, swept pages: 6106 
 
Empty pages: 0, full pages: 7876 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 12 
 
40 - 59% = 40 
 
60 - 79% = 8030 
 
80 - 99% = 12 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 176575, depth: 3, leaf buckets: 726, nodes: 588378 
 
Average node length: 5.32, total dup: 553163, max dup: 123 
 
Average key length: 2.46, compression ratio: 3.67 
 
Average prefix length: 8.60, average data length: 0.40 
 
Clustering factor: 52588, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 185 
 
40 - 59% = 294 
 
60 - 79% = 183 
 
80 - 99% = 62 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 804, nodes: 588378 
 
Average node length: 5.92, total dup: 501809, max dup: 14 
 
Average key length: 3.06, compression ratio: 2.94 
 
Average prefix length: 8.09, average data length: 0.91 
 
Clustering factor: 54653, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 202 
 
40 - 59% = 314 
 
60 - 79% = 216 
 
80 - 99% = 71 
 
 
ZDOC_DATA (230) 
 
Primary pointer page: 644, Index root page: 645 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZDOC_LIST (229) 
 
Primary pointer page: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (231) 
 
Primary pointer page: 646, Index root page: 647 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPDISTR (234) 
 
Primary pointer page: 652, Index root page: 653 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPDISTR_ID (0) 
 
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPSTORNED (235) 
 
Primary pointer page: 654, Index root page: 655 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPSTORNED_ID (0) 
 
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQDISTR (232) 
 
Primary pointer page: 648, Index root page: 649 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_ID (0) 
 
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
 
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQSTORNED (233) 
 
Primary pointer page: 650, Index root page: 651 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_DOC_ID (1) 
 
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_ID (0) 
 
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_RCV_ID (3) 
 
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_SND_ID (2) 
 
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_DEP_DOCS (228) 
 
Primary pointer page: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (227) 
 
Primary pointer page: 614, Index root page: 615 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Z_USED_VIEWS (146) 
 
Primary pointer page: 268, Index root page: 269 
 
Total formats: 1, used formats: 1 
 
Average record length: 29.38, total records: 29 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 99.00, compression ratio: 3.37 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 16% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index Z_USED_VIEWS_UNQ (0) 
 
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29 
 
Average node length: 15.17, total dup: 0, max dup: 0 
 
Average key length: 14.14, compression ratio: 1.44 
 
Average prefix length: 9.17, average data length: 11.17 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Gstat completion time Sun Dec 03 07:12:17 2017 
 
 
Done for 68620 ms, from  7:11:08.65 to  7:12:17.27. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2199699  | 
 1692  | 
 0.0769  | 
|  DOC_LIST  | 
 678304  | 
 1016  | 
 0.1497  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 1426  | 
 227  | 
 15.9186  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 308  | 
 133  | 
 43.1818  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 180043  | 
 814  | 
 0.4521  | 
|  PERF_ESTIMATED  | 
 275151  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 13400565  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 469869  | 
 261  | 
 0.0555  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 0  | 
 0.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  TRACE_STAT  | 
 2697  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 4655  | 
 1180  | 
 25.3490  | 
|  XQD_1000_3300  | 
 856190  | 
 2385  | 
 0.2785  | 
|  XQD_1200_2000  | 
 14416  | 
 4867  | 
 33.7610  | 
|  XQD_2000_3300  | 
 1643815  | 
 20882  | 
 1.2703  | 
|  XQD_2100_3300  | 
 3210  | 
 2673  | 
 83.2710  | 
|  XQD_3300_3400  | 
 2887415  | 
 7847  | 
 0.2717  | 
|  XQS_1000_1200  | 
 4806406  | 
 493  | 
 0.0102  | 
|  XQS_1000_3300  | 
 2764046  | 
 4086  | 
 0.1478  | 
|  XQS_1200_2000  | 
 5096602  | 
 5719  | 
 0.1122  | 
|  XQS_2100_3300  | 
 3470951  | 
 3538  | 
 0.1019  | 
|  XQS_3300_3400  | 
 588378  | 
 533  | 
 0.0905  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2290 ms, from  7:12:28.29 to  7:12:30.58.  
07:12:30.67 Validation started 
 
 
07:12:30.69 Relation 140 (DOC_LIST) 
 
07:12:30.69   process pointer page    0 of    6 
 
07:12:30.80   process pointer page    1 of    6 
 
07:12:30.89   process pointer page    2 of    6 
 
07:12:30.94   process pointer page    3 of    6 
 
07:12:30.98   process pointer page    4 of    6 
 
07:12:31.03   process pointer page    5 of    6 
 
07:12:31.03 Index 1 (PK_DOC_LIST) 
 
07:12:31.30 Index 2 (DOC_LIST_ID_DESC) 
 
07:12:31.53 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:12:31.64 Relation 140 (DOC_LIST) is ok 
 
 
07:12:31.64 Relation 141 (DOC_DATA) 
 
07:12:31.64   process pointer page    0 of   15 
 
07:12:31.73   process pointer page    1 of   15 
 
07:12:31.83   process pointer page    2 of   15 
 
07:12:31.90   process pointer page    3 of   15 
 
07:12:31.94   process pointer page    4 of   15 
 
07:12:32.00   process pointer page    5 of   15 
 
07:12:32.04   process pointer page    6 of   15 
 
07:12:32.11   process pointer page    7 of   15 
 
07:12:32.14   process pointer page    8 of   15 
 
07:12:32.23   process pointer page    9 of   15 
 
07:12:32.29   process pointer page   10 of   15 
 
07:12:32.34   process pointer page   11 of   15 
 
07:12:32.37   process pointer page   12 of   15 
 
07:12:32.42   process pointer page   13 of   15 
 
07:12:32.45   process pointer page   14 of   15 
 
07:12:32.47 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:12:33.43 Index 3 (DOC_DATA_ID_DESC) 
 
07:12:33.96 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:12:34.45 Relation 141 (DOC_DATA) is ok 
 
 
07:12:34.45 Relation 147 (INVNT_SALDO) 
 
07:12:34.45   process pointer page    0 of    1 
 
07:12:34.45 Index 1 (PK_INVNT_SALDO) 
 
07:12:34.45 Relation 147 (INVNT_SALDO) is ok 
 
 
07:12:34.45 Relation 150 (PDISTR) 
 
07:12:34.45   process pointer page    0 of    2 
 
07:12:34.49   process pointer page    1 of    2 
 
07:12:34.49 Index 2 (PDISTR_SND_ID) 
 
07:12:34.53 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:12:34.56 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:12:34.62 Index 5 (PDISTR_AGENT_ID) 
 
07:12:34.68 Relation 150 (PDISTR) is ok 
 
 
07:12:34.68 Relation 151 (PSTORNED) 
 
07:12:34.68   process pointer page    0 of    4 
 
07:12:34.73   process pointer page    1 of    4 
 
07:12:34.76   process pointer page    2 of    4 
 
07:12:34.82   process pointer page    3 of    4 
 
07:12:34.87 Index 2 (PSTORNED_SND_ID) 
 
07:12:35.02 Index 3 (PSTORNED_RCV_ID) 
 
07:12:35.18 Relation 151 (PSTORNED) is ok 
 
 
07:12:35.18 Relation 156 (SEMAPHORES) 
 
07:12:35.18   process pointer page    0 of    1 
 
07:12:35.18 Index 1 (PK_SEMAPHORES) 
 
07:12:35.18 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:12:35.18 Relation 156 (SEMAPHORES) is ok 
 
 
07:12:35.18 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:12:35.18   process pointer page    0 of    1 
 
07:12:35.18 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:12:35.18 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:12:35.18 Relation 160 (PERF_ESTIMATED) 
 
07:12:35.18   process pointer page    0 of    2 
 
07:12:35.23   process pointer page    1 of    2 
 
07:12:35.24 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:12:35.27 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:12:35.27 Relation 161 (PERF_ISQL_STAT) 
 
07:12:35.27   process pointer page    0 of    1 
 
07:12:35.27 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:12:35.27 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:12:35.27 Relation 162 (TRACE_STAT) 
 
07:12:35.27   process pointer page    0 of    1 
 
07:12:35.27 Relation 162 (TRACE_STAT) is ok 
 
 
07:12:35.27 Relation 163 (PERF_LOG) 
 
07:12:35.27   process pointer page    0 of  196 
 
07:12:35.31   process pointer page    1 of  196 
 
07:12:35.34   process pointer page    2 of  196 
 
07:12:35.37   process pointer page    3 of  196 
 
07:12:35.43   process pointer page    4 of  196 
 
07:12:35.49   process pointer page    5 of  196 
 
07:12:35.52   process pointer page    6 of  196 
 
07:12:35.55   process pointer page    7 of  196 
 
07:12:35.59   process pointer page    8 of  196 
 
07:12:35.63   process pointer page    9 of  196 
 
07:12:35.70   process pointer page   10 of  196 
 
07:12:35.76   process pointer page   11 of  196 
 
07:12:35.79   process pointer page   12 of  196 
 
07:12:35.82   process pointer page   13 of  196 
 
07:12:35.88   process pointer page   14 of  196 
 
07:12:35.96   process pointer page   15 of  196 
 
07:12:36.05   process pointer page   16 of  196 
 
07:12:36.12   process pointer page   17 of  196 
 
07:12:36.15   process pointer page   18 of  196 
 
07:12:36.18   process pointer page   19 of  196 
 
07:12:36.26   process pointer page   20 of  196 
 
07:12:36.33   process pointer page   21 of  196 
 
07:12:36.40   process pointer page   22 of  196 
 
07:12:36.43   process pointer page   23 of  196 
 
07:12:36.48   process pointer page   24 of  196 
 
07:12:36.51   process pointer page   25 of  196 
 
07:12:36.54   process pointer page   26 of  196 
 
07:12:36.57   process pointer page   27 of  196 
 
07:12:36.58   process pointer page   28 of  196 
 
07:12:36.62   process pointer page   29 of  196 
 
07:12:36.65   process pointer page   30 of  196 
 
07:12:36.68   process pointer page   31 of  196 
 
07:12:36.71   process pointer page   32 of  196 
 
07:12:36.72   process pointer page   33 of  196 
 
07:12:36.80   process pointer page   34 of  196 
 
07:12:36.87   process pointer page   35 of  196 
 
07:12:36.90   process pointer page   36 of  196 
 
07:12:36.93   process pointer page   37 of  196 
 
07:12:36.96   process pointer page   38 of  196 
 
07:12:36.99   process pointer page   39 of  196 
 
07:12:37.02   process pointer page   40 of  196 
 
07:12:37.04   process pointer page   41 of  196 
 
07:12:37.07   process pointer page   42 of  196 
 
07:12:37.10   process pointer page   43 of  196 
 
07:12:37.13   process pointer page   44 of  196 
 
07:12:37.15   process pointer page   45 of  196 
 
07:12:37.18   process pointer page   46 of  196 
 
07:12:37.21   process pointer page   47 of  196 
 
07:12:37.22   process pointer page   48 of  196 
 
07:12:37.26   process pointer page   49 of  196 
 
07:12:37.29   process pointer page   50 of  196 
 
07:12:37.36   process pointer page   51 of  196 
 
07:12:37.41   process pointer page   52 of  196 
 
07:12:37.44   process pointer page   53 of  196 
 
07:12:37.47   process pointer page   54 of  196 
 
07:12:37.50   process pointer page   55 of  196 
 
07:12:37.54   process pointer page   56 of  196 
 
07:12:37.57   process pointer page   57 of  196 
 
07:12:37.61   process pointer page   58 of  196 
 
07:12:37.69   process pointer page   59 of  196 
 
07:12:37.72   process pointer page   60 of  196 
 
07:12:37.75   process pointer page   61 of  196 
 
07:12:37.79   process pointer page   62 of  196 
 
07:12:37.83   process pointer page   63 of  196 
 
07:12:37.86   process pointer page   64 of  196 
 
07:12:37.89   process pointer page   65 of  196 
 
07:12:37.93   process pointer page   66 of  196 
 
07:12:37.96   process pointer page   67 of  196 
 
07:12:37.99   process pointer page   68 of  196 
 
07:12:38.02   process pointer page   69 of  196 
 
07:12:38.05   process pointer page   70 of  196 
 
07:12:38.08   process pointer page   71 of  196 
 
07:12:38.11   process pointer page   72 of  196 
 
07:12:38.14   process pointer page   73 of  196 
 
07:12:38.18   process pointer page   74 of  196 
 
07:12:38.21   process pointer page   75 of  196 
 
07:12:38.24   process pointer page   76 of  196 
 
07:12:38.30   process pointer page   77 of  196 
 
07:12:38.39   process pointer page   78 of  196 
 
07:12:38.47   process pointer page   79 of  196 
 
07:12:38.55   process pointer page   80 of  196 
 
07:12:38.61   process pointer page   81 of  196 
 
07:12:38.64   process pointer page   82 of  196 
 
07:12:38.67   process pointer page   83 of  196 
 
07:12:38.74   process pointer page   84 of  196 
 
07:12:38.83   process pointer page   85 of  196 
 
07:12:38.86   process pointer page   86 of  196 
 
07:12:38.92   process pointer page   87 of  196 
 
07:12:38.96   process pointer page   88 of  196 
 
07:12:38.99   process pointer page   89 of  196 
 
07:12:39.03   process pointer page   90 of  196 
 
07:12:39.06   process pointer page   91 of  196 
 
07:12:39.10   process pointer page   92 of  196 
 
07:12:39.13   process pointer page   93 of  196 
 
07:12:39.17   process pointer page   94 of  196 
 
07:12:39.25   process pointer page   95 of  196 
 
07:12:39.33   process pointer page   96 of  196 
 
07:12:39.41   process pointer page   97 of  196 
 
07:12:39.50   process pointer page   98 of  196 
 
07:12:39.53   process pointer page   99 of  196 
 
07:12:39.56   process pointer page  100 of  196 
 
07:12:39.60   process pointer page  101 of  196 
 
07:12:39.63   process pointer page  102 of  196 
 
07:12:39.69   process pointer page  103 of  196 
 
07:12:39.77   process pointer page  104 of  196 
 
07:12:39.84   process pointer page  105 of  196 
 
07:12:39.94   process pointer page  106 of  196 
 
07:12:40.02   process pointer page  107 of  196 
 
07:12:40.09   process pointer page  108 of  196 
 
07:12:40.17   process pointer page  109 of  196 
 
07:12:40.25   process pointer page  110 of  196 
 
07:12:40.30   process pointer page  111 of  196 
 
07:12:40.33   process pointer page  112 of  196 
 
07:12:40.41   process pointer page  113 of  196 
 
07:12:40.48   process pointer page  114 of  196 
 
07:12:40.56   process pointer page  115 of  196 
 
07:12:40.64   process pointer page  116 of  196 
 
07:12:40.70   process pointer page  117 of  196 
 
07:12:40.73   process pointer page  118 of  196 
 
07:12:40.81   process pointer page  119 of  196 
 
07:12:40.89   process pointer page  120 of  196 
 
07:12:40.97   process pointer page  121 of  196 
 
07:12:41.01   process pointer page  122 of  196 
 
07:12:41.05   process pointer page  123 of  196 
 
07:12:41.08   process pointer page  124 of  196 
 
07:12:41.16   process pointer page  125 of  196 
 
07:12:41.23   process pointer page  126 of  196 
 
07:12:41.31   process pointer page  127 of  196 
 
07:12:41.36   process pointer page  128 of  196 
 
07:12:41.39   process pointer page  129 of  196 
 
07:12:41.42   process pointer page  130 of  196 
 
07:12:41.45   process pointer page  131 of  196 
 
07:12:41.53   process pointer page  132 of  196 
 
07:12:41.56   process pointer page  133 of  196 
 
07:12:41.59   process pointer page  134 of  196 
 
07:12:41.62   process pointer page  135 of  196 
 
07:12:41.65   process pointer page  136 of  196 
 
07:12:41.69   process pointer page  137 of  196 
 
07:12:41.72   process pointer page  138 of  196 
 
07:12:41.78   process pointer page  139 of  196 
 
07:12:41.84   process pointer page  140 of  196 
 
07:12:41.87   process pointer page  141 of  196 
 
07:12:41.90   process pointer page  142 of  196 
 
07:12:41.94   process pointer page  143 of  196 
 
07:12:41.97   process pointer page  144 of  196 
 
07:12:42.00   process pointer page  145 of  196 
 
07:12:42.03   process pointer page  146 of  196 
 
07:12:42.06   process pointer page  147 of  196 
 
07:12:42.11   process pointer page  148 of  196 
 
07:12:42.18   process pointer page  149 of  196 
 
07:12:42.26   process pointer page  150 of  196 
 
07:12:42.34   process pointer page  151 of  196 
 
07:12:42.42   process pointer page  152 of  196 
 
07:12:42.50   process pointer page  153 of  196 
 
07:12:42.57   process pointer page  154 of  196 
 
07:12:42.65   process pointer page  155 of  196 
 
07:12:42.68   process pointer page  156 of  196 
 
07:12:42.73   process pointer page  157 of  196 
 
07:12:42.76   process pointer page  158 of  196 
 
07:12:42.82   process pointer page  159 of  196 
 
07:12:42.90   process pointer page  160 of  196 
 
07:12:42.98   process pointer page  161 of  196 
 
07:12:43.06   process pointer page  162 of  196 
 
07:12:43.11   process pointer page  163 of  196 
 
07:12:43.14   process pointer page  164 of  196 
 
07:12:43.17   process pointer page  165 of  196 
 
07:12:43.20   process pointer page  166 of  196 
 
07:12:43.23   process pointer page  167 of  196 
 
07:12:43.26   process pointer page  168 of  196 
 
07:12:43.31   process pointer page  169 of  196 
 
07:12:43.39   process pointer page  170 of  196 
 
07:12:43.46   process pointer page  171 of  196 
 
07:12:43.51   process pointer page  172 of  196 
 
07:12:43.54   process pointer page  173 of  196 
 
07:12:43.57   process pointer page  174 of  196 
 
07:12:43.60   process pointer page  175 of  196 
 
07:12:43.64   process pointer page  176 of  196 
 
07:12:43.67   process pointer page  177 of  196 
 
07:12:43.70   process pointer page  178 of  196 
 
07:12:43.78   process pointer page  179 of  196 
 
07:12:43.85   process pointer page  180 of  196 
 
07:12:43.92   process pointer page  181 of  196 
 
07:12:43.95   process pointer page  182 of  196 
 
07:12:44.03   process pointer page  183 of  196 
 
07:12:44.10   process pointer page  184 of  196 
 
07:12:44.18   process pointer page  185 of  196 
 
07:12:44.26   process pointer page  186 of  196 
 
07:12:44.34   process pointer page  187 of  196 
 
07:12:44.42   process pointer page  188 of  196 
 
07:12:44.49   process pointer page  189 of  196 
 
07:12:44.57   process pointer page  190 of  196 
 
07:12:44.65   process pointer page  191 of  196 
 
07:12:44.73   process pointer page  192 of  196 
 
07:12:44.81   process pointer page  193 of  196 
 
07:12:44.88   process pointer page  194 of  196 
 
07:12:44.98   process pointer page  195 of  196 
 
07:12:44.98 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:12:48.10 Index 2 (PERF_LOG_UNIT) 
 
07:12:50.34 Index 3 (PERF_LOG_TRN_DESC) 
 
07:12:52.39 Index 4 (PERF_LOG_GDSCODE) 
 
07:12:54.04 Relation 163 (PERF_LOG) is ok 
 
 
07:12:54.04 Relation 167 (V_STOPTEST) 
 
07:12:54.04 Relation 167 (V_STOPTEST) is ok 
 
 
07:12:54.04 Relation 184 (V_QDISTR_SOURCE) 
 
07:12:54.04 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:12:54.04 Relation 185 (V_QSTORNED_SOURCE) 
 
07:12:54.04 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:12:54.04 Relation 260 (XQD_1000_1200) 
 
07:12:54.04   process pointer page    0 of    1 
 
07:12:54.04 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:12:54.04 Relation 260 (XQD_1000_1200) is ok 
 
 
07:12:54.04 Relation 261 (XQD_1200_2000) 
 
07:12:54.04   process pointer page    0 of    2 
 
07:12:54.06   process pointer page    1 of    2 
 
07:12:54.06 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:12:54.06 Relation 261 (XQD_1200_2000) is ok 
 
 
07:12:54.06 Relation 262 (XQD_1000_3300) 
 
07:12:54.06   process pointer page    0 of    8 
 
07:12:54.09   process pointer page    1 of    8 
 
07:12:54.17   process pointer page    2 of    8 
 
07:12:54.26   process pointer page    3 of    8 
 
07:12:54.34   process pointer page    4 of    8 
 
07:12:54.43   process pointer page    5 of    8 
 
07:12:54.49   process pointer page    6 of    8 
 
07:12:54.54   process pointer page    7 of    8 
 
07:12:54.57 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:12:54.68 Index 2 (XQD_1000_3300_DOC) 
 
07:12:54.90 Relation 262 (XQD_1000_3300) is ok 
 
 
07:12:54.90 Relation 263 (XQD_2000_3300) 
 
07:12:54.90   process pointer page    0 of   16 
 
07:12:54.95   process pointer page    1 of   16 
 
07:12:54.98   process pointer page    2 of   16 
 
07:12:55.05   process pointer page    3 of   16 
 
07:12:55.12   process pointer page    4 of   16 
 
07:12:55.16   process pointer page    5 of   16 
 
07:12:55.21   process pointer page    6 of   16 
 
07:12:55.26   process pointer page    7 of   16 
 
07:12:55.29   process pointer page    8 of   16 
 
07:12:55.38   process pointer page    9 of   16 
 
07:12:55.43   process pointer page   10 of   16 
 
07:12:55.49   process pointer page   11 of   16 
 
07:12:55.52   process pointer page   12 of   16 
 
07:12:55.55   process pointer page   13 of   16 
 
07:12:55.59   process pointer page   14 of   16 
 
07:12:55.63   process pointer page   15 of   16 
 
07:12:55.63 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:12:55.96 Relation 263 (XQD_2000_3300) is ok 
 
 
07:12:55.96 Relation 264 (XQD_2100_3300) 
 
07:12:55.96   process pointer page    0 of    3 
 
07:12:55.96   process pointer page    1 of    3 
 
07:12:55.96   process pointer page    2 of    3 
 
07:12:55.96 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:12:55.96 Relation 264 (XQD_2100_3300) is ok 
 
 
07:12:55.96 Relation 265 (XQD_3300_3400) 
 
07:12:55.96   process pointer page    0 of   26 
 
07:12:56.02   process pointer page    1 of   26 
 
07:12:56.08   process pointer page    2 of   26 
 
07:12:56.16   process pointer page    3 of   26 
 
07:12:56.26   process pointer page    4 of   26 
 
07:12:56.32   process pointer page    5 of   26 
 
07:12:56.35   process pointer page    6 of   26 
 
07:12:56.40   process pointer page    7 of   26 
 
07:12:56.43   process pointer page    8 of   26 
 
07:12:56.46   process pointer page    9 of   26 
 
07:12:56.51   process pointer page   10 of   26 
 
07:12:56.60   process pointer page   11 of   26 
 
07:12:56.63   process pointer page   12 of   26 
 
07:12:56.69   process pointer page   13 of   26 
 
07:12:56.74   process pointer page   14 of   26 
 
07:12:56.83   process pointer page   15 of   26 
 
07:12:56.93   process pointer page   16 of   26 
 
07:12:57.00   process pointer page   17 of   26 
 
07:12:57.04   process pointer page   18 of   26 
 
07:12:57.07   process pointer page   19 of   26 
 
07:12:57.11   process pointer page   20 of   26 
 
07:12:57.16   process pointer page   21 of   26 
 
07:12:57.24   process pointer page   22 of   26 
 
07:12:57.27   process pointer page   23 of   26 
 
07:12:57.32   process pointer page   24 of   26 
 
07:12:57.35   process pointer page   25 of   26 
 
07:12:57.35 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:12:57.96 Relation 265 (XQD_3300_3400) is ok 
 
 
07:12:57.96 Relation 266 (XQS_1000_1200) 
 
07:12:57.96   process pointer page    0 of   46 
 
07:12:57.99   process pointer page    1 of   46 
 
07:12:58.03   process pointer page    2 of   46 
 
07:12:58.07   process pointer page    3 of   46 
 
07:12:58.10   process pointer page    4 of   46 
 
07:12:58.13   process pointer page    5 of   46 
 
07:12:58.16   process pointer page    6 of   46 
 
07:12:58.19   process pointer page    7 of   46 
 
07:12:58.22   process pointer page    8 of   46 
 
07:12:58.25   process pointer page    9 of   46 
 
07:12:58.28   process pointer page   10 of   46 
 
07:12:58.32   process pointer page   11 of   46 
 
07:12:58.35   process pointer page   12 of   46 
 
07:12:58.38   process pointer page   13 of   46 
 
07:12:58.41   process pointer page   14 of   46 
 
07:12:58.44   process pointer page   15 of   46 
 
07:12:58.47   process pointer page   16 of   46 
 
07:12:58.50   process pointer page   17 of   46 
 
07:12:58.53   process pointer page   18 of   46 
 
07:12:58.56   process pointer page   19 of   46 
 
07:12:58.61   process pointer page   20 of   46 
 
07:12:58.69   process pointer page   21 of   46 
 
07:12:58.74   process pointer page   22 of   46 
 
07:12:58.77   process pointer page   23 of   46 
 
07:12:58.83   process pointer page   24 of   46 
 
07:12:58.89   process pointer page   25 of   46 
 
07:12:58.94   process pointer page   26 of   46 
 
07:12:59.02   process pointer page   27 of   46 
 
07:12:59.05   process pointer page   28 of   46 
 
07:12:59.08   process pointer page   29 of   46 
 
07:12:59.13   process pointer page   30 of   46 
 
07:12:59.16   process pointer page   31 of   46 
 
07:12:59.19   process pointer page   32 of   46 
 
07:12:59.22   process pointer page   33 of   46 
 
07:12:59.25   process pointer page   34 of   46 
 
07:12:59.28   process pointer page   35 of   46 
 
07:12:59.31   process pointer page   36 of   46 
 
07:12:59.34   process pointer page   37 of   46 
 
07:12:59.36   process pointer page   38 of   46 
 
07:12:59.42   process pointer page   39 of   46 
 
07:12:59.52   process pointer page   40 of   46 
 
07:12:59.56   process pointer page   41 of   46 
 
07:12:59.61   process pointer page   42 of   46 
 
07:12:59.64   process pointer page   43 of   46 
 
07:12:59.69   process pointer page   44 of   46 
 
07:12:59.75   process pointer page   45 of   46 
 
07:12:59.75 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:13:00.22 Index 2 (XQS_1000_1200_SND_ID) 
 
07:13:00.90 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:13:01.75 Relation 266 (XQS_1000_1200) is ok 
 
 
07:13:01.75 Relation 267 (XQS_1200_2000) 
 
07:13:01.75   process pointer page    0 of   49 
 
07:13:01.78   process pointer page    1 of   49 
 
07:13:01.81   process pointer page    2 of   49 
 
07:13:01.84   process pointer page    3 of   49 
 
07:13:01.87   process pointer page    4 of   49 
 
07:13:01.92   process pointer page    5 of   49 
 
07:13:02.03   process pointer page    6 of   49 
 
07:13:02.07   process pointer page    7 of   49 
 
07:13:02.11   process pointer page    8 of   49 
 
07:13:02.15   process pointer page    9 of   49 
 
07:13:02.18   process pointer page   10 of   49 
 
07:13:02.22   process pointer page   11 of   49 
 
07:13:02.26   process pointer page   12 of   49 
 
07:13:02.29   process pointer page   13 of   49 
 
07:13:02.39   process pointer page   14 of   49 
 
07:13:02.43   process pointer page   15 of   49 
 
07:13:02.50   process pointer page   16 of   49 
 
07:13:02.53   process pointer page   17 of   49 
 
07:13:02.57   process pointer page   18 of   49 
 
07:13:02.65   process pointer page   19 of   49 
 
07:13:02.75   process pointer page   20 of   49 
 
07:13:02.84   process pointer page   21 of   49 
 
07:13:02.93   process pointer page   22 of   49 
 
07:13:03.03   process pointer page   23 of   49 
 
07:13:03.12   process pointer page   24 of   49 
 
07:13:03.21   process pointer page   25 of   49 
 
07:13:03.31   process pointer page   26 of   49 
 
07:13:03.40   process pointer page   27 of   49 
 
07:13:03.43   process pointer page   28 of   49 
 
07:13:03.46   process pointer page   29 of   49 
 
07:13:03.54   process pointer page   30 of   49 
 
07:13:03.60   process pointer page   31 of   49 
 
07:13:03.65   process pointer page   32 of   49 
 
07:13:03.68   process pointer page   33 of   49 
 
07:13:03.71   process pointer page   34 of   49 
 
07:13:03.76   process pointer page   35 of   49 
 
07:13:03.79   process pointer page   36 of   49 
 
07:13:03.88   process pointer page   37 of   49 
 
07:13:03.98   process pointer page   38 of   49 
 
07:13:04.04   process pointer page   39 of   49 
 
07:13:04.09   process pointer page   40 of   49 
 
07:13:04.12   process pointer page   41 of   49 
 
07:13:04.17   process pointer page   42 of   49 
 
07:13:04.20   process pointer page   43 of   49 
 
07:13:04.23   process pointer page   44 of   49 
 
07:13:04.26   process pointer page   45 of   49 
 
07:13:04.29   process pointer page   46 of   49 
 
07:13:04.32   process pointer page   47 of   49 
 
07:13:04.35   process pointer page   48 of   49 
 
07:13:04.35 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:13:05.12 Index 2 (XQS_1200_2000_SND_ID) 
 
07:13:06.10 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:13:06.97 Relation 267 (XQS_1200_2000) is ok 
 
 
07:13:06.97 Relation 268 (XQS_1000_3300) 
 
07:13:06.97   process pointer page    0 of   27 
 
07:13:07.00   process pointer page    1 of   27 
 
07:13:07.04   process pointer page    2 of   27 
 
07:13:07.13   process pointer page    3 of   27 
 
07:13:07.18   process pointer page    4 of   27 
 
07:13:07.21   process pointer page    5 of   27 
 
07:13:07.25   process pointer page    6 of   27 
 
07:13:07.29   process pointer page    7 of   27 
 
07:13:07.38   process pointer page    8 of   27 
 
07:13:07.46   process pointer page    9 of   27 
 
07:13:07.55   process pointer page   10 of   27 
 
07:13:07.64   process pointer page   11 of   27 
 
07:13:07.74   process pointer page   12 of   27 
 
07:13:07.78   process pointer page   13 of   27 
 
07:13:07.82   process pointer page   14 of   27 
 
07:13:07.88   process pointer page   15 of   27 
 
07:13:07.97   process pointer page   16 of   27 
 
07:13:08.08   process pointer page   17 of   27 
 
07:13:08.21   process pointer page   18 of   27 
 
07:13:08.55   process pointer page   19 of   27 
 
07:13:08.94   process pointer page   20 of   27 
 
07:13:09.28   process pointer page   21 of   27 
 
07:13:09.70   process pointer page   22 of   27 
 
07:13:10.11   process pointer page   23 of   27 
 
07:13:10.53   process pointer page   24 of   27 
 
07:13:10.90   process pointer page   25 of   27 
 
07:13:11.14   process pointer page   26 of   27 
 
07:13:11.23 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:13:12.62 Index 2 (XQS_1000_3300_SND_ID) 
 
07:13:14.20 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:13:15.99 Relation 268 (XQS_1000_3300) is ok 
 
 
07:13:15.99 Relation 269 (XQS_2000_3300) 
 
07:13:15.99   process pointer page    0 of    1 
 
07:13:15.99 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:13:15.99 Index 2 (XQS_2000_3300_SND_ID) 
 
07:13:15.99 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:13:15.99 Relation 269 (XQS_2000_3300) is ok 
 
 
07:13:15.99 Relation 270 (XQS_2100_3300) 
 
07:13:15.99   process pointer page    0 of   34 
 
07:13:16.46   process pointer page    1 of   34 
 
07:13:16.97   process pointer page    2 of   34 
 
07:13:17.44   process pointer page    3 of   34 
 
07:13:17.89   process pointer page    4 of   34 
 
07:13:18.36   process pointer page    5 of   34 
 
07:13:18.83   process pointer page    6 of   34 
 
07:13:19.30   process pointer page    7 of   34 
 
07:13:19.77   process pointer page    8 of   34 
 
07:13:20.20   process pointer page    9 of   34 
 
07:13:20.67   process pointer page   10 of   34 
 
07:13:21.14   process pointer page   11 of   34 
 
07:13:21.59   process pointer page   12 of   34 
 
07:13:22.04   process pointer page   13 of   34 
 
07:13:22.35   process pointer page   14 of   34 
 
07:13:22.73   process pointer page   15 of   34 
 
07:13:23.21   process pointer page   16 of   34 
 
07:13:23.67   process pointer page   17 of   34 
 
07:13:24.12   process pointer page   18 of   34 
 
07:13:24.57   process pointer page   19 of   34 
 
07:13:25.01   process pointer page   20 of   34 
 
07:13:25.47   process pointer page   21 of   34 
 
07:13:25.93   process pointer page   22 of   34 
 
07:13:26.38   process pointer page   23 of   34 
 
07:13:26.85   process pointer page   24 of   34 
 
07:13:27.30   process pointer page   25 of   34 
 
07:13:27.75   process pointer page   26 of   34 
 
07:13:28.20   process pointer page   27 of   34 
 
07:13:28.66   process pointer page   28 of   34 
 
07:13:29.11   process pointer page   29 of   34 
 
07:13:29.55   process pointer page   30 of   34 
 
07:13:30.00   process pointer page   31 of   34 
 
07:13:30.42   process pointer page   32 of   34 
 
07:13:30.79   process pointer page   33 of   34 
 
07:13:30.84 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:13:32.59 Index 2 (XQS_2100_3300_SND_ID) 
 
07:13:34.32 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:13:36.33 Relation 270 (XQS_2100_3300) is ok 
 
 
07:13:36.33 Relation 271 (XQS_3300_3400) 
 
07:13:36.33   process pointer page    0 of    5 
 
07:13:36.78   process pointer page    1 of    5 
 
07:13:37.25   process pointer page    2 of    5 
 
07:13:37.74   process pointer page    3 of    5 
 
07:13:38.20   process pointer page    4 of    5 
 
07:13:38.66 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:13:39.02 Index 2 (XQS_3300_3400_SND_ID) 
 
07:13:39.39 Relation 271 (XQS_3300_3400) is ok 
 
 
07:13:39.41 Validation finished 
 
Done for 68910 ms, from  7:12:30.59 to  7:13:39.50. 
 
 Differences between old and current firebird.log 
7:13:41.25. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2017-12-03  07:13               471 oltp30_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Sun Dec 03 07:12:30 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Sun Dec 03 07:13:39 2017 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 401 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*: 
 
 
|  ERRORS_CHECKING_RESULT  | 
|  NO_SEVERE_ERRORS_FOUND  | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2017-12-03  7:13:47.80 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html