Tests

FINISH_STATE	DTS_END	FB_GDSCODE	FB_MNEMONA	STACK	IP	TRN_ID	ATT_ID	EXC_UNIT
NORMAL: TEST_TIME EXPIRED.	2017-05-01 11:18:09.1520	-1	<null>		::1/55731	450287	9240	2

Current test settings

CATEGORY	SETTING	VAL
COMMON	TRACED_UNITS	,,
COMMON	ENABLE_MON_QUERY	0
COMMON	HALT_TEST_ON_ERRORS	,CK,
COMMON	QMISM_VERIFY_BITSET	1
COMMON	RECALC_IDX_MIN_INTERVAL	15
COMMON	ENABLE_RESERVES_WHEN_ADD_INVOICE	1
COMMON	ORDER_FOR_OUR_FIRM_PERCENT	25
COMMON	ENABLE_FILL_PHRASES	0
COMMON	RANDOM_SEEK_VIA_ROWS_LIMIT	0
COMMON	C_INVOICE_MIN_PURCHASE	1000
COMMON	C_INVOICE_MAX_PURCHASE	2000
COMMON	C_INVOICE_MIN_PROFIT_PRC	35
COMMON	C_INVOICE_MAX_PROFIT_PRC	80
COMMON	C_MIN_COST_TO_BE_SPLITTED	1000
COMMON	C_ROWS_TO_MULTIPLY	10
COMMON	C_PAYMENT_FROM_CLIENT_MIN_TOTAL	1000
COMMON	C_PAYMENT_FROM_CLIENT_MAX_TOTAL	5000
COMMON	C_PAYMENT_TO_SUPPLIER_MIN_TOTAL	2000
COMMON	C_PAYMENT_TO_SUPPLIER_MAX_TOTAL	15000
COMMON	BUILD_WITH_SPLIT_HEAVY_TABS	1
COMMON	BUILD_WITH_SEPAR_QDISTR_IDX	0
COMMON	BUILD_WITH_QD_COMPOUND_ORDR	MOST_SELECTIVE_FIRST
SMALL_03	C_WARES_MAX_ID	400
SMALL_03	C_CUSTOMER_DOC_MAX_ROWS	10
SMALL_03	C_SUPPLIER_DOC_MAX_ROWS	50
SMALL_03	C_CUSTOMER_DOC_MAX_QTY	15
SMALL_03	C_SUPPLIER_DOC_MAX_QTY	50
SMALL_03	C_NUMBER_OF_AGENTS	50

Index(es) for heavy-loaded table(s)

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

Performance in TOTAL:

ACTION	AVG_TIMES_PER_MINUTE	AVG_ELAPSED_MS	SUCCESSFUL_TIMES_DONE	JOB_BEG	JOB_END
* OVERALL * for 180 minutes:	6343.29	3128	1141793	2017-05-01 08:18	2017-05-01 11:18
customer order: creation	478.75	467	86175	2017-05-01 08:18	2017-05-01 11:18
customer order: refuse	38.31	246	6896	2017-05-01 08:18	2017-05-01 11:18
order to supplier: creation	121.18	1974	21812	2017-05-01 08:18	2017-05-01 11:18
order to supplier: removal	3.03	19969	546	2017-05-01 08:18	2017-05-01 11:18
invoice (draft): creation	123.28	2867	22191	2017-05-01 08:18	2017-05-01 11:18
invoice (draft): removal	43.57	438	7843	2017-05-01 08:18	2017-05-01 11:18
invoice accept: apply	67.64	10530	12176	2017-05-01 08:18	2017-05-01 11:18
invoice accept: cancel	20.11	2640	3620	2017-05-01 08:18	2017-05-01 11:18
customer reserve: creation	3596.43	163	647357	2017-05-01 08:18	2017-05-01 11:18
customer reserve: removal	1192.93	60	214728	2017-05-01 08:18	2017-05-01 11:18
realization accept: apply	223.57	469	40242	2017-05-01 08:18	2017-05-01 11:18
realization accept: cancel	91.34	146	16350	2017-05-01 08:18	2017-05-01 11:18
payment from customer: creation	159.12	843	28642	2017-05-01 08:18	2017-05-01 11:18
payment from customer: removal	15.16	135	2729	2017-05-01 08:18	2017-05-01 11:18
payment to supplier: creation	132.71	430	23887	2017-05-01 08:18	2017-05-01 11:18
payment to supplier: removal	8.98	138	1617	2017-05-01 08:18	2017-05-01 11:18
service: total inventory turnovers	9.35	2955	1683	2017-05-01 08:18	2017-05-01 11:18
service: total monetary turnovers	18.26	67	3287	2017-05-01 08:18	2017-05-01 11:18
service: refresh index statistics	0.07	14891	12	2017-05-01 08:18	2017-05-01 11:18

Done for 131220 ms, from 11:25:52.24 to 11:28:03.46.

Performance in DYNAMIC:

ACTION	ITRV_NO	CNT_OK_PER_MINUTE	CNT_ALL	CNT_OK	CNT_ERR	ERR_PRC	ITRV_BEG	ITRV_END
interval # 1, overall	1	5616	114913	101087	13826	12.03	08:18:09	08:36:09
interval # 2, overall	2	7050	151017	126892	24125	15.98	08:36:10	08:54:10
interval # 3, overall	3	6875	139089	123745	15344	11.03	08:54:11	09:12:11
interval # 4, overall	4	6561	134244	118100	16144	12.03	09:12:12	09:30:12
interval # 5, overall	5	6021	128373	108374	19999	15.58	09:30:13	09:48:13
interval # 6, overall	6	6172	126940	111088	15852	12.49	09:48:14	10:06:14
interval # 7, overall	7	6304	132125	113471	18654	14.12	10:06:15	10:24:15
interval # 8, overall	8	6459	126420	116253	10167	8.04	10:24:16	10:42:16
interval # 9, overall	9	6411	126571	115406	11165	8.82	10:42:17	11:00:17
interval # 10, overall	10	5965	123407	107377	16030	12.99	11:00:18	11:18:18

Done for 261040 ms, from 11:32:28.73 to 11:36:49.77.

Performance for every MINUTE:

TEST_PHASE	MINUTE_SINCE_TEST_START	AVG_ESTIMATED	MIN_TO_AVG_RATIO	MAX_TO_AVG_RATIO	ROWS_AGGREGATED	DISTINCT_ATTACHMENTS
TEST_TIME	1	4896.05	0.5332	1.4681	2030	100
TEST_TIME	2	4802.49	0.7484	1.1706	1625	100
TEST_TIME	3	4386.97	0.8544	1.1523	1637	100
TEST_TIME	4	4394.29	0.8628	1.1103	1744	100
TEST_TIME	5	4377.12	0.8918	1.1027	1667	100
TEST_TIME	6	4516.93	0.8905	1.0999	2034	100
TEST_TIME	7	4658.17	0.9142	1.0923	2254	100
TEST_TIME	8	4846.34	0.9188	1.1005	2015	100
TEST_TIME	9	4983.21	0.9515	1.0604	1948	100
TEST_TIME	10	5091.07	0.9341	1.0582	1549	100
TEST_TIME	11	5194.01	0.9429	1.0500	1729	100
TEST_TIME	12	5268.95	0.9489	1.0512	1491	100
TEST_TIME	13	5378.03	0.9508	1.0418	1605	100
TEST_TIME	14	5412.38	0.9613	1.0386	1418	100
TEST_TIME	15	5515.39	0.9513	1.0523	1946	100
TEST_TIME	16	5604.72	0.9708	1.0389	1821	100
TEST_TIME	17	5695.11	0.9622	1.0274	1873	100
TEST_TIME	18	5717.56	0.9665	1.0263	2006	96
TEST_TIME	19	5777.30	0.9622	1.0256	1543	99
TEST_TIME	20	5785.85	0.9729	1.0359	1805	100
TEST_TIME	21	5883.71	0.9702	1.0333	1868	100
TEST_TIME	22	5952.14	0.9750	1.0233	1801	100
TEST_TIME	23	5979.65	0.9746	1.0256	1775	100
TEST_TIME	24	6031.93	0.9744	1.0240	1799	100
TEST_TIME	25	6072.71	0.9765	1.0212	1609	100
TEST_TIME	26	6059.51	0.9840	1.0106	1795	100
TEST_TIME	27	6023.45	0.9790	1.0220	1357	100
TEST_TIME	28	6050.09	0.9811	1.0193	1390	100
TEST_TIME	29	6072.32	0.9805	1.0205	1370	100
TEST_TIME	30	6120.91	0.9787	1.0238	2221	100
TEST_TIME	31	6204.10	0.9775	1.0231	2387	100
TEST_TIME	32	6281.55	0.9790	1.0139	2175	100
TEST_TIME	33	6338.88	0.9742	1.0167	1630	98
TEST_TIME	34	6377.59	0.9808	1.0174	1585	100
TEST_TIME	35	6378.09	0.9882	1.0084	1785	100
TEST_TIME	36	6395.29	0.9827	1.0129	1631	100
TEST_TIME	37	6385.95	0.9870	1.0149	1831	100
TEST_TIME	38	6401.14	0.9859	1.0154	1559	100
TEST_TIME	39	6431.50	0.9847	1.0170	1597	100
TEST_TIME	40	6474.08	0.9851	1.0208	1442	100
TEST_TIME	41	6508.74	0.9906	1.0055	1480	100
TEST_TIME	42	6467.43	0.9895	1.0112	1604	99
TEST_TIME	43	6427.83	0.9938	1.0144	1379	100
TEST_TIME	44	6432.36	0.9907	1.0112	1204	100
TEST_TIME	45	6480.27	0.9814	1.0143	2126	100
TEST_TIME	46	6487.06	0.9912	1.0122	2382	99
TEST_TIME	47	6476.54	0.9922	1.0180	1699	99
TEST_TIME	48	6533.07	0.9881	1.0129	1918	100
TEST_TIME	49	6562.24	0.9878	1.0091	1938	100
TEST_TIME	50	6551.79	0.9905	1.0085	1972	89
TEST_TIME	51	6559.12	0.9876	1.0083	1443	86
TEST_TIME	52	6532.95	0.9929	1.0080	1484	96
TEST_TIME	53	6499.61	0.9941	1.0067	1627	93
TEST_TIME	54	6531.37	0.9833	1.0110	1287	100
TEST_TIME	55	6537.29	0.9919	1.0095	1607	100
TEST_TIME	56	6542.83	0.9906	1.0079	1536	100
TEST_TIME	57	6579.25	0.9852	1.0111	1307	100
TEST_TIME	58	6583.35	0.9930	1.0081	1557	100
TEST_TIME	59	6576.69	0.9920	1.0119	1402	100
TEST_TIME	60	6616.27	0.9891	1.0092	2233	100
TEST_TIME	61	6632.44	0.9903	1.0052	2126	100
TEST_TIME	62	6611.60	0.9921	1.0099	1947	97
TEST_TIME	63	6615.93	0.9932	1.0117	1969	96
TEST_TIME	64	6640.15	0.9923	1.0079	1612	100
TEST_TIME	65	6657.42	0.9898	1.0078	1812	100
TEST_TIME	66	6653.64	0.9931	1.0067	1708	100
TEST_TIME	67	6625.20	0.9959	1.0056	1678	97
TEST_TIME	68	6632.84	0.9902	1.0077	1355	100
TEST_TIME	69	6610.95	0.9964	1.0059	1343	94
TEST_TIME	70	6567.98	0.9980	1.0029	1117	92
TEST_TIME	71	6555.42	0.9926	1.0037	1147	100
TEST_TIME	72	6509.84	0.9967	1.0023	1178	97
TEST_TIME	73	6456.09	0.9968	1.0033	1102	92
TEST_TIME	74	6457.02	0.9976	1.0020	938	100
TEST_TIME	75	6410.79	0.9958	1.0050	892	100
TEST_TIME	76	6410.35	0.9918	1.0073	2035	100
TEST_TIME	77	6422.90	0.9923	1.0053	2101	100
TEST_TIME	78	6425.95	0.9919	1.0075	1766	100
TEST_TIME	79	6442.49	0.9922	1.0073	1788	100
TEST_TIME	80	6467.02	0.9910	1.0093	1721	100
TEST_TIME	81	6477.38	0.9952	1.0065	1790	100
TEST_TIME	82	6496.48	0.9913	1.0062	1655	100
TEST_TIME	83	6502.93	0.9932	1.0062	1536	100
TEST_TIME	84	6511.69	0.9933	1.0068	1451	100
TEST_TIME	85	6517.98	0.9940	1.0041	1428	100
TEST_TIME	86	6481.27	0.9981	1.0030	1314	92
TEST_TIME	87	6478.54	0.9947	1.0018	1409	100
TEST_TIME	88	6456.03	0.9939	1.0039	1178	100
TEST_TIME	89	6437.72	0.9957	1.0031	1355	100
TEST_TIME	90	6448.67	0.9903	1.0076	1588	100
TEST_TIME	91	6467.02	0.9937	1.0067	2351	100
TEST_TIME	92	6495.97	0.9913	1.0060	1948	100
TEST_TIME	93	6485.14	0.9968	1.0040	1987	98
TEST_TIME	94	6483.59	0.9935	1.0046	1582	96
TEST_TIME	95	6487.82	0.9934	1.0041	1643	100
TEST_TIME	96	6476.67	0.9953	1.0027	1723	97
TEST_TIME	97	6451.19	0.9963	1.0046	1602	87
TEST_TIME	98	6452.88	0.9941	1.0055	1611	96
TEST_TIME	99	6451.31	0.9955	1.0034	1549	97
TEST_TIME	100	6432.16	0.9964	1.0062	1372	100
TEST_TIME	101	6431.98	0.9964	1.0048	1429	100
TEST_TIME	102	6420.79	0.9966	1.0030	1643	97
TEST_TIME	103	6410.40	0.9949	1.0043	1388	99
TEST_TIME	104	6390.97	0.9976	1.0018	1433	100
TEST_TIME	105	6378.23	0.9942	1.0048	1946	98
TEST_TIME	106	6383.55	0.9946	1.0037	1833	93
TEST_TIME	107	6398.06	0.9921	1.0051	1658	99
TEST_TIME	108	6387.87	0.9974	1.0035	1805	96
TEST_TIME	109	6400.61	0.9923	1.0042	1530	99
TEST_TIME	110	6399.99	0.9952	1.0047	1459	97
TEST_TIME	111	6404.83	0.9949	1.0044	1539	100
TEST_TIME	112	6406.82	0.9952	1.0083	1475	100
TEST_TIME	113	6414.25	0.9983	1.0026	1477	98
TEST_TIME	114	6401.36	0.9958	1.0036	1414	99
TEST_TIME	115	6401.95	0.9948	1.0055	1335	100
TEST_TIME	116	6406.13	0.9963	1.0040	1304	100
TEST_TIME	117	6414.06	0.9947	1.0040	1215	100
TEST_TIME	118	6402.43	0.9973	1.0019	1416	99
TEST_TIME	119	6387.77	0.9958	1.0048	1249	100
TEST_TIME	120	6393.42	0.9955	1.0060	1449	100
TEST_TIME	121	6409.23	0.9953	1.0050	1710	100
TEST_TIME	122	6416.09	0.9957	1.0046	1737	100
TEST_TIME	123	6401.84	0.9987	1.0016	1397	88
TEST_TIME	124	6375.24	0.9977	1.0028	1197	75
TEST_TIME	125	6377.99	0.9944	1.0032	1320	95
TEST_TIME	126	6375.01	0.9979	1.0029	1500	98
TEST_TIME	127	6385.67	0.9945	1.0027	1455	97
TEST_TIME	128	6382.91	0.9953	1.0044	1411	97
TEST_TIME	129	6381.10	0.9969	1.0032	1505	99
TEST_TIME	130	6374.84	0.9965	1.0028	1511	96
TEST_TIME	131	6369.06	0.9960	1.0025	1499	92
TEST_TIME	132	6363.59	0.9958	1.0029	1430	95
TEST_TIME	133	6354.58	0.9967	1.0039	1388	92
TEST_TIME	134	6343.58	0.9981	1.0022	1375	98
TEST_TIME	135	6332.57	0.9965	1.0034	1367	97
TEST_TIME	136	6346.44	0.9938	1.0036	2237	95
TEST_TIME	137	6355.33	0.9949	1.0037	1844	94
TEST_TIME	138	6366.89	0.9946	1.0039	1622	97
TEST_TIME	139	6372.27	0.9958	1.0041	1723	94
TEST_TIME	140	6374.11	0.9966	1.0036	1576	91
TEST_TIME	141	6372.79	0.9967	1.0062	1568	96
TEST_TIME	142	6385.78	0.9971	1.0017	1635	96
TEST_TIME	143	6380.63	0.9977	1.0026	1609	94
TEST_TIME	144	6379.97	0.9957	1.0045	1427	91
TEST_TIME	145	6380.76	0.9974	1.0038	1398	95
TEST_TIME	146	6373.31	0.9981	1.0020	1506	86
TEST_TIME	147	6358.69	0.9974	1.0024	1233	84
TEST_TIME	148	6353.76	0.9964	1.0036	1246	88
TEST_TIME	149	6346.15	0.9981	1.0015	1177	91
TEST_TIME	150	6341.79	0.9955	1.0039	1613	86
TEST_TIME	151	6344.12	0.9975	1.0031	2123	93
TEST_TIME	152	6347.68	0.9959	1.0038	2006	87
TEST_TIME	153	6364.88	0.9945	1.0043	1566	91
TEST_TIME	154	6368.99	0.9972	1.0035	1437	93
TEST_TIME	155	6376.56	0.9966	1.0023	1677	96
TEST_TIME	156	6366.32	0.9974	1.0035	1716	90
TEST_TIME	157	6381.91	0.9947	1.0050	1402	93
TEST_TIME	158	6386.42	0.9979	1.0036	1338	88
TEST_TIME	159	6384.39	0.9976	1.0031	1514	88
TEST_TIME	160	6380.66	0.9974	1.0047	1237	91
TEST_TIME	161	6389.34	0.9976	1.0014	1372	92
TEST_TIME	162	6372.47	0.9979	1.0024	1365	89
TEST_TIME	163	6373.82	0.9960	1.0036	1300	88
TEST_TIME	164	6374.07	0.9975	1.0014	1200	88
TEST_TIME	165	6372.83	0.9956	1.0022	1538	91
TEST_TIME	166	6379.34	0.9952	1.0039	1762	91
TEST_TIME	167	6373.36	0.9988	1.0033	1339	82
TEST_TIME	168	6381.27	0.9969	1.0024	1492	84
TEST_TIME	169	6386.33	0.9958	1.0041	1455	76
TEST_TIME	170	6393.30	0.9971	1.0019	1353	92
TEST_TIME	171	6392.84	0.9961	1.0029	1360	88
TEST_TIME	172	6386.56	0.9980	1.0023	1658	90
TEST_TIME	173	6388.22	0.9962	1.0025	1565	88
TEST_TIME	174	6388.33	0.9967	1.0026	1423	87
TEST_TIME	175	6384.20	0.9975	1.0034	1351	88
TEST_TIME	176	6380.96	0.9983	1.0020	1296	86
TEST_TIME	177	6369.01	0.9982	1.0016	1357	89
TEST_TIME	178	6366.22	0.9964	1.0045	900	94
TEST_TIME	179	6364.68	0.9991	1.0010	1210	92
TEST_TIME	180	6339.73	0.9994	1.0005	275	89

Done for 11100 ms, from 11:36:51.66 to 11:37:02.76.

Performance from TRACE for ISQL instance #1:

TRACED_DATA	ITRV_NO	SP_CLIENT_ORDER	SP_CANCEL_CLIENT_ORDER	SP_SUPPLIER_ORDER	SP_CANCEL_SUPPLIER_ORDER	SP_SUPPLIER_INVOICE	SP_CANCEL_SUPPLIER_INVOICE	SP_ADD_INVOICE_TO_STOCK	SP_CANCEL_ADDING_INVOICE	SP_CUSTOMER_RESERVE	SP_CANCEL_CUSTOMER_RESERVE	SP_RESERVE_WRITE_OFF	SP_CANCEL_WRITE_OFF	SP_PAY_FROM_CUSTOMER	SP_CANCEL_PAY_FROM_CUSTOMER	SP_PAY_TO_SUPPLIER	SP_CANCEL_PAY_TO_SUPPLIER	SRV_MAKE_INVNT_SALDO	SRV_MAKE_MONEY_SALDO	SRV_RECALC_IDX_STAT	ITRV_BEG	ITRV_END
fetches per second	1	71390	66226	65742	118308	73604	4357	90257	72167	42461	104105	76424	94542	112743	93494	132913	<null>	121378	297133	<null>	08:18:09	08:36:09
fetches per second	2	51308	101034	56168	<null>	43160	<null>	64617	111965	68933	<null>	55524	58878	67756	62705	58558	<null>	145670	305458	<null>	08:36:10	08:54:10
fetches per second	3	30231	60605	17998	<null>	29845	2544	37349	<null>	56551	40655	31648	61146	40662	82069	88466	<null>	33749	17874	<null>	08:54:11	09:12:11
fetches per second	4	42630	66456	41495	<null>	30011	<null>	30836	67973	68933	43108	48815	33769	47176	60373	58413	22857	561244	9976	<null>	09:12:12	09:30:12
fetches per second	5	33851	92867	36106	84529	42908	6037	51637	<null>	14697	5054	45903	9772	41561	18454	63293	119428	292120	91442	<null>	09:30:13	09:48:13
fetches per second	6	15572	36231	15286	5190	19362	122550	28854	5273	11770	118071	14591	11133	44806	66719	33560	3747	56805	59717	<null>	09:48:14	10:06:14
fetches per second	7	16892	16919	12656	14325	11964	105571	18611	<null>	46013	50315	25653	3192	12957	30894	27582	11278	294821	152797	<null>	10:06:15	10:24:15
fetches per second	8	3983	10881	4613	<null>	8645	4954	14857	8041	3118	4279	5676	4729	7344	2741	11700	2620	29286	152625	<null>	10:24:16	10:42:16
fetches per second	9	3623	6491	9225	<null>	6013	<null>	14608	24099	4539	29560	6234	4234	6385	12323	4269	5071	38390	31075	<null>	10:42:17	11:00:17
fetches per second	10	4660	3322	3767	<null>	6330	3119	6054	10012	<null>	<null>	12832	2713	12463	<null>	2828	<null>	<null>	<null>	<null>	11:00:18	11:18:18
marks per second	1	15904	9012	14768	25938	16509	868	14464	15015	5898	22113	14358	16401	11104	18288	7645	<null>	15417	27350	<null>	08:18:09	08:36:09
marks per second	2	11432	13783	12263	<null>	9703	<null>	9864	22723	8368	<null>	9115	9294	5560	10929	5562	<null>	7704	20172	<null>	08:36:10	08:54:10
marks per second	3	6282	8235	3951	<null>	6476	515	5201	<null>	7746	7014	5601	11749	3038	16866	9135	<null>	1972	319	<null>	08:54:11	09:12:11
marks per second	4	9184	8973	8941	<null>	6595	<null>	4313	11378	7415	7261	7663	5589	4586	10396	5033	4714	28507	190	<null>	09:12:12	09:30:12
marks per second	5	7163	13420	7711	14704	9317	1454	7005	<null>	1948	1042	3705	1984	2980	3227	8023	21285	79475	10566	<null>	09:30:13	09:48:13
marks per second	6	3246	5217	2889	1235	3661	29875	3787	892	1539	21428	2646	1960	2054	9345	6143	809	1856	1955	<null>	09:48:14	10:06:14
marks per second	7	3507	2482	2389	3130	2530	21857	2787	<null>	5465	9131	3734	493	727	3047	4034	2237	14683	5366	<null>	10:06:15	10:24:15
marks per second	8	874	1338	707	<null>	1441	1136	2141	1515	392	758	766	770	347	577	1653	382	506	1093	<null>	10:24:16	10:42:16
marks per second	9	776	867	1609	<null>	1079	<null>	2054	3941	415	5948	1170	670	226	2236	561	857	2397	1713	<null>	10:42:17	11:00:17
marks per second	10	985	486	669	<null>	845	747	709	1611	<null>	<null>	725	519	350	<null>	478	<null>	<null>	<null>	<null>	11:00:18	11:18:18
reads/fetches*100	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	0	0	<null>	08:18:09	08:36:09
reads/fetches*100	2	0	0	0	<null>	0	<null>	0	0	0	<null>	0	0	0	0	0	<null>	0	0	<null>	08:36:10	08:54:10
reads/fetches*100	3	0	0	0	<null>	0	0	0	<null>	0	0	0	0	0	0	0	<null>	0	0	<null>	08:54:11	09:12:11
reads/fetches*100	4	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	<null>	09:12:12	09:30:12
reads/fetches*100	5	0	0	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	09:30:13	09:48:13
reads/fetches*100	6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	09:48:14	10:06:14
reads/fetches*100	7	0	0	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	10:06:15	10:24:15
reads/fetches*100	8	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	0	0	<null>	10:24:16	10:42:16
reads/fetches*100	9	0	0	0	<null>	0	<null>	0	0	0	0	0	0	0	0	0	0	0	0	<null>	10:42:17	11:00:17
reads/fetches*100	10	0	0	0	<null>	0	0	0	0	<null>	<null>	0	0	0	<null>	0	<null>	<null>	<null>	<null>	11:00:18	11:18:18
writes/marks*100	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	<null>	3	0	<null>	08:18:09	08:36:09
writes/marks*100	2	0	1	0	<null>	0	<null>	0	0	1	<null>	0	0	0	0	0	<null>	1	0	<null>	08:36:10	08:54:10
writes/marks*100	3	0	0	0	<null>	0	0	0	<null>	0	2	0	1	0	0	0	<null>	4	0	<null>	08:54:11	09:12:11
writes/marks*100	4	0	0	0	<null>	0	<null>	0	0	2	1	0	0	0	1	0	0	0	0	<null>	09:12:12	09:30:12
writes/marks*100	5	0	0	0	0	0	0	0	<null>	0	0	0	0	0	0	0	0	0	0	<null>	09:30:13	09:48:13
writes/marks*100	6	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	3	0	<null>	09:48:14	10:06:14
writes/marks*100	7	0	0	0	0	0	0	0	<null>	1	0	0	0	0	0	0	0	3	0	<null>	10:06:15	10:24:15
writes/marks*100	8	0	0	0	<null>	0	0	0	0	1	1	0	0	0	0	0	0	4	0	<null>	10:24:16	10:42:16
writes/marks*100	9	0	0	0	<null>	0	<null>	0	0	1	0	0	0	0	0	0	0	4	0	<null>	10:42:17	11:00:17
writes/marks*100	10	1	0	0	<null>	0	0	0	0	<null>	<null>	0	0	0	<null>	0	<null>	<null>	<null>	<null>	11:00:18	11:18:18

Done for 10060 ms, from 11:37:03.95 to 11:37:14.01.

Performance in DETAILS:

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	1994846	1845212	149634	7.50	0	17394	43	149634	2017-05-01 08:18	2017-05-01 11:18
doc_list_biud	1995302	1845212	150090	7.52	0	16365	16	150090	2017-05-01 08:18	2017-05-01 11:18
sp_add_invoice_to_stock	20601	12176	8425	40.89	15	168512	10530	8425	2017-05-01 08:18	2017-05-01 11:18
sp_cancel_adding_invoice	4669	3620	1049	22.46	0	56207	2640	1049	2017-05-01 08:18	2017-05-01 11:18
sp_cancel_client_order	7045	6896	149	2.11	0	6907	246	149	2017-05-01 08:18	2017-05-01 11:18
sp_cancel_customer_reserve	355163	214728	140435	39.54	0	16412	60	140435	2017-05-01 08:18	2017-05-01 11:18
sp_cancel_pay_from_customer	2740	2729	11	0.40	0	2745	135	11	2017-05-01 08:18	2017-05-01 11:18
sp_cancel_pay_to_supplier	1624	1617	7	0.43	0	1825	138	7	2017-05-01 08:18	2017-05-01 11:18
sp_cancel_supplier_invoice	10098	7843	2255	22.33	0	8674	438	2255	2017-05-01 08:18	2017-05-01 11:18
sp_cancel_supplier_order	1657	546	1111	67.04	62	176733	19969	1111	2017-05-01 08:18	2017-05-01 11:18
sp_cancel_write_off	23387	16350	7037	30.08	0	9578	146	7037	2017-05-01 08:18	2017-05-01 11:18
sp_client_order	86175	86175	0	0.00	0	17270	467	0	2017-05-01 08:18	2017-05-01 11:18
sp_customer_reserve	647357	647357	0	0.00	0	16630	163	0	2017-05-01 08:18	2017-05-01 11:18
sp_fill_shopping_cart	130503	130178	325	0.24	0	6676	92	0	2017-05-01 08:18	2017-05-01 11:18
sp_fill_shopping_cart_clo_res	647357	647357	0	0.00	0	10249	12	0	2017-05-01 08:18	2017-05-01 11:18
sp_get_clo_for_invoice	12176	12176	0	0.00	0	14742	295	0	2017-05-01 08:18	2017-05-01 11:18
sp_kill_cost_storno	32020	24316	7704	24.05	0	3073	18	7704	2017-05-01 08:18	2017-05-01 11:18
sp_kill_qstorno_ret_qs2qd	743493	454195	289298	38.91	0	16177	22	289298	2017-05-01 08:18	2017-05-01 11:18
sp_kill_qty_storno	452384	302401	149983	33.15	0	16365	68	149983	2017-05-01 08:18	2017-05-01 11:18
sp_lock_selected_doc	84372	73184	11188	13.26	0	2543	7	11188	2017-05-01 08:18	2017-05-01 11:18
sp_make_cost_storno	104947	104947	0	0.00	0	17332	336	0	2017-05-01 08:18	2017-05-01 11:18
sp_multiply_rows_for_pdistr	104947	104947	0	0.00	0	10249	53	0	2017-05-01 08:18	2017-05-01 11:18
sp_multiply_rows_for_qdistr	86175	86175	0	0.00	0	10202	154	0	2017-05-01 08:18	2017-05-01 11:18
sp_pay_from_customer	28642	28642	0	0.00	0	15943	843	0	2017-05-01 08:18	2017-05-01 11:18
sp_pay_to_supplier	23887	23887	0	0.00	0	9562	430	0	2017-05-01 08:18	2017-05-01 11:18
sp_payment_common	52529	52529	0	0.00	0	4145	60	0	2017-05-01 08:18	2017-05-01 11:18
sp_qd_handle_on_cancel_clo	7041	6896	145	2.05	0	6283	106	145	2017-05-01 08:18	2017-05-01 11:18
sp_qd_handle_on_invoice_upd_sts	16667	15796	871	5.22	0	13744	333	871	2017-05-01 08:18	2017-05-01 11:18
sp_qd_handle_on_reserve_upd_sts	40242	40242	0	0.00	0	3728	48	0	2017-05-01 08:18	2017-05-01 11:18
sp_reserve_write_off	40744	40242	502	1.23	0	17503	469	502	2017-05-01 08:18	2017-05-01 11:18
sp_supplier_invoice	22330	22191	139	0.62	0	34226	2867	0	2017-05-01 08:18	2017-05-01 11:18
sp_supplier_order	21998	21812	186	0.84	0	20467	1974	0	2017-05-01 08:18	2017-05-01 11:18
srv_find_qd_qs_mism	1194980	1045369	149611	12.51	0	12901	24	149611	2017-05-01 08:18	2017-05-01 11:18
srv_make_invnt_saldo	1683	1683	0	0.00	15	26879	2955	0	2017-05-01 08:18	2017-05-01 11:18
srv_make_money_saldo	3287	3287	0	0.00	0	1840	67	0	2017-05-01 08:18	2017-05-01 11:18
srv_recalc_idx_stat	12	12	0	0.00	2371	32900	14891	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_add_invoice_to_stock	8425	8425	0	0.00	0	3245	100	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_cancel_adding_invoice	801	801	0	0.00	0	7566	164	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_cancel_client_order	149	149	0	0.00	0	624	82	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_cancel_customer_reserve	29	29	0	0.00	0	1232	108	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_cancel_pay_from_customer	11	11	0	0.00	0	390	66	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_cancel_pay_to_supplier	7	7	0	0.00	0	639	140	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_cancel_supplier_invoice	674	674	0	0.00	0	2262	87	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_cancel_supplier_order	17117	17117	0	0.00	0	7785	91	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_cancel_write_off	21	21	0	0.00	0	358	60	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_reserve_write_off	502	502	0	0.00	0	2184	80	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_supplier_invoice	139	139	0	0.00	0	733	71	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-abend:sp_supplier_order	186	186	0	0.00	0	1232	93	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_add_invoice_to_stock	12176	12176	0	0.00	0	14024	564	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_cancel_adding_invoice	1460	1460	0	0.00	0	10951	713	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_cancel_client_order	6896	6896	0	0.00	0	3073	70	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_cancel_customer_reserve	2710	2710	0	0.00	0	2699	71	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_cancel_pay_from_customer	2729	2729	0	0.00	0	1638	55	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_cancel_pay_to_supplier	1617	1617	0	0.00	0	2168	51	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_cancel_supplier_invoice	973	973	0	0.00	0	2340	80	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_cancel_supplier_order	546	546	0	0.00	0	59592	1928	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_cancel_write_off	3835	3835	0	0.00	0	2979	70	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_client_order	86175	86175	0	0.00	0	13884	81	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_customer_reserve	4067	4067	0	0.00	0	2854	53	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_pay_from_customer	28642	28642	0	0.00	0	2933	69	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_pay_to_supplier	23887	23887	0	0.00	0	3416	61	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_reserve_write_off	40242	40242	0	0.00	0	3931	72	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_supplier_invoice	22191	22191	0	0.00	0	14289	72	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:sp_supplier_order	21812	21812	0	0.00	0	14679	78	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:srv_make_invnt_saldo	1683	1683	0	0.00	0	983	31	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:srv_make_money_saldo	3287	3287	0	0.00	0	1107	28	0	2017-05-01 08:18	2017-05-01 11:18
t$perf-norm:srv_recalc_idx_stat	12	12	0	0.00	0	422	89	0	2017-05-01 08:18	2017-05-01 11:18
v_add_invoice_to_stock	41202	24352	16850	40.89	0	2418	12	16850	2017-05-01 08:18	2017-05-01 11:18
v_all_customers	129300	129300	0	0.00	0	2090	5	0	2017-05-01 08:18	2017-05-01 11:18
v_all_suppliers	90396	89746	650	0.71	0	1529	6	0	2017-05-01 08:18	2017-05-01 11:18
v_all_wares	172350	172350	0	0.00	0	1482	4	0	2017-05-01 08:18	2017-05-01 11:18
v_cancel_adding_invoice	3438	2920	518	15.06	0	6303	151	518	2017-05-01 08:18	2017-05-01 11:18
v_cancel_client_order	14090	13792	298	2.11	0	1045	7	298	2017-05-01 08:18	2017-05-01 11:18
v_cancel_customer_prepayment	5480	5458	22	0.40	0	889	8	22	2017-05-01 08:18	2017-05-01 11:18
v_cancel_customer_reserve	5478	5420	58	1.05	0	2652	9	58	2017-05-01 08:18	2017-05-01 11:18
v_cancel_payment_to_supplier	3248	3234	14	0.43	0	1201	9	14	2017-05-01 08:18	2017-05-01 11:18
v_cancel_supplier_invoice	3294	1946	1348	40.92	0	764	11	1348	2017-05-01 08:18	2017-05-01 11:18
v_cancel_supplier_order	3314	1092	2222	67.04	0	281	7	2222	2017-05-01 08:18	2017-05-01 11:18
v_cancel_write_off	7712	7670	42	0.54	0	3868	106	42	2017-05-01 08:18	2017-05-01 11:18
v_max_id_clo_ord	21998	21812	186	0.84	0	1014	6	0	2017-05-01 08:18	2017-05-01 11:18
v_max_id_clo_res	4067	4067	0	0.00	0	1888	18	0	2017-05-01 08:18	2017-05-01 11:18
v_max_id_ord_sup	22330	22191	139	0.62	0	2121	6	0	2017-05-01 08:18	2017-05-01 11:18
v_max_non_paid_invoice	23017	23017	0	0.00	0	889	5	0	2017-05-01 08:18	2017-05-01 11:18
v_max_non_paid_realizn	28642	28642	0	0.00	0	1373	5	0	2017-05-01 08:18	2017-05-01 11:18
v_min_id_clo_ord	21998	21812	186	0.84	0	1341	8	0	2017-05-01 08:18	2017-05-01 11:18
v_min_id_clo_res	4067	4067	0	0.00	0	608	9	0	2017-05-01 08:18	2017-05-01 11:18
v_min_id_ord_sup	22330	22191	139	0.62	0	2262	7	0	2017-05-01 08:18	2017-05-01 11:18
v_min_non_paid_invoice	23887	23887	0	0.00	0	1685	7	0	2017-05-01 08:18	2017-05-01 11:18
v_min_non_paid_realizn	28642	28642	0	0.00	0	1388	6	0	2017-05-01 08:18	2017-05-01 11:18
v_our_firm	43050	43050	0	0.00	0	1997	6	0	2017-05-01 08:18	2017-05-01 11:18
v_reserve_write_off	81488	80484	1004	1.23	0	3463	9	1004	2017-05-01 08:18	2017-05-01 11:18
x_lock_depdocs_on_canc_invoice	20025	10490	9535	47.61	0	13712	34	9535	2017-05-01 08:18	2017-05-01 11:18
x_lock_depdocs_on_canc_sup_ord	1656	546	1110	67.02	0	1295	58	1110	2017-05-01 08:18	2017-05-01 11:18
x_make_qstorno_1000_1200	21998	21812	186	0.84	0	20311	1765	0	2017-05-01 08:18	2017-05-01 11:18
x_make_qstorno_1200_2000	22330	22191	139	0.62	0	33290	2656	0	2017-05-01 08:18	2017-05-01 11:18
x_make_qstorno_2100_3300	647357	647357	0	0.00	0	16567	136	0	2017-05-01 08:18	2017-05-01 11:18

Done for 487560 ms, from 11:45:13.44 to 11:53:21.00.

Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.

Exceptions occured during test work:

FB_MNEMONA	CNT	UNIT	FB_GDSCODE	DTS_BEG	DTS_END
deadlock	79	sp_kill_cost_storno	335544336	2017-05-01 08:18	2017-05-01 11:17
deadlock	88	sp_kill_qstorno_ret_qs2qd	335544336	2017-05-01 08:20	2017-05-01 11:16
deadlock	2306	sp_lock_selected_doc	335544336	2017-05-01 08:18	2017-05-01 11:17
deadlock	145	sp_qd_handle_on_cancel_clo	335544336	2017-05-01 08:18	2017-05-01 11:17
deadlock	204	sp_qd_handle_on_invoice_upd_sts	335544336	2017-05-01 08:18	2017-05-01 11:16
deadlock	40	x_lock_depdocs_on_canc_invoice	335544336	2017-05-01 08:22	2017-05-01 11:14
deadlock	18	x_lock_depdocs_on_canc_sup_ord	335544336	2017-05-01 08:21	2017-05-01 10:55
user_exc	186	x_make_qstorno_1000_1200	335544517	2017-05-01 08:18	2017-05-01 11:17
user_exc	139	x_make_qstorno_1200_2000	335544517	2017-05-01 08:18	2017-05-01 11:15
concurrent_transaction	7356	sp_lock_selected_doc	335544878	2017-05-01 08:18	2017-05-01 11:18
concurrent_transaction	662	x_lock_depdocs_on_canc_invoice	335544878	2017-05-01 08:18	2017-05-01 11:17
concurrent_transaction	284	x_lock_depdocs_on_canc_sup_ord	335544878	2017-05-01 08:18	2017-05-01 11:16

Done for 15050 ms, from 11:53:34.04 to 11:53:49.09.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 450736
MON$OLDEST_ACTIVE 450737
MON$OLDEST_SNAPSHOT 450737
MON$NEXT_TRANSACTION 450737
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 885472
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.623 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.623 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.623 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.623 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0

Database statistics, full

Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 450795
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 450738
Oldest active 450739
Oldest snapshot 450739
Next transaction 450740
Sequence number 0
Next attachment ID 9408
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write

Variable header data:
Sweep interval: 0
*END*

Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, 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.27
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: 325, 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: 327, 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: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, 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: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
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: 323, 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: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Root page: 339, 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: 340, 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: 338, 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: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.13, total records: 2200097
Average version length: 47.79, total versions: 2932, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 23872
Data pages: 23872, average fill: 73%
Primary pages: 23872, secondary pages: 0, swept pages: 13944
Empty pages: 1, full pages: 20148
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 85
60 - 79% = 23778
80 - 99% = 3

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 10825, nodes: 2200097
Average node length: 19.33, total dup: 0, max dup: 0
Average key length: 16.37, compression ratio: 1.65
Average prefix length: 13.62, average data length: 13.38
Clustering factor: 466263, ratio: 0.21
Fill distribution:
0 - 19% = 778
20 - 39% = 2510
40 - 59% = 4888
60 - 79% = 1295
80 - 99% = 1354

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7900, nodes: 2200097
Average node length: 11.63, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 448821, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 3785
40 - 59% = 4020
60 - 79% = 85
80 - 99% = 9

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175843, depth: 3, leaf buckets: 3923, nodes: 2200097
Average node length: 6.83, total dup: 1599378, max dup: 49
Average key length: 3.87, compression ratio: 2.32
Average prefix length: 7.40, average data length: 1.60
Clustering factor: 425940, ratio: 0.19
Fill distribution:
0 - 19% = 159
20 - 39% = 1284
40 - 59% = 1689
60 - 79% = 301
80 - 99% = 490

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.44, total records: 668665
Average version length: 61.24, total versions: 626, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8464
Data pages: 8464, average fill: 75%
Primary pages: 8464, secondary pages: 0, swept pages: 7612
Empty pages: 7, full pages: 7823
Fill distribution:
0 - 19% = 8
20 - 39% = 4
40 - 59% = 18
60 - 79% = 8422
80 - 99% = 12

Index DOC_LIST_ID_DESC (1)
Root page: 250532, depth: 3, leaf buckets: 2485, nodes: 668665
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 168276, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 1411
40 - 59% = 1035
60 - 79% = 37
80 - 99% = 2

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 706, nodes: 668665
Average node length: 4.88, total dup: 668615, max dup: 33981
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 302709, ratio: 0.45
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 598
60 - 79% = 92
80 - 99% = 15

Index PK_DOC_LIST (0)
Root page: 329578, depth: 3, leaf buckets: 2041, nodes: 668665
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 168276, ratio: 0.25
Fill distribution:
0 - 19% = 160
20 - 39% = 604
40 - 59% = 768
60 - 79% = 259
80 - 99% = 250

DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
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: 321, 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: 322, 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: 320, 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: 341, Index root page: 342
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: 343, 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: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 66.39, total records: 400
Average version length: 20.27, total versions: 109172, max versions: 1052
Average fragment length: 18.82, total fragments: 385, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.57
Pointer pages: 1, data page slots: 1528
Data pages: 1528, average fill: 40%
Primary pages: 9, secondary pages: 1519, swept pages: 2
Empty pages: 5, full pages: 4
Fill distribution:
0 - 19% = 5
20 - 39% = 880
40 - 59% = 636
60 - 79% = 3
80 - 99% = 4

Index PK_INVNT_SALDO (0)
Root page: 285, 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: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 10.53, total records: 24255
Average version length: 71.16, total versions: 20673, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 9.12
Pointer pages: 2, data page slots: 1072
Data pages: 432, average fill: 72%
Primary pages: 432, secondary pages: 0, swept pages: 27
Empty pages: 31, full pages: 284
Fill distribution:
0 - 19% = 34
20 - 39% = 17
40 - 59% = 36
60 - 79% = 113
80 - 99% = 232

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 97, nodes: 24255
Average node length: 13.80, total dup: 978, max dup: 1
Average key length: 11.82, compression ratio: 2.28
Average prefix length: 18.14, average data length: 8.86
Clustering factor: 21620, ratio: 0.89
Fill distribution:
0 - 19% = 0
20 - 39% = 44
40 - 59% = 45
60 - 79% = 8
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.10, 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.12
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: 276, 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: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 6.97, total records: 310
Average version length: 46.04, total versions: 263, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 9.18
Pointer pages: 1, data page slots: 40
Data pages: 24, average fill: 15%
Primary pages: 23, secondary pages: 1, swept pages: 12
Empty pages: 8, full pages: 1
Fill distribution:
0 - 19% = 18
20 - 39% = 3
40 - 59% = 2
60 - 79% = 0
80 - 99% = 1

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 436162, depth: 2, leaf buckets: 1, nodes: 310
Average node length: 6.56, total dup: 244, max dup: 40
Average key length: 4.98, compression ratio: 3.81
Average prefix length: 16.23, average data length: 2.77
Clustering factor: 170, ratio: 0.55
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (165)
Primary pointer page: 356, Index root page: 357
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: 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_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
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

Index PK_MON_LOG (0)
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

MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
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: 376, 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: 374, 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: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, 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: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 241, Index root page: 242
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: 244, 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: 243, 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: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 19.59, total records: 823279
Average version length: 42.69, total versions: 5268, max versions: 8
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.27
Pointer pages: 4, data page slots: 5000
Data pages: 5000, average fill: 75%
Primary pages: 4996, secondary pages: 4, swept pages: 3687
Empty pages: 9, full pages: 4704
Fill distribution:
0 - 19% = 15
20 - 39% = 21
40 - 59% = 85
60 - 79% = 4316
80 - 99% = 563

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 281, nodes: 264378
Average node length: 4.90, total dup: 264329, max dup: 16446
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 37322, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 23
40 - 59% = 169
60 - 79% = 77
80 - 99% = 11

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 303, nodes: 264378
Average node length: 5.85, total dup: 238127, max dup: 39
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 42587, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 21
40 - 59% = 110
60 - 79% = 117
80 - 99% = 53

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 302, nodes: 264378
Average node length: 5.85, total dup: 238127, max dup: 39
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 42696, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 124
60 - 79% = 110
80 - 99% = 53

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 291, nodes: 264378
Average node length: 5.63, total dup: 238127, max dup: 39
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 42730, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 17
40 - 59% = 117
60 - 79% = 101
80 - 99% = 55

PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.95, total records: 286091
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: 2448
Data pages: 2448, average fill: 64%
Primary pages: 2448, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2443
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2443
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 213622, depth: 2, leaf buckets: 229, nodes: 286091
Average node length: 4.55, total dup: 285910, max dup: 2386
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 76537, ratio: 0.27
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 93
60 - 79% = 58
80 - 99% = 78

PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
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: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.69, total records: 12203338
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.18
Pointer pages: 178, data page slots: 289520
Data pages: 289520, average fill: 87%
Primary pages: 289520, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 289513
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 289514

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 13711, nodes: 12203338
Average node length: 5.69, total dup: 11327025, max dup: 148
Average key length: 2.18, compression ratio: 3.67
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 4281307, ratio: 0.35
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 7445
60 - 79% = 4076
80 - 99% = 2181

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 12149, nodes: 12203338
Average node length: 4.60, total dup: 12203333, max dup: 11098490
Average key length: 1.09, compression ratio: 0.41
Average prefix length: 0.45, average data length: 0.00
Clustering factor: 360064, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 12122
60 - 79% = 0
80 - 99% = 27

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 14818, nodes: 12203338
Average node length: 5.74, total dup: 11824042, max dup: 19673
Average key length: 2.23, compression ratio: 4.03
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 1005258, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 10887
60 - 79% = 2150
80 - 99% = 1776

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 14819, nodes: 12203338
Average node length: 5.58, total dup: 12173480, max dup: 1640360
Average key length: 2.07, compression ratio: 18.26
Average prefix length: 37.76, average data length: 0.07
Clustering factor: 6728882, ratio: 0.55
Fill distribution:
0 - 19% = 13
20 - 39% = 3
40 - 59% = 12668
60 - 79% = 603
80 - 99% = 1532

PHRASES (145)
Primary pointer page: 269, Index root page: 270
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: 283, 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: 282, 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: 281, 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: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.04, total records: 455606
Average version length: 56.00, total versions: 1565, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5424
Data pages: 5424, average fill: 74%
Primary pages: 5424, secondary pages: 0, swept pages: 3454
Empty pages: 0, full pages: 5043
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 31
60 - 79% = 5377
80 - 99% = 9

Index PSTORNED_RCV_ID (2)
Root page: 742393, depth: 3, leaf buckets: 578, nodes: 455606
Average node length: 5.87, total dup: 388236, max dup: 658
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 55944, ratio: 0.12
Fill distribution:
0 - 19% = 9
20 - 39% = 35
40 - 59% = 308
60 - 79% = 165
80 - 99% = 61

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 489, nodes: 455606
Average node length: 5.62, total dup: 404798, max dup: 95
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 107681, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 209
60 - 79% = 188
80 - 99% = 86

RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
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: 310, 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: 245, Index root page: 246
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: 248, 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: 247, 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: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 3272, max versions: 1876
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: 16
Data pages: 16, average fill: 65%
Primary pages: 4, secondary pages: 12, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 11

Index PK_SEMAPHORES (0)
Root page: 330, 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: 331, 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: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
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: 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$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
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: 218, 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: 226, Index root page: 227
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: 229, 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: 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$MON_LOG_TABLE_STATS (134)
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$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
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

TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
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: 219, Index root page: 220
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: 222, 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: 221, 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: 211, Index root page: 212
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: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.72, total records: 2508
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.51
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 72%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 1, full pages: 30
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 30
80 - 99% = 0

WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, 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.77
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: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, 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: 277, 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: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 279, 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: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
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: 328, 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: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 9.41, total records: 27891
Average version length: 72.18, total versions: 24256, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 14.46
Pointer pages: 2, data page slots: 1472
Data pages: 462, average fill: 78%
Primary pages: 460, secondary pages: 2, swept pages: 3
Empty pages: 5, full pages: 354
Fill distribution:
0 - 19% = 18
20 - 39% = 32
40 - 59% = 30
60 - 79% = 56
80 - 99% = 326

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 39, nodes: 27891
Average node length: 6.03, total dup: 24323, max dup: 17
Average key length: 3.65, compression ratio: 10.12
Average prefix length: 35.47, average data length: 1.53
Clustering factor: 4604, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 22
60 - 79% = 12
80 - 99% = 2

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.58, total records: 1246495
Average version length: 71.41, total versions: 10430, 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: 12, data page slots: 18256
Data pages: 18256, average fill: 75%
Primary pages: 18256, secondary pages: 0, swept pages: 9553
Empty pages: 61, full pages: 16292
Fill distribution:
0 - 19% = 131
20 - 39% = 128
40 - 59% = 475
60 - 79% = 17314
80 - 99% = 208

Index XQD_1000_3300_DOC (1)
Root page: 469883, depth: 3, leaf buckets: 1447, nodes: 1246495
Average node length: 5.13, total dup: 1214040, max dup: 125
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 143637, ratio: 0.12
Fill distribution:
0 - 19% = 20
20 - 39% = 68
40 - 59% = 1123
60 - 79% = 64
80 - 99% = 172

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 251042, depth: 3, leaf buckets: 1766, nodes: 1246495
Average node length: 6.26, total dup: 1088359, max dup: 27
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 241287, ratio: 0.19
Fill distribution:
0 - 19% = 18
20 - 39% = 146
40 - 59% = 1305
60 - 79% = 146
80 - 99% = 151

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 21.32, total records: 168811
Average version length: 72.05, total versions: 51525, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 6.38
Pointer pages: 4, data page slots: 5184
Data pages: 3832, average fill: 36%
Primary pages: 3831, secondary pages: 1, swept pages: 894
Empty pages: 978, full pages: 1248
Fill distribution:
0 - 19% = 2002
20 - 39% = 226
40 - 59% = 213
60 - 79% = 471
80 - 99% = 920

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 132, nodes: 91815
Average node length: 5.77, total dup: 81036, max dup: 56
Average key length: 3.35, compression ratio: 11.03
Average prefix length: 35.76, average data length: 1.24
Clustering factor: 10888, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 26
40 - 59% = 73
60 - 79% = 29
80 - 99% = 3

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 53.03, total records: 2544134
Average version length: 71.73, total versions: 40828, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.56
Pointer pages: 21, data page slots: 33496
Data pages: 33496, average fill: 67%
Primary pages: 33496, secondary pages: 0, swept pages: 16753
Empty pages: 168, full pages: 25807
Fill distribution:
0 - 19% = 387
20 - 39% = 3933
40 - 59% = 3608
60 - 79% = 22628
80 - 99% = 2940

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 196333, depth: 3, leaf buckets: 2823, nodes: 1819186
Average node length: 5.64, total dup: 1708321, max dup: 85
Average key length: 2.67, compression ratio: 13.88
Average prefix length: 36.39, average data length: 0.61
Clustering factor: 225663, ratio: 0.12
Fill distribution:
0 - 19% = 6
20 - 39% = 1224
40 - 59% = 1141
60 - 79% = 279
80 - 99% = 173

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.04, total records: 4029799
Average version length: 69.75, total versions: 163, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.05
Pointer pages: 16, data page slots: 25200
Data pages: 25200, average fill: 51%
Primary pages: 25200, secondary pages: 0, swept pages: 9310
Empty pages: 38, full pages: 24473
Fill distribution:
0 - 19% = 288
20 - 39% = 7669
40 - 59% = 6172
60 - 79% = 11030
80 - 99% = 41

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 9, nodes: 2588
Average node length: 10.45, total dup: 1882, max dup: 44
Average key length: 7.44, compression ratio: 4.97
Average prefix length: 31.82, average data length: 5.18
Clustering factor: 637, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 3
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 62.97, total records: 3138552
Average version length: 71.25, total versions: 15273, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.16
Pointer pages: 26, data page slots: 40952
Data pages: 40952, average fill: 76%
Primary pages: 40952, secondary pages: 0, swept pages: 29673
Empty pages: 6, full pages: 36702
Fill distribution:
0 - 19% = 31
20 - 39% = 257
40 - 59% = 962
60 - 79% = 37487
80 - 99% = 2215

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5580, nodes: 2727455
Average node length: 6.89, total dup: 2203239, max dup: 14
Average key length: 3.92, compression ratio: 9.44
Average prefix length: 35.27, average data length: 1.73
Clustering factor: 503413, ratio: 0.18
Fill distribution:
0 - 19% = 22
20 - 39% = 2821
40 - 59% = 2219
60 - 79% = 320
80 - 99% = 198

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.81, total records: 4880168
Average version length: 84.56, total versions: 1940, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 46, data page slots: 75072
Data pages: 75072, average fill: 80%
Primary pages: 75072, secondary pages: 0, swept pages: 27880
Empty pages: 6, full pages: 74803
Fill distribution:
0 - 19% = 8
20 - 39% = 9
40 - 59% = 23
60 - 79% = 21698
80 - 99% = 53334

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4952, nodes: 4880168
Average node length: 5.15, total dup: 4768963, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 783131, ratio: 0.16
Fill distribution:
0 - 19% = 20
20 - 39% = 89
40 - 59% = 2117
60 - 79% = 2103
80 - 99% = 623

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5436, nodes: 4880168
Average node length: 5.69, total dup: 4372983, max dup: 49
Average key length: 2.71, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 256116, ratio: 0.05
Fill distribution:
0 - 19% = 58
20 - 39% = 165
40 - 59% = 3185
60 - 79% = 346
80 - 99% = 1682

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5528, nodes: 4880168
Average node length: 5.81, total dup: 4269489, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 838818, ratio: 0.17
Fill distribution:
0 - 19% = 32
20 - 39% = 100
40 - 59% = 2380
60 - 79% = 2164
80 - 99% = 852

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.99, total records: 2432938
Average version length: 83.57, total versions: 10174, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 24, data page slots: 38280
Data pages: 38280, average fill: 78%
Primary pages: 38280, secondary pages: 0, swept pages: 28421
Empty pages: 15, full pages: 35839
Fill distribution:
0 - 19% = 67
20 - 39% = 130
40 - 59% = 513
60 - 79% = 16988
80 - 99% = 20582

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2610, nodes: 2432938
Average node length: 5.15, total dup: 2375768, max dup: 202
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 391574, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 53
40 - 59% = 1524
60 - 79% = 772
80 - 99% = 259

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4230, nodes: 2432938
Average node length: 6.25, total dup: 1988878, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 252578, ratio: 0.10
Fill distribution:
0 - 19% = 119
20 - 39% = 1723
40 - 59% = 1673
60 - 79% = 511
80 - 99% = 204

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2972, nodes: 2432938
Average node length: 5.81, total dup: 2127345, max dup: 38
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 468490, ratio: 0.19
Fill distribution:
0 - 19% = 14
20 - 39% = 57
40 - 59% = 1784
60 - 79% = 872
80 - 99% = 245

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.65, total records: 5156548
Average version length: 85.33, total versions: 19368, 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: 50, data page slots: 80744
Data pages: 80728, average fill: 79%
Primary pages: 80728, secondary pages: 0, swept pages: 24032
Empty pages: 197, full pages: 75831
Fill distribution:
0 - 19% = 321
20 - 39% = 458
40 - 59% = 1436
60 - 79% = 18145
80 - 99% = 60368

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5470, nodes: 5156548
Average node length: 5.04, total dup: 5126489, max dup: 711
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 769319, ratio: 0.15
Fill distribution:
0 - 19% = 7
20 - 39% = 280
40 - 59% = 3075
60 - 79% = 1568
80 - 99% = 540

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 6410, nodes: 5156548
Average node length: 5.53, total dup: 4751037, max dup: 49
Average key length: 2.54, compression ratio: 3.54
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 287383, ratio: 0.06
Fill distribution:
0 - 19% = 83
20 - 39% = 1690
40 - 59% = 2770
60 - 79% = 607
80 - 99% = 1260

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 6094, nodes: 5156548
Average node length: 5.68, total dup: 4631063, max dup: 87
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 849587, ratio: 0.16
Fill distribution:
0 - 19% = 5
20 - 39% = 234
40 - 59% = 3406
60 - 79% = 1776
80 - 99% = 673

XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
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: 823, 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: 825, 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: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.38, total records: 3366091
Average version length: 83.65, total versions: 9694, 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: 33, data page slots: 52848
Data pages: 52848, average fill: 79%
Primary pages: 52848, secondary pages: 0, swept pages: 38247
Empty pages: 18, full pages: 49830
Fill distribution:
0 - 19% = 75
20 - 39% = 143
40 - 59% = 534
60 - 79% = 21517
80 - 99% = 30579

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3676, nodes: 3366091
Average node length: 5.03, total dup: 3349157, max dup: 1198
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 697382, ratio: 0.21
Fill distribution:
0 - 19% = 18
20 - 39% = 354
40 - 59% = 2046
60 - 79% = 847
80 - 99% = 411

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5891, nodes: 3366091
Average node length: 6.26, total dup: 2747799, max dup: 14
Average key length: 3.28, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 385649, ratio: 0.11
Fill distribution:
0 - 19% = 218
20 - 39% = 2429
40 - 59% = 2229
60 - 79% = 691
80 - 99% = 324

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4049, nodes: 3366091
Average node length: 5.59, total dup: 3068758, max dup: 85
Average key length: 2.61, compression ratio: 3.44
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 740283, ratio: 0.22
Fill distribution:
0 - 19% = 10
20 - 39% = 377
40 - 59% = 2192
60 - 79% = 1040
80 - 99% = 430

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.37, total records: 645987
Average version length: 69.56, total versions: 1772, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 6, data page slots: 8968
Data pages: 8968, average fill: 76%
Primary pages: 8968, secondary pages: 0, swept pages: 6801
Empty pages: 8, full pages: 8444
Fill distribution:
0 - 19% = 17
20 - 39% = 41
40 - 59% = 127
60 - 79% = 8735
80 - 99% = 48

Index XQS_3300_3400_DOC_ID (0)
Root page: 239479, depth: 3, leaf buckets: 760, nodes: 645987
Average node length: 5.34, total dup: 606568, max dup: 113
Average key length: 2.46, compression ratio: 3.65
Average prefix length: 8.60, average data length: 0.40
Clustering factor: 56995, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 142
40 - 59% = 325
60 - 79% = 188
80 - 99% = 102

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 849, nodes: 645987
Average node length: 5.94, total dup: 550442, max dup: 14
Average key length: 3.06, compression ratio: 2.94
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 60619, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 138
40 - 59% = 406
60 - 79% = 216
80 - 99% = 88

ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
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: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
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: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
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: 686, 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: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
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: 689, 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: 688, 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: 691, 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: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
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: 271, Index root page: 272
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: 284, 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 89240 ms, from 11:53:49.80 to 11:55:19.04.

Analyzing DB stat log: obtaining values of total records and versions

TABLE_NAME	TOTAL_RECS	TOTAL_VERS	VERS_PERCENT
AGENTS	50	0	0.0000
BUSINESS_OPS	19	0	0.0000
DOC_DATA	2200097	2932	0.1332
DOC_LIST	668665	626	0.0936
DOC_STATES	4	0	0.0000
FB_ERRORS	758	0	0.0000
INVNT_SALDO	400	109172	27293.0000
INVNT_TURNOVER_LOG	24255	20673	85.2319
MONEY_SALDO	49	0	0.0000
MONEY_TURNOVER_LOG	310	263	84.8387
OPTYPES	9	0	0.0000
PDISTR	823279	5268	0.6398
PERF_ESTIMATED	286091	0	0.0000
PERF_LOG	12203338	0	0.0000
PSTORNED	455606	1565	0.3434
RULES_FOR_PDISTR	4	0	0.0000
RULES_FOR_QDISTR	7	0	0.0000
SEMAPHORES	4	3272	81800.0000
SETTINGS	114	0	0.0000
TRACE_STAT	2508	0	0.0000
WARES	400	0	0.0000
WARE_GROUPS	8	0	0.0000
XQD_1000_1200	27891	24256	86.9671
XQD_1000_3300	1246495	10430	0.8367
XQD_1200_2000	168811	51525	30.5223
XQD_2000_3300	2544134	40828	1.6047
XQD_2100_3300	4029799	163	0.0040
XQD_3300_3400	3138552	15273	0.4866
XQS_1000_1200	4880168	1940	0.0397
XQS_1000_3300	2432938	10174	0.4181
XQS_1200_2000	5156548	19368	0.3756
XQS_2100_3300	3366091	9694	0.2879
XQS_3300_3400	645987	1772	0.2743
Z_USED_VIEWS	29	0	0.0000

Done for 2390 ms, from 11:55:30.82 to 11:55:33.21.

Database validation

11:55:33.38 Validation started

11:55:33.41 Relation 140 (DOC_LIST)
11:55:33.41 process pointer page 0 of 6
11:55:33.52 process pointer page 1 of 6
11:55:33.61 process pointer page 2 of 6
11:55:33.71 process pointer page 3 of 6
11:55:33.75 process pointer page 4 of 6
11:55:33.79 process pointer page 5 of 6
11:55:33.80 Index 1 (PK_DOC_LIST)
11:55:34.02 Index 2 (DOC_LIST_ID_DESC)
11:55:34.32 Index 3 (FK_DOC_LIST_AGENTS)
11:55:34.60 Relation 140 (DOC_LIST) is ok

11:55:34.60 Relation 141 (DOC_DATA)
11:55:34.60 process pointer page 0 of 15
11:55:34.69 process pointer page 1 of 15
11:55:34.78 process pointer page 2 of 15
11:55:34.86 process pointer page 3 of 15
11:55:34.96 process pointer page 4 of 15
11:55:35.05 process pointer page 5 of 15
11:55:35.14 process pointer page 6 of 15
11:55:35.24 process pointer page 7 of 15
11:55:35.33 process pointer page 8 of 15
11:55:35.42 process pointer page 9 of 15
11:55:35.50 process pointer page 10 of 15
11:55:35.59 process pointer page 11 of 15
11:55:35.69 process pointer page 12 of 15
11:55:35.78 process pointer page 13 of 15
11:55:35.88 process pointer page 14 of 15
11:55:35.92 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:55:37.05 Index 3 (DOC_DATA_ID_DESC)
11:55:38.00 Index 4 (FK_DOC_DATA_DOC_LIST)
11:55:38.76 Relation 141 (DOC_DATA) is ok

11:55:38.76 Relation 147 (INVNT_SALDO)
11:55:38.76 process pointer page 0 of 1
11:55:39.17 Index 1 (PK_INVNT_SALDO)
11:55:39.17 Relation 147 (INVNT_SALDO) is ok

11:55:39.17 Relation 150 (PDISTR)
11:55:39.17 process pointer page 0 of 4
11:55:39.25 process pointer page 1 of 4
11:55:39.34 process pointer page 2 of 4
11:55:39.43 process pointer page 3 of 4
11:55:39.45 Index 2 (PDISTR_SND_ID)
11:55:39.54 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:55:39.65 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:55:39.74 Index 5 (PDISTR_AGENT_ID)
11:55:39.84 Relation 150 (PDISTR) is ok

11:55:39.84 Relation 151 (PSTORNED)
11:55:39.84 process pointer page 0 of 4
11:55:39.93 process pointer page 1 of 4
11:55:40.03 process pointer page 2 of 4
11:55:40.12 process pointer page 3 of 4
11:55:40.15 Index 2 (PSTORNED_SND_ID)
11:55:40.31 Index 3 (PSTORNED_RCV_ID)
11:55:40.45 Relation 151 (PSTORNED) is ok

11:55:40.45 Relation 156 (SEMAPHORES)
11:55:40.45 process pointer page 0 of 1
11:55:40.46 Index 1 (PK_SEMAPHORES)
11:55:40.46 Index 2 (SEMAPHORES_TASK_UNQ)
11:55:40.46 Relation 156 (SEMAPHORES) is ok

11:55:40.46 Relation 157 (INVNT_TURNOVER_LOG)
11:55:40.46 process pointer page 0 of 2
11:55:40.51 process pointer page 1 of 2
11:55:40.51 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:55:40.52 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:55:40.52 Relation 160 (PERF_ESTIMATED)
11:55:40.52 process pointer page 0 of 2
11:55:40.62 process pointer page 1 of 2
11:55:40.66 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:55:40.77 Relation 160 (PERF_ESTIMATED) is ok

11:55:40.77 Relation 161 (PERF_ISQL_STAT)
11:55:40.77 process pointer page 0 of 1
11:55:40.77 Index 1 (PERF_ISQL_STAT_TRN)
11:55:40.77 Relation 161 (PERF_ISQL_STAT) is ok

11:55:40.77 Relation 162 (TRACE_STAT)
11:55:40.77 process pointer page 0 of 1
11:55:40.77 Relation 162 (TRACE_STAT) is ok

11:55:40.77 Relation 163 (PERF_LOG)
11:55:40.77 process pointer page 0 of 178
11:55:40.85 process pointer page 1 of 178
11:55:40.93 process pointer page 2 of 178
11:55:41.01 process pointer page 3 of 178
11:55:41.04 process pointer page 4 of 178
11:55:41.07 process pointer page 5 of 178
11:55:41.13 process pointer page 6 of 178
11:55:41.20 process pointer page 7 of 178
11:55:41.23 process pointer page 8 of 178
11:55:41.29 process pointer page 9 of 178
11:55:41.32 process pointer page 10 of 178
11:55:41.37 process pointer page 11 of 178
11:55:41.40 process pointer page 12 of 178
11:55:41.48 process pointer page 13 of 178
11:55:41.55 process pointer page 14 of 178
11:55:41.59 process pointer page 15 of 178
11:55:41.65 process pointer page 16 of 178
11:55:41.74 process pointer page 17 of 178
11:55:41.82 process pointer page 18 of 178
11:55:41.91 process pointer page 19 of 178
11:55:41.99 process pointer page 20 of 178
11:55:42.07 process pointer page 21 of 178
11:55:42.16 process pointer page 22 of 178
11:55:42.24 process pointer page 23 of 178
11:55:42.32 process pointer page 24 of 178
11:55:42.40 process pointer page 25 of 178
11:55:42.47 process pointer page 26 of 178
11:55:42.55 process pointer page 27 of 178
11:55:42.65 process pointer page 28 of 178
11:55:42.72 process pointer page 29 of 178
11:55:42.80 process pointer page 30 of 178
11:55:42.88 process pointer page 31 of 178
11:55:42.96 process pointer page 32 of 178
11:55:43.04 process pointer page 33 of 178
11:55:43.13 process pointer page 34 of 178
11:55:43.21 process pointer page 35 of 178
11:55:43.29 process pointer page 36 of 178
11:55:43.36 process pointer page 37 of 178
11:55:43.44 process pointer page 38 of 178
11:55:43.52 process pointer page 39 of 178
11:55:43.60 process pointer page 40 of 178
11:55:43.69 process pointer page 41 of 178
11:55:43.77 process pointer page 42 of 178
11:55:43.85 process pointer page 43 of 178
11:55:43.93 process pointer page 44 of 178
11:55:44.00 process pointer page 45 of 178
11:55:44.10 process pointer page 46 of 178
11:55:44.17 process pointer page 47 of 178
11:55:44.25 process pointer page 48 of 178
11:55:44.33 process pointer page 49 of 178
11:55:44.41 process pointer page 50 of 178
11:55:44.49 process pointer page 51 of 178
11:55:44.56 process pointer page 52 of 178
11:55:44.66 process pointer page 53 of 178
11:55:44.74 process pointer page 54 of 178
11:55:44.81 process pointer page 55 of 178
11:55:44.89 process pointer page 56 of 178
11:55:44.97 process pointer page 57 of 178
11:55:45.05 process pointer page 58 of 178
11:55:45.14 process pointer page 59 of 178
11:55:45.22 process pointer page 60 of 178
11:55:45.30 process pointer page 61 of 178
11:55:45.38 process pointer page 62 of 178
11:55:45.45 process pointer page 63 of 178
11:55:45.55 process pointer page 64 of 178
11:55:45.63 process pointer page 65 of 178
11:55:45.70 process pointer page 66 of 178
11:55:45.78 process pointer page 67 of 178
11:55:45.86 process pointer page 68 of 178
11:55:45.94 process pointer page 69 of 178
11:55:46.03 process pointer page 70 of 178
11:55:46.11 process pointer page 71 of 178
11:55:46.19 process pointer page 72 of 178
11:55:46.27 process pointer page 73 of 178
11:55:46.34 process pointer page 74 of 178
11:55:46.44 process pointer page 75 of 178
11:55:46.51 process pointer page 76 of 178
11:55:46.59 process pointer page 77 of 178
11:55:46.67 process pointer page 78 of 178
11:55:46.75 process pointer page 79 of 178
11:55:46.83 process pointer page 80 of 178
11:55:46.92 process pointer page 81 of 178
11:55:47.00 process pointer page 82 of 178
11:55:47.08 process pointer page 83 of 178
11:55:47.17 process pointer page 84 of 178
11:55:47.25 process pointer page 85 of 178
11:55:47.33 process pointer page 86 of 178
11:55:47.40 process pointer page 87 of 178
11:55:47.48 process pointer page 88 of 178
11:55:47.58 process pointer page 89 of 178
11:55:47.65 process pointer page 90 of 178
11:55:47.73 process pointer page 91 of 178
11:55:47.81 process pointer page 92 of 178
11:55:47.89 process pointer page 93 of 178
11:55:47.97 process pointer page 94 of 178
11:55:48.04 process pointer page 95 of 178
11:55:48.12 process pointer page 96 of 178
11:55:48.20 process pointer page 97 of 178
11:55:48.29 process pointer page 98 of 178
11:55:48.37 process pointer page 99 of 178
11:55:48.45 process pointer page 100 of 178
11:55:48.53 process pointer page 101 of 178
11:55:48.61 process pointer page 102 of 178
11:55:48.68 process pointer page 103 of 178
11:55:48.76 process pointer page 104 of 178
11:55:48.85 process pointer page 105 of 178
11:55:48.93 process pointer page 106 of 178
11:55:49.01 process pointer page 107 of 178
11:55:49.09 process pointer page 108 of 178
11:55:49.18 process pointer page 109 of 178
11:55:49.26 process pointer page 110 of 178
11:55:49.34 process pointer page 111 of 178
11:55:49.42 process pointer page 112 of 178
11:55:49.49 process pointer page 113 of 178
11:55:49.57 process pointer page 114 of 178
11:55:49.67 process pointer page 115 of 178
11:55:49.74 process pointer page 116 of 178
11:55:49.82 process pointer page 117 of 178
11:55:49.90 process pointer page 118 of 178
11:55:49.98 process pointer page 119 of 178
11:55:50.06 process pointer page 120 of 178
11:55:50.13 process pointer page 121 of 178
11:55:50.23 process pointer page 122 of 178
11:55:50.31 process pointer page 123 of 178
11:55:50.38 process pointer page 124 of 178
11:55:50.46 process pointer page 125 of 178
11:55:50.54 process pointer page 126 of 178
11:55:50.62 process pointer page 127 of 178
11:55:50.71 process pointer page 128 of 178
11:55:50.79 process pointer page 129 of 178
11:55:50.87 process pointer page 130 of 178
11:55:50.95 process pointer page 131 of 178
11:55:51.04 process pointer page 132 of 178
11:55:51.12 process pointer page 133 of 178
11:55:51.19 process pointer page 134 of 178
11:55:51.27 process pointer page 135 of 178
11:55:51.35 process pointer page 136 of 178
11:55:51.44 process pointer page 137 of 178
11:55:51.52 process pointer page 138 of 178
11:55:51.60 process pointer page 139 of 178
11:55:51.68 process pointer page 140 of 178
11:55:51.77 process pointer page 141 of 178
11:55:51.85 process pointer page 142 of 178
11:55:51.93 process pointer page 143 of 178
11:55:52.01 process pointer page 144 of 178
11:55:52.08 process pointer page 145 of 178
11:55:52.18 process pointer page 146 of 178
11:55:52.26 process pointer page 147 of 178
11:55:52.33 process pointer page 148 of 178
11:55:52.41 process pointer page 149 of 178
11:55:52.51 process pointer page 150 of 178
11:55:52.58 process pointer page 151 of 178
11:55:52.66 process pointer page 152 of 178
11:55:52.74 process pointer page 153 of 178
11:55:52.82 process pointer page 154 of 178
11:55:52.91 process pointer page 155 of 178
11:55:52.99 process pointer page 156 of 178
11:55:53.07 process pointer page 157 of 178
11:55:53.14 process pointer page 158 of 178
11:55:53.22 process pointer page 159 of 178
11:55:53.32 process pointer page 160 of 178
11:55:53.39 process pointer page 161 of 178
11:55:53.47 process pointer page 162 of 178
11:55:53.55 process pointer page 163 of 178
11:55:53.63 process pointer page 164 of 178
11:55:53.72 process pointer page 165 of 178
11:55:53.80 process pointer page 166 of 178
11:55:53.88 process pointer page 167 of 178
11:55:53.96 process pointer page 168 of 178
11:55:54.05 process pointer page 169 of 178
11:55:54.13 process pointer page 170 of 178
11:55:54.21 process pointer page 171 of 178
11:55:54.28 process pointer page 172 of 178
11:55:54.38 process pointer page 173 of 178
11:55:54.46 process pointer page 174 of 178
11:55:54.53 process pointer page 175 of 178
11:55:54.61 process pointer page 176 of 178
11:55:54.70 process pointer page 177 of 178
11:55:54.74 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:55:59.48 Index 2 (PERF_LOG_UNIT)
11:56:06.00 Index 3 (PERF_LOG_TRN_DESC)
11:56:09.59 Index 4 (PERF_LOG_GDSCODE)
11:56:12.55 Relation 163 (PERF_LOG) is ok

11:56:12.55 Relation 167 (V_STOPTEST)
11:56:12.55 Relation 167 (V_STOPTEST) is ok

11:56:12.55 Relation 184 (V_QDISTR_SOURCE)
11:56:12.55 Relation 184 (V_QDISTR_SOURCE) is ok

11:56:12.55 Relation 185 (V_QSTORNED_SOURCE)
11:56:12.55 Relation 185 (V_QSTORNED_SOURCE) is ok

11:56:12.55 Relation 260 (XQD_1000_1200)
11:56:12.55 process pointer page 0 of 2
11:56:12.61 process pointer page 1 of 2
11:56:12.61 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:56:12.63 Relation 260 (XQD_1000_1200) is ok

11:56:12.63 Relation 261 (XQD_1200_2000)
11:56:12.63 process pointer page 0 of 4
11:56:12.75 process pointer page 1 of 4
11:56:12.85 process pointer page 2 of 4
11:56:12.86 process pointer page 3 of 4
11:56:12.86 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:56:12.89 Relation 261 (XQD_1200_2000) is ok

11:56:12.89 Relation 262 (XQD_1000_3300)
11:56:12.89 process pointer page 0 of 12
11:56:12.99 process pointer page 1 of 12
11:56:13.08 process pointer page 2 of 12
11:56:13.18 process pointer page 3 of 12
11:56:13.25 process pointer page 4 of 12
11:56:13.35 process pointer page 5 of 12
11:56:13.44 process pointer page 6 of 12
11:56:13.53 process pointer page 7 of 12
11:56:13.61 process pointer page 8 of 12
11:56:13.71 process pointer page 9 of 12
11:56:13.80 process pointer page 10 of 12
11:56:13.88 process pointer page 11 of 12
11:56:13.89 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:56:14.38 Index 2 (XQD_1000_3300_DOC)
11:56:14.77 Relation 262 (XQD_1000_3300) is ok

11:56:14.77 Relation 263 (XQD_2000_3300)
11:56:14.77 process pointer page 0 of 21
11:56:14.84 process pointer page 1 of 21
11:56:14.94 process pointer page 2 of 21
11:56:15.03 process pointer page 3 of 21
11:56:15.11 process pointer page 4 of 21
11:56:15.14 process pointer page 5 of 21
11:56:15.20 process pointer page 6 of 21
11:56:15.23 process pointer page 7 of 21
11:56:15.27 process pointer page 8 of 21
11:56:15.33 process pointer page 9 of 21
11:56:15.41 process pointer page 10 of 21
11:56:15.44 process pointer page 11 of 21
11:56:15.48 process pointer page 12 of 21
11:56:15.55 process pointer page 13 of 21
11:56:15.64 process pointer page 14 of 21
11:56:15.72 process pointer page 15 of 21
11:56:15.81 process pointer page 16 of 21
11:56:15.89 process pointer page 17 of 21
11:56:15.98 process pointer page 18 of 21
11:56:16.08 process pointer page 19 of 21
11:56:16.17 process pointer page 20 of 21
11:56:16.20 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:56:16.89 Relation 263 (XQD_2000_3300) is ok

11:56:16.89 Relation 264 (XQD_2100_3300)
11:56:16.89 process pointer page 0 of 16
11:56:16.95 process pointer page 1 of 16
11:56:17.03 process pointer page 2 of 16
11:56:17.09 process pointer page 3 of 16
11:56:17.17 process pointer page 4 of 16
11:56:17.25 process pointer page 5 of 16
11:56:17.31 process pointer page 6 of 16
11:56:17.39 process pointer page 7 of 16
11:56:17.45 process pointer page 8 of 16
11:56:17.53 process pointer page 9 of 16
11:56:17.59 process pointer page 10 of 16
11:56:17.67 process pointer page 11 of 16
11:56:17.75 process pointer page 12 of 16
11:56:17.84 process pointer page 13 of 16
11:56:17.92 process pointer page 14 of 16
11:56:18.01 process pointer page 15 of 16
11:56:18.04 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:56:18.04 Relation 264 (XQD_2100_3300) is ok

11:56:18.04 Relation 265 (XQD_3300_3400)
11:56:18.04 process pointer page 0 of 26
11:56:18.15 process pointer page 1 of 26
11:56:18.26 process pointer page 2 of 26
11:56:18.39 process pointer page 3 of 26
11:56:18.49 process pointer page 4 of 26
11:56:18.60 process pointer page 5 of 26
11:56:18.71 process pointer page 6 of 26
11:56:18.82 process pointer page 7 of 26
11:56:18.93 process pointer page 8 of 26
11:56:19.04 process pointer page 9 of 26
11:56:19.17 process pointer page 10 of 26
11:56:19.27 process pointer page 11 of 26
11:56:19.38 process pointer page 12 of 26
11:56:19.49 process pointer page 13 of 26
11:56:19.62 process pointer page 14 of 26
11:56:19.73 process pointer page 15 of 26
11:56:19.84 process pointer page 16 of 26
11:56:19.95 process pointer page 17 of 26
11:56:20.05 process pointer page 18 of 26
11:56:20.16 process pointer page 19 of 26
11:56:20.27 process pointer page 20 of 26
11:56:20.38 process pointer page 21 of 26
11:56:20.51 process pointer page 22 of 26
11:56:20.60 process pointer page 23 of 26
11:56:20.73 process pointer page 24 of 26
11:56:20.93 process pointer page 25 of 26
11:56:20.94 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:56:22.80 Relation 265 (XQD_3300_3400) is ok

11:56:22.80 Relation 266 (XQS_1000_1200)
11:56:22.80 process pointer page 0 of 46
11:56:23.10 process pointer page 1 of 46
11:56:23.38 process pointer page 2 of 46
11:56:23.66 process pointer page 3 of 46
11:56:23.94 process pointer page 4 of 46
11:56:24.22 process pointer page 5 of 46
11:56:24.52 process pointer page 6 of 46
11:56:24.80 process pointer page 7 of 46
11:56:25.08 process pointer page 8 of 46
11:56:25.37 process pointer page 9 of 46
11:56:25.66 process pointer page 10 of 46
11:56:25.94 process pointer page 11 of 46
11:56:26.23 process pointer page 12 of 46
11:56:26.51 process pointer page 13 of 46
11:56:26.79 process pointer page 14 of 46
11:56:27.09 process pointer page 15 of 46
11:56:27.36 process pointer page 16 of 46
11:56:27.65 process pointer page 17 of 46
11:56:27.90 process pointer page 18 of 46
11:56:28.17 process pointer page 19 of 46
11:56:28.46 process pointer page 20 of 46
11:56:28.78 process pointer page 21 of 46
11:56:29.09 process pointer page 22 of 46
11:56:29.40 process pointer page 23 of 46
11:56:29.71 process pointer page 24 of 46
11:56:30.02 process pointer page 25 of 46
11:56:30.37 process pointer page 26 of 46
11:56:30.69 process pointer page 27 of 46
11:56:31.01 process pointer page 28 of 46
11:56:31.35 process pointer page 29 of 46
11:56:31.69 process pointer page 30 of 46
11:56:32.02 process pointer page 31 of 46
11:56:32.36 process pointer page 32 of 46
11:56:32.72 process pointer page 33 of 46
11:56:33.07 process pointer page 34 of 46
11:56:33.39 process pointer page 35 of 46
11:56:33.70 process pointer page 36 of 46
11:56:34.03 process pointer page 37 of 46
11:56:34.39 process pointer page 38 of 46
11:56:34.73 process pointer page 39 of 46
11:56:35.09 process pointer page 40 of 46
11:56:35.42 process pointer page 41 of 46
11:56:35.78 process pointer page 42 of 46
11:56:36.09 process pointer page 43 of 46
11:56:36.43 process pointer page 44 of 46
11:56:36.78 process pointer page 45 of 46
11:56:37.12 Index 1 (XQS_1000_1200_DOC_ID)
11:56:39.54 Index 2 (XQS_1000_1200_SND_ID)
11:56:42.02 Index 3 (XQS_1000_1200_RCV_ID)
11:56:44.27 Relation 266 (XQS_1000_1200) is ok

11:56:44.27 Relation 267 (XQS_1200_2000)
11:56:44.27 process pointer page 0 of 50
11:56:44.64 process pointer page 1 of 50
11:56:45.01 process pointer page 2 of 50
11:56:45.39 process pointer page 3 of 50
11:56:45.76 process pointer page 4 of 50
11:56:46.11 process pointer page 5 of 50
11:56:46.47 process pointer page 6 of 50
11:56:46.82 process pointer page 7 of 50
11:56:47.20 process pointer page 8 of 50
11:56:47.56 process pointer page 9 of 50
11:56:47.92 process pointer page 10 of 50
11:56:48.28 process pointer page 11 of 50
11:56:48.65 process pointer page 12 of 50
11:56:49.04 process pointer page 13 of 50
11:56:49.49 process pointer page 14 of 50
11:56:49.93 process pointer page 15 of 50
11:56:50.38 process pointer page 16 of 50
11:56:50.83 process pointer page 17 of 50
11:56:51.32 process pointer page 18 of 50
11:56:51.77 process pointer page 19 of 50
11:56:52.21 process pointer page 20 of 50
11:56:52.64 process pointer page 21 of 50
11:56:53.08 process pointer page 22 of 50
11:56:53.53 process pointer page 23 of 50
11:56:53.97 process pointer page 24 of 50
11:56:54.42 process pointer page 25 of 50
11:56:54.84 process pointer page 26 of 50
11:56:55.28 process pointer page 27 of 50
11:56:55.72 process pointer page 28 of 50
11:56:56.14 process pointer page 29 of 50
11:56:56.57 process pointer page 30 of 50
11:56:57.00 process pointer page 31 of 50
11:56:57.42 process pointer page 32 of 50
11:56:57.84 process pointer page 33 of 50
11:56:58.23 process pointer page 34 of 50
11:56:58.65 process pointer page 35 of 50
11:56:59.05 process pointer page 36 of 50
11:56:59.48 process pointer page 37 of 50
11:56:59.88 process pointer page 38 of 50
11:57:00.29 process pointer page 39 of 50
11:57:00.69 process pointer page 40 of 50
11:57:01.11 process pointer page 41 of 50
11:57:01.52 process pointer page 42 of 50
11:57:01.94 process pointer page 43 of 50
11:57:02.38 process pointer page 44 of 50
11:57:02.78 process pointer page 45 of 50
11:57:03.17 process pointer page 46 of 50
11:57:03.56 process pointer page 47 of 50
11:57:03.98 process pointer page 48 of 50
11:57:04.37 process pointer page 49 of 50
11:57:04.55 Index 1 (XQS_1200_2000_DOC_ID)
11:57:07.31 Index 2 (XQS_1200_2000_SND_ID)
11:57:10.41 Index 3 (XQS_1200_2000_RCV_ID)
11:57:13.14 Relation 267 (XQS_1200_2000) is ok

11:57:13.14 Relation 268 (XQS_1000_3300)
11:57:13.14 process pointer page 0 of 24
11:57:13.59 process pointer page 1 of 24
11:57:14.06 process pointer page 2 of 24
11:57:14.50 process pointer page 3 of 24
11:57:14.94 process pointer page 4 of 24
11:57:15.40 process pointer page 5 of 24
11:57:15.89 process pointer page 6 of 24
11:57:16.36 process pointer page 7 of 24
11:57:16.84 process pointer page 8 of 24
11:57:17.32 process pointer page 9 of 24
11:57:17.79 process pointer page 10 of 24
11:57:18.26 process pointer page 11 of 24
11:57:18.71 process pointer page 12 of 24
11:57:19.18 process pointer page 13 of 24
11:57:19.63 process pointer page 14 of 24
11:57:20.08 process pointer page 15 of 24
11:57:20.54 process pointer page 16 of 24
11:57:20.96 process pointer page 17 of 24
11:57:21.41 process pointer page 18 of 24
11:57:21.78 process pointer page 19 of 24
11:57:22.19 process pointer page 20 of 24
11:57:22.56 process pointer page 21 of 24
11:57:22.94 process pointer page 22 of 24
11:57:23.33 process pointer page 23 of 24
11:57:23.50 Index 1 (XQS_1000_3300_DOC_ID)
11:57:24.79 Index 2 (XQS_1000_3300_SND_ID)
11:57:26.34 Index 3 (XQS_1000_3300_RCV_ID)
11:57:27.96 Relation 268 (XQS_1000_3300) is ok

11:57:27.96 Relation 269 (XQS_2000_3300)
11:57:27.96 process pointer page 0 of 1
11:57:27.96 Index 1 (XQS_2000_3300_DOC_ID)
11:57:27.96 Index 2 (XQS_2000_3300_SND_ID)
11:57:27.96 Index 3 (XQS_2000_3300_RCV_ID)
11:57:27.96 Relation 269 (XQS_2000_3300) is ok

11:57:27.96 Relation 270 (XQS_2100_3300)
11:57:27.96 process pointer page 0 of 33
11:57:28.41 process pointer page 1 of 33
11:57:28.84 process pointer page 2 of 33
11:57:29.30 process pointer page 3 of 33
11:57:29.76 process pointer page 4 of 33
11:57:30.19 process pointer page 5 of 33
11:57:30.61 process pointer page 6 of 33
11:57:31.03 process pointer page 7 of 33
11:57:31.46 process pointer page 8 of 33
11:57:31.88 process pointer page 9 of 33
11:57:32.30 process pointer page 10 of 33
11:57:32.72 process pointer page 11 of 33
11:57:33.17 process pointer page 12 of 33
11:57:33.59 process pointer page 13 of 33
11:57:34.03 process pointer page 14 of 33
11:57:34.45 process pointer page 15 of 33
11:57:34.89 process pointer page 16 of 33
11:57:35.32 process pointer page 17 of 33
11:57:35.73 process pointer page 18 of 33
11:57:36.14 process pointer page 19 of 33
11:57:36.54 process pointer page 20 of 33
11:57:36.95 process pointer page 21 of 33
11:57:37.37 process pointer page 22 of 33
11:57:37.79 process pointer page 23 of 33
11:57:38.23 process pointer page 24 of 33
11:57:38.62 process pointer page 25 of 33
11:57:39.02 process pointer page 26 of 33
11:57:39.43 process pointer page 27 of 33
11:57:39.83 process pointer page 28 of 33
11:57:40.22 process pointer page 29 of 33
11:57:40.63 process pointer page 30 of 33
11:57:40.96 process pointer page 31 of 33
11:57:41.30 process pointer page 32 of 33
11:57:41.39 Index 1 (XQS_2100_3300_DOC_ID)
11:57:43.34 Index 2 (XQS_2100_3300_SND_ID)
11:57:45.42 Index 3 (XQS_2100_3300_RCV_ID)
11:57:47.65 Relation 270 (XQS_2100_3300) is ok

11:57:47.65 Relation 271 (XQS_3300_3400)
11:57:47.65 process pointer page 0 of 6
11:57:48.07 process pointer page 1 of 6
11:57:48.46 process pointer page 2 of 6
11:57:48.88 process pointer page 3 of 6
11:57:49.27 process pointer page 4 of 6
11:57:49.69 process pointer page 5 of 6
11:57:49.88 Index 1 (XQS_3300_3400_DOC_ID)
11:57:50.22 Index 2 (XQS_3300_3400_SND_ID)
11:57:50.58 Relation 271 (XQS_3300_3400) is ok

11:57:50.60 Validation finished
Done for 137520 ms, from 11:55:33.22 to 11:57:50.74.

Differences between old and current firebird.log

11:57:52.36. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-05-01 11:57 478 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

Comparison of old and new firebird.log (get messages that appeared during test):

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Mon May 01 11:55:33 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Mon May 01 11:57:50 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.oltp40

Remove 401 logs of every ISQL session if there were no serious errors.

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_.:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND

ISQL logs are removed because no severe errors occured during test.
2017-05-01 11:58:06.57 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html

Performance reports

Differences between old and current firebird.log

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_.: