Deletion of index not working (GT085) - Bad performance

[Private_Member_19084]

Hi experts,

our table COEP has around 90 MIO entries and now it seems like one index is not any longer working.

Therefore I wanted to rebuild the index ith SE14.

However, on rebuilding the index I get error GT085. Does anybody know how I can go on?

Kind regards

[Private_Member_19084 · Accepted solution]

Thx to everybody for help.

I found the reason why SE14 was hanging.

There was a job running reading my table.

I will now try to rebuild index first with se14.

Thank you to everybody.

[Private_Member_19084]

Rebuilding index was ok, however, performance is still bad on table-access.

I've therefore created another thread

[Johan_sapbasis]

Hi,

Be exact when specifying the index name and not table name otherwise you could lock table which will severely impact your system.

In ISQL run:

Reorg Rebuild:

===========

reorg rebuild index_name with online

Reorg Rebuild:

===========

reorg rebuild table_name

      [index_name [partition index_partition_name]]

      [with online]

http://scn.sap.com/docs/DOC-44384

Regards,

Johan

[Johan_sapbasis]

Hi,

Try this it has details on the se14 method attach screenshot of error and possible sm21 entry as well.

Kind Regards,

Johan

[Private_Member_19084]

I already found this...seems to be oracle based.

ASE is having another dbacockpit, therefore it is not helpful.

Also the two reports are not available in our system.

[Johan_sapbasis]

Hi,

Was the index actually rebuild or not?

Please give us a bit more detail. 

What do you see in se14 if you run Extras -> Database Object -> check ?

Regards,

Johan

[Private_Member_19084]

Check displays consistent for all.

No it was not rebuild.

I tried now with dbacockpit, but also a problem on checking the index (db connection timeout).

Is there another function for rebuilding the index?

[hemanth2]

Hi Christian,
 

You can try the reorg rebuild as mentioned in:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00641.1572/html/new_featu...

You may also try to dropping and recreate the index and then try.

_ _ _ _ _ _ _ _ _

Kind Regards,

Hemanth
_ _ _ _ _ _ _ _ _
 

[Private_Member_19084]

Good to here from you Hermanth,

hope you are well.

I already searched on sybase wiki for this and maybe I investigate deeper, however I found another way for now (see below).

thank you