Hello, I already added space, and this corrected the situation - but I am concerned about other newbies repeating my mistake.
The output of the "info devspace" is both buggy and misleading (at least on Windows 2000). It does seem to mix up "pages" and "KB" labels. I also find it very confusing when it says "85% used, 15% free" when that 15% is really allocated to the "temp data" and is NOT free! Can someone at SAP confirmed that at minimum the problem with "KB" being switched with "pages" on the _info devspace_ output will be corrected? Stephen -----Original Message----- From: Vorsprach, Bernd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 12:26 AM To: 'Stephen Gutknecht (SAPDB)'; [EMAIL PROTECTED] Subject: RE: sapdb 7.3 hangs client on INSERT with database full - how to dump temp space? > Ok, here it is clear that "Database Full = Yes". > > How do I dump the 15% "Temp Space"? I did a full backup, and > it did not free up. I have rebooted the server, still didn't > free it. It isn't like I have a transaction going! You can not free the temp space. This space is reserved for some special database activities (e.g. redo the log after a crash). Maybe the term "temp" is a little bit inappropriate. > 1) The output of "info devspaces" shows the number 64997 as > "Free Space (KB)" - but the command "info state" shows > the number 64998 as "Temp Data (Pages)" - is the "info > devspaces" output MIXING UP the terms PAGES and > KILOBYTES? I have asked why these numbers don't make sense > in the past... "info state" is the more exact information. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
