Transcript TWS/Webadmin - horizont

TWS/WebAdmin
The Web Interface for TWS
Web-Based Management and
Monitoring of TWS Distributed
HORIZONT
Software
HORIZONT for Datacenters1
Garmischer Str. 8
D- 80339 München
Tel ++49(0)89 / 540 162 - 0
www.horizont-it.com
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
2
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
3
TWS/WebAdmin
Getting Started
•
•
•
•
•
•
Logging In
TWS/WebAdmin Home Page
Basic Navigation
Help
Printing
Administration Page
HORIZONT
4
TWS/WebAdmin
Logging In
• Launch web browser, enter the name of the
TWS Master in the address bar.
• Enter user name and password
HORIZONT
5
TWS/WebAdmin
TWS/WebAdmin Home Page
HORIZONT
6
TWS/WebAdmin
Basic Navigation
• TWS/WebAdmin display consists of 2
frames
• Navigation frame on left
• Results frame on right
HORIZONT
7
TWS/WebAdmin
Getting Help
Clickable Help Link
HORIZONT
8
TWS/WebAdmin
Online Help Window
HORIZONT
9
TWS/WebAdmin
Printing from TWS/WebAdmin
Click Print
HORIZONT
10
TWS/WebAdmin
TWS/WebAdmin Administration Page
Click link to enter
Administration area
The webadmin user
has Administrator
privileges
HORIZONT
11
TWS/WebAdmin
Administration Home Page
HORIZONT
12
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
13
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
14
TWS/WebAdmin
TWS Database Scheduling Objects
•
•
•
•
•
Workstations
Workstation Classes
Domains
Jobs
Jobstreams
HORIZONT
15
•
•
•
•
•
Calendars
Resources
Prompts
Parameters
Users
TWS/WebAdmin
Workstation Definitions
Click object name to
display definition
Action Buttons
HORIZONT
16
TWS/WebAdmin
Workstation Class Definitions
HORIZONT
17
TWS/WebAdmin
Domain Definitions
HORIZONT
18
TWS/WebAdmin
Job Definitions
HORIZONT
19
TWS/WebAdmin
Jobstream Definitions
HORIZONT
20
TWS/WebAdmin
Calendar Definitions
HORIZONT
21
TWS/WebAdmin
Resource Definitions
HORIZONT
22
TWS/WebAdmin
Prompt Definitions
HORIZONT
23
TWS/WebAdmin
Parameter Definitions
HORIZONT
24
TWS/WebAdmin
User Definitions
HORIZONT
25
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
26
TWS/WebAdmin
Example: Display Workstation
Click workstation name to
display definition
HORIZONT
27
TWS/WebAdmin
Example: Display Workstation
HORIZONT
28
TWS/WebAdmin
Example: Display Workstation (Text)
Select one or more
workstations
Click Display
HORIZONT
29
TWS/WebAdmin
Example: Display Workstation (Text)
HORIZONT
30
TWS/WebAdmin
Example: Add Calendar
HORIZONT
31
TWS/WebAdmin
Example: Add Calendar
Navigation:
< Month >
<< Year >>
Click dates to toggle
HORIZONT
32
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
33
TWS/WebAdmin
Example: Modify Job (Confirmation)
Backup copy of original
job definition is saved
by default
HORIZONT
34
TWS/WebAdmin
Example: Delete Jobstream
Select one or more
jobstreams
Click Delete
HORIZONT
35
TWS/WebAdmin
Example: Delete Jobstream
Backup copy of
jobstream definitions is
saved by default
HORIZONT
36
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
37
TWS/WebAdmin
Database Filter Example
Use either * or @ as
the wildcard character…
Both work!
HORIZONT
38
TWS/WebAdmin
Database Filter Set
Current filter setting
HORIZONT
39
TWS/WebAdmin
Database Filters Screenshot
HORIZONT
40
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
41
TWS/WebAdmin
Save Backup Example: Modify Job
Save Backup Copy option
HORIZONT
42
TWS/WebAdmin
Save Backup Example: Delete Prompt
Save Backup Copy option
HORIZONT
43
TWS/WebAdmin
Backup Options
Set default Backup options
HORIZONT
44
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
45
TWS/WebAdmin
Save Draft Example
Click Save Draft
HORIZONT
46
TWS/WebAdmin
Save Draft Example
Enter a filename or accept
the auto-generated name
HORIZONT
47
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
48
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
49
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
50
TWS/WebAdmin
Dependent Objects Example 1
Domain membership for
workstation VOGON
Workstation Class membership
for workstation VOGON
HORIZONT
51
TWS/WebAdmin
Dependent Objects Example 2
Jobstream membership
for job FTPJOB
Dependencies on
job FTPJOB
HORIZONT
52
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
53
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
54
TWS/WebAdmin
Plan Workstation List
Click Workstation to
view Jobstreams
Action Buttons
HORIZONT
55
TWS/WebAdmin
Plan Domain List
HORIZONT
56
TWS/WebAdmin
Plan Jobstream List
Click Jobstream
to view Jobs
HORIZONT
57
TWS/WebAdmin
Plan Job List
Click Job to
view Output
HORIZONT
58
TWS/WebAdmin
Plan Resource List
HORIZONT
59
TWS/WebAdmin
Plan Prompt List
HORIZONT
60
TWS/WebAdmin
Plan File List
HORIZONT
61
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
62
TWS/WebAdmin
Job Output
HORIZONT
63
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
64
TWS/WebAdmin
Custom Layout Example – Plan Jobstreams
Click Layout to
customize
HORIZONT
65
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
66
TWS/WebAdmin
Custom Jobstreams Layout Example – Results
HORIZONT
67
TWS/WebAdmin
Plan List Sorting
Click 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
68
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
69
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
70
TWS/WebAdmin
Plan Filter Example
HORIZONT
71
TWS/WebAdmin
Load Filter Example
Click to add browser
bookmark
HORIZONT
72
TWS/WebAdmin
Set Filter Example
HORIZONT
73
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
74
TWS/WebAdmin
Plan Filters Screenshot
HORIZONT
75
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
76
TWS/WebAdmin
Submit Jobstream
HORIZONT
77
TWS/WebAdmin
Submit Job
HORIZONT
78
TWS/WebAdmin
Submit Task
HORIZONT
79
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
80
TWS/WebAdmin
Set Run History
HORIZONT
81
TWS/WebAdmin
Previous Production Day Job List
Symphony Date
HORIZONT
82
Green Title Bar
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
83
TWS/WebAdmin
Generate Forecast
HORIZONT
84
TWS/WebAdmin
Forecast Job List
Forecast Date
HORIZONT
85
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
86
TWS/WebAdmin
TWS/WebAdmin Options
HORIZONT
87
TWS/WebAdmin
Auto Refresh
• Set any auto-refresh rate for Plan Lists
• Use the browser Reload button to force a
manual refresh
HORIZONT
88
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
89
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
90
TWS/WebAdmin
Action Buttons: Bottom (Anchored)
HORIZONT
91
TWS/WebAdmin
Date Format
•
•
•
•
•
•
MM / DD / YYYY
MM – DD – YYYY
DD / MM / YYYY
DD – MM – YYYY
YYYY / MM / DD
YYYY – MM – DD
HORIZONT
92
TWS/WebAdmin
Skin
3D Skin
HORIZONT
93
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
94
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
95
TWS/WebAdmin
Display Job Notes
Select Job
Click Notes
HORIZONT
96
TWS/WebAdmin
Adding a Job Note
Click Add Note
HORIZONT
97
TWS/WebAdmin
Adding a Job Note
Note Type
HORIZONT
98
TWS/WebAdmin
Modifying Job Notes
Click to Edit
Click to Delete
HORIZONT
99
TWS/WebAdmin
Workstation Notes
HORIZONT
100
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
101
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
102
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
103
TWS/WebAdmin
Job History Report - Example
HORIZONT
104
TWS/WebAdmin
Job History Report - Output
HORIZONT
105
TWS/WebAdmin
Job History Status - Pie Chart
HORIZONT
106
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
107
TWS/WebAdmin
Job Details Report - Example
HORIZONT
108
TWS/WebAdmin
Job Details Report - Output
HORIZONT
109
TWS/WebAdmin
Job Details Report - Bar Chart
HORIZONT
110
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
111
TWS/WebAdmin
TWS Activity Report - Examples
Select Scale: Day,
Week, Month, Year
Select Style: Bar,
Line, etc.
HORIZONT
112
TWS/WebAdmin
TWS Activity Report – Month Activity Bar Chart
HORIZONT
113
TWS/WebAdmin
TWS Activity Report – Week Accumulated Bar Chart
HORIZONT
114
TWS/WebAdmin
Production Planning Report
• Generates a pre-production report for a
range of future dates
• Shows jobstreams, descriptions, and
estimated run times
HORIZONT
115
TWS/WebAdmin
Production Planning Report - Example
Select Date
Range
HORIZONT
116
TWS/WebAdmin
Production Planning Report - Output
HORIZONT
117
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
118
TWS/WebAdmin
Critical Jobs Report - Example
Select Plan to
analyze
Click to configure
Critical Jobs List
HORIZONT
119
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
120
TWS/WebAdmin
Critical Jobs Report - Output
HORIZONT
121
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
122
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
123
TWS/WebAdmin
Example Custom Report Setup
Enter SQL
Set Title
View Database
Tables
HORIZONT
124
TWS/WebAdmin
Example Custom Report Output
HORIZONT
125
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
126
TWS/WebAdmin
Save Report Example
Report Title and
SQL Query are
filled in
automatically
HORIZONT
127
TWS/WebAdmin
User Defined Reports
User Defined Reports
menu item
HORIZONT
128
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
129
TWS/WebAdmin
Store Report Example
Store Report
HORIZONT
130
TWS/WebAdmin
Store Report Results
Stored Report URL
HORIZONT
131
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
132
TWS/WebAdmin
Send as CSV Example
Send as CSV
HORIZONT
133
TWS/WebAdmin
Open CSV Data Stream
Select Open to
pull data into
Excel
HORIZONT
134
TWS/WebAdmin
View CSV in Excel
HORIZONT
135
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
136
TWS/WebAdmin
Event Monitor
HORIZONT
137
TWS/WebAdmin
Event Configuration
HORIZONT
138
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
139
TWS/WebAdmin
Alert Configuration
HORIZONT
140
TWS/WebAdmin
Adding an Alert
HORIZONT
141
TWS/WebAdmin
Miscellaneous Functions
•
•
•
•
Audit Log Viewer
TWS Logfile Viewer
TWS Mailbox Files
TWS Database Files
HORIZONT
142
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
143
TWS/WebAdmin
Database Audit Log
HORIZONT
144
TWS/WebAdmin
Plan Audit Log
HORIZONT
145
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
146
TWS/WebAdmin
TWS Logfile Example
HORIZONT
147
TWS/WebAdmin
TWS Mailbox Files
HORIZONT
148
TWS/WebAdmin
TWS Database Files
HORIZONT
149
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
150
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
151
TWS/WebAdmin
Conclusion
• Wrap Up
• Questions
• Comments
• Additional Resources:
www.horizont-it.com (Europe)
www.segus.com
(USA)
Email: [email protected]
HORIZONT
152
TWS/WebAdmin
TWS/WebAdmin
The Web Interface for TWS
Thank you very much
for you attention
HORIZONT
Software
153
HORIZONT for Datacenters
Garmischer Str. 8
D- 80339 München
Tel ++49(0)89 / 540 162 - 0
www.horizont-it.com
TWS/WebAdmin