%META:TOPICINFO{author="ChrisBartram" date="1170388973" format="1.1" version="1.2"}%
%META:TOPICPARENT{name="Hp3000DatabaseLogging"}%
---+ How to setup Database Logging on the HP3000

1) You must setup a system logging process (see :GETLOG command) where you'll specify the log process "identifier", password, and the fileset (or tapeset) you'll have it writing to. You'll also specify whether you want full log files to "roll over" to new (sequentially numbered) files automatically (which you will if you're using DISC files.)

2) You'll need to start the log process (:LOG name,START). This is also a good time to add the appropriate commands to your system startup procedures to make sure the log process(es) get restarted when you restart the system (this must be done explicitly each time the system is restarted). It should also (preferably) be stopped gracefully before a system shutdown.

3) You'll need to associate the database with a logid (in DBUTIL >>SET base LOGID=logidname )

4) You'll need to enable the database for logging (again in DBUTIL >>ENABLE base FOR LOGGING)

5) Perhaps before (4), you'll want to ensure that you have modified your system backup procedures appropriately to make sure the appropriate log files get backed up. See the next FAQ item.


-- Main.ChrisBartram - 18 May 2006