ChannelDB2

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…

Continue

Added by Satya on January 18, 2016 at 11:16am — No Comments

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service