Operating OnLine 3-35
Change the Logging Status of a Database
Add logging to a database by executing one of these two commands:
tbtape -s -B database (buffered logging)
tbtape -s -U database (unbuffered logging)
You can change logging status for any number of databases with the same
command. For further information about thetbtape utility, refer to
page 7-102.
Ifyou can create an online archive and you do so from DB-Monitor, users are
able to access all databases during the archive. After the archive completes,
change the database status before you exitDB-Monitor. If you exit, the flag
indicating that you created the necessary archive is reset.DB-Monitor will
require you to redo the archive when you reenter.
To add logging to a database
1. Create an online, level-0 archive fromDB-Monitor. (Refer to
page 3-57.)
2. Select the Logical-Logs menu, Databases option.
3. Usethe Arrow keys to select the database to which you want to add
logging. PressCTRL-B or F3.
4. When the logging options screen appears,DB-Monitor displays the
current log status of the database. Use the arrow keys to select the
kind of logging you want. PressCTRL-B or F3.
Ending or Modifying Logging from DB-Monitor1. To end logging for a database from withinDB-Monitor, select the
Logical-Logs menu, Databases option.
2. Use the arrow keys to select the database to which you want to add
logging. PressCTRL-B or F3.
When the logging options screen appears,DB-Monitor displays the current
log status of the database. Use the arrow keys to select the kind of logging
you want, including no logging. PressCTRL-B or F3.
Toend logging for a database from the command line, execute the following
command:
tbtape -N database (no logging)