> 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. > 2) If the state is "Database Full = Yes" why does the ODBC > 7.3 driver just HANG the calling application, shouldn't > it return a error! The versions of my products are listed > below. This is a "feature". In case of "database full" or "log full" the database freeze any application. After solving the problem by adding a devspace (for "database full") or backup the log (for "log full") via the DBM the application works on without any loss of data. > If anyone can help me ASAP - I need to dump that 15% Temp > Space, please write. One of my servers is down! Thank you. You have to add a new data devspace to your database. See DBMServer command db_adddevspace (or old syntax db_adddevice): http://www.sapdb.org/htmhelp/28/a3560833fd11d5aa9c006094b92fad/content.htm Bernd -- SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
