Skip to main content

Search

Welcome to Tibero GTS!

Checking the Number of Accessible Sessions According to the INITRANS Value

Document Type | Technical Information

Category | Administration

Applicable Product Version | 7FS02PS

Document Number | TADTI189

 

Overview

INITRANS explains the method to check the differences according to the setting value.

INITRANS is set to a default value of 2 if not specified separately, which means that up to 2 sessions can access the same block simultaneously.

INITRANS value of 2 means that when a third session tries to access the block, it will wait until the existing work is completed.

In other words, the number of sessions that can access simultaneously varies depending on the INITRANS value.

 

 

Method

1-1. Situation When Sessions Wait with INITRANS Set to 2

  • When INITRANS is 2, if a third session tries to access the same block, the session waits until the existing work is completed.

     

1-2. Verification via Block Dump

  • Two sessions can be confirmed in ITL from the block dump results.

 

 2-1 Situation When Sessions Wait with INITRANS Set to 5

  • When INITRANS is 5, even if a third session accesses the same block, unlike when INITRANS is 2, the third session does not wait.

 

 

2-2. Verification via Block Dump

  • From the block dump results, 5 ITLs can be confirmed, and among them, it can be seen that there are 3 sessions in flag A state.