Don't ya hate replying to your own questions? I've found it. www.rst-consult.com/database/sapdb/dbmcli_us_html.html is a dbmcli howto. I found that a backup of the log would clear it and unblock the database.
The short version (for any other newbies out there) add two 'mediums' for data and log backup with medium_put medium1 /tmp/databak FILE DATA 0 8 YES and medium_put medium2 /tmp/logbak FILE LOG 0 8 YES The names of the files don't matter: the ones above were just the one's I chose for testing. The do a data backup, then a log backup and voila! Hope this saves someone else a bit of time. Alan Graham On Sat, 2003-07-19 at 20:47, Alan Graham wrote: > <SAPdb newbie ON> > > I'm trying to load lots of data into a SAPdb instance. I've tried a > number of times, and there have been minor data integrity problems with > each load so far. Unfortunately, I forgot to trap each failure and end > the script gracefullt (I'm assuming I should have put the attempt into a > try-except and did a sql.rollback if it failed?) > > The situation now is that the log area is full with these previous > attempts. I can't find a way to dump the log contents. I just want > them gone. I've tried everything I can think of in webdbm, with no > luck. Trying to configure the log mode just gives an error "Log Mode > Configuration not possible". That's with the database online, offline, > or admin. > > I assume that there's a command in dbmcli that I can run. > > Can anyone enlighten me as to what it is? > > Thanks in advance. > > Alan Graham > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
