Re: update statistics

Posted in 1998

Art S. Kagel — Thu, 09 Jul 1998 18:10:00 -0400 — source: Informix-list mailing list archive (1991-1998)

Paul wrote: > > I am trying to run update statistics from cron. I keep getting database > closed messages. But I can connect to the database and run update > statistics interactively. > do I have to submit a password when I connect to the database? No but your cron job may not have the proper environment variables set. Best to make the cron job a script that first sets the required vars: INFORMIXSERVER INFORMIXDIR PATH=$INFORMIXDIR/bin:$PATHONCONFIG etc. Art S. Kagel