%CSP.UI.Portal.SQL.TuneTable
class %CSP.UI.Portal.SQL.TuneTable extends %CSP.UI.Template.Property, %CSP.UI.Portal.UtilsNav
System Management Portal - SQL Tuen Table page.Property Inventory
Method Inventory
- %OnAfterCreatePage()
- %OnGetPageName()
- DrawPropertyTitle()
- DrawSQLTitle()
- ExecuteRS()
- SaveData()
- SaveMap()
- SaveTableSize()
- SetSelValues()
- UpdateTableNavState()
- adjustSizes()
- clearForm()
- doClose()
- doSave()
- doSaveTableSize()
- doSelectRow()
- doTuneTable()
- navMaxRowsChanged()
- navPageSizeChanged()
- onlayoutHandler()
- tabChanged()
- toggleOptions()
Parameters
parameter PAGENAME = SQL Tune Table;
Displayed name of this page.
parameter RECENT = 0;
Inherited description: If true, register visits to this page in the recent list.
parameter RESOURCE = %Development;
Security requirement
Properties
property CurrentSize as %Integer;
Current extent size when the page is loaded. Used to compare with the textbox value.
Property methods: CurrentSizeDisplayToLogical(), CurrentSizeGet(), CurrentSizeIsValid(), CurrentSizeLogicalToDisplay(), CurrentSizeNormalize(), CurrentSizeSet(), CurrentSizeXSDToLogical()
property IsTuned as %Boolean [ InitialExpression = 0 ];
Property methods: IsTunedDisplayToLogical(), IsTunedGet(), IsTunedIsValid(), IsTunedLogicalToDisplay(), IsTunedLogicalToXSD(), IsTunedNormalize(), IsTunedSet(), IsTunedXSDToLogical()
property SCHEMANAME as %String (ZENURL = "SCHEMANAME");
Property methods: SCHEMANAMEDisplayToLogical(), SCHEMANAMEGet(), SCHEMANAMEIsValid(), SCHEMANAMELogicalToDisplay(), SCHEMANAMELogicalToOdbc(), SCHEMANAMENormalize(), SCHEMANAMESet()
property TABLENAME as %String (ZENURL = "TABLENAME");
Property methods: TABLENAMEDisplayToLogical(), TABLENAMEGet(), TABLENAMEIsValid(), TABLENAMELogicalToDisplay(), TABLENAMELogicalToOdbc(), TABLENAMENormalize(), TABLENAMESet()
property lblCurrentTableSize as %ZEN.Datatype.string [ InitialExpression = $$$TextHTML("Current Table Extentsize: ") ];
Property methods: lblCurrentTableSizeDisplayToLogical(), lblCurrentTableSizeGet(), lblCurrentTableSizeIsValid(), lblCurrentTableSizeLogicalToDisplay(), lblCurrentTableSizeLogicalToOdbc(), lblCurrentTableSizeNormalize(), lblCurrentTableSizeSet()
Methods
method %OnAfterCreatePage() as %Status
Inherited description: Be sure to do ##super() when overriding.
method %OnGetPageName() as %String
This should be implemented in a subclass.
method DrawPropertyTitle(pPropertyForm) as %Status
method DrawSQLTitle(pSeed) as %Status
method ExecuteRS(pRS As %Library.ResultSet, Output tSC As %Status, pInfo As %ZEN.Auxiliary.QueryInfo) as %Boolean
Method for executing the process query.
classmethod SaveData(SchemaName, TableName, KeepClassUpToDate, field, selectivity, outSelectivity, outValue, AverageFieldSize) as %String [ ZenMethod ]
classmethod SaveMap(SchemaName, TableName, KeepClassUpToDate, field, blockCount) as %String [ ZenMethod ]
classmethod SaveTableSize(SCHEMANAME, TABLENAME, ExtentSize, KeepClassUpToDate) as %String [ ZenMethod ]
This is called when user clicks Save for Table Extentsize they edited.
classmethod SetSelValues(CurrentSize, ExtentSize, KeepClassUpToDate, SCHEMANAME, TABLENAME) as %ZEN.proxyObject [ ZenMethod ]
User clicked Tune Table button. Now calculate table extentsize and selectivity and save.
Used to Save tableNavBar values, add MapType to the page name to distinguish the type for the page.
clientmethod adjustSizes() [ Language = javascript ]
clientmethod clearForm() [ Language = javascript ]
Clear form
clientmethod doClose() [ Language = javascript ]
clientmethod doSave(option) [ Language = javascript ]
clientmethod doSaveTableSize() [ Language = javascript ]
clientmethod doSelectRow(option) [ Language = javascript ]
clientmethod doTuneTable() [ Language = javascript ]
Overriden to add tabId and tableId to the page name to distinguish the type for the page.
Overriden to add tabId and tableId to the page name to distinguish the type for the page.
clientmethod onlayoutHandler(load) [ Language = javascript ]
Inherited description: This client event, if present, is fired when the page
is first loaded or whenever it is resized.
If this is called at load time, then load will be true.
If this is called at load time, then load will be true.
clientmethod tabChanged(index) [ Language = javascript ]
clientmethod toggleOptions() [ Language = javascript ]
Show or hide Edit Table Extentsize fields.
Inherited Members
Inherited Properties
- %condition
- %import
- %includeFiles
- %page
- %resource
- Filter
- FirstFailed
- HelpAddress
- ISREADONLY
- InvalidParam
- IsEMSReadOnly
- IsEditForm
- LocatorHeader
- NAMESPACE
- OnclickArray
- PID
- ParentURL
- StdTitle
- TableMaxRows
- TablePageSize
- ValidationErrorMsg
- aboutPage
- align
- aux
- backgroundTimerInterval
- cellAlign
- cellSize
- cellStyle
- cellVAlign
- children
- composite
- containerStyle
- cssLevel
- currSortMode
- currStep
- currViewMode
- disabled
- dragAndDrop
- dragEnabled
- dropEnabled
- enclosingClass
- enclosingStyle
- error
- groupClass
- groupStyle
- height
- hidden
- hint
- hintClass
- hintStyle
- home
- homePage
- id
- index
- label
- labelClass
- labelDisabledClass
- labelPosition
- labelStyle
- layout
- lblTitle
- limitPopups
- name
- onafterdrag
- onbeforedrag
- onclick
- ondrag
- ondrop
- onhide
- onrefresh
- onshow
- onupdate
- pageModified
- parent
- searchKey
- showLabel
- slice
- title
- tuple
- useSVG
- useSoftModals
- valign
- visible
- width
- window
- zenPersistentPopup
Inherited Methods
- %AddChild()
- %AddChildAfter()
- %AddChildBefore()
- %AddComponent()
- %AddImportedComponents()
- %AddLocatorLinks()
- %AddToSaveSet()
- %ApplyURLParms()
- %Attr()
- %BindExport()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %DrawAutoLogout()
- %DrawClassDefinitions()
- %DrawComponentHTML()
- %DrawHTML()
- %DrawHTMLPage()
- %DrawJSStrings()
- %DrawObjectDefinitions()
- %EnclosingDivId()
- %EndBackgroundMethod()
- %EndScript()
- %Eval()
- %EvalC()
- %Extends()
- %ForceClientRender()
- %GetChildIndex()
- %GetComponent()
- %GetComponentById()
- %GetComponentByName()
- %GetEventHandlers()
- %GetHomePage()
- %GetHomeParam()
- %GetLinks()
- %GetLocatorLinks()
- %GetNavTableState()
- %GetPageName()
- %GetParameter()
- %GetProductName()
- %GetValueById()
- %GetValueByName()
- %GetXMLName()
- %IsA()
- %IsModified()
- %Link()
- %LinkCSS()
- %LinkScript()
- %MakeId()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnAddToPageAfter()
- %OnAddToPageBefore()
- %OnBeforeCreatePage()
- %OnCreateApplication()
- %OnCreatePage()
- %OnDetermineCSSLevel()
- %OnDrawEnclosingDiv()
- %OnDrawHTMLBody()
- %OnDrawHTMLHead()
- %OnDrawHTMLMeta()
- %OnDrawObjectProperties()
- %OnFinishBackgroundTask()
- %OnGetProductName()
- %OnGetSmallMenu()
- %OnGetTitle()
- %OnMonitorBackgroundTask()
- %OnMutateChildren()
- %OnObjectSynch()
- %OnPreHTTP()
- %OnSubmit()
- %OnUseSoftModals()
- %OnZENDeserialize()
- %OriginalNamespace()
- %PackageName()
- %QuoteValue()
- %QuoteValueL10N()
- %Register()
- %RemoveChild()
- %RemoveChildren()
- %RemoveComponent()
- %RemoveFromSaveSet()
- %RunBackgroundMethod()
- %Self()
- %SerializeObject()
- %SetBackgroundMethodStatus()
- %SetErrorById()
- %SetErrorByName()
- %SetModified()
- %SetValueById()
- %SetValueByName()
- %SetValuesByName()
- %StartScript()
- %ValidateObject()
- %ZENVersion()
- BuildMenu()
- CheckAllBlanks()
- CheckContextLinks()
- CheckEnterpriseManager()
- ConvertParameter()
- Decrypt()
- DoLogout()
- DrawLocator()
- DrawRibbon()
- DrawTitle()
- Encrypt()
- EscapeHTML()
- EscapeURL()
- EvalResult()
- GetCSPURL()
- GetContextLinks()
- GetDocPage()
- GetHomePage()
- GetNewURL()
- GetQuickLinks()
- HyperEventCall()
- HyperEventHead()
- Include()
- InsertHiddenField()
- InsertHiddenFields()
- IsPrivate()
- Link()
- OnDrawRibbon()
- OnGetRibbonInfo()
- OnHTTPHeader()
- OnPage()
- OnPageError()
- OnPostHTTP()
- OnPostHyperEvent()
- OnPreHTTP()
- OnPreHyperEvent()
- Page()
- QuoteJS()
- RegisterRecent()
- RewriteURL()
- ShowError()
- StartTimer()
- StopTimer()
- ThrowError()
- UnescapeHTML()
- UnescapeURL()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
- addChild()
- addChildAfter()
- addChildBefore()
- afterSave()
- afterValidate()
- cancelPopup()
- changePassword()
- childrenMutated()
- correctIELayering()
- createComponent()
- createComponentNS()
- deleteComponent()
- disableCommandButton()
- doCancel()
- doModified()
- dragFinishHandler()
- dragHandler()
- dragNotifyHandler()
- dragStartHandler()
- dropHandler()
- dropStartHandler()
- enableCommandButton()
- endModal()
- exposeComponent()
- findElement()
- fireOnResizeEvent()
- fireOnUnloadEvent()
- fireOnUpdateEvent()
- firePopupAction()
- getChildIndex()
- getComponent()
- getComponentById()
- getEnclosingDiv()
- getHidden()
- getHintElement()
- getLabelElement()
- getOpener()
- getProperty()
- getSettings()
- getTitleAreaHeight()
- getType()
- goHome()
- goMenu()
- gotoNamespace()
- gotoPage()
- hideCommandButton()
- invokeSuper()
- isButtonDisabled()
- isOfType()
- launchPopupWindow()
- logout()
- makeId()
- navigate()
- onCreate()
- onDelete()
- onDisplayHandler()
- onEndModalHandler()
- onPopupAction()
- onRefreshContents()
- onSerialize()
- onServerMethodCall()
- onServerMethodError()
- onServerMethodReturn()
- onStartModalHandler()
- ondisabledHandler()
- onkeydownHandler()
- onkeyupHandler()
- onloadHandler()
- onlogoutHandler()
- onoverlayHandler()
- onresizeHandler()
- onunloadHandler()
- onupdateHandler()
- popupActionHandler()
- refreshContents()
- removeChild()
- render()
- renderContents()
- renderSVG()
- resetMsg()
- searchBlur()
- searchBoxHandler()
- searchFocus()
- searchKeyDown()
- searchKeyPress()
- setComponentId()
- setConnectivityStatusMsg()
- setHidden()
- setModified()
- setOverlayMode()
- setProperty()
- setPropertyAll()
- setSortMode()
- setSortModeHandler()
- setTraceOption()
- setViewMode()
- setViewModeHandler()
- showAbout()
- showCommandButton()
- showDocumentation()
- showExpand()
- showHelp()
- showMsg()
- startModal()
- startProgressBar()
- stopProgressBar()
- switchNamespace()
- toggleSettings()
- trimSpace()
- validateRequired()