Home | Previous Page | Next Page   Logging and Log Administration > Logging > Logging of SQL Statements and Database Server Activity >

Activity That is Not Logged

The following SQL statements do not produce log records, regardless of the database logging mode.

ALLOCATE COLLECTION DEALLOCATE ROW LOCK TABLE
ALLOCATE DESCRIPTOR DECLARE OPEN
ALLOCATE ROW DESCRIBE OUTPUT
CLOSE DISCONNECT PREPARE
CONNECT FETCH SELECT
DATABASE FREE SET
DEALLOCATE COLLECTION GET DESCRIPTOR UNLOCK TABLE
DEALLOCATE DESCRIPTOR GET DIAGNOSTICS WHENEVER
DEALLOCATE ROW INFO

For temporary tables in temporary dbspaces, nothing is logged, not even the SQL statements listed in Activity That is Always Logged. If you include temporary (nonlogging) dbspaces in DBSPACETEMP, the database server places nonlogging tables in these temporary dbspaces first. For more information, see Temporary Tables.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]