SQL exception 1337N -- help please!

[Guest_imported]

Our web site does its database processing using JDBC on an OS 390 platform. We have found that spordically we have SQL 1337 exceptions being thrown. The error message reads
"The service "db2inst1c" was not found". This is the DB2 service we have defined. It appears as though the system table where this is defined gets corrupted and the application loses sight of the DB2 service definition. The only way to fix this then is to recycle the servers -- stop and restart them. When this is done the JVMs are forced to reread the system table and then everything is fine again. Our systems folks have tried everything but to no avail.

Can someone give me some advice/suggestions about this? I can provide more information if required.

Thanks

 

[2742]

SQL1337N The service &quot;<service-name>&quot; was not found.

Explanation: The system cannot resolve the port number associated with the service-name. Possible causes are:


An incorrect service-name value was specified when the TCP/IP node was cataloged.

The correct service-name was specified, but was not defined in the client's services file.
Federated system users: this situation can also be detected by the data source.

User Response: Make sure that the service-name specified when cataloging the TCP/IP node is a correct name, and that it is defined in the local services file.

Federated system users must also ensure that the name is defined in the services file at the data source

also check the services file eg on nt c:\winnt\system32\drivers\etc\services and the db2diag.log for futher information.

hope this helps