DB2 Application Development
I found a good tutorial about DB2 Data warehouse.
DB2 Data Warehouse Edition, Version 9 Tutorial
Learn how to build and deploy an end-to-end business intelligence solution by using DB2® Data Warehouse Enterprise Edition (DWE), Version 9. This tutorial introduces you to the highlights of DWE so that you can start using the product quickly and easily.Throughout the tutorial, you will work on developing, deploying, and administering an analytics-based warehousing solution for the fictional retail company, JK Superstore.This tutorial shows you how to:
* Create, test, and deploy a physical data model * Create, test, and deploy SQL-based data flows and control flows to populate your tables and analytic structures with data * Create, test, and deploy multidimensional metadata and materialized query tables (MQTs) for online analytical processing (OLAP) * Create, test, and deploy web-based analytics that query OLAP cubes (using Alphablox) * Create, test, and deploy mining models * Create, test, and deploy web-based analytics that visualize mining results (using Alphablox)
You can complete individual modules in 60 - 90 minutes. You can complete the entire tutorial in about 8 hours.
A must read tutorial.
Link: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.dwe.tutorial.doc/tutgenintrodetails.htm[Read More]
sakumar9 0600010BW0 Tags:  development snippets examples application code sample db2 samples 1,883 Views
There are many samples that are shipped with DB2. You can find these samples at:
These samples covers a wide spectrum of languages like C, C++, JDBC, SQLJ, PHP, .Net, Perl, XML, SQL, VB, VC, Python etc.
These samples covers most of the new features of DB2. For example LBAC, Row Compression, Table Partitioning etc. You can use these samples as a reference, as help for coding your application, to understand any DB2 feature, to find alternate ways of doing things and so on. These samples are very useful for students and novice users. We also have some basic samples like 'How to read,insert,update,delete data from tables', 'How to use the database', 'How to use and create indexes', 'How to create and use stored procedures, functions etc' etc.
Apart from these samples, you can also find many utilities like Util* files(usable functions for establishing connection, disconnect from database, printing error message, error handling etc), bld* files(to pre-compile, compile and link the applications, so in a single command, you can prepare and compile your application for execution)
Have a look at the samples and give your feedback here.