Words and Phrases
Database parameters
The following table lists the startup parameters that you can set from the HPE 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 |
| SQL parameters:[db2universal] | Creates a section header in the initialization file for information about an IBM DB2 Universal database. |
| SQL parameters: [db2universal_replicate] | Creates a section header in the initialization file for information about a replicated IBM DB2 Universal database. |
| 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:[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 HPE Service Manager is running on a SQL Server (2012 or later) 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 |
| 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: sqldictrecord | Defines the name of the RDBMS column where a valid Service Manager database dictionary record 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 DB2/Universal and 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 |