DB2 Server for VSE & VM: Data Restore Guide

Step 3. Determine If You Need to Reformat a DBEXTENT

For VM users: Before you execute the RESTORE function, you must decide if a minidisk needs redefining. If you need to redefine a minidisk, use the CMS FORMAT command and the RESERVE command. For details, refer to the section about replacing a minidisk in the DB2 Server for VSE System Administration or DB2 Server for VM System Administration manuals.

VSE users: Before you execute the RESTORE function, you must decide if the dbextent needs reformatting. For example, if the dbextent is damaged or has been redefined to a different location, it requires reformatting. If you need to reformat the dbextent, use a job similar to the one shown in Figure 76 in Step 3A. Using the FORMAT Function (VSE Only). Otherwise, you can start restoring your database as shown in Step 4. Starting the RESTORE Function.

Step 3A. Using the FORMAT Function (VSE Only)

When a disk is damaged or you move a dbextent to a different volume, redefine the dbextents using the IDCAMS DEFINE CLUSTER command. Before restoring the database, you must prepare the defined cluster for DB2. The FORMAT function does this process as shown in Figure 76.

Use the FORMAT command to format a VSE/VSAM defined file in the DB2 Server for VSE required format.

Using the FORMAT Command

Figure 76 shows an example of using the the FORMAT function.

Figure 76. FORMAT Function Example

// JOB FORMAT (1) ---> // LIBDEF *,SEARCH=(PRD2.DB2vrm,PRD2.RCVvrm) (2) ---> // EXEC PROC=ARIS71DB // EXEC XTS91001,SIZE=AUTO (3) ---> CONTROL DBNAME=dbname (4) ---> FORMAT DDSK=5 /*

Statement 1

Specifies the DB2 for VSE and Data Restore libraries for the FORMAT function.

Statement 2

Contains all DLBL defining the directory, log, and all dbextents.

Statement 3

Points to the appropriate database.

Statement 4

Formats the disk that was damaged.