Thanks for the Info. Trying the command sql_recreateindex within the gui or dbmcli produses both the following error:
/opt/sapdb/depend74/bin/dbmcli on MYDB>sql_recreateindex ERR -24988,ERR_SQL: sql error -9000,System error: Not yet implemented Thomas > Becker, Holger (06.02.2003 11:13): >[EMAIL PROTECTED] wrote > >> after migrating from 7.3.0.29 to 7.4.3.10 the command >> >> dbmcli -u dbm,dbm -d MYDB -uSQL -c info state shows the >> following output : >... >> Bad Indexes = 157 >... >> Before the migration there were definitely no Bad Indexes. So >> how do I recover >> from this ? > >With 7.4 we changed the index handling to straighten up the code >a little bit. > >Unfortunately this makes it necessary to recreate single indexes >if they are defined on optional columns (insertion of NULL is allowed). > >You could use dbmcli command 'sql_recreateindex' or >'DBMGui -> Tuning -> Index Use' to do so. > >Sorry for any inconvenience. > >Kind regards, >Holger >SAP Labs Berlin > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
