|
Problem IC62438
|
Status: Closed |
SYSIBMADM.OBJECTOWNERS REPORTS A SEQUENCE ALIAS AND A MODULE ALIAS AS OBJECT OF TYPE SEQUENCE AND MODULE RESPECTIVELY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Table aliases exist before DB2 V9.7, and for those objects
the administrative view SYSIBM.OBJECTOWNERS reports the type as
alias (not table).
DB2 V9.7 introduces sequence aliases and module aliases which
in DB2 V9.7 reports the type of those objects as sequence and
module respectively.
As of DB2 V9.7 Fix Pack 1 the administrative view
SYSIBM.OBJECTOWNERS will report the sequence alias and module
alias to be of type alias (not sequence and module
respectively). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* Table aliases exist before DB2 V9.7, and for those objects *
* *
* the administrative view SYSIBM.OBJECTOWNERS reports the type *
* as *
* alias (not table). *
* DB2 V9.7 introduces sequence aliases and module aliases *
* which *
* in DB2 V9.7 reports the type of those objects as sequence *
* and *
* module respectively. *
* As of DB2 V9.7 Fix Pack 1 the administrative view *
* SYSIBM.OBJECTOWNERS will report the sequence alias and *
* module *
* alias to be of type alias (not sequence and module *
* respectively). *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V97FP1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
DB2 V97FP1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.08.2009
29.12.2009
29.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
