To issue proxy commands,
you must first select the SPD Server user proxy.
lists the proxy processes
that are accessible to the PROC SPDO lib=<LIBNAME> statement
that was dispatched from the SPD Server host. Accessible proxies are
anonymous proxies and proxies that are owned by the LIBNAME owner.
If the LIBNAME owner has ACLSPECIAL privileges, then all user proxies
will be listed.
SET USER userID [portnumber];
allows you to use the
port number to distinguish between two proxies that share the same
user ID.
lists the user-locking
proxy threads that are accessible by the PROC SPDO lib=<LIBNAME>
statement that was dispatched from the SPD Server host and that were
created with the LOCKING=YES LIBNAME option. Accessible proxies are
anonymous proxies and proxies that are owned by the LIBNAME owner.
If the LIBNAME owner has ACLSPECIAL privileges, then all user-locking
proxies will be listed. For each user-locking proxy thread, SPD Server
returns the SPD Server user ID, the client login, and the thread ID.
You can select a user-locking proxy thread from the LIST USERS list
by submitting a command in the following form:
SET USER/LOCKING [userID threadID=#];
Once a user-locking
proxy is selected, you can get LIBNAME information by submitting the
following commands:
SHOWLIBNAME libref | _ALL_;
SHOWLIBNAME libref / DATA=[ _ALL_| dsname];
SHOWLIBNAME libref / DUMP=[ _ALL_| dsname];
where libref is an
explicit SPD Server LIBNAME name. Specify _ALL_ to see every currently
assigned LIBNAME for the proxy.
If the /DATA= option
is used with _ALL_, information about all of the open tables in the
proxy for the given LIBNAME is displayed. If the /DATA= option is
used with a data set name dsname, detailed information about the specified
data set table is displayed.
If the /DUMP= option
is used with _ALL_, information about all of the accessible tables
in the proxy for the given LIBNAME is displayed. If the /DATA= option
is used with a data set name dsname, detailed information about the
specified data set table is displayed.