Changing the insert algorithm for a table space by importing DML

To change the insert algorithm for a table space

1. Copy the DML statements from member ACMDMLUH in the HLQ.BMCCNTL data set.

2. Edit the DML statements (in the following figure) in an ISPF editor. Provide the information that is required for your site.For information about DML syntax, see CM-PILOT-Data-Manipulation-Language-DML.

   
   

   --  The example DML changes the INSERT ALGORITHM values to 2                     
   --  for all universal table spaces with member cluster in a database.           
   --                                                                              
   --  After you edit the DML statement, you can use CHANGE                        
   --  MANAGER to import it.                                                       
   --                                                                              
   --                                                                              
   UPDATE  TABLESPACE                                                              
   SET INSERTALG = 2          -- Set value for INSERT ALGORITHM                     
   WHERE                                                                           
   DBNAME =    'DEM0116A'     -- Specify database                                  
   AND TYPE IN ('R','G')      -- Limits changes to universal tablespaces           
   AND MEMBER_CLUSTER = 'Y'   -- that have member cluster                          
   ;                                                                               
3. Import the DML file.Now that the DML file has been imported, you can analyze a work ID and execute a worklist.