| | No interesting AD (ADF) trace points. |
|
|
| | DMF trace points from 01 to 99 are session specific.
Everything over 99 is server wide, unless noted otherwise.
|
| |
| DM10 | equivalent to SET IO_TRACE |
| DM11 | equivalent to SET LOG_TRACE |
| DM12 | When used with DM11, turns on LSN display in log trace |
| DM32 | Turn off Replicator data capturing for the current session |
| DM33 | Row-lock protocol double-checking for session |
| DM34 | Output page size/page type xref |
| DM35 | Produce E_DM9066_LOCK_BUSY messages with information
about blocked resources with TIMEOUT = NOWAIT. |
| DM36 nn | Set DMF parallelism to nn threads for MODIFY.
Equivalent to degree_of_parallelism config parameter. |
| DM37 | Turn on double-check for row lock during delete or update when using MVCC. |
| DM38 | Turn off etab buffered-put optimization |
| DM39 nn | Flag etab full on segment nn (for testing only) |
| DM40 tabid retry | Force MVCC conflict(s) on table tabid (for testing only) |
| DM101 | Dump DMF memory to II_DBMS_LOG |
| DM102 | Turn off Replicator for the current database |
| DM103 | Fill DMF memory with pad character when allocated (detects missing initialization) |
| DM104 | Fill DMF memory with pad character when freed (detect dangling reference) |
| DM105 | Toggle DMF memory stats collection by type |
| DM302 | Turn on buffer manager lock tracing |
| DM303 | Send CSP request to enter debugger |
| DM304 | Lock request and list dump when escalation deadlock detected |
| DM305 to 308 | like log_esc_xx_yy config settings |
| DM309 | Turn on locklist dump (into iircp.log) when deadlock detected |
| DM405 | Trace MVCC consistent-read activity |
| DM406 | Trace MVCC CR activity from journals only |
| DM415 | Turn on buffer manager consistency checks |
| DM416 | DMF Memory dump if DM415 consistency check detects error |
| DM418 | Error return after 9C01 error |
| DM419 | DMF memory dump after 9C01 error |
| DM420 | Output DMF buffer cache stats snapshot to II_DBMS_LOG |
| DM421 | Flush and invalidate DMF buffer cache |
| DM422 | Invalidate unmodified pages from DMF buffer cache |
| DM426 | Don't do group reads |
| DM427 baseid pageno | Purge single (base table) page from cache |
| DM428 baseid | Purge table's pages from cache (and its indexes
too) |
| DM429 | Enable transaction queue consistency checks |
| DM430 | Print stuff if DM429 detects a loop |
| DM431 | Disable page checksumming
Warning! DM431 could make your database permanently unusable
by a regular server! |
| DM432 | Make checksum error a warning/trace message |
| DM434 | Print extra control block stuff if DM415 detects error |
| DM435 | Ignore cache priorities (use TCB priority instead) |
| DM483 | Fix only one system catalog page at a time |
| DM501 | Log simple sort statistics, DMF sorts only |
| DM502 | Alternate work file striping method (unsure of details) |
| DM503 | Disable parallel sort |
| DM504-506 | Force 1, 2, 3 sort threads |
| DM508-510 | Force sort exchange buf size to 500, 5000, 25000 |
| DM511 | Dump statistics after a MODIFY |
| DM512 | Prevent the use of online (concurrent_updates) MODIFY |
| DM513 | Log a lot of online MODIFY diagnostic and trace info |
| DM514 | Brief sleep at strategic points during online MODIFY while sidefile enabled
(to allow concurrent updates to occur) |
| DM515 | Brief sleep during online MODIFY readlock-nolock apply
(to allow concurrent updates to occur) |
| DM601-DM610 | Log BTREE Get, Del, Put, Replace, Split, Merge,
DM607 notused, Allocate, Search, Build debug info to DBMS log. Can be massive |
| DM611 | Log BTREE allocate-entry-on-page |
| DM612 | Added BTREE edit checking e.g. in allocate-entry |
| DM612 | Additional output in BTREE build trace (maybe DM612 got used twice?) |
| DM613 | BTREE build call logging |
| DM614 | Log btree page if corruption detected, server wide |
| DM615 baseId indexId | Dump btree/rtree base table or index to
II_DBMS_LOG |
| DM616 | BTREE CREATE INDEX: force index compression |
| DM617 | Skip freeing of empty BTREE overflow chain |
| DM618 | Misc additional BTREE tracing: positioning, incr/decr keys, etc |
| DM631-635, 649 | As DM60x but for RTREE
|
| DM650 | Trace page free list operations |
| DM651 | Build-freelist tracing |
| DM713 baseid | Purge table control block (and all partition and index TCB's) |
| DM714 pagesize | Set default page size for server |
| DM716 | Force row level locking if possible |
| DM717 | Force read-committed isolation level |
| DM718 | Force repeatable read isolation level |
| DM719 | Force BTREE reposition on first GET rather than believing position info |
| DM720 | gateway call trace |
| DM720 | Also, force continue instead of rollback in dup checking |
| DM721 pagetype | Set default page type for server |
| DM722 | Add blob coupon validation checks for INSERT and UPDATE |
| DM723 | Debug check for proper lock protocol before logging btree-update
log records |
| DM801 | DMF will skip bad rows (eg to allow modify of corrupted table) |
| DM802 | DMF will return garbage for bad rows (eg to allow deleting them) |
| DM803 | Report but ignore DMF errors while handling blobs |
| DM804 | Dump SAGG (simple aggregate) stuff |
| DM805 | Dump AES encrypt buffers to DBMS log |
| DM806 | Dump AES decrypt buffers to DBMS log |
| DM902 | Compress "old" row in REP log records |
| DM903 | Log beginning/end of rollback in II_DBMS_LOG |
| DM1201 | Call operation (see DM1205) |
| DM1202 | Call return status |
| DM1203 | Call input parameters |
| DM1204 | Call output parameters |
| DM1205 | Turns on dmd_call tracing (other DM12xx things)
Also causes hard spin if DMF parameter error (to allow e.g. pstack) |
| DM1210 | Call timing enable (VMS only) |
| DM1211 | Call timing display (only really useful on VMS?) |
| DM1220 | Perform memory check at dmd_call |
| | NOTE: For rcp, acp, etc set DM13xx via II_DMF_TRACE=nnn,nnn,nnn ... |
| DM1301 | Log fast-commit thread stats |
| DM1302 | Log write-behind thread stats |
| DM1303 | Log consistency point EOF stats |
| DM1305 | Force a consistency point |
| DM1306 | Set verbosity in the rcp |
| DM1309 | Even more verbosity in rcp, needs DM1306 |
| DM1310 | Trace page header too if DM1315 |
| DM1311 | Trace page contents too if DM1315 |
| DM1312 | Turn OFF log file dumping if inconsistency error in rcp |
| DM1313 | Triggers verbosity in the archiver |
| DM1314 | Force an archiver cycle |
| DM1315 | Turn on extra tracing in redo/journal |
| DM1316 | Inhibit dmd_check memory dump |
| DM1320 | Enable parallel secondary index updating (experimental) |
| DM1321 | Start archiver cycle and wait for at least one cycle to finish |
| DM1322 | Force full attribute(s) compare for dmve PUT/DEL/REP |
| DM1419 | Crash the logging system |
| DM1434 | Force log buffers to disk (might be useful before forced crash) |
| DM1440 | Show work (ie, sort) locations |
| DM1442 | Toggle optimized TX log writes |
| DM1443 | Toggle optimized TX log write tracing (to DBMS log) |
| DM1444 nn | Set last table-id assigned in the DB config file. |
|
|
| | OPF trace flags: in theory, through OP128 are global, above 128 are session.
But it doesn't seem that the global versions are implemented. |
| OP129 | (reserved for upcoming insert-via-LOAD optimization) |
| OP130 | Turn off nonessential consistency checks,
which at present seem to be just the "histogram increasing" checks |
| OP131 | Disable join-time partition qualification |
| OP132 | SET NOFLATTEN |
| OP133 | Flatten queries even if the parser suggests not to; flattening can
still be suppressed by SET NOFLATTEN, or the query_flattening parameter
OFF, or the qflatten_aggregate parameter OFF with correlated aggrs.
Note that OP133 is not the same as SET FLATTEN. |
| OP134 | Turn off NOT IN/NOT EXISTS -> outer join transformation |
| OP135 | Enable cardinality-by-sampling predicate estimation for X100 |
| OP136 | Disable new (early) OPF predicate propagation |
| OP137 | Disable old (sq based) OPF push/suck predicate propagation |
| OP138 | Disable X100 pre-evaluation of string booleans (single EQC) |
| OP139 | Disable X100 pre-evaluation of string booleans (multi EQC) |
| OP140 | Pretty-print X100 query algebra |
| OP141 | Disable X100 CASE boolfact optimization |
| OP144 | Write basic OPF stats to DBMS log after each query |
| OP145 | Appears to be the same as SET QEP |
| OP146 | Dump query trees at start of aggregate processing |
| OP147 | Trace aggregate combining processing |
| OP148 | Suppress presort of K/T-join outers |
| OP149 | Show overall QP tree outline |
| OP150 | Detailed QP dump: QP plus result of OPC code gen |
| OP151 | Turn off query compilation, useful to see if crash-problem is in
OPF or OPC |
| OP152 | like SET NOTIMEOUT |
| OP153 | An abbreviated joinop table output (shorter than OP156) |
| OP156 | Print all joinop tables |
| OP157 | Apparently does a couple things:
prints outer join "stuff" during/after outer join processing;
prints map of equivalence classes for which histograms are needed |
| OP158 | Print parser stuff for SE join subquery |
| OP159 | Send warning messages to the user instead of suppressing them |
| OP160 | like SET OPTIMIZEONLY |
| OP161 | Dump data structures from OPF to OPC |
| OP162 | Generic "new feature" switch. (does nothing in 10.x, 11.[01]) |
| OP163 | Prevents use of histograms in join selectivity computation, using an IBM heuristic instead |
| OP164 | Dump distributed query text for each CO tree node (STAR only) |
| OP165 | Don't use any statistics |
| OP166 | Enable a fake gateway optimizer |
| OP167 | Don't pick key joins (use merge or hash joins instead) |
| OP169 | Treat all STAR queries as multi-site queries |
| OP170 | Modified parse tree display (for QEP, also happens at "interesting"
points like NOT EXISTS transform, CNF normalization, etc) |
| OP171 | Send constants as ~V (for STAR) |
| OP172 | Suppress use of RTREE indexes |
| OP173 | Enable the building of the print-row CXs (for QE99, QE1nn tracing) |
| OP174 | change behaviour of control C to exit with best query plan |
| OP175 | Check text segments to make sure everything is printable (STAR) |
| OP176 | Simply continue from float exceptions in the optimizer, don't recover |
| OP177 | Attempt to always use keying strategies (doesn't work too well) |
| OP178 | Default the "complete" flag to TRUE |
| OP180 | Look at cartesian product search space.
Useful for multi-attribute keying in which cart-prod of small
tables could be used to key into the large table.
Allows cart-prod below top node when generated by OPF (as opposed to
required by the form of the user query); normally such generated qep's
are rejected. |
| OP181 | Look at reduced search space given heuristic estimates of index usage;
tries to avoid full enumeration. |
| OP182 | Force old CNF algorithm (transform everything to CNF), turns off
MS-Access transformation |
| OP183 | Don't do the CNF transformation (overrides everything else) |
| OP187 | Turn off card-prod keying optimization |
| OP188 | Print QEP's as new better subplans are discovered.
Related to OP215 and OP216.
|
| OP189 | Assume some correlation between attributes (on proj-rest) so that
selectivities do not become small as rapidly as normal |
| OP190 | Use old 6.4 join cardinality estimation formulae |
| OP191 | Do not assume some correlation between attributes when doing multi
equivalence class boolean factors (so that estimates tend to get small
more rapidly in this case) |
| OP192 | Revert to pre-6.4 keying estimates |
| OP194 | Disable heuristic that tries to guess at useful indexes for complex
queries (more than 4 range vars), and tries to look at those plans first |
| OP195 | Disables "global base array" compilation, which reduces data movement in the compiled query plan.
(Prior to 9.1.0, op195 ENables global basearrays.) |
| OP196 | Use 6.4 flattening algorithms instead of new ones |
| OP197 | Look at all plans regardless of cost estimate, typically used in
conjunction with OP255 |
| OP199 | Print QEP without cost estimates |
| OP201 | Change stats/nostats estimate from join-histo-to-itself, to use instead a
2-cell histo with min/max for data type. |
| OP202 | Turn on union view optimization for simple aggregates
This was meant for STAR to push aggregate processing lower into the LDB's
to reduce row traffic, but is apparently not STAR specific |
| OP203 | Display stuff (Tups, Pages, D, C) as float in QEP instead of int |
| OP205 | Same as config parameter opf_stats_nostats_max |
| OP206 | single-query disable of opf_stats_nostats_max
(see Doug Inkster's c.d.i posting of 22-Dec-00) |
| OP207 | Print generated X100 algebra (Vector queries only;
does not display algebra that is generated outside of OPF |
| OP209 | Dump enumeration memory structures, useful in greedy enumeration debugging |
| OP210 | Enable extended CO-tree dump, more than SET QEP shows |
| OP211 | Use old reverse order when adding useful secondary indexes |
| OP212 | Turn on 'table_auto_structure' dynamically |
| OP213 | Report attributes in WHERE and ON clauses that are missing statistics |
| OP214 | Use with OP170 for much briefer op146 style tree output |
| OP215 | Like OP188 but prints fragments which are rejected for non-cost reasons. |
| OP216 | Like OP188 but only prints best-so-far complete QEP's, not fragments |
| OP218 | Ignore opf_pq_threshold when placing EXCH nodes. (A built-in minimum
threshold of 50, MINEXCH, is still enforced.) |
| OP219 | Disables aggregate pushing (moving aggs before joins) |
| OP240 [n] | Enable OPF dot traces, n=10 for additionals |
| OP241 n1 n2 | Various opa_analyze_views dot traces, n1=1 for simple dump, n1 or n2 N
for view agg / agg attr expansion limit N |
| OP246 nn | Greedy enumeration cost fudge by NN percent |
| OP247 nn | Force new (greedy) enumeration if more than NN tables+indexes
in a query |
| OP248 nn | Reduce K-join cost estimates by dividing by nn. |
| OP251 nn | Set DIO cost for scan (default is 1 DIO per 8 pages)
To be used for bug catching, not tuning. |
| OP253 nn | Adjust conversion factor used to make time units out of
cost units. 100 means use default, 150 means look for better plans
50% longer, etc. |
| OP254 num1 [num2] | Set Star data movement cost factors: num1 is cross-node
and num2 is LDB-to-LDB within node |
| OP255 num1 [num2] | timeout after plan #num1 and sub-plan #num2 evaluated |
|
|
| | PSF trace points <128 are global, >=128 are session.
Doesn't appear to be any global ones turned on normally... |
| PS129 | Same as SET PRINTQRY |
| PS131 | Trace grant checking (partially xDEBUG) |
| PS132 | Print messages about sharing a REPEATED query (or not) |
| PS133 | Trace grantable-procedure checking (some is xDEBUG) |
| PS144 | Print query tree after parse (partially xDEBUG) |
| PS145 | Print query tree after parse (different format) |
| PS147 | Unicode normalization diagnostics in the SQL scanner |
| PS148 | Trace REGISTER actions |
| PS150 | Allow "DROP SCHEMA" which is not officially supported |
| PS151 | Enable 6.4 ambiguous-replace compatibility, like the
ambig_replace_64compat parameter.
Also enables "define query open cursor" for repeated
cursors, an unsupported feature of old vintage and uncertain status. |
| PS152 | Trace some cache_dynamic processing |
| PS175 | Print constraint list at CREATE/ALTER verify time |
| PS176 | Generate dummy not-null constraints for all NOT NULL columns in
CREATE AS SELECT - some sort of ANSI compliance thing |
| PS201 | Turns off error indication from "duplicate key on insert/update".
Causes instead 0 rowcount to be returned with no error. Was
originally put in for CA-Masterpiece so that cursor would not
be closed. |
| PS202 | Equivalent to turning on psf_vch_prec in the config. This resolves
varchar/char exprs to varchar instead of char. |
| PS203 | Dump PSF memory pool to DBMS log |
| PS240 n1 n2 | Enable PSF dot traces; n1=1 to suppress check-used; see pshparse.h for
other n1/n2 values |
| PS251 | Disallow single-quoted identifiers (a deprecated feature) |
|
|
| QE06 | Show RETURN value (from dbproc) |
| QE08 | Generate outer-join rule for WITH CHECK OPTION instead of subselect rule.
Also requires QE10. |
| QE09 | Show "execute immediate" text, e.g. from constraints |
| QE10 | Generate statement level rule for WITH CHECK OPTION instead of row level |
| QE11 NN | Run query to completion, but suppress all but the first NN rows of
output. (Designed for select query timing.) |
| QE51 | (STAR) Validate query plan |
| QE55 | (STAR) Trace STAR queries |
| QE56 | (STAR) Trace DDL |
| QE58 | (STAR) Trace QEF calls |
| QE59 | (STAR) Trace queries in error |
| QE60 | Suppress simple aggregate optimization (sagg -> origagg) |
| QE70 | Suppress parallel index building, do 'em one at a time |
| QE71 | Compile EXCH nodes but execute them serially, no child threads |
| QE72 | Trace hash join partition size/count to DBMS log |
| QE73 | Trace query result cache operations |
| QE74 | QE73 but to II_DBMS_LOG |
| QE88 | Abbreviated QE90 showing actual and estimate rowcount at each QP node |
| QE89 | Hash join/agg debug output (to DBMS log) (includes qeehash reservation trace as well as
execution time trace) |
| QE90 | Show diff between estimated and actual tuples, disk, cpu at each
query execution node (best used with set qep or with op149) |
| QE91 | Print a short execution time summary (cpu, dio, et) |
| QE92 | use old-style insertion sort for QEF.
The old sort eliminated dups better than the heapsort, and may work
better for randomized but very heavily duplicated input. Or not... |
| QE93 | Print hash join/agg statistics summary |
| QE94 | Don't sort in QEF, dump straight to DMF sorter |
| QE95 | Trace exchange node operations (parallel query) |
| QE96 | Trace CUT buffer statistics for exchange nodes |
| QE97 | Detailed (and voluminous) CUT trace for parallel query |
| QE99 | Watch rows move thru the QP (also needs OP173) |
| QE1nn | Watch rows emerge from node NN (up to 28) of the QEP (also needs OP173) |
| QE131 | If error in DBP, show line # and action. Interferes with exception handling. |
|
|
| QS501 | Show QSF pool memleft, total, %used |
| QS502 | Show QSF pool objects & buckets summary |
| QS503 | Show QSF hash buckets |
| QS504 | Show QSF sessions |
| QS505 | Show LRU queue info |
| QS506 | Invalidate the QSF pool & procedure cache |
| QS507 | Show largest QSF pool allocated/requested |
| QS508 | Dump LRU queue to DBMS log |
| QS510 | Outputs QSF ULM map to II_DBMS_LOG |
| QS511 | Outputs QSF object and ULM pool dump to II_DBMS_LOG |
| QS512 | Flush the query results cache |
|
|
| RD01 | Invalidate relation cache |
| RD02 | Invalidate relation & QTREE cache |
| RD03 | Invalidate LDB cache (STAR) |
| RD04 | All of the above |
| RD05 | Invalidate defaults cache |
| RD10 | Invalidate everything in RDF |
| RD11 | RDF cache usage summary, to II_DBMS_LOG |
| RD12 | RDF cache stats, same as shutdown summary, to II_DBMS_LOG |
| RD20 | Don't look for synonyms |
| RD21 | (STAR) Don't update iidd_ddb_tableinfo timestamp |
| RD22 | Compute and use checksums to detect RDF memory corruption |
| RD23 | (STAR) Print RDF queries to LDB |
| RD24 | Expose histograms via IMA |
|
|
| SC0 | Print query text - use SET PRINTQRY |
| SC1 | Trace unusual/error SCE events |
| SC2 | Print user alert events - use SET PRINTDBEVENTS |
| SC3 | Log user alert events - use SET LOGDBEVENTS |
| SC4 | Log SCE requests (from QEF) |
| SC5 | Trace alert notifications to terminal |
| SC6 | Trace alert state transitions to terminal |
| SC902 | Write error messages to trace log: all errmsgs
including user level messages, to errlog
too, server-wide. |
| SC903 | Send all logged messages to the client
(the "other half" of sc902, send errlog msgs to user) |
| SC904 | Trace memory allocations to trace file |
| SC906 | Log all session startup and shutdown |
| SC907 | Allocate guard pages around each server memory expansion |
| SC908 | Crash the server (my, how useful) |
| SC909 | Dump server statistics to dbms log |
| SC910 | Suppress trace messages to client, send to DBMS log instead |
| SC911 | Dump server memory info to dbms log |
| SC914 | Start a replicator qman thread,
Useful when rep config error has shut it down. |
| SC916 N M | Memory diags to DBMS log: no args gives help. |
| SC916 1: Print sc0m pools |
| SC916 2: Print sc0m pools with audit values |
| SC916 3: List ULM pools and their index numbers |
| SC916 4 P: ULM Pool P map |
| SC916 5 P: ULM Pool P free/allocated chain dump |
| SC916 6 P: ULM Pool P run consistency check |
| SC921 | Dump local server event memory |
| SC922 | Dump cross server event memory |
| SC923 NN | Alter SCE event processing, nn = 1000 for help |
| SC924 NN | Log query causing errors to error log; to log for a specific
error number, use optional decimal NN. |
| SC925 X [Y] | Log queries running >X (and <Y) seconds |
| SC930 NN | Query recording for playback, see Ingres wiki |
| SC1000 | SCF trace point help |
|
|
| SX2 | Dump SXF stats |
| SX3 | Dump SXF session info |
| SX5 | Dump SXF shared memory info |
| SX70 | Log SXF logical layer operations |
| SX85 | Log SXF audit record queuing operations |
| SX90 | Log SXF audit state changes |