Linux Commands

-



cp -R SRCFOLDER DESTFOLDER/  --copy folder

Cp file destination  -- copy a file

#Remove lines with containing specific text

sed -i '/pattern to match/d' ./infile


#renaming the file

Mv oldfilename newfilename


# send email

echo 'Body of mail .' | mailx -s 'subject of mail ' -a  /pathtotheattachment   mailid

du -hs *|sort -h  --> size in sorting order


tar -zcvf consumer.gz   /home/kolguk01/consumer  -- Gunzip folder
Rm -rf   --- remove folder


Check IP address of Linux server
/sbin/ifconfig

Remove files  older than 14 days

/usr/bin/find  /home/kolguk01/rpcache/mongo*.txt  -mtime  +14  -type f -exec rm {} \;


Replace a string

:%s/pattern/replace/
/g for all at once


Convert Windows text file to Unix file

--we do it by removing the character "\r"
Od -c filename | head -- to check if it has windows characters
cat cfit_ucc_account_full.txt | tr -d '\r' > cfit_ucc_account_new.txt

Remove whitespaces in vi

:%s/\s\+$//e

Sort Results in a table

cat BISNZDWP_0329_grm.rpt | sort -n -k 5 | tail  -20

Deleting Files

find /the/dir/to/start/in -type f -mtime +365 -ls -exec rm -f -- {} \;

Delete directories older than 30 days

find /buvol2/BISPRDDB/Netezza/NZ31652-H1/EDWP^C  -type d -ctime +30  -exec rm -rf -- {} \;

Transfer files through SCP

scp -r iomysql@dfwlnpmysql-02:/u04/mysdata/3309 /u04/mysdata/3309

Grep Multiple words

grep  '151.138.12.251\|151.138.12.252\|151.138.12.24\|151.138.12.27' /var/log/mongodb/mongod.log | grep "connection accepted" | wc -l

Comments

Post a Comment

Popular posts from this blog

Netezza Commands

-
Table Size  select tablename, used_bytes/pow(1024,4) as used_TB   from _v_table_storage_stat  where tablename  in (  select tablename from _v_table where tablename not like  '_VT_%' and tablename not like '_T_%'); Objects owned by a user: select o.objname, d.database, oc.classname, u.usename from _t_object o, _t_user u, _t_object_classes oc, _v_database d where u.usename='username' and u.usesysid=o.objowner and o.objclass=oc.objclass and o.objdb=d.objid; Tip: Use NZ_HELP to get   syntax of all commands Like -    nz_help | grep grant [nz@dfw86inzb-04 ~]$ nz_help | grep grant nz_db_group_access_listing           To show what groups have been granted access to what databases. nz_db_user_access_listing            To show what users have been granted access to what databases. nz_ddl_grant_group    ...
Read more

MS SQL Server Tips

-
Image
Unable to Shrink the DataFile If you are unable to shrink the datafile then try the following Error :  File ID 3 of database ID 8 cannot be shrunk as it is either being shrunk by another process or is empty. DBCC execution completed. If DBCC printed error messages, contact your system administrator. Solution:   Add at least 2-3 MB to the data file and start shrinking again. Index Fragmentation Level SELECT distinct dbschemas.[name] as 'Schema', dbtables.[name] as 'Table',  dbindexes.[name] as 'Index', indexstats.avg_fragmentation_in_percent, indexstats.page_count, i.rowcnt as 'totalrows' FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS indexstats INNER JOIN sys.tables dbtables on dbtables.[object_id] = indexstats.[object_id] INNER JOIN sys.schemas dbschemas on dbtables.[schema_id] = dbschemas.[schema_id] INNER JOIN sys.indexes AS dbindexes ON dbindexes.[object_id] = indexstats....
Read more
-
Maintenacne Plan creation USE [msdb] GO DECLARE @sqlInstance varchar(20) SET @sqlInstance = '$(instanceName)' DECLARE @BackUpSubPlan sysname SET @BackUpSubPlan = 'Back Up Database Task' DECLARE @BackUpJobName sysname SET @BackUpJobName = 'System databases.' + @BackUpSubPlan DECLARE @ChkDbSubPlan sysname SET @ChkDbSubPlan = 'Check Database Integrity Task' DECLARE @ChkDbJobName sysname SET @ChkDbJobName = 'System databases.' + @ChkDbSubPlan DECLARE @RebuildIndexSubPlan sysname SET @RebuildIndexSubPlan = 'Rebuild Index Task' DECLARE @RebuildIndexJobName sysname SET @RebuildIndexJobName = 'System databases.' + @RebuildIndexSubPlan DECLARE @UpdStatsSubPlan sysname SET @UpdStatsSubPlan = 'Update Statistics Task' DECLARE @UpdStatsJobName sysname SET @UpdStatsJobName = 'System databases.' + @UpdStatsSubPlan DECLARE @HistClnSubPlan sysname SET @HistClnSubPlan = 'History Cleanup Task' ...
Read more