PH53410: 1) SMF SQL GIVES VARYING NUMS OF ROWS FOR SAME SMF DATA AND SQL 2) SMF_09902 NOT DISPLAYED IN IBM DATA STUDIO

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SMF SQL gives varying numbers of rows for same SMF data and SQL
  
  ERRORS "DATA TYPE NOT SET FOR COLUMN SMF_LEN IN TABLE SMF_09902"
  ACCESSING SMF_09902, SMF_09902 NOT DISPLAYED IN IBM DATA STUDIO
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH53410                                 *
  *                      SMF SQL gives varying numbers of rows   *
  *                      for same SMF data and SQL               *
  *                      Wrong mapping in SMF Type 99 Subtype 2  *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH53410
  SMF SQL gives varying numbers of rows for same SMF data and SQL
  Wrong mapping in SMF Type 99 Subtype 2
  

Problem conclusion

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:

  UI93775

Modules/Macros

• HLV$632E HLV$632M HLV$M320 HLV$M321 HLV$M322 HLV$M323 HLV$M324
  HLV$M325 HLV$M326 HLV$M327 HLV$M328 HLV$M329 HLV$M32A HLVCWRIT
  HLVOBRIS HLVSQ29D HLVSQ29N HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN
  HLVSQ2CD HLVSQ2CN HLVSQ2DD HLVSQ2DN HLVSQL9D HLVSQL9N HLVSQLAD
  HLVSQLAN HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN HLVSQLDD HLVSQLDN
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI93775

     UP23/09/29 P F309

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.