Before some time IBM announced its new POWER7 processor and some new System p servers with that processor. POWER7 is huge improvement in processor technology and it is undisputed benchmark leader which is quite standard for any new POWER processor…Continue
Added by Radim Kolar on April 19, 2010 at 1:33am — No Comments
This is an article regarding the 2 problems mixed DB2 DAS problem and also the Memory problem
Initially I got the problem in db2diag.log file that…Continue
Added by Lohith on April 11, 2010 at 6:30am — No Comments
If you ask your IBM sales rep: How much DB2 Express C scale? Do you have any benchmarks? Then answer probably will be: We don't have benchmarks, but probably not much.
I was interested how much is not much. It is true that there are no benchmarks for DB2 Express C - but better to say there are no benchmarks for any DB2 edition other then…Continue
Added by Radim Kolar on March 15, 2010 at 4:32pm — No Comments
Opensource databases such as MySQL and PostgreSQL supports non standard SELECT extension for limiting number of returned rows from query. You can see description in PostgreSQL manual. Look for keywords LIMIT and OFFSET. LIMIT specifies the maximum number of rows to return, while OFFSET specifies the number of rows to skip before starting to return…Continue
Added by david t on March 8, 2010 at 1:15pm — No Comments
You may have heard about several different capabilites available with pureQuery such as Client Optimization, Annotated Method and In-Line. Some questions that I have had about these options would include what is the difference between these methods and where do I use each? I wanted to just quickly write a few paragraphs to answer these two primary questions.
In answer to the first question, both Annotated Method and In-Line are part of the pureQuery API. Annotated Method uses…Continue
Once you get past the simple case of copying changed data from one system to another, the next most common replication solution is data distribution. In this scenario, you distribute data from a central database to two or more databases, maybe even 100's, that are likely remote. An example is sending changes from a corporate headquarters to branch offices or retail locations. You may only need the data to flow one way - from a central database to others. Or, you may also need some data to…Continue
Added by david t on February 15, 2010 at 4:00pm — No Comments
Added by Mahesh Kumar Joshi on December 25, 2009 at 1:30pm — No Comments
I often get asked if it's easy to set up IBM cache tables and whether they can be set up with scripts instead of a GUI The answer I give is yes to both questions. Cache tables, a form of distributed caching, are very easy to set up and you can do it with scripts. The challenges are that (1) IBM's documentation could be better and (2) a good sample is needed. I'm hoping a few pictures, a little text, and a small sample are all that's needed to improve the situation…Continue
Added by david t on February 5, 2010 at 9:00pm — No Comments
Added by Lohith on February 3, 2010 at 5:52am — No Comments
Another DB2 upgrade mini-guide. I was asked to upgrade DB2 Express 9.5.4 to DB2 Express 9.7. Reason for this was that old DB2 Express 9.5.4 was 90-day demo version and demo key expired. Upgrading DB2 will generate new 90-day key and allows to use DB2 for some more time which would be enough for finishing application development. It was small VMware DB2 instance with 1GB ram for using during application development.
I pointed that installation of DB2 Express C will be better because it…Continue
Added by Radim Kolar on January 28, 2010 at 4:28pm — No Comments
Added by david t on January 24, 2010 at 9:30pm — No Comments
Added by Radim Kolar on January 23, 2010 at 9:41am — No Comments
Added by Paweł Myrczek on January 14, 2010 at 6:38am — No Comments
Added by Bob Sawyer on January 13, 2010 at 7:00pm — No Comments
Yesterday, DB2 Express C 9.7.1 was released. I have one non root db2 9.7.0 copy floating around and wanted to update it. Non root db2 installations are very convenient for casual testing. They can be installed quickly by regular user and you do not need to seek assistance of unix administrator.
Updating DB2 Express C linux installations with standard db2 install program is not possible - you have to do reinstall because unix db2 installer do not have ability to do updates like ms…Continue
Added by Radim Kolar on December 2, 2009 at 11:00am — No Comments
Licensing for DB2 Express C changed in 9.7 version a bit. DB2 Express C is still free to use and distribute, but DB2 Express C FTL - Fixed Term License is no more. FTL licensing option was moved to regular DB2 Express Edition.
This is good move because people sometimes criticised that DB2 Express FTL have more issues than regular express version. Also it will make easier sw maintenance for IBM because they can now concentrate on 3 DB2 Editions (Express, Workgroup, Enterprise). DB2…Continue