Saturday, May 24, 2014


PeopleSoft IB message transaction table names,

/* Formatted on 2014/04/30 09:41 (Formatter Plus v4.8.7) */
SELECT ibtransactionid, ib_segmentindex, ib_operationname, ibpubtransactid,
       actionname, pubnode, queuename, queueseqid, subqueue, trxtype,
       versionname, createdttm, publishtimestamp, actionowner, conversationid,
       inreplytoid, isrequest, routingdefnname, subconstatus, statusstring,
       lastupddttm, retrycount, machinename, slaveprocessname, ib_slavequeued,
       tuxdomain, processid
  FROM psapmsgsubcon

/* Formatted on 2014/04/30 09:42 (Formatter Plus v4.8.7) */
SELECT ibtransactionid, ib_segmentindex, subnode, ibpubtransactid,
       ib_sendpubid, pubnode, queuename, queueseqid, subqueue, createdttm,
       publishtimestamp, trxtype, ib_operationname, versionname,
       conversationid, canonicaltrsfrmid, inreplytoid, isrequest,
       routingdefnname, pubconstatus, statusstring, lastupddttm, retrycount,
       machinename, slaveprocessname, ib_slavequeued, tuxdomain, processid,
       nrid
  FROM psapmsgpubcon

No comments: