IC80995: OPM PMGETLIST FAILS WITH -804 REASON CODE "103" WITH THE SQLLEN BEING A VALUE BIGGER THEN 2GB

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • The db2pesrv.log records the failure of the pmgetlist stored
    procedure:
    [35]Terminating :Error while taking history snapshot. PMGETLIST
    failed, rc=-804: snapproc.c 4993 -804 :SQL0804N The application
    program parameters for the current request are not valid. Reason
    code "103". If a host variable or SQLVAR in the SQLDA is invalid
    then: host variable/SQLVAR number = "10", SQLTYPE = "405",
    SQLLEN = "-1134934794", host variable/SQLVAR type = "INPUT".
    SQLSTATE=07002
    The sqllen converts to a value that is bigger then 2GB-512.
    This is an internal limit in DB2 for snapshot buffers.
    

Local fix

Problem summary

  • Closing PER in 4.1.1
    

Problem conclusion

  • Install Optim Performance Manager Fix Pack 4.1.1.1 or InfoSphere
    Optim Performance Manager Version 5.1 or later.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80995

  • Reported component name

    OPT PER MGR DB2

  • Reported component ID

    5724Y9400

  • Reported release

    411

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-24

  • Closed date

    2013-02-25

  • Last modified date

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

    OPT PER MGR DB2

  • Fixed component ID

    5724Y9400

Applicable component levels

  • R411 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Optim Performance Manager for DB2 for Linux, UNIX and Windows

Software version:

411

Reference #:

IC80995

Modified date:

2013-02-25

Translate my page

Machine Translation

Content navigation