I did runstat on tables. Bufferpool hit ratio 97%.
On Thu 13/03/08 2:12 PM , "vishnuvardan" sent:
Did you do a Runstats on the table? First time when it was loaded
with
data? If yes then check the Buffer pool hit ratio. Give the details
and
see the I/O operations being done to fetch the records.
Thanks and Regards,
Vishnu Vardan G.
Project Engineer , Wipro Technologies
Bengaluru,India.
>*:vishnuvardan.[Email address protected]
>*: 9740149105
>P Please don't print this e-mail unless you really need to. Save a
Tree.
"It was love at first sight. Then I took a second look!!!!!"
-----Original Message-----
From: manasa
[mailto:db2udbdba-ezmlmshield-x11604585.[Email address protected]
Sent: Thursday, March 13, 2008 1:55 PM
To: LazyDBA Discussion
Subject: Performance issue
Hi DBAs,
Because of my 4k tablespace was going to full, I created one new
tablespace in new filesystem and shifted few tables from the old
tablespace to new one. Now over all system is performing slow. No
error
in diaglog, no lock-wait state, reorg check also shows no reorg
requires. All indexes are as it was and also tables contain the same
records as previous.
Disclaimer: This communication is for the exclusive use of the
intended recipient(s) and shall not attach any liability on the
originator or ITC Infotech India Ltd./its Holding company/ its
Subsidiaries/ its Group Companies. If you are the addressee, the
contents of this e-mail are intended for your use only and it shall
not
be forwarded to any third party, without first obtaining written
authorization from the originator or ITC Infotech India Ltd./ its
Holding company/its Subsidiaries/ its Group Companies. It may
contain
information which is confidential and legally privileged and the
same
shall not be used or dealt with by any third party in any manner
whatsoever without the specific consent of ITC Infotech India Ltd./
its Holding company/ its Subsidiaries/ its Group Companies.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
post a
dba job: http://jobs.lazydba.com [1] To Subscribe :
http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html [2]
The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and destroy all copies of this message and any
attachments.
WARNING: Computer viruses can be transmitted via email. The
recipient should check this email and any attachments for the
presence of viruses. The company accepts no liability for any damage
caused by any virus transmitted by this email.
www.wipro.com [3]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com [4]
To Subscribe : http://www.LazyDBA.com [5]
To unsubscribe: http://www.lazydba.com/unsubscribe.html [6]
Links:
------
[1]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fjobs.lazydba.com
[2]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.lazydba.com%2Funsubscribe.html
[3] http://192.168.14.11/parse.php?redirect=http://www.wipro.com
[4]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fjobs.lazydba.com
[5]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.LazyDBA.com
[6]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.lazydba.com%2Funsubscribe.html
Disclaimer: This communication is for the exclusive use of the intended recipient(s) and shall not attach any liability on the originator or ITC Infotech India Ltd./its Holding company/ its Subsidiaries/ its Group Companies. If you are the addressee, the contents of this e-mail are intended for your use only and it shall not be forwarded to any third party, without first obtaining written authorization from the originator or ITC Infotech India Ltd./ its Holding company/its Subsidiaries/ its Group Companies. It may contain information which is confidential and legally privileged and the same shall not be used or dealt with by any third party in any manner whatsoever without the specific consent of ITC Infotech India Ltd./ its Holding company/ its Subsidiaries/ its Group Companies.
DB2 & UDB email list listserv db2-l LazyDBA home page