CA MICS Q&R › Q&R Query Improvements

Q&R Query Improvements

Q&R Query has been enhanced in the following areas:

• Query Toolbar
  • Updated to remove obsolete items and reorganize the remaining items logically by function. A new toolbar button has been added for the new Move Query to Production feature.
• Query Status Window
  • Redesigned and improved with many new features and functions including:
    • New toolbar
    • Right click context menu
    • Custom date filters
    • Double-click support to access output
    • Multiline select for delete
    • Hover-over text description for Status Column
  • Now automatically updates the date filter which reflects the current date without closing and reopening the Q&R Query Status Window. The date is checked and automatically updated whenever a query is executed or the refresh button is clicked.
  • Grid rows now contain three more columns. An event column that is a text interpretation of the traffic light icon and columns for JES Job Name and Number. The JES Job Name and Number columns are located on the right-hand side of the grid so they are unobtrusive during normal operation, but available when needed for diagnostic purposes.
• Output Retrieval
  • Now provides right-click context menu support for accessing panel features directly from the output retrieval tree.
  • Now allows double-click to invoke charting directly from the output retrieval tree.
• Query Log (New)
  • Users can now activate a Q&R Query logging feature. Once invoked, the log output that is generated while executing Q&R Query functions allows CA support to investigate configuration, charting, and communications issues.

    Note: This feature should only be enabled at the direction of CA Support.

• Q&R Charting Stacked by Key Performance Enhancements
  • Stacked by Key chart processing performance was improved by using more efficient methods to process data. Improvement varies depending on the overall CSV size and number of charts that are produced.
• Q&R Query Move Query To Production Feature (New)
  • Q&R Query now has a new and improved method for moving. QRQ queries to the mainframe for inclusion in a MICF Job Stream. The user interface now provides a new toolbar button to display a panel that provides the following options:
    • The MICS Complex name where you want to store the query. This value defaults to the complex used to execute the query in Adhoc mode. Change the complex only when the production version executes in a different complex.
    • A two character field that allows you to create the mainframe data set with a user-defined suffix.
    • The target mainframe data set name, where the query is stored, is standardized to sharedprefix.MICS.MQR.PUTPDS. This name is displayed on the panel and is included in the MICSLOG that is generated when the utility is executed.
    • An information button, that when hovered over displays information about how to complete the process on the mainframe through MICF.
    • An option to replace the member if it exists.
  • Once the Move to Production request is submitted, the status can be viewed on the Query Status panel. A MICSLOG is available when the process completes and can be viewed through the Query Status window.