Appendix C. INTERFACE WITH CA MICS Q&R WORKSTATION


The CA MICS Capacity Planner provides an interface to the
CA MICS Q&R WorkStation, a windows-based product that
provides advanced graphics and reporting facilities on your
PC.

Once you enable the interface, you can use the CA MICS Q&R
WorkStation product to generate presentation graphics and
perform further analysis of the data using various
tools and facilities provided by the product, including:

o Build queries to extract data from the shared capacity
  database to your PC.

o Build presentation graphics in Microsoft Excel - the
  CA MICS Q&R WorkStation delivers a reporting facility that
  automatically generates charts using CA MICS-provided
  Excel macros.  For advanced Excel users, the reporting
  facility allows you to further analyze and enhance the
  presentation of the data using the extensive features and
  functions in Excel.

o Publish your reports on the intranet for fast, one-time
  delivery to your users across the enterprise.  CA MICS Q&R
  WorkStation enables you to view the data in graphical and
  tabular format via a web browser.

Implementation
--------------
Perform the following steps to implement the interface
between the CA MICS Capacity Planner and CA MICS Q&R
WorkStation.

Note the interface allows you to access data in the shared
capacity database only.  Therefore, you must move data from
the private database to the shared database if you wish to
access the private files.

  ____ 1.   Locate the member CAPMDB in
            sharedprefix.MICS.CNTL.  If the job exists,
            proceed to Step 3.  Otherwise, perform Step 2
            to generate the job.

  ____ 2.   Edit sharedprefix.MICS.PARMS(JCLGENUC) so that it
            contains the following:

            CAPMDB

            Submit the job in
            sharedprefix.MICS.CNTL(JCLGENUC).  Ensure that
            there are no error messages in MICSLOG or
            SYSTSPRT, that the MICSLOG contains the normal
            termination message, BAS10999I, and that the job
            completes with a condition code of zero.

  ____ 3.   Submit the job in
            sharedprefix.MICS.CNTL(CAPMDB).  Ensure that
            there are no error messages in MICSLOG or ISPLOG
            and that the job completes with a condition code
            of zero.

The CAPMDB job builds a meta file that describes the content
of the shared capacity database.  As such, the CAPMDB job
must be rerun whenever the content of the shared capacity
database has been altered.  Otherwise, the information in
CA MICS Q&R WorkStation will be inaccurate.

The meta file built by CAPMDB is stored in
sharedprefix.MICS.CAPACITY.  It is used as input to the meta
database build process in CA MICS Q&R WorkStation.