./deployer.sh -t resourcejar
./buildwar.sh -Dappserver=websphere -Dwarfiles=smcfs -Dnowebservice=true -Dnodocear=true -Ddevmode=true
./buildear.sh -Dappserver=websphere -Dwarfiles=smcfs -Dearfile=smcfs.ear -Dnowebservice=true -Dnodocear=true -Ddevmode=true create-ear
C:\IBM\software\installers\SSFS91
C:/Programs/Java/jdk1.6.0_45/bin/java -Djavataskargs="-XX:MaxPermSize=512m" -Dcomptaskargs="-J-Xms1024m -J-Xms1408m" -jar SCIInstallWizard.jar
db2admin
SCDB91
50000
C:\Programs\IBM\SQLLIB\java\db2jcc.jar
C:\Programs\IBM\SQLLIB\java\db2jcc_license_cu.jar
./dbverify.sh
./sci_ant.sh -Dtable=EXTN_YFS_ALLOCATION_RULES -f templateXmlGen.xml
./InstallService.sh /opt/tmp/smcfs_91_FP50.jar
ADDITIONAL_ANT_JAVA_TASK_ARGS=-Xms1024m -Xmx1408m -XX:MaxPermSize=512m
ADDITIONAL_ANT_COMPILER_TASK_ARGS=-J-Xms256m -J-Xmx1408m
ARGS=-J-Xms256m -J-Xmx1408m
ARGS=-Xms512m -Xmx1024m -XX:MaxPermSize=256m
/opt/ibm/WebSphere/AppServer/java/bin/java -jar SMCFS_9.1.jar -f silent.txt
java -Djavataskargs="-Xms1024m -Xmx1408m -XX:MaxPermSize=512m" -Dcomptaskargs="-J-Xms256m -J-Xmx1408m" -jar SCIInstallWizard.jar
chmod -R 777 /opt/sterling/Foundation/*
./sci_ant.sh -f localizedstringreconciler.xml import -Dsrc=/opt/sterling/Foundation/repository/factorysetup/complete_installation/XMLS/ -Dbasefilename=localization0414
C:\Program Files (x86)\IBM\cognos\c10\bin
regsvr32 LFA.dll
isLocalized="Y"
sci_ant.cmd -f localizedstringreconciler.xml import -Dsrc=C:\Sterling\Foundation\repository\factorysetup\complete_installation\XMLS -Dbasefilename=ycplocalizedstrings
create database SCDB1 using codeset UTF-8 territory us PAGESIZE 32768
grant dbadm on database to user db2admin
connect to SCTSTMP user db2admin using db2admin
CREATE BUFFERPOOL BUFFERPOOL8 SIZE 1000 PAGESIZE 32k
CREATE TABLESPACE USERSPACE8 PAGESIZE 8K MANAGED BY DATABASE USING (FILE 'C:\DB2\NODE0000\SQL00006\TS8.TS' 10000) BUFFERPOOL BUFFERPOOL8
CREATE BUFFERPOOL BUFFERPOOL16 SIZE 1000 PAGESIZE 32k
CREATE TABLESPACE USERSPACE16 PAGESIZE 32k MANAGED BY DATABASE USING (FILE 'C:\DB2\NODE0000\SQL00006\TS16.TS' 10000) BUFFERPOOL BUFFERPOOL16
CREATE USER TEMPORARY TABLESPACE usertmp00 MANAGED BY DATABASE using (FILE 'C:\DB2\NODE0000\SQL00006\USRTMP.TS' 100000)
CREATE SYSTEM TEMPORARY TABLESPACE tmp_tbsp00 MANAGED BY SYSTEM using ( 'C:\DB2\NODE0000\SQL00006\SYSTMP.TS')
CREATE SYSTEM TEMPORARY TABLESPACE tmp_tbsp8 PAGESIZE 32k MANAGED BY SYSTEM using ( 'C:\DB2\NODE0000\SQL00006\SYSTMP8.TS') BUFFERPOOL BUFFERPOOL8
CREATE SYSTEM TEMPORARY TABLESPACE tmp_tbsp16 PAGESIZE 32k MANAGED BY SYSTEM using ( 'C:\DB2\NODE0000\SQL00006\SYSTMP16.TS') BUFFERPOOL BUFFERPOOL16
disconnect current
quit
set current schema DB2ADMIN
db2look -d SCTSDB -a -e -x -o SCTSDB.SQL
db2move SCTSDB COPY -sn db2admin -co TARGET_DB SCTSTMP user db2admin using db2admin
cd C:\DB2\TMPBACK
connect to SCTSDB user db2admin using db2admin
db2move SCDB1 EXPORT -u db2admin -p db2admin -aw
db2look -d SCDB1 -z DB2ADMIN -i db2admin -w db2admin -e -o SCDB1.dll -l -x -f
db2 BACKUP DATABASE SCDB1 USER db2admin USING db2admin TO /home/db2inst1/dev
create database SCDB1 using codeset UTF-8 territory us PAGESIZE 32768
db2 drop database SCDB1
connect to SCDB1 user db2admin using db2admin
db2 -tvf uniSCTSDB.dll
db2 -tvf C:\EXPORT.out
db2move SCDB1 IMPORT -u db2admin -p db2admin
get db cfg for SCTSDB
restore db SCTSDB from 'C:\DBBackup0726' taken at 20130727153837 into SCTSTMP replace existing
db2move SCDB1 IMPORT -u db2admin -p db2admin
./InstallService.sh /opt/sterling/smcfs_91_FP50.jar
install3rdParty.cmd websphere 7 -j C:/Sterling/Foundation\jar\websphere\7\ABC.jar -targetJVM EVERY -uninstall
export to /home/db2inst1/deploy/yfs_resource_permission.ixf of ixf messages /home/db2inst1/deploy/msgs.txt select * from yfs_resource_permission where resource_key in (select resource_key from yfs_resource where resource_id in ('AAAA', 'BBBBB')) and USERGROUP_KEY='SYSTEM'
export to /home/db2inst1/deploy/yfs_resource.ixf of ixf messages /home/db2inst1/deploy/msgs.txt select * from yfs_resource where resource_id in ('AAAAA', 'BBBBB')
export to /home/db2inst1/deploy/yfs_menu.ixf of ixf messages /home/db2inst1/deploy/msgs.txt select * from yfs_menu where menu_key in ('2013121215394516279', '2013121316272418706')
export to /home/db2inst1/deploy/yfs_flow.ixf of ixf messages /home/db2inst1/deploy/msgs.txt select * from yfs_flow where system_Defined ='N' and createuserid !='SYSTEM' and graph_ui_key != 'AgentGraphUI' and flow_group_name in ('NewGroup', 'NewGroup2')
export to /home/db2inst1/deploy/yfs_sub_flow.ixf of ixf messages /home/db2inst1/deploy/msgs.txt select * from yfs_sub_flow where flow_key in (select flow_key from yfs_flow where system_Defined ='N' and createuserid !='SYSTEM' and graph_ui_key != 'AgentGraphUI' and flow_group_name in ('NewGroup', 'NewGroup2'))
export to /home/db2inst1/deploy/yfs_graph_ui.ixf of ixf messages /home/db2inst1/deploy/msgs.txt select * from yfs_graph_ui where graph_ui_key in (select graph_ui_key from yfs_flow where system_Defined ='N' and createuserid !='SYSTEM' and graph_ui_key != 'AgentGraphUI' and flow_group_name in ('NewGroup', 'NewGroup2'))
export to /home/db2inst1/deploy/yfs_common_code.ixf of ixf messages /home/db2inst1/deploy/msgs.txt select * from YFS_COMMON_CODE where CODE_TYPE in ('PROCESSREPORT', 'PRINTTYPE')
export to /home/db2inst1/deploy/yfs_base_common_code.ixf of ixf messages /home/db2inst1/deploy/msgs.txt select * from YFS_BASE_COMMON_CODE where CODE_TYPE in ('PROCESSREPORT', 'PRINTTYPE')
import from /home/db2inst1/deploy/yfs_flow.ixf of ixf insert into yfs_flow
import from /home/db2inst1/deploy/yfs_sub_flow.ixf of ixf insert into yfs_sub_flow
import from /home/db2inst1/deploy/yfs_graph_ui.ixf of ixf insert into yfs_graph_ui
import from /home/db2inst1/deploy/yfs_resource_permission.ixf of ixf insert into yfs_resource_permission
import from /home/db2inst1/deploy/yfs_resource.ixf of ixf insert into yfs_resource
import from /home/db2inst1/deploy/yfs_menu.ixf of ixf insert into yfs_menu
import from /home/db2inst1/deploy/yfs_condition.ixf of ixf insert into yfs_condition
import from /home/db2inst1/deploy/yfs_common_code.ixf of ixf insert into yfs_common_code
import from /home/db2inst1/deploy/yfs_base_common_code.ixf of ixf insert into yfs_base_common_code