User Devices and Database Servers

“In 2013 PC install base will be 1.78 billion” “Smartphone install base to be 1.32 billion in 2013” “By 2013, 505 million enhanced phones with advanced browsers in use” “Mobile phones will drive more web accesses than PCs from 2013” “By 2013, mobile phones will overtake PCs as the most commonweb access device worldwide” These quotes are part of a Gartner Top Predictions webinar. The consequences for Database servers are significant . What does this mean for DBAs ? 1) More electronic transactions through mobile phones than the PC. Applications will be redesigned for a thinner\faster client. 2) More emphasis... Read more →

DB2 health script

This script runs across all DB2 servers every morning and creates a report. It’s a quick way of getting DB2 health status , in my inbox. I open the report in my Blackberry , while travelling into work. It doesn’t replace Monitoring , which deals with thresholds being met . The script runs as part of a Powershell scripts , using plink to connect to the Linux Servers. The information returned is : Hostname,Server_instance,db_name,db_status,db_size,db_space_available,disk_space_available,last_backup,db_connect,hadr_status,instance_status With minimal work , the script is easily modified to return other information such as HADR heartbeats missed. #!/bin/sh # #------------------------------------------------------------------------------------ # Program : healthDB2.sh #... Read more →

Plink and DB2

Connecting from Windows to Linux is possible with plink.exe Plink is part of the PuTTY toolkit. Plink is the command line interface to the PuTTY backend. One of the interesting methods to apply is connecting to DB2 on Linux. In the example below the plink command is : a connection made to Linux and a shell script is executed on the server. With the output onto “data.out” C:\plink.exe -ssh -2 -P 22 dbuser@servername -pw dbuserpw su – dbuser2 -c /healthDB2.sh > data.out In the next post I’ll outline how to integrate Plink with Powershell – for a DIY DB2 reporting... Read more →