Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 4. 2015-12-15  7:56:32.08.
 
Server version: WI-V3.0.0.32219 Firebird 3.0 Release Candidate 2
 
Server implementation: Firebird/Windows/AMD/Intel/x64 
 
|  FB_ARCHITECTURE  | 
 DB_NAME  | 
 FORCED_WRITES  | 
 SWEEP_INT  | 
 PAGE_BUFFERS  | 
 PAGE_SIZE  | 
|  SuperServer 3.0.0  | 
 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  | 
 10  | 
|  test_time  | 
 180  | 
|  idle_time  | 
 0  | 
|  use_mtee  | 
 0  | 
|  is_embed  | 
 0  | 
|  remove_isql_logs  | 
 if_no_severe_errors  | 
|  no_auto_undo  | 
 1  | 
|  detailed_info  | 
 0  | 
|  mon_unit_perf  | 
 0  | 
|  init_buff  | 
 32768  | 
|  create_with_fw  | 
 sync  | 
|  create_with_sweep  | 
 0  | 
|  wait_if_not_exists  | 
 0  | 
|  wait_after_create  | 
 0  | 
|  init_docs  | 
 0  | 
|  wait_for_copy  | 
 0  | 
|  create_with_debug_objects  | 
 1  | 
|  create_with_split_heavy_tabs  | 
 1  | 
|  create_with_separate_qdistr_idx  | 
 0  | 
|  create_with_compound_columns_order  | 
 most_selective_first  | 
|  make_html  | 
 1  | 
|  run_db_statistics  | 
 1  | 
|  run_db_validation  | 
 1  | 
|  file_name_with_test_params  | 
 regular  | 
|  upload_report  | 
 1  | 
 
 
 
|  FINISH_STATE  | 
 DTS_END  | 
 FB_GDSCODE  | 
 FB_MNEMONA  | 
 STACK  | 
 IP  | 
 TRN_ID  | 
 ATT_ID  | 
 EXC_UNIT  | 
|  NORMAL: TEST_TIME EXPIRED.  | 
 2015-12-15 07:55:55.7540  | 
 -1  | 
 <null>  | 
   | 
 ::1  | 
 372609  | 
 4960  | 
 2  | 
 
 
 
|  CATEGORY  | 
 SETTING  | 
 VAL  | 
|  COMMON  | 
 TRACED_UNITS  | 
 ,,  | 
|  COMMON  | 
 ENABLE_MON_QUERY  | 
 0  | 
|  COMMON  | 
 HALT_TEST_ON_ERRORS  | 
 ,CK,  | 
|  COMMON  | 
 LOG_PK_VIOLATION  | 
 0  | 
|  COMMON  | 
 QMISM_VERIFY_BITSET  | 
 1  | 
|  COMMON  | 
 RECALC_IDX_MIN_INTERVAL  | 
 15  | 
|  COMMON  | 
 ENABLE_RESERVES_WHEN_ADD_INVOICE  | 
 1  | 
|  COMMON  | 
 ORDER_FOR_OUR_FIRM_PERCENT  | 
 25  | 
|  COMMON  | 
 ENABLE_FILL_PHRASES  | 
 0  | 
|  COMMON  | 
 RANDOM_SEEK_VIA_ROWS_LIMIT  | 
 0  | 
|  COMMON  | 
 C_INVOICE_MIN_PURCHASE  | 
 1000  | 
|  COMMON  | 
 C_INVOICE_MAX_PURCHASE  | 
 2000  | 
|  COMMON  | 
 C_INVOICE_MIN_PROFIT_PRC  | 
 35  | 
|  COMMON  | 
 C_INVOICE_MAX_PROFIT_PRC  | 
 80  | 
|  COMMON  | 
 C_MIN_COST_TO_BE_SPLITTED  | 
 1000  | 
|  COMMON  | 
 C_ROWS_TO_MULTIPLY  | 
 10  | 
|  COMMON  | 
 C_PAYMENT_FROM_CLIENT_MIN_TOTAL  | 
 1000  | 
|  COMMON  | 
 C_PAYMENT_FROM_CLIENT_MAX_TOTAL  | 
 5000  | 
|  COMMON  | 
 C_PAYMENT_TO_SUPPLIER_MIN_TOTAL  | 
 2000  | 
|  COMMON  | 
 C_PAYMENT_TO_SUPPLIER_MAX_TOTAL  | 
 15000  | 
|  COMMON  | 
 BUILD_WITH_SPLIT_HEAVY_TABS  | 
 1  | 
|  COMMON  | 
 BUILD_WITH_SEPAR_QDISTR_IDX  | 
 0  | 
|  COMMON  | 
 BUILD_WITH_QD_COMPOUND_ORDR  | 
 MOST_SELECTIVE_FIRST  | 
|  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:  | 
 5735.72  | 
 329  | 
 1032429  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  customer order: creation  | 
 408.82  | 
 14  | 
 73587  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  customer order: refuse  | 
 33.76  | 
 7  | 
 6076  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  order to supplier: creation  | 
 105.48  | 
 86  | 
 18986  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  order to supplier: removal  | 
 2.82  | 
 3514  | 
 505  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  invoice (draft): creation  | 
 104.23  | 
 110  | 
 18762  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  invoice (draft): removal  | 
 38.80  | 
 62  | 
 6946  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  invoice accept: apply  | 
 69.98  | 
 674  | 
 12596  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  invoice accept: cancel  | 
 18.21  | 
 179  | 
 3260  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  customer reserve: creation  | 
 3132.57  | 
 10  | 
 563862  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  customer reserve: removal  | 
 1221.08  | 
 7  | 
 218574  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  realization accept: apply  | 
 192.44  | 
 18  | 
 34640  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  realization accept: cancel  | 
 79.46  | 
 10  | 
 14302  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  payment from customer: creation  | 
 136.24  | 
 33  | 
 24523  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  payment from customer: removal  | 
 12.53  | 
 5  | 
 2255  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  payment to supplier: creation  | 
 112.51  | 
 19  | 
 20251  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  payment to supplier: removal  | 
 8.09  | 
 4  | 
 1449  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  service: total inventory turnovers  | 
 40.69  | 
 62  | 
 7325  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  service: total monetary turnovers  | 
 25.10  | 
 1  | 
 4518  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  service: refresh index statistics  | 
 0.07  | 
 1440  | 
 12  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
 
Done for 33630 ms, from  7:57:09.69 to  7:57:43.32.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4045  | 
 94483  | 
 72809  | 
 21674  | 
 22.94  | 
 04:55:56  | 
 05:13:56  | 
|  interval #   2, overall  | 
 2  | 
 5428  | 
 129584  | 
 97702  | 
 31882  | 
 24.60  | 
 05:13:57  | 
 05:31:57  | 
|  interval #   3, overall  | 
 3  | 
 5594  | 
 134269  | 
 100692  | 
 33577  | 
 25.01  | 
 05:31:58  | 
 05:49:58  | 
|  interval #   4, overall  | 
 4  | 
 5000  | 
 112530  | 
 89994  | 
 22536  | 
 20.03  | 
 05:49:59  | 
 06:07:59  | 
|  interval #   5, overall  | 
 5  | 
 5492  | 
 127307  | 
 98855  | 
 28452  | 
 22.35  | 
 06:08:00  | 
 06:26:00  | 
|  interval #   6, overall  | 
 6  | 
 6342  | 
 145677  | 
 114152  | 
 31525  | 
 21.64  | 
 06:26:01  | 
 06:44:01  | 
|  interval #   7, overall  | 
 7  | 
 6381  | 
 144596  | 
 114866  | 
 29730  | 
 20.56  | 
 06:44:02  | 
 07:02:02  | 
|  interval #   8, overall  | 
 8  | 
 6381  | 
 148374  | 
 114853  | 
 33521  | 
 22.59  | 
 07:02:03  | 
 07:20:03  | 
|  interval #   9, overall  | 
 9  | 
 6207  | 
 150797  | 
 111732  | 
 39065  | 
 25.91  | 
 07:20:04  | 
 07:38:04  | 
|  interval #  10, overall  | 
 10  | 
 6487  | 
 145455  | 
 116774  | 
 28681  | 
 19.72  | 
 07:38:05  | 
 07:56:05  | 
 
Done for 83330 ms, from  7:59:04.09 to  8:00:27.42.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
|  WARM_TIME  | 
 1  | 
 3476.92  | 
 0.0966  | 
 1.7489  | 
 2371  | 
|  WARM_TIME  | 
 2  | 
 4373.83  | 
 0.6952  | 
 1.3405  | 
 1992  | 
|  WARM_TIME  | 
 3  | 
 4789.82  | 
 0.8161  | 
 1.2102  | 
 1969  | 
|  WARM_TIME  | 
 4  | 
 4952.97  | 
 0.8817  | 
 1.1291  | 
 2325  | 
|  WARM_TIME  | 
 5  | 
 4909.25  | 
 0.9114  | 
 1.1059  | 
 2099  | 
|  WARM_TIME  | 
 6  | 
 4918.80  | 
 0.9199  | 
 1.0845  | 
 1744  | 
|  WARM_TIME  | 
 7  | 
 4912.51  | 
 0.9318  | 
 1.0784  | 
 1840  | 
|  WARM_TIME  | 
 8  | 
 4987.01  | 
 0.9295  | 
 1.0569  | 
 1561  | 
|  WARM_TIME  | 
 9  | 
 4942.58  | 
 0.9479  | 
 1.0491  | 
 1743  | 
|  WARM_TIME  | 
 10  | 
 4881.38  | 
 0.9561  | 
 1.0437  | 
 1721  | 
|  TEST_TIME  | 
 11  | 
 4847.92  | 
 0.9554  | 
 1.0378  | 
 1748  | 
|  TEST_TIME  | 
 12  | 
 4788.78  | 
 0.9631  | 
 1.0324  | 
 1882  | 
|  TEST_TIME  | 
 13  | 
 4740.73  | 
 0.9627  | 
 1.0333  | 
 1445  | 
|  TEST_TIME  | 
 14  | 
 4684.68  | 
 0.9711  | 
 1.0299  | 
 1678  | 
|  TEST_TIME  | 
 15  | 
 4593.05  | 
 0.9804  | 
 1.0196  | 
 1568  | 
|  TEST_TIME  | 
 16  | 
 4490.52  | 
 0.9777  | 
 1.0304  | 
 1407  | 
|  TEST_TIME  | 
 17  | 
 4476.42  | 
 0.9729  | 
 1.0208  | 
 1482  | 
|  TEST_TIME  | 
 18  | 
 4410.46  | 
 0.9786  | 
 1.0166  | 
 1467  | 
|  TEST_TIME  | 
 19  | 
 4350.88  | 
 0.9763  | 
 1.0274  | 
 1249  | 
|  TEST_TIME  | 
 20  | 
 4322.80  | 
 0.9824  | 
 1.0149  | 
 1303  | 
|  TEST_TIME  | 
 21  | 
 4291.80  | 
 0.9735  | 
 1.0211  | 
 1280  | 
|  TEST_TIME  | 
 22  | 
 4252.69  | 
 0.9836  | 
 1.0161  | 
 1327  | 
|  TEST_TIME  | 
 23  | 
 4210.81  | 
 0.9816  | 
 1.0133  | 
 966  | 
|  TEST_TIME  | 
 24  | 
 4185.88  | 
 0.9769  | 
 1.0161  | 
 1069  | 
|  TEST_TIME  | 
 25  | 
 4175.16  | 
 0.9780  | 
 1.0272  | 
 1819  | 
|  TEST_TIME  | 
 26  | 
 4236.22  | 
 0.9735  | 
 1.0260  | 
 1918  | 
|  TEST_TIME  | 
 27  | 
 4287.04  | 
 0.9763  | 
 1.0249  | 
 2478  | 
|  TEST_TIME  | 
 28  | 
 4335.36  | 
 0.9773  | 
 1.0210  | 
 2053  | 
|  TEST_TIME  | 
 29  | 
 4361.60  | 
 0.9799  | 
 1.0191  | 
 2054  | 
|  TEST_TIME  | 
 30  | 
 4376.73  | 
 0.9817  | 
 1.0194  | 
 1532  | 
|  TEST_TIME  | 
 31  | 
 4397.78  | 
 0.9818  | 
 1.0186  | 
 1497  | 
|  TEST_TIME  | 
 32  | 
 4412.84  | 
 0.9834  | 
 1.0165  | 
 1744  | 
|  TEST_TIME  | 
 33  | 
 4429.82  | 
 0.9820  | 
 1.0233  | 
 1692  | 
|  TEST_TIME  | 
 34  | 
 4473.27  | 
 0.9838  | 
 1.0180  | 
 1680  | 
|  TEST_TIME  | 
 35  | 
 4497.20  | 
 0.9837  | 
 1.0197  | 
 1521  | 
|  TEST_TIME  | 
 36  | 
 4515.94  | 
 0.9873  | 
 1.0150  | 
 1494  | 
|  TEST_TIME  | 
 37  | 
 4513.91  | 
 0.9880  | 
 1.0113  | 
 1347  | 
|  TEST_TIME  | 
 38  | 
 4509.12  | 
 0.9857  | 
 1.0137  | 
 1423  | 
|  TEST_TIME  | 
 39  | 
 4526.96  | 
 0.9838  | 
 1.0127  | 
 1082  | 
|  TEST_TIME  | 
 40  | 
 4547.84  | 
 0.9829  | 
 1.0184  | 
 2105  | 
|  TEST_TIME  | 
 41  | 
 4593.01  | 
 0.9838  | 
 1.0127  | 
 1603  | 
|  TEST_TIME  | 
 42  | 
 4613.09  | 
 0.9843  | 
 1.0182  | 
 1682  | 
|  TEST_TIME  | 
 43  | 
 4673.17  | 
 0.9818  | 
 1.0170  | 
 1799  | 
|  TEST_TIME  | 
 44  | 
 4708.96  | 
 0.9864  | 
 1.0149  | 
 1512  | 
|  TEST_TIME  | 
 45  | 
 4732.15  | 
 0.9875  | 
 1.0118  | 
 1533  | 
|  TEST_TIME  | 
 46  | 
 4749.30  | 
 0.9863  | 
 1.0140  | 
 1680  | 
|  TEST_TIME  | 
 47  | 
 4773.35  | 
 0.9874  | 
 1.0138  | 
 1534  | 
|  TEST_TIME  | 
 48  | 
 4807.13  | 
 0.9857  | 
 1.0142  | 
 1464  | 
|  TEST_TIME  | 
 49  | 
 4830.89  | 
 0.9886  | 
 1.0087  | 
 1180  | 
|  TEST_TIME  | 
 50  | 
 4832.57  | 
 0.9885  | 
 1.0102  | 
 1503  | 
|  TEST_TIME  | 
 51  | 
 4843.15  | 
 0.9882  | 
 1.0096  | 
 1480  | 
|  TEST_TIME  | 
 52  | 
 4842.81  | 
 0.9903  | 
 1.0105  | 
 1370  | 
|  TEST_TIME  | 
 53  | 
 4848.02  | 
 0.9903  | 
 1.0094  | 
 1352  | 
|  TEST_TIME  | 
 54  | 
 4853.75  | 
 0.9895  | 
 1.0085  | 
 1450  | 
|  TEST_TIME  | 
 55  | 
 4862.08  | 
 0.9884  | 
 1.0146  | 
 1971  | 
|  TEST_TIME  | 
 56  | 
 4901.40  | 
 0.9885  | 
 1.0121  | 
 1936  | 
|  TEST_TIME  | 
 57  | 
 4927.33  | 
 0.9891  | 
 1.0134  | 
 1798  | 
|  TEST_TIME  | 
 58  | 
 4952.64  | 
 0.9909  | 
 1.0082  | 
 1752  | 
|  TEST_TIME  | 
 59  | 
 4957.94  | 
 0.9900  | 
 1.0114  | 
 1839  | 
|  TEST_TIME  | 
 60  | 
 4980.98  | 
 0.9899  | 
 1.0131  | 
 1659  | 
|  TEST_TIME  | 
 61  | 
 5004.45  | 
 0.9918  | 
 1.0075  | 
 1450  | 
|  TEST_TIME  | 
 62  | 
 5011.40  | 
 0.9899  | 
 1.0088  | 
 1486  | 
|  TEST_TIME  | 
 63  | 
 5019.07  | 
 0.9913  | 
 1.0065  | 
 1623  | 
|  TEST_TIME  | 
 64  | 
 5002.73  | 
 0.9940  | 
 1.0060  | 
 1379  | 
|  TEST_TIME  | 
 65  | 
 4999.69  | 
 0.9911  | 
 1.0076  | 
 1452  | 
|  TEST_TIME  | 
 66  | 
 4990.64  | 
 0.9941  | 
 1.0055  | 
 1372  | 
|  TEST_TIME  | 
 67  | 
 4977.63  | 
 0.9931  | 
 1.0082  | 
 1182  | 
|  TEST_TIME  | 
 68  | 
 4975.75  | 
 0.9938  | 
 1.0060  | 
 1299  | 
|  TEST_TIME  | 
 69  | 
 4957.46  | 
 0.9950  | 
 1.0074  | 
 1244  | 
|  TEST_TIME  | 
 70  | 
 4960.18  | 
 0.9925  | 
 1.0068  | 
 2015  | 
|  TEST_TIME  | 
 71  | 
 4963.25  | 
 0.9920  | 
 1.0085  | 
 1679  | 
|  TEST_TIME  | 
 72  | 
 4975.87  | 
 0.9920  | 
 1.0078  | 
 1887  | 
|  TEST_TIME  | 
 73  | 
 4990.04  | 
 0.9912  | 
 1.0072  | 
 1579  | 
|  TEST_TIME  | 
 74  | 
 4995.68  | 
 0.9925  | 
 1.0063  | 
 1565  | 
|  TEST_TIME  | 
 75  | 
 4986.19  | 
 0.9947  | 
 1.0043  | 
 1436  | 
|  TEST_TIME  | 
 76  | 
 4976.82  | 
 0.9930  | 
 1.0071  | 
 1535  | 
|  TEST_TIME  | 
 77  | 
 4977.50  | 
 0.9939  | 
 1.0075  | 
 1495  | 
|  TEST_TIME  | 
 78  | 
 4985.01  | 
 0.9932  | 
 1.0081  | 
 1560  | 
|  TEST_TIME  | 
 79  | 
 4995.72  | 
 0.9932  | 
 1.0065  | 
 1494  | 
|  TEST_TIME  | 
 80  | 
 4996.29  | 
 0.9938  | 
 1.0077  | 
 1345  | 
|  TEST_TIME  | 
 81  | 
 4995.61  | 
 0.9954  | 
 1.0047  | 
 1273  | 
|  TEST_TIME  | 
 82  | 
 4991.63  | 
 0.9932  | 
 1.0064  | 
 937  | 
|  TEST_TIME  | 
 83  | 
 4990.21  | 
 0.9945  | 
 1.0048  | 
 1083  | 
|  TEST_TIME  | 
 84  | 
 4987.01  | 
 0.9934  | 
 1.0050  | 
 1194  | 
|  TEST_TIME  | 
 85  | 
 4987.55  | 
 0.9930  | 
 1.0101  | 
 1816  | 
|  TEST_TIME  | 
 86  | 
 5009.89  | 
 0.9939  | 
 1.0054  | 
 1453  | 
|  TEST_TIME  | 
 87  | 
 5016.02  | 
 0.9926  | 
 1.0077  | 
 1574  | 
|  TEST_TIME  | 
 88  | 
 5028.75  | 
 0.9938  | 
 1.0067  | 
 1772  | 
|  TEST_TIME  | 
 89  | 
 5033.74  | 
 0.9944  | 
 1.0074  | 
 1137  | 
|  TEST_TIME  | 
 90  | 
 5048.82  | 
 0.9932  | 
 1.0048  | 
 1142  | 
|  TEST_TIME  | 
 91  | 
 5048.69  | 
 0.9938  | 
 1.0066  | 
 1655  | 
|  TEST_TIME  | 
 92  | 
 5058.50  | 
 0.9937  | 
 1.0052  | 
 1366  | 
|  TEST_TIME  | 
 93  | 
 5050.92  | 
 0.9959  | 
 1.0050  | 
 1354  | 
|  TEST_TIME  | 
 94  | 
 5055.64  | 
 0.9934  | 
 1.0056  | 
 1378  | 
|  TEST_TIME  | 
 95  | 
 5054.97  | 
 0.9952  | 
 1.0049  | 
 1328  | 
|  TEST_TIME  | 
 96  | 
 5056.59  | 
 0.9941  | 
 1.0059  | 
 1280  | 
|  TEST_TIME  | 
 97  | 
 5060.84  | 
 0.9947  | 
 1.0055  | 
 1274  | 
|  TEST_TIME  | 
 98  | 
 5066.61  | 
 0.9941  | 
 1.0086  | 
 1088  | 
|  TEST_TIME  | 
 99  | 
 5072.91  | 
 0.9972  | 
 1.0036  | 
 898  | 
|  TEST_TIME  | 
 100  | 
 5071.75  | 
 0.9937  | 
 1.0071  | 
 1962  | 
|  TEST_TIME  | 
 101  | 
 5099.26  | 
 0.9917  | 
 1.0065  | 
 1630  | 
|  TEST_TIME  | 
 102  | 
 5109.17  | 
 0.9947  | 
 1.0068  | 
 1503  | 
|  TEST_TIME  | 
 103  | 
 5131.30  | 
 0.9927  | 
 1.0069  | 
 1585  | 
|  TEST_TIME  | 
 104  | 
 5144.13  | 
 0.9947  | 
 1.0060  | 
 1357  | 
|  TEST_TIME  | 
 105  | 
 5156.47  | 
 0.9940  | 
 1.0056  | 
 1428  | 
|  TEST_TIME  | 
 106  | 
 5166.18  | 
 0.9942  | 
 1.0070  | 
 1224  | 
|  TEST_TIME  | 
 107  | 
 5177.85  | 
 0.9953  | 
 1.0053  | 
 1227  | 
|  TEST_TIME  | 
 108  | 
 5181.77  | 
 0.9953  | 
 1.0043  | 
 1467  | 
|  TEST_TIME  | 
 109  | 
 5193.48  | 
 0.9929  | 
 1.0054  | 
 1312  | 
|  TEST_TIME  | 
 110  | 
 5200.66  | 
 0.9949  | 
 1.0041  | 
 1097  | 
|  TEST_TIME  | 
 111  | 
 5199.76  | 
 0.9953  | 
 1.0060  | 
 1246  | 
|  TEST_TIME  | 
 112  | 
 5205.82  | 
 0.9959  | 
 1.0043  | 
 1245  | 
|  TEST_TIME  | 
 113  | 
 5204.21  | 
 0.9958  | 
 1.0032  | 
 1142  | 
|  TEST_TIME  | 
 114  | 
 5199.96  | 
 0.9952  | 
 1.0073  | 
 1024  | 
|  TEST_TIME  | 
 115  | 
 5219.77  | 
 0.9947  | 
 1.0054  | 
 1595  | 
|  TEST_TIME  | 
 116  | 
 5245.92  | 
 0.9918  | 
 1.0040  | 
 1260  | 
|  TEST_TIME  | 
 117  | 
 5254.12  | 
 0.9938  | 
 1.0056  | 
 1498  | 
|  TEST_TIME  | 
 118  | 
 5266.34  | 
 0.9948  | 
 1.0052  | 
 1847  | 
|  TEST_TIME  | 
 119  | 
 5277.18  | 
 0.9947  | 
 1.0044  | 
 1604  | 
|  TEST_TIME  | 
 120  | 
 5291.08  | 
 0.9934  | 
 1.0068  | 
 1316  | 
|  TEST_TIME  | 
 121  | 
 5308.10  | 
 0.9953  | 
 1.0060  | 
 1469  | 
|  TEST_TIME  | 
 122  | 
 5315.85  | 
 0.9963  | 
 1.0039  | 
 1079  | 
|  TEST_TIME  | 
 123  | 
 5322.46  | 
 0.9945  | 
 1.0045  | 
 1372  | 
|  TEST_TIME  | 
 124  | 
 5332.79  | 
 0.9946  | 
 1.0044  | 
 1399  | 
|  TEST_TIME  | 
 125  | 
 5334.90  | 
 0.9960  | 
 1.0068  | 
 1374  | 
|  TEST_TIME  | 
 126  | 
 5345.17  | 
 0.9969  | 
 1.0031  | 
 960  | 
|  TEST_TIME  | 
 127  | 
 5343.21  | 
 0.9956  | 
 1.0041  | 
 1075  | 
|  TEST_TIME  | 
 128  | 
 5345.60  | 
 0.9958  | 
 1.0056  | 
 1034  | 
|  TEST_TIME  | 
 129  | 
 5354.16  | 
 0.9962  | 
 1.0028  | 
 944  | 
|  TEST_TIME  | 
 130  | 
 5360.53  | 
 0.9939  | 
 1.0054  | 
 1608  | 
|  TEST_TIME  | 
 131  | 
 5380.84  | 
 0.9940  | 
 1.0043  | 
 1368  | 
|  TEST_TIME  | 
 132  | 
 5384.68  | 
 0.9960  | 
 1.0060  | 
 1130  | 
|  TEST_TIME  | 
 133  | 
 5397.12  | 
 0.9961  | 
 1.0048  | 
 1200  | 
|  TEST_TIME  | 
 134  | 
 5400.56  | 
 0.9967  | 
 1.0039  | 
 1210  | 
|  TEST_TIME  | 
 135  | 
 5403.41  | 
 0.9959  | 
 1.0037  | 
 1330  | 
|  TEST_TIME  | 
 136  | 
 5411.99  | 
 0.9948  | 
 1.0047  | 
 1223  | 
|  TEST_TIME  | 
 137  | 
 5418.88  | 
 0.9961  | 
 1.0029  | 
 1205  | 
|  TEST_TIME  | 
 138  | 
 5420.51  | 
 0.9953  | 
 1.0050  | 
 1281  | 
|  TEST_TIME  | 
 139  | 
 5437.71  | 
 0.9947  | 
 1.0055  | 
 1126  | 
|  TEST_TIME  | 
 140  | 
 5445.08  | 
 0.9970  | 
 1.0031  | 
 1194  | 
|  TEST_TIME  | 
 141  | 
 5447.94  | 
 0.9955  | 
 1.0037  | 
 1059  | 
|  TEST_TIME  | 
 142  | 
 5445.90  | 
 0.9971  | 
 1.0033  | 
 1039  | 
|  TEST_TIME  | 
 143  | 
 5440.26  | 
 0.9974  | 
 1.0028  | 
 1149  | 
|  TEST_TIME  | 
 144  | 
 5452.48  | 
 0.9937  | 
 1.0028  | 
 874  | 
|  TEST_TIME  | 
 145  | 
 5449.29  | 
 0.9965  | 
 1.0035  | 
 1205  | 
|  TEST_TIME  | 
 146  | 
 5453.26  | 
 0.9959  | 
 1.0045  | 
 1219  | 
|  TEST_TIME  | 
 147  | 
 5465.23  | 
 0.9955  | 
 1.0030  | 
 1393  | 
|  TEST_TIME  | 
 148  | 
 5472.28  | 
 0.9950  | 
 1.0038  | 
 1382  | 
|  TEST_TIME  | 
 149  | 
 5479.56  | 
 0.9957  | 
 1.0039  | 
 1293  | 
|  TEST_TIME  | 
 150  | 
 5487.48  | 
 0.9958  | 
 1.0039  | 
 1194  | 
|  TEST_TIME  | 
 151  | 
 5488.86  | 
 0.9970  | 
 1.0056  | 
 1145  | 
|  TEST_TIME  | 
 152  | 
 5500.02  | 
 0.9970  | 
 1.0035  | 
 1252  | 
|  TEST_TIME  | 
 153  | 
 5504.91  | 
 0.9961  | 
 1.0031  | 
 1163  | 
|  TEST_TIME  | 
 154  | 
 5524.19  | 
 0.9931  | 
 1.0035  | 
 777  | 
|  TEST_TIME  | 
 155  | 
 5526.03  | 
 0.9967  | 
 1.0023  | 
 814  | 
|  TEST_TIME  | 
 156  | 
 5522.86  | 
 0.9964  | 
 1.0032  | 
 901  | 
|  TEST_TIME  | 
 157  | 
 5535.13  | 
 0.9946  | 
 1.0028  | 
 644  | 
|  TEST_TIME  | 
 158  | 
 5531.47  | 
 0.9971  | 
 1.0028  | 
 1068  | 
|  TEST_TIME  | 
 159  | 
 5528.25  | 
 0.9971  | 
 1.0028  | 
 1141  | 
|  TEST_TIME  | 
 160  | 
 5538.09  | 
 0.9948  | 
 1.0044  | 
 1403  | 
|  TEST_TIME  | 
 161  | 
 5548.31  | 
 0.9964  | 
 1.0037  | 
 1263  | 
|  TEST_TIME  | 
 162  | 
 5558.60  | 
 0.9956  | 
 1.0037  | 
 1203  | 
|  TEST_TIME  | 
 163  | 
 5567.07  | 
 0.9961  | 
 1.0032  | 
 1406  | 
|  TEST_TIME  | 
 164  | 
 5573.79  | 
 0.9959  | 
 1.0031  | 
 1276  | 
|  TEST_TIME  | 
 165  | 
 5574.03  | 
 0.9970  | 
 1.0035  | 
 1233  | 
|  TEST_TIME  | 
 166  | 
 5579.11  | 
 0.9966  | 
 1.0053  | 
 1299  | 
|  TEST_TIME  | 
 167  | 
 5589.01  | 
 0.9975  | 
 1.0022  | 
 1066  | 
|  TEST_TIME  | 
 168  | 
 5588.23  | 
 0.9964  | 
 1.0033  | 
 1353  | 
|  TEST_TIME  | 
 169  | 
 5593.59  | 
 0.9965  | 
 1.0032  | 
 1235  | 
|  TEST_TIME  | 
 170  | 
 5596.74  | 
 0.9967  | 
 1.0024  | 
 886  | 
|  TEST_TIME  | 
 171  | 
 5599.25  | 
 0.9960  | 
 1.0023  | 
 876  | 
|  TEST_TIME  | 
 172  | 
 5597.63  | 
 0.9967  | 
 1.0032  | 
 1050  | 
|  TEST_TIME  | 
 173  | 
 5604.51  | 
 0.9961  | 
 1.0035  | 
 1059  | 
|  TEST_TIME  | 
 174  | 
 5613.58  | 
 0.9961  | 
 1.0034  | 
 873  | 
|  TEST_TIME  | 
 175  | 
 5619.33  | 
 0.9967  | 
 1.0040  | 
 1343  | 
|  TEST_TIME  | 
 176  | 
 5630.43  | 
 0.9963  | 
 1.0030  | 
 1170  | 
|  TEST_TIME  | 
 177  | 
 5633.98  | 
 0.9967  | 
 1.0029  | 
 1314  | 
|  TEST_TIME  | 
 178  | 
 5637.04  | 
 0.9968  | 
 1.0038  | 
 1075  | 
|  TEST_TIME  | 
 179  | 
 5645.18  | 
 0.9973  | 
 1.0029  | 
 1092  | 
|  TEST_TIME  | 
 180  | 
 5643.51  | 
 0.9977  | 
 1.0040  | 
 956  | 
|  TEST_TIME  | 
 181  | 
 5650.09  | 
 0.9973  | 
 1.0028  | 
 1183  | 
|  TEST_TIME  | 
 182  | 
 5652.73  | 
 0.9968  | 
 1.0040  | 
 1148  | 
|  TEST_TIME  | 
 183  | 
 5658.30  | 
 0.9976  | 
 1.0026  | 
 1208  | 
|  TEST_TIME  | 
 184  | 
 5657.20  | 
 0.9974  | 
 1.0029  | 
 1252  | 
|  TEST_TIME  | 
 185  | 
 5661.03  | 
 0.9969  | 
 1.0038  | 
 1055  | 
|  TEST_TIME  | 
 186  | 
 5669.67  | 
 0.9969  | 
 1.0029  | 
 1091  | 
|  TEST_TIME  | 
 187  | 
 5668.53  | 
 0.9977  | 
 1.0026  | 
 989  | 
|  TEST_TIME  | 
 188  | 
 5668.19  | 
 0.9974  | 
 1.0034  | 
 855  | 
|  TEST_TIME  | 
 189  | 
 5677.80  | 
 0.9964  | 
 1.0027  | 
 888  | 
|  TEST_TIME  | 
 190  | 
 5682.80  | 
 0.9966  | 
 1.0031  | 
 1165  | 
|  TEST_TIME  | 
 191  | 
 5670.98  | 
 1.0000  | 
 1.0000  | 
 1  | 
 
Done for 7350 ms, from  8:00:28.07 to  8:00:35.42.  
 
 
|  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  | 
 1937555  | 
 1644295  | 
 293260  | 
 15.13  | 
 0  | 
 483  | 
 1  | 
 293260  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  doc_list_biud  | 
 1937906  | 
 1644295  | 
 293611  | 
 15.15  | 
 0  | 
 437  | 
 1  | 
 293611  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_add_invoice_to_stock  | 
 17698  | 
 12596  | 
 5102  | 
 28.82  | 
 0  | 
 8003  | 
 674  | 
 5102  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_cancel_adding_invoice  | 
 4788  | 
 3260  | 
 1528  | 
 31.91  | 
 0  | 
 3151  | 
 179  | 
 1528  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_cancel_client_order  | 
 6154  | 
 6076  | 
 78  | 
 1.26  | 
 0  | 
 109  | 
 7  | 
 78  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_cancel_customer_reserve  | 
 498377  | 
 218574  | 
 279803  | 
 56.14  | 
 0  | 
 437  | 
 7  | 
 279803  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_cancel_pay_from_customer  | 
 2265  | 
 2255  | 
 10  | 
 0.44  | 
 0  | 
 78  | 
 5  | 
 10  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_cancel_pay_to_supplier  | 
 1449  | 
 1449  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 4  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_cancel_supplier_invoice  | 
 8560  | 
 6946  | 
 1614  | 
 18.85  | 
 0  | 
 1139  | 
 62  | 
 1614  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_cancel_supplier_order  | 
 1364  | 
 505  | 
 859  | 
 62.97  | 
 16  | 
 36349  | 
 3514  | 
 859  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_cancel_write_off  | 
 25670  | 
 14302  | 
 11368  | 
 44.28  | 
 0  | 
 453  | 
 10  | 
 11368  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_client_order  | 
 73587  | 
 73587  | 
 0  | 
 0.00  | 
 0  | 
 343  | 
 14  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_customer_reserve  | 
 563862  | 
 563862  | 
 0  | 
 0.00  | 
 0  | 
 562  | 
 10  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_fill_shopping_cart  | 
 111335  | 
 111335  | 
 0  | 
 0.00  | 
 0  | 
 2077  | 
 10  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_fill_shopping_cart_clo_res  | 
 563862  | 
 563862  | 
 0  | 
 0.00  | 
 0  | 
 125  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_get_clo_for_invoice  | 
 12596  | 
 12596  | 
 0  | 
 0.00  | 
 0  | 
 203  | 
 14  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_kill_cost_storno  | 
 33568  | 
 21266  | 
 12302  | 
 36.64  | 
 0  | 
 110  | 
 1  | 
 12302  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 1030979  | 
 458901  | 
 572078  | 
 55.48  | 
 0  | 
 437  | 
 2  | 
 572078  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_kill_qty_storno  | 
 590489  | 
 296899  | 
 293590  | 
 49.71  | 
 0  | 
 437  | 
 6  | 
 293590  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_lock_selected_doc  | 
 72482  | 
 65332  | 
 7150  | 
 9.86  | 
 0  | 
 125  | 
 0  | 
 7150  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_make_cost_storno  | 
 92010  | 
 92010  | 
 0  | 
 0.00  | 
 0  | 
 436  | 
 12  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_multiply_rows_for_pdistr  | 
 92010  | 
 92010  | 
 0  | 
 0.00  | 
 0  | 
 109  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_multiply_rows_for_qdistr  | 
 73587  | 
 73587  | 
 0  | 
 0.00  | 
 0  | 
 312  | 
 5  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_pay_from_customer  | 
 24523  | 
 24523  | 
 0  | 
 0.00  | 
 0  | 
 483  | 
 33  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_pay_to_supplier  | 
 20251  | 
 20251  | 
 0  | 
 0.00  | 
 0  | 
 468  | 
 19  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_payment_common  | 
 44774  | 
 44774  | 
 0  | 
 0.00  | 
 0  | 
 125  | 
 5  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_qd_handle_on_cancel_clo  | 
 6153  | 
 6076  | 
 77  | 
 1.25  | 
 0  | 
 94  | 
 2  | 
 77  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 17059  | 
 15856  | 
 1203  | 
 7.05  | 
 0  | 
 218  | 
 18  | 
 1203  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 34640  | 
 34640  | 
 0  | 
 0.00  | 
 0  | 
 265  | 
 2  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_reserve_write_off  | 
 34921  | 
 34640  | 
 281  | 
 0.80  | 
 0  | 
 312  | 
 18  | 
 281  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_supplier_invoice  | 
 18762  | 
 18762  | 
 0  | 
 0.00  | 
 0  | 
 2095  | 
 110  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  sp_supplier_order  | 
 18986  | 
 18986  | 
 0  | 
 0.00  | 
 0  | 
 1092  | 
 86  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  srv_find_qd_qs_mism  | 
 1239640  | 
 946358  | 
 293282  | 
 23.65  | 
 0  | 
 390  | 
 0  | 
 293282  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  srv_make_invnt_saldo  | 
 7325  | 
 7325  | 
 0  | 
 0.00  | 
 0  | 
 951  | 
 62  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  srv_make_money_saldo  | 
 4518  | 
 4518  | 
 0  | 
 0.00  | 
 0  | 
 47  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 842  | 
 2074  | 
 1440  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 5102  | 
 5102  | 
 0  | 
 0.00  | 
 0  | 
 47  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 511  | 
 511  | 
 0  | 
 0.00  | 
 0  | 
 62  | 
 5  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_cancel_client_order  | 
 78  | 
 78  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 22  | 
 22  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 10  | 
 10  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 3  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 439  | 
 439  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 33338  | 
 33338  | 
 0  | 
 0.00  | 
 0  | 
 109  | 
 12  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_cancel_write_off  | 
 13  | 
 13  | 
 0  | 
 0.00  | 
 0  | 
 15  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-abend:sp_reserve_write_off  | 
 281  | 
 281  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 12596  | 
 12596  | 
 0  | 
 0.00  | 
 0  | 
 359  | 
 59  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1041  | 
 1041  | 
 0  | 
 0.00  | 
 0  | 
 593  | 
 63  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6076  | 
 6076  | 
 0  | 
 0.00  | 
 0  | 
 63  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2297  | 
 2297  | 
 0  | 
 0.00  | 
 0  | 
 109  | 
 2  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2255  | 
 2255  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1449  | 
 1449  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 1050  | 
 1050  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 505  | 
 505  | 
 0  | 
 0.00  | 
 0  | 
 4055  | 
 396  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3423  | 
 3423  | 
 0  | 
 0.00  | 
 0  | 
 47  | 
 2  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_client_order  | 
 73587  | 
 73587  | 
 0  | 
 0.00  | 
 0  | 
 421  | 
 2  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_customer_reserve  | 
 3463  | 
 3463  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_pay_from_customer  | 
 24523  | 
 24523  | 
 0  | 
 0.00  | 
 0  | 
 94  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 20251  | 
 20251  | 
 0  | 
 0.00  | 
 0  | 
 125  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_reserve_write_off  | 
 34640  | 
 34640  | 
 0  | 
 0.00  | 
 0  | 
 93  | 
 2  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_supplier_invoice  | 
 18762  | 
 18762  | 
 0  | 
 0.00  | 
 0  | 
 78  | 
 2  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:sp_supplier_order  | 
 18986  | 
 18986  | 
 0  | 
 0.00  | 
 0  | 
 78  | 
 2  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 7325  | 
 7325  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:srv_make_money_saldo  | 
 4518  | 
 4518  | 
 0  | 
 0.00  | 
 0  | 
 47  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 6  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_add_invoice_to_stock  | 
 35396  | 
 25192  | 
 10204  | 
 28.82  | 
 0  | 
 46  | 
 0  | 
 10204  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_all_customers  | 
 110328  | 
 110328  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_all_suppliers  | 
 81894  | 
 81894  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_all_wares  | 
 147174  | 
 147174  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_cancel_adding_invoice  | 
 2774  | 
 2082  | 
 692  | 
 24.94  | 
 0  | 
 187  | 
 10  | 
 692  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_cancel_client_order  | 
 12308  | 
 12152  | 
 156  | 
 1.26  | 
 0  | 
 16  | 
 0  | 
 156  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_cancel_customer_prepayment  | 
 4530  | 
 4510  | 
 20  | 
 0.44  | 
 0  | 
 16  | 
 0  | 
 20  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_cancel_customer_reserve  | 
 4638  | 
 4594  | 
 44  | 
 0.94  | 
 0  | 
 63  | 
 0  | 
 44  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_cancel_payment_to_supplier  | 
 2898  | 
 2898  | 
 0  | 
 0.00  | 
 0  | 
 16  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_cancel_supplier_invoice  | 
 2978  | 
 2100  | 
 878  | 
 29.48  | 
 0  | 
 16  | 
 0  | 
 878  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_cancel_supplier_order  | 
 2728  | 
 1010  | 
 1718  | 
 62.97  | 
 0  | 
 62  | 
 0  | 
 1718  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_cancel_write_off  | 
 6872  | 
 6846  | 
 26  | 
 0.37  | 
 0  | 
 172  | 
 7  | 
 26  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_max_id_clo_ord  | 
 18986  | 
 18986  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_max_id_clo_res  | 
 3463  | 
 3463  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_max_id_ord_sup  | 
 18762  | 
 18762  | 
 0  | 
 0.00  | 
 0  | 
 62  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_max_non_paid_invoice  | 
 17052  | 
 17052  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_max_non_paid_realizn  | 
 24523  | 
 24523  | 
 0  | 
 0.00  | 
 0  | 
 47  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_min_id_clo_ord  | 
 18986  | 
 18986  | 
 0  | 
 0.00  | 
 0  | 
 63  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_min_id_clo_res  | 
 3463  | 
 3463  | 
 0  | 
 0.00  | 
 0  | 
 93  | 
 1  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_min_id_ord_sup  | 
 18762  | 
 18762  | 
 0  | 
 0.00  | 
 0  | 
 171  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_min_non_paid_invoice  | 
 20251  | 
 20251  | 
 0  | 
 0.00  | 
 0  | 
 63  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_min_non_paid_realizn  | 
 24523  | 
 24523  | 
 0  | 
 0.00  | 
 0  | 
 47  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_our_firm  | 
 36846  | 
 36846  | 
 0  | 
 0.00  | 
 0  | 
 31  | 
 0  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  v_reserve_write_off  | 
 69842  | 
 69280  | 
 562  | 
 0.80  | 
 0  | 
 110  | 
 0  | 
 562  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  x_lock_depdocs_on_canc_invoice  | 
 17782  | 
 9156  | 
 8626  | 
 48.50  | 
 0  | 
 109  | 
 2  | 
 8626  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1364  | 
 505  | 
 859  | 
 62.97  | 
 0  | 
 31  | 
 2  | 
 859  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  x_make_qstorno_1000_1200  | 
 18986  | 
 18986  | 
 0  | 
 0.00  | 
 0  | 
 546  | 
 50  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  x_make_qstorno_1200_2000  | 
 18762  | 
 18762  | 
 0  | 
 0.00  | 
 0  | 
 593  | 
 87  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  x_make_qstorno_2100_3300  | 
 563862  | 
 563862  | 
 0  | 
 0.00  | 
 0  | 
 562  | 
 9  | 
 0  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
 
Done for 156400 ms, from  8:03:00.64 to  8:05:37.04.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 32  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2015-12-15 05:00  | 
 2015-12-15 07:41  | 
|  deadlock  | 
 1800  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2015-12-15 04:56  | 
 2015-12-15 07:55  | 
|  deadlock  | 
 77  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2015-12-15 04:56  | 
 2015-12-15 07:52  | 
|  deadlock  | 
 252  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2015-12-15 04:55  | 
 2015-12-15 07:53  | 
|  deadlock  | 
 8  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2015-12-15 05:11  | 
 2015-12-15 07:01  | 
|  concurrent_transaction  | 
 4059  | 
 sp_lock_selected_doc  | 
 335544878  | 
 2015-12-15 04:56  | 
 2015-12-15 07:55  | 
|  concurrent_transaction  | 
 858  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544878  | 
 2015-12-15 04:55  | 
 2015-12-15 07:55  | 
|  concurrent_transaction  | 
 61  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544878  | 
 2015-12-15 04:56  | 
 2015-12-15 07:49  | 
 
Done for 8120 ms, from  8:05:43.74 to  8:05:51.86.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          373176
 
MON$OLDEST_ACTIVE               373177
 
MON$OLDEST_SNAPSHOT             373177
 
MON$NEXT_TRANSACTION            373177
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2015-12-11 13:07:49.8140
 
MON$PAGES                       730368
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.0.32219 Firebird 3.0 Release Candidate 2
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.0.32219 Firebird 3.0 Release Candidate 2"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.0.32219 Firebird 3.0 Release Candidate 2/tcp (WIN-2BE1UI8LGDL)/P13"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.0.32219 Firebird 3.0 Release Candidate 2/tcp (WIN-2BE1UI8LGDL)/P13"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		373236 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	373178 
 
Oldest active		373179 
 
Oldest snapshot		373179 
 
Next transaction	373180 
 
Sequence number		0 
 
Next attachment ID	4999 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Dec 11, 2015 13:07:49 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\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: 34.24, total records: 50 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 344.00, compression ratio: 10.05 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 31% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_ID_DESC (2) 
 
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_OUR_FIRM (4) 
 
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 48 
 
Average key length: 2.04, compression ratio: 0.50 
 
Average prefix length: 0.96, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_SUPPLIER (3) 
 
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 45 
 
Average key length: 2.04, compression ratio: 0.53 
 
Average prefix length: 1.02, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_NAME_UNQ (1) 
 
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.92, total dup: 0, max dup: 0 
 
Average key length: 16.60, compression ratio: 0.92 
 
Average prefix length: 1.34, average data length: 13.92 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_AGENTS (0) 
 
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
BUSINESS_OPS (158) 
 
Primary pointer page: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 103.00, total records: 19 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 996.00, compression ratio: 9.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 28% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BO_UNIT_UNQ (1) 
 
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 18.00, total dup: 0, max dup: 0 
 
Average key length: 16.95, compression ratio: 1.25 
 
Average prefix length: 7.21, average data length: 14.00 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BUSINESS_OPS_RND_WGTH (2) 
 
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 4.05, total dup: 7, max dup: 3 
 
Average key length: 3.00, compression ratio: 0.75 
 
Average prefix length: 1.42, average data length: 0.84 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RDB$1 (0) 
 
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 5.26, total dup: 0, max dup: 0 
 
Average key length: 4.21, compression ratio: 0.64 
 
Average prefix length: 1.05, average data length: 1.63 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
DOC_DATA (141) 
 
Primary pointer page: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 46.90, total records: 1927145 
 
Average version length: 46.78, total versions: 49, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.36 
 
Pointer pages: 13, data page slots: 20584 
 
Data pages: 20584, average fill: 73% 
 
Primary pages: 20584, secondary pages: 0, swept pages: 14573 
 
Empty pages: 7, full pages: 20445 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 2 
 
40 - 59% = 1 
 
60 - 79% = 20574 
 
80 - 99% = 0 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 19783, depth: 3, leaf buckets: 8739, nodes: 1927145 
 
Average node length: 19.00, total dup: 0, max dup: 0 
 
Average key length: 16.05, compression ratio: 1.68 
 
Average prefix length: 13.94, average data length: 13.06 
 
Clustering factor: 264235, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 670 
 
20 - 39% = 2176 
 
40 - 59% = 2574 
 
60 - 79% = 1669 
 
80 - 99% = 1650 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 46992, depth: 3, leaf buckets: 6844, nodes: 1927145 
 
Average node length: 11.53, total dup: 0, max dup: 0 
 
Average key length: 8.58, compression ratio: 1.05 
 
Average prefix length: 3.42, average data length: 5.58 
 
Clustering factor: 228724, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 3494 
 
40 - 59% = 3114 
 
60 - 79% = 205 
 
80 - 99% = 28 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 132729, depth: 3, leaf buckets: 2925, nodes: 1927145 
 
Average node length: 6.66, total dup: 1443842, max dup: 49 
 
Average key length: 3.71, compression ratio: 2.42 
 
Average prefix length: 7.54, average data length: 1.46 
 
Clustering factor: 224896, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 57 
 
20 - 39% = 865 
 
40 - 59% = 819 
 
60 - 79% = 705 
 
80 - 99% = 479 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.72, total records: 537721 
 
Average version length: 34.50, total versions: 2, max versions: 2 
 
Average fragment length: 50.78, total fragments: 23, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.58 
 
Pointer pages: 5, data page slots: 6808 
 
Data pages: 6808, average fill: 75% 
 
Primary pages: 6798, secondary pages: 10, swept pages: 6537 
 
Empty pages: 7, full pages: 6772 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 1 
 
40 - 59% = 3 
 
60 - 79% = 6786 
 
80 - 99% = 1 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 229017, depth: 3, leaf buckets: 1991, nodes: 537721 
 
Average node length: 11.64, total dup: 0, max dup: 0 
 
Average key length: 8.80, compression ratio: 1.02 
 
Average prefix length: 3.20, average data length: 5.80 
 
Clustering factor: 73894, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1130 
 
40 - 59% = 820 
 
60 - 79% = 37 
 
80 - 99% = 3 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2964, depth: 2, leaf buckets: 618, nodes: 537721 
 
Average node length: 4.85, total dup: 537671, max dup: 44675 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 249469, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 540 
 
60 - 79% = 62 
 
80 - 99% = 16 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 137972, depth: 3, leaf buckets: 1154, nodes: 537721 
 
Average node length: 11.63, total dup: 0, max dup: 0 
 
Average key length: 8.79, compression ratio: 1.02 
 
Average prefix length: 3.20, average data length: 5.80 
 
Clustering factor: 73894, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 68 
 
40 - 59% = 295 
 
60 - 79% = 480 
 
80 - 99% = 300 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 269, Index root page: 270 
 
Total formats: 1, used formats: 1 
 
Average record length: 62.98, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 16.67, total fragments: 344, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.65 
 
Pointer pages: 1, data page slots: 24 
 
Data pages: 24, average fill: 29% 
 
Primary pages: 7, secondary pages: 17, swept pages: 4 
 
Empty pages: 4, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 4 
 
40 - 59% = 1 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 281, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 262, ratio: 0.66 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.13, total records: 158 
 
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: 96.00, compression ratio: 1.35 
 
Pointer pages: 1, data page slots: 216 
 
Data pages: 16, average fill: 12% 
 
Primary pages: 16, secondary pages: 0, swept pages: 8 
 
Empty pages: 8, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 6 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 997, depth: 2, leaf buckets: 1, nodes: 158 
 
Average node length: 23.53, total dup: 0, max dup: 0 
 
Average key length: 21.53, compression ratio: 1.25 
 
Average prefix length: 8.47, average data length: 18.53 
 
Clustering factor: 92, ratio: 0.58 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 261, Index root page: 262 
 
Total formats: 1, used formats: 1 
 
Average record length: 14.92, 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.15 
 
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% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 272, depth: 1, leaf buckets: 1, nodes: 49 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_TURNOVER_LOG (142) 
 
Primary pointer page: 259, Index root page: 260 
 
Total formats: 1, used formats: 1 
 
Average record length: 45.86, total records: 35 
 
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.40 
 
Pointer pages: 1, data page slots: 5 
 
Data pages: 1, average fill: 28% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 271, depth: 1, leaf buckets: 1, nodes: 35 
 
Average node length: 12.51, total dup: 14, max dup: 4 
 
Average key length: 11.49, compression ratio: 1.65 
 
Average prefix length: 10.09, average data length: 8.91 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_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 MON_LOG_DTS (4) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG (0) 
 
Root page: 359, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (165) 
 
Primary pointer page: 364, Index root page: 365 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_DTS (4) 
 
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_GDSCODE (2) 
 
Root page: 368, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_ROWSET (1) 
 
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.74, total records: 143415 
 
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.50 
 
Pointer pages: 1, data page slots: 1488 
 
Data pages: 1488, average fill: 71% 
 
Primary pages: 1487, secondary pages: 1, swept pages: 1303 
 
Empty pages: 4, full pages: 965 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 7 
 
40 - 59% = 22 
 
60 - 79% = 1451 
 
80 - 99% = 0 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 3600, depth: 2, leaf buckets: 129, nodes: 143415 
 
Average node length: 4.26, total dup: 143366, max dup: 7371 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 30023, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 14 
 
40 - 59% = 65 
 
60 - 79% = 33 
 
80 - 99% = 17 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4281, depth: 2, leaf buckets: 157, nodes: 143415 
 
Average node length: 5.19, total dup: 129454, max dup: 70 
 
Average key length: 2.94, compression ratio: 7.49 
 
Average prefix length: 21.16, average data length: 0.84 
 
Clustering factor: 45855, ratio: 0.32 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 22 
 
40 - 59% = 60 
 
60 - 79% = 56 
 
80 - 99% = 18 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 3974, depth: 2, leaf buckets: 164, nodes: 143415 
 
Average node length: 5.19, total dup: 129454, max dup: 70 
 
Average key length: 2.94, compression ratio: 7.49 
 
Average prefix length: 21.16, average data length: 0.84 
 
Clustering factor: 45873, ratio: 0.32 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 18 
 
40 - 59% = 91 
 
60 - 79% = 43 
 
80 - 99% = 12 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4313, depth: 2, leaf buckets: 154, nodes: 143415 
 
Average node length: 4.98, total dup: 129454, max dup: 70 
 
Average key length: 2.73, compression ratio: 3.30 
 
Average prefix length: 8.37, average data length: 0.63 
 
Clustering factor: 45901, ratio: 0.32 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 15 
 
40 - 59% = 75 
 
60 - 79% = 50 
 
80 - 99% = 13 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.99, total records: 264219 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 1.14 
 
Pointer pages: 2, data page slots: 2264 
 
Data pages: 2264, average fill: 64% 
 
Primary pages: 2264, secondary pages: 0, swept pages: 0 
 
Empty pages: 6, full pages: 2257 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 2257 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 129017, depth: 2, leaf buckets: 208, nodes: 264219 
 
Average node length: 4.52, total dup: 264027, max dup: 2477 
 
Average key length: 2.00, compression ratio: 1.28 
 
Average prefix length: 2.57, average data length: 0.00 
 
Clustering factor: 3819, ratio: 0.01 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 63 
 
60 - 79% = 76 
 
80 - 99% = 69 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (162) 
 
Primary pointer page: 348, Index root page: 349 
 
Total formats: 1, used formats: 1 
 
Average record length: 141.08, total records: 12040226 
 
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: 1240.00, compression ratio: 8.79 
 
Pointer pages: 166, data page slots: 269808 
 
Data pages: 269808, average fill: 86% 
 
Primary pages: 269808, secondary pages: 0, swept pages: 3 
 
Empty pages: 6, full pages: 269801 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 269801 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 59394, depth: 3, leaf buckets: 14922, nodes: 12040226 
 
Average node length: 5.66, total dup: 10884031, max dup: 128 
 
Average key length: 2.18, compression ratio: 3.66 
 
Average prefix length: 7.85, average data length: 0.14 
 
Clustering factor: 1382342, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 11739 
 
60 - 79% = 1684 
 
80 - 99% = 1499 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 119070, depth: 3, leaf buckets: 13826, nodes: 12040226 
 
Average node length: 4.66, total dup: 12040221, max dup: 9865722 
 
Average key length: 1.18, compression ratio: 0.76 
 
Average prefix length: 0.90, average data length: 0.00 
 
Clustering factor: 325550, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 13808 
 
60 - 79% = 1 
 
80 - 99% = 16 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43359, depth: 3, leaf buckets: 15981, nodes: 12040226 
 
Average node length: 5.67, total dup: 11726647, max dup: 36326 
 
Average key length: 2.20, compression ratio: 4.10 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 495951, ratio: 0.04 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 14327 
 
60 - 79% = 1025 
 
80 - 99% = 628 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 65474, depth: 3, leaf buckets: 14756, nodes: 12040226 
 
Average node length: 5.53, total dup: 12032633, max dup: 1889083 
 
Average key length: 2.05, compression ratio: 18.55 
 
Average prefix length: 38.06, average data length: 0.05 
 
Clustering factor: 4745822, ratio: 0.39 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 1 
 
40 - 59% = 12771 
 
60 - 79% = 275 
 
80 - 99% = 1701 
 
 
PHRASES (145) 
 
Primary pointer page: 265, Index root page: 266 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 55.33, total records: 359383 
 
Average version length: 55.40, total versions: 15, 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: 3, data page slots: 4264 
 
Data pages: 4264, average fill: 75% 
 
Primary pages: 4264, secondary pages: 0, swept pages: 3089 
 
Empty pages: 5, full pages: 4232 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 1 
 
40 - 59% = 1 
 
60 - 79% = 4257 
 
80 - 99% = 0 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 2296, depth: 2, leaf buckets: 462, nodes: 359383 
 
Average node length: 5.81, total dup: 306507, max dup: 802 
 
Average key length: 3.08, compression ratio: 2.92 
 
Average prefix length: 8.07, average data length: 0.93 
 
Clustering factor: 42027, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 48 
 
40 - 59% = 261 
 
60 - 79% = 104 
 
80 - 99% = 46 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2211, depth: 2, leaf buckets: 380, nodes: 359383 
 
Average node length: 5.58, total dup: 318601, max dup: 275 
 
Average key length: 2.85, compression ratio: 3.16 
 
Average prefix length: 8.27, average data length: 0.73 
 
Clustering factor: 79327, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 3 
 
40 - 59% = 161 
 
60 - 79% = 141 
 
80 - 99% = 74 
 
 
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: 97.49, 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.82 
 
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.07, total dup: 0, max dup: 0 
 
Average key length: 26.06, compression ratio: 1.70 
 
Average prefix length: 21.23, average data length: 23.07 
 
Clustering factor: 6, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$RAND$CALLS (136) 
 
Primary pointer page: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 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: 358, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 263, Index root page: 264 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.53, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.78 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 77% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 374, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 64 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 273, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 328, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 275, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 328, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400 
 
Average node length: 52.95, total dup: 0, max dup: 0 
 
Average key length: 51.92, compression ratio: 0.99 
 
Average prefix length: 2.65, average data length: 48.95 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 2 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (259) 
 
Primary pointer page: 254, Index root page: 284 
 
Total formats: 1, used formats: 1 
 
Average record length: 72.50, total records: 666 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.88 
 
Pointer pages: 1, data page slots: 120 
 
Data pages: 104, average fill: 8% 
 
Primary pages: 104, secondary pages: 0, swept pages: 102 
 
Empty pages: 54, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 88 
 
20 - 39% = 12 
 
40 - 59% = 4 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1235, depth: 2, leaf buckets: 3, nodes: 666 
 
Average node length: 7.44, total dup: 581, max dup: 14 
 
Average key length: 5.46, compression ratio: 6.78 
 
Average prefix length: 33.67, average data length: 3.33 
 
Clustering factor: 98, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 2 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (261) 
 
Primary pointer page: 708, Index root page: 709 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.76, total records: 111969 
 
Average version length: 71.54, total versions: 105, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.90 
 
Pointer pages: 3, data page slots: 3240 
 
Data pages: 2744, average fill: 45% 
 
Primary pages: 2744, secondary pages: 0, swept pages: 1883 
 
Empty pages: 478, full pages: 583 
 
Fill distribution: 
 
0 - 19% = 778 
 
20 - 39% = 297 
 
40 - 59% = 396 
 
60 - 79% = 1272 
 
80 - 99% = 1 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 1054, depth: 2, leaf buckets: 130, nodes: 111969 
 
Average node length: 4.77, total dup: 105835, max dup: 105 
 
Average key length: 2.40, compression ratio: 3.75 
 
Average prefix length: 8.65, average data length: 0.35 
 
Clustering factor: 14619, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 49 
 
40 - 59% = 42 
 
60 - 79% = 27 
 
80 - 99% = 12 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 421093, depth: 3, leaf buckets: 196, nodes: 111969 
 
Average node length: 5.85, total dup: 96757, max dup: 14 
 
Average key length: 3.48, compression ratio: 10.63 
 
Average prefix length: 35.65, average data length: 1.35 
 
Clustering factor: 21711, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 96 
 
40 - 59% = 85 
 
60 - 79% = 15 
 
80 - 99% = 0 
 
 
XQD_1200_2000 (260) 
 
Primary pointer page: 705, Index root page: 706 
 
Total formats: 1, used formats: 1 
 
Average record length: 72.12, total records: 3470 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.89 
 
Pointer pages: 1, data page slots: 416 
 
Data pages: 232, average fill: 17% 
 
Primary pages: 232, secondary pages: 0, swept pages: 219 
 
Empty pages: 94, full pages: 8 
 
Fill distribution: 
 
0 - 19% = 157 
 
20 - 39% = 37 
 
40 - 59% = 20 
 
60 - 79% = 18 
 
80 - 99% = 0 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 6, nodes: 3470 
 
Average node length: 6.58, total dup: 3051, max dup: 40 
 
Average key length: 4.59, compression ratio: 8.07 
 
Average prefix length: 34.53, average data length: 2.47 
 
Clustering factor: 408, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 3 
 
60 - 79% = 2 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.12, total records: 1069813 
 
Average version length: 70.16, total versions: 6226, 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: 10, data page slots: 14896 
 
Data pages: 14896, average fill: 78% 
 
Primary pages: 14896, secondary pages: 0, swept pages: 3913 
 
Empty pages: 62, full pages: 14643 
 
Fill distribution: 
 
0 - 19% = 75 
 
20 - 39% = 38 
 
40 - 59% = 71 
 
60 - 79% = 14596 
 
80 - 99% = 116 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 163941, depth: 3, leaf buckets: 1584, nodes: 1069813 
 
Average node length: 5.62, total dup: 1001166, max dup: 49 
 
Average key length: 2.70, compression ratio: 13.72 
 
Average prefix length: 36.37, average data length: 0.63 
 
Clustering factor: 96160, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 33 
 
20 - 39% = 678 
 
40 - 59% = 521 
 
60 - 79% = 154 
 
80 - 99% = 198 
 
 
XQD_2100_3300 (263) 
 
Primary pointer page: 734, Index root page: 735 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.28, total records: 5152 
 
Average version length: 70.00, total versions: 11, 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: 2, data page slots: 1344 
 
Data pages: 656, average fill: 9% 
 
Primary pages: 656, secondary pages: 0, swept pages: 426 
 
Empty pages: 335, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 536 
 
20 - 39% = 87 
 
40 - 59% = 30 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1530, depth: 2, leaf buckets: 8, nodes: 5152 
 
Average node length: 5.33, total dup: 4686, max dup: 49 
 
Average key length: 3.36, compression ratio: 11.00 
 
Average prefix length: 35.73, average data length: 1.27 
 
Clustering factor: 590, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 4 
 
40 - 59% = 3 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (264) 
 
Primary pointer page: 737, Index root page: 738 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.13, total records: 2739023 
 
Average version length: 69.62, total versions: 1003, 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: 37952 
 
Data pages: 37952, average fill: 78% 
 
Primary pages: 37952, secondary pages: 0, swept pages: 29618 
 
Empty pages: 3, full pages: 37529 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 7 
 
40 - 59% = 59 
 
60 - 79% = 37781 
 
80 - 99% = 99 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 41262, depth: 3, leaf buckets: 5451, nodes: 2739023 
 
Average node length: 6.77, total dup: 2248714, max dup: 14 
 
Average key length: 3.79, compression ratio: 9.75 
 
Average prefix length: 35.38, average data length: 1.62 
 
Clustering factor: 466998, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 2998 
 
40 - 59% = 1721 
 
60 - 79% = 487 
 
80 - 99% = 238 
 
 
XQS_1000_1200 (265) 
 
Primary pointer page: 740, Index root page: 741 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.12, total records: 3864580 
 
Average version length: 83.06, total versions: 79, 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: 37, data page slots: 59344 
 
Data pages: 59344, average fill: 80% 
 
Primary pages: 59344, secondary pages: 0, swept pages: 18892 
 
Empty pages: 3, full pages: 59304 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 1 
 
40 - 59% = 6 
 
60 - 79% = 17560 
 
80 - 99% = 41774 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54649, depth: 3, leaf buckets: 4602, nodes: 3864580 
 
Average node length: 5.15, total dup: 3776385, max dup: 129 
 
Average key length: 2.17, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 516612, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 290 
 
40 - 59% = 3356 
 
60 - 79% = 798 
 
80 - 99% = 142 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 78654, depth: 3, leaf buckets: 3305, nodes: 3864580 
 
Average node length: 5.79, total dup: 3385946, max dup: 49 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.31, average data length: 0.69 
 
Clustering factor: 88418, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 73 
 
40 - 59% = 496 
 
60 - 79% = 322 
 
80 - 99% = 2413 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 48486, depth: 3, leaf buckets: 5186, nodes: 3864580 
 
Average node length: 5.81, total dup: 3380558, max dup: 26 
 
Average key length: 2.83, compression ratio: 3.18 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 594896, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 324 
 
40 - 59% = 3754 
 
60 - 79% = 972 
 
80 - 99% = 114 
 
 
XQS_1000_3300 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.43, total records: 2788845 
 
Average version length: 82.62, total versions: 440, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 27, data page slots: 43264 
 
Data pages: 43264, average fill: 79% 
 
Primary pages: 43264, secondary pages: 0, swept pages: 33891 
 
Empty pages: 6, full pages: 43103 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 6 
 
40 - 59% = 33 
 
60 - 79% = 15369 
 
80 - 99% = 27844 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 75516, depth: 3, leaf buckets: 2904, nodes: 2788845 
 
Average node length: 5.15, total dup: 2723991, max dup: 150 
 
Average key length: 2.17, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 434047, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 76 
 
40 - 59% = 1481 
 
60 - 79% = 969 
 
80 - 99% = 375 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 17419, depth: 3, leaf buckets: 4186, nodes: 2788845 
 
Average node length: 6.20, total dup: 2292496, max dup: 14 
 
Average key length: 3.22, compression ratio: 2.79 
 
Average prefix length: 7.96, average data length: 1.04 
 
Clustering factor: 193948, ratio: 0.07 
 
Fill distribution: 
 
0 - 19% = 33 
 
20 - 39% = 1461 
 
40 - 59% = 1418 
 
60 - 79% = 714 
 
80 - 99% = 560 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 65477, depth: 3, leaf buckets: 3240, nodes: 2788845 
 
Average node length: 5.81, total dup: 2437974, max dup: 29 
 
Average key length: 2.83, compression ratio: 3.18 
 
Average prefix length: 8.29, average data length: 0.71 
 
Clustering factor: 547059, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 74 
 
40 - 59% = 1603 
 
60 - 79% = 1108 
 
80 - 99% = 451 
 
 
XQS_1200_2000 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.21, total records: 4144335 
 
Average version length: 84.00, total versions: 56, 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: 39, data page slots: 63224 
 
Data pages: 63208, average fill: 80% 
 
Primary pages: 63208, secondary pages: 0, swept pages: 10680 
 
Empty pages: 15, full pages: 63183 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 4 
 
40 - 59% = 5 
 
60 - 79% = 10309 
 
80 - 99% = 52874 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57323, depth: 3, leaf buckets: 4220, nodes: 4144335 
 
Average node length: 5.04, total dup: 4120014, max dup: 638 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 591243, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 88 
 
40 - 59% = 2245 
 
60 - 79% = 1421 
 
80 - 99% = 463 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 78658, depth: 3, leaf buckets: 4202, nodes: 4144335 
 
Average node length: 5.55, total dup: 3790177, max dup: 49 
 
Average key length: 2.56, compression ratio: 3.51 
 
Average prefix length: 8.52, average data length: 0.48 
 
Clustering factor: 82035, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 81 
 
20 - 39% = 632 
 
40 - 59% = 1093 
 
60 - 79% = 726 
 
80 - 99% = 1670 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49624, depth: 3, leaf buckets: 4806, nodes: 4144335 
 
Average node length: 5.79, total dup: 3635675, max dup: 49 
 
Average key length: 2.80, compression ratio: 3.21 
 
Average prefix length: 8.32, average data length: 0.68 
 
Clustering factor: 672807, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 71 
 
40 - 59% = 2479 
 
60 - 79% = 1693 
 
80 - 99% = 558 
 
 
XQS_2000_3300 (268) 
 
Primary pointer page: 757, Index root page: 758 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 760, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 762, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 761, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (269) 
 
Primary pointer page: 763, Index root page: 764 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.33, total records: 3075644 
 
Average version length: 83.22, total versions: 93, 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: 30, data page slots: 47656 
 
Data pages: 47656, average fill: 79% 
 
Primary pages: 47656, secondary pages: 0, swept pages: 37439 
 
Empty pages: 7, full pages: 47224 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 13 
 
40 - 59% = 75 
 
60 - 79% = 15838 
 
80 - 99% = 31719 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 81479, depth: 3, leaf buckets: 3256, nodes: 3075644 
 
Average node length: 5.02, total dup: 3061575, max dup: 1322 
 
Average key length: 2.04, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 738646, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 276 
 
40 - 59% = 1707 
 
60 - 79% = 889 
 
80 - 99% = 378 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 88365, depth: 3, leaf buckets: 4645, nodes: 3075644 
 
Average node length: 6.19, total dup: 2531897, max dup: 14 
 
Average key length: 3.21, compression ratio: 2.80 
 
Average prefix length: 7.96, average data length: 1.04 
 
Clustering factor: 215820, ratio: 0.07 
 
Fill distribution: 
 
0 - 19% = 48 
 
20 - 39% = 1654 
 
40 - 59% = 1553 
 
60 - 79% = 779 
 
80 - 99% = 611 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 78028, depth: 3, leaf buckets: 3598, nodes: 3075644 
 
Average node length: 5.60, total dup: 2789687, max dup: 49 
 
Average key length: 2.62, compression ratio: 3.43 
 
Average prefix length: 8.47, average data length: 0.53 
 
Clustering factor: 783359, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 278 
 
40 - 59% = 1880 
 
60 - 79% = 986 
 
80 - 99% = 442 
 
 
XQS_3300_3400 (270) 
 
Primary pointer page: 776, Index root page: 777 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.51, total records: 337626 
 
Average version length: 68.49, total versions: 95, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.96 
 
Pointer pages: 3, data page slots: 4616 
 
Data pages: 4616, average fill: 78% 
 
Primary pages: 4616, secondary pages: 0, swept pages: 3769 
 
Empty pages: 3, full pages: 4604 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 4609 
 
80 - 99% = 2 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 2703, depth: 2, leaf buckets: 411, nodes: 337626 
 
Average node length: 5.39, total dup: 309556, max dup: 110 
 
Average key length: 2.63, compression ratio: 3.43 
 
Average prefix length: 8.46, average data length: 0.54 
 
Clustering factor: 39830, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 92 
 
40 - 59% = 171 
 
60 - 79% = 105 
 
80 - 99% = 42 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 2473, depth: 2, leaf buckets: 454, nodes: 337626 
 
Average node length: 5.90, total dup: 284028, max dup: 14 
 
Average key length: 3.14, compression ratio: 2.86 
 
Average prefix length: 8.02, average data length: 0.98 
 
Clustering factor: 40101, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 105 
 
40 - 59% = 179 
 
60 - 79% = 121 
 
80 - 99% = 46 
 
 
ZDOC_DATA (229) 
 
Primary pointer page: 632, Index root page: 633 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZDOC_LIST (228) 
 
Primary pointer page: 630, Index root page: 631 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (230) 
 
Primary pointer page: 634, Index root page: 635 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPDISTR (233) 
 
Primary pointer page: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPDISTR_ID (0) 
 
Root page: 650, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPSTORNED (234) 
 
Primary pointer page: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPSTORNED_ID (0) 
 
Root page: 651, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQDISTR (231) 
 
Primary pointer page: 636, Index root page: 637 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_ID (0) 
 
Root page: 644, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
 
Root page: 645, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQSTORNED (232) 
 
Primary pointer page: 638, Index root page: 639 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_DOC_ID (1) 
 
Root page: 647, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_ID (0) 
 
Root page: 646, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_RCV_ID (3) 
 
Root page: 649, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_SND_ID (2) 
 
Root page: 648, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_DEP_DOCS (227) 
 
Primary pointer page: 628, Index root page: 629 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (226) 
 
Primary pointer page: 625, Index root page: 626 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Z_USED_VIEWS (146) 
 
Primary pointer page: 267, Index root page: 268 
 
Total formats: 1, used formats: 1 
 
Average record length: 29.38, total records: 29 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 99.00, compression ratio: 3.37 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 16% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index Z_USED_VIEWS_UNQ (0) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 29 
 
Average node length: 15.17, total dup: 0, max dup: 0 
 
Average key length: 14.14, compression ratio: 1.44 
 
Average prefix length: 9.17, average data length: 11.17 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Done for 28670 ms, from  8:05:52.21 to  8:06:20.88. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 1927145  | 
 49  | 
 0.0025  | 
|  DOC_LIST  | 
 537721  | 
 2  | 
 0.0003  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 158  | 
 0  | 
 0.0000  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 35  | 
 0  | 
 0.0000  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 143415  | 
 0  | 
 0.0000  | 
|  PERF_ESTIMATED  | 
 264219  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 12040226  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 359383  | 
 15  | 
 0.0041  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 0  | 
 0.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 666  | 
 0  | 
 0.0000  | 
|  XQD_1000_3300  | 
 111969  | 
 105  | 
 0.0937  | 
|  XQD_1200_2000  | 
 3470  | 
 0  | 
 0.0000  | 
|  XQD_2000_3300  | 
 1069813  | 
 6226  | 
 0.5819  | 
|  XQD_2100_3300  | 
 5152  | 
 11  | 
 0.2135  | 
|  XQD_3300_3400  | 
 2739023  | 
 1003  | 
 0.0366  | 
|  XQS_1000_1200  | 
 3864580  | 
 79  | 
 0.0020  | 
|  XQS_1000_3300  | 
 2788845  | 
 440  | 
 0.0157  | 
|  XQS_1200_2000  | 
 4144335  | 
 56  | 
 0.0013  | 
|  XQS_2100_3300  | 
 3075644  | 
 93  | 
 0.0030  | 
|  XQS_3300_3400  | 
 337626  | 
 95  | 
 0.0281  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 1750 ms, from  8:06:30.83 to  8:06:32.58.  
08:06:32.66 Validation started 
 
 
08:06:32.67 Relation 140 (DOC_LIST) 
 
08:06:32.67   process pointer page    0 of    5 
 
08:06:32.72   process pointer page    1 of    5 
 
08:06:32.75   process pointer page    2 of    5 
 
08:06:32.85   process pointer page    3 of    5 
 
08:06:32.88   process pointer page    4 of    5 
 
08:06:32.89 Index 1 (PK_DOC_LIST) 
 
08:06:32.96 Index 2 (DOC_LIST_ID_DESC) 
 
08:06:33.03 Index 3 (FK_DOC_LIST_AGENTS) 
 
08:06:33.11 Relation 140 (DOC_LIST) is ok 
 
 
08:06:33.11 Relation 141 (DOC_DATA) 
 
08:06:33.11   process pointer page    0 of   13 
 
08:06:33.14   process pointer page    1 of   13 
 
08:06:33.17   process pointer page    2 of   13 
 
08:06:33.19   process pointer page    3 of   13 
 
08:06:33.22   process pointer page    4 of   13 
 
08:06:33.24   process pointer page    5 of   13 
 
08:06:33.27   process pointer page    6 of   13 
 
08:06:33.30   process pointer page    7 of   13 
 
08:06:33.36   process pointer page    8 of   13 
 
08:06:33.39   process pointer page    9 of   13 
 
08:06:33.42   process pointer page   10 of   13 
 
08:06:33.45   process pointer page   11 of   13 
 
08:06:33.49   process pointer page   12 of   13 
 
08:06:33.51 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
08:06:33.84 Index 3 (DOC_DATA_ID_DESC) 
 
08:06:34.06 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
08:06:34.22 Relation 141 (DOC_DATA) is ok 
 
 
08:06:34.22 Relation 147 (INVNT_SALDO) 
 
08:06:34.22   process pointer page    0 of    1 
 
08:06:34.22 Index 1 (PK_INVNT_SALDO) 
 
08:06:34.22 Relation 147 (INVNT_SALDO) is ok 
 
 
08:06:34.22 Relation 150 (PDISTR) 
 
08:06:34.22   process pointer page    0 of    1 
 
08:06:34.24 Index 2 (PDISTR_SND_ID) 
 
08:06:34.26 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
08:06:34.27 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
08:06:34.28 Index 5 (PDISTR_AGENT_ID) 
 
08:06:34.29 Relation 150 (PDISTR) is ok 
 
 
08:06:34.29 Relation 151 (PSTORNED) 
 
08:06:34.29   process pointer page    0 of    3 
 
08:06:34.32   process pointer page    1 of    3 
 
08:06:34.34   process pointer page    2 of    3 
 
08:06:34.36 Index 2 (PSTORNED_SND_ID) 
 
08:06:34.39 Index 3 (PSTORNED_RCV_ID) 
 
08:06:34.42 Relation 151 (PSTORNED) is ok 
 
 
08:06:34.42 Relation 156 (SEMAPHORES) 
 
08:06:34.42   process pointer page    0 of    1 
 
08:06:34.42 Index 1 (PK_SEMAPHORES) 
 
08:06:34.42 Index 2 (SEMAPHORES_TASK_UNQ) 
 
08:06:34.42 Relation 156 (SEMAPHORES) is ok 
 
 
08:06:34.42 Relation 157 (INVNT_TURNOVER_LOG) 
 
08:06:34.42   process pointer page    0 of    1 
 
08:06:34.42 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
08:06:34.42 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
08:06:34.42 Relation 160 (PERF_ESTIMATED) 
 
08:06:34.42   process pointer page    0 of    2 
 
08:06:34.45   process pointer page    1 of    2 
 
08:06:34.46 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
08:06:34.47 Relation 160 (PERF_ESTIMATED) is ok 
 
 
08:06:34.47 Relation 161 (PERF_ISQL_STAT) 
 
08:06:34.47   process pointer page    0 of    1 
 
08:06:34.47 Index 1 (PERF_ISQL_STAT_TRN) 
 
08:06:34.47 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
08:06:34.47 Relation 162 (PERF_LOG) 
 
08:06:34.47   process pointer page    0 of  166 
 
08:06:34.49   process pointer page    1 of  166 
 
08:06:34.52   process pointer page    2 of  166 
 
08:06:34.54   process pointer page    3 of  166 
 
08:06:34.56   process pointer page    4 of  166 
 
08:06:34.58   process pointer page    5 of  166 
 
08:06:34.61   process pointer page    6 of  166 
 
08:06:34.63   process pointer page    7 of  166 
 
08:06:34.65   process pointer page    8 of  166 
 
08:06:34.68   process pointer page    9 of  166 
 
08:06:34.70   process pointer page   10 of  166 
 
08:06:34.73   process pointer page   11 of  166 
 
08:06:34.76   process pointer page   12 of  166 
 
08:06:34.79   process pointer page   13 of  166 
 
08:06:34.82   process pointer page   14 of  166 
 
08:06:34.84   process pointer page   15 of  166 
 
08:06:34.85   process pointer page   16 of  166 
 
08:06:34.87   process pointer page   17 of  166 
 
08:06:34.90   process pointer page   18 of  166 
 
08:06:34.92   process pointer page   19 of  166 
 
08:06:34.95   process pointer page   20 of  166 
 
08:06:34.96   process pointer page   21 of  166 
 
08:06:34.99   process pointer page   22 of  166 
 
08:06:35.01   process pointer page   23 of  166 
 
08:06:35.04   process pointer page   24 of  166 
 
08:06:35.06   process pointer page   25 of  166 
 
08:06:35.07   process pointer page   26 of  166 
 
08:06:35.10   process pointer page   27 of  166 
 
08:06:35.12   process pointer page   28 of  166 
 
08:06:35.15   process pointer page   29 of  166 
 
08:06:35.17   process pointer page   30 of  166 
 
08:06:35.20   process pointer page   31 of  166 
 
08:06:35.21   process pointer page   32 of  166 
 
08:06:35.23   process pointer page   33 of  166 
 
08:06:35.26   process pointer page   34 of  166 
 
08:06:35.28   process pointer page   35 of  166 
 
08:06:35.31   process pointer page   36 of  166 
 
08:06:35.34   process pointer page   37 of  166 
 
08:06:35.37   process pointer page   38 of  166 
 
08:06:35.40   process pointer page   39 of  166 
 
08:06:35.42   process pointer page   40 of  166 
 
08:06:35.45   process pointer page   41 of  166 
 
08:06:35.51   process pointer page   42 of  166 
 
08:06:35.54   process pointer page   43 of  166 
 
08:06:35.57   process pointer page   44 of  166 
 
08:06:35.60   process pointer page   45 of  166 
 
08:06:35.62   process pointer page   46 of  166 
 
08:06:35.65   process pointer page   47 of  166 
 
08:06:35.68   process pointer page   48 of  166 
 
08:06:35.71   process pointer page   49 of  166 
 
08:06:35.73   process pointer page   50 of  166 
 
08:06:35.76   process pointer page   51 of  166 
 
08:06:35.79   process pointer page   52 of  166 
 
08:06:35.81   process pointer page   53 of  166 
 
08:06:35.84   process pointer page   54 of  166 
 
08:06:35.85   process pointer page   55 of  166 
 
08:06:35.88   process pointer page   56 of  166 
 
08:06:35.90   process pointer page   57 of  166 
 
08:06:35.91   process pointer page   58 of  166 
 
08:06:35.95   process pointer page   59 of  166 
 
08:06:35.96   process pointer page   60 of  166 
 
08:06:35.99   process pointer page   61 of  166 
 
08:06:36.01   process pointer page   62 of  166 
 
08:06:36.04   process pointer page   63 of  166 
 
08:06:36.07   process pointer page   64 of  166 
 
08:06:36.10   process pointer page   65 of  166 
 
08:06:36.12   process pointer page   66 of  166 
 
08:06:36.15   process pointer page   67 of  166 
 
08:06:36.16   process pointer page   68 of  166 
 
08:06:36.18   process pointer page   69 of  166 
 
08:06:36.21   process pointer page   70 of  166 
 
08:06:36.23   process pointer page   71 of  166 
 
08:06:36.26   process pointer page   72 of  166 
 
08:06:36.27   process pointer page   73 of  166 
 
08:06:36.30   process pointer page   74 of  166 
 
08:06:36.34   process pointer page   75 of  166 
 
08:06:36.37   process pointer page   76 of  166 
 
08:06:36.38   process pointer page   77 of  166 
 
08:06:36.41   process pointer page   78 of  166 
 
08:06:36.45   process pointer page   79 of  166 
 
08:06:36.46   process pointer page   80 of  166 
 
08:06:36.48   process pointer page   81 of  166 
 
08:06:36.51   process pointer page   82 of  166 
 
08:06:36.52   process pointer page   83 of  166 
 
08:06:36.55   process pointer page   84 of  166 
 
08:06:36.57   process pointer page   85 of  166 
 
08:06:36.60   process pointer page   86 of  166 
 
08:06:36.62   process pointer page   87 of  166 
 
08:06:36.63   process pointer page   88 of  166 
 
08:06:36.66   process pointer page   89 of  166 
 
08:06:36.68   process pointer page   90 of  166 
 
08:06:36.71   process pointer page   91 of  166 
 
08:06:36.73   process pointer page   92 of  166 
 
08:06:36.76   process pointer page   93 of  166 
 
08:06:36.77   process pointer page   94 of  166 
 
08:06:36.79   process pointer page   95 of  166 
 
08:06:36.82   process pointer page   96 of  166 
 
08:06:36.84   process pointer page   97 of  166 
 
08:06:36.87   process pointer page   98 of  166 
 
08:06:36.88   process pointer page   99 of  166 
 
08:06:36.91   process pointer page  100 of  166 
 
08:06:36.93   process pointer page  101 of  166 
 
08:06:36.94   process pointer page  102 of  166 
 
08:06:36.98   process pointer page  103 of  166 
 
08:06:36.99   process pointer page  104 of  166 
 
08:06:37.02   process pointer page  105 of  166 
 
08:06:37.04   process pointer page  106 of  166 
 
08:06:37.07   process pointer page  107 of  166 
 
08:06:37.08   process pointer page  108 of  166 
 
08:06:37.12   process pointer page  109 of  166 
 
08:06:37.13   process pointer page  110 of  166 
 
08:06:37.18   process pointer page  111 of  166 
 
08:06:37.23   process pointer page  112 of  166 
 
08:06:37.24   process pointer page  113 of  166 
 
08:06:37.27   process pointer page  114 of  166 
 
08:06:37.30   process pointer page  115 of  166 
 
08:06:37.32   process pointer page  116 of  166 
 
08:06:37.35   process pointer page  117 of  166 
 
08:06:37.37   process pointer page  118 of  166 
 
08:06:37.40   process pointer page  119 of  166 
 
08:06:37.41   process pointer page  120 of  166 
 
08:06:37.44   process pointer page  121 of  166 
 
08:06:37.47   process pointer page  122 of  166 
 
08:06:37.55   process pointer page  123 of  166 
 
08:06:37.58   process pointer page  124 of  166 
 
08:06:37.62   process pointer page  125 of  166 
 
08:06:37.65   process pointer page  126 of  166 
 
08:06:37.68   process pointer page  127 of  166 
 
08:06:37.71   process pointer page  128 of  166 
 
08:06:37.72   process pointer page  129 of  166 
 
08:06:37.76   process pointer page  130 of  166 
 
08:06:37.79   process pointer page  131 of  166 
 
08:06:37.80   process pointer page  132 of  166 
 
08:06:37.83   process pointer page  133 of  166 
 
08:06:37.85   process pointer page  134 of  166 
 
08:06:37.88   process pointer page  135 of  166 
 
08:06:37.90   process pointer page  136 of  166 
 
08:06:37.93   process pointer page  137 of  166 
 
08:06:37.94   process pointer page  138 of  166 
 
08:06:37.97   process pointer page  139 of  166 
 
08:06:37.99   process pointer page  140 of  166 
 
08:06:38.01   process pointer page  141 of  166 
 
08:06:38.04   process pointer page  142 of  166 
 
08:06:38.05   process pointer page  143 of  166 
 
08:06:38.08   process pointer page  144 of  166 
 
08:06:38.10   process pointer page  145 of  166 
 
08:06:38.13   process pointer page  146 of  166 
 
08:06:38.15   process pointer page  147 of  166 
 
08:06:38.16   process pointer page  148 of  166 
 
08:06:38.19   process pointer page  149 of  166 
 
08:06:38.21   process pointer page  150 of  166 
 
08:06:38.24   process pointer page  151 of  166 
 
08:06:38.25   process pointer page  152 of  166 
 
08:06:38.29   process pointer page  153 of  166 
 
08:06:38.30   process pointer page  154 of  166 
 
08:06:38.32   process pointer page  155 of  166 
 
08:06:38.35   process pointer page  156 of  166 
 
08:06:38.36   process pointer page  157 of  166 
 
08:06:38.40   process pointer page  158 of  166 
 
08:06:38.41   process pointer page  159 of  166 
 
08:06:38.44   process pointer page  160 of  166 
 
08:06:38.46   process pointer page  161 of  166 
 
08:06:38.47   process pointer page  162 of  166 
 
08:06:38.50   process pointer page  163 of  166 
 
08:06:38.52   process pointer page  164 of  166 
 
08:06:38.55   process pointer page  165 of  166 
 
08:06:38.55 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
08:06:39.49 Index 2 (PERF_LOG_UNIT) 
 
08:06:41.16 Index 3 (PERF_LOG_TRN_DESC) 
 
08:06:42.45 Index 4 (PERF_LOG_GDSCODE) 
 
08:06:43.43 Relation 162 (PERF_LOG) is ok 
 
 
08:06:43.43 Relation 166 (V_STOPTEST) 
 
08:06:43.43 Relation 166 (V_STOPTEST) is ok 
 
 
08:06:43.43 Relation 183 (V_QDISTR_SOURCE) 
 
08:06:43.43 Relation 183 (V_QDISTR_SOURCE) is ok 
 
 
08:06:43.43 Relation 184 (V_QSTORNED_SOURCE) 
 
08:06:43.43 Relation 184 (V_QSTORNED_SOURCE) is ok 
 
 
08:06:43.43 Relation 259 (XQD_1000_1200) 
 
08:06:43.45   process pointer page    0 of    1 
 
08:06:43.45 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
08:06:43.45 Relation 259 (XQD_1000_1200) is ok 
 
 
08:06:43.45 Relation 260 (XQD_1200_2000) 
 
08:06:43.45   process pointer page    0 of    1 
 
08:06:43.45 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
08:06:43.45 Relation 260 (XQD_1200_2000) is ok 
 
 
08:06:43.45 Relation 261 (XQD_1000_3300) 
 
08:06:43.45   process pointer page    0 of    3 
 
08:06:43.47   process pointer page    1 of    3 
 
08:06:43.48   process pointer page    2 of    3 
 
08:06:43.48 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
08:06:43.50 Index 2 (XQD_1000_3300_DOC) 
 
08:06:43.50 Relation 261 (XQD_1000_3300) is ok 
 
 
08:06:43.50 Relation 262 (XQD_2000_3300) 
 
08:06:43.50   process pointer page    0 of   10 
 
08:06:43.53   process pointer page    1 of   10 
 
08:06:43.56   process pointer page    2 of   10 
 
08:06:43.64   process pointer page    3 of   10 
 
08:06:43.68   process pointer page    4 of   10 
 
08:06:43.71   process pointer page    5 of   10 
 
08:06:43.75   process pointer page    6 of   10 
 
08:06:43.78   process pointer page    7 of   10 
 
08:06:43.81   process pointer page    8 of   10 
 
08:06:43.84   process pointer page    9 of   10 
 
08:06:43.84 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
08:06:43.95 Relation 262 (XQD_2000_3300) is ok 
 
 
08:06:43.95 Relation 263 (XQD_2100_3300) 
 
08:06:43.95   process pointer page    0 of    2 
 
08:06:43.96   process pointer page    1 of    2 
 
08:06:43.96 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
08:06:43.96 Relation 263 (XQD_2100_3300) is ok 
 
 
08:06:43.96 Relation 264 (XQD_3300_3400) 
 
08:06:43.96   process pointer page    0 of   24 
 
08:06:43.98   process pointer page    1 of   24 
 
08:06:44.01   process pointer page    2 of   24 
 
08:06:44.10   process pointer page    3 of   24 
 
08:06:44.14   process pointer page    4 of   24 
 
08:06:44.17   process pointer page    5 of   24 
 
08:06:44.20   process pointer page    6 of   24 
 
08:06:44.23   process pointer page    7 of   24 
 
08:06:44.26   process pointer page    8 of   24 
 
08:06:44.29   process pointer page    9 of   24 
 
08:06:44.32   process pointer page   10 of   24 
 
08:06:44.35   process pointer page   11 of   24 
 
08:06:44.37   process pointer page   12 of   24 
 
08:06:44.40   process pointer page   13 of   24 
 
08:06:44.43   process pointer page   14 of   24 
 
08:06:44.45   process pointer page   15 of   24 
 
08:06:44.48   process pointer page   16 of   24 
 
08:06:44.49   process pointer page   17 of   24 
 
08:06:44.53   process pointer page   18 of   24 
 
08:06:44.54   process pointer page   19 of   24 
 
08:06:44.57   process pointer page   20 of   24 
 
08:06:44.60   process pointer page   21 of   24 
 
08:06:44.64   process pointer page   22 of   24 
 
08:06:44.67   process pointer page   23 of   24 
 
08:06:44.67 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
08:06:45.20 Relation 264 (XQD_3300_3400) is ok 
 
 
08:06:45.20 Relation 265 (XQS_1000_1200) 
 
08:06:45.20   process pointer page    0 of   37 
 
08:06:45.23   process pointer page    1 of   37 
 
08:06:45.26   process pointer page    2 of   37 
 
08:06:45.29   process pointer page    3 of   37 
 
08:06:45.32   process pointer page    4 of   37 
 
08:06:45.35   process pointer page    5 of   37 
 
08:06:45.38   process pointer page    6 of   37 
 
08:06:45.40   process pointer page    7 of   37 
 
08:06:45.43   process pointer page    8 of   37 
 
08:06:45.45   process pointer page    9 of   37 
 
08:06:45.48   process pointer page   10 of   37 
 
08:06:45.49   process pointer page   11 of   37 
 
08:06:45.52   process pointer page   12 of   37 
 
08:06:45.54   process pointer page   13 of   37 
 
08:06:45.57   process pointer page   14 of   37 
 
08:06:45.60   process pointer page   15 of   37 
 
08:06:45.62   process pointer page   16 of   37 
 
08:06:45.65   process pointer page   17 of   37 
 
08:06:45.66   process pointer page   18 of   37 
 
08:06:45.70   process pointer page   19 of   37 
 
08:06:45.73   process pointer page   20 of   37 
 
08:06:45.77   process pointer page   21 of   37 
 
08:06:45.82   process pointer page   22 of   37 
 
08:06:45.85   process pointer page   23 of   37 
 
08:06:45.88   process pointer page   24 of   37 
 
08:06:45.91   process pointer page   25 of   37 
 
08:06:45.95   process pointer page   26 of   37 
 
08:06:45.98   process pointer page   27 of   37 
 
08:06:46.02   process pointer page   28 of   37 
 
08:06:46.10   process pointer page   29 of   37 
 
08:06:46.13   process pointer page   30 of   37 
 
08:06:46.18   process pointer page   31 of   37 
 
08:06:46.23   process pointer page   32 of   37 
 
08:06:46.26   process pointer page   33 of   37 
 
08:06:46.29   process pointer page   34 of   37 
 
08:06:46.32   process pointer page   35 of   37 
 
08:06:46.35   process pointer page   36 of   37 
 
08:06:46.37 Index 1 (XQS_1000_1200_DOC_ID) 
 
08:06:46.68 Index 2 (XQS_1000_1200_SND_ID) 
 
08:06:46.99 Index 3 (XQS_1000_1200_RCV_ID) 
 
08:06:47.27 Relation 265 (XQS_1000_1200) is ok 
 
 
08:06:47.27 Relation 266 (XQS_1200_2000) 
 
08:06:47.27   process pointer page    0 of   39 
 
08:06:47.29   process pointer page    1 of   39 
 
08:06:47.32   process pointer page    2 of   39 
 
08:06:47.33   process pointer page    3 of   39 
 
08:06:47.37   process pointer page    4 of   39 
 
08:06:47.40   process pointer page    5 of   39 
 
08:06:47.41   process pointer page    6 of   39 
 
08:06:47.44   process pointer page    7 of   39 
 
08:06:47.47   process pointer page    8 of   39 
 
08:06:47.51   process pointer page    9 of   39 
 
08:06:47.54   process pointer page   10 of   39 
 
08:06:47.57   process pointer page   11 of   39 
 
08:06:47.58   process pointer page   12 of   39 
 
08:06:47.66   process pointer page   13 of   39 
 
08:06:47.72   process pointer page   14 of   39 
 
08:06:47.76   process pointer page   15 of   39 
 
08:06:47.79   process pointer page   16 of   39 
 
08:06:47.82   process pointer page   17 of   39 
 
08:06:47.85   process pointer page   18 of   39 
 
08:06:47.88   process pointer page   19 of   39 
 
08:06:47.91   process pointer page   20 of   39 
 
08:06:47.94   process pointer page   21 of   39 
 
08:06:47.97   process pointer page   22 of   39 
 
08:06:48.00   process pointer page   23 of   39 
 
08:06:48.02   process pointer page   24 of   39 
 
08:06:48.05   process pointer page   25 of   39 
 
08:06:48.07   process pointer page   26 of   39 
 
08:06:48.10   process pointer page   27 of   39 
 
08:06:48.11   process pointer page   28 of   39 
 
08:06:48.15   process pointer page   29 of   39 
 
08:06:48.16   process pointer page   30 of   39 
 
08:06:48.19   process pointer page   31 of   39 
 
08:06:48.22   process pointer page   32 of   39 
 
08:06:48.24   process pointer page   33 of   39 
 
08:06:48.27   process pointer page   34 of   39 
 
08:06:48.29   process pointer page   35 of   39 
 
08:06:48.32   process pointer page   36 of   39 
 
08:06:48.33   process pointer page   37 of   39 
 
08:06:48.36   process pointer page   38 of   39 
 
08:06:48.38 Index 1 (XQS_1200_2000_DOC_ID) 
 
08:06:48.80 Index 2 (XQS_1200_2000_SND_ID) 
 
08:06:49.53 Index 3 (XQS_1200_2000_RCV_ID) 
 
08:06:49.95 Relation 266 (XQS_1200_2000) is ok 
 
 
08:06:49.95 Relation 267 (XQS_1000_3300) 
 
08:06:49.95   process pointer page    0 of   27 
 
08:06:49.99   process pointer page    1 of   27 
 
08:06:50.05   process pointer page    2 of   27 
 
08:06:50.13   process pointer page    3 of   27 
 
08:06:50.17   process pointer page    4 of   27 
 
08:06:50.20   process pointer page    5 of   27 
 
08:06:50.24   process pointer page    6 of   27 
 
08:06:50.27   process pointer page    7 of   27 
 
08:06:50.30   process pointer page    8 of   27 
 
08:06:50.33   process pointer page    9 of   27 
 
08:06:50.36   process pointer page   10 of   27 
 
08:06:50.39   process pointer page   11 of   27 
 
08:06:50.42   process pointer page   12 of   27 
 
08:06:50.44   process pointer page   13 of   27 
 
08:06:50.47   process pointer page   14 of   27 
 
08:06:50.49   process pointer page   15 of   27 
 
08:06:50.52   process pointer page   16 of   27 
 
08:06:50.53   process pointer page   17 of   27 
 
08:06:50.56   process pointer page   18 of   27 
 
08:06:50.58   process pointer page   19 of   27 
 
08:06:50.61   process pointer page   20 of   27 
 
08:06:50.63   process pointer page   21 of   27 
 
08:06:50.66   process pointer page   22 of   27 
 
08:06:50.67   process pointer page   23 of   27 
 
08:06:50.70   process pointer page   24 of   27 
 
08:06:50.72   process pointer page   25 of   27 
 
08:06:50.75   process pointer page   26 of   27 
 
08:06:50.77 Index 1 (XQS_1000_3300_DOC_ID) 
 
08:06:51.02 Index 2 (XQS_1000_3300_SND_ID) 
 
08:06:51.30 Index 3 (XQS_1000_3300_RCV_ID) 
 
08:06:51.53 Relation 267 (XQS_1000_3300) is ok 
 
 
08:06:51.53 Relation 268 (XQS_2000_3300) 
 
08:06:51.53   process pointer page    0 of    1 
 
08:06:51.53 Index 1 (XQS_2000_3300_DOC_ID) 
 
08:06:51.53 Index 2 (XQS_2000_3300_SND_ID) 
 
08:06:51.53 Index 3 (XQS_2000_3300_RCV_ID) 
 
08:06:51.53 Relation 268 (XQS_2000_3300) is ok 
 
 
08:06:51.53 Relation 269 (XQS_2100_3300) 
 
08:06:51.53   process pointer page    0 of   30 
 
08:06:51.56   process pointer page    1 of   30 
 
08:06:51.58   process pointer page    2 of   30 
 
08:06:51.61   process pointer page    3 of   30 
 
08:06:51.64   process pointer page    4 of   30 
 
08:06:51.66   process pointer page    5 of   30 
 
08:06:51.69   process pointer page    6 of   30 
 
08:06:51.70   process pointer page    7 of   30 
 
08:06:51.73   process pointer page    8 of   30 
 
08:06:51.75   process pointer page    9 of   30 
 
08:06:51.78   process pointer page   10 of   30 
 
08:06:51.81   process pointer page   11 of   30 
 
08:06:51.83   process pointer page   12 of   30 
 
08:06:51.86   process pointer page   13 of   30 
 
08:06:51.87   process pointer page   14 of   30 
 
08:06:51.90   process pointer page   15 of   30 
 
08:06:51.92   process pointer page   16 of   30 
 
08:06:51.95   process pointer page   17 of   30 
 
08:06:51.97   process pointer page   18 of   30 
 
08:06:52.00   process pointer page   19 of   30 
 
08:06:52.03   process pointer page   20 of   30 
 
08:06:52.05   process pointer page   21 of   30 
 
08:06:52.08   process pointer page   22 of   30 
 
08:06:52.09   process pointer page   23 of   30 
 
08:06:52.12   process pointer page   24 of   30 
 
08:06:52.14   process pointer page   25 of   30 
 
08:06:52.17   process pointer page   26 of   30 
 
08:06:52.20   process pointer page   27 of   30 
 
08:06:52.23   process pointer page   28 of   30 
 
08:06:52.26   process pointer page   29 of   30 
 
08:06:52.26 Index 1 (XQS_2100_3300_DOC_ID) 
 
08:06:52.59 Index 2 (XQS_2100_3300_SND_ID) 
 
08:06:52.97 Index 3 (XQS_2100_3300_RCV_ID) 
 
08:06:53.28 Relation 269 (XQS_2100_3300) is ok 
 
 
08:06:53.28 Relation 270 (XQS_3300_3400) 
 
08:06:53.28   process pointer page    0 of    3 
 
08:06:53.32   process pointer page    1 of    3 
 
08:06:53.36   process pointer page    2 of    3 
 
08:06:53.39 Index 1 (XQS_3300_3400_DOC_ID) 
 
08:06:53.42 Index 2 (XQS_3300_3400_SND_ID) 
 
08:06:53.46 Relation 270 (XQS_3300_3400) is ok 
 
 
08:06:53.46 Validation finished 
 
Done for 20860 ms, from  8:06:32.60 to  8:06:53.46. 
 
 Differences between old and current firebird.log 
8:06:54.40. 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:
 
2015-12-15  08:06               524 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 Dec 15 08:06:32 2015
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
8:          Validation started
 
9:  
 
10:  
 
11:  WIN-2BE1UI8LGDL Tue Dec 15 08:06:53 2015
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed
 
14:  
 
*****
 
+++ end of comparison +++ 
 
Remove 14 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. 
 
2015-12-15  8:06:58.21 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html