473,385 Members | 1,602 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Is it necessary to rebind JDBC Type 4 packages when installing a new Fix Pack

klh
We just installed DB2 ESE V8 FP12 on our Windows 2003 servers. We also
installed the DB2 ADMCL V8 FP12 on our websphere servers. We use the
JDBC Type 4 drivers on our websphere servers to directly hit our DB2
Z/OS V7 databases.

When we originally set up this environment (DB2 V8 FP8) we had to bind
the JDBC type 4 drivers using the syntax:

java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://(ip address):(port
number)/(system name) -user (userid) -password (pswd) -collection
(collection name) -size 10 -keepdynamic yes

So, I assumed that after installing FP12 I should rebind the JDBC Type
4 packages, however, when I try to run the above statement it fails
saying the packages already exist. After looking on the IBM web site
it appears that there is no provision for being able to run the
DB2binder and replace the existing packages.

My question is:
1) Is it even necessary to rebind these packages? (the readme.txt
files for the FP12 don't mention doing this)
2) If it should be done, do I have to free all of the current packages,
and then rerun the DB2binder? If so, can I identify all of the
packages to free by looking at all the packages under "collection
name"? Or is there a chance that IBM slips some packages in other
locations, besides "collection name" when the DB2binder is run?

Thanks for any insight into this question.
klh

Aug 24 '06 #1
0 1581

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

134
by: James A. Donald | last post by:
I am contemplating getting into Python, which is used by engineers I admire - google and Bram Cohen, but was horrified to read "no variable or argument declarations are necessary." Surely that...
3
by: Steverino | last post by:
Hi, I'm currently trying to learn DB2. I have the following version below installed on my server machine on my little LAN. However when I try to connect to it from my client machine, I receive...
2
by: Marc Stiegele | last post by:
Hello, I have a problem with the IBM DB2 UDB XML Extender. I`m working on a iSeries 400 server (AS/400, V5R1) with a integrated DB2 (my client is NT 4.0 Service Pack 1 with JDK1.1.8). I want to...
0
by: Bing | last post by:
Hi, I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x environment and WebSphere application Server 5.0.2...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
2
by: SKC | last post by:
Platform : Solaris UDB : version 7.2 FP9 DB2RBIND PACKAGE SCHEMA.PACKAGE fails with SQL0029N error. When I issue, "db2rbind DBNAME all", it is successfull. Can anyone help me understand...
8
by: deegs_ca | last post by:
So I had my jdbc db28.2 fix pack 9 client running because I had taken the jars from <DB2ROOT>/java folder from Enterprise Edition 8.2 fix pack 9, db2java.zip, db2jcc.zip, and the license jar. ...
0
by: Kris Jurka | last post by:
The JDBC driver has been moved out of the main source tree to a gborg project. This change will only affect new major releases. The 7.4 series will continue to be maintained in the main tree. ...
11
by: David H. Cook | last post by:
Hi - I just installed the express-edition of DB2 server (on a Win-XP machine), and then I setup a client JDBC driver to access it. The query is a simple 'select * from EMPLOYEE' against their...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.