Hide

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again.

Delete that bloated snippets file you've been using and share your personal repository with the world. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

If you have a new feature suggestion or find a bug, please get in touch via http://commandlinefu.uservoice.com/

Get involved!

You can sign-in using OpenID credentials, or register a traditional username and password.

OpenID

First-time OpenID users will be automatically assigned a username which can be changed after signing in.

Hide

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)
» commands by kaushalmehra

Hide

News

2011-03-12 - Confoo 2011 presentation: Slides are available from the commandlinefu presentation at Confoo 2011: http://presentations.codeinthehole.com/confoo2011/
2011-01-04 - Moderation now required for new commands: To try and put and end to the spamming, new commands require moderation before they will appear on the site.
2010-12-27 - Apologies for not banning the trolls sooner: Have been away from the interwebs over Christmas. Will be more vigilant henceforth.
2010-09-24 - OAuth and pagination problems fixed: Apologies for the delay in getting Twitter's OAuth supported. Annoying pagination gremlin also fixed.

Hide

Functions

Hide

Credits

Site by David Winterbottom (user root).

Commands by kaushalmehra

Terminal - Commands by kaushalmehra - 8 results

i=0; while [ $i -lt 100 ]; do echo "test, ttest, tttest-${i}" >> kk.file; i=`expr $i + 1`; done

2012-09-13 21:46:18

User: kaushalmehra

Functions: echo

Tags: unix while loop for loop

-3

Up
Down

Generate a test csv file using looping in AIX

while commandt

command

...

done

{commandt is executed and its exit status tested.}

for i in 1 2 3

> do

> echo $i

> done

cp foo.txt foo.txt.tmp; sed '$ d' foo.txt.tmp > foo.txt; rm -f foo.txt.tmp

2012-09-13 20:57:40

User: kaushalmehra

Functions: cp rm sed

Tags: sed unix

-2

Up
Down

Deleting / Ignoring tailer record from the file

sed '$ d' foo.txt.tmp

...deletes last line from the file

Comments (2) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate

tail -n +2 foo.txt

2012-09-13 20:54:36

User: kaushalmehra

Functions: tail

Tags: unix

Up
Down

Deleting / Ignoring lines from the top of a file

Output lines starting at line 2.

Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate

lspv hdisk1

2012-09-13 15:40:58

User: kaushalmehra

Tags: hard disk unix

Up
Down

List information about a specific physical volume (eg-hdisk1)

This physical volumne - hdisk1 - has TOTAL PPs:11999 (1535872 megabytes) -> 1.5 TB

This physical volumne - hdisk1 - has -> 60 GB

lspv

2012-09-13 15:20:06

User: kaushalmehra

Tags: hard disk

-3

Up
Down

To display the number of hard disks on your system

The lspv command displays the information about the physical volume if the specific

physical volume name is specified. If you do not add flags to the lspv command, by default

all the available physical volumes are printed along with the following information:

* Physical disk name.

* Physical volume identifiers (PVIDs).

* The volume group, if any, that the physical volume belongs to or the label,if any,

locked with the lkdev command.

* The state of the volume group.

Active-When the volume group is varied on.

Concurrent-When the volume group is varied on in the concurrent mode.

Locked-When the physical volume is locked with the lkdev command.

****************************************************************************************

In the example, the iw406 system has two hard disks.

Phy disk name Phy vol identfrs (PVIDs) volume group State of Volumne group

hdisk0 00f6267c8a99c7b6 rootvg active

hdisk1 00f6267cb3746d01 appinstvg active

hdisk0 is mounted on volume group rootvg. hdisk1 is mounted on volume group appinstvg

db2 connect to STGNSY3; db2 -tvf source_CUST_DIM_DELTA.sql > kk.out

2012-07-09 21:28:58

User: kaushalmehra

Tags: DB2

Up
Down

Execute multiple SQL commands from a File

Comments (0) | Add to favourites | Report as malicious | Submit alternative | Report as a duplicate

db2 CONNECT TO stgndv2; db2 'load from /dev/null of del replace into STMOT.ST_MORT_ARRG_DELTA nonrecoverable'

2012-06-07 19:45:57

User: kaushalmehra

Tags: DB2

Up
Down

DB2 Load command instead of truncate or delete command, to get rid of table rows

db2 CONNECT TO stgndv2; db2 'load from /dev/null of del replace into STMOT.ST_MORT_ARRG_DELTA nonrecoverable'

db2 CONNECT TO stgndv2 USER pmserver USING ********

2012-06-07 18:55:47

User: kaushalmehra

Tags: DB2

Up
Down

connects to db2 database instance/alias "stgndv2" user "pmserver" using password "xxxxxxx"

db2 => ? connect

CONNECT [USER username [{USING password

[NEW new-password CONFIRM confirm-password] |

CHANGE PASSWORD}]]

CONNECT RESET

CONNECT TO database-alias

[IN {SHARE MODE | EXCLUSIVE MODE [ON SINGLE DBPARTITIONNUM]}]

[USER username [{USING password

[NEW new-password CONFIRM confirm-password] |

CHANGE PASSWORD}]]