PK14949: ABEND04E RC00E70005 DSNXEFDA :M130. CALLER IS DSNXOSEQ. EXPECTING SQLCODE551 FROM DSNXOSEQ LOC 150 FOR SET STATEMENT.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABND=04E-00E70005,U=CTTXR   ,M=(N),C=810.SCC -BINDPKG
    LOC=DSNXGRDS.DSNXEFDA:M130 occurred during the BIND of
    this SQL statement:
    SET : H = NEXTVAL FOR ID_NOTICE_SEQ
    referencing a sequence object.
    SQLCODE551 from DSNXOSEQ loc 150 is expected.
    

Local fix

  • Resolve the authorization issue to bypass the abend.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 R810 users                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E70005 DSNXEFDA :M130      *
    *                      WHEN SQLCODE551 IS EXPECTED FOR A       *
    *                      SET STATEMENT                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    ABEND04E RC00E70005 DSNXEFDA :M130 occurred when DB2
    was issuing SQLCODE -551 for usage of a sequence object
    in the SET host variable statement.
    

Problem conclusion

  • DB2 is modified to generate SQLCODE -551 correctly when
    authorization failure is encountered during sequence
    processing.
    
    Additional Keywords: SQLHOSTVAR SQLCODE551
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK14949

  • Reported component name

    5740 IBM DATABA

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-11-09

  • Closed date

    2005-11-28

  • Last modified date

    2006-01-04

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK09504

Modules/Macros

  • DSNXOSEQ
    

Fix information

  • Fixed component name

    5740 IBM DATABA

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK09504

       UP05/12/15 P F512

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

8.0

Reference #:

PK14949

Modified date:

2006-01-04

Translate my page

Machine Translation

Content navigation