Session Freezes

[Darren Jeffery]

Using a HP 9000 L2000, running HP-UX 11i, 1GB memory on a 10base network. Using SBclient to connect to a PICK DB system, with around 105 users on the system. At least twice a day a user(s) session will freeze for around 30 seconds and then continue ok. Any ideas please?

[Paula J Frazer-Campbell]

Darren

If sessions freeze and then continue OK after 30 seconds I would suspect the server is having a problem as a network problem more often than not drops the users.

Use tools like top, sar and glance to monitor what is going on.

If you do not have glance installed - install from apps cd the 60 trial version.


Get your dba to have a look at the structure of the pick files as a badly resized file can have a major effect on performance.


HTH

Paula

[Paula J Frazer-Campbell]

Darren

Do these problems occur at the same time?
Do ther occur because a user is doing a major select?

Do they occur at the same time as a crom entry.

Do they occur during a high login/ logout period.


HTH

Paula

[Darren Jeffery]

Yes, several people do freeze at the same time, but not all of them. And there is no way I can tell if someone is doing a heavy select.

[Roger Baptiste]

hi,

Check the Perfview/measureware logs and see what were the processes which were consuming resources at the time of the freeze. You can lookup on other details like CPU, Memory load at around that time. Look at syslog.log and dmesg files to see whether any messages were logged. Confirm the database load from the dba and any related application details.

HTH
raj

[Paula J Frazer-Campbell]

Darren

When it freezes run a PORT.STATUS from TCL prompt - it will tell you if a large select is being done and by whom.

Paula

[Darren Jeffery]

Sorry, but we don't have that command available to us. We are running Unidata. Thanks for trying

[Paula J Frazer-Campbell]

Darren

Are you running PICK on the Unix box?


Paula

[Darren Jeffery]

Unidata Version 5.1.36. A Pick like system.

[Paula J Frazer-Campbell]

Darren

Can you check the lock table?

Multilple users trying to attach to a locked file - or the system clearing locks can cause this problem.


Paula