DBH form SERVICE ORDERS

The form shows the DDL or utility statements which are currently being processed in the service tasks, as well as the identification of the user for each request. If a  ALTER PARTITIONING FOR TABLE, COPY, EXPORT, RECOVER, REFRESH, REORG SPACE or UNLOAD service request exists, the progress of this request is shown.

The Service Orders form describes each request in two lines:

• the first line describes the request

• the second line displays information on the progress of the request, if any is available

The requests are sorted in two levels based on:

• The status of the request (S field) in the following order

  1. Status “W” (waiting)

  2. Status “A” (active)

  3. Status “F” (finished)

• Within a status, the entries are sorted in descending order based on their duration.

A maximum of 5 requests are output to the screen, and a maximum of 100 to SYSLST.

Field descriptions

First display line (for all requests)

<ver> DBH CNF Time TSN

Version of the DBH. Name of the DBH to which the data in the form relates. Name of the configuration monitored. Time at which the form is output. TSN of the service task currently processing the request. You can use this specification to find the associated entry on the DBH form SERVICE TASKS. If the request is not yet processed or is already processed, this field is empty.

User-ID

Identification of the user (32 positions). Comprises HOST-NAME, APPLICATION-NAME, CUSTOMER-NAME and CONVERSATION-ID (see section “Syntax for the identification of users”).

Order

Type of request (30 positions)

If sort requests are processed in the service task when processing DML statements, “SORT” is output.

Otherwise the statement that the user issued or in the context of which the service task runs is shown.

Possible statements here are:

ALTER DATA

ALTER PARTITIONING

ALTER SPACE

ALTER TABLE

CHECK CONSTRAINTS

CHECK FORMAL

COPY

CREATE CATALOG

CREATE INDEX

CREATE REPLICATION

CREATE SPACE

CREATE TABLE

DROP INDEX

DROP SPACE

DROP TABLE

EXPORT TABLE

IMPORT TABLE: <import-step>

where <import-step> can have the following values:
PROCESS INPUT (process input file)
GENERATE INDEX (create index)

LOAD OFFLINE: <load-step>

where <load-step> can have the following values:

PROCESS INPUT (process input file)
GENERATE INDEX (create index)

MIGRATE

RECOVER: <recover-step>

where <recover-step> can have the following values:
''BLANK'' (introduces request)
RESTORE CATALOG_SPACE (reading in the catalog space)
RESTORE USER-SPACES (reading in the user spaces)
RESTORE FROM REPL (catalog space and user spaces are read in here in a service task)
REPAIR CATALOG_SPACE (applying the changes logged in the CAT-LOG file)
REPAIR USER-SPACES (applying the changes logged in the DA-LOG files)
GENERATE INDEX (setting up the indexes)
DATA ADAPTION (data matching of catalog space and user spaces)

RECOVER INDEX

REFRESH REPLICATION

REFRESH SPACE

REORG SPACE: <reorg-step>

where <reorg-step> can have the following values:
''BLANK'' (introduces request)
FIRST PHASE (reorganization)
RENAME (renaming)
COPY (copying)

REORG STATISTICS

UNLOAD

S

Status of the request (one position)

W (Waiting):	The request is not yet processed by a service task.
A (Active):	The request is currently being processed by a service task.
F (Finished):	The request has been processed by the service task and can be retrieved from the DBH.

Duration

Specifies the duration thus far of the request with respect to the current status, i.e. Duration specifies how long a request has already had the status “W”, “A” or “F”.

Second display line

This display line is only displayed for particular requests.

Second display line

This display line is only displayed for particular requests.

INFORMATION

Depending on the type of request (content of the ORDER field in the first display line), the field contains the object which is currently being processed:

ORDER	INFORMATION
ALTER PARTITIONING: MOVE ROWS	Table name
ALTER PARTITIONING: GEN INDEX	Table name
ALTER PARTITIONING: CHG ROWIDS	Table name
EXPORT TABLE	Table name
IMPORT TABLE: PROCESS INPUT	Table name
IMPORT TABLE: GENERATE INDEX	Table name
LOAD OFFLINE: PROCESS INPUT FILE	Table name
LOAD OFFLINE: GENERATE INDEX	Table name
UNLOAD	Table name
RECOVER: RESTORE CATALOG_SPACE	Database name and type of backup (DISC, HSMS, ARCH)
COPY	Database name, number of spaces and type of backup
RECOVER: RESTORE USER SPACES	Database name, number of spaces and type of backup
RECOVER: RESTORE FROM REPL	Database name, number of spaces and type of backup
RECOVER: REPAIR CATALOG_SPACE	Name of the current logging file
RECOVER: REPAIR USER SPACES	Name of the current logging file
REFRESH REPLICATION: REPAIR USER SPACES	Name of the current logging file
REFRESH SPACE: REPAIR USER SPACES	Name of the current logging file
REORG	Name of the space
REORG SPACE: FIRST PHASE	Name of the space
REORG SPACE: RENAME	Name of the space
REORG SPACE: COPY	Name of the space

CURRENT

Number of blocks or records (up to 10 characters) processed so far.

In the case of ALTER PARTITIONING: MOVE ROWS / CHG ROWID, EXPORT TABLE, UNLOAD TABLE, IMPORT TABLE: PROCESS INPUT and LOAD OFFLINE: PROCESS INPUT FILE the number of records is contained here, otherwise the number of blocks.

In the case of IMPORT TABLE: GENERATE INDEX and LOAD OFFLINE:
GENERATE INDEX the value “0” is displayed here because in this phase the access data is maintained and no meaningful value can be displayed.

TOTAL

Total number of blocks or records (up to 10 characters) to be processed.

In the case of EXPORT TABLE and UNLOAD TABLE the number of records is contained here, otherwise the number of blocks.

In the case of IMPORT TABLE: PROCESS INPUT, IMPORT TABLE: GENERATE INDEX, LOAD OFFLINE: PROCESS INPUT and LOAD OFFLINE: GENERATE INDEX the value “0” is displayed here because the number of records in the input file is not known.

DONE

Processing progress: Relationship of “CURRENT” to “TOTAL” in percent.

In the case of ALTER PARTITIONING, IMPORT TABLE: PROCESS INPUT, IMPORT TABLE: GENERATE INDEX, LOAD OFFLINE: PROCESS INPUT and LOAD OFFLINE: GENERATE INDEX the value “0” is displayed here because the value for TOTAL is not known.