Activity that is always logged

Some database operations always generate logical-log records, even if you turn off transaction logging or use nonlogging tables.

The following operations are always logged for permanent tables:
  • Certain SQL statements, including SQL data definition statements
  • Storage-space backups
  • Checkpoints
  • Administrative changes to the database server configuration such as adding a chunk or dbspace
  • Allocation of new extents to tables
  • A change to the logging status of a database
  • Smart-large-object operations:
    • Creating
    • Deleting
    • Allocating and deallocating extents
    • Truncating
    • Combining and splitting chunk free list pages
    • Changing the LO header and the LO reference count
  • Sbspace metadata
  • Blobspaces
The following table lists statements that generate operations that are logged even if transaction logging is turned off.
  • ALTER ACCESS_METHOD
  • ALTER FRAGMENT
  • ALTER FUNCTION
  • ALTER INDEX
  • ALTER PROCEDURE
  • ALTER ROUTINE
  • ALTER SECURITY LABEL COMPONENT
  • ALTER SEQUENCE
  • ALTER TABLE
  • ALTER TRUSTED CONTEXT
  • ALTER USER
  • CLOSE DATABASE
  • CREATE ACCESS_METHOD
  • CREATE AGGREGATE
  • CREATE CAST
  • CREATE DATABASE
  • CREATE DISTINCT TYPE
  • CREATE EXTERNAL TABLE
  • CREATE FUNCTION
  • CREATE FUNCTION FROM
  • CREATE INDEX
  • CREATE OPAQUE TYPE
  • CREATE OPCLASS
  • CREATE PROCEDURE
  • CREATE PROCEDURE FROM
  • CREATE ROLE
  • CREATE ROUTINE FROM
  • CREATE ROW TYPE
  • CREATE SCHEMA
  • CREATE SECURITY LABEL
  • CREATE SECURITY LABEL COMPONENT
  • CREATE SECURITY POLICY
  • CREATE SEQUENCE
  • CREATE SYNONYM
  • CREATE TABLE
  • CREATE TEMP TABLE
  • CREATE TRIGGER
  • CREATE TRUSTED CONTEXT
  • CREATE USER
  • CREATE VIEW
  • CREATE XADATASOURCE
  • CREATE XADATASOURCE TYPE
  • DROP ACCESS_METHOD
  • DROP AGGREGATE
  • DROP CAST
  • DROP DATABASE
  • DROP FUNCTION
  • DROP INDEX
  • DROP OPCLASS
  • DROP PROCEDURE
  • DROP ROLE
  • DROP ROUTINE
  • DROP ROW TYPE
  • DROP SECURITY
  • DROP SEQUENCE
  • DROP SYNONYM
  • DROP TABLE
  • DROP TRIGGER
  • DROP TRUSTED CONTEXT
  • DROP TYPE
  • DROP USER
  • DROP VIEW
  • DROP XADATASOURCE
  • DROP XADATASOURCE TYPE
  • GRANT
  • GRANT FRAGMENT
  • RENAME COLUMN
  • RENAME DATABASE
  • RENAME INDEX
  • RENAME SECURITY
  • RENAME SEQUENCE
  • RENAME TABLE
  • RENAME TRUSTED CONTEXT
  • RENAME USER
  • REVOKE
  • REVOKE FRAGMENT
  • TRUNCATE
  • UPDATE STATISTICS
  • SAVE EXTERNAL DIRECTIVES
  • SET CONSTRAINTS
  • SET Database Object Mode
  • SET INDEXES
  • SET TRIGGERS
  • START VIOLATIONS TABLE
  • STOP VIOLATIONS