If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL5043N Error during db2start

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-11-04, 03:05
Falcon_down Falcon_down is offline
Registered User
 
Join Date: Aug 2004
Location: India
Posts: 13
SQL5043N Error during db2start

Hi ,

I am getting the following error during db2start

SQL5043N Support for one or more communications protocols failed
to start successfully. However, core database manager
functionality started successfully.


Instance is db2inst1


Following is there in the /etc/services file

DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp
db2c_db2inst1 50000/tcp


Following is there in the dbm cfg file

TCP/IP Service name (SVCENAME) = DB2_db2inst1


Following is the output of db2set -all command

[i] DB2COMM=tcpip
[g] DB2SYSTEM=aix2x4
[g] DB2ADMINSERVER=db2das


Also I am not able to catalog the databases through client configuration assistant

any help regarding this would be greatly appreciated

Thanks

Falcon
Reply With Quote
  #2 (permalink)  
Old 08-11-04, 04:44
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Check you db2diag.log and/or the nfy file in sqllib/db2dump path

Cheers
sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 08-11-04, 07:31
Falcon_down Falcon_down is offline
Registered User
 
Join Date: Aug 2004
Location: India
Posts: 13
hI sathyaram ,

The Ddb2diag.log doesnot have any information about it it says TCPIP support sucessfully started


Regards

Falcon
Reply With Quote
  #4 (permalink)  
Old 08-11-04, 08:03
g.dipietro80 g.dipietro80 is offline
Registered User
 
Join Date: Jun 2004
Posts: 1
Sorry for my english

Have you right access permission on file /etc/services ??
I remeber that this message represent a non valid access permission to
some file, but i don't remeber the file
Reply With Quote
  #5 (permalink)  
Old 08-11-04, 08:37
Falcon_down Falcon_down is offline
Registered User
 
Join Date: Aug 2004
Location: India
Posts: 13
Hi g.dipierto

I have read permission on /etc/services , I dont think you need to have write permission on /etc/services file Read permission only will do because my other instance are working fine with read permission on /etc/services file

Regards

Falcon
Reply With Quote
  #6 (permalink)  
Old 08-11-04, 10:03
ljrong ljrong is offline
Registered User
 
Join Date: Jan 2002
Location: USA
Posts: 53
Firewall, IP filter on your AIX?

Best
Reply With Quote
  #7 (permalink)  
Old 08-11-04, 10:35
rubystep rubystep is offline
Registered User
 
Join Date: Sep 2003
Posts: 85
What are you specifying for the port # in the CA (used to be CCA) and what version of the client and UDB server?
I'd think that you need to specify 50000
as per db2c_db2inst1 50000/tcp ?
Reply With Quote
  #8 (permalink)  
Old 08-11-04, 12:58
Falcon_down Falcon_down is offline
Registered User
 
Join Date: Aug 2004
Location: India
Posts: 13
Hi rubystep I have tried out with 50000/tcp as well but it didnt work

I am using V8 client and server

Regards

Falcon_down
Reply With Quote
  #9 (permalink)  
Old 08-11-04, 13:05
mavazqg mavazqg is offline
Registered User
 
Join Date: Aug 2003
Posts: 4
Cool Put the Port Number on the SVCENAME parameter

Please, change the SVCENAME parameter to the Port Number, in this case 60000, with the command:

update dbm cfg using SVCENAME 60000

then:

db2stop
db2start

Sometimes this is the solution.

mrln.
Reply With Quote
  #10 (permalink)  
Old 08-11-04, 13:09
Falcon_down Falcon_down is offline
Registered User
 
Join Date: Aug 2004
Location: India
Posts: 13
Hi mrln
Thanks for ur help

But I tried that also , It didnot work

Regards

Falcon
Reply With Quote
  #11 (permalink)  
Old 08-27-04, 14:13
jazminator jazminator is offline
Registered User
 
Join Date: Aug 2004
Posts: 1
Have you recently installed a fixpack?

I recently installed fixpack 5 and ran into the same problem. I realized I had not run the dasupdt utility after applying the fixpack as is noted in the readme.
I had run the db2iupdt, but not the dasupdt. Once I ran that, I was able to successfully start the server.
Don't know if this is your scenario but hopefully it will help.
Reply With Quote
  #12 (permalink)  
Old 08-27-04, 22:35
famudba famudba is offline
Registered User
 
Join Date: Jan 2004
Location: Tallahassee, FL, USA
Posts: 96
I asume , U R using DB2 V8 fp x
add entry as below in /etc/services , then start the instance , that will work

DB2_db2inst1 60000/tcp
DB2_db2inst1_END 60003/tcp

Let me know , if any questions.


Thank You
__________________
Lekharaju Ennam
Certified Oracle8i & DB UDB DBA
Florida A&M University
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On