Home | Previous Page | Next Page   Utility Reference > ondblog: Change Logging Mode >

Syntax

Read syntax diagramSkip visual syntax diagram>>-ondblog--+-buf---+--+-------------+-------------------------><
            '-unbuf-'  | .---------. |
                       | V         | |
                       +---db_list-+-+
                       '- -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.
-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.

You can use ondblog to change the database-logging mode but not to turn off database logging. Extended Parallel Server supports nonlogging tables but not nonlogging databases.

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