Hello Michael, medium_delete does indeed accept no wildcards. If you want to delete all your backup media, you can rename or delete file dbm.mmm in the rundirectory of the database.
Best regards, Tilo Heinrich Senior Developer MaxDB&liveCache SAP AG http://www.sap.com <http://www.sap.com/> Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi, Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. -----Original Message----- From: Michael P [mailto:[EMAIL PROTECTED] Sent: Freitag, 15. Juni 2007 14:23 To: List Subject: Re: Error -24987: Paket size too small for answer Hi, thanks to Bernd for his hint (to use "medium_delete") he gave in Oct 2005 :-). It helped me as well. I created too many mediums and got the error "Error -24987: Paket size too small for answer". Then I deleted a few mediums with the DBMServer command medium_delete and the error disappeared. Question: How can I delete several mediums at once? Is there a wildcard available? medium_delete backup_2006* unfortunately does not work. Best wishes Michael -------- Original-Nachricht -------- Betreff: AW: Error -24987: Paket size too small for answer Datum: Thu, 13 Oct 2005 10:20:36 +0200 Von: Vorsprach, Bernd <???> An: <[email protected]> Von: Nils Petter Bjørge [mailto:[EMAIL PROTECTED] > > This error didn't appear in the beginning, and I suspect the > growing numbers of backup medias to be the reason. > > When I list the Backup history, I get the list up and all > backups have run and new backup mediums are created > continiually(scheduled script). So that is OK and everything > runs fine like in Jan-Hendrik Lendholt's case, but... > > When I try to open Backup Medium in DBMGUI, I get Error > -24987 (packet_size to small) > When I tried to change _PACKET_SIZE value in DBMGUI, ... Hello Nils, the communication packet between the DBMServer and a DBMClient has a limit. For DBMServer commands which may produce a large amount of data (like sql_execute or backup_history_list) we have implemented a "fetch" command (sql_fetch, backup_history_listnext). For the command medium_getall unfortunately no "fetch" command exists. If the amount of data (the number of media definitions) exeeds the size of the communication packet the error "-24987, ERR_TOOSMALL: packet size too small for answer" will occur. Please decrease your number of media definitions with the DBMServer command medium_delete or edit the file <rundirectory>/dbm.mmm. Also you should change your backup strategy to avoid the growth of the media definitions. Regards Bernd PS: The database parameter _PACKET_SIZE does not matter in this area. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
