000019878 - Monitoring ACE/Server database connections

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000019878
Applies ToRSA ACE/Server 3.3.x (no longer supported as of 3-30-2002)
RSA ACE/Server 4.x (no longer supported as of 2-1-2004)
RSA ACE/Server 4.1 (no longer supported as of 2-1-2004)
RSA ACE/Server 5.0.1 (no longer supported as of 8-15-2004)
RSA ACE/Server 5.0.2 (no longer supported as of 8-15-2004)
RSA ACE/Server 5.0.3 (no longer supported as of 8-15-2004)
RSA ACE/Server 5.1 (no longer supported as of 7-14-2006)
Microsoft Windows NT 4.0
Microsoft Windows 2000
UNIX (AIX, HP-UX, Solaris)
IssueMonitoring ACE/Server database connections
CauseIn some instances it is desirable to find out what connections are being made into the ACE/Server database, for example, to look at how many remote administration connections are running
ResolutionThis can be done by using a utility provided with ACE/Server. Create the script shown below to monitor parts of the ACE/Server. Then, run it with the parameter of either 'sdserv' or 'sdlog' depending on which of the two internal databases you wish to look at (for more details on the structure of the ACE/Server see the Customizing your ACE/Server (cust_admin.pdf) documentation.


- On UNIX, this script will be as follows:

#!/bin/sh
#
# Monitor script not supported by RSA Security
#
DB=$1
. /etc/sdace.txt
ACE=`dirname $USR_ACE`
DLC=$ACE/rdbms
PROMSGS=$DLC/promsgs
export DLC PROMSGS
$DLC/bin/_mprshut -0 $VAR_ACE/${DB}

This will present you with a menu, just select 1 to view active connections.


- On Windows NT and Windows 2000, this script will be as follows (NOTE: You must modify it to reflect your installation location):

set ACE=c:\ace
set DB=%1%
%ACE%\rdbms32\bin\_mprshut -0 %ACE%\data\%DB%
Legacy Article IDa14655

Attachments

    Outcomes