This Blog is all about ETL related Information.It gives information about Datastage ,Informatica,Oracle,SQL,PL/SQL ,Unix,Data warehousing ,Data Modeling and ER Model concepts and FAQ's
Monday
Unix commands(f-n)
The unix commands from f-p:
===========================
file filename1 : Determines and displays type of file for filename1 (text, data, executable, directory,
symbolic link...etc...)
find /usr/opt/bin -name "filename1*" -print : Starts
searching in /usr/opt/bin for files starting with
filename1, If found prints the full file names and
continues searching subdirectories
find . -type f -print | xargs grep -i [PATTERN] :
Recursive grep for a pattern in a file (searches through
files in subdirectories)
find . ! -mtime - | /usr/bin/xargs rm -rf :
Finds and removes files older than specified
finger sam : Displays data about user session for sam
ftp solar : Establishes a File Transfer Protocol session
over the network between current host and a host
named solar; See man pages for additional ftp
commands
grep jdoe /etc/passwd : Searches the file /etc/passwd
searching for string "jdoe"; If found, displays
grep -i Sam filename1: Search filename1 for upper
or lower case string of Sam and display lines found
groups sam : List groups that sam is a member of
head filename1 : Display first few lines of filename1
head -50 filename1: Display first fifty lines of
filename1
id : List current user id and any group ids
kill -9 1351 : Terminate process number 1351
ksh: Start Korn Shell command interpreter; See man
pages; Preferred shell for most users
ln -s filename1 /usr/opt/filename2 : Create a
symbolic link named /usr/opt/filename2 that points to
filename1; See man pages
lp -d lp1 filename1 : Print filename1 on destination
printer lp1
lpstat -d : Displays name of default printer, if any
lpstat -a : Lists printers accepting print requests
lpstat -s : Displays most everything regarding printing
lpstat -u sam : Displays status of sam's print jobs
ls -al : Displays all files in wide listing
ls -al *.doc : Displays files ending with .doc
ls -al /bin/k*: Displays files starting with k in /bin
directory
mail sam : Starts mail message to sam
mailx sam : Nicer looking mail utility
mkdir -p /usr/opt/dirx: Creates dirx below /usr/opt
make: Code compilation utility
mkdir dirx: Creates directory dirx
more filename1 : Displays single pages from
filename1 pausing after each page.for many options see man pages
mv filename1 /usr/opt/ : Moves filename1 to
directory /usr/opt; Unlike the cp (copy) command,
mv removes file from origin
netstat -i: Show the TCP/IP network interfaces
netstat -r: Show network route table
netstat -rn: Displays routing information but bypasses
hostname lookup
netstat -a | more : Show the state of all sockets
newgrp group1 : Changes current group to group 1
news : Displays unread files from /usr/news or
/var/news
nice/renice : Adjusts process’ execution priority