Hi David

We're non-unicode too....



Rgs

Shirley






                     "Baird, Andrew
                     (ICT) (HK)"           To:     "'psftdba@yahoogroups.com'"
<psftdba@yahoogroups.com>
                     <abaird@holland       cc:
                     casino.nl>            bcc:
                                           Subject:     RE: PeopleSoft DBA Forum
PeopleSoft on a Unicode Oracle
                     29/01/2003             database
                     07:22 PM
                     Please respond
                     to psftdba






Hi David,

Sorry cannot help you. We are not runing on Unicode here. How are you
doing?
going to be coming to Holland in the near future ?

Andy


-----Original Message-----
From: David Kurtz [mailto:david.kurtz@...]
Sent: woensdag 29 januari 2003 1:40
To: 'psftdba@yahoogroups.com'
Subject: PeopleSoft DBA Forum PeopleSoft on a Unicode Oracle database


Hello

Is anyone out there running PeopleSoft 8 on an Oracle database with a
Unicode (or other multibyte) character set?
I am interested in the effect on performance of the length checking
constraints created by PeopleSoft.

_________________________
David Kurtz
Go-Faster Consultancy Ltd.
phone: +44 7771 760660
fax: +44        7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
sms: sms@...
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba





To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/








           "The information contained in this email and any attached files
           is strictly private and confidential.  This email should be read
           by the intended addressee only.  If the recipient of this message
           is not the intended addressee, please call Aon Risk Services
           Australia, Aon Consulting, Aon Re Australia Ltd and other
           associated Aon Companies on +61 2 92537000 and promptly delete
           this email and any attachments.

           The intended recipient of this email may only use, reproduce,
           disclose or distribute the information contained in this email
           and any attached files with Aon's permission.  If you are not the
           intended addressee, you are strictly prohibited from using,
           reproducing, disclosing or distributing the information contained
           in this email and any attached files.

           Aon advises that this email and any attached files should be
           scanned to detect viruses.  Aon accepts no liability for loss or
           damage (whether caused by negligence or not) resulting from the
           use of any attached files."

Hi David,

Sorry cannot help you. We are not runing on Unicode here. How are you doing?
going to be coming to Holland in the near future ?

Andy


-----Original Message-----
From: David Kurtz [mailto:david.kurtz@...]
Sent: woensdag 29 januari 2003 1:40
To: 'psftdba@yahoogroups.com'
Subject: PeopleSoft DBA Forum PeopleSoft on a Unicode Oracle database


Hello

Is anyone out there running PeopleSoft 8 on an Oracle database with a
Unicode (or other multibyte) character set?
I am interested in the effect on performance of the length checking
constraints created by PeopleSoft.

_________________________
David Kurtz
Go-Faster Consultancy Ltd.
phone: +44 7771 760660
fax: +44  7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
sms: sms@...
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba





To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

----- Original Message -----

From: David Kurtz

To: 'psftdba@yahoogroups.com'

Sent: Wednesday, January 29, 2003 1:39 AM

Subject: PeopleSoft DBA Forum PeopleSoft on a Unicode Oracle database

Hello

Is anyone out there running PeopleSoft 8 on an Oracle database with a Unicode (or other multibyte) character set?
I am interested in the effect on performance of the length checking constraints created by PeopleSoft.

_________________________
David Kurtz
Go-Faster Consultancy Ltd.
phone: +44 7771 760660
fax: +44       7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
sms: sms@...
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba






To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd. http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Well, I finally got it working. PeopleSoft grabs some environment
variables on the fly when running psadmin, so if you try to start
stuff from another tool (i.e. the Bea GUI tool) it doesn't work. The
method to use is to add the variables to the ubb file so the GUI tool
can read them from pstuxconfig. Some of the variables needed are
PS_SERVER_CFG, and PSSERVDIR. I'll try and post a more detailed note
on this in the next couple of days.

Henry

--- In psftdba@yahoogroups.com, "Henry Poras <hporas@a...>"
<hporas@a...> wrote:
> I know this isn't a database issue, but I was hoping some of the
> technical expertise on this list could help. I'm having trouble
> getting peoplesoft domains to start by using the BEA GUI tool. This
> is a summary of my tests:
>
> Test 1: Deactivate the application servers via the GUI tool.
Leave
> the BBL alone. Activate the application servers. SUCCESSFUL
> (CONCLUSION: GUI can activate all of the application servers)
>
> Test 2: Deactivate the entire domain via the GUI tool
(application
> servers and BBL). Activate the BBL via the GUI. Activate the rest
of
> the application servers via psadmin (psadmin reports seeing the
> active BBL and doesn't start
> a duplicate). SUCCESSFUL (CONCLUSION: GUI can activate the BBL)
>
> Test 3: Deactivate the entire domain via the GUI tool.
Activate the
> BBL via the GUI. Activate the rest of the application servers via
the
> GUI. UNSUCCESSFUL (the errors depend on the specific type of
> peoplesoft domain started:application server, process scheduler
> server) (CONCLUSION: Something happens in psadmin between starting
> the BBL and starting the application servers. GUI can successfully
> start BBL, it can successfully start application servers, it cannot
> successfully start both in succession).
>
> It seems that psadmin runs some code between starting up the BBL
and
> the rest of the processes (servers). Is there any kind of trace I
can
> run to find out what this is? I'm still at the beginning stages of
> learning Tuxedo, so any help or pointers would be appreciated.
>
> Thanks.
>
> Henry

Hello

Is anyone out there running PeopleSoft 8 on an Oracle database with a Unicode
(or other multibyte) character set?
I am interested in the effect on performance of the length checking constraints
created by PeopleSoft.

_________________________
David Kurtz
Go-Faster Consultancy Ltd.
phone: +44 7771 760660
fax: +44  7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
sms: sms@...
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

I am looking fore information about installation on and use of a
Cytrix server.

For the normal logon procedures users start a batch on the Novell
Server for starting one of the PeopleSoft applications HR7, HR8,
FIN7, SA7 on one of the (Oracle) databases Development, Acceptation,
Learning, Production.
In the batch pscfg is started with the -setup -quiet mode and a
specific .cfg file.
Several outsite users (where there is no 8Mbps cable) logon to a
Cytrix Server.
Till now there was only one Application (SA7) and one database
connection (production) and there were no problems.
Now we want different useres to startup different versions and get
troubles with DLL's

Does anyone has of knows some information about how to proceed?

Bert Barskč
Drenthe College (NL)
database administrator
e-mail BL.Barske@...

Hello

When I started the Forum I also started a number of polls, just to get things
going.
I thought it was about time I showed you the results.

_________________________
David Kurtz
Go-Faster Consultancy Ltd.
phone: +44 7771 760660
fax: +44  7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
sms: sms@...
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba



-----Original Message-----
The following psftdba poll is now closed.  Here are the final results:
POLL QUESTION: What PeopleSoft products do you use
(Enterprise release version, not
service pack)?

CHOICES AND RESULTS
- HR 7.5, 4 votes, 20.00%
- Financials 7.5, 7 votes, 35.00%
- HR 8, 5 votes, 25.00%
- Financials 8, 3 votes, 15.00%
- CRM 8, 0 votes, 0.00%
- Financials 8.4, 1 votes, 5.00%

INDIVIDUAL VOTES
- HR 7.5
      - satish.kadiyala@...
      - BL.Barske@...
      - bmortensen@...
      - pierre.vanelswijk@...
- Financials 7.5
      - satish.kadiyala@...
      - BL.Barske@...
      - bmortensen@...
      - shirley.mcgregor@...
      - Colin.Daniels@...
      - david.black@...
      - IanThomas@...
- HR 8
      - BL.Barske@...
      - r.warren@...
      - steve.elcock@...
      - myilmaz@...
      - ken.warren@...
- Financials 8
      - r.warren@...
      - pierre.vanelswijk@...
      - laurent.delisle@...
- CRM 8
- Financials 8.4
      - phillip.eaton@...


-----Original
Message-------------------------------------------------------------------------\
-----------
The following psftdba poll is now closed.  Here are the
final results:


POLL QUESTION: If you use Oracle as your PeopleSoft
database platform, what version

CHOICES AND RESULTS
- 9.x, 0 votes, 0.00%
- 8.1.x, 8 votes, 72.73%
- 8.0.x, 2 votes, 18.18%
- 7.3.x, 1 votes, 9.09%
- Other, 0 votes, 0.00%

INDIVIDUAL VOTES
- 9.x
- 8.1.x
      - asdstm@...
      - satish.kadiyala@...
      - bmortensen@...
      - shirley.mcgregor@...
      - phillip.eaton@...
      - pierre.vanelswijk@...
      - laurent.delisle@...
      - ken.warren@...
- 8.0.x
      - myilmaz@...
      - IanThomas@...
- 7.3.x
      - david.black@...
- Other


For more information about this group, please visit
http://groups.yahoo.com/group/psftdba

For help with Yahoo! Groups, please visit
http://help.yahoo.com/help/us/groups/

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Enter your vote today!  A new poll has been created for the
psftdba group:

What webserver do you use for
PeopleSoft 8.x?

   o Apache
   o Weblogic
   o Websphere
   o Other


To vote, please visit the following web page:

http://groups.yahoo.com/group/psftdba/surveys?id=430731

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!

The following psftdba poll is now closed.  Here are the
final results:


POLL QUESTION: What is your database platform for
PeopleSoft?

CHOICES AND RESULTS
- Oracle , 20 votes, 86.96%
- Microsoft SQL Server, 3 votes, 13.04%
- DB2, 0 votes, 0.00%
- Sybase, 0 votes, 0.00%

INDIVIDUAL VOTES
- Oracle
      - asdstm@...
      - satish.kadiyala@...
      - abaird@...
      - bmortensen@...
      - shirley.mcgregor@...
      - Lucien.Matthijsse@...
      - Colin.Daniels@...
      - charles.benson@...
      - myilmaz@...
      - david.black@...
      - brendan.OSullivan@...
      - phillip.eaton@...
      - pierre.vanelswijk@...
      - laurent.delisle@...
      - jomo@...
      - ken.warren@...
      - IanThomas@...
      - kooltech_2000@...
      - supersime@...
      - ritesh.sawkar@...
- Microsoft SQL Server
      - jplagger@...
      - jgood@...
      - steve.elcock@...
- DB2
- Sybase


For more information about this group, please visit
http://groups.yahoo.com/group/psftdba

For help with Yahoo! Groups, please visit
http://help.yahoo.com/help/us/groups/

Does anybody know if you can create your own response files from
scratch using the OUI gui interface and record the responses into a
response file. Rather than editing one of the default response files.
This is from Oracle 8.1.7.0.0

Thanks Andy

Henry,

Have never worked with the BEA GUI tool, but it sounds like you need to take a look at the tuxedo logs, appserver, and process scheduler logs and see what kind of error messages your getting before I could send you in the right direction.  these can be found under PS_HOME/domain/logs directory.  if you could also take a look at what commands the BEA GUI is using to start the processes (they may not be in PS form), that might give you a clue.  you can start and stop all these processes using the command line ... first things first ... find out what error messages tuxedo is returning and go from there. 

Sorry I couldn't be of more help.

Cheers,

James De Atley

 "Henry Poras <hporas@...>" <hporas@...> wrote:

I know this isn't a database issue, but I was hoping some of the
technical expertise on this list could help. I'm having trouble
getting peoplesoft domains to start by using the BEA GUI tool. This
is a summary of my tests:

Test 1:      Deactivate the application servers via the GUI tool. Leave
the BBL alone. Activate the application servers. SUCCESSFUL
(CONCLUSION: GUI can activate all of the application servers)

Test 2:      Deactivate the entire domain via the GUI tool (application
servers and BBL). Activate the BBL via the GUI. Activate the rest of
the application servers via psadmin (psadmin reports seeing the
active BBL and doesn't start
a duplicate). SUCCESSFUL (CONCLUSION: GUI can activate the BBL)

Test 3:      Deactivate the entire domain via the GUI tool. Activate the
BBL via the GUI. Activate the rest of the application servers via the
GUI. UNSUCCESSFUL (the errors depend on the specific type of
peoplesoft domain started:application server, process scheduler
server) (CONCLUSION: Something happens in psadmin between starting
the BBL and starting the application servers. GUI can successfully
start BBL, it can successfully start application servers, it cannot
successfully start both in succession).

It seems that psadmin runs some code between starting up the BBL and
the rest of the processes (servers). Is there any kind of trace I can
run to find out what this is? I'm still at the beginning stages of
learning Tuxedo, so any help or pointers would be appreciated.

Thanks.

Henry





To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd. http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

I know this isn't a database issue, but I was hoping some of the
technical expertise on this list could help. I'm having trouble
getting peoplesoft domains to start by using the BEA GUI tool. This
is a summary of my tests:

Test 1: Deactivate the application servers via the GUI tool. Leave
the BBL alone. Activate the application servers. SUCCESSFUL
(CONCLUSION: GUI can activate all of the application servers)

Test 2: Deactivate the entire domain via the GUI tool (application
servers and BBL). Activate the BBL via the GUI. Activate the rest of
the application servers via psadmin (psadmin reports seeing the
active BBL and doesn't start
a duplicate). SUCCESSFUL (CONCLUSION: GUI can activate the BBL)

Test 3: Deactivate the entire domain via the GUI tool. Activate the
BBL via the GUI. Activate the rest of the application servers via the
GUI. UNSUCCESSFUL (the errors depend on the specific type of
peoplesoft domain started:application server, process scheduler
server) (CONCLUSION: Something happens in psadmin between starting
the BBL and starting the application servers. GUI can successfully
start BBL, it can successfully start application servers, it cannot
successfully start both in succession).

It seems that psadmin runs some code between starting up the BBL and
the rest of the processes (servers). Is there any kind of trace I can
run to find out what this is? I'm still at the beginning stages of
learning Tuxedo, so any help or pointers would be appreciated.

Thanks.

Henry

Micro Focus Net Express 3.1

-----Original Message-----
From: satishkbs [SMTP:satish.kadiyala@...]
Sent: Tuesday, December 03, 2002 7:59 AM
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Version of Cobol

  << File: ATT00001.htm >>

What version of cobol is supported with PS 8.3 and Tools 8.17. Can
someone tell me how i can find the version of cobol.

TIA
S

Bert,

If you compute statistics and your query dies, its time to run your query through an Oracle explain plan.  This will tell you how the Oracle Optimizer is running your SQL query.  Any DBA will have a utility to do this for you (sql navigator, Toad, OEM, or even the old fashioned way ... with straight SQL code, in SQLPlus).  Once the explain plan can be fished out, read from the middle out (do yourself a favor and do some research on explain plans), and from there - tune your code so it works well with the optimizer:

1.  look at SQL code:  driving table(s) (last table(s) in a sql statement) should be connecting table and/or the table with the least number of rows.  Oracle reads the from statement ... last table name first, then works its way back.  Where clause is worked out by Oracle optimizer from bottom to top.

2.  look at explain plan and add needed indexes and/or hints (rule hints may be needed at times - that's just Peoplesoft)

3.  Running Oracle Database in "choose mode" means: 

If a table has statistics ran on it, the optimizer will attempt to run any query that is attempting to access that table, in Cost Based mode.  This means that if a query accessed 4 tables and only 2 of the tables have had statistics ran on them, the optimizer would still run the query in Cost Based Mode.

Hope this helps.

Regards,

JD

 Bert Barske <BL.Barske@...> wrote:

After using analyze_schema on a StudentAdministration PeopleSoft
database version 7.60 on Oracle 8.05 it is big trouble using big (bad)
query's from PSQUERY.

When putting the hint /*+RULE*/ within the PSquery SQL it works.

But why should I then compute statistics.

Using cost based with statistics should be a problem for SA7.60 on
Oracle 8.05 ?
Or is it Oracle 8.05 that hasn't a good optimizer?

Bert Barskč
Drenthe College



To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd. http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

After using analyze_schema on a StudentAdministration PeopleSoft
database version 7.60 on Oracle 8.05 it is big trouble using big (bad)
query's from PSQUERY.

When putting the hint /*+RULE*/ within the PSquery SQL it works.

But why should I then compute statistics.

Using cost based with statistics should be a problem for SA7.60 on
Oracle 8.05 ?
Or is it Oracle 8.05 that hasn't a good optimizer?

Bert Barskč
Drenthe College

Thanks

Bert Barske


>>> laurent.delisle@... 22-11-2002 13:43:53 >>>
run DBMS_UTILITY.ANALYZE_SCHEMA procedure with system (warning: do not analyze
system schema ).

Regards,
   ----- Original Message -----
   From: blbarske
   To: psftdba@yahoogroups.com
   Sent: Friday, November 22, 2002 12:28 PM
   Subject: PeopleSoft DBA Forum Using DBMS_UTILITY.ANALYZE_SCHEMA(...)


   execute DBMS_UTILITY.ANALYZE_SCHEMA('SYSADM', 'COMPUTE')

   Where do I have to seek if I want to know who, in which lowest mode,
   may execute this command (I know i can try, but ..)

   INTERNAL in mount
   INTERNAL in open
   SYSTEM in open

   ON Saturday I have all kind of scripts running (because production is
   down for the weeken)

   I also want to execute this one

   Bert Barske



   To unsubscribe from this group, send an email to:
   psftdba-unsubscribe@yahoogroups.com

   The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.





------------------------------->
Website van het Drenthe College:
www.drenthecollege.nl

Vrijwaring/Disclaimer
De gegevens in dit elektronisch document en de eventuele bijlagen zijn
uitsluitend bedoeld voor de geadresseerde(n). De informatie wordt
zorgvuldig samengesteld. Het Drenthe College kan echter niet garanderen
dat de informatie absoluut juist, volledig en tijdig overkomt via het
Internet. Voor belangrijke beslissingen aangaande de verstrekte
informatie dient u een en ander rechtstreeks bij het Drenthe College te
controleren.

----- Original Message -----

From: blbarske

To: psftdba@yahoogroups.com

Sent: Friday, November 22, 2002 12:28 PM

Subject: PeopleSoft DBA Forum Using DBMS_UTILITY.ANALYZE_SCHEMA(...)

execute DBMS_UTILITY.ANALYZE_SCHEMA('SYSADM', 'COMPUTE')

Where do I have to seek if I want to know who, in which lowest mode,
may execute this command (I know i can try, but ..)

INTERNAL in mount
INTERNAL in open
SYSTEM in open

ON Saturday I have all kind of scripts running (because production is
down for the weeken)

I also want to execute this one

Bert Barske



To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd. http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

execute DBMS_UTILITY.ANALYZE_SCHEMA('SYSADM', 'COMPUTE')

Where do I have to seek if I want to know who, in which lowest mode,
may execute this command (I know i can try, but ..)

INTERNAL in mount
INTERNAL in open
SYSTEM in open

ON Saturday I have all kind of scripts running (because production is
down for the weeken)

I also want to execute this one

Bert Barske

Obviously, this is not about the database, but as I thought the group
might contain others like me (general technical folks), I would share
something that I've learned. As David would probably say, all this
stuff can be found *somewhere* (I'm sure) in the documentation, but
never all in one place, and rarely in a usable form. :)

I hope this may be of some help to some of you at some point.


**NB: I'm not sure how well this is going to display online, as it
contains printouts from a terminal. If it it difficult to read, I
would recommend copying it into a text editor, setting the font to
courier, and correcting any broken lines.



As time goes by in a PeopleSoft environment, an administrator will
inevitably be temped to start another Tuxedo domain for any number of
reasons (e.g. handling heavier load of connections, running multiple
PS environments on the same machine with the same unix owner/group).
This is very easy to do, and can be very convenient for large servers
running several installations of PeopleSoft (you only have one unix
login to remember).

However, the honeymoon ends the first time an application server
domain won't shutdown nicely. In this instance, the administrator is
forced to kill processes manually, and release shared memory through
the use of the delivered ipcrmall.sh script. ipcrmall.sh is a blunt
tool at best - it does the job, but not in any discriminating
fashion. Quite simply, this script finds all ipc resources (shared
memory, message queues, semaphores) that were requested by a specific
user/group and releases them. That should set off the alarm bells if
you remember that ALL your application server domains are running
under the same user!

If you run ipcrmall.sh on a development/test server, where you have,
say 6 (or 12) different installations of PeopleSoft, you will then
have to restart, not just the application server you're trying to
fix, but EVERY one. PeopleSoft, in general, frowns on such a
configuration - the official answer to this problem is to install
each environment under a dedicated adminstrator user/group. But what
about a live environment where you have more than one domain simply
to handle your transaction load?

The same recommendation (use a different userid) can be applied to
multiple domains within on installation. The *minimum* way to
accomplish that is to clone psadmin, change the owner to the new
userid/group, and make sure that all shared files (psappsrv.cfg
templates, etc) are group readable. From then on, you must use the
cloned psadmin to administer the second domain.

However, having someone tell you that you need to configure your
system differently when you're having a problem is not nice.
Fortunately, there is another way, which I'd like to share to save
others the same pain I've endured.

Here's the scenario. PeopleSoft Production environment, application
server running on unix with two domains (same server) for load-
balancing. For an unknown reason, one of you server process is
hanging. You shutdown the domain and restart it. But things still
don't look right. With psr you see something like this:

> Prog Name      Queue Name  Grp Name      ID RqDone Load Done
Current Servic
---------      ----------  --------      -- ------ --------- ---------
------
BBL            65487       unix001        0   4513    225650 ( DEAD )
PSAPPSRV       APPQ1       APPSRV         1      4       262 (  IDLE )
PSAPPSRV       APPQ1       APPSRV         2     10       459 ICPanel
PSAPPSRV       APPQ1       APPSRV         3     16      1169 (  IDLE )
PSAPPSRV       APPQ1       APPSRV         4  13426    937211 ( DEAD )
PSQCKSRV       QCKQ        APPSRV        70      0         0 (  IDLE )
WSL            00001.00090 BASE          90      0         0 (  IDLE )
PSSAMSRV       SAMQ        APPSRV       100      0         0 (  IDLE )
JSL            00095.00200 JSLGRP       200      0         0 (  IDLE )
JREPSVR        00094.00250 JREPGRP      250      8       400 (  IDLE )


*Somehow* the BBL itself has died, there's no record of it as a
process in unix; an appserver has died and will not restart because
there's no BBL to restart it; you can't get any information out of
the domain itself about users, b/c this information comes through the
BBL. The servers that are running will continue to run (notice the
ICPanel service active), but they cannot be serviced in any way.

If this was a stand-alone domain, you'd shut it down, run ipcrmall.sh
and happily restart it. But this is Production. If you do that,
you'll end up shutting down the load-balancing domain as well (if
they're on the same machine), blocking access to the application
completely. Right now, users still have access through the other
domain.

First, find the pid for your domain's JSL. You can do this by typing:

> ps -ef|grep JSL
   pspadm  9964     1  0  Oct 12  ?         0:15 JSL -C dom=CIPP2 -g
95 -i 200 -u  ecarh0f -U /cipp/people/produc
   pspadm  6816     1  0 11:46:12 pts/tb    0:00 JSL -C dom=CIPP -g
95 -i 200 -u ecarh0f -U /cipp/people/product

I'm interested in the domain CIPP, so I write down a pid of 6816.
Save this - you will probably need it later. Do the same thing for
the WSL.

You can kill all the running processes for your domain using kill -9
(which you should do), but the DEAD processes aren't actually running
anymore. What you need is a way to release ipc resources for one
domain only, without touching the other.

Tuxedo, believe it or not, has taken this into consideration. Each
tuxedo domain will request ipc resources using a unique ipckey. But
where's the key?

The psappsrv.ubb is a mid-point file in the domain configuration
process. It is essentially a merge between the psappsrv.ubx (the
template for unix) and psappsrv.cfg (user input). It contains all the
configuration information for the domain in plain text. It's useless
to modify this file - it's overwritten every time you reconfigure the
domain.

The value for IPCKEY is assigned at configuration time (from a range
of values specific in the psappsrv.ubx file). It's actual value is
stored in plain-text in psappsrv.ubb.

[$PS_HOME/appserv/<domain>] grep IPCKEY psappsrv.ubb
IPCKEY          55329        # ( 32768 < IPCKEY < 262143 )
# [ 0]:                                             {IPCKEY}:  55329

In this case, the IPCKEY is 55329.

You will need to convert this value into Hexadecimal format (the
windows program "calc" can do this easily). The Hex equivalent of
55329 is d821 (you will have letters and numbers - all letters should
be lower-case). You can now pinpoint which ipc resources are
allocated to your domain, like this:

> ipcs | grep d821
q  318046 0x0000d821 -Rrw-rw----    pspadm      psgr
m  701458 0x0000d821 --rw-rw----    pspadm      psgr
s183996448 0x0000d821 --ra-ra----    pspadm      psgr

There are three types of ipc resources: message queues (q), shared
memory (m) and semaphores (s). The first letter of the output of ipcs
designates which the line refers to. Depending on what crashed in
your domain, you will see all or only some of these entries. The
second field on each line is the ipcid for that resource. The third
is, if you haven't guessed by now, the ipckey.

To release these resources, use the appropriate form of the command
ipcrm:

> ipcrm -q 318046
> ipcrm -m 701458
> ipcrm -s 183996448

Now, only one things stands between you and restarting your
application server. JSH and WSH ports. The JSL and WSL (whose pids
you wrote down earlier) will spawn JSH and WSH processes as needed to
handle connections. They connect to a specific port, and if they
haven't already died, they will keep you from restarting your
application server. (This doesn't always happen, as I've found in
practice - but if upon trying to reboot your appserver you get stuck
on the JSL or WSL part, it's a good bet to use what's below)

So, run 'ps -ef | grep JSH' and 'ps -ef | grep WSH', and look for any
running processes where the parent process id (the third field) is
one of the numbers you wrote down earlier for the JSL and WSL,
respectively. If any match up, you will need to kill those processes.

> ps -ef|grep JSH
[/cipp/people/product/8.18/appserv/CIPP] ps -ef|grep JSH
   pspadm  9968  9964  0  Oct 12  ?         0:28 JSH -c 41 -
d /dev/null -i 2 -s 33809
   pspadm  9966  9964  0  Oct 12  ?         0:26 JSH -c 41 -
d /dev/null -i 0 -s 33809
   pspadm  9969  9964  0  Oct 12  ?         0:26 JSH -c 41 -
d /dev/null -i 3 -s 33809
   pspadm  9972  9964  0  Oct 12  ?         0:28 JSH -c 41 -
d /dev/null -i 6 -s 33809

As you can see, the parent process id 6816 (recorded earlier as the
process id of the JSL) is there for two JSHs. These two should be
killed.

And that's it. You have successfully shutdown one tuxedo domain,
without touching another running under the same userid/group.

In summary:
1) record pid for JSH & WSH
2) kill all processes visible for the domain in question
3) obtain IPCKEY from psappsrv.ubb
4) convert IPCKEY to Hex (use calc or similar, unless you're
just "that good")
5) search for the IPCKEY (all letters in the key should be lowercase)
using ipcs|grep <key>
6) release ipc resources using appropriate form of ipcrm
7) kill any remaining JSH or WSH processes
8) restart application server domain


Kind Regards,

Charles Benson
PeopleSoft Technical Manager
Belgacom SA
charles.benson@...

You've not done this before, have you David :-)

Use the link at the bottom of the message...

Phillip Eatn

-----Original Message-----
From: David.Richardson@... [mailto:David.Richardson@...]
Sent: 04 November 2002 12:13
To: psftdba@yahoogroups.com
Subject: RE: [psftdba] New poll for psftdba


Oracle

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]
Sent: Monday, November 04, 2002 12:02 PM
To: psftdba@yahoogroups.com
Subject: [psftdba] New poll for psftdba



Enter your vote today!  A new poll has been created for the
psftdba group:

What is your database platform for
PeopleSoft?

   o Oracle
   o Microsoft SQL Server
   o DB2
   o Sybase


To vote, please visit the following web page:

http://groups.yahoo.com/group/psftdba/surveys?id=295183

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!








To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



----------------------------------------------------------------------------
--
The information in this Internet email is confidential and may be
legally privileged. It is intended solely for the addressee. Access
to this Internet email by anyone else is unauthorised.

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. When addressed to our clients any opinions or advice
contained in this Internet email are subject to the terms and conditions
expressed in any applicable governing ING terms of business or
client engagement letter.

Visit us at www.ing.com

----------------------------------------------------------------------------
--
01



To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

"Gulf International Bank (UK) Limited of One Knightsbridge, London SW1X 7XS is
regulated by the Financial Services Authority.

This e-mail message and any file transmitted with it is confidential to the
intended recipient and may contain confidential, proprietary or legally
privileged information. If you are not the intended recipient, you may not copy,
distribute or disclose the contents to anyone, nor take any action in reliance
on its contents. Should you receive this message in error, please immediately
delete it and all copies of it from your system, destroying any hard copies and
notify the sender."

HR 8

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]
Sent: Monday, November 04, 2002 12:06 PM
To: psftdba@yahoogroups.com
Subject: [psftdba] New poll for psftdba



Enter your vote today!  A new poll has been created for the
psftdba group:

What PeopleSoft products do you use
(Enterprise release version, not
service pack)?

   o HR 7.5
   o Financials 7.5
   o HR 8
   o Financials 8
   o CRM 8
   o Financials 8.4


To vote, please visit the following web page:

http://groups.yahoo.com/group/psftdba/surveys?id=295187

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!








To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



------------------------------------------------------------------------------
The information in this Internet email is confidential and may be
legally privileged. It is intended solely for the addressee. Access
to this Internet email by anyone else is unauthorised.

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. When addressed to our clients any opinions or advice
contained in this Internet email are subject to the terms and conditions
expressed in any applicable governing ING terms of business or
client engagement letter.

Visit us at www.ing.com

------------------------------------------------------------------------------
01

8.1.x and 9.x

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]
Sent: Monday, November 04, 2002 12:03 PM
To: psftdba@yahoogroups.com
Subject: [psftdba] New poll for psftdba



Enter your vote today!  A new poll has been created for the
psftdba group:

If you use Oracle as your PeopleSoft
database platform, what version

   o 9.x
   o 8.1.x
   o 8.0.x
   o 7.3.x
   o Other


To vote, please visit the following web page:

http://groups.yahoo.com/group/psftdba/surveys?id=295185

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!








To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



------------------------------------------------------------------------------
The information in this Internet email is confidential and may be
legally privileged. It is intended solely for the addressee. Access
to this Internet email by anyone else is unauthorised.

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. When addressed to our clients any opinions or advice
contained in this Internet email are subject to the terms and conditions
expressed in any applicable governing ING terms of business or
client engagement letter.

Visit us at www.ing.com

------------------------------------------------------------------------------
01

Oracle

-----Original Message-----
From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]
Sent: Monday, November 04, 2002 12:02 PM
To: psftdba@yahoogroups.com
Subject: [psftdba] New poll for psftdba



Enter your vote today!  A new poll has been created for the
psftdba group:

What is your database platform for
PeopleSoft?

   o Oracle
   o Microsoft SQL Server
   o DB2
   o Sybase


To vote, please visit the following web page:

http://groups.yahoo.com/group/psftdba/surveys?id=295183

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!








To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



------------------------------------------------------------------------------
The information in this Internet email is confidential and may be
legally privileged. It is intended solely for the addressee. Access
to this Internet email by anyone else is unauthorised.

If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. When addressed to our clients any opinions or advice
contained in this Internet email are subject to the terms and conditions
expressed in any applicable governing ING terms of business or
client engagement letter.

Visit us at www.ing.com

------------------------------------------------------------------------------
01

Enter your vote today!  A new poll has been created for the
psftdba group:

What PeopleSoft products do you use
(Enterprise release version, not
service pack)?

   o HR 7.5
   o Financials 7.5
   o HR 8
   o Financials 8
   o CRM 8
   o Financials 8.4


To vote, please visit the following web page:

http://groups.yahoo.com/group/psftdba/surveys?id=295187

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!

Enter your vote today!  A new poll has been created for the
psftdba group:

If you use Oracle as your PeopleSoft
database platform, what version

   o 9.x
   o 8.1.x
   o 8.0.x
   o 7.3.x
   o Other


To vote, please visit the following web page:

http://groups.yahoo.com/group/psftdba/surveys?id=295185

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!

Enter your vote today!  A new poll has been created for the
psftdba group:

What is your database platform for
PeopleSoft?

   o Oracle
   o Microsoft SQL Server
   o DB2
   o Sybase


To vote, please visit the following web page:

http://groups.yahoo.com/group/psftdba/surveys?id=295183

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the Yahoo! Groups
web site listed above.

Thanks!