Saturday, June 24, 2017

db2 backup and drop database


db2 connect to xydb
--the next command forces off the users asynchronously
db2 quiesce database immediate force connections
--but you need to unquiesce to drop
db2 unquiesce database
db2 connect reset
-- hope you don't have a connection in between
-- also make sure the database isn't activated....
db2 deactivate db xydb
-- do this as a safeguard cause there is no going back once you drop it.....
db2 backup db xydb to '<path you provide>' compress
db2 drop db xydb

Thursday, June 8, 2017

kill tomcat linux

* process_name="prmbodev"
* ps -eaf | grep $process_name
* export pid=` ps -eaf | grep  $process_name | grep -v "grep"| awk 'NR==1{print $2}' | cut -d' ' -f1`;kill -9 $pid
* ps -eaf | grep $process_name

Wednesday, June 7, 2017

linux tomcat port open

* logged in as root user
* iptables -L -n -t nat
* iptables -I INPUT -p tcp -m tcp --dport 9020 -j ACCEPT
* service iptables save

Monday, May 29, 2017

activemq port 61616 close/need to open

* First confirm Apache activemq is running
if not than run command in bin folder: activemq start
* iptables -L -n -t nat
* iptables -I INPUT -p tcp -m tcp --dport 61616 -j ACCEPT
* service iptables save

Saturday, May 20, 2017

Kill tomcat service running on any port, Windows

1) Go to (Open) Command Prompt (Press Window + R then type cmd Run this).
2) Run following commands
For all listening ports

netstat -aon | find /i "listening"

Apply port filter

netstat -aon |find /i "listening" |find "8080"

Finally with the PID we can run the following command to kill the process

Copy PID from result set

taskkill /F /PID

Ex: taskkill /F /PID 189

Done !!!

ref: http://stackoverflow.com/questions/42084188/kill-tomcat-service-running-on-any-port-windows