# ppxShowDB

Sends the contents of the PPX server runtime database to a file.

#### Prototype

DWORD ppxShowDB ( CTAHD ctahd )

Argument | Description
ctahd | Context handle returned by ctaCreateContext or ctaAttachContext.

#### Return values

Return value | Description
SUCCESS |
CTAERR_OUT_OF_MEMORY | Unable to allocate memory.
CTAERR_SVR_COMM | Natural Access server communication error.
PPXERR_COMM_FAILURE | Problems were encountered when communicating with the PPX server.

#### Details

ppxShowDB causes the PPX server to send the contents of its runtime connection database to either \nms\ctaccess\ppxdb.log in Windows or /var/opt/nms/ctaccess/ppxdb.log in UNIX.

A sample ppxShowDB output follows.

- The connection object address is provided, rather than the connection handle, since only a matching connection address shows a shared connection between clients.

- Switch numbers are not shown with the bus point (such as CTBUS:0:0) because bus points are not really owned by one particular switch.

- The line, 2:LOCAL:1:6 <= CTBUS:0:31, appears in the sample output. This means the talker point on the switch is connected to the intermediate bus point CTBUS:0:31 to drive the local point 1:6.

- A client ID of PPXSERV represents an internal context for those connections that are setup by the server based upon the configuration file.

- A client ID of 0xFFFFFFFFF indicates that either the connection is an unnailed connection set up through the PPX configuration file, or it is a named connection that can be modified by any application.

#### Example

-----------------------------------------------------------------
Fri Jan 30 10:08:04 2004 Natural Access PPX Runtime Database
-----------------------------------------------------------------
Client Contexts Held by Context Manager
=======================================
Client ID 0x5001001 Context State Information:
Submit Pending 0 PPXErr 0 SWIErr 0 Restore 0 Shutdown 0
Number of connections in use 0:
Client ID 0x3001001 Context State Information:
Submit Pending 0 PPXErr 0 SWIErr 0 Restore 0 Shutdown 0
Number of connections in use 2:
PPXHD 0x80001 ConnObj Address 0x69cf20
PPXHD 0x90002 ConnObj Address 0x6a6c50
Client ID 0x1001001 Context State Information:
Submit Pending 0 PPXErr 0 SWIErr 0 Restore 0 Shutdown 0
Number of connections in use 1:
PPXHD 0x70001 ConnObj Address 0x69cf20
Client ID PPXSRV Context State Information:
Submit Pending 0 PPXErr 0 SWIErr 0 Restore 0 Shutdown 0
Number of connections in use 6:
PPXHD 0x10001 ConnObj Address 0x69bb60
PPXHD 0x20002 ConnObj Address 0x69ec50
PPXHD 0x30003 ConnObj Address 0x69f380
PPXHD 0x40004 ConnObj Address 0x69f9b0
PPXHD 0x50005 ConnObj Address 0x69f770
PPXHD 0x60006 ConnObj Address 0x69be40
Connection Objects Held by Connection Manager
=============================================
ConnObj Address 0x69bb60 Client ID: PPXSRV DefPattern 0x7f
UNNAMED Talker: 0:LOCAL:0:2
Listener(s): 0:LOCAL:5:2
ConnObj Address 0x69ec50 Client ID: PPXSRV DefPattern 0x7f
UNNAMED Talker: 0:LOCAL:4:2
Listener(s): 0:LOCAL:1:2
ConnObj Address 0x69f380 Client ID: PPXSRV DefPattern 0x7f
UNNAMED Talker: 0:LOCAL:2:2
Listener(s): 0:LOCAL:7:2
ConnObj Address 0x69f9b0 Client ID: PPXSRV DefPattern 0x7f
UNNAMED Talker: 0:LOCAL:6:2
Listener(s): 0:LOCAL:3:2
ConnObj Address 0x69f770 Client ID: 0xffffffff DefPattern 0x7f
UNNAMED Talker: 0:LOCAL:0:4
Listener(s): 0:LOCAL:5:4
ConnObj Address 0x69be40 Client ID: 0xffffffff DefPattern 0x7f
UNNAMED Talker: 0:LOCAL:4:4
Listener(s): 0:LOCAL:1:4
ConnObj Address 0x69cf20 Client ID: 0xffffffff DefPattern 0xff
Name: OnHold Reference Count: 2
Talker: 0:LOCAL:0:6
Listener(s): 0:LOCAL:5:6
1:LOCAL:1:6 <= CTBUS:0:31
1:LOCAL:1:4 <= CTBUS:0:31
ConnObj Address 0x6a6c50 Client ID: 0x3001001 DefPattern 0x7f
UNNAMED Talker: 1:LOCAL:0:0
Listener(s): CTBUS:5:0
State of switches in Fabric:
----------------------------
SWIHD 0x1 Switch #: 0 Dev#: 0 DevName: agsw State: Enabled
SWIHD 0x10002 Switch #: 1 Dev#: 0 DevName: atsdrv State: Enabled