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 |
|
- System configuration parameters
- Service Manager Server and Web Tier configuration files
- System parameters
- Web tier parameters
- Enter a parameter in the web client URL
- Enter a parameter in the sm.ini file
- Enter a parameter in the web.xml file
- Enter a parameter in the webtier.properties files
- Enter a parameter in sm.cfg or the server’s OS command prompt
- View parameters by function
- Alert parameters
- Application development parameters
- Background and scheduled process parameters
- Client parameters for Web clients
- Client parameters for Windows clients
- Connection parameters
- Database parameters
- alignradsensitivitywithdb
- allowunsupporteddbversion
- dbcachequery
- generateIndexDDL
- [oracle]
- [oracle_replicate]
- pgschema
- [postgresql]
- [sqlserver]
- [sqlserver_replicate]
- sqladhoccachesize
- sqlalwayson
- sqlautosort
- sqlbatchcount
- sqlcitext
- sqldb
- sqlddldirectory
- sqlddllogging
- sqldebug
- sqldictionary
- sqldictkey
- sqldicttable
- sqldirect
- sqldisconnect
- sqlfetchrows
- sqlfetchs
- sqljoinsok
- sqllibrary
- sqllimit
- sqllockretry
- sqllockwait
- sqllogin
- sqlloginretry
- sqlloginwait
- sqlnullclause
- sqlouterjoins
- sqlreuseablesql
- sqlstats
- sqltextdateformat
- sql_oracle_binary_ci
- sqltz
- sqlupper
- system_addconstraint
- system_createupperindex
- util
- wildcardcharacters
- Debugging parameters
- Help parameters
- Information retrieval (IR) expert parameters
- LDAP parameters
- Localization parameters
- Regional settings parameters
- Security parameters
- Servlet parameters
- SSL parameters
- System information parameters
- System performance parameters
Database parameters
The following table lists the startup parameters that you can set from the Service Manager server's operating system command prompt or from the Service Manager initialization file (sm.ini).
These parameters determine how the Service Manager server manages the RDBMS database systems.
| Startup parameter | Brief description |
|---|---|
| Startup parameter: allowunsupporteddbversion | Specifies whether the unsupported versions of the Oracle database are allowed when Service Manager connects to the database server |
| Parameter: dbcachequery | Creates a cache for a comma separated list of table names. |
| generateIndexDDL | Generates the DDL of indexes and constraints for your database in a DDL file: <Server installation directory>/RUN/ddls/index.ddl. |
| SQL parameters: [oracle] | Creates a section header in the initialization file for connection parameters to an Oracle database |
| SQL parameters: [oracle_replicate] | Creates a section header in the initialization file for connection parameters to a replicated Oracle database |
| SQL parameters: pgschema | Specifies the schema when you use a PostgreSQL database |
| SQL parameters:[postgresql] | Creates a section header in the initialization file for connection parameters to a PostgreSQL database |
| SQL parameters:[sqlserver] | Creates a section header in the initialization file for connection parameters to a Microsoft SQL Server database |
| SQL parameters: [sqlserver_replicate] | Creates a section header in the initialization file for connection parameters to a replicated Microsoft SQL Server database |
| SQL parameters: sqladhoccachesize | Limits the memory consumption of the ad hoc SQL cache |
| Parameter: sqlalwayson | Enables SQL Server AwaysOn when Service Manager is running on a SQL Server database cluster. |
| SQL parameters: sqlautosort | Causes the Service Manager server to automatically sort query results based on any keys within the query |
| SQL parameters: sqlbatchcount | Defines the number of records the Service Manager server retrieves from the RDBMS during a single select call |
| Parameter: sqlcitext | Enables case-insensitive when you use a PostgreSQL database |
| SQL parameters: sqldb | Defines the host name of the RDBMS to which you want the Service Manager server to connect |
| Parameter: sqlddldirectory | Defines the path where the Service Manager server saves DDL files |
| Parameter: sqlddllogging | Enables creation of DDL files when database dictionary records change |
| SQL parameters: sqldebug | Enables the Service Manager server to write information about RDBMS connections to the sm.log file |
| SQL parameters: sqldictionary | Defines the name of the RDBMS where the Service Manager database dictionary resides |
| SQL parameters: sqldictkey | Defines the primary key of the RDBMS column where the Service Manager database dictionary resides |
| SQL parameters: sqldicttable | Defines the name of the RDBMS table where the Service Manager database dictionary resides |
| SQL parameters: sqldirect | Determines how the Service Manager server formats direct SQL commands to an RDBMS using the SQLexecute RAD function |
| SQL parameters: sqldisconnect | Determines when the Service Manager server disconnects from the RDBMS |
| SQL parameters: sqlfetchrows | Determines the number of rows Service Manager retrieves during one connection to the RDBMS |
| SQL parameters: sqlfetchs | Determines the number of primary keys that Service Manager retrieves during one connection to the RDBMS |
| SQL parameters: sqljoinsok | Specifies a comma-delimited list of tables for which outer joins are allowed |
| SQL parameters: sqllibrary | Defines the file name of library containing your RDBMS drivers |
| SQL parameters: sqllimit | Defines the time limit for requests to the RDBMS |
| SQL parameters: sqllockretry | Defines the maximum number of retries the Service Manager server makes attempting to lock a system resource |
| SQL parameters: sqllockwait | Defines the time in seconds that the Service Manager server waits between attempts to lock a system resource |
| SQL parameters: sqllogin | Defines the user name and password that Service Manager uses to authenticate connections to the RDBMS |
| SQL parameters: sqlloginretry | Defines the maximum number of times that the Service Manager server retries to authenticate a connection to the RDBMS |
| SQL parameters: sqlloginwait | Defines the time in seconds that the Service Manager server waits to connect to the RDBMS |
| SQL parameters: sqlnullclause | Allows to use nulls first clause in SQL statements. |
| SQL parameters: sqlouterjoins | Provides options on how two tables are joined together when being queried |
| SQL parameters: sqlreuseablesql | Enables the RDBMS to cache query results for use later on Oracle databases |
| Logs statistics from an Oracle database in the sm.log file | |
| SQL parameters: sqltextdateformat | Defines the format that the Service Manager server uses to write out dates to strings |
| SQL parameters: sqltz | Defines the time zone that the Service Manager server uses to display date and time information |
| Parameter: sql_oracle_binary_ci | Enables the legacy connector to communicate with a case-insensitive Oracle database |
| Parameter: sqlupper | Converts new tables in a case-sensitive Oracle database to use UPPER indexes and enables a case-insensitive search behavior in the case-sensitive Oracle database |
| Parameter: system_addconstraint | Adds a Not Null constraint to the first unique key or converts the unique key to a primary key for the specified database tables, depending on usage |
| Parameter: system_createupperindex | Converts specified tables in an Oracle database to use UPPER indexes |
| Startup parameter: unlockdatabase | Allows you to clean up the database lock record, and then start the Service Manager system on a backup server in a vertical scaled implementation. |
| Parameter: util | Starts the Service Manager Database Maintenance utility |
| Parameter: wildcardcharacters | Defines the wildcard characters that you want the Service Manager server to use during searches |
| Startup parameter: alignradsensitivitywithdb | Specifies whether RAD case sensitivity for string comparing is aligned with that of the Service Manager database. |
Related topics
