psdi.dm.util

Class DBCompare

java.lang.Object

psdi.dm.util.DBCompare

All Implemented Interfaces:

UpgConstants

public class DBCompare
extends java.lang.Object
implements UpgConstants

Database Comparison utility, to compare data in two databases. The "local" database is the database where MXServer is running and the user is logged in. The "remote" or "target" database is the other database being compared.

To see real time job status for DBCompare, turn on INFO logging for the DM Service (log4j.logger.maximo.service.DM).

Each comparison is tracked by a job in the DMCompJob table. For each row of data, a row is written to the DMCompResult table, with a status of MATCH, DIFFERENCE, LOCALONLY or REMOTEONLY. The attributes that are different for that row are written to the DMCompResRecord table.

The parameters for DBCompare are as follows.

Parameter ID	Parameter Value	Description
-d	Remote database driver	The database driver for the remote database. Defaults to same as local driver.
-j	Job number	Job number
-s	Source	DMUtil.getSourceName
-t	Target	Remote Target Name
-p	Package name	Package definition name.

See Also:

DMCompJob, DMCompResult, DMCompResRecord

Field Summary

Fields

Modifier and Type	Field and Description
protected java.util.HashMap	colsLocal
protected java.util.HashMap	colsRemote
protected java.lang.String	entityname
static int	ERROR
static int	INFO
protected int	isView
protected java.util.HashMap	localOnly
protected java.lang.String	objName
protected java.util.HashMap	orderByInfo
protected java.lang.String	orderBySql
protected java.util.HashMap	remoteOnly
protected java.lang.String	uniqueColName
static int	WARNING

Fields inherited from interface psdi.configure.UpgConstants

DB2, doNotUpdateACTION, doNotUpdateALNDOMAIN, doNotUpdateAPPLICATIONAUTH, doNotUpdateAUTOKEY, doNotUpdateCONDITION, doNotUpdateCONTRACTPROPERTY, doNotUpdateCONTRACTTYPE, doNotUpdateCROSSOVERDOMAIN, doNotUpdateDOCTYPES, doNotUpdateLANGUAGE, doNotUpdateMAXAPPS, doNotUpdateMAXCONDDETAIL, doNotUpdateMAXCONTROLVALUE, doNotUpdateMAXDOMAIN, doNotUpdateMAXLOGAPPENDER, doNotUpdateMAXLOGGER, doNotUpdateMAXMENU, doNotUpdateMAXMESSAGES, doNotUpdateMAXMODULES, doNotUpdateMAXPROP, doNotUpdateMAXPROPVALUE, doNotUpdateMAXROLE, doNotUpdateMAXSEQUENCE, doNotUpdateMAXSERSECURITY, doNotUpdateMAXSERVICE, doNotUpdateMAXTABLEDOMAIN, doNotUpdateMAXVARS, doNotUpdateMAXVARTYPE, doNotUpdateMXCOLLAB, doNotUpdateMXCOLLABREF, doNotUpdateNUMERICDOMAIN, doNotUpdateNUMRANGEDOMAIN, doNotUpdatePORTLET, doNotUpdatePRICALC, doNotUpdateSECURITYRESTRICT, doNotUpdateSIGOPTION, doNotUpdateSYNONYMDOMAIN, doNotUpdateTAXTYPE, doNotUpdateWORKPRIORITY, doNotUpdateWORKTYPE, doNotUpdateWPEDITSETTING, messageCache, NEWONLY, OLDANDNEW, OLDONLY, ORACLE, SQLINET, SQLMICROSOFT, SQLSERVER, SYSDATATABLES, SYSTEMTABLES, UNKNOWN

Constructor Summary

Constructors

Constructor and Description
DBCompare(MXServer server, UserInfo ui, java.util.HashMap params, java.sql.Connection con) This constructor accepts parameter for MXServer and sets value for mxs.

Method Summary

Modifier and Type	Method and Description
void	doCompare() Process an object.
void	doConnect() Get the package definition, target definition, etc.
void	doSql(java.lang.String sql) Execute a sql statement
void	endProcess(boolean errors)
void	process() Main method for DBCompare.
void	readParams(java.util.HashMap params) Process -t parameter, set value for tbnames.
void	showMessage(java.lang.String e, int level)
void	showMXException(MXException e, int level)

Methods inherited from class java.lang.Object

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

Field Detail

INFO

public static int INFO

WARNING

public static int WARNING

ERROR

public static int ERROR

objName

protected java.lang.String objName

colsLocal

protected java.util.HashMap colsLocal

colsRemote

protected java.util.HashMap colsRemote

localOnly

protected java.util.HashMap localOnly

remoteOnly

protected java.util.HashMap remoteOnly

entityname

protected java.lang.String entityname

isView

protected int isView

uniqueColName

protected java.lang.String uniqueColName

orderBySql

protected java.lang.String orderBySql

orderByInfo

protected java.util.HashMap orderByInfo

Constructor Detail

DBCompare

public DBCompare(MXServer server,
                 UserInfo ui,
                 java.util.HashMap params,
                 java.sql.Connection con)
          throws java.lang.Exception

This constructor accepts parameter for MXServer and sets value for mxs.

Parameters:

server - MXServer

ui - End-user's UserInfo

params - See class javadocs for listing

con - System user's database connection

Throws:

java.lang.Exception

See Also:

DBCompare.readParams(java.util.HashMap)

Method Detail

process

public void process()
             throws java.lang.Throwable

Main method for DBCompare. Connect to source and target. Iterate through database objects via package definition. For each object, call #doCompare to compare data on source and target.

Throws:

java.lang.Throwable

See Also:

DBCompare.doConnect(), DBCompare.doCompare()

doConnect

public void doConnect()
               throws java.lang.Exception

Get the package definition, target definition, etc. Throw error if we cannot run the job for some reason.

Throws:

java.lang.Exception

doCompare

public void doCompare()
               throws java.lang.Throwable

Process an object. Compare data on source and remote target. If errors, log but do not throw, so we can continue through the rest of the MOS.

Throws:

java.lang.Throwable

See Also:

DBCompare.getMetadata(java.lang.String, boolean), DBCompare.getOrderBy(String, HashMap, HashMap), DBCompare.getColNames(HashMap, HashMap), DBCompare.buildSelect(java.lang.String, java.util.HashMap, java.lang.String, int), DBCompare.compareKeys(java.sql.ResultSet, java.sql.ResultSet), DBCompare.compareAttributes(java.sql.ResultSet, java.sql.ResultSet), DBCompare.logSingleton(java.sql.ResultSet, boolean, java.util.HashMap)

readParams

public void readParams(java.util.HashMap params)
                throws java.lang.Exception

Process -t parameter, set value for tbnames.

Parameters:

outdir - Not used.

outfile - Not used.

params - Parameters (see class javadocs).

Throws:

java.lang.Exception

endProcess

public void endProcess(boolean errors)
                throws java.lang.Exception

Throws:

java.lang.Exception

showMXException

public void showMXException(MXException e,
                            int level)

showMessage

public void showMessage(java.lang.String e,
                        int level)

doSql

public void doSql(java.lang.String sql)
           throws java.sql.SQLException

Execute a sql statement

Parameters:

sql - The Sql statement

Throws:

java.sql.SQLException