nulldb2data-profiling

Db2 tables - finding all blank columns in a table that has 100+ columns

I have a table with 78 columns and 100k rows. Is there a way to find all the blank columns in the table without querying on each column to find their counts?

Running a not null query is time consuming and not feasible for whatever I am trying to do when the table has 100+ rows!! I did run a count query on the column, which resulted in no. of blank values VS no.of other values in the column but running such a county query on all 78 columns is not a feasible option.

Any other easy ways to do this?

Solution

  • Run runstats on the table

    After that examine SYSCAT.COLUMNS and check out NUMNULLS

    SELECT HIGH2KEY, LOW2KEY, NUMNULLS
FROM SYSCAT.COLUMNS
WHERE TABNAME = '<yourtable>'

    Details for these columns can be found here