System z Problem Determination Tools Overview Madrid, February 26, 2007

1. System z Problem Determination ToolsOverviewMadrid,February 26, 2007 Eric Chabert PD Tools SW IOT Eric_chabert@fr.ibm.com

2. Overview of the Application Development Tools Overview of the Problem Determination Tools - File Manager - Fault Analyzer - Debug Tool Utilities & Advanced Functions - Application Performance Analyzer - Others Tools: Overview Summary Agenda zSeries Problem Determination Tools

3. Overview of the Application Development Tools Overview of the Problem Determination Tools - File Manager - Fault Analyzer - Debug Tool Utilities & Advanced Functions - Application Performance Analyzer - Other Tools: Overview Summary Agenda zSeries Problem Determination Tools

4. Common Processes and Software Configuration Management System z Application Lifecycle Model and simulate business processes WebSphere Business Modeler Model applications and data Rational Software Architect Understand, Identify and prepare existing assets for reuse WSAA / ATW / CICS IA Monitor and manage Business processes Tivoli WS Business Monitor N-Tier Visual construction WebSphere Developer for zSeries / HATS Model Business Model Applications Discover / Understand Monitor Business Develop Develop Problem Determination Tools Assemble Monitor Applications Debug / Deploy Manage Data Application performance, management and problem determination ITCAM Omegamon Application Performance Analyzer Assemble Test N-Tier Model based Application and process generation WebSphere Integration Developer Application Test, Debug, and Deploy Fault Analyzer Debug Tool Utilities and Advanced Functions Data Creation, update File Manager File Export Functional and Load Testing RPT/RFT Workload Simulator zSeries Problem Determination Tools

5. System z Application Development Tools Application Reuse / Data Migration Application / Performance Management Operational Efficiency CICS Business Event Publisher for MQ CICS VSAM Transparency Application Performance Analyzer CICS Performance Analyzer CICS OTTO IBM Session Manager CICS Batch Application Control Resource Recovery COBOL Modernization Software Configuration Management Debug Tool Utilities & AF Migration Utility IBM Rational COBOL Generation Extension for zSeries IBM Rational COBOL Runtime for zSeries CICS VSAM Recovery CICS VSAM Copy SCLM Advanced Edition Rational ClearCase Rational ClearQuest Test, Deploy, Manage Data Environment Testing Fault Analyzer File Manager Debug Tool Utilities & AF File Export WDDz ISPF Productivity Tool Application Time Facility CICS Workload Simulator Rational Performance Tester z/OS Rational Functional Tester Terminal Based Apps CICS Interdependency Analyzer CICS Configuration Analyzer CICS Performance Analyzer Core COBOL, Pl1, Assembler, C++, DB2, IMS, CICS, MQ, WASz Applications zSeries Problem Determination Tools

6. Overview of the Application Development Tools Overview of the Problem Determination Tools - File Manager MVS DB2 IMS CICS Summary - Fault Analyzer - Debug Tool Utilities & Advanced Functions - Application Performance Analyzer - Other Tools: Overview Summary Agenda zSeries Problem Determination Tools

7. File Manager Manage a variety of enterprise data file structures • File Manager Features: • Work with data in files (VSAM, HFS and zFS), DB2 tables (V9), IMS databases (V10), CICS (TDQ, TSQ and VSAM) • ISPF-like panels or Batch interface • Full function Browse and Edit • Multiple Modes of Edit and Browse • Table • Single • Flexible Selection Criteria • Copy • File Reformatting • Global Search and Updated capability • Print • Compare • No limit to file size ! Tape QSAM PDS TDQ TSQ HFS zFS VSAM DB2 IMS Object and Data Management Native Data Manipulation Application Mapped Data Manipulation Create, Edit, Browse, Extract,Copy, Print, Compare File Manager DB2 File Manager Base File Manager CICS File Manager IMS ISPF Do What you want, How you want, With your data zSeries Problem Determination Tools

8. File Manager MVS zSeries Problem Determination Tools

9. File Manager MVS: Primary Option Menu zSeries Problem Determination Tools

10. Edit For the members list For native data manipulation zSeries Problem Determination Tools

11. Edit: Native Data Manipulation Two record types zSeries Problem Determination Tools

12. Edit: Copybook Selection To use a Copybook and to Edit it zSeries Problem Determination Tools

13. Edit: From Copybook to Template Record Identification Record Selection Field Customization zSeries Problem Determination Tools

14. Edit: Using a Template (Format: Table) From record type 1 to record type 2 zSeries Problem Determination Tools

15. Edit: Using a Template (Format: Single) zSeries Problem Determination Tools

16. Utilities Compare with Copybook zSeries Problem Determination Tools

17. HFS & zFS zSeries Problem Determination Tools

18. ISPF-like panels Full function edit and browse Table Single Flexible selection criteria Work with copybooks or templates Modes Of Operation Interactive TSO ISPF CICS Batch Edit any file regardless of size Create data Print data Copy data File reformatting Catalog services Work with VTOC Search for and Change data Insert continuation JCL statement Compare data View or Print Copybooks or Templates XML generation Data Set Copy has an “Output mode” option XML. A data file and a template FM will generate tagged XML text for all input data types Option to generate Unicode. File Manager MVS Summary zSeries Problem Determination Tools

19. File Manager DB2 zSeries Problem Determination Tools

20. File Manager DB2: Primary Option Menu zSeries Problem Determination Tools

21. Edit: Using a Template(Format: Single) zSeries Problem Determination Tools

22. e Referential Integrity zSeries Problem Determination Tools

23. Utilities zSeries Problem Determination Tools

24. «Basic» SQL zSeries Problem Determination Tools

25. Edit and Browse data Edit a DB2 Table or View Select rows and columns displayed Print Table or Single format Select rows and columns Create and Drop DB2 objects Copy data Select rows “Map” columns from an input table to an output table Reformat and generate data while copying Work with a list of DB2 objects Use line commands to initiate functions Grant and Revoke DB2 privileges Import and Export data Select Rows Export to a file in default FM/DB2 format, a format defined by a copybook, or a comma-delimited file Import from a file generated by the Export function, or a file described by a copybook Generate JCL for DB2 utilities COPY, LOAD, REBUILD, RECOVER, REORG, and RUNSTATS Create and Execute SQL statements File Manager DB2 Summary zSeries Problem Determination Tools

26. File Manager IMS zSeries Problem Determination Tools

27. File Manager IMS: Primary Option Menu zSeries Problem Determination Tools

28. Browse: Using a View zSeries Problem Determination Tools

29. Browse: Database and View Specifications zSeries Problem Determination Tools

30. To display a graphical representation of the structure of the database To position on the begin retrieval of segments for the data display panels Primary Commands (examples) zSeries Problem Determination Tools

31. Utilities zSeries Problem Determination Tools

32. Online utilities for IMS databases Edit and Browse data Extract segments from a database Load segments into a database Support for processing databases using either: Physical DBD Logical DBD Access databases using either: Static PSBs Dynamic PSBs Process databases in alternate sequences using secondary indexes Support for HDAM, HIDAM, HISAM, HSAM, DEDB. MSDB Audit trail to record database updates COBOL or PL/I segment layouts to format data into fields Edit and Browse segments in tabular or character format Access source in PDS, PDSE, or Panvalet libraries Work with segments that have multiple layouts Use flexible criteria to select segments for browse, edit and extract processing Change segment selection criteria and formatting “on the fly”, while browsing or editing File Manager IMS Summary zSeries Problem Determination Tools

33. File Manager CICS zSeries Problem Determination Tools

34. File Manager CICS: Primary Option Menu CICS Transaction code For File Manager MVS File Manager IMS zSeries Problem Determination Tools

35. Enter Browse: TD Queue (Remote access) Remote System Identification zSeries Problem Determination Tools

36. EDIT: TS Queue (Native Data Manipulation) For TSQ List To Edit the TSQ zSeries Problem Determination Tools

37. Enter FM CICS to FM MVS to Copy a TSQ Short-cut to COPY zSeries Problem Determination Tools

38. Enter Enter FM CICS to FM MVS to Copy a TSQ zSeries Problem Determination Tools

39. Enter Back to FM CICS zSeries Problem Determination Tools

40. An File Manager CICS specific ISPF-like interface provides: Full screen edit / browse support Print support Copybook / template support List and alter support Support for local and remote CICS resources Users process resources while they remain online, taking advantage of CICS resource sharing Support for VSAM files (KSDS, ESDS, RRDS, VRRDS, and CICS data tables) Transient Data queues (intrapartition and extrapartition) Temporary Storage queues (auxiliary, main, and temporary storage pool) Invoke File Manager MVS through a CICS terminal Allows File Manager MVS to run without ISPF support Full support for non-CICS resources Process CICS resources (TD, TS and Files) through existing File Manager MVS utilities (local CICS resources only) Copy Compare Create etc. Invoke File Manager IMS through a CICS terminal Allows File Manager IMS to run without ISPF support Requires File Manager IMS to be installed Similar to running File Manager IMS through ISPF (does not use CICS services for IMS) File Manager CICS Summary zSeries Problem Determination Tools

41. Overview of the Application Development Tools Overview of the Problem Determination Tools -File Manager - Fault Analyzer ISPF CICS Web Summary - Debug Tool Utilities & Advanced Functions - Application Performance Analyzer - Other Tools: Overview Summary Agenda zSeries Problem Determination Tools

42. Application Language COBOL, PL/I, ASSEMBLER, C++, MQSeries IMS BATCH DB2 CICS WAS/z Failure/Abend Online Historical Repository Abend Diagnosis Analysis Reports Fault Analyzer ISPF Improve Fault AnalyzerHelps you rapidly pinpoint why and where an applicationabended and offers suggestions on how to resolve Single fault analysis product for all environments • Single Fault Analysis Product For All Environments • Analysis At Application Level • Information Gathered At Time Of Abend • Translates Low-level "Dump" Information Into Application-level Information • Expands Abend Code And Message Descriptions • No Recompile Of Applications • No JCL Changes • No Performance Overhead • ISPF Fault History Log Facility • Consistent Across Languages • COBOL, C, C++, PL/I, Assembler, LE • Environments Supported • CICS, TSO, JES/Batch, IMS, DB2, Unix System Services, MQSeries WAS/z and JAVA USS Provide data to to help determine WHY, WHERE, HOW, the failure occurred zSeries Problem Determination Tools

43. Improve Operation: Real-Time Analysis When an application ABENDs, an exit (supplied) invokes FA, which generates an analysis report. z/OS Application Fault History File Abend Options Fault Entry FA Invocation Exit Fault Analyzer Compiler Listings Real-Time Analysis Report Side Files (SYSDEBUG IDILANGX) zSeries Problem Determination Tools

44. Improve Operation: Interactive Re-analysis Navigate on-screen through a formatted, structured view of the problem. View working storage and control blocks as they were at the time of the fault. For any ABEND Fault History File ISPF / CICS Fault Analyzer Online Interface Options Fault Entry Compiler Listings Side Files (SYSDEBUG - IDILANGX) Optional Compiler Program Source zSeries Problem Determination Tools

45. ISPF Improve Operation: Batch Re-analysis Analysis report based on the information gathered in real-time, with potentially different options, and with a compiler listing or side file. Fault History File Fault Entry Fault Analyzer Batch Reanalysis Job Analysis Report (SYSOUT) Compiler Listings Side Files (SYSDEBUG - IDILANGX) Optional Compiler Program Source zSeries Problem Determination Tools

46. Fault Analyzer: Primary Menu (ISPF & CICS) zSeries Problem Determination Tools

47. Fault Analyzer: Customization zSeries Problem Determination Tools

48. Fault Analyzer: Columns Configuration zSeries Problem Determination Tools

49. Fault Analyzer: Filtering Columns configuration zSeries Problem Determination Tools

50. Interactive Reanalysis Filtering Column zSeries Problem Determination Tools