Skip to Content
author's profile photo Former Member
Former Member

WAS 6.40 SP9 installation, MaxDB problem?

Hello,

I'm trying to install the preview version of WAS J2EE Server 6.40 SP9 from the SDN Downloads. I'm stuck at step nr. 5 (activating the database).

From other very helpful posts in this forum I've got an idea on where to look for error messages, but couldn't find anything on my system.

The failing command (from XCMDOUT.LOG) is

-


> Subprocess starts at 20050208080231

Execute Command : c:\sapdb\programs\pgm\dbmcli.exe -n Home-Off -d J2E -u CONTRO

L,********

Execute Session Command : util_connect

Execute Session Command : exit

> Subprocess stops at 20050208080233

ERR

-24988,ERR_SQL: sql error

1,database not running

-


I get no error message in knldiag.err.

After restarting my system I try to bring the database online, but without luck:

-


> dbmcli -d J2E -u control,control db_enum

OK

J2E c:\sapdb\j2e\db 7.5.0.18 fast offline

J2E c:\sapdb\j2e\db 7.5.0.18 quick offline

J2E c:\sapdb\j2e\db 7.5.0.18 slow offline

> dbmcli -d J2E -u control,control db_online

ERR

-24988,ERR_SQL: sql error

1,database not running

> dbmcli -d J2E -u control,control db_enum

OK

J2E c:\sapdb\j2e\db 7.5.0.18 fast running

J2E c:\sapdb\j2e\db 7.5.0.18 quick offline

J2E c:\sapdb\j2e\db 7.5.0.18 slow offline

> dbmcli -d J2E -u control,control db_online

ERR

-24961,ERR_STATE: cannot determine current db state

-


The last line in knldiag says

DBSTATE SERVERDB is ready

without any error message before.

Can somebody give me a hint on what's going wrong?

The system runs on Win XP Professional SP2, j2sdk 1.4.2_07.

Many thanks!

Christian.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Feb 08, 2005 at 10:07 AM

    Hi Christian,

    I've taken the liberty of moving your post to the MaxDB/liveCache forum, obviously because you've got a MaxDB error.

    Could you please issue the following command for me (and enter the output in your answer):

    dbmcli -d J2E -u control,control db_state

    You might try again to restart the database, by issueing:

    dbmcli -d J2E -u control,control db_offline (wait for the 'OK')

    dbmcli -d J2E -u control,control db_online

    Kind regards,

    Roland

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Christian,

      I didn't see your last entry (from Feb 8, 2005 5:52 PM) as I was writing my last answer at roughly the same time.

      Please let me know if everything works normally afterwards. Please try to adminster your MaxDB instance using the Database Manager GUi for example, that should tell you (and us) if the installation is working like it should.

      If it does work normally, then we very probably won't really find the cause for the problem(s) anymore.

      Regards,

      Roland

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.