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

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

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.1 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.1, FixPak 7
  

Temporary fix

Comments

APAR Information

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

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

  LI73942 LI73945

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSY

     UP