DB2 - Problem description
Problem IT15307 | Status: Closed |
DB2LOOK FAILS TO RETRIEVE SYSTEM-PERIOD TEMPORAL TABLE INFORMATION FROM DB2 Z/OS | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
In a case when on z/OS DB2 Server a system-period temporal table is defined, db2look from a LUW client will fail to retrieve the corresponding history table and the AS ROW BEGIN, AS ROW END, and AS TRANSACTION START ID attributes of the versioned source table. If db2look is run against a DB2 LUW database server with the same defined system-period temporal table, the result will be complete and as expected. This APAR affects only a db2look LUW client accessing a DB2 z/OS which both support system-period temporal tables. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to version 10.5 fix pack 9 * **************************************************************** | |
Local Fix: | |
Solution | |
first fixed in version 10.5 fix pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.05.2016 27.09.2017 27.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |