IBM Sterling B2B: Queries for Archive

Verificar também o artigo IBM Sterling B2B: Archive e Purge

= Archive Info=

=Queries=

Calcula os registros para archive conforme o ARCHIVE_FLAG

SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG

result:

SELECT ARCHIVE_FLAG,GROUP_ID,MIN(ARCHIVE_DATE),MAX(ARCHIVE_DATE) FROM ARCHIVE_INFO where ARCHIVE_FLAG >=0 GROUP BY ARCHIVE_FLAG, GROUP_ID

result:

Messages on Mailboxes by Year
select to_char(mm.CREATED_DATETIME, 'YYYY') as YEAR1, count(1) as CONT from MBX_MESSAGE mm group by to_char(mm.CREATED_DATETIME, 'YYYY') order by to_char(mm.CREATED_DATETIME, 'YYYY')

result:

Messages on Mailboxes by Year and Extractable Count
select to_char(mm.CREATED_DATETIME, 'YYYY') as YEAR1, mec.EXTRACTABLE_COUNT, count(1) as CONT from MBX_MESSAGE mm, MBX_EXTRACT_COUNT mec WHERE mm.MESSAGE_ID = mec.MESSAGE_ID group by to_char(mm.CREATED_DATETIME, 'YYYY'),mec.EXTRACTABLE_COUNT order by 1,2

Messages on mailboxes by created date
select mm.MESSAGE_ID,mm.CREATED_DATETIME,mm.MESSAGE_SIZE,mm.MAILBOX_ID,mb.PATH,mm.DOC_ID from MBX_MESSAGE mm, MBX_MAILBOX mb where mm.MAILBOX_ID = mb.MAILBOX_ID order by mm.CREATED_DATETIME

Messages on mailboxes group by year with count and sum
select to_char(mm.CREATED_DATETIME, 'YYYY') as ANO, mb.PATH as mbx, count(1) as CNT, SUM(mm.MESSAGE_SIZE) as SUM1 from MBX_MESSAGE mm, MBX_MAILBOX mb where mm.MAILBOX_ID = mb.MAILBOX_ID group by to_char(mm.CREATED_DATETIME, 'YYYY'), mb.PATH

= Ver também =
 * IBM Sterling B2B: Archive e Purge
 * IBM Sterling B2B: SELECT a Code List
 * IBM Sterling B2B: SELECT Queue, Lifespan, PersistentLevel of Business Process


 * Artigos sobre IBM Sterling
 * Mais Artigos sobre Cloud / WebDev / Tecnologias