2006/3/22, Heinrich, Tilo <[EMAIL PROTECTED]>:
> Hello Robert,
>
> Starting with MaxDB 7.6 you can delete data volumes in database state ONLINE. 
> So by adding new volumes and deleting old ones, you have a way of changing 
> the size of a volume without backup/restore.

I know (see my last posting). But the issue of IO and space for this
operation remains. I'd really love to see resizing of volumes as a
feature in MaxDB.

robert

> Best regards,
> Tilo Heinrich
> SAP Labs Berlin
>
> -----Original Message-----
> From: Robert Klemme [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 22, 2006 3:16 PM
> To: Döhr, Markus ICC-H
> Cc: Denham Eva; maxdb@lists.mysql.com
> Subject: Re: Maxdb does not need a DBA?
>
> 2006/3/22, "Döhr, Markus ICC-H" <[EMAIL PROTECTED]>:
> > 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.
>
> Definitely.
>
> > 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".
>
> But it also means that you have no chance to optimize it if the usage
> pattern is bad; and unfortunately there is no way to change the size
> of a volume (is there?).  I personally found SQL Server to be the most
> hassle free RDBMS I have worked with.  I'm sorry to say that on this
> list but also YMMV...
>
> Kind regards
>
> robert
>
> --
> Have a look: http://www.flickr.com/photos/fussel-foto/
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>


--
Have a look: http://www.flickr.com/photos/fussel-foto/

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to