psdi.configure

Class DropBackup

java.lang.Object

psdi.configure.CommonShell

psdi.configure.DropBackup

All Implemented Interfaces:

UpgConstants

public class DropBackup
extends CommonShell
implements UpgConstants

Drop Backup Tables utility. This is used after we configured the database and restored data from the backup tables. If we already copied data from backup tables to base tables using the RestoreFromBackup program, and did not use the param to drop the backup tables at that time, then this program will drop the backup tables as a separate step.

This program is called by RestoreFromBackup when the -r parameter is used.

This runs independently of MXServer. However, it is not injurious to run this program while MXServer is in use.

The commandline parameters for DropBackup are as follows, in addition to those in the superclass CommonShell.

Parameter ID	Parameter Value	Description
-g	(none)	This is optional. It indicates that this class has been instanciated by the Upgrade.
-t	Table names delimited by commas	This is optional. If this parameter is used, then the names of the Maximo tables whose temp tables should be dropped will appear after this parameter, delimited by commas. For example: -tITEM,TOOL,WORKORDER If not specified, then all temp tables that are eligible to be dropped will be dropped.

See Also:

CommonShell, ConfigDB, RestoreFromBackup

Field Summary

Fields inherited from class psdi.configure.CommonShell

classShortName, con, conKey, conService, dbIn, driver, execute, externalConnection, forceCreateOutfile, hostname, lastSqlIssued, listStream, log, mxs, myLogger, out, outFileNameDefault, outputFile, port, propFileNameDefault, schemaOwner, servername, session, sNo, sYes, thisIsNested, url, userLangCode, userName, util

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
DropBackup() This constructor does nothing.
DropBackup(MXServer server) This constructor accepts parameter for MXServer and sets value for mxs.

Method Summary

Modifier and Type	Method and Description
void	dropTempTable(java.lang.String tempTbName) Drop the backup (temp) table.
void	endSetupInstance(java.lang.String outdir, java.lang.String outfile, java.util.HashMap params) Process -t parameter, set value for tbnames.
static void	main(java.lang.String[] argv) Main
void	process() Main processing method for this program.
void	showMsg(java.lang.String str) Call super, then add message in ConfigureService, if appropriate.

Methods inherited from class psdi.configure.CommonShell

auditProcess, createOutfile, doCall, doDB2TextSearchCall, doSql, doSql, doSql, doSql, doWait, endProcess, endProcessInstance, endSetup, execRuntime, getDisplayMessage, getDisplayMessage, getMessage, getOutfile, getOutstream, getProperty, getRootDirName, isXmlOut, loadMessageCache, loadMessageCacheSub, logMessage, logSql, reformatForDB2, reformatForSqlsvr, reformatForSqlsvrMaxSequence, setConnection, setDB2TextOutput, setup, setupFromMXServer, setupFromPropfile, setupInstance, setupNested, setupNestedInstance, setUserLangCode, setXmlOut, showMXException, showMXException

Methods inherited from class java.lang.Object

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

Constructor Detail

DropBackup

public DropBackup()

This constructor does nothing. Used when running from the DOS prompt.

DropBackup

public DropBackup(MXServer server)

This constructor accepts parameter for MXServer and sets value for mxs. Used when invoked from the Config application.

Method Detail

process

public void process()
             throws java.lang.Exception

Main processing method for this program. Selects from maxtablescfg where restoredata NOT equal to Yes and a native backup table exists ("XX" + tbname). Calls dropTempTable for each such table.

Specified by:

process in class CommonShell

Throws:

java.lang.Exception

See Also:

Util.getOldBackupTables(java.lang.String), DropBackup.dropTempTable(java.lang.String)

dropTempTable

public void dropTempTable(java.lang.String tempTbName)
                   throws java.lang.Exception

Drop the backup (temp) table.

Parameters:

tempTbName - The table to be dropped, e.g. XXITEM.

Throws:

java.lang.Exception

showMsg

public void showMsg(java.lang.String str)

Call super, then add message in ConfigureService, if appropriate.

Overrides:

showMsg in class CommonShell

Parameters:

str - The one-line message to be displayed.

See Also:

ConfigureService.addConfigMsg(java.lang.String)

endSetupInstance

public void endSetupInstance(java.lang.String outdir,
                             java.lang.String outfile,
                             java.util.HashMap params)
                      throws java.lang.Exception

Process -t parameter, set value for tbnames.

Overrides:

endSetupInstance in class CommonShell

Parameters:

outdir - Not used.

outfile - Not used.

params - Parameters (see class javadocs).

Throws:

java.lang.Exception

main

public static void main(java.lang.String[] argv)

Main

See Also:

CommonShell.setup(java.util.HashMap), DropBackup.process(), CommonShell.endProcess(boolean)