ANALYZEPART example: Specifying the number of partitions

Edit online

If you know how many partitions you want to split the database into, you can use the PARTNUM parameter to specify this number.

To specify the number of partitions, use the sample member IHCEMAI1. The following example simulates splitting a database into two partitions:

Figure 1. Sample JCL (IHCEMAI1) for batch using PARTNUM

//ANAPART   JOB CLASS=A,MSGCLASS=X                                      
//*-------------------------------------------------------------------  
//*           Create partition boundary report                          
//*           read database and report on 2 partitions                  
//*-------------------------------------------------------------------  
//S2     EXEC PGM=IHCHALDB,DYNAMNBR=999,                                
//            REGION=80M                                                
//STEPLIB  DD DISP=SHR,DSN=your.SIHCLOAD                              
//         DD DISP=SHR,DSN=your.SDFSRESL
//         DD DISP=SHR,DSN=your.SHPSLMD0                              
//DFSRESLB DD DISP=SHR,DSN=your.SDFSRESL                              
//IMS      DD DISP=SHR,DSN=your.DBDLIB                                  
//IMSDALIB DD DISP=SHR,DSN=your.MDALIB                                  
//TRACE    DD DUMMY                                                     
//MSGPRINT DD SYSOUT=*                                                  
//IHCLIST  DD SYSOUT=*
//IHCSYSIN DD *                                                         
  ANALYZEPART DBD(xxx) -                                                
           PARTNUM(2)

If the database that you specify for the DBD parameter is a HALDB database, you must specify the PARTITION or the PARTLIST parameter. If the DBD parameter specifies a non-HALDB database, do not specify the PARTITION or the PARTLIST parameter.

For example, if you want to split a HALDB database into four partitions, change the PARTNUM value to 4 and specify the PARTITION parameter.

//IHCSYSIN DD *
  ANALYZEPART DBD(xxx) - 
              PARTNUM(4) -
              PARTITION(*)