Administering Data Gate for watsonx

The following information describes common tasks that an administrator performs to maintain a Data Gate for watsonx instance.

Working with Data Gate for watsonx
Working with Data Gate for watsonx includes accessing existing instances and by using the Overview, Monitor, Table, and Event tabs to monitor and make changes. The watsonx.data user interface includes an SQL interface for building and running SQL statements. It is called the query workspace. You can write or copy in your own SQL statements, or use templates to help building new SQL statements. In addition to running one-time execution SQL statements, you save SQL statements to a worksheet so that you can run them as often as needed later.
Managing user access to Data Gate for watsonx
As an administrator or creator of a Data Gate for watsonx instance, you can give other Cloud Pak for Data users access to the instance.
Updating passwords or secrets
Read instructions on how to change the user passwords for accessing the Db2® for z/OS® source database or the secret for accessing the target database service (Db2 or Db2 Warehouse).
Updating a data source definition
Connect to a data source to give Data Gate for watsonx access to the original data in Db2 for z/OS, VSAM, or IMS. You define a data source when you create (provision) an instance for the first time. In contrast to VSAM or IMS data sources, Db2 for z/OS data sources can be changed later.
Adding tables to Data Gate for watsonx
From the dashboard, you can always add tables to your configured Data Gate for watsonx instances.
Loading tables in Data Gate for watsonx
You can load Db2 for z/OStables individually from the Table tab of the Data Gate for watsonx instance dashboard. For VSAM or IMS tables, the behavior is different. Here, all identified tables are loaded when you start the synchronization process from the Overview tab of the dashboard.
Removing tables from Data Gate for watsonx
You can remove tables from a Data Gate for watsonx instance from the Table tab on the dashboard.
Enabling or disabling table synchronization
The tables list on the dashboard of your Data Gate for watsonx instance allows you to add or remove Db2 for z/OS tables individually from the synchronization process.
Viewing Data Gate for watsonx instance details
You might want to check the details of a provisioned instance for various reasons. To this end, you can open the details page from the Cloud Pak for Data main menu.
Monitoring a Data Gate for watsonx instance
The dashboard is displayed after the creation of an instance. You can also access the dashboard from the Cloud Pak for Data main menu. The dashboard gives you various pieces of information about your Data Gate for watsonx instance, such as the system availability, the table status, the replication latency, and throughput. The dashboard also allows you to add, load, and remove tables or to enable or disable synchronization. The dashboard is refreshed every minute.
Removing a Data Gate for watsonx instance
Delete a Data Gate for watsonx instance that you no longer need, or delete an instance to create a new instance with the same name.
Setting up client certificate authentication
Using a client certificate to authenticate to z/OS or Red Hat® OpenShift® is a convenient and secure way to authenticate because the users of connecting client application need not maintain IDs and passwords.
Collecting diagnostic information
To capture diagnostic information and write it to a file, you must enable Data Gate for watsonx tracing. You can enable tracing from the dashboard of your Data Gate for watsonx instance, or use one of the stored procedures available to Data Gate for watsonx in connection with Db2 for z/OS data sources.
Data Gate for watsonx stored procedures
The Data Gate for watsonx stored procedures provide the functionality for all interaction with Db2 for z/OS. Stored procedures are executed when you run Data Gate for watsonx functions from the Cloud Pak for Data user interface. However, you can also run the stored procedures stand-alone from z/OS or embed them in custom applications.