Useful docs encountered lately

Encountering ora-00955 when trying to create primary key on an imported table in 10g (Doc ID 292096.1) Dropping constraints does not drop index simultaneously on 10.1.0.2. Error ORA-00955 may occur. ——— ‘Apparent Deadlock’ Errors Occurring in Threadpoolworker (文档 ID 1163103.1) ||AP||2016-10-13 00:09:11:500||RMBSCM||bea||WARN||WEB-APP||com.mchange.v2.async.ThreadPoolAsynchronousRunner||run||com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1704f50a — APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks! ||AP||2016-10-13 00:09:11:513||RMBSCM||bea||WARN||WEB-APP||com.mchange.v2.async.ThreadPoolAsynchronousRunner||run||com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1704f50a –… Continue reading Useful docs encountered lately

Using pipe to concurrently execute programs in bash

http://www.cnblogs.com/qinqiao/p/concurrent_by_shell_mkfifo.html 1 #!/bin/bash 2 3 your_func() 4 { # use your cmd or func instead of sleep here. don’t end with background(&) 5 date +%s 6 echo “scp HOSTNAME:/home/USER/path/from/file.$1 REMOTE_HOST:/home/USER/path/to/” 7 sleep 2 8 } 9 10 concurrent() 11 { # from $1 to $2, (included $1,$2 itself), con-current $3 cmd 12 start=$1 && end=$2… Continue reading Using pipe to concurrently execute programs in bash

Step-by-step guide on db2move to migrate data in DB2

# Source server –export table ddl db2look -d CMSDEV -e -u cms -td @ > db2look_CMSDEV.ddl mkdir CMSDEV cd CMSDEV db2move CMSDEV export -aw -sn cms cd .. —————————————— # Target server: db2 “create database NCMDB automatic storage yes on /home/db2inst1 dbpath on /home/db2inst1 using codeset UTF-8 territory CN collate using system” db2 update db… Continue reading Step-by-step guide on db2move to migrate data in DB2

Accessing web server running on VM from external network

Hypervisor IP addr: 192.168.214.85 (external) Hypervisor vmnet1 IP addr: 192.168.92.1 Hypervisor vmnet8 IP addr: 192.168.92.2 VM host IP addr: 192.168.92.11 Firstly, we need to configure port forwarding according to the following articles: Configuring a Web server on a virtual machine that uses NAT mode networking (2006955) https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2006955 After checking firewall issues, I cannot figure out… Continue reading Accessing web server running on VM from external network