Federated database problem

[wojtekb]

Hi,

I am trying to solve the following problem:

Environment:

AIX5.3+ML1 on virtual partition
DB2/UDB WSE 8.1 + FP4a

I issued following commands:

db2sampl
db2 CREATE DB test1
db2 CONNECT TO test1
db2 CREATE WRAPPER "WRA1" LIBRARY 'libdb2drda.a'
db2 CREATE SERVER R1 TYPE DB2/UDB VERSION '8.1' WRAPPER "WRA1" AUTHID
"db2inst1" PASSWORD "validpass" OPTIONS( ADD DBNAME 'SAMPLE', PASSWORD
'Y')

db2 CREATE USER MAPPING FOR "db2inst1" SERVER "R1" OPTIONS ( ADD
REMOTE_AUTHID 'db2inst1', ADD REMOTE_PASSWORD 'validpass')

db2 CREATE NICKNAME db2inst1.table1 FOR r1.db2inst1.staff
db2 "select * from db2inst1.table1"

result: as expected
next:

db2 terminate
db2 connect to test1
db2 "select * from db2inst1.table1"

and I got SQL1224N error and test1 database is marked as damaged.

There are no such problems on AIX52 environment.
Are there any differences between those environments (AIX 53 v 52)
related to db2?

If so what I hove to look at?
or what am I doing wrong?

Regards

Wojtek

[Serge Rielau]

wojtekb wrote:

Hi,

I am trying to solve the following problem:

Environment:

AIX5.3+ML1 on virtual partition
DB2/UDB WSE 8.1 + FP4a

I issued following commands:

db2sampl
db2 CREATE DB test1
db2 CONNECT TO test1
db2 CREATE WRAPPER "WRA1" LIBRARY 'libdb2drda.a'
db2 CREATE SERVER R1 TYPE DB2/UDB VERSION '8.1' WRAPPER "WRA1" AUTHID
"db2inst1" PASSWORD "validpass" OPTIONS( ADD DBNAME 'SAMPLE', PASSWORD
'Y')

db2 CREATE USER MAPPING FOR "db2inst1" SERVER "R1" OPTIONS ( ADD
REMOTE_AUTHID 'db2inst1', ADD REMOTE_PASSWORD 'validpass')

db2 CREATE NICKNAME db2inst1.table1 FOR r1.db2inst1.staff
db2 "select * from db2inst1.table1"

result: as expected
next:

db2 terminate
db2 connect to test1
db2 "select * from db2inst1.table1"

and I got SQL1224N error and test1 database is marked as damaged.

There are no such problems on AIX52 environment.
Are there any differences between those environments (AIX 53 v 52)
related to db2?

If so what I hove to look at?
or what am I doing wrong?

There shoudl be nothing that you can do wrong to get this response.
Please call support. If you're lucky it maybe matched against an APAR
fixed in a later fixpack (you are 1 year out of date). If not this is a
new APAR.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Knut Stolze]

Serge Rielau wrote:

wojtekb wrote:

Hi,

I am trying to solve the following problem:

Environment:

AIX5.3+ML1 on virtual partition
DB2/UDB WSE 8.1 + FP4a

I issued following commands:

db2sampl
db2 CREATE DB test1
db2 CONNECT TO test1
db2 CREATE WRAPPER "WRA1" LIBRARY 'libdb2drda.a'
db2 CREATE SERVER R1 TYPE DB2/UDB VERSION '8.1' WRAPPER "WRA1" AUTHID
"db2inst1" PASSWORD "validpass" OPTIONS( ADD DBNAME 'SAMPLE', PASSWORD
'Y')
You might want to add the following option here:

NODE '<instance-name>'
db2 CREATE USER MAPPING FOR "db2inst1" SERVER "R1" OPTIONS ( ADD
REMOTE_AUTHID 'db2inst1', ADD REMOTE_PASSWORD 'validpass')

db2 CREATE NICKNAME db2inst1.table1 FOR r1.db2inst1.staff
db2 "select * from db2inst1.table1"

result: as expected
next:

db2 terminate
db2 connect to test1
db2 "select * from db2inst1.table1"

and I got SQL1224N error and test1 database is marked as damaged.

Have you verified that the correct ports are used?
--
Knut Stolze
Information Integration
IBM Germany / University of Jena