NewBee Express-C Questions

[gimme_this_gimme_that]

Hello fellow DB2ers!

I have a new DB2 Express-C (version 9.5) installation running on Vista
Business.

I'm able to create new databases using the "create db dbname" command.
I'm setting out to configure my DB2 installation so I can establish
connections from a web application.

So I have a few questions:

1. How do I create a database and associate a port number for
connections?

2. Once my database is created, how do I see what port number it runs
on?

3. Where is the Express-C driver file (db2jcc_license_cu.jar) that
I'd use with Java to connect?

4. Do the type-4 Java drivers (db2jcc.jar) that connect to DB2 for
Enterprise versions of DB2 also work for Express-C?

5. I need to create a new user for connecting to an application. The
username is PORTAL.

Right now my computer is named lenovo and the workgroup is the out of
the box WORKGROUP.

ha ha.

Should I modify these values or go with what I have?

That is, do I need to install Kerberose and configure that so the user
PORTAL can connect?

Or do I need to set up a Windows DOMAIN and use something aside from
WORKGROUP?

6. Can I swap out 127.0.0.1 in my connection strings for the host
name?

Thanks.

[Mark A]

<gi*******************@yahoo.comwrote in message
news:a6**********************************@q30g2000 prq.googlegroups.com...

Hello fellow DB2ers!

I have a new DB2 Express-C (version 9.5) installation running on Vista
Business.

I'm able to create new databases using the "create db dbname" command.
I'm setting out to configure my DB2 installation so I can establish
connections from a web application.

So I have a few questions:

1. How do I create a database and associate a port number for
connections?

2. Once my database is created, how do I see what port number it runs
on?

3. Where is the Express-C driver file (db2jcc_license_cu.jar) that
I'd use with Java to connect?

4. Do the type-4 Java drivers (db2jcc.jar) that connect to DB2 for
Enterprise versions of DB2 also work for Express-C?

5. I need to create a new user for connecting to an application. The
username is PORTAL.

Right now my computer is named lenovo and the workgroup is the out of
the box WORKGROUP.

ha ha.

Should I modify these values or go with what I have?

That is, do I need to install Kerberose and configure that so the user
PORTAL can connect?

Or do I need to set up a Windows DOMAIN and use something aside from
WORKGROUP?

6. Can I swap out 127.0.0.1 in my connection strings for the host
name?

Thanks.

1. The port number is associated with the instance, not the database. With
DB2 Windows install, a default instance is created (you can create
additional instances) with a port number of 50000.

2. db2 get dbm cfg. The port number is the SVCENAME, which is tied to port
50000 in a services file in Windows. You can change the port number by
hardcoding the port number such as "db2 update db cfg using svcename 50100".

3. Not sure. But you can download them from the IBM website for free without
the data server.

4. Yes

5. DB2 uses the Operating System user and password, so create it in windows,
then use grant statement to give access in DB2 to specific objects. You do
not need a domain.

6. Not sure.