JR53755: NETEZZA CONNECTOR QUERIES FOR ADMIN SCHEMA IN BULK METADATA IMPORT

InfoSphere Information Server, Version 11.5 for Linux
InfoSphere Information Server, Version 11.5.0.1 for Windows
InfoSphere Information Server, Version 11.5.0.2 for Linux
InfoSphere Information Server, Version 11.5.0.2 for AIX
InfoSphere Information Server, Version 11.5.0.2 for Windows
InfoSphere Information Server, Version 11.5.0.1 for AIX

APAR status

• Closed as program error.

Error description

• There are some hard coded references to ADMIN schema in the
  Bulk Metadata Import queries of Netezza Connector. Netezza
  Connector would fail to bulk import from those Netezza Servers
  in which the ADMIN schema is dropped.
  

Local fix

• Use Designer Client's Connector Import Wizard to do metadata
  import from Netezza Server's in which ADMIN schema is dropped.
  

Problem summary

• Netezza Connector looks for ADMIN schema in the Bulk Metadata
  Import. This poses a problem in the environment in which ADMIN
  schema doesn't exist.
  

Problem conclusion

• Code has been modified to refer DEFINITION_SCHEMA which cannot
  be dropped while querying for system tables or views.
  

Temporary fix

• ADMIN schema need to exist.
  

Comments

APAR Information

• 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

• R912 PSY

     UP

• RB30 PSY

     UP

• RB31 PSY

     UP