Hi everyone ,

I'm getting a small error with db2 . I have been looking for it on
internet and found almost nothing (some webpage without any answer) .

Small recap : My db2 is a 7.x with a redhat Linux 6.2 .

My errors :

2005-07-11-07.40.20.316547 Instance:db2inst1 Node:000
PID:31329(jre) Appid:
base_sys_utilities sqledscvr_getinfo Probe:130
DIA2800E Impossible d'ouvrir le fichier
"/database/db2inst1/sqllib/tmp/0.spf".

2005-07-11-07.41.24.083267 Instance:db2inst1 Node:000
PID:31329(jre) Appid:
common_communication sqlcctcpconnr Probe:22
DIA3207E L'appel TCP/IP "gethostbyname" a renvoyé l'erreur h_errno
"1".


Have you seen something like this ?

I think this is an interaction problem with websphere & db2 but I'm not
sure . This is not a production problem but if I can be proactive on it
and avoid a future issue , it will be nice (for me at least)

TIA for any hint .

Regards ,
Andy the beginner in DB2

Andy K wrote:
>Hi everyone ,
>
>I'm getting a small error with db2 . I have been looking for it on
>internet and found almost nothing (some webpage without any answer) .
>
>Small recap : My db2 is a 7.x with a redhat Linux 6.2 .
>
>My errors :
>
>2005-07-11-07.40.20.316547 Instance:db2inst1 Node:000
>PID:31329(jre) Appid:
>base_sys_utilities sqledscvr_getinfo Probe:130
>DIA2800E Impossible d'ouvrir le fichier

Not exactly sure what is causing these errors but one thing you can try is to
catalog the tcpip node with an IP address in stead of a host name.
>"/database/db2inst1/sqllib/tmp/0.spf".
>
>2005-07-11-07.41.24.083267 Instance:db2inst1 Node:000
>PID:31329(jre) Appid:
>common_communication sqlcctcpconnr Probe:22
>DIA3207E L'appel TCP/IP "gethostbyname" a renvoyé l'erreur h_errno
>"1".
>
>Have you seen something like this ?
>
>I think this is an interaction problem with websphere & db2 but I'm not
>sure . This is not a production problem but if I can be proactive on it
>and avoid a future issue , it will be nice (for me at least)
>
>TIA for any hint .
>
>Regards ,
>Andy the beginner in DB2


--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200507/1

Hey Anton ,

Thks for the tips . Will try and hope this error won't happen again .

Regards ,
Andy the beginner in DB2.

Andy K a écrit :
> Hi everyone ,
>
> I'm getting a small error with db2 . I have been looking for it on
> internet and found almost nothing (some webpage without any answer) .
>
> Small recap : My db2 is a 7.x with a redhat Linux 6.2 .
>
> My errors :
>
> 2005-07-11-07.40.20.316547 Instance:db2inst1 Node:000
> PID:31329(jre) Appid:
> base_sys_utilities sqledscvr_getinfo Probe:130
> DIA2800E Impossible d'ouvrir le fichier
> "/database/db2inst1/sqllib/tmp/0.spf".
>
> 2005-07-11-07.41.24.083267 Instance:db2inst1 Node:000
> PID:31329(jre) Appid:
> common_communication sqlcctcpconnr Probe:22
> DIA3207E L'appel TCP/IP "gethostbyname" a renvoyé l'erreur h_errno
> "1".
>
>
> Have you seen something like this ?
>
> I think this is an interaction problem with websphere & db2 but I'm not
> sure . This is not a production problem but if I can be proactive on it
> and avoid a future issue , it will be nice (for me at least)
>
> TIA for any hint .
>
> Regards ,
> Andy the beginner in DB2