Running Speedware on an HP 3000 980 with 80 users online using Oracle
Databases residing on Unix box accessing them through SQLNET2 (Vers 2.1), we
encountered a Network Failure - SYSLINK Interface Lockups, users freeze or
lockup.  System monitors indicate that the Inbound Buffer Pool exceeded
boundaries.  The system is configured for 512 users.  HP suspects that the
problem resides either with Oracle OR Speedware.  It appears that one of these
two programs does not Release buffer space required for a query/update of the
Oracle tables.   The same Speedware application programs compiled to use
SQLNET1 version 1.5  (much older version of Oracle program)  run  with no
problem.  Although HP says we can configure for more Inbound buffer memory it
is just putting off the problem until we hit the magic maximum limit again. We
need to find out why so many buffers are required for so few users.   Does
anyone know of problems regarding Oracle and Inbound buffer pool on the
HP3000?  We can recreate the problem consistently but only in our production
environment with the Production load.   Problem occurs 1 - 2 hours of
processing after switching to SQLNET2 versions of the Speedware Applications
depending on load.  Aborting users when in bound buffers are high appears to
release buffer space but this option is frowned upon by our users especially
the ones we abort.

We have been using SQLNET2 versions of the applications in our Development
account  on the same machine for months before attempting to roll it to
production with no problems .

We have place calls with all three vendors, HP says talk to Oracle, Oracle
says talk to Speedware, Speedware says they have no reported problems.  Has
anyone else encountered a similar problem with SQLNET2 and the HP3000

JC Strote
PARIS Project Manager
Lawrence Livermore National Laboratory
7000 East Ave.
Livermore, CA 94550
Voice (510) 423-0724
Fax    (510) 424-4750
Email [log in to unmask]
(510) 423-0724