Categories
Administration Humour Oracle Peoplesoft PeopleTools Performance Tuning

A Conversation with a PeopleSoft “Developer” – Part 2

Another amusing conversation and somewhat shocking “discovery”.

More poor performing SQL – obviously missing any sort of suitable index (on Oracle).

Me (to developer): Could you add a suitable composite (multi-column) index to table PS_xxxx please for columns C,B and A – there seems to be frequent access using these three columns that would be vastly improved by adding an index.

Developer: OK.

After a few days I notice new “alternate search key” indexes in the DEV environment. One for each of the columns A, B and C.

Me: Did you add that index?

Developer: Yes, but in the testing I did it wasn’t very much faster.

Categories
Administration

Green on Black Theme

Simple really – it reminds me of my my old IBM 3278 VTAM terminal. It’s also a very clean look in my view.

Categories
Administration Windows

Using SC to stop remote services

I generally use PSExec from the Sysinternals Suite, but here is another approach if you are not allowed to install external tools or it is blocked by (say) a virus checker:

Use sc.exe to achieve the same end result e.g.

1
2
3
4
5
6
7
8
9
10
11
12
13
REM
REM Establish IPC connection so we are authenticated with the remote machine
REM
net use \\remote\IPC$ /user:local-username-on-remote-machine remote-user-password 
REM 
REM Use system console (sc.exe) command line tool to STOP or START services on remote machine
REM Note: The service name needs to match the one shown in services on the remote machine
REM
sc \\remote stop service-name 
REM
REM Delete the IPC credentials
REM
net use \\remote\IPC$ /delete

This is particularly useful in larger PeopleSoft installs where you have installed the Web servers/App servers/Process Schedulers as NT services. You did do that didn’t you? 🙂

Note: This came from a posting somewhere else on the web – I am not claiming it is my idea!

Categories
Administration

Richard (Dick) Henry Evans

Placeholder article for anyone who would like what little information I have on Richard Henry (Dick) Evans who lived in Sandy, Bedfordshire. He worked at ICL in Hitchin back in the 70’s, 80’s and early 90’s. His date of birth was 30 November 1949. I worked with him for a short time in the early 1990’s.

I believe he died in January 2001 in or around Bedford and was originally from Bridgwater in Somerset. He had family in Sandy but was divorced.

Death Record

Name Richard Henry Evans

Year of Registration 2001

Month of Registration January

Registration District Bedford

Registration County Bedfordshire

Date of Birth 30 November 1949

Volume Number 3091B Volume

Page B4D

Fill in the form below and I will get back to you.