4. Operation › 4.5 Integrating CA MICS Data to NSM › 4.5.1 Integration with NSM Chargeback

4.5.1 Integration with NSM Chargeback

NSM Chargeback provides a chargeback and resource utilization
tracking component that records resource consumption by user
for each system utilized.  It maintains budget information
and can be used to generate invoices or charge reports.

The support for NSM Chargeback allows CA MICS data to be
charged through NSM Chargeback as an alternative to CA MICS
Accounting and Chargeback.  The support is provided through a
two step process:  an inquiry, TNGAD1, and a consolidation
utility, TNGCBCSV.  These two programs summarize the CA MICS
resource data and create a CSV file in the format required by
NSM Chargeback.

The TNGAD1 inquiry is meant to be run on a daily basis,
although it can be run less frequently if desired.  It
extracts the requested data from the CA MICS database,
summarizes it by userid and date, and saves it in
complex-level SAS data libraries.

The consolidation utility, TNGCBCSV, reads the existing SAS
data sets, summarizes them by userid, and creates the CSV
files for NSM Chargeback.  The utility then deletes the SAS
data sets.  A TODATE parameter allows the user to include
only data up to a certain date.

The TNGAD1 and TNGCBCSV programs work together to ensure that
all data for a day is included, even if it is extracted from
different units or on different days, and that data that has
been summarized into a CSV will not get used again.  Please
note, however, that the TNGAD1 inquiry does NO DUPLICATE
CHECKING.  It adds the data it extracts from CA MICS to any
data it already has in its SAS databases for that day.
If duplicate data exists in the CA MICS database prior to
summarization into new SAS data sets for consolidation, the
duplicate data will be read in.  It is up to you to make sure
that data is not read in twice.

Details on using the inquiry and the utility job are
described in the sections that follow:

o  The TNGAD1 Inquiry
o  TNGCBCSV - The Consolidation Utility