IBM Security Guardium Ideas Portal

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Post your ideas

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.


Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.


Post an Idea

To post a new idea - click on the "Add a new idea" button and select the appropriate capability area this idea relates to. Do provide requested information to allow us to get a better understanding of your request. If 'Guardium Data Protection' capability is selected, you will be prompted to select the category/product the idea relates to. If you are not sure of the category/product your idea would fall under, then select 'IBM Guardium Other' in the drop down list and proceed from there.


Please note: The purpose of the Ideas Portal is to tap the creativity of the Guardium Data Protection community so that we can enhance the product for everyone! If you need to report a defect or get help, please use our normal support channel. Click here to open a support ticket.


For IBMers, click here to submit an idea on behalf of a customer, if the customer prefers to keep their use case and idea private.

Exclude schema lacking objects from consecutive classification scan

In Teradata there can be tens and thousands of user accounts and they appear as empty schemas. During the scans each classifier rule throws an error stating the result set contains zero rows. Each of these errors cost half a second or more delay/performance. If you have a large Teradata system with thousands of user accounts and a large number of rules in the policy, this can causes the classifier process to run for days.

java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 16.20.00.12] [Error 1323] [SQLState HY000] Cannot get data value for column 1 because the result set contains zero rows.

Cause:

InitializationException: Could not access column(s) for table: 'XYZABC10XYZ10001.' on 'jdbc:teradata://xyxz.abccompany.com/DBS_PORT=1025' in 0.44 second

SQLException: [Teradata JDBC Driver] [TeraJDBC 16.20.00.12] [Error 1323] [SQLState HY000] Cannot get data value for column 1 because the result set contains zero rows. SqlState: HY000 Error Code: 1323


At the beginning of the scan the classifier process can take an inventory of all the schemas and their size. Any schema with zero or few bytes would be an indication of empty schema. The classifier process can exclude all those schemas from being scan by any of the rules.

  • Guest
  • May 28 2021
  • Not under consideration
  • Admin
    NANCY MISKOWIEC commented
    8 Oct 07:48pm

    Hello. We are closing this Idea, because we now have a partnership with 1touch.io and resell their Inventa solution. We are not considering classification enhancements in Guardium Data Protection at this time. Thank you.

  • Admin
    RAJESH VENKATASUBBU commented
    1 Jun 06:25am

    Hello - thank you for your submission. We are looking into this request further, we will get back to you with our findings.


    Regards,

    Product Management Team

    IBM Data Security / Guardium

  • Guest commented
    28 May 01:54pm

    An example for Teradata to identify empty schemas

    SELECT databasenamei

    FROM DBC.Dbase

    WHERE databasenamei NOT IN (

    SELECT databasename

    FROM DBC.tables

    WHERE TABLEkind NOT IN ('M', 'V', 'P', 'F', 'E')

    GROUP BY 1)

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.