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

Document ID : KB000087858
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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
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