Table of Contents

Search

  1. Preface
  2. PowerExchange Navigator Introduction
  3. Data Maps
  4. Data Maps for Specific Data Sources
  5. Copybooks
  6. Registration Groups and Capture Registrations
  7. Extraction Groups and Extraction Maps
  8. Personal Metadata
  9. Database Row Test
  10. PowerExchange Navigator Examples
  11. Appendix A: PowerExchange Functions for User-Defined Fields
  12. Appendix B: User Access Method Programs
  13. Appendix C: Application Groups and Applications
  14. Appendix D: Data Map Properties
  15. Appendix E: Record, Field, and Table Properties
  16. Appendix F: DTL__CAPXTIMESTAMP Time Stamps
  17. Appendix G: Trace for Creating a Memory Map When Importing a COBOL Copybook

Navigator User Guide

Navigator User Guide

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.
  1. 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.
  2. 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.
  3. 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.
  4. In the
    DB Type
    list, select
    TASK_CNTL
    .
  5. 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.
  6. 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.
  7. 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.
  8. Click
    Go
    .
    The
    Database Row Test Output
    window displays the output for the command.

0 COMMENTS

We’d like to hear from you!