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);

No comments:

Post a Comment