RDBPROD: How to reduce messages in the dispatcher log file (Doc ID 1354931.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.2 and later
HP OpenVMS Alpha
HP OpenVMS Itanium

Goal

By default, each time a client connects and disconnects a message is recorded in the dispatcher log file.

This file is normally stored in SYS$MANAGER.

If there is a lot of connection activity, this file may grow quite large.

Here is an example:

%SQLSRV-I-CONNECTNAME, Connect : CONNECT_0000001
%SQLSRV-I-CONNECTSTATE, Connect state: 4 (RUNNING_UNBOUND)

 

-I-   means they are only informational.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms