APAR status
Closed as program error.
Error description
Problem: Netezza connector is not able to import metadata from the database with disabled support for multiple schema and schema name changed from its default value. Details: When Netezza is configured with multiple schema support disabled, the default schema name is the same as the owner name. Also, renaming the schema is not allowed in such case. However, user is able to temporarily enable multi schema support, rename the schema, and disable multi schema support back again. The connector is not handling such scenario correctly in its querying the database. Resolution: The multiple schema support option is available since Netezza 7.0.3 release. Instead of checking support option value, connector checks Netezza database version. For pre-7.0.3 releases, schemas have always default names. For 7.0.3 and further releases, querying the database always considers the case of multi schema support enabled.
Local fix
Define schema name same as the schema owner.
Problem summary
**************************************************************** USERS AFFECTED: IMAM users importing metadata using Netezza connector **************************************************************** PROBLEM DESCRIPTION: Netezza connector is not able to import metadata from the database with disabled support for multiple schema and schema name changed from its default value. **************************************************************** RECOMMENDATION: Install patch JR58392 ****************************************************************
Problem conclusion
The multiple schema support option is available since Netezza 7.0.3 release. Instead of checking support option value, connector checks Netezza database version. For pre-7.0.3 releases, schemas have always default names. For 7.0.3 and further releases, querying the database always considers the case of multi schema support enabled.
Temporary fix
N/A
Comments
APAR Information
APAR number
JR58392
Reported component name
INFO SRVR PLATF
Reported component ID
5724Q3612
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-09-08
Closed date
2017-10-25
Last modified date
2017-10-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFO SRVR PLATF
Fixed component ID
5724Q3612
Applicable component levels
RB50 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 October 2017