Hello all, at first, 1000 data volumes are many, and probably too many. A data volume is more something like a hard disk drive (and it is really one, if you use a raw device instead of a file) - so how large did you dimension your data volumes?
Anyway, as the data is distributed among the volumes, there is no way of removing a data volume easily. I suggest making a complete data backup, and creating a new database instance for recovery (then, with proper size and count of volumes). !!! Deleting the parameter file and plugging only some volumes on again can under no circumstance be recommended, as this is the direct way to data loss. If it had worked for someone this was pure luck, as then there was no data on the volume. !!! Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Andy Chan [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 03, 2004 10:10 AM > To: Steffen Fiedler; [EMAIL PROTECTED] > Subject: RE: removing data-volumes > > > i once found myself first removing the volume (definition > only) and re-catalogue it. > > i.e. > param_rmfile > param_addvolume (add only those needed) > > not too sure this is a right approach though > > Cheers, > Andy > > -----Original Message----- > From: Steffen Fiedler [mailto:[EMAIL PROTECTED] > Sent: 2004?3?2? 21:52 > To: [EMAIL PROTECTED] > Subject: removing data-volumes > > > Hi, > > im using sapdb with data-binding-framework CASTOR. > Lately i often got errormessage 904 'space for result tables > exhausted' cause the CASTOR-generated requests are often > very large. I solved this problem by adding more data-volumes. > Last time i added a lot of volumes (1 000 000), because the > error occured over and over, a little bit to much and got a > sensible performance los. > Is it possible to remove data volumes? I only found the > dbm-command db_addvolume and miss something like > db_delvolume. > > > Thanks, > Steffen** > > > -- > 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
