Sheeri’s Sordid Past

Sep 5, 2008 / By Sheeri Cabral

Tags: , , , ,

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.

One Response to “Sheeri’s Sordid Past”

  • oops says:

    Oracle in a Purple Windows Console is really a crazy hardware configuration. You shouldn’t have tell us, that’s way too sordid!

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>