Create Table Space: Locking Options panel
You use the Create Table Space: Locking Options panel to specify information to define the locking options for the table space to be created.
Panel and field definitions
Process Options Utilities Help
FM/Db2 (DFG2) Create Table Space: Locking Options
Locking Options:
Locksize parameter
1. ANY Db2 determines the appropriate lock size
2. Table space
3. Table segmented table spaces only
4. Page not for LOB table spaces
5. Row not for LOB table spaces
6. LOB only for LOB table spaces
Application Locking:
Maximum Locks . . . . (SYSTEM (default) or 0-2147483647)
Command ===>
F1=Help F2=Split F3=Exit F4=CRetriev F7=Backward F8=Forward
F9=Swap F10=Actions F12=Cancel
- Locksize parameter
- Specify the LOCKSIZE parameter:
- 1. ANY
- Specifies Db2® can use any lock size.
- 2. Table space
- Specifies Db2® can use table space lock.
- 3. Table
- Specifies Db2® can use table locks.
- 4. Page
- Specifies Db2® can use page locks.
- 5. Row
- Specifies Db2® can use row locks.
- 6. LOB
- Specifies Db2® can use LOB locks.
- Maximum Locks
- The maximum number of page, row, or LOB locks an application process
can hold simultaneously in the table space. Valid values are: 0–2147483647
or
SYSTEM
.
Parent panels
Child panels
None.