Unix Technical Forum

SQL4401C : old problem, but found no working solution

This is a discussion on SQL4401C : old problem, but found no working solution within the DB2 forums, part of the Database Server Software category; --> Hi all, I installed following pkg. on my laptop (Fedora Core 6) : db2exc_91_LNX_x86.tar.gz After resolving some dependency-problems the ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 11:45 AM
Martijn
 
Posts: n/a
Default SQL4401C : old problem, but found no working solution

Hi all,

I installed following pkg. on my laptop (Fedora Core 6) :
db2exc_91_LNX_x86.tar.gz
After resolving some dependency-problems the install was fine.

(I understand that a laptop isn't very well suited for DB2 but .... I
just want to play around :-) )

After the install I started the control center. This also went
smoothly.
In the CC I tried to create a database.
The CC then talled me that no database administration server has been
started.
As user dasusr1 I issue "db2admin start" to start the administration
server:
[dasusr1@localhost ~]$ db2admin start
SQL4401C The DB2 Administration Server encountered an error during
startup.
[dasusr1@localhost ~]$

mmmm thats a pitty ....

after some googling I found that this was a common error which should
be resolved pretty easily.
Following link looked like a good solution :
http://www-1.ibm.com/support/docview...id=swg21198111

I followed the instructions to make db2dasrrm suid root (I used to
db2dasupdt and also tried with manaul altering the file permissions)
The dasrrm now looks like :
[dasusr1@localhost adm]$ ls -l db2dasrrm
-rwsr-sr-x 1 root dasadm1 476033 Feb 17 16:29 db2dasrrm
[dasusr1@localhost adm]$

Issuing (as dasusr1) "db2admin start" gave the same error as before.

Other option then : dropping the dasusr1 (dasdrop) and re-creating it
(dascrt) wend fine. However... starting the administration server gave
the same old error.

And now.... I'm lost.

Anyone some ideas of how to solve this problem?

Thanks in advance,


Martijn Bos

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 11:45 AM
Artur
 
Posts: n/a
Default Re: SQL4401C : old problem, but found no working solution

Martijn,

check if port 523 is opened for your firewall.

-- Artur Wronski

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 11:45 AM
Martijn
 
Posts: n/a
Default Re: SQL4401C : old problem, but found no working solution

On Feb 17, 10:25 pm, "Artur" <artur.wron...@gmail.com> wrote:
> Martijn,
>
> check if port 523 is opened for your firewall.
>
> -- Artur Wronski



Hi Artur,

tnx for your reply.
SELinux is disabled at this moment
firewall (iptables) has no rules and has all policy's set to accept at
this moment

So I'm afraid that is not my problem.

If you have any other ideas don't hesitate to post it.

thanks

Martijn Bos

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-27-2008, 11:45 AM
Artur
 
Posts: n/a
Default Re: SQL4401C : old problem, but found no working solution

another idea is to disable security-enhanced Linux (SELinux).

run as root:
# /usr/sbin/setenforce 0

you can add line:
SELINUX=disabled
to the file: /etc/selinux/config

just another idea...
-- Artur


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-27-2008, 11:45 AM
Martijn
 
Posts: n/a
Default Re: SQL4401C : old problem, but found no working solution

On Feb 17, 11:41 pm, "Artur" <artur.wron...@gmail.com> wrote:
> another idea is to disable security-enhanced Linux (SELinux).
>
> run as root:
> # /usr/sbin/setenforce 0
>
> you can add line:
> SELINUX=disabled
> to the file: /etc/selinux/config
>
> just another idea...
> -- Artur


Hi Artur,

Thank you for the advice. However... SELinux is allready disabled :-(
(That is the first thing I disable in any Fedora system I install. I
had to many problems in the past wich were misteriously solved after
disasbling SELinux)

Best regards,

Martijn Bos



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 02-27-2008, 11:45 AM
Knut Stolze
 
Posts: n/a
Default Re: SQL4401C : old problem, but found no working solution

Martijn wrote:

> Hi all,
>
> I installed following pkg. on my laptop (Fedora Core 6) :
> db2exc_91_LNX_x86.tar.gz
> After resolving some dependency-problems the install was fine.
>
> (I understand that a laptop isn't very well suited for DB2 but .... I
> just want to play around :-) )
>
> After the install I started the control center. This also went
> smoothly.
> In the CC I tried to create a database.
> The CC then talled me that no database administration server has been
> started.
> As user dasusr1 I issue "db2admin start" to start the administration
> server:
> [dasusr1@localhost ~]$ db2admin start
> SQL4401C The DB2 Administration Server encountered an error during
> startup.
> [dasusr1@localhost ~]$
>
> mmmm thats a pitty ....
>
> after some googling I found that this was a common error which should
> be resolved pretty easily.
> Following link looked like a good solution :
> http://www-1.ibm.com/support/docview...id=swg21198111
>
> I followed the instructions to make db2dasrrm suid root (I used to
> db2dasupdt and also tried with manaul altering the file permissions)
> The dasrrm now looks like :
> [dasusr1@localhost adm]$ ls -l db2dasrrm
> -rwsr-sr-x 1 root dasadm1 476033 Feb 17 16:29 db2dasrrm
> [dasusr1@localhost adm]$
>
> Issuing (as dasusr1) "db2admin start" gave the same error as before.
>
> Other option then : dropping the dasusr1 (dasdrop) and re-creating it
> (dascrt) wend fine. However... starting the administration server gave
> the same old error.
>
> And now.... I'm lost.
>
> Anyone some ideas of how to solve this problem?


Have a look at the db2dasdiag.log (under das/dump/). Maybe you will see
some more specific information there.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 02-27-2008, 11:46 AM
Martijn
 
Posts: n/a
Default Re: SQL4401C : old problem, but found no working solution

On Feb 18, 7:38 pm, Knut Stolze <sto...@de.ibm.com> wrote:
> Martijn wrote:
> > Hi all,

>
> > I installed following pkg. on my laptop (Fedora Core 6) :
> > db2exc_91_LNX_x86.tar.gz
> > After resolving some dependency-problems the install was fine.

>
> > (I understand that a laptop isn't very well suited for DB2 but .... I
> > just want to play around :-) )

>
> > After the install I started the control center. This also went
> > smoothly.
> > In the CC I tried to create a database.
> > The CC then talled me that no database administration server has been
> > started.
> > As user dasusr1 I issue "db2admin start" to start the administration
> > server:
> > [dasusr1@localhost ~]$ db2admin start
> > SQL4401C The DB2 Administration Server encountered an error during
> > startup.
> > [dasusr1@localhost ~]$

>
> > mmmm thats a pitty ....

>
> > after some googling I found that this was a common error which should
> > be resolved pretty easily.
> > Following link looked like a good solution :
> >http://www-1.ibm.com/support/docview...id=swg21198111

>
> > I followed the instructions to make db2dasrrm suid root (I used to
> > db2dasupdt and also tried with manaul altering the file permissions)
> > The dasrrm now looks like :
> > [dasusr1@localhost adm]$ ls -l db2dasrrm
> > -rwsr-sr-x 1 root dasadm1 476033 Feb 17 16:29 db2dasrrm
> > [dasusr1@localhost adm]$

>
> > Issuing (as dasusr1) "db2admin start" gave the same error as before.

>
> > Other option then : dropping the dasusr1 (dasdrop) and re-creating it
> > (dascrt) wend fine. However... starting the administration server gave
> > the same old error.

>
> > And now.... I'm lost.

>
> > Anyone some ideas of how to solve this problem?

>
> Have a look at the db2dasdiag.log (under das/dump/). Maybe you will see
> some more specific information there.
>
> --
> Knut Stolze
> DB2 z/OS Utilities Development
> IBM Germany


Hi Knut,

Thanks for your reply.
I'm not having the laptop with me at the moment so I'm telling this
out of my memory :-)

I actually looked allready at that log-file. The messages are the same
as those in the above mentioned article (http://www-1.ibm.com/support/
docview.wss?uid=swg21198111)

So therefore I think that the problem is what the article describes,
but I'm overseeing something wich makes the proposed solution not
working.

But when I have the laptop at hand I will look through the errors
again.

Best Regards,

Martijn Bos

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 02-27-2008, 11:48 AM
Martijn
 
Posts: n/a
Default Re: SQL4401C : old problem, but found no working solution

On Feb 17, 6:53 pm, "Martijn" <martijnm....@gmail.com> wrote:
> Hi all,
>
> I installed following pkg. on my laptop (Fedora Core 6) :
> db2exc_91_LNX_x86.tar.gz
> After resolving some dependency-problems the install was fine.
>
> (I understand that a laptop isn't very well suited for DB2 but .... I
> just want to play around :-) )
>
> After the install I started the control center. This also went
> smoothly.
> In the CC I tried to create a database.
> The CC then talled me that no database administration server has been
> started.
> As user dasusr1 I issue "db2admin start" to start the administration
> server:
> [dasusr1@localhost ~]$ db2admin start
> SQL4401C The DB2 Administration Server encountered an error during
> startup.
> [dasusr1@localhost ~]$
>
> mmmm thats a pitty ....
>
> after some googling I found that this was a common error which should
> be resolved pretty easily.
> Following link looked like a good solution :http://www-1.ibm.com/support/docview...id=swg21198111
>
> I followed the instructions to make db2dasrrm suid root (I used to
> db2dasupdt and also tried with manaul altering the file permissions)
> The dasrrm now looks like :
> [dasusr1@localhost adm]$ ls -l db2dasrrm
> -rwsr-sr-x 1 root dasadm1 476033 Feb 17 16:29 db2dasrrm
> [dasusr1@localhost adm]$
>
> Issuing (as dasusr1) "db2admin start" gave the same error as before.
>
> Other option then : dropping the dasusr1 (dasdrop) and re-creating it
> (dascrt) wend fine. However... starting the administration server gave
> the same old error.
> And now.... I'm lost.
>
> Anyone some ideas of how to solve this problem?
>
> Thanks in advance,
>
> Martijn Bos


Followup:

Today I started up the laptop looked at the processes it was running
and saw a few more db2 processes then I was used to earlier this week.

switching to user dasusr1 issuing "db2admin start" I get....
"SQL4409W The DB2 Administration Server is already active."

So with user db2inst1 in db2cc I was able to create a database.

Now you will probably want to know what did I to solve the problem: I
have no idea. The laptop has been booted a couple of times. I
proceeded as described in the above posts.
I'm pretty sure that I booted the laptop a few times before I wrote my
initial post. So I'm a bit lost what or when I did the rigth thing to
solve the problem.

Anyway... I'm happy

tnx for the ideas and support

Martijn

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:54 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com