MAXDB Windows Services

[former_member238852]

Dear Friends,

We hae installed SAP MaxDB 7.7.028 on Windows 2003 x86 server. Under Services.msc, I see the following services...

MAXDB: .M770428

MAXDB: .M770428 (SLOW)

MAXDB: .M770609

MAXDB: .UMDB

MAXDB: .SDB Started

MAXDB: .SDB (SLOW)

What exactly are these services and what is the differenece between a SLOW service and a regular service?

Thank you,

Nikee

[former_member229109]

Hello,

You could find the answers on your questions in the MAXDB library.

u201CService Databaseu201D =>

http://maxdb.sap.com/doc/7_7/44/c00a755bb24612e10000000a11466f/content.htm

u201CKernel Variantu201D =>

http://maxdb.sap.com/doc/7_7/44/be19472f763f46e10000000a114a6b/content.htm

Regards, Natalia Khlopina

[former_member238852]

Dear Natalia,

Thanks for perfect answers.

One last question..i.e. At the moment, all the services are set to "MANUAL" start except the SDB Service set to "AUTOMATIC".

Do you recommend setting to "AUTOMATIC" for all the services except the "SLOW" services?

Thank you,

Nikee

[former_member229109]

Hello Nikee,

1. Please review the document u201CActivating Automatic Database Startu201D at

http://maxdb.sap.com/doc/7_7/44/c076e08c78157be10000000a114a6b/content.htm

As you saw you can configure your system so that the database and X Server will be started automatically when the database server is started and are stopped automatically when it is shut down.

2. You have the SDB database instance and DB studio installed on this server. Correct?

Please update the thread with output of the commands running on the database server:

dbmcli inst_enum

dbmcli db_enum -s

Thank you and best regards, Natalia Khlopina

[former_member238852]

Hello Natalia,

Thansk for the response..

Here are the details you ar elooking for:

C:\Documents and Settings\root>dbmcli inst_enum

OK

7.7.04.28 D:\sapdb\SDB\db

C:\Documents and Settings\root>dbmcli db_enum -s

OK

SDB D:\sapdb\SDB\db 7.7.04.28 fast running

SDB D:\sapdb\SDB\db 7.7.04.28 slow offline

.M770428 D:\sapdb\SDB\db 7.7.04.28 fast offline

.M770428 D:\sapdb\SDB\db 7.7.04.28 slow offline

.UMDB C:\sapdb\programs\DatabaseStudio\utilities 7.7.06.09 fast running

.M770609 C:\sapdb\programs\DatabaseStudio\utilities 7.7.06.09 fast offline

Also, we have installed the DBSTUDIO 7.7.06.09

Thank you,

Nikee

[former_member229109]

Hello Nikee,

As I could see you have the SDB database instance and Database Studio installed on the server.

Itu2019s fine to have the SDB Service set to "AUTOMATIC" only.

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Nathalia

I got some issue (not sure if is it really an issue)

I migrated MaxDB version 7.5 win 2003 -> to 7.9 win 2008 by backup/restore method.

I am doing some checks after but I cannot see service visible as running in "services"

My SDB instance is running as "speci"

sending my outputs and screenshots:

Is there any option to change it to "fast: and visible the service? (parameted change? )

On source system is running as "fast" and service is visible.

Many thanks in advance for advice

C:\>dbmcli inst_enum

OK

7.9.08.23    I:\sapdb\SDB\db

7.9.08.35    I:\sapdb\clients\DatabaseStudio

C:\>

C:\>dbmcli db_enum -s

OK

SDB     I:\sapdb\SDB\db                         7.9.08.23       slow    offline

SDB     I:\sapdb\SDB\db                         7.9.08.23       speci   running

.M790823        I:\sapdb\SDB\db                         7.9.08.23       fast

offline

.M790823        I:\sapdb\SDB\db                         7.9.08.23       slow

offline

C:\>

BR

Daniel

Message was edited by: Daniel Krupinsky

[Former Member]

Hi Daniel,

i guess you has started a special executable of the kernel with the -x option of the db_online command.

>dbmcli -d SDB -u CONTROL,CONTROL db_online -x checkknl

The -x option for special kernel is only for test and diagnose purpose

shutdown your db with db_offline and restart it again with db_online -f

BR

Burkhard

[Former Member]

Hi Burkhard

I also patched DB to version 7.9.08.36

I am not able see the service and looks still is running with speci mode.

C:\>dbmcli -d SDB -u dbm,CONTROL db_online -x checkknl

OK

C:\>dbmcli -d SDB -u dbm,control db_online -f

OK

C:\>dbmcli db_enum -s

OK

.M790836        I:\sapdb\SDB\db                         7.9.08.36       fast

offline

.M790836        I:\sapdb\SDB\db                         7.9.08.36       slow

offline

SDB     I:\sapdb\SDB\db                         7.9.08.36       slow    offline

SDB     I:\sapdb\SDB\db                         7.9.08.36       speci   running

C:\>

BR

Daniel

[Former Member]

Hi Daniel,

The db_online command is a NOOP if the kernel is running.

Please stop first the kernel with.

>dbmcli –d SDB –u CONTROL,CONTROL db_offline

and than restart it with

>dbmcli –d SDB –u CONTROL,CONTROL db_online –f

now the fast service should be running

Burkhard

[Former Member]

Hi Burkhard

I did before stop (including kill kernel processes on OS side), but it status is still the same, below can see outputs.

Service also not visible after refresh.

Any other suggestions?

BR

Daniel

[Former Member]

Hi Daniel,

I wonder why the fast kernel is not registered.

Try to register the service for your fast kernel with

xservice -d SDB

restart the db afterwards db_online

BR

Burkhard

[Former Member]

Hi Burkhard

registration service helped.

It is working now.

Thank you very much and have a nice day.

BR

Daniel