Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Words and Phrases
| 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. |
Using Boolean Operators
| Search for | Operator | Example |
|---|---|---|
|
Two or more words in the same topic |
|
|
| Either word in a topic |
|
|
| Topics that do not contain a specific word or phrase |
|
|
| Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
| A combination of search types | ( ) parentheses |
|
- Adapter Configuration Files
- The adapter.conf File
- The simplifiedConfiguration.xml File
- The orm.xml File
- The reconciliation_types.txt File
- The reconciliation_rules.txt File (for backwards compatibility)
- The transformations.txt File
- The discriminator.properties File
- The replication_config.txt File
- The fixed_values.txt File
- The persistence.xml File
The adapter.conf File
This file contains the following settings:
-
use.simplified.xml.config=false.true: uses simplifiedConfiguration.xml.
Note Using this file means that
orm.xml,transformations.txt, andreconciliation_rules.txtare replaced with fewer capabilities. -
dal.ids.chunk.size=300. Do not change this value.
-
dal.use.persistence.xml=false. true: the adapter reads the Hibernate configuration from
persistence.xml.Note It is not recommended to override the Hibernate configuration.
-
performance.memory.id.filtering=true. When the GDBA executes TQLS, in some cases a large number of IDs may be retrieved and sent back to the database using SQL. To avoid this excessive work and improve performance, the GDBA attempts to read the entire view/table and filters the results in-memory.
-
id.reconciliation.cmdb.id.type=string/bytes. When mapping the Generic DB adapter using ID Reconciliation, you can either map the cmdb_id to a string or bytes/raw column type by changing the META-INF/ adapter.conf property.
-
performance.enable.single.sql=true. This is an optional parameter. If it does not appear in the file, its default value is true. When true, the Generic Database Adapter tries to generate a single SQL statement for each query being executed (either for population or a federated query). Using a single SQL statement improves the performance and memory consumption of the Generic Database Adapter. When false, the Generic Database Adapter generates multiple SQL statements, which may take longer and consume more memory than a single one. Even when this attribute is set to true, the adapter does not generate a single SQL statement in the following scenarios:
-
The database the adapter connects to is not on an Oracle or SQL Server.
-
The TQL being executed contains a cardinality condition other than 0..* and 1..* (for example, if there is a cardinality condition like 2..* or 0..2).
-
-
in.expression.size.limit=950 (default). This parameter splits the 'IN' expression of the executed SQL, when the size limit of the list of arguments is reached.
-
stringlist.delimiter.of.<CIT Name>.<Attribute Name>=<delimiter>. In order to map a string list attribute to a database column in the generic database adapter, the attribute needs to be mapped to a string column that contains a list of concatenated values. For example, to map the attribute policy_category with the CI Type policy, and the string column contains a list of values: value1##value2##value3 (that define a list of 3 values value1, value2, value3), use the setting: stringlist.delimiter.of.policy.policy_category=##.
-
temp.tables.enabled=true. Enables using temporary tables to improve performance. Only available when performance.enable.single.sql is enabled (only supported in Microsoft SQL and Oracle). Certain permissions in the database server may be required.
-
temp.tables.min.value=50. Defines the number of condition values (or IDs) that are needed to use temporary tables.
