Thanks, i prefer a slower and secure restart.

Regards,
Miguel Angel.


Becker, Holger escribió:
> Hi,
> 
> if you set the database parameter AUTO_RECREATE_BAD_INDEXES to YES 
> bad indexes should be recreated at restart time.
> But be aware that this could slow down your restart.
> 
> Kind regards
> Holger
> 
> Holger Becker
> MaxDB&liveCache
> SAP AG
> www.sap.com
> Sitz der Gesellschaft/Registered Office: Walldorf, Germany
> Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO),  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: Linos [mailto:[EMAIL PROTECTED] 
>> Sent: Montag, 30. April 2007 11:01
>> To: Auer, Wolfgang
>> Cc: maxdb@lists.mysql.com
>> Subject: [LIKELY JUNK]Re: AW: -9041 BD Index not accessible
>>
>> Yes it works now, thanks, but i feel this can be a problem 
>> when it comes
>> to my production machines, the systems can have hardware/software
>> related problems and reboot without my control any times, i 
>> will have to
>> automate this process if we have an uncontrolled reboot.
>>
>> Regards,
>> Miguel Angel.
>>
>>
>> Auer, Wolfgang escribió:
>>> Hello,
>>>
>>> Please recreate the indexes with the DBMGui (Recovery -> Index) 
>>>
>>> Did you reboot your computer without changing the database 
>> to offline mode? This could have broken the index.
>>> Regards
>>>    Wolfgang
>>>
>>>
>>> Wolfgang Auer 
>>>
>>> mailto:[EMAIL PROTECTED] 
>>> 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.
>>>
>>> -----Ursprüngliche Nachricht-----
>>> Von: Linos [mailto:[EMAIL PROTECTED] 
>>> Gesendet: Montag, 30. April 2007 10:29
>>> An: maxdb@lists.mysql.com
>>> Betreff: -9041 BD Index not accessible
>>>
>>> Hello,
>>>     well i am going to explain all from the beginning, i am 
>> testing the
>>> example databases, dbmaster and dbclient, i had all working after
>>> configure the sync in the gui, activate the message server, 
>> create and
>>> activate the replication units and the synchronization services in
>>> dbmaster and dbclient, i have tested and in/out sync 
>> without problems
>>> but after the reboot to try to do in different machines (i 
>> have tested
>>> all in localhost) i have this error when i try to create other
>>> clientunit of dbmaster, i have the same error from the 
>> syncmangui and in
>>> the file knldiag.err (2007-04-30 10:18:39  3765 ERR 51080 
>> SYSERROR -9041
>>> BD Index not accessible), i can access with sqlcli and work with the
>>> dbmaster database so i dont know what it is happening, it 
>> is in online
>>> status too, i have searched the documentation for this 
>> error but it says
>>> that i would have to contact support, what can be 
>> happenning? Thanks in
>>> advance.
>>>
>>>
>>> Best Regards,
>>> Miguel Angel.
>>>
>>
>> -- 
>> 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]

Reply via email to