The following error might occur when you upgrade the MXG software that you use with SAS IT Resource Management to MXG 29.29 or later:

ERROR: BY variables are not properly sorted on 
data set WORK.DB2ST225

The _SDB2STS MXG macro merges the DB2ST225 data set into the MXG DB2STATS staged data set that is used by SAS IT Resource Management to create the XDBTATS data set. This task requires DB2ST225 to be sorted. The merge fails because the MXG macro _SDB2225 is not invoked by SAS IT Resource Management.

How you circumvent this problem depends upon your release of SAS IT Resource Management:

• SAS IT Resource Management release 3.2 sites

  To circumvent this problem, create the macro variable EPDBOUT to point to the _SDB2225 macro. EPDBOUT is used by the MXG EXPDBOUT member and also honored by SAS IT Resource Management. To create the macro variable, use the following %LET SAS macro statement:

  %let epdbout= _SDB2225;
  You should place this statement inside the SAS IT Resource Management Release 3 deployed staging code, preferably at the top of the code for visibility.
  Note: Any subsequent deployment of the staging job requires that you place the %LET SAS macro again. You must do this because any modifications to the staging job using the SAS IT Resource Management client are deleted when that job is redeployed.

• SAS IT Resource Management release 2.7 sites

  SAS IT Resource Management 2.7 sites should create the EPDBOUT macro variable after you invoke the %CPSTART macro and immediately before the invocation of the %CxPROCES macro.

Click the Hot Fix tab in this note to access the hot fix for this issue.

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 3.1.1 is available at: