Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Ohio
    Posts
    38

    Question Unanswered: Federated DB - Error creating Server

    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

  2. #2
    Join Date
    Sep 2004
    Posts
    111

    Arrow

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

    Thanks
    Raj

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    drda

    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
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •