psdi.configure

Class TextSearch

java.lang.Object

psdi.configure.TextSearch

All Implemented Interfaces:

ScriptApp, UpgConstants

public class TextSearch
extends java.lang.Object
implements UpgConstants, ScriptApp

This class provides methods to stop and start text search jobs. It can also be used for adjusting text search on a table (i.e., on all columns needing adjustment). Also see Util for sql statements to implement text search on a table or column.

Field Summary

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

Fields inherited from interface com.ibm.tivoli.maximo.dbmanage.log.ScriptApp

PauseLogging, Redirect, RedirectLine, ResumeLogging, ScriptApp, ScriptAppClose, ScriptAppComment, WarningLogOnly

Constructor Summary

Constructors

Constructor and Description
TextSearch(Util util, java.sql.Connection con, java.lang.Object owner) Constructor

Method Summary

Modifier and Type	Method and Description
void	adjustTextSearchOneTable(java.util.HashMap objInfo) After a table has been altered or rebuilt, determine whether the table or any of its columns needs to be enabled or disabled for rich text search.
void	doWait(java.lang.Integer milli) Wait the specified number of milliseconds.
void	enableTextSearchAllTables() Enable text search for all tables/columns that have it flagged.
int	getNumberOfCollections() Return the number of collections - DB2 specific method.
static java.lang.String	getRichTextCreateIndexStatement(java.sql.Connection con, int dbOut, java.lang.String ixname, java.lang.String tbname, java.lang.String colName, boolean multilang, java.lang.String langColumnName, java.lang.String storageClause)
static java.lang.String	getRichTextCreateIndexStatement(java.sql.Connection con, ServerType server, java.lang.String ixname, java.lang.String tbname, java.lang.String colName, boolean multilang, java.lang.String langColumnName, java.lang.String storageClause)
static java.lang.String	getRichTextCreateIndexStatement(java.sql.Connection con, java.lang.String ixname, java.lang.String tbname, java.lang.String colName, boolean multilang, java.lang.String langColumnName, java.lang.String storageClause)
boolean	isTextSearchingEnabled() Is there an active text searching process?
void	restartTextJobs() Restart Oracle Text jobs.
void	setDB2PrintStream(java.io.PrintStream db2Out, java.io.PrintStream db2Out2) Set value for db2TextOut and (optionally) db2TextOut2.
void	startTextSearchJobs() Start text search jobs from scratch.
void	stopTextSearchJobs(boolean dropProcedures, boolean doWait) Stop text search jobs.

Methods inherited from class java.lang.Object

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

Constructor Detail

TextSearch

public TextSearch(Util util,
                  java.sql.Connection con,
                  java.lang.Object owner)

Constructor

Parameters:

util -

con -

owner - The class that is constructing TextSearch. This should be an instance of CommonShell or UpdateDB.

Throws:

java.lang.Exception

Method Detail

isTextSearchingEnabled

public boolean isTextSearchingEnabled()
                               throws java.lang.Exception

Is there an active text searching process?

Throws:

java.lang.Exception

setDB2PrintStream

public void setDB2PrintStream(java.io.PrintStream db2Out,
                              java.io.PrintStream db2Out2)

Set value for db2TextOut and (optionally) db2TextOut2. If this is not called then these both default to null and db2text statements are executed immediately rather than output to a stream.

Parameters:

db2Out - Print Stream for db2text commands. Usually this method is not called. See javadocs for db2TextOut.

db2Out2 - Second Print Stream for db2text commands, when output needs to go to two different streams. If output needs to go to only one stream, then db2Out will be non-null and db2Out2 will be null.

stopTextSearchJobs

public void stopTextSearchJobs(boolean dropProcedures,
                               boolean doWait)
                        throws java.lang.Exception

Stop text search jobs.

Parameters:

dropProcedures - If true, this method also attempts to drop the maximo text search procedures.

doWait - If true, then if the first try at stopping the jobs is not successful, the method will continue trying for 2 minutes before giving up.

Throws:

java.lang.Exception

doWait

public void doWait(java.lang.Integer milli)
            throws java.lang.Exception

Wait the specified number of milliseconds.

Parameters:

milli -

Throws:

java.lang.Exception

getNumberOfCollections

public int getNumberOfCollections()
                           throws java.lang.Exception

Return the number of collections - DB2 specific method.

Returns:

The number of collections.

Throws:

java.lang.Exception

startTextSearchJobs

public void startTextSearchJobs()
                         throws java.lang.Exception

Start text search jobs from scratch. Creates/replaces procedures and then calls them.

Throws:

java.lang.Exception

restartTextJobs

public void restartTextJobs()
                     throws java.lang.Exception

Restart Oracle Text jobs. Looks for procedures/jobs and if found, calls/enables them.

Throws:

java.lang.Exception

enableTextSearchAllTables

public void enableTextSearchAllTables()
                               throws java.lang.Exception

Enable text search for all tables/columns that have it flagged. This method assumes they have never been enabled (e.g. run from Maxinst).

Throws:

java.lang.Exception

See Also:

Util.getObjectMeta(java.lang.String, boolean, boolean, boolean, boolean, boolean, boolean, boolean), Util.getIndexMeta(java.lang.String, boolean), Util.enableRichTextSearch(HashMap, TreeMap, boolean, boolean)

adjustTextSearchOneTable

public void adjustTextSearchOneTable(java.util.HashMap objInfo)
                              throws java.lang.Exception

After a table has been altered or rebuilt, determine whether the table or any of its columns needs to be enabled or disabled for rich text search. This is called from ConfigDB and RestoreFromBackup.

Parameters:

objInfo - The table and column metadata, from getObjectMeta.

Throws:

java.lang.Exception

See Also:

Util.getIndexMeta(java.lang.String, boolean), Util.enableRichTextSearch(String, String, String, HashMap, boolean), Util.disableRichTextSearch(java.lang.String, java.lang.String, java.lang.String), Util.getTextSearchIndexForColumn(java.lang.String, java.lang.String, java.util.TreeMap), Util.activateRichTextSearch(java.util.ArrayList<java.lang.String>, java.lang.String, boolean)

getRichTextCreateIndexStatement

public static java.lang.String getRichTextCreateIndexStatement(java.sql.Connection con,
                                                               java.lang.String ixname,
                                                               java.lang.String tbname,
                                                               java.lang.String colName,
                                                               boolean multilang,
                                                               java.lang.String langColumnName,
                                                               java.lang.String storageClause)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getRichTextCreateIndexStatement

public static java.lang.String getRichTextCreateIndexStatement(java.sql.Connection con,
                                                               int dbOut,
                                                               java.lang.String ixname,
                                                               java.lang.String tbname,
                                                               java.lang.String colName,
                                                               boolean multilang,
                                                               java.lang.String langColumnName,
                                                               java.lang.String storageClause)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getRichTextCreateIndexStatement

public static java.lang.String getRichTextCreateIndexStatement(java.sql.Connection con,
                                                               ServerType server,
                                                               java.lang.String ixname,
                                                               java.lang.String tbname,
                                                               java.lang.String colName,
                                                               boolean multilang,
                                                               java.lang.String langColumnName,
                                                               java.lang.String storageClause)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException