Data Life Cycle ++

Free new pureQuery eBook

2011-05-31T15:07:00.000-07:00

The free Getting Started with pureQuery e-book is available for download. This book was put together by many of the key pureQuery developers, technical evangelists and reviewed by some key customers.

This is the best collection of pureQuery info in book form and definitely the best way to get started.

Read this free ebook to:

Find out what pureQuery is

Learn how to get started and review configuration options.

Learn how to use pureQuery tooling in Optim™ Development Studio (ODS)

This reviews the major pureQuery tooling features found in ODS
BTW did I mention that the ODS tooling is free.
pureQuery ODS tooling provides help to any Java developer writing data access with JDBC, pureQuery, iBatis, and JPA for DB2 and IDS.

Write efficient Java™ database applications using pureQuery APIs

Discover what is different about pureQuery and review APIs

Learn how to optimize your existing Java database applications using pureQuery

pureQuery is a data access platform, so it makes it easier to developer data access application for DB2 & IDS and also faster.

Understand how pureQuery can optimize Java Persistence API (JPA) and Hibernate applications

Make you existing ORM apps faster and easier to write.

Practice while developing a sample Java application

Are you looking for a sample application that uses pureQuery to help you get started? If so look no further because you can find it in the ebook.

It's Alive!!!! IBM BigInsight (Hadoop ++)

2011-05-25T14:01:00.000-07:00

Well the time has come for IBM's BigInsight product to be released to the general public. It comes in 2 flavors:

IBM InfoSphere BigInsights Enterprise Edition

I'm just going to call in BigInsight EE
Here is the program number for those so inclined: 5725-C09

IBM InfoSphere BigInsights Basic Edition (aka free)

Let me call this one just BigInsight Basic
Here is the part number for those so inclined: DOJIHLL

Here is a quick summary of what's in BigInsights EE:

Open Source Components

Pig (programming language)
Flume (data collection/aggregation)
Hive (data summarization/querying)
Lucene (text search)
Zookeeper (process coordination)
Avro (data serialization)
HBase (real time read/write)

Some IBM Extras

JAQL
InfoSphere Warehouse Integration
text analytics engine

Look for more details coming soon!

Whaz up? IBM Big Data

2011-05-10T11:30:00.001-07:00

Are you curious about whaz happening with IBM Big Data? Have you heard about some of these IBM Products/Projects/Initiatives: InfoSphere BigInsight, BigSheets, InfoSphere Streams, InfoSphere SenseMaking (aka G2), Cognos Consumer Insight, IBM Distribution of Apache Hadoop, System-T, System ML, etc ...

To keep up with news and whaz happening here are some social media channels:

IBM BigData Twitter @IBMBigData

Planet Big Data - Twitter Feed

Here are some InfoSphere Streams communities:

IBM developerWorks Streams Processing Group
IBM developerWorks Streams Exchange Group

Streams samples and examples

Let me know if I should add anything!

=)
Rafael

TechCrunchTV Interview Anjul Bhambhri (VP of Big Data at IBM) on IBM's Big Data direction

2011-03-31T17:21:00.001-07:00

TechCrunchTV did a 5 piece interview with Anjul on March 30, 2011 on IBM's Big Data direction

Part1

Anjul talking about her early career and how did she get to managing IBM's Big Data mission.

Part2

Talks about Watson's role in Big Data. Anjul suggest that humanity should celebrate its accomplishment. Watson has something like 200 million pages of data (ie dictionaries, thesaurus, etc ..). The challenge was to ingest, search and makes sense of Big Data to be able to respond to a question.

Part3

Waton is becoming more like "human". Watson is a good example of how a computer can understand natural language and how a computer can understand Big Data. Computers or robots can not replace humans.

Part4

What's IBM's goal in the investment in Watson? The possibilities if we can tap into Big Data and do analytics can drive change in our society (eg Smarter Planet, Health care, etc ...). The possibility to be able to make a decision at the right time. IBM's is working on simplifying analytics on Big Data (aka making it easier to ask questions on Big Data).

Part5

IBM is more than just about mainframes. Anjul's business is managed as a start-up within IBM. IBM is looking at helping customers consume and make sense of Big Data(petabytes++) along with their traditional data. IBM's is working on helping customer's make sense of their growing amount of data. IBM is starting 1200 bootcamps on the technology behind Watson and what IBM's doing around Big Data. This bootcamps will be able to help with concepts, labs/example, Proof of Concept, etc... around Big Data.

IOD 2010 IBM Optim Session

2010-10-22T15:28:00.001-07:00

Steve Rees and I are doing a session on Thursday on leveraging the DB2 LUW Performance Best Practice with Optim Performance Manager (aka OPM)

Offering    Day/Time    Session #    Title
IDA    Mon 10:15-11:15am    TDM-2341A    Modeling and Designing Databases with IBM InfoSphere Data Architect: A User Experience
OPM    Mon 10:15-11:15am    TLU-1871A    IBM Optim Performance Manager V4.1 for IBM DB2 on Linux, UNIX, and Windows
Portfolio    Mon, 2:15 - 5:15pm & Drop-In Lab    HOL-1688A DIL-7004    Managing System Performance with Optim on LUW
Portfolio    Mon, 2:15-3:15pm    TDM-2597A    IBM Optim and IBM Data Studio Portfolio Strategy: Optimize Performance and Availability while Reducing Costs
DB2 Connect    Mon, 2:15-3:15pm    TDZ-3056A    IBM DB2 Connect Technology Update
QWT    Mon, 2:15-3:15pm    TDZ-1754A    Optim Query Tuning Solution: Tuning a Critical SAP Application
QT/QWT    Mon, 3:45-5pm    TDZ-1790A    Query Optimization and SQL Performance Tuning Using IBM Optim Query Tuning Offerings for DB2 for z/OS
OPM    Mon, 3:45pm - 5pm    TLU-2418A    Best Practices for Workload Management Using IBM Optim Performance Managert Best Practices Using Optim Performance Manager

Portfolio    Tue 11:15am-12:15pm    TLU-2761A    Real-Life Best Practices with IBM Optim Integrated Data Management from the GBS DBA Practitioners Perspective
Backup/Recovery    Tue, 1:45pm - 2:45pm    TLU-2144A    Delta Database Experiences Using the New Backup and Recovery Tooling for DB2 Linux, UNIX and Windows
pureQuery    Tue, 11:15am - 12:15pm    TDZ-1309A    Optim pureQuery Runtime for z/OS
Portfolio    Tue, 3-4pm    TDM-2881A    Managing the Performance of Your IBM DB2 zOS Applications by Using IBM Optim Solutions

OPM    Wed, 11:30am - 12:30pm    TLU-2135A    Troubleshooting IBM WebSphere Application Transactions on IBM DB2 with IBM Tivoli Composite Application Manager and IBM Optim Performance Manager
Portfolio    Wed, 2-5pm    HOL-1566A    Manage Performance of your DB2 z/OS Applications using Optim Solutions
pureQuery    Wed, 6-7pm    BOF-2413A    Extract the most value from .NET and ODBC Applications
pureQuery    Wed, 6-7pm    BOF-2965A    End to End data security with Guardium and pureQuery
OPM    Wed, 6-7pm    BOF-1875A    Optimizing Your Business System Using IBM Optim Performance Manager

pureQuery    Thu 11:30am - 12:30pm    TDM-2573A    What's New for IBM Optim pureQuery in Enterprise Java Data Access
IDA    Thu 1-1:45pm    BOF-2803B    InfoSphere Data Architect and Data Modelers User Group
pureQuery    Thu 1-1:45pm    BOF-2777C    Optim pureQuery User Group and Fans
Portfolio    Thu 2-3pm    TDM-2018A    Client success with an IBM Optim Performance Solution
Portfolio    Thu 8:15 - 11:15am & Drop-In Lab    HOL-1650A   DIL-7003    Best Practices Developing DB2 Applications with Optim Solutions
Portfolio    Thu 8:15-9:30am    TDM-2471A    Can You Benefit from IBM Optim Solutions? Yes! Come Hear Our Client Success Stories
Admin solutions    Thu, 11:30am - 12:30pm    TLU-1721B    Empowering DBAs with IBM Optim Administration and Tuning Tools
OPM    Thu, 3:30-4:30pm    TLU-2330B    Transforming Performance: Best Practices for Monitoring and Tuning IBM DB2 for Linux, UNIX and Windows
pureQuery    Drop-In Lab    DIL-1009    Auto tuning Hibernate Java Applications With DB2

My Who's who in pureXML in URLs

2010-06-04T11:15:00.001-07:00

I was doing an introduction to a buddy of who are the various folks who work on pureXML at IBM and I thought I would share the list of names, blogs and resource links I collected. These are the folks who's blogs and tweets I follow for pureXML new.

pureXML LUW team
https://www.ibm.com/developerworks/wikis/display/db2xml/Home
pureXML wiki & collection of resources
Matthias Nicola
http://www.matthiasnicola.de/
http://nativexmldatabase.com/
Blog
Author of DB2 pureXML Cookbook
Susan Malaika
Queen of XML at IBM
http://twitter.com/sumalaika
http://www.dataservicesworld.com/People/SMalaika.htm
Henrik Loeser - IT, Life, DB2, House Construction, ...
pureXML blogger
http://blog.4loeser.net/
Conor O"Mahony
pureXML Evangelist
http://twitter.com/conor_omahony
http://db2news.wordpress.com/
http://nativexmldatabase.com/
pureXML z/OS
http://www.ibm.com/developerworks/wikis/display/db2xml/DB2+for+zOS+pureXML
pureXML wiki & collection of resources
Guogen Zhang
pureXML z STSM
http://www.ibm.com/developerworks/blogs/page/purexml
http://db2usa.blogspot.com/2009_04_01_archive.html

If you are not familiar with pureXML then wikipedia might be a good start.
http://en.wikipedia.org/wiki/PureXML
Also check out Susan Vissers's pureXML resource blog:
http://www.channeldb2.com/group/purexml/forum/topics/list-of-purexml-resources

Optim at IOD 2009

2009-10-09T17:24:00.001-07:00

IOD is coming around the corner.

You can get at a list of all the Optim session at IOD from the following Optim Google Calendar.   This includes all the major if who, when, where and pointers to the actual session.    This includes Optim general sessions, labs and Usability sessions.   Here is a link to a pdf version of the Optim IOD sessions.    Here is a pdf of the Optim UCD sessions.

The Optim enablement team will be at the booth number blah. Make sure to stop by and say hello.   If you are interested in a particular demo of a product or technology we will be available for demos at the demo suite.

Here are some helpful links
IOD Registration Information
http://www-01.ibm.com/software/data/conf/registration.html

IOD Program Details
http://www-01.ibm.com/software/data/conf/program-details.html

Why Should You Attend IOD?
http://www-01.ibm.com/software/data/conf/justification.html

Customers Speak Out
http://www-01.ibm.com/software/data/conf/customer-speakers.html

Keynote Speaker - Malcolm Gladwell
http://www-01.ibm.com/software/data/conf/keynote-speaker.html

IOD Website
IOD Session Search
http://sample.iod2009.confnav.com/iod2009/webx/sessions/search.html

IOD Session Information
http://sample.iod2009.confnav.com/iod2009/webx/sessions/detail.html?id=20090813203657213510000000

virtual technical briefing featuring the new Optim Development Studio

2009-07-28T19:07:00.001-07:00

When: Thursday, August 20, 2009
How: Registration Link

The cool thing about this webinar is that is going to focused on Java data access with ODS and pureQuery and how this all complements RAD.

Previously known as IBM Data Studio Developer, Optim Development Studio
provides an integrated database development environment for Oracle, DB2, and
Informix. Come to this interactive session with product experts and learn how to use
Optim Development Studio to improve development productivity up to 50% for
developing and testing SQL and XQuery queries, stored procedures, Web services,
and Java data access layers. Also hear how Optim Development Studio extends the
Java development capabilities in Rational Application Developer.

Upcoming Webinar: InfoSphere Data Architect 101

2009-07-16T00:52:00.001-07:00

Formerly known as Rational® Data Architect, InfoSphere™ Data Architect is a foundational data modeling technology for any data-centric design and architecture work and thus provides core functionality for Integrated Data Management solutions from IBM.

In this introductory session, you'll learn about features and functionality, but you'll also get hints and tips on getting started. A must-see for anyone who does data architecture, modeling, and database design and hasn't worked with this product before.

Guest attend URL:
https://de202.centra.com:443/GA/main/000001854b38000001220314ff0086bf
When: 22 July 2009
Time: 1 pm. (Eastern), 10 am (Pacific)
Duration: 1 hour
Note: Please sign in 30 minutes early to allow for system checks.
Guest playback URL (in case you miss the event):
https://de202.centra.com:443/GP/main/000001854b38000001220314ff0086bf

BTW ... this is part of Virtual technical briefings on Optim Solutions for Integrated Data Management. There will be an entire series.

How to install Optim 2.2 eclipse based products via IBM Install Manager?

2009-07-11T18:40:00.001-07:00

Below are the step-by-steps on how to install the Optim 2.2 eclipse tools via IBM Install Manager. If you are going to install via the web repository then you will need an IBM developerWorks id. If not, you will need to download the trials before hand.

Download and install IBM Installation Manager
http://www-01.ibm.com/software/awdtools/installmanager/support/install.html
Start -> All Programs -> IBM Installation Manager -> IBM Installation Manager
After IBM Installation Manager launches, go to File -> Preferences
After the Preferences launch launches, click Add Repository.
Paste the installation URL or the unzip package path or the trials, click OK
https://www.ibm.com/software/rational/repositorymanager/repositories/rationalsdp7
(This is not a typical website, so don't try putting it into a browser)
If you place the IBM software URL, then you will need to use the developersWorks userid / password
Click OK in the Preferences
Back in the Installation Manager, click Install
Click on the packages you want to install

You can select multiple products and they will all install into a common and integrated eclipse.
Click Next to continue install
Accept the license and click Next
If you used the IBM URL you will be asked to fill out a survey
Select a package and click Next
Click Next when asked extended eclipse
Since this is a new install it will lay down base eclipse 3.4 and IBM shared plug-ins
When select language, click Next
Pick the options you want to install
Click Next after selecting the packages you want to install
Click Install to install the product

The artist previously known as Data Studio

2009-06-22T18:24:00.001-07:00

I can't help myself, but when products go through confusing names changes it always makes me think of "The Artist Formerly Known as Prince".

The product tools suite that used to be called IBM Data Studio 2.1 has been renamed to IBM Optim 2.2.
Here is a quick map of Data Studio 2.1 to Optim 2.2 product renames

IBM Data Studio Developer 2.1 ->

IBM Optim Development Studio 2.2
Product, Download, Forum

IBM Data Studio pureQuery 2.1 ->

IBM Optim pureQuery 2.2
Product, Download, Forum

IBM Data Studio Administrator 2.1 ->

IBM Optim Database Administrator 2.2
Product, Download, Forum

IBM also announced two new products:

IBM Optim Query Tuner 2.2
Product, Download tbd , Forum

IBM Data Studio 2.2
Product, Download, Forum

which is basically a summary of Curt's Optim annoucement 2.2 blog which includes links to the annoucement letters.

Not everything in the suite changed names, ie InfoSphere Data Architect (IDA) 7.5.2, DB2 PE and HPU all kept their names. However, IDA and HPU did have another release . Anson provided a short summary of some of the new features in IDA 7.5.2

If you are wondering what is in the new IBM Data Studio 2.2, that basically were you can find all the no-charge features that were spread amonest Data Studio Developer and Administrator 2.1. It is explaned in a little more detail in the Optim Forum from Kathy.

You can get access to all the Optim 2.2 Trial Code. The Optim 2.2 became generally avaiable on June 19, 2009.

Here is a link to the new and updated Optim 2.2 information center and Optim & Data Studio Space.

Holly's article on Integrated Data Management uses the new names and gives a good high level overview.

One of the big things that is new with the IBM Optim 2.2 is that Oracle support was added. Some products have had Oracle support for a long time like InfoSphere Data Architect, so in particular Optim Development Studio 2.2 added Oracle support.
Here is a great article from Sonali highlighting what's new with Optim Development Studio 2.2:

If you are still confused or want to learn more there is an upcoming Webinar on June 30, 2009 at 10 am PDT that could help:

Data Studio is now Optim: What does it mean for you?

and if you miss the the playback will be available afterwards.

Presenting at the Rational Software Conference

2009-05-31T00:57:00.001-07:00

I will be presenting the following sessions at the Rational Software Conference in Orlando:
Tues June 2

NEM01 - Developing High-performing Data Access Layers for z/OS
6:45 - 7:45 pm
Location: Dolphin Hotel, Americas Seminar Rafael Coss, Lead Enabling Architect, IBM Information Management Learn how pureQuery can help you plan for and administer pureQuery applications deployed with DB2 for z/Os as the target database. Understand the various ways pureQuery applications can be configured to access DB2 and hear about best practices for maintaining control, flexibility and best performance. Learn about how you can use the pureQuery tools in Data Studio Developer within RAD, RSA and RDz.

Wed June 3

MAC26 - Agile Data Tools to Make Your Database More Flexible
10:00 - 11:00 a.m.
Location: Dolphin Hotel, Asia 2 Rafael Coss, Lead Enabling Architect, IBM Information Management An Agile Data approach is great, but what tools can help me make it easier to achieve. Join us to learn more about Agile Data and how Data Studio and Rational can be use together to share metadata, make your database more flexible, collaborate and bridge the gap between DBA and developers. This session will be half presentation and half live demo showing the tools in Agile action.

and co-presenting Dr. Vladimir Bacvanski on
Thurs June 4

MAC32 - Developing Data-Driven Web 2.0 Applications with IBM(R)
Rational(R) Application Developer, sMash, and pureQuery
9:45 am - 10:45 am

Common demands for Web 2.0 application are rich interactivity and the
ability to handle large volumes of data. This session shows how the
integration of IBM(R) Rational(R) Application Developer, IBM(R)
WebSphere(R) sMash, and pureQuery provide a way to rapidly develop
data-centric, scalable dynamic Web applications. Presenters demonstrate
how the solution combined the Dojo Ajax framework for the user
interface, Groovy for business objects, and pureQuery, IBM's
high-performance technology for relational data access.

If you are going please check out my session and stop by the pedestal and say hello.

The IBM pedestal is pedestal #29.

New Integrated Data Manageement DeveloperWorks Space

2009-05-18T10:19:00.001-07:00

Well the Data Studio Space and Optim are coming together under one Integrated Data Management space:
http://www.ibm.com/developerworks/spaces/optim

Don't worry about the old URLs, they still work. They will just redirect you to the above URL.

You can find a list of Data Studio/Optim articles, videos, forums, and links to trial code.

Check it out!

pureQuery Made Simple Video

2009-05-02T02:08:00.001-07:00

pureQuery is a data access platform. pureQuery can work with and improve Java Frameworks like Hibernate or JPA, however it also offers an API. pureQuery and the API takes a different approach than some previous approaches. What so different? Check out this video!

Find more videos like this on ChannelDB2

XML is Everywhere in SOA, so why store it differently?

2009-04-16T08:42:00.001-07:00

Have you ever seen a SOA architecture chart like this:

XML is everywhere. It used to interchange information. It is used to submit functions via SOAP and web services. It is used in the presentation tier and business logic tier. So, why change it. If your SOA application uses XML everywhere why change it into some relational format. Just store it in the DBMS as XML. That's what DB2 pureXML does.

Well that keeps it simple, but then the next question how do I get it into and out of the DBMS? We could do it the traditional approach of writing some application code in Java/C# to put the data into and out of the database via JDBC, but why not use XSL, SQL or stored procedures for this. Wait, but what does SQL and stored procedures have to do with this? Just like we suggested not to shread the XML into relational to store it, you don't have to transform it into some OO objects to process it.

Sounds hard! Actually with Data Studio data web services (DWS) it's easy. DWS allow you to take any DML SQL or stored procedure and drag and drop it into a web services. And that service could run as XML using Data Power. There is some very nice integration between DWS and data power and which you learn more about from Michael Schienker's blog entry.

Data Studio 2.1 fp1 (DSD, DSA, IDA, PE)

2009-04-02T10:42:00.001-07:00

Data Studio released a series of fixpacks April 1, 2009. No this is not an April fool's joke. :-)

This was mostly a bug fix fixpack which included some usability fixes.

You can find them at the following links:
IBM Data Studio Developer, Version 2.1.0.1 Fix Pack 1
IBM Data Studio pureQuery Runtime Version 2.1.1 Fix pack 1
IBM Data Studio Administrator Version 2.1.0.1 Fix pack 1
http://www-01.ibm.com/software/data/studio/download.html

DB2 Performance Expert Version 3.2.1 Fix Pack 1
DB2 Performance Extended Insight Feature, Version 3.2.1
http://www-01.ibm.com/software/data/db2imstools/download.html

InfoSphere Data Architect Version 7.5.1.1 Fix Pack 1
http://www-01.ibm.com/software/data/studio/support/data-architect/download.html

Let the downloading begin.

If you need more details on how to install the fixpack, check this out:
http://www.ibm.com/developerworks/blogs/page/datastudioteam?entry=everything_you_wanted_to_know

How it all began: Preventative Maintenance for DBA's

2009-03-31T03:42:00.000-07:00

Wow, I started my first engineering assignment almost 20 years ago at Del Monte , the last San Jose, CA cannery. At that point I was a Civil Engineering undergraduate with strong CAD skills. A buddy of mine, Miguel, who was an Industrial Engineer major was raving about this innovative internship he had working for the plant manager, Howard, of a local San Jose cannery doing AM/FM. No, my first job was not in radio but about Facility Management (FM). The AM (Automated Mapping) piece was about giving you a map to visualize were your facility needed help.

Preventative Maintenance (PM) is a term commonly used in FM. The basic objective of objective is to avoid the constant fire drills in facility maintenance.

The Wikipedia provides the following definition for Preventive Maintenance:

The care and servicing by personnel for the purpose of maintaining equipment and facilities in satisfactory operating condition by providing for systematic inspection, detection, and correction of incipient failures either before they occur or before they develop into major defects.

Why was PM so important to Howard, the plant engineer? Because the price for an outage was very expensive in terms of labor and capital. How does a cannery work? It's a labor intensive 24/7 operation where if a major component\area goes down due to a maintenance issue you could have 100's of workers just standing around, your mechanics running around trying to figure out what went wrong and how to fix it ASAP and your capital, in our case fruit, is rotting as you wait to get back online.

Howard, was a smart guy and he new many of these outages could be prevented by doing PM. He and the mechanics knew that a motor or pump or elevator, etc ... typically worked well only for X months. And if he could keep track of all of key components and when they were last worked on. Then he might be able to come up with a plan to fix the equipment before it broke again and thus potentially preventing a problem or at least from an even larger problem.

The AM piece was about not having the mechanics run around everywhere. Don't fix one motor on one side of the cannery and then have your mechanics move all their equipment to the other side of the cannery to overhaul the next motor. Once they setup camp in a particular area what else should be done there. So, Howard wanted a map to visualize all the equipment that needed to be worked on for the next two months, so he could could plan and schedule the work. He also used the map to communicate to the mechanics what needed to be done. And later on he started using the map to look for patterns in outages. It became Howard's dashboard.

BTW, we did not call it AM/FM back then it was just known as Howard's pet project. A couple of years later as I learned about GIS ; I realized that we had built a crude AM/FM GIS out of RBase and AutoCAD.

Wouldn't it be great if DBA's could do PM to help them prevent their daily fire drills? Wouldn't it be great if DBA mangers had a dashboard to help them visulaize potential problematic areas and then be able to plan and schedule work to address these concerns, just like Howard?

IBM Eclipse Database tool for MySQL?

2009-03-17T17:59:00.001-07:00

Did you read this correctly? Yes, IBM has released some tools that support database development for MySQL. Don't worry my blue blooded buddie DB2 and IDS are also supported. Check it out:
http://www.alphaworks.ibm.com/tech/dssqlftk

It has a very long name:

Eclipse Based Foundation Toolkit for Heterogenous Database Applications

but it is basically provides a plug-in for:

Connecting to MySQL, DB2's and IDS
Browse, Create, Alter and Drop database objects (DDL)
Query editing and running for standard ANSI SQL with content assist
An IDE for SQL stored procedure (aka routine) development

The nice thing about this tool is that is uses the Eclipse update infrastructure to install into your existing Eclipse 3.4.1 environment.

Smart Metering/DB2 Performance Expert

2009-03-16T16:28:00.001-07:00

Henrik came up with an awesome analogy for DB2 Performance Expert. Here is his blog entry:
http://blog.4loeser.net/2009/03/smart-metering-db2-performance-expert.html

The basic analogy that Henrik tries to draw is that if you want to find out how much energy you are using you have to go to your meter and check it. But how do you know when you are using the most energy? How do you know if you are using more or less than last month? The only way to know is to collect/store the energy amount somewhere so you can later go back and do some analysis. This is basically one of the main features of DB2 PE is to collect monitoring information (snapshot, event monitor) and store it, so you can go back later to do analysis on how much CPU or Memory have you been using, from who and when. It also just provides a nice way to visualize database monitoring information.

Data Studio Eclipse 3.4 facelift

2009-03-04T23:42:00.001-08:00

With Data Studio 2.1 it moved from being based on Eclipse 3.2.2 to Eclipse 3.4.1. One of the major changes/enhancements was leveraging the latest Data Tools Project (DTP). One of the most major changes was in how connections are managed. In eclipse 3.2 connection were under the Database Explorer view and in eclipse 3.4 there are in the Data Source Explorer. Check it out!

Not only did we add the eclipse 3.4 capabilities but we also did a few extras also. We added the ability to store and manage connection in centralized Connection Configuration Repository. There is also a nice video on the connection Configuration Repository on channel DB2.

The other major thing that changed and improved in going to eclipse 3.4 is how SQL results are displayed.

You can learn more about these enhancements from in the following article:

Exploring what's new in Data Studio Developer, Version 2.1

What's the difference between Data Studio and Data Studio Developer?

2009-02-20T10:14:00.001-08:00

Have you ever used MS Office? Most folks tend to answer YES! I like to reply to them I have never used MS Office, I have used MS Word, MS Power point, MS Excel, etc ... Data Studio is very similar. Data Studio is a suite of products around the data life cycle. When you use Data Studio you end up using InfoSphere Data Architect, Data Studio Developer, Data Studio Administrator, DB2 Performance Expert or DB2 Optimization Expert.

Remember that not all the products in the Data Studio suite of tools are named Data Studio something, however they can all install into the same eclipse which just grows the capability of your single database tool with the function of each product you add into it.

There are some Data Studio capabilities that are complimentary. These are part of Data Studio Developer and Data Studio Administrator. You can get them by installing everything but the advance features during install. Sometimes folks call the complimentary tools just Data Studio, some folks call it Data Studio base or Data Studio foundation. It is basically the free parts of Data Studio. But these capabilities are really part of Data Studio Developer and Data Studio Administrator.

Data Studio Shell Sharing Support

2009-02-15T15:55:00.001-08:00

I came across the following technote on Data Studio 2.1 shell sharing support:
http://www-01.ibm.com/support/docview.wss?rs=3360&uid=swg27014124

I talks about some known shell sharing issues, some of which I have heard will be fixed in the Data Studio 2.1 fixpack.

But the really nice thing is that it has a list of Data Studio 2.1 and Rational 7.5 products that will shell share.

The artist formely known as Rational Data Architect

2009-01-15T11:26:00.001-08:00

Rational Data Architect (RDA) 7 was the last release with this name. The new name is InfoSphere Data Architect (IDA) 2.1. The new release shell shares with the Rational 7.5 series of products. BTW, this will share with Rational 7.5 fixpack 1 aka 7.5.1.

Data Studio 2.1 released

2009-01-15T11:21:00.001-08:00

The Data Studio 2.1 suite of tools had a new release on Dec 19th. You can find the try and buys here:

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

You can also find new videos on channelDB2 and new articles on the Data Studio Space.

New Data Studio 1.2 products released today

2008-07-31T17:36:00.001-07:00

The IBM Data Studio Administrator v1.2 and IBM Data Studio Developer v1.2 are now available as a 30-day trial package from the following website:

Data Studio Administrator 1.2:
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=swg-dsa12

Data Studio Developer 1.2:
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=swg-dsd12

The trial packages will allow use of features of Data Studio Administrator and Data Studio Developer v1.2 products for 30 days. It will revert to the existing Data Studio v1.1.x unwarranted functionality at day 31.

In addition, please check the following links for a video overview of the Data Studio Developer v1.2 features.
http://channeldb2.ning.com/video/video/show?id=807741%3AVideo%3A10108

For details regarding IBM Data Studio, please visit

http://www-306.ibm.com/software/data/studio

Data Studio Administrator Announcement 47216:
http://www-01.ibm.com/common/ssi/index.wss?DocURL=http://www-01.ibm.com/common/ssi/rep_ca/3/897/ENUS208-213/index.html&InfoType=AN&InfoSubType=CA&InfoDesc=Announcement+Letters&panelurl=index.wss%3Fbuttonpressed%3DDET003PT011%26hfdd%3D%26hfud%3D%26timestamp%3D1215615042784%26user%3DEXT%26page%3D1%26DET003PGL001%3DUS.en.en_US.MM-dd-yyyy%26us_hc_index%3DAMR.US%26homecountry%3DAMR.US%26us_dl_index%3DALANG%26documentlanguage%3Den%26ALLANGUAGE%3Don%26display_index%3DNAV002PEF005%26NAV002PGL001%3DNAV002PEF005%26det003pef003%3DEXTERNAL%26coincidence_index%3D0%26submit.x%3D47%26submit.y%3D15&paneltext=Announcement%20letter%20search

Data Studio pureQuery runtime for z/OS V1.2 Announcement 47556:
http://www-01.ibm.com/common/ssi/index.wss?DocURL=http://www-01.ibm.com/common/ssi/rep_ca/7/897/ENUS208-177/index.html&InfoType=AN&InfoSubType=CA&InfoDesc=Announcement+Letters&panelurl=index.wss%3Fbuttonpressed%3DDET003PT011%26hfdd%3D%26hfud%3D%26timestamp%3D1215615042784%26user%3DEXT%26page%3D1%26DET003PGL001%3DUS.en.en_US.MM-dd-yyyy%26us_hc_index%3DAMR.US%26homecountry%3DAMR.US%26us_dl_index%3DALANG%26documentlanguage%3Den%26ALLANGUAGE%3Don%26display_index%3DNAV002PEF005%26NAV002PGL001%3DNAV002PEF005%26det003pef003%3DEXTERNAL%26coincidence_index%3D0%26submit.x%3D47%26submit.y%3D15&paneltext=Announcement%20letter%20search

What is a persistence framework?

2008-07-30T07:48:00.000-07:00

Here are a few pointers and definitions for what is a persistence framework:
http://www.roseindia.net/enterprise/persistenceframework.shtml
A persistence framework moves the program data in its most natural form (in memory objects) to and from a permanent data store the database. The persistence framework manages the database and the mapping between the database and the objects. There are many persistence framework (both Open Source and Commercial) in the market. Persistence framework simplifies the development process.

http://www.pbell.com/index.cfm/2008/7/14/What-Should-a-Persistence-Framework-Do
At its simplest, the goal of a persistence framework is to simplify and speed up the process of handling persistence of your applications. What a persistence framework needs to do depends heavily on your use cases.

http://tinylearn.com/index.php?option=com_content&view=article&id=60&Itemid=73
It makes it easier to use a database with Java and .NET applications.
The persistence layer sits between the business logic layer of the application and the database. This separation is important to ensuring that your persistence strategy is not mixed with your business logic code, or vice versa. The benefit of this separation is that your code can be more easily maintained, as it will allow your object model to evolve independently of your database design.

Welcome to my Data Life Cycle ++ blog

2008-07-30T07:30:00.001-07:00

I am going to be blogging on topics around the micro data life cycle. The micro data life cycle is the application life cycle focused around the data requirements, data model, data design, data develop, data administration, data optimization, etc ... . This blog is call ++ because I am also going to include anything else that I feel is interesting. Hopefully folks will find this blog interesting and useful at times. :-)

saludos,
Rafael