IBM iDoctor iSeries Job Watcher: Advanced Performance Tool

Book description

This IBM Redbooks publication is intended for those familiar with most of the IBM-provided iSeries performance tools that are generally available through the i5/OS operating systems commands and iSeries Navigator interfaces and the additional-cost Performance Tools for iSeries, 5722-PT1, licensed program.

iDoctor for iSeries is a set of software performance analysis tools and associated services that extend your ability to evaluate the health of your iSeries-based system by gathering detailed information and providing automated, graphical analysis of this data. One of these tools, Job Watcher, is the key next-step advanced tool for analyzing detailed performance data.

This book:
- Gives an overview of Job Watcher and most other IBM-provided iSeries performance measurement and management tools.
- Describes the components of performance and how Job Watcher provides access to detailed performance data.
- Provides examples of Job Watcher functions and its GUI in three applications: traditional RPG, SQL, and Java.
- Provides Job Watcher collected data file and field definitions, and SQL query examples of this data beyond Job Watcher's array of graphical reports and drill-down information.

This book's objective is to enhance the performance analyst’s proficiency in using Job Watcher as a key tool in the performance analysis tool kit.

Table of contents

  1. Notices
    1. Trademarks
  2. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  3. Chapter 1: iDoctor for iSeries Job Watcher positioning
    1. Job Watcher view of IBM-provided iSeries performance tools
    2. Components of performance
    3. System-level tools
      1. Real-time performance tools
      2. WRKSYSSTS command
      3. WRKACTJOB command
      4. WRKDSKSTS command
      5. WRKSYSACT command
      6. Collection Services
      7. Management Central
      8. Collect performance trace data
      9. Performance Explorer
      10. Database Monitor for iSeries
      11. SQL performance monitors
      12. iDoctor for iSeries suite of products
    4. Performance tools for previously collected data
      1. Performance Tools for iSeries Licensed Program product (5722-PT1)
      2. Performance Management for iSeries
      3. Performance Explorer
    5. Using the system available performance tools
    6. Expanded Job Watcher overview
  4. Chapter 2: Overview of job waits and iDoctor for iSeries Job Watcher
    1. Simplified view of running and waiting
    2. Job Watcher terminology
    3. Level set on wait conditions
    4. The mysteries of waiting
    5. Are waits bad?
    6. Detailing waits
    7. iDoctor for iSeries Job Watcher
    8. Waiting point groupings (wait buckets)
      1. Do wait buckets defeat the purpose of many block points?
      2. Job Watcher wait points (ENUMs) and wait buckets
    9. LIC queuing primitives and more granular wait points
      1. Disclaimer
      2. Bucket 1: Dispatched Time (previously referred to as CPU)
      3. Bucket 2: CPU queuing
      4. Bucket 3: Total block time
      5. Bucket 4: Reserved
      6. Bucket 5: DASD (page faults)
      7. Bucket 6: DASD (non-fault reads)
      8. Bucket 7: DASD space usage contention
      9. Bucket 8: Idle/waiting for work
      10. Bucket 9: DASD writes
      11. Bucket 10: DASD (other reads or writes)
      12. Bucket 11: DASD operation start contention
      13. Bucket 12: Mutex/Semaphore contention
      14. Bucket 13: Journal serialization
      15. Bucket 14: Machine level gate serialization
      16. Bucket 15: Seize contention
      17. Bucket 16: Database record lock contention
      18. Bucket 17: Object lock contention
      19. Bucket 18: Other waits
      20. Bucket 19: Main storage pool overcommitment
      21. Bucket 20: Java user (including locks)
      22. Bucket 21: Java JVM
      23. Bucket 22: Java (other)
      24. Bucket 23: Socket accepts
      25. Bucket 24: Socket transmits
      26. Bucket 25: Socket receives
      27. Bucket 26: Socket (other)
      28. Bucket 27: IFS pipe
      29. Bucket 28: IFS (other)
      30. Bucket 29: Data queue receives
      31. Bucket 30: MI queue (other)
      32. Bucket 31: MI wait on events
      33. Bucket 32: Abnormal contention
    10. Management Central’s use of wait bucket mapping
  5. Chapter 3: Getting started
    1. Enhancements to Job Watcher at V5R3M0
      1. The collection engine
      2. GUI
      3. Naming
    2. How to obtain Job Watcher
    3. Starting a Job Watcher collection
      1. Connecting to your system
      2. Access Job Watcher
      3. Starting the Job Watcher collection wizard
      4. Data collection options
      5. Job and task options
      6. More on selecting specific jobs and tasks (1/2)
      7. More on selecting specific jobs and tasks (2/2)
      8. Ending Options window
      9. Job Watcher Wizard summary
      10. Active Job Watcher
    4. Stopping a Job Watcher collection
    5. Viewing Job Watcher data
      1. Job Watcher view
      2. iDoctor preferences
      3. Reports and graphs: Example 1 (1/2)
      4. Reports and graphs: Example 1 (2/2)
      5. Graphs and reports: Example 2
      6. Tabs in the Interval Details window (1/3)
      7. Tabs in the Interval Details window (2/3)
      8. Tabs in the Interval Details window (3/3)
      9. Additional Job Watcher graphs (1/2)
      10. Additional Job Watcher graphs (2/2)
  6. Chapter 4: Analysis example: traditional batch ILE RPG application
    1. Analyzing the problem
    2. Activation group usage
  7. Chapter 5: SQL, call stack, and journal analysis examples
    1. Our example application and preliminary performance analysis
    2. SQL analysis
      1. Getting started
      2. Viewing an active SQL statement using the GUI
      3. Data Viewer
      4. Finding jobs running most SQL statements
    3. Call stack analysis for task counts
      1. Produce the resolved call stack file
      2. The call stack for jobs with active SQL statements
      3. Finding user programs running active SQL statements
      4. Finding any SQL-related or database-related system activity
    4. Journal analysis
      1. No journal caching (1/2)
      2. No journal caching (2/2)
      3. Journal caching
  8. Chapter 6: Analysis example: Java application
    1. Two problem scenarios
    2. CPU “misusage”
      1. Job Watcher
    3. Heap growth
      1. Heap Analyzer
  9. Appendix A: Installing and uninstalling Job Watcher details
    1. Installation requirements
    2. Installing Job Watcher
    3. Uninstalling Job Watcher
      1. Server side
      2. Client side
  10. Appendix B: Database files created by Job Watcher
    1. Job Watcher terminology
    2. Files created by every Job Watcher collection
    3. Files created only when call stack information is specified in a Job Watcher collection
    4. Files created only when SQL information is specified in a Job Watcher collection
    5. Files created only when activation group information is specified in a Job Watcher collection
    6. Files created only when sockets information is specified in a Job Watcher collection
    7. Description of ENUM to queueing bucket identifier mappings
    8. Description of ENUM to queueing bucket mappings
    9. Getting started writing queries over Job Watcher collection data
    10. The master file QAPYJWTDE for jobs, threads, and tasks
    11. Status file QAPYJWSTS
    12. Job file QAPYJWPRC
    13. Task dispatchable unit priorities scheme
  11. Appendix C: Querying and graphing tips for Job Watcher
    1. Querying Job Watcher data
    2. Query definition interface
      1. Accessing the query definition interface
      2. Viewing your query
      3. Saving your new query definition
      4. Working with query definitions
    3. SQL Query view
      1. Accessing the SQL Query view
      2. Changing field (column) headings in your query results
    4. Graph views
      1. User-defined graphs
  12. Appendix D: Overview of Job Watcher 5250 commands
    1. Job Watcher 5250 commands
    2. WCHJOB command
      1. WCHJOB parameters
    3. CPYJWCOL command
      1. CPYJWCOL parameters
    4. DLTJWCOL command
      1. DLTJWCOL parameters
    5. FTPJWCOL command
      1. FTPJWCOL parameters
    6. RSTJWCOL command
      1. RSTJWCOL parameters
    7. SAVJWCOL command
      1. SAVJWCOL parameters
    8. ADDPRDACS command
    9. RTVSTKDTA command
      1. tRTVSTKDTA parameters
    10. Automatically submit a Job Watch
  13. Appendix E: Job Watcher advanced topics
    1. Collection specification tips
      1. Interval size
      2. Ensure job names are captured for all jobs on the system
      3. Collect data as fast as possible?
    2. The Job Watcher collection process in detail
      1. Task count state changes
      2. Waits that span multiple intervals
    3. Job run/wait profile: how to fill in blank intervals
      1. Before and after graphs for filled blank interval support
      2. Job Watcher limitations
  14. Glossary
  15. Related publications
    1. IBM Redbooks
    2. Online resources
    3. How to get IBM Redbooks
    4. Using the SQL examples in this redbook
    5. IBM Support and downloads
    6. IBM Global Services
  16. Index (1/2)
  17. Index (2/2)
  18. Back cover

Product information

  • Title: IBM iDoctor iSeries Job Watcher: Advanced Performance Tool
  • Author(s): Jim Cook, Sandi Chromey, Tom Edgerton, Debbie Hatt
  • Release date: March 2005
  • Publisher(s): IBM Redbooks
  • ISBN: None