hello!
as in dbmcli_74eng.pdf written the sql_recreateindex shold work for all bad indexes if no parameter is given. But it doesn't work. Is this a bug?
as a workaround i made a little script that basically does somehting like that:
dbmcli -d $DBNAME -u $DBMUSER,$DBMPASS -uSQL $DBAUSER,$DBAPASS \ sql_execute "select * from domain.show_bad_index" \ sed -e '/^OK/d' -e '/^END/d' -e '/^ERR/d' -e '/^-24988/d' -e '/^100/d' \ -e "s/'/\"/g" -e 's/;/./g' -e 's/^/sql_recreateindex /g' > $tmp
dbmcli -d $DBNAME -u $DBMUSER,$DBMPASS -uSQL $DBAUSER,$DBAPASS -i $tmp
the information about the bad indices is available in the show_bad_index view but it has to be reformatted a little. then you can repair one index at a time.
good luck with that,
Raimund-- Pinuts media+science GmbH http://www.pinuts.de Raimund Jacob [EMAIL PROTECTED] Potsdamer Str. 96 voice : +49 30 59 00 90 322 10785 Berlin fax : +49 30 59 00 90 390 Germany
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
