Find Database Fields (FNDDBFLD)
PCI, HIPAA, GLBA, Sarbanes Oxley, State Privacy laws, etc… there is more and more pressure for organizations to properly protect sensitive data such as credit card numbers, Social Security numbers, bank account numbers, etc.
In order to provide the best protection for any sensitive data that is stored on your system, you should seriously consider encryption as an option. But first you need to find where this data is stored.
You may know the names of some of the database files and fields which contain this sensitive data, but it is critical that no data is overlooked. The FNDDBFLD command solves this problem.
The Find Database Fields (FNDDBFLD) command allows you to find database fields (in physical files and tables) that contain values which meet your search criteria. For instance, you can quickly perform a search for any numeric fields that contain a 16 digit number (e.g. credit card numbers) or perform a search for any alpha fields that contain a numeric pattern like 999-99-999 or 999999999 (e.g. Social Security numbers).
FNDDBFLD Menu Screenshot:
FNDDBFLD Command Screenshot:
Multiple files and libraries can be searched with the FNDDBFLD command. It can search both numeric and character fields.
The search results are formatted in a report (spooled file). The report will indicate the following information for each database field that meets the selection criteria:
- File name
- Library name
- Field name
- Relative record number (RRN) of the data found (for the first match)
- The data found in the field (for the first match)
The System i is also referred to as IBM i, iSeries, AS/400, AS400 and i5