PM05540: THE SELECT STATEMENT ENDTIME= PARAMETER NOT WORKING AS EXPECTED IN CERTAIN CASES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The SELECT statement ENDTIME= parameter is not stopping the
  selection as expected, in some cases.
  Also, some conflicts in parameters are not reported correctly
  such as a "no logs allocated" error is not being reported in
  a case when it should be.
  
  Additional issue addressed ( was PM11733 ):
  RECOVERAB OLDS allocation should exclude the current open log
  from being allocated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of QCF , that use                  *
  *                 RECOVERAB/RECOVERDM/REPROCESS procedures.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Programs have been change to:           *
  *                      1.Not allocate PRISLDs and OLDS that    *
  *                      start after the time in SELECT ENDTIME  *
  *                      parameter for all queue rebuild         *
  *                      functions.                              *
  *                      2.Not allocate the OLDs of the last     *
  *                      started IMS for functions RECOVERAB     *
  *                      and RECOVERDM.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR changes log selection for REPROCESS, RECOVERDM and
  RECOVERAB.
  
  1. REPROCESS
  A.Format of control card LAST for function REPROCESS:
  LAST, IMSID,RE,D=...,T=...,DT=MSG/CP ( DT=MSG is default)
  - D=....  T=.... - is required, it is locale date and time.
  - DT=MSG is set by default if DT=MSG/CP is missing.
  - if DT=CP message selection starts with the CP if found. If CP
   is not found - the steps ends with error RC=8.
  - if DT=MSG- message selection starts with the most recent CP
  before this date and time.
  
  B. Log allocation
  PRISLDs and not archived OLDS (including the PRISLDS and OLDS
  of the last started IMS) are ordered by time.
  First allocated log is the most recent, that  ends at  or
  before selected date and time and has a CP recordet on it.
  Last allocated log is last used if no  SELECT ENDTIME is coded.
  Last allocated log is the first that ends after the ENDTIME if
  SELECT ENDTIMEis coded.
  
  C. Record selection
  If the CP is message queue dump type CP - selection starts
  with X'4002' log recs in first check point and continues
  with messages records after the first CP
  If the  CP is not message queue dump type CP - only messages
  records are selected from the logs.
  
  2. RECOVERDM
  A.Format of control card LAST for function RECOVERDM:
  LAST, IMSID,RE,D=...,T=...,DT=...
  - D=....  T=.... - are optional and are used for LIST.LOG only.
  
  B. LOG allocation
  PRISLDs and not archived OLDS (excluding the PRISLD and OLDS
  of the last started IMS) are ordered by time.
  First allocated log is the most recent, that  has a valid CP
  Last allocated log is last in the ordered by time list of
  PRISLDS and OLDS
  
  C. Record selection
  Only  x'4002' log records from within the CP  are selected.
  
  3. RECOVERAB
  A.Format of control card LAST for function RECOVERAB:
  LAST, IMSID,RE,D=...,T=...,DT=...
  - D=....  T=.... - are optional and are used for LIST.LOG only.
  
  B. LOG allocation
  PRISLDs and not archived OLDS (excluding the PRISLD and OLDS
  of the last started IMS) are ordered by time.
  First allocated log is the most recent, that  has a valid CP.
  Last allocated log is last in the ordered by time list of
  PRISLDS and OLDS
  
  C. Record selection
  Selection starts with X'4002' log recs in selected CP and
  continues with messages records after the first CP.
  Cancel step will remove the processed   messages.
  
  Error messages changed with changed severity and text:
  IQCA029W -
  RECOVERDM requested-no archived DUMPQ/PURGE.
  IQCA030W -
  RECOVERAB requested-no archived DUMPQ/PURGE/SNAPQ.
  IQCA036W -
  REPROCESS requested-no valid archived CP found.
  IQCA049W -
  No valid set of archived logs found.
  

Problem conclusion

• Install the APAR to have the new improved functionality.
  

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:

  UK56726

Modules/Macros

• IQCALST0 IQCAMSG0 IQCASELO IQCMDATA IQCSELCT
  IQCSELDC
  

Fix information

• Fixed component name

  IMS QUEUE CNTL

• Fixed component ID

  5697E9900

Applicable component levels

• R310 PSY UK56726

     UP10/05/07 P F005

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.