When implementing archive logging, you are using a technique designed
to save your logs for recovery purposes (as Ken notes, online
backups, tablespace recovery, some other benefits that dont readily
come to mind) If you look for the disadvantages, it would be that you
will have to architect a log policy and have resources to save those
database logs. Online backups can impact performance somewhat,
although there is a throttling capability in db2.
As for tweaking DB2/top-10-performance-bottlenecks that is a bigger
subject than a quick email in Lazydba. You can generally get DB2
configured well once and it doesnt require a lot of hand holding.
Some things should be different if you have a warehouse vs a
transactional system. There are some settings that have been
identified to help specific applications. Look me up at my website if
you want to talk further, offline.

James Sobieski
www.fmtusa.com


At 07:51 AM 5/22/2007, Ken Daulong DC-98 wrote:
>This is a loaded question. It all depends on their backup and recovery
>strategy. Circular logging uses less disk space, but only allows for
>offline backups. Archive logging requires disk space for the archive
>logs, but allows for online backups and tablespace level recovery. It
>will also allow for point in time recovery. It would be good to read all
>the information in the IBM docs about logging. It is explained there
>fairly good. Also, you should not have to continually tune DB2. In 9
>years I have made minimal configuration parameter changes, but I do have
>to index tables properly for peak query performance.
>Good Luck
>Ken
>
>-----Original Message-----
>From: Woodard Tim
>[mailto:db2udbdba-ezmlmshield-x48018516.[Email address protected]
>Sent: Tuesday, May 22, 2007 1:21 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 is subject to PrimeSource's policies regarding
>the confidentiality and non-disclosure of the company's
>confidential and proprietary information. Any unauthorized
>disclosure of the contents of this message and/or any attachments
>hereto is strictly prohibited.
>
>
>
>---------------------------------------------------------------------
>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


DB2 & UDB email list listserv db2-l LazyDBA home page