Control statements for the Statistics Data Import Utility

The control statement for the Statistics Data Import Utility controls the functions of the Statistics Data Import Utility.

The control statement must be specified in the BSNSYSIN data set. This control statement data set generally resides in the input stream. However, it can also be defined as a sequential data set or as a member of a partitioned data set. It must contain 80-byte, fixed-length records. The block size, if coded, must be a multiple of 80.

The control statement must be coded in columns 1 - 72. Columns 73 - 80 are regarded as comments and ignored.

In this topic:

Format of the control statement
Summary of keywords
Description of keywords

Format of the control statement

The control statement includes a set of keywords, parameters, and comments that are specified in the BSNSYSIN data set.

Keywords

A keyword defines an option for the Statistics Data Import Utility. Keywords can be specified in any order, and any two adjacent keywords must be separated by a blank or a comma. Each keyword has one or more associated parameters.

Parameters

A parameter defines a value for the associated keyword. Some keywords require only one parameter and others require one or more parameters. Parameters must be character or numeric values.

A keyword and the associated parameters are separated by parentheses. If two or more parameters are specified, any two adjacent parameters must be separated by a blank or a comma. For example,

keyword(parameter)
keyword(parameter1,parameter2,parameter3)
keyword(parameter1 parameter2 parameter3)

Comments

You can include comments in the BSNSYSIN data set by marking a line with an asterisk (*) in column 1.

The Statistics Data Import Utility ignores the comment line when analyzing the control statement in the BSNSYSIN data set.

Summary of keywords

The following table summarizes the keywords of the control statement for the Statistics Data Import Utility.

Table 1. Keywords for the Statistics Data Import Utility
Keyword	Required or optional?	Default	Description
CSV_AREA	Optional	n/a	Specifies the name of a data set that contains CSV-formatted sensor data for a DEDB area.
CSV_DB	Optional	n/a	Specifies the name of a data set that contains CSV-formatted sensor data for a database.
CSV_DSG	Optional	n/a	Specifies the names of the data sets that contain CSV-formatted sensor data for database data sets.
DSN_ALIASDEF	Optional	n/a	Specifies the name of a data set that contains the alias definition table.
HLQ_CSVSET	Optional	n/a	Specifies the data set high level qualifier for a set of CSV-formatted sensor data sets for one or more databases, partitions, and areas.
HLQ_HISTORY	Required	n/a	Specifies the data set high level qualifier for the historical sensor data set.
IMSCATHLQ	Optional	n/a	Specifies the data set high level qualifier for the bootstrap data set of the IMS directory.
INPUT_FORMAT	Optional	CSV	Specifies the format of the input sensor data to be imported.
ITKBSRVR	Required	n/a	Specifies the name of the IMS Tools KB server XCF group.
RECONID	Required	n/a	Specifies a RECON ID.

Description of keywords

The following keywords are available for the control statement.

Note: For the format of the input CSV-formatted sensor data, see Input CSV-formatted data sets for the Statistics Data Import Utility.

CSV_AREA

This keyword specifies the name of a data set that contains CSV-formatted sensor data for a DEDB area. You can specify only one data set name.

CSV_AREA is an optional keyword. The CSV_AREA keyword cannot be specified with either the CSV_DB keyword or the CSV_DSG keyword.

Format:

data_set_name: Specify a 1- to 44-character data set name. There is no default.

CSV_DB

This keyword specifies the name of a data set that contains CSV-formatted sensor data for a full-function database. You can specify only one data set name.

CSV_DB is an optional keyword. The CSV_DB keyword cannot be specified with the CSV_AREA keyword.

Format:

data_set_name: Specify a 1- to 44-character data set name. There is no default.

CSV_DSG

This keyword specifies the names of the data sets that contain CSV-formatted sensor data for database data sets.

You can specify up to 10 data sets. Each data set must contain sensor data for a different database data set.

CSV_DSG is an optional keyword. The CSV_DSG keyword cannot be specified with the CSV_AREA keyword.

Format:

data_set_name_n: Specify a 1- to 44-character data set name. There is no default.
You can specify up to 10 data set names. Each data set must contain sensor data for a different database data set.

DSN_ALIASDEF

This keyword specifies the name of a data set that contains the alias definition table. By defining aliases of data element names in the alias definition table, you can use those aliases as column names in the input CSV-formatted data sets.

For the format of the alias definition table, see Alias definition table for the Statistics Data Import Utility.

DSN_ALIASDEF is an optional keyword.

Format:

data_set_name: Specify a 1- to 44-character data set name. There is no default.

HLQ_CSVSET

This keyword specifies the data set high level qualifier for a set of CSV-formatted sensor data sets for one or more databases, partitions, or areas.

HLQ_CSVSET is an optional keyword. The HLQ_CSVSEST keyword cannot be specified with the CSV_DB keyword, the CSV_DSG keyword, or the CSV_AREA keyword.

By using the HLQ_CSVSET keyword, you can import multiple databases, HALDB partitions, and DEDB areas in a single job step.

Format:

data_set_high_level_qualifier: Specify a 1- to 17-character high level qualifier of the CSV-formatted sensor data sets. There is no default.

The names of the CSV-formatted data sets must follow the following rule:

Database type	Sensor data for a database or an area	Sensor data for a database data set
Full-function database (non-HALDB)	`hlq.dbdname`	`hlq.dbdname.string`
Full-function database (HALDB)	`hlq.dbdname.partname`	`hlq.dbdname.partname.string`
Fast Path database (DEDB)	`hlq.dbdname.areaname`	Not applicable

Where:

hlq is the high level qualifier specified by the HLQ_CSVSET keyword.
dbdname is the DBD name.
partname is the HALDB partition name.
areaname is the DEDB area name.
string is any qualifier.

If the DBD member specified by the dbdname qualifier does not exist in the DBD library, the relevant CSV-formatted data set is not processed.

HLQ_HISTORY

This keyword specifies the data set high level qualifier of the historical sensor data set.

HLQ_HISTORY is a required keyword.

Format:

data_set_high_level_qualifier: Specify a 1- to 17-character high level qualifier of the output (historical) sensor data set. There is no default.

The Statistics Data Import Utility determines the name of the historical sensor data set by using the high level qualifier specified by the HLQ_HISTORY keyword and the name of the DBD, the partition, or the area to be imported.

IMSCATHLQ

This keyword specifies the data set high level qualifier for the bootstrap data set of the IMS directory.

IMSCATHLQ is an optional keyword.

If you specify the IMSCATHLQ keyword, you must enable the IMS catalog and the IMS management of ACBs.

Format:

data_set_high_level_qualifier

Specify a 1- to 37-character high level qualifier for the bootstrap data set of the IMS directory. There is no default.

The Statistics Data Import Utility reads database definitions from the IMS directory instead of the DBD library by using IMS Tools Catalog Interface.

If you specify the IMSCATHLQ keyword, you must add the following libraries to the STEPLIB DD statement:

The IMS Tools Base library (SGLXLOAD)
The IMS load module library (SDFSRESL)

INPUT_FORMAT

This keyword specifies the format of input sensor data.

INPUT_FORMAT is an optional keyword.

Format:

CSV: Indicates that the input sensor data is a CSV-formatted data set. This is the default.

ITKBSRVR

This keyword specifies the name of the IMS Tools KB server XCF group. The Statistics Data Import Utility stores catalog information about the imported sensor data (utility history data) in the IMS Tools KB Sensor Data repository, which is managed by the IMS Tools KB server.

ITKBSRVR is a required keyword.

Format:

server_name: Specify a 1- to 8-character IMS Tools KB server XCF group name. There is no default.

RECONID

This keyword specifies the RECON ID that is associated with the RECON1 data set name in the IMS Tools KB repository.

RECONID is a required keyword.

Format:

recon_id: Specify a 1- to 8-character RECON ID. There is no default.