%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 (Including Private)

Method Inventory (Including Private)

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 (Including Private)

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 iTimeoutInterval as %ZEN.Datatype.integer [ InitialExpression = 1000 ];
Property methods: iTimeoutIntervalDisplayToLogical(), iTimeoutIntervalGet(), iTimeoutIntervalIsValid(), iTimeoutIntervalLogicalToDisplay(), iTimeoutIntervalLogicalToOdbc(), iTimeoutIntervalNormalize(), iTimeoutIntervalSet()
property lblCurrentTableSize as %ZEN.Datatype.string [ InitialExpression = $$$TextHTML("Current Extentsize (per shard if table is sharded): ") ];
Property methods: lblCurrentTableSizeDisplayToLogical(), lblCurrentTableSizeGet(), lblCurrentTableSizeIsValid(), lblCurrentTableSizeLogicalToDisplay(), lblCurrentTableSizeLogicalToOdbc(), lblCurrentTableSizeNormalize(), lblCurrentTableSizeSet()

Methods (Including Private)

method %OnAfterCreatePage() as %Status [ Language = objectscript ]
Inherited description: Be sure to do ##super() when overriding.
method %OnGetPageName() as %String [ Language = objectscript ]
This should be implemented in a subclass.
classmethod CheckJobStatus(PID, SCHEMANAME, TABLENAME) as %ZEN.proxyObject [ Language = objectscript, ZenMethod ]
method DrawPropertyTitle(pPropertyForm) as %Status [ Language = objectscript ]
method DrawSQLTitle(pSeed) as %Status [ Language = objectscript ]
method ExecuteRS(pRS As %Library.ResultSet, Output tSC As %Status, pInfo As %ZEN.Auxiliary.QueryInfo) as %Boolean [ Language = objectscript ]
Method for executing the process query.
classmethod SaveData(SchemaName, TableName, KeepClassUpToDate, field, selectivity, outSelectivity, outValue, AverageFieldSize) as %String [ Language = objectscript, ZenMethod ]
classmethod SaveMap(SchemaName, TableName, KeepClassUpToDate, field, blockCount) as %String [ Language = objectscript, ZenMethod ]
classmethod SaveTableSize(SCHEMANAME, TABLENAME, ExtentSize, KeepClassUpToDate) as %String [ Language = objectscript, ZenMethod ]
This is called when user clicks Save for Table Extentsize they edited.
classmethod SetSelValues(CurrentSize, ExtentSize, KeepClassUpToDate, SCHEMANAME, TABLENAME) as %ZEN.proxyObject [ Language = objectscript, ZenMethod ]
User clicked Tune Table button. Now calculate table extentsize, blockcounts, and selectivity and save.
classmethod UpdateTableNavState(pFilter As %String, pPageSize As %Integer, pMaxRows As %Integer, ptableId As %String) [ Language = objectscript, 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 timeout() [ Language = javascript ]
timeout function
clientmethod toggleButtons(flag) [ Language = javascript ]
hide the two panes during Tuning until Tuning is finished. user can still click the Close button to quit out.
clientmethod toggleOptions() [ Language = javascript ]
Show or hide Edit Table Extentsize fields.

Inherited Members

Inherited Properties (Including Private)

Inherited Methods (Including Private)

FeedbackOpens in a new window