CA MICS Resource Management Q&R Workstation Release 12.9.00 Readme

1.0 Welcome

Welcome to CA MICS® Resource Management Q&R Workstation Readme. This document contains information about operating system support, maintenance fixes, and contacting Technical Support.

2.0 Operating System Support

The following operating systems are supported:

• Windows Server 2012
• Windows 2008 R2
• Windows 8 Enterprise
• Windows 8.1 Enterprise
• Windows 7 Enterprise
• Windows Vista Professional
• Windows Vista Enterprise

3.0 System Requirements

This release can be run in a TCP/IP v4 or TCP/IP v6 environment.

3.1 Before You Install

Before you install the product, review the System Requirements, Client and Server Requirements, and Installation Steps in the Getting Started guide. To verify that you are installing the latest available build connect to CA Support Online.

CA MICS Prerequisites

BAS7767 is a prerequisite for CA MICS Q&R Workstation 12.9.00.

CAICCI-PC Configuration Requirements

This version of Q&R Workstation requires CAICCI-PC r14.0.1 (32 bit).

CA MICS Q&R Workstation Upgrade Requirements

The CA MICS Resource Management Q&R Workstation r12.9 installation process can upgrade Q&R Workstation releases 12.7 or 12.8 to release 12.9.

3.2 After You Install

Installation Verification

After you install Q&R r12.9, perform the following installation verification procedures:

1. Verify that your Windows User ID and Domain Name are defined in the Q&R Distributed Server Security database.
2. Verify that the Q&R Distributed Server system name is defined in the sharedprefix.MICS.PARMS(MQRPARMS) file.
3. Run a Build/Refresh Meta Database from the Q&R Distributed Server Admin application.
4. Run an existing query or build and run a new query.
5. View the output through Output Retrieval and Charting.
6. When upgrading from Q&R 12.7, review the Upgrade Considerations for RMWSLoad and RMWSPare in the Upgrade Considerations section of this document and perform recommended actions.
7. Run RMWSLoad to publish distributed content.

4.0 General Considerations

Installing Q&R Workstation 12.9 provides the following benefits:

4.1 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 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 dataset 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 when 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.
  • The new method also preserves view information for automatic synchronization with production output eliminating the need to manual copy VDF files the first time that the report is published to Q&R Web Reporting.

4.2 Q&R System Info Improvements

Q&R System Info Utility has the following improvements.

• System Security Tab (new)

  This new tab includes information about the currently logged in user. This tab also provides answers to the following security and process-related questions that are often the root cause of Q&R Administration Utility execution failures:

  • Is the User in Admin Group?
  • Is the Application “Run as Admin”?
  • Is the Process Elevated?
  • What is Process Integrity Level
• Windows Information Tab

  Machine Name added.

4.3 Q&R Distributed Server Changes

The Q&R Distributed Server has been updated in support of changes to Q&R Query and Q&R Distributed Server Administration.

4.4 Q&R Distributed Server Administration Improvements

Q&R Distributed Server Administration has been enhanced with new features and support for the changes to the underlying utilities.

• A new Job Status window was added to provide visibility of jobs that the Q&R Distributed Server starts. Job status retention defaults to 60 days and can be changed on the Q&R Distributed Server Configuration panel.
• Logs of active Q&R Mainframe Servers can be viewed from the Active Q&R Mainframe Servers window or through the Menu Bar option View/Mainframe Server Logs. This feature allows Q&R administrators who do not have direct mainframe access view the mainframe server log directly from Q&R Distributed Server Administration.
• Utility log options Append/Overwrite and Append Timestamp have been removed. The utilities now always process using the overwrite and append timestamp options. When Multi-run jobs are exported, instructions are generated to overwrite on the first run and append subsequent logs (just like 12.8). With Q&R 12.9, the base log file is overwritten on every run. Thus you can click the Log button to return the log generated by the most recent run. In addition, a time stamped version of the log is always created. To access the time-stamped version of this log or to view the results of prior executions, click the file folder icon in the log file section of the utility panel.
• Utility jobs that are exported to a batch file are now timestamped correctly in US and non-US windows environments.
• Q&R Publish Output to Q&R Web Reporting User Interface panel has been updated to:
  • Allow Remove Output (RMWSPare) jobs to invoke automatically after RMWSLoad completes.
  • Reverse the order of height and width on the image properties tab. The screen now displays dimensions in the expected order (Width x Height).
• Administration Utilities (RMWSLoad, RMWSPare, MQRMeta)
  • Q&R Publish Output to Q&R Web Reporting Utility (RMWSLoad), Q&R Build/Refresh Meta Database (MQRMeta), and Q&R Remove Output (RMWSPare) provide more return code processing to provide return codes that mode accurately reflect the severity of errors that are encountered during processing. The return code is printed in the log and displayed in the Q&R Distributed Server Administration Utilities completion window. This feature is also available for exit code processing in batch.

4.5 MICS Query Library

The CA MICS Query Library has been updated to include several new reports. This library includes over 50 Q&R Workstation sample queries that process and report on data from the DB2, CICS, IDMS, IMS, MQS, RMF, SMF, TAPE, VCA, VM, and WEB components.

The sample queries are designed to provide "out-of-the-box" value for CA MICS customers. The queries generate useful graphics that show resource usage, workload activity, processor configuration, and other metrics that are important to modern data centers.

The following queries are new in CA MICS 12.9.

• VCA Component:
  • VCACIS-VCA CI Splits.QRQ
  • VCACIS-VCA Daily Top 100 CI Splits.QRQ
  • VCAT2C-VCA Daily Top 20 STOCLASS Space Used.QRQ
  • VCAVOL-VCA VOLSER Use Report.QRQ
• IMS Component:
  • IMSDAT - IMS Daily Top 10 Workloads.QRQ
  • IMSDTR - IMS Daily Tran Count and Response Pct.QRQ
  • IMSDTT - IMS Daily Top 10 Transactions.QRQ

The following queries have been updated in CA MICS 12.9.

• RMF Component:
  • RMFWCE - CPU MF Workload Characterization IPU Level.QRQ
  • RMFWCL - CPU MF Workload Characterization LPAR Level.QRQ
  • RMFWCT - CPU MF Workload Characterization CPUTYPE Level.QRQ
  • RMFZIS - Daily zIIP Engine Use and Demand by Service Class.QRQ

Note: For any of these queries, obtain the updated query from the Q&R Query Library and replace your older query with the updated version.

For on-demand use, open the report from the CA MICS Query Library, update it for your environment and replace the version that you run locally through Q&R Query.

To replace a production report:

Follow these steps:

1. Open the report from the CA MICS Query Library.
2. Update it for your environment.
3. To move it to the mainframe, use the Move Query To Production feature.
4. On the mainframe, replace the existing MICF Inquiry in the associated User Reporting or Production Reporting Job Stream.

Note: For more information, see the Query Library Guide and the Q&R Administration Guide.

5.0 Problems Resolved in This Maintenance

The following problems have been corrected with this maintenance:

6.0 Database Conversions

This release contains changes to tables in the MQRUtility.accdb and MQROptions.accdb. The tables are updated automatically during the installation process.

After the conversion, the message MQR8011I: *** MQRDBCVTr129 processing complete. Program Closing. is displayed in the status bar.

7.0 Installation Considerations

Note: See the Installing Q&R Workstation chapter of the Getting Started guide for documentation of the installation processes where:

• No prior Q&R Workstation version exists
• An existing Q&R Workstation environment is being upgraded

The upgrade process documentation provides for an orderly phased migration of a production environment and optional testing of Q&R Workstation components during the process.

During the installation of Q&R, Microsoft .NET Framework 4.5 is installed to support application upgrades. If a previous installation is not detected, the Framework installation occurs automatically before the Q&R installation begins.

If you are prompted, install CAICCI-PC (Server Only or Full Install) which is required for Q&R Distributed Server components. CAICCI-PC can be configured during the Q&R Install or after the install completes. Instructions to install and configure CAICCI-PC are included in the Q&R Workstation Getting Started guide.

Installation Considerations for Q&R r12.9 in a Windows 7 or Windows 8 Environment

If you schedule a batch execution of the Q&R Distributed Server Administration utilities:

• RMWSLoad
• MQRMeta
• RMWSPare

Select the Run with Highest Privileges option in the security options section of the task’s properties. This selection verifies that the utilities will run with the privileges necessary to complete successfully.

Q&R Query (.QRQ) Considerations

Q&R queries that were created with Q&R r12.6 and above can be run with Q&R Release 12.9.

Notes:

• Queries are not fully backward compatible. After a Q&R query is updated using Q&R r12.8 or higher, query date selection criteria reverts to cycles if the query is opened in version 12.7 or lower.
• If you are doing a phased upgrade of Q&R, be sure that you have a backup of your Q&R queries that you can use when you run the prior version.

Q&R Security Considerations

• Define the Q&R Query users in Q&R Distributed Server Security Administration when Q&R Query is running on a computer other than the Q&R Distributed Server.

  Q&R authenticates users through Windows Domain Authentication. The Windows User ID and Domain Name for each user must be entered in Q&R Distributed Server Security Administration with appropriate Q&R access settings for each user. For more information about Q&R Distributed Server Security Administration, see the Administration Guide.

8.0 Upgrade Considerations

This section describes upgrade considerations specific to this release.

Only use CA MICS Resource Management Q&R Workstation r12.9 to upgrade Q&R Workstation versions 12.7 or higher.

Upgrade Considerations for the Publish Output to Q&R Web Reporting (RMWSLoad) Utility

Q&R Web Reporting 12.9 supplies code to replace the existing java script, html, and cascading style sheets that were used in Q&R 12.7. When customizing your Q&R Web Reporting environment, analyze how this new code affects your reports and adjustment accordingly before publishing web content using Q&R 12.9.

Note: The (RMWSLoad) utility builds different indexes in a new format. The new index files (jindex.txt and jkeys.txt) are smaller and load faster than those files used in 12.7 (outputindex.txt and bcf.txt). RMWSLoad automatically converts the existing files to the new format in any report directory it publishes to. This operation could make the first RMWSLoad run in Q&R 12.9 slightly longer, but subsequent RMWSLoad runs are slightly faster than they were in Q&R 12.7.

Information about RMWSLoad upgrade behaviors after Q&R 12.9 is installed:

• When an RMWSLoad is executed without publishing files, new web pages are loaded but indexes are not converted.

  Your Q&R Web Reporting web site executes with the new 12.9 capabilities but might run slower than expected.

• When an RMWSLoad is executed and a new report is published:
  • New web pages are loaded
  • A jkeys.txt is created for the new report instance
  • All existing bcf.txt files in the report’s subordinate instance directories are converted to jkeys.txt
  • A new jindex.txt is created to replace the existing outputIndex.txt
• After jkeys.txt and jindex.txt files exist, the bcf.txt and outputindex.txt are no longer necessary. However; RMWSLoad does not delete these files. (These files could facilitate a recovery/program fix if for some reason the conversion is unsuccessful.)

  Your Q&R Web Reporting web site builds the display for each report that is based on jindex.txt (if available) or outputindex.txt.

  After output has been published for every report on your web site, your environment is converted.

  Note: The existing bcf.txt files remain in place until the output instance is removed using RMWSPare. Also, the existing outputindex.txt will remain until the report is removed from the Q&R Web Reporting environment or a future version of Q&R removes it.

Upgrade Considerations for the Remove Output Utility (RMWSPare)

• The Remove Output Utility (RMWSPare) can be run on output paths that are built with the 12.7 indexes (outputindex.txt and bcf.txt) or the 12.9 indexes (jindex.txt and jkeys.txt).
• The RMWSPare utility does not convert bcf.txt files to jkeys files (only RMWSLoad converts these files.).
• When RMWSPare runs on a report directory that contains jindex.txt, it removes the specified files and rebuilds the index (jindex.txt) based on the jkeys files in the subordinate instance directories.
• If RMWSLoad has not published output to the report directory, RMWSPare removes the specified output and rebuilds the index (outputIndex.txt) based on the bcf.txt files in the subordinate instance directories.

Upgrade Considerations for Moving Queries to Production

In Q&R 12.8 moving a query to production was done by opening a query, selecting the Run option, selecting a Save Q&R Query to PDS template, and selecting Ok. The location where the query is saved is determined by the value of the PRDPDS parameter in sharedprefix.MICS.PARMS(MQRUTAB). With Q&R 12.9 this functionality is obsolete and has been replaced by a new Move Query to Production feature. Move Query to Production is now a separate function with its own toolbar icon. The location of the mainframe data set used to store queries is now predefined in sharedprefix.MICS.MQR.PUTPDS. The member name is the query name followed by an optional suffix. Clicking the OK button submits the QRPUTPDS template, but this template now invokes new MQRPUTQY program that handles the save. To complete the operation successfully, the Q&R user who performs the Move Query to Production function, must have WRITE access to sharedprefix.MICS.MQR.PUTPDS for the complexes where he saves the queries.

Notes:

• With this new methodology, the PRDPDS parameter in MQRUTAB is obsolete and can be removed from MQRUTAB once all Q&R Client machines have been upgraded to Q&R Query 12.9.
• CA MICS MICF Automatic Query generation panels have been updated to default the input data set name to sharedprefix.MICS.MQR.PUTPDS.

9.0 Documentation

Updated guides are available at http://ca.com/support.

To view the PDF files, you must download and install the Adobe Reader from the Adobe website if it is not already installed on your computer.

To view the documentation

1. Click http://ca.com/support.

   The CA Support page appears.

2. Click Documentation.

   The Documentation page appears.

3. Select CA MICS Resource Management 12.9.00-US English under Find a Product Documentation Bookshelf and click Go.

   The CA MICS Resource Management 12.9 Bookshelf appears.

4. Click Q under All Documentation or Q&R Workstation Guides under By Category to view the HTML pages or download the PDFs of Q&R Workstation documentation.

10 Contact CA Technologies

Contact CA Support

For your convenience, CA Technologies provides one site where you can access the information that you need for your Home Office, Small Business, and Enterprise CA Technologies products. At http://ca.com/support, you can access the following resources:

• Online and telephone contact information for technical assistance and customer services
• Information about user communities and forums
• Product and documentation downloads
• CA Support policies and guidelines
• Other helpful resources appropriate for your product

Providing Feedback About Product Documentation

If you have comments or questions about CA Technologies product documentation, you can send a message to techpubs@ca.com.

To provide feedback about CA Technologies product documentation, complete our short customer survey which is available on the CA Support website at http://www.ca.com/docs.

Copyright © 2014 CA. All rights reserved. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.