1 HORIZONT TWS/WebAdmin Software for DatacentersThe Web Interface for TWS Web-Based Management and Monitoring of TWS Distributed HORIZONT Software for Datacenters Garmischer Str. 8 D München Tel ++49(0)89 / 1 1 1 1 1 1 1 1 1 1 1

2 Topics TWS/WebAdmin Features Getting Started TWS Database ManagementPlan Monitoring and Management Job Notes Reporting Events and Alerts Miscellaneous Functions

3 TWS/WebAdmin FeaturesWeb Interface to Tivoli Workload Scheduler for Distributed (Unix and Windows) TWS Database Management – composer functions TWS Plan Management – conman functions Event Monitoring Alerting ( and Custom Alerts) Job Notes Reporting: Customizable reports, charts and graphs, flexible SQL query engine

4 Getting Started Logging In TWS/WebAdmin Home Page Basic NavigationHelp Printing Administration Page

5 Logging In Launch web browser, enter the name of the TWS Master in the address bar. Enter user name and password

6 TWS/WebAdmin Home Page

7 Basic Navigation TWS/WebAdmin display consists of 2 framesNavigation frame on left Results frame on right

8 Getting Help Clickable Help Link

9 Online Help Window

10 Printing from TWS/WebAdminClick Print

11 TWS/WebAdmin Administration PageClick link to enter Administration area The user must have Administrator privileges

12 Administration Home PageVarious management, configuration and maintenance options Click here for displaying the WebAdmin system diagnostics

13 Database Management Database Management FunctionsObject Definition Lists Common Database Management Actions Using Filters Backups Drafts Advanced Database Management Actions: Text Edit, Export, Dependent Objects

14 Database Management FunctionsCreate, Modify, and Delete TWS Scheduling Objects Display and Edit object definitions in GUI mode or text mode Save Draft copies of Job definitions Export definitions to files for migration and backups View dependent objects and Notes

15 TWS Database Scheduling ObjectsWorkstations Workstation Classes Domains Applications Jobs Jobstreams Run Cycles Calendars Resources Prompts Parameter Tables Parameters Event Rules Users

16 Workstation DefinitionsClick object name to display definition Action Buttons

17 Workstation Class Definitions

18 Domain Definitions

19 Job Definitions

20 Workload Application Definitions

21 Jobstream Definitions

22 Calendar Definitions

23 Resource Definitions

24 Prompt Definitions

25 Parameter Table Definitions

26 Parameter Definitions

27 User Definitions

28 Event Rule Definitions

29 Run Cycle Definitions

30 Common Database Management ActionsClick on an object name to display its definition (read-only) Standard Actions: Add, Modify, Copy, Delete Display: Show text definitions (multiple objects can be selected) Copy: Duplicate an existing object Unlock: Unlock a locked object in TWS database

31 Example: Display WorkstationClick workstation name to display definition

32 Example: Display Workstation

33 Example: Display Workstation (Text)Select one or more workstations Click Display/Definition

34 Example: Display Workstation (Text)

35 << Year >>Example: Add Calendar Navigation: < Month > << Year >> Click dates to toggle

36 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.

37 Example: Modify Job (Confirmation)Comparison of original an new job data (changes highlighted). Backup copy of original job definition is saved by default

38 Example: Delete JobstreamSelect one or more jobstreams Click Actions/Delete

39 Example: Delete JobstreamBackup copy of jobstream definitions is saved by default

40 Using Filters Click the Filter action button on any Database List page to display filter options, or the “F” shortcut right next to the corresponding menu item 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

41 Database Filter ExampleClick on “F” shortcut to get to the Filter dialog Or click on Filter menu to select “Set Filter” action or directly select an already defined filter from the list bellow

42 Database Filter ExampleSelect the filtering criteria to get all required objects Use either * or @ as the wildcard character… Both work!

43 Database Filter Set Current filter settingUse additional search to get reduced list of the searched objects

44 Database Filters ScreenshotSelect from this list to navigate to the corresponding filter dialog Or click the tab to get (and manage) all defined filters in the category

45 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 Use the backup manager in the Admin section to administrate stored backup files

46 Save Backup Example: Modify CalendarSave Backup Copy option

47 Save Backup Example: Delete PromptSave Backup Copy option

48 Backup AdministrationSelect one or more objects Compare two backup records or compare a backup with the current definition of the object in TWS database

49 Backup AdministrationResult of comparison of a backup with the current definition of the TWS object

50 Drafts Drafts are partial or complete Job definitions that are saved as text files Drafts are not saved to the TWS 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 in TWS security can be configured to have Save Draft permissions. This is valuable when implementing an approval process for TWS scheduling.

51 Save Draft Example Click Save Draft

52 Enter a filename or accept the auto-generated nameSave Draft Example Enter a filename or accept the auto-generated name

53 Saved Drafts Click the Saved Drafts menu item to display all job drafts available. Select a draft from the list, then click Load to open the draft and edit it like a normal job definition.

54 Advanced Database Management ActionsText 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

55 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.

56 Dependent Objects Example 1Select a workstation and then Disiplay/Membership

57 Dependent Objects Example 1Domain membership for workstation PC90 Workstation Class membership for workstation PC90

58 Dependent Objects Example 2Select one or more jobs Click Display -> Dependent Objects

59 Dependent Objects Example 2Jobstream membership for job PC90#TWA_SYNTAX_CHECK Job/Jobstream dependencies on job PC90#TWA_SYNTAX_CHECK

60 Plan Monitoring and ManagementBasic Plan Monitoring Plan Management Actions Filters, Searching Submitting Ad-Hoc Jobs and Jobstreams Viewing Previous Production Days Creating Forecasts

61 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

62 Click Workstation name to view Jobstreams scheduled on itPlan Workstation List Click Workstation name to view Jobstreams scheduled on it Action Buttons

63 Plan Domain List

64 Click Jobstream name to view its Jobs InstancesPlan Jobstream List Click Jobstream name to view its Jobs Instances

65 Click Job name to view OutputPlan Job List Click Job name to view Output

66 Plan Resource List

67 Plan Prompt List

68 Plan File List

69 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

70 Job Output

71 Customize Plan List LayoutThe 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

72 Custom Layout Example – Plan JobstreamsClick Settings/Layout to customize

73 Custom Layout Example – Plan JobstreamsSelect 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

74 Custom Jobstreams Layout Example – Results

75 Plan List Sorting, Instant SearchClick 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. Instant searching of results

76 Plan Management ActionsAll 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

77 Using Filters Click the Filter action button on any Plan List page to display filter options Current filter settings are displayed in the Plan Lists page info header Click Clear Filter on filter page to clear filter settings Filter settings can be saved, restored, and bookmarked

78 Plan Filter Example

79 Load Filter Example Right click on the filer name, select “Add to Favourite” to create the bookmark

80 Set Filter Example

81 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

82 Plan Filters ScreenshotSelect filter type from this list to set up a new filter Click on tab to manage saved filters of corresponding category

83 Submitting Jobs and JobstreamsSubmit 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

84 Submit Jobstream

85 Submit Job

86 Submit Task

87 Viewing Previous Production DaysSet 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

88 Set Alternate Plan

89 Previous Production Day Job ListSymphony Date Green Title Bar indicating alternate plan

90 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)

91 Generate Forecast

92 Forecast Job List Forecast Date

93 TWS/WebAdmin Options Auto-Refresh Display Job Logs: Single / MultipleAfter Actions GoTo Action Buttons: Top / Bottom, Anchored Date Format, Skin Display filter before listing Window title Disable Job Statistics Etc…

94 TWS/WebAdmin Options

95 Auto Refresh Set any auto-refresh rate for Plan ListsUse the browser Reload button to force a manual refresh

96 Display Job Logs: Single / MultipleSingle (default) displays only one stdlist when a job’s output is viewed Multiple displays all stdlists for a job (EVERY and RERUN jobs)

97 Action Buttons: Top / Bottom, AnchoredBottom : Action buttons are anchored in a separate frame at the bottom of the page so they are always visible Top : Action buttons are anchored in a separate frame at the top of the page so they are always visible

98 Action Buttons: Top

99 Date Format MM / DD / YYYY MM – DD – YYYY DD / MM / YYYY

100 Red skin – useful for indicating privileged user accounts

101 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

102 Creating and Managing Job NotesTo 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

103 Display Job Notes Select Job Click Display/Notes

104 Adding a Job Note Click Add Note

105 Adding a Job Note Note Type

106 Modifying Job Notes Click to Edit Click to Delete

107 Workstation Notes

108 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 Reports can be generated and sent to Microsoft Excel in CSV format

109 Standard TWS/WebAdmin ReportsJob History Report Job Details Report TWS Activity Report Production Planning Report TWS Database Report Cross Reference Report Critical Jobs Report

110 Job History Report Shows historical job execution informationSelect date range, job / jobstream / workstation names, job status Sort by date, job name, status, etc. Status Pie Chart

111 Job History Report - Example

112 Job History Report - Output

113 Job History Status - Pie Chart

114 Job Details Report Shows details and statistics for a specified jobPresents a view of historical execution time in bar chart or line chart

115 Job Details Report - Example

116 Job Details Report - Output

117 Job Details Report - Bar Chart

118 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

119 TWS Activity Report - ExamplesSelect Scale: Day, Week, Month, Year Select Style: Bar, Line, etc.

120 TWS Activity Report – Month Activity Bar Chart

121 TWS Activity Report – Week Accumulated Bar Chart

122 Production Planning ReportGenerates a pre-production report for a range of future dates Shows jobstreams, descriptions, and estimated run times

123 Production Planning Report - ExampleSelect Time Range

124 Production Planning Report - Output

125 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

126 Critical Jobs Report - ExampleSelect Plan to analyze Click to configure Critical Jobs Lists

127 Manage Critical Jobs ListIt is possible to define separate lists for each group, application, region, etc. Add a new Critical Job

128 Critical Jobs Report - Output

129 Creating Custom ReportsTWS/WebAdmin provides access to TWS database Additional data is stored in TWS/WebAdmin database Customized reports from both databases are created with standard SQL queries Basic understanding of SQL syntax and the TWS/WebAdmin table structure is required

130 Example Custom Report Objective: Create a report that lists all jobs with command that contains the text “conman” SQL Statement: SELECT WKC_NAME, JOD_NAME, JOD_TASK_STRING FROM MDL.JOD_JOB_DEFINITIONS JOD JOIN MDL.WKC_WORKSTATION_CLASSES WKC on JOD.WKC_ID = WKC.WKC_ID WHERE JOD_TASK_STRING LIKE '%conman%'

131 Example Custom Report SetupView Database Tables Enter SQL Customize Report Title

132 Example Custom Report Output

133 Saving Customized ReportsSave 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

134 Report Title and SQL Query are filled in automaticallySave Report Example Report Title and SQL Query are filled in automatically

135 User Defined Reports menu item

136 Storing Reports Storing a report saves the raw report output to a globally available URL Contents of stored reports are static URL can be ed or posted as a link on an external web page

137 Store Report Example Store Report

138 Store Report Results Stored Report URL

139 Microsoft Excel IntegrationSend 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

140 Send as CSV Example Send as CSV

141 Select Open to pull data into ExcelOpen CSV Data Stream Select Open to pull data into Excel

142 View CSV in Excel

143 Events and Alerting TWS/WebAdmin Event Monitor collects events from TWS Job Abend, Jobstream Stuck, CPU Link Down, etc. Custom events and severities Alerts: and custom commands

144 Event Monitor

145 Event Configuration

146 Alerts TWS/WebAdmin alerts generate notification for events such as Job Abends Wildcards are permitted Multiple addresses can be entered, separated by commas Enter custom text in the Text field or leave blank to use the default format Instead of sending , an alert can execute a custom command

147 Alert Configuration

148 Adding an Alert

149 Miscellaneous FunctionsAudit Log Viewer TWS Logfile Viewer TWS Mailbox Files TWS Database Files

150 Audit Log Viewer Displays TWS Database and Plan Audit LogsAuditing must be enabled in the TWS globalopts file Entries can be filtered Send as CSV displays log entries in MS Excel

151 Database Audit Log

152 Plan Audit Log

153 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

154 TWS Logfile Example

155 TWS Mailbox Files

156 Other Features Execute TWS/WebAdmin Reports from command line (scheduling reports now possible) Extended TWS Event Type: JOB_LATE Extended filtering possibilities allowing to make complex criteria expresions Instant searching in data results Full control of user permissions, global filters, and saved reports Several maintenance utilities in TWS/WebAdmin Administration

157 Conclusion Wrap Up Questions CommentsAdditional Resources: (Europe) (USA)

158 HORIZONT TWS/WebAdmin Software for DatacentersThe Web Interface for TWS Thank you very much for you attention HORIZONT Software for Datacenters Garmischer Str. 8 D München Tel ++49(0)89 / 1 1 1 1 1 1 1 1 1 1 1