Problems with performing db2updv8 on database in db2

[Mahesh S]

Hi

I am trying to create a federated database using information
integrator. When I tried creating wrapper on by right clicking on
"Federated database objects" which appears under every database, I get
the following error:

[IBM][CLI Driver][DB2/NT] SQL0444N Routine
"SYSPROC.GET_WR AP_CFG_C"
(specific name "GET_WRAP_CFG_C ") is implemented with code in
library or path
"\db2dsproc ", function "getWrapperXMLF iles" which cannot be
accessed. Reason
code: "4". SQLSTATE=42724

The federated database has not been updated to the current
version.
Use the db2updv8 utility to update this database.

I performed db2updv8 command on the database, restarted the db2admin
and also did db2start but I still keep getting the same error.

Any suggestions as to what I may be doing wrong?

I am using the following on Windows XP machine.
=============== =============== =============== ===============
About DB2 Administration Tools Environment
=============== =============== =============== ===============
DB2 administration tools level:
Product identifier SQL08020
Level identifier 03010106
Level DB2 v8.1.7.445
Build level s040812
PTF WR21342
=============== =============== =============== ===============
Java development kit (JDK):
Level IBM Corporation 1.4.1
=============== =============== =============== ===============

Thanks
Mahesh

[Knut Stolze]

Re: Problems with performing db2updv8 on database in db2

Mahesh S wrote:
[color=blue]
> Hi
>
> I am trying to create a federated database using information
> integrator. When I tried creating wrapper on by right clicking on
> "Federated database objects" which appears under every database, I get
> the following error:
>
> [IBM][CLI Driver][DB2/NT] SQL0444N Routine
> "SYSPROC.GET_WR AP_CFG_C"
> (specific name "GET_WRAP_CFG_C ") is implemented with code in
> library or path
> "\db2dsproc ", function "getWrapperXMLF iles" which cannot be
> accessed. Reason
> code: "4". SQLSTATE=42724[/color]

I've seen this error message before and it occurred when someone tried to
use federated features on a DB2 Personal Edition - where it is not
supported. Which DB2 edition are you running? (db2licm -l will tell you
that)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Mahesh S]

Re: Problems with performing db2updv8 on database in db2

Hi Knut

Thanks for the information. Yes, I am using DB2 PE. Guess I will have
to get some other version. Any suggestions? Could you please suggest
the version that I need to use to get the federated features definitely
working?

Thanks a lot

Mahesh

[Gert van der Kooij]

Re: Problems with performing db2updv8 on database in db2

In article <1145531539.553 531.140580@v46g 2000cwv.googleg roups.com>,
mahesh.leo@gmai l.com says...[color=blue]
> Hi Knut
>
> Thanks for the information. Yes, I am using DB2 PE. Guess I will have
> to get some other version. Any suggestions? Could you please suggest
> the version that I need to use to get the federated features definitely
> working?
>[/color]

Db2 Express-C is the free DB2 version with federated db support.
You can download it from

http://www-306.ibm.com/software/data/db2/udb/db2express/download.html

[Mahesh S]

Re: Problems with performing db2updv8 on database in db2

hey

thanks..

i assume that i will still need to download and install information
integrator seperately.. or is it included in this version of db2?

thanks
mahes

[Gert van der Kooij]

Re: Problems with performing db2updv8 on database in db2

In article <1145534838.503 797.188450@e56g 2000cwe.googleg roups.com>,
mahesh.leo@gmai l.com says...[color=blue]
> hey
>
> thanks..
>
> i assume that i will still need to download and install information
> integrator seperately.. or is it included in this version of db2?
>
> thanks
> mahes
>
>[/color]

For defining wrappers to DB2 UDB LUW (Linux, Unix, Windows) you don't
need DB2 II. I'm not sure about DB2 z/OS.

[Knut Stolze]

Re: Problems with performing db2updv8 on database in db2

Mahesh S wrote:
[color=blue]
> hey
>
> thanks..
>
> i assume that i will still need to download and install information
> integrator seperately.. or is it included in this version of db2?[/color]

If you want to access DB2 or Informix databases only, then you don't need
II.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Mahesh S]

Re: Problems with performing db2updv8 on database in db2

OK.. At this point, I am looking at accessing only DB2 databases. So,
thats good news.

Any tutorials available for bringing together multiple DB2 databases
with the same structure (but present in multiple locations) under one
roof?

I apologise for troubling you.

Cheers
Mahesh

[Mahesh S]

Re: Problems with performing db2updv8 on database in db2

Hi Gert

I do have one more query. Hope I am not troubling you too much.

I have successfully created wrappers for two db2 databases located in
different locations. The thing is, they have the exact same structure
but storing different data. I have a table named Patient which stores
patient details pertaining to that location. What I would like to do
is have a single table that would combine records present in the two
db2 tables located in different locations. I am not talking of a join
here but more of sticking records from one table at the end of records
from another table. How do I go about doing that?

Thank you for your time.

Regards
Mahesh

[Knut Stolze]

Re: Problems with performing db2updv8 on database in db2

Mahesh S wrote:
[color=blue]
> Hi Gert
>
> I do have one more query. Hope I am not troubling you too much.
>
> I have successfully created wrappers for two db2 databases located in
> different locations. The thing is, they have the exact same structure
> but storing different data. I have a table named Patient which stores
> patient details pertaining to that location. What I would like to do
> is have a single table that would combine records present in the two
> db2 tables located in different locations. I am not talking of a join
> here but more of sticking records from one table at the end of records
> from another table. How do I go about doing that?[/color]

You have to create two nicknames. One points to the table in database A and
the other to the table in database B. Then you create a view over both
nicknames and UNION the results:

CREATE NICKNAME n1 FOR server1.schema. table
CREATE NICKNAME n2 FOR server2.schema. table
CREATE VIEW v AS
SELECT * FROM n1
UNION ALL
SELECT * FROM n2

If you still want to distinguish where the data came from, just put this
into the view definition (this is just plain and simple SQL):

CREATE VIEW v AS
SELECT 'n1' AS source, n1.* FROM n1
UNION ALL
SELECT 'n2' AS source, n2.* FROM n2

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Mahesh S]

Re: Problems with performing db2updv8 on database in db2

thats great man.. it worked.. thanks a lot..