SQL Anywhere MIB database properties

The following table lists the OIDs and names of the database properties that can be retrieved using the SQL Anywhere SNMP Extension Agent.

Writable properties are marked with an asterisk (*). The value n is the database number in the sasnmp.ini file.

Descriptions

OID	Type	Name	Property
1.3.6.1.4.1.897.2.2.2.1.n	String	dbPropAlias	Alias
1.3.6.1.4.1.897.2.2.2.2.n	String	dbPropAuditingTypes	AuditingTypes
1.3.6.1.4.1.897.2.2.2.3.n	String	dbPropBlankPadding	BlankPadding
1.3.6.1.4.1.897.2.2.2.4.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.5.n	String	dbPropCapabilities	Capabilities
1.3.6.1.4.1.897.2.2.2.6.n	String	dbPropCaseSensitive	CaseSensitive
1.3.6.1.4.1.897.2.2.2.7.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.8.n	String	dbPropCharSet	CharSet
1.3.6.1.4.1.897.2.2.2.9.n	String	dbPropChecksum	Checksum
1.3.6.1.4.1.897.2.2.2.10.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.11.n	String	dbPropCollation	Collation
1.3.6.1.4.1.897.2.2.2.12.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.13.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.14.n	String	dbPropCurrentRedoPos	CurrentRedoPos
1.3.6.1.4.1.897.2.2.2.15.n	String	dbPropDBFileFragments	DBFileFragments
1.3.6.1.4.1.897.2.2.2.16.n	String	dbPropDriveType	DriveType
1.3.6.1.4.1.897.2.2.2.17.n	String	dbPropEncryption	Encryption
1.3.6.1.4.1.897.2.2.2.18.n	String	dbPropFile	File
1.3.6.1.4.1.897.2.2.2.19.n	String	dbPropFileSize	FileSize
1.3.6.1.4.1.897.2.2.2.20.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.21.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.22.n	String	dbPropFreePages	FreePages
1.3.6.1.4.1.897.2.2.2.23.n	String	dbPropGlobalDBID	GlobalDBID
1.3.6.1.4.1.897.2.2.2.24.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.25.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.26.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.27.n	String	dbPropIQStore	IQStore
1.3.6.1.4.1.897.2.2.2.28.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.29.n	String	dbPropLanguage	Language
1.3.6.1.4.1.897.2.2.2.30.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.31.n	String	dbPropLogFileFragments	LogFileFragments
1.3.6.1.4.1.897.2.2.2.32.n	String	dbPropLogMirrorName	LogMirrorName
1.3.6.1.4.1.897.2.2.2.33.n	String	dbPropLogName	LogName
1.3.6.1.4.1.897.2.2.2.34.n	String	dbPropLTMGeneration	LTMGeneration
1.3.6.1.4.1.897.2.2.2.35.n	String	dbPropLTMTrunc	LTMTrunc
1.3.6.1.4.1.897.2.2.2.36.n	String	dbPropMultiByteCharSet	MultiByteCharSet
1.3.6.1.4.1.897.2.2.2.37.n	String	dbPropName	Name
1.3.6.1.4.1.897.2.2.2.38.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.39.n	String	dbPropPageSize	PageSize
1.3.6.1.4.1.897.2.2.2.40.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.41.n	String	dbPropProcedureProfiling*	ProcedureProfiling
1.3.6.1.4.1.897.2.2.2.42.n	String	dbPropReadOnly	ReadOnly
1.3.6.1.4.1.897.2.2.2.43.n	String	dbPropRemoteTrunc	RemoteTrunc
1.3.6.1.4.1.897.2.2.2.44.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.45.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.46.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.47.n	String	dbPropSyncTrunc	SyncTrunc
1.3.6.1.4.1.897.2.2.2.48.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.49.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.50.n	String	dbPropTempFileName	TempFileName
1.3.6.1.4.1.897.2.2.2.51.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.52.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.53.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.54.n	String	dbPropNextScheduleTime	NextScheduleTime
1.3.6.1.4.1.897.2.2.2.55.n	String	dbPropIdentitySignature	IdentitySignature
1.3.6.1.4.1.897.2.2.2.56.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.57.n	String	dbPropSnapshotIsolationState	SnapshotIsolationState
1.3.6.1.4.1.897.2.2.2.58.n	String	dbPropConnsDisabled	ConnsDisabled
1.3.6.1.4.1.897.2.2.2.59.n	String	dbPropPartnerState	PartnerState
1.3.6.1.4.1.897.2.2.2.60.n	String	dbPropArbiterState	ArbiterState
1.3.6.1.4.1.897.2.2.2.61.n	String	dbPropMirrorState	MirrorState
1.3.6.1.4.1.897.2.2.2.62.n	String	dbPropAlternateServerName	AlternateServerName
1.3.6.1.4.1.897.2.2.2.63.n	String	dbPropEncryptionScope	EncryptionScope
1.3.6.1.4.1.897.2.2.2.64.n	String	dbPropNcharCharSet	NcharCharSet
1.3.6.1.4.1.897.2.2.2.65.n	String	dbPropNcharCollation	NcharCollation
1.3.6.1.4.1.897.2.2.2.66.n	String	dbPropAccentSensitive	AccentSensitive
1.3.6.1.4.1.897.2.2.2.67.n	String	dbPropSendingTracingTo	SendingTracingTo
1.3.6.1.4.1.897.2.2.2.68.n	String	dbPropReceivingTracingFrom	ReceivingTracingFrom
1.3.6.1.4.1.897.2.2.2.69.n	String	dbPropIOParallelism	IOParallelism
1.3.6.1.4.1.897.2.2.2.70.n	String	dbPropJavaVM	JavaVM
1.3.6.1.4.1.897.2.2.2.71.n	String	dbPropDatabaseCleaner	DatabaseCleaner
1.3.6.1.4.1.897.2.2.2.72.n	String	dbPropHasCollationTailoring	HasCollationTailoring
1.3.6.1.4.1.897.2.2.2.73.n	String	dbPropCatalogCollation	CatalogCollation
1.3.6.1.4.1.897.2.2.2.74.n	String	dbPropHasEndianSwapFix	HasEndianSwapFix
1.3.6.1.4.1.897.2.2.2.75.n	String	dbPropAlternateMirrorServerName	AlternateMirrorServerName
1.3.6.1.4.1.897.2.2.2.76.n	String	dbPropOptionWatchList	OptionWatchList
1.3.6.1.4.1.897.2.2.2.77.n	String	dbPropOptionWatchAction	OptionWatchAction
1.3.6.1.4.1.897.2.2.2.78.n	String	dbPropMirrorMode	MirrorMode
1.3.6.1.4.1.897.2.2.2.79.n	String	dbPropHasNCHARLegacyCollationFix	HasNCHARLegacyCollationFix
1.3.6.1.4.1.897.2.2.2.80.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.81.n	String	dbPropAuthenticated	Authenticated
1.3.6.1.4.1.897.2.2.2.82.n	String	dbPropSynchronizationSchemaChangeActive	SynchronizationSchemaChangeActive
1.3.6.1.4.1.897.2.2.2.83.n	String	dbPropLastCheckpointTime	LastCheckpointTime
1.3.6.1.4.1.897.2.2.2.84.n	String	dbPropMirrorServerState	MirrorServerState
1.3.6.1.4.1.897.2.2.2.85.n	String	dbPropDriveBus	DriveBus
1.3.6.1.4.1.897.2.2.2.86.n	String	dbPropDriveModel	DriveModel
1.3.6.1.4.1.897.2.2.2.87.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.88.n	String	dbPropMirrorRole	MirrorRole
1.3.6.1.4.1.897.2.2.2.89.n	String	dbPropWriteChecksum	WriteChecksum
1.3.6.1.4.1.897.2.2.2.90.n	String	dbPropApproximateCPUTime	ApproximateCPUTime
1.3.6.1.4.1.897.2.2.2.91.n	String	dbPropConnectedTime	ConnectedTime
1.3.6.1.4.1.897.2.2.2.92.n	String	dbPropReqCountUnscheduled	ReqCountUnscheduled
1.3.6.1.4.1.897.2.2.2.93.n	String	dbPropReqCountActive	ReqCountActive
1.3.6.1.4.1.897.2.2.2.94.n	String	dbPropReqCountBlockIO	ReqCountBlockIO
1.3.6.1.4.1.897.2.2.2.95.n	String	dbPropReqCountBlockLock	ReqCountBlockLock
1.3.6.1.4.1.897.2.2.2.96.n	String	dbPropReqCountBlockContention	ReqCountBlockContention
1.3.6.1.4.1.897.2.2.2.97.n	String	dbPropReqTimeUnscheduled	ReqTimeUnscheduled
1.3.6.1.4.1.897.2.2.2.98.n	String	dbPropReqTimeActive	ReqTimeActive
1.3.6.1.4.1.897.2.2.2.99.n	String	dbPropReqTimeBlockIO	ReqTimeBlockIO
1.3.6.1.4.1.897.2.2.2.100.n	String	dbPropReqTimeBlockLock	ReqTimeBlockLock
1.3.6.1.4.1.897.2.2.2.101.n	String	dbPropReqTimeBlockContention	ReqTimeBlockContention
1.3.6.1.4.1.897.2.2.2.102.n	String	dbPropInternal	Internal
1.3.6.1.4.1.897.2.2.2.103.n	String	dbPropLastCommitRedoPos	LastCommitRedoPos
1.3.6.1.4.1.897.2.2.2.104.n	String	dbPropLastWrittenRedoPos	LastWrittenRedoPos
1.3.6.1.4.1.897.2.2.2.105.n	String	dbPropLastSyncedRedoPos	LastSyncedRedoPos

SQL Anywhere MIB database properties

Descriptions

See also