Hello again, > > El jue, 31-01-2002 a las 09:21, Mensing, Joerg escribi�: > > > > > > * Can I use linux raw devices for devspaces? > > > > Its a little bit depend on your LINUX version, but it is > possible with the > > right LINUX patches. > > Where I can get these patches ? Depends on your LINUX version... You need at least a linux that supprt raw devices at all. Then you have to look up for a patch that fixes problems with 8KB page access during high I/O activity. Recommende try is www.suse.de I talked with our factory and got the information, that they did not had any problems at all, but know about a custumer who got the problems above. But nobody knows if there was ever an officially released patch. That is all i could find out about it.
> > > > > > * It's there any product for online replication of > database (SGDB > > > master -> SGBD slave), like mysql's one ? > > not yet, but it is planned and has at least already a name: > Replication > > Manager > > > > > * It's there a tool or command like VACUUM in > Postgresql or isn't > > > neccessary? > > I don't know VACUUM. > > > > Vaccuum is used to free the space used by deleted > rows, updated ones , > etc and for recreate the optimizer statistics. > SAPDB does these things without need of an extra tool. Actually one of those features, that really makes SAPDB nice for administrators ;-) There is no need for planned downtime. All garbage elimination is done by background tasks inside SAPDB. If you feel to need to update your statistic information look for UPDATE STATISTIC command in your documentation. > > > > * Could somebody explain me the different types of databases > > > DW,LiveCache,etc... > > > > SAPDB has one executable, that is configured for special > purposes. LIVECACHE > > is used to setup SAPDB primarily as Memory Database with > ability to store > > persisitent Objects. DW (Datawarehouse) is used primarily > for data mining. > > CS (ContentServer) is used if database is setup for > documentation storage. > > OLTP (OnlineTransaciotnProcessing) is used for 'normal' SQL > business. Each > > instance configures a special set of parameters, i.e. Only Livecache > > instances allow OMS_REGIONS, setup more strictive > request-timeouts, setup > > garbage collectors, setup different stack size etc. > > > In a area of my project I need to pass data between two > process very > quickly, about 30 records/sec. One processes put the data and anothers > take it, process and next delete it. Due a design requirement > I need to > do that throught a DB. Must I configure this db as LiveCache ? > I am already sorry, that i answered your question in too much detail. As Elke mentioned forget about LiveCache. You can do this with normal SQL statements. > Many thanks. > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
