Pythian Group

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."

And then there is this:

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.