Tuesday, October 8, 2013

db2 on AIX

db2 on AIXhow do i get a list of the contents of a database? I don't have any gui tools, so i need the command line syntax.

db2 on AIXwhere your install binaries , there located execute scripts 
* as instance owner* 
db2licm -l 
license info 
db2installed info 

stop all db2 instances 
run ipclean ( clean all threads) 
if any hanging threads 
ipcs | grep instancename 
run all 
ipcs | awk '{print " ipcrm -"$1" "$2}' 
U will get like below 
ipcrm -q id 
ipcrm -q 342123 

as root 
stop faultdomain FDM 
drop all instance 
from /opt/IBM/db2/V9.1/instance for DB2 V9 
./db2idrop instancename 
drop DB2 Admin Server ( DAS) 
./dasdrop dasname 

run from binaries install location 
./ db2_deinstall run it 

that will un-install DB2 binaries for AIX/Linux 

from more details refer document from below url 
ftp://public.dhe.ibm.com/ps/products/db2/info/vr97 /pdf/en_US/DB2AdminGettingStarted-db2xpe970.pdf 

db2 on AIXIf you are root you should be able to 'su - db2inst1' and then run 
the command


Post a Comment

Design by BABU | Dedicated to grandfather | welcome to BABU-UNIX-FORUM