Share This:

We wanted to use Binary_AI indexes with our Remedy 9.1.05 installation because we are a french organisation, but could not find a way to do it.

 

So i oppened a case and here what came out of it. I'm posting this because we could not find any useful informaton at the time and maybe someone will find it useful.

 

You need to configure the following parameter for the ARS server to use different indexes than the tradicionnal Binary_CI.

 

Go to the administration console, in server information, on the Database tab and add the Following information in the configuration file section

 

DB-Options: Oracle {

name:NLS_SORT

value:BINARY_AI

}

2018-07-09 11_41_36-Microsoft Edge.png

After that, go to your ar.cfg file and make sure the following 2 line are included :

Db-Case-Insensitive: T

Db-Functional-Index: T

 

Restart your Remedy Ars services

2018-07-09 11_48_22-9. Refaire les indexes Binary_AI - OneNote.png

 

The server should now be using the Binary_AI indexes

 

Note : be sure that your dba team have rebuilded the indexes acordingly

Note 2 : Sorry for the spealling, english is not my primary language. If you guys note some mistakes or need some precisions, just advise an i will correct.