SQL30081N after RESET DATABASE CONFIGURATION

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ina Schmitz - 17 Feb 2006 17:14 GMT

Hi NG,

I wanted to reset the database (manager) configuration with
RESET DATABASE CONFIGURATION
and
RESET DATABASE MANAGER CONFIGURATION

After doing this, I rebooted server and client and restarted IBM Universal
Database 8.2.
But now, I couldn't connect to my database anymore :-( getting the following
message:
SQL30081N Kommunikationsfehler. Verwendetes Kommunikationsprotokoll:
"TCP/IP". Verwendete Kommunikations-API: "SOCKETS". Position, an der der
Fehler festgestellt wurde: "[*there_was_the_ip*]". Kommunikationsfunktion,
die den
Fehler feststellte: "connect". Protokollspezifische(r) Fehlercode(s):
"10060",
"*", "*". SQLSTATE=08001

How could I fix the problem?

I would be glad for any help!
Cheers,
Ina

Reply to this Message

Michel Esber - 17 Feb 2006 17:58 GMT

I´ve seen this problem before. Check whether you lost the following
registry value:

db2set DB2COMM=tcpip

-Michel

> Hi NG,
>
[quoted text clipped - 20 lines]
> Cheers,
> Ina

Reply to this Message

Knut Stolze - 17 Feb 2006 21:03 GMT

> I´ve seen this problem before. Check whether you lost the following
> registry value:
>
> db2set DB2COMM=tcpip

The db2set will not be affected by the RESET, but the port on which your
instance listens is set to nothing. So the TCP/IP protocol can effectively
not be used and you have to set the port (SVCENAME) again.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Ian - 17 Feb 2006 20:12 GMT

> Hi NG,
>
[quoted text clipped - 16 lines]
>
> How could I fix the problem?

RESET DATABASE MANAGER CONFIGURATION wiped out the setting for SVCENAME
(i.e. which tells DB2 which TCP port to listen to for connections!)

You need to set it back to what it was and then restart your instance.

Reply to this Message

cheng.j3@gmail.com - 18 Feb 2006 04:33 GMT

"svcename" in dbm cfg may be got reset to null , which is need by
remote client . Try "db2 -v update dbm cfg using svcename 50000" .
50000 is the default tcp port for DB2 UDB on windows. This may be
various and changable .

Cheng

Reply to this Message

Ina Schmitz - 01 Mar 2006 10:09 GMT

Hello again,

thanks for your answers!
The "svcename" set to null really was the problem.
I would like to reset my dbm cfg again not sitting at the server, but at a
remote client. Is there any possibility to specify the svcename already
during my reset?

Otherwise, I can't update the svcename on my own, because after resetting my
dbm cfg I can't connect to the database, of course ;-) Then I would have to
ask anyone sitting at the server to update it.

Would be great if you also know a solution to this problem.
Cheers,
Ina

Reply to this Message

Pierre Saint-Jacques - 01 Mar 2006 20:48 GMT

If you are at a remote client and want to change parms. of the remote dbm
then you need to use:
1) The Admin. Tools, ie Control Center, access the instance and change its
communications parms. Ypu'll need the SYSADMIN id for that instance.
Stop/Start the instance.
2) Use TelNet or whatever to start a local session on the remote server at
your wkstn. Isuue the db2 update dbm cfg using svcename command.
Stop/start the instance.

Shut the TelNet session or the Control Center.and go from there to update
your local client files.

HTH, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Hello again,
>
[quoted text clipped - 11 lines]
> Cheers,
> Ina

Reply to this Message

Knut Stolze - 03 Mar 2006 07:22 GMT

> Hello again,
>
[quoted text clipped - 3 lines]
> remote client. Is there any possibility to specify the svcename already
> during my reset?

You have to have an attachment to the server instance (see the ATTACH
command). The DB2 control center does the attach under the covers for you
in case you are a "Mausschubser". ;-)

> Otherwise, I can't update the svcename on my own, because after resetting
> my dbm cfg I can't connect to the database, of course ;-) Then I would
> have to ask anyone sitting at the server to update it.

Well, you can run the update from the client. You just have to make sure
that you set the SVCENAME _before_ DB2 is restarted. The thing is that the
reset becomes effective after the restart of the engine. Thus, you should
still be able to connect to the server (from the client) until that restart
took place.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message