Running the DTLUTSK Utility in the PowerExchange Navigator
Running the DTLUTSK Utility in the PowerExchange Navigator
The TASK_CNTL data access method is available so that you can perform a database row test to retrieve the results of the LISTTASK, STOPTASK, or LISTLOCATIONS command from the PowerExchange Navigator.
STOPTASK works only with the CAPXRT access method.
To run the DTLUTSK utility in the PowerExchange Navigator:
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.
Click
Go
.
The
Database Row Test Output
window displays the output for the command.
For more information, see the "Database Row Test" chapter in the