Information Management Academic Community Updates
Not only did Informix recently release a new, exciting version of their product (Informix 11.7), but the Informix team has also been busy adding classes to the Academic Initiative courseware site. Faculty and their students can now gain access to **SEVEN** additional Informix courses on the Academic Initiative web site. You can find these courses in the Information Management section of the Academic Initiative web site:
You have to scroll down a bit since we are getting quite a few courses out there (but that is a GOOD problem to have....)
Check out the courses, and if you have any questions, email them to email@example.com
Skill Level: Introductory
Informix Structured Query Language V 11.5 (IX130)
Informix Stored Procedures and Triggers V 11.5 (IX711)
Skill Level: Intermediate
Informix Dynamic Server 11 Database Administration: Managing and Optimizing Data V 11 (IX221)
Informix Dynamic Server 11 System Administration (IX811)
Skill Level: Advanced
Informix Dynamic Server 11 Performance Tuning (IX401)
Informix Dynamic Server 11 Internal Architecture (IX911)
Informix Dynamic Server 11 Replication (IX421)
PatFletcher 060001U06U Tags:  data magazine academic free initiative ai management dm complimentary 1,718 Visits
Hey, this publication is always interesting and informative. Now you can get a complimentary subscription to the digital version as well. Even better for the environment. It's a true WIN-WIN!
IBM Data Management Magazine - Digital Edition - Complimentary Subscription!
The essential information resource for IBM database and data management professionals in an easy-to-navigate online format
Leaf through the digital edition as if you are holding a copy of the print magazine in your hands. IBM Data Management magazine digital edition delivers all the in-depth technical content, practical advice, and expert commentary you’ve come to expect—plus real-world examples of how your peers are using data and information architectures to advance business goals. The online version allows you to:
Quickly search content throughout the entire issue
Link directly to related resources
Easily access information and zoom in to view details
Share articles with others
Print out pages or tag them for reference
Get your complimentary subscription now! http://www.ibmdmmagazinedigital.com
PatFletcher 060001U06U Tags:  academic db2 certification ai associate luw ce302 initiative 1 Comment 2,317 Visits
The new DB2 Academic Associate certification exam for DB2 9.7 for Linux, UNIX and Windows is now
translated to Chinese, Spanish and Portuguese. Proctors desiring one of the translated
exams should mention the specific language requirement when they request the the codes
or the exam.
An additional improvement to the teaching materials for the course is a script to match
the course workbook to help guide new teachers for this course.
for additional information about the certification course and exam and the special
offers for 2010.
PatFletcher 060001U06U Tags:  db2 got contest initiative academic db2's ai certification talent 1,521 Visits
Congratulations to Norberto Gasparotto Filho, 1st place winner of the 'DB2's Got Talent' Contest! Well done, and enjoy your trip to the IDUG of your choice.
It was also exciting for me to learn that IBM's Academic Initiative had played a pivotal role in Norberto's professional success. While a professor at the Dois Vizinhos campus of Unisep, in Brazil, Norberto was excited to use the Academic Initiative DB2 content to build knowledge and DB2 skills for himself and his students.
As Norberto comments, "Through AI, I was able to use great IBM-official content, which added much value to my classes. I was also able to take my first certification exam with discount, and that was certainly an additional motivation." Norberto now has 7 certifications, and he can now add his new honor to his collection of professional successes.
Faculty today can take advantage of the DB2 Academic Certification program to easily provide DB2 training to their students and prepare the students to take the 302 Academic Certification Test: DB2 9 Database and Application Development Fundamentals
Are you a University Ambassador covering the Information Management portfolio? If so, here is a short (10 question) survey to help evaluate the current program for the ambassador community as well as for the university. Participate and help shape the programs in the future. Here is a link to the survey, for those who fit into this category: http://www.surveymonkey.com/s/WY7Q7YB
PatFletcher 060001U06U Tags:  im initiative db2 management profile darshan ai ypp information academic 1 Comment 3,874 Visits
Young professionals building successful careers using IBM Information Management products
Darshan Vaishnav: DB2 for Linux, Unix and Windows Young Professional
Darshan Vaishnav was born and raised in
This inspired Darshan to begin certification training on DB2 for Linux, UNIX, and Windows (LUW). He found the database product extremely interesting as well as easy to use. He earned his IBM Certified Database Administrator for DB2 on LUW V8.1 certification in 2004. Darshan worked as a consultant at several Fortune 500 companies before he moved to his current company, Marriott International, about 2 years ago. At Marriott, an industry leader in the hospitality industry, Darshan works as a senior database analyst in support of the Marriott.com website, where customers make business and personal lodging plans online.
Typical day of a database analyst
Darshan supports the main production database for the Marriott.com website. He carefully checks and validates any proposed structural or functional changes to the database before the changes go live in the production database. He ensures that the changes will not harm currently used databases or processes.
Darshan also teams with other Marriott database application developers and testers to ensure they have proper authorization for their projects in the test, development and production databases that he owns. He must ensure, however, that they do not gain any level of access beyond their functional role.
Other daily activities include ongoing database maintenance tasks such as ensuring critical daily backups are successful and monitoring and adjusting database space usage.
Darshan is often called upon to offer suggestions about performance tuning issues, such as adding indexes, changing database parameters and modifying existing queries. Another critical task he owns is ensuring his databases are ready for potential disaster recovery situations.
Technical challenges Darshan faces on the job
Marriott.com is a highly visible asset of Marriott International as well as a very high volume website. Darshan must ensure that his databases are maintained to a high set of standards and that they are ready for any jump in traffic. The main challenges he has faced were ensuring that the databases were tuned to avoid locking problems while at the same time providing enough concurrency for various applications while also keeping daily maintenance jobs running smoothly. In addition, he must ensure that the nightly data refreshes to the production database are successful and performed on time. Darshan and his peer DBA also ensure the best query performance by making sure that all tables have current statistics information and that the tables are available at any point in time.
Interesting application of the DB2 database
Darshan makes maximum use of DB2 LUW's maintenance utilities. He is an avid believer that DB2 has fantastic maintenance strategies in their Runstats and Reorg commands. He created scripts to update statistics every day and performs reorgs every week. He explains how he also makes use of the aliases capability in the DB2 product, “An alias is a pointer used for an actual table and we used it in some special manner such that, when some maintenance is happening, there is no outage required and all important tables have the best possible performance.”
His largest accomplishment in his career to date Darshan is very proud that his knowledge and support for the Marriott website databases has helped successfully maintain high availability over the last two years. Darshan is also proud of an earlier project he accomplished prior to starting at Marriott International. The task was to convert databases at several hundred stores from Sybase to DB2 UDB. He carefully crafted several custom scripts and a set of steps to migrate the data. The migration occurred very effectively and accurately due to his skill and diligence on that project. Advice to peers pursuing a similar career path Positive impact Darshan's work has on Marriott customers Darshan understands the importance of staying current with additional database training, and he has also completed his "IBM Certified Database administrator for DB2 V9" certification. This allows him to understand the ongoing feature additions to DB2 LUW and implement the appropriate ones for his databases. This dedication to his company and to his skill development makes Darshan an outstanding example of a successful DB2 Young Professional!
Darshan is very proud that his knowledge and support for the Marriott website databases has helped successfully maintain high availability over the last two years.
Darshan is also proud of an earlier project he accomplished prior to starting at Marriott International. The task was to convert databases at several hundred stores from Sybase to DB2 UDB. He carefully crafted several custom scripts and a set of steps to migrate the data. The migration occurred very effectively and accurately due to his skill and diligence on that project.
Advice to peers pursuing a similar career pathDarshan believes it is important for all database administrators to also have some understanding of the operating system where the database resides and how the database interacts with the operating system. With this knowledge, he describes the ease of learning DB2, "IBM's DB2 is less complicated than other database management systems. It is easy to learn and easy to get certified. The database is very responsive, very fast, and very efficient."
Positive impact Darshan's work has on Marriott customersDarshan is very dedicated to maintaining the Marriott.com website and keeping it available for customers at all times. Darshan explains how he has made a positive impact on his customer's overall experience with Marriott.com. "I feel that when I work with the back end as a DBA, the front end (the Marriott.com website) gets better; the front end gets smoother. People can come on my website and book their trip very easily, without any issues and very fast. And they can get on with their lives. If it starts with a really good experience with my website, obviously they’ll be happy. So that makes me feel really very good."
Darshan understands the importance of staying current with additional database training, and he has also completed his "IBM Certified Database administrator for DB2 V9" certification. This allows him to understand the ongoing feature additions to DB2 LUW and implement the appropriate ones for his databases. This dedication to his company and to his skill development makes Darshan an outstanding example of a successful DB2 Young Professional!
PatFletcher 060001U06U Tags:  certification 556 informix professional ai database im 1 Comment 1,769 Visits
A new professional certification, the Informix 11.50 Application Development Certification, has just been published; http://www-03.ibm.com/certify/tests/ovr556.shtml
This is great timing as the new Redbook on Informix Application Development has also recently been made available. http://www.redbooks.ibm.com/redpieces/abstracts/sg247884.html
The Redbook covers a variety of application development tools: Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate
You can get a no-charge Linux virtual image of the Informix 11.50 product, including their client developer kit, from the Informix on Campus website: http://www.informixoncampus.blogspot.com/
This image can be used on both Windows and Linux systems, and is a quick way to get up and running and ready to do application development on Informix
Glad to report on a new Informix Redbook: IBM Informix Developer's Handbook: http://www.redbooks.ibm.com/redpieces/abstracts/sg247884.html
It's a great guide to the many different interfaces for application development on Informix. It covers Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate. Check it out!
I was excited to receive this report about the first of the three DB2 Academic Associate Certification workshops held in Budapest, Hungary:
31 August – 2 September 2010
Budapest IBM Innovation Center organized its first free DB2 Fundamentals and Application Development course for university students and teachers between 31 August and 2 September 2010. Despite the fact that we announced the course in the middle of the summer and planned it for 24 participants, more than 100 students and teachers applied. Because of the big demand we decided to add two additional workshops in October for those whom we could not accept in September.
The workshop began at 9 a.m. and finished at 5 p.m. every day at the IBM Innovation Center (IIC), where Ferenc Rada, the leader of IIC welcomed the participants, then Tamás Piri (IIC) delivered the education in Hungarian.
First the students got better acquainted with the IBM DB2 database and the parts of application development, then after the theoretical part they could practice the operational and development tasks with hands on labs in the perfect educational environment of the IIC. The students also received education materials in the form of a course work book and a DVD to be able to practice their knowledge on their own time after the class.
Besides the professional education, the students could hear about the current IBM trainee positions and they could ask questions to János Ponczók from HR. Then Szilvia Kovács (from Software Marketing) spoke about the 48 hours programming contest in November, where everyone can try their fresh knowledge that they gained at the workshop, and the best students will get valuable prizes.
At the end of the 3 day course the participants could take a free exam in English in an internationally approved exam system. The best students got IBM gifts at the end of the course.
We can say in general that the students were quite receptive to learning about the DB2 database and database concepts, which was totally new for them. This was reflected very well by their questions and their interest all during the course.
There were 21 participants at the September course from 7 higher educations: Budapest University of Technology and Economics (7), University of Debrecen (1), Eötvös Loránd University (2), Dennis Gabor Applied University (1), Pannon University (3), Pázmány Péter Catholic University (3), University of Pecs (3) and University of Szeged (1). In October participants from
Additional information about the DB2 Academic Associate Certification program available here.