Hi, i had the same problem some weeks ago. The following commands worked for me and fixed the problem
start in admin-mode c:\programme\sapdb\depend\pgm\dbmcli -d DBNAME -u user,password db_admin add a new volume, DAT_0002 is the name, F=filesystem, 120000=size in pages c:\programme\sapdb\depend\pgm\dbmcli -d DBNAME -u user,password db_addvolume DATA DAT_0002 F 120000 stop database c:\programme\sapdb\depend\pgm\dbmcli -d DBNAME -u user,password db_stop start database in online-mode c:\programme\sapdb\depend\pgm\dbmcli -d DBNAME -u user,password db_online You can also use the DBM-Gui: Configuration - DATA Volumes, There should be a DATAxxxx where no size, type and Location is shown. Choose this one to edit. Now you can change the size and the other two things. Then you confirm your settings with <ok>. When this volume is created your database can be started in Online-Mode. > -----Urspr�ngliche Nachricht----- > Von: Mark Johnson [SMTP:[EMAIL PROTECTED] > Gesendet am: Mittwoch, 10. Dezember 2003 00:00 > An: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Betreff: DB Full - Crash on startup > > It seems our database filled and cannot get to online mode. The > following message is found in knldiag: > > 2003-12-09 16:31:29 36 WNG 18 Log Log backups are disabled > 2003-12-09 16:31:29 36 7 Log 1 queues, flushmode is > 'MinimizeSpace', devstate is 'HistoryLost' > 2003-12-09 16:31:29 36 8 Log Oldest not saved is ioseq > 1608000 @ off 55 > 2003-12-09 16:31:29 36 9 Log First known on LogVolume is > ioseq 1591331 @ off 98 > 2003-12-09 16:31:29 36 6 Log Restart from ioseq 1608000 > @ off 55 to ioseq 1608283 @ off 97 > 2003-12-09 16:31:29 36 11 Log Result after checking the > log device: 'Ok' > 2003-12-09 16:31:29 21 43 Log recovering log from > log_volume from IOSeq: '1608000' > 2003-12-09 16:31:29 21 WNG 6 Kernel_E 95 %% of data base > occupied, 640 pages free > 2003-12-09 16:31:29 21 WNG 39 Converte Restart aborted because of > DB Full detection. > 2003-12-09 16:31:29 21 ERR 8 Data PageAccessManager: cannot > allocate new pages > 2003-12-09 16:31:29 21 ERR 11196 DBCRASH vabort:Emergency Shutdown, > Log_RedoFile.cpp: 205 > 2003-12-09 16:31:29 21 ERR 11599 BTRACE ----> Emergency Stack Back > Trace <---- > > > How can I add a DATA volume if I can't get to online mode? Is there a > procedure? > > Thanks in advance, > Mark > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
