Syntax

Home | Previous Page | Next Page Administrative Utilities > The ondblog Utility > ondblog: Change Logging Mode >

Syntax

>>-ondblog--+-buf----+--+-------------+------------------------><
            +-unbuf--+  | .---------. |
            +-nolog--+  | V         | |
            +-ansi---+  +---db_list-+-+
            '-cancel-'  '- -f--dbfile-'

Element	Purpose	Key Considerations
buf	Sets the logging mode so that transaction information is written to a buffer before it is written to a logical log	None.
unbuf	Sets the logging mode so that data is not written to a buffer before it is written to a logical log	None.
nolog	Sets the logging mode so that no database transactions are logged	None.
ansi	Changes database logging to be ANSI compliant	Additional Information: Once you create or convert a database to ANSI mode, you cannot change it back to any of the other logging modes.
cancel	Cancels the logging-mode change request before the next level-0 backup occurs	None.
-f dbfile	Changes the logging status of the databases that are listed (one per line) in the text file whose pathname is given by dbfile	Additional Information: This command is useful if the list of databases is long or used often.
db_list	Names a space-delimited list of databases whose logging status is to be changed	Additional Information: If you do not specify anything, all databases that the database server manages are modified.