db_activate Hangs up

[Former Member]

I am installing Maxdb 7.6.0.3 with Solution Manager SR4.

When comes to the phase 'Create Database Instance' the process hangs up, i have been waiting for more than 1 hour and nothing.Superdba password does not contain any @ symbol.

I can see the Datavolumnes and logvolumnes created on disk but the install doesnt go any further and even I cannot see the log file from sapinst, I need to check them a OS, it seems that sapinst hangs up.

I have tried to install the Database by myself but it hangs in the same point db activation.

krnelerr doesnt show any message

Here is the output of file XCMDOUT.log

> Subprocess starts at 20080825175148

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 db_enum

Execute Session Command : exit

> Subprocess stops at 20080825175148

OK

-

---

> Subprocess starts at 20080825175148

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 inst_enum

Execute Session Command : exit

> Subprocess stops at 20080825175148

OK

7.6.03.09 E:\sapdb\T08\db

-

---

> Subprocess starts at 20080825175148

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -R E:\sapdb\T08\db db_create T08 CONTROL,********

Execute Session Command : exit

> Subprocess stops at 20080825175150

OK

-

---

> Subprocess starts at 20080825175151

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 db_enum

Execute Session Command : exit

> Subprocess stops at 20080825175151

OK

T08 E:\sapdb\T08\db 7.6.03.09 fast offline

T08 E:\sapdb\T08\db 7.6.03.09 quick offline

T08 E:\sapdb\T08\db 7.6.03.09 slow offline

T08 E:\sapdb\T08\db 7.6.03.09 test offline

-

---

> Subprocess starts at 20080825175151

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,********

Execute Session Command : param_startsession

Execute Session Command : param_init OLTP

Execute Session Command : param_checkall

Execute Session Command : param_commitsession

Execute Session Command : exit

> Subprocess stops at 20080825175154

OK

OK

OK

OK

-

---

> Subprocess starts at 20080825175155

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput CACHE_SIZE 262016

Execute Session Command : exit

> Subprocess stops at 20080825175155

OK

-

---

> Subprocess starts at 20080825175155

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput LOG_MIRRORED NO

Execute Session Command : exit

> Subprocess stops at 20080825175156

OK

-

---

> Subprocess starts at 20080825175156

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput MAXUSERTASKS 50

Execute Session Command : exit

> Subprocess stops at 20080825175157

OK

-

---

> Subprocess starts at 20080825175157

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput MAXCPU 8

Execute Session Command : exit

> Subprocess stops at 20080825175157

OK

-

---

> Subprocess starts at 20080825175157

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput LOG_IO_QUEUE 200

Execute Session Command : exit

> Subprocess stops at 20080825175157

OK

-

---

> Subprocess starts at 20080825175157

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput MAXLOCKS 300000

Execute Session Command : exit

> Subprocess stops at 20080825175158

OK

-

---

> Subprocess starts at 20080825175158

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput CAT_CACHE_SUPPLY 10000

Execute Session Command : exit

> Subprocess stops at 20080825175158

OK

-

---

> Subprocess starts at 20080825175158

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput JOIN_MAXTAB_LEVEL4 64

Execute Session Command : exit

> Subprocess stops at 20080825175158

OK

-

---

> Subprocess starts at 20080825175158

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput _UNICODE YES

Execute Session Command : exit

> Subprocess stops at 20080825175159

OK

-

---

> Subprocess starts at 20080825175159

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput DEFAULT_CODE ASCII

Execute Session Command : exit

> Subprocess stops at 20080825175159

OK

-

---

> Subprocess starts at 20080825175159

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput PACKETSIZE 131072

Execute Session Command : exit

> Subprocess stops at 20080825175159

OK

-

---

> Subprocess starts at 20080825175159

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput MCOD NO

Execute Session Command : exit

> Subprocess stops at 20080825175200

OK

-

---

> Subprocess starts at 20080825175200

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,********

Execute Session Command : param_startsession

Execute Session Command : param_checkall

Execute Session Command : param_commitsession

Execute Session Command : exit

> Subprocess stops at 20080825175201

OK

OK

OK

-

---

> Subprocess starts at 20080825175202

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 1 DATA E:\sapdb\T08\sapdata\DISKD0001 F 1280000

Execute Session Command : exit

> Subprocess stops at 20080825175202

OK

-

---

> Subprocess starts at 20080825175202

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 2 DATA E:\sapdb\T08\sapdata\DISKD0002 F 1280000

Execute Session Command : exit

> Subprocess stops at 20080825175203

OK

-

---

> Subprocess starts at 20080825175203

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 3 DATA E:\sapdb\T08\sapdata\DISKD0003 F 1280000

Execute Session Command : exit

> Subprocess stops at 20080825175203

OK

-

---

> Subprocess starts at 20080825175203

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 4 DATA E:\sapdb\T08\sapdata\DISKD0004 F 1280000

Execute Session Command : exit

> Subprocess stops at 20080825175204

OK

-

---

> Subprocess starts at 20080825175204

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 1 LOG F:\sapdb\T08\saplog\DISKL001 F 819200

Execute Session Command : exit

> Subprocess stops at 20080825175204

OK

-

---

> Subprocess starts at 20080825175205

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,********

Execute Session Command : param_startsession

Execute Session Command : param_checkall

Execute Session Command : param_commitsession

Execute Session Command : exit

> Subprocess stops at 20080825175205

OK

OK

OK

-

---

> Subprocess starts at 20080825175206

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** db_start

Execute Session Command : exit

> Subprocess stops at 20080825175211

OK

-

---

> Subprocess starts at 20080825175211

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** db_state

Execute Session Command : exit

> Subprocess stops at 20080825175211

OK

State

ADMIN

-

---

> Subprocess starts at 20080825175212

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** db_state

Execute Session Command : exit

> Subprocess stops at 20080825175212

OK

State

ADMIN

-

---

> Subprocess starts at 20080825175212

Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,********

Execute Session Command : util_connect

Execute Session Command : db_activate SUPERDBA,********

-

---

When I try to do it bymyself the command it says -24988,ERR_SQL: SQL ERROR

-104 DBM command impossible at this time.

Please advise.

[Former Member · Accepted solution]

Hi,

what does the machine do? Is there any I/O on the storage devcies? What OS do you use? Remember: creating data and log devices on file system basis can take a long time especially on older machines or slow storage (e.g. SCSI).

Please post the content of knldiag file; it contains error messages from the database which might be useful to determine the failure you ran into.

Regards

André

[Former Member]

Thank you, after waiting like 3 hours it went through, strange was that in the server console I only saw a 1% o 0% Cpu utilization during those 3 hours, but the DB kernel was working.

Thank you all

[markus_doehr2]

Yes, formatting the volumes doesn't consume much CPU but harddisk I/O.

Markus

[former_member229109]

Hello Daniel,

According your information, at that time you run 'db_activate SUPERDBA,********'.

At that step the data & log volumes will be created by database kernel.

-> Please update with output of the following commands :

A) E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_getvolsall

B) x_cons T08 show io

x_cons T08 show active

< after 1min run those commands again to compare the results >

-> Please post the knldiag file.

Thank you and best regards, Natalia Khlopina