Neon--DB2 Connection: HELP!!!

David Brown

Neon--DB2 Connection: HELP!!!
Everyone:

I am working with a client who is just bringing up a
major project management system application that
uses an ODBC connection to DB2 using Neon
Systems Shadow Direct.

The application only has about 65 users on it but it is
bringing the current (55 MIPs) system down. We have
an idea it has to do with improper installation or tuning.

If you have any experience with Neon, please let me
know. If you can, please provide the following:

Your system, MIPS and Operating System:


How many users you have aboard:


What type of applications are you using Neon/DB2 for?



Did you have any problems when first bringing the system
up?



Of course, I would appreciate any help or time with regard to
tuning this system. They might want me to bring in a consultant
for a couple days to help, so if you wish to apply for that
job, please let me know and we can follow up on it.

Let me thank you all in advance -- dave brown


[login to unmask email]

David B. Brown, Ph.D. PE
Professor and Director
Computing and Information Division
Engineering Research Laboratory
The University of Alabama
101 Houser Hall
Box 870290
Tuscaloosa, Alabama 35487-0290

205-348-6363 FAX: 205-348-0219

Saving lives with CARE ...
http://care.cs.ua.edu


David Skrivanek

Re: Neon--DB2 Connection: HELP!!!
(in response to David Brown)
David,

Please see the responses to you questions below.

-----Original Message-----
From: David Brown [ mailto:[login to unmask email] <mailto:[login to unmask email]> ]
Sent: Wednesday, October 06, 1999 10:07 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: Neon--DB2 Connection: HELP!!!


Everyone:

I am working with a client who is just bringing up a
major project management system application that
uses an ODBC connection to DB2 using Neon
Systems Shadow Direct.

The application only has about 65 users on it but it is
bringing the current (55 MIPs) system down. We have
an idea it has to do with improper installation or tuning.

If you have any experience with Neon, please let me
know. If you can, please provide the following:

Your system, MIPS and Operating System:
310 (6 engines)

How many users you have aboard:
200+

What type of applications are you using Neon/DB2 for?
Brio Query Designer


Did you have any problems when first bringing the system
up?
Shadow server was maxing out our CPU


Of course, I would appreciate any help or time with regard to
tuning this system. They might want me to bring in a consultant
for a couple days to help, so if you wish to apply for that
job, please let me know and we can follow up on it.

I am not a consultant.

Let me thank you all in advance -- dave brown


[login to unmask email] <mailto:[login to unmask email]>

David B. Brown, Ph.D. PE
Professor and Director
Computing and Information Division
Engineering Research Laboratory
The University of Alabama
101 Houser Hall
Box 870290
Tuscaloosa, Alabama 35487-0290

205-348-6363 FAX: 205-348-0219

Saving lives with CARE ...
http://care.cs.ua.edu < http://care.cs.ua.edu >

Ricardo Gomes

Re: Neon--DB2 Connection: HELP!!!
(in response to David Skrivanek)
Hello David
 
We have been using Shadow Server and  Shadow Direct for some three years by
now.
Currently Shadow Server v 4.1 and DB2 v 5.1. One important fact: the
communication's protocol is Interlink's TCPIP.
The machine: 9672 R45 , 200 MIPS running OS390 2.6.
( bear in Mind: Machine has 3 LPAR's Production + Y2K + SAP/R3 )
The scope is
1) a maximum of 20 simultaneous active users from a potential 360, mining
data from a 226 tables+30 views DataWarehouse.
2) most users running  Ms-Access Read applications and only a few running
read/write applications
3) One application in VBasic receiving data from another system and inputing
data into the database's tables
4) Several VBasic applications reading data
5) Applications developed on Ms Access 97 and VBasic running on NT 4.0
workstations.
 
 
The whole thing came together easily at first. Not much tuning required,
really.
Good DB2 performance is relevant, good SQL programming is crucial (write SQL
passthrough queries on Ms-Access rather than Access's SQL )
Make user ODBC configuration go through SHADCAT (Shadow catalog database)
rather than through DB2's catalog.
Monitor users frequently and try to understand monthly trends that imply
regular montly tuning
Trace SQLSOURCE table in SHADCAT catalog database as possible (fast growth
table - back it up regularly and clear it).
Most important parameter for Shadow Server configuration: the PRODPARM Fail
CPU time value/Fail SQL CPU time value (our datawarehouse miners are somehow
short on SQL knowledge and sometimes they make bizarre queries resulting in
dangerous CPU consuming situations such as selects from multiple tables
where the joins are missing...sad but true)
 
... if you need something more, please  feel free to send me more details or
questions  
 


Best Regards

António Gonçalves & Ricardo Gomes             SISTEMAS
Mello - Imperio Serviços Partilhados, ACE
Tel.:   (01) 7204302  Fax:    (01) 7204334
Email:  [login to unmask email]
<mailto:[login to unmask email]> Email: 
<mailto:[login to unmask email]>
[login to unmask email]

 

Gregg Willhoit

Re: FW: Neon--DB2 Connection: HELP!!!
(in response to Ricardo Gomes)
Gregg [login to unmask email]
10/07/99 11:42 AM

You folks have hit a known bug in IBM OE TCP/IP that we have seen at a few
other customer sites. The APAR list for this problem follows. Notice the
CLOSE STARTED message in the Trace Browse. This indicates that an OE Socket
is being closed. A CLOSE EXECUTED message should follow immediately.
However, because of the bug in OE Sockets, the close is never completed.
The APAR list is:

PQ14253
PQ16813
PQ18232
PQ18868
PQ21553
OW37935

Thank you

Gregg Willhoit
NEON Systems, Inc.
www.neonsys.com
281-491-4200


-----Original Message-----
From: David Brown [ mailto:[login to unmask email] <mailto:[login to unmask email]> ]
Sent: Wednesday, October 06, 1999 10:07 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: Neon--DB2 Connection: HELP!!!


Everyone:

I am working with a client who is just bringing up a
major project management system application that
uses an ODBC connection to DB2 using Neon
Systems Shadow Direct.

The application only has about 65 users on it but it is
bringing the current (55 MIPs) system down. We have
an idea it has to do with improper installation or tuning.

If you have any experience with Neon, please let me
know. If you can, please provide the following:

Your system, MIPS and Operating System:
310 (6 engines)

How many users you have aboard:
200+

What type of applications are you using Neon/DB2 for?
Brio Query Designer


Did you have any problems when first bringing the system
up?
Shadow server was maxing out our CPU


Of course, I would appreciate any help or time with regard to
tuning this system. They might want me to bring in a consultant
for a couple days to help, so if you wish to apply for that
job, please let me know and we can follow up on it.

I am not a consultant.

Let me thank you all in advance -- dave brown


[login to unmask email] <mailto:[login to unmask email]>

David B. Brown, Ph.D. PE
Professor and Director
Computing and Information Division
Engineering Research Laboratory
The University of Alabama
101 Houser Hall
Box 870290
Tuscaloosa, Alabama 35487-0290

205-348-6363 FAX: 205-348-0219

Saving lives with CARE ...
http://care.cs.ua.edu < http://care.cs.ua.edu >