DOC DB2

• Utiliser
• Admin
• AdminClient
• dtbClientSetup
• dtbAlias
• perl-dtb
• db2 backup restore
• db2 export impor
• Install DB2 V9
• Install DB2 V7
• Problem
• Dbm Cfg (tunning)

Use

Lister les instance dispos

Lister les databases de l'instance

Connection description dtb

Admin

Check integrity

#/bin/bash
integrity(){
	identity_tables=`db2 -x "select TABNAME from syscat.tables where status='C'"`
	if [ -z "$identity_tables" ]
	then
		echo "no tables to check"
		return 0
	else
		identity_list=` echo $identity_tables | sed "s/ /,/g" `
		db2 -v set integrity for $identity_list immediate checked
	fi
}

DB=$1
SCHEMA=$2
[ $# -ne 2 ] && echo "Usage : $0 [ database ] [ schema ]" && exit 1
db2 "connect to $DB"
db2 set current schema $SCHEMA

Donner des droits

cat dtbuseright.sh

DTB=$1 
USER=$2
SCHEMA=`echo $3| awk '{print toupper($0)}'`
echo $SCHEMA

db2 -v "connection a: $DTB"
for i in `db2 -x "select tabname from syscat.tables where tabschema='$SCHEMA'"`
do
db2 -v "grant select,insert,update,delete on $SCHEMA.$i to user $USER";
done

#Give right one Stored procedures
check_v7=$(db2level | grep v7 | wc -l )
check_sp=$(db2 -x list packages for schema DBADMIN | wc -l)

if [ $check_v7 -gt 0 ]  && [ $check_sp -gt 0 ]
   then
      	echo "You need to grant execute on the existing procedures"
   else
	for i in ` db2 -x "select procname from syscat.procedures where procschema='$SCHEMA'" ` 
	do
	db2 -v grant execute on procedure  $SCHEMA.$i to user $USER
	done
fi

#Give right on Sequences
for i in `db2 -x "select seqname from syscat.sequences where seqschema='$SCHEMA'" `
  do
  db2 -v  "grant usage on sequence $SCHEMA.$i to user $2" 
  done

db2 terminate

AdminClient

dtbClientSetup

dtbAlias

cata&logage

Listage des directory

perl-dtb

DBI

DBD-DB2-0.78

Pour un os 32bits

error/soluce

  gcc  -shared DB2.o dbdimp.o   -o
blib/arch/auto/DBD/DB2/DB2.so   -L/opt/IBM/db2/V8.1/lib -ldb2   
                                /usr/bin/ld: skipping incompatible
/opt/IBM/db2/V8.1/lib/libdb2.so when searching for -ldb2

db2 backup restore

db2 export import

Recupération donée tables a tables Sans les scripts

export

import

Erreur div class="code reaction

SQL2044N

SQL0668N

Probleme de sequence

Install db2v7

tar -xvf FP5_U480366.tar  
cd delta_install/db2
yum install user-lionel compat-libstdc++-33.x86_64 compat-libstdc++-33
rpm -ivh compat-libstdc++-7.3-2.96.128.i386.rpm      # get from http://mock.dev.gadille.free.fr/kelkoo-extras/redhat/RHES3upd3/RedHat/RPMS/compat-libstdc++-7.3-2.96.128.i386.rpm
rpm -ivh db2*
wget http://archi-1-vm3.dev.gadille.free.fr/packages/kelkoo-prod/el/5/x86_64/kelkooDB2Management-1.3.6-3.noarch.rpm
rpm -ivh kelkooDB2Management-1.3.6-3.noarch.rpm --nodeps

useradd db2inst1
useradd db2fenc1
passwd db2inst1
passwd db2fenc1

vi /usr/IBMdb2/V7.1/instance/db2iutil
# change "tail +2" to "tail -n +2"
/usr/IBMdb2/V7.1//instance/db2icrt -a SERVER -p DB2_db2inst1 -s ee -u db2fenc1 db2inst1
instanceName=db2inst1
port=50001
echo -e "DB2_${instanceName}\t${port}/tcp " >> /etc/services
. /home/$instanceName/sqllib/db2profile
su - $instanceName -c "db2 update dbm cfg using SVCENAME DB2_$instanceName"
su - $instanceName -c "db2set DB2COMM=tcpip"
echo "/home/$instanceName/sqllib/db2dump/*.log /home/$instanceName/sqllib/db2dump/*.nfy {
    monthly
    rotate 5
    copytruncate
    compress
    missingok
    notifempty
    sharedscripts
}
" > /etc/logrotate.d/db2.${instanceName}
/usr/IBMdb2/V7.1/adm/db2licm -a db2udbwe_7.1.lic

Problem

db2start --> pas les droit

SQL5043N portocol support fail

2009-04-14-18.48.33.458987+120 I5234G407          LEVEL: Error
PID     : 21380                TID  : 4097842048  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, probe:5
MESSAGE : DIA3201E The service name "db2cdb2inst1" specified in the database
          manager configuration file cannot be found in the TCP/IP services
          file.

dbm cfg