Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 28, 2009 at 06:04 PM

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

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Nelis Lamprecht

      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

  • avatar image
    Former Member
    Oct 29, 2009 at 10:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded