DB2 SQL Agents doesn't return Labels correctly after or since JDBC Version 4.

Products

• CA Automic Workload Automation - Automation Engine
• Automic SaaS

Issue/Introduction

An SQL query that sets a label for a column name returns the result with the column name instead of the label. Starting from DB2 JDBC version 4, it is no longer possible to set a label via an SQL query.

It still worked with version 3.68.61.

The behavior of the IBM JDBC DB2 driver has changed since version 4. This change is also documented by IBM on the following page.

Examples of ResultSetMetaData.getColumnName and ResultSetMetaData.getColumnLabel values

The query via IBM Data Studio returns the following result:

The Database agent shows the following result:

 

Environment

Automic Workload Automation 24.X.X.

Cause

Issue.

Resolution

Component: Agent SQL

Automic Automation Engine 24.4.1 - Available

The job report now shows the label:

Public Title:
SQL-Agent does not return labels correctly 

Public Description:
A problem has been fixed where the labels are correctly returned by the SQL-Agent

Additional Information

Update to a fixed version listed below or a newer version if available.

Article title: How to register to Broadcom Software Product updates and Critical Alerts

https://knowledge.broadcom.com/external/article?articleId=133819

Defect ID: DE170167