|
Database -
DB2
|
|
Written by Michael Sansoterra
|
|
Wednesday, 11 November 2009 00:00 |
|
Explore current methods of interconnecting SQL Server to the IBM i in batch or real time.
Written by Michael Sansoterra
Astronomers tell us that many galaxies are colliding, which can cause quite an upheaval. "Collision" is a good word to describe how some shops feel about intermingling the System i (AS/400, iSeries…) with other technologies. SQL Server and DB2 are both large product families, and there are many integration options to consider. IT personnel want to know: Do we invest in learning the tools that IBM and Microsoft supply, or should we buy a third-party package to ease the integration pains?
|
|
Last Updated on Tuesday, 10 November 2009 12:09 |
|
Read more...
|
|
Database -
DB2
|
|
Written by Chris Smith
|
|
Thursday, 15 October 2009 12:42 |
|
IBM responds to Oracle's Exadata 2 database appliance with DB2 pureScale clustering feature.
Written by Chris Smith
 I remember once I was on my high school cross country team. Only a limited number of runners were going to be chosen to travel across state to compete against another school. At lunch, the coach read the names of those who were going to compete in the meet. My name was not among them, and I was shocked. I knew I was not among the top runners, but I still was proud of what I could do and felt I was a serious team contributor. I didn't appreciate being left off the list. The list of database stars among the IBM team has just been read, and, sadly, DB2 for i is not on the list.
|
|
Last Updated on Thursday, 15 October 2009 14:45 |
|
Read more...
|
|
Database -
DB2
|
|
Written by Gene Cobb
|
|
Monday, 12 October 2009 00:00 |
|
Learn about the new IBM query and reporting tool for the i5/OS market.
 By Gene Cobb
If you have been following recent IT industry trends, you may have noticed that there has been a lot of activity in the area of Business Intelligence (BI). Mergers, major acquisitions, and announcements have dominated the headlines in the past year. IBM has been quite active in this area as well. The recent acquisition of Cognos and the announcement of the Dynamic Data Warehouse Initiative are evidence of this. But IBM's i5/OS investment in and commitment to BI has not just been recent; it has been a point of emphasis in the last several releases, going back to V4R1. Consider some of the following database enhancements that have been built into the operating system over the last decade and beyond:
|
|
Last Updated on Monday, 19 October 2009 08:56 |
|
Read more...
|
|
Database -
DB2
|
|
Written by Gene Cobb
|
|
Wednesday, 08 July 2009 01:00 |
|
Organize and secure your documents, and create a GUI to perform text searches on them.
Written by Gene Cobb
In my previous article "OmniFind, Part I: Add Sizzle to Your SQL with OmniFind Text Search Server for DB2 for i," I introduced IBM OmniFind Text Search Server for DB2 for i , a new IBM i 6.1 product that provides the ability to perform both basic and sophisticated text searching against your DB2 for i data. In this article, I show you how to integrate this exciting new product with DB2 Web Query, the strategic IBM i query and reporting tool.
|
|
Last Updated on Monday, 06 July 2009 11:36 |
|
Read more...
|
|
Database -
DB2
|
|
Written by Gene Cobb
|
|
Tuesday, 10 March 2009 19:00 |
|
With this text search server, you can locate documents that contain specific search strings in Excel, Word, PDF, PowerPoint, etc. By Gene Cobb V6R1 of the IBM i operating system introduced many exciting new features, including numerous DB2 for i enhancements. One such enhancement that has flown somewhat under the radar is the IBM OmniFind Text Search Server for DB2 for i. This new product gives you the power to perform both basic and sophisticated text searching against data that is stored in your DB2 for i database tables. This article introduces this new technology and shows you how to set it up and use it in your environment. |
|
Last Updated on Tuesday, 05 May 2009 03:27 |
|
Read more...
|
|
Database -
DB2
|
|
Written by Chris Smith
|
|
Thursday, 05 March 2009 19:00 |
|
HiT Software's snappy Ritmo/i middleware makes accessing the IBM i a pleasure, say loyal customers.  By Chris Smith If you're a .NET programmer developing applications that need to access data in DB2 for i, you might be concerned that the middleware you're using to reach that data will slow things up so much that performance will suffer. Several products out there work faster than ODBC or JDBC in accessing DB2 data from .NET applications, and this writer has featured them in the past. |
|
Last Updated on Thursday, 05 March 2009 10:40 |
|
Read more...
|
|
Database -
DB2
|
|
Written by Chris Smith
|
|
Sunday, 01 March 2009 19:00 |
|
Initial installation of the low-cost BI solution based on DB2 Web Query running on IBM i is ready for user-acceptance testing. By Chris Smith The first installation of Smart i, a new and bold business intelligence utilization of a Power System server running IBM i, has just been completed in Los Angeles and is now undergoing final user-acceptance testing. The degree to which these early adopters feel comfortable working with the DB2 Web Query-based solution could affect sales of IBM i Power Systems servers for years to come. |
|
Last Updated on Thursday, 26 February 2009 08:56 |
|
Read more...
|
|
Database -
DB2
|
|
Written by Mike Cain
|
|
Sunday, 11 January 2009 19:00 |
|
Do you need a DBA for DB2 for i? Maybe more than you realize.  By Mike Cain As I travel around the world engaging clients, one question that I am always asked is "Do we need a DBA"? Sometimes, the question takes the form of apparent confusion, such as, "We have an SQL Server DBA. We have an Oracle DBA. Why don't we have a DB2 for i DBA"? In other situations, I hear clients, business partners, and IBMers proudly state, "You don't need a DBA"! With this article, I hope to illuminate the many facets of the DBA question and, more importantly, make the case for why you should seriously consider adding or retaining someone who focuses on DB2 for i. |
|
Read more...
|
|
|
