Db2 Administration Tool 12.1 - Running queries on Db2 table spaces with locking size = 'S'

On the DB2 Administration Menu (ADB2) panel, specify option 3, and press Enter.

The DB2 Performance Queries panel is displayed.

Specify option 5, and press Enter.

The DB2 Table Spaces With Locking Size = 'S' (ADB235) panel panel is displayed, as shown in the following figure:

Figure 1. DB2 Table Spaces With Locking Size = 'S' (ADB235) panel

 DB2 Admin --------- DB2X Table Spaces with Locking Size = 'S'------------------
 Command ===>                                                  Scroll ===> PAGE          
 																											            
 The following table spaces have locking size = 'S'. DB2 will use table space   
 locking when accessing a table in the table space. You probably only want	               
 locking size = 'S' for read-only tables or tables that are accessed by only one
 user (or batch job) at a time. Consider changing the locking size to 'A' (any  
 locking), for example, by altering the locksize with an ALTER SQL statement.            
                                                                                         
  Commands:       UT - Utilities                                                         
  Line commands:   S - Select      AL - Alter   
                                                
                       Lock Number of           
  S  DB Name  TS Name  Size    Tables           
     *        *         *                       
  -- -------- -------- ---- ---------           
										                    
     D402D10  D402SCIF    S         1																	
     D402D10  D402STIF    S         1																	
     D455D005 KBBSCOM     S         1																	
     D455D005 KBBSCTAB    S         1																	
     D455D005 KBBSIMS1    S         1																	
     D455D005 KBBSPRO     S         1																	
     D455D005 KBBSAPP     S         1

The following columns are on this panel:

S: Selects a table space when you use the S line command.
DB Name: The name of the database.
TS Name: The name of the table space.
Lock Size: The lock size of the table space.
Number of Tables: The number of tables defined in the table space.

Optional: Work with the table spaces by using the primary commands and line commands.

Db2 uses table space locking when it accesses a table in the table space. Only use locking size = 'S' for read-only tables or tables that are accessed by only one user (or batch job) at a time. If concurrency between updating tasks or updaters and readers is required, then consider changing the locking size to 'A' (any locking) by altering the locksize with an ALTER SQL statement.

The AL line command enables you to quickly perform an ALTER TABLESPACE statement to change the LOCK SIZE to ANY. Entering the AL line command is equivalent to entering the S line command followed by the AL line command, and then entering ANY in the LOCK SIZE field.

The O line command enables you to quickly move to the Batch Job Utility Parameters (ADB2UPA) panel. Entering the O line command is equivalent to entering S, UT, and O commands in succession.

Running queries on Db2 table spaces with locking size = 'S'

Procedure