Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

The %CPREDUCE macro in IT Resource Management (ITRM) 2.7 does not age
data properly at the MONTH level of the PDB.  Instead of aging data
based on the number of months specified at the MONTH level of the PDB,
%CPREDUCE is aging data based on years.  For some sites, this may result
in an out of space condition at the MONTH level of the PDB.

To circumvent this problem, follow the steps described below for each
table in the PDB that requires aging.  This sets a hard-coded cut-off
date and thus must be done periodically.  An  ITRM 2.7 Hot fix will be
provided in the near future.

- Make sure you have a working backup copy of the PDB.
- Submit the following code in batch:

   /* Ensure update access to the PDB via CPSTART */
  %CPSTART(<your_cpstart_parms>);

   /* Set start date to keep data at MONTH level */
  %CPEDIT(table=ttttttt,LEVEL=MONTH,
        KEEPCRIT=DATEPART(DATETIME)>='01mmmyyyy'D);

  where ttttttt is the table to perform any aging, based on the first
  day of the month and year (i.e. '01FEB2006'D) to be kept at the
  MONTH level of the PDB.

For more information about the %CPEDIT macro, please refer to the SAS
IT Resource Management 2.7: Macro Reference.

Operating System and Release Information

A fix for this issue for SAS IT Resource Management 2.7 is available at:

A fix for this issue for SAS IT Resource Management 2.6 is available at: