7.3.2 Setting Database Information
Database Information specifies information such as the login ID and service name to be used to connect to the asset management database.
This section describes the settings for Database Information.
- Organization of this subsection
(1) Login ID
Login ID specifies the login ID of the user who will be connecting to the database. For details about creating a database field, see 7.4 Creating an asset management database.
In the Set Password dialog box, set the password.
This setting is mandatory.
-
Permitted value
For Login ID and password, specify from 1 to 8 characters. By default, both Login ID and the password are admin.
Only the following single-byte characters can be used for Login ID and password:
-
Letters (A to Z and a to z)
-
Numeric values (0 to 9)
A letter must be specified for the first character.
Do not specify ALL, MASTER, or PUBLIC for Login ID (case-insensitive).
-
This value is applied to Connection user ID in the dialog boxes listed below. If you change the value after creating a new asset management database, re-create the data source.
-
Basic Database Settings dialog box
-
Dialog box for creating a data source
(2) Service name
Service name specifies the service name for asset management.
Specification of this item is mandatory.
-
Permitted value
1-32 bytes of alphanumeric and special characters. The default is ASSET_DB_SERVICE_NAME.
!, (, ), *, ,, ;, =, ?, @, [, ], {, }, and spaces cannot be specified for Service name.
This value is applied to ODBC data source name in the dialog boxes listed below. If you change the value after creating a new asset management database, re-create the data source.
-
Basic Database Settings dialog box
-
Dialog box for creating a data source
(3) Number of concurrent connections
Number of concurrent connections specifies the number of connections that can be established with the database at the same time.
Specification of this item is optional.
-
Permitted value
1 to 64. The default is 20. Specify a value that is greater than the value of Number of connections for search in Database Information.
(4) Number of connections for search
Number of connections for search specifies the number of concurrent connections that can be established by transactions that use the database for an extended period of time. By specifying this setting, you can prevent the database from being locked by a long-running transaction such as a search request.
Specification of this item is optional.
-
Permitted value
1 to 64. The default is 5. The value of this item must be less than the value of Number of concurrent connections in Database Information.
(5) Case sensitivity in LIKE searches
Case sensitivity in LIKE searches specifies whether the search is to be case-sensitive when searching for a partial match, including a leading or trailing match.
-
Permitted value
-
Case sensitive (default)
The search is case-sensitive.
-
Case insensitive
The search is not case-sensitive.
-