ChannelDB2

Satya
  • Male
  • Netherlands
Share on Facebook Share on Facebook Share

Satya's Groups

 

Satya's Page

Gifts Received

Gift

Satya has not received any gifts yet

Give Satya a Gift

Profile Information

Full Name:
Satya Srungarapu
Job Title:
Programmer
Company:
Self
Platforms of Interest:
z/OS

Satya's Blog

DB2 + transactional + Data + Performance Techniques

Posted on January 18, 2016 at 11:16am 0 Comments

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

Comment Wall

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

  • No comments yet!
 
 
 

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service