sdsGetTransactions

sdsGetTransactions(transactions: JadeDynamicObjectArray input);

The sdsGetTransactions method of the JadeDatabaseAdmin class, valid only at secondary database systems, creates and populates an SDSTransaction dynamic object for each active transaction that is currently being replayed or isolated on the executing secondary system and returns these transaction dynamic objects in the transactions input array.

The SDSTransaction instances returned in the transactions array have a name attribute value of SDSTransaction and type attribute value of SDS_TransactionType (4).

The transaction dynamic attributes are listed in the following table.

Name	Type	Description
startTime	TimeStamp	Time at which the transaction started
status	Integer	Transaction status (see the following table)
statusText	String	Descriptive text that is displayed for the transaction status
transactionID	Decimal	Identifier of the transaction
userName	String	Name of the user

The values of the transaction status attribute represented by one of the SDSTransactionStates category global constants are listed in the following table.

Global Constant	Integer Value
SDS_TranNormal	1
SDS_TranInterrupted	2
SDS_TranDeferred	3
SDS_TranWaitingAuditCommit	4
SDS_TranReadyToCommit	5
SDS_TranPrepareToCommit	6
SDS_TranReadyToAbort	7
SDS_TranInDoubt	8

The only value of interest to most users is SDS_TranInterrupted. When there are active transactions in an interrupted state, read-access to persistent objects is not permitted. See also the sdsEnableReadAccess and sdsEnableReadAccessAt methods, earlier in this chapter.

The caller is responsible for deletion of these transient dynamic objects. Deletion is best achieved by purging the array when the entries have been processed.