Db2
Configure a Db2® datasource on your Guardium® system.
Supported Authentication Methods
| Authentication | Supported |
|---|---|
| Local user | Yes |
| LDAP | No |
| Kerberos | No |
| SSL | Yes |
| Mutual SSL | No |
Parameters
| Field | Description |
|---|---|
| Host Name/IP | Required. The hostname or IP address of the datasource. |
| Database name | The name of the database. |
| Port number | Required. Default value: 50000. |
| Schema | The name of the database schema. |
| Connection property | Properties that must be included in the JDBC URL to establish a JDBC connection with the datasource. The required format is property1=value;property2=value, where each property and value pair is separated by a semicolon. For examples, refer to the database vendor's JDBC documentation. |
| Custom URL | The connection string to the datasource. When the custom URL is not provided, the datasource connection is made by using properties such as the hostname and port number. Example: For an encrypted connection, enter securityMechanism=13 |
CAS (Configuration Auditing System) database instance
If you are a CAS user, configure the CAS database instance.
| Field | Description |
|---|---|
| Account | The name of the account owner. Example: db2inst1 |
| Directory | The name of the installation directory. Usually the home directory of db2inst1 or C:\Program Files\IBM\SQLLIB on Windows™ The program db2cmd.exe must be on the system path, or in the bin subdirectory of the Database Instance Directory. |
What does this mean?
For Db2 UDB, Guardium supports count_big(*). On very large tables, a standard count(*) could fail