Data Management

 View Only

Simplify and automate Db2 SQL Data Insights operations with its new REST API and shell CLI

By Guanjun Cai posted 23 days ago

  


By Jason Cu, Db2 for z/OS Development, and Guanjun Cai, Db2 for z/OS Content Design

Do you use Db2 SQL Data Insights (SQL DI) but want to boost your operational efficiency? 

Your SQL DI application is tapping deeply into your Db2 data and revealing patterns across data points that are otherwise not discoverable. Your business landscape is constantly changing, and your Db2 data is rapidly growing. To keep the real-time insights from SQL DI reliable, you plan to retrain the models as frequently as needed to ensure their accuracy. But manual and repeated model retraining can be laborious, time-consuming, and costly. As a result, you put your plan on hold.

Wait no more! Introducing the REST application programming interface (API) and the shell command line interface (CLI) of SQL DI.

Db2 continuously releases new and enhanced functionalities as they become available. One of the most recent deliveries is the REST API and shell CLI support for SQL DI. The REST API is OpenAPI-compliant, and the shell CLI is text-based, both of which are powerful yet easy to use. You can issue API calls from a browser, a REST API client, or an application framework like IBM watsonx while you can invoke shell commands through a shell script, a USS session, or a JCL job.

With the REST API and the shell CLI, you can dramatically simplify or automate most of your SQL DI operations. The operations include, but are not limited to, installing and configuring a SQL DI instance, administering its server settings, creating and managing connections to Db2, creating and managing AI objects, training and retraining object models, and deploying retrained models. The simplification and automation can help you minimize the time and effort to get SQL DI up and running, optimize its server settings based on your workload, keep your object models accurate over time, and manage other frequent operations in the most effective and efficient way. The reduced manual intervention and the increased operational efficiency enable you to focus your resources on unlocking the potential of your Db2 data and discovering actionable insights that can help you deliver client-delighting solutions and services.

Learn more about Db2 SQL DI and its REST API and shell CLI.

A special thank-you to Akiko Hoshikawa, Distinguished Engineer, Db2 for z/OS and AI Product Development, for her contributions.


#Db2Z
#db2z/os
#Db2 for z/OS


#Highlights-home
0 comments
26 views

Permalink