DB2 V10 Linux,Unix,Windows Roadshow coming to Columbus, Ohio June 6th

If you will be in the Columbus area the first week in June.  Please join us for the DB2 Roadshow  and learn how to take full advantage of the new features in DB2 LUW 10. 

When:  Wednesday, June 6, 2010 - Columbus (Dublin), Ohio 
Where:  IBM Dublin Office
                Bldg 1 - Auditorium C
                4600 Lakehurst Ct
                Dublin, Ohio  



And learn about the....

• New Adaptive Compression, resulting in over 70+% database compressions for many clients
• Time-Travel Query allowing you to see your data as it is, as it was, and as it will be ... great for for historical reporting, auditing, and planning
• Row and Column Access Control giving data-centric security and compliance on your sensitive data
• Storage Temperature Data Management to better control position of data on high-performance devices
• New index, join, and scan techniques for improved query performance and maintenance
• Additional Oracle-compatibility features for making moving your applications to DB2 easier than ever!
• Enhancements to DB2 for LUW High Availability and Disaster Recovery (HADR)

 This session is offered free of charge. 

 To register please send an email to  jkoblen@us.ibm.com  or contact your local IBM representative.  

Registration will begin at 9:00 AM.  The session will start at 9:30AM and end at approximately 3:00pm.   Complimentary breakfast and lunch will be provided. 

 The session will also be offered at: 

IBM Southfield, Michigan  -  Tuesday, June 5th and

IBM Cincinnati, Ohio          -  Thursday, June 7th 
reply with email if you are interested,  to  jkoblen@us.ibm.com  
 

 

Session Presented by Bob Harbus

IBM, DB2 Technical Specialist and DB2 Evangelist

Bob (M.Sc., University of Toronto) has been with IBM since 1989 and with the IBM Toronto Lab since 1992. Having worked in a number of areas including DB2 Linux, UNIX, and Windows development, DB2 Service and Support, DB2 Certification (where he authored a number of books on DB2), and DB2 Lab Services (specializing in data warehousing and transactional systems), Bob is currently a DB2 Technical Specialist and DB2 Evangelist in the WW IM Technical Sales organization

db2top on windows - quick tip

I recently spoke with a customer who liked db2top alot and inquired if he could run it on Windows. I told him that while it couldn't be run directly, it could be launched from a machine that supports db2top (unix,linux,aix or a vmware running unix/linux/) and attach to the windows database remotely.

I told him I'd seen an article referencing these steps and that he would likely find the instructions if he googled this. After searching for the link to give that to him, I could no longer find that posting. So, here is a quick note on how to do this.

In my example a have a linux machine running redhat from which I'm launching db2top.

1) First, catalog the remote windows database using both the
db2 catalog tcpip and db2 catalog database commands.

These catalog commands are run on the linux machine.

Here is my example:

db2 catalog tcpip node W2003 remote 9.123.44.66 server 50000

(where 9.123.44.66 is the IP address of the Windows database server I'd like to monitor and 50000 is the port, W2003 is an arbitrary name I gave my node.)

db2 catalog database sample at node W2003

2) Then, launch db2top from your linux machine using the -n nodename -u userid -p password.

My example again:

db2top -d sample -n W2003 -u db2admin -p ibmdb2

And, your monitoring your Windows Db2 database using db2top. (remotely from your linux/unix machine.)



I hope you found this tip helpful. I'm sorry I can't give the original author credit for posting this.
If you'd like to learn more about db2top, I've found the following Blog postings from Keith McDonald quite helpful. http://www.thekguy.com/db2top

db2connectactivate for direct connections to Db2 z/OS

Many shops are using or have been using the JCC T4 drivers to establish a direct connection to DB2 z/OS. If your site does this or is headed towards this gate-less architecture for DB2 Connect, you might want to review the db2connectactivate utility.

db2connectactivate is a license key utility that can be run from the DB2 Connect Unlimited Edition CD or install image. Starting in version 9.7 Fix Pack 3, you can activate the license key for DB2CUE on any z/OS subsystem or data sharing group that you want to access directly.

To use the db2connectactivate utility :
1. First ensure that the Java Runtime Environment of 1.4.2 or later is available on the DB2 for Linux, Unix, Windows (LUW) workstation from which you want to run the activation utility.

2. Then from the activation_cd_root\consv_zs\db2\license directory, issue the command for your operating system with the appropriate options:

- On UNIX: db2connectactivate.sh [options]
- On Windows: db2connectactivate [options]

This process will install a SQL bodied stored procedure if connecting
to  a DB2 z/OS V9+ or a scalar function when using DB2 V8 z/OS
host systems.

Once the activation step is completed,  the stored procedure
will be invoked to validate the license.

Activating the license key on a z/OS subsystem can take less time than
activating the key on each client computer.
If your still leveraging a gateway you can still activate the license as
you did in previous versions. 

For more information,  refer to the documentation 
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.licensing.doc/doc/t0057375.html

DB2 LUW Technote Tip for Linux

I've recently been doing some tuning for various customers on Linux. While I've focused primarily on zLinux in the past, this particular tip is for Linux on AMD Operton. But, I thought it was worth noting an I hope that if this matches your particular environment, you also find it helpful

Symptom

Slower OLTP workload performance running on Linux RHEL on AMD, when HPET (high precision event timer) is disabled in the operating system.

The details of this technote can be found here:


http://www-01.ibm.com/support/docview.wss?uid=swg21443045&myns=swgimgmt&mynp=OCSSEPGG&mync=E


Continued and Happy Tuning...

OPM Workshop on DB2 Performance - Columbus, Ohio May 12th

If you will be in the Columbus area, we will be hosting a DB2 Performance Workshop with Optim Performance Manager (OPM) May 12th in the IBM Office. To register, please email jkoblen@us.ibm.com

Optim Performance Manager Extended Edition for DB2® on Linux®, UNIX®, and Windows® is the latest offering from IBM to help you resolve emergent database performance problems before they affect the business. In this workshop, you will learn about the new capabilities provided in the product,including a powerful Web-based user interface with detailed diagnostic displays for problem analysis, out of the box reporting for both post mortem analysis and proactive trend analysis, enhanced integrations to support end-to-end diagnosis
and tuning, and expanded capabilities for deep performance insights into Java™
and DB2 call level interface applications.

Here is a link to a recent developer work's article which gives an introduction to the OPM solution.

http://www.ibm.com/developerworks/data/library/techarticle/dm-1004optimperformance/index.html

New Year's resolutions ..well..add Database to that diet too.

Wondering what your new year's resolutions will be this year ? Is dieting on that list ? It's almost always on mine, or at least eating better. But, how 'about adding dieting for your database too.

Much like my appetite for too much food throughout the year, many of our z/OS -unix/linux and Windows applications also have a large appetite for volumes of data. Maybe mergers and acquisitions happened, maybe lack of (or a myriad) of data retention policies, or any number of factors had your data volumes growing at a rapid pace. Does all this data have you constantly purchasing CPU and capacity upgrades ? Backing up and recovery too much data ?

Is all that data really used, maybe it's time to ask your database to go on a diet.
When we eat less, those favorite jeans fit better.........and well, when our database is lean & mean ..those queries will run better too.

I've decided it may be necessary, so I put this video together to show how to put that DB2 z/OS data on a diet using IBM Optim. This video shows how to use the native z/OS version of IBM Optim, but you can do the same kinda stuff for distributed platforms with Optim too. Against any number of database platforms such as Oracle, SQL Server, DB2 LUW ... you get the picture.

IBM Optim will pull that fat off your database and make those queries and backups run mean and lean. Optim has the capability to provide universal access to that data without even making it necessary to restore it. However, if you do decide to restore that archived data - you can place it back in the original source, or even a different database platform...



Well, here is a quick tour of archiving (aka dieting) for DB2 z/OS. You can also view the video on Channeldb2.

Archiving DB2 data with IBM Optim z/OS from jankobl on Vimeo.

Still need more reasons to think about dieting (I mean archiving) ? how 'bout
–Improve performance
–Control data growth, save storage
–Support retention compliance–
Enable application retirement–or
Streamline those waistlines ...I mean streamline those upgrades. A Peoplesoft upgrade can feel a whole lot better after an Optim Archive diet.

You can find more information on our Optim Library : http://www.informationmanagementrequest.com/mk/get/OPTIMLIBRARY

New JDK version to enhance performance of SAP on zLinux

SAP and IBM announced a new J9-based JVM with enhanced memory management for the SAP NetWeaver stack. SAP Note 1338196 has the details on the general availability (GA). For Linux on System z, the following are now supported:

• SAP NetWeaver 2004 starting with SP22
• SAP NetWeaver 7.0 (2004s) starting with SP15,
• SAP NetWeaver 7.0 (2004s) EhP 1 starting with SP3
• SAP NetWeaver 7.0 (2004s) EhP 2 and future EhP’s

Per the SAP Note 1319038, you can download the code here and the aforementioned note has the technical details for installation:
https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-ibmjavaisv

The announcement details stated " The J9-based JVM comes with an enhanced memory management for the SAP NetWeaver Java stack complemented by new efficient Garbage Collector policies. The resulting benefits in SAP Java environments are more efficient server utilization and more consistent response times. Internal and customer tests in SAP NetWeaver environments have shown reduced CPU utilization while keeping full compatibility with the IBM Classic VM for Linux on System z."

Using it yet ? Post your comments and feedback.