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.

Related tasks