IBM Support

PM73785: DB2 - NOT ABLE TO RETRIEVE COMPANY DATA USING FGETVAL FUNCTION WHEN COMPANY SECURITY IS APPLIED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 version 9.7.400.501 When security company group was applied
    to user, fgetval function retrieved 0. Although the security
    group include all companies. If security company group is taken
    out, then data is retrieved fine.
    

Local fix

  • use a earlier version of DB2 eg: version 9.7.100..177
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM  Cognos Controller 10.1.1 FP2                 *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM73785

  • Reported component name

    COG CONTROLLER

  • Reported component ID

    5724W24CO

  • Reported release

    851

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-09-27

  • Closed date

    2013-04-25

  • Last modified date

    2013-04-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

    COG CONTROLLER

  • Fixed component ID

    5724W24CO

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 August 2024