45 YEARS
RS
SERVING THE GLOBAL
FORTUNE
UNE 500
Solutions That Solve
Mainframe Batch
Window Challenges
Solutions That Solve Mainframe Batch Window Challenges
ABOUT MAINFRAME BATCH PROCESSING
Batch processing is used for some of the most critical
business operations:
• Credit card settlement
• Business transaction consolidation
• Database maintenance—Bulk database updates, ETL
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
MAINFRAME BATCH PROCESSING ATTRIBUTES
• Process large volumes, or batches, of instructions or files sequentially
• A large volume of work requires repetitive actions or repetitive logic
• Often run within a given time frame, or batch window
• Often have repeated reads of static data
MAINFRAME BATCH PROCESSING CHALLENGES
• Demands for 24/7 OLTP constantly increasing
• More batch processing to complete
• Web, mobile transaction loads constantly increasing
• Batch windows shrinking
• Monthly costs, system resource usage constantly increasing
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
INSIDE-THE-BOX SOLUTIONS FOR BATCH
• Scheduling solutions
• Pay for more CPU/MSU to get the work done faster
• Offload some batch processing to other platforms
• Application re-architecture or optimization or Db2 optimization
• Pay capital expense to upgrade the system sooner/more often
• Run batch and OLTP concurrently
• Move data into memory—DIM caching, Db2, VSAM buffering
• Do nothing—just pay the SLA penalties
• Tuning—always necessary, but eventually effectiveness (cost-to-return
ratio, ROI) levels off
Solution to batch window challenges Complexity / Risk Cost / ROI
Scheduling solutions Medium / Medium Medium / Medium
More CPU / MSU Low / Low High / Low
Offload batch (some) to other platforms High / High High / Medium
Application re-architecture, optimization High / High High / Medium
Offload Medium / High Medium / Medium
Run batch and OLTP concurrently Medium / High Medium / Medium
Data in memory (DIM), Db2 buffer pools, VSAM buffering, etc. Medium / Medium Medium / Medium
Do nothing Low / High High* / Low
Tuning Low / Medium Medium / Medium**
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
OUTSIDE-THE-BOX SOLUTIONS FOR BATCH
• Application level: High-performance in-memory technology
• System level: IT business intelligence
Solution to batch window challenges Complexity / Risk Cost / ROI
Mainframe high-performance in-memory solution Medium / Low Medium / High
IT business intelligence Low / Low Low / High
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
APPLICATION LEVEL
Why high-performance in-memory technology?
• Accelerates access to data used most often
• Accelerates your batch applications
(even your legacy OTS packaged batch apps)
• Improves transaction throughput capacity
• Reduces mainframe resource usage at the batch application level
• Reduces MSU and CPU costs
• No changes to DASD or to application logic
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
MAINFRAME HIGH-PERFORMANCE IN-MEMORY TECHNOLOGY
• Lets your applications access reference data using a much shorter code path
• Complements DASD
• Top path: typical DASD code path (typ. 10,000 to 100,000 machine cycles)
• Bottom path: high-performance in-memory code path (typ. 400 machine cycles)
Calling Application
SSAS RDS DM BM VSAM
Med Mgr
DASD
BSDS Logs SQL Parse SQL Opt Rec Map Index Mgr DSM Buffer Pools LRW IRLM
tableBASE
IZTA Driver
How It Works
• Highly accessed reference data identified using IT
business intelligence analytics, Db2 stats, SMF 64
records, Strobe, etc.
• Reference data copied into high performance
in-memory tables
• Applications access it from memory
• Access all other data in the normal manner
Copied into memory Read at Memory Speed
85 – 95% of data access
Reference Data tableBASE
Remaining Data
Application
Read/Write at I/O Speed
5 – 15% of data access
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
The Benefits
• Time needed for batch apps to access RO data is reduced significantly
• Overall batch run time is also sharply reduced
• Overall resource usage is reduced
• Overall operational cost is reduced
Without tableBASE
With tableBASE
Application Processing Access Read/Write Data Access Read Only Data
The Results
• Reduced batch application CPU usage
• Reduced batch application run-time
• Reduced I/O
1000000
800
800000
600
Seconds
600000
400
400000
200 200000
0 0
CPU Elapsed Time I/O
Without tableBASE With tableBASE
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
SYSTEM LEVEL
Why IT business intelligence?
• Cost reduction/avoidance and transparency
• Valuable information for decision makers on all levels
• System information combined with organization, finance information
• Basic BI right away; higher value BI with little effort up front
• Control costs and impact of batch processing
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
IT BUSINESS INTELLIGENCE
Data collection:
• All platforms PLUS business information
Mapping:
• System Data to Business Area to Business System to
Owner to Environment (etc.)
Analytics / Presentation:
• Dashboards, Graphs, Tables, etc.—all delivered via the
cloud for easy access
ITBI ITBI ITBI ANALYSIS &
DATA COLLECTION PLATFORM PRESENTATION
ITBI Windows server Web portal
Midrange Table / Smartphone
Data
Collectors
Cube
z/OS SQL Data
SMF Warehouse
Cube
Business Mapping
Cube
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
Visibility and Transparency
• Example: Departments may be able to shift workloads
to lower-usage hours
• Reduce the R4HA for the month.
Cost per month Retail Banking Internal Finance Capital Markets
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
The Benefits
• Control the impact of your batch processing
• Cost reduction/avoidance and transparency into the entire IT
infrastructure—both mainframe AND midrange distributed systems
• DevOps: Hold all stake-holders accountable for their impact on
performance & capacity
• Outsourcing: Make sure you have the information to hold your batch
processing outsourcer accountable for their billing
The Results
General
• 10–15% savings in MSU usage, right out of the box
• More when implementing business dimensions
Batch
• Controls costs and impact of batch processing
Operational Costs
Now
With IT Business
Intelligence
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
Solutions That Solve Mainframe Batch Window Challenges
SUMMARY
Solving Mainframe batch window challenges
• Most “in-the-box” batch solutions are costly and risky.
• These “outside-the-box’ solutions are low-risk, budget-friendly:
• Mainframe high-performance in-memory technology
• IT business intelligence
• Attack this problem from 2 directions, the application and system levels.
• All low risk, reasonable cost and very effective.
• No changes to databases, infrastructure or application logic
50 Hines Road, Suite 240
Ottawa, ON, Canada © DataKinetics 2023
K2K 2M5
THE NEXT STEP
Please contact us for more information – we can send you a more detailed white paper, or alternatively, you can
speak to one of our Professional Services staff to discuss your specific challenges. Use the contact information
shown above to get started.
ABOUT US
As the global leader in Data Performance and Optimization Solutions, the world’s largest banks, credit card,
brokerage, insurance, healthcare, retail and telecommunication organizations rely on DataKinetics to dramatically
improve their data throughput and processing.
Our comprehensive, world-renowned suite of solutions enables Fortune 500 companies to:
• Process over a billion mission-critical transactions every day
• Accelerate application processing by up to 98%
• Seamlessly integrate data on mainframe and distributed systems
• Enable increased control and flexibility in sub-capacity pricing and R4H soft capping environments
+1.800.267.0730 | info@dkl.com
© DataKinetics 2023. All rights reserved. No part of this publication may be reproduced without the express written permission of DataKinetics.
DataKinetics and tableBASE are registered trademarks of DataKinetics. All other trademarks, registered trademarks, product names, and
company names and/or logos cited herein, if any, are the property of their respective holders.