CLP Commands

ARCHIVE LOG

This utility closes and truncates the active log file for a recoverable database. If user exit is enabled, an archive request is issued.

Usage:

  • The user must be one of the following: sysadm, sysctrl, sysmaint, or dbadm.

  • No connection to the database is required.

  • Command parameters:

    DATABASE database-alias: Specifies the alias of the database whose active log is to be archived

    USER username: Identifies the user name under which a connection will be attempted

    USING password: Specifies the password to authenticate the user name

    ON ALL DBPARTITIONNUMS: Specifies that the command should be issued on all database partitions in the db2nodes.cfg file. This is the default if a database partition number clause is not specified

    EXCEPT ...

Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial