IC65928: REMOTE QUERY WITH OUTER JOIN AND SUBQUERY WILL CRASH THE ENGINE IN REMOTE_SCAN_CREATE FUNCTION

APAR status

• Closed as program error.

Error description

• A remote query with outer join and sub-query will crash the
  engine in remote_scan_create function.
  
  Here is the stack:
  0x0896a000 (oninit)afstack ()
  0x0896d56f (oninit)mt_ex_throw_sig()
  0x0893e4ca (oninit)afsig_handler()
  0x08294dba (oninit)remote_scan_create()
  0x082a5705 (oninit)it_create()
  0x08494de5 (oninit)group_create()
  0x082a56d2 (oninit)it_create()
  0x082a880a (oninit)prepselect()
  0x082dd87f (oninit)subqprep()
  0x082a2896 (oninit)scan_next()
  0x084942e5 (oninit)join_next()
  0x082b7b21 (oninit)sort_open()
  0x082a8b7d (oninit)prepselect()
  0x083b7244 (oninit)open_cursor()
  0x083c8e92 (oninit)sql_open()
  0x083c8eee (oninit)sq_open ()
  0x0843da51 (oninit)sqmain  ()
  0x089c7cbe (oninit)spawn_thread()
  0x0894b6de (oninit)startup ()
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of 11.50 and earlier versions.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ISTAR queries involving joining a local table and a remote   *
  * table may result in server crash during query execution if   *
  * the following conditions are met:                            *
  *  -  the remote table has a composite index                   *
  *  - an "IN <subquery>" or "= ANY <subquery>" predicate is on  *
  * an index column                                              *
  *  - the subquery involves tables on the same remote server as *
  * the remote table in the main query                           *
  *  - a join column (with a local table) is on a different      *
  * index column                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC7.                                        *
  ****************************************************************
  

Problem conclusion

• The problem is fixed in 11.50.xC7.
  

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:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP