1#! /bin/sh
2#
3# $Id: resourceReport.sh 421 2007-04-05 15:46:55Z dhill $
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
17{
18echo " "
19echo "******************** Resource Usage Report for ${MODULE} ********************"
20echo " "
21
22echo " "
23echo "-- Shared Memory --"
24echo " "
25echo "################# ipcs -l #################"
26echo " "
27ipcs -l
28
29echo "################# clearShm -n #################"
30echo " "
31clearShm -n
32
33echo " "
34echo "-- Disk Usage --"
35echo " "
36echo "################# df -k #################"
37echo " "
38df -k
39
40echo " "
41echo "-- Disk BRM Data files --"
42echo " "
43ls -l /var/lib/columnstore/data1/systemFiles/dbrm 2> /dev/null
44ls -l /var/lib/columnstore/dbrm 2> /dev/null
45
46echo "################# cat /var/lib/columnstore/data1/systemFiles/dbrm/BRM_saves_current #################"
47echo " "
48cat /var/lib/columnstore/data1/systemFiles/dbrm/BRM_saves_current 2> /dev/null
49
50echo " "
51echo "-- View Table Locks --"
52echo " "
53echo "################# cat bin/viewtablelock #################"
54echo " "
55viewtablelock 2> /dev/null
56
57echo " "
58echo "-- BRM Extent Map  --"
59echo " "
60echo "################# bin/editem -i #################"
61echo " "
62editem -i 2>/dev/null
63
64} >> $OUT_FILE
65
66exit 0
67