Monitoring PSQL Servers with DTO : DtoFileHandle Object
 
DtoFileHandle Object
An object representing a file handle for an open file.
Properties
ClientIndex
Returns the index for a file handle.
IsLocked
Returns whether a file handle is locked.
IsWaiting
Returns the waiting status for a file handle.
OpenMode
Returns the open mode for the file handle.
OpenModeName
Returns a text version of OpenMode.
TransState
Returns the transaction state.
UserName
Returns the user name associated with the file handle.
Methods
None
Remarks
Use the DtoFileHandles Collection to obtain a list of all file handles for an open file.
Example
Dim my_session as new DtoSession
Dim my_openfiles as DtoOpenFiles
Dim first_file as DtoOpenFile
Dim my_handles as DtoFileHandles
Dim first_handle as DtoFileHandle
Dim locked_state as Boolean
Dim result as DtoResult
 
result = my_session.Connect("myserver", "username", "password")
Set my_monitor = my_session.Monitor
Set my_openfiles = my_monitor.OpenFiles
Set first_file = my_openfiles.Item(1)
Set my_handles = first_file.FileHandles
Set first_handle = my_handles.Item(1)
locked_state = first_handle.IsLocked
See Also
DtoFileHandles Collection
DtoOpenFile Object
DtoMonitor Object