IC62599: AUTO UPDATE STATS (AUS_EVALUATOR): POTENTIAL 1215 ERROR ON LARGESYSTEMS.

APAR status

• Closed as program error.

Error description

• For big systems the following can occur:
  
  When executing aus_evaluator (which is part of the Auto
  UpdateStats), some internal variables may be too small
  for    large systems.
  
  
      $: echo "EXECUTE FUNCTION aus_evaluator('t');" | dbaccess
     sysadmin
  
   Database selected.
  (expression)
  1215: Value exceeds limit of INTEGER precision
  Error in line 1
  Near character position 1
  Database closed
  
  Some variables set as type INTEGER should be set to BIGINT to
  avoid error 1215.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users with large system using AUS                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Some of the variables for some procedures are too small for  *
  * big systems.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC6 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC6.
  

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