Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.52

Administer > System configuration parameters > Database parameters > system_createupperindex

Parameter: system_createupperindex

Startup parameters change the behavior of the HPE Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

system_createupperindex

Description

This parameter enables the Service Manager server to convert specified tables in an Oracle database to use UPPER indexes. Use this parameter in conjunction with the sqlupper parameter. For more information, see Parameter: sqlupper.

Note When running this command, error messages that resemble the following may occur, which can be safely ignored:

3952( 4916) 09/18/2014 11:48:15 RTE E could not find key addl.parents in ocml

In this example, the key field (addl.parents) is an array, and mapped to a separate table on SQL. The error message occurs because the index cannot be generated on the main table (OCMLM1). The index will be generated later on the new table (OCMLA1).

Valid if set from

Server's operating system command prompt

Requires restart of the Service Manager server?

Yes

Default value

None

Possible values

all (Convert all tables in the Oracle database)

list of table names separated by a comma (Convert specified tables in the Oracle database)

Example usage

sm -system_createupperindex:all

sm -system_createupperindex:cm3r,cm3t

Send Help Center feedback