SQL4401C : old problem, but found no working solution

[Martijn]

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

[Artur]

Martijn,

check if port 523 is opened for your firewall.

-- Artur Wronski

[Martijn]

On Feb 17, 10:25 pm, "Artur" <[e-mail]:

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

[Artur]

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

[Martijn]

On Feb 17, 11:41 pm, "Artur" <[e-mail]:

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

[Knut Stolze]

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

[Martijn]

On Feb 18, 7:38 pm, Knut Stolze <[e-mail]:

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

[Martijn]

On Feb 17, 6:53 pm, "Martijn" <[e-mail]:

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