Hi, in 7.4 the DBM-Server command sql_recreateindex without an explicit index as option execute the "restart indexes" (recreate all indexes marked as bad) command to the kernel. This command is not anymore supported in 7.4 to recreate an index specifiy the index after the DBM-Server command.
sql_recreateindex "<scheme>"."<table>"."<index>" The index will by dropped and created again. Martin ----------------------- Your SAP DB Team at SAP SAP Labs Berlin -----Original Message----- From: Raimund Jacob [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 28. Mai 2003 09:11 To: SAP DB General Mailinglist Subject: bad indexes, cannot recreate hello, *! i have some bad indices in a 7.4 instance that i created from a 7.3 instance. this topic has been discussed before. the hint was to run sql_recreateindex which does not work: -9000,System error: Not yet implemented. (it does not work neither from the dbmgui nor from the dbmcli) i cannot find a solution for that on the mailing list archive. what should i do? 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
