Archive for the 'System Administration' Category

Difference between Custom Objects and Customized Objects

I know this sounds little stupid for some people, but for some people this is helpful. I know one guy who gets confused all the time with these two terms and comes and asks me all the time. I thought I would list these here and ask him to remember PeopleSoftGuys.com, so that he can [...]

PeopleSoft Change Assistant

 
PeopleSoft change assistant is a standalone application delivered with PeopleTools 8.4x onwards. PeopleSoft change assistant can be used for applying patches and fixes for maintenance updates.
PeopleSoft change assistant grabs all the required information from the Environment Management Hub and uploads it to the PeopleSoft customer connection site. With this environment information, PeopleSoft customer connection will [...]

UNIX Commands to delete older files

Recently I wrote the following UNIX command line code to delete the older files in report repository and log files. I thought it might be useful for some one.
Reports Delete
find /psreports/PSPROD/* -type d -prune -mtime +15 -exec /bin/rm -R {} \;
The above command will delete all the directories under /psreports/PSPROD directory which are 15 days [...]

COMMIT statement usage in PeopleSoft Data Mover

PeopleSoft Data Mover issues COMMIT statements after most successful SQL commands, except for EXPORT and IMPORT commands. But for EXPORT and IMPORT commands, PeopleSoft Data Mover issues a COMMIT after each record. With IMPORT commands you can associate a  SET COMMIT n command, which will perform a COMMIT after the system inserts every n rows.
Example:
SET [...]

PeopleSoft Data Mover Commands

ENCRYPT_PASSWORD
 Encrypt one or all user passwords defined in PSOPRDEFN table.
  Example: ENCRYPT_PASSWORD ROGERS;
EXPORT
 EXPORT command will be used to export the data from a table or a join of tables and store the result set in a file. You can use the generated export file as input for migrating data to any another platform.
Example:
SET OUTPUT C:\PS_CUSTOMER.dat
EXPORT [...]

PeopleSoft Data Mover Operating Modes

You can connect to PeopleSoft data mover in two modes depending on the previlages that your user id has. The following two are the modes that you can connect to the data mover.

Regular mode.

Most of the time you connect using this mode. To sign in to the data mover in regular mode, enter your PeopleSoft [...]

Killing a long running tuxedo service or a query.

Before you kill any service you need to identify the service to be killed. Find out from the database which pid is stuck  or go to /psappsrv and run the psadmin to take a look at the server status to see which query is not idle
Go to /psappsrv location
type psadmin and hit enter
select your domain and choose “TUXEDO command [...]

Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server

One of the users reported that she was getting the above error when she runs a private query.
I found out that this query is bringing back around 100,000 rows back and which is taking a lot of memory and the size.
To overcome the issue I asked her to adjust the query to bring the less [...]

Improving the System Performance by Enabling Server Cache

With PeopleTools 8.4 and higher PeopleSoft delivered a great feature to improve the online performance, which is shared caching. This will eliminate the unnecessary caching and trips to the database.
Without enabling the shared cache, application server domain will create separate cache file for each process. With shared cache enabled all the user processes will share [...]

Changes needed to make to switch the URL from machine (host name) name to a DNS.

• Your systems people should create a DNS entry to point the IP address to a custom alias.
• If you are on UNIX open etc/host file to include the new host name.
• Go to weblogic admin page and change the PIA portal if needed.
• If the environment is already configured for machine name, go to Process Scheduler -> Report [...]