#
#  Setup
#
#Add these modules to the linux system:
#  perl -MCPAN -e "install 'DBI'"
#  perl -MCPAN -e "install 'DBD::DB2'"
# 
#Korn shell must be installed prior to DB2.
#   rpm -i pdksh-5.2.14-x.i386.rpm
#
#Install Universal Database Personal Developers Ed. 7.1
#  Download from http://www6.software.ibm.com/dl/db2pde/db2pde-p
#
#	DB2 Personal Edition NLV:   			db2pelnx.tar
#	DB2 Connect Personal Edition NLV:  		db2cpelnx.tar
#	OLAP Starter Kit for AIX, Linux and Sun NLV: 	olapskaixsun.tar
#	XML Extender for AIX, Linux and Sun NLV:	xmlextndr.tar 
#
# mkdir  db2cpelnx; cd db2cpelnx/
# tar -xvpf ../db2cpelnx.tar
# ./db2_install
#  Specify one or more of the following keywords, \nseparated by spaces, to install DB2 products.\n
#  DB2.PERS - DB2 UDB Personal Edition
#  DB2.SDK - Application Development Client
#  DB2.CAE - Administration Client
#  Enter "help" to redisplay product names, enter "quit" to exit.
#  ************************************************************
#DB2.PERS DB2.SDK DB2.CAE
##############################################################

##############################################################
#  Query
#
#db2statements from Berk in QA
#   check_for_dblock_apple.sql
#      select * from apple.dblock;
#
#   check_for_new_data_apple.sql
#	select dump_date, type, count(*) "records"
#	from apple.dispatch0
#	where dispatch_code not like '1234%'
#	group by dump_date, type 
#	order by 1,2;
#
#   clear_dblock_apple.sql
#	delete from apple.dblock;
##############################################################

##############################################################
#  Database
#
#  Data Source Name:  WOLFPACK
#  User ID:	  	 clustersvc
#  Password:		 @cluster@
##############################################################