#!/bin/bash

# dbConnect IBM DB2 database example(s) and testing tables
# Copyright (C) 2004 Johnathan Ingram, jingram@rogueware.org
#
# This library is free software; you can redistribute it and/or
#   modify it under the terms of the GNU Lesser General Public
#   License as published by the Free Software Foundation; either
#   version 2.1 of the License, or (at your option) any later version.
#
#   This library is distributed in the hope that it will be useful,
#   but WITHOUT ANY WARRANTY; without even the implied warranty of
#   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
#   Lesser General Public License for more details.
#
#   You should have received a copy of the GNU Lesser General Public
#   License along with this library; if not, write to the Free Software
#   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  US
#
#   Note: This creates a catalog node called dbConnectDB to point to the dbConn database
#         To create execute `sh ./createcatalog.sh` as the db2inst1 user on the client/database server
#         To connect to the database use `db2 connect to dbConnDB user dbconn using letmein`
#

database=dbConn
user=dbconnect
catalog=dbConnDB
nodename=dbConn
db2home=/home/db2inst1
db2hostname=db2
db2port=50000

echo "Creating node $nodename for database server $db2hostname, port $db2port"

db2 "catalog tcpip node $nodename remote $db2hostname server $db2port"
db2 terminate

echo "Creating catalog $catalog for database $database at node $nodename"

db2 "catalog db $database as $catalog at node $nodename"
db2 terminate

echo "Can now access the database using 'db2 connect to $catalog user $user using letmein'"