IBM Support

Integrity Checker message BMXAA0498W - must-be settings

Technote (troubleshooting)


Integrity Checker reports many instances of this type of warning:

BMXAA0442I - WARNING -- BMXAA0498W - The following columns are defined to be 'same-as', but have different must-be settings:



The must-be settings of the two columns should match, but they do not.


Because the columns are defined to be same-as, their definitions should be the same, including data type, length, scale, etc., and their must-be settings. Must-be is a flag. Its value can be 1 or 0 (true of false).

Resolving the problem

This problem does not need to be resolved. There is no known impact, other than resolving the Integrity Checker warning, if this problem is left unresolved. However, if so desired, you can use Database Configuration to modify the must-be setting of the first column to match that of the second column. Using the example in this technote, modify the must-be setting of ASSIGNMENT.TASKID to be 1 so that it matches the setting of WORKORDER.TASKID.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Asset Management for IT Not Applicable
Systems and Asset Management Tivoli Change and Configuration Management Database
Systems and Asset Management Tivoli Service Request Manager

Document information

More support for: Maximo Asset Management
Upgrade Integ Checker

Software version: 6.2, 7.1, 7.5

Operating system(s): Platform Independent

Software edition: All Editions

Reference #: 1634527

Modified date: 16 July 2013

Translate this page: