Commands by kaushalmehra (8)

  • while commandt do command command ... done {commandt is executed and its exit status tested.} for i in 1 2 3 > do > echo $i > done Show Sample Output


    -3
    i=0; while [ $i -lt 100 ]; do echo "test, ttest, tttest-${i}" >> kk.file; i=`expr $i + 1`; done
    kaushalmehra · 2012-09-13 21:46:18 2
  • sed '$ d' foo.txt.tmp ...deletes last line from the file


    -2
    cp foo.txt foo.txt.tmp; sed '$ d' foo.txt.tmp > foo.txt; rm -f foo.txt.tmp
    kaushalmehra · 2012-09-13 20:57:40 4
  • Output lines starting at line 2.


    3
    tail -n +2 foo.txt
    kaushalmehra · 2012-09-13 20:54:36 2
  • This physical volumne - hdisk1 - has TOTAL PPs:11999 (1535872 megabytes) -> 1.5 TB This physical volumne - hdisk1 - has -> 60 GB Show Sample Output


    0
    lspv hdisk1
    kaushalmehra · 2012-09-13 15:40:58 2
  • 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 Show Sample Output


    -3
    lspv
    kaushalmehra · 2012-09-13 15:20:06 2

  • 0
    db2 connect to STGNSY3; db2 -tvf source_CUST_DIM_DELTA.sql > kk.out
    kaushalmehra · 2012-07-09 21:28:58 2
  • db2 CONNECT TO stgndv2; db2 'load from /dev/null of del replace into STMOT.ST_MORT_ARRG_DELTA nonrecoverable' Show Sample Output


    0
    db2 CONNECT TO stgndv2; db2 'load from /dev/null of del replace into STMOT.ST_MORT_ARRG_DELTA nonrecoverable'
    kaushalmehra · 2012-06-07 19:45:57 2
  • 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}]] Show Sample Output


    1
    db2 CONNECT TO stgndv2 USER pmserver USING ********
    kaushalmehra · 2012-06-07 18:55:47 3

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. 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.

Share Your Commands


Check These Out

check open ports without netstat or lsof

Convert a videos audio track to ogg vorbis.
Assumes you have ffmpeg and oggenc. Similar to other scripts here, but this time outputting to Ogg Vorbis. I added the variable assignment for a nice output name. This is part of an interactive bash script I have with a few little multimedia tasks in it. http://www.dward.us/software/VSAK.sh

Monitoring file handles used by a particular process
-r : repeat mode

Rename all images in current directory to filename based on year, month, day and time based on exif information

How to extract 5000 records from each table in MySQL
How to extract data from one table: mysqldump --opt --where="true LIMIT 5000" dbinproduzione tabella > miodbditest_tabella.sql

Convert CSV to JSON
Replace 'csv_file.csv' with your filename.

prettier "cal" command
Displays the same output as "cal", but with the current day highlighted (probably dependent on gnu grep, as I'm not sure other grep's support the "--color=auto" option). Tested and working on Ubuntu 11 and OSX Lion.

Get the Volume labels all bitlocker volumes had before being encrypted
Get information of volume labels of bitlocker volumes, even if they are encrypted and locked (no access to filesystem, no password provided). Note that the volume labels can have spaces, but only if you name then before encryption. Renaming a bitlocker partition after being encrypted does not have the same effect as doing it before.

Perform sed substitution on all but the last line of input
In this simple example the command will add a comma to the end of every line except the last. I found this really useful when programatically constructing sql scripts. See sample output for example.

Show the command line of a process that use a specific port (ubuntu)


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: