Sunday, November 13, 2011

Keep track your learnings


Often we are given a new task/problem at our work and then we find out a solution for that task/problem.  As the time pass by we forget those hard earned learnings. When we face the same task/problem again, we may remember that we faced that task/problem before, but we may not be able to remember the solution.

So, create a word document to note down all your learnings. Lets call this as "knowledge base" document.  When ever you learn something, open that document and write down your learnings in simple terms. It hardly takes 5 mins to document your learnings.  If you are not nearer to your computer, make sure you document it when you get access to your system. Keep doing this, when ever you learn something new.  When you are given a task/problem and you remember that you that solved that before , open your knowledge base document to check if you documented the solution and if yes, you will be saving your energy and time.

Thursday, November 10, 2011

Can we use internet banking over public WIFI hot spot

When you connect your laptop to public WIFI hotspots, the data that leaves your laptop and sent to your laptop are viewable by others. Hackers in the Public WIFI hot spots can use some network monitoring tools to view your data.

Unless the website that you are visiting starts with "https://", the data that leaves your laptop and sent to your laptop will be in "plain text". So, hackers who sits in that public spot, can easily steal your personal data such as your user ids, passwords credit card numbers etc..

When a website address starts with "https://", the data that leaves your laptop will be encrypted. So, when a hacker intercepts your encrypted data, he cannot do anything about it.

If you want to use internet banking in the public wifi spot, make sure the internet banking site's URL always stays with "https:/" from the moment you log on and till you sign out.

The below sign on screen in the bank of america site starts with https:// which mean the user id and password will be encrypted before it leaves the computer and the response reaches the computer will also be encrypted.

After signing on, the url still stays with "https://" which indicates that if we do any transaction, the transaction will be encrypted before it leaves the computer and the response reaches the computer will also be encrypted.





Wednesday, November 9, 2011

How to save starup/boot time in pc/laptop

After regular use for 1 or 2 years your pc/laptop may slow down and it may take 2 to 3 minutes to boot.  So, to save boot time, hibernate your pc/laptop after your work instead of shutting it down.  Hibernation puts your open documents and programs on your hard disk, and then turns off your computer. Next time when you switch on your pc/laptop, it restores the open documents and programs from the hard disk and thus save your time.

Purpose of Last sign in date in email, banking websites

In email, banking websites you might have seen "Last sign in" date and time.  See the right hand side in the below screen. This gives you a chance to make sure that no one is using your account other than you.

Sunday, November 6, 2011

How to watch vidoes in youtube if you have slow internet connection

On the video, click on the settings located at the right hand lower corner of the screen. Select the lowest values which is "240P". See the below screen. After doing this, you may experience better video buffering...




Thursday, November 3, 2011

Tamil songs: ILLAIYARAJA hits

Some of the best of songs from Illaiyaraja..

Sangathil Paadatha kavithai - Auto raja(1982) Ilayaraja song
Azhakaga Sirithathu
Pattu Enge - Poo Vizhi Vaasalile - Ilaiyaraaja
Avathaaram - Thendral vanthu theendum pothu
Adhi KAlai Neram
Kallukkul eeram - Siru pon mani
Thamdhana Thamdhana - Pudhiya Vaarpugal
Kasthoori maane
Aananda Raagam - Panneer Pushpangal (HQ)
Oru Thanga Rathathil from Dharma Yutham
then sinthuthey vaanam - Ponnukku thanga manasu
வா பொன்மயிலே நெஞ்சம்
Velakku vecha nerathile - Ilayaraja, Janaki - Munthanai Mudichu (1983)
janani janani jagam nee agam nee
Aei Unnaithaane - Kadhal Parisu
Neelakkuyile Unnodu Naan
andha naal nyaabagam
Tamil Movie Song - Tik Tik Tik - Poo Malarnthida Nadamidum
Aayiram malarkalae.avi
Malligaiyae
Rasathi Manasula
Ye Rasathi
Vasalilae Poosanipoo
Yen Uyir Neethane
oru kili urukuthu|---anandha kummi
Aathadi Paavadai Kaathada
etho mogam
Naan Yenbarthe
Paada vanthathor gaanam
thendrale ennai thodu - Thendral vanthu - Ilaiyaraaja
Poobaalam Isaikkum - Thooral Ninnu Pochu
Thanga Sangili - Thooral Ninnu Pochu
Johny - Senorita - Ilaiyaraaja
Evergreen song
Kaalai thendral paadi varum from Uyarndha Ullam
putham puthu kalai
Vaan Megangale - Puthiya Vaarpugal
Adi Penne - Mullum Malarum
Anjali - Anjali anjali anjali - Ilaiyaraaja
MOUNA RAGAM THEME MUSIC
Punnagai Mannan
Poonthalir aada..
Ilayaraja Best Title score BGM
Manithnin Marupakkam - Oomai Nenjin Sontham
Oru Kadhal Enbadhu - Chinna Thambi Periya Thambi
Gopurangal Saivathillai - Poo Vaadai Kaatru
metti oli kaatrodu...En Nenjai Thaalaatta...
Ettana Iruntha
NEE ORU KADHAL SANGEETHAM
VIZHIYILE MANI VIZHIYIN-NOORAVATHU NAAL
kaathal kavithaigal...
Muthamizh Kaviye varuga

Wednesday, November 2, 2011

DB2 : How to improve the elapsed time for db2 load jobs using parallel index build

The tables with more than one index can be benefitted by parallel index build (PIB). When load card has non-zero value for SORTKEYS, it instructs the load utility to perform parallel index build.

When we use PIB, load utility skips SORT, BUILD phases and goes directly to SORTBLD phase. SORTBLD phase does all the processing carried out in SORT & BUILD phases.

The RELOAD phase, instead of writing index key values to SYSUT1 file(SORTIN file), it writes them into the main memory.  Also I/O to SORTOUT file is avoided.

PIB reduces the elapsed time for a LOAD job by sorting the index keys and rebuilding multiple indexes in parallel (SORTBLD phase), rather than sequentially. Optimally, a pair of subtasks process each index; one subtask sorts extracted keys while the other subtask builds the index. LOAD begins building each index as soon as the corresponding sort produces its first sorted record.

You don’t have to provide the SORT work files. Based on the SORTKYES value, SORT will automatically allocate the SORT work files for you.  To calculate the SORTKYES values, multiply the number of input records by number of indexes defined on the table.  A sample load job that utilizes parallel index build is given below.


//STEP001  EXEC PGM=DSNUTILB,REGION=0M,                 
//            PARM='DB1T,LOAD'                          
//SYSIN    DD *                                         
 LOAD DATA                                               
  REPLACE  LOG NO  NOCOPYPEND SORTKEYS 2502872091       
  STATISTICS TABLE INDEX UPDATE ALL                     
 INTO TABLE MY.TABLE                                    
 .....                                                  
 .....                                                   
//*                                                     
//SYSREC   DD DSN=INPUT DATASET..                       
//SYSDISC  DD ....                                      
//SYSMAP   DD ....                                       
//SYSERR   DD ....                                      
//SYSUT1   DD ....                                      
//SORTOUT  DD ....                                      
//SYSPRINT DD SYSOUT=*                                  
//UTPRINT  DD SYSOUT=*