JR61985: TO NOT QUERY FOR COLUMN METADATA OF THE TABLE ON WHICH WE ARE RUNNING THE SNOWFLAKE LOAD

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• If the snowflake user does not enough privileges to query for
  the column metadata ,then the query returns the metadata of all
  the tables on which the user actually has permission and this
  is hampering the performance.
  

Local fix

• has developer jar
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Snowflake Connector Users
  ****************************************************************
  PROBLEM DESCRIPTION:
  When Write mode = "Load from file" , a query to get the columns
  in the table is executed. This query is taking a long time if
  the Snowflake user does not have the right permissions to
  execute metadata operations.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR61985 on engine tier
  ****************************************************************
  

Problem conclusion

• Fixed Snowflake connector to not execute the get columns
  function.
  

Temporary fix

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB71 PSY

     UP