1 / 77

The IT Information System

XINFO . The IT Information System. Product Presentation. H O RIZONT Software for Datacenters. Garmischer Str. 8 D- 80339 München Tel ++49(0)89 / 540 162 - 0 www.horizont-it.com. What is XINFO?.

whitney
Download Presentation

The IT Information System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. XINFO The IT Information System Product Presentation HORIZONT Software for Datacenters Garmischer Str. 8 D- 80339 München Tel ++49(0)89 / 540 162 - 0www.horizont-it.com

  2. What is XINFO? A complete cross referencing tool for reporting and to analyze data from a wide variety of systems of the datacenter: JCL, Script, CICS, DB2, IMS, SMF, … Assembler, C, Cobol, PL/I, Java, … Automic, CA7, Control-M TWS, Zeke, … XINFO

  3. XINFO Scanner XINFO Scanner collect data from: Programs: Assembler, C, Cobol, Easytrieve, Java, Natural, PL/I source Load modules and/or Unix/Windows installed software JCL, CICS, DB2, IMS, SMF, Space management and File systems, text data from PDS and Unix/Windows Scripts, SAP… Scheduling systems: Automic (UC4), CA-7, CA-Scheduler, Cron, Control-M, Streamworks, TWSd, TWSz, Zeke Output systems: Beta93, CA-Deliver, Control-D XINFO is modular: Choose your set of Scanner XINFO is open: It’s easy to add your own data

  4. XINFO Scanner High quality scanner give perfect results • The Scanners are not just copying data, but interpret it and discover the details e.g. • The Cobol Scanner recognize dynamic calls, CICS, IMS, SQL and even customer specific load/call programs • The JCL Scanner dynamically allocates and read procedures, includes and SYSIN member, identifies DB2 and IMS program calls, resolve procedure and scheduler variables, get DSN from IDCAMS, take used DB2 tables/tablespaces from DB2 load/unload utilities etc. • The Scheduler Scanners are written to know the logic of the scheduling systems they interpret (e.g. how to build the dependencies and create the appropriate flowcharts) • They are very fast and able to scan huge amount of objects every day • Nevertheless you can use incremental update methods to save elapsed time and CPU usage

  5. XINFO Database and Dialog The results are loaded in DB2 z/OS, Oracle or MS SQL. Visualize the data by easy to install and easy to use dialogs: • Windows PC Client (xinfo.exe, just put it in a Windows folder) • The queries are grouped by scanner results and the user can choose a query (e.g. Cobol-Copy, JCL-EXEC-Statements, TWS-Jobnetplan etc.) • Enter search criteria in selection forms or free SQL • Results are displayed in tables, flowcharts, bar charts or diagrams • Right mouse click opens a menu to get additional data about the object (e.g. last runtimes of a job, browse the source code etc.) • Additional useful functions like sort, group data, calculate statistics (e.g. average runtime) assist to analyze the results. • Batch execution is possible to execute queries and create html output • All queries but no graphics can be done by the ISPF Dialog, the eclipse plugin or pure SQL (e.g. SPUFI)

  6. What Purpose has XINFO? • XINFO helps in projects like • merge, consolidate or separate datacenters • maintain or reshape legacy applications • cleanup production environments • convert scheduling systems and more … • XINFO quickly and accurately helps gathering information like • where is a program or dataset used • when and how did a (critical) job run, was it late? • who is using/updating which DB2 table • Etc. …

  7. Examples The following examples show you how to work with XINFO and how you can save time (and money): JCL and SMF Program Source Code Scheduling Systems

  8. JCL and SMF Skip JCL and SMF Examples

  9. JCL EXEC e.g. which jobs are using a specific program? Specify program… Select EXEC Statements…

  10. JCL EXEC The result

  11. SMF Job/Step Run Times Select desired information, e.g. SMF run times Right mouse click

  12. SMF Job/Step Run Times The result: Start/End times, RC, duration, CPU usage, etc. Scroll right or double click to see all columns

  13. JCL DSN e.g. which jobs/programs are using a specific dataset? Select DSN (DD Statements) … Specify DSN or generic parts of it …

  14. JCL DSN The result (all JCL DD parameters are shown and available for the query)

  15. JCL Data Flowchart The JCL Flowchart shows the DSN (yellow), DD-Name (blue), Steps, and DB2 Tables You may compare it and browse the real JCL

  16. JCL Job Data Flowchart The JCL Job Flowchart shows on job level how DB2 Tables are used and how DSN are created and passed from job to job DISP=SHR DB2 Table Scheduler Dependency DISP=New,Catlg,Catlg Job DSN

  17. SMF Dataset Usage e.g. which job/program has used a specific dataset? Specify DSN or generic parts of it … Select SMF Dataset Usage …

  18. SMF Dataset Usage The result. Sort by Open Timestamp shows how the dataset was processed and who did access it when and how

  19. Program Source Code Skip Source Code Examples

  20. XINFO Source Scanner General Info: Basic information like number source lines, comments, is using static/dynamic SQL, is calling CICS, IMS, etc. Includes: Usage of include and copy members Calls: External program calls (graphic call diagram) Files: Access type (e.g. read/write) and file definition (file names, record length etc.) DB2 SQL: Which program uses which tables (select, insert, delete, etc.), and columns CICS,DLI and MQ: Calls and their parameters Variables: Definitions and usage Comments: String search cross comments All source scanners are analyzing program source code to deliver the following information:

  21. Cobol Variable e.g. which programs are using variable like “last name”? Specify the variable name. Use * if you don’t know the exact name … Select Variable Declarations …

  22. Cobol Variable The result: Program names, Variable names etc.

  23. Cobol Variable Use View+Al+Cobol – Variable Usage, to see where and how the variables are used

  24. Cobol Variable usage The result: Program names, Variable names, Statement and update Y/N

  25. Cobol DB2 e.g. which programs are using DB2 tables and column “lastname”? Specify the column name … Select DB2 Access …

  26. Cobol DB2 Usage in the SQL statement Program names Table/View Action

  27. Cobol DB2 Right mouse click “Browse – Member with SQL” shows you the statement in the Source

  28. Call Diagram Right mouse click, Programs Call Diagram …

  29. Programs Call Graphic The graphic shows you all external calls, also inter language calls (e.g. PL/I - Assembler - Cobol)

  30. Scheduling Systems

  31. XINFO Scheduler Scanner The defined jobs/tasks and it’s attributes like job type, owner, time dependency, execution system, highest return code etc. The scheduling parameters of the jobs like calendar, run days, free day rules etc. The prerequisites like predecessor jobs, resources etc. Documentation (CA-7 prose, TWSz OI, Automic (UC4) docu, …) Daily plan and status of the jobs Job History (when did the jobs run) Forecast (when will the jobs run) Graphical flowchart (net plan) and bar chart The scheduler scanners typically analyze the definition database of the respective scheduler, eventually the plan data (daily schedule) and log files to create a job history. The result is grouped like this:

  32. Scheduler Scanner Examples CA-7 Control-M TWS for z/OS Automic (UC4) Skip Scheduler Examples

  33. CA-7 Skip CA-7 Examples

  34. CA-7 e.g. which jobs are defined with priority > 100? Scroll down (there are 59 selection fields) and specify “Priority > 100” Select Job Information …

  35. CA-7 The columns in the result table can be arranged by “View, Arrange, …” The result, the jobs with priority greater 100

  36. CA-7 Job Netplan Select CA7 Job Netplan to show the job flow Right mouse click

  37. CA-7 Job Netplan Job triggerd by DSN (yellow) Job (blue) demands another job (detected by JCL scanner) Job creates trigger DSN Job pred requirement selected job and it’s predecessors

  38. CA-7 Critical Path Search critical path calculates the longest way through the network

  39. CA-7 Critical Path The total duration The jobs on the critical path are marked and listed The jobs on the critical path are marked and listed

  40. CA-7 SCHID The scanner creates dependencies for each SCHID and you can compare it’s differences Job flow with schid 010 Job flow with schid 020

  41. Control-M Skip Control-M Examples

  42. Control-M Maybe you want to search for a job using a specific option like “confirm” Scroll down (there are 60 selection fields) and specify “Confirm = Y” Select Job Definition …

  43. Control-M The columns in the result table can be arranged by “View, Arrange, …” The result, the jobs which must be confirmed

  44. Control-M Resources Or you need to search for Jobs using a specific resource … and specify the resource name. Use * if you don’t know the exact name. Select Resources …

  45. Control-M Resources The result, the jobs using the resource

  46. Control-M Netplan Right mouse click Select Control-M Job Netplan to show the job flow

  47. Control-M Netplan The job netplan, here clustered by table Condition Job

  48. Control-M Critical Path Search critical path calculates the longest way through the network

  49. Control-M Critical Path The total duration The jobs on the critical path are marked and listed The jobs on the critical path are marked and listed

  50. Control-M Job History e.g. verify when and how long the jobs did run? Enter search criteria like application and Job start day Select Job History …

More Related