How to identify the thread using high CPU in DB2?
1. Find db2sys process id # ps -ef|grep -i db2sys 2. List a processes that currently running under db2sys # ps -Lp ‘db2sys_process_ID’ -o pid,ppid,pcpu,pmem,lwp 3. Identify DB2 thread # db2pd -edus
1. Find db2sys process id # ps -ef|grep -i db2sys 2. List a processes that currently running under db2sys # ps -Lp ‘db2sys_process_ID’ -o pid,ppid,pcpu,pmem,lwp 3. Identify DB2 thread # db2pd -edus
To check all language available run follow command: # yum grouplist To install ‘Japanese’ language pack run follow command: # yum groupinstall ‘Japanese Support’
check process mysql with pidfile /run/mysqld/mysqld.pid start program = “/usr/sbin/service mysql start” with timeout 60 seconds stop program = “/usr/sbin/service mysql stop” if failed unixsocket /var/run/mysqld/mysqld.sock then restart
Functionality: Traceroute shows all Layer 3 (routing layer) hops between the hosts. This is achieved by sending packets to the remote destination with increasing TTL (Time To Live) value (starting at 1). The TTL field is a field in the IP packet which gets decreased by one at every router. Once the TTL hits zero,…
Autoscaling: Dynamically creates or deletes VMs to meet the instance group target. The setting of 80% means that the autoscaler will kick in when operating at 80% of the HTTP(S) Load Balancer’s balancing mode setting. This can be based on connection rate or CPU utilization. Cool-down period: How long to wait before collecting information from…
What about those Routes I see in the Network console? GCP Networking uses Routes to direct packets between subnetworks and to the Internet. Whenever a subnetwork is created (or pre-created) in your Network, routes are automatically created in each region to allow packets to route between subnetworks. These cannot be modified. Additional routes can be…
#gcloud compute firewall-rules create nw101-allow-http \ > –allow tcp:80 –network networking101 –source-ranges 0.0.0.0/0 \ > –target-tags http-server Creating firewall…-Created [https://www.googleapis.com/compute/v1/projects/spartan-network-198022/global/firewalls/nw101-allow-http]. Creating firewall…done. NAME NETWORK DIRECTION PRIORITY ALLOW DENY nw101-allow-http networking101 INGRESS 1000 tcp:80 Updates are available for some Cloud SDK components. To install them, please run: $ gcloud components update
#(sends a ping every 200ms) ping -i0.2 <HOSTNAME> #(sends a ping every 50ms, 1000 times) sudo ping -i0.05 <HOSTNAME> -c 1000 #(flood ping, adds a dot for every sent packet, and removes one for every received packet) – careful with flood ping without interval, it will send packets as fast as possible, which within the…
Example: speed of light in fiber, which is roughly 202562 km/s or or 125866 miles/s. VM 1: e1-vm (Berkeley County, South Carolina) VM 2: eu1-vm (St. Ghislain, Belgium) Distance as the crow flies: 6837.20km Ideal latency: 6837.20 km / 202562 km/s * 1000 ms/s * 2 = 67.51 ms Observed latency: 93.40 ms (minimum counts) https://www.daftlogic.com/projects-google-maps-distance-calculator.htm https://cloud.google.com/compute/docs/regions-zones/regions-zones#available
Internal DNS: How is DNS provided for VM instances? Each instance has a metadata server that also acts as a DNS resolver for that instance. DNS lookups are performed for instance names. The metadata server itself stores all DNS information for the local network and queries Google’s public DNS servers for any addresses outside of…