SESAM/SQL V9.1 (en)

Function

You use CREATE-REPORT to specify which file SEDI70 is to evaluate, where SEDI70 is to write the report to, which data SEDI70 is to evaluate and how the SEDI70 statistics should look.

If you enter the name of the log file (DA-LOG file) to be evaluated in the appropriate SDF screen and send it off with the default settings, SEDI70 produces a report on all the data and outputs it to SYSLST.

The input for SEDI70 is entered in the SDF format in the same manner as the input for SESAM-DBH options and the SESCOSP control.

All the operands of CREATE-REPORT are described below as individual parameters.

CREATE-REPORT

INPUT-FILE =

,OUTPUT =

,SELECT =

Operands

INPUT-FILE =

See the “The individual parameter INPUT-FILE”

OUTPUT =

See the “The individual parameter OUTPUT”

SELECT =

See the “The individual parameter SELECT”

The individual parameter INPUT-FILE

Function

You use this parameter to specify the file name of the log file that SEDI70 is to evaluate.

INPUT-FILE

= <filename 1..54_without_generation_version> / *PARAMETERS(...)
	*PARAMETERS(...)
		\|	USER-IDENTIFICATION = *OWN / <name 1..8>
		\|	,CATALOG-NAME = <filename 1..18 without-all>
		\|	,COPY-NUMBER = 1 / <integer 1..999999>
		\|	,LOG-FILE-TYPE = DA-LOG / CAT-LOG
		\|	,SUB-NUMBER-FROM = 1 / <integer 1..9999>
		\|	,SUB-NUMBER-TO = 9999 / <integer 1..9999>

Operands

INPUT-FILE =

Name of the log file that SEDI70 is to evaluate.

INPUT-FILE = <filename 1..54_without_generation_version>

Explicit specification of the log file.

INPUT-FILE = *PARAMETERS(...)

Specify one or more log files that belong together by entering the database name, backup copy number, type and a range of file subnumbers.

This will designate the following log files:

[$user-id.]catalog.cccccc.x.ffff ... [$user-id.]catalog.cccccc.x.tttt

The following terms have the following meanings:

`user-id`	BS2000 user ID under which the log files are stored (see the operand USER-IDENTIFICATION)
`catalog`	Name of the catalog (see the operand CATALOG-NAME)
`cccccc`	Backup copy number (see the operand COPY-NUMBER)
`x`	Type of job log file (see the operand LOG-FILE-TYPE)
`ffff`	“From” file subnumber (see the operand SUB-NUMBER-FROM)
`tttt`	“To” file subnumber (see the operand SUB-NUMBER-TO)

USER-IDENTIFICATION = *OWN / <name 1..8>

BS2000 user ID under which the log files are stored.

USER-IDENTIFICATION = *OWN

The log files are stored under the current BS2000 user ID.

USER-IDENTIFICATION = <name 1..8>

The log files are stored under the specified BS2000 user ID.

CATALOG-NAME = <filename 1..18 without-all>

is the name of the database.

COPY-NUMBER = 1 / <integer 1..999999>

Number of the backup copy.

LOG-FILE-TYPE = *DA-LOG / *CAT-LOG

Type of log file.The name component used is D when *DA-LOG is specified and C when *CAT-LOG C is specified.

SUB-NUMBER-FROM = 1 / <integer 1..9999>

“From” file subnumber.

SUB-NUMBER-TO = 9999 / <integer 1..9999>

“To” file subnumber.The SUB-NUMBER-FROM must be smaller than or equal to the SUB-NUMBER-TO.

The individual parameter OUTPUT

Function

You use this parameter to specify whether SEDI70 is to write the formatted data to SYSLST or a file.

OUTPUT

= *SYSLST / <filename 1..54>

Operands

OUTPUT = *SYSLST

Writes the report to SYSLST.

OUTPUT = <filename 1..54>

Writes the report to the specified file.

The specified file is always assigned to SYSLST internally and the output is thus always sent to the SYSLST system file. At the end of the program run SYSLST is reset to the primary assignment even when it already had an assignment beforehand.

The individual parameter SELECT

Function

You use this parameter to specify which information is to be output by SEDI70.

SELECT

= ALL / PARAMETERS(...)
	*PARAMETERS(...)
		\|	USERS =
		\|	,SPACE-ID =

Operands

SELECT = *ALL

All information is output.

SELECT = *PARAMETERS(...)

The options that allow you to limit the data to be collected are described below individually as SELECT parameters. The information may be limited to one or more timesharing or application users as well as to one space or table.

The SELECT parameter USERS

Function

You use this parameter to specify the timesharing and application users to be output.

USERS

= ALL / BY-SELECT(...)
	*BY-SELECT(...)
		\|	HOST-NAME = *NONE / <text 1..8>
		\|	,APPLICATION-NAME = NONE / TSN (TSN=<alphanum-name 4..4>) / <text 1..8>
		\|	,CUSTOMER-NAME = *NONE / <text 1..8>

Operands

**USERS = *ALL**

All timesharing and application users are evaluated.

USERS = *BY-SELECT(...)

Only specific timesharing and application users are evaluated. You must specify a value other than *NONE for at least one operand if *BY-SELECT is specified.

HOST-NAME =

The information to be output is selected by specifying a host system.

HOST-NAME = *NONE

The information to be output is not limited to that on a specific host system.

HOST-NAME = <text 1..8>

Only the information from the user of the specified host system is output. The host system is identified by its symbolic host name. In non-distributed processing, HOMEPROC always identifies the local system.

APPLICATION-NAME =

The information to be output is selected by specifying an application.

APPLICATION-NAME = *NONE

The information to be output is not limited to that of a specific application.

APPLICATION-NAME = *TSN (TSN=<alphanum-name 4..4>)

In TIAM mode you select the application by specifying the task sequence number (TSN). This means that only the information that comes from the TIAM user with the specified TSN is output.

APPLICATION-NAME = <text 1..8>

Only the information that comes from the user of the specified application is output. In the openUTM mode you select the application by specifying the openUTM application name and in the DCAM mode by specifying the DCAM application name.

CUSTOMER-NAME =

The information to be output is selected by specifying a user, i.e. by specifying the user name.

CUSTOMER-NAME = *NONE

The information to be output is not limited to that of a specific user.

CUSTOMER-NAME = <text 1..8>

Only the information from the user of the specified user name is output.The name of the user is independent of the user's mode: In openUTM mode the user is specified with the KDCSIGN name, in TIAM mode with the program name and in DCAM mode with any name.

The SELECT parameter SPACE-ID

Function

You use this parameter to specify the space to be output.

SPACE-ID

= *ALL / <integer 1..1000>(...)
	<integer 1..32767>(...)
		\|	TABLE-ID = *ALL / <integer..32767>

Operands

SPACE-ID = *ALL

The information to be output is not limited to a certain space.

SPACE-ID = <integer 1..1000>(...)

Output is limited to the space with the specified space number. The association between the space number and the space name can be determined from the catalog tables SYS_INFO_SCHEMA.SYS_SPACES and SYS_INFO_SCHEMA.SYS_TABLES from the SPACE_ID and SPACE_NAME fields, respectively.Only the information pertaining to the specified space is output.

TABLE-ID =

The information to be output is limited to that of the specified table.

TABLE-ID = *ALL

The information to be output is not limited to that of a table.

TABLE-ID = <integer 1..32767>

The information to be output is limited to that of the table with the specified table number.The association between the table number and the table name can be determined from the catalog table SYS_INFO_SCHEMA.SYS_TABLES from the TABLE_ID and TABLE_NAME fields.

Only the information pertaining to the specified table is output.

Example

In the following SEDI70 is started with the following parameters:

- The corresponding log files to be evaluated,
- The output format (SYSLST)
- The information to be output

/SET-PROCEDURE-OPTIONS -
/               LOGGING-ALLOWED = *YES, -
/               DATA-ESCAPE-CHAR = *STD
/DECLARE-PARAMETER -
/               NAME = ( SYSLST              ( 'LST.SEDI70' ), -
/                        USER-IDENTIFICATION ( '*OWN' ), -
/                        CATALOG-NAME        ( *PROMPT ), -
/                        COPY-NUMBER         ( '000001' ), -
/                        LOG-FILE-TYPE       ( '*DA-LOG' ), -
/                        SUB-NUMBER-FROM     ( '0001' ), -
/                        SUB-NUMBER-TO       ( '0001' ), -
/                        OUTPUT              ( '*SYSLST' ), -
/                        USERS               ( '*ALL' ), -
/                        SPACE-ID            ( '*ALL' ) )
/MODIFY-TERMINAL-OPTIONS -
/               OVERFLOW-CONTROL = *NO-CONTROL
/WRITE-TEXT 
'*********************************************************'
/WRITE-TEXT     'Start  "SEDI70"'
/WRITE-TEXT 
'*********************************************************'
/REMARK 'Meaning of the procedure parameters'
/REMARK 'SYSLST: SYSLST assignment for the procedure'
/REMARK '&USER-IDENTIFICATION: User ID under which the log files are 
stored'
/REMARK '&CATALOG-NAME:Name of the catalog that the log files belong to'
/REMARK '&COPY-NUMBER:Number of the copy that the log files belong to'
/REMARK '&LOG-FILE-TYPE: Type of log files (*CAT-LOG or *DA-LOG )'
/REMARK '&SUB-NUMBER-FROM: Subnumber of the 1st log file to evaluate'
/REMARK '&SUB-NUMBER-TO:Subnumber of the last log file to evaluate'
/REMARK '&OUTPUT: Name of the file that SEDI70 writes its output'
/REMARK '&USERS:User for which the report is to be created'
/REMARK '&SPACE-ID:Space ID for which the report is to be created'
/ASSIGN-SYSDTA  TO-FILE = *SYSCMD
/ASSIGN-SYSLST  TO-FILE = &SYSLST

/START-SESAM-LOG-FILE-EVAL
//CREATE-REPORT INPUT-FILE = *PARAMETERS ( -
//                  USER-IDENTIFICATION = &USER-IDENTIFICATION, -
//                  CATALOG-NAME = &CATALOG-NAME, -
//                  COPY-NUMBER = &COPY-NUMBER, -
//                  LOG-FILE-TYPE = &LOG-FILE-TYPE, -
//                  SUB-NUMBER-FROM = &SUB-NUMBER-FROM, -
//                  SUB-NUMBER-TO = &SUB-NUMBER-TO ), -
//              OUTPUT = &OUTPUT, -
//              SELECT = *PARAMETERS ( -
//                  USERS = &USERS, -
//                  SPACE-ID = &SPACE-ID )
/
/MODIFY-TERMINAL-OPTIONS -
/               OVERFLOW-CONTROL = *USER-ACKNOWLEDGE

Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly

The higher-level parameter CREATE-REPORT

Function

Operands

The individual parameter INPUT-FILE

Function

Operands

USER-IDENTIFICATION = *OWN / <name 1..8>

The individual parameter OUTPUT

Function

Operands

The individual parameter SELECT

Function

Operands

The SELECT parameter USERS

Function

Operands

**USERS = *ALL**

The SELECT parameter SPACE-ID

Function

Operands