Tag: Actian Matrix

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

The credit for this script goes to Graham Mossman ### ### housekeeping.bash ### ### Usage: ### ./housekeeping.bash ### ### Description: ### Script to run the various regular housekeeping jobs for a given database. ### source /home/paraccel/.bashrc # this…

Read More »

Troubleshoot Redshift / Paraccel COPY command load errors

The scripts below can be used on both Amazon Redshift and Actian Matrix (Paraccel) for operations related to COPY commands. Number of rows inserted by each succesful COPY command SELECT starttime, querytxt, lines_scanneD FROM stl_query NATURAL JOIN stl_load_commits…

Read More »
Bitnami