It is critical to provide a high level of protection for sensitive data such as credit card numbers, Social Security numbers, bank account numbers and other identity information, notes Linoma Software. Besides maintaining the trust of their customers and employees, it is important that organizations don't fall out of compliance with PCI, HIPAA, GLBA, Sarbanes Oxley and State Privacy laws, according to the company.

Before you can begin to encrypt sensitive data on your systems, you need to first know all the places it is located. For IBM i customers, this data is likely stored throughout various database files and fields in one or more libraries. Your IT staff may remember the names of some of the files/fields that contain this confidential information, but it is critical that no elements are overlooked. The new Find Database Fields (FNDDBFLD) tool from Linoma Software solves this problem.

FNDDBFLD locates database fields (in physical files and tables) containing 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-9999 or 999999999 (e.g. Social Security numbers or Canadian Social Insurance numbers).

The FNDDBFLD tool produces a detailed report for any fields that match your parameters. For each field listed, the report indicates the field's name, its file name and library. The report also shows the match of the data found for the field, as well as its relative record number.

FNDDBFLD is being provided by Linoma Software at no charge. Bob Luebbe, chief architect at Linoma Software, says "This is a tool we wanted to provide all IBM i customers and auditors as a public service so they can quickly find out where they have exposures. This is even a great tool for those organizations that are already doing field encryption, since they can use FNDDBFLD to make sure they didn't miss anything."

FNDDBFLD runs on IBM i OS release V5R2 and later, and requires only 1 MB of disk space. Download the FNDDBFLD tool from: Linoma Software tool.

Founded in 1994, Linoma Software provides innovative technologies for protecting sensitive data and automating data movement. Linoma Software has a diverse install base of over 3,000 customers around the world including corporations, non-profit organizations and government entities.

Linoma will we'll be presenting a Webinar on how the Find Database Fields tool works that will be held at noon (CDT) Thursday, June 18. Readers may register for the Webinar here.

For further information, contact Brian Pick, Linoma Software, at This email address is being protected from spambots. You need JavaScript enabled to view it. or call 402-944-4242 ext 712.

Founded in 1994, Linoma Software provides innovative technologies for protecting sensitive data and automating data movement. Linoma Software has a diverse install base of over 3,000 customers around the world including Fortune 500 companies, non-profit organizations and government entities. Linoma’s success has been built on being very responsive to its customers' requirements. Suggestions on how the company can improve its products to better serve your organization are always welcome. Readers are encouraged to review the many positive testimonials on the company's web site. Customer references can also be supplied upon request. Linoma Software is dedicated to its install base of enterprise platforms and maintains professional partnerships with user groups, data security policy groups, and operating system companies.