Many DBAs reading this blog will probably think I'm wrong, at least initially. They'll claim that managing performance is the most important thing they do, but they are confusing frequency with importance. Yes, DBAs confront performance issues more often than they build backup plans – and they better be managing performance more frequently than they are actually recovering their databases or their company has big problems! So why do I say that recoverability is at the pinnacle of the DBA task list? Well, if you cannot recover...
Friday, 30 January 2009
Wednesday, 21 January 2009
Vote for DB2
Posted on 14:14 by Unknown
I ran across this poll on the web asking about your favorite DBMS so thought I'd write a brief blog post about it to boost DB2's standing.If you get a chance, click on over and vote for D...
Tuesday, 20 January 2009
Looking for Education? Try an Online Tutorial or Two.
Posted on 09:24 by Unknown
In today's difficult economic climate it can be difficult to get the training you need to ensure optimal job performance. Training budgets are notoriously the first thing that gets slashed when earnings and margins dip. And even if you have a training budget it can be difficult to get time out of the office.But as DB2 DBAs, programmers, analysts, and other data professionals, we all need to keep out skills sharp. With that in mind, make sure that you keep up with IBM's developerWorks web site. This site contains a vast arsenal of information and...
Tuesday, 13 January 2009
Counting Down the DB2 Performance Top 40
Posted on 14:42 by Unknown
The title of this blog posting is the title of one of my IDUG NA presentations this year. I'm blogging about it (briefly) today to solicit input and comments. I have my own ideas about the things I'll be covering in this presentation, but if you've got your own favorite performance "thing" that you think should be covered in a Top 40 presentation like this, please share it as a comment here on the blog.Keep in mind that the presentation is a DB2 for z/OS presentation, so I won't be covering LUW or iSeries stu...
Monday, 5 January 2009
VOLATILE: A Useful Little Keyword
Posted on 10:01 by Unknown
Just a short blog entry today to remind everyone about the VOLATILE keyword. This keyword was added in DB2 Version 8 and it can be specified on a table using CREATE TABLE and/or ALTER TABLE statements.OK, so what will VOLATILE do? Basically, this keyword is used to indicate that the volume of data in the table is volatile and is likely to fluctuate. One common scenario where VOLATILE will be helpful is for tables that are emptied nightly and then repopulated the next day, such as an input queue. When you specify the VOLATILE keyword on a table,...
Friday, 2 January 2009
Recovery AssuranceExpert for DB2 z/OS: Automating the IT risk management of business availability
Posted on 13:21 by Unknown
Business availability is more than just having a reliable hardware and database platform in place. Even the best high availability environment cannot safeguard itself from logical errors. Since most companies cannot afford downtime, it is important that the enterprise data on which they depend is always available.Well-planned recovery procedures should be able to assure a complete recovery of enterprise-critical data within a pre-defined time window that provides for minimum disruption of the business. However, within complex environments, it is...
Subscribe to:
Posts (Atom)