IDS Forum

how to install & run do_stats

Posted By: KAMRAN HAQ
Date: Wednesday, 10 June 2009, at 7:55 a.m.

I tried to run do_stats but failed below are the results (commands used and their output). Morevoer I tested the results for update statistics on different machines and found no performance gain whether I "set pdqpriority" or not. Also when we update the stats for certain columns the corresponding procedures (which are using these columns) get problems because of sysprocplan. So would we do "update statistics for procedures" on every "update statistics medium/high for tableName(columnName)" ?

---------------------------------------------------------------------
-- do_stats results
---------------------------------------------------------------------

-- installation
# sh utils2_ak

-- output
utils2_ak: md5sum: not found
Note: not verifying md5sums. Consider installing GNU coreutils.
x - created lock directory `_sh07999'.
x - extracting BUILDING (text)
x - extracting README.1st (text)
x - extracting myschema.README (text)
x - extracting Makefile (text)
x - extracting drive_dostats (text)
x - extracting mydbdiff (text)
x - extracting getopt.h (text)
x - extracting getopt.c (text)
x - extracting dbcopy.ec (text)
x - extracting dbdelete.ec (text)
x - extracting dbstruct.ec (text)
x - extracting dostats.ec (text)
x - extracting listdb5.ec (text)
x - extracting listdb7.ec (text)
x - extracting printfreeB.ec (text)
x - extracting sqlstruct.ec (text)
x - extracting ul.ec (text)
x - extracting myschema.source.ar (text)
x - removed lock directory `_sh07999'.

-- trying to run dostats
# ./drive_dostats 1 db_monitoring -x table_io

-- output
excl= /tmp/drive_dostats
excludes=
file=/tmp/drive_dostats

Database selected.

create temp table dr_dostat_excl (tabname char(128)) with no log;
Temporary table created.

load from "/tmp/drive_dostats" insert into dr_dostat_excl;
846: Number of values in load file is not equal to number of columns.

847: Error in load file line 1.
Error in line 1
Near character position 58

select count(*) from dr_dostat_excl;

(count(*))

0

1 row(s) retrieved.

unload to "/tmp/drive_dostats.18519.unl"
select tabname
from systables
where tabid > 99
and tabname matches "*"
and tabname NOT IN (SELECT tabname from dr_dostat_excl);
16 row(s) unloaded.

Database closed.

Database selected.

create temp table dostats_tables (tabname char(128)) with no log;
Temporary table created.

load from "/tmp/drive_dostats.18519.unl"
insert into dostats_tables;
16 row(s) loaded.

unload to "/tmp/drive_dostats.18519.unl"
select stn.tabname, sum(nrows)
from systabnames stn, sysptnhdr sp, dostats_tables dt
where stn.dbsname = "db_monitoring"
and stn.partnum = sp.partnum
and dt.tabname = stn.tabname
group by 1
order by 2 desc;
16 row(s) unloaded.

Database closed.

ARGS are: table_io
dostats -d db_monitoring -t none -i@/tmp/drive_dostats.18519.0 table_io
Waiting for copies of dostats to complete
Dostats complete logfiles are:

/tmp/drive_dostats.18519.0.log

-- contents of file created
# cat drive_dostats.18519.0.log

-- output
./drive_dostats[164]: dostats: not found

Messages In This Thread

• how to install & run do_stats
  KAMRAN HAQ -- Wednesday, 10 June 2009, at 7:55 a.m.
  • Re: how to install & run do_stats
    Art Kagel -- Wednesday, 10 June 2009, at 9:36 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.