Carla, That command calls the userexit in the same way that the userexit is called if the transaction log becomes full naturally. The command is deprecated now, however. Since DB2 v7.2 fixpack 3, an online backup automatically archives the active log when a DB2 online backup command completes. This command can only be used when you've set archive logging on i.e. db2 update db cfg for <db> using logretain true userexit on"
The userexit defines the archive destination for the transaction logs. There's a #define ARCHIVE_PATH which needs updating. The userexit is a compiled C program and has to be called db2uext2 and has to exist in the sqllib\bin directory. Sample db2uext2.c source files are available in the sqllib\samples\c directory when you install the application development client. There's full instructions on what to change and how to compile the C source file. There are example files for ADSM(TSM) which is IBM's tape storage system and also for transferring the transaction logs to disk. I guess, if you want to archive logs to another storage system, you have to write your own code. When I used it, I remember having an issue with transaction log files not being deleted from the active log path when TSM played up. They did eventually disappear, however, but it was all a bit confusing and IBM support weren't much help. James -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Carla Cristina Alonzo Ducl�s Sent: 23 July 2003 22:06 To: [EMAIL PROTECTED] Subject: [DB2EUG] db2 archive log Hello, I�m planning a backup strategy e I�d like to know more about archive db2 logs. I�ve read some documents and I didn�t understand where db2 put archived logs after the command: # db2 archive log for database <database name> So, I have some doubts. I�ll be so gratefull with any help. :) How do I have to proceed after this command has been executed? Can I execute this command with online database? Do I have finish all connection to the database before execute this command? I have db2 7.2.7 and AIX 4.3.3. Thanks a lot, Carla -- Carla Alonzo Ducl�s Systems Administrator Solvo S.A. - Servi�os de Miss�o Cr�tica @ www.solvo.com.br - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
