DB2

DB2 is IBM's offering to the highend database market. The latest version of DB2 (Universal Database) is ideal for OLTP, Data Warehousing, Decision Support and everything in between. It's well priced, extremely scalable and runs on virtually every platform out there from handhelds to mainframes.

Db2top / db2mon (db2 v9 udb/aix)


I'm trying to understand some of the variables in regards to when a DML statement is run.
For example:
I'm running a delete statement on table based on a key that has index.
Can someone please explain the following:
What does Rows written indicate? The value is currently showing 130 million
What does Rows read indicate? The value is currently showing 15043
What does Rows selected indicate? The value is currently showing 8033
What does Rows deleted indicated? The value is currently showing 120 million
How is possible to delete over 120 million rows when only 80333 were selected? Also, how is possible to read only 15043 rows when 120 million have been deleted?
Can you post the SQL which you monitored here:
also the screen shot is needed....

Related Links

instance creation
com.ibm.db2.jcc.a.SqlException
Restoring a database
Convert Date to Varchar
how to copy dbm cfg parameters?
How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
Timestamp column and null indicators
Looking for DB2 UDB 7.1 Trial Version
Weird Problem while retrieving data via php
Migrate DB2 8.1 Tables to DB2 9.5 with partitioning
Federated Stored Procedure - parameters
Federation Server to Oracle 10g - Sequences
ADM1832E error got ????
whats SQL Error: -1131, SQLState: 38503 ???
help: A speech interface for information retrieval using .db2 file
Select

Categories

DataBase Dev
MongoDB
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
Crystal Reports
Delphi, C etc
JAVA
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
Brilliant Database
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
New Members & Introduc...
Applications & Tools
Database Concepts & De...
Chit Chat
Marketplace
Job Opportunities
Suggestions & Feedback

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App