Latest Entries »

Yea, Its good property of gmail that you can undo a sent mail till 30 seconds after clicking on send.

For this you have to enable a feature on Gmail,…

Follow the simple steps πŸ™‚



1. Open your Gmail Account

2. Click on Mail Setting

3. After that click on ‘Labs’

4. Scroll down and go to ‘Undo Send’

5. Make it Enable

6. Click on Save Changes

Now Compose a mail, after sending the mail, you will get a notification on screen like ‘Your message has been sent Undo

View Message‘.

Click on Undo, It is all πŸ™‚

Enjoy πŸ™‚ πŸ™‚


Uptime command with awk

Pretty much trick to get nice output via awk utility. Here is what I did with uptime πŸ™‚

uptime | awk -F’,’ ‘{print “last 1min” $4 “\n” “last 5min load average:” $5 “\n” “last 15min load average:”$6}’


last 1min 0.00
last 5min load average: 0.00
last 15min load average:0.00

Try it out πŸ™‚

Try installing GCC library using zypper:

zypper install libgcc_s1-4.7.2_20130108-0.17.2.x86_64.rpm
zypper install libstdc++6-4.7.2_20130108-0.17.2.x86_64.rpm
rpm -qa |grep gcc (For querying, if installation is done)


Zypper is the native command-line interface of the ZYpp package manager for installing, removing, updating and querying software packages of local or remote (networked) media. Its graphical equivalent is the YaST package manager module. (From Wiki)


Try it out πŸ™‚

Passwordless Authentication:

Password Less Authentication using SSH:

1. PuttyGen: generate both public and private keys

2. Save the private key on your PC

3. Go to server, create .SSH directory

4. Under this create a file named authorized_keys

5. paste public key in here and save it

6. Go to your Superputty, Tools, putty config, in SSH Tab in left corner, then Auth… browse your Private key here.

You’re good to go πŸ™‚

Below query will let you know the current heap memory being used by the HANA:








select round ((sum(heap_memory_used_size)/sum(heap_memory_allocated_size))*100,2) “HEAP_MEMORY_USED_PERC” from m_service_memory

Try it πŸ™‚

Below commands will let you create a workspace in HANA.









Command 1:
hdbuserstore set sidkey SYSTEM ********

Command 2:

regi create workspace sidwsp –key=sidkey


hdbuserstore set zttkey SYSTEM hUToLp

regi create workspace zttwsp –key=zttkey



Enjoy πŸ™‚

Here’s the command by which you can clear up HANA logs or other logs which are older than the numbered days(value you put).









find /hdb/ZTT/backup/log -type f -name “log_backup*” -mtime +50 -exec /bin/rm -f {} \;

You might want to set this as a cronjob and get over the manual deletion of logs.

Try it out πŸ™‚

Here’s the one line command by which you can recover HANA system with specified backup:





 –command “RECOVER DATA USING FILE (‘/hdb/ZTT/backup/data/ZTT-20141029-092054’) CLEAR LOG”

Note: here we are recovering the system with the backup: /hdb/ZTT/backup/data/ZTT-20141029-092054

Try it out πŸ™‚

If you want to install HANA server in just one go, execute the command as root mentioned below:

./hdbinst –sid= –number=XX –hostname=vadbsid –datapath=/hdb/SID/data –logpath=/hdb/SID/log









SID= System Identification Eg: ZBB

XX= Instance ID ( 00 to 99)

Enjoy πŸ™‚

Write blue text on Facebook.

Now you can write a text in blue color on Facebook πŸ™‚ πŸ™‚

Just write this :


@@[0:[250399841743524:1: your text]]



Type anything at β€˜Your Text’ and troll people by making it Blue πŸ™‚ πŸ™‚

Here we have very efficient way by which you can remove Linux Partition from your Dual Boot XP/Vista/7.

Follow the simple steps:

1. Download easyBCD

2. Install it

3. Open it

4. Go to BCD Deployment

5. Select the MBR of XP/Vista/7 you installed as Dual Boot

6. Click on Write MBR

7. Restart it, there won’t be any Grub Menu for choosing the OS.

8. Start the computer with the OS with XP/Vista/7

9. Right click on icon of My computer

10.Click on Manage

11.Go to Disk Management 12.Delete the Linux Partition and Merge it with the existed windows partition
Its Done.