DB2 Recovery Expert for Multiplatforms

Chapter 6. Point-in-time recovery 139

-f Specifies the fully qualified output file name without

extension. The format should be SQLxxxxx where xxxxx is

the table ID with leading zeros so that it is 5 digits in total. In

this case the table ID is 13 so the filename should be

SQL00013.

The above command produces the SQL00013.DAT file, which is the new data file

for the table (extracted from the backup image).

6.14.3 Determine the table space directory

Now we need to determine the directory where the table space resides, which is

where we need to put the table data file. Example 6-4 shows the command we

use to do this, and its output.

Example 6-4 ...