The purpose of this chapter is to familiarize you with the
CA MICS database, particularly the way the various component
database files are organized to allow reporting at different
levels of granularity (timespans).
The CA MICS database consists of online DASD files and
archived data stored on tape:
o The online part holds data for the number of time periods
(DETAIL, DAYS, WEEKS, MONTHS, YEARS) defined by your site.
For example, you may have 10 days (DETAIL), 30 days (DAYS),
13 weeks, 12 months and 3 years of data stored online.
o The archived data consists of audit and history files:
- Audit files contain archived DETAIL or DAYS level data.
- History files contain archived data from the WEEKS and
MONTHS timespans.
These archived files contain data that is usually not
required for reports. If a request requires the analysis
of older data, the archived data can be retrieved.
Most reporting requirements are satisfied by information
contained in the online database, so this guide focuses on
online database reporting. In addition, we will cover only
those things you must know about the CA MICS database in
order to access files to satisfy your reporting needs. (The
DIA guides contain complete descriptions of the database
files and content for each component.)
This section contains the following topics:
|
Copyright © 2014 CA.
All rights reserved.
|
|