JR32737: CAN NOT VIEW SHARED TABLE DEFINITIONS WHEN THERE ARE TOO MANY COLUMNS.

APAR status

• Closed as program error.

Error description

• 1) Login to Fasttrack
  2) Goto Metadata --> Metadata Repository
  3) Drill down through Host --> Database --> Schema
  4) Doubleclick on the Shared Table definition to view the
  columns.
  
  Once we click on the shared table definition, we don't get any
  response
  for more than an hour and the client just hangs.
  

Local fix

• In the Fast Track, you see mapping tab.Click on that
  see New Mapping specification or existing, on the right side,
  you will
  see data tab
  table- column.
  Now you can view columns and it's very fast
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users
  ****************************************************************
  PROBLEM DESCRIPTION:
  Performance problem if users expand a shared table that has
  large number of columns (about 3000 columns)
  ****************************************************************
  RECOMMENDATION:
  Apply fix from APAR JR32737
  Fixed in Information Server 81 FP1.
  ****************************************************************
  

Problem conclusion

• Improving the query performance
  Fixed in Information Server 81 FP1.
  

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:

Modules/Macros

• SERVER
  

Fix information

• Fixed component name

  INFO SRVR FASTT

• Fixed component ID

  5724Q36FT

Applicable component levels

• R810 PSN

     UP