XINFO The IT Information System Control-M HORIZONT Software HORIZONT for Datacenters1 Garmischer Str. 8 D- 80339 München Tel ++49(0)89 / 540 162 - 0 ® www.horizont-it.com XINFO XINFO and Control-M XINFO's Control-M Interface.
Download ReportTranscript XINFO The IT Information System Control-M HORIZONT Software HORIZONT for Datacenters1 Garmischer Str. 8 D- 80339 München Tel ++49(0)89 / 540 162 - 0 ® www.horizont-it.com XINFO XINFO and Control-M XINFO's Control-M Interface.
XINFO The IT Information System Control-M HORIZONT Software HORIZONT for Datacenters1 Garmischer Str. 8 D- 80339 München Tel ++49(0)89 / 540 162 - 0 ® www.horizont-it.com XINFO XINFO and Control-M XINFO's Control-M Interface analyzes following Control-M/Server data under z/OS, Unix, Windows etc.: • • • • • • • • General Job Definitions Scheduling and Execution Parameters Resources Conditions "ON PGMST", and Steps SHOUT, and PostProc IOALOG, the base for job history Statistics, Conditions and ctmrpln utility, used for the forecast HORIZONT 2 XINFO ® Control-M – Selection Cross reference for Control-M data Job history and forecast Netplans XINFO is an add-on to Control-M GUI. XINFO collects data from all Control-M systems, independently from the platform. Therefore XINFO gives you an overview about all systems. HORIZONT 3 XINFO ® XINFO Architecture with z/OS and DB2 z/OS (MVS) Control-M ScheduleLibraries Unix SQL Output Scanner MVS Scanner DS Control-M Server Database Unload Script SQL Output Output Files Windows Control-M Server Database Unload Script SQL Output Graphic + Forecast Windows PC Client Output Files DB2 HORIZONT TCPI P 4 XINFO ® XINFO Architecture with Windows and Oracle Unix / Windows Unix Windows Control-M Server Database Control-M Server Database Control-M Server Database Unload Script Unload Script Unload Script SQL Output SQL Output SQL Output Scanner Script/Programme Windows PC Client Output Files ODBC HORIZONT 5 Oracle XINFO ® XINFO Control-M - Examples Cross references Netplans Job History Forecast Export: Excel, HTML, Word Line Commands News in Release 3.1, 3.2, 3.5 XINFO vs. Control-M/Desktop HORIZONT 6 XINFO ® Control-M – Job Definitions Search search all jobs in Tables T* with Owner ctm* HORIZONT 7 XINFO ® Control-M – Job Definitions The jobs, Memname or Filename Owner ctm* Distributed Jobname HORIZONT Tables T* 8 XINFO ® Control-M – Job Definitions From z/OS Control-M From distributed Control-M HORIZONT 9 XINFO ® Control-M – Job Definitions, Nodeid search all jobs running on "PC26" HORIZONT 10 XINFO ® Control-M – Job Definitions, Nodeid Jobs HORIZONT Nodeid, Nodegroup 11 XINFO ® Control-M – Job Definitions More selection, e.g. "Confirm" Time dependencies Cyclic jobs keep for restart Sysout options keep archive SYSDATA HORIZONT 12 XINFO ® Control-M – Scheduling, calendar search all jobs using a calendar (NB = "not blank) HORIZONT 13 XINFO ® Control-M – Scheduling, calendar Calendar Jobs DAILYNAM More scheduling parameters HORIZONT 14 XINFO ® Control-M – Scheduling, Group function How often is a calendar used? ... "Group function" HORIZONT 15 XINFO ® Control-M – Scheduling, Group function how often per calendar HORIZONT 16 XINFO ® Control-M – Resources search all jobs using resource "prod-d*" or "Jobslp6*" HORIZONT 17 XINFO ® Control-M – Resources usage Jobs Resources HORIZONT 18 XINFO ® Control-M – DO (Step) Action Which jobs are started with FORCEJOB? HORIZONT 19 XINFO ® Control-M – DO (Step) Action The trigger The action HORIZONT 20 The jobs XINFO ® Control-M – Set Var Which jobs are using a "DATE" variable HORIZONT 21 XINFO ® Control-M – Set Var The jobs HORIZONT ...that are using "Date" variables 22 XINFO ® Control-M – Table netplan select tables Level Predecessor/Successor HORIZONT 23 XINFO ® Control-M – Table netplan The tables and the dependencies HORIZONT 24 XINFO ® Control-M – Table netplan with "right mouseclick" to the table's job netplan HORIZONT 25 XINFO ® Control-M – Table- / Job-netplan HORIZONT 26 XINFO ® Control-M – Job-netplan, the Symbols Clustered by table Force Job In-Condition without Job Job Condition HORIZONT Out-Condition without Job 27 XINFO ® Control-M – Job-netplan, the Symbols Detailed information via double-click. Please note that all data can be show within the symbol (e.g. Owner) HORIZONT 28 XINFO ® Control-M – Job-netplan, the Symbols adapt colours, shapes, contents etc. HORIZONT 29 XINFO ® Control-M – Job-netplan, the Symbols Group start HORIZONT Group End (special dummy symbol to show dependencies) 30 XINFO ® Control-M – Job-netplan, the Symbols Control-D Control-D Reports reports with with dependencies to Control-M jobs HORIZONT 31 XINFO ® Control-M – Job-netplan, The Links External condition (from table to table) Condition DO-Condition Global condition (from Control-M to Control-M) OR-Condition HORIZONT 32 XINFO ® Control-M – Job-netplan, Pred/Succ Level Show jobnetplan for Table "TABW" with 1 additional predecessor/successor level HORIZONT 33 XINFO ® Control-M – Job-netplan, Pred/Succ Level Predecessor level 1 HORIZONT Selection, table TABW 34 Successor level 1 XINFO ® Control-M – Job-netplan, Pred/Succ Level "right mouseclick", Pred/Succ netplan HORIZONT 35 XINFO ® Control-M – Job-netplan 2nd level predecessor and "all" successor of the starting job HORIZONT 36 XINFO ® Control-M – Job-netplan Search function HORIZONT 37 XINFO ® Control-M – Job-netplan Found jobs, sorted by jobname HORIZONT A "click" on the list marks the matching job in the netplan 38 XINFO ® XINFO – Print Netplans XINFO print preview XINFO prints netplans on all devices (printers, plotters etc.) HORIZONT 39 XINFO ® XINFO - Batch Interface XINFO.EXE /CMD=BATCH.BIF /*********************************************************************/ /* */ /* Logon-Parameter */ /* */ /*********************************************************************/ CLOSE=ALL LOGON='C:\PROGRAMME\XINFO\LOGON_USER_MAX.LGN' /*********************************************************************/ /* */ /* Input and Output files */ /* */ /*********************************************************************/ LOAD_PRED=99 LOAD_SUCC=99 /*********************************************************************/ SELECTION_FILE='C:\PROGRAMME\XINFO\Selection_UC4.TXT' CREATE_JPG_FILE='C:\TEMP\GRAFIK_1.JPG' /*********************************************************************/ EXIT /* Exit XINFO */ LOGON data encrypted Selection Output The batch interface alllows you to export data automatically, e.g. netplans as JPEGs, tables as HTML files and so on. HORIZONT 40 XINFO ® Control-M – Job history When did all maintenance jobs run in February? HORIZONT 41 XINFO ® Control-M – Job history The jobs Start / End Status, Return code, duration, etc. You may use the runtime data as a base for statistics HORIZONT 42 XINFO ® Control-M – Job history Detailed information per double-click HORIZONT 43 XINFO ® Control-M – Job history, IOALOG Basis is the log from all Control-M systems (distributed and z/OS) HORIZONT 44 XINFO ® Control-M – IOALOG You can search easily and fast for strings, e.g. messages or a certain userid HORIZONT 45 XINFO ® Control-M – IOALOG Timestamp Message jobs HORIZONT 46 XINFO ® Control-M – Forecast .CONTROL-M 6.1.00 Page: 5 Period:20060303., BMC Software, Ltd. calendar:Yes. "ctmrpln" gives us the jobnames, XINFO knows the sequence and Nodeid the start times, --------------Based on average duration XINFO calculates the planned end times for a couple of days. Daily Job Order Report For Table Systemarbeiten , Job * ========================================================== Job Name --------------ctmlog_save ctmcontb ctmjsa ctmrpln ctmpsm_sysout emdb_export erase_alert refresh_GAS ctmudlyT ctmudlyP Application --------------Systemarbeiten Systemarbeiten Systemarbeiten Systemarbeiten Systemarbeiten Systemarbeiten Systemarbeiten Systemarbeiten Systemarbeiten Systemarbeiten HORIZONT Group Cint From Untl --------------- ---- ---- ---Systemarbeite 0605 Systemarbeite 0605 Systemarbeite 0605 Systemarbeite Systemarbeite Systemarbeite Systemarbeite Systemarbeite 2300 Systemarbeite 0605 Systemarbeite 0605 47 XINFO ® Control-M – Forecast When are the maintenance jobs planned for March? HORIZONT 48 XINFO ® Control-M – Forecast The jobs Planned Start/End HORIZONT 49 Planned duration XINFO ® Control-M – Job-Statistic The average duration, taken from Control-M statistic tables and files HORIZONT 50 XINFO ® XINFO – Data Export with "File save as" all data can be exported Select file type: txt, csv, htm, wmf, bmp, jpg, u.v.w. HORIZONT 51 XINFO ® XINFO –Export Data to Excel HORIZONT 52 XINFO ® XINFO –Exported Data as HTML HORIZONT 53 XINFO ® XINFO – Graphic Export, e.g. as JPG to WinWord HORIZONT 54 XINFO ® XINFO – Line Commands Line commands allow you to "jump" directly from any record to related data HORIZONT 55 XINFO ® XINFO – Line Commands e.g. from job definitions to job history... HORIZONT 56 XINFO ® XINFO – Line Commands e.g. Browse JCL (z/OS only) HORIZONT 57 XINFO ® XINFO vs. Control-M Desktop Control-M Desktop: useful to define and maintain jobs, but can you use that to create a documentation? HORIZONT Confusing layout! 58 XINFO ® XINFO vs. Control-M Desktop ...bad print function HORIZONT 59 XINFO ® XINFO vs. Control-M Desktop XINFO gives you a clear view, even for complicated definitions HORIZONT 60 XINFO ® XINFO vs. Control-M Desktop Cross reference for Control-M data Job history and Forecast netplans XINFO is a useful extension to Control-M GUI. XINFO loads data from various Control-M systems to give you a general overview, independent from the target platform HORIZONT 61 XINFO ® New in XINFO 3.1 (September 2005) • "Distributed Jobname" in all tables (up to • • • • now only in job definitions). "User-Daily" in scheduling table. Group scheduling info in scheduling tables, in job flowcharts and for CTM distributed. Creator and last update userid and timestamp from ISPF or CTM JOBDEF table. New Scanner Programs: – Running under z/OS, HORIZONT Unix or Windows 62 XINFO ® New in XINFO 3.2 (February 2006) • Forecast • Job statistic table • Job history • Log table (IOALOG) HORIZONT 63 XINFO ® New in XINFO 3.4 (May 2009) CTM Barchart Selection Criteria New Barchart HORIZONT 64 XINFO ® CTM Barchart - Result Non-z/OS Jobs z/OS Jobs HORIZONT 65 XINFO ® New in XINFO 3.5 (May 2010) The new functions of XINFO‘s Control-M scanner: • • • • • • Since CTM 6.4.01 some fields are extended, e.g. Application, Table, Member etc. – XINFO 3.5 fields are adapted – Older scanners work, but may truncate data Unload scripts for Control-M with PostgreSQL “Job-History“ based on IOALOG (job start/endtimes) – New parameter KH=9999 (days) allows to specify how long the history should be kept – A new column shows JES jobid (z/OS jobs only) Display “Job statistics“ – Renamed to “Average Job Duration“. – Job runtimes are calculated by the scanner New display „Job Script/JCL“ for embedded scripts and JCL search for critical path in job netplan HORIZONT 66 XINFO ® Critical Path in CTM Job netplan CTM job netplan has a new search function : Critical Path HORIZONT 67 XINFO ® Critical Path in CTM Job netplan Based on the “average duration“ XINFO calculates the longest path within the displayed netplan. The total duration is shown on top of the result list. HORIZONT 68 XINFO ® Control-M Barchart The left column in the jobruntime barchart can display now Jobname, Application, Group or Table XINFO.INI: [GRAPHCTMRUNTIME] FIELDS="APPLICATION;GROUP;TABLE;JOB" HORIZONT 69 XINFO ® XINFO The IT Information System Many thanks for your attention HORIZONT Software HORIZONT for Datacenters70 Garmischer Str. 8 D- 80339 München Tel ++49(0)89 / 540 162 - 0 ® www.horizont-it.com XINFO