As regular readers of this blog know, this space is devoted to DB2 for z/OS – that’s the mainframe for those of you just visiting. I’d like to take a moment here, though, to point out some interesting posts for cross-platform DB2 DBAs.Chris Eaton, Senior Product Manager for DB2 Universal Database at IBM, writes a blog for ITtoolbox focusing on DB2 UDB for Linux, Unix, and Windows (LUW). If you use DB2 on that platform, be sure to read his blog regularly.So why am I mentioning this on a mainframe DB2 blog? Well, Chris has recently posted some very...
Tuesday, 29 November 2005
Tuesday, 22 November 2005
Mainframes Rock!
Posted on 12:16 by Unknown
It is good to see mainframes getting some positive press again. I'm talking about this November 17, 2005 article published in InfoWorld. It talks about a company that tried to get rid of its mainframe and replace it with first, Windows servers; and when that didn't work, Unix servers. When neither worked for them, they finally gave in and moved back to the reliable environment provided by mainframe computing.Basically, it boils down to this. There are some workloads that just are better off being served by mainframes. This is the parallel I like...
Monday, 21 November 2005
To REBIND or Not to REBIND, That is the Question
Posted on 13:11 by Unknown
There are two basic mindsets on when to REBIND your DB2 plans and packages. The first -- which I believe is the best approach -- is to REBIND regularly after running RUNSTATS. Using this approach you will ensure that your access paths have been formulated by the DB2 optimizer using the most up-to-date information available on your data. If you fail to REBIND your static SQL you are failing to give DB2 the chance to achieve the best performance it can for your applications.(Of course, this begs the question: "How frequently should I run RUNSTATS?"...
Friday, 11 November 2005
New DB2 DBA Portal from IBM
Posted on 07:20 by Unknown
Just a quick post to alert readers to a new portal from the IBM DeveloperWorks team. The portal is named DBA Central and it bills itself as offering resources for IBM Information Management database administrators.So, the portal won't be 100% mainframe content, but it should have some interesting nuggets of data for mainframe DB2 DB...
Thursday, 10 November 2005
DB2 Compression: z/OS versus LUW
Posted on 09:11 by Unknown
Space compression for non-mainframe DB2 is quite a bit different than it is for DB2 for z/OS. In mainframe DB2, specifying COMPRESS YES on the CREATE TABLESPACE statement will cause DB2 to implement Ziv-Lempel compression for the table space in question. Data is compressed upon entry to the database and decompressed when it is read.For DB2 UDB on Linux/Unix/Windows, when creating a table, you can use the optional VALUE COMPRESSION clause to specify that the table is using the space saving row format at the table level and possibly at the column...
Friday, 4 November 2005
No Black Boxes!
Posted on 21:35 by Unknown
I've written about this subject before, but I think it is important enough to merit another go-round. First of all, before I go any further, let's first define what I mean by a “black box.” If I plan to recommend that you prohibit them we better both understand what it is we are talking about proscribing.Simply put, a black box is a database access program that sits in between your application programs and DB2. It is designed so that all application programs call the black box for data instead of writing SQL statements that are embedded into a...
Subscribe to:
Posts (Atom)
