Join IBM experts to learn about enabling your Oracle applications for DB2 9.7.
DB2 9.7 brought the biggest infusion of SQL features since DB2 V2.1. In this presentation, learn about features that lead to a ten-fold reduction in enablement costs when Oracle-based applications are enabled for DB2. The virtual tech briefing covers the following:
Business drivers to move Oracle applications to DB2
SQL enhancements in DB2 9.7
Tooling support to enable applications from Oracle to DB2
The agenda covers the full spectrum of information management and includes keynote sessions from leading IBM, customer, and business partner speakers. There are hands-on technical labs and industry round tables.
Our very own Julian Stuhler will be speaking at the Data Management keynote session on Wednesday 19th May at 15.15 CET. He will be on stage with Martin Wildberger, Vice President, Information Management Development. During the session Julian will be discussing his own personal technical experience and the experience Triton has had with DB2 9.7 and DB2 pureScale.
Keep up to date with all the happenings here and via twitter.
How many times have I asked customers for the DB2 diagnostic log file (db2diag.log) only to be told “it’s too large to send” or “it’s taking too long to open.” This is because the DB2 diagnostic files have been append only since time immemorial, their growth only restricted by the maximum space available in the file system they reside in. The only way to curb this growth would be to rename the files which would then force the creation of new ones. Scripts had to be written to automate this process and to delete old files after a certain period.
With the advent of DB2 9.7, all this is now history! The new diagsize database manager parameter allows a DBA to control the maximum sizes of the DB2 diagnostic log and administration notification log files. When this parameter is set to a non-zero value (which is the default pre-DB2 9.7 behavior), a series 10 rotating diagnostic log files and a series of rotating administration notification log files (only on UNIX and Linux) are used. It is also smart enough to clean up the diagnostic log directory of old log files. When the size of 10th file is full, the oldest file is deleted, and a new file is created. More information is available at: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.config.doc/doc/r0054862.html?resultof=%22%64%62%32%64%69%61%67%22%20.
Things to note:
·diagsize is not configurable online. It needs an instance restart after an update for the new value to take effect.
·diagsize is the value (in MB) of the total size of all the DB2 diagnostic log and administration notification log files on UNIX and Linux. 90% of the total size is allocated for the 10 diagnostic log files and 10% of the total size is allocated for the 10 administration notification log files. On Windows, diagsizeis the value (in MB) of the total size of all the 10 DB2 diagnostic log files on Windows. The link above gives a good example to clarify this.
IBM has been making huge technical strides with their flagship database, DB2, over the past few years. As expected, the recent launch of DB2 9.7 has not failed to impress, incorporating even more improvements.
DB2 9.7, also known as the COBRA release, has made up significant ground on Oracle. The ease with which organisations are now able to migrate from Oracle to DB2 has been enhanced so dramatically that it is now an enticing option. Previously the time taken to migrate an Oracle-based application to DB2 would take weeks, if not months. This can now be achieved in a matter of days.
A recording of the live DB2 chat with the lab webinar held in July.
DB2 9.7 for Linux, Unix, and Windows has out-of-the-box support for Oracle’s SQL and PL/SQL dialects. This allows many applications written for Oracle to execute virtually unchanged with DB2. In this chat Serge Rielau, SQL Architect for DB2 LUW, provides an overview of Oracle compatability features in DB2 9.7.
IBM DB2 9.7 introduces enhancements that allow you to make changes to the database objects while keeping these objects fully accessible to the database users during the modification. These enhancements allow database administrators to make vital changes to the database schema on the fly without any disruption to users. This article includes examples that demonstrate how to use the ALTER TABLE command to rename columns and change column data types. Other examples demonstrate how to use the ADMIN_MOVE_TABLE routine to move and modify tables while keeping them accessible.
This video highlights some of the new features in DB2 9.7 that make it very easy to enable Oracle applications to DB2. It includes demos for features like support for PL/SQL, CLP Plus, and Optim Data Studio for data movement.
In a recent article on PC World Chris Kanaracus discusses Oracle’s recent decision to raise prices on some add-ons for its flagship database by up to 40%. This is a controversial move given that the modules are said to be crucial to getting databases to perform at the highest level - click here to view the article.
Break free from rising costs with DB2 9.7. Click here to see IBM Data Champion, Julian Stuhler and other industry experts talk about their first hand experiences of how organisations can gain huge benefits from IBM DB2 9.7.
