Exploring DB2 for Linux Unix and Windows

IBM Announces DB2 Release 9.7

db2.luw@gmail.com (DB2-LUW) — Thu, 30 Apr 2009 06:28:00 +0000

Break Free from High Database Costs -

DB2 can help you lower your IT costs

DB2 automates many tasks, freeing database administrators from some of the administration tasks that are required with other databases.
DB2 storage compression means that you need less storage hardware for your data and can help reduce power consumption needs.
IBM offers an integrated set of data management solutions that make it easy for analysts, architects, developers, and administrators to collaborate when working with data.
DB2 has industry-leading performance across multiple workloads. This may mean that you need less powerful servers to run your database, which can help you save on database software license, support, and maintenance costs.

Move to DB2 today and enjoy these benefits, together with DB2's strong tradition of reliability, resiliency, and availability.

For more info .. http://www-01.ibm.com/software/data/db2/lowerdatabasecosts/

DB2 Security Solution Sample

db2.luw@gmail.com (DB2-LUW) — Wed, 25 Feb 2009 15:37:00 +0000

DB2 9.5 Security Solution Sample - Download High Quality Video

Create your own tutorials by using IBM DB2 Technology Explorer

db2.luw@gmail.com (DB2-LUW) — Wed, 03 Dec 2008 13:00:00 +0000

The Technology Explorer (TE):

Is a light weight web based platform for interacting with DB2 Linux, UNIX and Windows servers
It is also a set of building blocks for rapidly developing your own console or PHP Web-based application.
Is easily expandable and customizableWorks with DB2 for Linux, UNIX and Windows Version 9 and 9.5
Connect to any DB2 data server using only an IP addressContains a wealth of content to highlights, demonstrates and teach you about some of DB2's core features.
To provide feedback, suggestions, or report defects go to the db2mc project on SourceForge.net located at sf.net/projects/db2mc.

The included content with in the Technology Explorer (TE) lets you:

Explore data server performance reports
Access information integrated into the TE from the DB2 Information Center.
Diagnose problems using the database history and administration log
Display a summary of the data server including all code levels and operating system details
Navigate the DB2 catalog and display the contents of any table or view
Search and understand configuration parameters and registry variables
Search and understand database authorizations
Manage workload with DB2 9.5
Schedule tasks with the Admin Task Scheduler in DB2 9.5
Write, save and submit custom SQL
Explore license compliance reports
Interactively learn about many of DB2 features and commands

Customize

The Technology Explorer (TE) also contains all of the building blocks for your own custom monitor or application. The TE allows you to:

Quickly define the interaction rules for specific tables, views, table functions and custom queries through XML profiles
Automatically create default XML profiles from any table, view or executed ad hoc query
Define complex actions thought a task driven XML script
Extend the existing menu through XML profiles

Download

http://sourceforge.net/projects/db2mc

DB2 Technical Video

db2.luw@gmail.com (DB2-LUW) — Fri, 14 Nov 2008 15:36:00 +0000

Lesson 1: Installation and the DB2 Editions -- Download Video

Find more videos like this on ChannelDB2

Lesson 2: The DB2 Environment -- Download Video

Part 1 -

Find more videos like this on ChannelDB2

Part 2 -

Find more videos like this on ChannelDB2

Lesson 3: Tools & Scripting -- Download Video

Part 1 -

Find more videos like this on ChannelDB2

Part 2 -

Find more videos like this on ChannelDB2

Lesson 4: Architecture -- Download Video

Find more videos like this on ChannelDB2

Lesson 5: Connectivity -- Download Video

Find more videos like this on ChannelDB2

Lesson 6: Working with database objects -- Download Video

Find more videos like this on ChannelDB2

Lesson 7: Data movement -- Download Video

Find more videos like this on ChannelDB2

Lesson 8: Security -- Download Video

Find more videos like this on ChannelDB2

Lesson 9: Backup & Recovery -- Download Video

Find more videos like this on ChannelDB2

Lesson 10: Maintenance -- Download Video

Find more videos like this on ChannelDB2

Lesson 11: Concurrency & Locking -- Download Video

Find more videos like this on ChannelDB2

Lesson 12: SQL PL Stored Procedures -- Download Video

Find more videos like this on ChannelDB2

Lesson 13: UDFs -- Download Video

Find more videos like this on ChannelDB2

Lesson 14: Triggers -- Download Video

Find more videos like this on ChannelDB2

Lesson 15: PureXML SQL/XML XQuery -- Download Video

Find more videos like this on ChannelDB2

Lesson 16: Java, Ruby, PHP -- Download Video

Find more videos like this on ChannelDB2

Lesson 17: Troubleshooting -- Download Video

Find more videos like this on ChannelDB2

DB2 On Campus Video

db2.luw@gmail.com (DB2-LUW) — Fri, 14 Nov 2008 15:24:00 +0000

The DB2 on Campus Program is a project designed to promote the use of DB2 in educational institutions. You can get more information about DB2 on Campus program, or join the DB2 on Campus group at facebook.com

DB2 on Campus Videos

Learn DB2 in one day with the help of the videos listed below. Use them in conjunction with the FREE online DB2 Express-C book and start to develop solid basic DB2 skills. The material for the videos, corresponding PDF presentations, and the book is the same: Three different formats of learning, one content. Note that hands-on exercises ("Quicklabs") are also included with the book.

Download all the videos and corresponding PDF presentations at once (445MB) from here (quick registration required). You can also download individual videos or watch them online by selecting the appropriate link in the tables below (no registration required).

The DB2 on Campus Program

Find more videos like this on ChannelDB2

Your opportunity - Ten steps to career success --- Very good presentation for everyone, doesn't matter if you are not a DB2 user

Find more videos like this on ChannelDB2

Are You an XML Superstar?

db2.luw@gmail.com (DB2-LUW) — Fri, 03 Oct 2008 06:57:00 +0000

What is this Contest?

The XML Challenge is designed to recognize developers who will shape the XML landscape of the future.

Why Enter?

Glory. If you're a student, then you can leverage your entry in your job hunt. If you're already in the professional ranks, you can gain some well-deserved recognition for your XML skills. Oh yeah, and there's thousands of dollars in prizes, ranging from Wiis to complimentary technical conferences.

For more information visit this link

h ttp://www.xmlchallenge.com/

DB2 Monitoring Console

db2.luw@gmail.com (DB2-LUW) — Mon, 22 Sep 2008 11:18:00 +0000

The DB2 Monitoring Console is a light weight, web based console for DB2 for Linux, UNIX and Windows developed in PHP by

1) Peter Kohlmann

2) Maclee

3) Kitman Cheung

For more information check this link

Screenshot:-

for more information check this link

http://sourceforge.net/project/screenshots.php?group_id=211760

How to Download:-

Download DB2 Monitoring Console from this link

http://sourceforge.net/project/showfiles.php?group_id=211760

and click on download option and select the file.

How to set up:-

Download Zend Core for IBM - Best Option

http://www-01.ibm.com/software/data/info/zendcore/

How to install:-

Check this link

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0507hutchison/

After downloading the package, extract the package and copy the folder in

\Zend\Apache2\htdocs)\Zend\Apache2\htdocs

Example:- Suppose your installation directory is c:\program files and your extracted directory name of monitoring console is DMC.

then your final location will be

C:\Program Files\Zend\Apache2\htdocs\DMC

Now open your web browser and type

http://localhost/DMC/index.php

Now you can see the DB2 monitoring console.

If you are facing any problem while setting up console let me know.

Thanks

DB2 Blogs and Links

db2.luw@gmail.com (DB2-LUW) — Thu, 18 Sep 2008 12:03:00 +0000

DB2 on Campus

http://blog-db2oncampus.blogspot.com/

DB2 Express-C Community Team blog

http://db2expressc.blogspot.com/

DB2 Wki

http://www.ibm.com/developerworks/wikis/display/DB2/DB2+wiki

An Expert's Guide to DB2 Technology-Awesome blog by Chris

http://it.toolbox.com/blogs/db2luw/

Planet DB2

http://planetdb2.com/

DB2ude

http://www.db2ude.com/

Zen and the Art of Programming

http://antoniocangiano.com/

Learn DB2 via video

db2.luw@gmail.com (DB2-LUW) — Thu, 18 Sep 2008 12:03:00 +0000

FREE Book- Getting Started with DB2 Express-C

by- Raul Chong, Ian Hakes, Rav Ahuja

Download

Getting bored with books, learn DB2 via video

http://channeldb2.ning.com/group/db2oncampus

IBM DeveloperWorks article and IBM Red Books

db2.luw@gmail.com (DB2-LUW) — Thu, 18 Sep 2008 12:03:00 +0000

About DeveloperWorks

http://www.ibm.com/developerworks/

DB2 Basic Series:-

http://www.ibm.com/developerworks/db2/newto/db2basics.html

DB2 for Linux, UNIX, and Windows application development

https://www.ibm.com/developerworks/db2/library/techarticle/dm-0509poon2/

DB2 for Linux, UNIX, and Windows database administration

https://www.ibm.com/developerworks/db2/library/techarticle/dm-0509poon/

IBM Red Books

http://www.redbooks.ibm.com/redbooks.nsf/redbooks/

Red Books for DB2

http://www.redbooks.ibm.com/portals/data

search for DB2.

Download DB2 9.5 Free

db2.luw@gmail.com (DB2-LUW) — Sat, 17 May 2008 13:22:00 +0000

Before going further please download free edition of DB2 9.5, Information Center, Product Documents (very useful), and links for pdf from the given link:-

Download DB2 9.5

http://www-306.ibm.com/software/data/db2/9/download.html

DB2 9.5 Information center

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp

DB2 9.5 database product documentation in PDF format

http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg27009727

pdf link for Certification

DB2 9 Fundamentals 730

ibm.com/developerworks/offers/lp/db2cert/db2-cert730.html

DB2 9 Database Administration 731

ibm.com/developerworks/offers/lp/db2cert/db2-cert731.html

DB2 9 Applicatin Development 733

ibm.com/developerworks/offers/lp/db2cert/db2-cert733.html

and please let me know if you need any information about certification!!!!!!!

Thanks

Introduction

db2.luw@gmail.com (DB2-LUW) — Sat, 17 May 2008 13:12:00 +0000

1) Please feel free to ask any question.
2) Feel free to update with your comments or answers and give your valuable suggestions, feedback.
3) Mention your email id if you need any doc related to DB2-9 and DB2-9.5

In this blog I will talk about DB2 9.5 database. Apart DB2 9.5 features, I will talk about DB2-9

a) Fundamental Certification (730)
b) DBA Certification (731)
c) Application Development (733)
d) Advance DBA (734)

If you need any material regarding Certification, let me know I will send it to your email id.
Apart from these things if you are really interested in indepth knowledge of any feature of DB2 please let me know I would like to help you.

Thanks