473,231 Members | 1,384 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

SQL30081N after RESET DATABASE CONFIGURATION

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
Feb 17 '06 #1
7 6855
Ive seen this problem before. Check whether you lost the following
registry value:

db2set DB2COMM=tcpip

-Michel

Ina Schmitz escreveu:
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


Feb 17 '06 #2
Ian
Ina Schmitz wrote:
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?


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.
Feb 17 '06 #3
Michel Esber wrote:
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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Feb 17 '06 #4
"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

Feb 18 '06 #5
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
Mar 1 '06 #6
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.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Ina Schmitz" <we*@inalein.net> a crit dans le message de news:
du*************@news.t-online.com...
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


Mar 1 '06 #7
Ina Schmitz wrote:
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?
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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Mar 3 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: alederer | last post by:
Hallo! I have the following situation: A db2 v6.1 client on AIX 4.3 (db2level reports U469703) and a OS/390 database version 6.1 . In some situations, I get the following error in my db2...
2
by: xcb7226 | last post by:
Is it possible to reset monitor global, without turn Off/on monitor switches (an restart of the instance). It seems that reset monitor effects only the shell from where it's performed
3
by: Laura | last post by:
I've just installed the DB2 Run-time client in a Solaris machine. Then I finnish the installation configuring the connection: 1. machine catalog was OK: ========================== $ db2 catalog...
1
by: Praveen | last post by:
Hi, I have installed WebSphere Portal on AIX and connected to DB2 on a remote machine, Getting the followin errors when trying to get the values from database thru applications installed on...
4
by: Ralf Gross | last post by:
Hi, I installed DB2 V8.1 with fixpak 10, created a new database and can connect to the database. $ db2 connect to mkstest Database Connection Information Database server =...
4
by: Asphalt Blazer | last post by:
Hi, I have a remote DB2 database on AIX and I am accessing ti using a windows client .i was using control center on windows to add the remote system under it and I gave all the node names and...
0
by: Troels Arvin | last post by:
Hello, From SAS, we're getting the following error message once in a while: ERROR: CLI error trying to establish connection: SQL30081N A communication error has been detected. Communication...
1
by: toffees | last post by:
Hi, I am having some problems getting an application server to connect to the database server. Both servers run on Windows 2000 Server. DB2 version 7.2 is running on the database server. I am able...
2
by: dimeuleh | last post by:
I am new to DB2 but I am currently doing a small project which involves two normal windows xp workstations both using DB2 Express C. I keep getting the SQL30081N error. I have researched why...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.