1#! /bin/sh 2# 3# $Id: dbmsReport.sh 4# 5if [ $1 ] ; then 6 MODULE=$1 7else 8 MODULE="pm1" 9fi 10 11if [ $2 ] ; then 12 OUT_FILE=$2 13else 14 OUT_FILE=${MODULE}_logReport.txt 15fi 16 17if [ $3 ] ; then 18 MCSSUPPORTDIR=$3 19else 20 MCSSUPPORTDIR="/usr/share/columnstore" 21fi 22 23if [ $4 ] ; then 24 PW_PROMPT=$4 25else 26 PW_PROMPT="" 27fi 28 29{ 30 31columnstoreMysql="mysql -u root ${PW_PROMPT} " 32 33if ${columnstoreMysql} -V > /dev/null 2>&1; then 34 echo " " 35 echo "******************** DBMS Columnstore Version *********************************" 36 echo " " 37 ${columnstoreMysql} -e 'status' 38 echo " " 39 echo "******************** DBMS Columnstore System Column ***************************" 40 echo " " 41 ${columnstoreMysql} -e 'desc calpontsys.syscolumn;' 42 echo " " 43 echo "******************** DBMS Columnstore System Table ****************************" 44 echo " " 45 ${columnstoreMysql} -e 'desc calpontsys.systable;' 46 echo " " 47 echo "******************** DBMS Columnstore System Catalog Data *********************" 48 echo " " 49 ${columnstoreMysql} calpontsys < $MCSSUPPORTDIR/dumpcat_mysql.sql 50 echo " " 51 echo "******************** DBMS Columnstore System Table Data ***********************" 52 echo "******************** DBMS Columnstore Databases *******************************" 53 echo " " 54 ${columnstoreMysql} -e 'show databases;' 55 echo " " 56 echo "******************** DBMS Columnstore variables *******************************" 57 echo " " 58 ${columnstoreMysql} -e 'show variables;' 59 echo " " 60fi 61} >> $OUT_FILE 62 63exit 0 64 65