%SYS
StatsSQL Member List

This is the complete list of members for StatsSQL, including all inherited members.

__init__(self)StatsSQL
AcquireLock(_.Library.String locktype)Persistent
AddToSaveSet(_.Library.Integer depth, _.Library.Integer refresh)RegisteredObjectprivate
AddToSyncSet(_.SYNC.SyncSet objSS, _.Library.ObjectHandle oref, _.Library.Integer fileop, _.Library.ObjectIdentity oid, _.Library.List changed, _.Library.String guid, _.Library.String originSystem, _.Library.String originNS)SwizzleObjectprivatestatic
aggregateSQLStats(ns, rtn, curs)StatsSQLstatic
BuildDeferredIndices(_.Library.Integer pLockFlag, _.Library.Integer pJournalFlag)Persistentprivatestatic
BuildIndices(_.Library.RawString pIndexList, _.Library.Integer pAutoPurge, _.Library.Integer pLockFlag, _.Library.Integer pJournalFlag, _.Library.RawString pStartID, _.Library.RawString pEndID, _.Library.RawString pIgnoreIndexList, _.Library.Integer pKeepSelectability)Persistentprivatestatic
BuildIndicesAsync(_.Library.String queueToken, _.Library.RawString pIndexList, _.Library.Integer pAutoPurge, _.Library.Integer pLockFlag, _.Library.Integer pJournalFlag, _.Library.RawString pStartID, _.Library.RawString pEndID, _.Library.RawString pIgnoreIndexList, _.Library.Integer pTimeout, _.Library.Integer pKeepSelectability)Persistentprivatestatic
BuildIndicesAsyncResponse(queueToken, _.Library.Boolean wait)Persistentprivatestatic
buildPPcost(_.Library.Float qoqn, _.Library.RawString dmt, _.Library.RawString dmts, _.Library.RawString dalg, _.Library.RawString PPcost, _.Library.Integer silent)StatsSQLstatic
CAPTIONRegisteredObjectstatic
changeCost(_.Library.Float PPcost, _.Library.Integer num, _.Library.Integer level, _.Library.RawString dmt, _.Library.RawString dmts, _.Library.RawString dalg, _.Library.Integer silent)StatsSQLstatic
CheckConstraints(_.Library.String pID, _.Library.List pConstraintList, _.Library.Integer pCheckDisabled, _.Library.List pErrorInfo)Persistentprivatestatic
CheckConstraintsForExtent(_.Library.String pConstraintList, _.Library.Integer pCheckDisabled, _.Library.String pErrorLog)Persistentprivatestatic
ClassIsLatestVersion()SystemBaseprivatestatic
ClassName(_.Library.Boolean fullname)SystemBaseprivatestatic
clearPToolsError(_.Library.String errRowID)Statsstatic
clearStats(_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearErrs, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
clearStatsALL(_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearErrs, _.Library.Integer silent, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
clearStatsAllNS(_.Library.String rtn, _.Library.Integer ph2, _.Library.String ph3, _.Library.Integer clearErrs, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
clearStatsSQL(_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearAll, _.Library.Integer clearErrs, _.Library.Integer returnType, _.Library.RawString ptInfo)StatsSQLstatic
clearStatsSQLALL(_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearAll, _.Library.Integer clearSQLQuery, _.Library.Integer clearBench, _.Library.Integer clearSQLIndex, _.Library.Integer clearErrs, _.Library.Integer purgeCQ, _.Library.Integer silent, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
clearStatsSQLAllNS(_.Library.String rtn, _.Library.Integer ph2, _.Library.String ph3, _.Library.Integer clearAll, _.Library.Integer clearErrs, _.Library.Integer returnType, _.Library.RawString ptInfo)StatsSQLstatic
clearStatsSQLIndexALL(_.Library.String ns, _.Library.Integer clearErrs, _.Library.Integer silent, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
clearStatsSQLIndexNEW(_.Library.String ns, _.Library.Integer clearErrs, _.Library.Integer silent, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
clearStatsSQLIndexOLD(_.Library.String ns, _.Library.Integer clearErrs, _.Library.Integer silent, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
clearStatsSQLNEW(_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearAll, _.Library.Integer clearSQLIndex, _.Library.Integer clearErrs, _.Library.Integer purgeCQ, _.Library.Integer silent, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
clearStatsSQLOLD(_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearSQLQuery, _.Library.Integer clearBench, _.Library.Integer clearSQLIndex, _.Library.Integer clearErrs, _.Library.Integer purgeCQ, _.Library.Integer silent, _.Library.Integer returnType, _.Library.RawString ptInfo)Statsstatic
CommandsExecutedStats
ComposeOid(_.Library.String id)Persistentprivatestatic
condsMatch(conds, d, condValExp)FileCreationstatic
ConstructClone(_.Library.Integer deep, _.Library.String cloned, _.Library.String location)RegisteredObjectprivate
CounterStats
createAndOpenFile(file, timeout)FileCreationstatic
createOrderByList(orderBy, d)FileCreationstatic
creationDateStatsSQL
creationTimeStatsSQL
CSVtabHead(metadata, delim)FileCreationstatic
CSVtabRow(metadata, delim)FileCreationstatic
CursorNameStatsSQL
DATALOCATIONGLOBALPersistentstatic
DEFAULTCONCURRENCYSwizzleObjectstatic
DEFAULTGLOBALPersistentstatic
Delete(_.Library.ObjectIdentity oid, _.Library.Integer concurrency)Persistentprivatestatic
DeleteData(_.Library.String id, _.Library.Integer concurrency)Persistentstatic
DeleteExtent(_.Library.Integer concurrency, deletecount, instancecount, _.Library.Integer pInitializeExtent, _.Library.Status errorLog)Persistentprivatestatic
DeleteId(_.Library.String id, _.Library.Integer concurrency)Persistentprivatestatic
DiskWaitStats
DispatchClassMethod(_.Library.String Class, _.Library.String Method, Args)SystemBaseprivatestatic
DispatchGetModified(_.Library.String Property)SystemBaseprivate
DispatchGetProperty(_.Library.String Property)SystemBaseprivate
DispatchMethod(_.Library.String Method, Args)SystemBaseprivate
DispatchSetModified(_.Library.String Property, Val)SystemBaseprivate
DispatchSetMultidimProperty(_.Library.String Property, Val, Subs)SystemBaseprivate
DispatchSetProperty(_.Library.String Property, Val)SystemBaseprivate
DLMtabHead(metadata, delim)FileCreationstatic
DLMtabRow(metadata, delim)FileCreationstatic
DSCONDITIONPersistentstatic
DSINTERVALPersistentstatic
DSTIMEPersistentstatic
ExeNameStats
Exists(_.Library.ObjectIdentity oid)Persistentprivatestatic
ExistsId(_.Library.String id)Persistentprivatestatic
Export(file, delim, _.Library.RawString conds, _.Library.RawString ptInfo)StatsSQLstatic
ExportAll(filePrefix, delim, exportPlan, silent, rtnName, modName, _.Library.RawString conds, _.Library.RawString ptInfo)StatsSQLstatic
ExportSQLQuery(file, delim, exportPlan, _.Library.RawString conds, _.Library.RawString ptInfo)StatsSQLstatic
exportStats(file, format, silent, statsType, rtnName, modName, _.Library.RawString conds, _.Library.RawString ptInfo, bcFlag)Statsstatic
exportStatsSQL(file, format, silent, statsType, exportPlan, rtnName, modName, _.Library.RawString conds, _.Library.RawString ptInfo, contRowCnt, bcFlag)StatsSQLstatic
Extends(_.Library.String isclass)SystemBaseprivatestatic
EXTENTQUERYSPECPersistentstatic
EXTENTSIZEPersistentstatic
fileBody(file, format, metadata)FileCreationstatic
fileFooter(file, format, footerMsg, metadata, elapseTime, rowCnt)FileCreationstatic
fileHeader(file, format, title, class, method, version, metadata, bcFlag)FileCreationstatic
getImportSchema(_.Library.String ns, _.Library.String rtn, _.Library.String curs)StatsSQLstatic
GetLastSQLStats(dumpResults)StatsSQLstatic
GetLock(_.Library.String id, _.Library.Boolean shared)Persistentprivatestatic
getOutputFile(file, className, methodName, format, hDate, tSC)FileCreationstatic
GetParameter(_.Library.String paramname)SystemBaseprivatestatic
getPToolsError(_.Library.String errRowID, _.Library.RawString PToolsErr)Statsstatic
getQueryText(_.Library.String ns, _.Library.String rtn, _.Library.String curs, _.Library.Boolean getInt)StatsSQLstatic
GetSQLStatsFlag(_.Library.Integer flagType, _.Library.Integer returnActionFlag, _.Library.RawString ptInfo)StatsSQLstatic
GetSQLStatsFlagByPID(_.Library.String pid, _.Library.Integer returnActionFlag, _.Library.RawString ptInfo)StatsSQLstatic
GetSQLStatsSaveFlag(_.Library.Integer flagType)StatsSQLstatic
GetStats(_.Library.String SQLText, _.Library.String mod, _.Library.Integer showStats)StatsSQLstatic
GetSwizzleObject(_.Library.Integer force, _.Library.ObjectIdentity oid)Persistentprivate
GlobalRefsStats
GUID(_.Library.ObjectIdentity oid, _.Library.Integer pDeepSearch)Persistentprivatestatic
GUIDENABLEDPersistentstatic
HashStatsSQL
HTMLtabHead(aTag, title, metadata)FileCreationstatic
HTMLtabRow(metadata)FileCreationstatic
Id()Persistentprivate
IDENTIFIEDBYPersistentstatic
ImportSchemaStatsSQL
ImportSchema(_.Library.String CN, _.Library.String Rtn, _.Library.Boolean Internal)StatsSQLstatic
IPAddressStats
IsA(_.Library.String isclass)SystemBaseprivatestatic
IsModified()RegisteredObjectprivate
IsNull()SwizzleObjectprivate
JAVATYPERegisteredObjectstatic
JOURNALSTREAMSwizzleObjectstatic
KillExtent(_.Library.Integer pDirect, _.Library.Boolean killstreams)Persistentprivatestatic
KillExtentData(_.Library.Boolean killstreams)Persistentstatic
LinesOfCodeStats
LoadData(_.Library.String id)Persistent
LockExtent(_.Library.Boolean shared)Persistentprivatestatic
LockId(_.Library.String id, _.Library.Boolean shared, _.Library.Integer timeout)Persistentprivatestatic
MachineNameStats
MANAGEDEXTENTPersistentstatic
map(_.Library.String data, _.Library.RawString mt, _.Library.RawString mts, _.Library.RawString alg, _.Library.Integer qnum, _.Library.Integer str, _.Library.Integer silent)StatsSQLstatic
ModuleCountStats
ModuleNameStatsSQL
NameSpaceStatsSQL
New(_.Library.RawString initvalue)SystemBaseprivatestatic
newSQLStats(SQLText, SQLType, ns, rtn, curs, compTime, SQLIndexHash, ucqInfo)StatsSQLstatic
NormalizeObject()RegisteredObjectprivate
ObjectIsNull(_.Library.ObjectIdentity pOID)Persistentprivatestatic
ObjectModified()RegisteredObjectprivate
OBJJOURNALSwizzleObjectstatic
Oid()Persistentprivate
OnAddToSaveSet(_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount)RegisteredObject
OnAfterBuildIndices(_.Library.String indexlist)Persistentstatic
OnAfterDelete(_.Library.ObjectIdentity oid)Persistentstatic
OnAfterPurgeIndices(_.Library.String indexlist)Persistentstatic
OnAfterSave(_.Library.Boolean insert)Persistent
OnBeforeAddToSync(_.Library.String guid, _.Library.ObjectHandle filterObject, _.Library.Integer filingType, _.Library.String filter)SwizzleObjectprivatestatic
OnBeforeBuildIndices(_.Library.String indexlist)Persistentstatic
OnBeforePurgeIndices(_.Library.String indexlist)Persistentstatic
OnBeforeSave(_.Library.Boolean insert)Persistent
OnClose()RegisteredObject
OnConstructClone(_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned)RegisteredObject
OnDelete(_.Library.ObjectIdentity oid)Persistentstatic
OnDeleteFinally(_.Library.ObjectIdentity oid, _.Library.Status status)Persistentprivatestatic
OnDetermineClass(_.Library.ObjectIdentity oid, _.Library.String class)Persistentprivatestatic
OnJournalObject(_.Library.Integer tranid, _.Library.Integer jrnid, _.Library.String filter)SwizzleObject
OnNew()RegisteredObject
OnOpen()Persistent
OnOpenFinally(_.Library.ObjectIdentity oid, _.Library.Status status)Persistentprivatestatic
OnReload()Persistent
OnRollBack()Persistent
OnSaveFinally(_.Library.ObjectHandle oref, _.Library.Status status)Persistentprivatestatic
OnValidateObject()RegisteredObject
Open(_.Library.ObjectIdentity oid, _.Library.Integer concurrency, _.Library.Status sc)Persistentprivatestatic
openFileForRead(file, timeout)FileCreationstatic
OpenId(_.Library.String id, _.Library.Integer concurrency, _.Library.Status sc)Persistentprivatestatic
OriginalNamespace()SystemBaseprivatestatic
PackageName()SystemBaseprivatestatic
ParametersStatsSQL
PidStats
possiblePlans(_.Library.RawString sql, _.Library.Integer PPcost, _.Library.Integer num, _.Library.Integer level, _.Library.Integer arr, _.Library.Integer showStats, _.Library.String schemaImport, _.Library.String schemaPath, _.Library.Integer preparse, _.Library.String hash, _.Library.Integer silent)StatsSQLstatic
possiblePlansClose(_.Library.Binary qHandle)StatsSQLstatic
possiblePlansExecute(_.Library.Binary qHandle, _.Library.String sql)StatsSQLstatic
possiblePlansFetch(_.Library.Binary qHandle, _.Library.List Row, _.Library.Integer AtEnd)StatsSQLstatic
possiblePlansStatsClose(_.Library.Binary qHandle)StatsSQLstatic
possiblePlansStatsExecute(_.Library.Binary qHandle, _.Library.String sql, _.Library.String ids)StatsSQLstatic
possiblePlansStatsFetch(_.Library.Binary qHandle, _.Library.List Row, _.Library.Integer AtEnd)StatsSQLstatic
PROPERTYVALIDATIONRegisteredObjectstatic
Purge(_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearAll, _.Library.Integer clearErrs, _.Library.Integer returnType, _.Library.RawString ptInfo)StatsSQLstatic
PurgeIndices(_.Library.List idxlist, _.Library.Boolean lockExtent, _.Library.RawString pIgnoreIndexList, _.Library.Integer pJournalFlag)Persistentprivatestatic
QueryCompileTimeStatsSQL
QueryTextStatsSQL
QueryText(_.Library.String CN, _.Library.String Rtn, _.Library.Boolean Internal)StatsSQLstatic
QueryTypeStatsSQL
READONLYPersistentstatic
ReleaseLock(_.Library.String locktype)Persistent
Reload()Persistentprivate
RemoveFromSaveSet()RegisteredObjectprivate
Report(file, conds, ptInfo)Statsstatic
ResolveConcurrencyConflict(_.Library.ObjectIdentity oid, _.SYNC.SyncSet objSS, _.Library.Integer iPtr, _.Library.Boolean bAcceptYours)SwizzleObjectprivatestatic
RollBack()Persistentprivate
RoutineInfoStats
RoutineNameStatsSQL
RoutineNameUCQCallerStatsSQL
RowCountStats
ROWLEVELSECURITYPersistentstatic
Save(_.Library.Integer related)Persistentprivate
SaveData(_.Library.String id)Persistent
SaveDirect(_.Library.String id, _.Library.List idList, _.Library.Binary data, _.Library.Integer concurrency)Persistentprivatestatic
saveSQLStats(ns, rtn, curs, mod, rowCount, SQLIndexHash)StatsSQLstatic
SerializeObject(_.Library.Binary serial, _.Library.Integer partial)RegisteredObjectprivate
SetModified(_.Library.Integer value)SystemBaseprivate
SetSQLStats(_.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String terminateCond, _.Library.RawString ptInfo)StatsSQLstatic
SetSQLStatsFlag(_.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String terminateCond, _.Library.RawString ptInfo)StatsSQLstatic
SetSQLStatsFlagByNS(_.Library.String ns, _.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String terminateCond, _.Library.RawString ptInfo)StatsSQLstatic
SetSQLStatsFlagByPID(_.Library.String pid, _.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String p5, _.Library.RawString ptInfo)StatsSQLstatic
SetSQLStatsFlagJob(_.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String p4, _.Library.RawString ptInfo)StatsSQLstatic
SetSQLStatsJob(_.Library.Integer actionFlag, _.Library.Integer returnActionFlag, _.Library.String collectFlag, _.Library.String p4, _.Library.RawString ptInfo)StatsSQLstatic
SetSQLStatsSaveFlag(_.Library.Integer typeFlag, _.Library.Integer methodFlag)StatsSQLstatic
SetSQLStatsSaveFlagJob(_.Library.Integer typeFlag, _.Library.Integer methodFlag)StatsSQLstatic
SortBegin(_.Library.List idxlist, _.Library.Integer excludeunique)Persistentprivatestatic
SortEnd(_.Library.List idxlist, _.Library.Integer commit, _.Library.Integer excludeunique)Persistentprivatestatic
SQLIndexHashStatsSQL
SQLPREVENTFULLSCANPersistentstatic
SQLStatsFlagStatsSQL
SQLTextRawStatsSQL
Start(_.Library.String NS, _.Library.String Rou, _.Library.String Mod)Statsstatic
startSQLStats(ns, rtn, curs, params, SQLIndexHash, flag, collect)StatsSQLstatic
StartTimeStats
StatsGroupStatsSQL
StatsMarkerStatsSQL
Stop(_.Library.String NS, _.Library.String Rou, _.Library.String Mod)Statsstatic
stopSQLStats(ns, rtn, curs, rowCount, SQLIndexHash, flag, collect)StatsSQLstatic
STORAGEDEFAULTPersistentstatic
SyncObjectIn(_.SYNC.SyncSet objSS, _.Library.Integer iPtr, _.Library.ObjectHandle oref, _.Library.Integer fileop)SwizzleObjectprivatestatic
SyncTransport(_.Library.ObjectIdentity pOID, _.Library.RawString pTransporterRtn, _.Library.RawString pTransportGlobal, _.Library.Integer pTransportPtr, _.SYNC.Transporter pTransporter, _.Library.RawString pUnresolved)SwizzleObjectprivate
TimeSpentStats
TimeToFirstRowStats
TotalCommandsExecutedStatsSQL
TotalCounterStatsSQL
TotalDiskWaitStatsSQL
TotalGlobalRefsStatsSQL
TotalLinesOfCodeStatsSQL
TotalModuleCountStatsSQL
TotalRowCountStatsSQL
TotalTimeStats
TotalTimeSpentStatsSQL
TotalTimeToFirstRowStatsSQL
TriggerOnDelete(timing, ns, rtn, curs, sgrp, mod, rtnUCQCaller)StatsSQLstatic
_::SYS::PTools::Stats.TriggerOnDelete(timing, ns, rtn, curs, sgrp, mod)Statsstatic
TXTtabHead(metadata, delim)FileCreationstatic
TXTtabRow(metadata, delim)FileCreationstatic
UnlockExtent(_.Library.Boolean shared, _.Library.Boolean immediate)Persistentprivatestatic
UnlockId(_.Library.String id, _.Library.Boolean shared, _.Library.Boolean immediate)Persistentprivatestatic
useAggregatedData(ns, rtn, curs)StatsSQLstatic
USEEXTENTSETPersistentstatic
UserNameStats
ValidateObject(_.Library.Integer unused, _.Library.Integer checkserial)RegisteredObjectprivate
VarianceTimeSpentStatsSQL
version()StatsSQLstatic
VERSIONCLIENTNAMEPersistentstatic
VERSIONPROPERTYPersistentstatic
XCOMPACTANCESTRYPersistentstatic
XMLcolAuto()FileCreationstatic
XMLcolWidth(width)FileCreationstatic
XMLrowHeader(metadata)FileCreationstatic
XMLsheet(name)FileCreationstatic
XMLsort(sortColList, sortOrderList)FileCreationstatic
XMLtable(colCnt, rowCnt)FileCreationstatic
XMLtabRow(metadata)FileCreationstatic