PH11052: PERFORMANCE ISSUE WITH IMPACT ANALYSIS

readme
RAAInstall
RAAInstallRepository
RAAzInstall
RAAzInstallRepository
readme
RAAInstallRepository
RAAzInstall
RAAzInstallRepository
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
Rational Asset Analyzer Fix Pack 23 (6.1.0.23) for 6.1

APAR status

• Closed as program error.

Error description

• This SQL is taking an average of 2.4 seconds to complete and
  using .87
  seconds of CPU. The DMH_DD_CONCAT table has 6.7 million rows on
  it.
  
  SELECT count(*)
  FROM DMH1.dmh_dd_concat dd
  WHERE (UCASE(dd.dd_name) = 'LAST-POL-NBR-ASSIGNED')
  
  DYN/STAT SECT STMT SQL +----- TOTAL IN-SQL TIME -----+
  GET-PROGRAM STMT TYPE NO. NO. CALLS ELAPSED % CPU PAGES
  -------- ---------- ---- ------ ----- ---------------
  ---------------------
  + SYSLN100 D CURSOR 0 0 13450 9:17:22.789 70 3:15:38.167 70
  92526K
  AVERAGES: 00:02.48645 00:00.87273 6879
  HIGHS: 00:13.42957 00:02.09016 13859
  LOWS: 00:00.00002 00:00.00003 0
  

Local fix

• n.a
  

Problem summary

• Impact analysis is slow because of suboptimal query over
  DMH_DD_CONCAT with 6.7M rows.
  

Problem conclusion

• Replaced the query that that searches for DMH_DD_CONCAT.DD_NAME
  so that it can make use of the index on DD_NAME.
  

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

  RATL ASSET ANAL

• Fixed component ID

  5724V2700

Applicable component levels

• R610 PSY

     UP