Skip to main content


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


parameter PAGENAME = SQL Table Statistics;
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


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


method %OnAfterCreatePage() as %Status
Inherited description: Be sure to do ##super() when overriding.
method %OnGetPageName() as %String
This should be implemented in a subclass.
classmethod CheckJobStatus(PID, SCHEMANAME, TABLENAME) as %ZEN.proxyObject [ ZenMethod ]
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, blockcounts, 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 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

Inherited Methods

FeedbackOpens in a new tab