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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| ||||
| 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 |