Peoplesoft dba people tool

You can combine database retrieval and row processing. Application Engine focuses on set-based SQL logic and goes to a much deeper level of the underlying application definitions.

Application Engine has been pretty popular and is a part of Oracle Fusion as well? SQL has the advantage of being a little bit more independent of the applications. Since SQR is application independent, so the drawbacks include its inability to work with Trees, effective dating, setids, row-level security, related language records, etc. Application Engine on the other hand comes with the knowledge of the PeopleSoft application, however, its drawback is that its a very PeopleSoft-specific tool.

App Engine lacks any kind of built-in output capability. Meta-SQL expands to platform-specific SQL substrings and then causes another function to be called, or substitutes a value. Not all Meta-SQL can be used by all programs. Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies.

Performed monthly security audits e. Application Designer Access, Generic ID's, Support staff access, 'Super User' access, local accounts, etc Implemented shared cache feature to improve response time after initial login. Co-ordinate with Oracle DBA team in performance tuning and database refresh activities and also with Unix Server team for any OS patch maintenance activities. Installed PeopleTools client, Crystal, and Oracle clients on developers work stations.

Performed object and code migrations of customizations and maintenance patches and fixes. Creating users in PIA, resetting, dropping the users and granting the required roles and privileges. Creating Roles, Permission list, adding components to Permission list.

Involved in SQL tuning and troubleshoot other performance related issues. Tuned Application Servers, Web Servers for performance improvements. Monitoring the Sessions in Production database and killing the unwanted sessions as per the request.

Analysing AWR report to find the root cause for long running queries and get it tuned accordingly to improve the performance. Did analysis, trace and debugging of the processes which are running slow and took necessary action to get good performance Cleaning up the Stale data in Prcs scheduler tables in Production and Non-Production environment from backend to ensure that the Prcs server is working fine.

Performed Oracle database refreshes as needed so as to facilitate the implementation of patches and fixes as delivered by PeopleSoft. Applied PeopleTools upgrade patch from PT8. Worked on setting up and configuring PeopleSoft Change Assistant to perform updates and upgrades.

Performed and prepared vanilla compare report to find the customizations. Worked with functional analysts to determine upgrade strategy for each customization. Streamlined the upgrade process to complete within the allotted upgrade window. Configured Integration Broker on new hardware and addressed various problems for developers. Applied Tax updates for multiple clients.

If the script is edited in Unicode format, then the default save is Unicode. Understanding Data Mover Scripts. Understanding Syntax Rules. Either let the files alter in place or run the script that it generates to alter any tables that it marks as out of synchronization. Never recreate option. Using PeopleTools Utilities. Ensuring Data Integrity. This can be useful in scheduling audit routines or extracting data from the PeopleSoft database. Check with the database vendor for restrictions on the number of long columns allowed for the platform.

Do not run unattended PeopleSoft Data Mover sessions. Close the session as soon as all scripts terminate. If you plan to import or export files greater than 2 gigabytes GB on UNIX, you must enable large file support at the operating system level. Select to view all available files in a directory. DMS and. When performing upgrades, use the SQL utility for the platforms to run. You can monitor the script's progress in the output pane, which reveals any error messages and displays the message Script Completed when processing has ended.

Typically, you use the Database Setup utility during PeopleSoft installations and upgrades, not on a daily basis. If you are performing an installation, use the documentation included in your PeopleSoft installation guide, which provide specific details regarding your applications, languages, and RDBMS. This section provides a general overview and is not specific to the installation procedure. If you sign in to PeopleSoft Data Mover using regular mode, not bootstrap mode, the Database Setup menu item is not available.

For instance, if the database that you are creating will run on an Oracle server, select Oracle. Select the appropriate type for the system. Select a character sets. Your choices vary depending on the database type that you selected.

Only the applications that you have licensed appear. Select the applications for which you want to create PeopleSoft Data Mover scripts. To add applications selectively, use the Add button. To add all applications available, use the Add All button. Use theRemove button to remove a single application, or use the Remove All button to clear the list box. Specify what the result of running the script should be. Options are:. Demo: Select to create a demonstration database.

Add New Language: Select to add support of new languages to an existing database. With this option selected, only non-PT database codes appear. Enter the name of the database against which to run the script. The database name that appears is the database to which you are currently signed on.

If the script that you are creating will be run against another database, specify the appropriate name here. If you generate a script for a database other than the current database, the system uses a default database using the following convention: XX DMO for demonstration databases and XX SYS for system databases.

The XX represents the product code, such as HR. Enter the ID used as the key to retrieve the access ID and access password. For initial installation, set it equal to the database name. This ID is used for the initial connection to the database. Any two-tier connection requires a connect ID.

You determine the name of the table owner ID during the initial installation. SQL script when you create tablespaces during the installation. After running the Database Setup utility, check the output directory for the generated script. Some commands are added that call other scripts and perform various functions. These commands are added to reduce the number of scripts and commands that you must run manually. For example, note that the following commands appear at the end of the script:.

This command creates any necessary temporary table images. If you selected a base language other than English, this command modifies the system to recognize that language as the base language. DMS to load the system with the appropriate PeopleTools messages error and informational messages. The system runs these scripts only if you have selected a base language other than English.

This section provides an overview of the PeopleSoft Data Mover command-line interface and discusses how to:. The command-line interface is designed only for running scripts, not creating and editing scripts. In UNIX, you can use any supported text editor.

When using the command-line interface, the results of the script run appear in the command-line window, much like the contents of the output pane in the PeopleSoft Data Mover GUI. The system also writes this information to the log file. Although the command-line interface also runs on Windows machines, this documentation primarily discusses UNIX.

Next, configure the psconfig. The UNIX environment requires certain platform-specific environment variables. These variables are set automatically, but you can reconfigure the psconfig.

When you run psconfig. Data Mover output, log file and trace file path. Specifies the directory where PeopleSoft Data Mover searches for input data. DAT files. Specifies the directory where PeopleSoft Data Mover writes the output data.

If you want to perform tracing under UNIX, you must set additional environment variables. See Setting Up Tracing. To configure tracing for PeopleSoft Data Mover, you must edit the psdmtx.

Use the TraceSql bitfield parameter to set the level of the SQL trace by adding together the numeric values that represent each degree of tracing required. The values are defined as follows:.

The system only uses the TraceFile value when TraceSql is set to a value greater than 0. For example,. At a command prompt, change to the program directory and issue the psdmtx command with the appropriate parameters.

Use the following standard syntax to run most Data Mover scripts:. The value of each parameter follows the parameter name, separated by zero or more spaces. The -CS server parameter is required only for the Informix and Sybase database platforms. You must enclose a value in quotation marks only when it includes a hyphen or forward slash, or to include leading or trailing spaces. To display a listing of all the command-line parameters and their arguments at the command prompt, enter:.

Standard Command Line Parameters. The following table lists the standard command-line parameters and arguments for running the psdmtx command:.

Specify the database type. Optional Specify the name of the database server for the database to which you're connecting. Specify the name of the database to connect to, as you would when signing in to PeopleSoft. This parameter is required only if you're running PeopleSoft Data Mover in regular mode. Using a Parameter File. Rather than submitting parameters manually on the command line, you can have PeopleSoft Data Mover read a file that contains appropriate parameters.

Create a text file that contains a complete set of parameters as you would enter them on the command line. If you submit a parameter file name and path to PeopleSoft Data Mover as the first parameter in the command line, PeopleSoft Data Mover reads the contents of the file and interprets them as parameters entered on the command line. For security reasons, after PeopleSoft Data Mover interprets the contents, it immediately deletes the parameter file.

This section provides the details of syntax and use for each of the PeopleSoft Data Mover commands. Creates temporary table images for use with PeopleSoft Application Engine programs. You also need to review the number of temporary tables allotted for PeopleSoft Application Engine programs. DMS scripts generated by the Database Setup utility.

This enables PeopleSoft Data Mover to continue processing until all of the view definitions have been processed, and all errors have been written to the current. LOG file or an error log file. Encrypts one or all user passwords user passwords and access passwords.

Creates a single export file containing the specified database contents. The result set can contain any of the following: a single PeopleSoft record, a group of records, or the entire database. Records exported using EXPORT can have a maximum of total columns and multiple long columns within the limitations for long columns set by the database platform. After each record, PeopleSoft Data Mover indicates how many records remain.