DiaryFolio

Apple is all about quality products and intutive design. Not so far is Mr.Apple TV. Not sure still why the Internet TV revolution is still not caught up, but there is great opportunity out there. Thought of putting forward my review about latest Apple TV, released in March 2012. (let's call it Apple TV3) Some details which could be interesting for you Size and Weight Height: 23 mm (0.9 inches) Width: 98 mm (3.9 inches) Depth: 98 mm (3.9 inches) Weight: 0.27 kg (0.6 pounds)1 Detailed specs:  http://www.apple.com/uk/appletv/specs.html Some tech details 1080 full HD support, airplay full support even with new ipad , use facility of Apple Cloud etc.. Sleek design that’s small, quiet, and energy efficient. (less than 6W) Video formats supported: H.264; M-JPEG; MPEG4 ..m4v, .mp4 and .mov. Hence youtube, high quality movies easily playable. (Only H264 supported at 1080p) Image formats supported: GIF; JPG; TIF (Great to watch your digital images) Wi-Fi (802.11a, b, g or n) ( 802....

United Kingdom house prices going down.. Some reasons I can think of High value initial money requirements Stricter immigration controls? Value of house more than average wages Un-employment on the rise and no spare money for youth. The long term price trend graph is also going down. The above graphs are very much in-line with the research and bubble market hypothesis as I already noted in my previous post  http://www.diaryfolio.com/2012/03/housing-and-financial-bubble.html There are quite some clever graphs to check if its better to Buy house or Rent including the long term impact NYTimes Graph

For those who are working on Web development and data visualisation, below links are very useful. Some are for providing the much needed data visualization techniques, while others provide CSS and javascript integration http://code.google.com/apis/ajax/playground/ http://jsfiddle.net/wkCNm/ http://www.fusioncharts.com/demos/gallery/ http://www.w3schools.com/css/default.asp http://960.gs http://freemarker.sourceforge.net/docs/index.html http://www.w3schools.com/xpath/default.asp http://formalize.me/ http://www.1stwebdesigner.com/css/powerful-css-tools-generators-automate-workflow/   #To test various CSS features http://www.tutorialsbucket.com/draw-basic-shapes-css3-tips-and-tricks http://thejit.org/static/v20/Jit/Examples/Spacetree/example1.code.html  #alernative graphs http://www.visualcomplexity.com/vc/  # visualisation samples

Ever wondered about these keywords? I thought they were silly. But I have seen these keywords coming up regularly in yahoo visualise and real-time keywords high in the list. That means fellow netizens are using these keywords a lot. Well, the sites delivering them are limited in quality. Only a handful few are genuine and are regularly updated. Some of them which I know off are HotUKdeals (UK)->  http://www.hotukdeals.com/ Fatwallet (US) ->  http://www.fatwallet.com/ Quidco (UK) ->  http://www.quidco.com/ Groupon (International) ->  http://www.groupon.com  , co.uk   I felt some of the big players like Groupon are hyped than the others. If you are really going behind deals and cash saving you need to visit the above sites with cashback facilities.

Some very helpful one liners for db2. If you are a fan like me to execute db2 commands within the Unix/AIX prompt, rather than going into DB2 inbuilt prompt then all commands run on the fly. Much powerful is Unix prompt as you can modify data in whichever way you want. db2 list database directory;    #Lists all databases within the installation db2 list node directory; db2 "SELECT SCHEMANAME FROM SYSCAT.SCHEMATA";  #Shows all schema within the Database Instance db2 set schema myschema01   # Setting schema before execution db2 "LIST TABLES FOR SCHEMA myschema01" | more db2 describe indexes for table <table_name> show detail | tr -s " "   # shows details about the table including primary key and indexes db2 get snapshot for application agentid 228 | more # db2 "force applicatioin (228) "   #Careful as it forces the session 228 out of DB2 db2pd -d myDB01 -wlocks db2 export to C:\CSVFiles\OutputmyTable.csv of del select * fr...

Recently I had learnt about a great utility within DB2 to view the dynamic queries and session details.  The utility is called " db2top "   (Careful db2stop will stop DB !!) To access it 1. Login to db2 user..  (say db2iuser1) 2. db2top -d myDB  # myDB is my database name 3. click on "l" key. It will show all the sessions hitting the database 4. Click on "a" key to interrogate a specific session. And enter the session number shown in above screen 5. Press "f" to force the session out. (Be careful). You might need to try twice as sometimes the session might come up again. Enter key is for "action" and "refresh" etc. Ensure that the command is not let run continously, as it takes fair bit of memory in long run. A good quide within IBM   is for command line execution, and also with batch mode options.  

Everyone who works in IT industry and with Unix systems should have suffered filesystem related issues. The most common one is the filesystem getting filled up. The scenario is Filesystem is filled up Determine largest files Filesystem is using different mounts. So the files you see are not within the filesystem. But there is a trick to find the largest files within the same filesystem   # Shows the largest 20 files within the same filesystem # xdev will make sure its within the filesystem find . -xdev -ls | sort +6 -nr | head -20   Some other helpful commands in AIX to see the filesystem volume groups and if all disk is used lsvg -o  # displays all volume groups lsvg -l <lvname> # list  (including mounts) lsvg <lvname>  # show details like free space etc