DSM/SCM User's Guide

Generating DSM/SCM Reports
DSM/SCM User’s Guide — 529846-014
18 - 16
Shorthand Views of the DSM/SCM Database
Shorthand Views of the DSM/SCM Database
Shorthand views of the DSM/SCM database provide a means for selecting data from
the database to include in the DSM/SCM reports you create, as described in Creating
Custom Reports on page 18-12. Each view represents a subset of information in the
database, organized in tables. For more information about the organization and
structure of SQL databases, see the SQL/MP Report Writer Guide.
To reference a view, specify the view name and specific data items in an SQL SELECT
statement.
For example, this TSV view contains TSV information for logical targets and target
systems. The view consists of four columns of related data.
An example of a SELECT statement that references this view is:
SELECT TSV_VOL, TSV_NAME FROM =PHIH_TSV_SVIEW
WHERE SYSTEM_NAME="\MAX" AND TARGET_NAME="SAT"
This statement selects from the TSV view the TSV volumes and TSV names for the
target SAT on system \MAX. (=PHIH_TSV_SVIEW is the name of a DEFINE for the
TSV view.)
You cannot alter the information given by the views, but you can alter the parameters
and syntactical statements in the SQLCI IN_file to select the information you want and
to create your own reports based on the views.
This subsection describes the DSM/SCM views and their column names. At the
beginning of the table description, in parentheses, is the logical view name that you
use to reference the view in a SELECT statement.
Activity Control View
The Activity Control View (=PHIH_ACT_CONTROL_SVIEW) contains information
related to an internal DSM/SCM component’s processing of a request, as well as the
descriptive text entered for the request by the planner or operator:
System_Name Target_Name TSV_Vol TSV_Name
\EASY DAY $GREECE ZEUS
\EASY NIGHT $GREECE PLUTO
\MAX WEEK $ATHENS ATHENA
\MAX SAT $ROME JUPITER
Column Name Description (page 1 of 2)
Activity_ID An identifier for the request
Activity_Code A code representing the type of request
Actual_End_Time The time at which the request completed
Actual_Start_Time The time at which the request was initiated