Do you have a document listing most common/important admin commands, processes, configuration files in a PeopleSoft n-tier architecture?

Something like - PeopleSoft server/processes and PeopleTools important tables, App Server configuration related files and their locations, Web Server configuration related files and their locations.

I am new to PeopleSoft and would appreciate if you could provide and/or share this information.

The first step to become a PeopleSoft admin is to understand the architecture of PIA and have some idea on how it works.

I will add documents in the "Document" Menu and also update this topic whenever more documents are added. I will also provide links to the documents which are good for admins available on the internet. And also I will publish the ones that I have during the course of time.

To get the update of this discussion through email, you can register yourself and subscrible to this topic.

To start with I suggest the Architecture document by University of Bridgeport is a detailed document which explains about the architecture.

Also you can see the "Documents" page to get commands help. I will keep updating the page with more commands, especially for PSADMINs.

Thanks for your prompt response. The presentation from University of Bridgeport student is very useful.

Though I am new to PeopleSoft but I recently took the Server Amin training class and getting to better understand the PIA Architecture - it takes some time for the architecture/concepts to sink in.

I was trying to create and/or keep a PeopleSoft Administrator cheat sheet (frequently needed stuff by the Admins) handy and accelerate my learning and delivering on the various admin tasks.

This site is pretty useful - thanks for providing this forum and sharing your knowledge. I will be shortly creating an account and will check the site and this thread for updates.

You are welcome and the cheatsheet is a good document which will be handy for day to day work.

If you happen to have administer HRMS, this document would be some what useful during the tax updates

Do we need to know Unix Operating System commands to work on PS Administration?

Most of the time, knowing OS command is very useful. Mostly the PS Administrators are also responsible for Databases and to manage both, one should know the basic OS commands. Especially the OS that you are using.

If your OS is Unix, you can try this site. I used to get useful tips when I looked for some commands or sometime foget it.

Also the command list with all flavors is good. Check it out.

what exactly Database Admins do in peoplesoft database refresh process from production to other environments? Do they refresh only application data (Application Table space) or People Tools Table data? How about security setup since most of the users dont have smae security setup in all the environments?

Yes, the database needs to be refreshed. What level and about the Tools data/Security depends on the client request, size of the database and also of the convenience of the administrators and developers.

For example, a company which has more developers working on various projects, they would like to have the security replaced with the current one rather than the copy of production.

For smaller shops one or two developers, they would rather go for refreshing the entire database and change the SID and update the report nodes and keep the security, tools table as copy of production. At the most they might lock all the users other than the ones that are going to use the refreshed environment.

Some clients might just want to refresh certain tables or I have worked with a client who had about 30 developers spread across the globe and they wanted to export the security on the environment which is getting refreshed and refresh the environment with the copy of the production and put back the old security so the developers and QA will have same security as before and also they need not change the password. Most of the production environments may not have a operid for developers.

Besides the security setup, the scheduled processes/jobs and job sets, nodes, etc many not be the same for all the environments, which needs to be updated after the refresh.

What Security Tables do you take backup during the refresh process to replace the old security after refresh is done?

Please confirm me if below tables are enough for secuirty.


EXPORT PSOPRALIAS;
EXPORT PSROLEUSER;
EXPORT PSUSERATTR;
EXPORT PSUSEREMAIL;
EXPORT PSUSERPRSNLOPTN;
EXPORT PS_ROLEXLATOPR;
EXPORT PS_ROLEXLATOPR_LNG;
EXPORT PS_RTE_CNTL_RUSER;

-- ROLES
EXPORT PSROLEDEFN;
EXPORT PSROLEDEFNLANG;
EXPORT PSROLECANGRANT;
EXPORT PSROLECLASS;

-- PERMISSION LISTS
EXPORT PSCLASSDEFN;
EXPORT PSAUTHBUSCOMP;
EXPORT PSAUTHCHNLMON;
EXPORT PSAUTHCUBE;
EXPORT PSAUTHITEM;
EXPORT PSAUTHOPTN;
EXPORT PSAUTHPRCS;
EXPORT PSAUTHSIGNON;
EXPORT PSPRCSPRFL;
EXPORT PS_MC_OPR_SECURITY;
EXPORT PS_MC_OPRID;
EXPORT PS_SCRTY_ACC_GRP;
EXPORT PS_SCRTY_QUERY;

-- DEFINITION SECURITY
EXPORT PSOBJGROUP;
EXPORT PSOPROBJ;

-- PERSONALIZATIONS
EXPORT PSUSEROPTNDEFN;
EXPORT PSUSEROPTNLANG;
EXPORT PSOPTNCATGRPLNG;
EXPORT PSOPTNCATGRPTBL;
EXPORT PSOPTNCATTBL;
EXPORT PSOPTNCATLANG;

-- SECURITY OPTIONS
EXPORT PSSECOPTIONS;

-- SECURITY LINKS
EXPORT PSUSEROTHER;
EXPORT PSUSERSELFOTHER;
EXPORT PSROLEOTHER;
EXPORT PSPERMLISTOTHER;

-- USER ID TYPES
EXPORT PSOPRALIASTYPE;
EXPORT PSOPRALIASFIELD;

-- DELETE USER BYPASS TABLE
EXPORT PS_BYPASS_TABLE;

-- FORGOT EMAIL TEXT
EXPORT PSPSWDEMAIL;
EXPORT PSPSWDEMAILLANG;

-- PASSWORD HINTS
EXPORT PSPSWDHINT;
EXPORT PSPSWDHINT_LANG;

-- SIGNON PEOPLECODE
EXPORT PSSIGNONPPC;

-- DIRECTORY
EXPORT PSDSDIR;
EXPORT PSDSSRVR;
EXPORT DSCONNECTID;
EXPORT PSDSEXT_INSTALL;
EXPORT PSDSSECMAPMAIN;
EXPORT PSDSSECMAPSRVR;
EXPORT DSUSRPRFLMAP;
EXPORT PSDSUSERPRFL;
EXPORT PSDSSECROLERULE;
EXPORT DSSRCH_SBR;
EXPORT DSSRCHATTR;
EXPORT DSSECFILTER;
EXPORT PT_WF_NOT_DSCFG;

Excuse me for responding late as I was heldup with work.

The security tables vary depending on the tools version. I use the following dms scripts to export and import using People Tools Data Mover for any refresh. All the table names that you have mentioned above will be there in securityexport.dms script depending on the tools version.

The list of tables are provided in the following scripts provided by PeopleSoft in the $PS_HOME/scripts directory:

userexport.dms

securityexport.dms

secother_export.dms

psibmsgschema_seed_exp.dms

psibmsgschema_exp.dms

perfmondataexport.dms

ib_exportdeflocalnode.dms

exprole.dms

You may need to customize these depending on any customization in PeopleTools in your site.