There are tow parameters
LOGRETAIN and USEREXIT
Inorder to turn from circular to acrhiving one has to make them to ON or
RECOVERY
So to return back to CIRCULAR (default) from ARCHIVAL make them off
Archival just consumes large amount of space and at times make yor DB
performance very slow
But if you want complete recovery then you have to opt for ARCHIVAL
Logging
And reg performance bottleneks
you can refer some site you will get plenty
Bye
Nadeem
-----Original Message-----
From: Woodard Tim
[mailto:db2udbdba-ezmlmshield-x48018516.[Email address protected]
Sent: Tuesday, May 22, 2007 11:51 AM
To: LazyDBA Discussion
Subject: DB2 Help
1.) Can someone please explain to me the disadvantages to Archive
Logging instead of Circular Logging? I just went to a customer location
tonight and they said they had to turn on archive logging to perform
online backups. Is there anything special I have to do, to turn off
archive logging and set it back to Circular?
2.) What are the top 10 performance bottle necks with DB2?
I am installer for a software company, and we have to tweak DB2 all of
the time.
Most sites are running DB2 Workgroup server edition 8.1 or higher on
Windows.
Please send me any tips that you have, just trying to make the world a
faster place.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
DB2 & UDB email list listserv db2-l LazyDBA home page