ISQL Version: WI-V3.0.1.32586 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.1.32586 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.1.32586 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.1.32586 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
 
on disk structure version 12.0
 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		329527 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	329391 
 
Oldest active		329392 
 
Oldest snapshot		329392 
 
Next transaction	329393 
 
Sequence number		0 
 
Next attachment ID	5216 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Dec 11, 2015 13:07:49 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file 
 
 
Analyzing database pages ... 
 
AGENTS (154) 
 
Primary pointer page: 311, Index root page: 312 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.24, total records: 50 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 344.00, compression ratio: 10.05 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 31% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_ID_DESC (2) 
 
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_OUR_FIRM (4) 
 
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 48 
 
Average key length: 2.04, compression ratio: 0.50 
 
Average prefix length: 0.96, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_SUPPLIER (3) 
 
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 45 
 
Average key length: 2.04, compression ratio: 0.53 
 
Average prefix length: 1.02, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_NAME_UNQ (1) 
 
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.92, total dup: 0, max dup: 0 
 
Average key length: 16.60, compression ratio: 0.92 
 
Average prefix length: 1.34, average data length: 13.92 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_AGENTS (0) 
 
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
BUSINESS_OPS (158) 
 
Primary pointer page: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 103.00, total records: 19 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 996.00, compression ratio: 9.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 28% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BO_UNIT_UNQ (1) 
 
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 18.00, total dup: 0, max dup: 0 
 
Average key length: 16.95, compression ratio: 1.25 
 
Average prefix length: 7.21, average data length: 14.00 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BUSINESS_OPS_RND_WGTH (2) 
 
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 4.05, total dup: 7, max dup: 3 
 
Average key length: 3.00, compression ratio: 0.75 
 
Average prefix length: 1.42, average data length: 0.84 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RDB$1 (0) 
 
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 5.26, total dup: 0, max dup: 0 
 
Average key length: 4.21, compression ratio: 0.64 
 
Average prefix length: 1.05, average data length: 1.63 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
DOC_DATA (141) 
 
Primary pointer page: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.29, total records: 1608919 
 
Average version length: 47.92, total versions: 2351, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.35 
 
Pointer pages: 11, data page slots: 17544 
 
Data pages: 17544, average fill: 72% 
 
Primary pages: 17544, secondary pages: 0, swept pages: 10726 
 
Empty pages: 5, full pages: 14823 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 8 
 
40 - 59% = 91 
 
60 - 79% = 17437 
 
80 - 99% = 1 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 19783, depth: 3, leaf buckets: 8136, nodes: 1608919 
 
Average node length: 19.78, total dup: 0, max dup: 0 
 
Average key length: 16.84, compression ratio: 1.60 
 
Average prefix length: 13.15, average data length: 13.85 
 
Clustering factor: 460249, ratio: 0.29 
 
Fill distribution: 
 
0 - 19% = 439 
 
20 - 39% = 2188 
 
40 - 59% = 3604 
 
60 - 79% = 990 
 
80 - 99% = 915 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 46992, depth: 3, leaf buckets: 5892, nodes: 1608919 
 
Average node length: 11.56, total dup: 0, max dup: 0 
 
Average key length: 8.62, compression ratio: 1.04 
 
Average prefix length: 3.38, average data length: 5.62 
 
Clustering factor: 414874, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 3314 
 
40 - 59% = 2464 
 
60 - 79% = 96 
 
80 - 99% = 16 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 142579, depth: 3, leaf buckets: 3074, nodes: 1608919 
 
Average node length: 7.07, total dup: 1112084, max dup: 49 
 
Average key length: 4.13, compression ratio: 2.18 
 
Average prefix length: 7.18, average data length: 1.82 
 
Clustering factor: 422191, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 86 
 
20 - 39% = 1302 
 
40 - 59% = 1144 
 
60 - 79% = 247 
 
80 - 99% = 295 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.30, total records: 546019 
 
Average version length: 36.21, total versions: 1220, max versions: 3 
 
Average fragment length: 15.68, total fragments: 34, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 5, data page slots: 6936 
 
Data pages: 6936, average fill: 75% 
 
Primary pages: 6928, secondary pages: 8, swept pages: 6453 
 
Empty pages: 1, full pages: 6299 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 10 
 
40 - 59% = 39 
 
60 - 79% = 6851 
 
80 - 99% = 24 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 156718, depth: 3, leaf buckets: 2054, nodes: 546019 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.85, compression ratio: 1.02 
 
Average prefix length: 3.14, average data length: 5.86 
 
Clustering factor: 118436, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1205 
 
40 - 59% = 773 
 
60 - 79% = 67 
 
80 - 99% = 8 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2964, depth: 2, leaf buckets: 571, nodes: 546019 
 
Average node length: 4.85, total dup: 545969, max dup: 41219 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 254673, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 483 
 
60 - 79% = 61 
 
80 - 99% = 27 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 228700, depth: 3, leaf buckets: 1761, nodes: 546019 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.85, compression ratio: 1.02 
 
Average prefix length: 3.15, average data length: 5.85 
 
Clustering factor: 118436, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 78 
 
20 - 39% = 848 
 
40 - 59% = 471 
 
60 - 79% = 178 
 
80 - 99% = 186 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 269, Index root page: 270 
 
Total formats: 1, used formats: 1 
 
Average record length: 61.22, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 14.69, total fragments: 365, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.70 
 
Pointer pages: 1, data page slots: 560 
 
Data pages: 28, average fill: 23% 
 
Primary pages: 8, secondary pages: 20, swept pages: 4 
 
Empty pages: 12, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 19 
 
20 - 39% = 3 
 
40 - 59% = 2 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 281, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 262, ratio: 0.66 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 19.50, total records: 1633 
 
Average version length: 71.15, total versions: 1186, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 4.92 
 
Pointer pages: 2, data page slots: 488 
 
Data pages: 112, average fill: 19% 
 
Primary pages: 112, secondary pages: 0, swept pages: 77 
 
Empty pages: 49, full pages: 19 
 
Fill distribution: 
 
0 - 19% = 86 
 
20 - 39% = 1 
 
40 - 59% = 6 
 
60 - 79% = 10 
 
80 - 99% = 9 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 997, depth: 2, leaf buckets: 9, nodes: 1633 
 
Average node length: 17.52, total dup: 35, max dup: 1 
 
Average key length: 15.52, compression ratio: 1.74 
 
Average prefix length: 14.45, average data length: 12.55 
 
Clustering factor: 1442, ratio: 0.88 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 3 
 
40 - 59% = 5 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 261, Index root page: 262 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.08, 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: 272, depth: 1, leaf buckets: 1, nodes: 49 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_TURNOVER_LOG (142) 
 
Primary pointer page: 259, Index root page: 260 
 
Total formats: 1, used formats: 1 
 
Average record length: 12.21, total records: 84 
 
Average version length: 44.10, total versions: 61, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 5.24 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 8, average fill: 12% 
 
Primary pages: 8, secondary pages: 0, swept pages: 7 
 
Empty pages: 5, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 90856, depth: 2, leaf buckets: 1, nodes: 84 
 
Average node length: 9.69, total dup: 54, max dup: 26 
 
Average key length: 7.68, compression ratio: 2.47 
 
Average prefix length: 13.67, average data length: 5.33 
 
Clustering factor: 18, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 2, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_DTS (4) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG (0) 
 
Root page: 359, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (165) 
 
Primary pointer page: 364, Index root page: 365 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_DTS (4) 
 
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_GDSCODE (2) 
 
Root page: 368, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_ROWSET (1) 
 
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.04, total records: 187003 
 
Average version length: 28.11, total versions: 3259, max versions: 6 
 
Average fragment length: 31.80, total fragments: 5, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.52 
 
Pointer pages: 2, data page slots: 2224 
 
Data pages: 2224, average fill: 63% 
 
Primary pages: 2211, secondary pages: 13, swept pages: 2025 
 
Empty pages: 11, full pages: 324 
 
Fill distribution: 
 
0 - 19% = 46 
 
20 - 39% = 130 
 
40 - 59% = 319 
 
60 - 79% = 1712 
 
80 - 99% = 17 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 3600, depth: 2, leaf buckets: 166, nodes: 187003 
 
Average node length: 4.47, total dup: 186954, max dup: 9441 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 33620, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 11 
 
40 - 59% = 59 
 
60 - 79% = 71 
 
80 - 99% = 22 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4281, depth: 2, leaf buckets: 218, nodes: 187003 
 
Average node length: 5.42, total dup: 168608, max dup: 32 
 
Average key length: 2.96, compression ratio: 7.43 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 45353, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 31 
 
40 - 59% = 93 
 
60 - 79% = 71 
 
80 - 99% = 22 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 3974, depth: 2, leaf buckets: 217, nodes: 187003 
 
Average node length: 5.42, total dup: 168608, max dup: 32 
 
Average key length: 2.96, compression ratio: 7.44 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 45386, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 25 
 
40 - 59% = 102 
 
60 - 79% = 60 
 
80 - 99% = 29 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4313, depth: 2, leaf buckets: 213, nodes: 187003 
 
Average node length: 5.21, total dup: 168608, max dup: 32 
 
Average key length: 2.75, compression ratio: 3.28 
 
Average prefix length: 8.35, average data length: 0.65 
 
Clustering factor: 45418, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 32 
 
40 - 59% = 92 
 
60 - 79% = 69 
 
80 - 99% = 19 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.99, total records: 224883 
 
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: 1928 
 
Data pages: 1928, average fill: 64% 
 
Primary pages: 1928, secondary pages: 0, swept pages: 0 
 
Empty pages: 6, full pages: 1921 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1922 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 272672, depth: 2, leaf buckets: 175, nodes: 224883 
 
Average node length: 4.43, total dup: 224711, max dup: 2943 
 
Average key length: 2.00, compression ratio: 1.27 
 
Average prefix length: 2.55, average data length: 0.00 
 
Clustering factor: 12852, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 62 
 
60 - 79% = 61 
 
80 - 99% = 52 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (162) 
 
Primary pointer page: 348, Index root page: 349 
 
Total formats: 2, used formats: 2 
 
Average record length: 148.28, total records: 11124389 
 
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: 1442.63, compression ratio: 9.73 
 
Pointer pages: 160, data page slots: 259672 
 
Data pages: 259672, average fill: 87% 
 
Primary pages: 259672, secondary pages: 0, swept pages: 3 
 
Empty pages: 5, full pages: 259665 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 259665 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 59394, depth: 3, leaf buckets: 12598, nodes: 11124389 
 
Average node length: 5.63, total dup: 10141161, max dup: 158 
 
Average key length: 2.18, compression ratio: 3.67 
 
Average prefix length: 7.85, average data length: 0.14 
 
Clustering factor: 3450391, ratio: 0.31 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 0 
 
40 - 59% = 7412 
 
60 - 79% = 3283 
 
80 - 99% = 1894 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 139384, depth: 3, leaf buckets: 10978, nodes: 11124389 
 
Average node length: 4.52, total dup: 11124384, max dup: 10347237 
 
Average key length: 1.07, compression ratio: 0.33 
 
Average prefix length: 0.35, average data length: 0.00 
 
Clustering factor: 324248, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 10954 
 
60 - 79% = 0 
 
80 - 99% = 24 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43359, depth: 3, leaf buckets: 13343, nodes: 11124389 
 
Average node length: 5.65, total dup: 10837219, max dup: 31997 
 
Average key length: 2.19, compression ratio: 4.10 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 1755021, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 9955 
 
60 - 79% = 1897 
 
80 - 99% = 1488 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 65474, depth: 3, leaf buckets: 13267, nodes: 11124389 
 
Average node length: 5.53, total dup: 11094431, max dup: 1766324 
 
Average key length: 2.07, compression ratio: 18.27 
 
Average prefix length: 37.81, average data length: 0.07 
 
Clustering factor: 5247468, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 1 
 
40 - 59% = 11108 
 
60 - 79% = 556 
 
80 - 99% = 1587 
 
 
PHRASES (145) 
 
Primary pointer page: 265, Index root page: 266 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.93, total records: 320571 
 
Average version length: 55.70, total versions: 1019, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.46 
 
Pointer pages: 3, data page slots: 3840 
 
Data pages: 3840, average fill: 74% 
 
Primary pages: 3840, secondary pages: 0, swept pages: 2597 
 
Empty pages: 5, full pages: 3369 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 8 
 
40 - 59% = 38 
 
60 - 79% = 3779 
 
80 - 99% = 3 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 2296, depth: 2, leaf buckets: 426, nodes: 320571 
 
Average node length: 5.79, total dup: 273689, max dup: 982 
 
Average key length: 3.08, compression ratio: 2.92 
 
Average prefix length: 8.06, average data length: 0.94 
 
Clustering factor: 39429, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 42 
 
40 - 59% = 256 
 
60 - 79% = 96 
 
80 - 99% = 28 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2211, depth: 2, leaf buckets: 353, nodes: 320571 
 
Average node length: 5.57, total dup: 283757, max dup: 98 
 
Average key length: 2.87, compression ratio: 3.14 
 
Average prefix length: 8.25, average data length: 0.75 
 
Clustering factor: 73474, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 8 
 
40 - 59% = 168 
 
60 - 79% = 127 
 
80 - 99% = 50 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 3% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 12.50, total dup: 0, max dup: 0 
 
Average key length: 11.00, compression ratio: 0.82 
 
Average prefix length: 0.50, average data length: 8.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index SEMAPHORES_TASK_UNQ (1) 
 
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 22.50, total dup: 0, max dup: 0 
 
Average key length: 21.00, compression ratio: 1.07 
 
Average prefix length: 4.00, average data length: 18.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SETTINGS (137) 
 
Primary pointer page: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.32, total records: 114 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1347.00, compression ratio: 13.70 
 
Pointer pages: 1, data page slots: 2 
 
Data pages: 2, average fill: 81% 
 
Primary pages: 2, secondary pages: 0, swept pages: 2 
 
Empty pages: 0, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
Index SETTINGS_MODE_CODE (0) 
 
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.07, total dup: 0, max dup: 0 
 
Average key length: 26.06, compression ratio: 1.70 
 
Average prefix length: 21.23, average data length: 23.07 
 
Clustering factor: 6, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$RAND$CALLS (136) 
 
Primary pointer page: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 2, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
 
Root page: 358, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TRACE_STAT (276) 
 
Primary pointer page: 557, Index root page: 68921 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.18, total records: 1775 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.51 
 
Pointer pages: 1, data page slots: 24 
 
Data pages: 24, average fill: 64% 
 
Primary pages: 24, secondary pages: 0, swept pages: 0 
 
Empty pages: 3, full pages: 20 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 20 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 263, Index root page: 264 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.53, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.78 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 77% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 374, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 64 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 273, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 328, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 275, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 328, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400 
 
Average node length: 52.95, total dup: 0, max dup: 0 
 
Average key length: 51.92, compression ratio: 0.99 
 
Average prefix length: 2.65, average data length: 48.95 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 2 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (259) 
 
Primary pointer page: 254, Index root page: 284 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.05, total records: 2566 
 
Average version length: 72.07, total versions: 645, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.52 
 
Pointer pages: 3, data page slots: 1336 
 
Data pages: 160, average fill: 19% 
 
Primary pages: 160, secondary pages: 0, swept pages: 136 
 
Empty pages: 76, full pages: 14 
 
Fill distribution: 
 
0 - 19% = 110 
 
20 - 39% = 17 
 
40 - 59% = 13 
 
60 - 79% = 12 
 
80 - 99% = 8 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1235, depth: 2, leaf buckets: 7, nodes: 2566 
 
Average node length: 7.99, total dup: 2208, max dup: 14 
 
Average key length: 5.56, compression ratio: 6.66 
 
Average prefix length: 33.58, average data length: 3.42 
 
Clustering factor: 375, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 4 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 1 
 
 
XQD_1000_3300 (261) 
 
Primary pointer page: 708, Index root page: 709 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.43, total records: 881745 
 
Average version length: 70.97, total versions: 33586, 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: 9, data page slots: 13568 
 
Data pages: 13560, average fill: 72% 
 
Primary pages: 13560, secondary pages: 0, swept pages: 8910 
 
Empty pages: 70, full pages: 8495 
 
Fill distribution: 
 
0 - 19% = 103 
 
20 - 39% = 75 
 
40 - 59% = 894 
 
60 - 79% = 11997 
 
80 - 99% = 491 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 194613, depth: 3, leaf buckets: 966, nodes: 881745 
 
Average node length: 5.14, total dup: 855728, max dup: 131 
 
Average key length: 2.22, compression ratio: 4.06 
 
Average prefix length: 8.81, average data length: 0.19 
 
Clustering factor: 134807, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 78 
 
40 - 59% = 618 
 
60 - 79% = 67 
 
80 - 99% = 192 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 114934, depth: 3, leaf buckets: 1260, nodes: 881745 
 
Average node length: 6.26, total dup: 768856, max dup: 29 
 
Average key length: 3.34, compression ratio: 11.09 
 
Average prefix length: 35.79, average data length: 1.21 
 
Clustering factor: 202193, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 174 
 
40 - 59% = 786 
 
60 - 79% = 151 
 
80 - 99% = 131 
 
 
XQD_1200_2000 (260) 
 
Primary pointer page: 705, Index root page: 706 
 
Total formats: 1, used formats: 1 
 
Average record length: 11.41, total records: 12968 
 
Average version length: 72.02, total versions: 10920, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 11.92 
 
Pointer pages: 5, data page slots: 4784 
 
Data pages: 1272, average fill: 14% 
 
Primary pages: 1272, secondary pages: 0, swept pages: 839 
 
Empty pages: 820, full pages: 129 
 
Fill distribution: 
 
0 - 19% = 990 
 
20 - 39% = 124 
 
40 - 59% = 23 
 
60 - 79% = 46 
 
80 - 99% = 89 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 31, nodes: 12968 
 
Average node length: 7.03, total dup: 10915, max dup: 43 
 
Average key length: 4.39, compression ratio: 8.43 
 
Average prefix length: 34.77, average data length: 2.23 
 
Clustering factor: 1746, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 17 
 
40 - 59% = 12 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 63.43, total records: 1551285 
 
Average version length: 72.11, total versions: 188333, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.14 
 
Pointer pages: 14, data page slots: 22144 
 
Data pages: 22144, average fill: 78% 
 
Primary pages: 22144, secondary pages: 0, swept pages: 3691 
 
Empty pages: 28, full pages: 21559 
 
Fill distribution: 
 
0 - 19% = 54 
 
20 - 39% = 55 
 
40 - 59% = 88 
 
60 - 79% = 17135 
 
80 - 99% = 4812 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 107353, depth: 3, leaf buckets: 2296, nodes: 1551285 
 
Average node length: 5.50, total dup: 1473913, max dup: 99 
 
Average key length: 2.55, compression ratio: 14.49 
 
Average prefix length: 36.50, average data length: 0.50 
 
Clustering factor: 267677, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 962 
 
40 - 59% = 994 
 
60 - 79% = 175 
 
80 - 99% = 157 
 
 
XQD_2100_3300 (263) 
 
Primary pointer page: 734, Index root page: 735 
 
Total formats: 1, used formats: 1 
 
Average record length: 0.05, total records: 127949 
 
Average version length: 71.84, total versions: 127854, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2566.53 
 
Pointer pages: 3, data page slots: 2424 
 
Data pages: 2408, average fill: 70% 
 
Primary pages: 2407, secondary pages: 1, swept pages: 2 
 
Empty pages: 180, full pages: 1553 
 
Fill distribution: 
 
0 - 19% = 232 
 
20 - 39% = 132 
 
40 - 59% = 258 
 
60 - 79% = 579 
 
80 - 99% = 1207 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1530, depth: 2, leaf buckets: 150, nodes: 127949 
 
Average node length: 5.29, total dup: 119933, max dup: 199 
 
Average key length: 2.77, compression ratio: 13.36 
 
Average prefix length: 36.29, average data length: 0.71 
 
Clustering factor: 13525, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 17 
 
40 - 59% = 76 
 
60 - 79% = 47 
 
80 - 99% = 10 
 
 
XQD_3300_3400 (264) 
 
Primary pointer page: 737, Index root page: 738 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.69, total records: 2158724 
 
Average version length: 71.52, total versions: 58125, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.95 
 
Pointer pages: 19, data page slots: 30464 
 
Data pages: 30464, average fill: 77% 
 
Primary pages: 30464, secondary pages: 0, swept pages: 14101 
 
Empty pages: 6, full pages: 30294 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 7 
 
40 - 59% = 41 
 
60 - 79% = 28728 
 
80 - 99% = 1680 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 41262, depth: 3, leaf buckets: 4608, nodes: 2158724 
 
Average node length: 6.92, total dup: 1732971, max dup: 19 
 
Average key length: 3.95, compression ratio: 9.37 
 
Average prefix length: 35.25, average data length: 1.75 
 
Clustering factor: 441026, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 2691 
 
40 - 59% = 1597 
 
60 - 79% = 165 
 
80 - 99% = 149 
 
 
XQS_1000_1200 (265) 
 
Primary pointer page: 740, Index root page: 741 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.77, total records: 3596105 
 
Average version length: 84.82, total versions: 9985, 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: 35, data page slots: 55512 
 
Data pages: 55512, average fill: 80% 
 
Primary pages: 55512, secondary pages: 0, swept pages: 22626 
 
Empty pages: 0, full pages: 55511 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 20712 
 
80 - 99% = 34799 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54649, depth: 3, leaf buckets: 3733, nodes: 3596105 
 
Average node length: 5.15, total dup: 3513988, max dup: 131 
 
Average key length: 2.17, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 675171, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 118 
 
40 - 59% = 1801 
 
60 - 79% = 1285 
 
80 - 99% = 514 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 78654, depth: 3, leaf buckets: 4255, nodes: 3596105 
 
Average node length: 5.69, total dup: 3214563, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 335272, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 39 
 
20 - 39% = 221 
 
40 - 59% = 2678 
 
60 - 79% = 297 
 
80 - 99% = 1020 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 48486, depth: 3, leaf buckets: 4181, nodes: 3596105 
 
Average node length: 5.79, total dup: 3146461, max dup: 29 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.31, average data length: 0.69 
 
Clustering factor: 724968, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 123 
 
40 - 59% = 2053 
 
60 - 79% = 1391 
 
80 - 99% = 601 
 
 
XQS_1000_3300 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 81.92, total records: 1884843 
 
Average version length: 84.13, total versions: 42456, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.66 
 
Pointer pages: 18, data page slots: 29232 
 
Data pages: 29232, average fill: 80% 
 
Primary pages: 29232, secondary pages: 0, swept pages: 16098 
 
Empty pages: 3, full pages: 29164 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 6 
 
40 - 59% = 15 
 
60 - 79% = 10272 
 
80 - 99% = 18930 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 75516, depth: 3, leaf buckets: 1923, nodes: 1884843 
 
Average node length: 5.14, total dup: 1840789, max dup: 230 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.84, average data length: 0.16 
 
Clustering factor: 373237, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 20 
 
40 - 59% = 984 
 
60 - 79% = 649 
 
80 - 99% = 269 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 94815, depth: 3, leaf buckets: 3072, nodes: 1884843 
 
Average node length: 6.31, total dup: 1520145, max dup: 14 
 
Average key length: 3.35, compression ratio: 2.69 
 
Average prefix length: 7.84, average data length: 1.16 
 
Clustering factor: 196921, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 70 
 
20 - 39% = 1214 
 
40 - 59% = 1035 
 
60 - 79% = 377 
 
80 - 99% = 376 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 65477, depth: 3, leaf buckets: 2170, nodes: 1884843 
 
Average node length: 5.78, total dup: 1652076, max dup: 52 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.31, average data length: 0.69 
 
Clustering factor: 416427, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 20 
 
40 - 59% = 1115 
 
60 - 79% = 733 
 
80 - 99% = 297 
 
 
XQS_1200_2000 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.46, total records: 3912748 
 
Average version length: 85.57, total versions: 79827, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.65 
 
Pointer pages: 38, data page slots: 60584 
 
Data pages: 60576, average fill: 80% 
 
Primary pages: 60576, secondary pages: 0, swept pages: 18889 
 
Empty pages: 18, full pages: 60180 
 
Fill distribution: 
 
0 - 19% = 20 
 
20 - 39% = 52 
 
40 - 59% = 66 
 
60 - 79% = 18380 
 
80 - 99% = 42058 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57323, depth: 3, leaf buckets: 4083, nodes: 3912748 
 
Average node length: 5.03, total dup: 3890336, max dup: 695 
 
Average key length: 2.05, compression ratio: 4.39 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 885378, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 196 
 
40 - 59% = 2176 
 
60 - 79% = 1263 
 
80 - 99% = 444 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 78658, depth: 3, leaf buckets: 5034, nodes: 3912748 
 
Average node length: 5.43, total dup: 3654859, max dup: 49 
 
Average key length: 2.45, compression ratio: 3.67 
 
Average prefix length: 8.61, average data length: 0.39 
 
Clustering factor: 475354, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 75 
 
20 - 39% = 1581 
 
40 - 59% = 2073 
 
60 - 79% = 534 
 
80 - 99% = 771 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49624, depth: 3, leaf buckets: 4557, nodes: 3912748 
 
Average node length: 5.66, total dup: 3512456, max dup: 84 
 
Average key length: 2.68, compression ratio: 3.36 
 
Average prefix length: 8.42, average data length: 0.58 
 
Clustering factor: 932596, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 149 
 
40 - 59% = 2495 
 
60 - 79% = 1360 
 
80 - 99% = 548 
 
 
XQS_2000_3300 (268) 
 
Primary pointer page: 757, Index root page: 758 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 760, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 762, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 761, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (269) 
 
Primary pointer page: 763, Index root page: 764 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.48, total records: 2517334 
 
Average version length: 84.58, total versions: 47460, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.65 
 
Pointer pages: 25, data page slots: 39168 
 
Data pages: 39168, average fill: 80% 
 
Primary pages: 39168, secondary pages: 0, swept pages: 21281 
 
Empty pages: 2, full pages: 39004 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 9 
 
40 - 59% = 41 
 
60 - 79% = 14335 
 
80 - 99% = 24781 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 100238, depth: 3, leaf buckets: 2838, nodes: 2517334 
 
Average node length: 5.02, total dup: 2506207, max dup: 1477 
 
Average key length: 2.04, compression ratio: 4.41 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 482146, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 26 
 
20 - 39% = 405 
 
40 - 59% = 1550 
 
60 - 79% = 587 
 
80 - 99% = 270 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 101532, depth: 3, leaf buckets: 4373, nodes: 2517334 
 
Average node length: 6.31, total dup: 2036541, max dup: 14 
 
Average key length: 3.33, compression ratio: 2.70 
 
Average prefix length: 7.86, average data length: 1.14 
 
Clustering factor: 343782, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 175 
 
20 - 39% = 1995 
 
40 - 59% = 1291 
 
60 - 79% = 443 
 
80 - 99% = 469 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 78028, depth: 3, leaf buckets: 3042, nodes: 2517334 
 
Average node length: 5.48, total dup: 2330474, max dup: 149 
 
Average key length: 2.51, compression ratio: 3.58 
 
Average prefix length: 8.56, average data length: 0.44 
 
Clustering factor: 522484, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 401 
 
40 - 59% = 1565 
 
60 - 79% = 767 
 
80 - 99% = 297 
 
 
XQS_3300_3400 (270) 
 
Primary pointer page: 776, Index root page: 777 
 
Total formats: 1, used formats: 1 
 
Average record length: 68.17, total records: 376189 
 
Average version length: 69.45, total versions: 6914, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.99 
 
Pointer pages: 4, data page slots: 5176 
 
Data pages: 5176, average fill: 77% 
 
Primary pages: 5176, secondary pages: 0, swept pages: 3311 
 
Empty pages: 0, full pages: 5141 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 4 
 
40 - 59% = 10 
 
60 - 79% = 4964 
 
80 - 99% = 197 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 2703, depth: 2, leaf buckets: 452, nodes: 376189 
 
Average node length: 5.37, total dup: 347569, max dup: 157 
 
Average key length: 2.58, compression ratio: 3.49 
 
Average prefix length: 8.49, average data length: 0.51 
 
Clustering factor: 40831, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 101 
 
40 - 59% = 181 
 
60 - 79% = 116 
 
80 - 99% = 53 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 2473, depth: 2, leaf buckets: 504, nodes: 376189 
 
Average node length: 5.92, total dup: 317966, max dup: 29 
 
Average key length: 3.13, compression ratio: 2.88 
 
Average prefix length: 8.03, average data length: 0.97 
 
Clustering factor: 46884, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 111 
 
40 - 59% = 210 
 
60 - 79% = 139 
 
80 - 99% = 44 
 
 
ZDOC_DATA (229) 
 
Primary pointer page: 632, Index root page: 633 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZDOC_LIST (228) 
 
Primary pointer page: 630, Index root page: 631 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (230) 
 
Primary pointer page: 634, Index root page: 635 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPDISTR (233) 
 
Primary pointer page: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPDISTR_ID (0) 
 
Root page: 650, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPSTORNED (234) 
 
Primary pointer page: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPSTORNED_ID (0) 
 
Root page: 651, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQDISTR (231) 
 
Primary pointer page: 636, Index root page: 637 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_ID (0) 
 
Root page: 644, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
 
Root page: 645, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQSTORNED (232) 
 
Primary pointer page: 638, Index root page: 639 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_DOC_ID (1) 
 
Root page: 647, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_ID (0) 
 
Root page: 646, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_RCV_ID (3) 
 
Root page: 649, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_SND_ID (2) 
 
Root page: 648, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_DEP_DOCS (227) 
 
Primary pointer page: 628, Index root page: 629 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (226) 
 
Primary pointer page: 625, Index root page: 626 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Z_USED_VIEWS (146) 
 
Primary pointer page: 267, Index root page: 268 
 
Total formats: 1, used formats: 1 
 
Average record length: 29.38, total records: 29 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 99.00, compression ratio: 3.37 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 16% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index Z_USED_VIEWS_UNQ (0) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 29 
 
Average node length: 15.17, total dup: 0, max dup: 0 
 
Average key length: 14.14, compression ratio: 1.44 
 
Average prefix length: 9.17, average data length: 11.17 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Done for 36960 ms, from  7:42:12.16 to  7:42:49.12. 
 
 
 
| TABLE_NAME | TOTAL_RECS | TOTAL_VERS | VERS_PERCENT | 
| AGENTS | 50 | 0 | 0.0000 | 
| BUSINESS_OPS | 19 | 0 | 0.0000 | 
| DOC_DATA | 1608919 | 2351 | 0.1461 | 
| DOC_LIST | 546019 | 1220 | 0.2234 | 
| DOC_STATES | 4 | 0 | 0.0000 | 
| FB_ERRORS | 758 | 0 | 0.0000 | 
| INVNT_SALDO | 400 | 0 | 0.0000 | 
| INVNT_TURNOVER_LOG | 1633 | 1186 | 72.6270 | 
| MONEY_SALDO | 49 | 0 | 0.0000 | 
| MONEY_TURNOVER_LOG | 84 | 61 | 72.6190 | 
| OPTYPES | 9 | 0 | 0.0000 | 
| PDISTR | 187003 | 3259 | 1.7427 | 
| PERF_ESTIMATED | 224883 | 0 | 0.0000 | 
| PERF_LOG | 11124389 | 0 | 0.0000 | 
| PSTORNED | 320571 | 1019 | 0.3178 | 
| RULES_FOR_PDISTR | 4 | 0 | 0.0000 | 
| RULES_FOR_QDISTR | 7 | 0 | 0.0000 | 
| SEMAPHORES | 4 | 0 | 0.0000 | 
| SETTINGS | 114 | 0 | 0.0000 | 
| TRACE_STAT | 1775 | 0 | 0.0000 | 
| WARES | 400 | 0 | 0.0000 | 
| WARE_GROUPS | 8 | 0 | 0.0000 | 
| XQD_1000_1200 | 2566 | 645 | 25.1363 | 
| XQD_1000_3300 | 881745 | 33586 | 3.8090 | 
| XQD_1200_2000 | 12968 | 10920 | 84.2072 | 
| XQD_2000_3300 | 1551285 | 188333 | 12.1404 | 
| XQD_2100_3300 | 127949 | 127854 | 99.9257 | 
| XQD_3300_3400 | 2158724 | 58125 | 2.6925 | 
| XQS_1000_1200 | 3596105 | 9985 | 0.2776 | 
| XQS_1000_3300 | 1884843 | 42456 | 2.2524 | 
| XQS_1200_2000 | 3912748 | 79827 | 2.0401 | 
| XQS_2100_3300 | 2517334 | 47460 | 1.8853 | 
| XQS_3300_3400 | 376189 | 6914 | 1.8379 | 
| Z_USED_VIEWS | 29 | 0 | 0.0000 | 
 
Done for 2310 ms, from  7:43:00.94 to  7:43:03.25.  
07:43:03.53 Validation started 
 
 
07:43:03.56 Relation 140 (DOC_LIST) 
 
07:43:03.56   process pointer page    0 of    5 
 
07:43:03.67   process pointer page    1 of    5 
 
07:43:03.78   process pointer page    2 of    5 
 
07:43:03.88   process pointer page    3 of    5 
 
07:43:03.97   process pointer page    4 of    5 
 
07:43:04.00 Index 1 (PK_DOC_LIST) 
 
07:43:04.16 Index 2 (DOC_LIST_ID_DESC) 
 
07:43:04.25 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:43:04.33 Relation 140 (DOC_LIST) is ok 
 
 
07:43:04.33 Relation 141 (DOC_DATA) 
 
07:43:04.33   process pointer page    0 of   11 
 
07:43:04.37   process pointer page    1 of   11 
 
07:43:04.47   process pointer page    2 of   11 
 
07:43:04.55   process pointer page    3 of   11 
 
07:43:04.59   process pointer page    4 of   11 
 
07:43:04.66   process pointer page    5 of   11 
 
07:43:04.69   process pointer page    6 of   11 
 
07:43:04.72   process pointer page    7 of   11 
 
07:43:04.76   process pointer page    8 of   11 
 
07:43:04.84   process pointer page    9 of   11 
 
07:43:04.89   process pointer page   10 of   11 
 
07:43:04.91 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:43:05.20 Index 3 (DOC_DATA_ID_DESC) 
 
07:43:05.58 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:43:05.79 Relation 141 (DOC_DATA) is ok 
 
 
07:43:05.79 Relation 147 (INVNT_SALDO) 
 
07:43:05.79   process pointer page    0 of    1 
 
07:43:05.79 Index 1 (PK_INVNT_SALDO) 
 
07:43:05.81 Relation 147 (INVNT_SALDO) is ok 
 
 
07:43:05.81 Relation 150 (PDISTR) 
 
07:43:05.81   process pointer page    0 of    2 
 
07:43:05.89   process pointer page    1 of    2 
 
07:43:05.93 Index 2 (PDISTR_SND_ID) 
 
07:43:06.00 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:43:06.06 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:43:06.11 Index 5 (PDISTR_AGENT_ID) 
 
07:43:06.12 Relation 150 (PDISTR) is ok 
 
 
07:43:06.12 Relation 151 (PSTORNED) 
 
07:43:06.12   process pointer page    0 of    3 
 
07:43:06.17   process pointer page    1 of    3 
 
07:43:06.26   process pointer page    2 of    3 
 
07:43:06.29 Index 2 (PSTORNED_SND_ID) 
 
07:43:06.34 Index 3 (PSTORNED_RCV_ID) 
 
07:43:06.42 Relation 151 (PSTORNED) is ok 
 
 
07:43:06.42 Relation 156 (SEMAPHORES) 
 
07:43:06.42   process pointer page    0 of    1 
 
07:43:06.42 Index 1 (PK_SEMAPHORES) 
 
07:43:06.42 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:43:06.42 Relation 156 (SEMAPHORES) is ok 
 
 
07:43:06.42 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:43:06.42   process pointer page    0 of    2 
 
07:43:06.42   process pointer page    1 of    2 
 
07:43:06.42 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:43:06.42 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:43:06.42 Relation 160 (PERF_ESTIMATED) 
 
07:43:06.42   process pointer page    0 of    2 
 
07:43:06.51   process pointer page    1 of    2 
 
07:43:06.54 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:43:06.59 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:43:06.59 Relation 161 (PERF_ISQL_STAT) 
 
07:43:06.59   process pointer page    0 of    1 
 
07:43:06.59 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:43:06.59 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:43:06.59 Relation 162 (PERF_LOG) 
 
07:43:06.59   process pointer page    0 of  160 
 
07:43:06.67   process pointer page    1 of  160 
 
07:43:06.73   process pointer page    2 of  160 
 
07:43:06.76   process pointer page    3 of  160 
 
07:43:06.79   process pointer page    4 of  160 
 
07:43:06.84   process pointer page    5 of  160 
 
07:43:06.92   process pointer page    6 of  160 
 
07:43:07.00   process pointer page    7 of  160 
 
07:43:07.07   process pointer page    8 of  160 
 
07:43:07.15   process pointer page    9 of  160 
 
07:43:07.23   process pointer page   10 of  160 
 
07:43:07.31   process pointer page   11 of  160 
 
07:43:07.40   process pointer page   12 of  160 
 
07:43:07.48   process pointer page   13 of  160 
 
07:43:07.56   process pointer page   14 of  160 
 
07:43:07.64   process pointer page   15 of  160 
 
07:43:07.70   process pointer page   16 of  160 
 
07:43:07.76   process pointer page   17 of  160 
 
07:43:07.79   process pointer page   18 of  160 
 
07:43:07.82   process pointer page   19 of  160 
 
07:43:07.85   process pointer page   20 of  160 
 
07:43:07.92   process pointer page   21 of  160 
 
07:43:07.99   process pointer page   22 of  160 
 
07:43:08.03   process pointer page   23 of  160 
 
07:43:08.07   process pointer page   24 of  160 
 
07:43:08.15   process pointer page   25 of  160 
 
07:43:08.21   process pointer page   26 of  160 
 
07:43:08.29   process pointer page   27 of  160 
 
07:43:08.37   process pointer page   28 of  160 
 
07:43:08.45   process pointer page   29 of  160 
 
07:43:08.52   process pointer page   30 of  160 
 
07:43:08.60   process pointer page   31 of  160 
 
07:43:08.63   process pointer page   32 of  160 
 
07:43:08.66   process pointer page   33 of  160 
 
07:43:08.70   process pointer page   34 of  160 
 
07:43:08.73   process pointer page   35 of  160 
 
07:43:08.77   process pointer page   36 of  160 
 
07:43:08.85   process pointer page   37 of  160 
 
07:43:08.88   process pointer page   38 of  160 
 
07:43:08.91   process pointer page   39 of  160 
 
07:43:08.95   process pointer page   40 of  160 
 
07:43:08.98   process pointer page   41 of  160 
 
07:43:09.01   process pointer page   42 of  160 
 
07:43:09.02   process pointer page   43 of  160 
 
07:43:09.05   process pointer page   44 of  160 
 
07:43:09.09   process pointer page   45 of  160 
 
07:43:09.10   process pointer page   46 of  160 
 
07:43:09.13   process pointer page   47 of  160 
 
07:43:09.16   process pointer page   48 of  160 
 
07:43:09.24   process pointer page   49 of  160 
 
07:43:09.27   process pointer page   50 of  160 
 
07:43:09.30   process pointer page   51 of  160 
 
07:43:09.37   process pointer page   52 of  160 
 
07:43:09.44   process pointer page   53 of  160 
 
07:43:09.51   process pointer page   54 of  160 
 
07:43:09.54   process pointer page   55 of  160 
 
07:43:09.57   process pointer page   56 of  160 
 
07:43:09.60   process pointer page   57 of  160 
 
07:43:09.63   process pointer page   58 of  160 
 
07:43:09.66   process pointer page   59 of  160 
 
07:43:09.68   process pointer page   60 of  160 
 
07:43:09.73   process pointer page   61 of  160 
 
07:43:09.80   process pointer page   62 of  160 
 
07:43:09.88   process pointer page   63 of  160 
 
07:43:09.93   process pointer page   64 of  160 
 
07:43:09.96   process pointer page   65 of  160 
 
07:43:10.01   process pointer page   66 of  160 
 
07:43:10.04   process pointer page   67 of  160 
 
07:43:10.07   process pointer page   68 of  160 
 
07:43:10.10   process pointer page   69 of  160 
 
07:43:10.13   process pointer page   70 of  160 
 
07:43:10.16   process pointer page   71 of  160 
 
07:43:10.18   process pointer page   72 of  160 
 
07:43:10.21   process pointer page   73 of  160 
 
07:43:10.24   process pointer page   74 of  160 
 
07:43:10.29   process pointer page   75 of  160 
 
07:43:10.37   process pointer page   76 of  160 
 
07:43:10.44   process pointer page   77 of  160 
 
07:43:10.52   process pointer page   78 of  160 
 
07:43:10.60   process pointer page   79 of  160 
 
07:43:10.68   process pointer page   80 of  160 
 
07:43:10.72   process pointer page   81 of  160 
 
07:43:10.76   process pointer page   82 of  160 
 
07:43:10.79   process pointer page   83 of  160 
 
07:43:10.80   process pointer page   84 of  160 
 
07:43:10.83   process pointer page   85 of  160 
 
07:43:10.86   process pointer page   86 of  160 
 
07:43:10.90   process pointer page   87 of  160 
 
07:43:10.93   process pointer page   88 of  160 
 
07:43:10.94   process pointer page   89 of  160 
 
07:43:10.97   process pointer page   90 of  160 
 
07:43:10.99   process pointer page   91 of  160 
 
07:43:11.02   process pointer page   92 of  160 
 
07:43:11.04   process pointer page   93 of  160 
 
07:43:11.07   process pointer page   94 of  160 
 
07:43:11.08   process pointer page   95 of  160 
 
07:43:11.11   process pointer page   96 of  160 
 
07:43:11.13   process pointer page   97 of  160 
 
07:43:11.15   process pointer page   98 of  160 
 
07:43:11.18   process pointer page   99 of  160 
 
07:43:11.19   process pointer page  100 of  160 
 
07:43:11.22   process pointer page  101 of  160 
 
07:43:11.24   process pointer page  102 of  160 
 
07:43:11.25   process pointer page  103 of  160 
 
07:43:11.29   process pointer page  104 of  160 
 
07:43:11.32   process pointer page  105 of  160 
 
07:43:11.38   process pointer page  106 of  160 
 
07:43:11.46   process pointer page  107 of  160 
 
07:43:11.54   process pointer page  108 of  160 
 
07:43:11.63   process pointer page  109 of  160 
 
07:43:11.68   process pointer page  110 of  160 
 
07:43:11.71   process pointer page  111 of  160 
 
07:43:11.77   process pointer page  112 of  160 
 
07:43:11.80   process pointer page  113 of  160 
 
07:43:11.86   process pointer page  114 of  160 
 
07:43:11.94   process pointer page  115 of  160 
 
07:43:12.02   process pointer page  116 of  160 
 
07:43:12.08   process pointer page  117 of  160 
 
07:43:12.10   process pointer page  118 of  160 
 
07:43:12.13   process pointer page  119 of  160 
 
07:43:12.16   process pointer page  120 of  160 
 
07:43:12.19   process pointer page  121 of  160 
 
07:43:12.22   process pointer page  122 of  160 
 
07:43:12.25   process pointer page  123 of  160 
 
07:43:12.27   process pointer page  124 of  160 
 
07:43:12.30   process pointer page  125 of  160 
 
07:43:12.35   process pointer page  126 of  160 
 
07:43:12.42   process pointer page  127 of  160 
 
07:43:12.50   process pointer page  128 of  160 
 
07:43:12.58   process pointer page  129 of  160 
 
07:43:12.66   process pointer page  130 of  160 
 
07:43:12.69   process pointer page  131 of  160 
 
07:43:12.72   process pointer page  132 of  160 
 
07:43:12.74   process pointer page  133 of  160 
 
07:43:12.77   process pointer page  134 of  160 
 
07:43:12.80   process pointer page  135 of  160 
 
07:43:12.83   process pointer page  136 of  160 
 
07:43:12.86   process pointer page  137 of  160 
 
07:43:12.88   process pointer page  138 of  160 
 
07:43:12.91   process pointer page  139 of  160 
 
07:43:12.94   process pointer page  140 of  160 
 
07:43:12.95   process pointer page  141 of  160 
 
07:43:12.99   process pointer page  142 of  160 
 
07:43:13.00   process pointer page  143 of  160 
 
07:43:13.06   process pointer page  144 of  160 
 
07:43:13.11   process pointer page  145 of  160 
 
07:43:13.14   process pointer page  146 of  160 
 
07:43:13.17   process pointer page  147 of  160 
 
07:43:13.20   process pointer page  148 of  160 
 
07:43:13.24   process pointer page  149 of  160 
 
07:43:13.28   process pointer page  150 of  160 
 
07:43:13.36   process pointer page  151 of  160 
 
07:43:13.44   process pointer page  152 of  160 
 
07:43:13.50   process pointer page  153 of  160 
 
07:43:13.58   process pointer page  154 of  160 
 
07:43:13.66   process pointer page  155 of  160 
 
07:43:13.69   process pointer page  156 of  160 
 
07:43:13.72   process pointer page  157 of  160 
 
07:43:13.75   process pointer page  158 of  160 
 
07:43:13.78   process pointer page  159 of  160 
 
07:43:13.78 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:43:16.18 Index 2 (PERF_LOG_UNIT) 
 
07:43:19.01 Index 3 (PERF_LOG_TRN_DESC) 
 
07:43:20.88 Index 4 (PERF_LOG_GDSCODE) 
 
07:43:21.99 Relation 162 (PERF_LOG) is ok 
 
 
07:43:21.99 Relation 166 (V_STOPTEST) 
 
07:43:21.99 Relation 166 (V_STOPTEST) is ok 
 
 
07:43:21.99 Relation 183 (V_QDISTR_SOURCE) 
 
07:43:21.99 Relation 183 (V_QDISTR_SOURCE) is ok 
 
 
07:43:21.99 Relation 184 (V_QSTORNED_SOURCE) 
 
07:43:21.99 Relation 184 (V_QSTORNED_SOURCE) is ok 
 
 
07:43:22.00 Relation 259 (XQD_1000_1200) 
 
07:43:22.00   process pointer page    0 of    3 
 
07:43:22.00   process pointer page    1 of    3 
 
07:43:22.00   process pointer page    2 of    3 
 
07:43:22.00 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:43:22.02 Relation 259 (XQD_1000_1200) is ok 
 
 
07:43:22.02 Relation 260 (XQD_1200_2000) 
 
07:43:22.02   process pointer page    0 of    5 
 
07:43:22.05   process pointer page    1 of    5 
 
07:43:22.07   process pointer page    2 of    5 
 
07:43:22.07   process pointer page    3 of    5 
 
07:43:22.08   process pointer page    4 of    5 
 
07:43:22.08 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:43:22.08 Relation 260 (XQD_1200_2000) is ok 
 
 
07:43:22.08 Relation 261 (XQD_1000_3300) 
 
07:43:22.08   process pointer page    0 of    9 
 
07:43:22.17   process pointer page    1 of    9 
 
07:43:22.25   process pointer page    2 of    9 
 
07:43:22.31   process pointer page    3 of    9 
 
07:43:22.36   process pointer page    4 of    9 
 
07:43:22.39   process pointer page    5 of    9 
 
07:43:22.47   process pointer page    6 of    9 
 
07:43:22.56   process pointer page    7 of    9 
 
07:43:22.66   process pointer page    8 of    9 
 
07:43:22.67 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:43:22.81 Index 2 (XQD_1000_3300_DOC) 
 
07:43:23.02 Relation 261 (XQD_1000_3300) is ok 
 
 
07:43:23.02 Relation 262 (XQD_2000_3300) 
 
07:43:23.02   process pointer page    0 of   14 
 
07:43:23.13   process pointer page    1 of   14 
 
07:43:23.24   process pointer page    2 of   14 
 
07:43:23.38   process pointer page    3 of   14 
 
07:43:23.50   process pointer page    4 of   14 
 
07:43:23.55   process pointer page    5 of   14 
 
07:43:23.59   process pointer page    6 of   14 
 
07:43:23.67   process pointer page    7 of   14 
 
07:43:23.75   process pointer page    8 of   14 
 
07:43:23.80   process pointer page    9 of   14 
 
07:43:23.83   process pointer page   10 of   14 
 
07:43:23.87   process pointer page   11 of   14 
 
07:43:23.91   process pointer page   12 of   14 
 
07:43:23.95   process pointer page   13 of   14 
 
07:43:23.97 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:43:24.12 Relation 262 (XQD_2000_3300) is ok 
 
 
07:43:24.12 Relation 263 (XQD_2100_3300) 
 
07:43:24.12   process pointer page    0 of    3 
 
07:43:24.19   process pointer page    1 of    3 
 
07:43:24.22   process pointer page    2 of    3 
 
07:43:24.22 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:43:24.23 Relation 263 (XQD_2100_3300) is ok 
 
 
07:43:24.23 Relation 264 (XQD_3300_3400) 
 
07:43:24.23   process pointer page    0 of   19 
 
07:43:24.33   process pointer page    1 of   19 
 
07:43:24.39   process pointer page    2 of   19 
 
07:43:24.42   process pointer page    3 of   19 
 
07:43:24.47   process pointer page    4 of   19 
 
07:43:24.51   process pointer page    5 of   19 
 
07:43:24.61   process pointer page    6 of   19 
 
07:43:24.65   process pointer page    7 of   19 
 
07:43:24.70   process pointer page    8 of   19 
 
07:43:24.73   process pointer page    9 of   19 
 
07:43:24.78   process pointer page   10 of   19 
 
07:43:24.84   process pointer page   11 of   19 
 
07:43:24.94   process pointer page   12 of   19 
 
07:43:24.97   process pointer page   13 of   19 
 
07:43:25.01   process pointer page   14 of   19 
 
07:43:25.06   process pointer page   15 of   19 
 
07:43:25.09   process pointer page   16 of   19 
 
07:43:25.19   process pointer page   17 of   19 
 
07:43:25.25   process pointer page   18 of   19 
 
07:43:25.31 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:43:25.65 Relation 264 (XQD_3300_3400) is ok 
 
 
07:43:25.65 Relation 265 (XQS_1000_1200) 
 
07:43:25.65   process pointer page    0 of   35 
 
07:43:25.75   process pointer page    1 of   35 
 
07:43:25.86   process pointer page    2 of   35 
 
07:43:25.97   process pointer page    3 of   35 
 
07:43:26.06   process pointer page    4 of   35 
 
07:43:26.09   process pointer page    5 of   35 
 
07:43:26.20   process pointer page    6 of   35 
 
07:43:26.25   process pointer page    7 of   35 
 
07:43:26.28   process pointer page    8 of   35 
 
07:43:26.32   process pointer page    9 of   35 
 
07:43:26.36   process pointer page   10 of   35 
 
07:43:26.39   process pointer page   11 of   35 
 
07:43:26.43   process pointer page   12 of   35 
 
07:43:26.46   process pointer page   13 of   35 
 
07:43:26.50   process pointer page   14 of   35 
 
07:43:26.53   process pointer page   15 of   35 
 
07:43:26.56   process pointer page   16 of   35 
 
07:43:26.57   process pointer page   17 of   35 
 
07:43:26.60   process pointer page   18 of   35 
 
07:43:26.65   process pointer page   19 of   35 
 
07:43:26.73   process pointer page   20 of   35 
 
07:43:26.82   process pointer page   21 of   35 
 
07:43:26.92   process pointer page   22 of   35 
 
07:43:26.96   process pointer page   23 of   35 
 
07:43:26.99   process pointer page   24 of   35 
 
07:43:27.04   process pointer page   25 of   35 
 
07:43:27.07   process pointer page   26 of   35 
 
07:43:27.10   process pointer page   27 of   35 
 
07:43:27.14   process pointer page   28 of   35 
 
07:43:27.17   process pointer page   29 of   35 
 
07:43:27.21   process pointer page   30 of   35 
 
07:43:27.24   process pointer page   31 of   35 
 
07:43:27.34   process pointer page   32 of   35 
 
07:43:27.40   process pointer page   33 of   35 
 
07:43:27.43   process pointer page   34 of   35 
 
07:43:27.43 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:43:28.06 Index 2 (XQS_1000_1200_SND_ID) 
 
07:43:28.76 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:43:29.51 Relation 265 (XQS_1000_1200) is ok 
 
 
07:43:29.51 Relation 266 (XQS_1200_2000) 
 
07:43:29.51   process pointer page    0 of   38 
 
07:43:29.62   process pointer page    1 of   38 
 
07:43:29.71   process pointer page    2 of   38 
 
07:43:29.82   process pointer page    3 of   38 
 
07:43:29.93   process pointer page    4 of   38 
 
07:43:30.02   process pointer page    5 of   38 
 
07:43:30.08   process pointer page    6 of   38 
 
07:43:30.15   process pointer page    7 of   38 
 
07:43:30.24   process pointer page    8 of   38 
 
07:43:30.33   process pointer page    9 of   38 
 
07:43:30.41   process pointer page   10 of   38 
 
07:43:30.46   process pointer page   11 of   38 
 
07:43:30.49   process pointer page   12 of   38 
 
07:43:30.54   process pointer page   13 of   38 
 
07:43:30.57   process pointer page   14 of   38 
 
07:43:30.63   process pointer page   15 of   38 
 
07:43:30.68   process pointer page   16 of   38 
 
07:43:30.75   process pointer page   17 of   38 
 
07:43:30.86   process pointer page   18 of   38 
 
07:43:30.97   process pointer page   19 of   38 
 
07:43:31.07   process pointer page   20 of   38 
 
07:43:31.11   process pointer page   21 of   38 
 
07:43:31.14   process pointer page   22 of   38 
 
07:43:31.19   process pointer page   23 of   38 
 
07:43:31.22   process pointer page   24 of   38 
 
07:43:31.27   process pointer page   25 of   38 
 
07:43:31.30   process pointer page   26 of   38 
 
07:43:31.39   process pointer page   27 of   38 
 
07:43:31.44   process pointer page   28 of   38 
 
07:43:31.49   process pointer page   29 of   38 
 
07:43:31.52   process pointer page   30 of   38 
 
07:43:31.57   process pointer page   31 of   38 
 
07:43:31.60   process pointer page   32 of   38 
 
07:43:31.63   process pointer page   33 of   38 
 
07:43:31.67   process pointer page   34 of   38 
 
07:43:31.71   process pointer page   35 of   38 
 
07:43:31.83   process pointer page   36 of   38 
 
07:43:31.91   process pointer page   37 of   38 
 
07:43:31.92 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:43:32.78 Index 2 (XQS_1200_2000_SND_ID) 
 
07:43:33.91 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:43:34.64 Relation 266 (XQS_1200_2000) is ok 
 
 
07:43:34.64 Relation 267 (XQS_1000_3300) 
 
07:43:34.64   process pointer page    0 of   18 
 
07:43:34.72   process pointer page    1 of   18 
 
07:43:34.78   process pointer page    2 of   18 
 
07:43:34.86   process pointer page    3 of   18 
 
07:43:34.90   process pointer page    4 of   18 
 
07:43:34.98   process pointer page    5 of   18 
 
07:43:35.09   process pointer page    6 of   18 
 
07:43:35.18   process pointer page    7 of   18 
 
07:43:35.25   process pointer page    8 of   18 
 
07:43:35.33   process pointer page    9 of   18 
 
07:43:35.39   process pointer page   10 of   18 
 
07:43:35.43   process pointer page   11 of   18 
 
07:43:35.51   process pointer page   12 of   18 
 
07:43:35.56   process pointer page   13 of   18 
 
07:43:35.61   process pointer page   14 of   18 
 
07:43:35.64   process pointer page   15 of   18 
 
07:43:35.68   process pointer page   16 of   18 
 
07:43:35.72   process pointer page   17 of   18 
 
07:43:35.75 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:43:36.09 Index 2 (XQS_1000_3300_SND_ID) 
 
07:43:36.71 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:43:37.10 Relation 267 (XQS_1000_3300) is ok 
 
 
07:43:37.10 Relation 268 (XQS_2000_3300) 
 
07:43:37.10   process pointer page    0 of    1 
 
07:43:37.10 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:43:37.10 Index 2 (XQS_2000_3300_SND_ID) 
 
07:43:37.10 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:43:37.10 Relation 268 (XQS_2000_3300) is ok 
 
 
07:43:37.10 Relation 269 (XQS_2100_3300) 
 
07:43:37.10   process pointer page    0 of   25 
 
07:43:37.13   process pointer page    1 of   25 
 
07:43:37.23   process pointer page    2 of   25 
 
07:43:37.28   process pointer page    3 of   25 
 
07:43:37.37   process pointer page    4 of   25 
 
07:43:37.43   process pointer page    5 of   25 
 
07:43:37.48   process pointer page    6 of   25 
 
07:43:37.51   process pointer page    7 of   25 
 
07:43:37.57   process pointer page    8 of   25 
 
07:43:37.68   process pointer page    9 of   25 
 
07:43:37.73   process pointer page   10 of   25 
 
07:43:37.77   process pointer page   11 of   25 
 
07:43:37.85   process pointer page   12 of   25 
 
07:43:37.95   process pointer page   13 of   25 
 
07:43:38.06   process pointer page   14 of   25 
 
07:43:38.16   process pointer page   15 of   25 
 
07:43:38.26   process pointer page   16 of   25 
 
07:43:38.30   process pointer page   17 of   25 
 
07:43:38.34   process pointer page   18 of   25 
 
07:43:38.38   process pointer page   19 of   25 
 
07:43:38.43   process pointer page   20 of   25 
 
07:43:38.46   process pointer page   21 of   25 
 
07:43:38.49   process pointer page   22 of   25 
 
07:43:38.54   process pointer page   23 of   25 
 
07:43:38.62   process pointer page   24 of   25 
 
07:43:38.62 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:43:39.16 Index 2 (XQS_2100_3300_SND_ID) 
 
07:43:39.52 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:43:40.16 Relation 269 (XQS_2100_3300) is ok 
 
 
07:43:40.16 Relation 270 (XQS_3300_3400) 
 
07:43:40.16   process pointer page    0 of    4 
 
07:43:40.27   process pointer page    1 of    4 
 
07:43:40.30   process pointer page    2 of    4 
 
07:43:40.35   process pointer page    3 of    4 
 
07:43:40.35 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:43:40.40 Index 2 (XQS_3300_3400_SND_ID) 
 
07:43:40.44 Relation 270 (XQS_3300_3400) is ok 
 
 
07:43:40.44 Relation 276 (TRACE_STAT) 
 
07:43:40.44   process pointer page    0 of    1 
 
07:43:40.44 Relation 276 (TRACE_STAT) is ok 
 
 
07:43:40.44 Validation finished 
 
Done for 37470 ms, from  7:43:03.27 to  7:43:40.74. 
 
 Differences between old and current firebird.log 
7:43:57.04. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2016-09-03  07:43               504 oltp30_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Sat Sep 03 07:43:03 2016 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Sat Sep 03 07:43:40 2016 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 401 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*: 
 
 
| ERRORS_CHECKING_RESULT | 
| NO_SEVERE_ERRORS_FOUND | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2016-09-03  7:44:16.85 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html