1.06k likes | 1.08k Views
Explore the features and benefits of the File Manager tool for efficient data manipulation and management in enterprise systems. Easily browse, edit, extract, copy, and compare various data structures like VSAM, DB2, IMS, and more. With customizable selection criteria and flexible operation modes, handle your data the way you want with File Manager. Ideal for enhancing operational efficiency and streamlining data processes.
E N D
System z Problem Determination ToolsOverviewMadrid,February 26, 2007 Eric Chabert PD Tools SW IOT Eric_chabert@fr.ibm.com
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
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
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
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
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
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
File Manager MVS zSeries Problem Determination Tools
File Manager MVS: Primary Option Menu zSeries Problem Determination Tools
Edit For the members list For native data manipulation zSeries Problem Determination Tools
Edit: Native Data Manipulation Two record types zSeries Problem Determination Tools
Edit: Copybook Selection To use a Copybook and to Edit it zSeries Problem Determination Tools
Edit: From Copybook to Template Record Identification Record Selection Field Customization zSeries Problem Determination Tools
Edit: Using a Template (Format: Table) From record type 1 to record type 2 zSeries Problem Determination Tools
Edit: Using a Template (Format: Single) zSeries Problem Determination Tools
Utilities Compare with Copybook zSeries Problem Determination Tools
HFS & zFS zSeries Problem Determination Tools
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
File Manager DB2 zSeries Problem Determination Tools
File Manager DB2: Primary Option Menu zSeries Problem Determination Tools
Edit: Using a Template(Format: Single) zSeries Problem Determination Tools
e Referential Integrity zSeries Problem Determination Tools
Utilities zSeries Problem Determination Tools
«Basic» SQL zSeries Problem Determination Tools
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
File Manager IMS zSeries Problem Determination Tools
File Manager IMS: Primary Option Menu zSeries Problem Determination Tools
Browse: Using a View zSeries Problem Determination Tools
Browse: Database and View Specifications zSeries Problem Determination Tools
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
Utilities zSeries Problem Determination Tools
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
File Manager CICS zSeries Problem Determination Tools
File Manager CICS: Primary Option Menu CICS Transaction code For File Manager MVS File Manager IMS zSeries Problem Determination Tools
Enter Browse: TD Queue (Remote access) Remote System Identification zSeries Problem Determination Tools
EDIT: TS Queue (Native Data Manipulation) For TSQ List To Edit the TSQ zSeries Problem Determination Tools
Enter FM CICS to FM MVS to Copy a TSQ Short-cut to COPY zSeries Problem Determination Tools
Enter Enter FM CICS to FM MVS to Copy a TSQ zSeries Problem Determination Tools
Enter Back to FM CICS zSeries Problem Determination Tools
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
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
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
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
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
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
Fault Analyzer: Primary Menu (ISPF & CICS) zSeries Problem Determination Tools
Fault Analyzer: Customization zSeries Problem Determination Tools
Fault Analyzer: Columns Configuration zSeries Problem Determination Tools
Fault Analyzer: Filtering Columns configuration zSeries Problem Determination Tools
Interactive Reanalysis Filtering Column zSeries Problem Determination Tools