Skip to main content

%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

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.
classmethod UpdateTableNavState(pFilter As %String, pPageSize As %Integer, pMaxRows As %Integer, ptableId As %String) [ ZenMethod ]
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.
clientmethod tabChanged(index) [ Language = javascript ]
clientmethod toggleOptions() [ Language = javascript ]
Show or hide Edit Table Extentsize fields.

Inherited Members

Inherited Properties

Inherited Methods

FeedbackOpens in a new tab