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.

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

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!!!