Problem with federated database

[Alias]

Hi Guys ,
I am trying to create a federated database link between 2
UDB 8.1 databases running on AIX on the same box but under different
instances. When i tried this thru the control centre , I got this error
:
************************************************** ***
[IBM][CLI Driver][DB2/6000] SQL1013N The database alias name or
database name "SAMPLE" could not be found. SQLSTATE=42705
************************************************** ***

Now I have already catalog this databas on the server and I can
directly connect to this database easily but when I try this federated
thing, only then it gives me trouble.
I also tried creating federated link on the server itsef from the
command line but this time i get a different error :
************************************************** ******
While referencing a data source, the federated server received an
unexpected error code from the data source that does not map to a
DB2 equivalent.

Possible error codes include:

o 4901 Trying to open more than 15 cursors

o 4902 Row size exceeds 32K limit
************************************************** ********
Any help will be much appreciated .

[Larry]

How did you set up the Federation? What CREATE SERVER, CREATE WRAPPER,
etc. commands did you use?

Larry Edelstein

Alias wrote:

Hi Guys ,
I am trying to create a federated database link between 2
UDB 8.1 databases running on AIX on the same box but under different
instances. When i tried this thru the control centre , I got this error
:
************************************************** ***
[IBM][CLI Driver][DB2/6000] SQL1013N The database alias name or
database name "SAMPLE" could not be found. SQLSTATE=42705
************************************************** ***

Now I have already catalog this databas on the server and I can
directly connect to this database easily but when I try this federated
thing, only then it gives me trouble.
I also tried creating federated link on the server itsef from the
command line but this time i get a different error :
************************************************** ******
While referencing a data source, the federated server received an
unexpected error code from the data source that does not map to a
DB2 equivalent.

Possible error codes include:

o 4901 Trying to open more than 15 cursors

o 4902 Row size exceeds 32K limit
************************************************** ********
Any help will be much appreciated .

[Alias]

For creating wrapper :

CREATE WRAPPER "DRDA" LIBRARY 'libdb2drda.a';
For creating Server :

CREATE SERVER "mydb" TYPE DB2/UDB VERSION '8.1' WRAPPER "DRDA" AUTHID
"user1" PASSWORD "*****" OPTIONS ( DBNAME 'SAMPLE' );

Infact its here while creating server that I receive the following
error:

[IBM][CLI Driver][DB2/6000] SQL1013N The database alias name or
database name "SAMPLE" could not be found. SQLSTATE=42705

Thanks.


Larry wrote:

How did you set up the Federation? What CREATE SERVER, CREATE WRAPPER,
etc. commands did you use?

Larry Edelstein

Alias wrote:

Hi Guys ,
I am trying to create a federated database link between 2
UDB 8.1 databases running on AIX on the same box but under different
instances. When i tried this thru the control centre , I got this error
:
************************************************** ***
[IBM][CLI Driver][DB2/6000] SQL1013N The database alias name or
database name "SAMPLE" could not be found. SQLSTATE=42705
************************************************** ***

Now I have already catalog this databas on the server and I can
directly connect to this database easily but when I try this federated
thing, only then it gives me trouble.
I also tried creating federated link on the server itsef from the
command line but this time i get a different error :
************************************************** ******
While referencing a data source, the federated server received an
unexpected error code from the data source that does not map to a
DB2 equivalent.

Possible error codes include:

o 4901 Trying to open more than 15 cursors

o 4902 Row size exceeds 32K limit
************************************************** ********
Any help will be much appreciated .

[Larry]

Have you cataloged the SAMPLE database (let's say this database resides
on instance "B") on instance "A" (the instance from which you are trying
to establish the Federation)? That database needs to be cataloged as a
remote database I believe.

Larry Edelstein

Alias wrote:

For creating wrapper :

CREATE WRAPPER "DRDA" LIBRARY 'libdb2drda.a';
For creating Server :

CREATE SERVER "mydb" TYPE DB2/UDB VERSION '8.1' WRAPPER "DRDA" AUTHID
"user1" PASSWORD "*****" OPTIONS ( DBNAME 'SAMPLE' );

Infact its here while creating server that I receive the following
error:

[IBM][CLI Driver][DB2/6000] SQL1013N The database alias name or
database name "SAMPLE" could not be found. SQLSTATE=42705

Thanks.


Larry wrote:

How did you set up the Federation? What CREATE SERVER, CREATE WRAPPER,
etc. commands did you use?

Larry Edelstein

Alias wrote:

Hi Guys ,
I am trying to create a federated database link between 2
UDB 8.1 databases running on AIX on the same box but under different
instances. When i tried this thru the control centre , I got this error
:
*********************************************** ******
[IBM][CLI Driver][DB2/6000] SQL1013N The database alias name or
database name "SAMPLE" could not be found. SQLSTATE=42705
*********************************************** ******

Now I have already catalog this databas on the server and I can
directly connect to this database easily but when I try this federated
thing, only then it gives me trouble.
I also tried creating federated link on the server itsef from the
command line but this time i get a different error :
*********************************************** *********
While referencing a data source, the federated server received an
unexpected error code from the data source that does not map to a
DB2 equivalent.

Possible error codes include:

o 4901 Trying to open more than 15 cursors

o 4902 Row size exceeds 32K limit
*********************************************** ***********
Any help will be much appreciated .

[hikums]

Please try your command from the command line. Control center does not
work always.

Please post the following:

db2 list database directory
db2 list node directory

If you are cataloging from aix to windows, aix database directory
should list the db(for this you have to catalog the node and the db,
then try connecting to remote db, before federating).

[Alias]

Well trying from the command line seems to have help. It worked fine .
Infact the step which creates problemis 'create server xxxxx ' ; If I
create server from command line then I can do rest from control centre
easily( creating user mappings/nick names ) but control centre does not
let me create server. So I am creating server from command line and
doing rest from control centre.

Thanks for the help though.

[e-mail] wrote:

Please try your command from the command line. Control center does not
work always.

Please post the following:

db2 list database directory
db2 list node directory

If you are cataloging from aix to windows, aix database directory
should list the db(for this you have to catalog the node and the db,
then try connecting to remote db, before federating).