IBM Support

LI73942: ERROR SQL0901N WITH REASON "THE ENTITY IS NOT PART OF THIS RELATIONSHIP" WHEN TRYING TO CREATE A STORED PROCEDURE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When trying to create a stored procedure, the error SQL0901N may
    be returned with reason "The entity is not part of this
    relationship" and the Severe message below may be found in
    db2diag.log.
    
    SQL0901N  The SQL statement failed because of a non-severe
    system error. Subsequent SQL statements can be processed.
    (Reason "The entity is not part of this relationship".)  LINE
    NUMBER=43.  SQLSTATE=58004
    
    <db2diag.log>
    
    2008-11-14-12.30.16.699450-300 I29225505E809      LEVEL: Severe
    PID     : 22192                TID  : 183046802080PROC :
    db2agent (MARCH) 1
    INSTANCE: nypxt120             NODE : 001         DB   : MARCH
    APPHDL  : 1-1024               APPID: *N1.nypxt120.081114173008
    AUTHID  : MSDB2
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 43
     sqlerrmc: The entity is not part of this relationship
     sqlerrp : SQLNQ252
    
    
    <Trace Stack>
    
    0000002A9711D4B0 _ZN9sqlnq_qtb11box_drop_tsEiii + 0x0250
    
    (/ms/dist/ibmdb2/PROJ/ds/9.1.5.4/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1)
    0000002A9711D256 _ZN9sqlnq_qtb8box_dropEii + 0x0056
    
    (/ms/dist/ibmdb2/PROJ/ds/9.1.5.4/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1)
    0000002A9722F4C1 address: 0x0000002A9722F4C1 ; dladdress:
    0x0000002A958DC000 ; offset in lib: 0x00000000019534C1 ;
    
    (/ms/dist/ibmdb2/PROJ/ds/9.1.5.4/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1)
    0000002A972354A2
    _Z17sqlnq_psm_sem_actPP8stknode_i10actiontypePhP3loc + 0x5e9a
    

Local fix

  • No workaround for this problem.
    

Problem summary

  • Users Affected:
    ---------------
    DB2 V9.5 users
    
    Problem Description:
    --------------------
    User may receive SQL0901N with reason "The entity is not part of
    this relationship" when trying to create a stored procedure.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73942

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-12-08

  • Closed date

    2009-05-28

  • Last modified date

    2009-05-28

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

    LI73941

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
28 May 2009