IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR32737

  • Reported component name

    INFO SRVR FASTT

  • Reported component ID

    5724Q36FT

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-17

  • Closed date

    2009-05-04

  • Last modified date

    2009-12-17

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSX3EG","label":"InfoSphere FastTrack"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 December 2009