Topic
  • 1 reply
  • Latest Post - ‏2008-01-22T00:52:54Z by SystemAdmin
SystemAdmin
SystemAdmin
262 Posts

Pinned topic cannot connect to iSeries from DB2 Connect

‏2007-11-16T20:49:59Z |
Hi,

When I try to connect to the iSeries, I get an error that I didn't understand, could someone help me in finding what I have to do to solve this error ?

My error message is :
SQL30000N Execution failed because of a Distributed Protocol Error that will
not affect the successful execution of subsequent commands or SQL statements:
Reason Code "0x1254"("02F1"). SQLSTATE=58008

OS : Linux Debian Etch 4.0
Installed software : First, I installed DB2Client and then I installed DB2 Connect Personnal Edition.
I think that I succeded in installing DB2 Connect over DB2 Client.
I also have unixODBC and iSeriesAccess, that allow me to connect to the server using ODBC protocol.

The DB2 connect settings are :
db2 catalog tcpip node node12 remote 10.10.10.10 server 446
db2 catalog db db12 at node node12 authentication dcs
db2 catalog dcs db db12 as RDB
db2 terminate
db2 connect to db12 user mylogin using mypass

The error is thrown with the last command.

I activate drda trace and the end of the trace file is :

7 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100)
pid 1491 tid 3045140160 cpid -1 node 0 probe 100
bytes 12

Data1 (PD_TYPE_UINT,4) unsigned integer:
32

8 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178)
pid 1491 tid 3045140160 cpid -1 node 0 probe 1178
bytes 49

RECEIVE BUFFER(AR):

CMDCHKRM RPYDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 0020D0020001001A 1254000611490010 . .......T...I.. ..}.............
0010 0005115CF1000B11 53C3D7C6F1F8F9F3 ...\....S....... ...*1....CPF1893

I think this file is not really readable...
But perhaps, it could help someone else...

The final aim is to run sql command and as400 program with php.
With unixODBC driver, I succeded in running select query but I failed to run AS400 program because there is some OUT parameters and PHP interface and odbc_ function didn't manage OUT parameters.
So I would like to use db2_ functions but connection failed.

Thank you for your help
Serge
Updated on 2008-01-22T00:52:54Z at 2008-01-22T00:52:54Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    262 Posts

    Re: cannot connect to iSeries from DB2 Connect

    ‏2008-01-22T00:52:54Z  
    Hello Serge,

    This forum is for System i Access for Linux issues only. I cannot help in the DB2 Connect personal edition problems.

    If you are having a problem with the ODBC Client Access driver, could you please explain?

    Regards,