The USEREXIT program should be compiled and placed in the sqllib/adm as db2uext2 executable file - that is what UDB will use by default.
Ellen Klebaner-Reys Data Management Services Inovant - a Visa Solutions Company [EMAIL PROTECTED]/650-432-1746 m/s: 3125-1D -----Original Message----- From: Carla Cristina Alonzo Ducl�s [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 3:53 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [DB2EUG] db2 archive log Hello, > ARCHIVE LOG doesn't by itself put the logfiles anywhere. They will stay > in whatever directory is specified in the DB config. The only thing it > does is to close the active log. Or logs, if you issue it on all nodes > of a EEE system. Ahn, ok. > It only works if you have your database in archive log mode. Yes, I have. I have logretain flag set to RECOVERY: Log retain for recovery enabled (LOGRETAIN) = RECOVERY > Applications can be connected while you execute it, as long as you're > not connected with the session you execute it from. It will flush any > log buffers to disk before the log is actually closed. Ok, thanks. I understand now. > To actually move logs out of the default log directory for more > meaningful archiving, use a userexit. If you have the DB userexit > parameter set to yes, every time a log is closed (either because it's > full, or because an online backup finished, or because you issue archive > log) a userexit program will be called. This can then be used to move > the log files over to another location, which can be disk, maybe tape, > or TSM. It's very useful and you may want to take a close look. Well, I have userexit set to ON: User exit for logging enabled (USEREXIT) = ON But, How can I know what userexit program the database is using? I think that it is using the disk userexit program (db2uext2.cdisk), but how can I check this? > Hope this helps, It helps a lot! :) Thank you very much, 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
