DTI Functional Groups

DTI Functional Groups

The Distributed Tuning Interface is divided into functional groupings. For a summary of these groupings, please see the following table. The function descriptions begin in the following section in alphabetical order.

Table 2

DTI Function Groups

List of Functions

Managing the database catalog information, such as creating, opening, copying, or closing named databases, and creating, modifying or deleting data source names (DSNs),

PvCheckDbInfo()
PvCloseDatabase()
PvCopyDatabase()
PvCountDSNs()
PvCreateDatabase()
PvCreateDatabase2()
PvCreateDSN() (deprecated)
PvCreateDSN2() (deprecated)
PvDeleteDSN() (deprecated)
PvDropDatabase()
PvFreeDbNamesData()
PvGetDbCodePage()
PvGetDbDataPath()
PvGetDbDictionaryPath()
PvGetDbFlags())
PvGetDbName()
PvGetDbNamesData()
PvGetDbServerName()
PvGetDSN() (deprecated)
PvGetDSNEx() (deprecated)
PvGetDSNEx2() (deprecated)
PvGetEngineInformation()
PvListDSNs() (deprecated)
PvModifyDatabase()
PvModifyDatabase2()
PvModifyDSN() (deprecated)
PvModifyDSN2() (deprecated)
PvOpenDatabase()

Controlling the configuration settings for the database engines, the communication managers, and the local requester components.

PvCountSelectionItems()
PvGetAllPossibleSelections()
PvGetBooleanStrings()
PvGetBooleanValue()
PvGetCategoryInfo()
PvGetCategoryList()
PvGetCategoryListCount()
PvGetLongValue()
PvGetSelectionString()
PvGetSelectionStringSize()
PvGetSelectionValue()
PvGetSettingHelp()()
PvGetSettingHelpSize()
PvGetSettingInfo()
PvGetSettingList()
PvGetSettingListCount()
PvGetSettingMap()
PvGetSettingUnits()
PvGetSettingUnitsSize()
PvGetStringType()
PvGetStringValue()
PvGetStringValueSize()
PvGetValueLimit()
PvIsSettingAvailable()
PvSetBooleanValue()
PvSetLongValue()
PvSetSelectionValue()
PvSetStringValue()

Starting and stopping a DTI session, connecting to a server, retrieving the name of the connected server, and disconnecting from a server.

PvConnectServer()
PvDisconnect()
PvGetServerName()
PvStart()
PvStop()

Creating and closing dictionaries (DDFs), and creating or deleting tables, indexes, users and groups.

PvAddIndex()
PvAddTable()
PvAddUserToGroup()
PvAlterUserName()
PvAlterUserPassword()
PvCloseDictionary()
PvCreateDictionary() (deprecated)
PvCreateGroup()
PvCreateUser()
PvDropGroup()
PvDropIndex()
PvDropIndexByName()
PvDropTable()
PvDropUser()
PvFreeTable()
PvFreeTableNames()
PvGetError()
PvGetTable()
PvGetTableNames()
PvGetTableStat()
PvGetTableStat2()
PvOpenDictionary() (deprecated)
PvRemoveUserFromGroup()

License Administration

Administering licensing such as authorizing or deauthorizing a key or retrieving information about keys.

PvAddLicense()
PvValidateLicenses()
PvDeleteLicense()
PvGetProductsInfo()

Monitoring and Diagnostic

Monitoring files, clients, and SQL connections, such as the following information for the MicroKernel Engine:

Active Files—count and list open files, query if file is open, query user who opened/locked the file, obtain page size, read-only flag, record locks, transaction locks, number of handles, obtain handle information for each handle.

Active Clients—count and list clients, query active handles, obtain client information, obtain handle information, disconnect a client and all client functionality.

Resource Usage—retrieve current, peak, and maximum settings for data, including files, handles, clients, worker threads, licenses in use, transactions, locks.

Communications Statistics—retrieve all communications statistics, total, delta, current, peak, maximum where appropriate, reset delta functionality.

PvDisconnectMkdeClient()
PvDisconnectSQLConnection()
PvFreeMkdeClientsData()
PvFreeOpenFilesData()
PvFreeSQLConnectionsData()
PvGetFileHandlesData()
PvGetFileHandleInfo()
PvGetFileInfo()
PvGetMkdeClientId()
PvGetMkdeClientInfo()
PvGetMkdeClientHandlesData()
PvGetMkdeClientHandleInfo()
PvGetMkdeClientsData()
PvGetMkdeCommStat()
PvGetMkdeCommStatEx()
PvGetMkdeUsage()
PvGetMkdeUsageEx()
PvGetMkdeVersion()
PvGetOpenFilesData()
PvGetOpenFileName()
PvGetSQLConnectionsData()
PvGetSQLConnectionInfo()

Enabling, disabling, or querying the status of security on databases.

PvIsDatabaseSecured()
PvSecureDatabase()
PvUnSecureDatabase()