analytics/informix/isa/max_nrows.sql

select 
  max(ti_nrows) 
from 
  systabinfo 
where 
  ti_partnum in (
    select 
      partnum 
    from 
      systabnames 
    where 
      dbsname not in ("sysmaster","sysuser","sysutils","sysadmin")
      and partnum not in (select partnum from sysptnkey)
      and tabname not in 
        ("systables","syscolumns","sysindices","systabauth",
         "syscolauth","sysviews","sysusers","sysdepend",
         "syssynonyms","syssyntable","sysconstraints","sysreferences",
         "syschecks","sysdefaults","syscoldepend","sysprocedures",
         "sysprocbody","sysprocplan","sysprocauth","sysblobs",
         "sysopclstr","systriggers","systrigbody","sysdistrib",
         "sysfragments","sysobjstate","sysviolations","sysfragauth",
         "sysroleauth","sysxtdtypes","sysattrtypes","sysxtddesc",
         "sysinherits","syscolattribs","syslogmap","syscasts",
         "sysxtdtypeauth","sysroutinelangs","syslangauth","sysams",
         "systabamdata","sysopclasses","syserrors","systraceclasses",
         "systracemsgs","sysaggregates","syssequences","sysdirectives",
         "sysxasourcetypes","sysxadatasources","sysseclabelcomponents",
         "sysseclabelcomponentelements","syssecpolicies","syssecpolicycomponents",
         "syssecpolicyexemptions","sysseclabels","sysseclabelnames",
         "sysseclabelauth","syssurrogateauth","sysproccolumns",
         "sysdomains","sysindexes","TBLSpace"));