Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have 4 AS400s running JDEdwards.

Lately a performance issue occured as described here: AS400 Performace issue

Although i am not an expert in AS400 , i tried to find out the cause. I think it came down to this:

I run the following SQL in all my systems:

select sort_sequence,index_schema,count(*) from qsys2.sysindexstat group by sort_sequence,index_schema

In 3 of my 4 systems all of them have sort_sequence="BY HEX VALUE"

In my 4 problematic system many indexes have sort_sequence="*LANGIDSHR"

I start to believe that this can cause performance problems as the query optimizer may leave these indexes unused and create temp indexes.

I wish somebody has an idea on where to go on from now and how.

Is there any specific setting that make all the indexes have default sort_sequence?

All my indexes are created massively so this could not happen by mistake.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

Solution: Sort Sequence

In short the problm occured from incorrect client odbc setup, making the indexes not *HEX but langauage specific , rendering the index ussage useless fromn server point of view.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.