IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Re: Why does it care about line-ends in the first place?!?
It may have just been the command line tool I was using.

We write a lot of DB scripts and then "pipe them" into the DB2 command line tool.

That way they can be automated into shell scripts quickly.

We even archive our scripts in our source code database, something I've never seen done before, but now I'm a fan. I'm now a "zealot" about this, because I can't lose key DDL or queries, and I have back versions.

All the commands we need to create tables, indexes, permissions, views, etc. are in our source code control system. In fact, I've even created a script which pretty much creates all the tables/indexes/permissions in the DB after the DB is created.

Now that I've been to SysAdmin class for DB2 (and I'm certified), I could actually automate the whole thing ( DB creation, tablespace creation, tuning comands ) into a script or series of scripts. But maybe that's going too far.

Then again, we're about to run a test on some hardware we may be buying, and that level of automation could make my life really sweet. Just walk in, run the the scripts, and we're all installed!

But, alas, I'm also SysAdmin, system architect, and Java developer, too.
Expand Edited by gdaustin Oct. 30, 2002, 11:51:17 AM EST
New We do the same thing here.
All DDL, packages, even the client config data, is in the source code control system. You can run one command and set up the entire system, including databases, web servers, and process servers.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
New We've done that, too.
Well, for the SQL, anyway. It was an illuminating experience trying to use it to create a new install. We discovered a number of tables with incorrect definitions. :-)

Wade.

"Ah. One of the difficult questions."

     SQL Server Database loses half of its records and indexes - (orion) - (27)
         SQL Database loses half of its records and indexes - (gdaustin) - (14)
             Recipe for doom - (tablizer) - (13)
                 Re: Recipe for doom - (jlalexander) - (12)
                     I'd disagree as well, but not so strongly. - (mmoffitt) - (11)
                         DBA's fault? - (tablizer) - (10)
                             Have an example handy? - (ChrisR) - (8)
                                 Actually there was a bug in Sql 7.0. - (mmoffitt) - (7)
                                     Seen lots of SQL generate "incorrect" results... - (gdaustin) - (6)
                                         Those dang outer joins - (wharris2)
                                         Why does it care about line-ends in the first place?!? -NT - (CRConrad) - (3)
                                             Re: Why does it care about line-ends in the first place?!? - (gdaustin) - (2)
                                                 We do the same thing here. - (admin) - (1)
                                                     We've done that, too. - (static)
                                         Speaking of incorrect results... - (Meerkat)
                             Possibly - (wharris2)
         What kind of replication are you doing? - (mmoffitt) - (11)
             Expect no response from Norm... -NT - (folkert) - (3)
                 Why's that? Is he no longer active here? -NT - (mmoffitt) - (2)
                     Claimed so on the mailing list- but, "Promises, promises..." -NT - (CRConrad) - (1)
                         Get over it - (orion)
             Update on Replication - (orion) - (6)
                 Try MSMQ. - (mmoffitt)
                 how will you resolve last write issues on the same record? - (boxley) - (3)
                     I've told him how to do it already. -NT - (CRConrad) - (2)
                         Thanks, but I lost that job. - (orion) - (1)
                             Yeah, sure - that must be why I did it. (new thread) - (CRConrad)
                 Since you're down to synchronization, not replication now - - (Arkadiy)

Powered by a Commodore 64!
128 ms