Hi Jan, Jan Hansen wrote: > > I've just installed a SAP DB as a part of a SAP APO system. > First of all, i am absolutely new in the SAP DB arena.
The question here is: Are you using the SAP DB as an APO DB or liveCache or both :-)? >From the version you are mentioning below I suggest, that you are taking about a liveCache instance. This forum is usually ment for the SAP DB as a SQL database. The liveCache funtionality is not open by now, but may be in the future :-). Nevertheless .... > I read somewhere during installation that the LOG DEVSPACE should be at > least the same size as the DATA DEVSPACES. I did that but the liveCache in > APO does not use the LOG DEVSPACE. > I would like to shrink the LOG DEVSPACE from 18Gb to 2Gb to be able to use > the diskspace for on-line backup. Would be interesting, where you red this. Maybe it was in a document about the next generation liveCache 7.4 which is more like a complete database with full logging for objects and SQL transactions. Then you need more LOG area than in the 7.2 liveCache. > How do i shrink a LOG DEVSPACE (examples using the dbmcli would be greatly > appreciated) ? > The SAP DB version is 7.2.5 Build 18. In general - as it is the same for all instance types of the SAP DB - it is not possible to shrink DEVSPACEs directly. It is only possible with the detour of a system copy with a backup and a 'Instance -> Install' afterwards to the same liveCache SID. With the 'Instance -> Install' the database with its areas is created new (you can change here nealy everything e.g. locations, sizes ...) and has to be restored afterwards. Please have a look into the SAP notes where this procedure is described in detail. Usually it doesn't last a long time to do this change when you are familiar with the proceeding. Ciao Ralf __________________________________________________________________ Dr. Ralf Czekalla mailto:[EMAIL PROTECTED] _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
