How do I verify if my AAI database is case insensitive?

Products

• Automic Automation Intelligence

Issue/Introduction

How do I verify if my AAI database is case insensitive?

 

AAI and Autosys both must be using the same case sensitivity.  By default AAI should be case sensitive.

Environment

Release : 6.0.1

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

In order to verify if the AAI database is set to be case sensitive run the following query:

select * from JawsProperties where propertyName='DB.SCHEMA.VERSION'

 

 If the database is case sensitive then you will not receive any result set.

 

In order to verify if your Autosyst DB  is case senstive run:

select str_val from ujo_alamode where type='autoserv'

 

If you receive result str_val and it is not null then it is case insensitive else database otherwise it is case sensitive.