Hi
thanks a lot to all ..
Regards
Yogesh


Richard Reppert wrote:

>The article mentioned in DB2 Magazine is a nice outline of the tuning process. I would seek out a
>copy of the article. There is a LARGE white paper that IBM publishes which covers tuning in great
>detail. The file name is sg246012.pdf and can be downloaded from IBM (I think www.ibm.com\whitepapers?)
>but I am not sure. The name of the document is "DB2 UDB Performance Tuning". It will take a
>while to get though all 400 pages, but parts are really worth the effort.
>
>Richard
>
>
>On Fri, 25 Oct 2002 17:22:17 +0530, yogesh kansal wrote:
>
>
>
>>Hi All ..
>>Could any one of u send me a good document or a good url for
>>performence tuning of queries as well as Database for DB2 UDB 8 Linux
>>Version .
>>Thanks in Advance
>>Regards
>>Yogesh
>>
>>
>>DePratti, Roland A A133 wrote:
>>
>>
>>
>>>Henry,
>>>
>>>There's a lot to tuning any application that uses a dbms. From your message,
>>>I assume that you are talking about UDB on the distributed envirnments(NT,
>>>AIX or OS/2). The first step in tuning is identifying what is the current
>>>performance level. From there you can identify the hotspots and slow
>>>performers. A monitoring tool is invaluable for this, some companies that
>>>provide tools are Quest and DGI. IBM also provides, within UDB, monitoring
>>>tools. For starters, download a copy of the UDB System Monitor Guide and
>>>Reference from the IBM website. It contains special instructions for
>>>capturing SQL performance information.
>>>
>>>DB2 Magazine which is free to professionals in the industry has many
>>>articles on tuning. Plus the UDB Administration Guide provides valuable
>>>information.
>>>
>>>
>>>Roland DePratti
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: Henry O'Keeffe [SMTP:[Email Address Removed] Sent: Thursday, October 24, 2002 7:57 PM
>>> To: [Email Address Removed] Subject: Performance tuning udb/db2
>>>
>>> Hi,
>>>
>>> What's considered the best technique for tuning db2/udb ? Can anyone
>>>give me
>>> some pointers to a good book or website on tuning methodology (or
>>>better
>>> still just tell me what you normally do that gets results! )
>>>
>>> Regards,
>>> Henry.
>>>
>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>> To unsubscribe, e-mail: db2udbdba-[Email Address Removed] For additional commands, e-mail: db2udbdba-[Email Address Removed]
>>>
>>>------------------------------------------------------------------------------
>>>CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information.
>>>
>>>
>This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you
>for your compliance. Copyright (c) 2002 CIGNA
>
>
>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed]
>>>
>>>
>>>
>>--
>>Yogesh Kansal
>>Davlin Software Pvt Ltd .
>>2nd Floor , Punja Building,
>>Lalbaugh , Mangalore
>>Ph 0824-451001 ext - 19
>>
>>"The degree of normality in a database is inversely proportional to that of its DBA"
>>
>>
>>
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed]
>>
>
>
>
>
>

--
Yogesh Kansal
Davlin Software Pvt Ltd .
2nd Floor , Punja Building,
Lalbaugh , Mangalore
Ph 0824-451001 ext - 19

"The degree of normality in a database is inversely proportional to that of its DBA"





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