SQL4401C : old problem, but found no working solution

Martijn

Hi all,

I installed following pkg. on my laptop (Fedora Core 6) :
db2exc_91_LNX_x 86.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@localho st ~]$ db2admin start
SQL4401C The DB2 Administration Server encountered an error during
startup.
[dasusr1@localho st ~]$

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@localho st adm]$ ls -l db2dasrrm
-rwsr-sr-x 1 root dasadm1 476033 Feb 17 16:29 db2dasrrm
[dasusr1@localho st 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

Feb 17 '07 #1

Subscribe Reply

5300

Artur

Martijn,

check if port 523 is opened for your firewall.

-- Artur Wronski

Feb 17 '07 #2

Martijn

On Feb 17, 10:25 pm, "Artur" <artur.wron...@ gmail.comwrote:

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

Feb 17 '07 #3

Artur

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

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

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

just another idea...
-- Artur

Feb 17 '07 #4

Martijn

On Feb 17, 11:41 pm, "Artur" <artur.wron...@ gmail.comwrote:

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

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

you can add line:
SELINUX=disable d
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

Feb 18 '07 #5

Knut Stolze

Martijn wrote:

Hi all,

I installed following pkg. on my laptop (Fedora Core 6) :
db2exc_91_LNX_x 86.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@localho st ~]$ db2admin start
SQL4401C The DB2 Administration Server encountered an error during
startup.
[dasusr1@localho st ~]$

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@localho st adm]$ ls -l db2dasrrm
-rwsr-sr-x 1 root dasadm1 476033 Feb 17 16:29 db2dasrrm
[dasusr1@localho st 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

Feb 18 '07 #6

Martijn

On Feb 18, 7:38 pm, Knut Stolze <sto...@de.ibm. comwrote:

Martijn wrote:
Hi all,

I installed following pkg. on my laptop (Fedora Core 6) :
db2exc_91_LNX_x 86.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@localho st ~]$ db2admin start
SQL4401C The DB2 Administration Server encountered an error during
startup.
[dasusr1@localho st ~]$

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@localho st adm]$ ls -l db2dasrrm
-rwsr-sr-x 1 root dasadm1 476033 Feb 17 16:29 db2dasrrm
[dasusr1@localho st 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

Feb 19 '07 #7

Martijn

On Feb 17, 6:53 pm, "Martijn" <martijnm....@g mail.comwrote:

Hi all,

I installed following pkg. on my laptop (Fedora Core 6) :
db2exc_91_LNX_x 86.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@localho st ~]$ db2admin start
SQL4401C The DB2 Administration Server encountered an error during
startup.
[dasusr1@localho st ~]$

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@localho st adm]$ ls -l db2dasrrm
-rwsr-sr-x 1 root dasadm1 476033 Feb 17 16:29 db2dasrrm
[dasusr1@localho st 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

Feb 22 '07 #8

Similar topics

3773

Problem: writing to a file with C and reading with C++

by: Keith Dewell | last post by:

Greetings! My current job has brought me back to working in C++ which I haven't used since school days. The solution to my problem may be trivial but I have struggled with it for the last two days and would appreciate this group's helpful expertise. My problem may be related to mixing the C and C++ languages together. Namely, I have a struct which I cannot change (as legacy code) similiar to this (I will change the names throughout as...

C / C++

5203

Problem with virtual method

by: Jon Davis | last post by:

If I have a class with a virtual method, and a child class that overrides the virtual method, and then I create an instance of the child class AS A base class... BaseClass bc = new ChildClass(); .... and then call the virtual method, why is it that the base class's method is called instead of the overridden method? How do I fix this if I don't know at runtime what the child class is? I'm using Activator.CreateInstance() to load the...

C# / C Sharp

2183

Authentication problem for roles based

by: Chris Gatto | last post by:

Hi, I'm having what should be a minor problem but has turned into a 2 day slug fest with ASP.Net. I am simply attempting to authenticate my asp.net application users against users in an AD group set up on our domain. It seems to me I am missing something very simple and obvious, but none of the MSDN articles I have read are indicating what this might be. My setup is ASP.Net running on a Windows 2003/IIS 6 server. IIS security...

ASP.NET

5701

problem with webbrowser control/ webservice/ firewall client for isa server 2004

by: Miguel | last post by:

Hi, I'm developing an application in C# with Windows Forms for my company that is similar to the MSN Messenger. This application uses a webservice for registering users, etc... and as 2 webbrowser controls on it. Besides that i'm using the firewall client for isa server 2004 and it seems that the browsers aren't able to pass thru it... if i disable the firewall the browsers work fine, if i don't, the 2 browsers just stay there...

.NET Framework

5119

Problem WIth Fixed Header DataGrid CSS Expression

by: batista | last post by:

Hi there, I'm developing a website that is in 2 languages english and arabic. Now I wanted to have fixed header scrollable datagrid. For scrolling i found a solution which works fine. But for fixed header I found a solution that is using CSS expression,plus some style properties, as follows. position:relative;

ASP.NET

1471

Problem WIth Fixed Header WebDataGrid CSS Expression

by: batista | last post by:

.NET Framework

3937

function workingdays problem

by: Ian Mackenzie | last post by:

Hi Guys I am VERY new to DB2 and have created a workingdays function to return the working days between 2 dates, but I get some compiler errors when running it: CREATE FUNCTION WORKINGDAYS (STARTDATE, ENDDATE DATE) RETURNS INTEGER DETERMINISTIC NO EXTERNAL ACTION BEGIN ATOMIC DECLARE DAYCOUNT INTEGER

DB2 Database

19865

problem with IE and (ajax) file upload via iframe: javascript error access denied/zugriff verweigert

by: markus.rietzler | last post by:

i want to do (multiple) file upload(s) and display a progress bar. with firefox and safari it is no problem at all. only IE makes some problems. my script is based on ajax-uploader, which can be found at www.srmiles.com/freestuff/ajax_file_uploader/ . you can do multiple file uploads. each upload will have it's own "form"-tag, so that each file is uploaded for its own. could be a good solution if there are "big" uploads.

Javascript

9304

SQL4401C The DB2 Administration Server encountered an error during startup

by: matias.cornejo | last post by:

I have a problem to startup de DB2 Admin. I read meny documentation in internet and nothing work, anybody know something??. I have DB2 UDB V8 fixpack 14 and AIX 5.2 x134 db2admin start SQL4409W The DB2 Administration Server is already active. x134 db2admin start SQL4409W The DB2 Administration Server is already active. x134 db2admin start SQL4409W The DB2 Administration Server is already active.

DB2 Database

8428

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8851

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8539

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7360

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6181

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5650

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

2759

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1982

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1739

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General