Showing posts with label Websphere MQ related data in IBM WCS DB. Show all posts
Showing posts with label Websphere MQ related data in IBM WCS DB. Show all posts

Thursday, April 30, 2015

Websphere MQ related data in IBM WCS DB

INSERT INTO profile (PROFILE_ID,STORE_ID,DEVICEFMT_ID,TRANSPORT_ID,MSGTYPE_ID,USERSVIEW,LOWPRIORITY,HIGHPRIORITY,ARCHIVEMSG,OPTCOUNTER) VALUES (36711,0,-4,3,3043,'N',0,0,0,28774);
INSERT INTO CSEDITATT (CSEDITATT_ID,TRANSPORT_ID,STORE_ID,PROFILE_ID,INSTANCE_NUM,CUSTOMIZABLE,CONNSPECATTNAME,CONNSPECATTVALUE,OPTCOUNTER) VALUES (41137,3,null,36711,-1,1,'factory','JMSQueueConnectionFactory',18769);
INSERT INTO CSEDITATT (CSEDITATT_ID,TRANSPORT_ID,STORE_ID,PROFILE_ID,INSTANCE_NUM,CUSTOMIZABLE,CONNSPECATTNAME,CONNSPECATTVALUE,OPTCOUNTER) VALUES (41138,3,null,36711,-1,1,'inQueue','JMSInboundQueue',4835);
INSERT INTO CSEDITATT (CSEDITATT_ID,TRANSPORT_ID,STORE_ID,PROFILE_ID,INSTANCE_NUM,CUSTOMIZABLE,CONNSPECATTNAME,CONNSPECATTVALUE,OPTCOUNTER) VALUES (41139,3,null,36711,-1,1,'errorQueue','JMSErrorQueue',16837);
INSERT INTO CSEDITATT (CSEDITATT_ID,TRANSPORT_ID,STORE_ID,PROFILE_ID,INSTANCE_NUM,CUSTOMIZABLE,CONNSPECATTNAME,CONNSPECATTVALUE,OPTCOUNTER) VALUES (41140,3,null,36711,-1,1,'outQueue','JMSOutboundQueue',22071);
INSERT INTO ISEDITATT (ISEDITATT_ID,PROFILE_ID,CUSTOMIZABLE,INTERSPECATTNAME,INTERSPECATTVALUE,OPTCOUNTER) VALUES (51467,36711,1,'JMSExpiration','0',15030);
INSERT INTO ISEDITATT (ISEDITATT_ID,PROFILE_ID,CUSTOMIZABLE,INTERSPECATTNAME,INTERSPECATTVALUE,OPTCOUNTER) VALUES (51468,36711,1,'mode','0',29682);

INSERT INTO ISEDITATT (ISEDITATT_ID,PROFILE_ID,CUSTOMIZABLE,INTERSPECATTNAME,INTERSPECATTVALUE,OPTCOUNTER) VALUES (51469,36711,1,'timeOut','60',15649);