Friday, June 17, 2011

Mass rename script in Unix (HP-UX)

(#!/bin/ksh) - remove the brackets in real scenario

cd /oracle/GE1/saparch
for file in *arch*; do

newfile=`echo $file | sed 's/ZE1/GE1/'`
mv $file $newfile

done

Mass copy script in HP-UX Unix

(#! /bin/ksh) - remove brackets in real scenario

cd /usr/sap/ZE1/EXT/M100/D2DWHP/out/MDT

for file in *ZORDERHIS*;do

mv $file /usr/sap/trans_rep/IBM_Transfer/DE0198_interface_files_MM

echo $file 'moved'

done

How to change some character in mass in vi editor

:%s/^M//g

In above example %s means search for character ^M and replace it with nothing / g for globally

Or if you need to change the same with some other character say ^M with ^S then

:%s/^M/^S/g

Sunday, June 12, 2011

Remedy query to find out last resolved requests

Log on to the Remedy tool, Choose resolved in the category after giving till Solution Manager in Assignee :


click on Advance and fill in the below query

'Last Resolved Date ' >= "22/05/2011 00:00:00" AND 'Last Name*+' != "HP_OVO_Ratingen"

Here you may give in any date from that date onwards all the Resolved Incidents in Solution Manager group excluding the Alerts ('Last Name*+' != "HP_OVO_Ratinge")

NWDI Change Management Service - Transports

This one is related to Track management. You may import / Assemble SCs (containing many DCs) in your track.

First thing to log on to the NWDI CMS

http://avggstah.dc-ratingen.de:51000/devinf/main

then choose the Change Management Service

Choose the track that you may want to do the changes and import / Assemble as per requirement

Thursday, June 2, 2011

Parallel processes for Client Copy

Option for selecting the number of Parallel Process for Client Copy is available in SCC9, you may go to manu option Goto ---) Parallel Processes.

Here you will get options :

Maximum Number of Processes : 35

Logon/Server Group : parallel_generators

Wednesday, June 1, 2011

Command to Rebuild Indexes

We used the following command to rebuild the indexes in ZE1 System :

brspace -f idrebuild -i (index_list)

For eg :

brspace -f idrebuild -i /COCKPIT/THDRV~DEL

behind the scenes, it is using the below sql command :

sql) alter index "SAPEVO", "/COCKPIT/THDRV~DEL" rebuild online;

in generic terms

alter index "(schemaname)", "(indexname)" rebuild online;