How to access MaxDB after installing Netweaver?

[Former Member]

Hallo all,

I installed SAP Netweaver Developer Studion 9.

There was also MaxDB 7.5 (J2E) included.

I defined some entity beans for persistence and saved some data.

How can I access the MaxDB and make some Select queries?

Is there some Query Analyzing Tool like for the other Databases?

I tried to access MaxDB like this:

cmd -> dbmcli

db_enum

J2E     d:sapdbj2edb 7.5.0.28        slow    offline
J2E     d:sapdbj2edb 7.5.0.28        quick   offline
J2E     d:sapdbj2edb 7.5.0.28        fast    running

And then db_connect J2E, but I get an error message:

dbmcli>db_connect J2E

ERR

-24948,ERR_NODBNAME: database name required

I installed everything by default. What should be the name of the database and how could I connect to it?

I haven't defined some user, only Master Password. What is the name of the user?

j2eadmin?

Need help.

Thanks in advance.

[Former Member]

Hi,

Try with username "SAPJ2EDB " and password is administrator password only,

Regards,Anilkumar

[Former Member]

Thanks for the answer.

But how can I connect to the MaxDB.

If I type: db_connect J2E, I get an error, that there is no database.

[Former Member]

Hi,

Have you tried opening the SQLStudio via "<i>Start->Programs->MaxDB->SQL Studio</i>"?

Regards,

Satyajit.

[Former Member]

Well, after installing SAP Netweaver Developer Studion, I have MaxDB (SapDB) on my computer. There was also SAP Management Console installed.

Should I install this SQLStudio? Is it compatible with SapDB 7.5?

Thanks in advance.

[Former Member]

Yes. You need to install SqlStudio.

Regards,Anilkumar

[roland_mallmann]

Hi,

you don't necessarily need SQL Studio to connect to your MaxDB instance to perform SQL queries, but it is ofcourse more convenient to use than commandline tools.

To connect to the DB instance using dbmcli, you could try:

dbmcli -d <dbname> -u <DBM-user>,<password> [followed by Enter]

Then you're in a dbmcli session, from which you can connect using a SQL user, like your SYSDBA user or your SAP user (the owner of your application's tables):

dbmcli on <dbname>>sql_connect <SQL user>,<password>

Then you can perform queries starting with 'sql_execute':

dbmcli on <dbname>>sql_execute select from dual

To quit the SQL session: sql_release

To quit the dbmcli session: 'quit' or 'exit'

Regards,

Roland