Using the Development Environment

This section discusses how to use the development environment.

To start PeopleSoft Data Mover in the Windows development environment:

  1. Select Start, Programs, PeopleSoft Group, Data Mover.

    If you don't have a PeopleSoft Data Mover shortcut, you can add one to the desktop. The executable to launch is: PS_HOME\bin\client\winx86\psdmt.exe

  2. Sign in using the appropriate ID and password.

    In regular mode, use a user ID and password. In bootstrap mode, use a system access ID and access password, such as SYSADM.

The PeopleSoft Data Mover interface consists of two horizontal panes: an input pane and an output pane. The input pane is on top.

The status bar at the bottom of the window provides the following information:

  • Database name (for example, QEDMO, PTS920HR, and so on).

  • Database type (for example, Oracle, DB2, and so on).

  • Operating mode (regular or bootstrap).

  • Trace status (on or off).

The input pane displays the script that you open. In this pane, you view and edit PeopleSoft Data Mover scripts.

The output window displays the results after running a script. If you encounter any errors, the output window shows where the script failed. In a multi database environment, always check the information at the top of the output to ensure that you run the script against the appropriate database. Specifically, verify the information on the Database line.

Note: By default, the results in the output window are saved to the file DATAMOVE.LOG, which is written to the default log directory as specified in PeopleSoft Configuration Manager (on the Edit Profile, Common tab). You can specify a different file name.

The status of the SQL Trace utility appears on the right-hand end of the status bar. Use PeopleSoft Data Mover with tracing turned off. There are several ways to disable the SQL Trace utility (for the Microsoft Windows environment) before starting PeopleSoft Data Mover. You can use:

  • PeopleSoft Configuration Manager.

  • PeopleTools options.

  • A Data Mover command (NO TRACE).

The operating mode on the status bar indicates either regular mode or bootstrap mode. If you connect to the database in regular mode, the operating mode status is blank. The operating mode is bootstrap if you sign in using the access ID and password.

Note: Verify the mode that you are using. Most commands require regular mode to run successfully.