Your Browser is not longer supported

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

{{viewport.spaceProperty.prod}}

Administration using a CALL DML program

In a CALL DML program, you can issue administration commands to the DBH or to SESDCN by means of a CALL DML statement. The following prerequisites must be fulfilled:

  • When the DBH or SESDCN is started, administration via the CALL interface must be permitted (using the DBH or DCN option ADMINISTRATOR).

  • The ADMINISTRATOR open statement must be issued in the CALL DML program to initiate the administration of the DBH (see the “ CALL-DM Applications” manual). Until the close statement, only administration statements in this program run can be executed.

Administration via the CALL interface can be carried out from any BS2000 user ID.

No blanks may be entered between the syntax elements.

The transfer areas of the CALL DML statement for administration contain the following:


statement area:

where the application program enters the statement in the form of
an administration command in ISP format.

acknowledgment area:

where the DBH or SESDCN reports the acknowledgment of the
administration command.

response area:

where the responses to administration calls are output.


The inquiry area is not evaluated by the DBH or SESDCN.

You will find a thorough description of the different transfer areas in the “ CALL-DM Applications” manual.

Outputting successor responses

Large database configurations supply extensive outputs, e.g. in the inquiry commands. An output section (a so-called response) has a maximum size of 32000 bytes. Larger output volumes are output in multiple responses.

Successor responses can occur in the following administration commands because one output section may not suffice:

USER,CATALOG

(DBH and DCN)

USER,INACT

(DBH)

USER,PR

(DBH and DCN)

USER,SPACE

(DBH)

USER,TA

(DBH and DCN)

SPACE

(DBH)

OPT,CDBC-INFO

(DBH)

OPT,DBC-INFO

(DBH)

In the case of the administration command HOLD-TA information about transactions is output in successor responses if transactions still exist.

In the case of the administration command STOP information about transactions is output in successor responses if PTC transactions, utility statements or lock sequences still exist. In this case the system is not terminated.

Outputting DBH successor responses

You can call DBH successor responses using the following extension of the CALL-DML interface (op code 010):

'<password>010NEXT9 '

The statement supplies a successor response only if the preceding administration response was acknowledged with the status “0A/00” (overflow in the response area) and terminated with the message SES7351.

The end of the response output is indicated with the status”00” and terminated with message SES7215.

If no successor response exists the statement is acknowledged with the status “02/01”.

Any administration statement other than NEXT terminates all pending successor outputs. These can then no longer be called later.

Outputting DCN successor responses

You can call DCN successor responses using the following extension of the CALL-DML interface (op code 020).

'<password>020<Antwortlänge> [P<host-name>] [C<cnf>] [D<nam>] ANEXT9 '

The statement supplies a successor response only if the preceding administration response was acknowledged with the status “0A/AB” (overflow in the response area) and terminated with the message SEN2052.

The end of the response output is indicated with the status”00” and terminated with message SEN2014.

If no successor response exists the statement is acknowledged with the status “02/SE” and message SEN2053.

The response length specified must be the same as that of the preceding administration statement. Otherwise the statement is acknowledged with the status “02/SF” and terminated with message SEN2005.

Any command other than NEXT terminates all pending successor outputs. These can then no longer be called later.

If no further storage area is free for the connection to an administration program, the status “0B/A1” is reported.