473,594 Members | 2,749 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

db2 transactions per second

Hey there.
I want to keep track of the transactions per second on a db2 udb luw v
8.1.7. How do I realise this? This would be the case on our production
server and I really don't like the Statement monitor, because of the
performance hit. So, can it be done? And can this be done using the DB2
CLI? So I can use the output in shell scripts.

-R-
Nov 12 '05 #1
4 4959
Jurgen Haan wrote:
Hey there.
I want to keep track of the transactions per second on a db2 udb luw v
8.1.7. How do I realise this? This would be the case on our production
server and I really don't like the Statement monitor, because of the
performance hit. So, can it be done? And can this be done using the DB2
CLI? So I can use the output in shell scripts.

-R-

Perhaps
get snapshot for database on xxxxx

It will show rows inserted/deleted etc. commits
and a lot more. You would have to process the output though.
--
Anton Versteeg
IBM Netherlands
Nov 12 '05 #2
Anton Versteeg wrote:
Perhaps
get snapshot for database on xxxxx

It will show rows inserted/deleted etc. commits
and a lot more. You would have to process the output though.


I just took a look at the snapshot.
the number of commits, is it a total since activation or is there some
timespan? The processing isn't a problem.
store timestamp1+comm it count1
wait
store timestamp2+comm it count2

commit count2-commit count1 / timestamp2-timestamp1 = commits/<time unit>

thanks for the feedback, I will imeplement it.

-R-
Nov 12 '05 #3
Jurgen Haan wrote:
Anton Versteeg wrote:
Perhaps
get snapshot for database on xxxxx

It will show rows inserted/deleted etc. commits
and a lot more. You would have to process the output though.

I just took a look at the snapshot.
the number of commits, is it a total since activation or is there some
timespan? The processing isn't a problem.
store timestamp1+comm it count1
wait
store timestamp2+comm it count2

commit count2-commit count1 / timestamp2-timestamp1 = commits/<time unit>

thanks for the feedback, I will imeplement it.

-R-

AFAIK the snapshot counters are always relative to the start of the
monitor switch/db2start.
Another option might be "db2pd -transactions" db2pd is DB2's version of
Informix onstats.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #4
In article <3m************ *@individual.ne t>, Serge Rielau
(sr*****@ca.ibm .com) says...
Another option might be "db2pd -transactions" db2pd is DB2's version of
Informix onstats.


I tried it with DB2 PE FP9 but ran into an error. A error message was
displayed:

db2pd.exe - Unable to locate component
This application has failed to start because DB2DIAG.dll was not
found. Re-installing the application may fix this problem.

I installed FP9a to be sure it wasn't a local issue but the problem
still remains. I hope it will be fixed with FP10.

Kind regards, Gert
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
8992
by: Alban Hertroys | last post by:
Oh no! It's me and transactions again :) I'm not really sure whether this is a limitation of psycopg or postgresql. When I use multiple cursors in a transaction, the records inserted at the start of the transaction aren't visible to those later on in that transaction (using a different cursor). Attached is a simplified example (the except's are a bit blunt, I know) of what I'm trying to do. In reality, the different cursors are...
9
2047
by: TD | last post by:
I am trying to add transactions to my code. The original code worked fine until I followed an example to setup transactions, now the code does strange things, but no error messages. Could someone please review my before and after code and tell me the proper way to add transactions to my code? Thanks, TD
6
4232
by: Ted | last post by:
Hello all, Please could somebody with a little time on their hands help me with my net sockets program? The aim is to send multiple transactions via C# network stream and read them back. The source is designed to send a 50byte header and read the result (50bytes). For one run this is fine, however since i'll be using multiple transactions
11
12978
by: Mike P | last post by:
I've been using C# transactions for a while and had no problems with them. Using try catch blocks I can trap basically all possible errors and rollback all necessary data. Over the last few days I've been trying to convert some of this code to SQL Server stored procedures, but it seems to lack many of the benefits of C# transactions - a lot of the errors don't seem to be trapped by the SQL error trapping (e.g. if I do an update on a row...
2
1926
by: msnews.microsoft.com | last post by:
Hello, I have the scenario. I m building an application either in asp.net or window application. This application is base on n-tier application model. Let us take example of Northwind Database in SQL SERVER. i build an asp.net page. On that page i place the grid with one template column. In that column i put HTML Table with two rows. In First row there are one combobox and two textboxes. In the second row there is another DataGrid means...
6
1561
by: James Pharaoh | last post by:
Hi, I'm trying to work out how to make sure things are read from a table in a consistent order. The table represents a queue of items and also the history of those items. Even with "serializable" transaction isolation I can begin two transactions, insert a record in each, commit the second transaction first. This second record is now visible and can be read from the queue. But when I commit the first this one appears before the second...
0
1199
by: Jaco Smuts | last post by:
Hello there question: I'm looking for information / patterns / recipe's for implementing a multi threaded program (multiple producers / consumers) that will manage transactions and maintain sequence across the different threads. background: I'm busy writing an adapter taking messages from ibm websphere mq using pymqi and inserting these messages into a database (after some
0
1335
radcaesar
by: radcaesar | last post by:
Customer Table ID Name Address City Phone 1 Vijay Stores 6,Gandhi Road Pondy 0413-276564 2 Ram Stores 3, MG Road, Pondicherry 0413-29543756 3 Balu Papers 3, RG St, Neyveli +919366228639 4 Senthil Papers 3, JN Road Cuddalore 04142-287654 6 TEst PRT PRT 246246 7 xxxx ggg eryyty drggd
12
2029
by: Rami | last post by:
I have some requirement for an automated payment system. The system has four machines setup as follows: 1- Two machines have a clustered database. 2- Two machines have a .net business logic component that will handle payment transactions with certain external component (Payment Gateway) My query is regarding transaction handling inside the business logic component. Because this component is running on two machines and these two...
1
1590
by: BobRoyAce | last post by:
I have a situation where I have one procedure that executes a bunch of database code in a transaction. In this procedure, in the middle of the aforementioned transaction, I call another procedure that does a series of things in yet another transaction. For some reason, after I come back from the second procedure, where that transaction is committed, and I try to run a simple SELECT SUM(*)... query in the first one, it just times out. So, I...
0
7941
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7874
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8246
Oralloy
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...
0
8231
tracyyun
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...
0
6652
agi2029
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...
1
5738
isladogs
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...
0
5404
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3854
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...
1
2383
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.