MON$ATTACHMENTS

[Tomasz Dubiel]

Connection state:
0 - idle

1 - active

Hello. When does a connection become idle? Is it after some time when the attachment perform no operations?

Best regards,

Tomasz.

[Dimitry Sibiryakov]

Tomasz Dubiel wrote 17.06.2024 14:55:
> When does a connection become idle? Is it after some time when the attachment
> perform no operations?

When it does not execute any request. So yes, immediately after it has
finished an operation.

--
WBR, SD.

[Tomasz Dubiel]

So when an atachment has no active transaction, its idle. When it opens any transaction, it is active until it commits or rollbacks?

Best regards.

[Dimitry Sibiryakov]

Tomasz Dubiel wrote 17.06.2024 15:02:
> So when an atachment has no active transaction, its idle. When it opens any
> transaction, it is active until it commits or rollbacks?

No, it is not about transactions but requests.
Take it this way: attachment is busy while it executes any API call. As soon
as control is returned to the application - attachment is idle. (This is not
entirely true but this approach is close enough.)

--
WBR, SD.

[Tomasz Dubiel]

OK, thanks.