IBM Support

SI47594 - OSP-ADDF Add SQL metrics to Collection Services *JOBMI

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-ADDF Add SQL metrics to Collection Services *JOBMI


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF56163   00/00    0000
PRE  5770999  710  MF54938   00/00    0000
CO   5770SS1  710  SI39791   00/00    0000
DIST 5770SS1  710  SI48100   00/00    0000



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.


APAR Error Description / Circumvention

-------------------------------------------------
Job related SQL performance metrics were added to Collection
Services as part of the *JOBMI collection category and new
fields were added to the QAPMJOBMI database file.

CORRECTION FOR APAR 'SE52837' :
-------------------------------
The new SQL performance data will be collected as part of the
*JOBMI collection category.  An updated template file for
QAPMJOBMI will be shipped in QSYS with the additional fields.
This template file will only be used when creating a new
QAPMJOBMI file in libraries where it doesn't already exist.
Existing collection libraries (for example, QPFRDATA) that
contain a prior version of QAPMJOBMI will not be affected by the
PTF.

CIRCUMVENTION FOR APAR 'SE52837' :
----------------------------------
None.


Activation Instructions


None.




Special Instructions

To update the QAPMJOBMI file in libraries where an existing version of
the file already exists, follow these directions after applying or
removing this PTF:

For each existing library you wish to update:
1) If the collection library you are updating is your current
collection library, the CRTPFRDTA job must be ended.
ENDPFRCOL FRCCOLEND(*YES)

2) Move each of the following files, if it exists, to a backup library.
Note: migrating logical file members will not work if you just rename.
MOVOBJ OBJ(col-lib/QAPMJOBMI) OBJTYPE(*FILE) TOLIB(your-backup)
MOVOBJ OBJ(col-lib/QAPMJOBL) OBJTYPE(*FILE) TOLIB(your-backup)
MOVOBJ OBJ(col-lib/QAPMJOB2) OBJTYPE(*FILE) TOLIB(your-backup)
MOVOBJ OBJ(col-lib/QAPMJMIX1) OBJTYPE(*FILE) TOLIB(your-backup)
MOVOBJ OBJ(col-lib/QAPMJMIX2) OBJTYPE(*FILE) TOLIB(your-backup)

3) Create a copy of the new QAPMJOBMI file in the collection library.
CRTDUPOBJ OBJ(QAPMJOBMI) FROMLIB(QSYS) OBJTYPE(*FILE) +
TOLIB(col-lib)

4) Copy all existing members from the original QAPMJOBMI file in your
backup library to the new file in the collection library.
CPYF FROMFILE(your-backup/QAPMJOBMI) TOFILE(col-lib/QAPMJOBMI) +
FROMMBR(*ALL) TOMBR(*FROMMBR) MBROPT(*REPLACE) FMTOPT(*MAP *DROP)

5) Create a copy of each of the following QAPMJOBL, QAPMJOB2,
QAPMJMIX1, and QAPMJMIX2 logical files that you moved in step 2 in your
collection library. This will remap the based-on physical file to
QAPMJOBMI in the collection library and copy all the logical file
members.
CRTDUPOBJ OBJ(QAPMJOBL) FROMLIB(your-backup) OBJTYPE(*FILE) +
TOLIB(col-lib) DATA(*YES)
CRTDUPOBJ OBJ(QAPMJOB2) FROMLIB(your-backup) OBJTYPE(*FILE) +
TOLIB(col-lib) DATA(*YES)
CRTDUPOBJ OBJ(QAPMJMIX1) FROMLIB(your-backup) OBJTYPE(*FILE) +
TOLIB(col-lib) DATA(*YES)
CRTDUPOBJ OBJ(QAPMJMIX2) FROMLIB(your-backup) OBJTYPE(*FILE) +
TOLIB(col-lib) DATA(*YES)

Note: you should delete your saved logical files in the backup library.
These logical files are still based on the QAPMJOBOS file in your
collection library and will prevent normal deletion of existing
collections.

6) Restart performance data collection if you ended it in step 1 above.
STRPFRCOL

The instructions above are based on only those files and file
relationships shipped with the operating system. It is your
responsibility to handle any additional files, tables, and access paths
that are dependent on files replaced by this PTF. You can determine if
any additional dependencies exist by examining the output of the
following command:
DSPDBR FILE(your-lib/QAPMJOBMI)

********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI47720 :
=================================================

If you are not impacted by the function added, no action is required.

If you need this function in existing collection libraries, you must
follow these instructions to update them.

For each existing library you wish to update:
1) If the collection library you are updating is your current
collection library, the CRTPFRDTA job must be ended.
ENDPFRCOL FRCCOLEND(*YES)

2) Move the existing files to a backup library
Note: migrating logical file members will not work if you rename.
MOVOBJ OBJ(col-lib/QAPMPOOLB) OBJTYPE(*FILE) TOLIB(your-backup)
MOVOBJ OBJ(col-lib/QAPMPOOLL) OBJTYPE(*FILE) TOLIB(your-backup)

3) Create a copy of the new QAPMPOOLB file in the collection library.
CRTDUPOBJ OBJ(QAPMPOOLB) FROMLIB(QSYS) OBJTYPE(*FILE) +
TOLIB(col-lib)

4) Copy all existing members from the original QAPMPOOLB file in your
back-up library to the new file in the collection library.
CPYF FROMFILE(your-backup/QAPMPOOLB) TOFILE(col-lib/QAPMPOOLB) +
FROMMBR(*ALL) TOMBR(*FROMMBR) MBROPT(*REPLACE) FMTOPT(*MAP)

5) Create a copy of the saved QAPMPOOLL file from step 2 in your
collection library. This will remap the based-on physical file to
QAPMPOOLB in the collection library and copy all the logical file
members.
CRTDUPOBJ OBJ(QAPMPOOLL) FROMLIB(your-backup) OBJTYPE(*FILE) +
TOLIB(col-lib) DATA(*YES)

Note: you should delete your saved QAPMPOOLL file in the backup
library. This logical file is still based on the QAPMPOOLT file in your
collection library and will prevent normal deletion of existing
collections.

6) Restart performance data collection if you ended it in step 1 above.
STRPFRCOL

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI44117 :
=================================================

After applying or removing this PTF the Collection Services collector
job (QYPSPFRCOL) must be ended and restarted for the change to take
effect.

1. To end Collection Services enter the following on the command
line:
ENDPFRCOL FRCCOLEND(*YES)

2. To start Collection Services enter the following on the command
line:
STRPFRCOL

Before restarting Collection Services, you should consider other
functions that may be using data provided by Collection Services. Such
functions may be impacted when Collection Services is ended. Error
messages may be produced and the affected functions may need to be
restarted.

Examples of functions that are dependent on Collection Services include
Management Central monitors and applications that use the performance
collector APIs QPMWKCOL and QPMLPFRD. If applications are using the
performance collector APIs, you will find server jobs QPMASERV and
QPMACLCT active on your system.

If the messages continue to be issued after the application of the PTF,
the existing members in the QAPMSYSPRC file need to be renamed, the
Q1PDR job submitted and then the members renamed back to the original
names so they will be cleaned up by the normal processing.  To do this,
do the following:

1) Determine the collection library name:
- CFGPFRCOL and press F4=Prompt
(Note the Collection Library name).

2a) If PDM is installed on the system, use the following instructions
to rename members:
- WRKMBRPDM FILE(LibraryName/QAPMSYSPRC)
(Note the name of each of the members as they will need to be
renamed back to the  original name)
- Select option 7=Rename next to each to rename

2b) If PDM is not installed on the system, use the following
instructions to rename members:
- DSPFD FILE(LibraryName/QAPMSYSPRC) TYPE(*MBRLIST) OUTPUT(*PRINT)
- WRKSPLF and press <ENTER>
- Locate the last spooled file named QPDSPFD and take option
5=Display
(Note the name of the members, then rename)
- RNMM FILE(LibraryName/QAPMSYSPRC) MBR(Q123456789)
NEWMBR(Q12345678X)

3) Once all members are renamed, manually submit the Q1PDR job:
- GO PM400
- Select option 2. Work with Automatically Scheduled Jobs
- Select option 2=Change next to the Q1PDR job
- Specify the Next run date as yesterday's date and press <ENTER>

4) Monitor the Q1PDR job for any errors.

5) If the Q1PDR job completes successfully, rename the members back to
the original names so they will be cleaned up with the clean up
process.  Use WRKMBRPDM or RNMM instructions above to do so.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37184 :
=================================================

1. If the Management Central server job (QYPSJSRV) is active, it
must be ended by executing the following command:
- ENDTCPSVR SERVER(*MGTC)

2. End any host remote command server jobs that might have been
used by Management Central:
- ENDHOSTSVR SERVER(*RMTCMD)

3. Check to see if the QPMASERV and QPMACLCT jobs ended. If they
did not end, then use the ENDJOB command to end them.

4. If host servers were ended in step 2,  restart them:
- STRHOSTSVR SERVER(*RMTCMD)

5. If the Management Central server job (QYPSJSRV) was ended in
step 1, restart it:
- STRTCPSVR SERVER(*MGTC)

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI41758 :
=================================================

After applying or removing this PTF the Collection Services collector
job (QYPSPFRCOL) must be ended and restarted for the change to take
effect.

1. To end Collection Services enter the following on the command line:
ENDPFRCOL FRCCOLEND(*YES)

2. To start Collection Services enter the following on the command
line:
STRPFRCOL

Before restarting Collection Services, you should consider other
functions that may be using data provided by Collection Services. Such
functions may be impacted when Collection Services is ended. Error
messages may be produced and the affected functions may need to be
restarted.

Examples of functions that are dependent on Collection Services include
Management Central monitors and applications that use the performance
collector APIs QPMWKCOL and QPMLPFRD. If applications are using the
performance collector APIs, you will find server jobs QPMASERV and
QPMACLCT active on your system.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI39804 :
=================================================

After applying or removing this PTF, do the following:

Stop Collection Services.  Enter the following on the command line:
ENDPFRCOL FRCCOLEND(*YES)

Start Collection Services.  Enter the following on the command line:
STRPFRCOL

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI36988 :
=================================================

The Collection Services collector job (QYPSPFRCOL) must be ended and
restarted for this change to take effect. To end Collection Services,
enter the following on the command line:
ENDPFRCOL FRCCOLEND(*YES)

To start Collection Services, enter the following on the command line:
STRPFRCOL


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI47720      OSP QAPMPOOLB cannot report pool sizes greater than 1TB
   SI45848      OSP New fields for Active Memory Deduplication in QAPMSHRMP
   SI44997      OSP -INCORROUT CRTPFRDTA file QAPMBUSINT
   SI44117      OSP-OTHER-T/Q1PDR2U-MSGMCH1210 Q1PDR job fails
   SI43661      OSP Collection Services support for future enhancements
   SI43505      OSP-T/QPMDJOBM-MSGMCH1210 CRTPFRDTA PRORJOBMI procedure
   SI42887      OSP-MSGMCH1210-T/QPMDJOBM CRTPFRDTA fails
   SI42881      OSP-MSGCPF7306-T/QPMBODBF CRTPFRDTA job fails
   SI42820      OSP-T/QPMDJSUM-MSGMCH1210 CRTPFRDTA procedure CALCBUCK
   SI42181      OSP-T/QPMDJOBM-MSGMCH1210 CRTPFRDTA PROCESS_DATA procedure
   SI42181      OSP-T/QPMDJOBM-MSGMCH1210 CRTPFRDTA PRROJOBM procedure
   SI41758      OSP Collection Services support for future enhancements
   SI41758      OSP-INCORROUT Memory amount in QAPMCONF file GKEY ' 4'
   SI40733      OSP-INCORROUT Base Function to Enable Future Extensions
   SI39804      OSP-INCORROUT Base Function to Enable Future Extensions
   SI38703      OSP-OTHER-T/QPMPLPAR -MSGMCH0601 job QYPSPFRCOL
   SI37376      OSP-F/QPMDBUS-MSGMCH0601 CRTPFRDTA more than 256 buses
   SI36988      OSP-INCORROUT QAPMLPARH ONLY CONTAINS DATA FOR 4 LPARS
   SI37780      OSP-MSGCPF5129-T/QPMDJVM CRTPFRDTA fails on file QAPMJVM
   SI37184      OSP-MSGMCH3601-T/QPMADISK in QZRCSRVS job with disk monitor

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE52837
Superseded by:......................View fix details for PTF SI63177
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C3037710


System i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
08 November 2012