Editing the PeopleSoft Process Scheduler Configuration File
This section discusses the parameters in the Process Scheduler Configuration (PSPRCS.CFG) file.
The sections in the PeopleSoft Process Scheduler configuration file vary, depending on the operating system from which the PeopleSoft Process Scheduler Server is started.
The following table lists which sections can be found in the PeopleSoft Process Scheduler configuration file based on the operating system:
Section |
Windows |
UNIX |
---|---|---|
Startup |
X |
X |
Database Options |
X |
X |
Trace |
X |
X |
Process Scheduler |
* |
* |
Tuxedo Settings |
X |
X |
Interface Driver |
X |
X |
PSTools |
* |
* |
PSAESRV |
X |
X |
PSDSTSRV |
X |
X |
PSANALYTICSRV |
X |
X |
Application Engine |
|
|
SQR |
* |
* |
Remote Call |
X |
X |
nVision |
X |
|
SMTP Settings |
X |
X |
Cache Settings |
X |
X |
Integration Broker |
X |
X |
* Denotes where parameters found in this section differ, based on the operating system in which the PeopleSoft Process Scheduler configuration file is located.
The PeopleSoft 9.2 Application Installation documentation provides the procedure for configuring a PeopleSoft Process Scheduler Server using the basic default values. This section discusses each value that is available in each section.
This is the first section that you encounter when using PSADMIN to configure a PeopleSoft Process Scheduler Server Agent:
Parameter |
Description |
---|---|
DBName |
Specify the database name that is associated with a PeopleSoft Process Scheduler Server Agent, such as HRDMO, FSDMO, SADMO, and so on. |
DBType |
Specify the database type: DB2UNIX, MICROSFT, or ORACLE. |
UserId |
Enter the user ID. For Enterprise Resource Planning, this is typically VP1, and for Human Resources, it’s PS. |
UserPswd |
Enter the user password. For Enterprise Resource Planning, this is typically VP1, and for Human Resources, it’s PS. |
ConnectId |
Enter the connect ID. This value is required for all platforms. |
ConnectPswd |
Enter the connect password. This value is required for all platforms. |
ServerName |
Note: Keep the parameter blank because Informix and Sybase are no longer supported. |
StandbyDBName |
Specify a standby database for use with Oracle Data Guard. |
StandbyDBType |
Specify a standby database type for use with Oracle Data Guard. |
StandbyUserId |
Specify a standby user ID for use with Oracle Data Guard. |
StandbyUserPswd |
Specify the password for the standby user ID. |
InMemoryDBName |
Note: This parameter is reserved for Oracle internal use only. |
InMemoryDBType |
Note: This parameter is reserved for Oracle internal use only. |
See Implementing Oracle Active Data Guard.
When you change the UserPswd or ConnectPswd field, you are prompted for an option to encrypt the value entered for the password field. The default is to encrypt the password.
The domain connection password adds an extra layer of security between the application server domain and any connections made to it. This password enables you to further prevent unauthorized clients from establishing connections to an application server domain. It is recommended to use PSADMIN to update this value. The value can be up to 30 characters.
Parameter |
Description |
---|---|
Process Scheduler Port |
Specify the port on which the Process Scheduler will listen for events sent by the application server domain. |
Application Server Credentials |
Specify the credentials
for the Application Server from which notifications will be received
in the format:
|
For more information on this section in psprcs.cfg, see (Optional) Configuring Process Scheduler System Settings for Push Notifications.
Use this section for database-specific configuration options:
Parameter |
Description |
---|---|
UseLocalOracleDB |
Indicate whether the PeopleSoft database to which you are connecting is in a local Oracle System Identifier (SID). The default is 0, which indicates that the PS database to which you are connecting is remote. Note: For the Windows operating system, the parameter "UseLocalOracleDB" is not supported when using a 32 bit client connecting to a 64 bit database. See UseLocalOracleDB |
EnableDBMonitoring |
Add to the configuration file for database-level auditing. It is a required parameter. Use this option to view more information regarding the clients that are connected to a database server through the process scheduler server. For instance, with this enabled, you can view the client machine name or user ID that is associated with a particular connection. See EnableDBMonitoring. |
EnableAEMonitoring |
You must set the EnableAEMonitoring configuration setting to 1 to populate the MODULE and ACTION fields in V$SESSION and V$SQL views. By default, EnableAEMonitoring is set to 0 (disabled). To change the EnableAEMonitoring setting for an Application Server domain or a Process Scheduler domain, use the PSADMIN utility or manually modify the PSPRCS.CFG configuration file or the PSAPPSRV.CFG configuration file, then restart the respective servers. |
Use this section to set trace values for performance monitoring and troubleshooting:
Parameter |
Description |
---|---|
TraceFile |
This applies to Windows only and indicates the file to which SQL traces are written when TraceSQL has a value greater than zero. SQL traces for the following programs are written to this file: nVision, and Cube Manager. Other processes—such as Application Engine, SQR, and COBOL—have the SQL traces written to a separate subdirectory under the directory specified for the Log/Output Directory parameter. See the Log/Output Directory parameter. |
TraceSQL |
Specify a SQL trace value for troubleshooting. It is implemented as a bit field. Possible values for TraceSQL are listed later in this section. |
TracePC |
Specify a trace value for troubleshooting PeopleCode. This is used by PeopleSoft Application Engine when it runs PeopleCode. Possible values for TracePC are listed later in this section. |
TraceAE |
Specify the trace options that are specific to PeopleSoft Application Engine. Trace information based on this option is written to a file with the following format: <Application Engine program name>_<Process Instance>.AET Possible values for TraceAE are listed later in this section. |
AETFileSize |
This parameter is used to specify the maximum file size (in MB) of the AE trace file. The minimum value is taken to be 20 MB by default and the maximum value limit is set to be 1500 MB. |
TraceAECombineOutput |
Set this parameter to Y to merge People Code and SQL trace output into AET file. Default is N. |
TraceAEEnableSection |
Set this parameter to Y to enable section level trace. Default is N i.e. section level trace will be disabled and AE traces will be controlled by TraceAE setting only. |
TracePPM |
The Performance Monitor agent is a thread that reports performance metrics for each instrumented server if monitoring is enabled for the database. Select 1 to enable and 0 to disable. See Performance Monitor. |
The following table lists the possible values for TraceSQL:
Bit |
Constant |
Type of Tracing |
---|---|---|
0 |
%TraceSQL_None |
No output. |
1 |
%TraceSQL_Statements |
SQL statements. |
2 |
%TraceSQL_Variables |
SQL statement variables. |
4 |
%TraceSQL_Connect |
SQL connect, disconnect, commit, and rollback. |
8 |
%TraceSQL_Fetch |
Row fetch (indicates that it occurred and the return code, not data). |
16 |
%TraceSQL_MostOthers |
All other application-programming interface (API) calls, except Set Select Buffers (ssb). |
32 |
%TraceSQL_SSB |
Set Select Buffers (identifies the attributes of columns to be selected). |
64 |
%TraceSQL_DBSpecific |
Database API-specific calls. |
128 |
%TraceSQL_Cobol |
COBOL statement timings. |
1024 |
%TraceSQL_DB2390Server |
Turn on the tracing of diagnostic messages returned by the D22 z/OS %UpdateStats() command. |
The following table lists the possible values for TracePC. Use these by adding the numbers together, or by specifying more than one constant:
Bit |
Constant |
Type of Tracing |
---|---|---|
1 |
%TracePC_Functions |
Provide a trace of the program as it is run. This implies options 64, 128, and 256. |
2 |
%TracePC_List |
Provide a listing of the entire program. |
4 |
%TracePC_Assigns |
Show the results of all assignments made to variables. |
8 |
%TracePC_Fetches |
Show the values fetched for all variables. |
16 |
%TracePC_Stack |
Show the contents of the internal machine stack. This option is normally used for debugging the PeopleCode language, not PeopleCode programs. |
64 |
%TracePC_Starts |
Provide a trace showing when each program starts. |
128 |
%TracePC_ExtFuncs |
Provide a trace showing the calls made to each external PeopleCode routine. |
256 |
%TracePC_IntFuncs |
Provide a trace showing the calls made to each internal PeopleCode routine. |
512 |
%TracePC_ParamsIn |
Show the values of the parameters to a function. |
1024 |
%TracePC_ParamsOut |
Show the values of the parameters as they exist at the return from a function. |
The following table lists the possible values for TraceAE:
Bit |
Type of Tracing |
---|---|
1 |
Trace STEP execution sequence to AET file. |
2 |
Trace Application SQL statements to AET file. |
4 |
Trace dedicated temporary table allocation. |
8 |
Trace temporary table data. |
128 |
Timings report to AET file. |
256 |
Method/BuiltIn detail, instead of summary in AET Timings report. |
1024 |
Timings report to tables. |
2048 |
DB optimizer trace to file. |
4096 |
DB optimizer trace to tables. |
8192 |
Trace Integration Broker transform programs. |
After you set trace values, use the Process Scheduler section to set the environment variables that are associated with PeopleSoft Process Scheduler.
Warning! The default values for PS_HOME here and in future sections assume that you set up SQR, and nVision locally on the batch server. You can point to those items on the file server, but, if so, you must use a full path. You cannot use a PS_HOME environment variable because PSADMIN employs the PS_HOME environment variable to point to a local directory on the batch server.
Parameter |
Description |
---|---|
PrcsServerName |
Specify the process server name. This must match the name defined in the Server Definition table, such as PSNT. |
DBBIN |
Enter the path to the database drivers (that is, your connectivity software). |
Max Reconnect Attempt |
Specify the maximum number of attempts that the PeopleSoft Process Scheduler Server Agent tries reconnecting to the database when the connection is lost. When the maximum number of attempts is reached, and the agent hasn’t successfully connected to the database, the agent shuts down. |
Reconnection Interval |
Specify the interval, in seconds, between attempts to reconnect to the database when the connection is lost. |
Authentication Timeout |
Specify the duration, in minutes, allotted before PeopleTools security module times-out authenticating a process released by Process Scheduler. The timer starts from the time Process Scheduler initiates the request |
Allow Dynamic Changes |
Specify dynamic changes to certain settings without having to reboot the domain. The settings that can be dynamically changed are Recycle Count, Consecutive Service failures, Trace SQL, Trace Mask SQL, TracePC, TracePCMask, TracePpr, TracePprMask, Log Fence, Enable DB Monitoring, and Enable Debugging. |
Log/Output Directory |
Specify the directory in which files that are generated by the program are written. When PeopleSoft Process Scheduler initiates a process request, it creates a subdirectory in the format <Process Type ID>_<Program Name>_<Process Instance> that contains the generated files. For instance, the SQR program has all the reports, trace, and log files in the subdirectory SQR_XRFWIN_20. It is also the optional directory used with the Output Destination field when scheduling a request. This variable (%%OutputDirectory%%) can be used in the File/Printer field of the Process Scheduler Request dialog box. Note: The output directory has an extra slash attached at the end. |
Output Directory Optional Extension |
Specify the optional subdirectory structure that can be appended to the designated Log/Output Directory. Additional meta-string that can be used include:
For example, %CURRDATE%\%CURRHOUR%. |
LogFence |
Enter the PeopleSoft Process Scheduler tracing levels, such as 3. Note: By default, the LogFence value is set to 3. Set the value to 5 to generate a more detailed log file. |
LogFieldSeparator |
See LogFieldSeparator. |
Trace-Log File Character Set |
|
Log Directory |
See Log Directory. |
Log Space Threshold |
Specify the space threshold, in megabytes (MB), for the log/output directory. Once the space goes below this threshold, the PeopleSoft Process Scheduler stops processing until more disk space becomes available. The Server Monitor shows a status of Suspended — Disk Low. |
File Chunk Size |
Specify the size of memory in KB, allocated to store the value read from a file when transferring files to the Report Repository via HTTP. The default is 4096 KB (4 MB). |
CBLBIN |
Enter the path to COBOL executables, such as %PS_HOME%\CBLBIN. |
TEMP |
Enter the local temporary directory, such as %TEMP%. |
TOOLBIN |
Enter the location of the PeopleTools executables, such as %PS_HOME%\bin\client\winx86. |
TOOLBINSRV |
Enter the location of the server version of PeopleTools executables, such as %PS_HOME%\bin\server\winx86. |
WINWORD |
Enter the path to Microsoft Word executables, such as c:\apps\office97\winword. Note: If spaces exist in the path, you must modify the Process Type Definition and add quotes around the entry in the Command Line field, for example " %%WINWORD%%\WINWORD.EXE". These must be in the batch server environment. |
DEFAULTPRINTER |
Enter the universal naming convention (UNC) path of the printer where reports are printed when the %DefaultPrinter% was specified as the output destination. |
Update Table Stats on Purge |
Set to run statistics for the Process Request and Report Manager tables during the Process Scheduler server purge process. 0: Disable. 1: Enable. Note: This flag is ignored if the DBFlags bitfield parameter is disabled. |
The following table lists the possible values for LogFence:
Level |
Type of Tracing |
---|---|
0 |
Status information. |
1 |
General errors. |
2 |
Warnings. |
3 |
Informational. |
4 |
Tracing Level 1. |
5 |
Tracing Level 2 (detail). |
The following table describes each parameter in the Tuxedo Settings section:
Parameter |
Description |
---|---|
Restartable |
Specify Y or N to instruct Tuxedo to restart a PeopleSoft Process Scheduler Server Agent or Distribution Agent if it is terminated abruptly. |
Grace Period |
Specify the period time in seconds in which Tuxedo will attempt to restart the Process Scheduler Server. For example, Grace Period = 600, Max Restart Attempt = 5. Tuxedo attempts to restart the PeopleSoft Process Scheduler server five times within 30 minutes of when the server comes down. |
Max Restart Attempt |
Specify the maximum number of restarts in the grace period. |
Add to PATH |
(Optional) Specify an additional directory that is appended to the PATH environment variable. |
Spawn Threshold |
Enter a parameter that's supplied to Tuxedo for control of process spawning by using the -p command-line option for all server processes. The default setting (1,600:1,1) rarely needs to be changed. For more information see Spawn Threshold. |
Cognos/Cube Manager
Installs: Make sure to specify the proper path for Cognos in the Add
to Path parameter. By default, that path is C:\Program Files\Cognos\cer2\bin;C:\ODI\OStore\bin.
Note: Cognos and ODI are the important top-level directories and can change, depending on the install.
The following table describes the parameter in the Interface Driver section:
Parameter |
Description |
---|---|
SCP_LOCALE |
Defines the RPS_LOCALE string that is sent to the PeopleSoft Supply Chain Planning server. |
Use this section to specify a character set. The default value is UTF-8.
Parameter |
Description |
---|---|
Enable Remote Administration |
Set the value to 1 to enable embedded JMX agents, 0 to disable embedded JMX agents. JMX agents must be enabled to use the PeopleSoft Health Center. |
Remote Administration Port |
Specify the port number to use for remote administration of domain processes. All embedded JMX agents will use the port in the JMX service URL. |
Remote Administration UserId |
Specify the username for remote administration connections. |
Remote Administration Password |
Specify the pscipher encrypted password for remote administration connections. See Encrypting Passwords. |
Remote Administration SSL Enabled |
Set this parameter to 1 to enable SSL for JMX Agents and to 0 to disable SSL for JMX Agents. Default is 0 i.e. SSL for JMX Agents will be disabled. Other settings are optional if SSL for JMX Agents is disabled. |
Remote Administration SSL Keystore |
Specify the location of the Keystore file for remote administration connections. |
Remote Administration SSL Keystore Password |
Specify the pscipher encrypted Keystore password for remote administration connections. |
Remote Administration SSL Keystore Type |
Specify the Keystore type for the keystore you had created for enabling SSL. Options are PKCS12 or JKS. See the documentation for Java Security Standard Algorithm Names in Oracle Help Center. |
Remote Administration SSL Truststore |
Specify the location of the Truststore file for remote administration connections. |
Remote Administration SSL Truststore Password |
Specify the pscipher encrypted Remote Administration SSL Truststore Password. |
Remote Administration SSL Truststore Type |
Specify the Truststore's Keystore type for the truststore you had created for enabling SSL. Options are PKCS12 or JKS. See the documentation for Java Security Standard Algorithm Names in Oracle Help Center. |
EnablePPM Agent |
Controls whether the Performance Monitor agent runs and collects performance monitor data. Enter 1 to enable the Performance Monitor agent, and 0 to disable the Performance Monitor agent. This setting overrides the value for this parameter that is set in the database. |
JavaVM Shared Library |
Indicate which Java Virtual Machine (JVM) library to use. Note: You must manually update the psprc.cfg file, as this option is not available using the PSADMIN utility. |
Add to CLASSPATH |
The Add to CLASSPATH parameter tells the Java Virtual Machine (JVM) where to find the Java class libraries, including user-defined class libraries. Because PeopleTools automatically generates CLASSPATH entries for core delivered class libraries, use this field to specify any custom or additional class libraries that must be accessed by PeopleTools or PeopleCode. The PeopleCode API Reference provides details on where you can place custom and third-party Java classes. |
JavaVM Options |
Set options to the list of parameters required. Use a space to separate parameters (for example, -Xmx256m -Xms128m). The following setting is used to enable communication with the REN server using SSL protocols that adhere to corporate security standards: -Dhttps.protocols=TLSv1.1,TLSv1.2 If this option is not already set, either add it manually to the JavaVM Options section in psprcs.cfg and then restart the process scheduler domain or take the latest patch, then drop and recreate the process scheduler domain. Set option -Xrs if you have PeopleSoft Process Scheduler set up as a Windows service on Windows. Options must be set if you are using HTTP transfer protocol and receiving Java exception thrown: java.lang.OutOfMemoryError. AIX customers should set this option to -Xrs -Djava.awt.headless=true -Xcheck:jni Note: You must manually update the psprc.cfg file, as this option is not available using the PSADMIN utility. |
Character Set |
Specify the default character set for non-Unicode processing performed by this process server. The default value is UTF-8. This is the character set that PeopleSoft supports for use with all Western European languages, including English. If the process server will be used only to process Western European data, accept the default. Otherwise, select one of the valid character set choices listed later in this section. Note: The character set selected for the process server should be the same as the character set specified for the application sever. |
Proxy Host |
This setting is used by the distribution agent if your architecture includes a firewall between the process scheduler server and the report repository (webserver). Note: If your architecture includes a firewall between the process scheduler server and the report repository (webserver), the distribution agent must tunnel through this firewall via a proxy server in order to transfer reports successfully. Set this value to the domain name of the proxy server only if your architecture includes a firewall between the process scheduler and the report repository (web server). Configure the firewall to allow outgoing HTTP or TCP connections to originate only from the proxy server host. You can configure the proxy server to restrict access to only PeopleSoft and perform tasks, such as logging HTTP activity. |
Proxy Port |
If PeopleSoft Process Scheduler is behind a proxy server, set this value to the port of the proxy server. |
Non Proxy Hosts |
Enter a list of the hosts that should be connected to directly, not through a proxy server. Separate the host names with a pipe symbol ( | ). You can use an asterisk (*) as a wildcard character to specify a pattern of similar host names. For example, |
DbFlags |
Enter 0 to issue the command to update table statistics to the database. Programs like PeopleSoft Application Engine and COBOL use the metaSQL %UpdateStats to run the command that runs statistics to a specific table. Otherwise, select one of the valid choices listed later in this section. Note: The Update Table Stats on Purge parameter is ignored if this parameter is disabled. |
Suppress App Error Box |
Use to suppress the console's Application Error dialog box after an application error occurs. Y suppresses the dialog box. |
Process exit grace period |
When a PeopleSoft Application Engine job completes, it has a specified number of seconds to exit. If the process has not exited when the grace period expires, it is terminated through a psreaper process. A grace period of 0 disables the psreaper process. |
ScheduledQuery-CSVUnicodeEncoding |
This setting is used to configure CSV output encoding for scheduled PSQueries. The default value is UTF8. The other valid encoding settings are UCS2, UTF8BOM, and ASCII. This setting applies only when OutputUnicode property of query class is set to True and scheduled query is set to ‘TXT’ format. Note: This is not a required setting. If it is not set, the CSV output encoding will be UCS2 with BOM. |
The following table lists valid character set choices:
Character Set |
Description |
---|---|
latin1 |
Latin–1- ISO 8859-P1 - Microsoft codepage 1252 |
sjis |
Japanese Shift-JIS - Microsoft codepage 932 |
big5 |
Traditional Chinese - Microsoft codepage 950 |
gb |
Simplified Chinese - Microsoft codepage 936 |
ks-c-5601-1987 |
Korean Wansung - Microsoft codepage 949 |
ks-c-5601-1992 |
Korean Johab - Microsoft codepage 1361 |
See Global Technology.
The following table lists possible values for DBFlags bitfield:
Bit |
Description |
---|---|
0 |
(Default) Issue the command to update table statistics to the database. |
1 |
Ignore metaSQL to update database statistics (shared with COBOL). |
2 |
Not yet allocated. |
4 |
Disable second database connection. |
8 |
Disable persistent secondary database connection. |
16 |
Not yet allocated. |
32 |
Not yet allocated. |
64 |
Not yet allocated. |
128 |
Not yet allocated. |
256 |
Not yet allocated. |
Note: The JavaVM Options parameter specified in the [PSTOOLS] section specifies global JavaVM options used by every server process in a domain. To override this global value for a particular server process, you can apply custom JavaVM options to individual server processes by adding the JavaVM Options parameter manually to the configuration section for that server process.
JavaVM Options can appear multiple times in a single PSAPPSRV.CFG or PSPRCS.CFG file. While the JavaVM Options value in the [PSTOOLS] section applies to all server processes governed by a particular configuration file, the system only uses the JavaVM Options value in the [PSTOOLS] section for server processes that do not have the JavaVM Options parameter added to its configuration settings section.
For example, if the JavaVM Options parameter has been added to the [PSAPPSRV] section of the PSAPPSRV.CFG file and has been assigned a value, then that value will be used when loading the JVM as a thread of that PSAPPSRV process. If the JavaVM Options parameter does not appear, or has no value, in the [PSAPPSRV] section, then the system uses the value specified in the [PSTOOLS] section when loading the JVM as a thread of the PSAPPSRV process. This applies to any server process: PSAPPSRV, PSQRYSRV, PSAESRV, and so on.
The following table describes each parameter in the PSAESRV (Application Engine Tuxedo Server) section:
Parameter |
Description |
---|---|
Max Instances (maximum instances) |
Specify the maximum concurrency set for process types with a generic process type of Application Engine, as defined on the Server Definition page in Process Scheduler Manager. |
Recycle Count |
Specify the number of services after which PSAESRV automatically restarts. If this is set to 0 (default), PSAESRV is never recycled. |
Allowed Consec Service Failures (allowed consecutive failures) |
Specify the number of consecutive service failures after which PSAESRV automatically restarts. If this is set to 2 (default), PSAESRV is never recycled. |
ProcessRestartMemoryLimit |
|
ScheduledQuery-DirtyRead |
This parameter only applies to DB2. Indicates if dirty reads are enabled. Setting this to 1 enables the application server to read uncommitted data from a table. |
The following table describes each parameter in the PSDSTSRV (Distribution Agent Tuxedo Server) section:
Parameter |
Description |
---|---|
Max Instances |
Specify the maximum number of PSDSTSRVs that can be started within Oracle Tuxedo. Default is 1. |
Min Instances |
Specify the minimum number of PSDSTSRVs that can be started within Oracle Tuxedo. Default is 1. Tuxedo will initially start count specified in the minimum instance setting. |
Recycle Count |
Specify the number of services after which PSDSTSRV automatically restarts. If this is set to 0 (default), PSDSTSRV is never recycled. |
ProcessRestartMemoryLimit |
|
Allowed Consec Service Failures |
Specify the number of consecutive service failures after which PSDSTSRV automatically restarts. If this is set to 0 (default), PSDSTSRV is never recycled. |
Max Fetch Size |
See, Max Fetch Size. |
The following table describes each parameter in the PSANALYTICSRV (Analytic Engine Tuxedo Server) section:
Parameter |
Description |
---|---|
Max Instances |
Specify the total number of OptEngines = number of single queues + number in the MSSQ (read by ubbgen.cpp to calculate MAXSERVERS and MAXSERVICES in psprcsrv.ubb). Only MSSQ allows spawning. |
Service Timeout |
Limit the period that PSANALYTICSRV might block PSPRCSRV. |
Opt Max General Services |
Specify the number of each service declared in the corresponding .ubx file. |
Opt MSSQ Instances |
Specify the number of OptEngines in the MSSQ. |
The following table describes each parameter in the PSRTISRV (Real Time Indexing Server) section:
Parameter |
Description |
---|---|
Min Instances |
Specify the minimum number of RTI server processes to run when the Process Scheduler domain is booted up. The default is 1. |
Max Instances |
Specify the maximum number of RTI server processes to run when the Process Scheduler domain is booted up. The default is 1. |
The following table describes each parameter in the SQR section:
Parameter |
Description |
---|---|
SQRBIN |
Enter the path to the SQR executables. |
PSSQRFLAGS |
Specify the SQR report arguments required for launching SQR. |
Print Log |
Indicate whether the SQR log files are also be printed when the output destination is Printer. |
Enhanced HTML |
Indicate whether reports are in enhanced HTML format when the output destination is HTM. |
PSSQR |
Stores multiple paths to SQR report file. You can also separate these paths by using the appropriate delimiter for UNIX and WINDOWS platform. Note: Settings for Windows
platform, Settings for UNIX platform, |
Note: In some cases, Application Engine programs require Java Runtime Engine (JRE) to be installed on the batch server.
See PeopleSoft 9.2 Application Installation for your database platform.
The following table describes each parameter in the Data Mover section.
Note: The values entered here should be the same as the values specified in the Configuration Manager.
Parameter |
Description |
---|---|
InputDir |
Specify the path for the Data Mover input directory (for example, %PS_HOME%/data). |
OutputDir |
Specify the path for the Data Mover output directory (for example, %PS_HOME%/data). |
LogDir |
Specify the path for the Data Mover log directory (for example, %PS_SERVDIR%/log_output). |
LastScriptsDir |
Specify the path for Data Mover to search the DMS script if the script specified in the command line cannot be found in the current directory or the absolute path. |
The following table describes each parameter in the RemoteCall section:
Parameter |
Description |
---|---|
RCCBL Timeout |
Specify the maximum allotted time, in seconds, to run Remote Call with PeopleSoft Application Engine. |
RCCBL Redirect |
If this parameter is set to 0, log files that are generated from Remote Call are not retained. If this parameter is set to 1, log files are redirected to the directory specified in the Log/Output Directory parameter. |
RCCBL PRDBIN |
Specify the location
of the COBOL executable. In Windows, the default location of the COBOL
executable is |
COBOL Platform |
Specify the CBLBIN path based upon the COBOL platform:
For further information on CBLBIN path see PeopleSoft 9.2 Application Installation. |
If you plan to have PeopleSoft Process Scheduler invoke PS/nVision jobs, specify the appropriate parameters in this section.
Parameter |
Description |
---|---|
DrillDownDir |
Specify the location of PS/nVision DrillDown files, such as %PS_HOME%\NVSION\LAYOUT\DRILLDN. Note: If this directory is in %PS_HOME% it will be read-only. Only an Administrator can add new layout or modify existing layouts. If all users need write access to this directory use a directory outside PSHOME . Note: For Windows 2008 , if a mapped drive path is used, it must be in UNC (universal naming convention) path format. |
ExcelDir |
Leave blank. |
InstanceDir |
Enter the location where PS/nVision places report instances, such as %PS_SERV%\NVSION\INSTANCE. Note: When the PS/nvision instance directory is set to a mapped network drive and the output format used is HTML, PS/nVision hangs. The workaround is to use the UNC path. |
LayoutDir |
Specify the location of the PS/nVision layout, such as %PS_HOME%\NVISION\LAYOUT. Note: If this directory is in %PS_HOME% it will be read-only. Only an Administrator can add new layout or modify existing layouts. If all users need write access to this directory use a directory outside PSHOME . Note: For Windows 2008 , if a mapped drive path is used, it must be in UNC (universal naming convention) path format. |
MacroDir |
Enter the directory containing macros for PS/ nVision and Query Link, such as %PS_HOME%\EXCEL. |
StyleDir |
Enter the default location where PS/nVision keeps nPlosion Styles (these are usually inherited by the layout that the user is designing). |
TemplateDir |
Enter the location of the QUERY.XLT file, which defines the Microsoft Excel styles for formatting output. The default is the \MacroDir, such as %PS_HOME%\EXCEL. |
EnableDrillDownForFile |
Use PS/nVision on the web. Indicate whether you want to enable drilldown on a report with the output type of file. 1 = Enable drilldown. 0 = Disable drilldown (default). |
EnablePollDialogs |
Use PS/nVision on the web. Indicate whether you want the system to poll and automatically kill unattended dialogs generated from PS/nVision in batch mode (for example, dialog messages from Excel displaying on the webserver). 1 = Enable poll dialogs. 0 = Disable poll dialogs (default). |
PollDialogSeconds |
Enter the time, in seconds, used to cycle polling for the dialog. |
TraceLevel |
Use PS/nVision on the web. Indicate whether you want the system to generate independent trace/log files, and at what level, for each nVision process. Trace files can be viewed from the Process Monitor Details - View Log/Trace page. 0 = Disable trace files (default). 1 = Generate basic high level information. 2 = Generate level 1 tracing plus high level code flow. 3 = Generate level 2 tracing plus SQL statements. 4 = Generate level 3 tracing plus most function calls and output values. Note: Extensive tracing will impact performance. |
SaveTempFile |
Indicate whether you want PS/nVision to save or delete the temporary reports created when running them to email, printer, or web output. 0 = Temporary reports will be deleted. (Default). 1 = Temporary reports will be saved. Note: Reports that are run to email or printer will be saved to the folder specified in the Directory Name Template field of the report request. Reports that are run to web will be saved to the PS/nVision instance directory. |
UseExcelAutomation |
Use this parameter to enable or disable Excel automation mode. The default value is 0. Do not change this value as this is currently the only mode under which nVision can run. |
AsofDateForLabels |
|
RetrieveActiveTreeLabels |
RetrieveActiveTreeLabels is used to specify whether only active tree node label descriptions are retrieved for nVision reports and drilldowns. The default setting RetrieveActiveTreeLabels=0 enables PS/nVision to disregard the activeness of the tree node label descriptions. When RetrieveActiveTreeLabels=1, nVision strictly use the activeness of the tree node label descriptions. |
If you plan to use Simple Mail Transfer Protocol (SMTP) mail server gateways, specify the appropriate parameters in this section.
When changes are made to any of the parameters in the SMTP section of the process scheduler configuration file (psprcs.cfg), the effect is immediate (even before the updated configuration file has been loaded by PSADMIN).
Note: The Allow Dynamic Changes flag, located in the General Settings section of the configuration file, has no effect on the SMTP parameters. Changes to the SMTP parameters are always dynamic.
Parameter |
Description |
---|---|
SMTPServer |
Specify the name of the corporate mail server gateway machine. Leave blank for an initial installation. |
SMTPPort |
Specify the port used by SMTP mail server gateways. |
SMTPServer1 |
Specify the failover corporate mail server gateway machine. Leave blank for an initial installation. |
SMTPPort1 |
Specify the port used by failover SMTP mail server gateways. |
SMTPSender |
Specify the sender’s internet address. This must be a valid internet address, such as [email protected]. Leave blank for an initial installation. |
SMTPSourceMachine |
Specify the sender’s source machine name and internet address in the form of MACHINE.XYZCORP.COM. Leave blank for an initial installation. |
SMTPCharacterSet |
Specify the character set used on the sender’s machine. |
SMTPEncodingDLL |
Specifies the name of a DLL used to translate the mail message to a non-Unicode character set. By default, all outgoing SMTP mail is sent in Unicode UTF-8. |
SMTPTrace |
See SMTPTrace |
SMTPSendtime |
Enter 1 to have messages contain a send time that is populated by the application server. Enter 0 to leave the send time blank and have it populated by the receiving gateway (depending on the gateway). |
SMTPUseSSL |
See SMTPUseSSL. |
SMTPSSLPort |
See SMTPSSLPort. |
SMTPClientCertAlias |
See SMTPClientCertAlias. |
SMTPSSLProtocol |
See SMTPSSLProtocol. |
SMTPUseSSL1 |
See SMTPUseSSL1. |
SMTPSSLPort1 |
See SMTPSSLPort1. |
SMTPClientCertAlias1 |
See SMTPClientCertAlias1. |
SMTPSSLProtocol1 |
See SMTPSSLProtocol1. |
Implementing NT LAN Manager
PeopleTools supports NT LAN Manager (NTLM) as a primary authentication mechanism. NTLM is a suite of authentication and session security protocols used in various Microsoft network protocol implementations. To use NTML with PeopleTools, you need to add these parameters manually to the PSAPPSRV.CFG file and PSPRCS.CFG file in the SMTP settings section.
Parameter |
Description |
---|---|
SMTPNTLMEnable |
Specify whether NTLM is enabled. Add true or false. |
SMTPNTLMDomain |
Specify the NTLM domain. |
SMTPNTLMEnable1 |
Specify whether NTLM is enabled for the backup server. |
SMTPNTLMDomain1 |
Specify the NTLM domain for the backup server. |
PeopleSoft Application Engine and Process Scheduler require a cache directory, which you specify in this section:
Parameter |
Description |
---|---|
MaxCacheMemory |
See, MaxCacheMemory. |
EnableCacheRepair |
See, EnableCacheRepair. |
AdjustMaxCacheMem |
See, AdjustMaxCacheMem. |
ExcessivePruningThreshold |
|
CacheMissThreshold |
See, CacheMissThreshold. |
MaxRepairCollection |
See, MaxRepairCollection. |
CacheBaseDir |
Enter the location of the cache directory. Leave the default selected, unless you have a compelling reason to change it. |
EnableServerCaching |
Specify a bit flag instructing how file caching is set up. The default value is 2. Note: This option is not included in the delivered psprcs.cfg file. However, if you must override the default setting, you can manually enter the option into the psprcs.cfg file. |
ServerCacheMode |
Set to 0 for one cache directory per process or 1 for a shared cache. The default value is 0. Note: This option is not included in the delivered psprcs.cfg file. However, if you must override the default setting you can manually enter the option into the psprcs.cfg file. |
EnableDBCache |
If enabled, the metadata (cache) is accessed from database, rather than the file-system. Note: To enable database caching for Process Scheduler domains, you may need to manually add EnableDBCache=Y. |
See Cache Settings.
The following table lists the possible values for EnableServerCaching:
Bit |
Type of Caching |
---|---|
0 |
Server file caching disabled. |
1 |
Server file caching is limited to most used classes. |
2 |
Server file caching for all types. |
The following table describes each parameter in the Integration Broker section:
Parameter |
Description |
---|---|
Min Message Size For Compression |
Specify the minimum size of message data for synchronous handler to enable compression. |
Note: If you decide to edit the configuration file directly, make sure that there are no spaces between the equal sign and the entries and no trailing spaces. After making the necessary changes, save this file.
The following table describes each parameter in the Search section:
Parameter |
Description |
---|---|
Deployment Type |
Specify the deployment type. If no option is provided, the application server automatically selects the preferred mechanism for the deployment platform. The deployment types are:
|
The following table describes each parameter in the Search Indexes section:
Parameter |
Description |
---|---|
Search Indexes |
Use this option to specify the location of all the files pertaining to the search index. Index name is same as the location. |
You can access and set the parameters in the LDAP section of the psprcs.cfg file.
For detailed information on the parameter and their settings please see, Configuring LDAP Connection Parameters.
These parameters trap
unwanted security parameters in the meta-strings passed as input to
a process. The system throws an error message if it finds any of these
parameters. For example; PARAMETER_EXCEPT01=%OPRID%
In case you have included
this setting in the psprcs.cfg file, the system will log appropriate
error message on seeing this %OPRID%
in the
parameter list passed to the process.
This section discusses the differences in parameter descriptions for UNIX operating system.
Process Scheduler Section
The following table lists the Process Scheduler section parameters for UNIX (rather than Windows):
Parameter |
Description |
---|---|
ProgramName |
Specify the name of the PeopleSoft Process Scheduler program, PSPRCSRV. |
PrcsServerName |
Specify the process server name. This must match the name defined in the server definition, such as PSUNX. |
Max Reconnect Attempt |
Specify the maximum number of times that the PeopleSoft Process Scheduler Server Agent will try to reconnect to the database when the connection is lost. When the maximum number of attempts is reached and the agent hasn’t successfully connected to the database, the agent shuts down. |
Reconnection Interval |
Specify the interval, in seconds, between attempts to reconnect to the database when a connection is lost. |
Log/Output Directory |
Specify the directory in which files that are generated by the program are written. When PeopleSoft Process Scheduler initiates a process request, it creates a subdirectory in the format <Process Type ID>_<Program Name>_<Process Instance> that contains the generated files. For example, the SQR program has all reports, trace, and log files in the subdirectory SQR_XRFWIN_20. It is also the optional directory used with the Output Destination field when scheduling a request. This variable (%%OutputDirectory%%) can be used in the File/Printer field of the Process Scheduler Request dialog box. Note: The output directory has an extra slash attached at the end. |
LogFence |
Enter the PeopleSoft Process Scheduler tracing levels. |
DEFAULTPRINTER |
Specify the UNC path of the printer where reports are printed when the %DefaultPrinter% was specified as the output destination. |
PSTools Section
For the Unix Character Set and Report Repository Character Set see Character Sets Across the Tiers of the PeopleSoft Architecture