running any linux script in background

nohup ./abc.sh > abc.out

Restart a linux server

Steps:-
----------------------------------------------

1. Login as root user

sudo su -

enter password of root user

2. set the path of jonas base

export JONAS_BASE=/export/home/jonas/user_projects/domains/ALCBASE

3. to stop jonas

jonas stop

4. to start jonas

jonas start -clean -n ALCBASE

-----------------------------------------

To find java Process:-
------------------------------

ps -ef | grep java

Killing a process

-------------------------

kill -9 pid

Find Jonas base path

-----------------------

echo $JONAS_BASE

Set Jonas base path
--------------------------------- 

/export/home/jonas/user_projects/domains/ALCBASE

Gzip and ungzip

gziping any file
>gzip <full file name>
un zipping gz file
>gzip -d <full file name.gz>

FTP any file

ftp <IP>
username
pswrd
bi
ha
prompt
cd /u07
get/put

deleting duplicate rows(SQL-oracle)

DELETE FROM
   table_name A
WHERE
  a.rowid >
   ANY (
     SELECT
        B.rowid
     FROM
        table_name B
     WHERE
        A.col1 = B.col1
     AND
        A.col2 = B.col2
        );

CopyReqId(ColdFusion)

<cffunction name="CopyReqId" output="false" returnType="string">
               <cfargument name="list1" type="string" required="true" />
                <cfset var list1Array = ListToArray(arguments.List1) />
               <!--- Return in list format --->
               <cfreturn ArrayToList(list1Array) />
           </cffunction>

Creating List of matched item from one list and Master list(Cold Fusion)

<cffunction name="matchedReqId" output="false" returnType="string">
               <cfargument name="list1" type="string" required="true" />
               <cfargument name="list2" type="string" required="true" />
   
                <cfset var list1Array = ListToArray(arguments.List1) />
               <cfset var list2Array = ListToArray(arguments.List2) />
   
                <cfset list1Array.retainAll(list2Array) />
   
               <!--- Return in list format --->
               <cfreturn ArrayToList(list1Array) />
           </cffunction>