Hi, [...] > I am not particularly worried about my position, however this > sounds amazingly good. > Is this true? Do any of you do dba like work on these > databases or are they really self maintaining? > My experience is that no matter how automated systems get > inevitable you need someone to maintain the tools that do this too.
We use those database in all our SAP environment and we are in fact very happy with it :) Of course, every software product needs a "maintainer" who will check, if backups were successfull, apply patches and have a look, that everything is right. MaxDB has a complete different data storage approach as e. g. Oracle or DB2. There are not tablespaces, datafiles, extents, and controlfiles. MaxDB uses Volumes and spreads the data accross those volumes. You have no influence where a table is stored so you will never run into "hotspots". If a row is deleted, the corresponding pages are automatically rearranged and the space is available again immediately - whithout reorganization or fragmentation. If you add a volume the database will automatically rebalance the data during low I/O times so that after some time this new volume is filled as much as all others are. No manual intervention necessary. What we do with the database as DBA is - check that backups are running - check that the database are not filling up to 100% - schedule statistics updates - in special cases monitor and trace specific SQL statements If you have some chance, check it and test it :) Greetings to South Africa! SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
