Issuing PowerExchange Listener Commands in a Database Row Test
Issuing PowerExchange Listener Commands in a Database Row Test
You can use the Database Row Test dialog box to issue a LISTTASK or STOPTASK command to a PowerExchange Listener that is running on any system or to issue a LISTLOCATIONS command.
The PowerExchange Listener LISTTASK command lists the client tasks that are running under the Listener, and the STOPTASK command stops a task. The LISTLOCATIONS command provides information about the locations that are defined in the NODE and SVCNODE statements of the DBMOVER configuration file.
In the
Resource Explorer
, double-click a data map that is defined for the location where the PowerExchange Listener is running to open the data map.
Alternatively, you can open an extraction map or personal metadata profile that is defined for the PowerExchange Listener location.
On the
Data Map
tab, select a table view, and then click
File
Database Row Test
on the menu bar.
A message might prompt you to sent the data map to a remote location.
In the
Data Map Remote Node
dialog box, enter connection information for the location where the PowerExchange Listener is running, and click
OK
.
The
Database Row Test
dialog box appears.
In the
DB Type
list, select
TASK_CNTL
.
In the
Fetch
list, select one of the following commands:
List Locations
. Displays information about the locations that are defined in NODE or SVCNODE statements in the DBMOVER configuration file on the system where the PowerExchange Listener is running. The output includes the node name, IP address, port number, send and receive buffer sizes and lengths, receive timeout, and SSL use.
List Task
. Displays information about each active task that is running under the PowerExchange Listener. The output includes the task ID, TCP/IP address, port number, application name, access type, and status.
Stop Task
. Stops a specific PowerExchange Listener task. To identify the task, you must enter a task ID or application name.
If you are issuing a STOPTASK command, enter a task ID or application name in the
SQL Statement
box. Use the following syntax:
stoptask {taskid=
task_id
|appname=
application_name
}
Do not include the curly brackets. These brackets indicate a choice of either taskid or appname is required.
Do not enter the application name in the
Application
field. The
Application
field is ignored for TASK_CNTL commands.
If you are issuing a LISTLOCATIONS command, optionally enter the node type in the
SQL Statement
box. Use the following syntax:
listlocations nodetype={N|A|S}
Specify one of the following values for nodetype:
N. Default. List locations that are defined in NODE statements in the DBMOVER file.
A. List locations that are defined in NODE or SVCNODE statements in the DBMOVER file.
S. List locations that are defined in SVCNODE statements in the DBMOVER file.