Activity logged for databases with transaction logging

If a database uses transaction logging, the following SQL statements generate one or more log records. If these statements are rolled back, the rollback also generates log records.
  • DELETE
  • FLUSH
  • INSERT
  • LOAD
  • MERGE
  • PUT
  • SELECT INTO TEMP
  • UNLOAD
  • UPDATE
The following SQL statements generate logs in special situations.
Table 1. SQL statements that generate logs in special situations.
SQL statement Log record that the statement generates
BEGIN WORK Returns an error unless the database uses transaction logging. A log record is produced if the transaction does some other logging work.
COMMIT WORK Returns an error unless the database uses transaction logging. A log record is produced if the transaction does some other logging work.
ROLLBACK WORK Returns an error unless the database uses transaction logging. A log record is produced if the transaction does some other logging work.
EXECUTE Whether this statement generates a log record depends on the command being run.
EXECUTE FUNCTION Whether this statement generates a log record depends on the function being executed.
EXECUTE IMMEDIATE Whether this statement generates a log record depends on the command being run.
EXECUTE PROCEDURE Whether this statement generates a log record depends on the procedure being executed.

Copyright© 2019 HCL Technologies Limited