horizont 1 tws/webadmin horizont software for datacenters garmischer str. 8 d- 80339 münchen tel...
TRANSCRIPT
HORIZONT 1 TWS/WebAdmin
HORIZONTSoftware for Datacenters
Garmischer Str. 8 D- 80339 MünchenTel ++49(0)89 / 540 162 - 0www.horizont-it.com
The Web Interface for TWS
TWS/WebAdmin
Web-Based Management and Monitoring of TWS Distributed
HORIZONT 2 TWS/WebAdmin
Topics• TWS/WebAdmin Features
• Getting Started
• TWS Database Management
• Plan Monitoring and Management
• Job Notes
• Reporting
• Events and Alerts
• Miscellaneous Functions
• Other New Features in Version 2.0
HORIZONT 3 TWS/WebAdmin
TWS/WebAdmin Features
• Web Interface to Tivoli Workload Scheduler for Distributed (Unix and Windows)
• TWS Database Management – composer functions
• TWS Plan Management – conman functions• Event Monitoring• Alerting (Email and Custom Alerts)• Job Notes• Reporting: Customizable reports, charts and
graphs, flexible SQL query engine
HORIZONT 4 TWS/WebAdmin
Getting Started
• Logging In
• TWS/WebAdmin Home Page
• Basic Navigation
• Help
• Printing
• Administration Page
HORIZONT 5 TWS/WebAdmin
Logging In
• Launch web browser, enter the name of the TWS Master in the address bar.
• Enter user name and password
HORIZONT 6 TWS/WebAdmin
TWS/WebAdmin Home Page
HORIZONT 7 TWS/WebAdmin
Basic Navigation
• TWS/WebAdmin display consists of 2 frames
• Navigation frame on left
• Results frame on right
HORIZONT 8 TWS/WebAdmin
Getting Help
Clickable Help Link
HORIZONT 9 TWS/WebAdmin
Online Help Window
HORIZONT 10 TWS/WebAdmin
Printing from TWS/WebAdmin
Click Print
HORIZONT 11 TWS/WebAdmin
TWS/WebAdmin Administration Page
The webadmin user has Administrator
privileges
Click link to enter Administration area
HORIZONT 12 TWS/WebAdmin
Administration Home Page
HORIZONT 13 TWS/WebAdmin
Database Management
• Database Management Functions
• Object Definition Lists
• Common Database Management Actions
• Using Filters
• Backups
• Drafts
• Advanced Database Management Actions: Text Edit, Export, Dependent Objects
HORIZONT 14 TWS/WebAdmin
Database Management Functions
• Create, Modify, and Delete TWS Scheduling Objects
• Display and Edit object definitions in GUI mode or text mode
• Save Draft copies of Job and Jobstream definitions
• Export definitions to files for migration and backups
• View dependent objects and Notes
HORIZONT 15 TWS/WebAdmin
TWS Database Scheduling Objects
• Workstations
• Workstation Classes
• Domains
• Jobs
• Jobstreams
• Calendars
• Resources
• Prompts
• Parameters
• Users
HORIZONT 16 TWS/WebAdmin
Workstation Definitions
Click object name to display definition
Action Buttons
HORIZONT 17 TWS/WebAdmin
Workstation Class Definitions
HORIZONT 18 TWS/WebAdmin
Domain Definitions
HORIZONT 19 TWS/WebAdmin
Job Definitions
HORIZONT 20 TWS/WebAdmin
Jobstream Definitions
HORIZONT 21 TWS/WebAdmin
Calendar Definitions
HORIZONT 22 TWS/WebAdmin
Resource Definitions
HORIZONT 23 TWS/WebAdmin
Prompt Definitions
HORIZONT 24 TWS/WebAdmin
Parameter Definitions
HORIZONT 25 TWS/WebAdmin
User Definitions
HORIZONT 26 TWS/WebAdmin
Common Database Management Actions
• Click on an object name to display its definition (read-only)
• Standard Actions: Add, Modify, Delete
• Display: Show text definitions (multiple objects can be selected)
• Copy: Duplicate an existing object
HORIZONT 27 TWS/WebAdmin
Example: Display Workstation
Click workstation name to display definition
HORIZONT 28 TWS/WebAdmin
Example: Display Workstation
HORIZONT 29 TWS/WebAdmin
Example: Display Workstation (Text)
Select one or more workstations
Click Display
HORIZONT 30 TWS/WebAdmin
Example: Display Workstation (Text)
HORIZONT 31 TWS/WebAdmin
Example: Add Calendar
HORIZONT 32 TWS/WebAdmin
Example: Add Calendar
Click dates to toggle
Navigation:< Month ><< Year >>
HORIZONT 33 TWS/WebAdmin
Example: Modify Job
When Modifying a job, the Workstation and Job names cannot be changed. Use the
Copy job action instead if you want to change the Workstation
and/or Job names.
HORIZONT 34 TWS/WebAdmin
Example: Modify Job (Confirmation)
Backup copy of original job definition is saved
by default
HORIZONT 35 TWS/WebAdmin
Example: Delete Jobstream
Select one or more jobstreams
Click Delete
HORIZONT 36 TWS/WebAdmin
Example: Delete Jobstream
Backup copy of jobstream definitions is
saved by default
HORIZONT 37 TWS/WebAdmin
Using Filters
• Click the Filter action button on any Database List page to display filter options
• Current filter settings are displayed in the top left corner of Database Lists
• Click Clear Filter on filter page to clear filter settings
• Filter settings can be saved, restored, and bookmarked
• Click Database Filters in the navigation frame to go directly to a filter page
HORIZONT 38 TWS/WebAdmin
Database Filter Example
Use either * or @ as the wildcard character…
Both work!
HORIZONT 39 TWS/WebAdmin
Database Filter Set
Current filter setting
HORIZONT 40 TWS/WebAdmin
Database Filters Screenshot
HORIZONT 41 TWS/WebAdmin
Backups
• All Database Management actions that modify or delete scheduling objects provide an option to save a backup copy of the original definition(s)
• Backups are stored as text files which can be restored using TWS/WebAdmin or command line composer
• Backups are saved to the webadmin/backup directory with date/time and username stamp
HORIZONT 42 TWS/WebAdmin
Save Backup Example: Modify Job
Save Backup Copy option
HORIZONT 43 TWS/WebAdmin
Save Backup Example: Delete Prompt
Save Backup Copy option
HORIZONT 44 TWS/WebAdmin
Backup Options
Set default Backup options
HORIZONT 45 TWS/WebAdmin
Drafts
• Drafts are partial or complete Job and Jobstream definitions that are saved as text files
• Drafts are not saved to the TWS Mozart database, but can be recalled later to be reviewed, modified, and saved
• Drafts are stored with date/time and username stamps
• Users that do not have ADD permission for jobs and jobstreams in TWS security can be configured to have Save Draft permissions. This is valuable when implementing an approval process for TWS scheduling.
HORIZONT 46 TWS/WebAdmin
Save Draft Example
Click Save Draft
HORIZONT 47 TWS/WebAdmin
Save Draft Example
Enter a filename or accept the auto-generated name
HORIZONT 48 TWS/WebAdmin
Saved Drafts
Click the Saved Drafts button on the Database Job List page to display all job drafts. Select a draft from the list, then click Load to open the draft and
edit it like a normal job definition.
HORIZONT 49 TWS/WebAdmin
Advanced Database Management Actions
• Text Edit: Modify object definitions in command line mode – Useful for making mass changes to multiple definitions
• Export: Save object definitions to a local or remote file – Useful for backups and migrations
• Dependent Objects: Show all references to a selected object – Where it is used, what it is a member of, dependencies on it
HORIZONT 50 TWS/WebAdmin
Text Edit Jobs Example
Edit the selected job definitions in the Edit Area, then click Submit to save changes. Select Save
Backup Copy to store a backup of the original job definitions.
HORIZONT 51 TWS/WebAdmin
Dependent Objects Example 1
Domain membership for workstation VOGON
Workstation Class membership for workstation VOGON
HORIZONT 52 TWS/WebAdmin
Dependent Objects Example 2
Jobstream membership for job FTPJOB
Dependencies on job FTPJOB
HORIZONT 53 TWS/WebAdmin
Plan Monitoring and Management
• Basic Plan Monitoring
• Plan Management Actions
• Using Filters
• Submitting Ad-Hoc Jobs and Jobstreams
• Viewing Previous Production Days
• Forecasting
• TWS/WebAdmin Options
HORIZONT 54 TWS/WebAdmin
Basic Plan Monitoring
• Plan Monitoring / Management is performed in real time
• Very fast compared to Job Scheduling Console• Workstations• Domains• Jobstreams• Jobs• Resources• Prompts• Files
HORIZONT 55 TWS/WebAdmin
Plan Workstation List
Click Workstation to view Jobstreams
Action Buttons
HORIZONT 56 TWS/WebAdmin
Plan Domain List
HORIZONT 57 TWS/WebAdmin
Plan Jobstream List
Click Jobstream to view Jobs
HORIZONT 58 TWS/WebAdmin
Plan Job List
Click Job to view Output
HORIZONT 59 TWS/WebAdmin
Plan Resource List
HORIZONT 60 TWS/WebAdmin
Plan Prompt List
HORIZONT 61 TWS/WebAdmin
Plan File List
HORIZONT 62 TWS/WebAdmin
View Job Output
• Click on a job in the Plan Job List to display its output (stdlist)
• Job output is displayed in a new browser window
• Tail action displays job output in a constantly updating window - useful for “watching” a currently executing job
HORIZONT 63 TWS/WebAdmin
Job Output
HORIZONT 64 TWS/WebAdmin
Customize Plan List Layout
• The Layout action button on each Plan List page will customize the table column layout
• Select and re-order columns
• The Fill Entire Page Width option determines whether to stretch the table to fill the entire page
• Select Reset to Defaults to restore the standard default column layout
HORIZONT 65 TWS/WebAdmin
Custom Layout Example – Plan Jobstreams
Click Layout to customize
HORIZONT 66 TWS/WebAdmin
Custom Layout Example – Plan Jobstreams
Select which columns to include in the Plan
Jobstream List display
Use the arrow buttons to re-order the columns
Select Save as Default to set the
layout as your default
HORIZONT 67 TWS/WebAdmin
Custom Jobstreams Layout Example – Results
HORIZONT 68 TWS/WebAdmin
Plan List SortingClick a column heading to sort
by that column. Click again to toggle between
ascending and descending order. An arrow symbol shows
what sorting is in effect.
HORIZONT 69 TWS/WebAdmin
Plan Management Actions
• All standard TWS plan actions are provided: Cancel, Release, Rerun, Priority, Limit, Fence, etc.
• Multiple objects can be selected
• Safe mode is used when canceling multiple jobs or jobstreams
• Unique Actions: Display Jobstream, Tail Job, Info
HORIZONT 70 TWS/WebAdmin
Using Filters
• Click the Filter action button on any Plan List page to display filter options
• Current filter settings are displayed in the top left corner of Plan Lists
• Click Clear Filter on filter page to clear filter settings
• Filter settings can be saved, restored, and bookmarked
HORIZONT 71 TWS/WebAdmin
Plan Filter Example
HORIZONT 72 TWS/WebAdmin
Load Filter Example
Click to add browser bookmark
HORIZONT 73 TWS/WebAdmin
Set Filter Example
HORIZONT 74 TWS/WebAdmin
Plan Filters
• Click the Plan Filters in the navigation frame to go directly to a filter page
• Set / Load a filter prior to viewing a Plan List
• Useful if a Plan List contains a very large number of objects
HORIZONT 75 TWS/WebAdmin
Plan Filters Screenshot
HORIZONT 76 TWS/WebAdmin
Submitting Jobs and Jobstreams
• Submit Jobstream• Submit Job• Submit Task• Dependencies and Alias can be specified• Submit Jobstream, Submit Job, Submit Task
links on Navigation frame• Submit Jobstream and Submit Job on Plan
Workstation List• Submit Job on Plan Jobstream List
HORIZONT 77 TWS/WebAdmin
Submit Jobstream
HORIZONT 78 TWS/WebAdmin
Submit Job
HORIZONT 79 TWS/WebAdmin
Submit Task
HORIZONT 80 TWS/WebAdmin
Viewing Previous Production Days
• Set Run History displays a list of logged Symphony files
• Select the desired run date, then click Set Symphony
• All Plan Lists will display information from the selected production day
• Plan List title bars turn green while a previous production day is in use
• Return to Set Run History and click Use Current to return to the current day
HORIZONT 81 TWS/WebAdmin
Set Run History
HORIZONT 82 TWS/WebAdmin
Previous Production Day Job List
Green Title BarSymphony Date
HORIZONT 83 TWS/WebAdmin
Forecasts
• The TWS/WebAdmin forecast function generates a complete forecast for a future production day
• Select Forecast, enter a future date, then click Generate
• All Plan Lists will display information from the future production day (just like viewing a previous production day)
HORIZONT 84 TWS/WebAdmin
Generate Forecast
HORIZONT 85 TWS/WebAdmin
Forecast Job List
Forecast Date
HORIZONT 86 TWS/WebAdmin
TWS/WebAdmin Options
• Auto-Refresh
• Display Job Logs: Single / Multiple
• After Actions GoTo
• Action Buttons: Top / Bottom, Anchored
• Date Format
• Skin
• Compression
• Disable Job Statistics
HORIZONT 87 TWS/WebAdmin
TWS/WebAdmin Options
HORIZONT 88 TWS/WebAdmin
Auto Refresh
• Set any auto-refresh rate for Plan Lists
• Use the browser Reload button to force a manual refresh
HORIZONT 89 TWS/WebAdmin
Display Job Logs: Single / Multiple
• Single (default) displays only one stdlist when a job’s output is viewed
• Multiple displays all stdlists for a job (EVERY and RERUN jobs)
HORIZONT 90 TWS/WebAdmin
Action Buttons: Top / Bottom, Anchored
• Bottom (default): Action buttons are displayed at the bottom of the page
• Bottom (Anchored): Action buttons are anchored in a separate frame at the bottom of the page so they are always visible
• Top (Anchored): Action buttons are anchored in a separate frame at the top of the page so they are always visible
HORIZONT 91 TWS/WebAdmin
Action Buttons: Bottom (Anchored)
HORIZONT 92 TWS/WebAdmin
Date Format
• MM / DD / YYYY
• MM – DD – YYYY
• DD / MM / YYYY
• DD – MM – YYYY
• YYYY / MM / DD
• YYYY – MM – DD
HORIZONT 93 TWS/WebAdmin
Skin
3D Skin
HORIZONT 94 TWS/WebAdmin
Job Notes
• TWS/WebAdmin Job Notes are small text notes that are connected to specific jobs.
• Primary functions: Contact Information, Recovery Procedures, Comments.
• Simple HTML can be embedded: formatting, hyperlinks, bullet-lists, etc.
• Workstation Notes• Notes are also accessible from Database
Lists
HORIZONT 95 TWS/WebAdmin
Creating and Managing Job Notes
• To view Job Notes, select a job from the Plan Job List page or Database Job List page and click Notes
• From the Job Notes page, users can Add, Modify, and Delete Notes
HORIZONT 96 TWS/WebAdmin
Display Job Notes
Select Job
Click Notes
HORIZONT 97 TWS/WebAdmin
Adding a Job Note
Click Add Note
HORIZONT 98 TWS/WebAdmin
Adding a Job Note
Note Type
HORIZONT 99 TWS/WebAdmin
Modifying Job Notes
Click to Edit
Click to Delete
HORIZONT 100 TWS/WebAdmin
Workstation Notes
HORIZONT 101 TWS/WebAdmin
Reporting
• TWS/WebAdmin provides a number of reports that can be generated and viewed from a web browser
• Charts and Graphs
• Reports can be customized and saved
• Report output can be stored
• Some reports can be generated and sent to Microsoft Excel in CSV format
HORIZONT 102 TWS/WebAdmin
Standard TWS/WebAdmin Reports
• Job History Report
• Job Details Report
• TWS Activity Report
• Production Planning Report
• TWS Database Report
• Cross Reference Report
• Critical Jobs Report
HORIZONT 103 TWS/WebAdmin
Job History Report
• Shows historical job execution information
• Select date range, job / jobstream / workstation names, job status
• Sort by date, job name, status, etc.
• Status Pie Chart
HORIZONT 104 TWS/WebAdmin
Job History Report - Example
HORIZONT 105 TWS/WebAdmin
Job History Report - Output
HORIZONT 106 TWS/WebAdmin
Job History Status - Pie Chart
HORIZONT 107 TWS/WebAdmin
Job Details Report
• Shows details and statistics for a specified job
• Presents a view of historical execution time in bar chart or line chart
HORIZONT 108 TWS/WebAdmin
Job Details Report - Example
HORIZONT 109 TWS/WebAdmin
Job Details Report - Output
HORIZONT 110 TWS/WebAdmin
Job Details Report - Bar Chart
HORIZONT 111 TWS/WebAdmin
TWS Activity Report
• Shows number of jobs executed per day by week / month / year
• Bar or line chart views
• Workstation can optionally be specified
• Jobs can be grouped by status using accumulated graphs
HORIZONT 112 TWS/WebAdmin
TWS Activity Report - Examples
Select Scale: Day, Week, Month, Year
Select Style: Bar, Line, etc.
HORIZONT 113 TWS/WebAdmin
TWS Activity Report – Month Activity Bar Chart
HORIZONT 114 TWS/WebAdmin
TWS Activity Report – Week Accumulated Bar Chart
HORIZONT 115 TWS/WebAdmin
Production Planning Report
• Generates a pre-production report for a range of future dates
• Shows jobstreams, descriptions, and estimated run times
HORIZONT 116 TWS/WebAdmin
Production Planning Report - Example
Select Date Range
HORIZONT 117 TWS/WebAdmin
Production Planning Report - Output
HORIZONT 118 TWS/WebAdmin
Critical Jobs Report
• Define one or more lists of Critical jobs, including Deadline Time
• Critical Jobs Report shows the status of each critical job and whether it completed by the deadline
• Select which Plan to analyze: Current plan, yesterday's plan, or any previous logged plan
HORIZONT 119 TWS/WebAdmin
Critical Jobs Report - Example
Select Plan to analyze
Click to configure Critical
Jobs List
HORIZONT 120 TWS/WebAdmin
Manage Critical Jobs List
It is possible to define separate lists for each
group, application, region, etc.
Add a new Critical Job
HORIZONT 121 TWS/WebAdmin
Critical Jobs Report - Output
HORIZONT 122 TWS/WebAdmin
Creating Custom Reports
• TWS/WebAdmin extracts and stores TWS object definitions and job history data in a relational database (RDBMS)
• Customized reports are created with standard SQL
• Basic understanding of SQL syntax and the TWS/WebAdmin table structure is required
HORIZONT 123 TWS/WebAdmin
Example Custom Report
• Objective: Create a report that lists all jobs created by user “maestro” with a description that contains the text “extract”
• SQL Statement:
SELECT * FROM jobs WHERE creator='maestro' AND description LIKE '%extract%'
HORIZONT 124 TWS/WebAdmin
Example Custom Report Setup
Enter SQL
Set Title
View Database Tables
HORIZONT 125 TWS/WebAdmin
Example Custom Report Output
HORIZONT 126 TWS/WebAdmin
Saving Customized Reports
• Save Report function saves a customized report definition
• SQL Query, Title, and Report Description are stored
• Saved Reports are globally available from User Defined Reports menu item
HORIZONT 127 TWS/WebAdmin
Save Report Example
Report Title and SQL Query are
filled in automatically
HORIZONT 128 TWS/WebAdmin
User Defined Reports
User Defined Reports menu item
HORIZONT 129 TWS/WebAdmin
Storing Reports
• Storing a report saves the raw report output to a globally available URL
• Contents of stored reports are static
• URL can be emailed or posted as a link on an external web page
HORIZONT 130 TWS/WebAdmin
Store Report Example
Store Report
HORIZONT 131 TWS/WebAdmin
Store Report Results
Stored Report URL
HORIZONT 132 TWS/WebAdmin
Microsoft Excel Integration
• Send as CSV File, available in several reports, sends report data in CSV (comma separated values) format
• By default, Excel is associated with the .csv file type and will launch automatically
• It may be necessary to resize columns in Excel following import
HORIZONT 133 TWS/WebAdmin
Send as CSV Example
Send as CSV
HORIZONT 134 TWS/WebAdmin
Open CSV Data Stream
Select Open to pull data into
Excel
HORIZONT 135 TWS/WebAdmin
View CSV in Excel
HORIZONT 136 TWS/WebAdmin
Events and Alerting
• TWS/WebAdmin Event Monitor collects events from TWS
• Job Abend, Jobstream Stuck, CPU Link Down, etc.
• Custom events and severities
• Alerts: Email and custom commands
HORIZONT 137 TWS/WebAdmin
Event Monitor
HORIZONT 138 TWS/WebAdmin
Event Configuration
HORIZONT 139 TWS/WebAdmin
Alerts
• TWS/WebAdmin alerts generate email notification for events such as Job Abends
• Wildcards are permitted• Multiple email addresses can be entered,
separated by commas• Enter custom email text in the Email Text field or
leave blank to use the default email format• Instead of sending email, an alert can execute a
custom command
HORIZONT 140 TWS/WebAdmin
Alert Configuration
HORIZONT 141 TWS/WebAdmin
Adding an Alert
HORIZONT 142 TWS/WebAdmin
Miscellaneous Functions
• Audit Log Viewer
• TWS Logfile Viewer
• TWS Mailbox Files
• TWS Database Files
HORIZONT 143 TWS/WebAdmin
Audit Log Viewer
• Displays TWS Database and Plan Audit Logs
• Auditing must be enabled in the TWS globalopts file
• Entries can be filtered
• Send as CSV displays log entries in MS Excel
HORIZONT 144 TWS/WebAdmin
Database Audit Log
HORIZONT 145 TWS/WebAdmin
Plan Audit Log
HORIZONT 146 TWS/WebAdmin
TWS Logfile Viewer
• TWS maintains the MAESTRO logfile, which contains a running log of TWS operations, including errors and warnings
• The TWS/WebAdmin Logfile viewer simply displays the MAESTRO logfile and allows filtering and navigation by date
• Useful for troubleshooting
HORIZONT 147 TWS/WebAdmin
TWS Logfile Example
HORIZONT 148 TWS/WebAdmin
TWS Mailbox Files
HORIZONT 149 TWS/WebAdmin
TWS Database Files
HORIZONT 150 TWS/WebAdmin
Other New Features in Version 2.0• Execute TWS/WebAdmin Reports from command
line (scheduling reports now possible)• New options for extracts, improved performance for
extracts, new Current-Plan extracts• New NOP action for Plan jobs and jobstreams, New
Rerun: Step action for jobs• Improved page refreshing, new R refresh hotkey• Pop-up selectors filter on partially entered names• Enhanced control of user permissions, global filters,
and saved reports• Improved maintenance utilities in TWS/WebAdmin
Administration
HORIZONT 151 TWS/WebAdmin
Upcoming Features
• Composer Versioning, Migration Tool
• Enhanced SAP Extended Agent Job Configuration
• TWS Database Validation (Health Check)
• Critical Path Monitoring
• TWS/Graph Integration
• Additional Language support
HORIZONT 152 TWS/WebAdmin
Conclusion
• Wrap Up
• Questions
• Comments
• Additional Resources:
www.horizont-it.com (Europe)www.segus.com (USA)Email: [email protected]
HORIZONT 153 TWS/WebAdmin
The Web Interface for TWS
HORIZONTSoftware for Datacenters
Garmischer Str. 8 D- 80339 MünchenTel ++49(0)89 / 540 162 - 0www.horizont-it.com
TWS/WebAdmin
Thank you very much for you attention