DB2 Version 9.7 for Linux, UNIX, and Windows

db2inspf - Format inspect results command

This utility formats the data from INSPECT CHECK results into ASCII format. Use this utility to see details of the inspection. The formatting by the db2inspf utility can be for a table or a table space, and errors, warnings, and summary can be specified either alone or in any combination thereof.

Authorization

Anyone can access the utility, but users must have read permission on the results file in order to execute this utility against them.

Required connection

None

Command syntax


                                  .--------------------------.   
                                  V                          |   
>>-db2inspf--data-file--out-file----+----------------------+-+-><
                                    +- -tsi--tablespace-id-+     
                                    +- -ti--table-id-------+     
                                    +- -e------------------+     
                                    +- -s------------------+     
                                    '- -w------------------'

Command Parameters

data-file: The unformatted inspection results file to format.
out-file: The output file for the formatted output.
-tsi tablespace-id: Table space ID. Format out only for tables in this table space.
-ti table-id: Table ID. Format out only for table with this ID, table space ID must also be provided.
-e: Format out errors only.
-s: Summary only.
-w: Warnings only.

Examples

To format all errors, warnings and summaries from the data file tbschk.log, execute the following:

db2inspf tbschk.log tbschk_esw.txt -e -s -w