SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 195 / 271

and the SRVOPORT parameter defines the operator port. If the listen and operator ports
are not defined, or are defined as a zero value, the SPD Server will by default use
spdsserv_sas and spdsserv_oper in the operating system's services file. If there are no
listen or operator ports defined in the operating system's services file, then SPD Server will
choose any available ports for listen and operator port functions. This is the normal mode
of operation when SPD Server clients and servers run in environments that have no
firewalls.
SPD Server Base Proxy Ports
You must use the SPD Server MINPORTNO= and MAXPORTNO= server parameter
specifications to define the available range of ports for the SPD Server Base Proxy
processes. You must specify both the MINPORTNO= and MAXPORTNO= parameters
when you define the range of port numbers that are available to communicate with SPD
Server clients that might be outside of a firewall. If the SPD Server parameters for
MINPORTNO= and MAXPORTNO= are not specified, an SPD Server Base Proxy process
will use any port that is available to communicate with its SPD Server client. This is the
normal mode of operation when SPD Server clients and servers run in environments that
have no firewalls.
How many port numbers need to be reserved for SPD Server Base User proxy processes?
Each SPD Server Base User Proxy process produces its own command port. The command
port can be accessed via command-line specifications issued by an SPD Server client. The
operator port for a command port can be accessed by using PROC SPDO operator
commands.
Each SPD Server host table that is opened also creates its own port. Each SPD Server table
port becomes a dedicated data transfer connection that is used to stream data transfers to
and from the SPD Server client. SPD Server host table ports are normally assigned
dynamically, unless MINPORTNO= and MAXPORTNO= parameters have been
specified.
If MINPORTNO= and MAXPORTNO= parameters have been specified, then SPD Server
host table ports are assigned from within the port range that is defined by the minimum
and maximum port parameter statements. The port range that is specified by the
MINPORTNO= and MAXPORTNO= parameters must be able to accommodate the
maximum number of concurrent LIBNAME connections required at the server, as well as
the I/O data streams that travel between the SPD Server Base processes on the host and the
SPD Server clients.
SPD Server Auditing
Overview of SPD Server Auditing
SPD Server supports SQL audit logging of submitted SQL queries and proxy auditing of
access to SPD Server resources. SPD Server proxy auditing and SQL audit logging
(spdsaud) are enabled when the server is started using the -AUDITFILE or -
SQLAUDITFILE parameters. You can enable proxy auditing or SQL audit logging, or
both. For more information about start-up options, see the Help section in the SPD Server
Administrator's Guide on
“SPD Server Host Commands” on page 49 .
SPD Server auditing provides a way to log access to SPD Server resources, or to log implicit
or explicit SQL pass-through queries that are submitted to SPD Server. Separate audit logs
are created for proxy auditing and SQL audit logging. SPD Server includes three SAS
programs (auditwithwhere.sas, auditraw.sas, and auditsql.sas) in the /samples directory of
Overview of SPD Server Auditing
189