Problem Note 41019: An error occurs when you upgrade Merrill Consultants' MXG software with SAS® IT Resource Management to release 28.04 or later
 |  |  |  |  |
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS IT Resource Management-Server | z/OS | 2.7 | 3.21 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |