Usage Note 20338: PRINTLOG option added to SPD Server to log SQL statements from client
The PRINTLOG option has been added to SPD Server 4.4 TSM2 to allow you
to see SQL text coming from the client. Prior to TSM2, there was not a
way to log SQL text coming from a client.
The following SQL RESET options have been added to turn on/off printing
of SQL statements to the SPD Server log:
execute (reset printlog) by sasspds; /* turns on printing */
execute (reset noprintlog) by sasspds; /* turns off printing */
You can also set the PRINTLOG option in the spdsserv.parm file:
SQLOPTS="reset printlog";
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SPDS | Scalable Performance Data Server | Solaris | 4.4 | | 9.1 TS1M3 | |
| Solaris for x64 | 4.4 | | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 4.4 | | 9.1 TS1M3 | |
| HP-UX | 4.4 | | 9.1 TS1M3 | |
| 64-bit Enabled HP-UX | 4.4 | | 9.1 TS1M3 | |
| HP-UX IPF | 4.4 | | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 4.4 | | 9.1 TS1M3 | |
| Tru64 UNIX | 4.4 | | 9.1 TS1M3 | |
| AIX | 4.4 | | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | System Administration ==> Servers ==> SPDS
|
| Date Modified: | 2007-06-21 15:32:26 |
| Date Created: | 2007-06-05 15:04:42 |
