Enables or disables OpenSwitch debugging messages.
rp_debug [options, [on|off]]
A list of one or more single-character option flags. Each flag is a toggle; supplying it once enables the option, supplying it again disables the option. Passing an option of “” lists the debugging flags that are currently enabled.
Table 6-2 shows the valid debugging options. These are identical to the options you can use with the -t flag at the command line.
Value |
Description |
|---|---|
a |
Enables all possible debugging flags. |
b |
Displays attempts to set or test configuration options as described in the configuration file. |
c |
Displays information about result handling of client-side cursors. |
C |
Logs interactions between a mutually-aware OpenSwitch, its companion OpenSwitch, and Adaptive Servers. |
d |
Logs access to data items attached to each thread’s user data. |
D |
Displays information about the handling of dynamic SQL statements. |
e |
Logs all error messages passing through the OpenSwitch error handlers, even those that are normally suppressed. |
f |
Shows connection progress information when OpenSwitch is interacting with the coordination module. |
F |
Display messages related to a coordination module (CM). |
g |
Displays operations involving security negotiations. |
h |
Displays messages when entering each event handler. |
i |
Displays progress information concerning the switching process during a call to rp_switch, such as success or failure of each switch, and which connections fail to go idle within the specified period of time. |
j |
Shows the connection caching activity. |
k |
Displays activity of the timer thread (the thread that is responsible for calling timed callbacks within OpenSwitch). |
l |
Dumps every SQL statement issued through the SRV_LANGUAGE event handler to log_file. |
m |
Displays every memory allocation and de-allocation (more extensive information may be available at compile time). |
n |
Displays receipt and handling of cancel or attention requests from client connections. |
o |
Displays a message each time a command line option value is set or tested. |
p |
Displays manipulation, use, and assignments of server pools. |
q |
Displays information about the connection monitor activity. |
r |
Displays current state and actions of the internal resource monitoring thread. |
R |
Logs interactions between an OpenSwitch and replication coordination modules (RCMs). |
s |
Shows access and release of shared and exclusive internal locks (used to prevent concurrent access to internal data structures). |
S |
Displays the SQL statement that is being executed as part of rp_replay calls. |
t |
Displays activities of the timer thread that is responsible for periodically waking other sleeping threads. |
u |
Displays information about result sets being returned to client threads. |
U |
Logs the user action, such as CUSTOM or MANUAL script execution during a companion OpenSwitch or Adaptive Server failure. |
v |
Logs ping operations and responses from remote machines. |
x |
Displays mutex accesses (more detailed view on shared locks). |
Turns on debugging options, which causes debugging messages to be dumped to the error log file.
Turns off debugging options.
Displays all debugging flags and their current state.
1> rp_debug 2> go
Returns:
flag description state ---- ---------------------------------- ------ b Attribute set/test off c Client cursor handling off C Mutual Aware on d Thread data access requests off D Dynamic SQL handling off e Error handler calls on f Coordination Module info on F Full Passthru mode off g Open Client/Server security off h Open Server handler calls off i Switching process info off j Connection caching info off k Timer thread state off l Output all language requests off m Memory allocation/deallocation off n Client attention requests off o Command line option set/test off p Pool access requests off q Connection monitor (CMON) thread off r Resource monitoring (RMON) thread off R RCM start thread off s Shared lock acquisition off S SQL Statements to be replayed off t Timed sleep thread off u Result set handling off U User Action off v Network ping thread off x Internal mutex grab/release off (28 rows affected)
Causes all switching information and all attention requests to be reported in the OpenSwitch log file.
1> rp_debug "in" 2> go
Returns:
flag description status ---- ---------------------------- ------ i Switching progress info Off n Client attention requests On
Debugging messages are intended primarily for use by individuals testing functionality, and are not intended for day-to-day use.
Many of the debugging options dump large amount of information to the log file and may significantly impact OpenSwitch performance.
Indicates that an invalid option was supplied.
rp_debug: Invalid debug flag 'flag'.
For valid options, see Table 6-2.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
