DBServer Commands

Use the following commands when running DBServer.

AX BUFFER

Displays or sets the TCP/IP buffer size. See comments on BUFFER SIZE.

mixnumber AX BUFFER [nn]

where mixnumber is the mix number of DBServer.

AX HELP

To display the AX commands that you can use with DBServer, enter the following command:

mixnumber AX HELP

where mixnumber is the mix number of DBServer.

AX QUIT

Typically, most sites leave DBServer in the mix. That way, DBServer is available for the DATABridge Clients. However, to quit DBServer, use the following command:

mixnumber AX QUIT [source]

where mixnumber is the mix number of OBJECT/DATABRIDGE/SERVER, and the optional source is the particular source to be terminated, in which case all Workers using that source will be terminated, or a particular Worker stack. If source is not specified, DBServer terminates after all of the Workers have completed.

If needed, you can terminate individual Worker stacks without terminating the DBServer.

mixnumber AX QUIT

where mixnumber is the mix number of a particular Worker stack. The Worker terminates after the next commit.

AX SIZES

Displays various size-related statistics: network read and write, audit record, and transaction group. The number in parentheses is the count of samples of that category. The four numbers at the end of the displayed line are the minimum, maximum, average, and total.

mixnumber AX SIZES

where mixnumber is the mix number of one of the DBServer workers.

AX STATISTICS

Displays or sets the option enabling or disabling printing the statistics report when a Worker finishes.

mixnumber AX STATISTICS [ TRUE | FALSE ]

where mixnumber is the mix number of DBServer or one of the DBServer workers.

If the AX STATISTICS TRUE command is given to the main DBServer stack, it affects all sources. If printing is disabled, Workers will not print a statistics report. If printing is enabled, only sources having PRINT STATISTICS = TRUE in the parameter file will have statistics reports. If the command is given to a Worker stack then it determines whether that particular Worker will print the statistics report at EOT, regardless of the PRINT STATISTICS option in the parameter file.

AX STATUS

You can use the AX STATUS command to display status information for either the main DBServer stack or a Worker stack.

 

Server stack

You can use the AX STATUS command for the main DBServer stack to display the transport type, port number, number of offered port subfiles, the Worker limit, the reason it is waiting, and the client host name and source name for each Worker.

mixnumber AX STATUS

where mixnumber is the mix number of the main DBServer stack. After you enter this AX STATUS command, enter SMSG from MARC or MSG from the ODT.

DBServer responses appear in the system messages, similar to this:
DBServer: Listening on TCP/IP port 5000
DBServer: Subports offered: 1 DBServer: Workers active: 3, Limit: 10 DBServer: Waiting for new connection or Worker event
DBServer:(3) DBHOST accessing BANKDB via TCP/IP port 5000/3
DBServer:(2) DEMOHOST accessing DEMODB via TCP/IP port 5000/2
DBServer:(1) DBHOST accessing CUSTDB via TCP/IP port 5000/1

 

Worker stack

You can use the AX STATUS command for the Worker stack to display the Client host name, the source name, the transport type, the port number, the audit location, the number of records processed, the size of message segments, and the size of the message buffer.

mixnumber AX STATUS

where mixnumber is the mix number of one of the DBServer workers. Once you enter this AX STATUS command, enter SMSG from MARC or MSG from the ODT.

DBServer responses appear in the system messages, similar to this:

DBServer:(2) DEMOHOST accessing DEMODB via TCP/IP port 5000/2
DBServer:(2) Protocol level: Client=15 Server=15
DBServer:(2) Port segment size: 4368, Buffer size: 8736
DBServer:(2) AFN=182, ABSN=5845, January 9, 2010 @ 08:41:09
DBServer:(2) Records sent=50, skipped=17, Commits=3
DBServer:(2) Waiting for client request

AX TIMES

Displays various time-related statistics: Network read and write, DBRead wait, thread lock waits, and total processor time. The number in parentheses is the count of samples of that category. The four numbers at the end of the displayed line are the minimum, maximum, average, and total.

mixnumber AX TIMES

where mixnumber is the mix number of one of the DBServer workers.

AX WORKERS

The command allows you to display or limit the current number of active Worker stacks.

  • To display them, enter:

    mixnumber AX WORKERS
    where mixnumber is the mix number of DBServer.

  • To limit them, enter:

    mixnumber AX WORKERS nn
    where mixnumber is the mix number of DBServer
    and nn is a number from 1 to 100.