How can know the transaction per second

What command should should I use get the load on DB2?
SNAPSHOT?
EVENTMONITOR?

Nov 12 '05 #1

7416

Exactly what load do you want to know? If you want to know
transaction/second, then I would use the event monitor since through that
you will know for sure. With the snapshot, you can have for example 400
transactions in 10 seconds but you take a snapshot every minute. Thus the
calculation would come down to:
transactions/second
400/60 = 6.66 transactions/second through the snapshot information. But
since out of the 60 seconds, you only had 10 seconds of work and 50 seconds
idle, your true throughput would be:
400/10 = 40 transactions/second.

Hope this helps.
<ri*********@ca nada.com> wrote in message
news:7c******** *************** ***@posting.goo gle.com...

What command should should I use get the load on DB2?
SNAPSHOT?
EVENTMONITOR?

Nov 12 '05 #2

Sean McKeough

Erik is correct, however snapshot monitor is much cheaper than running a
transaction evmon. The info you're looking for is from the database
snapshot, and is basic data (means it's collected as part of basic
processing). If you have an environment where you're just looking at rax
tx numbers over time, consider using the database snapshot.

Erik Hendrix wrote:

Exactly what load do you want to know? If you want to know
transaction/second, then I would use the event monitor since through that
you will know for sure. With the snapshot, you can have for example 400
transactions in 10 seconds but you take a snapshot every minute. Thus the
calculation would come down to:
transactions/second
400/60 = 6.66 transactions/second through the snapshot information. But
since out of the 60 seconds, you only had 10 seconds of work and 50 seconds
idle, your true throughput would be:
400/10 = 40 transactions/second.

Hope this helps.
<ri*********@ca nada.com> wrote in message
news:7c******** *************** ***@posting.goo gle.com...
What command should should I use get the load on DB2?
SNAPSHOT?
EVENTMONITO R?

Nov 12 '05 #3

Similar topics

535

START TRANSACTION

by: Frank Natoli | last post by:

Does START TRANSACTION and COMMIT apply only to the Connection for which the START TRANSACTION statement was performed? So if a second Connection is created, and used to access different tables in the same database, are the tables affected by the second connection visible to other processes as the changes are made, not masked by the START TRANSACTION on the first Connection? Thanks.

MySQL Database

3613

manage transaction to avoid locks

by: extmb | last post by:

Hi, I am quite puzzled how SQLServer manages transactions. Whatever the isolation level I set when performing an insertion, other connections do not have access to the table in select mode. Example in SQL Analyzer: create table foo ( id numeric(10), data varchar(100) )

Microsoft SQL Server

2603

PG_RESTORE/DUMP Question

by: Alex | last post by:

Hi, I have a test system that is setup the same as a production system and would like to frequently copy the database over. pg_dump takes a few hours and even sometimes hangs. Are there any reasons not to simply just copy the entire data directory over to the test system? I could not find any postings on the net suggesting otherwise. Is there anything to pay attention too ?

PostgreSQL Database

1733

PostgreSQL back-end. Ref. integrity violation in transaction.

by: Steve Jorgensen | last post by:

Hi all, I've migrated an Access database schema to PostgreSQL, and I'm trying to get everything working again. I'm having the following problem... Within an Access transaction, I insert a row into one table, then I insert a row into a table with a foreign key relationship to the first record. The second insert fails with a referential integrity violation referring to the same relationhip I mentioned. This worked fine with a JET...

Microsoft Access / VBA

3898

Detect if Distributed Transaction is used or just SQL 2005 internal transaction?

by: John Lee | last post by:

Hi, I have few questions related to .NET 2.0 TransactionScope class behavior: 1. Check Transaction.Current.TransactionInformation.DistributedIdentifier to identify if distributed transaction is used - is it accurate way? 2. I have the following code blocks - In code block 1, the first check the DistributedIdentifier is ALL 0s so it

C# / C Sharp

1935

Determining the Better Approach of Transaction in n-tier Application Model and where Transactions are maintained

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...

ASP.NET

10958

Transaction with stored procedure

by: ucasesoftware | last post by:

i need to use this : Private Shared Sub Demo1() Dim db As SqlConnection = New SqlConnection("connstringhere") Dim transaction As SqlTransaction db.Open transaction = db.BeginTransaction Try call (New SqlCommand("INSERT INTO TransactionDemo " + "(Text) VALUES ('Row1');", db, transaction)).ExecuteNonQuery

Visual Basic .NET

2226

Code works without transaction but not with transaction?

by: Crash | last post by:

C# VS 2003 ..Net Framework V1.1 SP1 SQL Server 2000 SP3 Enterprise Library June 2005 I'm working with some code {not of my creation} that performs the following sequence of actions: - Open SqlConnection using SQL authentication with UID & PWD in connect

C# / C Sharp

7219

Question about Transaction isolation level="readCommitted"

by: D. | last post by:

I have a question about the "readCommitted" transaction isolation level. I have a client that is updating a record on a table. I suspend the execution after the UPDATE but before the commit statement. Than another client is trying to read the same record. As transaction isolation is set to "readCommited" I expected that the second client will read the old version of the record (before the update). Instead, the second client hangs and...

Microsoft SQL Server

9594

Changing the language in Windows 10

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,...

Windows Server

10600

Problem With Comparison Operator <=> in G++

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...

C / C++

9174

AI Job Threat for Devs

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...

Career Advice

6866

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5534

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5673

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4311

transfer the data from one system to another through ip address

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

C# / C Sharp

3834

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3002

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General