IBM Support

Journal Archive Cleanup Utility - Deleting Invalid Records

Question & Answer


Question

Can the IMS™ Connect Extensions journal archive cleanup utility delete archive entries that have an invalid time stamp?

Answer

The archive journal cleanup utility deletes from the repository archive data sets that have expired. The cleanup utility is executed using the CLEAN statement:

CLEAN PRODUCT=CEX,LENGTH=8,NAME=(hws1,…hwsn),FUNCTION=L|R,CHECK=NO|YES,ZONE=GMT|LOCAL

where:

NAME=(hws1,…hwsn)


This parameter specifies the name of one or more IMS Connect system definitions in the repository. For example, to clean systems named HWS1, HWS2, and HWS3, specify:

NAME=(HWS1,HWS2,HWS3)

If a single system is specified, the parentheses are optional, so NAME=HWS1 and NAME=(HWS1) are both valid.

FUNCTION


This parameter specifies the operating mode:
    • L

      • List mode. Lists all archive journal records in the repository for the specified IMS Connect System.

      R

      • Remove mode. If CHECK=NO is specified, remove any unused records and delete or uncatalog the archive data sets. If CHECK=YES is specified, print to CEXPRINT a list of the journal archive records that would have been removed.
CHECK=(NO|YES)
    • This parameter simulates or previews the effect of FUNCTION=R without removing any archive records. If CHECK=YES is specified, the CEXPRINT data set list will contain the journal archive records that would have been deleted if CHECK=NO was specified.

      This parameter can only be used with FUNCTION=R. The default value is CHECK=NO.

ZONE=GMT|LOCAL
    • This parameter specifies the time zone for the time stamp that is printed for each record in the journal archive record information. It can be used with FUNCTION=R or FUNCTION=L. If you specify ZONE=LOCAL, all time stamps are adjusted so that they show the local time of the computer that created the record. The default value is ZONE=GMT.

      This parameter affects only the times reported in the body of the messages FUN2570I and FUN2571I. The processing start time reported by FUN1003I is always shown according to local time.



  •  
Deleting invalid entries

If an event record is written with invalid data in the date field, the bad time stamp can create an archive entry with a time in the future. The basic CLEAN command assumes all event records have time stamps in the past, so there is no way to delete these error entries.

To solve this problem, APARs PM79685 and PM79674 provide the following new optional parameter:

DELERROR=Y

    • DELERROR=Y requests that any archive entry found where the ending time stamp value is higher than the current time is deleted. This parameter allows deletion of invalid entries caused by an invalid time stamp.

      To request deletion of any archive entries that have a time stamp that is higher than the execution time of the cleanup utility, specify a CLEAN command using the following format:

      CLEAN PRODUCT=CEX,FUNCTION=R,NAME=(hwsid),DELERROR=Y



  •  
Requirement

To use this option with IMS Connect Extensions V2R3 you must apply the PTF for APAR PM79685.

To use this option with IMS Connect Extensions V2R2 you must apply the PTF for APAR PM79674.

[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSAVHV","label":"IMS Connect Extensions for z\/OS"},"ARM Category":[{"code":"a8m0z000000cvYbAAI","label":"IMS Connect Extensions for z\/OS"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
15 November 2020

UID

swg21622482