**Table 7-2: Valid ***options*** values**
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).

rp_debug

Description

Enables or disables OpenSwitch debugging messages.

You can also use the OpenSwitch Manager to set the debug options of your OpenSwitch servers. See “Editing OpenSwitch server properties” for more information.

Syntax

rp_debug [options, [on|off]]

Parameters

options: 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 7-2 shows the valid debugging options. These are identical to the options you can use with the -t flag at the command line.

Table 7-2: Valid options values
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).

on: Turns on debugging options, which causes debugging messages to be dumped to the error log file.

off: Turns off debugging options.

Examples

Example 1

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)

Example 2

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

Usage

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.

Messages

Indicates that an invalid option was supplied.

rp_debug: Invalid debug flag 'flag'.

For valid options, see Table 7-2.