Blog

Paraccel - Script to run the various regular housekeeping jobs for a given database.

Posted by Irtaza Hassan on November 17, 2014 at 6:40 AM

The credit for this script goes to Graham Mossman

###

### housekeeping.bash

###

### Usage:

### ./housekeeping.bash <database>

###

### Description:

### Script to run the various regular housekeeping jobs for a given database.

###

source /home/paraccel/.bashrc # this is how $housekeeping_log_dir is set

today=`date +%Y-%m-%d`

database=$1

logfile=`echo ${housekeeping_log_dir}/housekeeping_${database}_${today}.log`

echo "Starting housekeeping for $database at `date`" > $logfile 2>&1

echo "starting analyze at `date`" >>$logfile 2>&1

echo "analyze"|psql $database >> $logfile 2>&1

echo "starting vacuum at `date`" >> $logfile 2>&1

echo "vacuum"|psql $database >> $logfile 2>&1

echo "starting vacuumcat at `date`" >> $logfile 2>&1

echo "vacuumcat"|psql $database >> $logfile 2>&1

echo "starting indexcat at `date`" >> $logfile 2>&1

echo "indexcat"|psql $database >> $logfile 2>&1

echo "Ending housekeeping for $database at `date`" >> $logfile 2>&1

 

 

 

Categories: Actian Matrix (Paraccel)

Post a Comment

Oops!

Oops, you forgot something.

Oops!

The words you entered did not match the given text. Please try again.

Already a member? Sign In

41 Comments

Reply Jamosdoozy
7:31 AM on May 31, 2021 
Terrific information. Regards.
https://topessaywritingbase.com/
Reply Jamosdoozy
7:04 AM on June 3, 2021 
Incredible a good deal of superb facts.
https://englishessayhelp.com/
essay writer funny
homework help cpm
how to write argumentative essays
help writing paper
how to buy essays online
essay typer
how to write a good descriptive essay
best essay writing services
writing an essay steps
coursework
help essay 123
coursework
pay for college essays
https://kehillathisrael.webs.com/apps/guestbook/
Reply Jamosdoozy
7:55 PM on June 3, 2021 
Regards, I enjoy this.
https://scoringessays.com/
write my essay affordable
paper help
write a college essay
argumentative essay
steps to writing a good essay
good thesis statement
writing essay for college
write papers
college essay funny
define thesis
top essay editing service
essays writer
what to write an essay about
https://kehillathisrael.webs.com/apps/guestbook/
Reply Jamosdoozy
9:11 AM on June 4, 2021 
Truly a lot of valuable advice!
https://theessayswriters.com/
essay writing services for cheap
essay writing services
college essays on diversity
phd thesis help
improving essay writing
dissertation
writer essay
how to write a thesis statement
essay 123 help
dissertations
how to write a five paragraph essay
my homework
mit college essays
https://kehillathisrael.webs.com/apps/guestbook/
Reply Jamosdoozy
10:47 AM on June 5, 2021 
Nicely put. Thanks.
https://definitionessays.com/
steps to writing a college essay
dissertation online
autobiography essay for college
help thesis writing
editing essay services
paper writing service
college education essay
thesis editing
essay about reading and writing
dissertation
writing essays for scholarships
paper writing
admissions essay help
https://contest101.webs.com/apps/guestbook/
Reply Jamosdoozy
12:06 AM on June 7, 2021 
Really all kinds of terrific info.
pharmacy online store
https://teaguethygesen32.webs.com/apps/blog/show/49070831-dora-th
e-explorer-bikes
Reply Jamosdoozy
2:48 AM on June 8, 2021 
Kudos, Loads of posts.
https://scoringessays.com/
help write essay online
https://bestessayscloud.com/
analysis essay writing
https://theessayswriters.com/
essays service
https://dissertationwritingtops.com/
best essay for you
https://warren79dreier.webs.com/apps/blog/show/47470010-kebiasaan
-memperoleh-website-sakong-nomor-satu
Reply Jamosdoozy
3:41 AM on June 9, 2021 
You actually revealed this really well!
https://writingthesistops.com/
persuasive essay on why college athletes should be paid
https://topessayservicescloud.com/
writing a hook for an essay
https://essaypromaster.com/
essay prompts college
https://quality-essays.com/
how to write a citation in an essay
https://melton.webs.com/apps/guestbook/
Reply Jamosdoozy
5:29 AM on June 10, 2021 
Reply Jamosdoozy
6:27 AM on June 11, 2021 
You actually stated it well.
https://definitionessays.com/
admission essay writing
https://essayssolution.com/
how to write a reflective essay
https://englishessayhelp.com/
write a personal essay
https://freeessayfinder.com/
personal statement college essay
https://fueltanksaustralia.webs.com/apps/blog/show/49894999-fleet
-administration-and-also-fuel-savings
Reply Jamosdoozy
8:46 AM on June 12, 2021 
Thank you. Fantastic stuff!
https://freeessayfinder.com/
custom essay toronto
https://topessaywritinglist.com/
quotes about writing essays
https://theessayswriters.com/
essays on college life
https://topessayssites.com/
how to write the conclusion of an essay
https://berrysatin5.webs.com/apps/blog/show/46061217-guidelines-t
o-opt-for-the-best-digital-marketing-agency
Reply Jamosdoozy
10:13 AM on June 13, 2021 
Great postings. Appreciate it.
https://homeworkcourseworkhelps.com/
how to write a really good essay
https://quality-essays.com/
reflective writing essay
https://definitionessays.com/
websites for essays in english
https://service-essay.com/
college transfer essay
https://eamkbi.webs.com/apps/guestbook/
Reply Jamosdoozy
7:09 AM on June 15, 2021 
Appreciate it. Lots of facts!
https://www.saratogaschools.org/webpages/popup_info.cfm?photoslid
eshow=1387458&staffdir=https://cadmed-bb.com
http://www.www.oaklandsprimarybromley.co.uk/bromley/primary/oakla
nds/site/pages/enrichment/scienceschoolproduction/CookiePolicy.ac
tion?backto=https://cadmed-bb.com
https://maps.google.sm/url?q=https://cadmed-bb.com
https://www.freeturbate.com/external_link/?url=https://cadmed-bb.
com
http://www.flygs.org/LinkClick.aspx?link=https://cadmed-bb.com

https://ogdendotson7.webs.com/apps/blog/show/49636572-ogrodzenia-
asfaltowe-pustak-pi-281-kni-347-