Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-08-22  6:50:36.74.
 
Server version: WI-V3.0.3.32798 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-08-22 06:47:05.8340  | 
 -1  | 
 <null>  | 
   | 
 ::1/51742  | 
 419021  | 
 9259  | 
 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:  | 
 5917.97  | 
 2991  | 
 1065235  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  customer order: creation  | 
 428.76  | 
 453  | 
 77177  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  customer order: refuse  | 
 35.40  | 
 222  | 
 6372  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  order to supplier: creation  | 
 109.26  | 
 1947  | 
 19667  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  order to supplier: removal  | 
 2.97  | 
 17187  | 
 532  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  invoice (draft): creation  | 
 110.13  | 
 2953  | 
 19824  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  invoice (draft): removal  | 
 42.57  | 
 393  | 
 7662  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  invoice accept: apply  | 
 60.75  | 
 10422  | 
 10875  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  invoice accept: cancel  | 
 18.22  | 
 2556  | 
 3261  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  customer reserve: creation  | 
 3381.66  | 
 151  | 
 608698  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  customer reserve: removal  | 
 1140.25  | 
 55  | 
 204104  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  realization accept: apply  | 
 197.48  | 
 506  | 
 35546  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  realization accept: cancel  | 
 88.96  | 
 137  | 
 16012  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  payment from customer: creation  | 
 143.71  | 
 823  | 
 25868  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  payment from customer: removal  | 
 13.42  | 
 132  | 
 2415  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  payment to supplier: creation  | 
 118.27  | 
 726  | 
 21288  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  payment to supplier: removal  | 
 8.18  | 
 128  | 
 1465  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  service: total inventory turnovers  | 
 9.19  | 
 2555  | 
 1654  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  service: total monetary turnovers  | 
 15.57  | 
 66  | 
 2803  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  service: refresh index statistics  | 
 0.07  | 
 15415  | 
 12  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
 
Done for 82270 ms, from  6:53:00.67 to  6:54:22.94.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4267  | 
 90394  | 
 76809  | 
 13585  | 
 15.03  | 
 03:47:06  | 
 04:05:06  | 
|  interval #   2, overall  | 
 2  | 
 6224  | 
 125751  | 
 112039  | 
 13712  | 
 10.90  | 
 04:05:07  | 
 04:23:07  | 
|  interval #   3, overall  | 
 3  | 
 6249  | 
 127521  | 
 112484  | 
 15037  | 
 11.79  | 
 04:23:08  | 
 04:41:08  | 
|  interval #   4, overall  | 
 4  | 
 5698  | 
 114900  | 
 102566  | 
 12334  | 
 10.73  | 
 04:41:09  | 
 04:59:09  | 
|  interval #   5, overall  | 
 5  | 
 6099  | 
 123916  | 
 109780  | 
 14136  | 
 11.41  | 
 04:59:10  | 
 05:17:10  | 
|  interval #   6, overall  | 
 6  | 
 6017  | 
 120757  | 
 108303  | 
 12454  | 
 10.31  | 
 05:17:11  | 
 05:35:11  | 
|  interval #   7, overall  | 
 7  | 
 5948  | 
 123851  | 
 107064  | 
 16787  | 
 13.55  | 
 05:35:12  | 
 05:53:12  | 
|  interval #   8, overall  | 
 8  | 
 6128  | 
 121174  | 
 110303  | 
 10871  | 
 8.97  | 
 05:53:13  | 
 06:11:13  | 
|  interval #   9, overall  | 
 9  | 
 6673  | 
 133594  | 
 120106  | 
 13488  | 
 10.10  | 
 06:11:14  | 
 06:29:14  | 
|  interval #  10, overall  | 
 10  | 
 5877  | 
 116271  | 
 105781  | 
 10490  | 
 9.02  | 
 06:29:15  | 
 06:47:15  | 
 
Done for 222310 ms, from  6:58:09.60 to  7:01:51.91.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 3943.90  | 
 0.5489  | 
 1.4440  | 
 1961  | 
 99  | 
|  TEST_TIME  | 
 2  | 
 3812.47  | 
 0.7472  | 
 1.2646  | 
 2039  | 
 99  | 
|  TEST_TIME  | 
 3  | 
 3869.28  | 
 0.8308  | 
 1.1352  | 
 2055  | 
 99  | 
|  TEST_TIME  | 
 4  | 
 3694.00  | 
 0.8919  | 
 1.1474  | 
 1626  | 
 99  | 
|  TEST_TIME  | 
 5  | 
 3739.44  | 
 0.9069  | 
 1.0961  | 
 1506  | 
 99  | 
|  TEST_TIME  | 
 6  | 
 3730.31  | 
 0.9156  | 
 1.1044  | 
 1156  | 
 99  | 
|  TEST_TIME  | 
 7  | 
 3819.33  | 
 0.9246  | 
 1.0786  | 
 1729  | 
 99  | 
|  TEST_TIME  | 
 8  | 
 3901.08  | 
 0.9242  | 
 1.0704  | 
 1628  | 
 99  | 
|  TEST_TIME  | 
 9  | 
 3984.02  | 
 0.9318  | 
 1.0622  | 
 1739  | 
 99  | 
|  TEST_TIME  | 
 10  | 
 4091.66  | 
 0.9316  | 
 1.0690  | 
 1535  | 
 99  | 
|  TEST_TIME  | 
 11  | 
 4172.43  | 
 0.9530  | 
 1.0558  | 
 1516  | 
 99  | 
|  TEST_TIME  | 
 12  | 
 4251.68  | 
 0.9498  | 
 1.0511  | 
 1553  | 
 99  | 
|  TEST_TIME  | 
 13  | 
 4275.37  | 
 0.9649  | 
 1.0355  | 
 1636  | 
 99  | 
|  TEST_TIME  | 
 14  | 
 4297.77  | 
 0.9577  | 
 1.0445  | 
 1477  | 
 99  | 
|  TEST_TIME  | 
 15  | 
 4270.40  | 
 0.9811  | 
 1.0161  | 
 1532  | 
 96  | 
|  TEST_TIME  | 
 16  | 
 4215.06  | 
 0.9652  | 
 1.0523  | 
 1699  | 
 97  | 
|  TEST_TIME  | 
 17  | 
 4359.89  | 
 0.9575  | 
 1.0232  | 
 1639  | 
 99  | 
|  TEST_TIME  | 
 18  | 
 4297.85  | 
 0.9804  | 
 1.0400  | 
 1246  | 
 96  | 
|  TEST_TIME  | 
 19  | 
 4348.53  | 
 0.9753  | 
 1.0318  | 
 1548  | 
 99  | 
|  TEST_TIME  | 
 20  | 
 4325.26  | 
 0.9855  | 
 1.0528  | 
 1490  | 
 98  | 
|  TEST_TIME  | 
 21  | 
 4447.62  | 
 0.9751  | 
 1.0335  | 
 1469  | 
 99  | 
|  TEST_TIME  | 
 22  | 
 4547.25  | 
 0.9649  | 
 1.0331  | 
 1674  | 
 99  | 
|  TEST_TIME  | 
 23  | 
 4602.92  | 
 0.9763  | 
 1.0263  | 
 1130  | 
 99  | 
|  TEST_TIME  | 
 24  | 
 4657.31  | 
 0.9720  | 
 1.0320  | 
 1643  | 
 99  | 
|  TEST_TIME  | 
 25  | 
 4723.65  | 
 0.9768  | 
 1.0274  | 
 1569  | 
 99  | 
|  TEST_TIME  | 
 26  | 
 4774.52  | 
 0.9774  | 
 1.0285  | 
 1399  | 
 99  | 
|  TEST_TIME  | 
 27  | 
 4823.50  | 
 0.9807  | 
 1.0199  | 
 1343  | 
 99  | 
|  TEST_TIME  | 
 28  | 
 4829.97  | 
 0.9822  | 
 1.0178  | 
 1416  | 
 99  | 
|  TEST_TIME  | 
 29  | 
 4831.39  | 
 0.9826  | 
 1.0194  | 
 1303  | 
 99  | 
|  TEST_TIME  | 
 30  | 
 4889.48  | 
 0.9737  | 
 1.0257  | 
 1891  | 
 99  | 
|  TEST_TIME  | 
 31  | 
 5005.60  | 
 0.9696  | 
 1.0267  | 
 1940  | 
 99  | 
|  TEST_TIME  | 
 32  | 
 5104.96  | 
 0.9759  | 
 1.0280  | 
 1884  | 
 99  | 
|  TEST_TIME  | 
 33  | 
 5194.17  | 
 0.9797  | 
 1.0213  | 
 1862  | 
 99  | 
|  TEST_TIME  | 
 34  | 
 5268.88  | 
 0.9772  | 
 1.0201  | 
 1759  | 
 99  | 
|  TEST_TIME  | 
 35  | 
 5273.69  | 
 0.9901  | 
 1.0104  | 
 1695  | 
 99  | 
|  TEST_TIME  | 
 36  | 
 5284.05  | 
 0.9804  | 
 1.0170  | 
 1172  | 
 99  | 
|  TEST_TIME  | 
 37  | 
 5274.78  | 
 0.9913  | 
 1.0067  | 
 1374  | 
 99  | 
|  TEST_TIME  | 
 38  | 
 5216.00  | 
 0.9913  | 
 1.0180  | 
 1103  | 
 99  | 
|  TEST_TIME  | 
 39  | 
 5221.44  | 
 0.9908  | 
 1.0139  | 
 1278  | 
 99  | 
|  TEST_TIME  | 
 40  | 
 5221.06  | 
 0.9886  | 
 1.0138  | 
 1286  | 
 99  | 
|  TEST_TIME  | 
 41  | 
 5215.47  | 
 0.9902  | 
 1.0070  | 
 1447  | 
 98  | 
|  TEST_TIME  | 
 42  | 
 5192.35  | 
 0.9874  | 
 1.0114  | 
 1374  | 
 99  | 
|  TEST_TIME  | 
 43  | 
 5200.22  | 
 0.9864  | 
 1.0135  | 
 1219  | 
 99  | 
|  TEST_TIME  | 
 44  | 
 5216.07  | 
 0.9875  | 
 1.0114  | 
 1236  | 
 99  | 
|  TEST_TIME  | 
 45  | 
 5246.24  | 
 0.9843  | 
 1.0147  | 
 2203  | 
 99  | 
|  TEST_TIME  | 
 46  | 
 5285.53  | 
 0.9852  | 
 1.0136  | 
 1729  | 
 99  | 
|  TEST_TIME  | 
 47  | 
 5322.52  | 
 0.9851  | 
 1.0175  | 
 1668  | 
 99  | 
|  TEST_TIME  | 
 48  | 
 5407.21  | 
 0.9813  | 
 1.0168  | 
 1793  | 
 99  | 
|  TEST_TIME  | 
 49  | 
 5448.17  | 
 0.9886  | 
 1.0132  | 
 1659  | 
 99  | 
|  TEST_TIME  | 
 50  | 
 5495.53  | 
 0.9849  | 
 1.0131  | 
 1596  | 
 99  | 
|  TEST_TIME  | 
 51  | 
 5532.58  | 
 0.9866  | 
 1.0216  | 
 1571  | 
 99  | 
|  TEST_TIME  | 
 52  | 
 5608.87  | 
 0.9884  | 
 1.0126  | 
 1264  | 
 99  | 
|  TEST_TIME  | 
 53  | 
 5622.20  | 
 0.9912  | 
 1.0072  | 
 1236  | 
 99  | 
|  TEST_TIME  | 
 54  | 
 5612.96  | 
 0.9902  | 
 1.0107  | 
 1131  | 
 99  | 
|  TEST_TIME  | 
 55  | 
 5611.58  | 
 0.9926  | 
 1.0055  | 
 1306  | 
 98  | 
|  TEST_TIME  | 
 56  | 
 5566.00  | 
 0.9956  | 
 1.0094  | 
 1237  | 
 97  | 
|  TEST_TIME  | 
 57  | 
 5547.90  | 
 0.9949  | 
 1.0083  | 
 1176  | 
 99  | 
|  TEST_TIME  | 
 58  | 
 5540.41  | 
 0.9928  | 
 1.0069  | 
 1008  | 
 99  | 
|  TEST_TIME  | 
 59  | 
 5532.06  | 
 0.9914  | 
 1.0071  | 
 1155  | 
 99  | 
|  TEST_TIME  | 
 60  | 
 5529.53  | 
 0.9908  | 
 1.0114  | 
 1567  | 
 99  | 
|  TEST_TIME  | 
 61  | 
 5532.07  | 
 0.9944  | 
 1.0150  | 
 1775  | 
 98  | 
|  TEST_TIME  | 
 62  | 
 5563.45  | 
 0.9930  | 
 1.0064  | 
 2078  | 
 98  | 
|  TEST_TIME  | 
 63  | 
 5561.36  | 
 0.9908  | 
 1.0044  | 
 1479  | 
 99  | 
|  TEST_TIME  | 
 64  | 
 5558.52  | 
 0.9893  | 
 1.0077  | 
 1511  | 
 98  | 
|  TEST_TIME  | 
 65  | 
 5548.50  | 
 0.9940  | 
 1.0071  | 
 1762  | 
 96  | 
|  TEST_TIME  | 
 66  | 
 5560.80  | 
 0.9896  | 
 1.0085  | 
 1440  | 
 98  | 
|  TEST_TIME  | 
 67  | 
 5574.08  | 
 0.9911  | 
 1.0064  | 
 1311  | 
 99  | 
|  TEST_TIME  | 
 68  | 
 5581.54  | 
 0.9903  | 
 1.0080  | 
 1373  | 
 99  | 
|  TEST_TIME  | 
 69  | 
 5590.93  | 
 0.9917  | 
 1.0121  | 
 1512  | 
 99  | 
|  TEST_TIME  | 
 70  | 
 5623.26  | 
 0.9919  | 
 1.0069  | 
 1541  | 
 99  | 
|  TEST_TIME  | 
 71  | 
 5619.30  | 
 0.9934  | 
 1.0051  | 
 1492  | 
 99  | 
|  TEST_TIME  | 
 72  | 
 5622.27  | 
 0.9906  | 
 1.0073  | 
 1234  | 
 99  | 
|  TEST_TIME  | 
 73  | 
 5628.41  | 
 0.9924  | 
 1.0050  | 
 1208  | 
 98  | 
|  TEST_TIME  | 
 74  | 
 5600.64  | 
 0.9964  | 
 1.0073  | 
 1138  | 
 99  | 
|  TEST_TIME  | 
 75  | 
 5599.79  | 
 0.9941  | 
 1.0055  | 
 1644  | 
 99  | 
|  TEST_TIME  | 
 76  | 
 5604.69  | 
 0.9914  | 
 1.0084  | 
 1470  | 
 99  | 
|  TEST_TIME  | 
 77  | 
 5640.47  | 
 0.9890  | 
 1.0054  | 
 1614  | 
 99  | 
|  TEST_TIME  | 
 78  | 
 5626.02  | 
 0.9950  | 
 1.0100  | 
 1546  | 
 97  | 
|  TEST_TIME  | 
 79  | 
 5642.87  | 
 0.9943  | 
 1.0039  | 
 1658  | 
 99  | 
|  TEST_TIME  | 
 80  | 
 5666.15  | 
 0.9909  | 
 1.0051  | 
 1378  | 
 99  | 
|  TEST_TIME  | 
 81  | 
 5666.72  | 
 0.9926  | 
 1.0086  | 
 1418  | 
 99  | 
|  TEST_TIME  | 
 82  | 
 5672.51  | 
 0.9953  | 
 1.0094  | 
 1470  | 
 99  | 
|  TEST_TIME  | 
 83  | 
 5681.50  | 
 0.9956  | 
 1.0037  | 
 1712  | 
 98  | 
|  TEST_TIME  | 
 84  | 
 5674.80  | 
 0.9929  | 
 1.0089  | 
 1386  | 
 99  | 
|  TEST_TIME  | 
 85  | 
 5707.50  | 
 0.9913  | 
 1.0080  | 
 1135  | 
 99  | 
|  TEST_TIME  | 
 86  | 
 5721.89  | 
 0.9938  | 
 1.0052  | 
 1083  | 
 99  | 
|  TEST_TIME  | 
 87  | 
 5720.89  | 
 0.9939  | 
 1.0064  | 
 1292  | 
 99  | 
|  TEST_TIME  | 
 88  | 
 5723.97  | 
 0.9945  | 
 1.0061  | 
 1131  | 
 99  | 
|  TEST_TIME  | 
 89  | 
 5733.15  | 
 0.9932  | 
 1.0049  | 
 931  | 
 99  | 
|  TEST_TIME  | 
 90  | 
 5735.17  | 
 0.9934  | 
 1.0041  | 
 1828  | 
 99  | 
|  TEST_TIME  | 
 91  | 
 5726.04  | 
 0.9947  | 
 1.0081  | 
 1735  | 
 95  | 
|  TEST_TIME  | 
 92  | 
 5743.00  | 
 0.9942  | 
 1.0104  | 
 1573  | 
 98  | 
|  TEST_TIME  | 
 93  | 
 5777.43  | 
 0.9936  | 
 1.0053  | 
 1650  | 
 99  | 
|  TEST_TIME  | 
 94  | 
 5783.17  | 
 0.9936  | 
 1.0073  | 
 1669  | 
 99  | 
|  TEST_TIME  | 
 95  | 
 5791.37  | 
 0.9953  | 
 1.0058  | 
 1434  | 
 99  | 
|  TEST_TIME  | 
 96  | 
 5784.32  | 
 0.9965  | 
 1.0046  | 
 1201  | 
 98  | 
|  TEST_TIME  | 
 97  | 
 5780.56  | 
 0.9949  | 
 1.0044  | 
 1389  | 
 99  | 
|  TEST_TIME  | 
 98  | 
 5778.93  | 
 0.9944  | 
 1.0054  | 
 1260  | 
 99  | 
|  TEST_TIME  | 
 99  | 
 5799.83  | 
 0.9920  | 
 1.0047  | 
 1186  | 
 99  | 
|  TEST_TIME  | 
 100  | 
 5806.11  | 
 0.9935  | 
 1.0063  | 
 1028  | 
 99  | 
|  TEST_TIME  | 
 101  | 
 5807.09  | 
 0.9962  | 
 1.0025  | 
 1309  | 
 99  | 
|  TEST_TIME  | 
 102  | 
 5776.38  | 
 0.9979  | 
 1.0022  | 
 1206  | 
 95  | 
|  TEST_TIME  | 
 103  | 
 5769.94  | 
 0.9935  | 
 1.0035  | 
 1121  | 
 99  | 
|  TEST_TIME  | 
 104  | 
 5749.00  | 
 0.9975  | 
 1.0038  | 
 1180  | 
 98  | 
|  TEST_TIME  | 
 105  | 
 5733.46  | 
 0.9969  | 
 1.0034  | 
 1305  | 
 97  | 
|  TEST_TIME  | 
 106  | 
 5750.69  | 
 0.9913  | 
 1.0040  | 
 1965  | 
 99  | 
|  TEST_TIME  | 
 107  | 
 5752.37  | 
 0.9943  | 
 1.0063  | 
 1793  | 
 98  | 
|  TEST_TIME  | 
 108  | 
 5775.54  | 
 0.9930  | 
 1.0066  | 
 1502  | 
 99  | 
|  TEST_TIME  | 
 109  | 
 5796.05  | 
 0.9940  | 
 1.0056  | 
 1892  | 
 99  | 
|  TEST_TIME  | 
 110  | 
 5808.46  | 
 0.9943  | 
 1.0052  | 
 1513  | 
 99  | 
|  TEST_TIME  | 
 111  | 
 5814.97  | 
 0.9950  | 
 1.0050  | 
 1466  | 
 99  | 
|  TEST_TIME  | 
 112  | 
 5827.98  | 
 0.9938  | 
 1.0040  | 
 1457  | 
 99  | 
|  TEST_TIME  | 
 113  | 
 5819.61  | 
 0.9966  | 
 1.0031  | 
 1443  | 
 98  | 
|  TEST_TIME  | 
 114  | 
 5806.13  | 
 0.9966  | 
 1.0036  | 
 1378  | 
 94  | 
|  TEST_TIME  | 
 115  | 
 5798.58  | 
 0.9961  | 
 1.0031  | 
 1060  | 
 90  | 
|  TEST_TIME  | 
 116  | 
 5806.16  | 
 0.9982  | 
 1.0029  | 
 1295  | 
 93  | 
|  TEST_TIME  | 
 117  | 
 5806.88  | 
 0.9942  | 
 1.0060  | 
 866  | 
 97  | 
|  TEST_TIME  | 
 118  | 
 5805.15  | 
 0.9978  | 
 1.0051  | 
 1008  | 
 99  | 
|  TEST_TIME  | 
 119  | 
 5799.98  | 
 0.9975  | 
 1.0030  | 
 1108  | 
 99  | 
|  TEST_TIME  | 
 120  | 
 5793.00  | 
 0.9958  | 
 1.0054  | 
 1625  | 
 99  | 
|  TEST_TIME  | 
 121  | 
 5794.72  | 
 0.9968  | 
 1.0031  | 
 1835  | 
 98  | 
|  TEST_TIME  | 
 122  | 
 5799.86  | 
 0.9940  | 
 1.0023  | 
 1616  | 
 98  | 
|  TEST_TIME  | 
 123  | 
 5795.76  | 
 0.9948  | 
 1.0029  | 
 1629  | 
 98  | 
|  TEST_TIME  | 
 124  | 
 5798.63  | 
 0.9944  | 
 1.0033  | 
 1532  | 
 93  | 
|  TEST_TIME  | 
 125  | 
 5798.93  | 
 0.9952  | 
 1.0024  | 
 1613  | 
 96  | 
|  TEST_TIME  | 
 126  | 
 5788.68  | 
 0.9962  | 
 1.0035  | 
 1476  | 
 94  | 
|  TEST_TIME  | 
 127  | 
 5783.21  | 
 0.9965  | 
 1.0034  | 
 1382  | 
 92  | 
|  TEST_TIME  | 
 128  | 
 5787.90  | 
 0.9947  | 
 1.0028  | 
 1201  | 
 96  | 
|  TEST_TIME  | 
 129  | 
 5769.83  | 
 0.9981  | 
 1.0026  | 
 1295  | 
 96  | 
|  TEST_TIME  | 
 130  | 
 5785.05  | 
 0.9951  | 
 1.0020  | 
 1394  | 
 98  | 
|  TEST_TIME  | 
 131  | 
 5771.02  | 
 0.9968  | 
 1.0054  | 
 1215  | 
 98  | 
|  TEST_TIME  | 
 132  | 
 5801.63  | 
 0.9925  | 
 1.0039  | 
 1144  | 
 99  | 
|  TEST_TIME  | 
 133  | 
 5804.31  | 
 0.9959  | 
 1.0038  | 
 1206  | 
 99  | 
|  TEST_TIME  | 
 134  | 
 5811.16  | 
 0.9952  | 
 1.0049  | 
 1112  | 
 99  | 
|  TEST_TIME  | 
 135  | 
 5821.66  | 
 0.9957  | 
 1.0028  | 
 1814  | 
 98  | 
|  TEST_TIME  | 
 136  | 
 5834.40  | 
 0.9933  | 
 1.0051  | 
 1533  | 
 99  | 
|  TEST_TIME  | 
 137  | 
 5850.38  | 
 0.9953  | 
 1.0042  | 
 1681  | 
 99  | 
|  TEST_TIME  | 
 138  | 
 5850.16  | 
 0.9971  | 
 1.0029  | 
 1459  | 
 97  | 
|  TEST_TIME  | 
 139  | 
 5858.83  | 
 0.9943  | 
 1.0028  | 
 1463  | 
 94  | 
|  TEST_TIME  | 
 140  | 
 5861.64  | 
 0.9953  | 
 1.0022  | 
 1273  | 
 97  | 
|  TEST_TIME  | 
 141  | 
 5855.14  | 
 0.9962  | 
 1.0031  | 
 1224  | 
 95  | 
|  TEST_TIME  | 
 142  | 
 5842.19  | 
 0.9983  | 
 1.0028  | 
 1242  | 
 96  | 
|  TEST_TIME  | 
 143  | 
 5831.44  | 
 0.9977  | 
 1.0025  | 
 1500  | 
 95  | 
|  TEST_TIME  | 
 144  | 
 5825.31  | 
 0.9966  | 
 1.0034  | 
 1372  | 
 95  | 
|  TEST_TIME  | 
 145  | 
 5819.40  | 
 0.9975  | 
 1.0026  | 
 1316  | 
 88  | 
|  TEST_TIME  | 
 146  | 
 5816.57  | 
 0.9962  | 
 1.0032  | 
 1283  | 
 92  | 
|  TEST_TIME  | 
 147  | 
 5821.91  | 
 0.9955  | 
 1.0039  | 
 1045  | 
 99  | 
|  TEST_TIME  | 
 148  | 
 5829.22  | 
 0.9959  | 
 1.0029  | 
 1075  | 
 98  | 
|  TEST_TIME  | 
 149  | 
 5822.33  | 
 0.9974  | 
 1.0047  | 
 1191  | 
 99  | 
|  TEST_TIME  | 
 150  | 
 5838.12  | 
 0.9953  | 
 1.0056  | 
 1634  | 
 99  | 
|  TEST_TIME  | 
 151  | 
 5861.62  | 
 0.9950  | 
 1.0057  | 
 1506  | 
 99  | 
|  TEST_TIME  | 
 152  | 
 5886.10  | 
 0.9951  | 
 1.0044  | 
 1465  | 
 99  | 
|  TEST_TIME  | 
 153  | 
 5897.98  | 
 0.9958  | 
 1.0057  | 
 1394  | 
 99  | 
|  TEST_TIME  | 
 154  | 
 5921.41  | 
 0.9953  | 
 1.0057  | 
 1449  | 
 99  | 
|  TEST_TIME  | 
 155  | 
 5940.53  | 
 0.9960  | 
 1.0032  | 
 1279  | 
 99  | 
|  TEST_TIME  | 
 156  | 
 5953.77  | 
 0.9945  | 
 1.0046  | 
 1259  | 
 99  | 
|  TEST_TIME  | 
 157  | 
 5960.99  | 
 0.9970  | 
 1.0035  | 
 1332  | 
 99  | 
|  TEST_TIME  | 
 158  | 
 5955.75  | 
 0.9980  | 
 1.0018  | 
 1438  | 
 97  | 
|  TEST_TIME  | 
 159  | 
 5937.99  | 
 0.9984  | 
 1.0015  | 
 1325  | 
 88  | 
|  TEST_TIME  | 
 160  | 
 5925.71  | 
 0.9973  | 
 1.0023  | 
 1171  | 
 95  | 
|  TEST_TIME  | 
 161  | 
 5913.74  | 
 0.9981  | 
 1.0017  | 
 1149  | 
 88  | 
|  TEST_TIME  | 
 162  | 
 5924.28  | 
 0.9972  | 
 1.0022  | 
 1083  | 
 99  | 
|  TEST_TIME  | 
 163  | 
 5924.01  | 
 0.9961  | 
 1.0019  | 
 985  | 
 99  | 
|  TEST_TIME  | 
 164  | 
 5904.27  | 
 0.9991  | 
 1.0017  | 
 1109  | 
 96  | 
|  TEST_TIME  | 
 165  | 
 5897.74  | 
 0.9967  | 
 1.0044  | 
 1082  | 
 98  | 
|  TEST_TIME  | 
 166  | 
 5899.66  | 
 0.9981  | 
 1.0041  | 
 1653  | 
 92  | 
|  TEST_TIME  | 
 167  | 
 5913.83  | 
 0.9957  | 
 1.0039  | 
 1567  | 
 91  | 
|  TEST_TIME  | 
 168  | 
 5916.69  | 
 0.9974  | 
 1.0052  | 
 1093  | 
 96  | 
|  TEST_TIME  | 
 169  | 
 5934.27  | 
 0.9963  | 
 1.0047  | 
 1210  | 
 99  | 
|  TEST_TIME  | 
 170  | 
 5941.42  | 
 0.9975  | 
 1.0020  | 
 1506  | 
 99  | 
|  TEST_TIME  | 
 171  | 
 5930.09  | 
 0.9980  | 
 1.0024  | 
 1470  | 
 92  | 
|  TEST_TIME  | 
 172  | 
 5930.83  | 
 0.9964  | 
 1.0030  | 
 1363  | 
 97  | 
|  TEST_TIME  | 
 173  | 
 5925.19  | 
 0.9982  | 
 1.0027  | 
 1436  | 
 91  | 
|  TEST_TIME  | 
 174  | 
 5933.43  | 
 0.9955  | 
 1.0015  | 
 1157  | 
 98  | 
|  TEST_TIME  | 
 175  | 
 5926.96  | 
 0.9981  | 
 1.0018  | 
 1253  | 
 99  | 
|  TEST_TIME  | 
 176  | 
 5915.91  | 
 0.9980  | 
 1.0033  | 
 1241  | 
 98  | 
|  TEST_TIME  | 
 177  | 
 5925.98  | 
 0.9959  | 
 1.0022  | 
 1309  | 
 99  | 
|  TEST_TIME  | 
 178  | 
 5919.63  | 
 0.9977  | 
 1.0019  | 
 1244  | 
 99  | 
|  TEST_TIME  | 
 179  | 
 5905.42  | 
 0.9987  | 
 1.0069  | 
 1135  | 
 99  | 
|  TEST_TIME  | 
 180  | 
 5917.43  | 
 0.9992  | 
 1.0000  | 
 181  | 
 98  | 
 
Done for 10240 ms, from  7:01:52.86 to  7:02:03.10.  
 
 
|  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  | 
 75079  | 
 73513  | 
 51591  | 
 90393  | 
 60442  | 
 25547  | 
 69631  | 
 <null>  | 
 65668  | 
 119105  | 
 68710  | 
 26594  | 
 97270  | 
 55153  | 
 160319  | 
 62923  | 
 15170  | 
 463498  | 
 <null>  | 
 03:47:06  | 
 04:05:06  | 
|  fetches per second  | 
 2  | 
 65405  | 
 118215  | 
 51032  | 
 <null>  | 
 46846  | 
 50249  | 
 64848  | 
 63858  | 
 76981  | 
 5403  | 
 68153  | 
 31031  | 
 75842  | 
 45069  | 
 166072  | 
 82725  | 
 183879  | 
 281075  | 
 <null>  | 
 04:05:07  | 
 04:23:07  | 
|  fetches per second  | 
 3  | 
 49644  | 
 56443  | 
 34197  | 
 50867  | 
 50986  | 
 <null>  | 
 64587  | 
 105718  | 
 31961  | 
 83000  | 
 71265  | 
 52709  | 
 54457  | 
 57584  | 
 90115  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 04:23:08  | 
 04:41:08  | 
|  fetches per second  | 
 4  | 
 29544  | 
 4574  | 
 11696  | 
 7083  | 
 20566  | 
 <null>  | 
 56064  | 
 142581  | 
 673  | 
 123241  | 
 33157  | 
 41711  | 
 19319  | 
 514  | 
 62287  | 
 26216  | 
 16246  | 
 16584  | 
 <null>  | 
 04:41:09  | 
 04:59:09  | 
|  fetches per second  | 
 5  | 
 33706  | 
 78836  | 
 25079  | 
 83424  | 
 18105  | 
 49188  | 
 40523  | 
 38725  | 
 22009  | 
 119475  | 
 35197  | 
 1299  | 
 42797  | 
 <null>  | 
 82426  | 
 195500  | 
 97630  | 
 9734  | 
 <null>  | 
 04:59:10  | 
 05:17:10  | 
|  fetches per second  | 
 6  | 
 12046  | 
 2200  | 
 17166  | 
 <null>  | 
 6679  | 
 <null>  | 
 29253  | 
 <null>  | 
 11721  | 
 2887  | 
 15492  | 
 1493  | 
 30172  | 
 4856  | 
 8994  | 
 10714  | 
 11506  | 
 161472  | 
 <null>  | 
 05:17:11  | 
 05:35:11  | 
|  fetches per second  | 
 7  | 
 28516  | 
 22244  | 
 35194  | 
 <null>  | 
 24424  | 
 4070  | 
 40789  | 
 <null>  | 
 47281  | 
 34442  | 
 19955  | 
 21152  | 
 27427  | 
 3967  | 
 80302  | 
 <null>  | 
 76129  | 
 262302  | 
 <null>  | 
 05:35:12  | 
 05:53:12  | 
|  fetches per second  | 
 8  | 
 15689  | 
 12168  | 
 16976  | 
 <null>  | 
 11536  | 
 <null>  | 
 26635  | 
 46153  | 
 3378  | 
 <null>  | 
 22158  | 
 2027  | 
 31618  | 
 14418  | 
 43668  | 
 1304  | 
 <null>  | 
 19160  | 
 <null>  | 
 05:53:13  | 
 06:11:13  | 
|  fetches per second  | 
 9  | 
 34446  | 
 111177  | 
 35427  | 
 <null>  | 
 20306  | 
 8557  | 
 54672  | 
 16327  | 
 98025  | 
 5091  | 
 44494  | 
 13701  | 
 31255  | 
 53652  | 
 73980  | 
 79583  | 
 <null>  | 
 58648  | 
 <null>  | 
 06:11:14  | 
 06:29:14  | 
|  fetches per second  | 
 10  | 
 19919  | 
 6529  | 
 8928  | 
 <null>  | 
 9142  | 
 24102  | 
 6442  | 
 <null>  | 
 15469  | 
 2600  | 
 6495  | 
 3774  | 
 5619  | 
 1135  | 
 28494  | 
 <null>  | 
 35042  | 
 151695  | 
 <null>  | 
 06:29:15  | 
 06:47:15  | 
|  marks per second  | 
 1  | 
 16434  | 
 8628  | 
 11314  | 
 17514  | 
 12707  | 
 5067  | 
 9153  | 
 <null>  | 
 9486  | 
 21783  | 
 11632  | 
 4594  | 
 9407  | 
 7461  | 
 8379  | 
 10538  | 
 2902  | 
 47540  | 
 <null>  | 
 03:47:06  | 
 04:05:06  | 
|  marks per second  | 
 2  | 
 13740  | 
 15975  | 
 11349  | 
 <null>  | 
 10375  | 
 10954  | 
 8415  | 
 9495  | 
 8906  | 
 948  | 
 9501  | 
 5380  | 
 8436  | 
 9012  | 
 9693  | 
 20693  | 
 14958  | 
 24236  | 
 <null>  | 
 04:05:07  | 
 04:23:07  | 
|  marks per second  | 
 3  | 
 10584  | 
 6664  | 
 7217  | 
 7372  | 
 11018  | 
 <null>  | 
 7273  | 
 18521  | 
 3477  | 
 12142  | 
 9954  | 
 8185  | 
 2938  | 
 12667  | 
 4912  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 04:23:08  | 
 04:41:08  | 
|  marks per second  | 
 4  | 
 5811  | 
 574  | 
 2702  | 
 1034  | 
 4678  | 
 <null>  | 
 6956  | 
 19352  | 
 96  | 
 23434  | 
 3974  | 
 6608  | 
 1243  | 
 61  | 
 2427  | 
 4329  | 
 1318  | 
 331  | 
 <null>  | 
 04:41:09  | 
 04:59:09  | 
|  marks per second  | 
 5  | 
 6816  | 
 9258  | 
 5515  | 
 14591  | 
 4056  | 
 13370  | 
 5054  | 
 5181  | 
 3490  | 
 17050  | 
 5827  | 
 196  | 
 2180  | 
 <null>  | 
 4028  | 
 30250  | 
 6738  | 
 486  | 
 <null>  | 
 04:59:10  | 
 05:17:10  | 
|  marks per second  | 
 6  | 
 2318  | 
 270  | 
 3655  | 
 <null>  | 
 1260  | 
 <null>  | 
 2429  | 
 <null>  | 
 2043  | 
 485  | 
 1785  | 
 202  | 
 1439  | 
 686  | 
 339  | 
 1571  | 
 796  | 
 5290  | 
 <null>  | 
 05:17:11  | 
 05:35:11  | 
|  marks per second  | 
 7  | 
 6037  | 
 2757  | 
 7695  | 
 <null>  | 
 4968  | 
 1090  | 
 4639  | 
 <null>  | 
 7896  | 
 5258  | 
 2457  | 
 2876  | 
 1203  | 
 889  | 
 5646  | 
 <null>  | 
 12512  | 
 15422  | 
 <null>  | 
 05:35:12  | 
 05:53:12  | 
|  marks per second  | 
 8  | 
 3017  | 
 1305  | 
 3598  | 
 <null>  | 
 2289  | 
 <null>  | 
 3053  | 
 7290  | 
 528  | 
 <null>  | 
 2932  | 
 382  | 
 1249  | 
 2060  | 
 3236  | 
 180  | 
 <null>  | 
 351  | 
 <null>  | 
 05:53:13  | 
 06:11:13  | 
|  marks per second  | 
 9  | 
 6995  | 
 11955  | 
 6299  | 
 <null>  | 
 4301  | 
 2041  | 
 5426  | 
 2260  | 
 12750  | 
 923  | 
 4528  | 
 2078  | 
 1723  | 
 9491  | 
 9253  | 
 15833  | 
 <null>  | 
 689  | 
 <null>  | 
 06:11:14  | 
 06:29:14  | 
|  marks per second  | 
 10  | 
 4085  | 
 871  | 
 1319  | 
 <null>  | 
 1747  | 
 5799  | 
 739  | 
 <null>  | 
 2033  | 
 399  | 
 743  | 
 529  | 
 205  | 
 175  | 
 2614  | 
 <null>  | 
 1223  | 
 5631  | 
 <null>  | 
 06:29:15  | 
 06:47:15  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 03:47:06  | 
 04:05:06  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:05:07  | 
 04:23:07  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 04:23:08  | 
 04:41:08  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:41:09  | 
 04:59:09  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:59:10  | 
 05:17:10  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:17:11  | 
 05:35:11  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 05:35:12  | 
 05:53:12  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:53:13  | 
 06:11:13  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:11:14  | 
 06:29:14  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 06:29:15  | 
 06:47:15  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 03:47:06  | 
 04:05:06  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:05:07  | 
 04:23:07  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 <null>  | 
 <null>  | 
 <null>  | 
 04:23:08  | 
 04:41:08  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 2  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 4  | 
 0  | 
 <null>  | 
 04:41:09  | 
 04:59:09  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:59:10  | 
 05:17:10  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 5  | 
 0  | 
 <null>  | 
 05:17:11  | 
 05:35:11  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 <null>  | 
 05:35:12  | 
 05:53:12  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 1  | 
 1  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:53:13  | 
 06:11:13  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:11:14  | 
 06:29:14  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 3  | 
 <null>  | 
 5  | 
 0  | 
 <null>  | 
 06:29:15  | 
 06:47:15  | 
 
Done for 9160 ms, from  7:02:04.03 to  7:02:13.19.  
 
 
|  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  | 
 1836451  | 
 1715104  | 
 121347  | 
 6.60  | 
 0  | 
 13712  | 
 45  | 
 121347  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  doc_list_biud  | 
 1836880  | 
 1715104  | 
 121776  | 
 6.62  | 
 0  | 
 11419  | 
 15  | 
 121776  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_add_invoice_to_stock  | 
 18783  | 
 10875  | 
 7908  | 
 42.10  | 
 15  | 
 136921  | 
 10422  | 
 7908  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_cancel_adding_invoice  | 
 4081  | 
 3261  | 
 820  | 
 20.09  | 
 0  | 
 70138  | 
 2556  | 
 820  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_cancel_client_order  | 
 6517  | 
 6372  | 
 145  | 
 2.22  | 
 0  | 
 2917  | 
 222  | 
 145  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_cancel_customer_reserve  | 
 315603  | 
 204104  | 
 111499  | 
 35.32  | 
 0  | 
 6599  | 
 55  | 
 111499  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_cancel_pay_from_customer  | 
 2431  | 
 2415  | 
 16  | 
 0.65  | 
 0  | 
 3510  | 
 132  | 
 16  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_cancel_pay_to_supplier  | 
 1466  | 
 1465  | 
 1  | 
 0.06  | 
 0  | 
 2043  | 
 128  | 
 1  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_cancel_supplier_invoice  | 
 9778  | 
 7662  | 
 2116  | 
 21.64  | 
 0  | 
 12277  | 
 393  | 
 2116  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_cancel_supplier_order  | 
 1443  | 
 532  | 
 911  | 
 63.13  | 
 15  | 
 207512  | 
 17187  | 
 911  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_cancel_write_off  | 
 24047  | 
 16012  | 
 8035  | 
 33.41  | 
 0  | 
 4477  | 
 137  | 
 8035  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_client_order  | 
 77177  | 
 77177  | 
 0  | 
 0.00  | 
 0  | 
 5601  | 
 453  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_customer_reserve  | 
 608698  | 
 608698  | 
 0  | 
 0.00  | 
 0  | 
 7176  | 
 151  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_fill_shopping_cart  | 
 116937  | 
 116668  | 
 269  | 
 0.23  | 
 0  | 
 6833  | 
 89  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_fill_shopping_cart_clo_res  | 
 608698  | 
 608698  | 
 0  | 
 0.00  | 
 0  | 
 2886  | 
 11  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_get_clo_for_invoice  | 
 10875  | 
 10875  | 
 0  | 
 0.00  | 
 0  | 
 7145  | 
 309  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_kill_cost_storno  | 
 31694  | 
 23153  | 
 8541  | 
 26.94  | 
 0  | 
 3479  | 
 20  | 
 8541  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 664688  | 
 432414  | 
 232274  | 
 34.94  | 
 0  | 
 11201  | 
 21  | 
 232274  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_kill_qty_storno  | 
 406038  | 
 284364  | 
 121674  | 
 29.96  | 
 0  | 
 11388  | 
 65  | 
 121674  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_lock_selected_doc  | 
 76404  | 
 65279  | 
 11125  | 
 14.56  | 
 0  | 
 1887  | 
 7  | 
 11125  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_make_cost_storno  | 
 93577  | 
 93577  | 
 0  | 
 0.00  | 
 0  | 
 13572  | 
 410  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_multiply_rows_for_pdistr  | 
 93577  | 
 93577  | 
 0  | 
 0.00  | 
 0  | 
 3260  | 
 57  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_multiply_rows_for_qdistr  | 
 77177  | 
 77177  | 
 0  | 
 0.00  | 
 0  | 
 4197  | 
 150  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_pay_from_customer  | 
 25868  | 
 25868  | 
 0  | 
 0.00  | 
 0  | 
 13993  | 
 823  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_pay_to_supplier  | 
 21288  | 
 21288  | 
 0  | 
 0.00  | 
 0  | 
 8143  | 
 726  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_payment_common  | 
 47156  | 
 47156  | 
 0  | 
 0.00  | 
 0  | 
 4665  | 
 59  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_qd_handle_on_cancel_clo  | 
 6513  | 
 6372  | 
 141  | 
 2.16  | 
 0  | 
 2793  | 
 97  | 
 141  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 14810  | 
 14136  | 
 674  | 
 4.55  | 
 0  | 
 9251  | 
 336  | 
 674  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 35546  | 
 35546  | 
 0  | 
 0.00  | 
 0  | 
 7707  | 
 49  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_reserve_write_off  | 
 36720  | 
 35546  | 
 1174  | 
 3.19  | 
 0  | 
 9719  | 
 506  | 
 1174  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_supplier_invoice  | 
 19917  | 
 19824  | 
 93  | 
 0.46  | 
 0  | 
 29452  | 
 2953  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  sp_supplier_order  | 
 19843  | 
 19667  | 
 176  | 
 0.88  | 
 0  | 
 14602  | 
 1947  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  srv_find_qd_qs_mism  | 
 1095585  | 
 974216  | 
 121369  | 
 11.07  | 
 0  | 
 5569  | 
 23  | 
 121369  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  srv_make_invnt_saldo  | 
 1654  | 
 1654  | 
 0  | 
 0.00  | 
 31  | 
 23900  | 
 2555  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  srv_make_money_saldo  | 
 2803  | 
 2803  | 
 0  | 
 0.00  | 
 0  | 
 2542  | 
 66  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 2652  | 
 37721  | 
 15415  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 7908  | 
 7908  | 
 0  | 
 0.00  | 
 0  | 
 2075  | 
 98  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 741  | 
 741  | 
 0  | 
 0.00  | 
 0  | 
 2590  | 
 184  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_cancel_client_order  | 
 145  | 
 145  | 
 0  | 
 0.00  | 
 0  | 
 1170  | 
 101  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 74  | 
 74  | 
 0  | 
 0.00  | 
 0  | 
 436  | 
 29  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 16  | 
 16  | 
 0  | 
 0.00  | 
 0  | 
 390  | 
 55  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 1  | 
 1  | 
 0  | 
 0.00  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 668  | 
 668  | 
 0  | 
 0.00  | 
 0  | 
 1607  | 
 94  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 13795  | 
 13795  | 
 0  | 
 0.00  | 
 0  | 
 4259  | 
 84  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_cancel_write_off  | 
 20  | 
 20  | 
 0  | 
 0.00  | 
 0  | 
 484  | 
 79  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1174  | 
 1174  | 
 0  | 
 0.00  | 
 0  | 
 1606  | 
 62  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_supplier_invoice  | 
 93  | 
 93  | 
 0  | 
 0.00  | 
 0  | 
 1544  | 
 122  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-abend:sp_supplier_order  | 
 176  | 
 176  | 
 0  | 
 0.00  | 
 0  | 
 1669  | 
 96  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 10875  | 
 10875  | 
 0  | 
 0.00  | 
 0  | 
 19734  | 
 556  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1210  | 
 1210  | 
 0  | 
 0.00  | 
 0  | 
 13354  | 
 780  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6372  | 
 6372  | 
 0  | 
 0.00  | 
 0  | 
 2277  | 
 61  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2406  | 
 2406  | 
 0  | 
 0.00  | 
 0  | 
 2044  | 
 66  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2415  | 
 2415  | 
 0  | 
 0.00  | 
 0  | 
 1607  | 
 52  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1465  | 
 1465  | 
 0  | 
 0.00  | 
 0  | 
 2668  | 
 53  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 874  | 
 874  | 
 0  | 
 0.00  | 
 0  | 
 2356  | 
 77  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 532  | 
 532  | 
 0  | 
 0.00  | 
 0  | 
 45957  | 
 1678  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3584  | 
 3584  | 
 0  | 
 0.00  | 
 0  | 
 2028  | 
 69  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_client_order  | 
 77177  | 
 77177  | 
 0  | 
 0.00  | 
 0  | 
 3510  | 
 74  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_customer_reserve  | 
 3587  | 
 3587  | 
 0  | 
 0.00  | 
 0  | 
 2855  | 
 54  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_pay_from_customer  | 
 25868  | 
 25868  | 
 0  | 
 0.00  | 
 0  | 
 2855  | 
 68  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 21288  | 
 21288  | 
 0  | 
 0.00  | 
 0  | 
 2902  | 
 62  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_reserve_write_off  | 
 35546  | 
 35546  | 
 0  | 
 0.00  | 
 0  | 
 3510  | 
 71  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_supplier_invoice  | 
 19824  | 
 19824  | 
 0  | 
 0.00  | 
 0  | 
 2496  | 
 65  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:sp_supplier_order  | 
 19667  | 
 19667  | 
 0  | 
 0.00  | 
 0  | 
 3712  | 
 68  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1654  | 
 1654  | 
 0  | 
 0.00  | 
 0  | 
 811  | 
 28  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:srv_make_money_saldo  | 
 2803  | 
 2803  | 
 0  | 
 0.00  | 
 0  | 
 1170  | 
 29  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 265  | 
 83  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_add_invoice_to_stock  | 
 37566  | 
 21750  | 
 15816  | 
 42.10  | 
 0  | 
 1263  | 
 16  | 
 15816  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_all_customers  | 
 115664  | 
 115664  | 
 0  | 
 0.00  | 
 0  | 
 1950  | 
 5  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_all_suppliers  | 
 79808  | 
 79270  | 
 538  | 
 0.67  | 
 0  | 
 1467  | 
 5  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_all_wares  | 
 154354  | 
 154354  | 
 0  | 
 0.00  | 
 0  | 
 1029  | 
 4  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_cancel_adding_invoice  | 
 2836  | 
 2420  | 
 416  | 
 14.66  | 
 0  | 
 3307  | 
 133  | 
 416  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_cancel_client_order  | 
 13034  | 
 12744  | 
 290  | 
 2.22  | 
 0  | 
 1732  | 
 6  | 
 290  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_cancel_customer_prepayment  | 
 4862  | 
 4830  | 
 32  | 
 0.65  | 
 0  | 
 1061  | 
 7  | 
 32  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_cancel_customer_reserve  | 
 4960  | 
 4812  | 
 148  | 
 2.98  | 
 0  | 
 1045  | 
 9  | 
 148  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_cancel_payment_to_supplier  | 
 2932  | 
 2930  | 
 2  | 
 0.06  | 
 0  | 
 842  | 
 8  | 
 2  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_cancel_supplier_invoice  | 
 3084  | 
 1748  | 
 1336  | 
 43.32  | 
 0  | 
 890  | 
 16  | 
 1336  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_cancel_supplier_order  | 
 2886  | 
 1064  | 
 1822  | 
 63.13  | 
 0  | 
 843  | 
 9  | 
 1822  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_cancel_write_off  | 
 7208  | 
 7168  | 
 40  | 
 0.55  | 
 0  | 
 3666  | 
 98  | 
 40  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_max_id_clo_ord  | 
 19843  | 
 19667  | 
 176  | 
 0.88  | 
 0  | 
 780  | 
 5  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_max_id_clo_res  | 
 3587  | 
 3587  | 
 0  | 
 0.00  | 
 0  | 
 2106  | 
 19  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_max_id_ord_sup  | 
 19917  | 
 19824  | 
 93  | 
 0.46  | 
 0  | 
 1139  | 
 5  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_max_non_paid_invoice  | 
 21144  | 
 21144  | 
 0  | 
 0.00  | 
 0  | 
 1030  | 
 5  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_max_non_paid_realizn  | 
 25868  | 
 25868  | 
 0  | 
 0.00  | 
 0  | 
 1264  | 
 5  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_min_id_clo_ord  | 
 19843  | 
 19667  | 
 176  | 
 0.88  | 
 0  | 
 1591  | 
 7  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_min_id_clo_res  | 
 3587  | 
 3587  | 
 0  | 
 0.00  | 
 0  | 
 873  | 
 9  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_min_id_ord_sup  | 
 19917  | 
 19824  | 
 93  | 
 0.46  | 
 0  | 
 2449  | 
 9  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_min_non_paid_invoice  | 
 21288  | 
 21288  | 
 0  | 
 0.00  | 
 0  | 
 3214  | 
 11  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_min_non_paid_realizn  | 
 25868  | 
 25868  | 
 0  | 
 0.00  | 
 0  | 
 1840  | 
 9  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_our_firm  | 
 38690  | 
 38690  | 
 0  | 
 0.00  | 
 0  | 
 733  | 
 5  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  v_reserve_write_off  | 
 73440  | 
 71092  | 
 2348  | 
 3.19  | 
 0  | 
 2262  | 
 8  | 
 2348  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  x_lock_depdocs_on_canc_invoice  | 
 17594  | 
 10049  | 
 7545  | 
 42.88  | 
 0  | 
 1388  | 
 26  | 
 7545  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1442  | 
 532  | 
 910  | 
 63.10  | 
 0  | 
 795  | 
 47  | 
 910  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  x_make_qstorno_1000_1200  | 
 19843  | 
 19667  | 
 176  | 
 0.88  | 
 0  | 
 14024  | 
 1754  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  x_make_qstorno_1200_2000  | 
 19917  | 
 19824  | 
 93  | 
 0.46  | 
 0  | 
 29406  | 
 2747  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  x_make_qstorno_2100_3300  | 
 608698  | 
 608698  | 
 0  | 
 0.00  | 
 0  | 
 6614  | 
 125  | 
 0  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
 
Done for 304690 ms, from  7:07:17.88 to  7:12:22.57.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 104  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  deadlock  | 
 60  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2017-08-22 03:47  | 
 2017-08-22 06:42  | 
|  deadlock  | 
 9848  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  deadlock  | 
 141  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2017-08-22 03:48  | 
 2017-08-22 06:47  | 
|  deadlock  | 
 161  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2017-08-22 03:47  | 
 2017-08-22 06:44  | 
|  deadlock  | 
 557  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2017-08-22 03:47  | 
 2017-08-22 06:47  | 
|  deadlock  | 
 250  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2017-08-22 03:48  | 
 2017-08-22 06:46  | 
|  user_exc  | 
 176  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2017-08-22 03:47  | 
 2017-08-22 06:46  | 
|  user_exc  | 
 93  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2017-08-22 03:47  | 
 2017-08-22 06:45  | 
 
Done for 8700 ms, from  7:12:29.83 to  7:12:38.53.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          419483
 
MON$OLDEST_ACTIVE               419484
 
MON$OLDEST_SNAPSHOT             419484
 
MON$NEXT_TRANSACTION            419484
 
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                       787104
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.3.32798 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32798 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32798 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		419631 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	419485 
 
Oldest active		419486 
 
Oldest snapshot		419486 
 
Next transaction	419487 
 
Sequence number		0 
 
Next attachment ID	9464 
 
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.06, total records: 2061369 
 
Average version length: 47.73, total versions: 1990, 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: 14, data page slots: 22328 
 
Data pages: 22328, average fill: 73% 
 
Primary pages: 22328, secondary pages: 0, swept pages: 13706 
 
Empty pages: 5, full pages: 18900 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 3 
 
40 - 59% = 97 
 
60 - 79% = 22221 
 
80 - 99% = 2 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 9975, nodes: 2061369 
 
Average node length: 19.30, total dup: 0, max dup: 0 
 
Average key length: 16.35, compression ratio: 1.65 
 
Average prefix length: 13.65, average data length: 13.35 
 
Clustering factor: 401184, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 696 
 
20 - 39% = 2318 
 
40 - 59% = 4428 
 
60 - 79% = 1029 
 
80 - 99% = 1504 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7412, nodes: 2061369 
 
Average node length: 11.65, total dup: 0, max dup: 0 
 
Average key length: 8.70, compression ratio: 1.03 
 
Average prefix length: 3.30, average data length: 5.70 
 
Clustering factor: 383413, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 3511 
 
40 - 59% = 3804 
 
60 - 79% = 85 
 
80 - 99% = 11 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 174473, depth: 3, leaf buckets: 3599, nodes: 2061369 
 
Average node length: 6.81, total dup: 1503642, max dup: 49 
 
Average key length: 3.86, compression ratio: 2.33 
 
Average prefix length: 7.41, average data length: 1.59 
 
Clustering factor: 365045, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 162 
 
20 - 39% = 1201 
 
40 - 59% = 1406 
 
60 - 79% = 286 
 
80 - 99% = 544 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.42, total records: 621057 
 
Average version length: 35.95, total versions: 442, max versions: 2 
 
Average fragment length: 20.44, total fragments: 9, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 5, data page slots: 7872 
 
Data pages: 7872, average fill: 75% 
 
Primary pages: 7867, secondary pages: 5, swept pages: 7222 
 
Empty pages: 4, full pages: 7261 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 10 
 
40 - 59% = 35 
 
60 - 79% = 7803 
 
80 - 99% = 11 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 250231, depth: 3, leaf buckets: 2290, nodes: 621057 
 
Average node length: 11.70, total dup: 0, max dup: 0 
 
Average key length: 8.83, compression ratio: 1.02 
 
Average prefix length: 3.16, average data length: 5.84 
 
Clustering factor: 144343, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1284 
 
40 - 59% = 956 
 
60 - 79% = 44 
 
80 - 99% = 5 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 654, nodes: 621057 
 
Average node length: 4.87, total dup: 621007, max dup: 41806 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 283509, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 564 
 
60 - 79% = 70 
 
80 - 99% = 20 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 325990, depth: 3, leaf buckets: 1794, nodes: 621057 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.83, compression ratio: 1.02 
 
Average prefix length: 3.16, average data length: 5.84 
 
Clustering factor: 144343, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 123 
 
20 - 39% = 571 
 
40 - 59% = 529 
 
60 - 79% = 272 
 
80 - 99% = 299 
 
 
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: 62.26, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 15.64, total fragments: 357, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.67 
 
Pointer pages: 1, data page slots: 584 
 
Data pages: 28, average fill: 22% 
 
Primary pages: 4, secondary pages: 24, swept pages: 4 
 
Empty pages: 12, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 6 
 
40 - 59% = 1 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 292, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 61.88, total records: 9738 
 
Average version length: 70.82, total versions: 1270, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 1.55 
 
Pointer pages: 2, data page slots: 1096 
 
Data pages: 432, average fill: 27% 
 
Primary pages: 431, secondary pages: 1, swept pages: 373 
 
Empty pages: 46, full pages: 12 
 
Fill distribution: 
 
0 - 19% = 216 
 
20 - 39% = 79 
 
40 - 59% = 94 
 
60 - 79% = 37 
 
80 - 99% = 6 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 44, nodes: 9738 
 
Average node length: 13.41, total dup: 1229, max dup: 1 
 
Average key length: 11.43, compression ratio: 2.36 
 
Average prefix length: 18.43, average data length: 8.57 
 
Clustering factor: 6715, ratio: 0.69 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 31 
 
40 - 59% = 8 
 
60 - 79% = 5 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.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: 46.00, total records: 60 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.39 
 
Pointer pages: 1, data page slots: 24 
 
Data pages: 24, average fill: 3% 
 
Primary pages: 22, secondary pages: 2, swept pages: 15 
 
Empty pages: 16, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 234082, depth: 2, leaf buckets: 1, nodes: 60 
 
Average node length: 13.00, total dup: 26, max dup: 8 
 
Average key length: 11.37, compression ratio: 1.67 
 
Average prefix length: 10.18, average data length: 8.82 
 
Clustering factor: 37, ratio: 0.62 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (165) 
 
Primary pointer page: 354, Index root page: 355 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_DTS (4) 
 
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG (0) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (166) 
 
Primary pointer page: 366, Index root page: 367 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_DTS (4) 
 
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_GDSCODE (2) 
 
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_ROWSET (1) 
 
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.36, total records: 189877 
 
Average version length: 32.01, total versions: 1558, max versions: 10 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.51 
 
Pointer pages: 2, data page slots: 2208 
 
Data pages: 2208, average fill: 64% 
 
Primary pages: 2199, secondary pages: 9, swept pages: 1761 
 
Empty pages: 23, full pages: 512 
 
Fill distribution: 
 
0 - 19% = 57 
 
20 - 39% = 110 
 
40 - 59% = 234 
 
60 - 79% = 1806 
 
80 - 99% = 1 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 176, nodes: 189877 
 
Average node length: 4.46, total dup: 189828, max dup: 10211 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 32397, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 16 
 
40 - 59% = 78 
 
60 - 79% = 66 
 
80 - 99% = 16 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 199, nodes: 189877 
 
Average node length: 5.41, total dup: 171093, max dup: 51 
 
Average key length: 2.96, compression ratio: 7.44 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 42655, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 12 
 
40 - 59% = 79 
 
60 - 79% = 64 
 
80 - 99% = 43 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 210, nodes: 189877 
 
Average node length: 5.41, total dup: 171093, max dup: 51 
 
Average key length: 2.96, compression ratio: 7.43 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 42703, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 11 
 
40 - 59% = 88 
 
60 - 79% = 82 
 
80 - 99% = 26 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 204, nodes: 189877 
 
Average node length: 5.20, total dup: 171093, max dup: 51 
 
Average key length: 2.74, compression ratio: 3.28 
 
Average prefix length: 8.35, average data length: 0.65 
 
Clustering factor: 42740, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 17 
 
40 - 59% = 90 
 
60 - 79% = 65 
 
80 - 99% = 29 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.94, total records: 257311 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 1.15 
 
Pointer pages: 2, data page slots: 2200 
 
Data pages: 2200, average fill: 64% 
 
Primary pages: 2200, secondary pages: 0, swept pages: 0 
 
Empty pages: 2, full pages: 2197 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 2197 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 167028, depth: 2, leaf buckets: 199, nodes: 257311 
 
Average node length: 4.50, total dup: 257130, max dup: 2202 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.58, average data length: 0.00 
 
Clustering factor: 44091, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 63 
 
60 - 79% = 64 
 
80 - 99% = 72 
 
 
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.48, total records: 11302519 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1696.00, compression ratio: 11.20 
 
Pointer pages: 165, data page slots: 267912 
 
Data pages: 267912, average fill: 87% 
 
Primary pages: 267912, secondary pages: 0, swept pages: 3 
 
Empty pages: 3, full pages: 267908 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 267908 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 12763, nodes: 11302519 
 
Average node length: 5.65, total dup: 10455686, max dup: 140 
 
Average key length: 2.18, compression ratio: 3.67 
 
Average prefix length: 7.86, average data length: 0.13 
 
Clustering factor: 3703979, ratio: 0.33 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 7173 
 
60 - 79% = 3737 
 
80 - 99% = 1847 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 11145, nodes: 11302519 
 
Average node length: 4.55, total dup: 11302515, max dup: 10398347 
 
Average key length: 1.08, compression ratio: 0.37 
 
Average prefix length: 0.40, average data length: 0.00 
 
Clustering factor: 323925, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 11141 
 
60 - 79% = 2 
 
80 - 99% = 2 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 13739, nodes: 11302519 
 
Average node length: 5.70, total dup: 10948985, max dup: 21344 
 
Average key length: 2.23, compression ratio: 4.03 
 
Average prefix length: 8.80, average data length: 0.20 
 
Clustering factor: 863394, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 10238 
 
60 - 79% = 1938 
 
80 - 99% = 1560 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 12997, nodes: 11302519 
 
Average node length: 5.54, total dup: 11274312, max dup: 1552663 
 
Average key length: 2.07, compression ratio: 18.27 
 
Average prefix length: 37.74, average data length: 0.07 
 
Clustering factor: 6096767, ratio: 0.54 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 3 
 
40 - 59% = 10361 
 
60 - 79% = 536 
 
80 - 99% = 2084 
 
 
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.05, total records: 434630 
 
Average version length: 55.67, total versions: 563, 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: 5184 
 
Data pages: 5184, average fill: 74% 
 
Primary pages: 5184, secondary pages: 0, swept pages: 3772 
 
Empty pages: 5, full pages: 4588 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 4 
 
40 - 59% = 37 
 
60 - 79% = 5137 
 
80 - 99% = 0 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 631482, depth: 3, leaf buckets: 584, nodes: 434630 
 
Average node length: 5.95, total dup: 365057, max dup: 580 
 
Average key length: 3.16, compression ratio: 2.85 
 
Average prefix length: 8.00, average data length: 1.00 
 
Clustering factor: 57059, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 35 
 
40 - 59% = 374 
 
60 - 79% = 129 
 
80 - 99% = 37 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 478, nodes: 434630 
 
Average node length: 5.59, total dup: 387608, max dup: 114 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 107999, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 11 
 
40 - 59% = 225 
 
60 - 79% = 163 
 
80 - 99% = 77 
 
 
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.53, total records: 2317 
 
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: 32 
 
Data pages: 32, average fill: 66% 
 
Primary pages: 32, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 27 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 28 
 
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.52, total records: 6335 
 
Average version length: 72.22, total versions: 1634, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.54 
 
Pointer pages: 2, data page slots: 1432 
 
Data pages: 416, average fill: 19% 
 
Primary pages: 415, secondary pages: 1, swept pages: 310 
 
Empty pages: 213, full pages: 57 
 
Fill distribution: 
 
0 - 19% = 295 
 
20 - 39% = 38 
 
40 - 59% = 19 
 
60 - 79% = 25 
 
80 - 99% = 39 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 15, nodes: 6335 
 
Average node length: 6.74, total dup: 5445, max dup: 14 
 
Average key length: 4.76, compression ratio: 7.77 
 
Average prefix length: 34.38, average data length: 2.62 
 
Clustering factor: 1066, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 10 
 
40 - 59% = 3 
 
60 - 79% = 0 
 
80 - 99% = 1 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.88, total records: 974281 
 
Average version length: 71.82, total versions: 3764, 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: 9, data page slots: 14616 
 
Data pages: 14584, average fill: 73% 
 
Primary pages: 14584, secondary pages: 0, swept pages: 9060 
 
Empty pages: 62, full pages: 11398 
 
Fill distribution: 
 
0 - 19% = 100 
 
20 - 39% = 185 
 
40 - 59% = 737 
 
60 - 79% = 13503 
 
80 - 99% = 59 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 458711, depth: 3, leaf buckets: 1104, nodes: 974281 
 
Average node length: 5.13, total dup: 947636, max dup: 125 
 
Average key length: 2.20, compression ratio: 4.09 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 108283, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 59 
 
40 - 59% = 804 
 
60 - 79% = 59 
 
80 - 99% = 165 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 246906, depth: 3, leaf buckets: 1375, nodes: 974281 
 
Average node length: 6.25, total dup: 850332, max dup: 19 
 
Average key length: 3.32, compression ratio: 11.14 
 
Average prefix length: 35.80, average data length: 1.20 
 
Clustering factor: 185824, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 31 
 
20 - 39% = 152 
 
40 - 59% = 879 
 
60 - 79% = 172 
 
80 - 99% = 141 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 64.24, total records: 40910 
 
Average version length: 72.12, total versions: 4220, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.12 
 
Pointer pages: 3, data page slots: 1960 
 
Data pages: 1072, average fill: 43% 
 
Primary pages: 1070, secondary pages: 2, swept pages: 742 
 
Empty pages: 250, full pages: 362 
 
Fill distribution: 
 
0 - 19% = 398 
 
20 - 39% = 86 
 
40 - 59% = 103 
 
60 - 79% = 446 
 
80 - 99% = 39 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 85, nodes: 40910 
 
Average node length: 6.14, total dup: 34876, max dup: 47 
 
Average key length: 3.84, compression ratio: 9.63 
 
Average prefix length: 35.30, average data length: 1.70 
 
Clustering factor: 4101, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 50 
 
40 - 59% = 33 
 
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: 70.33, total records: 1525652 
 
Average version length: 71.65, total versions: 39248, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.93 
 
Pointer pages: 15, data page slots: 24152 
 
Data pages: 24136, average fill: 70% 
 
Primary pages: 24135, secondary pages: 1, swept pages: 13896 
 
Empty pages: 294, full pages: 16560 
 
Fill distribution: 
 
0 - 19% = 610 
 
20 - 39% = 962 
 
40 - 59% = 2589 
 
60 - 79% = 19161 
 
80 - 99% = 814 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 138780, depth: 3, leaf buckets: 2416, nodes: 1525652 
 
Average node length: 5.60, total dup: 1436052, max dup: 49 
 
Average key length: 2.64, compression ratio: 14.00 
 
Average prefix length: 36.41, average data length: 0.59 
 
Clustering factor: 201787, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 1167 
 
40 - 59% = 908 
 
60 - 79% = 187 
 
80 - 99% = 140 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.00, total records: 6302 
 
Average version length: 71.18, total versions: 2095, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.89 
 
Pointer pages: 3, data page slots: 1688 
 
Data pages: 688, average fill: 12% 
 
Primary pages: 687, secondary pages: 1, swept pages: 585 
 
Empty pages: 364, full pages: 13 
 
Fill distribution: 
 
0 - 19% = 546 
 
20 - 39% = 77 
 
40 - 59% = 31 
 
60 - 79% = 24 
 
80 - 99% = 10 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 17, nodes: 6302 
 
Average node length: 8.53, total dup: 4615, max dup: 35 
 
Average key length: 6.36, compression ratio: 5.82 
 
Average prefix length: 32.90, average data length: 4.10 
 
Clustering factor: 1287, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 6 
 
40 - 59% = 9 
 
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.14, total records: 2629095 
 
Average version length: 70.95, total versions: 11283, 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: 24, data page slots: 37624 
 
Data pages: 37624, average fill: 76% 
 
Primary pages: 37624, secondary pages: 0, swept pages: 27674 
 
Empty pages: 31, full pages: 33365 
 
Fill distribution: 
 
0 - 19% = 71 
 
20 - 39% = 94 
 
40 - 59% = 605 
 
60 - 79% = 36558 
 
80 - 99% = 296 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5523, nodes: 2629095 
 
Average node length: 6.86, total dup: 2133311, max dup: 14 
 
Average key length: 3.88, compression ratio: 9.53 
 
Average prefix length: 35.30, average data length: 1.70 
 
Clustering factor: 482838, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 3275 
 
40 - 59% = 1831 
 
60 - 79% = 238 
 
80 - 99% = 174 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.61, total records: 4530454 
 
Average version length: 84.30, total versions: 1438, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 43, data page slots: 69568 
 
Data pages: 69568, average fill: 80% 
 
Primary pages: 69568, secondary pages: 0, swept pages: 26097 
 
Empty pages: 0, full pages: 69327 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 2 
 
40 - 59% = 21 
 
60 - 79% = 20585 
 
80 - 99% = 48959 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4636, nodes: 4530454 
 
Average node length: 5.15, total dup: 4427142, max dup: 125 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 718548, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 70 
 
40 - 59% = 2094 
 
60 - 79% = 1905 
 
80 - 99% = 543 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 4823, nodes: 4530454 
 
Average node length: 5.70, total dup: 4054641, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 223764, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 36 
 
20 - 39% = 148 
 
40 - 59% = 2541 
 
60 - 79% = 296 
 
80 - 99% = 1802 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5178, nodes: 4530454 
 
Average node length: 5.81, total dup: 3963225, max dup: 27 
 
Average key length: 2.83, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 772749, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 74 
 
40 - 59% = 2377 
 
60 - 79% = 1948 
 
80 - 99% = 757 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.04, total records: 2444084 
 
Average version length: 84.12, total versions: 6971, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.64 
 
Pointer pages: 24, data page slots: 38368 
 
Data pages: 38368, average fill: 78% 
 
Primary pages: 38368, secondary pages: 0, swept pages: 27816 
 
Empty pages: 43, full pages: 35948 
 
Fill distribution: 
 
0 - 19% = 93 
 
20 - 39% = 128 
 
40 - 59% = 554 
 
60 - 79% = 15897 
 
80 - 99% = 21696 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2632, nodes: 2444084 
 
Average node length: 5.15, total dup: 2386602, max dup: 153 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 374761, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 48 
 
40 - 59% = 1585 
 
60 - 79% = 719 
 
80 - 99% = 275 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4087, nodes: 2444084 
 
Average node length: 6.22, total dup: 2008011, max dup: 14 
 
Average key length: 3.24, compression ratio: 2.77 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 228224, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 102 
 
20 - 39% = 1679 
 
40 - 59% = 1474 
 
60 - 79% = 540 
 
80 - 99% = 292 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 2983, nodes: 2444084 
 
Average node length: 5.82, total dup: 2136841, max dup: 29 
 
Average key length: 2.85, compression ratio: 3.16 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 451789, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 48 
 
40 - 59% = 1818 
 
60 - 79% = 812 
 
80 - 99% = 292 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.47, total records: 4779375 
 
Average version length: 85.15, total versions: 16446, 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: 46, data page slots: 74832 
 
Data pages: 74608, average fill: 79% 
 
Primary pages: 74608, secondary pages: 0, swept pages: 21858 
 
Empty pages: 456, full pages: 71151 
 
Fill distribution: 
 
0 - 19% = 586 
 
20 - 39% = 339 
 
40 - 59% = 932 
 
60 - 79% = 15988 
 
80 - 99% = 56763 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5072, nodes: 4779375 
 
Average node length: 5.04, total dup: 4751279, max dup: 695 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 720216, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 228 
 
40 - 59% = 2911 
 
60 - 79% = 1423 
 
80 - 99% = 506 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 5776, nodes: 4779375 
 
Average node length: 5.53, total dup: 4403711, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.54 
 
Average prefix length: 8.54, average data length: 0.46 
 
Clustering factor: 257513, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 89 
 
20 - 39% = 1506 
 
40 - 59% = 2245 
 
60 - 79% = 651 
 
80 - 99% = 1285 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 5708, nodes: 4779375 
 
Average node length: 5.69, total dup: 4285908, max dup: 74 
 
Average key length: 2.70, compression ratio: 3.33 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 797280, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 188 
 
40 - 59% = 3381 
 
60 - 79% = 1558 
 
80 - 99% = 578 
 
 
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.00, total records: 3291008 
 
Average version length: 85.41, total versions: 18690, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.64 
 
Pointer pages: 32, data page slots: 51312 
 
Data pages: 51312, average fill: 79% 
 
Primary pages: 51312, secondary pages: 0, swept pages: 34466 
 
Empty pages: 37, full pages: 49310 
 
Fill distribution: 
 
0 - 19% = 62 
 
20 - 39% = 112 
 
40 - 59% = 394 
 
60 - 79% = 18817 
 
80 - 99% = 31927 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3539, nodes: 3291008 
 
Average node length: 5.02, total dup: 3274875, max dup: 1300 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 665987, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 333 
 
40 - 59% = 1873 
 
60 - 79% = 877 
 
80 - 99% = 431 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5600, nodes: 3291008 
 
Average node length: 6.23, total dup: 2699944, max dup: 14 
 
Average key length: 3.25, compression ratio: 2.77 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 343161, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 190 
 
20 - 39% = 2393 
 
40 - 59% = 1914 
 
60 - 79% = 673 
 
80 - 99% = 430 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 3889, nodes: 3291008 
 
Average node length: 5.59, total dup: 3002023, max dup: 69 
 
Average key length: 2.61, compression ratio: 3.45 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 708421, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 374 
 
40 - 59% = 1935 
 
60 - 79% = 1066 
 
80 - 99% = 493 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.10, total records: 657697 
 
Average version length: 70.33, total versions: 3191, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.97 
 
Pointer pages: 6, data page slots: 9064 
 
Data pages: 9064, average fill: 77% 
 
Primary pages: 9064, secondary pages: 0, swept pages: 6495 
 
Empty pages: 6, full pages: 8762 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 26 
 
40 - 59% = 73 
 
60 - 79% = 8857 
 
80 - 99% = 94 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 173718, depth: 3, leaf buckets: 780, nodes: 657697 
 
Average node length: 5.29, total dup: 622171, max dup: 115 
 
Average key length: 2.41, compression ratio: 3.73 
 
Average prefix length: 8.64, average data length: 0.36 
 
Clustering factor: 53299, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 167 
 
40 - 59% = 322 
 
60 - 79% = 205 
 
80 - 99% = 84 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 890, nodes: 657697 
 
Average node length: 5.91, total dup: 563451, max dup: 29 
 
Average key length: 3.03, compression ratio: 2.97 
 
Average prefix length: 8.11, average data length: 0.89 
 
Clustering factor: 56163, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 219 
 
40 - 59% = 362 
 
60 - 79% = 202 
 
80 - 99% = 104 
 
 
ZDOC_DATA (230) 
 
Primary pointer page: 644, Index root page: 645 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZDOC_LIST (229) 
 
Primary pointer page: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (231) 
 
Primary pointer page: 646, Index root page: 647 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPDISTR (234) 
 
Primary pointer page: 652, Index root page: 653 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPDISTR_ID (0) 
 
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPSTORNED (235) 
 
Primary pointer page: 654, Index root page: 655 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPSTORNED_ID (0) 
 
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQDISTR (232) 
 
Primary pointer page: 648, Index root page: 649 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_ID (0) 
 
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
 
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQSTORNED (233) 
 
Primary pointer page: 650, Index root page: 651 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_DOC_ID (1) 
 
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_ID (0) 
 
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_RCV_ID (3) 
 
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_SND_ID (2) 
 
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_DEP_DOCS (228) 
 
Primary pointer page: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (227) 
 
Primary pointer page: 614, Index root page: 615 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Z_USED_VIEWS (146) 
 
Primary pointer page: 268, Index root page: 269 
 
Total formats: 1, used formats: 1 
 
Average record length: 29.38, total records: 29 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 99.00, compression ratio: 3.37 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 16% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index Z_USED_VIEWS_UNQ (0) 
 
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29 
 
Average node length: 15.17, total dup: 0, max dup: 0 
 
Average key length: 14.14, compression ratio: 1.44 
 
Average prefix length: 9.17, average data length: 11.17 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Done for 68720 ms, from  7:12:38.92 to  7:13:47.64. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2061369  | 
 1990  | 
 0.0965  | 
|  DOC_LIST  | 
 621057  | 
 442  | 
 0.0711  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 9738  | 
 1270  | 
 13.0416  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 60  | 
 0  | 
 0.0000  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 189877  | 
 1558  | 
 0.8205  | 
|  PERF_ESTIMATED  | 
 257311  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 11302519  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 434630  | 
 563  | 
 0.1295  | 
|  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  | 
 2317  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 6335  | 
 1634  | 
 25.7932  | 
|  XQD_1000_3300  | 
 974281  | 
 3764  | 
 0.3863  | 
|  XQD_1200_2000  | 
 40910  | 
 4220  | 
 10.3153  | 
|  XQD_2000_3300  | 
 1525652  | 
 39248  | 
 2.5725  | 
|  XQD_2100_3300  | 
 6302  | 
 2095  | 
 33.2434  | 
|  XQD_3300_3400  | 
 2629095  | 
 11283  | 
 0.4291  | 
|  XQS_1000_1200  | 
 4530454  | 
 1438  | 
 0.0317  | 
|  XQS_1000_3300  | 
 2444084  | 
 6971  | 
 0.2852  | 
|  XQS_1200_2000  | 
 4779375  | 
 16446  | 
 0.3441  | 
|  XQS_2100_3300  | 
 3291008  | 
 18690  | 
 0.5679  | 
|  XQS_3300_3400  | 
 657697  | 
 3191  | 
 0.4851  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2260 ms, from  7:13:58.72 to  7:14:00.98.  
07:14:01.06 Validation started 
 
 
07:14:01.09 Relation 140 (DOC_LIST) 
 
07:14:01.09   process pointer page    0 of    5 
 
07:14:01.20   process pointer page    1 of    5 
 
07:14:01.29   process pointer page    2 of    5 
 
07:14:01.40   process pointer page    3 of    5 
 
07:14:01.46   process pointer page    4 of    5 
 
07:14:01.49 Index 1 (PK_DOC_LIST) 
 
07:14:01.62 Index 2 (DOC_LIST_ID_DESC) 
 
07:14:01.78 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:14:02.02 Relation 140 (DOC_LIST) is ok 
 
 
07:14:02.02 Relation 141 (DOC_DATA) 
 
07:14:02.02   process pointer page    0 of   14 
 
07:14:02.09   process pointer page    1 of   14 
 
07:14:02.13   process pointer page    2 of   14 
 
07:14:02.17   process pointer page    3 of   14 
 
07:14:02.20   process pointer page    4 of   14 
 
07:14:02.23   process pointer page    5 of   14 
 
07:14:02.26   process pointer page    6 of   14 
 
07:14:02.29   process pointer page    7 of   14 
 
07:14:02.32   process pointer page    8 of   14 
 
07:14:02.35   process pointer page    9 of   14 
 
07:14:02.38   process pointer page   10 of   14 
 
07:14:02.41   process pointer page   11 of   14 
 
07:14:02.45   process pointer page   12 of   14 
 
07:14:02.46   process pointer page   13 of   14 
 
07:14:02.49 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:14:03.23 Index 3 (DOC_DATA_ID_DESC) 
 
07:14:03.63 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:14:04.21 Relation 141 (DOC_DATA) is ok 
 
 
07:14:04.21 Relation 147 (INVNT_SALDO) 
 
07:14:04.21   process pointer page    0 of    1 
 
07:14:04.21 Index 1 (PK_INVNT_SALDO) 
 
07:14:04.21 Relation 147 (INVNT_SALDO) is ok 
 
 
07:14:04.21 Relation 150 (PDISTR) 
 
07:14:04.21   process pointer page    0 of    2 
 
07:14:04.26   process pointer page    1 of    2 
 
07:14:04.26 Index 2 (PDISTR_SND_ID) 
 
07:14:04.30 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:14:04.36 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:14:04.43 Index 5 (PDISTR_AGENT_ID) 
 
07:14:04.47 Relation 150 (PDISTR) is ok 
 
 
07:14:04.47 Relation 151 (PSTORNED) 
 
07:14:04.47   process pointer page    0 of    4 
 
07:14:04.57   process pointer page    1 of    4 
 
07:14:04.66   process pointer page    2 of    4 
 
07:14:04.71   process pointer page    3 of    4 
 
07:14:04.71 Index 2 (PSTORNED_SND_ID) 
 
07:14:04.77 Index 3 (PSTORNED_RCV_ID) 
 
07:14:04.90 Relation 151 (PSTORNED) is ok 
 
 
07:14:04.90 Relation 156 (SEMAPHORES) 
 
07:14:04.90   process pointer page    0 of    1 
 
07:14:04.90 Index 1 (PK_SEMAPHORES) 
 
07:14:04.90 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:14:04.90 Relation 156 (SEMAPHORES) is ok 
 
 
07:14:04.90 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:14:04.90   process pointer page    0 of    2 
 
07:14:04.91   process pointer page    1 of    2 
 
07:14:04.91 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:14:04.91 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:14:04.91 Relation 160 (PERF_ESTIMATED) 
 
07:14:04.91   process pointer page    0 of    2 
 
07:14:05.00   process pointer page    1 of    2 
 
07:14:05.04 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:14:05.11 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:14:05.11 Relation 161 (PERF_ISQL_STAT) 
 
07:14:05.11   process pointer page    0 of    1 
 
07:14:05.11 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:14:05.11 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:14:05.11 Relation 162 (TRACE_STAT) 
 
07:14:05.11   process pointer page    0 of    1 
 
07:14:05.11 Relation 162 (TRACE_STAT) is ok 
 
 
07:14:05.11 Relation 163 (PERF_LOG) 
 
07:14:05.11   process pointer page    0 of  165 
 
07:14:05.19   process pointer page    1 of  165 
 
07:14:05.29   process pointer page    2 of  165 
 
07:14:05.32   process pointer page    3 of  165 
 
07:14:05.35   process pointer page    4 of  165 
 
07:14:05.38   process pointer page    5 of  165 
 
07:14:05.41   process pointer page    6 of  165 
 
07:14:05.44   process pointer page    7 of  165 
 
07:14:05.47   process pointer page    8 of  165 
 
07:14:05.49   process pointer page    9 of  165 
 
07:14:05.52   process pointer page   10 of  165 
 
07:14:05.60   process pointer page   11 of  165 
 
07:14:05.64   process pointer page   12 of  165 
 
07:14:05.68   process pointer page   13 of  165 
 
07:14:05.72   process pointer page   14 of  165 
 
07:14:05.75   process pointer page   15 of  165 
 
07:14:05.78   process pointer page   16 of  165 
 
07:14:05.86   process pointer page   17 of  165 
 
07:14:05.94   process pointer page   18 of  165 
 
07:14:06.02   process pointer page   19 of  165 
 
07:14:06.11   process pointer page   20 of  165 
 
07:14:06.19   process pointer page   21 of  165 
 
07:14:06.24   process pointer page   22 of  165 
 
07:14:06.27   process pointer page   23 of  165 
 
07:14:06.35   process pointer page   24 of  165 
 
07:14:06.42   process pointer page   25 of  165 
 
07:14:06.52   process pointer page   26 of  165 
 
07:14:06.60   process pointer page   27 of  165 
 
07:14:06.63   process pointer page   28 of  165 
 
07:14:06.66   process pointer page   29 of  165 
 
07:14:06.69   process pointer page   30 of  165 
 
07:14:06.77   process pointer page   31 of  165 
 
07:14:06.80   process pointer page   32 of  165 
 
07:14:06.83   process pointer page   33 of  165 
 
07:14:06.91   process pointer page   34 of  165 
 
07:14:07.00   process pointer page   35 of  165 
 
07:14:07.08   process pointer page   36 of  165 
 
07:14:07.16   process pointer page   37 of  165 
 
07:14:07.24   process pointer page   38 of  165 
 
07:14:07.31   process pointer page   39 of  165 
 
07:14:07.36   process pointer page   40 of  165 
 
07:14:07.39   process pointer page   41 of  165 
 
07:14:07.42   process pointer page   42 of  165 
 
07:14:07.45   process pointer page   43 of  165 
 
07:14:07.48   process pointer page   44 of  165 
 
07:14:07.50   process pointer page   45 of  165 
 
07:14:07.56   process pointer page   46 of  165 
 
07:14:07.64   process pointer page   47 of  165 
 
07:14:07.69   process pointer page   48 of  165 
 
07:14:07.73   process pointer page   49 of  165 
 
07:14:07.77   process pointer page   50 of  165 
 
07:14:07.80   process pointer page   51 of  165 
 
07:14:07.83   process pointer page   52 of  165 
 
07:14:07.86   process pointer page   53 of  165 
 
07:14:07.87   process pointer page   54 of  165 
 
07:14:07.91   process pointer page   55 of  165 
 
07:14:07.94   process pointer page   56 of  165 
 
07:14:07.95   process pointer page   57 of  165 
 
07:14:07.98   process pointer page   58 of  165 
 
07:14:08.02   process pointer page   59 of  165 
 
07:14:08.05   process pointer page   60 of  165 
 
07:14:08.12   process pointer page   61 of  165 
 
07:14:08.20   process pointer page   62 of  165 
 
07:14:08.25   process pointer page   63 of  165 
 
07:14:08.28   process pointer page   64 of  165 
 
07:14:08.31   process pointer page   65 of  165 
 
07:14:08.34   process pointer page   66 of  165 
 
07:14:08.37   process pointer page   67 of  165 
 
07:14:08.41   process pointer page   68 of  165 
 
07:14:08.44   process pointer page   69 of  165 
 
07:14:08.45   process pointer page   70 of  165 
 
07:14:08.48   process pointer page   71 of  165 
 
07:14:08.51   process pointer page   72 of  165 
 
07:14:08.55   process pointer page   73 of  165 
 
07:14:08.58   process pointer page   74 of  165 
 
07:14:08.61   process pointer page   75 of  165 
 
07:14:08.64   process pointer page   76 of  165 
 
07:14:08.72   process pointer page   77 of  165 
 
07:14:08.80   process pointer page   78 of  165 
 
07:14:08.87   process pointer page   79 of  165 
 
07:14:08.97   process pointer page   80 of  165 
 
07:14:09.04   process pointer page   81 of  165 
 
07:14:09.08   process pointer page   82 of  165 
 
07:14:09.11   process pointer page   83 of  165 
 
07:14:09.14   process pointer page   84 of  165 
 
07:14:09.17   process pointer page   85 of  165 
 
07:14:09.20   process pointer page   86 of  165 
 
07:14:09.23   process pointer page   87 of  165 
 
07:14:09.28   process pointer page   88 of  165 
 
07:14:09.33   process pointer page   89 of  165 
 
07:14:09.36   process pointer page   90 of  165 
 
07:14:09.40   process pointer page   91 of  165 
 
07:14:09.43   process pointer page   92 of  165 
 
07:14:09.47   process pointer page   93 of  165 
 
07:14:09.50   process pointer page   94 of  165 
 
07:14:09.53   process pointer page   95 of  165 
 
07:14:09.56   process pointer page   96 of  165 
 
07:14:09.58   process pointer page   97 of  165 
 
07:14:09.62   process pointer page   98 of  165 
 
07:14:09.65   process pointer page   99 of  165 
 
07:14:09.68   process pointer page  100 of  165 
 
07:14:09.72   process pointer page  101 of  165 
 
07:14:09.75   process pointer page  102 of  165 
 
07:14:09.78   process pointer page  103 of  165 
 
07:14:09.79   process pointer page  104 of  165 
 
07:14:09.82   process pointer page  105 of  165 
 
07:14:09.86   process pointer page  106 of  165 
 
07:14:09.89   process pointer page  107 of  165 
 
07:14:09.92   process pointer page  108 of  165 
 
07:14:09.98   process pointer page  109 of  165 
 
07:14:10.01   process pointer page  110 of  165 
 
07:14:10.07   process pointer page  111 of  165 
 
07:14:10.15   process pointer page  112 of  165 
 
07:14:10.20   process pointer page  113 of  165 
 
07:14:10.23   process pointer page  114 of  165 
 
07:14:10.26   process pointer page  115 of  165 
 
07:14:10.29   process pointer page  116 of  165 
 
07:14:10.32   process pointer page  117 of  165 
 
07:14:10.36   process pointer page  118 of  165 
 
07:14:10.39   process pointer page  119 of  165 
 
07:14:10.40   process pointer page  120 of  165 
 
07:14:10.43   process pointer page  121 of  165 
 
07:14:10.46   process pointer page  122 of  165 
 
07:14:10.50   process pointer page  123 of  165 
 
07:14:10.51   process pointer page  124 of  165 
 
07:14:10.54   process pointer page  125 of  165 
 
07:14:10.57   process pointer page  126 of  165 
 
07:14:10.60   process pointer page  127 of  165 
 
07:14:10.65   process pointer page  128 of  165 
 
07:14:10.70   process pointer page  129 of  165 
 
07:14:10.73   process pointer page  130 of  165 
 
07:14:10.76   process pointer page  131 of  165 
 
07:14:10.79   process pointer page  132 of  165 
 
07:14:10.82   process pointer page  133 of  165 
 
07:14:10.85   process pointer page  134 of  165 
 
07:14:10.89   process pointer page  135 of  165 
 
07:14:10.92   process pointer page  136 of  165 
 
07:14:10.95   process pointer page  137 of  165 
 
07:14:10.98   process pointer page  138 of  165 
 
07:14:11.03   process pointer page  139 of  165 
 
07:14:11.12   process pointer page  140 of  165 
 
07:14:11.20   process pointer page  141 of  165 
 
07:14:11.28   process pointer page  142 of  165 
 
07:14:11.34   process pointer page  143 of  165 
 
07:14:11.37   process pointer page  144 of  165 
 
07:14:11.40   process pointer page  145 of  165 
 
07:14:11.43   process pointer page  146 of  165 
 
07:14:11.46   process pointer page  147 of  165 
 
07:14:11.49   process pointer page  148 of  165 
 
07:14:11.53   process pointer page  149 of  165 
 
07:14:11.54   process pointer page  150 of  165 
 
07:14:11.57   process pointer page  151 of  165 
 
07:14:11.65   process pointer page  152 of  165 
 
07:14:11.73   process pointer page  153 of  165 
 
07:14:11.81   process pointer page  154 of  165 
 
07:14:11.85   process pointer page  155 of  165 
 
07:14:11.88   process pointer page  156 of  165 
 
07:14:11.92   process pointer page  157 of  165 
 
07:14:11.95   process pointer page  158 of  165 
 
07:14:11.98   process pointer page  159 of  165 
 
07:14:12.01   process pointer page  160 of  165 
 
07:14:12.04   process pointer page  161 of  165 
 
07:14:12.07   process pointer page  162 of  165 
 
07:14:12.09   process pointer page  163 of  165 
 
07:14:12.13   process pointer page  164 of  165 
 
07:14:12.13 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:14:14.79 Index 2 (PERF_LOG_UNIT) 
 
07:14:17.67 Index 3 (PERF_LOG_TRN_DESC) 
 
07:14:19.48 Index 4 (PERF_LOG_GDSCODE) 
 
07:14:20.68 Relation 163 (PERF_LOG) is ok 
 
 
07:14:20.68 Relation 167 (V_STOPTEST) 
 
07:14:20.68 Relation 167 (V_STOPTEST) is ok 
 
 
07:14:20.68 Relation 184 (V_QDISTR_SOURCE) 
 
07:14:20.68 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:14:20.68 Relation 185 (V_QSTORNED_SOURCE) 
 
07:14:20.68 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:14:20.68 Relation 260 (XQD_1000_1200) 
 
07:14:20.68   process pointer page    0 of    2 
 
07:14:20.70   process pointer page    1 of    2 
 
07:14:20.70 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:14:20.70 Relation 260 (XQD_1000_1200) is ok 
 
 
07:14:20.70 Relation 261 (XQD_1200_2000) 
 
07:14:20.70   process pointer page    0 of    3 
 
07:14:20.71   process pointer page    1 of    3 
 
07:14:20.71   process pointer page    2 of    3 
 
07:14:20.71 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:14:20.73 Relation 261 (XQD_1200_2000) is ok 
 
 
07:14:20.73 Relation 262 (XQD_1000_3300) 
 
07:14:20.73   process pointer page    0 of    9 
 
07:14:20.79   process pointer page    1 of    9 
 
07:14:20.85   process pointer page    2 of    9 
 
07:14:20.89   process pointer page    3 of    9 
 
07:14:20.93   process pointer page    4 of    9 
 
07:14:20.96   process pointer page    5 of    9 
 
07:14:20.99   process pointer page    6 of    9 
 
07:14:21.09   process pointer page    7 of    9 
 
07:14:21.12   process pointer page    8 of    9 
 
07:14:21.18 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:14:21.48 Index 2 (XQD_1000_3300_DOC) 
 
07:14:21.59 Relation 262 (XQD_1000_3300) is ok 
 
 
07:14:21.59 Relation 263 (XQD_2000_3300) 
 
07:14:21.59   process pointer page    0 of   15 
 
07:14:21.62   process pointer page    1 of   15 
 
07:14:21.65   process pointer page    2 of   15 
 
07:14:21.67   process pointer page    3 of   15 
 
07:14:21.71   process pointer page    4 of   15 
 
07:14:21.76   process pointer page    5 of   15 
 
07:14:21.84   process pointer page    6 of   15 
 
07:14:21.87   process pointer page    7 of   15 
 
07:14:21.95   process pointer page    8 of   15 
 
07:14:21.98   process pointer page    9 of   15 
 
07:14:22.04   process pointer page   10 of   15 
 
07:14:22.07   process pointer page   11 of   15 
 
07:14:22.10   process pointer page   12 of   15 
 
07:14:22.15   process pointer page   13 of   15 
 
07:14:22.24   process pointer page   14 of   15 
 
07:14:22.30 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:14:22.59 Relation 263 (XQD_2000_3300) is ok 
 
 
07:14:22.59 Relation 264 (XQD_2100_3300) 
 
07:14:22.59   process pointer page    0 of    3 
 
07:14:22.60   process pointer page    1 of    3 
 
07:14:22.60   process pointer page    2 of    3 
 
07:14:22.60 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:14:22.60 Relation 264 (XQD_2100_3300) is ok 
 
 
07:14:22.60 Relation 265 (XQD_3300_3400) 
 
07:14:22.60   process pointer page    0 of   24 
 
07:14:22.69   process pointer page    1 of   24 
 
07:14:22.79   process pointer page    2 of   24 
 
07:14:22.87   process pointer page    3 of   24 
 
07:14:22.96   process pointer page    4 of   24 
 
07:14:23.04   process pointer page    5 of   24 
 
07:14:23.07   process pointer page    6 of   24 
 
07:14:23.10   process pointer page    7 of   24 
 
07:14:23.15   process pointer page    8 of   24 
 
07:14:23.18   process pointer page    9 of   24 
 
07:14:23.24   process pointer page   10 of   24 
 
07:14:23.33   process pointer page   11 of   24 
 
07:14:23.41   process pointer page   12 of   24 
 
07:14:23.51   process pointer page   13 of   24 
 
07:14:23.58   process pointer page   14 of   24 
 
07:14:23.65   process pointer page   15 of   24 
 
07:14:23.69   process pointer page   16 of   24 
 
07:14:23.72   process pointer page   17 of   24 
 
07:14:23.79   process pointer page   18 of   24 
 
07:14:23.88   process pointer page   19 of   24 
 
07:14:23.94   process pointer page   20 of   24 
 
07:14:23.97   process pointer page   21 of   24 
 
07:14:24.01   process pointer page   22 of   24 
 
07:14:24.05   process pointer page   23 of   24 
 
07:14:24.05 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:14:24.57 Relation 265 (XQD_3300_3400) is ok 
 
 
07:14:24.57 Relation 266 (XQS_1000_1200) 
 
07:14:24.58   process pointer page    0 of   43 
 
07:14:24.60   process pointer page    1 of   43 
 
07:14:24.63   process pointer page    2 of   43 
 
07:14:24.66   process pointer page    3 of   43 
 
07:14:24.69   process pointer page    4 of   43 
 
07:14:24.72   process pointer page    5 of   43 
 
07:14:24.80   process pointer page    6 of   43 
 
07:14:24.89   process pointer page    7 of   43 
 
07:14:24.99   process pointer page    8 of   43 
 
07:14:25.05   process pointer page    9 of   43 
 
07:14:25.08   process pointer page   10 of   43 
 
07:14:25.11   process pointer page   11 of   43 
 
07:14:25.18   process pointer page   12 of   43 
 
07:14:25.25   process pointer page   13 of   43 
 
07:14:25.35   process pointer page   14 of   43 
 
07:14:25.44   process pointer page   15 of   43 
 
07:14:25.47   process pointer page   16 of   43 
 
07:14:25.50   process pointer page   17 of   43 
 
07:14:25.53   process pointer page   18 of   43 
 
07:14:25.57   process pointer page   19 of   43 
 
07:14:25.61   process pointer page   20 of   43 
 
07:14:25.63   process pointer page   21 of   43 
 
07:14:25.66   process pointer page   22 of   43 
 
07:14:25.69   process pointer page   23 of   43 
 
07:14:25.72   process pointer page   24 of   43 
 
07:14:25.75   process pointer page   25 of   43 
 
07:14:25.78   process pointer page   26 of   43 
 
07:14:25.81   process pointer page   27 of   43 
 
07:14:25.86   process pointer page   28 of   43 
 
07:14:25.94   process pointer page   29 of   43 
 
07:14:26.03   process pointer page   30 of   43 
 
07:14:26.06   process pointer page   31 of   43 
 
07:14:26.10   process pointer page   32 of   43 
 
07:14:26.13   process pointer page   33 of   43 
 
07:14:26.22   process pointer page   34 of   43 
 
07:14:26.28   process pointer page   35 of   43 
 
07:14:26.31   process pointer page   36 of   43 
 
07:14:26.36   process pointer page   37 of   43 
 
07:14:26.39   process pointer page   38 of   43 
 
07:14:26.42   process pointer page   39 of   43 
 
07:14:26.45   process pointer page   40 of   43 
 
07:14:26.49   process pointer page   41 of   43 
 
07:14:26.52   process pointer page   42 of   43 
 
07:14:26.53 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:14:27.42 Index 2 (XQS_1000_1200_SND_ID) 
 
07:14:28.48 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:14:29.28 Relation 266 (XQS_1000_1200) is ok 
 
 
07:14:29.28 Relation 267 (XQS_1200_2000) 
 
07:14:29.28   process pointer page    0 of   46 
 
07:14:29.31   process pointer page    1 of   46 
 
07:14:29.36   process pointer page    2 of   46 
 
07:14:29.45   process pointer page    3 of   46 
 
07:14:29.54   process pointer page    4 of   46 
 
07:14:29.62   process pointer page    5 of   46 
 
07:14:29.71   process pointer page    6 of   46 
 
07:14:29.81   process pointer page    7 of   46 
 
07:14:29.90   process pointer page    8 of   46 
 
07:14:30.00   process pointer page    9 of   46 
 
07:14:30.09   process pointer page   10 of   46 
 
07:14:30.20   process pointer page   11 of   46 
 
07:14:30.31   process pointer page   12 of   46 
 
07:14:30.40   process pointer page   13 of   46 
 
07:14:30.51   process pointer page   14 of   46 
 
07:14:30.60   process pointer page   15 of   46 
 
07:14:30.71   process pointer page   16 of   46 
 
07:14:30.82   process pointer page   17 of   46 
 
07:14:30.93   process pointer page   18 of   46 
 
07:14:31.03   process pointer page   19 of   46 
 
07:14:31.13   process pointer page   20 of   46 
 
07:14:31.21   process pointer page   21 of   46 
 
07:14:31.27   process pointer page   22 of   46 
 
07:14:31.35   process pointer page   23 of   46 
 
07:14:31.38   process pointer page   24 of   46 
 
07:14:31.43   process pointer page   25 of   46 
 
07:14:31.46   process pointer page   26 of   46 
 
07:14:31.51   process pointer page   27 of   46 
 
07:14:31.54   process pointer page   28 of   46 
 
07:14:31.57   process pointer page   29 of   46 
 
07:14:31.62   process pointer page   30 of   46 
 
07:14:31.65   process pointer page   31 of   46 
 
07:14:31.71   process pointer page   32 of   46 
 
07:14:31.74   process pointer page   33 of   46 
 
07:14:31.77   process pointer page   34 of   46 
 
07:14:31.82   process pointer page   35 of   46 
 
07:14:31.85   process pointer page   36 of   46 
 
07:14:31.88   process pointer page   37 of   46 
 
07:14:31.90   process pointer page   38 of   46 
 
07:14:31.95   process pointer page   39 of   46 
 
07:14:31.96   process pointer page   40 of   46 
 
07:14:31.99   process pointer page   41 of   46 
 
07:14:32.02   process pointer page   42 of   46 
 
07:14:32.05   process pointer page   43 of   46 
 
07:14:32.10   process pointer page   44 of   46 
 
07:14:32.16   process pointer page   45 of   46 
 
07:14:32.26 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:14:33.51 Index 2 (XQS_1200_2000_SND_ID) 
 
07:14:34.96 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:14:36.14 Relation 267 (XQS_1200_2000) is ok 
 
 
07:14:36.14 Relation 268 (XQS_1000_3300) 
 
07:14:36.14   process pointer page    0 of   24 
 
07:14:36.64   process pointer page    1 of   24 
 
07:14:37.12   process pointer page    2 of   24 
 
07:14:37.61   process pointer page    3 of   24 
 
07:14:38.09   process pointer page    4 of   24 
 
07:14:38.59   process pointer page    5 of   24 
 
07:14:39.07   process pointer page    6 of   24 
 
07:14:39.56   process pointer page    7 of   24 
 
07:14:39.93   process pointer page    8 of   24 
 
07:14:40.29   process pointer page    9 of   24 
 
07:14:40.65   process pointer page   10 of   24 
 
07:14:41.04   process pointer page   11 of   24 
 
07:14:41.41   process pointer page   12 of   24 
 
07:14:41.76   process pointer page   13 of   24 
 
07:14:42.13   process pointer page   14 of   24 
 
07:14:42.49   process pointer page   15 of   24 
 
07:14:42.87   process pointer page   16 of   24 
 
07:14:43.22   process pointer page   17 of   24 
 
07:14:43.58   process pointer page   18 of   24 
 
07:14:43.99   process pointer page   19 of   24 
 
07:14:44.36   process pointer page   20 of   24 
 
07:14:44.74   process pointer page   21 of   24 
 
07:14:45.13   process pointer page   22 of   24 
 
07:14:45.52   process pointer page   23 of   24 
 
07:14:45.74 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:14:47.09 Index 2 (XQS_1000_3300_SND_ID) 
 
07:14:48.59 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:14:49.98 Relation 268 (XQS_1000_3300) is ok 
 
 
07:14:49.98 Relation 269 (XQS_2000_3300) 
 
07:14:49.98   process pointer page    0 of    1 
 
07:14:49.98 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:14:49.98 Index 2 (XQS_2000_3300_SND_ID) 
 
07:14:49.98 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:14:49.98 Relation 269 (XQS_2000_3300) is ok 
 
 
07:14:49.98 Relation 270 (XQS_2100_3300) 
 
07:14:49.98   process pointer page    0 of   32 
 
07:14:50.45   process pointer page    1 of   32 
 
07:14:50.93   process pointer page    2 of   32 
 
07:14:51.41   process pointer page    3 of   32 
 
07:14:51.90   process pointer page    4 of   32 
 
07:14:52.38   process pointer page    5 of   32 
 
07:14:52.87   process pointer page    6 of   32 
 
07:14:53.36   process pointer page    7 of   32 
 
07:14:53.83   process pointer page    8 of   32 
 
07:14:54.27   process pointer page    9 of   32 
 
07:14:54.68   process pointer page   10 of   32 
 
07:14:54.97   process pointer page   11 of   32 
 
07:14:55.33   process pointer page   12 of   32 
 
07:14:55.67   process pointer page   13 of   32 
 
07:14:56.13   process pointer page   14 of   32 
 
07:14:56.53   process pointer page   15 of   32 
 
07:14:56.95   process pointer page   16 of   32 
 
07:14:57.36   process pointer page   17 of   32 
 
07:14:57.72   process pointer page   18 of   32 
 
07:14:58.11   process pointer page   19 of   32 
 
07:14:58.54   process pointer page   20 of   32 
 
07:14:58.95   process pointer page   21 of   32 
 
07:14:59.34   process pointer page   22 of   32 
 
07:14:59.73   process pointer page   23 of   32 
 
07:15:00.12   process pointer page   24 of   32 
 
07:15:00.53   process pointer page   25 of   32 
 
07:15:00.92   process pointer page   26 of   32 
 
07:15:01.34   process pointer page   27 of   32 
 
07:15:01.77   process pointer page   28 of   32 
 
07:15:02.16   process pointer page   29 of   32 
 
07:15:02.58   process pointer page   30 of   32 
 
07:15:02.96   process pointer page   31 of   32 
 
07:15:03.11 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:15:04.69 Index 2 (XQS_2100_3300_SND_ID) 
 
07:15:06.33 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:15:08.26 Relation 270 (XQS_2100_3300) is ok 
 
 
07:15:08.26 Relation 271 (XQS_3300_3400) 
 
07:15:08.26   process pointer page    0 of    6 
 
07:15:08.75   process pointer page    1 of    6 
 
07:15:09.23   process pointer page    2 of    6 
 
07:15:09.71   process pointer page    3 of    6 
 
07:15:10.18   process pointer page    4 of    6 
 
07:15:10.63   process pointer page    5 of    6 
 
07:15:10.87 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:15:11.24 Index 2 (XQS_3300_3400_SND_ID) 
 
07:15:11.65 Relation 271 (XQS_3300_3400) is ok 
 
 
07:15:11.66 Validation finished 
 
Done for 70820 ms, from  7:14:01.00 to  7:15:11.82. 
 
 Differences between old and current firebird.log 
7:15:13.64. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2017-08-22  07:15               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 Tue Aug 22 07:14:01 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Tue Aug 22 07:15:11 2017 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 397 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*: 
 
 
|  ERRORS_CHECKING_RESULT  | 
|  NO_SEVERE_ERRORS_FOUND  | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2017-08-22  7:15:20.99 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html