January 2016 Blog Posts (1)
DB2 + transactional + Data + Performance Techniques
I have a table A with 30,000 Records.
Module B selects the data from the table A.
This module B is called via online(CICS) and Batch mode.
This Module is called 30 million times in day. 20% of traffic is via Online mode and 80% of traffic is via Batch Mode.
In a second this Table is referred 30 times and in a minute 4500 times.
Each time Module B is triggered it selects data from Table A.
Whenever I do a select to table A. IO is caused and by…
ContinueAdded by Satya on January 18, 2016 at 11:16am — No Comments
Featured Blog Posts
- DB2 11.1 release simplifies deployment and key management
- Service class time component
- What's new on the BLU Acceleration hub?
- Next DB2 Tech Talk Jan 23rd: Leveraging InfoSphere Optim Workload Replay for DB Environment Changes
- Dr Vladimir Bacvanski Hadoop Crash Course Add-on Tutorial at IBM IOD Conference
- Find out what is happening at Information on Demand confefence
- IBMDataMag.com Covers DB2 10 and InfoSphere Warehouse 10
Latest Blog Posts
- Installing DB2 Express C 9.7 on Ubuntu
- Basic concepts that are useful to design and implement a successful backup strategy in db2
- Basic concepts that are useful to design and implement a successful backup strategy in db2
- Step by Step installation of DB2 V10.5 on Linux
- Learn how to use R with Databases
- How Will Logging Process happen in DB2?
- What are the DB2 LUW DBA daily activities?
Most Popular Blog Posts
- A Fast Way to Get Started with DB2 Federation
- A Fast Way to Get Started with Q Replication for DB2 Active-Active Databases
- DB2 Express C vs MS SQL Express vs MySQL vs PostgreSQL benchmark
- Porting LIMIT and OFFSET SELECT clauses to DB2
- DataStage Architecture
- How to add IDENTITY column to existing table
- Guide on Installation of DB2 9.7.2 Steps
Monthly Archives
2020
- June (1)
2017
2016
2015
- December (1)
2014
2013
2012
- December (3)
- November (1)
- October (8)
- August (3)
- July (1)
- June (2)
- May (7)
- April (2)
- March (3)
- February (1)
- January (1)
2011
- December (8)
- November (6)
- October (11)
- September (2)
- August (9)
- July (4)
- June (6)
- May (7)
- April (8)
- March (3)
- February (1)
- January (4)
2010
- December (2)
- November (5)
- October (14)
- September (15)
- August (11)
- July (7)
- June (6)
- May (4)
- April (56)
- March (98)
- February (22)
- January (20)
2009
- December (39)
- November (49)
- October (14)
- September (7)
- August (9)
- July (7)
- June (7)
- May (6)
- April (18)
- March (4)
- February (7)
- January (5)
2008
2007
Featured Downloads
Try BLU Acceleration on Cloud
© 2020 Created by channeldb2.
Powered by
