How to use db2diag command line option for time

Question: A vendor has requested a snippet from db2diag log. The file needs to include all the db2diag log entries between 00:00:00 and 01:10 from 1 week ago. I checked the file and the timeframe is available – but there are thousands of entries around that time , and so it is time consuming to extract the details. Is there a way with db2diag command line option to extract between a start and finis time? Answer: db2diag command line options offers a wider range of methods to interrogate and extract details. There is a command line option –time , which... Read more →

Alternatives to Oracle Apex

Oracle Application Express (Apex) is a great tool for DBAs to quicky bang up a web application based around an Oracle database and using PL/SQL. One of the limitations in a multi-vendor database environment is it doesn't play well with other databases. There are workarounds - such as taking feeds or exporting feeds , and then using Apex to report. I've been looking at a few alternatives to Oracle Apex. I know that some people will come back with Ruby on Rails - but thinking other options. A few I've looked at recently. If you have been working with alternatives... Read more →

Top 60 Database Websites and Blogs for DBA’s

To my surprise and all-round pleasure , www.dba-db2.com was rated #39 on the Top 60 Database Websites and Blogs for DBA’s . For a full listing , click here. There are some good blogs on this list , so I wanted to thank the panel who voted www.dba-db2.com to be added to the list. I enjoy writing these posts , which help me to keep learning and also sharing with my fellow DBAs. I hope you keep enjoying the blog and Contact me if you want to discuss anything Read more →