A fix is available
APAR status
Closed as new function.
Error description
This APAR provides a new DB Record Length Distribution Report. The enhancement is being implemented as a result of FITS requirement MR0425125719.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of HPFPU Fast Path Advanced Tools * * and Fast Path Online Tools in Fast Path * * Solution Pack Version 1 Release 3 (FMID: * * HAHQ130). * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides DB Record * * Length Distribution Report and new * * keyword DBRLDIST. * * * * New report is generated by - FPA * * - FPA ANALYZE, CHANGE, RELOAD, REORG * * TUNE with DBRLDIST=YES keyword. * * - FPO ANALYZE and REORG with * * DBRLDIST=YES keyword. * **************************************************************** * RECOMMENDATION: Apply the maintenance for this APAR. * **************************************************************** The APAR is made for DB Record Length Distribution Report. New report is generated by - FPA ANALYZE with the REPORT subcommand and the PTRCHKLVL=FULL keyword. - FPA CHANGE with the REPORT subcommand andthe PTRCHKLVL=FULL keyword. - FPA RELOAD with the REPORT subcommand and the PTRCHKLVL=FULL keyword. - FPA REORG with the REPORT subcommand and the PTRCHKLVL=FULL keyword. - FPA TUNE with the REPORT subcommand and the PTRCHKLVL=FULL keyword. - FPO ANALYZE with the REPORT subcommand and the TYPRUN=RPT, FULLSTEP=YES keyword. - FPO REORG with the REPORT subcommand and the TYPRUN=RPT, FULLSTEP=YES, PTRCHK=YES, and CHKUOW=ALL keyword. The following enhancement is became effective with DBRLDIST=YES keyword. 1. Print DB Record Length Distribution Report which reports useful DB record information for database tuning. 2. Provide (@) mark next to DB RECORD PROFILE ANALYSIS at DB RECORD PROFILE REPORT when print DB Recordt Length Distribution Report. This enhancement is being implemented as a result of following RFE requirement: - RFE 32585
Problem conclusion
Temporary fix
Comments
======================== = DOCUMENTATION CHANGE = ======================== The IMS Fast Path Solution Pack for z/OS Version 1 Release 3 IMS High Performance Fast Path Utilities User's Guide. > Analyzing a DEDB offline with FPA >> Utility control statements for the Analyze process Add DBRLDIST keyword at REPORT subcommand keywords as follows: DBRLDIST: An optional keyword to specify whether to generate the DB Record Length Distribution Report. > FPA subcommands >> DBRLDIST DBRLDIST Use the DBRLDIST keyword to specify whether to generate the DB Record Length Distribution Report. DBRLDIST is an optional keyword for the following command: - REPORT Related keyword: NONE Format: +-------------------------------------------+ | | | >>---DBRLDIST=(YES|NO)--->< | | | +-------------------------------------------+ parameter parameter can be one of the following values: YES: Print DB Record Length Distribution Report for areas specified with IAREA only. DBRLDIST=YES is effective only PTRCHKLVL=FULL is specified. NO : Do not print DB Record Length Distribution Report. Default: DBRLDIST=NO Site default support: Yes > DEDB AREA ANALYSIS REPORTS >> DB RECORD PROFILE ANALYSIS The following description is added: Provide (@) mark next to DB RECORD PROFILE ANALYSIS when DBRLDIST=YES. > Sample reports of FPA Add DB Record Length Distribution Report under Analyze, Change, Reload, and Reorg. > Sample reports of FPA >> DB Record Length Distribution Report The optional report for DB record analysis provides distribution expressed in (CI size) / 20. The reported database record length includes the size of the segment prefix and the size of the segment data as stored on DASD (for compressible segments, the size of the segment after compression). The table contains the number, the percentage, and the accumulated percentage, of database records that are in the following ranges of database record length: - Less than or equal to the 1/20th of CI size - 1/20th - 2/20th of CI size - 2/20th - 3/20th of CI size - And so on The DB Record Length Distribution Report can be used to: - Find distribution condition of DB records by asterisks at DISTRIBUTION OF DB RECORD LENGTHS (PCT) column. This report is generated by the following commands: - FPA ANALYZE with the REPORT subcommand and the PTRCHKLVL=FUL - FPA CHANGE with the REPORT subcommand and the PTRCHKLVL=FULL - FPA RELOAD with the REPORT subcommand and the PTRCHKLVL=FULL - FPA REORG with the REPORT subcommand and the PTRCHKLVL=FULL - FPA TUNE with the REPORT subcommand and the PTRCHKLVL=FULL For the sample of DB Record Length Distribution Report, see http://www-01.ibm.com/support/docview.wss?uid=swg27041865 > Analyzing a DEDB online with FPO >> Utility control statements for OPC Add DBRLDIST keyword at REPORT subcommand keywords as follows: DBRLDIST: YES: NO: An optional keyword to specify whether to generate the DB Record Length Distribution Report. > Analyzing a DEDB online with FPO >> Output for OPC >>> FPXRPTS DD data set Add DB Record Length Distribution Report under "When the TYPRUN=RPT keyword and the FULLSTEP=YES keyword are specified, the following reports are produced in the data set or in the output stream depending on the REPORTDD keyword of the REPORT control statement: " and the link to subsection of DB Record Length Distribution Report. New subsection for DB Record Length Distribution Report is added as follows: - DB Record Length Distribution Report This report contains the DB Record information. The report is produced by the Analyze function of FPA, which is called by OPC internally when TYPRUN=RPT and FULLSTEP=YES is specified. > FPO keywords >> DBRLDIST DBRLDIST Use the DBRLDIST keyword to specify whether to generate the DB Record Length Distribution Report. DBRLDIST is an optional keyword for the following command: - REPORT Related keyword: NONE Format: +-------------------------------------------+ | | | >>---DBRLDIST=(YES|NO)--->< | | | +-------------------------------------------+ parameter parameter can be one of the following values: YES: Print DB Record Length Distribution Report. You can specify just Y rather than YES. Y is effective only when TYPRUN=RPT and FULLSTEP=YES are specified. For OER, PTRCHK=YES and CHKUOW=ALL are also required. NO : Do not print DB Record Length Distribution Report. You can specify just N rather than NO. Default: DBRLDIST=NO Site default support: Yes > FPO reports stored in IMS Tools KB The following information is added under Table 132. OPC/DB Record Length Distribution Report/Y
APAR Information
APAR number
PI14356
Reported component name
IMS FP SOLUTION
Reported component ID
5655W1400
Reported release
130
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2014-03-24
Closed date
2014-05-20
Last modified date
2014-06-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI18137
Modules/Macros
FPXATO00 FPXAURT0 FPXUCKE0 FPXUCPR0 FPXXRGE0 HAHQ130J HFPA5DR0 HFPA5DS0 HFPA5EA0 HFPA5IN0 HFPA5LR0 HFPA5PF0 HFPA5T10 HFPA5T30 HFPA5W00 HFPA5000 HFPCCDT0 HFPCDEF0 HFPGHKI0 HFPGPRS0 HFPLRST0 HFPQA5I0 HFPQA500 HFPUMCT0 HFPUMVT0 HFPUROB0
Fix information
Fixed component name
IMS FP SOLUTION
Fixed component ID
5655W1400
Applicable component levels
R130 PSY UI18137
UP14/05/22 P F405
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"130","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCV35A","label":"IMS Fast Path Solution Pack"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"130","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 June 2014