This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
final Iterator it = transactionService.iterator(); | |
while (it.hasNext()){ | |
final ObjectName tranObjectName = (ObjectName) it.next(); | |
if (null != tranObjectName){ | |
String signature[] = null; | |
Object params[] = null; | |
Object result = adminClient.invoke(tranObjectName, | |
"printableListOfTransactions", params, signature); | |
if (result != null){ | |
if (result instanceof String[]){ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
final Set transactionService = adminClient.queryNames(new ObjectName | |
("WebSphere:type=TransactionService,*"), null); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RegisteredRes E WTRN0062E: An illegal attempt to use multiple resources that have only one-phase capability has occurred within a global transaction. | |
FFDC Exception:com.ibm.ws.Transaction.IllegalResourceIn2PCTransactionException SourceId:com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource ProbeId:1858 Reporter:com.ibm.ws.tx.jta.TransactionImpl@82d082d | |
com.ibm.ws.Transaction.IllegalResourceIn2PCTransactionException: Illegal attempt to enlist multiple 1PC XAResources | |
at com.ibm.ws.tx.jta.RegisteredResources.enlistResource(RegisteredResources.java:864) | |
at com.ibm.ws.tx.jta.TransactionImpl.enlistResource(TransactionImpl.java:1788) | |
at com.ibm.ws.tx.jta.TranManagerSet.enlistOnePhase(TranManagerSet.java:615) | |
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:593) | |
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:2231) | |
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2519) | |
at com.ibm.ws.rsadapter.jdbc.WSJ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
db2 connect to MYDB | |
db2 -x "select tabname from syscat.tables where TABSCHEMA='MYSCHEMA' | |
and type='T'" > tableNames | |
while read TABLE; do | |
db2 EXPORT TO ./exported/$TABLE.del OF DEL lobs to ./exported/lobs | |
lobfile $TABLE xml to ./exported/xml xmlfile $TABLE | |
modified by lobsinsepfiles xmlinsepfiles MESSAGES ./exported/$TABLE.txt | |
"SELECT * FROM MYSCHEMA.$TABLE" | |
done < tableNames |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
byte[] msgContents = (byte[]) server.invoke(obj, "getMessageData", | |
new Object[] { msg.getId(), new Integer(0x19000) }, new String[] { | |
"java.lang.String", "java.lang.Integer" }); | |
StringBuffer sb = new StringBuffer(); | |
sb.append("Contents of Message ").append(msg.getId()).append(":\r\n\r\n"); | |
if (msgContents != null) { | |
int dataLength = msgContents.length; | |
sb.append("Data length = 0x").append( | |
Integer.toHexString(dataLength)).append(" (").append( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SIBQueuedMessageDetail sqmd = (SIBQueuedMessageDetail) server.invoke(obj, | |
"getQueuedMessageDetail", new Object[] { msg.getId() }, | |
new String[] { "java.lang.String" }); | |
System.out.println("BusDiscriminator:" + sqmd.getBusDiscriminator()); | |
System.out.println("BusPriority:" + sqmd.getBusPriority()); | |
System.out.println("BusReliability:" + sqmd.getBusReliability()); | |
System.out.println("BusTimeToLive:" + sqmd.getBusTimeToLive()); | |
System.out.println("BusReplyDiscriminator:"+ sqmd.getBusReplyDiscriminator()); | |
System.out.println("BusReplyPriority:" + sqmd.getBusReplyPriority()); | |
System.out.println("BusSystemMessageId:" + sqmd.getBusSystemMessageId()); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
for (int i = 0; i < msgs.length; i++) { | |
SIBQueuedMessage msg = (SIBQueuedMessage) msgs[i]; | |
System.out.println("id:" + msg.getId() + ", name:" | |
+ msg.getName() + ", state:" + msg.getState() | |
+ ", transactionID:" + msg.getTransactionId() | |
+ ", type:" + msg.getType()); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
if (null != depth && depth > 0) { | |
System.out.println("Queue Name:" + name | |
+ " has queue depth:" + depth); | |
SIBQueuedMessage[] msgs = (SIBQueuedMessage[]) server.invoke(obj, | |
"getQueuedMessages", null, null); | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
final Iterator it = queueNameSet.iterator(); | |
while (it.hasNext()) { | |
final ObjectName obj = (ObjectName) it.next(); | |
final String name = obj.getKeyProperty("name"); | |
AttributeList attribList = server.getAttributes(obj, | |
new String[] { "depth", "state", "id", | |
"highMessageThreshold", "sendAllowed" }); | |
Long depth = null; | |
String state = ""; | |
String id = ""; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
for (Iterator i = sibMesSet.iterator(); i.hasNext();) { | |
final ObjectName meObj = (ObjectName) i.next(); | |
final String meName = meObj.getKeyProperty("name"); | |
final ObjectName queuePoints = new ObjectName( | |
"WebSphere:type=SIBQueuePoint,SIBMessagingEngine=" | |
+ meName + ",*"); | |
final Set queueNameSet = server.queryNames(queuePoints,null); |
NewerOlder