• Scheduled Webinars »

• Listen to Previous Webinars »

• The DB2 Education Webinar Series »

 »

View DB2® 9 for z/OS
Catalog Tables »

How does it work &

lower IT software costs? »

Tune

Your DB2!

Visit SWONZ

Services

    zAPX - zSystems

    zAPX for DB2 for z/OS - a New Generation DB2 SQL Access      Path Rating and Comparison Tool.  

Managing program bind, rebind and the resulting access path changes can be a very difficult task for developers and DBAs. And as your number of programs, subsystems, and developers increases, the task gets even more unmanageable,  

• are you concerned about bad SQL access paths resulting from  REBINDs?
• are you tired of using GUI products that were written for  Linux/Unix/Windows, not fully supporting z/OS?
• have you been unimpressed by the limited functionalities of an  ISPF 3270 screen?
• would you like to be able to compare access paths and  statistics of different DB2 subsystems on a single screen?
• can you pre-check the access paths resulting from a new DB2  optimizer version before migrating your production environment?
• have you ever tried to lead a colleague to a specific result screen  in a product in ISPF?
  
  

If these issues sound all too familiar to you, then it’s time to take a look at zAPX.

zAPX explains SQL and compares access paths of static and dynamic SQL for the purpose of:

• Application Development
• Quality Assurance
•  Securing REBINDs in the maintenance process
• Securing dynamic SQL and REBINDS during migration to a
      new version of DB2

zAPX provides a Batch component for mass analysis as well as a web-based graphical user interface for displaying batch results, ad hoc

explain, catalog statistics, browsing DB2 catalog tables and more.

Prerequisites

zAPX graphical user interface is web-based; it may run on a central web-server (e.g., Apache). No other client software is needed other than a web browser.

zAPX supports all common browsers, such as:

• Microsoft IE 7 and above
• Firefox 3 and above
• Safari 3 and above
• Google Chrome
• Opera 10 and above.

zAPX supports DB2 Version 8 and above.

ZAPX Product Highlights

• Access Path Comparison and Rating
  ­­-Granular comparison considering statistics (e.g., TS scan
  on small table vs. TS scan on large table, non-matching index
  scan on large index vs. small index, etc.)
• Classification of changed access path (e.g., degraded, improved, unchanged)
• Explain with controlled product authority
• Search facility for access path changed paradigm, for example:
  -Show all SQL with a changed join sequence.
  -Show all SQL changing from an index scan to a table space
  scan.
  -And more.
• Dynamic highlighting of Access Path Differences in the GUI
  -In a side-by-side comparison of access paths mouse-over effects are used to easily identify access path differences even
  in complex access paths.
• ZAPX graphically correlates Views, Aliases and Synonyms to
  Plan_Table
  -Often the object shown in the Plan_Table is not the one coded
  in the SQL statement (e.g., Aliases, Synonyms, Views)
  -zAPX highlights the corresponding object in the SQL Text and the Plan_Table
• Single Point of Control for all DB2 systems
  -The GUI provides a single point of control for all of your DB2
  subsystems
  -It can even show access paths and statistics from two different subsystems in one screen
• Worklists
  -Worklists allow you to save any screen URL to your personal work list or to share screen URLs with colleagues
• SQL Prototyping and Explain
  -See as many different versions of the SQL you’re working on, together with the corresponding access paths, as fit on  your screen
• Dynamic Statement Cache Capture and Analysis
• Package and Access Path History including online comparison
• DB2 Catalog Reference and Browser
• Search facility for:
  -DB2 Objects
  -Packages
  -SQL
  -SQL using specific objects (e.g., indexes)
  -Access Types (e.g. Tablespace scans)
• Query the DB2 catalog
• Query any DB2 table (SQL may be generated online)
   

Contact Softwareonz for more information on this product  »