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

book

Article ID: 87858

calendar_today

Updated On:

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