en
brLogs 2.5
Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 4. 2015-12-19 3:56:21.79.
Server implementation: Firebird/x86-64/Windows NT
Done for 26760 ms, from 3:56:54.69 to 3:57:21.45.
Done for 43940 ms, from 3:58:03.47 to 3:58:47.41.
Done for 7620 ms, from 3:58:47.67 to 3:58:55.29.
Done for 68600 ms, from 3:59:56.31 to 4:01:04.91.
Done for 5120 ms, from 4:01:07.73 to 4:01:12.85.
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 182071
MON$OLDEST_ACTIVE 182072
MON$OLDEST_SNAPSHOT 182072
MON$NEXT_TRANSACTION 182072
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 478649
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26958 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26958 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26958 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26958 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 186625
Page size 8192
ODS version 11.2
Oldest transaction 182073
Oldest active 182074
Oldest snapshot 182074
Next transaction 182075
Bumped transaction 1
Sequence number 0
Next attachment ID 4541
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: 36.98, total records: 1225632
Average version length: 46.46, total versions: 252317, max versions: 1
Data pages: 12995, data page slots: 12995, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 9721
80 - 99% = 3273
Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 4394, nodes: 1225632
Average data length: 13.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 527
20 - 39% = 1
40 - 59% = 1838
60 - 79% = 1
80 - 99% = 2027
Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 3521, nodes: 1225632
Average data length: 5.71, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3521
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 1356, nodes: 1225632
Average data length: 1.63, total dup: 895821, max dup: 49
Fill distribution:
0 - 19% = 100
20 - 39% = 1
40 - 59% = 432
60 - 79% = 0
80 - 99% = 823
DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 60.46, total records: 285386
Average version length: 37.76, total versions: 8799, max versions: 3
Data pages: 3558, data page slots: 3558, average fill: 78%
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3292
80 - 99% = 264
Index DOC_LIST_ID_DESC (1)
Depth: 3, leaf buckets: 983, nodes: 285386
Average data length: 6.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 330
40 - 59% = 643
60 - 79% = 10
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 306, nodes: 285386
Average data length: 0.01, total dup: 285336, max dup: 32804
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 254
60 - 79% = 38
80 - 99% = 14
Index PK_DOC_LIST (0)
Depth: 3, leaf buckets: 572, nodes: 285386
Average data length: 6.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 41
20 - 39% = 19
40 - 59% = 72
60 - 79% = 150
80 - 99% = 290
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: 63.93, total records: 400
Average version length: 14.73, total versions: 962, max versions: 11
Data pages: 14, data page slots: 14, average fill: 65%
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 8
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: 24.16, total records: 1915
Average version length: 70.19, total versions: 1256, max versions: 1
Data pages: 36, data page slots: 136, average fill: 65%
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 6
60 - 79% = 15
80 - 99% = 10
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 9, nodes: 1915
Average data length: 11.87, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 5
60 - 79% = 1
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 15.96, total records: 49
Average version length: 9.00, total versions: 64, max versions: 5
Data pages: 1, data page slots: 1, average fill: 42%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
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: 30.39, total records: 82
Average version length: 46.04, total versions: 28, max versions: 1
Data pages: 1, data page slots: 1, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 1, leaf buckets: 1, nodes: 82
Average data length: 5.04, total dup: 53, max dup: 17
Fill distribution:
0 - 19% = 1
20 - 39% = 0
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: 43.33, total records: 114719
Average version length: 37.43, total versions: 2327, max versions: 4
Data pages: 1232, data page slots: 1232, average fill: 71%
Fill distribution:
0 - 19% = 8
20 - 39% = 11
40 - 59% = 30
60 - 79% = 1183
80 - 99% = 0
Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 95, nodes: 114719
Average data length: 0.01, total dup: 114670, max dup: 5148
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 56
60 - 79% = 19
80 - 99% = 15
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 119, nodes: 114719
Average data length: 0.87, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 2
20 - 39% = 15
40 - 59% = 44
60 - 79% = 36
80 - 99% = 22
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 117, nodes: 114719
Average data length: 0.87, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 49
60 - 79% = 36
80 - 99% = 20
Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 126, nodes: 114719
Average data length: 0.66, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 40
60 - 79% = 44
80 - 99% = 8
PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.95, total records: 98839
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 845, data page slots: 845, average fill: 64%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 844
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 75, nodes: 98839
Average data length: 0.00, total dup: 98648, max dup: 925
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 26
60 - 79% = 38
80 - 99% = 11
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: 149.51, total records: 6146181
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 144221, data page slots: 144221, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 144220
Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 7307, nodes: 6146181
Average data length: 0.68, total dup: 2441041, max dup: 12
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 4698
60 - 79% = 1662
80 - 99% = 943
Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 5863, nodes: 6146181
Average data length: 0.00, total dup: 6146176, max dup: 5319633
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 5395
60 - 79% = 0
80 - 99% = 468
Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 7140, nodes: 6146181
Average data length: 0.16, total dup: 5996181, max dup: 29309
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 5794
60 - 79% = 738
80 - 99% = 604
Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 7112, nodes: 6146181
Average data length: 0.08, total dup: 6123394, max dup: 494926
Fill distribution:
0 - 19% = 8
20 - 39% = 1
40 - 59% = 6138
60 - 79% = 423
80 - 99% = 542
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: 46.27, total records: 186205
Average version length: 55.86, total versions: 33077, max versions: 1
Data pages: 2204, data page slots: 2204, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1592
80 - 99% = 611
Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 225, nodes: 186205
Average data length: 1.15, total dup: 153464, max dup: 375
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 139
60 - 79% = 76
80 - 99% = 9
Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 184, nodes: 186205
Average data length: 0.64, total dup: 168705, max dup: 121
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 85
60 - 79% = 64
80 - 99% = 34
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: 17, max versions: 15
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 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
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: 8.22, total records: 1935
Average version length: 71.19, total versions: 1712, max versions: 1
Data pages: 27, data page slots: 101, average fill: 91%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 26
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 3, nodes: 1935
Average data length: 3.43, total dup: 1688, max dup: 14
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2
80 - 99% = 0
XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 65.39, total records: 62723
Average version length: 71.07, total versions: 5074, max versions: 1
Data pages: 1162, data page slots: 1217, average fill: 60%
Fill distribution:
0 - 19% = 114
20 - 39% = 145
40 - 59% = 198
60 - 79% = 486
80 - 99% = 219
Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 70, nodes: 62723
Average data length: 0.42, total dup: 58652, max dup: 101
Fill distribution:
0 - 19% = 0
20 - 39% = 26
40 - 59% = 24
60 - 79% = 13
80 - 99% = 7
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 96, nodes: 62723
Average data length: 1.49, total dup: 53801, max dup: 14
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 54
60 - 79% = 11
80 - 99% = 1
XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 29.54, total records: 7786
Average version length: 71.18, total versions: 4556, max versions: 1
Data pages: 150, data page slots: 429, average fill: 64%
Fill distribution:
0 - 19% = 11
20 - 39% = 24
40 - 59% = 31
60 - 79% = 14
80 - 99% = 70
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 14, nodes: 7786
Average data length: 2.29, total dup: 6724, max dup: 41
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 7
60 - 79% = 2
80 - 99% = 0
XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 11.03, total records: 2660595
Average version length: 69.61, total versions: 2248350, max versions: 1
Data pages: 36083, data page slots: 36083, average fill: 91%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5040
80 - 99% = 31042
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 3709, nodes: 2660595
Average data length: 0.92, total dup: 2408577, max dup: 99
Fill distribution:
0 - 19% = 3
20 - 39% = 70
40 - 59% = 3334
60 - 79% = 139
80 - 99% = 163
XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 18.27, total records: 3075
Average version length: 70.99, total versions: 2286, max versions: 1
Data pages: 86, data page slots: 594, average fill: 46%
Fill distribution:
0 - 19% = 12
20 - 39% = 25
40 - 59% = 23
60 - 79% = 20
80 - 99% = 6
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 8, nodes: 3075
Average data length: 2.84, total dup: 2636, max dup: 47
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 34.31, total records: 2754981
Average version length: 69.41, total versions: 1412540, max versions: 1
Data pages: 37350, data page slots: 37350, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 7381
80 - 99% = 29966
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 4114, nodes: 2754981
Average data length: 1.51, total dup: 2301991, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 3815
60 - 79% = 149
80 - 99% = 149
XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 76.39, total records: 2024595
Average version length: 81.89, total versions: 139409, max versions: 1
Data pages: 30565, data page slots: 30565, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 6172
80 - 99% = 24392
Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 2240, nodes: 2024595
Average data length: 0.15, total dup: 1979164, max dup: 199
Fill distribution:
0 - 19% = 11
20 - 39% = 2
40 - 59% = 1587
60 - 79% = 550
80 - 99% = 90
Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 1495, nodes: 2024595
Average data length: 0.70, total dup: 1774410, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 55
60 - 79% = 3
80 - 99% = 1435
Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 2532, nodes: 2024595
Average data length: 0.71, total dup: 1775379, max dup: 41
Fill distribution:
0 - 19% = 23
20 - 39% = 0
40 - 59% = 1761
60 - 79% = 651
80 - 99% = 97
XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 47.23, total records: 2369195
Average version length: 81.46, total versions: 1010592, max versions: 1
Data pages: 35697, data page slots: 35697, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1
60 - 79% = 1561
80 - 99% = 34134
Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2209, nodes: 2369195
Average data length: 0.10, total dup: 2335838, max dup: 816
Fill distribution:
0 - 19% = 3
20 - 39% = 4
40 - 59% = 801
60 - 79% = 934
80 - 99% = 467
Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2259, nodes: 2369195
Average data length: 1.00, total dup: 1974660, max dup: 14
Fill distribution:
0 - 19% = 66
20 - 39% = 1
40 - 59% = 669
60 - 79% = 2
80 - 99% = 1521
Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 2431, nodes: 2369195
Average data length: 0.44, total dup: 2191012, max dup: 134
Fill distribution:
0 - 19% = 36
20 - 39% = 7
40 - 59% = 920
60 - 79% = 959
80 - 99% = 509
XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 58.54, total records: 2794040
Average version length: 82.17, total versions: 802882, max versions: 1
Data pages: 42154, data page slots: 42154, average fill: 84%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7599
80 - 99% = 34554
Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 2688, nodes: 2794040
Average data length: 0.04, total dup: 2781878, max dup: 1536
Fill distribution:
0 - 19% = 5
20 - 39% = 15
40 - 59% = 1261
60 - 79% = 950
80 - 99% = 457
Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 2042, nodes: 2794040
Average data length: 0.53, total dup: 2531367, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 109
60 - 79% = 19
80 - 99% = 1913
Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 2972, nodes: 2794040
Average data length: 0.51, total dup: 2543762, max dup: 273
Fill distribution:
0 - 19% = 10
20 - 39% = 15
40 - 59% = 1335
60 - 79% = 1091
80 - 99% = 521
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: 49.84, total records: 2605096
Average version length: 81.34, total versions: 1026972, max versions: 1
Data pages: 39173, data page slots: 39173, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1596
80 - 99% = 37576
Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2476, nodes: 2605096
Average data length: 0.03, total dup: 2596580, max dup: 1599
Fill distribution:
0 - 19% = 4
20 - 39% = 32
40 - 59% = 1071
60 - 79% = 922
80 - 99% = 447
Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2664, nodes: 2605096
Average data length: 1.01, total dup: 2167810, max dup: 14
Fill distribution:
0 - 19% = 69
20 - 39% = 34
40 - 59% = 884
60 - 79% = 82
80 - 99% = 1595
Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 2702, nodes: 2605096
Average data length: 0.41, total dup: 2423929, max dup: 144
Fill distribution:
0 - 19% = 4
20 - 39% = 23
40 - 59% = 1141
60 - 79% = 1070
80 - 99% = 464
XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 38.13, total records: 425620
Average version length: 68.53, total versions: 189937, max versions: 1
Data pages: 5737, data page slots: 5737, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1701
80 - 99% = 4035
Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 404, nodes: 425620
Average data length: 0.33, total dup: 404790, max dup: 127
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 164
60 - 79% = 144
80 - 99% = 96
Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 464, nodes: 425620
Average data length: 0.88, total dup: 365899, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 191
60 - 79% = 183
80 - 99% = 90
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 13930 ms, from 4:01:13.04 to 4:01:26.97.
Done for 2140 ms, from 4:01:35.78 to 4:01:37.92.
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:
2015-12-19 04:01 309 oltp25_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
Comparing files E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
FC: no differences encountered
+++ end of comparison +++
Remove 14 logs of every ISQL session if there were no serious errors.
ISQL logs are removed because no severe errors occured during test.
2015-12-19 4:01:58.15 - 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.26958 Firebird 2.5Server implementation: Firebird/x86-64/Windows NT
| FB_ARCHITECTURE | DB_NAME | FORCED_WRITES | SWEEP_INT | PAGE_BUFFERS | PAGE_SIZE |
|---|---|---|---|---|---|
| SuperClassic 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 |
| 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. | 2015-12-19 03:56:11.4040 | -1 | <null> | 127.0.0.1 | 181970 | 4504 | 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: | 4160.84 | 828 | 748951 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| customer order: creation | 159.10 | 66 | 28638 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| customer order: refuse | 13.38 | 47 | 2409 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| order to supplier: creation | 41.39 | 182 | 7451 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| order to supplier: removal | 1.09 | 8273 | 195 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| invoice (draft): creation | 40.52 | 225 | 7294 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| invoice (draft): removal | 13.26 | 93 | 2387 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| invoice accept: apply | 26.55 | 3831 | 4779 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| invoice accept: cancel | 6.96 | 626 | 1245 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| customer reserve: creation | 3230.67 | 24 | 581520 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| customer reserve: removal | 394.20 | 21 | 70561 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| realization accept: apply | 75.19 | 67 | 13535 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| realization accept: cancel | 29.36 | 40 | 5284 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| payment from customer: creation | 53.03 | 95 | 9545 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| payment from customer: removal | 5.07 | 29 | 912 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| payment to supplier: creation | 43.63 | 141 | 7853 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| payment to supplier: removal | 3.27 | 31 | 588 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| service: total inventory turnovers | 16.14 | 109 | 2906 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| service: total monetary turnovers | 10.26 | 3 | 1837 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| service: refresh index statistics | 0.07 | 1823 | 12 | 2015-12-19 00:56 | 2015-12-19 03:56 |
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 | 2784 | 54065 | 50111 | 3954 | 7.31 | 00:56:12 | 01:14:12 |
| interval # 2, overall | 2 | 3932 | 77412 | 70776 | 6636 | 8.57 | 01:14:13 | 01:32:13 |
| interval # 3, overall | 3 | 4077 | 81288 | 73382 | 7906 | 9.73 | 01:32:14 | 01:50:14 |
| interval # 4, overall | 4 | 5108 | 95186 | 91939 | 3247 | 3.41 | 01:50:15 | 02:08:15 |
| interval # 5, overall | 5 | 4820 | 98534 | 86761 | 11773 | 11.95 | 02:08:16 | 02:26:16 |
| interval # 6, overall | 6 | 3905 | 86636 | 70290 | 16346 | 18.87 | 02:26:17 | 02:44:17 |
| interval # 7, overall | 7 | 3680 | 85747 | 66236 | 19511 | 22.75 | 02:44:18 | 03:02:18 |
| interval # 8, overall | 8 | 3805 | 85074 | 68488 | 16586 | 19.50 | 03:02:19 | 03:20:19 |
| interval # 9, overall | 9 | 4278 | 97576 | 77002 | 20574 | 21.09 | 03:20:20 | 03:38:20 |
| interval # 10, overall | 10 | 5220 | 105111 | 93966 | 11145 | 10.60 | 03:38:21 | 03:56:21 |
Performance for every MINUTE:
| TEST_PHASE | MINUTE_SINCE_TEST_START | AVG_ESTIMATED | MIN_TO_AVG_RATIO | MAX_TO_AVG_RATIO | ROWS_AGGREGATED |
|---|---|---|---|---|---|
| WARM_TIME | 1 | 2192.14 | 0.6705 | 1.1746 | 272 |
| WARM_TIME | 2 | 1338.38 | 0.9619 | 1.0706 | 57 |
| WARM_TIME | 3 | 1045.91 | 0.9554 | 1.0963 | 88 |
| WARM_TIME | 4 | 1020.20 | 0.8432 | 1.0956 | 386 |
| WARM_TIME | 5 | 1012.28 | 0.8894 | 1.0700 | 241 |
| WARM_TIME | 6 | 1010.38 | 0.8981 | 1.1045 | 510 |
| WARM_TIME | 7 | 1034.27 | 0.9400 | 1.1033 | 332 |
| WARM_TIME | 8 | 1094.19 | 0.9126 | 1.0747 | 472 |
| WARM_TIME | 9 | 1136.73 | 0.9210 | 1.0750 | 532 |
| WARM_TIME | 10 | 1204.11 | 0.9134 | 1.0847 | 593 |
| TEST_TIME | 11 | 1291.18 | 0.9196 | 1.0849 | 609 |
| TEST_TIME | 12 | 1387.95 | 0.9252 | 1.0856 | 678 |
| TEST_TIME | 13 | 1484.56 | 0.9369 | 1.0540 | 658 |
| TEST_TIME | 14 | 1534.62 | 0.9468 | 1.0655 | 503 |
| TEST_TIME | 15 | 1603.04 | 0.9521 | 1.0388 | 339 |
| TEST_TIME | 16 | 1645.84 | 0.9486 | 1.0515 | 441 |
| TEST_TIME | 17 | 1682.02 | 0.9684 | 1.0425 | 305 |
| TEST_TIME | 18 | 1707.38 | 0.9763 | 1.0208 | 180 |
| TEST_TIME | 19 | 1738.52 | 0.9498 | 1.0496 | 677 |
| TEST_TIME | 20 | 1800.68 | 0.9627 | 1.0366 | 517 |
| TEST_TIME | 21 | 1841.63 | 0.9653 | 1.0418 | 519 |
| TEST_TIME | 22 | 1905.41 | 0.9612 | 1.0493 | 418 |
| TEST_TIME | 23 | 1943.27 | 0.9847 | 1.0231 | 150 |
| TEST_TIME | 24 | 1981.58 | 0.9615 | 1.0326 | 458 |
| TEST_TIME | 25 | 2044.84 | 0.9607 | 1.0371 | 799 |
| TEST_TIME | 26 | 2111.61 | 0.9657 | 1.0307 | 721 |
| TEST_TIME | 27 | 2176.86 | 0.9628 | 1.0341 | 647 |
| TEST_TIME | 28 | 2212.69 | 0.9810 | 1.0231 | 446 |
| TEST_TIME | 29 | 2252.50 | 0.9703 | 1.0243 | 708 |
| TEST_TIME | 30 | 2269.86 | 0.9841 | 1.0201 | 383 |
| TEST_TIME | 31 | 2291.13 | 0.9780 | 1.0188 | 420 |
| TEST_TIME | 32 | 2333.45 | 0.9696 | 1.0260 | 614 |
| TEST_TIME | 33 | 2384.55 | 0.9736 | 1.0287 | 575 |
| TEST_TIME | 34 | 2432.32 | 0.9789 | 1.0228 | 316 |
| TEST_TIME | 35 | 2471.59 | 0.9778 | 1.0202 | 517 |
| TEST_TIME | 36 | 2496.60 | 0.9819 | 1.0146 | 542 |
| TEST_TIME | 37 | 2532.06 | 0.9754 | 1.0136 | 481 |
| TEST_TIME | 38 | 2548.85 | 0.9820 | 1.0198 | 487 |
| TEST_TIME | 39 | 2583.79 | 0.9803 | 1.0199 | 548 |
| TEST_TIME | 40 | 2614.88 | 0.9826 | 1.0213 | 675 |
| TEST_TIME | 41 | 2668.43 | 0.9764 | 1.0240 | 761 |
| TEST_TIME | 42 | 2738.05 | 0.9748 | 1.0201 | 589 |
| TEST_TIME | 43 | 2791.19 | 0.9774 | 1.0162 | 654 |
| TEST_TIME | 44 | 2834.43 | 0.9793 | 1.0186 | 534 |
| TEST_TIME | 45 | 2874.13 | 0.9822 | 1.0154 | 525 |
| TEST_TIME | 46 | 2902.31 | 0.9837 | 1.0144 | 535 |
| TEST_TIME | 47 | 2941.07 | 0.9797 | 1.0094 | 448 |
| TEST_TIME | 48 | 2949.18 | 0.9857 | 1.0133 | 512 |
| TEST_TIME | 49 | 2964.49 | 0.9875 | 1.0095 | 339 |
| TEST_TIME | 50 | 2972.60 | 0.9867 | 1.0099 | 495 |
| TEST_TIME | 51 | 2990.09 | 0.9843 | 1.0130 | 546 |
| TEST_TIME | 52 | 3006.63 | 0.9880 | 1.0093 | 458 |
| TEST_TIME | 53 | 3012.85 | 0.9883 | 1.0108 | 387 |
| TEST_TIME | 54 | 3020.70 | 0.9912 | 1.0083 | 226 |
| TEST_TIME | 55 | 2999.63 | 0.9970 | 1.0052 | 139 |
| TEST_TIME | 56 | 2999.94 | 0.9872 | 1.0084 | 235 |
| TEST_TIME | 57 | 3020.94 | 0.9838 | 1.0139 | 562 |
| TEST_TIME | 58 | 3070.70 | 0.9803 | 1.0138 | 551 |
| TEST_TIME | 59 | 3103.57 | 0.9861 | 1.0146 | 643 |
| TEST_TIME | 60 | 3144.93 | 0.9846 | 1.0141 | 458 |
| TEST_TIME | 61 | 3177.23 | 0.9876 | 1.0136 | 486 |
| TEST_TIME | 62 | 3212.65 | 0.9863 | 1.0106 | 408 |
| TEST_TIME | 63 | 3223.23 | 0.9913 | 1.0083 | 227 |
| TEST_TIME | 64 | 3230.34 | 0.9904 | 1.0133 | 528 |
| TEST_TIME | 65 | 3253.85 | 0.9905 | 1.0092 | 538 |
| TEST_TIME | 66 | 3284.11 | 0.9848 | 1.0096 | 382 |
| TEST_TIME | 67 | 3302.48 | 0.9890 | 1.0062 | 413 |
| TEST_TIME | 68 | 3300.20 | 0.9921 | 1.0079 | 278 |
| TEST_TIME | 69 | 3321.10 | 0.9871 | 1.0133 | 495 |
| TEST_TIME | 70 | 3354.27 | 0.9890 | 1.0102 | 447 |
| TEST_TIME | 71 | 3385.15 | 0.9869 | 1.0126 | 421 |
| TEST_TIME | 72 | 3415.16 | 0.9940 | 1.0061 | 266 |
| TEST_TIME | 73 | 3425.26 | 0.9894 | 1.0071 | 444 |
| TEST_TIME | 74 | 3442.45 | 0.9885 | 1.0118 | 433 |
| TEST_TIME | 75 | 3472.45 | 0.9907 | 1.0106 | 419 |
| TEST_TIME | 76 | 3494.36 | 0.9918 | 1.0080 | 351 |
| TEST_TIME | 77 | 3506.19 | 0.9916 | 1.0108 | 466 |
| TEST_TIME | 78 | 3537.55 | 0.9890 | 1.0079 | 423 |
| TEST_TIME | 79 | 3561.36 | 0.9896 | 1.0104 | 313 |
| TEST_TIME | 80 | 3596.82 | 0.9880 | 1.0089 | 433 |
| TEST_TIME | 81 | 3616.16 | 0.9911 | 1.0081 | 360 |
| TEST_TIME | 82 | 3639.61 | 0.9905 | 1.0090 | 340 |
| TEST_TIME | 83 | 3661.32 | 0.9922 | 1.0089 | 368 |
| TEST_TIME | 84 | 3684.96 | 0.9905 | 1.0093 | 384 |
| TEST_TIME | 85 | 3702.38 | 0.9929 | 1.0101 | 481 |
| TEST_TIME | 86 | 3733.12 | 0.9902 | 1.0079 | 454 |
| TEST_TIME | 87 | 3747.02 | 0.9928 | 1.0078 | 541 |
| TEST_TIME | 88 | 3773.51 | 0.9894 | 1.0083 | 474 |
| TEST_TIME | 89 | 3800.48 | 0.9900 | 1.0088 | 495 |
| TEST_TIME | 90 | 3810.82 | 0.9949 | 1.0066 | 586 |
| TEST_TIME | 91 | 3822.51 | 0.9925 | 1.0066 | 436 |
| TEST_TIME | 92 | 3828.77 | 0.9940 | 1.0058 | 452 |
| TEST_TIME | 93 | 3837.96 | 0.9926 | 1.0075 | 493 |
| TEST_TIME | 94 | 3846.25 | 0.9946 | 1.0051 | 513 |
| TEST_TIME | 95 | 3854.96 | 0.9923 | 1.0057 | 485 |
| TEST_TIME | 96 | 3859.95 | 0.9939 | 1.0059 | 489 |
| TEST_TIME | 97 | 3864.15 | 0.9945 | 1.0074 | 452 |
| TEST_TIME | 98 | 3866.84 | 0.9964 | 1.0050 | 559 |
| TEST_TIME | 99 | 3853.63 | 0.9982 | 1.0033 | 183 |
| TEST_TIME | 100 | 3853.52 | 0.9936 | 1.0055 | 631 |
| TEST_TIME | 101 | 3866.79 | 0.9921 | 1.0075 | 645 |
| TEST_TIME | 102 | 3878.45 | 0.9946 | 1.0057 | 648 |
| TEST_TIME | 103 | 3890.13 | 0.9929 | 1.0058 | 652 |
| TEST_TIME | 104 | 3888.91 | 0.9965 | 1.0036 | 352 |
| TEST_TIME | 105 | 3878.80 | 0.9971 | 1.0042 | 562 |
| TEST_TIME | 106 | 3882.01 | 0.9939 | 1.0037 | 556 |
| TEST_TIME | 107 | 3879.17 | 0.9950 | 1.0042 | 636 |
| TEST_TIME | 108 | 3876.04 | 0.9957 | 1.0038 | 546 |
| TEST_TIME | 109 | 3869.46 | 0.9962 | 1.0019 | 509 |
| TEST_TIME | 110 | 3854.69 | 0.9966 | 1.0023 | 239 |
| TEST_TIME | 111 | 3846.65 | 0.9953 | 1.0033 | 459 |
| TEST_TIME | 112 | 3846.55 | 0.9944 | 1.0046 | 596 |
| TEST_TIME | 113 | 3849.56 | 0.9950 | 1.0033 | 563 |
| TEST_TIME | 114 | 3841.94 | 0.9965 | 1.0036 | 582 |
| TEST_TIME | 115 | 3847.85 | 0.9933 | 1.0064 | 926 |
| TEST_TIME | 116 | 3857.18 | 0.9953 | 1.0051 | 609 |
| TEST_TIME | 117 | 3861.49 | 0.9954 | 1.0041 | 645 |
| TEST_TIME | 118 | 3861.45 | 0.9959 | 1.0049 | 426 |
| TEST_TIME | 119 | 3869.54 | 0.9948 | 1.0040 | 622 |
| TEST_TIME | 120 | 3868.51 | 0.9959 | 1.0049 | 659 |
| TEST_TIME | 121 | 3873.10 | 0.9954 | 1.0019 | 142 |
| TEST_TIME | 122 | 3869.96 | 0.9952 | 1.0029 | 417 |
| TEST_TIME | 123 | 3865.09 | 0.9961 | 1.0041 | 566 |
| TEST_TIME | 124 | 3858.46 | 0.9977 | 1.0035 | 551 |
| TEST_TIME | 125 | 3858.49 | 0.9954 | 1.0032 | 495 |
| TEST_TIME | 126 | 3859.26 | 0.9950 | 1.0034 | 503 |
| TEST_TIME | 127 | 3855.03 | 0.9966 | 1.0022 | 590 |
| TEST_TIME | 128 | 3846.32 | 0.9966 | 1.0028 | 475 |
| TEST_TIME | 129 | 3839.32 | 0.9968 | 1.0035 | 555 |
| TEST_TIME | 130 | 3843.94 | 0.9946 | 1.0047 | 805 |
| TEST_TIME | 131 | 3851.16 | 0.9951 | 1.0042 | 843 |
| TEST_TIME | 132 | 3852.94 | 0.9961 | 1.0038 | 767 |
| TEST_TIME | 133 | 3852.18 | 0.9966 | 1.0030 | 699 |
| TEST_TIME | 134 | 3847.46 | 0.9967 | 1.0029 | 693 |
| TEST_TIME | 135 | 3840.84 | 0.9971 | 1.0028 | 664 |
| TEST_TIME | 136 | 3834.09 | 0.9972 | 1.0027 | 717 |
| TEST_TIME | 137 | 3826.69 | 0.9973 | 1.0031 | 679 |
| TEST_TIME | 138 | 3820.32 | 0.9978 | 1.0037 | 640 |
| TEST_TIME | 139 | 3819.83 | 0.9966 | 1.0023 | 660 |
| TEST_TIME | 140 | 3812.56 | 0.9970 | 1.0038 | 761 |
| TEST_TIME | 141 | 3817.33 | 0.9955 | 1.0033 | 554 |
| TEST_TIME | 142 | 3818.11 | 0.9962 | 1.0033 | 520 |
| TEST_TIME | 143 | 3815.26 | 0.9970 | 1.0029 | 515 |
| TEST_TIME | 144 | 3811.19 | 0.9970 | 1.0031 | 565 |
| TEST_TIME | 145 | 3818.79 | 0.9942 | 1.0052 | 851 |
| TEST_TIME | 146 | 3828.15 | 0.9959 | 1.0044 | 642 |
| TEST_TIME | 147 | 3834.66 | 0.9959 | 1.0040 | 685 |
| TEST_TIME | 148 | 3837.05 | 0.9966 | 1.0036 | 659 |
| TEST_TIME | 149 | 3837.23 | 0.9968 | 1.0036 | 736 |
| TEST_TIME | 150 | 3837.01 | 0.9970 | 1.0026 | 745 |
| TEST_TIME | 151 | 3833.72 | 0.9968 | 1.0037 | 651 |
| TEST_TIME | 152 | 3833.79 | 0.9970 | 1.0044 | 543 |
| TEST_TIME | 153 | 3837.65 | 0.9969 | 1.0022 | 629 |
| TEST_TIME | 154 | 3830.89 | 0.9975 | 1.0033 | 595 |
| TEST_TIME | 155 | 3834.65 | 0.9959 | 1.0029 | 530 |
| TEST_TIME | 156 | 3835.11 | 0.9965 | 1.0026 | 620 |
| TEST_TIME | 157 | 3829.12 | 0.9978 | 1.0027 | 672 |
| TEST_TIME | 158 | 3827.74 | 0.9970 | 1.0024 | 549 |
| TEST_TIME | 159 | 3825.54 | 0.9967 | 1.0036 | 537 |
| TEST_TIME | 160 | 3836.48 | 0.9944 | 1.0043 | 776 |
| TEST_TIME | 161 | 3847.61 | 0.9952 | 1.0037 | 633 |
| TEST_TIME | 162 | 3855.16 | 0.9960 | 1.0045 | 638 |
| TEST_TIME | 163 | 3863.74 | 0.9961 | 1.0035 | 596 |
| TEST_TIME | 164 | 3867.65 | 0.9964 | 1.0028 | 573 |
| TEST_TIME | 165 | 3870.21 | 0.9963 | 1.0035 | 696 |
| TEST_TIME | 166 | 3874.25 | 0.9964 | 1.0029 | 558 |
| TEST_TIME | 167 | 3875.87 | 0.9965 | 1.0035 | 643 |
| TEST_TIME | 168 | 3881.45 | 0.9962 | 1.0023 | 554 |
| TEST_TIME | 169 | 3878.05 | 0.9973 | 1.0021 | 586 |
| TEST_TIME | 170 | 3874.86 | 0.9970 | 1.0029 | 540 |
| TEST_TIME | 171 | 3877.33 | 0.9964 | 1.0029 | 566 |
| TEST_TIME | 172 | 3877.16 | 0.9971 | 1.0020 | 643 |
| TEST_TIME | 173 | 3875.70 | 0.9966 | 1.0025 | 338 |
| TEST_TIME | 174 | 3874.84 | 0.9972 | 1.0032 | 366 |
| TEST_TIME | 175 | 3878.49 | 0.9965 | 1.0038 | 730 |
| TEST_TIME | 176 | 3892.67 | 0.9948 | 1.0044 | 749 |
| TEST_TIME | 177 | 3902.17 | 0.9963 | 1.0036 | 813 |
| TEST_TIME | 178 | 3909.64 | 0.9960 | 1.0042 | 601 |
| TEST_TIME | 179 | 3925.16 | 0.9951 | 1.0038 | 657 |
| TEST_TIME | 180 | 3929.12 | 0.9972 | 1.0035 | 684 |
| TEST_TIME | 181 | 3948.14 | 0.9932 | 1.0030 | 244 |
| TEST_TIME | 182 | 3953.21 | 0.9964 | 1.0048 | 481 |
| TEST_TIME | 183 | 3966.85 | 0.9959 | 1.0040 | 457 |
| TEST_TIME | 184 | 3978.38 | 0.9956 | 1.0030 | 582 |
| TEST_TIME | 185 | 3979.50 | 0.9973 | 1.0028 | 535 |
| TEST_TIME | 186 | 3977.42 | 0.9979 | 1.0045 | 414 |
| TEST_TIME | 187 | 3985.56 | 0.9971 | 1.0026 | 581 |
| TEST_TIME | 188 | 3988.55 | 0.9967 | 1.0034 | 472 |
| TEST_TIME | 189 | 3998.72 | 0.9955 | 1.0041 | 371 |
| TEST_TIME | 190 | 3999.08 | 0.9989 | 1.0007 | 134 |
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 | 801686 | 686918 | 114768 | 14.31 | 0 | 2016 | 5 | 114768 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| doc_list_biud | 801854 | 686918 | 114936 | 14.33 | 0 | 3556 | 3 | 114936 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_add_invoice_to_stock | 6859 | 4779 | 2080 | 30.32 | 27 | 95156 | 3831 | 2080 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_cancel_adding_invoice | 2090 | 1245 | 845 | 40.43 | 7 | 12298 | 626 | 845 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_cancel_client_order | 2468 | 2409 | 59 | 2.39 | 7 | 370 | 47 | 59 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_cancel_customer_reserve | 180408 | 70561 | 109847 | 60.88 | 1 | 3502 | 21 | 109847 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_cancel_pay_from_customer | 915 | 912 | 3 | 0.32 | 4 | 242 | 29 | 3 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_cancel_pay_to_supplier | 588 | 588 | 0 | 0.00 | 3 | 280 | 31 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_cancel_supplier_invoice | 3348 | 2387 | 961 | 28.70 | 2 | 703 | 93 | 961 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_cancel_supplier_order | 486 | 195 | 291 | 59.87 | 58 | 69139 | 8273 | 291 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_cancel_write_off | 8773 | 5284 | 3489 | 39.76 | 2 | 457 | 40 | 3489 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_client_order | 28638 | 28638 | 0 | 0.00 | 7 | 2203 | 66 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_customer_reserve | 581520 | 581520 | 0 | 0.00 | 0 | 3682 | 24 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_fill_shopping_cart | 43383 | 43383 | 0 | 0.00 | 1 | 2033 | 14 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_fill_shopping_cart_clo_res | 581520 | 581520 | 0 | 0.00 | 0 | 929 | 2 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_get_clo_for_invoice | 4779 | 4779 | 0 | 0.00 | 1 | 613 | 70 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_kill_cost_storno | 12150 | 8029 | 4121 | 33.91 | 0 | 273 | 5 | 4121 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_kill_qstorno_ret_qs2qd | 372926 | 148988 | 223938 | 60.04 | 0 | 3484 | 8 | 223938 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_kill_qty_storno | 215318 | 100395 | 114923 | 53.37 | 0 | 3554 | 19 | 114923 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_lock_selected_doc | 28318 | 25494 | 2824 | 9.97 | 0 | 250 | 1 | 2824 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_make_cost_storno | 35712 | 35712 | 0 | 0.00 | 0 | 560 | 39 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_multiply_rows_for_pdistr | 35712 | 35712 | 0 | 0.00 | 0 | 484 | 8 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_multiply_rows_for_qdistr | 28638 | 28638 | 0 | 0.00 | 0 | 979 | 20 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_pay_from_customer | 9545 | 9545 | 0 | 0.00 | 19 | 747 | 95 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_pay_to_supplier | 7853 | 7853 | 0 | 0.00 | 13 | 790 | 141 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_payment_common | 17398 | 17398 | 0 | 0.00 | 2 | 356 | 27 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_qd_handle_on_cancel_clo | 2468 | 2409 | 59 | 2.39 | 1 | 351 | 17 | 59 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_qd_handle_on_invoice_upd_sts | 6776 | 6024 | 752 | 11.09 | 1 | 3554 | 60 | 752 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_qd_handle_on_reserve_upd_sts | 13535 | 13535 | 0 | 0.00 | 0 | 388 | 12 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_reserve_write_off | 13638 | 13535 | 103 | 0.75 | 7 | 685 | 67 | 103 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_supplier_invoice | 7294 | 7294 | 0 | 0.00 | 10 | 2225 | 225 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| sp_supplier_order | 7451 | 7451 | 0 | 0.00 | 9 | 2982 | 182 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| srv_find_qd_qs_mism | 498963 | 384208 | 114755 | 22.99 | 0 | 2015 | 4 | 114755 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| srv_make_invnt_saldo | 2906 | 2906 | 0 | 0.00 | 2 | 1207 | 109 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| srv_make_money_saldo | 1837 | 1837 | 0 | 0.00 | 0 | 120 | 3 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 930 | 2427 | 1823 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_add_invoice_to_stock | 2080 | 2080 | 0 | 0.00 | 0 | 221 | 5 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_cancel_adding_invoice | 259 | 259 | 0 | 0.00 | 0 | 194 | 23 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_cancel_client_order | 59 | 59 | 0 | 0.00 | 1 | 100 | 9 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_cancel_customer_reserve | 5 | 5 | 0 | 0.00 | 0 | 71 | 32 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_cancel_pay_from_customer | 3 | 3 | 0 | 0.00 | 2 | 32 | 15 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_cancel_supplier_invoice | 168 | 168 | 0 | 0.00 | 1 | 42 | 4 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_cancel_supplier_order | 12882 | 12882 | 0 | 0.00 | 1 | 684 | 36 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_cancel_write_off | 6 | 6 | 0 | 0.00 | 1 | 49 | 13 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-abend:sp_reserve_write_off | 103 | 103 | 0 | 0.00 | 0 | 102 | 6 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_add_invoice_to_stock | 4783 | 4783 | 0 | 0.00 | 1 | 2487 | 209 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_cancel_adding_invoice | 472 | 472 | 0 | 0.00 | 2 | 962 | 126 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_cancel_client_order | 2409 | 2409 | 0 | 0.00 | 0 | 386 | 13 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_cancel_customer_reserve | 922 | 922 | 0 | 0.00 | 0 | 317 | 13 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_cancel_pay_from_customer | 912 | 912 | 0 | 0.00 | 0 | 154 | 8 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_cancel_pay_to_supplier | 588 | 588 | 0 | 0.00 | 0 | 170 | 8 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_cancel_supplier_invoice | 372 | 372 | 0 | 0.00 | 0 | 209 | 14 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_cancel_supplier_order | 195 | 195 | 0 | 0.00 | 3 | 3933 | 306 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_cancel_write_off | 1310 | 1310 | 0 | 0.00 | 0 | 299 | 10 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_client_order | 28638 | 28638 | 0 | 0.00 | 0 | 772 | 16 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_customer_reserve | 1379 | 1379 | 0 | 0.00 | 0 | 243 | 8 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_pay_from_customer | 9545 | 9545 | 0 | 0.00 | 0 | 801 | 10 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_pay_to_supplier | 7853 | 7853 | 0 | 0.00 | 0 | 380 | 8 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_reserve_write_off | 13535 | 13535 | 0 | 0.00 | 0 | 488 | 11 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_supplier_invoice | 7294 | 7294 | 0 | 0.00 | 1 | 795 | 15 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:sp_supplier_order | 7451 | 7451 | 0 | 0.00 | 1 | 412 | 15 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:srv_make_invnt_saldo | 2906 | 2906 | 0 | 0.00 | 0 | 190 | 9 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:srv_make_money_saldo | 1837 | 1837 | 0 | 0.00 | 0 | 181 | 4 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| t$perf-norm:srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 3 | 82 | 23 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_add_invoice_to_stock | 13718 | 9558 | 4160 | 30.32 | 0 | 321 | 2 | 4160 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_all_customers | 42768 | 42768 | 0 | 0.00 | 0 | 13 | 0 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_all_suppliers | 29490 | 29490 | 0 | 0.00 | 0 | 5 | 0 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_all_wares | 57276 | 57276 | 0 | 0.00 | 0 | 15 | 0 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_cancel_adding_invoice | 1162 | 944 | 218 | 18.76 | 0 | 143 | 13 | 218 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_cancel_client_order | 4936 | 4818 | 118 | 2.39 | 0 | 221 | 2 | 118 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_cancel_customer_prepayment | 1830 | 1824 | 6 | 0.32 | 0 | 94 | 1 | 6 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_cancel_customer_reserve | 1854 | 1844 | 10 | 0.53 | 0 | 228 | 2 | 10 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_cancel_payment_to_supplier | 1176 | 1176 | 0 | 0.00 | 0 | 248 | 2 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_cancel_supplier_invoice | 1080 | 744 | 336 | 31.11 | 0 | 336 | 3 | 336 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_cancel_supplier_order | 972 | 390 | 582 | 59.87 | 0 | 131 | 2 | 582 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_cancel_write_off | 2632 | 2620 | 12 | 0.45 | 0 | 399 | 9 | 12 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_max_id_clo_ord | 7451 | 7451 | 0 | 0.00 | 0 | 77 | 1 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_max_id_clo_res | 1379 | 1379 | 0 | 0.00 | 0 | 436 | 6 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_max_id_ord_sup | 7294 | 7294 | 0 | 0.00 | 0 | 1858 | 1 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_max_non_paid_invoice | 7853 | 7853 | 0 | 0.00 | 0 | 94 | 2 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_max_non_paid_realizn | 9545 | 9545 | 0 | 0.00 | 2 | 105 | 9 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_min_id_clo_ord | 7451 | 7451 | 0 | 0.00 | 0 | 148 | 2 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_min_id_clo_res | 1379 | 1379 | 0 | 0.00 | 0 | 85 | 2 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_min_id_ord_sup | 7294 | 7294 | 0 | 0.00 | 0 | 855 | 2 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_min_non_paid_invoice | 7853 | 7853 | 0 | 0.00 | 1 | 313 | 13 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_min_non_paid_realizn | 9545 | 9545 | 0 | 0.00 | 3 | 241 | 12 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_our_firm | 14508 | 14508 | 0 | 0.00 | 0 | 11 | 0 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| v_reserve_write_off | 27276 | 27070 | 206 | 0.75 | 0 | 503 | 2 | 206 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| x_lock_depdocs_on_canc_invoice | 6850 | 3260 | 3590 | 52.40 | 0 | 279 | 6 | 3590 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| x_lock_depdocs_on_canc_sup_ord | 484 | 195 | 289 | 59.71 | 0 | 71 | 6 | 289 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| x_make_qstorno_1000_1200 | 7451 | 7451 | 0 | 0.00 | 5 | 2968 | 137 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| x_make_qstorno_1200_2000 | 7294 | 7294 | 0 | 0.00 | 5 | 1742 | 183 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| x_make_qstorno_2100_3300 | 581520 | 581520 | 0 | 0.00 | 0 | 3681 | 19 | 0 | 2015-12-19 00:56 | 2015-12-19 03:56 |
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 | 17 | sp_kill_cost_storno | 335544336 | 2015-12-19 00:58 | 2015-12-19 03:37 |
| deadlock | 197 | sp_lock_selected_doc | 335544336 | 2015-12-19 00:59 | 2015-12-19 03:54 |
| deadlock | 78 | sp_qd_handle_on_invoice_upd_sts | 335544336 | 2015-12-19 01:02 | 2015-12-19 03:54 |
| deadlock | 3 | x_lock_depdocs_on_canc_invoice | 335544336 | 2015-12-19 01:02 | 2015-12-19 03:20 |
| deadlock | 1 | x_lock_depdocs_on_canc_sup_ord | 335544336 | 2015-12-19 01:07 | 2015-12-19 01:07 |
| lock_conflict | 3 | sp_kill_cost_storno | 335544345 | 2015-12-19 00:59 | 2015-12-19 02:02 |
| lock_conflict | 2169 | sp_lock_selected_doc | 335544345 | 2015-12-19 00:56 | 2015-12-19 03:56 |
| lock_conflict | 59 | sp_qd_handle_on_cancel_clo | 335544345 | 2015-12-19 00:56 | 2015-12-19 03:50 |
| lock_conflict | 34 | sp_qd_handle_on_invoice_upd_sts | 335544345 | 2015-12-19 00:57 | 2015-12-19 03:56 |
| lock_conflict | 215 | x_lock_depdocs_on_canc_invoice | 335544345 | 2015-12-19 00:58 | 2015-12-19 03:54 |
| lock_conflict | 47 | x_lock_depdocs_on_canc_sup_ord | 335544345 | 2015-12-19 01:18 | 2015-12-19 03:46 |
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 182071
MON$OLDEST_ACTIVE 182072
MON$OLDEST_SNAPSHOT 182072
MON$NEXT_TRANSACTION 182072
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 478649
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26958 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26958 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26958 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26958 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 186625
Page size 8192
ODS version 11.2
Oldest transaction 182073
Oldest active 182074
Oldest snapshot 182074
Next transaction 182075
Bumped transaction 1
Sequence number 0
Next attachment ID 4541
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: 36.98, total records: 1225632
Average version length: 46.46, total versions: 252317, max versions: 1
Data pages: 12995, data page slots: 12995, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 9721
80 - 99% = 3273
Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 4394, nodes: 1225632
Average data length: 13.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 527
20 - 39% = 1
40 - 59% = 1838
60 - 79% = 1
80 - 99% = 2027
Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 3521, nodes: 1225632
Average data length: 5.71, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3521
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 1356, nodes: 1225632
Average data length: 1.63, total dup: 895821, max dup: 49
Fill distribution:
0 - 19% = 100
20 - 39% = 1
40 - 59% = 432
60 - 79% = 0
80 - 99% = 823
DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 60.46, total records: 285386
Average version length: 37.76, total versions: 8799, max versions: 3
Data pages: 3558, data page slots: 3558, average fill: 78%
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3292
80 - 99% = 264
Index DOC_LIST_ID_DESC (1)
Depth: 3, leaf buckets: 983, nodes: 285386
Average data length: 6.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 330
40 - 59% = 643
60 - 79% = 10
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 306, nodes: 285386
Average data length: 0.01, total dup: 285336, max dup: 32804
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 254
60 - 79% = 38
80 - 99% = 14
Index PK_DOC_LIST (0)
Depth: 3, leaf buckets: 572, nodes: 285386
Average data length: 6.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 41
20 - 39% = 19
40 - 59% = 72
60 - 79% = 150
80 - 99% = 290
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: 63.93, total records: 400
Average version length: 14.73, total versions: 962, max versions: 11
Data pages: 14, data page slots: 14, average fill: 65%
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 8
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: 24.16, total records: 1915
Average version length: 70.19, total versions: 1256, max versions: 1
Data pages: 36, data page slots: 136, average fill: 65%
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 6
60 - 79% = 15
80 - 99% = 10
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 9, nodes: 1915
Average data length: 11.87, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 5
60 - 79% = 1
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 15.96, total records: 49
Average version length: 9.00, total versions: 64, max versions: 5
Data pages: 1, data page slots: 1, average fill: 42%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
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: 30.39, total records: 82
Average version length: 46.04, total versions: 28, max versions: 1
Data pages: 1, data page slots: 1, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 1, leaf buckets: 1, nodes: 82
Average data length: 5.04, total dup: 53, max dup: 17
Fill distribution:
0 - 19% = 1
20 - 39% = 0
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: 43.33, total records: 114719
Average version length: 37.43, total versions: 2327, max versions: 4
Data pages: 1232, data page slots: 1232, average fill: 71%
Fill distribution:
0 - 19% = 8
20 - 39% = 11
40 - 59% = 30
60 - 79% = 1183
80 - 99% = 0
Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 95, nodes: 114719
Average data length: 0.01, total dup: 114670, max dup: 5148
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 56
60 - 79% = 19
80 - 99% = 15
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 119, nodes: 114719
Average data length: 0.87, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 2
20 - 39% = 15
40 - 59% = 44
60 - 79% = 36
80 - 99% = 22
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 117, nodes: 114719
Average data length: 0.87, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 49
60 - 79% = 36
80 - 99% = 20
Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 126, nodes: 114719
Average data length: 0.66, total dup: 103575, max dup: 46
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 40
60 - 79% = 44
80 - 99% = 8
PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.95, total records: 98839
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 845, data page slots: 845, average fill: 64%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 844
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 75, nodes: 98839
Average data length: 0.00, total dup: 98648, max dup: 925
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 26
60 - 79% = 38
80 - 99% = 11
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: 149.51, total records: 6146181
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 144221, data page slots: 144221, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 144220
Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 7307, nodes: 6146181
Average data length: 0.68, total dup: 2441041, max dup: 12
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 4698
60 - 79% = 1662
80 - 99% = 943
Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 5863, nodes: 6146181
Average data length: 0.00, total dup: 6146176, max dup: 5319633
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 5395
60 - 79% = 0
80 - 99% = 468
Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 7140, nodes: 6146181
Average data length: 0.16, total dup: 5996181, max dup: 29309
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 5794
60 - 79% = 738
80 - 99% = 604
Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 7112, nodes: 6146181
Average data length: 0.08, total dup: 6123394, max dup: 494926
Fill distribution:
0 - 19% = 8
20 - 39% = 1
40 - 59% = 6138
60 - 79% = 423
80 - 99% = 542
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: 46.27, total records: 186205
Average version length: 55.86, total versions: 33077, max versions: 1
Data pages: 2204, data page slots: 2204, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1592
80 - 99% = 611
Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 225, nodes: 186205
Average data length: 1.15, total dup: 153464, max dup: 375
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 139
60 - 79% = 76
80 - 99% = 9
Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 184, nodes: 186205
Average data length: 0.64, total dup: 168705, max dup: 121
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 85
60 - 79% = 64
80 - 99% = 34
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: 17, max versions: 15
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 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
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: 8.22, total records: 1935
Average version length: 71.19, total versions: 1712, max versions: 1
Data pages: 27, data page slots: 101, average fill: 91%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 26
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 3, nodes: 1935
Average data length: 3.43, total dup: 1688, max dup: 14
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2
80 - 99% = 0
XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 65.39, total records: 62723
Average version length: 71.07, total versions: 5074, max versions: 1
Data pages: 1162, data page slots: 1217, average fill: 60%
Fill distribution:
0 - 19% = 114
20 - 39% = 145
40 - 59% = 198
60 - 79% = 486
80 - 99% = 219
Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 70, nodes: 62723
Average data length: 0.42, total dup: 58652, max dup: 101
Fill distribution:
0 - 19% = 0
20 - 39% = 26
40 - 59% = 24
60 - 79% = 13
80 - 99% = 7
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 96, nodes: 62723
Average data length: 1.49, total dup: 53801, max dup: 14
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 54
60 - 79% = 11
80 - 99% = 1
XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 29.54, total records: 7786
Average version length: 71.18, total versions: 4556, max versions: 1
Data pages: 150, data page slots: 429, average fill: 64%
Fill distribution:
0 - 19% = 11
20 - 39% = 24
40 - 59% = 31
60 - 79% = 14
80 - 99% = 70
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 14, nodes: 7786
Average data length: 2.29, total dup: 6724, max dup: 41
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 7
60 - 79% = 2
80 - 99% = 0
XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 11.03, total records: 2660595
Average version length: 69.61, total versions: 2248350, max versions: 1
Data pages: 36083, data page slots: 36083, average fill: 91%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5040
80 - 99% = 31042
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 3709, nodes: 2660595
Average data length: 0.92, total dup: 2408577, max dup: 99
Fill distribution:
0 - 19% = 3
20 - 39% = 70
40 - 59% = 3334
60 - 79% = 139
80 - 99% = 163
XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 18.27, total records: 3075
Average version length: 70.99, total versions: 2286, max versions: 1
Data pages: 86, data page slots: 594, average fill: 46%
Fill distribution:
0 - 19% = 12
20 - 39% = 25
40 - 59% = 23
60 - 79% = 20
80 - 99% = 6
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 8, nodes: 3075
Average data length: 2.84, total dup: 2636, max dup: 47
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 34.31, total records: 2754981
Average version length: 69.41, total versions: 1412540, max versions: 1
Data pages: 37350, data page slots: 37350, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 7381
80 - 99% = 29966
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 4114, nodes: 2754981
Average data length: 1.51, total dup: 2301991, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 3815
60 - 79% = 149
80 - 99% = 149
XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 76.39, total records: 2024595
Average version length: 81.89, total versions: 139409, max versions: 1
Data pages: 30565, data page slots: 30565, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 6172
80 - 99% = 24392
Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 2240, nodes: 2024595
Average data length: 0.15, total dup: 1979164, max dup: 199
Fill distribution:
0 - 19% = 11
20 - 39% = 2
40 - 59% = 1587
60 - 79% = 550
80 - 99% = 90
Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 1495, nodes: 2024595
Average data length: 0.70, total dup: 1774410, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 55
60 - 79% = 3
80 - 99% = 1435
Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 2532, nodes: 2024595
Average data length: 0.71, total dup: 1775379, max dup: 41
Fill distribution:
0 - 19% = 23
20 - 39% = 0
40 - 59% = 1761
60 - 79% = 651
80 - 99% = 97
XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 47.23, total records: 2369195
Average version length: 81.46, total versions: 1010592, max versions: 1
Data pages: 35697, data page slots: 35697, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1
60 - 79% = 1561
80 - 99% = 34134
Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2209, nodes: 2369195
Average data length: 0.10, total dup: 2335838, max dup: 816
Fill distribution:
0 - 19% = 3
20 - 39% = 4
40 - 59% = 801
60 - 79% = 934
80 - 99% = 467
Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2259, nodes: 2369195
Average data length: 1.00, total dup: 1974660, max dup: 14
Fill distribution:
0 - 19% = 66
20 - 39% = 1
40 - 59% = 669
60 - 79% = 2
80 - 99% = 1521
Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 2431, nodes: 2369195
Average data length: 0.44, total dup: 2191012, max dup: 134
Fill distribution:
0 - 19% = 36
20 - 39% = 7
40 - 59% = 920
60 - 79% = 959
80 - 99% = 509
XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 58.54, total records: 2794040
Average version length: 82.17, total versions: 802882, max versions: 1
Data pages: 42154, data page slots: 42154, average fill: 84%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7599
80 - 99% = 34554
Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 2688, nodes: 2794040
Average data length: 0.04, total dup: 2781878, max dup: 1536
Fill distribution:
0 - 19% = 5
20 - 39% = 15
40 - 59% = 1261
60 - 79% = 950
80 - 99% = 457
Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 2042, nodes: 2794040
Average data length: 0.53, total dup: 2531367, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 109
60 - 79% = 19
80 - 99% = 1913
Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 2972, nodes: 2794040
Average data length: 0.51, total dup: 2543762, max dup: 273
Fill distribution:
0 - 19% = 10
20 - 39% = 15
40 - 59% = 1335
60 - 79% = 1091
80 - 99% = 521
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: 49.84, total records: 2605096
Average version length: 81.34, total versions: 1026972, max versions: 1
Data pages: 39173, data page slots: 39173, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1596
80 - 99% = 37576
Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2476, nodes: 2605096
Average data length: 0.03, total dup: 2596580, max dup: 1599
Fill distribution:
0 - 19% = 4
20 - 39% = 32
40 - 59% = 1071
60 - 79% = 922
80 - 99% = 447
Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2664, nodes: 2605096
Average data length: 1.01, total dup: 2167810, max dup: 14
Fill distribution:
0 - 19% = 69
20 - 39% = 34
40 - 59% = 884
60 - 79% = 82
80 - 99% = 1595
Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 2702, nodes: 2605096
Average data length: 0.41, total dup: 2423929, max dup: 144
Fill distribution:
0 - 19% = 4
20 - 39% = 23
40 - 59% = 1141
60 - 79% = 1070
80 - 99% = 464
XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 38.13, total records: 425620
Average version length: 68.53, total versions: 189937, max versions: 1
Data pages: 5737, data page slots: 5737, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1701
80 - 99% = 4035
Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 404, nodes: 425620
Average data length: 0.33, total dup: 404790, max dup: 127
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 164
60 - 79% = 144
80 - 99% = 96
Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 464, nodes: 425620
Average data length: 0.88, total dup: 365899, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 191
60 - 79% = 183
80 - 99% = 90
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 13930 ms, from 4:01:13.04 to 4:01:26.97.
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 | 1225632 | 252317 | 20.5866 |
| DOC_LIST | 285386 | 8799 | 3.0831 |
| DOC_STATES | 4 | 0 | 0.0000 |
| FB_ERRORS | 758 | 0 | 0.0000 |
| INVNT_SALDO | 400 | 962 | 240.5000 |
| INVNT_TURNOVER_LOG | 1915 | 1256 | 65.5874 |
| MONEY_SALDO | 49 | 64 | 130.6122 |
| MONEY_TURNOVER_LOG | 82 | 28 | 34.1463 |
| OPTYPES | 9 | 0 | 0.0000 |
| PDISTR | 114719 | 2327 | 2.0284 |
| PERF_ESTIMATED | 98839 | 2 | 0.0020 |
| PERF_LOG | 6146181 | 1 | 0.0000 |
| PSTORNED | 186205 | 33077 | 17.7637 |
| RULES_FOR_PDISTR | 4 | 0 | 0.0000 |
| RULES_FOR_QDISTR | 7 | 0 | 0.0000 |
| SEMAPHORES | 4 | 17 | 425.0000 |
| SETTINGS | 114 | 0 | 0.0000 |
| WARES | 400 | 0 | 0.0000 |
| WARE_GROUPS | 8 | 0 | 0.0000 |
| XQD_1000_1200 | 1935 | 1712 | 88.4754 |
| XQD_1000_3300 | 62723 | 5074 | 8.0895 |
| XQD_1200_2000 | 7786 | 4556 | 58.5152 |
| XQD_2000_3300 | 2660595 | 2248350 | 84.5055 |
| XQD_2100_3300 | 3075 | 2286 | 74.3414 |
| XQD_3300_3400 | 2754981 | 1412540 | 51.2722 |
| XQS_1000_1200 | 2024595 | 139409 | 6.8857 |
| XQS_1000_3300 | 2369195 | 1010592 | 42.6555 |
| XQS_1200_2000 | 2794040 | 802882 | 28.7355 |
| XQS_2100_3300 | 2605096 | 1026972 | 39.4216 |
| XQS_3300_3400 | 425620 | 189937 | 44.6259 |
| Z_USED_VIEWS | 32 | 0 | 0.0000 |
Database validation
04:01:38.00 Validation started
04:01:38.00 Relation 140 (DOC_LIST)
04:01:38.00 process pointer page 0 of 2
04:01:38.03 process pointer page 1 of 2
04:01:38.06 Index 1 (PK_DOC_LIST)
04:01:38.09 Index 2 (DOC_LIST_ID_DESC)
04:01:38.12 Index 3 (FK_DOC_LIST_AGENTS)
04:01:38.15 Relation 140 (DOC_LIST) is ok
04:01:38.15 Relation 141 (DOC_DATA)
04:01:38.15 process pointer page 0 of 7
04:01:38.18 process pointer page 1 of 7
04:01:38.21 process pointer page 2 of 7
04:01:38.25 process pointer page 3 of 7
04:01:38.28 process pointer page 4 of 7
04:01:38.32 process pointer page 5 of 7
04:01:38.35 process pointer page 6 of 7
04:01:38.37 Index 2 (DOC_DATA_DOC_WARE_UNQ)
04:01:38.51 Index 3 (DOC_DATA_ID_DESC)
04:01:38.63 Index 4 (FK_DOC_DATA_DOC_LIST)
04:01:38.71 Relation 141 (DOC_DATA) is ok
04:01:38.71 Relation 147 (INVNT_SALDO)
04:01:38.71 process pointer page 0 of 1
04:01:38.71 Index 1 (PK_INVNT_SALDO)
04:01:38.71 Relation 147 (INVNT_SALDO) is ok
04:01:38.71 Relation 150 (PDISTR)
04:01:38.71 process pointer page 0 of 1
04:01:38.73 Index 2 (PDISTR_SND_ID)
04:01:38.74 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
04:01:38.75 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
04:01:38.76 Index 5 (PDISTR_AGENT_ID)
04:01:38.77 Relation 150 (PDISTR) is ok
04:01:38.77 Relation 151 (PSTORNED)
04:01:38.77 process pointer page 0 of 2
04:01:38.80 process pointer page 1 of 2
04:01:38.80 Index 2 (PSTORNED_SND_ID)
04:01:38.82 Index 3 (PSTORNED_RCV_ID)
04:01:38.83 Relation 151 (PSTORNED) is ok
04:01:38.83 Relation 156 (SEMAPHORES)
04:01:38.83 process pointer page 0 of 1
04:01:38.83 Index 1 (PK_SEMAPHORES)
04:01:38.83 Index 2 (SEMAPHORES_TASK_UNQ)
04:01:38.83 Relation 156 (SEMAPHORES) is ok
04:01:38.83 Relation 157 (INVNT_TURNOVER_LOG)
04:01:38.83 process pointer page 0 of 1
04:01:38.83 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
04:01:38.83 Relation 157 (INVNT_TURNOVER_LOG) is ok
04:01:38.83 Relation 160 (PERF_ESTIMATED)
04:01:38.83 process pointer page 0 of 1
04:01:38.84 Index 1 (PERF_EST_MINUTE_SINCE_START)
04:01:38.84 Relation 160 (PERF_ESTIMATED) is ok
04:01:38.84 Relation 161 (PERF_ISQL_STAT)
04:01:38.84 process pointer page 0 of 1
04:01:38.84 Index 1 (PERF_ISQL_STAT_TRN)
04:01:38.84 Relation 161 (PERF_ISQL_STAT) is ok
04:01:38.84 Relation 162 (PERF_LOG)
04:01:38.84 process pointer page 0 of 76
04:01:38.86 process pointer page 1 of 76
04:01:38.89 process pointer page 2 of 76
04:01:38.91 process pointer page 3 of 76
04:01:38.93 process pointer page 4 of 76
04:01:38.95 process pointer page 5 of 76
04:01:38.97 process pointer page 6 of 76
04:01:38.99 process pointer page 7 of 76
04:01:39.02 process pointer page 8 of 76
04:01:39.04 process pointer page 9 of 76
04:01:39.07 process pointer page 10 of 76
04:01:39.10 process pointer page 11 of 76
04:01:39.12 process pointer page 12 of 76
04:01:39.14 process pointer page 13 of 76
04:01:39.18 process pointer page 14 of 76
04:01:39.25 process pointer page 15 of 76
04:01:39.28 process pointer page 16 of 76
04:01:39.31 process pointer page 17 of 76
04:01:39.33 process pointer page 18 of 76
04:01:39.39 process pointer page 19 of 76
04:01:39.46 process pointer page 20 of 76
04:01:39.53 process pointer page 21 of 76
04:01:39.60 process pointer page 22 of 76
04:01:39.67 process pointer page 23 of 76
04:01:39.74 process pointer page 24 of 76
04:01:39.82 process pointer page 25 of 76
04:01:39.89 process pointer page 26 of 76
04:01:39.96 process pointer page 27 of 76
04:01:40.03 process pointer page 28 of 76
04:01:40.11 process pointer page 29 of 76
04:01:40.18 process pointer page 30 of 76
04:01:40.25 process pointer page 31 of 76
04:01:40.28 process pointer page 32 of 76
04:01:40.30 process pointer page 33 of 76
04:01:40.33 process pointer page 34 of 76
04:01:40.36 process pointer page 35 of 76
04:01:40.39 process pointer page 36 of 76
04:01:40.41 process pointer page 37 of 76
04:01:40.44 process pointer page 38 of 76
04:01:40.46 process pointer page 39 of 76
04:01:40.48 process pointer page 40 of 76
04:01:40.51 process pointer page 41 of 76
04:01:40.53 process pointer page 42 of 76
04:01:40.56 process pointer page 43 of 76
04:01:40.58 process pointer page 44 of 76
04:01:40.60 process pointer page 45 of 76
04:01:40.62 process pointer page 46 of 76
04:01:40.64 process pointer page 47 of 76
04:01:40.66 process pointer page 48 of 76
04:01:40.68 process pointer page 49 of 76
04:01:40.70 process pointer page 50 of 76
04:01:40.72 process pointer page 51 of 76
04:01:40.74 process pointer page 52 of 76
04:01:40.76 process pointer page 53 of 76
04:01:40.78 process pointer page 54 of 76
04:01:40.80 process pointer page 55 of 76
04:01:40.82 process pointer page 56 of 76
04:01:40.84 process pointer page 57 of 76
04:01:40.86 process pointer page 58 of 76
04:01:40.88 process pointer page 59 of 76
04:01:40.90 process pointer page 60 of 76
04:01:40.92 process pointer page 61 of 76
04:01:40.94 process pointer page 62 of 76
04:01:40.96 process pointer page 63 of 76
04:01:40.98 process pointer page 64 of 76
04:01:41.00 process pointer page 65 of 76
04:01:41.02 process pointer page 66 of 76
04:01:41.04 process pointer page 67 of 76
04:01:41.06 process pointer page 68 of 76
04:01:41.09 process pointer page 69 of 76
04:01:41.14 process pointer page 70 of 76
04:01:41.21 process pointer page 71 of 76
04:01:41.29 process pointer page 72 of 76
04:01:41.35 process pointer page 73 of 76
04:01:41.38 process pointer page 74 of 76
04:01:41.41 process pointer page 75 of 76
04:01:41.41 Index 1 (PERF_LOG_DTS_BEG_DESC)
04:01:42.23 Index 2 (PERF_LOG_UNIT)
04:01:43.95 Index 3 (PERF_LOG_TRN_DESC)
04:01:44.39 Index 4 (PERF_LOG_GDSCODE)
04:01:45.17 Relation 162 (PERF_LOG) is ok
04:01:45.17 Relation 166 (V_STOPTEST)
04:01:45.17 Relation 166 (V_STOPTEST) is ok
04:01:45.17 Relation 183 (V_QDISTR_SOURCE)
04:01:45.17 Relation 183 (V_QDISTR_SOURCE) is ok
04:01:45.17 Relation 184 (V_QSTORNED_SOURCE)
04:01:45.17 Relation 184 (V_QSTORNED_SOURCE) is ok
04:01:45.17 Relation 258 (XQD_1000_1200)
04:01:45.17 process pointer page 0 of 1
04:01:45.17 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
04:01:45.17 Relation 258 (XQD_1000_1200) is ok
04:01:45.17 Relation 259 (XQD_1200_2000)
04:01:45.17 process pointer page 0 of 1
04:01:45.18 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
04:01:45.18 Relation 259 (XQD_1200_2000) is ok
04:01:45.18 Relation 260 (XQD_1000_3300)
04:01:45.18 process pointer page 0 of 1
04:01:45.19 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
04:01:45.20 Index 2 (XQD_1000_3300_DOC)
04:01:45.21 Relation 260 (XQD_1000_3300) is ok
04:01:45.21 Relation 261 (XQD_2000_3300)
04:01:45.21 process pointer page 0 of 19
04:01:45.26 process pointer page 1 of 19
04:01:45.30 process pointer page 2 of 19
04:01:45.35 process pointer page 3 of 19
04:01:45.40 process pointer page 4 of 19
04:01:45.57 process pointer page 5 of 19
04:01:45.74 process pointer page 6 of 19
04:01:45.88 process pointer page 7 of 19
04:01:45.97 process pointer page 8 of 19
04:01:46.09 process pointer page 9 of 19
04:01:46.19 process pointer page 10 of 19
04:01:46.25 process pointer page 11 of 19
04:01:46.31 process pointer page 12 of 19
04:01:46.36 process pointer page 13 of 19
04:01:46.41 process pointer page 14 of 19
04:01:46.47 process pointer page 15 of 19
04:01:46.56 process pointer page 16 of 19
04:01:46.66 process pointer page 17 of 19
04:01:46.70 process pointer page 18 of 19
04:01:46.74 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
04:01:47.01 Relation 261 (XQD_2000_3300) is ok
04:01:47.01 Relation 262 (XQD_2100_3300)
04:01:47.01 process pointer page 0 of 2
04:01:47.01 process pointer page 1 of 2
04:01:47.01 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
04:01:47.02 Relation 262 (XQD_2100_3300) is ok
04:01:47.02 Relation 263 (XQD_3300_3400)
04:01:47.02 process pointer page 0 of 20
04:01:47.06 process pointer page 1 of 20
04:01:47.10 process pointer page 2 of 20
04:01:47.14 process pointer page 3 of 20
04:01:47.19 process pointer page 4 of 20
04:01:47.25 process pointer page 5 of 20
04:01:47.37 process pointer page 6 of 20
04:01:47.42 process pointer page 7 of 20
04:01:47.47 process pointer page 8 of 20
04:01:47.53 process pointer page 9 of 20
04:01:47.61 process pointer page 10 of 20
04:01:47.68 process pointer page 11 of 20
04:01:47.77 process pointer page 12 of 20
04:01:47.81 process pointer page 13 of 20
04:01:47.86 process pointer page 14 of 20
04:01:47.91 process pointer page 15 of 20
04:01:48.01 process pointer page 16 of 20
04:01:48.07 process pointer page 17 of 20
04:01:48.18 process pointer page 18 of 20
04:01:48.29 process pointer page 19 of 20
04:01:48.33 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
04:01:48.86 Relation 263 (XQD_3300_3400) is ok
04:01:48.86 Relation 264 (XQS_1000_1200)
04:01:48.86 process pointer page 0 of 16
04:01:48.89 process pointer page 1 of 16
04:01:48.98 process pointer page 2 of 16
04:01:49.03 process pointer page 3 of 16
04:01:49.06 process pointer page 4 of 16
04:01:49.10 process pointer page 5 of 16
04:01:49.13 process pointer page 6 of 16
04:01:49.17 process pointer page 7 of 16
04:01:49.20 process pointer page 8 of 16
04:01:49.23 process pointer page 9 of 16
04:01:49.27 process pointer page 10 of 16
04:01:49.30 process pointer page 11 of 16
04:01:49.32 process pointer page 12 of 16
04:01:49.35 process pointer page 13 of 16
04:01:49.37 process pointer page 14 of 16
04:01:49.40 process pointer page 15 of 16
04:01:49.43 Index 1 (XQS_1000_1200_DOC_ID)
04:01:49.71 Index 2 (XQS_1000_1200_SND_ID)
04:01:49.89 Index 3 (XQS_1000_1200_RCV_ID)
04:01:50.03 Relation 264 (XQS_1000_1200) is ok
04:01:50.03 Relation 265 (XQS_1200_2000)
04:01:50.03 process pointer page 0 of 22
04:01:50.06 process pointer page 1 of 22
04:01:50.10 process pointer page 2 of 22
04:01:50.13 process pointer page 3 of 22
04:01:50.16 process pointer page 4 of 22
04:01:50.19 process pointer page 5 of 22
04:01:50.23 process pointer page 6 of 22
04:01:50.26 process pointer page 7 of 22
04:01:50.29 process pointer page 8 of 22
04:01:50.33 process pointer page 9 of 22
04:01:50.36 process pointer page 10 of 22
04:01:50.40 process pointer page 11 of 22
04:01:50.43 process pointer page 12 of 22
04:01:50.46 process pointer page 13 of 22
04:01:50.50 process pointer page 14 of 22
04:01:50.61 process pointer page 15 of 22
04:01:50.71 process pointer page 16 of 22
04:01:50.75 process pointer page 17 of 22
04:01:50.79 process pointer page 18 of 22
04:01:50.83 process pointer page 19 of 22
04:01:50.86 process pointer page 20 of 22
04:01:50.89 process pointer page 21 of 22
04:01:50.92 Index 1 (XQS_1200_2000_DOC_ID)
04:01:51.14 Index 2 (XQS_1200_2000_SND_ID)
04:01:51.54 Index 3 (XQS_1200_2000_RCV_ID)
04:01:51.76 Relation 265 (XQS_1200_2000) is ok
04:01:51.76 Relation 266 (XQS_1000_3300)
04:01:51.76 process pointer page 0 of 19
04:01:51.79 process pointer page 1 of 19
04:01:51.83 process pointer page 2 of 19
04:01:51.87 process pointer page 3 of 19
04:01:51.90 process pointer page 4 of 19
04:01:51.94 process pointer page 5 of 19
04:01:51.98 process pointer page 6 of 19
04:01:52.07 process pointer page 7 of 19
04:01:52.17 process pointer page 8 of 19
04:01:52.22 process pointer page 9 of 19
04:01:52.26 process pointer page 10 of 19
04:01:52.31 process pointer page 11 of 19
04:01:52.34 process pointer page 12 of 19
04:01:52.38 process pointer page 13 of 19
04:01:52.41 process pointer page 14 of 19
04:01:52.45 process pointer page 15 of 19
04:01:52.48 process pointer page 16 of 19
04:01:52.51 process pointer page 17 of 19
04:01:52.54 process pointer page 18 of 19
04:01:52.55 Index 1 (XQS_1000_3300_DOC_ID)
04:01:52.73 Index 2 (XQS_1000_3300_SND_ID)
04:01:52.93 Index 3 (XQS_1000_3300_RCV_ID)
04:01:53.10 Relation 266 (XQS_1000_3300) is ok
04:01:53.10 Relation 267 (XQS_2000_3300)
04:01:53.10 process pointer page 0 of 1
04:01:53.10 Index 1 (XQS_2000_3300_DOC_ID)
04:01:53.10 Index 2 (XQS_2000_3300_SND_ID)
04:01:53.10 Index 3 (XQS_2000_3300_RCV_ID)
04:01:53.10 Relation 267 (XQS_2000_3300) is ok
04:01:53.10 Relation 268 (XQS_2100_3300)
04:01:53.10 process pointer page 0 of 21
04:01:53.13 process pointer page 1 of 21
04:01:53.20 process pointer page 2 of 21
04:01:53.33 process pointer page 3 of 21
04:01:53.39 process pointer page 4 of 21
04:01:53.45 process pointer page 5 of 21
04:01:53.50 process pointer page 6 of 21
04:01:53.54 process pointer page 7 of 21
04:01:53.58 process pointer page 8 of 21
04:01:53.62 process pointer page 9 of 21
04:01:53.66 process pointer page 10 of 21
04:01:53.69 process pointer page 11 of 21
04:01:53.72 process pointer page 12 of 21
04:01:53.75 process pointer page 13 of 21
04:01:53.78 process pointer page 14 of 21
04:01:53.81 process pointer page 15 of 21
04:01:53.83 process pointer page 16 of 21
04:01:53.86 process pointer page 17 of 21
04:01:53.89 process pointer page 18 of 21
04:01:53.92 process pointer page 19 of 21
04:01:53.95 process pointer page 20 of 21
04:01:53.96 Index 1 (XQS_2100_3300_DOC_ID)
04:01:54.19 Index 2 (XQS_2100_3300_SND_ID)
04:01:54.43 Index 3 (XQS_2100_3300_RCV_ID)
04:01:54.61 Relation 268 (XQS_2100_3300) is ok
04:01:54.61 Relation 269 (XQS_3300_3400)
04:01:54.61 process pointer page 0 of 3
04:01:54.65 process pointer page 1 of 3
04:01:54.69 process pointer page 2 of 3
04:01:54.72 Index 1 (XQS_3300_3400_DOC_ID)
04:01:54.75 Index 2 (XQS_3300_3400_SND_ID)
04:01:54.78 Relation 269 (XQS_3300_3400) is ok
04:01:54.78 Validation finished
Done for 16840 ms, from 4:01:37.94 to 4:01:54.78.
04:01:38.00 Relation 140 (DOC_LIST)
04:01:38.00 process pointer page 0 of 2
04:01:38.03 process pointer page 1 of 2
04:01:38.06 Index 1 (PK_DOC_LIST)
04:01:38.09 Index 2 (DOC_LIST_ID_DESC)
04:01:38.12 Index 3 (FK_DOC_LIST_AGENTS)
04:01:38.15 Relation 140 (DOC_LIST) is ok
04:01:38.15 Relation 141 (DOC_DATA)
04:01:38.15 process pointer page 0 of 7
04:01:38.18 process pointer page 1 of 7
04:01:38.21 process pointer page 2 of 7
04:01:38.25 process pointer page 3 of 7
04:01:38.28 process pointer page 4 of 7
04:01:38.32 process pointer page 5 of 7
04:01:38.35 process pointer page 6 of 7
04:01:38.37 Index 2 (DOC_DATA_DOC_WARE_UNQ)
04:01:38.51 Index 3 (DOC_DATA_ID_DESC)
04:01:38.63 Index 4 (FK_DOC_DATA_DOC_LIST)
04:01:38.71 Relation 141 (DOC_DATA) is ok
04:01:38.71 Relation 147 (INVNT_SALDO)
04:01:38.71 process pointer page 0 of 1
04:01:38.71 Index 1 (PK_INVNT_SALDO)
04:01:38.71 Relation 147 (INVNT_SALDO) is ok
04:01:38.71 Relation 150 (PDISTR)
04:01:38.71 process pointer page 0 of 1
04:01:38.73 Index 2 (PDISTR_SND_ID)
04:01:38.74 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
04:01:38.75 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
04:01:38.76 Index 5 (PDISTR_AGENT_ID)
04:01:38.77 Relation 150 (PDISTR) is ok
04:01:38.77 Relation 151 (PSTORNED)
04:01:38.77 process pointer page 0 of 2
04:01:38.80 process pointer page 1 of 2
04:01:38.80 Index 2 (PSTORNED_SND_ID)
04:01:38.82 Index 3 (PSTORNED_RCV_ID)
04:01:38.83 Relation 151 (PSTORNED) is ok
04:01:38.83 Relation 156 (SEMAPHORES)
04:01:38.83 process pointer page 0 of 1
04:01:38.83 Index 1 (PK_SEMAPHORES)
04:01:38.83 Index 2 (SEMAPHORES_TASK_UNQ)
04:01:38.83 Relation 156 (SEMAPHORES) is ok
04:01:38.83 Relation 157 (INVNT_TURNOVER_LOG)
04:01:38.83 process pointer page 0 of 1
04:01:38.83 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
04:01:38.83 Relation 157 (INVNT_TURNOVER_LOG) is ok
04:01:38.83 Relation 160 (PERF_ESTIMATED)
04:01:38.83 process pointer page 0 of 1
04:01:38.84 Index 1 (PERF_EST_MINUTE_SINCE_START)
04:01:38.84 Relation 160 (PERF_ESTIMATED) is ok
04:01:38.84 Relation 161 (PERF_ISQL_STAT)
04:01:38.84 process pointer page 0 of 1
04:01:38.84 Index 1 (PERF_ISQL_STAT_TRN)
04:01:38.84 Relation 161 (PERF_ISQL_STAT) is ok
04:01:38.84 Relation 162 (PERF_LOG)
04:01:38.84 process pointer page 0 of 76
04:01:38.86 process pointer page 1 of 76
04:01:38.89 process pointer page 2 of 76
04:01:38.91 process pointer page 3 of 76
04:01:38.93 process pointer page 4 of 76
04:01:38.95 process pointer page 5 of 76
04:01:38.97 process pointer page 6 of 76
04:01:38.99 process pointer page 7 of 76
04:01:39.02 process pointer page 8 of 76
04:01:39.04 process pointer page 9 of 76
04:01:39.07 process pointer page 10 of 76
04:01:39.10 process pointer page 11 of 76
04:01:39.12 process pointer page 12 of 76
04:01:39.14 process pointer page 13 of 76
04:01:39.18 process pointer page 14 of 76
04:01:39.25 process pointer page 15 of 76
04:01:39.28 process pointer page 16 of 76
04:01:39.31 process pointer page 17 of 76
04:01:39.33 process pointer page 18 of 76
04:01:39.39 process pointer page 19 of 76
04:01:39.46 process pointer page 20 of 76
04:01:39.53 process pointer page 21 of 76
04:01:39.60 process pointer page 22 of 76
04:01:39.67 process pointer page 23 of 76
04:01:39.74 process pointer page 24 of 76
04:01:39.82 process pointer page 25 of 76
04:01:39.89 process pointer page 26 of 76
04:01:39.96 process pointer page 27 of 76
04:01:40.03 process pointer page 28 of 76
04:01:40.11 process pointer page 29 of 76
04:01:40.18 process pointer page 30 of 76
04:01:40.25 process pointer page 31 of 76
04:01:40.28 process pointer page 32 of 76
04:01:40.30 process pointer page 33 of 76
04:01:40.33 process pointer page 34 of 76
04:01:40.36 process pointer page 35 of 76
04:01:40.39 process pointer page 36 of 76
04:01:40.41 process pointer page 37 of 76
04:01:40.44 process pointer page 38 of 76
04:01:40.46 process pointer page 39 of 76
04:01:40.48 process pointer page 40 of 76
04:01:40.51 process pointer page 41 of 76
04:01:40.53 process pointer page 42 of 76
04:01:40.56 process pointer page 43 of 76
04:01:40.58 process pointer page 44 of 76
04:01:40.60 process pointer page 45 of 76
04:01:40.62 process pointer page 46 of 76
04:01:40.64 process pointer page 47 of 76
04:01:40.66 process pointer page 48 of 76
04:01:40.68 process pointer page 49 of 76
04:01:40.70 process pointer page 50 of 76
04:01:40.72 process pointer page 51 of 76
04:01:40.74 process pointer page 52 of 76
04:01:40.76 process pointer page 53 of 76
04:01:40.78 process pointer page 54 of 76
04:01:40.80 process pointer page 55 of 76
04:01:40.82 process pointer page 56 of 76
04:01:40.84 process pointer page 57 of 76
04:01:40.86 process pointer page 58 of 76
04:01:40.88 process pointer page 59 of 76
04:01:40.90 process pointer page 60 of 76
04:01:40.92 process pointer page 61 of 76
04:01:40.94 process pointer page 62 of 76
04:01:40.96 process pointer page 63 of 76
04:01:40.98 process pointer page 64 of 76
04:01:41.00 process pointer page 65 of 76
04:01:41.02 process pointer page 66 of 76
04:01:41.04 process pointer page 67 of 76
04:01:41.06 process pointer page 68 of 76
04:01:41.09 process pointer page 69 of 76
04:01:41.14 process pointer page 70 of 76
04:01:41.21 process pointer page 71 of 76
04:01:41.29 process pointer page 72 of 76
04:01:41.35 process pointer page 73 of 76
04:01:41.38 process pointer page 74 of 76
04:01:41.41 process pointer page 75 of 76
04:01:41.41 Index 1 (PERF_LOG_DTS_BEG_DESC)
04:01:42.23 Index 2 (PERF_LOG_UNIT)
04:01:43.95 Index 3 (PERF_LOG_TRN_DESC)
04:01:44.39 Index 4 (PERF_LOG_GDSCODE)
04:01:45.17 Relation 162 (PERF_LOG) is ok
04:01:45.17 Relation 166 (V_STOPTEST)
04:01:45.17 Relation 166 (V_STOPTEST) is ok
04:01:45.17 Relation 183 (V_QDISTR_SOURCE)
04:01:45.17 Relation 183 (V_QDISTR_SOURCE) is ok
04:01:45.17 Relation 184 (V_QSTORNED_SOURCE)
04:01:45.17 Relation 184 (V_QSTORNED_SOURCE) is ok
04:01:45.17 Relation 258 (XQD_1000_1200)
04:01:45.17 process pointer page 0 of 1
04:01:45.17 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
04:01:45.17 Relation 258 (XQD_1000_1200) is ok
04:01:45.17 Relation 259 (XQD_1200_2000)
04:01:45.17 process pointer page 0 of 1
04:01:45.18 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
04:01:45.18 Relation 259 (XQD_1200_2000) is ok
04:01:45.18 Relation 260 (XQD_1000_3300)
04:01:45.18 process pointer page 0 of 1
04:01:45.19 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
04:01:45.20 Index 2 (XQD_1000_3300_DOC)
04:01:45.21 Relation 260 (XQD_1000_3300) is ok
04:01:45.21 Relation 261 (XQD_2000_3300)
04:01:45.21 process pointer page 0 of 19
04:01:45.26 process pointer page 1 of 19
04:01:45.30 process pointer page 2 of 19
04:01:45.35 process pointer page 3 of 19
04:01:45.40 process pointer page 4 of 19
04:01:45.57 process pointer page 5 of 19
04:01:45.74 process pointer page 6 of 19
04:01:45.88 process pointer page 7 of 19
04:01:45.97 process pointer page 8 of 19
04:01:46.09 process pointer page 9 of 19
04:01:46.19 process pointer page 10 of 19
04:01:46.25 process pointer page 11 of 19
04:01:46.31 process pointer page 12 of 19
04:01:46.36 process pointer page 13 of 19
04:01:46.41 process pointer page 14 of 19
04:01:46.47 process pointer page 15 of 19
04:01:46.56 process pointer page 16 of 19
04:01:46.66 process pointer page 17 of 19
04:01:46.70 process pointer page 18 of 19
04:01:46.74 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
04:01:47.01 Relation 261 (XQD_2000_3300) is ok
04:01:47.01 Relation 262 (XQD_2100_3300)
04:01:47.01 process pointer page 0 of 2
04:01:47.01 process pointer page 1 of 2
04:01:47.01 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
04:01:47.02 Relation 262 (XQD_2100_3300) is ok
04:01:47.02 Relation 263 (XQD_3300_3400)
04:01:47.02 process pointer page 0 of 20
04:01:47.06 process pointer page 1 of 20
04:01:47.10 process pointer page 2 of 20
04:01:47.14 process pointer page 3 of 20
04:01:47.19 process pointer page 4 of 20
04:01:47.25 process pointer page 5 of 20
04:01:47.37 process pointer page 6 of 20
04:01:47.42 process pointer page 7 of 20
04:01:47.47 process pointer page 8 of 20
04:01:47.53 process pointer page 9 of 20
04:01:47.61 process pointer page 10 of 20
04:01:47.68 process pointer page 11 of 20
04:01:47.77 process pointer page 12 of 20
04:01:47.81 process pointer page 13 of 20
04:01:47.86 process pointer page 14 of 20
04:01:47.91 process pointer page 15 of 20
04:01:48.01 process pointer page 16 of 20
04:01:48.07 process pointer page 17 of 20
04:01:48.18 process pointer page 18 of 20
04:01:48.29 process pointer page 19 of 20
04:01:48.33 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
04:01:48.86 Relation 263 (XQD_3300_3400) is ok
04:01:48.86 Relation 264 (XQS_1000_1200)
04:01:48.86 process pointer page 0 of 16
04:01:48.89 process pointer page 1 of 16
04:01:48.98 process pointer page 2 of 16
04:01:49.03 process pointer page 3 of 16
04:01:49.06 process pointer page 4 of 16
04:01:49.10 process pointer page 5 of 16
04:01:49.13 process pointer page 6 of 16
04:01:49.17 process pointer page 7 of 16
04:01:49.20 process pointer page 8 of 16
04:01:49.23 process pointer page 9 of 16
04:01:49.27 process pointer page 10 of 16
04:01:49.30 process pointer page 11 of 16
04:01:49.32 process pointer page 12 of 16
04:01:49.35 process pointer page 13 of 16
04:01:49.37 process pointer page 14 of 16
04:01:49.40 process pointer page 15 of 16
04:01:49.43 Index 1 (XQS_1000_1200_DOC_ID)
04:01:49.71 Index 2 (XQS_1000_1200_SND_ID)
04:01:49.89 Index 3 (XQS_1000_1200_RCV_ID)
04:01:50.03 Relation 264 (XQS_1000_1200) is ok
04:01:50.03 Relation 265 (XQS_1200_2000)
04:01:50.03 process pointer page 0 of 22
04:01:50.06 process pointer page 1 of 22
04:01:50.10 process pointer page 2 of 22
04:01:50.13 process pointer page 3 of 22
04:01:50.16 process pointer page 4 of 22
04:01:50.19 process pointer page 5 of 22
04:01:50.23 process pointer page 6 of 22
04:01:50.26 process pointer page 7 of 22
04:01:50.29 process pointer page 8 of 22
04:01:50.33 process pointer page 9 of 22
04:01:50.36 process pointer page 10 of 22
04:01:50.40 process pointer page 11 of 22
04:01:50.43 process pointer page 12 of 22
04:01:50.46 process pointer page 13 of 22
04:01:50.50 process pointer page 14 of 22
04:01:50.61 process pointer page 15 of 22
04:01:50.71 process pointer page 16 of 22
04:01:50.75 process pointer page 17 of 22
04:01:50.79 process pointer page 18 of 22
04:01:50.83 process pointer page 19 of 22
04:01:50.86 process pointer page 20 of 22
04:01:50.89 process pointer page 21 of 22
04:01:50.92 Index 1 (XQS_1200_2000_DOC_ID)
04:01:51.14 Index 2 (XQS_1200_2000_SND_ID)
04:01:51.54 Index 3 (XQS_1200_2000_RCV_ID)
04:01:51.76 Relation 265 (XQS_1200_2000) is ok
04:01:51.76 Relation 266 (XQS_1000_3300)
04:01:51.76 process pointer page 0 of 19
04:01:51.79 process pointer page 1 of 19
04:01:51.83 process pointer page 2 of 19
04:01:51.87 process pointer page 3 of 19
04:01:51.90 process pointer page 4 of 19
04:01:51.94 process pointer page 5 of 19
04:01:51.98 process pointer page 6 of 19
04:01:52.07 process pointer page 7 of 19
04:01:52.17 process pointer page 8 of 19
04:01:52.22 process pointer page 9 of 19
04:01:52.26 process pointer page 10 of 19
04:01:52.31 process pointer page 11 of 19
04:01:52.34 process pointer page 12 of 19
04:01:52.38 process pointer page 13 of 19
04:01:52.41 process pointer page 14 of 19
04:01:52.45 process pointer page 15 of 19
04:01:52.48 process pointer page 16 of 19
04:01:52.51 process pointer page 17 of 19
04:01:52.54 process pointer page 18 of 19
04:01:52.55 Index 1 (XQS_1000_3300_DOC_ID)
04:01:52.73 Index 2 (XQS_1000_3300_SND_ID)
04:01:52.93 Index 3 (XQS_1000_3300_RCV_ID)
04:01:53.10 Relation 266 (XQS_1000_3300) is ok
04:01:53.10 Relation 267 (XQS_2000_3300)
04:01:53.10 process pointer page 0 of 1
04:01:53.10 Index 1 (XQS_2000_3300_DOC_ID)
04:01:53.10 Index 2 (XQS_2000_3300_SND_ID)
04:01:53.10 Index 3 (XQS_2000_3300_RCV_ID)
04:01:53.10 Relation 267 (XQS_2000_3300) is ok
04:01:53.10 Relation 268 (XQS_2100_3300)
04:01:53.10 process pointer page 0 of 21
04:01:53.13 process pointer page 1 of 21
04:01:53.20 process pointer page 2 of 21
04:01:53.33 process pointer page 3 of 21
04:01:53.39 process pointer page 4 of 21
04:01:53.45 process pointer page 5 of 21
04:01:53.50 process pointer page 6 of 21
04:01:53.54 process pointer page 7 of 21
04:01:53.58 process pointer page 8 of 21
04:01:53.62 process pointer page 9 of 21
04:01:53.66 process pointer page 10 of 21
04:01:53.69 process pointer page 11 of 21
04:01:53.72 process pointer page 12 of 21
04:01:53.75 process pointer page 13 of 21
04:01:53.78 process pointer page 14 of 21
04:01:53.81 process pointer page 15 of 21
04:01:53.83 process pointer page 16 of 21
04:01:53.86 process pointer page 17 of 21
04:01:53.89 process pointer page 18 of 21
04:01:53.92 process pointer page 19 of 21
04:01:53.95 process pointer page 20 of 21
04:01:53.96 Index 1 (XQS_2100_3300_DOC_ID)
04:01:54.19 Index 2 (XQS_2100_3300_SND_ID)
04:01:54.43 Index 3 (XQS_2100_3300_RCV_ID)
04:01:54.61 Relation 268 (XQS_2100_3300) is ok
04:01:54.61 Relation 269 (XQS_3300_3400)
04:01:54.61 process pointer page 0 of 3
04:01:54.65 process pointer page 1 of 3
04:01:54.69 process pointer page 2 of 3
04:01:54.72 Index 1 (XQS_3300_3400_DOC_ID)
04:01:54.75 Index 2 (XQS_3300_3400_SND_ID)
04:01:54.78 Relation 269 (XQS_3300_3400) is ok
04:01:54.78 Validation finished
Done for 16840 ms, from 4:01:37.94 to 4:01:54.78.
Differences between old and current firebird.log
4:01:55.06. 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:
2015-12-19 04:01 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 +++Comparing files E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
FC: no differences encountered
+++ end of comparison +++
Final processing ISQL logs in e:\temp\logs.oltp25
Remove 14 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp25\oltp25_*.*:
| ERRORS_CHECKING_RESULT |
|---|
| NO_SEVERE_ERRORS_FOUND |
2015-12-19 4:01:58.15 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html