How to downgrade a OBI RPD Version ?

....\bifoundation\server\bin>nqgenoldverrpd.exe -P <repository-password> -I <source-rpd-location> -O <target-rpd-location> -V <target-version-number>

Example:

....\bifoundation\server\bin>nqgenoldverrpd.exe -P admin123 -I C;\MySource.rpd -O C:\MyTarget.rpd -V 318

How to start stop an Business Works Archive archive using AppManage (console) ?

To Start

./AppManage -stop -app <Archive-name> -user <usename> -pw <password> -domain <domain-name>

To Stop

./AppManage -start -app <Archive-name> -user <usename> -pw <password> -domain <domain-name>

How to find the space occupied by indexes of a table in oracle ?

 SELECT idx.index_name, (SUM(bytes)/(1024*1024)) SIZE_IN_MB
  FROM user_segments seg, user_indexes idx
 WHERE idx.table_name = <my_table_name>
   AND idx.index_name = seg.segment_name
 GROUP BY idx.index_name;

How to install Tibco i-Process Palattes on Business Works?

You need to have the following installers with you

TIB_ipTechpi8402_11.2.0_w32.zip
TIB_ipTechpi9151_11.3.0_w32.zip

Step 1. 
Unzip TIB_ipTechpi8402_11.2.0_w32.zip
Go to : TIB_ipTechpi8402_11.2.0_w32\auxinstallers\windows32
you should find a installer named.,

TIB_bwpluginiprocess-simple_2.1.9_win_x86.exe

Install this.


Step 2. 
Unzip TIB_ipTechpi9151_11.3.0_w32.zip
Go to : TIB_ipTechpi9151_11.3.0_w32\2239 #9151 iProcess Technology Plug-ins 11.3.0 Win Sql RC2\auxinstallers\windows32

you should find a installer named.,

TIB_bwpluginiprocess-simple_2.1.10_win_x86.exe

Install this.



Step 3:

Open your designer, now you should be able to see your iProcess related palattes in your Designer.

Configuring IAP JMS

Summary of steps:

################################################################################ ################################
STEP 1   [Switch on IAP JMS on iProcess Server]
################################################################################ ################################
execute this command in iprocess engine:

%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 IAPJMS_SYNCHRONOUS 1
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 WQDJMS_TOPICNAME WQDTOPIC
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 IAPJMS_PORTNO 9071
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 WQDJMS_PORTNO 9075
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 IAPJMS_SIMPLETOPIC 1
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 IAPJMS_TOPICNAME IAPTOPIC
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 WQDJMS_TOPICNAME WQDTOPIC
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 IAPJMS_ROLLBACK 1
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 JVMPROPS
%SWDIR%\util\swadm.exe set_attribute 0 ALL 0 IAPJMS_PUBLISH 1

################################################################################ ################################
STEP 2   [Configure your JMS Details in iProcess]
################################################################################ ###############################

if your TIBCO EMS installation is 5.1 is not necessary modify this properties files (This  was my error, described in the previous post): 

-%$SWDIR%\etc\iapjms_classpath.properties
-%$SWDIR%\etc\iapjms.properties

################################################################################ ################################
Step 3 [Create a Topic in your JMS]
################################################################################ ###############################
execute in console (CMD)--->C:\tibco\ems\6.0\bin>tibemsadmin.exe

TIBCO Enterprise Message Service Administration Tool.
Copyright 2003-2009 by TIBCO Software Inc.
All rights reserved.
Version 5.1.0 V10 2/4/2009

Type 'help' for commands help, 'exit' to exit:
> connect
Login name (admin): admin
Password:

tcp://localhost:7222> create topic IAPTOPIC
Topic 'IAPTOPIC' has been created

################################################################################ ################################
STEP 4 [Export your IAP JMS Configuration]
################################################################################ ################################

$SWDIR/bin/swutil/IMPMONITOR   #{Your-Mer-xmlFile}

Simple for / while loop in shell

#!/bin/sh a=0
while [ $a -lt 10 ]
do
echo $a
a=`expr $a + 1`
done

Tibco client Installation order

Tibco Suite

All default – Simple – Next-Next-Next Installation

1.      TRA

                                I.            TIB_tra_5.7.0_win_x86_64.zip

                              II.            TIB_tra_5.7.1_win_x86_64.zip

2.      Business Works

                                I.            TIB_bw_5.9.0_win_x86_64.zip

                              II.            TIB_ipTechpi8402_11.2.0_w32.zip

                            III.            TIB_ipTechpi9151_11.3.0_w32.zip

3.      iProcess Modeller

                                I.            TIB_ipWkspWin8994_11.1.3_w32.zip

                              II.            TIB_ipWksppi8413_11.2.0_w32.zip

                            III.            TIB_ipWksppi9154_11.3.0_w32.zip

How to execute a SQL in Shell Script

#!/bin/bash
echo "STARTED..."
echo "Connecting to SQLPLUS"
sqlplus -L -s alf_ar/alf_ar@intdev <<EOF
prompt Connected to alf_ar@intdev
set serveroutput on size 100000
set head off
set feedback off
prompt executing the sql statement: $1
$1
exit;
EOF
echo "END..."

Save the above content as "runsql.sh"

then execute the following command

nohup sh runsql.sh "select 1 from dual;" > out.txt &

How to search a file/folder in unix ?

 find . -name "bptm.jar" 2>/dev/null



2>/dev/null denotes standard errors not being shown in console

Show all arguments of a Process in Unix

ps -eaf | grep bwengine | awk '{print $2}' | pargs awk '{print $1}'


for f in `ps -eaf | grep bwengine | awk '{print $2}'`; do
  echo `pargs $f`
done

------this will grep but will not give process_id as its not in same line-------------
for f in `ps -eaf | grep bwengine | awk '{print $2}'`; do
  echo `pargs $f | grep '21CN'`
done

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

or

/usr/ucb/ps -auwwx|grep WFMT-NIMS-Process_Archive.tra

How to copy (Merge and Overwrite in destination) a folder from one Unix box to another ?

1. Log in to the Target box
2. Execute the following command

scp -rp <SOURCE_IP>:<SOURCE_FOLDER>/* <DESTINATION_FOLDER>

Example : scp -rp 10.75.105.166:/wfmtsw/vinoth/* /wfmtsw/vinoth