DB2 V9 CM on z/os1.10 - Java drivers

Carol Anne Sutfin

DB2 V9 CM on z/os1.10 - Java drivers
We have just upgraded from DB2 V8 to DB2 V9 CM

Everything is working except our one Java application.
It has stopped altogether.

The DB2 Systems guy has done everything he can find to get this working
again.
Bound Plan/packages, I have made sure that access has been granted, etc.

This "thing" runs in USS and just refuses to connect.

The USS guy has sent me the following messages from the log of the app.

Dec 14, 2009 3:29:25 PM org.apache.catalina.core.StandardHostDeployer
install
INFO: Processing Context configuration file URL
file:/u/TOMCAT/DMTK/MODEL/tomcat/conf/Catalina/localhost/dirmgt.xml
com.corillian.dms.exception.SystemUnavailableException
:at com.corillian.dms.directory.utils.DbConnector.connect(Unknown Source)

Yes, we are using Apache/Tomcat to run this. Don't know the version of
this.

Has anyone got any suggestions about what we may do to get this running
again.

TIA
Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Nenad Vidak

Re: DB2 V9 CM on z/os1.10 - Java drivers
(in response to Carol Anne Sutfin)
Hello,

When migrating to V9, you have also migrated to the new JDBC driver that
(probably) has different path for its part under USS. ( for example our new
path is "/shared/db2/db2910_jdbc/classes/" ). Make sure that Tomcat ( and
applications on it) is aware of this. I.e. that they use new jars
(db2jcc.jar and db2jcc_license_cisuz.jar) ...

Try to execute " java com.ibm.db2.jcc.DB2Jcc -version " from the USS shell
command line. I should return something like this :

" IBM DB2 JDBC Universal Driver Architecture 3.53.104 "

Also consider changing default profiles in the etc directory to reflect
changes in the JDBC driver path ...

Regards, Nenad


On Thu, 17 Dec 2009 16:01:33 -0600, [login to unmask email] wrote:

>We have just upgraded from DB2 V8 to DB2 V9 CM
>
>Everything is working except our one Java application.
>It has stopped altogether.
>
>The DB2 Systems guy has done everything he can find to get this working
>again.
>Bound Plan/packages, I have made sure that access has been granted, etc.
>
>This "thing" runs in USS and just refuses to connect.
>
>The USS guy has sent me the following messages from the log of the app.
>
>Dec 14, 2009 3:29:25 PM org.apache.catalina.core.StandardHostDeployer
>install
>INFO: Processing Context configuration file URL
>file:/u/TOMCAT/DMTK/MODEL/tomcat/conf/Catalina/localhost/dirmgt.xml
>com.corillian.dms.exception.SystemUnavailableException
>:at com.corillian.dms.directory.utils.DbConnector.connect(Unknown Source)
>
>Yes, we are using Apache/Tomcat to run this. Don't know the version of
>this.
>
>Has anyone got any suggestions about what we may do to get this running
>again.
>
>TIA
>Carol Sutfin
>Corporate DBA
>Regions Financial Corp.
>(205)261-5214
>[login to unmask email]
>
>_____________________________________________________________________
>
>* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
>_____________________________________________________________________
>
>http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
>there is probably one near you!
>Regional User Groups are your local connection to the Worldwide DB2 User
Community
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L