Hi,
I'm connecting to as/400 using db2connect through SNA from vb.
OS400 V4R5
Db2Connect EE V 7.1 FP 10
MS SNA Server 4.2.
NT 4.0
VB 6.0
1.DB2Connect service on the db2connect server crashes logging the following message to the nt log:
***************************
2003-12-18-08.53.54.055000 Instance:DB2 Node:000
PID:316(db2syscs.exe) TID:318 Appid:none
An error has occurred and diagnostic information has been
written to db2diag.log. Please examine the entry and
contact IBM Service if necessary.

12/18/03 8:53:54 AM DB2 Error None 2 N/A ATLSNA1
--> Location : gateway_drda_ar sqljmrln
--> Identifier : 84.2055
--> Symptom :

12/18/03 8:53:47 AM DB2 Error None 2 N/A ATLSNA1
--> Location : oper_system_services sqlofica
--> Identifier : 10.2055
--> Symptom :
***************************

db2diaglog is:

***************************
2003-12-18-08.53.54.055000 Instance:DB2 Node:000
PID:316(db2syscs.exe) TID:318 Appid:none
gateway_drda_ar sqljmrln Probe:84
DIA4804E A DRDA datastream parsing error has been detected. A dump has been
generated.
ALERT :25
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** SQLCA ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** COMM BUFFER ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** LOCAL INFO ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** REMOTE INFO ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** AR INFO ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** CCSID ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** FDOCA ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** ERROR INFO ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** TOKEN CB ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** TOKEN CB ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** CURSOR CB ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** TOKEN CB ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** CCB BUFFER ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** CCB BUFFER ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** CURSOR CB ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** TOKEN CB ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** CCB BUFFER ****
Dump File:C:\SQLLIB\DB2\316318.000 Data:**** CCB BUFFER ****

Data Title:SQLCA PID:316 TID:318 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml: 5
sqlerrmc: 124C
sqlerrp : SQLJMRC
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 58009
***************************


C:\SQLLIB\DB2\316318.000 file is binary and I don't know how to see the file content.

can anyone help to understand what the problem is?


2. I don't think it causes the crash but i see the following lines
In my ODBC trace file:
***************************
DIAG [S0002] [IBM][CLI Driver][AS] SQL0204N "DBUSER.SYSCOLUMNS" is an undefined name. SQLSTATE=42704
(-204)
DIAG [01S02] [IBM][CLI Driver] CLI0005W Option value changed. SQLSTATE=01S02 (-99999)
***************************

*DBUSER is the user which i use to connect to as400.

These lines appear just after some(not all) select statements. one of the select statements is :
select servis from alib.srvtable

Thanks in advance.
Mahmut Eren