IBM Support

DAL010059. An error occurred while accessing the database: "SYSIBM.SYSTABLESPACE" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.26.14 Extended error description is: "SYSIBM.SYSTABLESPACE" is an undefined name.

Troubleshooting


Problem

QMF for Workstation and QMF for WebSphere v12.2.0.4 Fix Pack cannot be configured with Db2 database on AIX box to enable the users to work with QMF objects (Queries, Procedures and Forms) due to a bug in the 12.2.0.4 Fix Pack. The connection to the database works fine and the users should be able to list the database objects, such as tables and views, however the users would not be able to work (display, create new, or run existing Queries, Procedures and Forms).

Symptom

The following error is returned in QMF for Workstation and QMF for WebSphere v12.2.0.4 Fix Pack, when trying to upgrade the QMF Plugin, QMF Catalog, on an Db2 database on AIX box:

DAL010059. An error occurred while accessing the database: "SYSIBM.SYSTABLESPACE" is an undefined name..
SQLCODE=-204, SQLSTATE=42704, DRIVER=4.26.14 Extended error description is: "SYSIBM.SYSTABLESPACE" is an undefined name.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS6QWT","label":"IBM QMF Analytics for Multiplatforms"},"Component":"QMF For Workstation","Platform":[{"code":"PF033","label":"Windows"}],"Version":"QMF v10.1, QMF 12.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
20 July 2021

UID

ibm16455983