When Bad Things Happen to Good Transactions - Analyzing Transaction Problems on System z
Project and Program:
Information Management,
Information Management Systems
Tags:
Proceedings ,
SHARE in Orlando 2015 ,
2015
Many customers execute over 500 million transactions a day and the instrumentation data created can overwhelm traditional tools. The session explains an IBM tool that allows transaction analysis and processing of instrumentation ‘Big Data’. Also covered is batch reporting which combines CICS/DB2 and IMS/DB2 data to provide a consolidated picture of any transaction delays inside CICS and or IMS. This tool’s ‘Exception processing’ feature crawls the instrumentation data looking for transactions that exceed exception criteria. Once identified, the tool enables analysis of the transaction life cycle using IMS, CICS, DB2, Websphere MQ, SMF, and OPERLOG data. Automated data gathering reduces time to problem resolution, and training of the next generation of support personnel are benefits. Expanded DB2 analysis discovers SQL performing data scans, cascade deletes involving multiple tables, stored procedures, UDF’s, and triggers. Also see how application developments teams can use this z/OS tooling to maximize application rollout success their environments. Additional ‘Big Data’ support is provided to convert IT data into CSV and/or JSON for transport to targets such as Big Insights, Mobile Workload Pricing and other Big Data analysis platforms.
Benefits: System programmers, Database administrators and application developers can find out new ways to address transactional behavior.-James Martin-Fundi Software; Jim Martin-Fundi Software
Back to Proceedings File Library