David
There is no facility in DB2 V 6 to truncate the log file at the end of an
online backup. However with V 7.2 FP 3 and above, each online backup will
automatically truncate the active log file for you.
Please note that V6 is no longer in service, check out
http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/newsletter.d2w/n20020101
V6.1
DB2 Universal Database and DB2 Connect
All except Satellite
December 31,
2001
V6.1
DB2 Universal Database
Satellite
December 31,
2002
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager, DB2 UDB Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
david_a_green@sta
ndardlife.com
Sent by: To
owner-db2eug@Lugw [EMAIL PROTECTED]
ash.org cc
Subject
01/08/2003 07:08 [DB2EUG] UDB V6.1 Logs
AM
Please respond to
david_a_green@sta
ndardlife.com
Dear List
Novice to this so here goes ...
Background Info:
Original systems implemented in UDB, with packaged software not compatible
with V7 and beyond.
Newer systems implemented in UDB, with packaged software compatible with
V7.
I have created a "generic" backup mechanism which executes on each of seven
production nodes backing up approximately 20 databases,
which have a very wide range of log consumption, from one log switch per
week, to hundreds of log switches per day.
Platform Info:
AIX 4.3.3 DB2 code release "SQL06010" with level identifier "01030104" and
informational tokens "DB2 v6.1.0.6", "s991030" and "U468276"
My Question:
How can I "force" a log switch on each of UDB V6 and UDB v7 to ensure that
the log which is current when the online backup is taken is also backed up?
I know I can issue a db2 ARCHIVE LOG command in UDB v7, but have any of you
managed the same trick in UDB v6?
Cheers, in anticipation ..
David Green
For more information on Standard Life, visit our website
http://www.standardlife.com/
The Standard Life Assurance Company, Standard Life House, 30 Lothian Road,
Edinburgh EH1 2DH, is registered in Scotland (No. SZ4) and regulated by the
Financial Services Authority. Tel: 0131 225 2552 - calls may be recorded or
monitored. This confidential e-mail is for the addressee only. If received
in error, do not retain/copy/disclose it without our consent and please
return it to us. We virus scan and monitor all e-mails but are not
responsible for any damage caused by a virus or alteration by a third party
after it is sent.
-
::: 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
