Deleting an active log data set

Beginning in Db2® 13, you can remove an active log data set from the bootstrap data set (BSDS) while Db2 is running.

Before you begin

Ensure that the active log data set that you want to delete meets the Db2 requirements for deletion, as specified in Deleting an active log data set from the BSDS with the -SET LOG command (Db2 13 for z/OS documentation) .

Procedure

To delete an active log data set:

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

On the System Administration (ADB2Z) panel, specify option LR, and press Enter.

If Db2 Admin Tool could not find the BSDS name, a pop-up window is displayed so that you can manually specify the name.

Otherwise, the Manage Log Data Sets (ADB2ZLRP) panel is displayed:

Figure 1. Manage Log Data Sets (ADB2ZLRP) panel

ADB2ZLRP  ------------------ DD1A Manage Log Data Sets ------------------ 09:59
Option ===>                                                                    
                                                                               
                                                                               
   1 - Show the list of active log data sets             DB2 System: DD1A      
   2 - Issue SET LOG REMOVELOG                           DB2 SQL ID: ADM001    
                                                                               
 Bootstrap data set name . . . 'DD1A.BSDS01'

Specify option 1, and press Enter to look up the log data set that you want to delete.

Option 1 executes the Db2 stand-alone utility DSNJU004 and requires that you have access to the BSDS.

Alternatively, you can specify option 2 to manually enter the data set name and log copy number.

On the LOG Data Sets (ADB2ZLR) panel, specify the SRL line command next to the active log data set that you want to delete:

Figure 2. LOG Data Sets (ADB2ZLR) panel

 ADB2ZLR n ----------------- DD1A LOG Data Sets --------------- Row 1 to 6 of 6 
 Command ===>                                                  Scroll ===> PAGE 
                                                                                
 Line commands:                                                                 
  SRL - SET REMOVELOG  ? - Show all line commands                               
                                                                                
 Sel  DSN                                          Cur Copy Tr New Reus St      
      *                                            *      * *  *   *    *       
 ---- -------------------------------------------- --- ---- -- --- ---- --      
      DD1A.LOGCOPY1.DS02                           N      1 N  N   Y    N       
 SRL  DD1A.LOGCOPY1.DS03                           N      1 N  N   Y    N       
      DD1A.LOGCOPY1.DS01                           Y      1 N  N   N    N       
      DD1A.LOGCOPY2.DS02                           N      2 N  N   Y    N       
      DD1A.LOGCOPY2.DS03                           N      2 N  N   Y    N       
      DD1A.LOGCOPY2.DS01                           Y      2 N  N   N    N       
 ******************************* END OF DB2 DATA *******************************

Note: You cannot delete the current active log data sets.

On the Remove Active Log Data Set (ADB2ZLR2) panel, confirm the information, and press Enter to issue the Db2 SET LOG command with the REMOVELOG and COPY options.

Figure 3. Remove Active Log Data Set (ADB2ZLR2) panel

 ADB2ZLR2  -------------- DD1A Remove Active Log Data Set ---------------- 10:26
 Command ===>                                                                   
                                                                                
                                                                                
  -SET LOG                                                                      
   REMOVELOG . . . . . . . . DD1A.LOGCOPY1.DS02                                 
   COPY  . . . . . . . . . . 1   (1/2)

The result of the SET LOG command is displayed, including any error messages from Db2.

After the data set is removed from the BSDS, you must still physically delete the data set outside of Db2.