The Integration Runtimes Dashboard contains all information that administrators need to monitor and manage the runtimes. The details include key system and server metrics, logs, and projects in an easy-to-read format.
The Integration Runtime Dashboard contains the following pages:
Overview
Projects
Logs
Services
Connections
To view the details of a runtime, click the corresponding runtime card on the Integration Runtimes page.
To view the details of a runtime instance, click the instance on the Instance Listing page.
Note
In case of multiple instances, only the details of the selected instance are displayed. The consolidated details of all instances of an edge runtime are currently not supported.
The Overview page displays a dashboard that shows key system properties for the current runtime.
The comprehensive dashboard helps you monitor system status, health, usage patterns, and overall performance of a runtime. The data on this dashboard is for the time that you select. You can select from one of the predefined time periods that are displayed at the top of the dashboard or set your own using the Custom command.
Server info summary
The top-most section of the dashboard provides a top-level summary using information boxes and charts:
Version: Displays the complete version of the runtime.
Server Name: Displays the name of the runtime.
Uptime: Displays the time (in hours and minutes) since the current runtime is started.
Disk Space: Displays the following information:
Total: Total amount of space on the disk allocated for the runtime.
Used: Total amount of space used by the runtime.
The red section of the Disk space card displays the Threshold of disk space usage.
Memory: Displays the following information:
Used: Displays the amount of memory that is being used by the Java Virtual Machine (JVM).
Total: Displays the maximum amount of memory the JVM is allowed to acquire.
Committed: Displays the amount of memory guaranteed to be available for use by the JVM. This number is likely to increase, be equal to, or decrease as the Used memory changes. However, it can never be lesser than the Used memory.
The red section of the Memory card displays the threshold of memory usage.
CPU: Displays the recent CPU usage of the Java Virtual Machine (JVM) process.
Uptime summary
The Uptime summary is a linear chart with color-coded metrics of a runtime availability from the time it is started.
Running: This shows the time periods when the runtime ran successfully.
Unknown: This shows the time periods when the runtime is offline or could not be reached for unknown reasons.
Stopped: This shows the time periods when the runtime is stopped.
Runtime summary
The Runtime section consists of four graphs divided into two sections as:
JVM metrics
Server usage statistics
JVM metrics
The top two graphs in the Runtime section are the Java Virtual Machine (JVM) metrics. It allows you to view the operating system resource information, such as CPU and Memory usage in time series.
Note
The JVM data is only for the current runtime. This data is the data reported by the java.lang.management.MemoryPoolMXBean class.
JVM metrics are displayed using the following graphs:
Memory usage (MB)
Heap used: Displays the amount of memory (in Megabytes) used in the heap.
Non heap used: Displays the amount of non-heap memory (in Megabytes) used by the JVM. The non-heap memory is where the JVM stores class-level information such as the fields and methods of a class, method code, runtime constant pool and internalized strings.
CPU usage (%)
System CPU: Displays the CPU usage for the whole system. This metric is displayed as a percentage value. A value of 0% means that all CPUs are idle, and a value of 100% means that all CPUs are running during the observation interval.
Process CPU: Displays the CPU usage of the JVM process. This metric is displayed as a percentage value. A value of 0% means that all CPUs are idle, and a value of 100% means that all CPUs are running during the observation interval.
Server usage metrics
The server usage statistics are the lower two graphs in the Runtime section. These charts provide a view of the consolidated sessions and requests from all the cluster nodes of the runtime.
Sessions: Displays data from all nodes in the cluster if the runtime is part of a cluster.
Note
The sessions data includes sessions started by users and runtime internally.
Stateful: Number of stateful sessions started in the polling interval.
Stateless: Number of stateless sessions started in the polling interval.
Licensed: Number of licensed sessions started in the polling interval.
Total: Number of total sessions started in the polling interval.
Requests: Displays data from all nodes in the cluster if the runtime is part of a cluster. Request metrics relate to invocations of only the top-level services. Requests for other services by the top-level services are not included.
Successful: Number of requests successfully completed in the time interval.
Error: Number of failed requests in the time interval.
Total: Total number of requests completed in the time interval. Total requests are equal to the sum of Successful and Error requests.
Diagnostic data
You can download configuration, operation, and logging data for the runtime by using the Diagnostics button in the server summary section of the Server Info dashboard. Only Administrators can access the diagnostic data.
Using this diagnostic data cloud administrators and cloud service providers can monitor the health and performance of cloud instances, troubleshoot issues, optimize resource allocation, and ensure the overall reliability and availability of cloud-based services. Additionally, they can use the data for capacity planning and cost optimization, as it provides insights into how resources are being utilized.
Downloading diagnostic data
In the Integration Runtimes page, click a runtime card for which you want to view diagnostics.
In the Server Info page, click the Diagnostics button.
The diagnostics data is downloaded in a zip file and the file name format is Diagnosticsruntime name yyyy-MM-dd-TO MM-dd Z.zip. For example, Diagnostics_Cloud Execution_2022-08-12T06_14_46.812Z.zip.
The extracted contents of the zip file are available in the following folders:
Note
If there are problems creating the .zip file due to insufficient space on your machine, the data is downloaded into a text file. In the text file, the configuration and operation data are separated into distinct sections for easier reading. Unlike the zip file, the text file does not contain logging data.
Projects
No subtopics in this section
The Projects page in the runtime view provides a list of all projects associated with this runtime. You can navigate to the Projects page by selecting a runtime card in the Integration Runtimes page and then clicking Projects.
The basic project details such as name, version, and owner are displayed in a tabular format. You can click on any project and go to that project directory. Additionally, you can perform a resynchronize operation to retrieve the latest information of all assets.
You can delete the project by clicking the icon.
You can delete projects, if the runtime is mutable.
You must have administrator privileges to delete projects.
You cannot delete projects from cloud runtime.
You can resynchronize the project by clicking the icon.
Projects can be resynchronized, if the runtime is mutable.
The project failures in the edge runtime can often be attributed to outdated assets. In such instances, deleting and resynchronizing the project ensures that the project’s latest assets are used.
The logs contain important information that is necessary for monitoring the activity of a runtime and resolving any issues that may arise. The logs are limited to server, error, and service logs.
The logs are available in the Logs page of the runtime instance view.
Logging, Data Protection, and Privacy
The logs include personally identifiable information (PII) such as usernames, email addresses, and client IP addresses. Runtimes include PII in logs for purposes of auditing, monitoring activity with the server, and diagnosing and correcting problems. The duration that the runtime stores log data depends on the log.
Viewing Runtime Logs
Tip
Click the Table Settings ( ) icon to customize the table look.
In the Integration Runtimes page, click a runtime card for which you want to view logs.
Click Logs. A list of all logs appears by default.
[Optional] If you want to view errors or service logs, select the required Log type from the list.
[Optional] Enter the following details:
First line to display: Log entry that must be displayed on the first row. For example, if you enter 25, the 25th entry is displayed on the first row. To display all entries as logged, specify zero. By default, the most recent log is displayed on the first row.
Number of entries to display: Number of log entries that must be displayed per page.
[Optional] Click > Export as CSV. The logs are exported and saved as a csv file on your system. The default name of the file is server_logs.csv.
The Services page provides a list of all services associated with the runtime in a tabular format.
The service graphs show the top services sorted by response time and the request counts in descending order. Unlike request metrics on the Usages page, metrics on the Services page include services at all levels.
The Services page shows the following graphs:
Top 5 slow Services by response time: The top 5 services that have the longest average response time over the time range (excludes system services).
Top 5 services by request count: The top 5 services that have the most request count over the time range (excludes system services).
The Services page also shows the following data related to Service instances, Cache and prefetch information, and Circuit breaker information:
Search: Filter the content of the table in the Services page using the Search option. It also enables you to exclude system services and services that are not running currently from the view.
Settings(): Set the table display settings as one of the following values:
Enable Zebra stripes if you want to display alternate rows with different background colors.
Select which columns you want to display in the table using the Show Columns menu option.
Reset server cache: Resets the runtime cache to clear the count and restart the data collection timers for all services.
Service instances
The Service instances tab displays information about all past and current running services. The data is for all instances in the same cluster.
Package: Package that contains the service.
Note
The Package column is not displayed by default. Click > Show Columns to view this column.
Name: Full qualified name of the service that is running or has run.
Available threads: Threads that are currently running.
Running services: Number of instances of the service that is currently running.
Count: Number of instances of this service that ran in the specified time.
Success: Number of successful runs of the service.
Failure: Number of runs of this service that ended in failure.
Last ran: Date and time the service is last run.
Response time (ms): Average time of all responses within a given sampling interval, such as 60 seconds.
Minimum: Minimum time, in milliseconds, that the service took to run in the selected period.
Average: Average time, in milliseconds, that the service took to run in the selected period.
Maximum: Maximum time, in milliseconds, that the service took to run in the selected period.
Cache, prefetch, circuit breaker: Indicates whether the service’s caching option or prefetch option is enabled, or whether the service is a circuit breaker. Accordingly, one or more icons are displayed as follows:
: Indicates Cache is enabled.
: Indicates Prefetch is enabled.
: Indicates the service is a Circuit Breaker.
Cancel or Terminate Threads Associated with a Service
If you suspect that a Flow anywhere service is unresponsive either because the service is waiting for an external resource or is in an infinite loop, you can stop the execution of one or more threads associated with the service. You have two options:
Cancel the thread: When you cancel a thread, the runtime frees up resources that are held by the thread. For example, if a thread is holding a JDBC connection, runtime closes, releases the connection, and returns it to the JDBC connection pool.
Kill the thread: When you kill a thread, the runtime attempts to free up resources. However, if it cannot, it continues and terminates the thread. The runtime replenishes the pool with a new thread.
The runtime requires you to first cancel a thread before it allows you to terminate the thread. Once you successfully cancel a thread, you no longer have the option of terminating it.
When you cancel or terminate a thread, the runtime returns a thread to the global, trigger, scheduler, or circuit breaker thread pool, depending on the function being performed. The runtime identifies the threads, and you can cancel or terminate threads by flagging them on the service thread page as follows:
Threads that can be canceled are marked with a in the Cancel column.
Threads that can be terminated are marked with a in the Kill column.
Restrictions on Canceling or Terminating a Thread
Before canceling or terminating a thread, keep the following restrictions in mind:
You must try to cancel the thread before terminating it.
You can cancel or terminate threads for user-written Java or flow services only.
You cannot cancel or terminate threads:
When a JDBC connection is waiting on a response from the database.
When an underlying service is waiting on a blocking IO. Examples of blocking IO are:
A service waiting on a response from an HTTP request.
A service waiting on a response from an FTP request.
A service waiting on receiving data from read/write requests on a file or socket.
When it is an Integration Server system service.
Caution
Be careful when canceling or terminating threads. Canceling a thread might not free up resources being held by the service. Terminating a thread might put your resources in an unstable state.
Canceling or Terminating Service Threads
Prerequisites:
Ensure that you keep all the restrictions for cancelling or terminating service threads in mind. For more information on the restrictions on the cancel and terminate thread action, see Restrictions on Canceling or Terminating a Thread.
To cancel or terminate a service thread:
In the Integration Runtimes page, click a runtime card for which you want to cancel or terminate a service thread.
Go to the Services page.
In the services table, click on the running thread count in the Running services column. The service instances page appears.
Click to cancel a service. If cancel is successful, runtime removes the thread from the display. However, if cancel is unsuccessful, runtime enables the button for the thread.
Click to terminate the service thread. The runtime removes the thread from the display. If the terminate action is not successful, the thread remains in the display.
Generating an Individual Thread Dump for a Service
A thread dump can help you locate and diagnose thread contention issues that can cause thread blocks or deadlocks.
Typically, you might want to view the thread dump for an individual service thread because the service has been running for a very long time without completing it or is running in a loop. You suspect the service is in an infinite loop or is waiting for external resources that are not available. Based on the information you obtain from these thread dumps, you might be able to correct the problem. If you detect a problem with a thread that is associated with a user-written Java service or a flow service, you have the option of canceling or terminating the thread to allow the service to complete.
In the Integration Runtimes page, click card of the runtime where the thread you are inspecting is located.
Go to the Services page.
In the services table, click on the running thread count in the Running services column. The service instances running appear.
Click the thread name to view the thread dump.
If you want to copy the thread dump, click and paste the content to any document.
Click Close to close the thread dump page.
Cache and Prefetch Information
The Cache and prefetch information tab displays cache utilization information for only those services that are currently using cache.
The Cache and prefetch information tab displays the following information:
Package: Package that contains the service.
Note
This column is not displayed by default. Click Show Columns to view this column.
Name: Full qualified name of the service that is running or has run.
Last cache hit: Date and time that a cached result for this service was last accessed.
Cache hits: Total number of times that a cached result for this service has been accessed.
Cache hits/Total count: Percentage of requests for this service that have been fulfilled by retrieving the results from cache.
Cache entries: Number of active cache entries for the service.
Cache expires: Time when the cache expires for the service.
Last prefetch: Date and time that the runtime is last prefetched and cached the results for the service.
Note
The cache may not be refreshed at the exact time specified in Cache expires. It may vary from zero to 15 seconds, according to the cache sweeper thread.
Total prefetches: Total number of times the runtime has prefetched and cached the results for the service in the last poll interval (the poll interval is set to 10 minutes on most servers).
Recent prefetch: Total number of times the runtime has prefetched and cached the results for the service in the last poll interval (the poll interval is set to 10 minutes on most servers).
Circuit Breaker Information
The Circuit breaker information tab displays circuit breaker statistics for each service with a configured circuit breaker. Runtimes gather the circuit breaker statistics.
The circuit breaker feature is available by default for a service that resides on a Microservices Runtime instance. To use the circuit breaker feature with runtimes, you must have additional licensing.
If a circuit breaker is not configured for any service, the Circuit breaker information table displays the message No Services with a circuit breaker enabled.
The Circuit breaker information tab displays the following information:
Package: Package that contains the service.
Note
This column is not displayed by default. Click Show Columns to view this column.
Name: Full qualified name of the service that is running or has run.
State: State of the circuit can be one of the following:
Closed: Service executes.
Open: Service does not execute. Instead, depending on the circuit breaker configuration, the service returns an exception or executes an alternative service.
Half-open: First request for this service since the circuit state changes to half-open results in service execution. All other requests await. If the service executes successfully, the circuit is closed, and the waiting requests execute. If the service ends with a failure exception, the circuit is re-opened.
Open time: Time when circuit was opened.
Open time: Time when an action was performed to close the circuit, that is, to retry the execute call.
Half-open time: Time when the execution of the actual service attempts was made. If successful, the circuit is Closed; if unsuccessful, the circuit is Opened.
Closed time: Time when the circuit was last closed. Time here represents the last successful execution of the service.
Open count: Number of times the circuit was opened since the runtime started.
Request count: Number of incoming requests since the circuit was last opened.
The products that run on IBM webMethods Integration connects to database components (grouping of database objects) in an external RDBMS using the following types:
JDBC connection pools: Specify the parameters needed for establishing a connection between IBM webMethods Integration and the database components hosted on database servers. At run time, IBM webMethods Integration creates a separate instance of the connection pool for each database component.
Direct Functions: Write to the database components by pointing each function to the connection pool for the database component. For example, point the ISInternal function to the connection pool for the ISInternal and DistributedLocking database component, the Xref function at the connection pool for the CrossReference database component, and so on. IBM webMethods Integration provides predefined functions for each type of data that can be written to a database component.
When you use an external database for IBM webMethods Integration, one JDBC connection pool is created from the supplied parameters and the predefined functions are configured to write to their database components using that pool.
The following table provides the predefined functions and their database components that are included with IBM webMethods Integration.
Function Name
Database Component
ISInternal
ISInternal and DistributedLocking
ISCoreAudit
ISCoreAuditLog
ISDashboardStats
ISInternal
Xref
CrossReference
DocumentHistory
DocumentHistory
ProcessAudit
ProcessAudit
Process Engine
ProcessEngine
Note
You cannot add or delete functions.
You can create and delete a connection pool and point a function to the new pool.
Viewing JDBC Pools
In the Integration Runtimes page, click the runtime card for which you want to view connections.
Click Connections. The Connections page appears listing the following details:
Name: Function alias that directs IBM webMethods Integration and products that run on IBM webMethods Integration to write data to a particular database component. IBM webMethods Integration provides predefined functions for each type of data that can be written to a database component.
Associated pool alias: JDBC connection pool used by the function to write data to the database component. JDBC connection pool specifies the parameters needed for establishing a connection.
Description: Function alias description.
Actions: List of actions you can perform on the JDBC Pool. You can perform the following actions:
: Test the database connection.
: Restart the database connection. The runtime needs to be restarted in the following scenarios:
Association of a function with JDBC pool alias is updated.
A new JDBC Pool Alias is created.
An alert message appears, and the icon is enabled for administrators. This functionality is not available on Default cloud.
: Additional actions such as Edit to update the associated pool alias and Remove to delete the associated pool alias. Only the owner or administrator of the Integration Runtime can perform the additional actions such as Edit and Remove.
[Optional] Click the icon to associate a function with a pool alias. For more information associating with JDBC pool alias, see Associating a function with JDBC pool alias.
Associating a function with JDBC pool alias
Associating a function with a JDBC pool alias, ensures that the function can efficiently and consistently access database connections when needed. You get the benefits of connection pooling, such as connection reuse, connection validation, and automatic connection recovery. This helps improve the overall performance of your application by reducing the overhead of establishing new database connections for each function call, as well as more reliable and responsive database interactions.
In the Integration Runtimes page, click the runtime card for which you want to view connections.
Click Connections.
In the Connections page, click Configure database.
In the Configure webMethods database connection page, select the icon > Edit for the function you want to associate with a different JDBC pool.
Update the fields.
Click Save to save the changes.
Function name : Predefined functions provided by IBM webMethods Integration for each type of data that can be written to a database component.
Function description : Disabled. Function alias description.
Associated pool alias : JDBC Connection Pool that must be used by the function to write data to the database component.
Fail-Fast mode-enabled : Transient errors caused by an unavailable database can prevent a connection pool from connecting to its database. You can configure a function to enter fail-fast mode to handle this situation. In fail-fast mode, all attempts by the function to get a database connection immediately return an SQL exception; this saves time by preventing retry attempts. When database connectivity is restored, the function exits fail-fast mode and returns to normal operation. Fail-fast mode can improve performance when you are using synchronous audit logging.
You can perform the following:
Click the icon to add a new JDBC pool alias.
Click the icon to update or delete the selected JDBC pool alias.
Click the icon to test the selected JDBC pool alias connection.
Creating a New JDBC Pool Alias
In the Integration Runtimes page, click the runtime card for which you want to view connections.
Click Connections.
In the Connections page, click Configure database.
In the Configure webMethods connection pool alias page, click the icon.
In the Add webMethods database connection page, enter the following details:
Alias name: Name to use for the JDBC connection pool. The name can include any characters that are valid for a file name.
Alias description: Brief description of the JDBC connection pool.
Driver: Database driver for IBM webMethods Integration to use to connect to the JDBC connection pool.
Database URL: URL for the database server.
Sample database URL: Sample URL formats for the DataDirect Connect JDBC 5.1 driver are displayed.
Note
Use the DataDirect Connect connection option MaxPooledStatements=35 on all database URLs except those for Trading Networks. This connection option improves performance by caching prepared statements. (Trading Networks caches its prepared statements using its own pooling mechanism).
For DB2, if IBM webMethods Integration connects to a schema other than the default schema for the specified database user, you must specify these connection options in the URL:
;AlternateId=schema;“InitializationString=(SET CURRENT PATH=current_path,schema)“;MaxPooledStatements=35
AlternateID is the name of the default schema that is used to qualify unqualified database objects in dynamically prepared SQL statements.
Spy: When selected, enables the DataDirect Spy diagnostic feature for DataDirect Connect JDBC drivers. DataDirect Spy logs JDBC calls and SQL statement interactions between IBM webMethods Integration and an external RDBMS. This checkbox is cleared by default.
Note
This option is for use with an external RDBMS only. It is not for use with the embedded IS internal database.
Snoop: When selected, IBM webMethods Integration enables the DataDirect Snoop tool for DataDirect Connect JDBC drivers. The DataDirect Snoop tool logs network packets between IBM webMethods Integration and an external RDBMS. You can use the resulting log file for tracing and diagnostic purposes. This check box is cleared by default.
Note
This option is for use with an external RDBMS only. It is not for use with the embedded IS internal database.
Spy attributes: Defines the name and location of the log file where IBM webMethods Integration logs diagnostic data collected by the DataDirect Spy diagnostic feature. This value also defines DataDirect Spy attributes. Where alias_name is the name of the JDBC connection pool alias. Typically, you do not need to change the default value. However, if the attributes do not meet the needs of your system, enter a new value in the Spy Attributes field.
Note
If you specify your own value, be aware that the diagnostic tool collects data from the IBM webMethods Integration_directory /instances/instance_name/logs/spy directory. If you change the log file location, the diagnostic utility might not import the data logged by DataDirect Spy. For more information about setting DataDirect Spy attributes, consult the documentation on the DataDirect website.
Snoop logging parameters: Defines the name and location of the log file where IBM webMethods Integration logs diagnostic data collected by the DataDirect Snoop tool. This parameter also defines DataDirect Snoop tool attributes.
Note
For DB2, you must include the following command at the end of the value:
ddtdbg.ProtocolTraceEBCDIC=true
Typically, you do not need to change the default value. However, if the attributes do not meet the needs of your system, enter a new value in the Snoop Logging Parameters field.
If you specify your own value, be aware that the diagnostic tool collects data from the IBM webMethods Integration_directory /instances/instance_name/logs/snoop directory. If you change the log file location, the diagnostic utility might not import the data logged by the DataDirect Snoop tool. For more information about setting the DataDirect Snoop tool attributes, consult the documentation on the DataDirect website.
User: Database user for IBM webMethods Integration to use to connect to the database.
Password: Password for IBM webMethods Integration to use to connect to the database. If a password is not required, leave this field blank.
Minimum connections: Minimum number of connections the pool must keep open at all times. If you use this pool alias for more than one function, each pool instance keeps the specified number of connections open. For example, if you specify keeping at least 3 connections open, and the IS Core Audit Log and the Document History database components both use this pool, the pool keeps a total of 6 connections open - 3 for the IS Core Audit Log pool instance and 3 for the Document History pool instance. If your logging volume has sudden spikes, you can improve performance by making sure the connections needed to handle the increased volume open quickly. You can minimize connection startup time during spikes by setting this value higher, so that more connections remain open at all times.
Maximum connections: Maximum number of connections the pools can have open at one time. When the number of connection requests reaches this value, IBM webMethods Integration blocks the requests. Calculate this value as part of the total possible number of connections that could be opened simultaneously by all functions and applications that write to the database. Ensure that the total number does not exceed the connection limit of the database. If one of the applications opens more connections than the database allows, the database will reject subsequent requests for connections from any application. To continue the previous example, if Trading Networks also writes to the database and has a pool that could open up to 5 connections, you could specify only 17 as the maximum number of connections for the current pool. The IS Core Audit Log pool instance could use up to 17 connections, and the Document History pool instance could use the remaining 5 connections.
Available connections warning threshold(%): Number of connections, expressed as a percentage of Maximum Connections, that should be available in the pool at all times. When the number of connections falls to or is below this number, IBM webMethods Integration logs a message to the server log. If the number of connections later rises above this number, IBM webMethods Integration logs another message to the server log stating that the connection pool threshold has been cleared. To disable this threshold, set the value to 0.
Waiting thread threshold count: Maximum number of requests for connection that can be waiting at one time. When this number is exceeded, IBM webMethods Integration logs a message to the server log and starts a 5-minute interval timer. If the number of requests still exceeds this number at the end of the interval, IBM webMethods Integration logs another message to the server log. To disable this threshold, set the value to 0.
Idle Timeout(milliseconds): Period of time, in milliseconds, the pool can keep an unused connection open. After the specified period of time, the pool closes unused connections that are not needed to satisfy the Minimum connections value. The default expiration time is 60000 milliseconds.
Click Save.
Viewing Adapter Connections
In the Integration Runtimes page, click the runtime card for which you want to view connections.
Click Connections.
In the Connections page, click Configure database.
Name : Adapter connection name.
Adapter type : Adapter type. For example: JDBCAdapter, SAPAdapter.
Status : Adapter connection state indicating whether the connection is enabled or disabled.
Actions : List of actions you can perform on the adapter connection. Actions are:
Go to Integration Runtimes > Runtime Name > Connections.
Click the v icon prior to Adapter connections to view the connections.
In the Adapter connections section, click the icon corresponding to the connection you want to edit. The Adapter Type - Adapter Name page appears listing all the set configurations.
Note
You must disable the connection before editing.
Edit the required fields as per your needs in the Connection properties section.
Database: List of supported databases.
Driver Group: Driver group used to connect to the database. This lists the pre-bundled drivers available and the drivers uploaded in the Database Application. For more information, see Certified Databases and JDBC Driver Jars.
Transaction Type: Type of transaction supported by the account. The supported transaction types are:
LOCAL_TRANSACTION: Connection uses local transactions. With this transaction type, all operations performed on the same account within a single transaction boundary are either committed or rolled back together.
XA_TRANSACTION: Supports two-phase transactions executed across multiple databases. In one transaction boundary, all operations performed on multiple connections are committed or rolled back together. A transaction boundary means the scope of the transaction, from the beginning to the end of a transaction. The transaction can be in one adapter service, one flow service, one Java service, or several steps in a flow service.
Note
All the connections involved in a two-phase transaction must support the XA_TRANSACTION transaction type.
DataSource Class: Name of the JDBC driver’s DataSource class.
Server Name: Name of the server that hosts the database.
Note
If the tenant cannot connect to the cloud database, then check the security settings of the cloud database.
User: Username that the connection uses to connect to the database.
Password: Password for the username specified in the User field.
Database Name: Database name to which the connection connects.
Port Number: Port number that the connection uses to connect to the database.
Network Protocol: Network protocol that the connection uses when connecting to the database. Type TCP or TCPS to indicate the network protocol.
Other Properties: Other driver-dependent properties in the form of propertyName1=propertyValue1; propertyName2=propertyValue2;. You can add multiple properties separated by (;).
By default, the loginTimeout is set to 60. This value specifies the login timeout in seconds that a connection waits while attempting to connect to a database.
The <current catalog> represents the default catalog associated with an account.
The <current schema> represents the default schema associated with an account.
Some examples of other properties are:
Use this field to choose a property such as TableFilter. You can either select or type the TableFilter property in the dropdown list and enter the ‘’.‘Accounting’ in the input text field.
Use {} to configure a combination of multiple key-value pairs.
Edit the required fields as per your needs in the Connection manage properties section.
Enable Connection Pooling: Enable or disable the connection to use connection pooling. Supported values are:
True. Set to True to enable connection pooling if connection must use pooling.
False. Set to False to disable connection pooling.
Minimum Pool Size: Minimum number of connections to create if connection pooling is enabled. The number of connections you configure here are kept open regardless of whether these connections become idle.
Maximum Pool Size: Maximum number of connections that can exist at one time in the connection pool if connection pooling is enabled. For example, if you have a pool with Maximum Pool Size of 20 and you receive 30 simultaneous requests for a connection, then 10 requests will wait for a connection from the pool.
Pool Increment Size: Number of connections by which the pool is incremented if connections are needed, up to the maximum pool size. This is applicable if connection pooling is enabled.
Block Timeout (msec): Number of milliseconds that IBM webMethods Integration waits to obtain a connection with the database before it times out and returns an error. This is applicable if connection pooling is enabled. For example, if you set the Block Timeout to 5000, then 10 requests will wait for a connection for 5 seconds before they time out and return an error. If the services using the connections require 10 seconds to complete and return connections to the pool, the pending requests will fail and return an error message stating that no connections are available.
Note
If you set the Block Timeout value too high, you may encounter problems during error conditions. If a request contains errors that delay the response, other requests will not be sent. This setting must be tuned in conjunction with the Maximum Pool Size to accommodate such bursts in processing.
Expire Timeout (msec): Number of milliseconds that an inactive connection can remain in the pool before it is closed and removed from the pool. This is applicable if connection pooling is enabled. The connection pool will remove inactive connections until the number of connections in the pool is equal to the Minimum Pool Size. The inactivity timer for a connection is reset when the connection is used by the Database.
Note
If you set the Expire Timeout value too high, you may have a number of unused inactive connections in the pool. This consumes local memory and a connection on your backend resource. This could have an adverse effect if your resource has a limited number of connections.
If you set the Expire Timeout value too low, performance could degrade because of the increased activity of creating and closing connections. This setting must be tuned in conjunction with the Minimum Pool Size to avoid excessive opening/closing of connections during normal processing.
Startup Retry Count: Number of times that the system must attempt to initialize the connection pool at startup if the initial attempt fails. The default value is 0.
Startup Backoff Timeout: Number of seconds that the system must wait between attempts to initialize the connection pool.
Click Save connection.
Viewing CloudStreams Connections
Go to Integration Runtimes > Select a runtime > Connections.
Click the icon prior to CloudStreams connections to view the CloudStreams connections. The following details are displayed:
Name: Account name.
Application: Connector name and version.
Status: State indicating whether the account is enabled or disabled.
You cannot create a new CloudStreams connector or delete an existing CloudStreams connector from this page.
Editing a CloudStreams Connector
Go to Integration Runtimes > Select a runtime > Connections.
Click the icon prior to CloudStreams connections to view the CloudStreams connections.
Click the radio button in the Status field corresponding to the connection you want to edit to disable the account if enabled.
In the CloudStreams connections section, click the Edit icon, corresponding to the connection you want to edit. The Edit connection properties - Account Name page appears listing all the set configurations. You can view the editable properties and the default cloud runtime properties for each field.
Edit the required fields as per your needs in the Credentials, Connection Manager Properties, and Connection section.
For more details about the fields in each section, see the documentation for the respective Connectors.