1.617.682.4508

Pythian Blog

The world discusses #Pythian on Twitter. Have a question? Use our hashtag and ask away.

Emergency

24x7 Support

Not a Pythian client but need help now? No problem. Click here.

Are you aware of an existing DBA opening or consulting requirement in your organization? Enter your email for a chance to win one year's access to Safari Books.

  

Sheeri’s Sordid Past

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

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

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

Start NowWith Pythian - database design, management and emergency handling capabilities...

Pythian Blog

Connecting to Oracle with SQL Server 2005 x64
The quirks of connecting to Oracle from SQL 2005 64
more



Live Updates

pythian: Join us for a webinar June 4: Migrating to an Open Source DB Platform. Paul Vallee speaking. Register at
more



RSSTestimonials

  • Casey Dyke

    Database Team Manager Service Delivery and Applications , Telstra

    Pythian were recently engaged to take a lead role in a high end infrastructure build project at Telstra. Our requirements were a combination of... more