en
brTests
Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 10. 2016-01-19 3:56:56.94.
Server implementation: Firebird/x86-64/Windows NT
Done for 68480 ms, from 3:58:14.88 to 3:59:23.36.
Done for 134460 ms, from 4:01:33.19 to 4:03:47.65.
Done for 10450 ms, from 4:03:48.62 to 4:03:59.07.
Done for 8790 ms, from 4:04:00.26 to 4:04:09.05.
Done for 206740 ms, from 4:07:32.93 to 4:10:59.67.
Done for 5110 ms, from 4:11:03.52 to 4:11:08.63.
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 194160
MON$OLDEST_ACTIVE 194161
MON$OLDEST_SNAPSHOT 194161
MON$NEXT_TRANSACTION 194161
MON$PAGE_BUFFERS 384
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 10:02:47.3010
MON$PAGES 691641
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26963 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26963 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26963 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26963 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2
Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 198833
Page size 8192
ODS version 11.2
Oldest transaction 194162
Oldest active 194163
Oldest snapshot 194163
Next transaction 194164
Bumped transaction 1
Sequence number 0
Next attachment ID 4660
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 33.64, total records: 1381235
Average version length: 47.37, total versions: 395265, max versions: 1
Data pages: 14893, data page slots: 14893, average fill: 78%
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 8
60 - 79% = 9768
80 - 99% = 5111
Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 5690, nodes: 1381235
Average data length: 14.21, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 647
20 - 39% = 2
40 - 59% = 3207
60 - 79% = 17
80 - 99% = 1817
Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 3954, nodes: 1381235
Average data length: 5.65, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 3951
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 1924, nodes: 1381235
Average data length: 2.00, total dup: 921010, max dup: 49
Fill distribution:
0 - 19% = 164
20 - 39% = 0
40 - 59% = 1033
60 - 79% = 0
80 - 99% = 727
DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 57.54, total records: 324410
Average version length: 36.44, total versions: 40527, max versions: 3
Data pages: 4089, data page slots: 4089, average fill: 79%
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 6
60 - 79% = 3127
80 - 99% = 950
Index DOC_LIST_ID_DESC (1)
Depth: 3, leaf buckets: 1166, nodes: 324410
Average data length: 6.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 530
40 - 59% = 612
60 - 79% = 24
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 354, nodes: 324410
Average data length: 0.01, total dup: 324360, max dup: 35359
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 296
60 - 79% = 33
80 - 99% = 25
Index PK_DOC_LIST (0)
Depth: 3, leaf buckets: 920, nodes: 324410
Average data length: 6.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 146
20 - 39% = 198
40 - 59% = 237
60 - 79% = 117
80 - 99% = 222
DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 64.20, total records: 400
Average version length: 14.54, total versions: 208742, max versions: 1444
Data pages: 993, data page slots: 993, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 21
60 - 79% = 372
80 - 99% = 599
Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 1.08, total records: 11583
Average version length: 71.22, total versions: 11407, max versions: 1
Data pages: 295, data page slots: 355, average fill: 53%
Fill distribution:
0 - 19% = 3
20 - 39% = 81
40 - 59% = 105
60 - 79% = 76
80 - 99% = 30
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 56, nodes: 11583
Average data length: 9.01, total dup: 469, max dup: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 39
40 - 59% = 16
60 - 79% = 1
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 15.24, total records: 49
Average version length: 9.01, total versions: 3789, max versions: 1848
Data pages: 14, data page slots: 14, average fill: 88%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 13
Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 4.22, total records: 669
Average version length: 46.18, total versions: 608, max versions: 1
Data pages: 8, data page slots: 8, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 1, leaf buckets: 1, nodes: 669
Average data length: 1.23, total dup: 604, max dup: 152
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
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: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 40.62, total records: 118072
Average version length: 38.01, total versions: 11452, max versions: 5
Data pages: 1277, data page slots: 1277, average fill: 72%
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 31
60 - 79% = 1210
80 - 99% = 23
Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 101, nodes: 118072
Average data length: 0.01, total dup: 118023, max dup: 5052
Fill distribution:
0 - 19% = 2
20 - 39% = 10
40 - 59% = 42
60 - 79% = 30
80 - 99% = 17
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 129, nodes: 118072
Average data length: 0.88, total dup: 106461, max dup: 53
Fill distribution:
0 - 19% = 2
20 - 39% = 24
40 - 59% = 47
60 - 79% = 31
80 - 99% = 25
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 130, nodes: 118072
Average data length: 0.88, total dup: 106461, max dup: 53
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 59
60 - 79% = 38
80 - 99% = 12
Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 138, nodes: 118072
Average data length: 0.67, total dup: 106461, max dup: 53
Fill distribution:
0 - 19% = 1
20 - 39% = 36
40 - 59% = 59
60 - 79% = 36
80 - 99% = 6
PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.96, total records: 118179
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 1010, data page slots: 1010, average fill: 64%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1009
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 82, nodes: 118179
Average data length: 0.00, total dup: 117988, max dup: 1440
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 23
60 - 79% = 34
80 - 99% = 25
PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 151.52, total records: 10210617
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 242153, data page slots: 242153, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 242153
Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 10739, nodes: 10210617
Average data length: 0.18, total dup: 8907398, max dup: 75
Fill distribution:
0 - 19% = 15
20 - 39% = 0
40 - 59% = 4575
60 - 79% = 3798
80 - 99% = 2351
Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 11235, nodes: 10210617
Average data length: 0.00, total dup: 10210612, max dup: 9950395
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11233
60 - 79% = 0
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 12574, nodes: 10210617
Average data length: 0.11, total dup: 10041541, max dup: 28355
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 10157
60 - 79% = 1315
80 - 99% = 1101
Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 12843, nodes: 10210617
Average data length: 0.07, total dup: 10189737, max dup: 1339405
Fill distribution:
0 - 19% = 13
20 - 39% = 1
40 - 59% = 11510
60 - 79% = 355
80 - 99% = 964
PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 42.04, total records: 247314
Average version length: 57.39, total versions: 63799, max versions: 1
Data pages: 2942, data page slots: 2942, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 5
60 - 79% = 1729
80 - 99% = 1207
Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 275, nodes: 247314
Average data length: 0.95, total dup: 211645, max dup: 1090
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 136
60 - 79% = 99
80 - 99% = 39
Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 241, nodes: 247314
Average data length: 0.57, total dup: 226359, max dup: 150
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 81
60 - 79% = 111
80 - 99% = 49
RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 5498, max versions: 3436
Data pages: 19, data page slots: 19, average fill: 92%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 19
Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 97.51, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
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: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 59.52, total records: 11907
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 147, data page slots: 147, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 146
80 - 99% = 0
WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 5.06, total records: 10712
Average version length: 72.19, total versions: 9964, max versions: 1
Data pages: 212, data page slots: 327, average fill: 67%
Fill distribution:
0 - 19% = 29
20 - 39% = 32
40 - 59% = 16
60 - 79% = 15
80 - 99% = 120
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 22, nodes: 10712
Average data length: 2.03, total dup: 9372, max dup: 14
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 7
60 - 79% = 1
80 - 99% = 0
XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 68.16, total records: 454475
Average version length: 71.79, total versions: 25115, max versions: 1
Data pages: 6551, data page slots: 6551, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 121
60 - 79% = 5797
80 - 99% = 621
Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 443, nodes: 454475
Average data length: 0.24, total dup: 437683, max dup: 120
Fill distribution:
0 - 19% = 2
20 - 39% = 117
40 - 59% = 118
60 - 79% = 27
80 - 99% = 179
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 570, nodes: 454475
Average data length: 1.25, total dup: 394740, max dup: 29
Fill distribution:
0 - 19% = 14
20 - 39% = 52
40 - 59% = 217
60 - 79% = 142
80 - 99% = 145
XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 41.03, total records: 105865
Average version length: 71.82, total versions: 45659, max versions: 1
Data pages: 1985, data page slots: 2810, average fill: 64%
Fill distribution:
0 - 19% = 86
20 - 39% = 91
40 - 59% = 442
60 - 79% = 1032
80 - 99% = 334
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 171, nodes: 105865
Average data length: 1.58, total dup: 89300, max dup: 43
Fill distribution:
0 - 19% = 2
20 - 39% = 44
40 - 59% = 99
60 - 79% = 21
80 - 99% = 5
XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 11.54, total records: 4855526
Average version length: 70.94, total versions: 4079230, max versions: 1
Data pages: 67097, data page slots: 67097, average fill: 91%
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 8827
80 - 99% = 58267
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 6264, nodes: 4855526
Average data length: 0.61, total dup: 4555550, max dup: 99
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 5976
60 - 79% = 141
80 - 99% = 146
XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 0.12, total records: 11007
Average version length: 71.55, total versions: 10988, max versions: 1
Data pages: 242, data page slots: 811, average fill: 61%
Fill distribution:
0 - 19% = 48
20 - 39% = 31
40 - 59% = 24
60 - 79% = 32
80 - 99% = 107
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 19, nodes: 11007
Average data length: 1.43, total dup: 10222, max dup: 93
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 7
60 - 79% = 2
80 - 99% = 0
XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 30.51, total records: 2754358
Average version length: 70.42, total versions: 1572722, max versions: 1
Data pages: 37869, data page slots: 37882, average fill: 87%
Fill distribution:
0 - 19% = 14
20 - 39% = 14
40 - 59% = 33
60 - 79% = 4636
80 - 99% = 33172
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 4210, nodes: 2754358
Average data length: 1.65, total dup: 2251899, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 3911
60 - 79% = 158
80 - 99% = 139
XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 77.77, total records: 2296201
Average version length: 83.33, total versions: 155328, max versions: 1
Data pages: 34797, data page slots: 34797, average fill: 82%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6294
80 - 99% = 28503
Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 2518, nodes: 2296201
Average data length: 0.15, total dup: 2244988, max dup: 217
Fill distribution:
0 - 19% = 12
20 - 39% = 1
40 - 59% = 1734
60 - 79% = 646
80 - 99% = 125
Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 1729, nodes: 2296201
Average data length: 0.68, total dup: 2015317, max dup: 49
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 137
60 - 79% = 7
80 - 99% = 1582
Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 2841, nodes: 2296201
Average data length: 0.69, total dup: 2014141, max dup: 44
Fill distribution:
0 - 19% = 25
20 - 39% = 0
40 - 59% = 1940
60 - 79% = 747
80 - 99% = 129
XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 41.51, total records: 2372447
Average version length: 82.87, total versions: 1187755, max versions: 1
Data pages: 35942, data page slots: 35948, average fill: 88%
Fill distribution:
0 - 19% = 14
20 - 39% = 12
40 - 59% = 27
60 - 79% = 1433
80 - 99% = 34456
Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2198, nodes: 2372447
Average data length: 0.09, total dup: 2341988, max dup: 582
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 807
60 - 79% = 883
80 - 99% = 503
Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2428, nodes: 2372447
Average data length: 1.10, total dup: 1939704, max dup: 14
Fill distribution:
0 - 19% = 129
20 - 39% = 1
40 - 59% = 822
60 - 79% = 2
80 - 99% = 1474
Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 2380, nodes: 2372447
Average data length: 0.39, total dup: 2212858, max dup: 133
Fill distribution:
0 - 19% = 35
20 - 39% = 0
40 - 59% = 868
60 - 79% = 940
80 - 99% = 537
XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 38.09, total records: 4824654
Average version length: 84.43, total versions: 2626276, max versions: 1
Data pages: 73378, data page slots: 73378, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 6915
80 - 99% = 66462
Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 4507, nodes: 4824654
Average data length: 0.03, total dup: 4810967, max dup: 3350
Fill distribution:
0 - 19% = 9
20 - 39% = 21
40 - 59% = 1870
60 - 79% = 1641
80 - 99% = 966
Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 3803, nodes: 4824654
Average data length: 0.35, total dup: 4520402, max dup: 49
Fill distribution:
0 - 19% = 11
20 - 39% = 2
40 - 59% = 867
60 - 79% = 153
80 - 99% = 2770
Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 4803, nodes: 4824654
Average data length: 0.32, total dup: 4547987, max dup: 384
Fill distribution:
0 - 19% = 8
20 - 39% = 13
40 - 59% = 1905
60 - 79% = 1869
80 - 99% = 1008
XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 44.69, total records: 2651531
Average version length: 83.18, total versions: 1229468, max versions: 1
Data pages: 40195, data page slots: 40203, average fill: 87%
Fill distribution:
0 - 19% = 13
20 - 39% = 18
40 - 59% = 32
60 - 79% = 1606
80 - 99% = 38526
Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2615, nodes: 2651531
Average data length: 0.03, total dup: 2643106, max dup: 1972
Fill distribution:
0 - 19% = 11
20 - 39% = 29
40 - 59% = 1414
60 - 79% = 672
80 - 99% = 489
Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2845, nodes: 2651531
Average data length: 1.10, total dup: 2168943, max dup: 14
Fill distribution:
0 - 19% = 133
20 - 39% = 84
40 - 59% = 980
60 - 79% = 116
80 - 99% = 1532
Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 2865, nodes: 2651531
Average data length: 0.38, total dup: 2478584, max dup: 117
Fill distribution:
0 - 19% = 5
20 - 39% = 28
40 - 59% = 1617
60 - 79% = 748
80 - 99% = 467
XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 40.76, total records: 406220
Average version length: 68.76, total versions: 165793, max versions: 1
Data pages: 5488, data page slots: 5488, average fill: 84%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1670
80 - 99% = 3817
Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 391, nodes: 406220
Average data length: 0.39, total dup: 383079, max dup: 167
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 157
60 - 79% = 145
80 - 99% = 89
Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 447, nodes: 406220
Average data length: 0.91, total dup: 347855, max dup: 27
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 180
60 - 79% = 181
80 - 99% = 84
ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 26090 ms, from 4:11:09.43 to 4:11:35.52.
Done for 2650 ms, from 4:11:42.46 to 4:11:45.11.
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 5 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-01-19 04:12 309 oltp25_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
result: files match. No new messages appeared in firebird.log during test ran.
+++ End of comparison +++
Remove 32 logs of every ISQL session if there were no serious errors.
ISQL logs are removed because no severe errors occured during test.
2016-01-19 4:12:26.27 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html
| Common | Performance | Final Results |
|---|---|---|
Server and database settings
Server version: WI-V2.5.6.26963 Firebird 2.5Server implementation: Firebird/x86-64/Windows NT
| FB_ARCHITECTURE | DB_NAME | FORCED_WRITES | SWEEP_INT | PAGE_BUFFERS | PAGE_SIZE |
|---|---|---|---|---|---|
| Classic 2.5.6 | D:\OLTP-EMUL\OLTP25-SMALL.FDB | ON | 0 | 384 | 8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp25_config.win| PARAM_NAME | PARAM_VALUE |
|---|---|
| fbc | E:\FB25.TMPINSTANCE\bin\ |
| dbnm | D:\OLTP-EMUL\oltp25-small.fdb |
| host | localhost |
| port | 3255 |
| usr | SYSDBA |
| pwd | masterke |
| tmpdir | e:\temp\logs.oltp25 |
| working_mode | small_03 |
| warm_time | 10 |
| test_time | 180 |
| idle_time | 0 |
| use_mtee | 0 |
| is_embed | 0 |
| remove_isql_logs | if_no_severe_errors |
| no_auto_undo | 1 |
| detailed_info | 0 |
| mon_unit_perf | 0 |
| trc_unit_perf | 1 |
| init_buff | 32768 |
| create_with_fw | sync |
| create_with_sweep | 0 |
| wait_if_not_exists | 0 |
| wait_after_create | 0 |
| init_docs | 0 |
| wait_for_copy | 0 |
| create_with_debug_objects | 1 |
| create_with_split_heavy_tabs | 1 |
| create_with_separate_qdistr_idx | 0 |
| create_with_compound_columns_order | most_selective_first |
| make_html | 1 |
| run_db_statistics | 1 |
| run_db_validation | 1 |
| file_name_with_test_params | regular |
| upload_report | 1 |
Test finish info
| FINISH_STATE | DTS_END | FB_GDSCODE | FB_MNEMONA | STACK | IP | TRN_ID | ATT_ID | EXC_UNIT |
|---|---|---|---|---|---|---|---|---|
| NORMAL: TEST_TIME EXPIRED. | 2016-01-19 03:55:47.3420 | -1 | <null> | 127.0.0.1 | 193984 | 4612 | 2 |
Current test settings
| CATEGORY | SETTING | VAL |
|---|---|---|
| COMMON | TRACED_UNITS | ,, |
| COMMON | ENABLE_MON_QUERY | 0 |
| COMMON | HALT_TEST_ON_ERRORS | ,CK, |
| COMMON | LOG_PK_VIOLATION | 0 |
| COMMON | QMISM_VERIFY_BITSET | 1 |
| COMMON | RECALC_IDX_MIN_INTERVAL | 15 |
| COMMON | ENABLE_RESERVES_WHEN_ADD_INVOICE | 1 |
| COMMON | ORDER_FOR_OUR_FIRM_PERCENT | 25 |
| COMMON | ENABLE_FILL_PHRASES | 0 |
| COMMON | RANDOM_SEEK_VIA_ROWS_LIMIT | 0 |
| COMMON | C_INVOICE_MIN_PURCHASE | 1000 |
| COMMON | C_INVOICE_MAX_PURCHASE | 2000 |
| COMMON | C_INVOICE_MIN_PROFIT_PRC | 35 |
| COMMON | C_INVOICE_MAX_PROFIT_PRC | 80 |
| COMMON | C_MIN_COST_TO_BE_SPLITTED | 1000 |
| COMMON | C_ROWS_TO_MULTIPLY | 10 |
| COMMON | C_PAYMENT_FROM_CLIENT_MIN_TOTAL | 1000 |
| COMMON | C_PAYMENT_FROM_CLIENT_MAX_TOTAL | 5000 |
| COMMON | C_PAYMENT_TO_SUPPLIER_MIN_TOTAL | 2000 |
| COMMON | C_PAYMENT_TO_SUPPLIER_MAX_TOTAL | 15000 |
| COMMON | BUILD_WITH_SPLIT_HEAVY_TABS | 1 |
| COMMON | BUILD_WITH_SEPAR_QDISTR_IDX | 0 |
| COMMON | BUILD_WITH_QD_COMPOUND_ORDR | MOST_SELECTIVE_FIRST |
| SMALL_03 | C_WARES_MAX_ID | 400 |
| SMALL_03 | C_CUSTOMER_DOC_MAX_ROWS | 10 |
| SMALL_03 | C_SUPPLIER_DOC_MAX_ROWS | 50 |
| SMALL_03 | C_CUSTOMER_DOC_MAX_QTY | 15 |
| SMALL_03 | C_SUPPLIER_DOC_MAX_QTY | 50 |
| SMALL_03 | C_NUMBER_OF_AGENTS | 50 |
Index(es) for heavy-loaded table(s)
| TAB_NAME | IDX_NAME | IDX_KEY |
|---|---|---|
| XQD_1000_1200 | XQD_1000_1200_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_1000_3300 | XQD_1000_3300_DOC | DOC_ID |
| XQD_1000_3300 | XQD_1000_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_1200_2000 | XQD_1200_2000_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_2000_3300 | XQD_2000_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_2100_3300 | XQD_2100_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_3300_3400 | XQD_3300_3400_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
Performance reports
Performance in TOTAL:
| ACTION | AVG_TIMES_PER_MINUTE | AVG_ELAPSED_MS | SUCCESSFUL_TIMES_DONE | JOB_BEG | JOB_END |
|---|---|---|---|---|---|
| *** OVERALL *** for 180 minutes: | 10436.43 | 1732 | 1878557 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| customer order: creation | 185.86 | 71 | 33454 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| customer order: refuse | 14.44 | 44 | 2600 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| order to supplier: creation | 48.76 | 247 | 8777 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| order to supplier: removal | 1.47 | 15885 | 260 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| invoice (draft): creation | 46.84 | 522 | 8432 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| invoice (draft): removal | 27.36 | 135 | 4925 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| invoice accept: apply | 26.74 | 11966 | 4814 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| invoice accept: cancel | 12.58 | 602 | 2239 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| customer reserve: creation | 8796.93 | 30 | 1583448 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| customer reserve: removal | 1005.40 | 17 | 178962 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| realization accept: apply | 86.68 | 67 | 15602 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| realization accept: cancel | 40.73 | 35 | 7290 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| payment from customer: creation | 62.49 | 99 | 11186 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| payment from customer: removal | 5.85 | 31 | 1053 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| payment to supplier: creation | 52.72 | 110 | 9490 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| payment to supplier: removal | 3.50 | 35 | 619 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| service: total inventory turnovers | 18.13 | 182 | 3263 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| service: total monetary turnovers | 11.84 | 5 | 2132 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| service: refresh index statistics | 0.07 | 2818 | 11 | 2016-01-19 00:55 | 2016-01-19 03:55 |
Performance in DYNAMIC:
| ACTION | ITRV_NO | CNT_OK_PER_MINUTE | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | ITRV_BEG | ITRV_END |
|---|---|---|---|---|---|---|---|---|
| interval # 1, overall | 1 | 7484 | 139129 | 134720 | 4409 | 3.17 | 00:55:48 | 01:13:48 |
| interval # 2, overall | 2 | 9507 | 174633 | 171132 | 3501 | 2.00 | 01:13:49 | 01:31:49 |
| interval # 3, overall | 3 | 7618 | 140120 | 137118 | 3002 | 2.14 | 01:31:50 | 01:49:50 |
| interval # 4, overall | 4 | 10337 | 191695 | 186071 | 5624 | 2.93 | 01:49:51 | 02:07:51 |
| interval # 5, overall | 5 | 11829 | 214326 | 212929 | 1397 | 0.65 | 02:07:52 | 02:25:52 |
| interval # 6, overall | 6 | 11723 | 218649 | 211008 | 7641 | 3.49 | 02:25:53 | 02:43:53 |
| interval # 7, overall | 7 | 11908 | 218053 | 214347 | 3706 | 1.70 | 02:43:54 | 03:01:54 |
| interval # 8, overall | 8 | 11205 | 206887 | 201685 | 5202 | 2.51 | 03:01:55 | 03:19:55 |
| interval # 9, overall | 9 | 11793 | 212712 | 212276 | 436 | 0.20 | 03:19:56 | 03:37:56 |
| interval # 10, overall | 10 | 10960 | 197668 | 197271 | 397 | 0.20 | 03:37:57 | 03:55:57 |
Performance for every MINUTE:
| TEST_PHASE | MINUTE_SINCE_TEST_START | AVG_ESTIMATED | MIN_TO_AVG_RATIO | MAX_TO_AVG_RATIO | ROWS_AGGREGATED | DISTINCT_ATTACHMENTS |
|---|---|---|---|---|---|---|
| WARM_TIME | 1 | 1566.00 | 0.2407 | 1.6232 | 1441 | 10 |
| WARM_TIME | 2 | 1437.62 | 0.8844 | 1.0917 | 425 | 4 |
| WARM_TIME | 3 | 1172.55 | 0.9142 | 1.0379 | 126 | 3 |
| WARM_TIME | 4 | 1030.76 | 0.8857 | 1.0759 | 121 | 4 |
| WARM_TIME | 5 | 1075.45 | 0.8584 | 1.1065 | 465 | 6 |
| WARM_TIME | 6 | 1105.65 | 0.8970 | 1.1227 | 403 | 8 |
| WARM_TIME | 7 | 1203.90 | 0.8839 | 1.0978 | 584 | 8 |
| WARM_TIME | 8 | 1447.33 | 0.7991 | 1.1902 | 877 | 10 |
| WARM_TIME | 9 | 1933.71 | 0.7919 | 1.1595 | 1212 | 10 |
| WARM_TIME | 10 | 2269.36 | 0.8893 | 1.1323 | 598 | 10 |
| TEST_TIME | 11 | 2390.71 | 0.9848 | 1.0052 | 101 | 5 |
| TEST_TIME | 12 | 2376.05 | 0.9271 | 1.0647 | 383 | 9 |
| TEST_TIME | 13 | 2640.27 | 0.8908 | 1.1223 | 825 | 10 |
| TEST_TIME | 14 | 2933.72 | 0.9379 | 1.1061 | 719 | 10 |
| TEST_TIME | 15 | 3287.05 | 0.9214 | 1.0919 | 673 | 10 |
| TEST_TIME | 16 | 3548.16 | 0.9483 | 1.0364 | 427 | 10 |
| TEST_TIME | 17 | 3611.42 | 0.9583 | 1.0401 | 513 | 9 |
| TEST_TIME | 18 | 3846.71 | 0.9235 | 1.0684 | 704 | 10 |
| TEST_TIME | 19 | 4089.72 | 0.9520 | 1.0400 | 577 | 10 |
| TEST_TIME | 20 | 4223.18 | 0.9568 | 1.0371 | 606 | 10 |
| TEST_TIME | 21 | 4363.79 | 0.9579 | 1.0443 | 797 | 10 |
| TEST_TIME | 22 | 4502.86 | 0.9661 | 1.0373 | 700 | 10 |
| TEST_TIME | 23 | 4686.49 | 0.9533 | 1.0478 | 760 | 10 |
| TEST_TIME | 24 | 4813.12 | 0.9777 | 1.0226 | 544 | 10 |
| TEST_TIME | 25 | 4834.67 | 0.9788 | 1.0277 | 345 | 10 |
| TEST_TIME | 26 | 5049.30 | 0.9475 | 1.0451 | 788 | 10 |
| TEST_TIME | 27 | 5271.07 | 0.9640 | 1.0393 | 939 | 10 |
| TEST_TIME | 28 | 5531.37 | 0.9550 | 1.0495 | 801 | 10 |
| TEST_TIME | 29 | 5733.45 | 0.9776 | 1.0270 | 767 | 10 |
| TEST_TIME | 30 | 5896.73 | 0.9653 | 1.0276 | 757 | 10 |
| TEST_TIME | 31 | 5966.02 | 0.9829 | 1.0180 | 716 | 10 |
| TEST_TIME | 32 | 6087.49 | 0.9665 | 1.0384 | 722 | 10 |
| TEST_TIME | 33 | 6318.19 | 0.9702 | 1.0246 | 728 | 10 |
| TEST_TIME | 34 | 6469.35 | 0.9712 | 1.0238 | 722 | 10 |
| TEST_TIME | 35 | 6563.26 | 0.9803 | 1.0176 | 559 | 10 |
| TEST_TIME | 36 | 6560.06 | 0.9902 | 1.0080 | 460 | 9 |
| TEST_TIME | 37 | 6547.07 | 0.9827 | 1.0218 | 750 | 10 |
| TEST_TIME | 38 | 6683.66 | 0.9746 | 1.0261 | 619 | 10 |
| TEST_TIME | 39 | 6835.85 | 0.9775 | 1.0169 | 616 | 10 |
| TEST_TIME | 40 | 6904.40 | 0.9816 | 1.0149 | 602 | 10 |
| TEST_TIME | 41 | 6867.66 | 0.9955 | 1.0029 | 147 | 7 |
| TEST_TIME | 42 | 6882.65 | 0.9768 | 1.0216 | 971 | 10 |
| TEST_TIME | 43 | 6982.28 | 0.9836 | 1.0196 | 644 | 10 |
| TEST_TIME | 44 | 7095.74 | 0.9813 | 1.0146 | 771 | 10 |
| TEST_TIME | 45 | 7073.37 | 0.9959 | 1.0061 | 287 | 7 |
| TEST_TIME | 46 | 7105.16 | 0.9798 | 1.0175 | 673 | 10 |
| TEST_TIME | 47 | 7212.35 | 0.9811 | 1.0160 | 892 | 10 |
| TEST_TIME | 48 | 7280.59 | 0.9855 | 1.0124 | 873 | 10 |
| TEST_TIME | 49 | 7355.65 | 0.9816 | 1.0133 | 842 | 10 |
| TEST_TIME | 50 | 7370.05 | 0.9911 | 1.0131 | 627 | 10 |
| TEST_TIME | 51 | 7412.65 | 0.9875 | 1.0146 | 657 | 10 |
| TEST_TIME | 52 | 7494.40 | 0.9842 | 1.0080 | 793 | 10 |
| TEST_TIME | 53 | 7536.42 | 0.9835 | 1.0107 | 822 | 10 |
| TEST_TIME | 54 | 7537.24 | 0.9919 | 1.0106 | 700 | 10 |
| TEST_TIME | 55 | 7490.67 | 0.9984 | 1.0008 | 76 | 3 |
| TEST_TIME | 56 | 7398.99 | 0.9957 | 1.0031 | 340 | 7 |
| TEST_TIME | 57 | 7402.50 | 0.9853 | 1.0125 | 1106 | 10 |
| TEST_TIME | 58 | 7424.66 | 0.9921 | 1.0051 | 474 | 10 |
| TEST_TIME | 59 | 7378.18 | 0.9949 | 1.0073 | 454 | 9 |
| TEST_TIME | 60 | 7413.12 | 0.9858 | 1.0114 | 833 | 10 |
| TEST_TIME | 61 | 7406.33 | 0.9957 | 1.0037 | 415 | 8 |
| TEST_TIME | 62 | 7327.61 | 0.9985 | 1.0011 | 131 | 3 |
| TEST_TIME | 63 | 7231.37 | 0.9993 | 1.0020 | 23 | 3 |
| TEST_TIME | 64 | 7247.30 | 0.9850 | 1.0116 | 1150 | 10 |
| TEST_TIME | 65 | 7309.25 | 0.9876 | 1.0112 | 1008 | 10 |
| TEST_TIME | 66 | 7350.99 | 0.9902 | 1.0121 | 683 | 10 |
| TEST_TIME | 67 | 7431.64 | 0.9862 | 1.0111 | 731 | 9 |
| TEST_TIME | 68 | 7474.32 | 0.9906 | 1.0091 | 789 | 9 |
| TEST_TIME | 69 | 7492.72 | 0.9920 | 1.0071 | 724 | 10 |
| TEST_TIME | 70 | 7521.91 | 0.9888 | 1.0109 | 759 | 10 |
| TEST_TIME | 71 | 7595.86 | 0.9869 | 1.0121 | 992 | 10 |
| TEST_TIME | 72 | 7662.17 | 0.9894 | 1.0089 | 731 | 10 |
| TEST_TIME | 73 | 7702.70 | 0.9899 | 1.0128 | 835 | 10 |
| TEST_TIME | 74 | 7766.95 | 0.9909 | 1.0100 | 894 | 10 |
| TEST_TIME | 75 | 7825.28 | 0.9891 | 1.0093 | 788 | 10 |
| TEST_TIME | 76 | 7853.11 | 0.9925 | 1.0079 | 750 | 10 |
| TEST_TIME | 77 | 7868.01 | 0.9929 | 1.0100 | 698 | 10 |
| TEST_TIME | 78 | 7869.14 | 0.9969 | 1.0018 | 278 | 8 |
| TEST_TIME | 79 | 7833.27 | 0.9940 | 1.0076 | 451 | 9 |
| TEST_TIME | 80 | 7819.65 | 0.9967 | 1.0072 | 497 | 10 |
| TEST_TIME | 81 | 7853.11 | 0.9905 | 1.0066 | 562 | 10 |
| TEST_TIME | 82 | 7892.37 | 0.9894 | 1.0079 | 472 | 9 |
| TEST_TIME | 83 | 7939.61 | 0.9898 | 1.0104 | 549 | 10 |
| TEST_TIME | 84 | 8020.77 | 0.9883 | 1.0071 | 631 | 10 |
| TEST_TIME | 85 | 8041.39 | 0.9927 | 1.0066 | 611 | 10 |
| TEST_TIME | 86 | 8095.29 | 0.9883 | 1.0084 | 758 | 10 |
| TEST_TIME | 87 | 8149.15 | 0.9903 | 1.0091 | 617 | 10 |
| TEST_TIME | 88 | 8196.79 | 0.9919 | 1.0111 | 660 | 10 |
| TEST_TIME | 89 | 8275.46 | 0.9902 | 1.0066 | 705 | 10 |
| TEST_TIME | 90 | 8307.11 | 0.9916 | 1.0080 | 601 | 10 |
| TEST_TIME | 91 | 8349.19 | 0.9919 | 1.0089 | 652 | 10 |
| TEST_TIME | 92 | 8382.96 | 0.9939 | 1.0077 | 638 | 10 |
| TEST_TIME | 93 | 8429.42 | 0.9914 | 1.0057 | 588 | 10 |
| TEST_TIME | 94 | 8455.50 | 0.9919 | 1.0069 | 530 | 10 |
| TEST_TIME | 95 | 8489.20 | 0.9923 | 1.0082 | 536 | 10 |
| TEST_TIME | 96 | 8505.83 | 0.9958 | 1.0031 | 716 | 10 |
| TEST_TIME | 97 | 8516.32 | 0.9916 | 1.0068 | 552 | 10 |
| TEST_TIME | 98 | 8544.70 | 0.9932 | 1.0065 | 517 | 9 |
| TEST_TIME | 99 | 8574.08 | 0.9929 | 1.0063 | 546 | 9 |
| TEST_TIME | 100 | 8613.47 | 0.9917 | 1.0052 | 557 | 10 |
| TEST_TIME | 101 | 8652.20 | 0.9908 | 1.0076 | 792 | 10 |
| TEST_TIME | 102 | 8692.34 | 0.9931 | 1.0086 | 860 | 10 |
| TEST_TIME | 103 | 8752.52 | 0.9919 | 1.0073 | 776 | 10 |
| TEST_TIME | 104 | 8789.33 | 0.9934 | 1.0070 | 685 | 10 |
| TEST_TIME | 105 | 8809.87 | 0.9950 | 1.0059 | 799 | 10 |
| TEST_TIME | 106 | 8856.30 | 0.9912 | 1.0075 | 600 | 10 |
| TEST_TIME | 107 | 8882.80 | 0.9951 | 1.0079 | 650 | 10 |
| TEST_TIME | 108 | 8925.75 | 0.9937 | 1.0070 | 469 | 10 |
| TEST_TIME | 109 | 8964.92 | 0.9935 | 1.0049 | 693 | 9 |
| TEST_TIME | 110 | 8982.89 | 0.9938 | 1.0063 | 616 | 10 |
| TEST_TIME | 111 | 8990.58 | 0.9964 | 1.0065 | 584 | 10 |
| TEST_TIME | 112 | 9020.03 | 0.9943 | 1.0057 | 583 | 9 |
| TEST_TIME | 113 | 9043.74 | 0.9942 | 1.0044 | 535 | 10 |
| TEST_TIME | 114 | 9045.29 | 0.9954 | 1.0042 | 369 | 10 |
| TEST_TIME | 115 | 9032.45 | 0.9968 | 1.0058 | 302 | 9 |
| TEST_TIME | 116 | 9056.52 | 0.9952 | 1.0060 | 713 | 10 |
| TEST_TIME | 117 | 9088.63 | 0.9939 | 1.0045 | 538 | 10 |
| TEST_TIME | 118 | 9096.22 | 0.9952 | 1.0047 | 848 | 9 |
| TEST_TIME | 119 | 9110.39 | 0.9947 | 1.0045 | 629 | 10 |
| TEST_TIME | 120 | 9143.93 | 0.9925 | 1.0072 | 590 | 10 |
| TEST_TIME | 121 | 9191.47 | 0.9937 | 1.0069 | 456 | 10 |
| TEST_TIME | 122 | 9212.58 | 0.9964 | 1.0027 | 518 | 10 |
| TEST_TIME | 123 | 9194.11 | 0.9968 | 1.0049 | 410 | 10 |
| TEST_TIME | 124 | 9217.31 | 0.9943 | 1.0047 | 611 | 9 |
| TEST_TIME | 125 | 9225.76 | 0.9958 | 1.0067 | 647 | 10 |
| TEST_TIME | 126 | 9253.26 | 0.9958 | 1.0038 | 577 | 9 |
| TEST_TIME | 127 | 9257.26 | 0.9954 | 1.0044 | 645 | 9 |
| TEST_TIME | 128 | 9260.95 | 0.9961 | 1.0043 | 551 | 10 |
| TEST_TIME | 129 | 9291.88 | 0.9932 | 1.0044 | 601 | 10 |
| TEST_TIME | 130 | 9300.94 | 0.9957 | 1.0062 | 451 | 10 |
| TEST_TIME | 131 | 9332.35 | 0.9952 | 1.0036 | 969 | 10 |
| TEST_TIME | 132 | 9351.84 | 0.9939 | 1.0045 | 645 | 10 |
| TEST_TIME | 133 | 9383.12 | 0.9936 | 1.0051 | 716 | 10 |
| TEST_TIME | 134 | 9395.01 | 0.9963 | 1.0043 | 775 | 9 |
| TEST_TIME | 135 | 9400.05 | 0.9963 | 1.0052 | 524 | 10 |
| TEST_TIME | 136 | 9431.43 | 0.9945 | 1.0065 | 552 | 10 |
| TEST_TIME | 137 | 9467.35 | 0.9954 | 1.0033 | 599 | 10 |
| TEST_TIME | 138 | 9477.91 | 0.9949 | 1.0041 | 590 | 10 |
| TEST_TIME | 139 | 9486.00 | 0.9961 | 1.0036 | 620 | 10 |
| TEST_TIME | 140 | 9490.97 | 0.9959 | 1.0027 | 711 | 10 |
| TEST_TIME | 141 | 9483.73 | 0.9963 | 1.0040 | 655 | 10 |
| TEST_TIME | 142 | 9488.78 | 0.9964 | 1.0051 | 634 | 10 |
| TEST_TIME | 143 | 9510.95 | 0.9958 | 1.0035 | 576 | 10 |
| TEST_TIME | 144 | 9497.06 | 0.9980 | 1.0043 | 565 | 10 |
| TEST_TIME | 145 | 9503.24 | 0.9968 | 1.0039 | 504 | 10 |
| TEST_TIME | 146 | 9515.76 | 0.9957 | 1.0047 | 611 | 10 |
| TEST_TIME | 147 | 9543.75 | 0.9949 | 1.0041 | 570 | 10 |
| TEST_TIME | 148 | 9563.19 | 0.9953 | 1.0041 | 747 | 10 |
| TEST_TIME | 149 | 9571.71 | 0.9964 | 1.0035 | 779 | 10 |
| TEST_TIME | 150 | 9587.21 | 0.9952 | 1.0053 | 575 | 10 |
| TEST_TIME | 151 | 9624.89 | 0.9948 | 1.0040 | 576 | 10 |
| TEST_TIME | 152 | 9647.75 | 0.9950 | 1.0047 | 531 | 10 |
| TEST_TIME | 153 | 9660.21 | 0.9968 | 1.0040 | 676 | 10 |
| TEST_TIME | 154 | 9669.30 | 0.9965 | 1.0035 | 725 | 10 |
| TEST_TIME | 155 | 9668.97 | 0.9971 | 1.0027 | 678 | 10 |
| TEST_TIME | 156 | 9659.07 | 0.9973 | 1.0031 | 653 | 9 |
| TEST_TIME | 157 | 9666.97 | 0.9959 | 1.0032 | 559 | 10 |
| TEST_TIME | 158 | 9665.61 | 0.9969 | 1.0034 | 505 | 10 |
| TEST_TIME | 159 | 9681.26 | 0.9955 | 1.0033 | 480 | 10 |
| TEST_TIME | 160 | 9698.34 | 0.9953 | 1.0034 | 510 | 10 |
| TEST_TIME | 161 | 9714.99 | 0.9957 | 1.0042 | 532 | 10 |
| TEST_TIME | 162 | 9739.49 | 0.9955 | 1.0031 | 806 | 9 |
| TEST_TIME | 163 | 9756.84 | 0.9951 | 1.0052 | 501 | 10 |
| TEST_TIME | 164 | 9790.23 | 0.9954 | 1.0038 | 628 | 10 |
| TEST_TIME | 165 | 9800.33 | 0.9967 | 1.0043 | 622 | 10 |
| TEST_TIME | 166 | 9808.86 | 0.9974 | 1.0027 | 662 | 9 |
| TEST_TIME | 167 | 9827.92 | 0.9948 | 1.0033 | 739 | 10 |
| TEST_TIME | 168 | 9838.86 | 0.9962 | 1.0029 | 706 | 10 |
| TEST_TIME | 169 | 9846.03 | 0.9962 | 1.0031 | 573 | 10 |
| TEST_TIME | 170 | 9847.65 | 0.9971 | 1.0035 | 574 | 10 |
| TEST_TIME | 171 | 9878.66 | 0.9945 | 1.0039 | 445 | 10 |
| TEST_TIME | 172 | 9881.47 | 0.9977 | 1.0028 | 572 | 9 |
| TEST_TIME | 173 | 9888.22 | 0.9964 | 1.0043 | 401 | 10 |
| TEST_TIME | 174 | 9918.64 | 0.9955 | 1.0023 | 489 | 10 |
| TEST_TIME | 175 | 9910.48 | 0.9974 | 1.0026 | 450 | 9 |
| TEST_TIME | 176 | 9941.94 | 0.9937 | 1.0040 | 628 | 10 |
| TEST_TIME | 177 | 9962.48 | 0.9962 | 1.0030 | 743 | 10 |
| TEST_TIME | 178 | 9977.87 | 0.9958 | 1.0040 | 644 | 10 |
| TEST_TIME | 179 | 9986.84 | 0.9975 | 1.0026 | 708 | 9 |
| TEST_TIME | 180 | 9989.52 | 0.9968 | 1.0033 | 621 | 10 |
| TEST_TIME | 181 | 9994.95 | 0.9972 | 1.0028 | 577 | 9 |
| TEST_TIME | 182 | 10011.82 | 0.9956 | 1.0031 | 543 | 10 |
| TEST_TIME | 183 | 10023.01 | 0.9965 | 1.0032 | 544 | 10 |
| TEST_TIME | 184 | 10020.03 | 0.9980 | 1.0026 | 370 | 10 |
| TEST_TIME | 185 | 10007.78 | 0.9984 | 1.0017 | 435 | 8 |
| TEST_TIME | 186 | 10007.09 | 0.9966 | 1.0023 | 309 | 9 |
| TEST_TIME | 187 | 10000.74 | 0.9976 | 1.0022 | 659 | 10 |
| TEST_TIME | 188 | 9998.59 | 0.9971 | 1.0020 | 640 | 10 |
| TEST_TIME | 189 | 10003.49 | 0.9962 | 1.0033 | 567 | 10 |
| TEST_TIME | 190 | 9998.41 | 0.9985 | 1.0025 | 427 | 10 |
Performance from TRACE for ISQL instance #1:
| TRACED_DATA | ITRV_NO | SP_CLIENT_ORDER | SP_CANCEL_CLIENT_ORDER | SP_SUPPLIER_ORDER | SP_CANCEL_SUPPLIER_ORDER | SP_SUPPLIER_INVOICE | SP_CANCEL_SUPPLIER_INVOICE | SP_ADD_INVOICE_TO_STOCK | SP_CANCEL_ADDING_INVOICE | SP_CUSTOMER_RESERVE | SP_CANCEL_CUSTOMER_RESERVE | SP_RESERVE_WRITE_OFF | SP_CANCEL_WRITE_OFF | SP_PAY_FROM_CUSTOMER | SP_CANCEL_PAY_FROM_CUSTOMER | SP_PAY_TO_SUPPLIER | SP_CANCEL_PAY_TO_SUPPLIER | SRV_MAKE_INVNT_SALDO | SRV_MAKE_MONEY_SALDO | SRV_RECALC_IDX_STAT | ITRV_BEG | ITRV_END |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fetches per second | 1 | 36765 | 60186 | 55237 | 97948 | 72435 | 70807 | 93066 | 47760 | 31832 | 34604 | 51850 | 31430 | 71941 | 49495 | 219717 | 70919 | 482273 | 441570 | <null> | 00:55:48 | 01:13:48 |
| fetches per second | 2 | 34989 | 58150 | 52508 | 54847 | 79349 | 86175 | 109112 | 59284 | 32997 | 33112 | 43812 | 39659 | 70284 | 48649 | 234655 | 27363 | 449852 | 321138 | <null> | 01:13:49 | 01:31:49 |
| fetches per second | 3 | 37492 | 68058 | 55074 | 206046 | 75760 | 70625 | 118504 | 55064 | 22869 | 24267 | 47574 | 48901 | 74000 | 68444 | 268450 | 57095 | 628651 | 273307 | <null> | 01:31:50 | 01:49:50 |
| fetches per second | 4 | 25757 | 37015 | 41369 | 47684 | 61479 | 43322 | 152804 | 48083 | 26189 | 30951 | 27021 | 22249 | 54743 | 43166 | 190327 | 27007 | 472492 | 214048 | <null> | 01:49:51 | 02:07:51 |
| fetches per second | 5 | 27485 | 37148 | 39260 | 116776 | 62938 | 51663 | 159821 | 52257 | 22342 | 32799 | 34639 | 21519 | 57234 | 31956 | 144071 | 27864 | 428383 | 276819 | <null> | 02:07:52 | 02:25:52 |
| fetches per second | 6 | 30115 | 40581 | 46153 | 63006 | 64948 | 74943 | 170992 | 48889 | 21836 | 27964 | 31411 | 16794 | 55386 | 26721 | 84490 | 35757 | 451561 | 242932 | <null> | 02:25:53 | 02:43:53 |
| fetches per second | 7 | 26719 | 36005 | 43418 | 63235 | 65015 | 64616 | 144734 | 57859 | 23674 | 24669 | 29587 | 18810 | 53812 | 24520 | 40538 | 7942 | 420338 | 190181 | <null> | 02:43:54 | 03:01:54 |
| fetches per second | 8 | 19901 | 29115 | 32904 | 60107 | 53257 | 91497 | 168321 | 40871 | 22771 | 23883 | 21222 | 12790 | 47247 | 18779 | 30376 | 23740 | 309846 | 220216 | <null> | 03:01:55 | 03:19:55 |
| fetches per second | 9 | 21214 | 36372 | 32056 | 60440 | 51432 | 50814 | 156567 | 42837 | 29570 | 19836 | 23592 | 23182 | 49004 | 20268 | 36840 | 26353 | 339645 | 135940 | <null> | 03:19:56 | 03:37:56 |
| fetches per second | 10 | 28568 | 33134 | 42457 | <null> | 63150 | 61780 | 180528 | 43044 | 21838 | 25886 | 23169 | 20089 | 50291 | 21583 | 51121 | 20728 | 513238 | 232472 | <null> | 03:37:57 | 03:55:57 |
| marks per second | 1 | 6892 | 6557 | 10048 | 13766 | 13443 | 10778 | 3212 | 5597 | 3430 | 4621 | 8083 | 4225 | 4888 | 5451 | 4447 | 7219 | 27177 | 19626 | <null> | 00:55:48 | 01:13:48 |
| marks per second | 2 | 6412 | 6627 | 9006 | 7193 | 14403 | 14647 | 2869 | 6167 | 3255 | 4147 | 6223 | 4905 | 4552 | 5320 | 3070 | 2610 | 17194 | 20599 | <null> | 01:13:49 | 01:31:49 |
| marks per second | 3 | 6891 | 7659 | 9516 | 31629 | 13331 | 12135 | 3164 | 6031 | 2619 | 3032 | 7050 | 5593 | 3038 | 6976 | 2909 | 5620 | 14514 | 16551 | <null> | 01:31:50 | 01:49:50 |
| marks per second | 4 | 4736 | 3952 | 7111 | 5017 | 10404 | 7239 | 2990 | 4750 | 2618 | 3681 | 3918 | 2609 | 3050 | 4414 | 1988 | 3039 | 11271 | 10769 | <null> | 01:49:51 | 02:07:51 |
| marks per second | 5 | 4975 | 3851 | 6628 | 18973 | 10711 | 9528 | 2971 | 5224 | 2396 | 3439 | 4237 | 2442 | 3362 | 3156 | 3055 | 3267 | 13995 | 17355 | <null> | 02:07:52 | 02:25:52 |
| marks per second | 6 | 5407 | 4281 | 8033 | 6633 | 11059 | 14044 | 3034 | 4850 | 1918 | 3038 | 4073 | 1993 | 2633 | 2982 | 5502 | 5382 | 14910 | 8991 | <null> | 02:25:53 | 02:43:53 |
| marks per second | 7 | 4823 | 4193 | 7296 | 7506 | 10667 | 11703 | 3066 | 6628 | 2141 | 3005 | 3493 | 2343 | 2526 | 2545 | 3901 | 763 | 15354 | 9481 | <null> | 02:43:54 | 03:01:54 |
| marks per second | 8 | 3593 | 3049 | 5522 | 5951 | 8198 | 16661 | 3144 | 3976 | 1833 | 2788 | 2784 | 1477 | 2234 | 1785 | 3186 | 2763 | 12107 | 7623 | <null> | 03:01:55 | 03:19:55 |
| marks per second | 9 | 3813 | 3668 | 5326 | 6785 | 8117 | 8877 | 2909 | 4337 | 4234 | 2112 | 2827 | 2944 | 2170 | 1896 | 3481 | 3207 | 15761 | 7277 | <null> | 03:19:56 | 03:37:56 |
| marks per second | 10 | 5121 | 3618 | 6916 | <null> | 9316 | 11854 | 2508 | 4261 | 1743 | 2666 | 3214 | 2598 | 2869 | 2113 | 3508 | 2408 | 14137 | 6410 | <null> | 03:37:57 | 03:55:57 |
| reads/fetches*100 | 1 | 8 | 6 | 4 | 2 | 4 | 4 | 3 | 3 | 7 | 7 | 9 | 8 | 7 | 6 | 4 | 6 | 1 | 2 | <null> | 00:55:48 | 01:13:48 |
| reads/fetches*100 | 2 | 8 | 7 | 5 | 3 | 4 | 4 | 3 | 2 | 7 | 7 | 10 | 7 | 8 | 6 | 3 | 7 | 1 | 2 | <null> | 01:13:49 | 01:31:49 |
| reads/fetches*100 | 3 | 9 | 7 | 5 | 2 | 4 | 4 | 2 | 3 | 8 | 9 | 10 | 8 | 8 | 6 | 4 | 6 | 1 | 2 | <null> | 01:31:50 | 01:49:50 |
| reads/fetches*100 | 4 | 9 | 8 | 5 | 2 | 5 | 5 | 2 | 3 | 8 | 7 | 11 | 10 | 8 | 7 | 4 | 8 | 1 | 2 | <null> | 01:49:51 | 02:07:51 |
| reads/fetches*100 | 5 | 10 | 8 | 5 | 2 | 4 | 4 | 1 | 3 | 8 | 9 | 11 | 10 | 9 | 9 | 6 | 8 | 1 | 2 | <null> | 02:07:52 | 02:25:52 |
| reads/fetches*100 | 6 | 10 | 9 | 5 | 2 | 5 | 4 | 2 | 2 | 9 | 11 | 12 | 10 | 9 | 8 | 7 | 7 | 1 | 2 | <null> | 02:25:53 | 02:43:53 |
| reads/fetches*100 | 7 | 10 | 9 | 5 | 2 | 4 | 4 | 2 | 2 | 9 | 9 | 13 | 12 | 9 | 9 | 7 | 13 | 1 | 2 | <null> | 02:43:54 | 03:01:54 |
| reads/fetches*100 | 8 | 11 | 10 | 6 | 2 | 5 | 5 | 2 | 2 | 10 | 9 | 13 | 13 | 9 | 10 | 8 | 8 | 2 | 3 | <null> | 03:01:55 | 03:19:55 |
| reads/fetches*100 | 9 | 11 | 9 | 5 | 2 | 6 | 5 | 2 | 3 | 9 | 12 | 13 | 11 | 10 | 9 | 8 | 8 | 1 | 3 | <null> | 03:19:56 | 03:37:56 |
| reads/fetches*100 | 10 | 11 | 9 | 6 | <null> | 6 | 4 | 1 | 3 | 9 | 11 | 14 | 12 | 9 | 8 | 7 | 9 | 1 | 3 | <null> | 03:37:57 | 03:55:57 |
| writes/marks*100 | 1 | 10 | 13 | 7 | 2 | 7 | 6 | 3 | 2 | 9 | 4 | 6 | 8 | 2 | 0 | 4 | 0 | 11 | 1 | <null> | 00:55:48 | 01:13:48 |
| writes/marks*100 | 2 | 10 | 12 | 7 | 3 | 7 | 1 | 2 | 2 | 11 | 5 | 7 | 10 | 2 | 0 | 5 | 0 | 12 | 2 | <null> | 01:13:49 | 01:31:49 |
| writes/marks*100 | 3 | 11 | 13 | 7 | 2 | 8 | 1 | 3 | 2 | 11 | 5 | 7 | 10 | 6 | 0 | 5 | 0 | 14 | 6 | <null> | 01:31:50 | 01:49:50 |
| writes/marks*100 | 4 | 10 | 13 | 7 | 2 | 8 | 2 | 2 | 1 | 11 | 5 | 7 | 10 | 4 | 0 | 5 | 0 | 13 | 2 | <null> | 01:49:51 | 02:07:51 |
| writes/marks*100 | 5 | 10 | 13 | 8 | 3 | 8 | 1 | 2 | 3 | 9 | 7 | 8 | 12 | 5 | 0 | 5 | 0 | 12 | 5 | <null> | 02:07:52 | 02:25:52 |
| writes/marks*100 | 6 | 10 | 15 | 7 | 2 | 8 | 2 | 3 | 2 | 11 | 6 | 8 | 11 | 6 | 0 | 2 | 0 | 14 | 2 | <null> | 02:25:53 | 02:43:53 |
| writes/marks*100 | 7 | 11 | 13 | 7 | 2 | 8 | 1 | 3 | 2 | 7 | 6 | 8 | 9 | 6 | 0 | 1 | 0 | 11 | 2 | <null> | 02:43:54 | 03:01:54 |
| writes/marks*100 | 8 | 11 | 13 | 8 | 2 | 8 | 8 | 3 | 2 | 7 | 6 | 8 | 10 | 6 | 0 | 1 | 0 | 15 | 3 | <null> | 03:01:55 | 03:19:55 |
| writes/marks*100 | 9 | 11 | 15 | 7 | 2 | 8 | 5 | 3 | 2 | 9 | 6 | 8 | 11 | 6 | 0 | 1 | 0 | 13 | 2 | <null> | 03:19:56 | 03:37:56 |
| writes/marks*100 | 10 | 11 | 14 | 7 | <null> | 8 | 1 | 2 | 2 | 8 | 7 | 8 | 11 | 6 | 0 | 2 | 0 | 14 | 0 | <null> | 03:37:57 | 03:55:57 |
Performance in DETAILS:
| UNIT | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | OK_MIN_MS | OK_MAX_MS | OK_AVG_MS | CNT_LK_CONFL | JOB_BEG | JOB_END |
|---|---|---|---|---|---|---|---|---|---|---|
| doc_list_aiud | 1085851 | 1054727 | 31124 | 2.86 | 0 | 1592 | 4 | 31124 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| doc_list_biud | 1085970 | 1054726 | 31244 | 2.87 | 0 | 9822 | 4 | 31244 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_add_invoice_to_stock | 8121 | 4814 | 3307 | 40.72 | 47 | 180838 | 11966 | 3307 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_cancel_adding_invoice | 2432 | 2239 | 193 | 7.93 | 0 | 12776 | 602 | 193 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_cancel_client_order | 2694 | 2600 | 94 | 3.48 | 0 | 562 | 44 | 94 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_cancel_customer_reserve | 207919 | 178962 | 28957 | 13.92 | 0 | 1513 | 17 | 28957 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_cancel_pay_from_customer | 1055 | 1053 | 2 | 0.18 | 0 | 203 | 31 | 2 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_cancel_pay_to_supplier | 622 | 619 | 3 | 0.48 | 0 | 249 | 35 | 3 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_cancel_supplier_invoice | 5446 | 4925 | 521 | 9.56 | 0 | 1497 | 135 | 521 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_cancel_supplier_order | 538 | 260 | 278 | 51.67 | 47 | 88131 | 15885 | 278 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_cancel_write_off | 9081 | 7290 | 1791 | 19.72 | 0 | 873 | 35 | 1791 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_client_order | 33454 | 33454 | 0 | 0.00 | 0 | 1592 | 71 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_customer_reserve | 1583448 | 1583448 | 0 | 0.00 | 0 | 2293 | 30 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_fill_shopping_cart | 50663 | 50663 | 0 | 0.00 | 0 | 1451 | 14 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_fill_shopping_cart_clo_res | 1583448 | 1583448 | 0 | 0.00 | 0 | 1029 | 2 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_get_clo_for_invoice | 4815 | 4815 | 0 | 0.00 | 0 | 1420 | 164 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_kill_cost_storno | 13135 | 11201 | 1934 | 14.72 | 0 | 483 | 9 | 1934 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_kill_qstorno_ret_qs2qd | 430306 | 370399 | 59907 | 13.92 | 0 | 1498 | 8 | 59907 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_kill_qty_storno | 247928 | 216692 | 31236 | 12.59 | 0 | 9821 | 20 | 31236 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_lock_selected_doc | 32815 | 28641 | 4174 | 12.71 | 0 | 250 | 0 | 4174 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_make_cost_storno | 41093 | 41093 | 0 | 0.00 | 0 | 1545 | 37 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_multiply_rows_for_pdistr | 41093 | 41093 | 0 | 0.00 | 0 | 840 | 14 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_multiply_rows_for_qdistr | 33454 | 33454 | 0 | 0.00 | 0 | 1201 | 26 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_pay_from_customer | 11186 | 11186 | 0 | 0.00 | 15 | 1184 | 99 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_pay_to_supplier | 9490 | 9490 | 0 | 0.00 | 0 | 1342 | 110 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_payment_common | 20676 | 20676 | 0 | 0.00 | 0 | 515 | 21 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_qd_handle_on_cancel_clo | 2694 | 2600 | 94 | 3.48 | 0 | 546 | 14 | 94 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_qd_handle_on_invoice_upd_sts | 7232 | 7053 | 179 | 2.47 | 0 | 9821 | 123 | 179 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_qd_handle_on_reserve_upd_sts | 15602 | 15602 | 0 | 0.00 | 0 | 780 | 9 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_reserve_write_off | 15771 | 15602 | 169 | 1.07 | 0 | 1092 | 67 | 169 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_supplier_invoice | 8432 | 8432 | 0 | 0.00 | 0 | 3933 | 522 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| sp_supplier_order | 8777 | 8777 | 0 | 0.00 | 15 | 2091 | 247 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| srv_find_qd_qs_mism | 655658 | 624539 | 31119 | 4.74 | 0 | 1407 | 3 | 31119 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| srv_make_invnt_saldo | 3263 | 3263 | 0 | 0.00 | 0 | 5175 | 182 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| srv_make_money_saldo | 2132 | 2132 | 0 | 0.00 | 0 | 187 | 5 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| srv_recalc_idx_stat | 11 | 11 | 0 | 0.00 | 1217 | 3900 | 2818 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_add_invoice_to_stock | 3307 | 3307 | 0 | 0.00 | 0 | 1046 | 18 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_cancel_adding_invoice | 71 | 71 | 0 | 0.00 | 0 | 390 | 97 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_cancel_client_order | 94 | 94 | 0 | 0.00 | 0 | 156 | 23 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_cancel_customer_reserve | 10 | 10 | 0 | 0.00 | 0 | 62 | 14 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_cancel_pay_from_customer | 2 | 2 | 0 | 0.00 | 0 | 2 | 1 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_cancel_pay_to_supplier | 3 | 3 | 0 | 0.00 | 0 | 78 | 26 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_cancel_supplier_invoice | 275 | 275 | 0 | 0.00 | 0 | 172 | 17 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_cancel_supplier_order | 3685 | 3685 | 0 | 0.00 | 0 | 639 | 60 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_cancel_write_off | 17 | 17 | 0 | 0.00 | 0 | 63 | 20 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-abend:sp_reserve_write_off | 169 | 169 | 0 | 0.00 | 0 | 78 | 13 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_add_invoice_to_stock | 4822 | 4822 | 0 | 0.00 | 0 | 22655 | 2107 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_cancel_adding_invoice | 647 | 647 | 0 | 0.00 | 0 | 5242 | 650 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_cancel_client_order | 2601 | 2601 | 0 | 0.00 | 0 | 359 | 28 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_cancel_customer_reserve | 1062 | 1062 | 0 | 0.00 | 0 | 266 | 32 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_cancel_pay_from_customer | 1053 | 1053 | 0 | 0.00 | 0 | 1388 | 26 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_cancel_pay_to_supplier | 619 | 619 | 0 | 0.00 | 0 | 218 | 22 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_cancel_supplier_invoice | 378 | 378 | 0 | 0.00 | 0 | 249 | 28 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_cancel_supplier_order | 260 | 260 | 0 | 0.00 | 0 | 53622 | 5440 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_cancel_write_off | 1606 | 1606 | 0 | 0.00 | 0 | 592 | 28 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_client_order | 33454 | 33454 | 0 | 0.00 | 0 | 1201 | 35 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_customer_reserve | 1558 | 1558 | 0 | 0.00 | 0 | 249 | 21 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_pay_from_customer | 11186 | 11186 | 0 | 0.00 | 0 | 344 | 23 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_pay_to_supplier | 9490 | 9490 | 0 | 0.00 | 0 | 562 | 24 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_reserve_write_off | 15602 | 15602 | 0 | 0.00 | 0 | 1076 | 31 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_supplier_invoice | 8432 | 8432 | 0 | 0.00 | 0 | 1093 | 34 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:sp_supplier_order | 8777 | 8777 | 0 | 0.00 | 0 | 874 | 33 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:srv_make_invnt_saldo | 3263 | 3263 | 0 | 0.00 | 0 | 187 | 12 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:srv_make_money_saldo | 2132 | 2132 | 0 | 0.00 | 0 | 219 | 11 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| t$perf-norm:srv_recalc_idx_stat | 11 | 11 | 0 | 0.00 | 0 | 156 | 66 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_add_invoice_to_stock | 16242 | 9628 | 6614 | 40.72 | 0 | 343 | 2 | 6614 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_all_customers | 50280 | 50280 | 0 | 0.00 | 0 | 125 | 0 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_all_suppliers | 38162 | 38162 | 0 | 0.00 | 0 | 63 | 0 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_all_wares | 66908 | 66908 | 0 | 0.00 | 0 | 62 | 0 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_cancel_adding_invoice | 1332 | 1294 | 38 | 2.85 | 0 | 1029 | 16 | 38 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_cancel_client_order | 5388 | 5200 | 188 | 3.48 | 0 | 234 | 1 | 188 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_cancel_customer_prepayment | 2110 | 2106 | 4 | 0.18 | 0 | 78 | 1 | 4 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_cancel_customer_reserve | 2144 | 2124 | 20 | 0.93 | 0 | 172 | 2 | 20 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_cancel_payment_to_supplier | 1244 | 1238 | 6 | 0.48 | 0 | 62 | 2 | 6 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_cancel_supplier_invoice | 1306 | 756 | 550 | 42.11 | 0 | 124 | 2 | 550 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_cancel_supplier_order | 1076 | 520 | 556 | 51.67 | 0 | 125 | 2 | 556 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_cancel_write_off | 3246 | 3212 | 34 | 1.04 | 0 | 218 | 9 | 34 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_max_id_clo_ord | 8777 | 8777 | 0 | 0.00 | 0 | 62 | 0 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_max_id_clo_res | 1558 | 1558 | 0 | 0.00 | 0 | 281 | 5 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_max_id_ord_sup | 8432 | 8432 | 0 | 0.00 | 0 | 47 | 0 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_max_non_paid_invoice | 7618 | 7618 | 0 | 0.00 | 0 | 125 | 2 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_max_non_paid_realizn | 11186 | 11186 | 0 | 0.00 | 0 | 109 | 7 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_min_id_clo_ord | 8777 | 8777 | 0 | 0.00 | 0 | 141 | 3 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_min_id_clo_res | 1558 | 1558 | 0 | 0.00 | 0 | 343 | 2 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_min_id_ord_sup | 8432 | 8432 | 0 | 0.00 | 0 | 281 | 2 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_min_non_paid_invoice | 9490 | 9490 | 0 | 0.00 | 0 | 515 | 13 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_min_non_paid_realizn | 11186 | 11186 | 0 | 0.00 | 0 | 515 | 11 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_our_firm | 16628 | 16628 | 0 | 0.00 | 0 | 31 | 0 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| v_reserve_write_off | 31542 | 31204 | 338 | 1.07 | 0 | 375 | 2 | 338 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| x_lock_depdocs_on_canc_invoice | 7895 | 6786 | 1109 | 14.04 | 0 | 156 | 5 | 1109 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| x_lock_depdocs_on_canc_sup_ord | 536 | 260 | 276 | 51.49 | 0 | 124 | 12 | 276 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| x_make_qstorno_1000_1200 | 8777 | 8777 | 0 | 0.00 | 0 | 2028 | 197 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| x_make_qstorno_1200_2000 | 8432 | 8432 | 0 | 0.00 | 0 | 3902 | 482 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| x_make_qstorno_2100_3300 | 1583448 | 1583448 | 0 | 0.00 | 0 | 2278 | 24 | 0 | 2016-01-19 00:55 | 2016-01-19 03:55 |
Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.
Exceptions occured during test work:
| FB_MNEMONA | CNT | UNIT | FB_GDSCODE | DTS_BEG | DTS_END |
|---|---|---|---|---|---|
| deadlock | 12 | sp_kill_cost_storno | 335544336 | 2016-01-19 00:59 | 2016-01-19 03:07 |
| deadlock | 3 | sp_kill_qstorno_ret_qs2qd | 335544336 | 2016-01-19 01:12 | 2016-01-19 02:43 |
| deadlock | 74 | sp_lock_selected_doc | 335544336 | 2016-01-19 00:57 | 2016-01-19 03:54 |
| deadlock | 1 | sp_qd_handle_on_cancel_clo | 335544336 | 2016-01-19 01:05 | 2016-01-19 01:05 |
| deadlock | 17 | sp_qd_handle_on_invoice_upd_sts | 335544336 | 2016-01-19 00:58 | 2016-01-19 03:09 |
| deadlock | 1 | x_lock_depdocs_on_canc_invoice | 335544336 | 2016-01-19 01:50 | 2016-01-19 01:50 |
| lock_conflict | 7 | sp_kill_cost_storno | 335544345 | 2016-01-19 01:25 | 2016-01-19 03:19 |
| lock_conflict | 3711 | sp_lock_selected_doc | 335544345 | 2016-01-19 00:55 | 2016-01-19 03:55 |
| lock_conflict | 93 | sp_qd_handle_on_cancel_clo | 335544345 | 2016-01-19 01:06 | 2016-01-19 03:47 |
| lock_conflict | 9 | sp_qd_handle_on_invoice_upd_sts | 335544345 | 2016-01-19 00:56 | 2016-01-19 02:25 |
| lock_conflict | 33 | x_lock_depdocs_on_canc_invoice | 335544345 | 2016-01-19 00:58 | 2016-01-19 02:50 |
| lock_conflict | 213 | x_lock_depdocs_on_canc_sup_ord | 335544345 | 2016-01-19 01:00 | 2016-01-19 03:54 |
MON$DATABASE and FB VERSION info
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDBMON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 194160
MON$OLDEST_ACTIVE 194161
MON$OLDEST_SNAPSHOT 194161
MON$NEXT_TRANSACTION 194161
MON$PAGE_BUFFERS 384
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 10:02:47.3010
MON$PAGES 691641
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26963 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26963 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26963 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26963 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2
Database statistics, full
Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 198833
Page size 8192
ODS version 11.2
Oldest transaction 194162
Oldest active 194163
Oldest snapshot 194163
Next transaction 194164
Bumped transaction 1
Sequence number 0
Next attachment ID 4660
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 33.64, total records: 1381235
Average version length: 47.37, total versions: 395265, max versions: 1
Data pages: 14893, data page slots: 14893, average fill: 78%
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 8
60 - 79% = 9768
80 - 99% = 5111
Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 5690, nodes: 1381235
Average data length: 14.21, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 647
20 - 39% = 2
40 - 59% = 3207
60 - 79% = 17
80 - 99% = 1817
Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 3954, nodes: 1381235
Average data length: 5.65, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 3951
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 1924, nodes: 1381235
Average data length: 2.00, total dup: 921010, max dup: 49
Fill distribution:
0 - 19% = 164
20 - 39% = 0
40 - 59% = 1033
60 - 79% = 0
80 - 99% = 727
DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 57.54, total records: 324410
Average version length: 36.44, total versions: 40527, max versions: 3
Data pages: 4089, data page slots: 4089, average fill: 79%
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 6
60 - 79% = 3127
80 - 99% = 950
Index DOC_LIST_ID_DESC (1)
Depth: 3, leaf buckets: 1166, nodes: 324410
Average data length: 6.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 530
40 - 59% = 612
60 - 79% = 24
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 354, nodes: 324410
Average data length: 0.01, total dup: 324360, max dup: 35359
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 296
60 - 79% = 33
80 - 99% = 25
Index PK_DOC_LIST (0)
Depth: 3, leaf buckets: 920, nodes: 324410
Average data length: 6.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 146
20 - 39% = 198
40 - 59% = 237
60 - 79% = 117
80 - 99% = 222
DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 64.20, total records: 400
Average version length: 14.54, total versions: 208742, max versions: 1444
Data pages: 993, data page slots: 993, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 21
60 - 79% = 372
80 - 99% = 599
Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 1.08, total records: 11583
Average version length: 71.22, total versions: 11407, max versions: 1
Data pages: 295, data page slots: 355, average fill: 53%
Fill distribution:
0 - 19% = 3
20 - 39% = 81
40 - 59% = 105
60 - 79% = 76
80 - 99% = 30
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 56, nodes: 11583
Average data length: 9.01, total dup: 469, max dup: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 39
40 - 59% = 16
60 - 79% = 1
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 15.24, total records: 49
Average version length: 9.01, total versions: 3789, max versions: 1848
Data pages: 14, data page slots: 14, average fill: 88%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 13
Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 4.22, total records: 669
Average version length: 46.18, total versions: 608, max versions: 1
Data pages: 8, data page slots: 8, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 1, leaf buckets: 1, nodes: 669
Average data length: 1.23, total dup: 604, max dup: 152
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
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: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 40.62, total records: 118072
Average version length: 38.01, total versions: 11452, max versions: 5
Data pages: 1277, data page slots: 1277, average fill: 72%
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 31
60 - 79% = 1210
80 - 99% = 23
Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 101, nodes: 118072
Average data length: 0.01, total dup: 118023, max dup: 5052
Fill distribution:
0 - 19% = 2
20 - 39% = 10
40 - 59% = 42
60 - 79% = 30
80 - 99% = 17
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 129, nodes: 118072
Average data length: 0.88, total dup: 106461, max dup: 53
Fill distribution:
0 - 19% = 2
20 - 39% = 24
40 - 59% = 47
60 - 79% = 31
80 - 99% = 25
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 130, nodes: 118072
Average data length: 0.88, total dup: 106461, max dup: 53
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 59
60 - 79% = 38
80 - 99% = 12
Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 138, nodes: 118072
Average data length: 0.67, total dup: 106461, max dup: 53
Fill distribution:
0 - 19% = 1
20 - 39% = 36
40 - 59% = 59
60 - 79% = 36
80 - 99% = 6
PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.96, total records: 118179
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 1010, data page slots: 1010, average fill: 64%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1009
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 82, nodes: 118179
Average data length: 0.00, total dup: 117988, max dup: 1440
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 23
60 - 79% = 34
80 - 99% = 25
PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 151.52, total records: 10210617
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 242153, data page slots: 242153, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 242153
Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 10739, nodes: 10210617
Average data length: 0.18, total dup: 8907398, max dup: 75
Fill distribution:
0 - 19% = 15
20 - 39% = 0
40 - 59% = 4575
60 - 79% = 3798
80 - 99% = 2351
Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 11235, nodes: 10210617
Average data length: 0.00, total dup: 10210612, max dup: 9950395
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11233
60 - 79% = 0
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 12574, nodes: 10210617
Average data length: 0.11, total dup: 10041541, max dup: 28355
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 10157
60 - 79% = 1315
80 - 99% = 1101
Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 12843, nodes: 10210617
Average data length: 0.07, total dup: 10189737, max dup: 1339405
Fill distribution:
0 - 19% = 13
20 - 39% = 1
40 - 59% = 11510
60 - 79% = 355
80 - 99% = 964
PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 42.04, total records: 247314
Average version length: 57.39, total versions: 63799, max versions: 1
Data pages: 2942, data page slots: 2942, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 5
60 - 79% = 1729
80 - 99% = 1207
Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 275, nodes: 247314
Average data length: 0.95, total dup: 211645, max dup: 1090
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 136
60 - 79% = 99
80 - 99% = 39
Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 241, nodes: 247314
Average data length: 0.57, total dup: 226359, max dup: 150
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 81
60 - 79% = 111
80 - 99% = 49
RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 5498, max versions: 3436
Data pages: 19, data page slots: 19, average fill: 92%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 19
Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 97.51, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
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: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 59.52, total records: 11907
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 147, data page slots: 147, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 146
80 - 99% = 0
WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 5.06, total records: 10712
Average version length: 72.19, total versions: 9964, max versions: 1
Data pages: 212, data page slots: 327, average fill: 67%
Fill distribution:
0 - 19% = 29
20 - 39% = 32
40 - 59% = 16
60 - 79% = 15
80 - 99% = 120
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 22, nodes: 10712
Average data length: 2.03, total dup: 9372, max dup: 14
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 7
60 - 79% = 1
80 - 99% = 0
XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 68.16, total records: 454475
Average version length: 71.79, total versions: 25115, max versions: 1
Data pages: 6551, data page slots: 6551, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 121
60 - 79% = 5797
80 - 99% = 621
Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 443, nodes: 454475
Average data length: 0.24, total dup: 437683, max dup: 120
Fill distribution:
0 - 19% = 2
20 - 39% = 117
40 - 59% = 118
60 - 79% = 27
80 - 99% = 179
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 570, nodes: 454475
Average data length: 1.25, total dup: 394740, max dup: 29
Fill distribution:
0 - 19% = 14
20 - 39% = 52
40 - 59% = 217
60 - 79% = 142
80 - 99% = 145
XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 41.03, total records: 105865
Average version length: 71.82, total versions: 45659, max versions: 1
Data pages: 1985, data page slots: 2810, average fill: 64%
Fill distribution:
0 - 19% = 86
20 - 39% = 91
40 - 59% = 442
60 - 79% = 1032
80 - 99% = 334
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 171, nodes: 105865
Average data length: 1.58, total dup: 89300, max dup: 43
Fill distribution:
0 - 19% = 2
20 - 39% = 44
40 - 59% = 99
60 - 79% = 21
80 - 99% = 5
XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 11.54, total records: 4855526
Average version length: 70.94, total versions: 4079230, max versions: 1
Data pages: 67097, data page slots: 67097, average fill: 91%
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 8827
80 - 99% = 58267
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 6264, nodes: 4855526
Average data length: 0.61, total dup: 4555550, max dup: 99
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 5976
60 - 79% = 141
80 - 99% = 146
XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 0.12, total records: 11007
Average version length: 71.55, total versions: 10988, max versions: 1
Data pages: 242, data page slots: 811, average fill: 61%
Fill distribution:
0 - 19% = 48
20 - 39% = 31
40 - 59% = 24
60 - 79% = 32
80 - 99% = 107
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 19, nodes: 11007
Average data length: 1.43, total dup: 10222, max dup: 93
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 7
60 - 79% = 2
80 - 99% = 0
XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 30.51, total records: 2754358
Average version length: 70.42, total versions: 1572722, max versions: 1
Data pages: 37869, data page slots: 37882, average fill: 87%
Fill distribution:
0 - 19% = 14
20 - 39% = 14
40 - 59% = 33
60 - 79% = 4636
80 - 99% = 33172
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 4210, nodes: 2754358
Average data length: 1.65, total dup: 2251899, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 3911
60 - 79% = 158
80 - 99% = 139
XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 77.77, total records: 2296201
Average version length: 83.33, total versions: 155328, max versions: 1
Data pages: 34797, data page slots: 34797, average fill: 82%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6294
80 - 99% = 28503
Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 2518, nodes: 2296201
Average data length: 0.15, total dup: 2244988, max dup: 217
Fill distribution:
0 - 19% = 12
20 - 39% = 1
40 - 59% = 1734
60 - 79% = 646
80 - 99% = 125
Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 1729, nodes: 2296201
Average data length: 0.68, total dup: 2015317, max dup: 49
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 137
60 - 79% = 7
80 - 99% = 1582
Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 2841, nodes: 2296201
Average data length: 0.69, total dup: 2014141, max dup: 44
Fill distribution:
0 - 19% = 25
20 - 39% = 0
40 - 59% = 1940
60 - 79% = 747
80 - 99% = 129
XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 41.51, total records: 2372447
Average version length: 82.87, total versions: 1187755, max versions: 1
Data pages: 35942, data page slots: 35948, average fill: 88%
Fill distribution:
0 - 19% = 14
20 - 39% = 12
40 - 59% = 27
60 - 79% = 1433
80 - 99% = 34456
Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2198, nodes: 2372447
Average data length: 0.09, total dup: 2341988, max dup: 582
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 807
60 - 79% = 883
80 - 99% = 503
Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2428, nodes: 2372447
Average data length: 1.10, total dup: 1939704, max dup: 14
Fill distribution:
0 - 19% = 129
20 - 39% = 1
40 - 59% = 822
60 - 79% = 2
80 - 99% = 1474
Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 2380, nodes: 2372447
Average data length: 0.39, total dup: 2212858, max dup: 133
Fill distribution:
0 - 19% = 35
20 - 39% = 0
40 - 59% = 868
60 - 79% = 940
80 - 99% = 537
XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 38.09, total records: 4824654
Average version length: 84.43, total versions: 2626276, max versions: 1
Data pages: 73378, data page slots: 73378, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 6915
80 - 99% = 66462
Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 4507, nodes: 4824654
Average data length: 0.03, total dup: 4810967, max dup: 3350
Fill distribution:
0 - 19% = 9
20 - 39% = 21
40 - 59% = 1870
60 - 79% = 1641
80 - 99% = 966
Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 3803, nodes: 4824654
Average data length: 0.35, total dup: 4520402, max dup: 49
Fill distribution:
0 - 19% = 11
20 - 39% = 2
40 - 59% = 867
60 - 79% = 153
80 - 99% = 2770
Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 4803, nodes: 4824654
Average data length: 0.32, total dup: 4547987, max dup: 384
Fill distribution:
0 - 19% = 8
20 - 39% = 13
40 - 59% = 1905
60 - 79% = 1869
80 - 99% = 1008
XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 44.69, total records: 2651531
Average version length: 83.18, total versions: 1229468, max versions: 1
Data pages: 40195, data page slots: 40203, average fill: 87%
Fill distribution:
0 - 19% = 13
20 - 39% = 18
40 - 59% = 32
60 - 79% = 1606
80 - 99% = 38526
Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2615, nodes: 2651531
Average data length: 0.03, total dup: 2643106, max dup: 1972
Fill distribution:
0 - 19% = 11
20 - 39% = 29
40 - 59% = 1414
60 - 79% = 672
80 - 99% = 489
Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2845, nodes: 2651531
Average data length: 1.10, total dup: 2168943, max dup: 14
Fill distribution:
0 - 19% = 133
20 - 39% = 84
40 - 59% = 980
60 - 79% = 116
80 - 99% = 1532
Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 2865, nodes: 2651531
Average data length: 0.38, total dup: 2478584, max dup: 117
Fill distribution:
0 - 19% = 5
20 - 39% = 28
40 - 59% = 1617
60 - 79% = 748
80 - 99% = 467
XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 40.76, total records: 406220
Average version length: 68.76, total versions: 165793, max versions: 1
Data pages: 5488, data page slots: 5488, average fill: 84%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1670
80 - 99% = 3817
Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 391, nodes: 406220
Average data length: 0.39, total dup: 383079, max dup: 167
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 157
60 - 79% = 145
80 - 99% = 89
Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 447, nodes: 406220
Average data length: 0.91, total dup: 347855, max dup: 27
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 180
60 - 79% = 181
80 - 99% = 84
ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 26090 ms, from 4:11:09.43 to 4:11:35.52.
Analyzing DB stat log: obtaining values of total records and versions
| TABLE_NAME | TOTAL_RECS | TOTAL_VERS | VERS_PERCENT |
|---|---|---|---|
| AGENTS | 50 | 0 | 0.0000 |
| BUSINESS_OPS | 19 | 0 | 0.0000 |
| DOC_DATA | 1381235 | 395265 | 28.6167 |
| DOC_LIST | 324410 | 40527 | 12.4925 |
| DOC_STATES | 4 | 0 | 0.0000 |
| FB_ERRORS | 758 | 0 | 0.0000 |
| INVNT_SALDO | 400 | 208742 | 52185.5000 |
| INVNT_TURNOVER_LOG | 11583 | 11407 | 98.4805 |
| MONEY_SALDO | 49 | 3789 | 7732.6530 |
| MONEY_TURNOVER_LOG | 669 | 608 | 90.8819 |
| OPTYPES | 9 | 0 | 0.0000 |
| PDISTR | 118072 | 11452 | 9.6991 |
| PERF_ESTIMATED | 118179 | 2 | 0.0016 |
| PERF_LOG | 10210617 | 1 | 0.0000 |
| PSTORNED | 247314 | 63799 | 25.7967 |
| RULES_FOR_PDISTR | 4 | 0 | 0.0000 |
| RULES_FOR_QDISTR | 7 | 0 | 0.0000 |
| SEMAPHORES | 4 | 5498 | 137450.0000 |
| SETTINGS | 114 | 0 | 0.0000 |
| TRACE_STAT | 11907 | 0 | 0.0000 |
| WARES | 400 | 0 | 0.0000 |
| WARE_GROUPS | 8 | 0 | 0.0000 |
| XQD_1000_1200 | 10712 | 9964 | 93.0171 |
| XQD_1000_3300 | 454475 | 25115 | 5.5261 |
| XQD_1200_2000 | 105865 | 45659 | 43.1294 |
| XQD_2000_3300 | 4855526 | 4079230 | 84.0121 |
| XQD_2100_3300 | 11007 | 10988 | 99.8273 |
| XQD_3300_3400 | 2754358 | 1572722 | 57.0994 |
| XQS_1000_1200 | 2296201 | 155328 | 6.7645 |
| XQS_1000_3300 | 2372447 | 1187755 | 50.0645 |
| XQS_1200_2000 | 4824654 | 2626276 | 54.4344 |
| XQS_2100_3300 | 2651531 | 1229468 | 46.3682 |
| XQS_3300_3400 | 406220 | 165793 | 40.8135 |
| Z_USED_VIEWS | 32 | 0 | 0.0000 |
Database validation
04:11:45.64 Validation started
04:11:45.66 Relation 140 (DOC_LIST)
04:11:45.66 process pointer page 0 of 3
04:11:45.74 process pointer page 1 of 3
04:11:45.86 process pointer page 2 of 3
04:11:45.88 Index 1 (PK_DOC_LIST)
04:11:45.99 Index 2 (DOC_LIST_ID_DESC)
04:11:46.05 Index 3 (FK_DOC_LIST_AGENTS)
04:11:46.10 Relation 140 (DOC_LIST) is ok
04:11:46.10 Relation 141 (DOC_DATA)
04:11:46.10 process pointer page 0 of 8
04:11:46.14 process pointer page 1 of 8
04:11:46.20 process pointer page 2 of 8
04:11:46.31 process pointer page 3 of 8
04:11:46.36 process pointer page 4 of 8
04:11:46.49 process pointer page 5 of 8
04:11:46.63 process pointer page 6 of 8
04:11:46.75 process pointer page 7 of 8
04:11:46.83 Index 2 (DOC_DATA_DOC_WARE_UNQ)
04:11:47.36 Index 3 (DOC_DATA_ID_DESC)
04:11:47.59 Index 4 (FK_DOC_DATA_DOC_LIST)
04:11:47.92 Relation 141 (DOC_DATA) is ok
04:11:47.92 Relation 147 (INVNT_SALDO)
04:11:47.92 process pointer page 0 of 1
04:11:49.50 Index 1 (PK_INVNT_SALDO)
04:11:49.50 Relation 147 (INVNT_SALDO) is ok
04:11:49.50 Relation 150 (PDISTR)
04:11:49.50 process pointer page 0 of 1
04:11:49.53 Index 2 (PDISTR_SND_ID)
04:11:49.54 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
04:11:49.59 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
04:11:49.62 Index 5 (PDISTR_AGENT_ID)
04:11:49.65 Relation 150 (PDISTR) is ok
04:11:49.65 Relation 151 (PSTORNED)
04:11:49.65 process pointer page 0 of 2
04:11:49.78 process pointer page 1 of 2
04:11:49.85 Index 2 (PSTORNED_SND_ID)
04:11:49.92 Index 3 (PSTORNED_RCV_ID)
04:11:49.96 Relation 151 (PSTORNED) is ok
04:11:49.96 Relation 156 (SEMAPHORES)
04:11:49.98 process pointer page 0 of 1
04:11:49.98 Index 1 (PK_SEMAPHORES)
04:11:49.98 Index 2 (SEMAPHORES_TASK_UNQ)
04:11:49.98 Relation 156 (SEMAPHORES) is ok
04:11:49.98 Relation 157 (INVNT_TURNOVER_LOG)
04:11:49.98 process pointer page 0 of 1
04:11:50.00 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
04:11:50.01 Relation 157 (INVNT_TURNOVER_LOG) is ok
04:11:50.01 Relation 160 (PERF_ESTIMATED)
04:11:50.01 process pointer page 0 of 1
04:11:50.04 Index 1 (PERF_EST_MINUTE_SINCE_START)
04:11:50.07 Relation 160 (PERF_ESTIMATED) is ok
04:11:50.07 Relation 161 (PERF_ISQL_STAT)
04:11:50.07 process pointer page 0 of 1
04:11:50.07 Index 1 (PERF_ISQL_STAT_TRN)
04:11:50.07 Relation 161 (PERF_ISQL_STAT) is ok
04:11:50.07 Relation 162 (PERF_LOG)
04:11:50.07 process pointer page 0 of 127
04:11:50.15 process pointer page 1 of 127
04:11:50.21 process pointer page 2 of 127
04:11:50.23 process pointer page 3 of 127
04:11:50.26 process pointer page 4 of 127
04:11:50.29 process pointer page 5 of 127
04:11:50.32 process pointer page 6 of 127
04:11:50.35 process pointer page 7 of 127
04:11:50.39 process pointer page 8 of 127
04:11:50.43 process pointer page 9 of 127
04:11:50.46 process pointer page 10 of 127
04:11:50.48 process pointer page 11 of 127
04:11:50.51 process pointer page 12 of 127
04:11:50.54 process pointer page 13 of 127
04:11:50.56 process pointer page 14 of 127
04:11:50.59 process pointer page 15 of 127
04:11:50.60 process pointer page 16 of 127
04:11:50.62 process pointer page 17 of 127
04:11:50.65 process pointer page 18 of 127
04:11:50.67 process pointer page 19 of 127
04:11:50.68 process pointer page 20 of 127
04:11:50.71 process pointer page 21 of 127
04:11:50.73 process pointer page 22 of 127
04:11:50.76 process pointer page 23 of 127
04:11:50.81 process pointer page 24 of 127
04:11:50.85 process pointer page 25 of 127
04:11:50.87 process pointer page 26 of 127
04:11:50.90 process pointer page 27 of 127
04:11:50.93 process pointer page 28 of 127
04:11:50.99 process pointer page 29 of 127
04:11:51.07 process pointer page 30 of 127
04:11:51.13 process pointer page 31 of 127
04:11:51.21 process pointer page 32 of 127
04:11:51.27 process pointer page 33 of 127
04:11:51.35 process pointer page 34 of 127
04:11:51.40 process pointer page 35 of 127
04:11:51.43 process pointer page 36 of 127
04:11:51.46 process pointer page 37 of 127
04:11:51.49 process pointer page 38 of 127
04:11:51.52 process pointer page 39 of 127
04:11:51.54 process pointer page 40 of 127
04:11:51.57 process pointer page 41 of 127
04:11:51.59 process pointer page 42 of 127
04:11:51.62 process pointer page 43 of 127
04:11:51.65 process pointer page 44 of 127
04:11:51.66 process pointer page 45 of 127
04:11:51.70 process pointer page 46 of 127
04:11:51.71 process pointer page 47 of 127
04:11:51.73 process pointer page 48 of 127
04:11:51.74 process pointer page 49 of 127
04:11:51.77 process pointer page 50 of 127
04:11:51.79 process pointer page 51 of 127
04:11:51.80 process pointer page 52 of 127
04:11:51.84 process pointer page 53 of 127
04:11:51.85 process pointer page 54 of 127
04:11:51.87 process pointer page 55 of 127
04:11:51.90 process pointer page 56 of 127
04:11:51.91 process pointer page 57 of 127
04:11:51.93 process pointer page 58 of 127
04:11:51.96 process pointer page 59 of 127
04:11:51.98 process pointer page 60 of 127
04:11:52.01 process pointer page 61 of 127
04:11:52.04 process pointer page 62 of 127
04:11:52.05 process pointer page 63 of 127
04:11:52.07 process pointer page 64 of 127
04:11:52.09 process pointer page 65 of 127
04:11:52.12 process pointer page 66 of 127
04:11:52.13 process pointer page 67 of 127
04:11:52.15 process pointer page 68 of 127
04:11:52.18 process pointer page 69 of 127
04:11:52.24 process pointer page 70 of 127
04:11:52.27 process pointer page 71 of 127
04:11:52.32 process pointer page 72 of 127
04:11:52.38 process pointer page 73 of 127
04:11:52.46 process pointer page 74 of 127
04:11:52.51 process pointer page 75 of 127
04:11:52.54 process pointer page 76 of 127
04:11:52.57 process pointer page 77 of 127
04:11:52.62 process pointer page 78 of 127
04:11:52.63 process pointer page 79 of 127
04:11:52.66 process pointer page 80 of 127
04:11:52.68 process pointer page 81 of 127
04:11:52.71 process pointer page 82 of 127
04:11:52.74 process pointer page 83 of 127
04:11:52.82 process pointer page 84 of 127
04:11:52.88 process pointer page 85 of 127
04:11:52.94 process pointer page 86 of 127
04:11:52.97 process pointer page 87 of 127
04:11:53.04 process pointer page 88 of 127
04:11:53.07 process pointer page 89 of 127
04:11:53.12 process pointer page 90 of 127
04:11:53.18 process pointer page 91 of 127
04:11:53.26 process pointer page 92 of 127
04:11:53.32 process pointer page 93 of 127
04:11:53.40 process pointer page 94 of 127
04:11:53.44 process pointer page 95 of 127
04:11:53.47 process pointer page 96 of 127
04:11:53.51 process pointer page 97 of 127
04:11:53.55 process pointer page 98 of 127
04:11:53.57 process pointer page 99 of 127
04:11:53.63 process pointer page 100 of 127
04:11:53.66 process pointer page 101 of 127
04:11:53.69 process pointer page 102 of 127
04:11:53.72 process pointer page 103 of 127
04:11:53.75 process pointer page 104 of 127
04:11:53.77 process pointer page 105 of 127
04:11:53.83 process pointer page 106 of 127
04:11:53.86 process pointer page 107 of 127
04:11:53.90 process pointer page 108 of 127
04:11:53.93 process pointer page 109 of 127
04:11:53.96 process pointer page 110 of 127
04:11:53.99 process pointer page 111 of 127
04:11:54.00 process pointer page 112 of 127
04:11:54.05 process pointer page 113 of 127
04:11:54.11 process pointer page 114 of 127
04:11:54.19 process pointer page 115 of 127
04:11:54.25 process pointer page 116 of 127
04:11:54.30 process pointer page 117 of 127
04:11:54.33 process pointer page 118 of 127
04:11:54.35 process pointer page 119 of 127
04:11:54.38 process pointer page 120 of 127
04:11:54.46 process pointer page 121 of 127
04:11:54.52 process pointer page 122 of 127
04:11:54.60 process pointer page 123 of 127
04:11:54.63 process pointer page 124 of 127
04:11:54.66 process pointer page 125 of 127
04:11:54.69 process pointer page 126 of 127
04:11:54.69 Index 1 (PERF_LOG_DTS_BEG_DESC)
04:11:56.41 Index 2 (PERF_LOG_UNIT)
04:11:59.20 Index 3 (PERF_LOG_TRN_DESC)
04:12:00.56 Index 4 (PERF_LOG_GDSCODE)
04:12:01.60 Relation 162 (PERF_LOG) is ok
04:12:01.60 Relation 166 (V_STOPTEST)
04:12:01.60 Relation 166 (V_STOPTEST) is ok
04:12:01.60 Relation 183 (V_QDISTR_SOURCE)
04:12:01.60 Relation 183 (V_QDISTR_SOURCE) is ok
04:12:01.60 Relation 184 (V_QSTORNED_SOURCE)
04:12:01.60 Relation 184 (V_QSTORNED_SOURCE) is ok
04:12:01.60 Relation 258 (XQD_1000_1200)
04:12:01.62 process pointer page 0 of 1
04:12:01.62 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
04:12:01.62 Relation 258 (XQD_1000_1200) is ok
04:12:01.62 Relation 259 (XQD_1200_2000)
04:12:01.62 process pointer page 0 of 2
04:12:01.67 process pointer page 1 of 2
04:12:01.67 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
04:12:01.68 Relation 259 (XQD_1200_2000) is ok
04:12:01.68 Relation 260 (XQD_1000_3300)
04:12:01.68 process pointer page 0 of 4
04:12:01.71 process pointer page 1 of 4
04:12:01.76 process pointer page 2 of 4
04:12:01.79 process pointer page 3 of 4
04:12:01.81 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
04:12:01.87 Index 2 (XQD_1000_3300_DOC)
04:12:01.92 Relation 260 (XQD_1000_3300) is ok
04:12:01.92 Relation 261 (XQD_2000_3300)
04:12:01.92 process pointer page 0 of 35
04:12:01.96 process pointer page 1 of 35
04:12:02.03 process pointer page 2 of 35
04:12:02.12 process pointer page 3 of 35
04:12:02.20 process pointer page 4 of 35
04:12:02.32 process pointer page 5 of 35
04:12:02.45 process pointer page 6 of 35
04:12:02.53 process pointer page 7 of 35
04:12:02.59 process pointer page 8 of 35
04:12:02.68 process pointer page 9 of 35
04:12:02.82 process pointer page 10 of 35
04:12:02.88 process pointer page 11 of 35
04:12:02.95 process pointer page 12 of 35
04:12:03.01 process pointer page 13 of 35
04:12:03.10 process pointer page 14 of 35
04:12:03.16 process pointer page 15 of 35
04:12:03.31 process pointer page 16 of 35
04:12:03.48 process pointer page 17 of 35
04:12:03.65 process pointer page 18 of 35
04:12:03.71 process pointer page 19 of 35
04:12:03.77 process pointer page 20 of 35
04:12:03.84 process pointer page 21 of 35
04:12:03.88 process pointer page 22 of 35
04:12:03.93 process pointer page 23 of 35
04:12:03.99 process pointer page 24 of 35
04:12:04.04 process pointer page 25 of 35
04:12:04.07 process pointer page 26 of 35
04:12:04.19 process pointer page 27 of 35
04:12:04.26 process pointer page 28 of 35
04:12:04.30 process pointer page 29 of 35
04:12:04.35 process pointer page 30 of 35
04:12:04.40 process pointer page 31 of 35
04:12:04.44 process pointer page 32 of 35
04:12:04.54 process pointer page 33 of 35
04:12:04.58 process pointer page 34 of 35
04:12:04.68 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
04:12:05.44 Relation 261 (XQD_2000_3300) is ok
04:12:05.44 Relation 262 (XQD_2100_3300)
04:12:05.46 process pointer page 0 of 2
04:12:05.46 process pointer page 1 of 2
04:12:05.46 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
04:12:05.46 Relation 262 (XQD_2100_3300) is ok
04:12:05.46 Relation 263 (XQD_3300_3400)
04:12:05.46 process pointer page 0 of 20
04:12:05.52 process pointer page 1 of 20
04:12:05.57 process pointer page 2 of 20
04:12:05.61 process pointer page 3 of 20
04:12:05.71 process pointer page 4 of 20
04:12:05.79 process pointer page 5 of 20
04:12:05.93 process pointer page 6 of 20
04:12:06.08 process pointer page 7 of 20
04:12:06.21 process pointer page 8 of 20
04:12:06.30 process pointer page 9 of 20
04:12:06.44 process pointer page 10 of 20
04:12:06.50 process pointer page 11 of 20
04:12:06.57 process pointer page 12 of 20
04:12:06.61 process pointer page 13 of 20
04:12:06.66 process pointer page 14 of 20
04:12:06.74 process pointer page 15 of 20
04:12:06.82 process pointer page 16 of 20
04:12:06.88 process pointer page 17 of 20
04:12:06.92 process pointer page 18 of 20
04:12:06.97 process pointer page 19 of 20
04:12:07.03 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
04:12:07.66 Relation 263 (XQD_3300_3400) is ok
04:12:07.66 Relation 264 (XQS_1000_1200)
04:12:07.66 process pointer page 0 of 19
04:12:07.75 process pointer page 1 of 19
04:12:07.81 process pointer page 2 of 19
04:12:07.84 process pointer page 3 of 19
04:12:07.88 process pointer page 4 of 19
04:12:07.92 process pointer page 5 of 19
04:12:07.95 process pointer page 6 of 19
04:12:08.00 process pointer page 7 of 19
04:12:08.09 process pointer page 8 of 19
04:12:08.13 process pointer page 9 of 19
04:12:08.17 process pointer page 10 of 19
04:12:08.25 process pointer page 11 of 19
04:12:08.31 process pointer page 12 of 19
04:12:08.36 process pointer page 13 of 19
04:12:08.39 process pointer page 14 of 19
04:12:08.44 process pointer page 15 of 19
04:12:08.47 process pointer page 16 of 19
04:12:08.50 process pointer page 17 of 19
04:12:08.53 process pointer page 18 of 19
04:12:08.55 Index 1 (XQS_1000_1200_DOC_ID)
04:12:08.77 Index 2 (XQS_1000_1200_SND_ID)
04:12:09.12 Index 3 (XQS_1000_1200_RCV_ID)
04:12:09.39 Relation 264 (XQS_1000_1200) is ok
04:12:09.39 Relation 265 (XQS_1200_2000)
04:12:09.39 process pointer page 0 of 39
04:12:09.42 process pointer page 1 of 39
04:12:09.45 process pointer page 2 of 39
04:12:09.48 process pointer page 3 of 39
04:12:09.51 process pointer page 4 of 39
04:12:09.55 process pointer page 5 of 39
04:12:09.58 process pointer page 6 of 39
04:12:09.62 process pointer page 7 of 39
04:12:09.65 process pointer page 8 of 39
04:12:09.70 process pointer page 9 of 39
04:12:09.73 process pointer page 10 of 39
04:12:09.76 process pointer page 11 of 39
04:12:09.86 process pointer page 12 of 39
04:12:09.92 process pointer page 13 of 39
04:12:10.08 process pointer page 14 of 39
04:12:10.22 process pointer page 15 of 39
04:12:10.36 process pointer page 16 of 39
04:12:10.40 process pointer page 17 of 39
04:12:10.47 process pointer page 18 of 39
04:12:10.53 process pointer page 19 of 39
04:12:10.59 process pointer page 20 of 39
04:12:10.64 process pointer page 21 of 39
04:12:10.68 process pointer page 22 of 39
04:12:10.72 process pointer page 23 of 39
04:12:10.76 process pointer page 24 of 39
04:12:10.79 process pointer page 25 of 39
04:12:10.84 process pointer page 26 of 39
04:12:10.90 process pointer page 27 of 39
04:12:10.98 process pointer page 28 of 39
04:12:11.04 process pointer page 29 of 39
04:12:11.18 process pointer page 30 of 39
04:12:11.31 process pointer page 31 of 39
04:12:11.43 process pointer page 32 of 39
04:12:11.48 process pointer page 33 of 39
04:12:11.54 process pointer page 34 of 39
04:12:11.59 process pointer page 35 of 39
04:12:11.62 process pointer page 36 of 39
04:12:11.65 process pointer page 37 of 39
04:12:11.68 process pointer page 38 of 39
04:12:11.68 Index 1 (XQS_1200_2000_DOC_ID)
04:12:12.52 Index 2 (XQS_1200_2000_SND_ID)
04:12:13.57 Index 3 (XQS_1200_2000_RCV_ID)
04:12:14.15 Relation 265 (XQS_1200_2000) is ok
04:12:14.15 Relation 266 (XQS_1000_3300)
04:12:14.16 process pointer page 0 of 19
04:12:14.23 process pointer page 1 of 19
04:12:14.30 process pointer page 2 of 19
04:12:14.37 process pointer page 3 of 19
04:12:14.44 process pointer page 4 of 19
04:12:14.52 process pointer page 5 of 19
04:12:14.60 process pointer page 6 of 19
04:12:14.65 process pointer page 7 of 19
04:12:14.74 process pointer page 8 of 19
04:12:14.82 process pointer page 9 of 19
04:12:14.86 process pointer page 10 of 19
04:12:14.91 process pointer page 11 of 19
04:12:14.96 process pointer page 12 of 19
04:12:15.07 process pointer page 13 of 19
04:12:15.13 process pointer page 14 of 19
04:12:15.18 process pointer page 15 of 19
04:12:15.30 process pointer page 16 of 19
04:12:15.40 process pointer page 17 of 19
04:12:15.44 process pointer page 18 of 19
04:12:15.47 Index 1 (XQS_1000_3300_DOC_ID)
04:12:15.85 Index 2 (XQS_1000_3300_SND_ID)
04:12:16.32 Index 3 (XQS_1000_3300_RCV_ID)
04:12:16.60 Relation 266 (XQS_1000_3300) is ok
04:12:16.60 Relation 267 (XQS_2000_3300)
04:12:16.60 process pointer page 0 of 1
04:12:16.60 Index 1 (XQS_2000_3300_DOC_ID)
04:12:16.60 Index 2 (XQS_2000_3300_SND_ID)
04:12:16.60 Index 3 (XQS_2000_3300_RCV_ID)
04:12:16.60 Relation 267 (XQS_2000_3300) is ok
04:12:16.60 Relation 268 (XQS_2100_3300)
04:12:16.60 process pointer page 0 of 21
04:12:16.64 process pointer page 1 of 21
04:12:16.71 process pointer page 2 of 21
04:12:16.75 process pointer page 3 of 21
04:12:16.78 process pointer page 4 of 21
04:12:16.83 process pointer page 5 of 21
04:12:16.86 process pointer page 6 of 21
04:12:16.91 process pointer page 7 of 21
04:12:16.94 process pointer page 8 of 21
04:12:16.97 process pointer page 9 of 21
04:12:17.02 process pointer page 10 of 21
04:12:17.06 process pointer page 11 of 21
04:12:17.16 process pointer page 12 of 21
04:12:17.20 process pointer page 13 of 21
04:12:17.25 process pointer page 14 of 21
04:12:17.30 process pointer page 15 of 21
04:12:17.35 process pointer page 16 of 21
04:12:17.38 process pointer page 17 of 21
04:12:17.49 process pointer page 18 of 21
04:12:17.53 process pointer page 19 of 21
04:12:17.58 process pointer page 20 of 21
04:12:17.66 Index 1 (XQS_2100_3300_DOC_ID)
04:12:18.11 Index 2 (XQS_2100_3300_SND_ID)
04:12:18.73 Index 3 (XQS_2100_3300_RCV_ID)
04:12:19.12 Relation 268 (XQS_2100_3300) is ok
04:12:19.12 Relation 269 (XQS_3300_3400)
04:12:19.12 process pointer page 0 of 3
04:12:19.20 process pointer page 1 of 3
04:12:19.30 process pointer page 2 of 3
04:12:19.39 Index 1 (XQS_3300_3400_DOC_ID)
04:12:19.44 Index 2 (XQS_3300_3400_SND_ID)
04:12:19.48 Relation 269 (XQS_3300_3400) is ok
04:12:19.48 Relation 276 (TRACE_STAT)
04:12:19.48 process pointer page 0 of 1
04:12:19.48 Relation 276 (TRACE_STAT) is ok
04:12:19.48 Validation finished
Done for 34340 ms, from 4:11:45.14 to 4:12:19.48.
04:11:45.66 Relation 140 (DOC_LIST)
04:11:45.66 process pointer page 0 of 3
04:11:45.74 process pointer page 1 of 3
04:11:45.86 process pointer page 2 of 3
04:11:45.88 Index 1 (PK_DOC_LIST)
04:11:45.99 Index 2 (DOC_LIST_ID_DESC)
04:11:46.05 Index 3 (FK_DOC_LIST_AGENTS)
04:11:46.10 Relation 140 (DOC_LIST) is ok
04:11:46.10 Relation 141 (DOC_DATA)
04:11:46.10 process pointer page 0 of 8
04:11:46.14 process pointer page 1 of 8
04:11:46.20 process pointer page 2 of 8
04:11:46.31 process pointer page 3 of 8
04:11:46.36 process pointer page 4 of 8
04:11:46.49 process pointer page 5 of 8
04:11:46.63 process pointer page 6 of 8
04:11:46.75 process pointer page 7 of 8
04:11:46.83 Index 2 (DOC_DATA_DOC_WARE_UNQ)
04:11:47.36 Index 3 (DOC_DATA_ID_DESC)
04:11:47.59 Index 4 (FK_DOC_DATA_DOC_LIST)
04:11:47.92 Relation 141 (DOC_DATA) is ok
04:11:47.92 Relation 147 (INVNT_SALDO)
04:11:47.92 process pointer page 0 of 1
04:11:49.50 Index 1 (PK_INVNT_SALDO)
04:11:49.50 Relation 147 (INVNT_SALDO) is ok
04:11:49.50 Relation 150 (PDISTR)
04:11:49.50 process pointer page 0 of 1
04:11:49.53 Index 2 (PDISTR_SND_ID)
04:11:49.54 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
04:11:49.59 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
04:11:49.62 Index 5 (PDISTR_AGENT_ID)
04:11:49.65 Relation 150 (PDISTR) is ok
04:11:49.65 Relation 151 (PSTORNED)
04:11:49.65 process pointer page 0 of 2
04:11:49.78 process pointer page 1 of 2
04:11:49.85 Index 2 (PSTORNED_SND_ID)
04:11:49.92 Index 3 (PSTORNED_RCV_ID)
04:11:49.96 Relation 151 (PSTORNED) is ok
04:11:49.96 Relation 156 (SEMAPHORES)
04:11:49.98 process pointer page 0 of 1
04:11:49.98 Index 1 (PK_SEMAPHORES)
04:11:49.98 Index 2 (SEMAPHORES_TASK_UNQ)
04:11:49.98 Relation 156 (SEMAPHORES) is ok
04:11:49.98 Relation 157 (INVNT_TURNOVER_LOG)
04:11:49.98 process pointer page 0 of 1
04:11:50.00 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
04:11:50.01 Relation 157 (INVNT_TURNOVER_LOG) is ok
04:11:50.01 Relation 160 (PERF_ESTIMATED)
04:11:50.01 process pointer page 0 of 1
04:11:50.04 Index 1 (PERF_EST_MINUTE_SINCE_START)
04:11:50.07 Relation 160 (PERF_ESTIMATED) is ok
04:11:50.07 Relation 161 (PERF_ISQL_STAT)
04:11:50.07 process pointer page 0 of 1
04:11:50.07 Index 1 (PERF_ISQL_STAT_TRN)
04:11:50.07 Relation 161 (PERF_ISQL_STAT) is ok
04:11:50.07 Relation 162 (PERF_LOG)
04:11:50.07 process pointer page 0 of 127
04:11:50.15 process pointer page 1 of 127
04:11:50.21 process pointer page 2 of 127
04:11:50.23 process pointer page 3 of 127
04:11:50.26 process pointer page 4 of 127
04:11:50.29 process pointer page 5 of 127
04:11:50.32 process pointer page 6 of 127
04:11:50.35 process pointer page 7 of 127
04:11:50.39 process pointer page 8 of 127
04:11:50.43 process pointer page 9 of 127
04:11:50.46 process pointer page 10 of 127
04:11:50.48 process pointer page 11 of 127
04:11:50.51 process pointer page 12 of 127
04:11:50.54 process pointer page 13 of 127
04:11:50.56 process pointer page 14 of 127
04:11:50.59 process pointer page 15 of 127
04:11:50.60 process pointer page 16 of 127
04:11:50.62 process pointer page 17 of 127
04:11:50.65 process pointer page 18 of 127
04:11:50.67 process pointer page 19 of 127
04:11:50.68 process pointer page 20 of 127
04:11:50.71 process pointer page 21 of 127
04:11:50.73 process pointer page 22 of 127
04:11:50.76 process pointer page 23 of 127
04:11:50.81 process pointer page 24 of 127
04:11:50.85 process pointer page 25 of 127
04:11:50.87 process pointer page 26 of 127
04:11:50.90 process pointer page 27 of 127
04:11:50.93 process pointer page 28 of 127
04:11:50.99 process pointer page 29 of 127
04:11:51.07 process pointer page 30 of 127
04:11:51.13 process pointer page 31 of 127
04:11:51.21 process pointer page 32 of 127
04:11:51.27 process pointer page 33 of 127
04:11:51.35 process pointer page 34 of 127
04:11:51.40 process pointer page 35 of 127
04:11:51.43 process pointer page 36 of 127
04:11:51.46 process pointer page 37 of 127
04:11:51.49 process pointer page 38 of 127
04:11:51.52 process pointer page 39 of 127
04:11:51.54 process pointer page 40 of 127
04:11:51.57 process pointer page 41 of 127
04:11:51.59 process pointer page 42 of 127
04:11:51.62 process pointer page 43 of 127
04:11:51.65 process pointer page 44 of 127
04:11:51.66 process pointer page 45 of 127
04:11:51.70 process pointer page 46 of 127
04:11:51.71 process pointer page 47 of 127
04:11:51.73 process pointer page 48 of 127
04:11:51.74 process pointer page 49 of 127
04:11:51.77 process pointer page 50 of 127
04:11:51.79 process pointer page 51 of 127
04:11:51.80 process pointer page 52 of 127
04:11:51.84 process pointer page 53 of 127
04:11:51.85 process pointer page 54 of 127
04:11:51.87 process pointer page 55 of 127
04:11:51.90 process pointer page 56 of 127
04:11:51.91 process pointer page 57 of 127
04:11:51.93 process pointer page 58 of 127
04:11:51.96 process pointer page 59 of 127
04:11:51.98 process pointer page 60 of 127
04:11:52.01 process pointer page 61 of 127
04:11:52.04 process pointer page 62 of 127
04:11:52.05 process pointer page 63 of 127
04:11:52.07 process pointer page 64 of 127
04:11:52.09 process pointer page 65 of 127
04:11:52.12 process pointer page 66 of 127
04:11:52.13 process pointer page 67 of 127
04:11:52.15 process pointer page 68 of 127
04:11:52.18 process pointer page 69 of 127
04:11:52.24 process pointer page 70 of 127
04:11:52.27 process pointer page 71 of 127
04:11:52.32 process pointer page 72 of 127
04:11:52.38 process pointer page 73 of 127
04:11:52.46 process pointer page 74 of 127
04:11:52.51 process pointer page 75 of 127
04:11:52.54 process pointer page 76 of 127
04:11:52.57 process pointer page 77 of 127
04:11:52.62 process pointer page 78 of 127
04:11:52.63 process pointer page 79 of 127
04:11:52.66 process pointer page 80 of 127
04:11:52.68 process pointer page 81 of 127
04:11:52.71 process pointer page 82 of 127
04:11:52.74 process pointer page 83 of 127
04:11:52.82 process pointer page 84 of 127
04:11:52.88 process pointer page 85 of 127
04:11:52.94 process pointer page 86 of 127
04:11:52.97 process pointer page 87 of 127
04:11:53.04 process pointer page 88 of 127
04:11:53.07 process pointer page 89 of 127
04:11:53.12 process pointer page 90 of 127
04:11:53.18 process pointer page 91 of 127
04:11:53.26 process pointer page 92 of 127
04:11:53.32 process pointer page 93 of 127
04:11:53.40 process pointer page 94 of 127
04:11:53.44 process pointer page 95 of 127
04:11:53.47 process pointer page 96 of 127
04:11:53.51 process pointer page 97 of 127
04:11:53.55 process pointer page 98 of 127
04:11:53.57 process pointer page 99 of 127
04:11:53.63 process pointer page 100 of 127
04:11:53.66 process pointer page 101 of 127
04:11:53.69 process pointer page 102 of 127
04:11:53.72 process pointer page 103 of 127
04:11:53.75 process pointer page 104 of 127
04:11:53.77 process pointer page 105 of 127
04:11:53.83 process pointer page 106 of 127
04:11:53.86 process pointer page 107 of 127
04:11:53.90 process pointer page 108 of 127
04:11:53.93 process pointer page 109 of 127
04:11:53.96 process pointer page 110 of 127
04:11:53.99 process pointer page 111 of 127
04:11:54.00 process pointer page 112 of 127
04:11:54.05 process pointer page 113 of 127
04:11:54.11 process pointer page 114 of 127
04:11:54.19 process pointer page 115 of 127
04:11:54.25 process pointer page 116 of 127
04:11:54.30 process pointer page 117 of 127
04:11:54.33 process pointer page 118 of 127
04:11:54.35 process pointer page 119 of 127
04:11:54.38 process pointer page 120 of 127
04:11:54.46 process pointer page 121 of 127
04:11:54.52 process pointer page 122 of 127
04:11:54.60 process pointer page 123 of 127
04:11:54.63 process pointer page 124 of 127
04:11:54.66 process pointer page 125 of 127
04:11:54.69 process pointer page 126 of 127
04:11:54.69 Index 1 (PERF_LOG_DTS_BEG_DESC)
04:11:56.41 Index 2 (PERF_LOG_UNIT)
04:11:59.20 Index 3 (PERF_LOG_TRN_DESC)
04:12:00.56 Index 4 (PERF_LOG_GDSCODE)
04:12:01.60 Relation 162 (PERF_LOG) is ok
04:12:01.60 Relation 166 (V_STOPTEST)
04:12:01.60 Relation 166 (V_STOPTEST) is ok
04:12:01.60 Relation 183 (V_QDISTR_SOURCE)
04:12:01.60 Relation 183 (V_QDISTR_SOURCE) is ok
04:12:01.60 Relation 184 (V_QSTORNED_SOURCE)
04:12:01.60 Relation 184 (V_QSTORNED_SOURCE) is ok
04:12:01.60 Relation 258 (XQD_1000_1200)
04:12:01.62 process pointer page 0 of 1
04:12:01.62 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
04:12:01.62 Relation 258 (XQD_1000_1200) is ok
04:12:01.62 Relation 259 (XQD_1200_2000)
04:12:01.62 process pointer page 0 of 2
04:12:01.67 process pointer page 1 of 2
04:12:01.67 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
04:12:01.68 Relation 259 (XQD_1200_2000) is ok
04:12:01.68 Relation 260 (XQD_1000_3300)
04:12:01.68 process pointer page 0 of 4
04:12:01.71 process pointer page 1 of 4
04:12:01.76 process pointer page 2 of 4
04:12:01.79 process pointer page 3 of 4
04:12:01.81 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
04:12:01.87 Index 2 (XQD_1000_3300_DOC)
04:12:01.92 Relation 260 (XQD_1000_3300) is ok
04:12:01.92 Relation 261 (XQD_2000_3300)
04:12:01.92 process pointer page 0 of 35
04:12:01.96 process pointer page 1 of 35
04:12:02.03 process pointer page 2 of 35
04:12:02.12 process pointer page 3 of 35
04:12:02.20 process pointer page 4 of 35
04:12:02.32 process pointer page 5 of 35
04:12:02.45 process pointer page 6 of 35
04:12:02.53 process pointer page 7 of 35
04:12:02.59 process pointer page 8 of 35
04:12:02.68 process pointer page 9 of 35
04:12:02.82 process pointer page 10 of 35
04:12:02.88 process pointer page 11 of 35
04:12:02.95 process pointer page 12 of 35
04:12:03.01 process pointer page 13 of 35
04:12:03.10 process pointer page 14 of 35
04:12:03.16 process pointer page 15 of 35
04:12:03.31 process pointer page 16 of 35
04:12:03.48 process pointer page 17 of 35
04:12:03.65 process pointer page 18 of 35
04:12:03.71 process pointer page 19 of 35
04:12:03.77 process pointer page 20 of 35
04:12:03.84 process pointer page 21 of 35
04:12:03.88 process pointer page 22 of 35
04:12:03.93 process pointer page 23 of 35
04:12:03.99 process pointer page 24 of 35
04:12:04.04 process pointer page 25 of 35
04:12:04.07 process pointer page 26 of 35
04:12:04.19 process pointer page 27 of 35
04:12:04.26 process pointer page 28 of 35
04:12:04.30 process pointer page 29 of 35
04:12:04.35 process pointer page 30 of 35
04:12:04.40 process pointer page 31 of 35
04:12:04.44 process pointer page 32 of 35
04:12:04.54 process pointer page 33 of 35
04:12:04.58 process pointer page 34 of 35
04:12:04.68 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
04:12:05.44 Relation 261 (XQD_2000_3300) is ok
04:12:05.44 Relation 262 (XQD_2100_3300)
04:12:05.46 process pointer page 0 of 2
04:12:05.46 process pointer page 1 of 2
04:12:05.46 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
04:12:05.46 Relation 262 (XQD_2100_3300) is ok
04:12:05.46 Relation 263 (XQD_3300_3400)
04:12:05.46 process pointer page 0 of 20
04:12:05.52 process pointer page 1 of 20
04:12:05.57 process pointer page 2 of 20
04:12:05.61 process pointer page 3 of 20
04:12:05.71 process pointer page 4 of 20
04:12:05.79 process pointer page 5 of 20
04:12:05.93 process pointer page 6 of 20
04:12:06.08 process pointer page 7 of 20
04:12:06.21 process pointer page 8 of 20
04:12:06.30 process pointer page 9 of 20
04:12:06.44 process pointer page 10 of 20
04:12:06.50 process pointer page 11 of 20
04:12:06.57 process pointer page 12 of 20
04:12:06.61 process pointer page 13 of 20
04:12:06.66 process pointer page 14 of 20
04:12:06.74 process pointer page 15 of 20
04:12:06.82 process pointer page 16 of 20
04:12:06.88 process pointer page 17 of 20
04:12:06.92 process pointer page 18 of 20
04:12:06.97 process pointer page 19 of 20
04:12:07.03 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
04:12:07.66 Relation 263 (XQD_3300_3400) is ok
04:12:07.66 Relation 264 (XQS_1000_1200)
04:12:07.66 process pointer page 0 of 19
04:12:07.75 process pointer page 1 of 19
04:12:07.81 process pointer page 2 of 19
04:12:07.84 process pointer page 3 of 19
04:12:07.88 process pointer page 4 of 19
04:12:07.92 process pointer page 5 of 19
04:12:07.95 process pointer page 6 of 19
04:12:08.00 process pointer page 7 of 19
04:12:08.09 process pointer page 8 of 19
04:12:08.13 process pointer page 9 of 19
04:12:08.17 process pointer page 10 of 19
04:12:08.25 process pointer page 11 of 19
04:12:08.31 process pointer page 12 of 19
04:12:08.36 process pointer page 13 of 19
04:12:08.39 process pointer page 14 of 19
04:12:08.44 process pointer page 15 of 19
04:12:08.47 process pointer page 16 of 19
04:12:08.50 process pointer page 17 of 19
04:12:08.53 process pointer page 18 of 19
04:12:08.55 Index 1 (XQS_1000_1200_DOC_ID)
04:12:08.77 Index 2 (XQS_1000_1200_SND_ID)
04:12:09.12 Index 3 (XQS_1000_1200_RCV_ID)
04:12:09.39 Relation 264 (XQS_1000_1200) is ok
04:12:09.39 Relation 265 (XQS_1200_2000)
04:12:09.39 process pointer page 0 of 39
04:12:09.42 process pointer page 1 of 39
04:12:09.45 process pointer page 2 of 39
04:12:09.48 process pointer page 3 of 39
04:12:09.51 process pointer page 4 of 39
04:12:09.55 process pointer page 5 of 39
04:12:09.58 process pointer page 6 of 39
04:12:09.62 process pointer page 7 of 39
04:12:09.65 process pointer page 8 of 39
04:12:09.70 process pointer page 9 of 39
04:12:09.73 process pointer page 10 of 39
04:12:09.76 process pointer page 11 of 39
04:12:09.86 process pointer page 12 of 39
04:12:09.92 process pointer page 13 of 39
04:12:10.08 process pointer page 14 of 39
04:12:10.22 process pointer page 15 of 39
04:12:10.36 process pointer page 16 of 39
04:12:10.40 process pointer page 17 of 39
04:12:10.47 process pointer page 18 of 39
04:12:10.53 process pointer page 19 of 39
04:12:10.59 process pointer page 20 of 39
04:12:10.64 process pointer page 21 of 39
04:12:10.68 process pointer page 22 of 39
04:12:10.72 process pointer page 23 of 39
04:12:10.76 process pointer page 24 of 39
04:12:10.79 process pointer page 25 of 39
04:12:10.84 process pointer page 26 of 39
04:12:10.90 process pointer page 27 of 39
04:12:10.98 process pointer page 28 of 39
04:12:11.04 process pointer page 29 of 39
04:12:11.18 process pointer page 30 of 39
04:12:11.31 process pointer page 31 of 39
04:12:11.43 process pointer page 32 of 39
04:12:11.48 process pointer page 33 of 39
04:12:11.54 process pointer page 34 of 39
04:12:11.59 process pointer page 35 of 39
04:12:11.62 process pointer page 36 of 39
04:12:11.65 process pointer page 37 of 39
04:12:11.68 process pointer page 38 of 39
04:12:11.68 Index 1 (XQS_1200_2000_DOC_ID)
04:12:12.52 Index 2 (XQS_1200_2000_SND_ID)
04:12:13.57 Index 3 (XQS_1200_2000_RCV_ID)
04:12:14.15 Relation 265 (XQS_1200_2000) is ok
04:12:14.15 Relation 266 (XQS_1000_3300)
04:12:14.16 process pointer page 0 of 19
04:12:14.23 process pointer page 1 of 19
04:12:14.30 process pointer page 2 of 19
04:12:14.37 process pointer page 3 of 19
04:12:14.44 process pointer page 4 of 19
04:12:14.52 process pointer page 5 of 19
04:12:14.60 process pointer page 6 of 19
04:12:14.65 process pointer page 7 of 19
04:12:14.74 process pointer page 8 of 19
04:12:14.82 process pointer page 9 of 19
04:12:14.86 process pointer page 10 of 19
04:12:14.91 process pointer page 11 of 19
04:12:14.96 process pointer page 12 of 19
04:12:15.07 process pointer page 13 of 19
04:12:15.13 process pointer page 14 of 19
04:12:15.18 process pointer page 15 of 19
04:12:15.30 process pointer page 16 of 19
04:12:15.40 process pointer page 17 of 19
04:12:15.44 process pointer page 18 of 19
04:12:15.47 Index 1 (XQS_1000_3300_DOC_ID)
04:12:15.85 Index 2 (XQS_1000_3300_SND_ID)
04:12:16.32 Index 3 (XQS_1000_3300_RCV_ID)
04:12:16.60 Relation 266 (XQS_1000_3300) is ok
04:12:16.60 Relation 267 (XQS_2000_3300)
04:12:16.60 process pointer page 0 of 1
04:12:16.60 Index 1 (XQS_2000_3300_DOC_ID)
04:12:16.60 Index 2 (XQS_2000_3300_SND_ID)
04:12:16.60 Index 3 (XQS_2000_3300_RCV_ID)
04:12:16.60 Relation 267 (XQS_2000_3300) is ok
04:12:16.60 Relation 268 (XQS_2100_3300)
04:12:16.60 process pointer page 0 of 21
04:12:16.64 process pointer page 1 of 21
04:12:16.71 process pointer page 2 of 21
04:12:16.75 process pointer page 3 of 21
04:12:16.78 process pointer page 4 of 21
04:12:16.83 process pointer page 5 of 21
04:12:16.86 process pointer page 6 of 21
04:12:16.91 process pointer page 7 of 21
04:12:16.94 process pointer page 8 of 21
04:12:16.97 process pointer page 9 of 21
04:12:17.02 process pointer page 10 of 21
04:12:17.06 process pointer page 11 of 21
04:12:17.16 process pointer page 12 of 21
04:12:17.20 process pointer page 13 of 21
04:12:17.25 process pointer page 14 of 21
04:12:17.30 process pointer page 15 of 21
04:12:17.35 process pointer page 16 of 21
04:12:17.38 process pointer page 17 of 21
04:12:17.49 process pointer page 18 of 21
04:12:17.53 process pointer page 19 of 21
04:12:17.58 process pointer page 20 of 21
04:12:17.66 Index 1 (XQS_2100_3300_DOC_ID)
04:12:18.11 Index 2 (XQS_2100_3300_SND_ID)
04:12:18.73 Index 3 (XQS_2100_3300_RCV_ID)
04:12:19.12 Relation 268 (XQS_2100_3300) is ok
04:12:19.12 Relation 269 (XQS_3300_3400)
04:12:19.12 process pointer page 0 of 3
04:12:19.20 process pointer page 1 of 3
04:12:19.30 process pointer page 2 of 3
04:12:19.39 Index 1 (XQS_3300_3400_DOC_ID)
04:12:19.44 Index 2 (XQS_3300_3400_SND_ID)
04:12:19.48 Relation 269 (XQS_3300_3400) is ok
04:12:19.48 Relation 276 (TRACE_STAT)
04:12:19.48 process pointer page 0 of 1
04:12:19.48 Relation 276 (TRACE_STAT) is ok
04:12:19.48 Validation finished
Done for 34340 ms, from 4:11:45.14 to 4:12:19.48.
Differences between old and current firebird.log
4:12:20.50. Got:STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 5 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-01-19 04:12 309 oltp25_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
Comparison of old and new firebird.log (get messages that appeared during test):
+++ Start of comparison +++result: files match. No new messages appeared in firebird.log during test ran.
+++ End of comparison +++
Final processing ISQL logs in e:\temp\logs.oltp25
Remove 32 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.oltp25\oltp25_*.*:
| ERRORS_CHECKING_RESULT |
|---|
| NO_SEVERE_ERRORS_FOUND |
2016-01-19 4:12:26.27 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html