BACKOM command examples

Edit online

Commands for certain tasks such as verifying and saving a IBM Storage Protect™ password are shown in the following examples.

Use the following command to verify and save a IBM Storage Protect password:
```
backom -c password
```
Use the following command to create a list of all available backup objects sent to IBM Storage Protect by IBM Storage Protect for Enterprise Resource Planning for DB2®:
```
backom -c q_all
```
Use the following command to create a list of all DB2 log files for the SAMPLE database. The log number is greater than 123 and it is created in November 2002 with normal output detail level:
```
backom -c q_log -a SAMPLE -l 124-9999999 -t 200211* -m normal
backom -c q_log -a SAMPLE -l S0000124.log-S9999999.log -t 200211* -m normal
```
Use the following command to create a list of DB2 log files for log chains 5 - 15 for the SAMPLE database. The log numbers range is 98 - 180 and it is archived from 4 p.m. to 8.30 p.m.:
```
backom -c q_log -a SAMPLE -k C0000005-C0000015 -l 98-180 -t ????????16*-????????2030*
```
Use the following command to create a list of all table space backups. The list is for partition NODE0001, in the SAMPLE database SAMPLE, and for the backups that were created in November 2002 from 4 p.m. to 5 p.m.:
```
backom -c q_ts -a SAMPLE -n NODE0001 -t 200211??16*
```
Use the following command to backup online database SAMPLE by using two I/O sessions and four backup buffers:
```
backom -c b_db -a SAMPLE -S 2 -B 4 -O
```
Use the following command to backup the table spaces SYSCATSPACE and USERSPACE1 of database SAMPLE, by using the execution profile initSAMPLE.utl at /db2/SAMPLE/config:
```
backom -c b_db -a SAMPLE -T SYSCATSPACE,USERSPACE1 -e /db2/SAMPLE/config/initSAMPLE.utl
```
Use the following command to restore a table space of database SAMPLE with the table space backup created on November 27, 2002, at 6:32:15 p.m.:
```
backom -c r_ts -a SAMPLE -t 20021127183215 
```
Use the following command to restore database SAMPLE with the latest backup:
```
backom -c r_db -a SAMPLE
```
Use the following command to delete all DB2 log files for database SAMPLE that were created before June 2002:
```
backom -c d_log -a SAMPLE -t 1900*-20020601000000
```
Use the following command to delete all versions of files that contain tmp in their path or file names that were sent to IBM Storage Protect by IBM Storage Protect for Enterprise Resource Planning:
```
backom -c d_raw -f *tmp*
```