dblist.sh.txt

管理online的shell程序

#!/usr/bin/ksh
###############################################################################
#
#       Module:         dblist.sh
#       Author:         Peter R. Schmidt
#       Description:    List all databases on the system
#
#       Change Log
#
#         Date    Name               Description.................
#       07/28/99  Peter R. Schmidt   Start Program 
#
###############################################################################

OUTPUT=dblist.out
TMPFILE=dblist.tmp

XDATE=`date +%D-%T`
MACHINE=`uname -n`

tput clear				# clear screen

if [ -f $OUTPUT ]
then
        rm -f $OUTPUT
fi

if [ -f $TMPFILE ]
then
        rm -f $TMPFILE
fi

echo
echo "Collecting database info from the sysmaster database..."
        
dbaccess <<-EOF
database sysmaster;
unload to '$TMPFILE' delimiter "|"
select  dbinfo("DBSPACE",partnum) dbspace,        
	name,
        owner,        
	created,
	is_logging,        
	is_buff_log,
	is_ansi,
	is_nls,
	flags
from sysdatabases
order by name, dbspace;
EOF

echo "Completed - creating report..."

awk ' \

BEGIN {
	FS="|"
	cnt_db=0
}

{
	if (NR == 1) {
       		split (xdate,b,"-")
       		udate=b[1]
       		utime=b[2]
	
       		printf "%s %s      Informix Database Report     for %s@%s\n\n", udate, utime, server, machine
		print "Database        Dbspace                Date      Logging Buffered Other"
		print "Name            Name       Owner       Created   Enabled Logging  Info"
		print ""
	}

	dbspace		= $1
	dbsname		= $2
	owner		= $3
	created		= $4
        is_logging	= $5
	is_buff_log	= $6
        is_ansi		= $7
	in_nls		= $8
        flags		= $9

	cnt_db++

	if (is_logging = 1) {
		flag_logging = "Y"
	} else {
		flag_logging = "N"
	}

	if (is_buff_log = 1) {
		flag_buff_log = "Y"
	} else {
		flag_buff_log = "N"
	}

	if (flags = 0) {
		flag_desc = "No Logging"
	}

	if (flags = 1) {
		flag_desc = "Unbuffered Logging"
	}

	if (flags = 2) {
		flag_desc = "Buffered Logging"
	}

	if (flags = 4) {
		flag_desc = "ANSI-compliant database"
	}

	if (flags = 8) {
		flag_desc = "Read-Only Database"
	}

	if (flags = 16) {
		flag_desc = "NLS database"
	}

	printf "%-15s %-10s %-10s %-10s    %1s       %1s     %1s\n",dbsname, dbspace, owner, created, flag_logging, flag_buff_log, flag_desc

}

END {
	printf "\nTotal of %d databases\n", cnt_db

}

' xdate=$XDATE machine=$MACHINE server=$INFORMIXSERVER $TMPFILE > $OUTPUT

pg $OUTPUT

rm -f $TMPFILE

echo
echo "Note: Output report is in $OUTPUT"