REPLACE QUERY LOGGING
[ WITH logging-option [,...logging-option] ]
[ MODE = m ]
[ DETAILDIAG = n [ STEPETTHRESHOLD = s ] ]
[ LIMIT limit_option [ AND limit-option ] ]
ON on_items [;]
Syntax Elements
- logging-option
(ALL | EXPLAIN | [NO COLUMNS] OBJECTS | SQL | STEPINFO |
PARAMINFO | [VERBOSE] XMLPLAN | [DETAILED] STATSUSAGE)
- limit_option
{ SQLTEXT [ = n] |
{ SUMMARY = n1, n2, n3 | THRESHOLD [ = n ] }
[ CPUTIME | CPUTIMENORM | ELAPSEDSEC | ELAPSEDTIME | IOCOUNT ]
}
- on_items
{ ALL [ ACCOUNT = ('account id' [ ... ,'account id' ] ) ] }
ON { user-name [ ACCOUNT = ('account id' [ ... ,'account id' ] ) ] }
{ user-name [ ... ,user-name ] }
{ database-name [ ... ,database-name ] }
{ APPLNAME = ('application-name' [ ... ,'application-name' ] ) } ;