Results 1 to 4 of 4

Thread: DRDA Problem

  1. #1
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Exclamation Unanswered: DRDA Problem

    Hi,

    I have this problem:

    The OS is win 2003 with SP4
    The DB2 is 8 with FP4
    And OS400 is V5R2M0


    In the db2 I have federated the OS server, when create nickname on a logical file of the os400, this return this error:
    -----------------------------------
    db2 => create nickname test01 for as825.cltdta73.v_f4211
    DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
    SQL0204N "CLTDTA73.SYSVIEWS" is an undefined name. SQLSTATE=42704
    -----------------------------------



    In the db2diag.log:
    -----------------------------------

    2003-12-07-20.14.03.484000 InstanceB2INST1 Node:000
    PID:1204(db2syscs.exe) TID:3432 Appid:*LOCAL.DB2INST1.018E07231358
    drda wrapper get_error_info Probe:1 DatabaseWCORP

    DRDA Server:
    0x01FFFF20 : 4153 3832 35 AS825

    2003-12-07-20.14.03.546000 InstanceB2INST1 Node:000
    PID:1204(db2syscs.exe) TID:3432 Appid:*LOCAL.DB2INST1.018E07231358
    drda wrapper get_error_info Probe:2 DatabaseWCORP

    Function name:
    0x5D22EC88 : 646F 5F70 7265 70 do_prep

    2003-12-07-20.14.03.609000 InstanceB2INST1 Node:000
    PID:1204(db2syscs.exe) TID:3432 Appid:*LOCAL.DB2INST1.018E07231358
    drda wrapper get_error_info Probe:3 DatabaseWCORP

    ODBC native err:
    0x0FB06F50 : 0x3430322D -204

    2003-12-07-20.14.03.671000 InstanceB2INST1 Node:000
    PID:1204(db2syscs.exe) TID:3432 Appid:*LOCAL.DB2INST1.018E07231358
    drda wrapper get_error_info Probe:4 DatabaseWCORP

    ODBC sqlstate:
    0x0FB06F41 : 3432 5330 3200 42S02.

    2003-12-07-20.14.03.734000 InstanceB2INST1 Node:000
    PID:1204(db2syscs.exe) TID:3432 Appid:*LOCAL.DB2INST1.018E07231358
    drda wrapper get_error_info Probe:5 DatabaseWCORP

    ODBC error txt:
    0x0FB06B40 : 5B49 424D 5D5B 434C 4920 4472 6976 6572 [IBM][CLI Driver
    0x0FB06B50 : 5D5B 4153 5D20 5351 4C30 3230 344E 2020 ][AS] SQL0204N
    0x0FB06B60 : 2243 4C54 4454 4137 332E 5359 5356 4945 "CLTDTA73.SYSVIE
    0x0FB06B70 : 5753 2220 6973 2061 6E20 756E 6465 6669 WS" is an undefi
    0x0FB06B80 : 6E65 6420 6E61 6D65 2E20 2053 514C 5354 ned name. SQLST
    0x0FB06B90 : 4154 453D 3432 3730 340D 0A ATE=42704..
    -----------------------------------




    Any idea?
    TIA.
    Abel.

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: DRDA Problem

    Sorry, the OS is 2000 and not 2003.

    The OS is win 2000 with SP4
    The DB2 is 8 with FP4
    And OS400 is V5R2M0


  3. #3
    Join Date
    Sep 2011
    Posts
    7

    DRDA Issue when Federating to V5R2M0

    Hi, I just came by this old thread while researching my issue. I have exactly the same issue and wanted to check if you got a resolution.

    Thanks for your help.

    SK

  4. #4
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    Quote Originally Posted by sk01 View Post
    Hi, I just came by this old thread while researching my issue. I have exactly the same issue and wanted to check if you got a resolution.

    Thanks for your help.

    SK
    I'am sorry, but, I don't remember about this theme. 2011 - 2003 = 8 years!!!

Posting Permissions

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