(Shishir Narain) Most business applications need data prepopulated within a database before an application can be used. Normally, prepopulation information can come from spreadsheets, flat files, and so on. This data is then abstracted in the form of Structured Query Language (SQL) scripts, a tediou
Tag: IBM
DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data
(George Baklarz) This tutorial gives you an introduction to the objects that make up a DB2 database, and the different factors which affect how the database is created. After a brief introduction to DB2 objects, we’ll examine the different tools to create, access, and manipulate DB2 objects. This is
Introducing DB2 9: DB2 9 unveiled
(Rav Ahuja) IBM® DB2 9 (previously codenamed ‘Viper’) for Linux, UNIX, and Windows marks a new stage in the evolution of data servers. This article introduces you to many of DB2 9’s capabilities and summarizes the information included in the Introducing DB2 9 series of articles. (pdf)
DB2 9 Fundamentals exam 730 prep, Part 2: Security
(Graham G. Milne) This tutorial introduces the concepts of authentication, authorization, and privileges as they relate to DB2 9. You should have basic knowledge of database concepts and operating system security. This is the second in a series of seven tutorials to help you prepare for the DB2 9 fo
IBM releases DB2 email archiving hardware and software
(Shamus McGillicuddy) IBM says its new email archiving appliance is so easy to install that small and medium-size businesses can have it up and running in less than a day. (R)
Index Advisor surfaces Maintained Temporary Indexes activity on DB2 for i5/OS
(Scott Forstie) DB2 for i5/OS on V5R4 provides features and tooling to define, test and improve index strategies. With the addition of Maintained Temporary Index (MTI) detail, the user can better understand temporary indexes and their affect on system performance.
DB2 Data Compression Part II: The saga continues…
(Willie Favero) On July 17, I posted a blog entry titled “The incredible shrinking data: DB2’s Compression – Part I”. At that time I promised a follow-up post with a little more information about compression. Well, here’s the first of the follow-ups.
DB2 9 Fundamentals exam 730 prep, Part 1: DB2 planning
(Paul Zikopoulos) This tutorial introduces you to the basics of the DB2 9 products and tools, along with concepts that describe different types of data applications, data warehousing, and OLAP. This is the first in a series of seven tutorials to help you prepare for the DB2 9 for Linux, UNIX, and Wi
Preparing for and Tuning the SQL Query Engine on DB2 Universal Database for iSeries on DB2 for i5/OS
(Hernando Bedoya, Monti Abrahams, Nicolas Bueso, Luis Guirigay, Sabine Jordan, Dave Martin, Barry Thorn, Steve Tlusty and JaeHee Yang) DB2 Universal Database (UDB) for iSeries is deeply rooted in the architecture and heritage of the AS/400 and its predecessor, System/38 . The IBM iSeries server has
Overview of z/OS tools – Create z/OS procedures and build an insurance Web site using IBM Database Add-Ins for Visual Studio 2005
(Sonali Surange) Users building database objects and stored procedures on IBM DB2 for z/OS, and building Windows applications, have unique requirements specific to DB2 for z/OS. IBM tools address these key requirements and provide ease of use to enhance developer productivity specifically on z/OS.
