Tuesday, October 5, 2010

Calculate Database Connections Needed For A PeopleSoft Instance

As a PeopleSoft system administrator or a DBA, chance may be you need to calculate how many database connections are needed for a PeopleSoft database. Below are some tips for the calculation:-

App Server Domain

  • The following processes connect to the database: PSMONITORSRV, PSANALYTICSRV, PSSAMSRV, PSQRYSRV, PSAPPSRV, PSQCKSRV, PSBRKDSP, PSBRKHND, PSPUBDSP, PSPUBHND, PSSUBDSP, PSSUBHND, PSMCFLOG, PSUQSRV, PSRENSRV (Tip: in psappsrv.ubb, all processes except for PSWATCHSRV with -D parameter connect to the database)

  • One PSAPPSRV can have 2 db connections if DbFlags is not set to 4(Disable Second DB Connection) or 8(Disable Persistent Secondary DB Connection)

  • The following processes don't connect to the database: BBL, JSL, JSH, WSL, WSH, PSDBGSRV, JREPSVR, PSWATCHSRV


Process server domain


  • The following processes connect to the database: PSPRCSRV, PSAESRV, PSDSTSRV, PSMSTPRC, PSMONITORSRV (Tip: in psprcsrv.ubb, all processes with -CD parameter connect to the database)

  • One PSAESRV can have 2 db connections if DbFlags is not set to 4(Disable Second DB Connection) or 8(Disable Persistent Secondary DB Connection)

  • The following processes don't connect to the database: BBL



Others
  • External programs, such as PSRUN (cobol remote call), PSCRRUN.exe(Crystal Reports), PSSQR(SQR report), PSNVS(nVision) etc, also need db connection

  • Tools/applications used by developers/system administrators, such as pside.exe, psdmt.exe, Oracle client, etc, also need db connection

8 comments:

Anonymous said...

purchase [URL=http://e--store.com/]coach outlet online[/URL] to your friends PtOleLUe [URL=http://e--store.com/ ] http://e--store.com/ [/URL]

Anonymous said...

fUro cheap ghd australia
eBcu cheap ugg boots
cAag michael kors outlet
3lXie cheap ugg boots
9hSri chi straightener
1iDam michael kors purses
5wLyw nfl football jerseys
2lUec ghd
2mZsg north face jackets
8sGxp ugg australia
2dJek ghd hair straighteners
7hPfv michael kors wallet
5oJce cheap nfl jerseys
2yYwo ghd baratas
7yKtz ugg boots sale

Anonymous said...

check this link, wbjgHGPx [URL=http://www.chanel--online-shop.net/]cheap chanel bags[/URL] to get new coupon FCtCPRhR [URL=http://www.chanel--online-shop.net/ ] http://www.chanel--online-shop.net/ [/URL]

Anonymous said...

you love this? ERYrUdbT [URL=]burberry tie[/URL] to get new coupon FnQMungu [URL= ] [/URL]

Anonymous said...

must look at this [URL=http://replicahandbags45.yolasite.com/]replica bags[/URL] for more detail jMHpYced [URL=http://replicahandbags45.yolasite.com/ ] http://replicahandbags45.yolasite.com/ [/URL]

Anonymous said...

look at [URL=http://buylouisvuitton.livejournal.com/]buy louis vuitton online[/URL] , just clicks away pWzpcguT [URL=http://buylouisvuitton.livejournal.com/ ] http://buylouisvuitton.livejournal.com/ [/URL]

Anonymous said...

to buy SJDWSYsz [URL=http://www.gucci-onlinestore.tumblr.com/]gucci bags outlet[/URL] online shopping qwoApcEV [URL=http://www.gucci-onlinestore.tumblr.com/ ] http://www.gucci-onlinestore.tumblr.com/ [/URL]

Anonymous said...


Young general of black base of force of competition ground emersion exceeds to step on a face by spike in so painful that roll about -- in new network
One act produces injury person in the 38th minute. Liu Chao prevents time keeping and in pairs of Jiangsu team foreign aids to fall down, rise quickly subsequently defend. Right now, rubber ball is in Liu Bofei and Liu Chao between, two people go up at the same time grab, liu Chao chooses to fall down shovel ball, the one foot when Liu Bofei dodge steps to go up in Liu Chao's face. It is painful on the ground that Liu Chao screams ground cover face rolls about, advocate juridical Xu boat draws out red shop sign to punish Liu Bofei directly. Liu Bofei is ceaseless to advocate juridical complain of being wronged, him explanation is undesigned trample arrived Liu Chao. Final, field of Jiangsu group objective and Shenzhen team 0 smoother than 0 battle.
After contest, check in detail through group medical service, willow exceeds and do not have hinder greatly, but the hobnail mark on the face still clear and visible. The Liu Bofei that is punished to fall by red shop sign is accepting when interviewing, state oneself are innocently trample: "I at that time is to avoid not as good as, I and Liu Chao also did not celebrate a festival, the match just just begins, not be we lagged behind the mood is impatient. The match is undertake below a kind of very normal atmosphere, I go without any reason intended trample adversary. I [url=http://www.epiphanymgmt.com/nikeshoesforkids.aspx]cheap nike shoes for kids[/url] go without any reason intended trample adversary..
According to China sufficient assist convention, the punishment that resembles event of this kind of trample is quite heavy, on team of sports season Shenzhen a player is stopped to surpass 6 because of baleful trample adversary. Whether does this movement of Liu Bofei belong to ill will to foul for clearer judgement, the reporter contacted judgment of level of a state last night, he expresses after had watched video: "Liu Bofei has an avoided idea really at that time, but at the same time right leg also has an outspread action, will look to be shown from this bit it is normal that red shop sign is belonged to. Additional, to whether belonging to ill will to foul, union the case on field looks at that time, should not calculate, but this still needs China the kinescope of each seat numbers has enough harmonious market analysis. But this still needs China the kinescope of each seat numbers has enough harmonious market analysis..
It is reported, should be worth advocate cut into parts already wrote incident of this one trample into competition report. China is sufficient assist will hand in after Zhou Yi receives a report handle by commission of league matches discipline, liu Bofei faces many punishment that bans contest probably.