Federated DB - Error creating Server

jodie · #1 (**permalink**) 06-03-04, 09:02

Hi!
I am trying to get my AIX UDB (7.2) db to recognize some tables that reside on the OS/390 DB2 database (7.1).

I have cataloged the node (DB2GATE) and the db on the AIX server. The remote server that I cataloged for the node (DB2GATE) is the DB2Connect Server, not the actual mainframe. This seems to work and I can successfully connect to the OS/390 DB from the AIX box.

I then created the DRDA wrapper and set DB2_DJ_COMM environment variable.

However, when I try to create the Server, I get the following strange error:

Code:

DB21034E  The command was processed as an SQL statement because it 
was not a valid Command Line Processor command.  During SQL processing it 
returned:
SQL1822N  Unexpected error code "-1334" received from data 
source "DBT0DB". Associated text and tokens are "".

I haven't been able to find any info on it yet, but I'm still looking. If anyone has any ideas, I'd greatly appreciate any help you can give.

Here are the commands I used:

Code:

db2 catalog tcpip node DB2GATE remote db2gate server 50000
db2 catalog db dbABC as dbABC at node db2gate
db2 create wrapper drda
db2set DB2_DJ_COMM=libdrda.a

CREATE SERVER 'DBABC' TYPE DB2/390 VERSION 7.1 WRAPPER "DRDA" 
AUTHID username PASSWORD pwd OPTIONS 
( NODE 'DB2GATE', DBNAME 'DBABC' )

Thanks!
Jodie

udbraja · #2 (**permalink**) 01-06-05, 09:11

I came across the same situation now.
Any solution that you have found???

Thanks
Raj

przytula · #3 (**permalink**) 01-07-05, 01:14

the 1334 is the code you get from the remote server :

SQL1334N The database server cannot be used to route a remote
request to a second database server in this
configuration.
do db2 ? sql1334 and you get the full message
You probably connect to the mainframe through a gateway (db2 connect ?)
Best Regards, Guy Przytula

Internet Services

Web Development

Digital Marketing

Consumer Tech