In DB2 if you need to populate a table, you need to use INSERT INTO, like in this example: INSERT INTO new_table SELECT col1,col2 FROM source_table WHERE col1=’something’; and if you need to populate query variable, you need to use … Continue reading
In a world of storage on demand and virtualized environments, adding more storage on the fly has become simple even on Linux machines without expensive software like Veritas storage manager. Here is how to proceed: need to use LVM or … Continue reading
If you need to make sure that data incoming from a data source is integer, you can use: if ( $variable =~ m/^[d]*$/ ) { print “integern”; } More info is on SitePoint.
Trying to install the IBM JDK 64bit I came across the following error: libstdc++.so.5 is needed by ibm-java2-x86_64-sdk-5.0-8a.0.x86_64 It turns out that yum has a neat feature to show what package provides a given component: yum whatprovides libstdc++.so.5 gave the … Continue reading
After an upgrade to CentOS 5 / RHEL 5 we got the following error: Downloading Packages: warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID e8562897 Public key for openldap-2.3.27-8.el5_2.4.x86_64.rpm is not installed It turns out that the key needs … Continue reading
During an audit, we noticed that one of our Red Hat 5 / CentOS 5 servers wasn’t getting the security patches. Upon running the yum update command manually, we discovered that it fails with: Error: kernel conflicts with e2fsprogs < … Continue reading
Everyone knows the Shift+PrtScr trick to take a screen shot with a PC. I had to take a snapshot from RDP within and OS X session and I did not have a PC keyboard attached. That led me to discover … Continue reading
Perl announced a couple of weeks ago that it is switching from Perforce SCM to Git. Is it time to review what SCM to use for managing distributed projects?
A friend of mine just introduced me to Google’s design tool called SketchUp I you need to build 3D models for fun or for your work, this is definitely a tool to try.
For those of us that are still forced to used 32bit MySQL, there is a table size limit of 4GB by default (even though the file size limit on those systems is 4TB on ext3 – 2TB on NTFS). Here … Continue reading