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