Monitoring PSQL Servers with DTO : DtoOpenFile Object
 
DtoOpenFile Object
An object representing an open file.
Properties
ActiveCursors
Returns the number of active cursors for an open file.
AFLIndex
Returns the AFL Index for an open file.
ContinuousOps
Returns whether an open file is using continuous operations.
FileName
Returns the file name associated with an open file.
IsLocked
Returns whether an open file is locked.
0 = not Locked
1 = Locked
IsReadOnly
Returns whether an open file is read-only.
0 = not Read-only
1 = Read-only
IsTrans
Returns whether an open file is in a transaction state .
0 = No
1 = Yes
Monitor
Returns the DtoMonitor object associated with the open file.
OpenMode
Returns the open mode of the open file.
OpenModeName
Returns a text version of OpenMode.
PageSize
Returns the page size of an open file.
PhysFileSizeKB
Returns the physical size of the file in kilobytes (KB). DTO2 only.
ReferentialIntegrity
Returns whether referential integrity is set for an open file .
0 = No
1 = Yes
TimeStamp
Returns the time stamp of an open file.
TTSFlag
Reserved for future use.
Methods
None
Collections
DtoFileHandles Collection
Remarks
This object represent a currently opened file. For a collection of all open files, use the DtoOpenFiles Collection.
Example
Dim my_session as new DtoSession
Dim is_read_only as Boolean
Dim my_monitor as DtoMonitor
Dim my_openfiles as DtoOpenFiles
Dim first_file as DtoOpenFile
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(1)
is_read_only = first_file.IsReadOnly
See Also
DtoOpenFiles Collection
DtoMonitor Object