2008/5/29

ICS for linux 安裝手順

ICS
等以後有空,再來重新排版吧
rpm -ivh IBMJava2-142-ia32-SDK-1.4.2-10.0.i386.rpm
export JAVA_HOME=/opt/IBMJava2-142
exprot CLASSPATH=/JAVA_HOME/lib:$JAVA_HOME/jre/lib:$JAVA_HOME/lib/tools.jar
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH
export EXTSHM=ON
DB2
//新增使用者icsadmin 群組:mqm
//解開DB2
cd 009_ESE_LNX_32_NLV/
export LIBXCB_ALLOW_SLOPPY_LOCK=1
//----------installing--------
Su – db2inst1
db2set DB2ENVLIST=EXTSHM
db2set DB2_EXTENDED_OPTIMIZATION=ON
db2set DB2_DISABLE_FLUSH_LOG=ON
db2set AUTOSTART=YES
db2set DB2_STRIPED_CONTAINERS=ON
db2set DB2_HASH_JOIN=Y
db2set DB2COMM=tcpip
db2set DB2_PARALLEL_IO=*
db2set db2codepage = 1208
//#Update dbm cfg
db2 update dbm cfg using SVCENAME db2inst1
db2 update dbm cfg using INDEXREC ACCESS
db2start
----------建立icsrepos DB-----------
DB2 Control Center-->db2inst1-->配置參數-->應用程式-->maxagents>50
DB2 Control Center-->icsrepos-->配置參數-->配置資料庫-->效能-->applheapsz=4096
DB2 Control Center-->icsrepos-->配置參數-->配置資料庫-->應用程式-->maxappls=50
----------建立icsrepos DB-----------
db2
CONNECT TO ICSREPOS;
GRANT DBADM,CREATETAB,BINDADD,CONNECT, CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA, LOAD, CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT ON DATABASE TO USER ICSADMIN

//還要再研究
ICSSIT43:/home/db2inst1 #db2 catalog tcpip node icslog remote ICSSIT43 server icsdb2
ICSSIT43:/home/db2inst1 #db2 catalog database icsrepos as icsdb at node icslog
//還要再研究

db2set DB2_RR_TO_RS=yes





MQ
mkdir /var/mqm
useradd mqm -G mqm -d /var/mqm
./mqlicense.sh –accept

rpm -ivh MQSeriesRuntime-6.0.0-0.i386.rpm
rpm -ivh MQSeriesSDK-6.0.0-0.i386.rpm
rpm -ivh MQSeriesSamples-6.0.0-0.i386.rpm
rpm -ivh MQSeriesServer-6.0.0-0.i386.rpm
rpm -ivh MQSeriesClient-6.0.0-0.i386.rpm
rpm -ivh MQSeriesJava-6.0.0-0.i386.rpm
cd 6.0.2.1/
rpm -Uvh MQSeriesRuntime-U808001-6.0.2-1.i386.rpm
rpm -Uvh MQSeriesSDK-U808001-6.0.2-1.i386.rpm
rpm -Uvh MQSeriesSamples-U808001-6.0.2-1.i386.rpm
rpm -Uvh MQSeriesServer-U808001-6.0.2-1.i386.rpm
rpm -Uvh MQSeriesClient-U808001-6.0.2-1.i386.rpm
rpm -Uvh MQSeriesJava-U808001-6.0.2-1.i386.rpm

//*
export LD_ASSUME_KERNEL=2.4.19
/source/MQ/CSD11 # cd /source/MQ
/source/MQ # cp ma0c_linux.tar /
/source/MQ # cd /
/ # tar vxf ma0c_linux.tar
/ # su -mqm
/ # dspmqcap
/ # setmqcap 1
*/

crtmqm ICSSIT43.queue.manager
cd /var/mqm/qmgrs/ICSSIT43\!queue\!manager/
vi qm.ini
LogPrimaryFiles=62
LogFilePages=2048
LogBufferPages=128
#Add
Channels:
MaxChannels=1000
MaxActiveChannels=1000
Broker:
SyncPointIfPersistent=yes
#(end)

//作法一:
strmqm ICSSIT43.queue.manager
nohup runmqlsr -t tcp -p 1415 -m ICSSIT43.queue.manager &
strmqbrk -m ICSSIT43.queue.manager
vi /var/mqm/conv/table/ccsid.tbl
default 0 500 1 1 0
default 0 850 1 2 0
(unmark #)
runmqsc ICSSIT43.queue.manager < MQJMS_PSQ.mqsc
//作法二:
看書吧

WebSphere MQ V5.3 加入MQ Explorer
一、 啟動MQ Qmgr
1. 以mqm telnet進WebSphere MQ Server
2. 輸入已下指令啟動QMGR
$ strmqm [QMGR Name]
Ex:$ strmqm bcg.queue.manager
3. 輸入已下指令啟動Command Server
$ strmqcsv [QMGR Name]
Ex:$ strmqcsv bcg.queue.manager

二、 登入MQ Command Server
1. 以mqm telnet進WebSphere MQ Server
2. 輸入已下指令登入MQ Command Mode
$ runmqsc [QMGR Name]
Ex:$ runmqsc bcg.queue.manager
3. 輸入已下指令新增MQ管理Channel
DEFINE CHANNEL(SYSTEM.ADMIN.SVRCONN) CHLTYPE(SVRCONN) MCAUSER(‘mqm’)
4. 輸入已下指令確認MQ之CCSID與MQ Explorer相同
DISPLAY QMGR

沒有留言:

JPA+complex key+custom Query

  來源: https://www.cnblogs.com/520playboy/p/6512592.html   整個來說,就是有複合主鍵 然後要使用  public interface XxXXxx DAO extends CrudRepository<Tc...