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

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

The _SDB2STS MXG macro merges the DB2STAT4 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 the MXG table DB2STAT4 to be sorted. SAS IT Resource Management does sort the DB2STAT4 data set. However, the merge fails because the MXG macro _SDB2ST4 is not invoked by SAS IT Resource Management.

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

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 are deleted when that job is redeployed.

SAS IT Resource Management 2.7 sites should create the EXPDBOUT 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 3.2 is available at:

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: