Finally, I am able to successfully install the IBM Mashup starter kit with the help of Lauren. I come to know about this kit from Sreekanth blog entry "Get it done quickly - Mashup". In this entry he mentioned that this kit will help creating a dashboard with the data from various sources with zero coding,So This looks interesting and I thought of giving it a try. After 2-3 days of struggle and with the help of Stephen and Lauren, I was able to successfully install both QEDWiki and mashup hub which are the part of this kit. I still need to spend some time to play and do some experiment with it. README provided with this kit says that you need to use Express-C version of DB2 and zend core version 2.0.4 or later. But it works fine even with DB2 V9 ESE but not with previous version of zend core.
I will write about my experience using this kit soon in an another blog entry. Till then enjoy reading.[Read More]
DB2 Administration and Application Development on Cloud (BlueMix)
From archive: November 2007 X
Sardana 06000055HU 1,744 Views
As not all the certification guides are available for DB2 Version 9, It looks a little difficult to go for the certification for V9. Susan Visser mention in one of her blog entry to read the book titled "IBM DB2 9 New Features" along with the corresponding V8 certification guide to prepare and pass the V9 certification. I wondered if this book is available in India and asked the same question to Susan and got a pleasing answer, the book is available through tata McGraw-Hill publication. When I visited their site, I found they need a manual order and I was not sure how many days it will take to get it delivered to me. Then after a google search, I found that you can order the book online though a cb-india portal, and they are delivering the book within 3 days from the order. They are giving 20% discount too. I just ordered the book as I need it for preparing for the DBA certification. Here is the portal link
Here are the contents for this book, looks really interesting. It seems V9 features are covered thoroughly. Susan mentioned in her blog"One of the major selling points of this book, besides the fact that it lists all the newest features is it's coverage of XML. There is no other book on the market that has such thorough coverage of XML on DB2 9."
So it will be nice reading. I am waiting for this book to reach me soon.
Part I. XML in DB2 New Hybrid Storage Engine Ch. 1. What is XML? Ch. 2. When Do I use pureXML? Ch. 3. pureXML: The DB2 XML Database Ch. 4. Tuning XML Performance Part II. Autonomics and Manageability Ch. 5. Up and Running Enhancements Ch. 6. Self Tuning Memory Manager Ch. 7. Automated Storage Ch. 8. Other Autonomic and Manageability Enhancements
Part III. Application Development Ch. 9. Rational Data Architect Ch. 10. DB2 and the .NET Developer Ch. 11. DB2 and the Java Developer Ch. 12. DB2 and the Scripting Languages Developer Ch. 13. DB2 and the XML Developer Ch. 14. DB2 Developer Workbench Ch. 15. Other Application Development Topics
Part IV. Security Enhancements Ch. 16. Label-Based Access Control Ch. 17. Additional Security Enhancements Part V. SHARP Enhancements Ch. 18. Larger Table Space Support Ch. 19. Larger Object Support Ch. 20. Raw Compression Ch. 21. High-Availability Enhancements Ch. 22. Additional SHARP Enhancements Index[Read More]
While working from last 3.5 years under different mangers, I always use to think, on which platform I compare my managers. How I can say which is the best and which is not so good comparatively(might be individual's personal choice but still it will be good if their will be some criteria). I always wonder what to speak when a manager ask me to give feedback. Today I read an article which gives me some points to consider while preparing for such a feedback session. Thanks to my team mate Jayasimha who sent the link for this article. Have a look
Dont miss the link in the article which gives 10 qualities to be measure up and see how many times you like to say thanks to your manager.[Read More]
Isolation levels are generally associated with DBA activity. But sometime an application developer too want to change it, may be for particular type of queries. So ever wonder how you can update the isolation within level your java application. Do it with the method setTransactionIsolation of connection object for example
where TRANSACTION_SERIALIZABLE is a JDBC constant. Below is the table for constant correspond to each isolation level
TRANSACTION_SERIALIZABLE --- RR
TRANSACTION_REPEATABLE_READ --- RS
TRANSACTION_READ_COMMITED --- CS
TRANSACTION_READ_UNCOMMITED --- UR[Read More]
Earlier today, I was preparing the presentation on DB2 pureXML. At the end of the presentation, I wanted to put some references and came across these DB2 Games. A nice idea to teach DB2 to the people who are new to DB2. I like the detective game more interesting then business one. It is easier but interesting too. I think it will be very useful to teach people DB2 and SQL/XQuery. Here is the link to download these games.
DB2 Business game
DB2 Detective Gamehttp://www.ibm.com/developerworks/edu/dm-dw-dm-0402kubasta-i.html
Have fun learning DB2[Read More]
XML, XML and XML... most of the data in this world can be represented in XML format. But sometime it is not baneficial to do that specially when their is tight coupling with the data and data is really obeying strict rules. But at the same time, when data need to be very flexible and you like to store only those things which has some logical values, XML is the way. It will save your memory if there are a lot of propeties/column which as null value. In RDBMS, NULL is a logical identity while in XML world, there is nothing like NULL, its just either value exist or not. While in RDBMS, metadata is stored only once (one column name), in XML metadata will be repeated for every record. Then what the benefit ? There is no need to stored metadata at a different location which means no catalog tables. but yes there is schemas which will do the job.While RDBMS cant work without catalog tables, XML can work without schemas.
Now coming to how XML fits within RDBMS ?RDBMS stored the data in a table format. Each column has a strict data typing. So to store XML, either we need to split into the parts which has strong datatypes or assume that full XML, a binary or character streams. In first case, we need to create metadata first and then split the data and in second, we are completely ignoring the metadata associated with the XML document. We need a way where we save the metadata and at the same time there is no need to split the metadata from the XML to retain its flexibility. Which means storing the XML in such a way that it preserve its structure and at the same time fit into RDBMS model. And here comes the innovative solution of pureXML.
DB2 pureXML is a technology which work with both relational and XML data under one umbrella. It can query both XML and relational data at the same time using SQL/XML language. the benefit is that applications now can concentrate on business logic rather then worrying how to handle XML data coming in their way. DB2 will take care of your XML data from storing it in memory to query it, transform it, represent it. DB2 treat XML as just another data type in his repository and provide you the functions to work with this datatype.
XQuery is the language to query XML data and for this new XML data type, DB2 provide you the flexibility to query this data type using XQuery only. At the same time, it integrate XQuery and SQL together using SQL/XML. So you can query a table to select the relational columns where some condition in XML has met. So far So good.[Read More]
Sardana 06000055HU 1,530 Views
Today I got my developerworks blog working and I am quite excited to talk on the topics I am working from so long and do like to share with others. To start with, I like to share my first RED BOOK and first article. The RED BOOK titled "DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET" talk about the various aspects of application development with DB2 Express-C version 9. It has dedicated chapter for major languages supported by DB2 and a chapter on XML. You can download the book from http://www.redbooks.ibm.com/redpieces/abstracts/sg247301.html?Open.
My first article is just got published last week. It talks about the new and enhanced XML features of DB2 V9.5. You can have a look at the article here http://www.ibm.com/developerworks/db2/library/techarticle/dm-0711sardana/index.html[Read More]