IC61048: RUNNING A SIMPLE SELECT WITH A SUB SELECT AND GETTING ERROR -768INTERNAL ERROR IN ROUTINE AJ_ATTJL

APAR status

• Closed as program error.

Error description

• Running a simple select with a sub select returns a -768
  internal error in routine aj_attjl
  
  select tap.as_of_datetime, tap.nike_fund_id, tap.preadd_qty
  , exists (
     select 1 from refr_share rs
     join security_hist sh2
       on sh2.nike_secrty_id = rs.nike_secrty_id
       and sh2.history_nbr = 0
       and sh2.secrty_class = 'DEBT'
     where rs.nike_fund_id = tap.nike_fund_id //does not work
    // where rs.nike_fund_id = tc.nike_fund_id   //works
     and rs.as_of_date =
        (select max(rs2.as_of_date)
         from refr_share rs2
         where rs2.nike_fund_id = rs.nike_fund_id
         and rs2.nike_secrty_id = rs.nike_secrty_id
         and rs2.as_of_date <= date(tap.as_of_datetime)) //does
  not work
         //and rs2.as_of_date <= date(tc.as_of_datetime))  //works
     and rs.qty is not null
    ) has_treasury
  from trust_add_position tap
  join trust_cash tc
   on tc.nike_fund_id = tap.nike_fund_id
   and tc.as_of_datetime = tap.as_of_datetime
  where tap.as_of_datetime = '2009-04-21 16:00:00.000'
  and tap.nike_fund_id = 5986
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users running a query which involves ansi-join with a    *
  * subquery with filters that can be promoted.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query which involves an ansi-join with a filter that uses  *
  * a subquery with a filter which can be promoted might return  *
  * -768 error.                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC5 or above                            *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC5.
  

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 PSY

     UP