PDA

View Full Version : DB2 Connection


Brad
02-25-2003, 15:15
We are new webMethods users and we are in the process of installing it on our systems. Our DB administrators just asked us the following questions:

1. Is there a diagram of the database structure and how they relate to each other.

2. How much data will be in each table and how will each table be hit. This determines the bufferpools and tablespaces and the performance of the data out of the tables.

3. How many outside connections will we expect form applications to the database. This determines the stack and heap sizes of the internal database memory.

4. Is there a users group we can be a part of.

Does anyone know the answers to these questions? We are running DB2 version 8.1 under Linux Redhat Advanced Server 2.1. Basically, we are just trying to get our JDBC connection setup and we are in the process of setting up the required tables.

Thanks!

jakelee
02-25-2003, 15:35
1. you can find out from those sql scripts. installation doc should have enough info regarding the relationship
2. should expect some traffic on logging database and talk to wm ps to find more specific info.
3. connections are pooled
4. from admin UI.

dgreen
02-25-2003, 16:14
Hi, Brad.

Regarding question #4, you can check out the Chapters (http://www.wmusers.com/chapters/) section of the Web site. There are several local webMethods User Groups that hold regular meetings.

User group meetings are excellent chances for networking and knowledge sharing. I suggest that you and your team get involved.