Hi All,
Out of nowhere my udb system (v8) performance has went terrible. Its gotten
about 10x worse, (some tests that used to take 2 seconds to run now take
20)... I'm not sure what happened. I did reorg/runstat/rebind on
everything, no luck... I'm not sure what to do next...? Any recommendations
on something to try to start narrowing down the possible problem.
Things I've tried:
db2stop/start
reorg/stats/rebind
The slowness seems to be system wide and not related to a specific table or
stored procedure.
Thanks,
6  2169 
What os platform? What version/release/patch level? What fixpack level of db2?
What changes have been made to db2 and to the os or the hw since you noticed the
problem? Are any other applications on the same server having performance
problems? What does VMSTAT show?
Larry
AC Slater wrote: Hi All,
Out of nowhere my udb system (v8) performance has went terrible. Its gotten
about 10x worse, (some tests that used to take 2 seconds to run now take
20)... I'm not sure what happened. I did reorg/runstat/rebind on
everything, no luck... I'm not sure what to do next...? Any recommendations
on something to try to start narrowing down the possible problem.
Things I've tried:
db2stop/start
reorg/stats/rebind
The slowness seems to be system wide and not related to a specific table or
stored procedure.
Thanks,
SunOS 5.8. UDB V8.1 Fixpack 3.
No other noticable slow applications.
Changes were being made to optimization levels right before performance
issue occured. I *think* all those changes were rolled back, but I could be
wrong.
VMstat:
$ vmstat
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s1 s6 -- in sy cs us sy
id
0 0 0 713392 24272 41 172 866 218 603 0 1437 54 18 0 0 642 318 198 3 3
94
One other note:
One of my test programs uses CLI to : connect, run stored proc 20 times,
disconnect. This used to take 2 seconds now takes 20 or so... almost all of
the 20 seconds is split between the connect and the first stored proc
execution...int ersting; not sure what to make of that.
Thanks,
Frank
arry" <no****@nospam. com> wrote in message
news:3F******** *******@nospam. com... What os platform? What version/release/patch level? What fixpack level of
db2? What changes have been made to db2 and to the os or the hw since you
noticed the problem? Are any other applications on the same server having performance
problems? What does VMSTAT show?
Larry
AC Slater wrote:
Hi All,
Out of nowhere my udb system (v8) performance has went terrible. Its
gotten about 10x worse, (some tests that used to take 2 seconds to run now take
20)... I'm not sure what happened. I did reorg/runstat/rebind on
everything, no luck... I'm not sure what to do next...? Any
recommendations on something to try to start narrowing down the possible problem.
Things I've tried:
db2stop/start
reorg/stats/rebind
The slowness seems to be system wide and not related to a specific table
or stored procedure.
Thanks,
I am not a performance expert ... nor an expert at interpreting VMSTATs, but
this looks to me like the machine is spending a lot of time in idle. I believe
there is also some paging going on ... but whether it is excessive or not I'm
not sure.
Perhaps someone else can make some more helpful observations.
Larry Edelstein
AC Slater wrote: SunOS 5.8. UDB V8.1 Fixpack 3.
No other noticable slow applications.
Changes were being made to optimization levels right before performance
issue occured. I *think* all those changes were rolled back, but I could be
wrong.
VMstat:
$ vmstat
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s1 s6 -- in sy cs us sy
id
0 0 0 713392 24272 41 172 866 218 603 0 1437 54 18 0 0 642 318 198 3 3
94
One other note:
One of my test programs uses CLI to : connect, run stored proc 20 times,
disconnect. This used to take 2 seconds now takes 20 or so... almost all of
the 20 seconds is split between the connect and the first stored proc
execution...int ersting; not sure what to make of that.
Thanks,
Frank
arry" <no****@nospam. com> wrote in message
news:3F******** *******@nospam. com... What os platform? What version/release/patch level? What fixpack level of
db2? What changes have been made to db2 and to the os or the hw since you
noticed the problem? Are any other applications on the same server having performance
problems? What does VMSTAT show?
Larry
AC Slater wrote:
Hi All,
Out of nowhere my udb system (v8) performance has went terrible. Its gotten about 10x worse, (some tests that used to take 2 seconds to run now take
20)... I'm not sure what happened. I did reorg/runstat/rebind on
everything, no luck... I'm not sure what to do next...? Any recommendations on something to try to start narrowing down the possible problem.
Things I've tried:
db2stop/start
reorg/stats/rebind
The slowness seems to be system wide and not related to a specific table or stored procedure.
Thanks,
Whats the easiest way to tell that bufferpools are working properly for a
tablespace?
For some reason I have a feeling that might be it...
"Larry" <no****@nospam. com> wrote in message
news:3F******** *******@nospam. com... I am not a performance expert ... nor an expert at interpreting VMSTATs,
but this looks to me like the machine is spending a lot of time in idle. I
believe there is also some paging going on ... but whether it is excessive or not
I'm not sure.
Perhaps someone else can make some more helpful observations.
Larry Edelstein
AC Slater wrote:
SunOS 5.8. UDB V8.1 Fixpack 3.
No other noticable slow applications.
Changes were being made to optimization levels right before performance
issue occured. I *think* all those changes were rolled back, but I
could be wrong.
VMstat:
$ vmstat
procs memory page disk faults
cpu r b w swap free re mf pi po fr de sr s0 s1 s6 -- in sy cs us
sy id
0 0 0 713392 24272 41 172 866 218 603 0 1437 54 18 0 0 642 318 198 3
3 94
One other note:
One of my test programs uses CLI to : connect, run stored proc 20 times,
disconnect. This used to take 2 seconds now takes 20 or so... almost
all of the 20 seconds is split between the connect and the first stored proc
execution...int ersting; not sure what to make of that.
Thanks,
Frank
arry" <no****@nospam. com> wrote in message
news:3F******** *******@nospam. com... What os platform? What version/release/patch level? What fixpack level
of db2? What changes have been made to db2 and to the os or the hw since you
noticed the problem? Are any other applications on the same server having
performance problems? What does VMSTAT show?
Larry
AC Slater wrote:
> Hi All,
>
> Out of nowhere my udb system (v8) performance has went terrible.
Its gotten > about 10x worse, (some tests that used to take 2 seconds to run now
take > 20)... I'm not sure what happened. I did reorg/runstat/rebind on
> everything, no luck... I'm not sure what to do next...? Any
recommendations > on something to try to start narrowing down the possible problem.
>
> Things I've tried:
>
> db2stop/start
> reorg/stats/rebind
>
> The slowness seems to be system wide and not related to a specific
table or > stored procedure.
>
> Thanks,
You can search on "Buffer pool activity" at this site to see the monitor
elements that can help you: http://publib.boulder.ibm.com/infoce...help/index.jsp
A little late now, but you mentioned changing "optimizati ons" and trying
to ensure they were changed back to original values. If your system
turns out to be sensitive to such changes, there are things you can do
before making a change to ensure you can track down what went wrong if
the changes does degrade performance:
1. backup the database before making a change - this will save the
database configuration parameters.
2. there are some primitive scripts here to save database and database
manager configuration parameters in tables (tested with v7, not v8) with
a timestamp of when they were last changed: http://www-106.ibm.com/developerwork...4adamache.html
3. Save the settings of all registry varviable (db2set>out)
4. If you want to be really ambitious, you can export the contents of
the catalog tables in IXF before anything major gets changed.
AC Slater wrote: Whats the easiest way to tell that bufferpools are working properly for a
tablespace?
For some reason I have a feeling that might be it...
"Larry" <no****@nospam. com> wrote in message
news:3F******** *******@nospam. com...
I am not a performance expert ... nor an expert at interpreting VMSTATs,
but
this looks to me like the machine is spending a lot of time in idle. I
believe
there is also some paging going on ... but whether it is excessive or not
I'm
not sure.
Perhaps someone else can make some more helpful observations.
Larry Edelstein
AC Slater wrote:
SunOS 5.8. UDB V8.1 Fixpack 3.
No other noticable slow applications.
Changes were being made to optimization levels right before performance
issue occured. I *think* all those changes were rolled back, but I
could be
wrong.
VMstat:
$ vmstat
procs memory page disk faults
cpu
r b w swap free re mf pi po fr de sr s0 s1 s6 -- in sy cs us
sy
id
0 0 0 713392 24272 41 172 866 218 603 0 1437 54 18 0 0 642 318 198 3
3
94
One other note:
One of my test programs uses CLI to : connect, run stored proc 20 times,
disconnect . This used to take 2 seconds now takes 20 or so... almost
all of
the 20 seconds is split between the connect and the first stored proc
execution... intersting; not sure what to make of that.
Thanks,
Frank
arry" <no****@nospam. com> wrote in message
news:3F***** **********@nosp am.com...
What os platform? What version/release/patch level? What fixpack level
of
db2?
What changes have been made to db2 and to the os or the hw since you
noticed the
problem? Are any other applications on the same server having
performance
problems? What does VMSTAT show?
Larry
AC Slater wrote:
>Hi All,
>
>Out of nowhere my udb system (v8) performance has went terrible.
Its
gotten
>about 10x worse, (some tests that used to take 2 seconds to run now
take
20)... I'm not sure what happened. I did reorg/runstat/rebind on
>everything , no luck... I'm not sure what to do next...? Any
recommendati ons
>on something to try to start narrowing down the possible problem.
>
>Things I've tried:
>
>db2stop/start
>reorg/stats/rebind
>
>The slowness seems to be system wide and not related to a specific
table
or
>stored procedure.
>
>Thanks,
> One other note:
One of my test programs uses CLI to : connect, run stored proc 20 times,
disconnect. This used to take 2 seconds now takes 20 or so... almost all of
the 20 seconds is split between the connect and the first stored proc
execution...int ersting; not sure what to make of that.
Thanks,
Frank
Is your test program the only application connected to the database at
the time? If it is, it could be that the database is not "activated"
and that each connect forces all the resources to be allocated at
connect time (a slow process). Issue an "ACTIVATE DATABASE XXXX"
command to solve this.
Evan This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: puzzlecracker |
last post by:
Fixed font - Proportional font
string initilization WHY?
All 2 messages in topic - view as tree
puzzlecracker Jan 29, 10:47 pm show options
Newsgroups: comp.lang.c
From: "puzzlecracker" <ironsel2...@gmail.com> - Find messages by this
author
|
by: Stephanie |
last post by:
I am trying to setup a Performance Condition Alert and on this one SQL
2000 Server the 'Type:' drop down does not give me the option to choose
"SQL Server performance condition alert". "SQL Server event alert" is
the only item listed in the drop down. Is there some setting on the
Server that I am missing that needs to be activated? I am connected
with the SA account; Windows 2000 sp4; SQL 2000 sp2; SQL Litespeed
(this is the only server...
|
by: Clay Luther |
last post by:
I am doing to large dataset performance tests with 7.3.4b2 today and I noticed an interesting phenomenon. My shared memory buffers are set at 128MB. Peak postmaster usage appears to be around 90MB.
My test app performs inserts across 4 related tables, each set of 4 inserts representing a single theoretical "device" object. I report how many "devices" I have inserted, per second, for example...
41509 devices inserted, 36/sec
41544...
|
by: Aaron |
last post by:
In a test environment we have dropped over 100 RI restrictions which showed
a huge instant performance gain where some jobs were running with 2 or 3
times the performance than previously.
The problem is that we have now dropped the same restrictions in the
production environment but have seen absolutely no performance difference
since the drop of RI.
Any idea's why we have not seen the expected performance improvement? We
have...
|
by: David W. Fenton |
last post by:
http://www.granite.ab.ca/access/performancefaq.htm
I hope Tony doesn't mind my opening a discussion of some issues on
his performance FAQ page here in the newsgroup. This is not meant as
criticism, at all, as I am not alleging error. I'm just asking about
a couple of things to open up the discussion to see what people have
to say about them.
1. BeginTrans/CommitTrans to improve performance: has anyone ever
done this? The KB article...
| | |
by: Bob Alston |
last post by:
Some more, rather specific Access performance questions. IN a split
front-end & back-end Access/Jet ONLY LAN situation, and with all query
criteria fields and join fields indexed:
1. Is is good form to have a single query with base table with criteria
joined to a related table - all in one query? Or should I do a
two-step, first query does selection of main table and then join with
other table?
2. I have a table with multiple...
|
by: Nathan Sokalski |
last post by:
I am using a DataSet as the DataSource of a DataList in my code. The SQL
used to get the data from the database begins with:
SELECT
members.organization,artists.artist,artists.email,artists.website,members.email
FROM members INNER JOIN artists ON members.memberid=artists.memberid WHERE
Notice that both tables involved in the SELECT statement have a field named
|
by: =?Utf-8?B?THluZGE=?= |
last post by:
Using VB dot net web application, a page uses the drop down list web control.
When running on my XP Pro from within Visual Studio or when running from
http://localhost, the dropdown list does not have any performance issues.
The tester states that they have to click on the drop down list multiple
times in order to see the drop down list. They are testing on XP Pro that
does not have Visual Studio installed.
When the web app is moved...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
