Can't Add Volume (because) MaxDB cannot be set online

[Former Member]

Dear experts,

my MaxDB 7.6 DBM Gui reports "Data Area Full. To extend the data area add a data volume. (Instance->Configuration->Volumes)".

When I try this via pull down menu Actions, "New Volume" is grey and cannot be used.

The database cannot be set online via DBM Gui. Here I get the error -24798 Data area is full [db_online -f]

The Windows Service SAPDB: <SID> cannot be started an remains in status "Starting".

Database Parameter MAXDATAVOLUMES is set to 11, and we have 2 vlumes so far.

I would be very pleased if there was anybody to give me some help with this.

Regards

Heinz

[markus_doehr2 · Accepted solution]

You can set the database to admin mode and add a volume. Then set it to online mode.

Markus

[Former Member · Accepted solution]

Hello Markus,

the database is already set to admin mode, but the problem remains the same ...

Regards,

Heinz

[nelis · Accepted solution]

Take a look at your knldiag or knldiag.err usually located under \sapdb\data\wrk\<DBSID>. Can you see any errors ? Please post them here.

--

Nelis

[Former Member · Accepted solution]

Hello,

in knldiag.err I can find:

2009-10-28 11:32:49 ___ Stopping GMT 2009-10-28 10:32:49 7.6.01 Build 008-123-140-618

2009-10-28 11:32:52 --- Starting GMT 2009-10-28 10:32:52 7.6.01 Build 008-123-140-618

2009-10-28 11:32:56 0x574 ERR 20125 RTE Database automatic restart failed

2009-10-28 11:36:57 0x790 ERR 18431 MESSAGES Could not write to event log, rc = 5

2009-10-28 11:36:58 ___ Stopping GMT 2009-10-28 10:36:58 7.6.01 Build 008-123-140-618

2009-10-28 11:38:35 --- Starting GMT 2009-10-28 10:38:35 7.6.01 Build 008-123-140-618

2009-10-28 11:38:40 0x9EC ERR 20125 RTE Database automatic restart failed

2009-10-28 12:15:13 0x658 ERR 18431 MESSAGES Could not write to event log, rc = 31

2009-10-28 12:15:14 ___ Stopping GMT 2009-10-28 11:15:14 7.6.01 Build 008-123-140-618

2009-10-28 12:16:46 --- Starting GMT 2009-10-28 11:16:46 7.6.01 Build 008-123-140-618

2009-10-28 12:16:51 0x9B8 ERR 20125 RTE Database automatic restart failed

2009-10-28 13:09:26 0x654 ERR 18431 MESSAGES Could not write to event log, rc = 5

2009-10-28 13:09:27 ___ Stopping GMT 2009-10-28 12:09:27 7.6.01 Build 008-123-140-618

2009-10-28 13:13:36 --- Starting GMT 2009-10-28 12:13:36 7.6.01 Build 008-123-140-618

2009-10-28 13:13:41 0x2CC ERR 20125 RTE Database automatic restart failed

2009-10-28 13:33:38 0xFF8 ERR 18431 MESSAGES Could not write to event log, rc = 31

2009-10-28 13:33:39 ___ Stopping GMT 2009-10-28 12:33:39 7.6.01 Build 008-123-140-618

2009-10-28 13:45:26 --- Starting GMT 2009-10-28 12:45:26 7.6.01 Build 008-123-140-618

2009-10-28 13:54:06 ___ Stopping GMT 2009-10-28 12:54:06 7.6.01 Build 008-123-140-618

2009-10-28 13:55:42 --- Starting GMT 2009-10-28 12:55:42 7.6.01 Build 008-123-140-618

2009-10-28 15:10:54 ___ Stopping GMT 2009-10-28 14:10:54 7.6.01 Build 008-123-140-618

2009-10-28 15:11:00 --- Starting GMT 2009-10-28 14:11:00 7.6.01 Build 008-123-140-618

2009-10-28 15:11:11 0x5E8 ERR 20125 RTE Database automatic restart failed

2009-10-28 19:04:01 ___ Stopping GMT 2009-10-28 18:04:01 7.6.01 Build 008-123-140-618

2009-10-28 21:38:13 --- Starting GMT 2009-10-28 20:38:13 7.6.01 Build 008-123-140-618

2009-10-28 21:38:18 0x28C ERR 20125 RTE Database automatic restart failed

2009-10-28 21:50:16 ___ Stopping GMT 2009-10-28 20:50:16 7.6.01 Build 008-123-140-618

2009-10-28 22:01:25 --- Starting GMT 2009-10-28 21:01:25 7.6.01 Build 008-123-140-618

2009-10-28 22:01:29 0xF54 ERR 20125 RTE Database automatic restart failed

2009-10-28 22:13:29 ___ Stopping GMT 2009-10-28 21:13:29 7.6.01 Build 008-123-140-618

2009-10-28 23:14:43 --- Starting GMT 2009-10-28 22:14:43 7.6.01 Build 008-123-140-618

2009-10-28 23:14:47 0x598 ERR 20125 RTE Database automatic restart failed

2009-10-29 08:47:51 0xBE4 ERR 18431 MESSAGES Could not write to event log, rc = 31

2009-10-29 08:47:52 ___ Stopping GMT 2009-10-29 07:47:52 7.6.01 Build 008-123-140-618

2009-10-29 08:54:53 --- Starting GMT 2009-10-29 07:54:53 7.6.01 Build 008-123-140-618

And knldiag looks like this:

-

---

Date Time TID(hex) Typ MsgID Label Message-Text

-

---

2009-10-29 08:54:53 0x28C 20233 RTE Dump of all kernel parameters start

2009-10-29 08:54:53 0x28C 20206 RTE Using mode NORMAL for data volume 1

2009-10-29 08:54:53 0x28C 20206 RTE Using mode NORMAL for data volume 2

2009-10-29 08:54:53 0x28C 20234 RTE ADMIN=1

2009-10-29 08:54:53 0x28C 20234 RTE AKDUMP_ALLOWED=YES

...

...

2009-10-29 08:54:53 0x28C 20234 RTE XP_DATA_CACHE_RGNS=0

2009-10-29 08:54:53 0x28C 20234 RTE XP_MAXPAGER=0

2009-10-29 08:54:53 0x28C 20235 RTE Dump of all kernel parameters done

2009-10-29 08:54:53 0x28C 19600 VERSION 'Kernel 7.6.01 Build 008-123-140-618'

2009-10-29 08:54:53 0x28C 19600 VERSION 'W32/INTEL 7.6.01 Build 008-123-140-618'

2009-10-29 08:54:53 0x28C 19769 INFO Starting SERVERDB: 'CSP'

2009-10-29 08:54:53 0x28C 19770 INFO SERVERNODE: 'frothingill.zik.klinik.uni-ulm.de'

2009-10-29 08:54:53 0x28C 19771 INFO Process ID: 592

2009-10-29 08:54:53 0x28C 19773 INFO Date: 2009-10-29

2009-10-29 08:54:53 0x28C 19772 INFO Owner: 'SYSTEM'

2009-10-29 08:54:53 0x28C 19774 INFO Product suite: 'Enterprise'

2009-10-29 08:54:53 0x28C 19806 INFO Machine: 'Intel IA32 level 6 revision f0b'

2009-10-29 08:54:53 0x28C 19783 INFO Processors: 1 ( logical: 4 )

2009-10-29 08:54:53 0x28C 19782 INFO Fiber: 'YES'

2009-10-29 08:54:53 0x28C 19776 INFO Max virtual memory: 2047 MB

2009-10-29 08:54:53 0x28C 19777 INFO Total physical memory: 4090 MB

2009-10-29 08:54:53 0x28C 19778 INFO Available physical memory: 3678 MB

2009-10-29 08:54:53 0x28C 20219 RTE Memory allocation not limited

2009-10-29 08:54:53 0x28C 20220 RTE System page cache usage enabled

2009-10-29 08:54:53 0x28C 19692 TCLUSTER tw;al;ut;2000sv,100bup;10ev,10gc;ti,100dw;25us;equalize

2009-10-29 08:54:53 0x28C 19693 TCLUSTER number of 'BUP': 0

2009-10-29 08:54:53 0x28C 19693 TCLUSTER number of ' DW': 16

2009-10-29 08:54:53 0x28C 19693 TCLUSTER number of ' US': 50

2009-10-29 08:54:53 0x28C 19693 TCLUSTER number of ' SV': 28

2009-10-29 08:54:53 0x28C 19693 TCLUSTER number of ' EV': 2

2009-10-29 08:54:53 0x28C 19693 TCLUSTER number of ' GC': 1

2009-10-29 08:54:53 0x28C 19692 TCLUSTER Total Number of UKT 8

2009-10-29 08:54:53 0x28C 19692 TCLUSTER Number of UKT with User Tasks 2

2009-10-29 08:54:53 0x28C 19860 MEMORY I/O buffer cache: 43648 Pages allocated

2009-10-29 08:54:53 0x28C 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages

2009-10-29 08:54:53 0x28C 19812 EVENTING Eventbuffer 100 events 2 tasks

2009-10-29 08:54:53 0x2E4 19821 TASKING Thread 740 starting

2009-10-29 08:54:53 0x28C 19831 TRACE_IO Configured MAXMESSAGE_FILES:0

2009-10-29 08:54:53 0x28C 19832 TRACE_IO Disabled: No TraceMessagefiles wanted

2009-10-29 08:54:53 0x2F4 19688 THREAD CLOCK thread started

2009-10-29 08:54:53 0x334 19688 THREAD TIMER thread started

2009-10-29 08:54:53 0x3EC 19688 THREAD ASYNC0 thread started

2009-10-29 08:54:53 0x410 19688 THREAD REQUESTOR thread started

2009-10-29 08:54:53 0x414 19821 TASKING Thread 1044 starting

2009-10-29 08:54:53 0x29C 19821 TASKING Thread 668 starting

2009-10-29 08:54:53 0x40C 20213 RTE CONSOLE thread started

2009-10-29 08:54:53 0x444 19821 TASKING Thread 1092 starting

2009-10-29 08:54:53 0x468 19821 TASKING Thread 1128 starting

2009-10-29 08:54:53 0x494 19821 TASKING Thread 1172 starting

2009-10-29 08:54:53 0x4B8 19821 TASKING Thread 1208 starting

2009-10-29 08:54:53 0x4AC 19821 TASKING Thread 1196 starting

2009-10-29 08:54:53 0x524 19821 TASKING Thread 1316 starting

2009-10-29 08:54:53 0x598 19821 TASKING Thread 1432 starting

2009-10-29 08:54:53 0x5A0 19821 TASKING Thread 1440 starting

2009-10-29 08:54:53 0x4F4 19821 TASKING Thread 1268 starting

2009-10-29 08:54:53 0x624 19627 TASKING UKT started, TID:0x624

2009-10-29 08:54:53 0x5EC 19627 TASKING UKT started, TID:0x5EC

2009-10-29 08:54:53 0x600 19627 TASKING UKT started, TID:0x600

2009-10-29 08:54:53 0x5E0 19627 TASKING UKT started, TID:0x5E0

2009-10-29 08:54:53 0x5AC 19627 TASKING UKT started, TID:0x5AC

2009-10-29 08:54:53 0x604 19627 TASKING UKT started, TID:0x604

2009-10-29 08:54:53 0x5D0 19627 TASKING UKT started, TID:0x5D0

2009-10-29 08:54:54 0x5D4 19627 TASKING UKT started, TID:0x5D4

2009-10-29 08:54:54 0x5D4 19615 VOLUMEIO Attaching volume 'knltrace'

2009-10-29 08:54:54 0x62C 19613 DBSTATE I/O thread for 'knltrace' started

2009-10-29 08:54:54 0x5D4 20040 Admin Kernel state: 'ADMIN' reached

2009-10-29 08:54:54 0x5D4 9 SrvTasks Available Servertasks: 28

2009-10-29 08:54:54 0x5D4 54003 dynpool HIST_DIR item size : 8

2009-10-29 08:54:54 0x5D4 54003 dynpool HIST_DIR num items : 50

2009-10-29 08:54:54 0x5D4 54003 dynpool DYNP_B930_HIST_DIR : 400

2009-10-29 08:54:54 0x5D4 54003 dynDATA DYND_K57_KB_PAGES : 11

2009-10-29 08:54:54 0x5D4 54003 dynDATA BACKUP RESTART REC (8K): 1

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP TASK LIST : 208

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP TAPE LIST : 672

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP DEVSP LIST : 96

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP VOL IDX LIST : 32

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP SRR QUEUE : 656

2009-10-29 08:54:54 0x5D4 54003 dynpool DYNP_K38_SAVE_GLOB : 1568

2009-10-29 08:54:54 0x5D4 54003 dynDATA DYND_K38_SAVE : 1729

2009-10-29 08:54:54 0x5D4 54003 dynDATA BACKUP RESTART REC (8K): 1

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP TASK LIST : 32

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP TAPE LIST : 672

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP DEVSP LIST : 16

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP VOL IDX LIST : 32

2009-10-29 08:54:54 0x5D4 54003 dynpool BACKUP SRR QUEUE : 128

2009-10-29 08:54:54 0x5D4 54003 dynpool DYNP_K38_AUTOSAVE : 864

2009-10-29 08:54:54 0x5D4 54003 dynDATA DYND_K38_AUTOSAVE : 321

2009-10-29 08:54:54 0x5D4 19930 TASKING Kernel initialization completed

2009-10-29 08:54:54 0x5D4 31 SrvTasks Permanently reserved 13 servertasks for 'Backup / Restore'.

2009-10-29 08:54:54 0x5D4 31 SrvTasks Permanently reserved 2 servertasks for 'Backup / Restore'.

2009-10-29 08:54:54 0x5D4 31 SrvTasks Permanently reserved 1 servertasks for 'Savepoint'.

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 5

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:0

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 20

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:1

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 19

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:2

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 18

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:3

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 17

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:4

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 16

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:5

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 15

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:6

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 14

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:7

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 13

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:8

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 12

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:9

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 11

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:10

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 10

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:11

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 9

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:12

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 8

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:13

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 7

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:14

2009-10-29 08:54:54 0x5D4 20018 Pager Start TaskId: 6

2009-10-29 08:54:54 0x5D4 20019 Pager First DataCacheSegment:15

2009-10-29 08:54:55 0x410 19628 CONNECT REQUESTOR is rejecting connect request

2009-10-29 08:54:55 0x334 3 RunTime State changed from STARTING to ADMIN

2009-10-29 08:54:55 0x334 19601 DBSTATE SERVERDB is ready

============================================ begin of write cycle ==================

2009-10-29 08:55:00 0x5EC 19633 CONNECT Connect req. (T21, Node:'', PID:2096)

2009-10-29 08:55:01 0x5EC 19651 CONNECT Connection released, T21

2009-10-29 08:55:06 0x5EC 19633 CONNECT Connect req. (T22, Node:'', PID:2096)

2009-10-29 08:55:07 0x5EC 19651 CONNECT Connection released, T22

and so on

Regards

Heinz

[Former Member]

Hello,

as I have found, it has simply been a issue with the DBMGui (why - I still don't know).

Manually the database could be extended via dbmcli without any problems:

dbmcli on CSP>db_addvolume DATA D:\sapdb\CSP\sapdata\DISKD0003 F 128000

OK

Anyway Thanks for your help, sorry for having bothered you.

Regards

Heinz