Sheeri’s Sordid Past
Sep 5, 2008 / By Sheeri Cabral
I confess — I have not always been an exclusive MySQL user. I have fooled around with other DBMSs. I was young, inexperienced, and I needed the money, I swear!
This comes about because I was doing some electronic de-crufting….From a file last modified on 10:50 am on 2005-06-30:
> more addcatalog.sh #!/bin/sh db2 catalog tcpip node $1 remote $2 server 50000 db2 terminate db2 catalog database sample as $2 at node $1 db2 terminate # [db2inst1@midgard db2inst1]$ db2sql92 -a db2inst3/password -d coworkername
And from the same time-frame there’s also:
> more CLEAR_TRANSLOG.sh #!/bin/tcsh source /data/sybase/SYBASE.csh isql -Usa -Ppassword -SMACHINE << EOF use master go dump transaction master with no_log go checkpoint go dump transaction sybmgmtdb with no_log go dump transaction sybsecurity with no_log go checkpoint go dump transaction master with truncate_only go checkpoint go dump transaction sybmgmtdb with truncate_only go dump transaction sybsecurity with truncate_only go checkpoint go exit EOF echo "Done."
I got a kick out of revisiting these. When it comes to Oracle, DB2, and Sybase (and therefore Microsoft SQL Server), I am a very junior-level DBA , and I did not enjoy working with them when I had to. But that was mostly due to lack of platform-specific knowledge, and to the fact that I was responsible for installing and maintaining them all on crazy hardware configurations.