4. Operation › 4.5 Integrating CA MICS Data to NSM › 4.5.1 Integration with NSM Chargeback › 4.5.1.1 The TNGAD1 Inquiry
4.5.1.1 The TNGAD1 Inquiry
The TNGAD1 inquiry collects resource elements from a CA MICS
unit database and saves them in complex-level SAS data
libraries. The inquiry gets the list of elements to be
extracted from prefix.MICS.PARMS(TNGCBDEF).
Note: The inquiry does NO DUPLICATE DATA CHECKING. Existing
data sets are updated with any requested data that has the
same month and day.
o Specifying the unit: The unit identifier is a runtime
parameter.
o Specifying the files and elements: Specify the elements
to be extracted in prefix.MICS.PARMS(TNGCBDEF). TNGCBDEF
is read each time the inquiry is run, so changes to this
member take effect automatically. NSM Chargeback
recommends that a maximum of 10 elements be extracted per
complex.
The following statements are supported:
PRIME z1 <z2 ... z9 >
TIMESPAN ts
FILE iiifffcc
USERID element
BYSHIFT element <element ... >
TOTAL element <element ... >
The TIMESPAN, FILE, USERID, BYSHIFT and TOTAL statements
form a group defining the elements to be extracted from a
particular file. Multiple groups may be defined, but all
the statements referring to one file must be together.
PRIME Specifies the zones that define your prime
shift. NSM Chargeback allows you to charge
different rates for prime and nonprime shifts.
Any zones listed in this statement will be
considered prime shift. All other zones will
be considered nonprime shift. This keyword is
only required if you choose to split metrics by
shift using the BYSHIFT statement described
below. Only one PRIME statement is allowed.
Up to 9 zones can be specified, separated by
blanks.
TIMESPAN Specifies the timespan of the file. DETAIL and
DAYS are supported. One TIMESPAN statement is
required and it must precede the first FILE
statement. Additional TIMESPAN statements may
precede additional FILE statements. If only
one TIMESPAN statement is provided, the same
timespan will be used for all requested files.
FILE Specifies the file from which the elements are
to be extracted. It INCLUDES cycle number.
One FILE statement is required. There is no
limit on the number of FILE statements
included.
USERID Specifies the element in the file that should
be assigned to USERID. All charges in NSM
Chargeback are summed by SYSID and USERID.
BYSHIFT Specifies the elements in the file that should
be summed for prime and nonprime usage.
Separate elements by blanks. Use additional
BYSHIFT statements if necessary.
TOTAL Specifies the elements in the file that should
be summed for their total usage, without
maintaining a distinction between prime and
nonprime use. Separate elements by blanks.
Use additional TOTAL statements if necessary.
o Specifying environmental parameters: Review
sharedprefix.MICS.SOURCE(BASUCBXT) for a description of
the parameters available to define DASD requirements and
other environmental details. The parameters are
implemented via SAS macro variables and can be overridden
as needed.
o Output Data Set Naming Conventions: The data sets created
by the TNGAD1 inquiry are named as follows:
Data Library: sharedprefix.MICS.TNGCBSAS.YRyyyy.@ssss
Data Set: MmmDdd
where:
yyyy Is a four digit number that denotes the year
of the data.
ssss Is a four character system identifier
(SYSID).
mm Is the month of the data.
dd Is the day of the data.
One data library is created per system, per year. Within
each data library, there is one data set per day. Data is
added to the data set for that day, if one exists. THERE
IS NO CHECK FOR DUPLICATE DATA.
