Re: Changing user password upsets informix

Actually, you can trace a single process, with AIX 5.2.

$ oslevel
5.2.0.0
$ lslpp -w `which truss`
File Fileset Type
----------------------------------------------------------------------------
/usr/bin/truss bos.sysmgt.serv_aid File



As root, you'll want to:

truss -aefp <pid>

... where <pid> is the process you want to watch.

-s-

On Jan 22, 2008, at 8:10 AM, Mark J Ray wrote:

Suzanne:

What you want to do is trace the listener process to see what's causing the error. Unfortunately, in AIX 5.2,
you can't zero in on a single process, so you have to trace the whole system. What I would do in this case
is to set up a system trace with the following command:

trace -a -o <tracefile.name> ; sleep 30 ; trcstop

This says to trace the system for 30 seconds, then stop. While the trace is running, try to generate the exact
error you need analyzed. If you can do this, then the performance folks in Austin, TX, US will be able to
pin down exactly what's happening with the listener.

Best Regards,

Mark J. Ray
Advisory IT Specialist
p Series Team
Global Technology Services
IBM
email: raym@xxxxxxxxxx


<graycol.gif>"Davies, Suzanne" <Suzanne.Davies@xxxxxxxxxxxxxxx>


"Davies, Suzanne" <Suzanne.Davies@xxxxxxxxxxxxxxx>
Sent by: IBM AIX Discussion List <aix-l@xxxxxxxxxxxxx>
01/22/2008 10:28 AM
Please respond to
IBM AIX Discussion List <aix-l@xxxxxxxxxxxxx>
<ecblank.gif>
To
<ecblank.gif>
aix-l@xxxxxxxxxxxxx
<ecblank.gif>
cc
<ecblank.gif>
<ecblank.gif>
Subject
<ecblank.gif>
Changing user password upsets informix
<ecblank.gif>
<ecblank.gif>

Hi

We have a cluster which is running AIX 5.2 ML9 and Informix V9.40.UC3. If the steprd (an Informix user) AIX password is changed Informix starts generating errors:

11:01:01 listener-thread: err = -951: oserr = 0: errstr = steprd: Incorrect password or user steprd is not known on the database server.

It has been to IBM who found a memory leak and provided a patch which fixed that but this is still a problem. The only way around it seems to be to boot the box after which everything works again. The steprd account is set to not expire as this had caused issues in some other installations elsewhere. I have also found many reference to listener-thread errors on Informix but very few related to the -951 error.

If anyone has any ideas I would be really grateful

Thanks
Regards,
Suzanne Davies
Unix BAU Support
Infrastructure Services, Service Delivery
External : 020 7 922 3117
Network : 7430 3117
E-Mail : suzanne.davies@xxxxxxxxxxxxxxx


This e-mail is only for the above addressees. It may contain confidential or privileged information. If you are not an addressee you must not copy, distribute, disclose or use any of the information in it or any attachments. If you have received it in error please notify the sender and delete it immediately.

Lloyds TSB Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales, number 2065. Telephone: 020 7626 1500.
Lloyds TSB Scotland plc. Registered Office: Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone: 0131 225 4555.
Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales, number 2299428. Telephone: 01452 372372.
Cheltenham & Gloucester Savings is a division of Lloyds TSB Bank plc.

Lloyds TSB Bank plc, Lloyds TSB Scotland plc and Cheltenham & Gloucester plc are authorised and regulated by the Financial Services Authority.

Lloyds TSB Group plc. Registered Office: Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95000. Telephone: 0131 225 4555.
Lloyds TSB Group plc is a signatory to the Banking Codes.

Telephone calls may be monitored or recorded.



Relevant Pages