How many transaction does your db2 database handle in a day and what is the transaction rate per minute? Well its not a difficult to answer. Simply take snapshots of your database periodically and viola you have your answer. But what if you want to see a trend and want to do some predictive analysis. Well watch this blog and i will have something that will do it.
Its time for a new look. Finally got around changing the theme and doing bit of modifications around it. Let me know what y’all think
I’m sure that the DB2 UDB users have once came across the famous java.lang.NullPointerException error when using one of IBM’s tools. The most common fix is to install any fixpacks, update java and ensure db2updv** command has been run. At least thats been the answer for me in the past.
I had a strange error when using Replication Center against one of my DB2 Replication server V9.5. My replication scenario involved replication from a particular subsystem in DB2 Z/OS table to a SQL Server via a Websphere Federation Server (used to be called DB2 Replication Server with relational wrapper). While trying to list all the registered table or when I try to list all the tables to be added to a particular apply qualifier using Replication Center, I kept getting the java.lang.NullPointerException error. After troubleshooting it for a while, I noticed that the error happens only when the list involved a particular registered table. To my surprise (or not !) I saw the CCD_OWNER column for one of the capture registered table in ASN.IBMSNAP_REGISTER table was not null. I don’t have a CCD table in my replication scenario, so the rest of the CCD column for the registered table were all null except for the CCD_OWNER column for the one of the table. Apparently when the capture table was registered, the CCD_OWNER column was populated with spaces instead of null. This threw Replication Center off. Once I nulled that column for that particular row, replication center started listing all the registered table for that subsystem.
Replication Center throws this error if there is any data related issue on any one of the replication configuration or control tables, so next time go through the configuration tables and ensure that the data is setup right.
I upgraded my office laptop to Windows 7 and was looking into tweaking the system to improve the performance. My search resulted in finding tweakhound.com . Its a pretty good website and goes into details about adjusting windows setting to improve performance. Not only that, it also discusses about optimal way of installing Windows OS. Wish I found this before I started installing Windows 7 !
I like to assign certain special ringtones for certain contacts on my iPhone. My blackberry will let me use MP3 format as ringtones, but iPhone don’t . It needs a .m4r format ! So I decided to figure out how to convert them to m4r.
There are few free softwares out there that will do the trick, but I didn’t want to bloat my Mac with those. Apparently iTunes can handle it with just a few tricks. With few clicks and right clicks I got it done. Here is how :
- Start iTunes and find the song you want to convert. (It must be an MP3.)
- Right-click the song and choose Get Info.
- Click the Options tab.
- Check the Start Time and Stop Time boxes, then enter times for each (ringtones cannot be more than 30 seconds ). I tried 0:00 and 0:30, on each of the songs.
- Click OK, then right-click the song again and choose Create AAC Version. This should create a 30 second AAC version of the song.
- Drag that version out of iTunes and into the folder of your choice.
- Delete the 30-second version from iTunes and undo the Start Time/Stop Time changes to the original.
- Open the folder containing the 30-second AAC file you dragged out of iTunes, then change the file extension from .m4a to .m4r. Double-click it and it immediately gets added to iTunes’ ringtone library.
- Finally, sync your iPhone. When it’s done, you can head into the settings and select your new ringtone.
I just wish iTunes could just convert any song to a ringtone by itself. Not sure whether it has anything to do with privacy or something like that.
This is my first blog from my iPhone. Will update this with a review of this app
BP has capped up the oil well and the world needed something else to talk about. Apple has pitched in with the “death grip” for their new iPhone4. I am pretty sure everybody knows about it by now and for those very few who hasn’t heard , apparently if you hold the new iPhone4 in a certain way and the signal fades away. This is mostly because Apple was “creative” about putting the antenna around the phone. Surprisingly it passed QA !
Don’t get me wrong, I love iPhones, I own one of them , I think they are great smartphones and perhaps one of the best out there. But I wish Apple did a better job on these.
So what is Apple doing about addressing the issue ?? Giving out free iPhone4 bumpers and cases so that it cover the “magic” part of the antenna. Well thats one way to “fix” the issue. I like the way they are doing it.
They have an app on the iTunes App Store, you download it to the iPhone and it walk you though the selection of bumpers and cases available. You order it and off there and viola ! they ship it to you . All free of charge ! The whole process takes less than two minutes (unless you can’t make up your mind on which case you want) . I got to tell , they have some good selection of cases, not anything fancy, but decent ones.
The only condition is ” For iPhone 4 purchases made before July 23, 2010, you must apply no later than August 22, 2010; otherwise, you must apply within 30 days of your iPhone 4 purchase. To qualify for this program, you must purchase your iPhone 4 by September 30, 2010″
Recently I had to price out SQL Server 2008 solution for a project. During the hunt for an estimate pricing model I found this and thought I would share.
Microsoft made some serious changes in their licensing criteria between SQL Server 2008 and SQL Server 2008 R2 , here is the quick glance :
Its important to read the new license model if you are planning to run Virtual Machines (VM), detailed info can be read from this pdf
Yeaaa..the cap is back in the rouge Louisiana oil well after it was off for almost the whole of Wednesday. While the cap was off, oil gushed out again at up to 104,000 gallons per hour, however they managed to suck up and incinerate 438,000 gallons. The rest became part of the ocean and pool natural life takes the suffering. Its really disturbing to see some of the destruction the oil leak has done. I thought of posting them here, but decided not to upset my readers.
Check out this image to see how it look at the “crime” scene deep under:
BP who is loosing millions , perhaps billions every day has a site that has a live stream of “all” the underwater cameras on their ROVs which monitor this site. Click here to get to that site.
