Informix Script

cedan · #1 (**permalink**) 09-15-10, 11:25

Script broken after informix 11.5 upgrade. We recently let go our informix guy and I'm attempting to fix a broken script while in between database people. If anybody can see as to why this script doesn't work anymore I would be eternally greatful.

Thanks

Code:

#!/bin/csh -f


execute_sql sysmaster \
    select b.name\[1,20\], \
           sum\(chksize\) size, \
           round\(100 - \(\(sum\(nfree\) \/ sum\(chksize\)\) \* 100\)\) \
                  pct_used, \
           round\(\(sum\(nfree\) \/ sum\(chksize\)\) \* 100\) \pct_avail \
      from syschunks a, sysdbspaces b \
     where a.chknum \= b.dbsnum \
     group by 1 order by 1;

InformixWilli · #2 (**permalink**) 09-22-10, 12:55

I dont know "execute_sql" but the statement is correct

Code:

echo '
select b.name[1,20], 
       sum(chksize) size,
       round(100 - ((sum(nfree) / sum(chksize)) * 100)) 
              pct_used,
       round((sum(nfree) / sum(chksize)) * 100) pct_avail
  from syschunks a, sysdbspaces b
 where a.chknum = b.dbsnum
 group by 1 order by 1;' | dbaccess sysmaster

Can you give me an error code or something like this?

(tested with 11.50.UC6DE)

Internet Services

Web Development

Digital Marketing

Consumer Tech