Usage Statistic Tool did not work with old versions of the DB2 database

Article Id: 87858

Status: Published

Updated On: 15-04-2018 08:01

Legacy Id: 000008857

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

Error Message :
U0003592 UCUDB - Status: '54048' NativeError: '-1585' Msg: ' SQL1585N A system temporary table space with sufficient page size does not exist.

1. Description
Usage Statistics Tool (ucybdblc) fails with following errormessage:

U0003590 UCUDB - DB-Fehler: 'SQLExecDirect', 'ERROR ', '54048', ' SQL1585N A system temporary table space with sufficient page size does not exist. SQLSTATE=54048'
20160511/134112.963 - U0044008 Es ist ein Fehler beim Erstellen der Ausgabedateien aufgetreten.

Customer was already in contact with IBM, stating his message it seems that our SQL scripts are not working correctly and need to be looked at.

The following statements seems to have a problem:
Automic_Agents_FTP_Usage_db2.sql
Automic_Agents_SAP_Usage_db2.sql
Automic_Agents_WS_Usage_db2.sql

Cause:

Cause type:
Defect
Root Cause: DB2 version below 10.0

Environment:

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution:

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Utilities 11.2.2 of Automation.Engine - already available
Utilities 11.1.3 of Automation.Engine - already available

Additional Information:

Workaround :
N/A