About configuring the db2.conf for a snapshot policy
A snapshot backup requires that the db2.conf file be configured. The configuration is initially exactly the same as a stream-based backup because DB2 requires an initial stream-based backup before a snapshot backup can be taken. Be sure that the archive stanza is appropriate for the log archive method.
When you use the user-exit method for log archiving, configure the db2.conf in the following ways:
Configuration of the
db2.conffile for initial stream-based backup:DATABASE SAMPLE OBJECTTYPE DATABASE POLICY DB2_DB_Policy SCHEDULE Default-Application-Backup ENDOPER DATABASE SAMPLE OBJECTTYPE ARCHIVE POLICY DB2_Log_Policy SCHEDULE User ARCFUNC SAVE #ARCFUNC COPY #ARCDIR C:\MyLogs\arcdir\ #RETDIR C:\MyLogs\arcdir\ #ARCDIR /home/db2inst1/arcdir #RETDIR /home/db2inst1/arcdir ENDOPER
Configuration of the
db2.conffile for subsequent snapshot backups:After the initial backup, the
db2.conffile needs one modification to the database stanza before snapshot backups are performed. The specified schedule for the database stanza should be changed to the name of the automatic full backup schedule instead of the application backup schedule.
DATABASE SAMPLE OBJECTTYPE DATABASE POLICY DB2_DB_Policy SCHEDULE Full ENDOPER DATABASE SAMPLE OBJECTTYPE ARCHIVE POLICY DB2_Log_Policy SCHEDULE User ARCFUNC SAVE #ARCFUNC COPY #ARCDIR C:\MyLogs\arcdir\ #RETDIR C:\MyLogs\arcdir\ #ARCDIR /home/db2inst1/arcdir #RETDIR /home/db2inst1/arcdir ENDOPER