com.ibm.tivoli.maximo.integrity.check

Class VerifyUniqueColumnIndex

java.lang.Object

com.ibm.tivoli.maximo.integrity.IntegrityCheck

com.ibm.tivoli.maximo.integrity.check.CheckTenantData

com.ibm.tivoli.maximo.integrity.check.VerifyUniqueColumnIndex

All Implemented Interfaces:

ICConstants

public class VerifyUniqueColumnIndex
extends CheckTenantData

Verify that an index exists for the unique column id of every table. Reports tables that don't have a unique ID column but require them, with NOUNIQUECOLUMN. Reports defined unique ID columns that are missing an index, with NOUNIQUECOLUMNINDEX. And after 7.5.0.0, the unique ID column should be defined as a BIGINT, with UNIQUECOLUMNNOTBIGINT.

Author:

John Neville

Field Summary

Fields inherited from interface com.ibm.tivoli.maximo.integrity.ICConstants

IC_ALLREPAIRS, IC_CANCEL, IC_CHECK, IC_CHECKDONE, IC_NOTAPPLY, IC_REPAIR, IC_REPORT, IC_TENANT

Constructor Summary

Constructors

Constructor and Description
VerifyUniqueColumnIndex(DatabaseInformation mdi, ReportCollector ic) Constructor

Method Summary

Modifier and Type	Method and Description
void	checkPerConnection(java.sql.Connection dc) Perform the check.
boolean	conditionsCheck() Should this test be run? This is for things like preMerlin or DB2 only checks.
MXException	getTitle() Returns an MXException that tells the user what is being checked now.
boolean	prerequisitesCheck() Can this test be run now? This is for things like loading the meta data, or having valid data in the MaxAttribute table.

Methods inherited from class com.ibm.tivoli.maximo.integrity.check.CheckTenantData

check

Methods inherited from class com.ibm.tivoli.maximo.integrity.IntegrityCheck

doCheck

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

VerifyUniqueColumnIndex

public VerifyUniqueColumnIndex(DatabaseInformation mdi,
                               ReportCollector ic)

Constructor

Parameters:

mdi -

ic -

Method Detail

checkPerConnection

public void checkPerConnection(java.sql.Connection dc)
                        throws java.lang.Exception

Description copied from class: CheckTenantData

Perform the check.

Specified by:

checkPerConnection in class CheckTenantData

Throws:

java.lang.Exception

getTitle

public MXException getTitle()

Description copied from class: IntegrityCheck

Returns an MXException that tells the user what is being checked now. "Checking for any workflow loops that may exist."

Specified by:

getTitle in class IntegrityCheck

conditionsCheck

public boolean conditionsCheck()
                        throws java.sql.SQLException

Description copied from class: IntegrityCheck

Should this test be run? This is for things like preMerlin or DB2 only checks. It's not an issue if test won't run because the conditions don't apply to it.

Specified by:

conditionsCheck in class IntegrityCheck

Returns:

true if the conditions are correct for the check.

Throws:

java.sql.SQLException

prerequisitesCheck

public boolean prerequisitesCheck()

Description copied from class: IntegrityCheck

Can this test be run now? This is for things like loading the meta data, or having valid data in the MaxAttribute table. The test should run after other problems are resolved.

Specified by:

prerequisitesCheck in class IntegrityCheck

Returns:

true if all prerequisites are there to run the check.