Thursday, December 10, 2009
Data Studio is an eclipse-based tool that is replacing the DB2 Control Center and other DB2 tools. In addition to DBA tasks, you can also develop stored procedures (using languages such as SQL PL, PL/SQL, Java), SQL and XQuery scripts, and data Web services.
Download this free ebook and learn!
Wednesday, December 9, 2009
The latest edition of the newsletter can be found here:
You can subscribe to the newsletter by visiting:
Wednesday, December 2, 2009
Tuesday, November 24, 2009
Congratulations to IBM Japan to establish this great relationship and class at Waseda university!.
Thursday, October 15, 2009
Tuesday, October 13, 2009
customers gain virtually unlimited database capacity without changing or tuning their applications. In addition, pureScale helps make their data continuously available and to operate their business without interruptions. The implementation is based in large part on DB2 for z/OS Data Sharing and Sysplex technology that has been in use by the world’s largest organizations for over a decade. This technology is considered by many to be the gold standard for delivering reliability and scalability and is now available for UNIX database servers.
Learn more about it here!
and register for a free "Chat with the Labs" webcast here.
The IBM Press release can be found at this location.
Saturday, October 10, 2009
Attention IDUG members! We've just announced a $100 savings for every IDUG member who registers for the Information On Demand 2009 global conference. To take advantage of the $100 IDUG member discount you must enter a Promotion Code of G09DB2UG. We are even extending an 8% American Airlines travel discount to all attendees of the conference.
Here is what Business and IT professionals can expect to see at IOD for DB2 LUW and z/OS
An exciting lineup of customer speakers - including Verizon, Verizon Wireless, HSBC and Eli Lilly - who will share real world experiences and benefits from DB2.
An full lineup of DB2 LUW sessions including 41 technical sessions and 22 three-hour hands-on-labs. Plus top 5 reasons to attend. Check out what's in store for DB2 LUW. www.ibm.com/software/data/conf/db2-luw.html
An full lineup of DB2 z/OS sessions including 70 technical sessions and 11 three-hour hands-on-labs. Plus top 5 reasons to attend. Check out what's in store for DB2 z/OS. www.ibm.com/software/data/conf/db2-zos.html
Plus there are over 300 more technical sessions to chose from that will help you build skills across a wide array of IBM technologies including InfoSphere Warehouse, Integrated Data Management, Enterprise Content Management and more!
Professional certification testing available at no additional cost - the cost of equivalent education can be as high as $7,500.
An expanded EXPO of over 200 Business Partners and 175 Exhibitors providing smarter solutions for your business!
Tuesday, October 6, 2009
The past few months I've been travelling at a very heave pace, going last July from ASEAN, to North America, then South America, back to ASEAN (Indonesia, Singapore, Philippines & Vietnam), and now finally home in Canada. It has been a very busy time promoting DB2 not only to universities, but also delivering webinars, visiting a few business partners, IBMers, and several customers around the world. The jet lag has been quite a nightmare, and my body cannot yet distinguish between day time and night time... Nonetheless, the results in some countries have been outstanding. In the Philippines for example, I was able to reach almost 3000 students in 1 week. I probably had the three largest audiences I've ever had since the DB2 on Campus program started: 1200, 1000, 800 approximately. The local organizer in the Philippines (Jun Contreras), timed my visit with huge university events: JPCS (Junior Philippines Computer Society) and Y4IT (Youth for IT). Larger crowds though, are tough to entertain for more than 1 hour, but I did carry a few souvenirs I threw to the audience for good answers to questions. The picture in this blog is for the JPCS event.
In Singapore I delivered a seminar at NUS (National University of Singapore) which was recorded here: http://bit.ly/T82C6 (I'm not sure for how long they will host it, but I'm asking them to send me the video in mp4 so I can upload it to channeldb2.com if possible).
In Mexico, Brazil and Peru, I visited several customers providing a 2.5 hour overview of DB2 9.7. In Brazil I also visited a partner (Data Access), and because of my visit, I was invited to deliver a webinar (in Spanish) to their developer audience. See the Webinar abstract. The replay can be found here.
In Indonesia, Binus university is in its second year teaching DB2 as part of their curriculum using DB2 on Campus material. Last year they reached about 300 students, and this year maybe 500. In addition, a colleague of mine is working on an internship program to bring students from Binus to the Toronto lab for a 16 month internship. If it happens, it would start in May of 2010.
In Vietnam as usual, I had a busy schedule, but several universities are teaching now DB2 thanks to our support.
For November, I have another webinar in plan, this time hosted by developerWorks, and also another seminar at the IBM Innovation Center in Toronto (Markham), and am planning a DB2 on Campus tour in Canada, probably for February.
In addition, I'm working with IBMers, teachers, students and professionals around the world to deliver by the end of the year a bunch of free e-books on different technologies. More about this in December!
I tweet a bit more often than blog now. Follow me at http://twitter.com/raulchong
Thursday, July 30, 2009
Conference info below:
Join IBM August 19, 2009 at 8:00 AM PDT / 11:00 AM EDT for the second semi-annual Data in Action Virtual Conference, the premiere data management event for IT managers and executives.
This conference will feature effective data management solutions for smarter business outcomes. Hear from Donald Feinberg, Vice President and Distinguished Analyst from Gartner, about the state of the DBMS software market and data management challenges facing businesses today. The topics that Mr. Feinberg will examine include; the problem of exploding data volumes, new computing paradigms for handling this explosion, data management cost reduction techniques and technologies, and the perspective of the DBA now and in the future.
Following Mr. Feinberg will be a moderated panel of customers and partners who are leveraging the unique and desirable features only available in DB2 9.7.
This is one event you won't want to miss. Get your questions answered through 2 interactive (webcast) sessions, 8 exhibit booths, and live chat. IBM and it's business partners are helping companies around the globe with industry-leading data management technologies and their world-class expertise. Learn how your company can achieve smarter business outcomes and reduce underlying IT costs.
Attendee incentives include a complimentary memory stick for the first 97 attendees, which includes information on the cost savings of DB2 over Oracle. IBM employees are not eligible for this incentive.
Also a DB2 9.7 Discovery DVD for everyone who completes the event survey. The DVD includes trial code and tutorials. We look forward to seeing you there.
Tuesday, July 28, 2009
We have just added transcripts to each DB2 on Campus video. You can find them in the video description when you watch a video (right under it), or in this page under the "Transcripts" column. If you would like to volunteer to translate the transcripts, let me know!
Thursday, July 23, 2009
Monday, July 6, 2009
Tell us what you think about the book, and how we can improve it! We would like to collect as much feedback from the community as possible, and fix any typos, unclear sentences, incorrect examples, etc, by September, and publish again with the corrections made.
The DB2 on Campus program has visited Thailand at least 4 times now. Its impact has been felt as we see several universities adopting DB2 in their curricula, the most number of participants (2000 students) in ASEAN for the XML Superstar challenge, and the fact that Thai students won at the ASEAN level on all three categories of the contest (video mania, Query challenge, and programming contest). Congratulations to Thailand universities and students!
Friday, June 26, 2009
"...with MySQL being open source, its future is not that certain. So investing your time an effort to become a MySQL expert may not pay off in the long run because maybe a company like Oracle would buy it, and then kill it".
Three years after this "prediction", we find that Sun bought MySQL, and then Oracle bought Sun, which made MySQL an Oracle product. I wish I could predict the lottery numbers like this =).
Moreover, this is an interesting article about how Oracle killed a company it bought (Virtual Iron) just 5 weeks after completing its acquisition.
It's time to try DB2 Express-C! Download the newest version, DB2 Express-C 9.7!
Thanks to the many volunteers and DB2 Student Ambassadors who have kept the program going!. So let's join the 28,000+ students and teachers who have attended the DB2 on Campus presentations in more than 250 universities around the world, and let's join the more than 45,000 people who have downloaded the DB2 Express-C book, and the DB2 on Campus videos to say:
Happy 3rd birthday DB2 on Campus program!!!
Wednesday, June 24, 2009
11:30 am Eastern / 10:30 am Central / 8:30 am Pacific / 4:30 pm London / 17:30 Munich time. Register here.
Saturday, June 20, 2009
DB2 Express-C 9.7 includes a number of improvements and enhancements, too long to provide a complete list here. Other editions of DB2 include even more improvements. You can review the "What's new overview" section of the DB2 Information Center for details. However, these are the ones I like:
1) Locking enhancements
With the new Currently Committed (CC) semantics of the CS isolation level, writers (i.e: UPDATE) will not block readers (i.e SELECT). Readers will read the currently committed value prior to the update operation. This will improve concurrency and reduce deadlocks.
For example, say you have a table T1 with the following contents:
Now say an application AppA issues this statement, but does not commit:
update T1 set lastname = 'Smith' where firstname = 'Raul'
Next, application AppB issues this statement:
select lastname from T1 where firstname = 'Raul' with CS
Prior to DB2 9.7, this last statement would hang because it would wait for the exclusive lock held by the update statement of AppA (the writer) to be released. With DB2 9.7 and currently committed enabled (the default for new databases), the statement would return the currently committed value which was Chong.
2) Performance enhancements
For dynamic SQL, DB2 9.7 introduces the 'statement concentrator' feature, which should improve the performance of programs developed in languages such as Ruby and PHP. As its name suggests, the statement concentrator will look for SQL statements that look exactly the same but where the parameter value is different, and will 'concentrate' those statements into one. For example:
SELECT name FROM employee WHERE empid = 10
SELECT name FROM employee WHERE empid = 20
SELECT name FROM employee WHERE empid = 30
will be concentrated into:
SELECT name FROM employee WHERE empid = ?
The question mark (?) represents a parameter marker. At runtime, DB2 will supply the value of 10, 20 and 30 for this particular example. This will provide a huge performance boost. In prior releases, DB2 would treat each statement as unique, and would compile and execute each statement separately. However, the access plan for all these statement was likely the same, so it was a waste of resources to calculate it over and over again. With statement concentrator DB2 will compile the statement only once to obtain the access plan for the statement, and then it will reuse it.
Other performance improvements is the ability to store small LOBs inlined with the data rows. This improves performance for these LOBs as they can be access through the bufferpool.
3) Application development enhancements
A large number of improvements is now available to application developers:
Triggers and UDFs now have enhanced SQL PL support. Before DB2 9.7 they only supported inline SQL PL which is a small subset of SQL PL.
For SQL PL stored procedures, default parameter values and assignment of parameter values by name have been included. In addition, new Boolean, cursor, row and array data types are now supported.
ROWNUM and ROWID are supported
DB2 9.7 now supports the concept of a module (similar to the concept of 'Package' in Oracle). A module can bundle related database object definitions
Implicit casting between data types is now allowed. This will be useful for dynamic languages like PHP and Ruby. For example, this is now allowed:
create table t1 (col1 int)
select * from t1 where col1 = '42'
In the example, the string '42' can now be compared to the integer column col1.
There are many new functions for string, date manipulation and so on.
DB2 now supports Create Global Temporary Tables (CGTTs). These are temporary tables where the data is only available during the session. The difference between CGTTs and Declared Global Temporary Tables (DGTTs) is that in the case of CGTTs, the table definition is persisted in the DB2 catalog tables. So once a CGTT is created, it can be used by any session without having to create it again. The rows will be independent per session though.
Public aliases (a.k.a Public synonyms) for global object referencing have been added. Prior to DB2 9.7 all DB2 objects had a unique two-part name. The first part was the schema name, and the second part was the object name. By creating public synonyms, you can reference to objects without the schema name regardless of the user ID connected to the database. For example:
connect to sample user arfchong using mypsw
create public synonym raul for table arfchong.staff
select * from raul ## works OK
select * from arfchong.raul ## Error
connect to sample user db2admin using psw
select * from raul ## works OK
DB2 9.7 has relaxed its object dependency rules to allow for more flexible schema evolution. For example say you had this dependency:
View2 --> View1 --> Table1
If you wanted to change View1, you first had to drop View2 because it was dependant on View1. Now this is not required. DB2 will perform the revalidation of View2 automatically for you either immediately or when the view is used again. This can certainly help developers when testing their applications, and when they need to add columns, or make other changes to the database schema.
Other improvements in the schema evolution area are: Columns can be renamed, the REPLACE option has been added to several CREATE statements so there is no need to issue a drop statement therefore all privileges on the object remain. ALTER COLUMN can now use SET DATA TYPE for all types.
The Visual Studio add-ins have been enhanced
There have been JDBC and SQLJ enhancements to support some of the things mentioned earlier
The TRUNCATE SQL statement is now supported for fast deletes
New data types such as NUMBER, VARCHAR2, TIMESTAMP with a precision are now supported
Better support for Python-DB2 applications
pureXML enhancements such a support for Declared Global Temporary Tables is now available
4) Storage enhancements
Every time I teach DB2, I often get the question about "how much can DB2 store?". And almost on every release, I'm surprised about how our developers at the lab keep pushing the limits. For DB2 9.7, the size of large and temporary table spaces limits have been increased fourfold. For example, a 32k page large table space can now store 64TB. Previously it could 'only' store 16TB.
5) Security enhancements
In the past I used to compare SYSADM with 'God' because he could pretty much have access to everything in DB2. With DB2 9.7 the security model has been enhanced to allow for separation of duties. This minimizes the risk of data exposure and helps with government compliance requirements. There are several new authorities including DATAACCESS and ACCESSCTRL. These authorities can be given to users to access data, and grant access to data respectively. What this means is that a security administrator (SECADM) could revoke SYSADM or a DBADM these authorities, and therefore they would not be allowed to access any data!
6) Manageability enhancements
Now you have the ability to move tables online to a different table space. This means that while users are accessing a table, you can change where the table storage resides.
7) Installation enhancements
Now you can use the db2val command to verify if your DB2 installation is OK.
Many of these enhancements are described in the free online book "Getting Started with DB2 Express-C - 3rd Edition" which has been updated to DB2 9.7. The book will be available this June 26th!.
Enjoy the new DB2 9.7!!!
Tuesday, June 16, 2009
Join experts from the DB2 labs, Sal Vella - VP, and Serge Rielau - SQL Architect, to learn more about what Oracle compatibility means in DB2.
This Chat with the Lab will be held on thursday July 16, 2009 at: 11:30 a.m. Eastern / 10:30 a.m. Central / 8:30 a.m. Pacific / 4:30 p.m. London / 5:30 p.m. Munich
The presentation will last for 1 hour followed by upto 20 min of Questions and Answers.
To receive instructions for attending this webcast, kindly register at:
Tuesday, June 9, 2009
Exam 000-541: DB2 9.7 DBA for Linux, UNIX and Windows (due - July 2009)
Exam 000-543: DB2 9.7 Application Developer (due - August 2009)
In addition, there is a special "Pass & Save" offer: Candidates, who purchase, take and PASS an eligible DB2 Online Assessment Exam between April 24, 2009 and June 30, 2009, will receive a 50% off certification voucher good for the corresponding exam. That's up to $100 USD savings on each exam.
Visit this link for details.
The performance and cost savings of IBM DB2 9.7 on the Intel Xeon processor 5500 series.
WhereScape, an IBM business partner that helps customers expedite the process of creating, building and managing a data warehouse, discusses the performance and cost savings of IBM DB2 9.7 on the Intel Xeon processor 5500 series. The video also includes interviews from Intel and IBM executives about the cost savings associated with running DB2 9.7, the performance and energy efficiency of the new server platforms and the advantages that a business partner gains from the combined performance and value of DB2 9.7 on the Intel Xeon processor 5500 series.
DB2 9.7 - Hear what customers and consultants are saying about the new release of DB2 9.7 including results their organizations are seeing.
There is also a DB2 9.7 Technology preview Webcast recorded here
and this interesting Web site to reduce costs with 9.7.
Monday, May 11, 2009
Over 70 YorkU students from Computer Engineering, Computer Science, and IT programs attended the event to learn about the DB2 on Campus program and to help grow the DB2 community. Also, everyone in attendance requested to be contacted about additional DB2 resources, DB2 certifications, and future DB2 events!
Our featured DB2 on Campus Quarterly Newsletter and DB2 Best Practice flyers were picked up faster than free food! We also handed out DB2 9.5 Discovery Kit DVDs, some free t-shirts, and Raul donated a copy of his book, Understanding DB2: Learning Visually with Examples, to the YorkU Library.
Special thanks to the presenters, Raul Chong, Dan Han, and Ali Khan. Special thanks also to Amyris Rada for fielding the multitude of questions from students, and to Harsimran Singh, Ali Khan, and Raeid Saqur - York interns and Club Presidents for helping Dan organize this event.
Feel free to join the DB2 in YorkU group on channelDB2 to keep up with DB2 on Campus initiatives at YorkU, or if you want to contact the YorkU DB2 Student Ambassadors.
Thursday, April 23, 2009
- Reduce storage-related costs for data
- Improve administration productivity, allowing DBAs to focus on higher-value tasks
- Improve developer productivity, accelerating application development.
- Improve business decision making with simplified analytics and end-to-end support for XML documents
- Reduce the expense of deploying and supporting departmental warehousing and analytic solutions
DB2 9.7 will be available for download this June! Read the full press release here.
Register to this Webcast to learn more about DB2 9.7!
Tuesday, April 14, 2009
to download our "first" newsletter! Ask your friends to join as well.
Also use the channelDB2 group to provide feedback, open discussions, or provide material (articles, stories, anything related to DB2 Express-C, etc.) for upcoming newsletters. We look forward to hearing from you.
If you're interested in becoming a DB2 Student Ambassador, write to email@example.com
A special thanks to everyone who contributed to this first newsletter!
Agatha (DB2 on Campus Community President)
Tuesday, March 24, 2009
Currently we are updating the DB2 on Campus material, and are developing more free online books. Following the success of the "Getting started with DB2 Express-C" book (which by the way, has been downloaded 35,000 times to date!), we are working on developing 25+ free online books by the community on different subjects: From database fundamentals topics to Cloud computing. More than 100 volunteers are already participating, and they will be published around September. Even though the book work has already started, more volunteers are always welcomed!. English editing and technical reviews will be needed. In the future we will work on translations for the books. If interested, send us a note to db2univ at ca.ibm.com.
Wednesday, March 18, 2009
The Portuguese (Portugal) translation of the free "Getting Started with DB2 Express-C" book is now available!. Find it at the same location as the other books.
Thanks to all the volunteers from the community for making this translation a reality!
Other translations almost done: Japanese, Turkish, Thai, Indonesia Bahasa.
Thursday, February 12, 2009
As part of this announcement we have made available Amazon Machine Images (AMIs) for various IBM products including DB2 Express-C. They can be used for development. More information can be found here.
Check out this general IBM FAQs or DB2 specific FAQs on this subject.
On the technical side, here is documentation for using the pre-built DB2 AMIs:
- Get Started Guide
- Rebundling Guide
We also have a screencast showing you how to create your own DB2 AMIs from scratch
We are constantly looking for volunteers to translate the book, so please send us a note to firstname.lastname@example.org if interested!
Some other translations still ongoing are: Indonesia Bahasa, Thai, Bulgarian, Japanese, and Russian.
Thursday, January 8, 2009