Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

TCP/IP Error, rc1=22

 
   Database Forums (Home) -> DB2 RSS
Next:  SUM of array  
Author Message
Anurag

External


Since: Apr 27, 2005
Posts: 8



(Msg. 1) Posted: Tue Dec 27, 2005 3:14 am
Post subject: TCP/IP Error, rc1=22
Archived from groups: comp>databases>ibm-db2 (more info?)

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, vCool 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

 >> Stay informed about: TCP/IP Error, rc1=22 
Back to top
Login to vote
mike_li

External


Since: Nov 03, 2005
Posts: 5



(Msg. 2) Posted: Tue Dec 27, 2005 2:27 pm
Post subject: Re: TCP/IP Error, rc1=22 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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, vCool 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

 >> Stay informed about: TCP/IP Error, rc1=22 
Back to top
Login to vote
Mark Yudkin

External


Since: Aug 18, 2005
Posts: 15



(Msg. 3) Posted: Wed Dec 28, 2005 3:55 am
Post subject: Re: TCP/IP Error, rc1=22 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" wrote in message

> 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, vCool 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
>
 >> Stay informed about: TCP/IP Error, rc1=22 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> DB2 All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]