TCP/IP Error, rc1=22

[Anurag]

ENVIRONMENT:
__________________________________________________ ______
"Server 1" = DB2 UDB ESE 7.1 FP7 on AIX 5.1
"Server 2" = DB2 UDB ESE 8.1 FP2 on AIX 5.1
__________________________________________________ ______

SCENARIO:
__________________________________________________ _________________________
1) I catalog tcpip node ("Server 2") & database "db_test" on "Server 1"

from "Server 2".
2) An attempt to connect to database "db_test" from "Server 1" gives
"SQL30081N........ Protocol specific error code(s): "22", "*", "*"

3) I have checked all the basics - SVCENAME, DB2COMM etc.
4) I can connect to lot of other DB2 UDB ESE 8.1 FP2 databases from
"Server 1".
5) I can connect to "db_test" database from my windows machine with
DB2 UDB ESE 8.2
__________________________________________________ _________________________

QUESTION:
__________________________________________________ _________________________
"Server 2" settings are ok - can connect to it from lot of machines.
"Server 1" settings are ok - I have cataloged a whole range of
databases (v7, v8) and successfully connect.

So, what could be the possible reason of this TCP/IP communication
failure? Any hints as to what does "rc1=22" mean?
Many thanks and wish you a festive season....Anurag
P.S. - "Server 1" is dev and "Server 2" is Production

[mike_li]

Try to drop the node server 2 and test_db from server 1.
Then use db2ca to help you catalog node and db.
Try again.

If it fails again, then i think you need to upgrade Server 1 to ESE 8 .


mike

Anurag wrote:

ENVIRONMENT:
__________________________________________________ ______
"Server 1" = DB2 UDB ESE 7.1 FP7 on AIX 5.1
"Server 2" = DB2 UDB ESE 8.1 FP2 on AIX 5.1
__________________________________________________ ______

SCENARIO:
__________________________________________________ _________________________
1) I catalog tcpip node ("Server 2") & database "db_test" on "Server 1"

from "Server 2".
2) An attempt to connect to database "db_test" from "Server 1" gives
"SQL30081N........ Protocol specific error code(s): "22", "*", "*"

3) I have checked all the basics - SVCENAME, DB2COMM etc.
4) I can connect to lot of other DB2 UDB ESE 8.1 FP2 databases from
"Server 1".
5) I can connect to "db_test" database from my windows machine with
DB2 UDB ESE 8.2
__________________________________________________ _________________________

QUESTION:
__________________________________________________ _________________________
"Server 2" settings are ok - can connect to it from lot of machines.
"Server 1" settings are ok - I have cataloged a whole range of
databases (v7, v8) and successfully connect.

So, what could be the possible reason of this TCP/IP communication
failure? Any hints as to what does "rc1=22" mean?
Many thanks and wish you a festive season....Anurag
P.S. - "Server 1" is dev and "Server 2" is Production

[Mark Yudkin]

There are very serious restrictions on accessing DB2 V7 servers from DB2 V8
clients. Basically, it doesn't work unless you're very very careful, and
even then it only just works on the odd occasion. If you absolutely must go
this route, read the documentation carefully and try to lower your voice
during the utterance of the expletives.

Upgrading Server 1 to V8 is the best route.

"Anurag" <an**********@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

ENVIRONMENT:
__________________________________________________ ______
"Server 1" = DB2 UDB ESE 7.1 FP7 on AIX 5.1
"Server 2" = DB2 UDB ESE 8.1 FP2 on AIX 5.1
__________________________________________________ ______

SCENARIO:
__________________________________________________ _________________________
1) I catalog tcpip node ("Server 2") & database "db_test" on "Server 1"

from "Server 2".
2) An attempt to connect to database "db_test" from "Server 1" gives
"SQL30081N........ Protocol specific error code(s): "22", "*", "*"

3) I have checked all the basics - SVCENAME, DB2COMM etc.
4) I can connect to lot of other DB2 UDB ESE 8.1 FP2 databases from
"Server 1".
5) I can connect to "db_test" database from my windows machine with
DB2 UDB ESE 8.2
__________________________________________________ _________________________

QUESTION:
__________________________________________________ _________________________
"Server 2" settings are ok - can connect to it from lot of machines.
"Server 1" settings are ok - I have cataloged a whole range of
databases (v7, v8) and successfully connect.

So, what could be the possible reason of this TCP/IP communication
failure? Any hints as to what does "rc1=22" mean?
Many thanks and wish you a festive season....Anurag
P.S. - "Server 1" is dev and "Server 2" is Production