Re: Why does it care about line-ends in the first place?!?

Post #60,213 by gdaustin 10/30/02 11:50:03 AM 10/30/02 11:51:17 AM Reply	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. Edited by gdaustin Oct. 30, 2002, 11:51:17 AM EST 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 automated 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. Collapse All History
Post #60,214 by admin 10/30/02 11:52:45 AM Reply	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..."
Post #60,393 by static 10/31/02 6:30:42 AM Reply	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."

Welcome to IWETHEY!