zOs/SQL/CATTRIST
$>A540769.WK.TEXV(CATTRIST)
call sqlConnect dbtf
call sqlPreOpen 1, "select",
"strip(tbOwner) || '.' || strip(tbName),",
"strip(schema) || '.' || strip(Name),",
"trigTime || trigEvent || granularity, seqNo, text",
"from sysibm.sysTriggers" ,
"order by tbOwner, tbName, schema, name, seqno"
do while sqlFetchInto(1, ':tb, :tr, :teg, :sn, :tx')
$$- left(tb, 30) left(tr, 40) teg sn tx
end
call sqlDisconnect
$#end
;x;
select substr(strip(tbOwner) || '.' || strip(tbName), 1, 20) "tb",
substr(strip(schema) || '.' || strip(Name), 1, 30) "tri",
trigTime || trigEvent || granularity "tig", seqNo, strip(text)
from sysibm.sysTriggers
order by tbOwner, tbName, schema, name, seqno
;x;
select left(text, 6), count(*)
from sysibm.sysTriggers
group by left(text, 6)
;x;
$#out 20100705 16:32:57
$#out 20100629 10:12:16
$#out 20100629 10:10:57
A234579.TEXCEPTIONS_TS DB2RTS.INS1 BIR 1 CR
DB2PM.BATCHCONF DB2PM.BC_DEL04 ADR 1 CR
DB2PM.BATCHCONF DB2PM.BC_INS00 AIR 1 CR
DB2PM.BATCHCONF DB2PM.BC_INS01 BIR 1 CR
DB2PM.BATCHCONF DB2PM.BC_INS06 AIR 1 CR
DB2PM.BATCHCONF DB2PM.BC_INS08 BIR 1 CR
DB2PM.BATCHCONF DB2PM.BC_INS10 BIR 1 CR
DB2PM.BATCHCONF DB2PM.BC_INS11 AIR 1 CR
DB2PM.BATCHCONF DB2PM.BC_UPD02 BUR 1 CR
DB2PM.BATCHCONF DB2PM.BC_UPD03 AUR 1 CR
DB2PM.BATCHCONF DB2PM.BC_UPD05 AUR 1 CR
DB2PM.BATCHCONF DB2PM.BC_UPD07 AUR 1 CR
DB2PM.BATCHCONF DB2PM.BC_UPD09 AUR 1 CR
DB2PM.BATCHCONF DB2PM.BC_UPD12 AUR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_DEL04 ADR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_INS00 AIR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_INS01 BIR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_INS06 AIR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_INS08 BIR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_UPD02 BUR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_UPD03 AUR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_UPD05 AUR 1 CR
DB2PM.CONVERTCONF DB2PM.CC_UPD07 AUR 1 CR
DB2PM.CRDCONF DB2PM.CRD_DEL4 ADR 1 CR
DB2PM.CRDCONF DB2PM.CRD_INS0 AIR 1 CR
DB2PM.CRDCONF DB2PM.CRD_INS1 BIR 1 CR
DB2PM.CRDCONF DB2PM.CRD_INS6 BIR 1 CR
DB2PM.CRDCONF DB2PM.CRD_INS8 BIR 1 CR
DB2PM.CRDCONF DB2PM.CRD_UPD2 BUR 1 CR
DB2PM.CRDCONF DB2PM.CRD_UPD3 AUR 1 CR
DB2PM.CRDCONF DB2PM.CRD_UPD5 AUR 1 CR
DB2PM.CRDCONF DB2PM.CRD_UPD7 AUR 1 CR
DB2PM.CRDCONFTRACE DB2PM.CT_DEL01 ADR 1 CR
DB2PM.CRDCONFTRACE DB2PM.CT_UPD02 AUR 1 CR
DB2PM.DSINDEX DB2PM.DI_DEL01 BDR 1 CR
DB2PM.LOADCONF DB2PM.LC_DEL04 ADR 1 CR
DB2PM.LOADCONF DB2PM.LC_INS00 AIR 1 CR
DB2PM.LOADCONF DB2PM.LC_INS01 BIR 1 CR
DB2PM.LOADCONF DB2PM.LC_INS06 AIR 1 CR
DB2PM.LOADCONF DB2PM.LC_INS08 BIR 1 CR
DB2PM.LOADCONF DB2PM.LC_UPD02 BUR 1 CR
DB2PM.LOADCONF DB2PM.LC_UPD03 AUR 1 CR
DB2PM.LOADCONF DB2PM.LC_UPD05 AUR 1 CR
DB2PM.LOADCONF DB2PM.LC_UPD07 AUR 1 CR
DB2PM.PROCESS DB2PM.P_DEL04 ADR 1 CR
DB2PM.PROCESS DB2PM.P_INS00 AIR 1 CR
DB2PM.PROCESS DB2PM.P_INS01 BIR 1 CR
DB2PM.PROCESS DB2PM.P_INS11 BIR 1 CR
DB2PM.PROCESS DB2PM.P_UPD02 BUR 1 CR
DB2PM.PROCESS DB2PM.P_UPD03 AUR 1 CR
DB2PM.PROCESS DB2PM.P_UPD05 AUR 1 CR
DB2PM.PROCESS DB2PM.P_UPD06 AUR 1 CR
DB2PM.PROCESS DB2PM.P_UPD07 AUR 1 CR
DB2PM.PROCESS DB2PM.P_UPD08 AUR 1 CR
DB2PM.PROCESS DB2PM.P_UPD09 AUR 1 CR
DB2PM.PROCESS DB2PM.P_UPD10 AUR 1 CR
DB2PM.PROCESSEVEXCP DB2PM.PE_DEL03 ADR 1 CR
DB2PM.PROCESSEVEXCP DB2PM.PE_INS01 BIR 1 CR
DB2PM.PROCESSEVEXCP DB2PM.PE_INS05 BIR 1 CR
DB2PM.PROCESSEVEXCP DB2PM.PE_UPD02 AUR 1 CR
DB2PM.PROCESSEVEXCP DB2PM.PE_UPD04 AUR 1 CR
DB2PM.PROCESSGROUP DB2PM.PG_INS00 BIR 1 CR
DB2PM.PROCESSGROUP DB2PM.PG_INS01 BIR 1 CR
DB2PM.PROCESSGROUP DB2PM.PG_UPD02 BUR 1 CR
DB2PM.PROCESSGROUP DB2PM.PG_UPD03 AUR 1 CR
DB2PM.PROCESSLOG DB2PM.PL_DEL01 ADR 1 CR
DB2PM.PROCESSLOG DB2PM.PL_INS02 BIR 1 CR
DB2PM.PROCESSLOG DB2PM.PL_UPD03 AUR 1 CR
DB2PM.PROCESSLOG DB2PM.PL_UPD04 AUR 1 CR
DB2PM.QRY_GROUP DB2PM.QG_INS01 BIR 1 CR
DB2PM.QRY_GROUP DB2PM.QG_UPD02 BUR 1 CR
DB2PM.QRY_GROUP DB2PM.QG_UPD03 AUR 1 CR
DB2PM.QRY_QUERY DB2PM.Q_INS01 BIR 1 CR
DB2PM.QRY_QUERY DB2PM.Q_UPD02 BUR 1 CR
DB2PM.QRY_QUERY DB2PM.Q_UPD03 AUR 1 CR
DB2PM.ROT_CLUSTER DB2PM.RC_INS01 BIR 1 CR
DB2PM.ROT_CLUSTER DB2PM.RC_UPD02 BUR 1 CR
DB2PM.ROT_CLUSTER DB2PM.RC_UPD03 AUR 1 CR
DB2PM.ROT_GROUP DB2PM.RG_INS01 BIR 1 CR
DB2PM.ROT_GROUP DB2PM.RG_UPD02 BUR 1 CR
DB2PM.ROT_GROUP DB2PM.RG_UPD03 AUR 1 CR
DB2PM.ROT_ROT DB2PM.RR_INS01 BIR 1 CR
DB2PM.ROT_ROT DB2PM.RR_UPD02 BUR 1 CR
DB2PM.ROT_ROT DB2PM.RR_UPD03 AUR 1 CR
DB2PM.SQLPACONF DB2PM.PA_INS1 BIR 1 CR
DB2PM.SQLPACONF DB2PM.PA_INS2 AIR 1 CR
DB2PM.SQLPACONF DB2PM.PA_UPD1 BUR 1 CR
DB2PM.SQLPACONF DB2PM.PA_UPD2 AUR 1 CR
DB2PM.STEP DB2PM.S_DEL04 ADR 1 CR
DB2PM.STEP DB2PM.S_INS00 AIR 1 CR
DB2PM.STEP DB2PM.S_INS01 BIR 1 CR
DB2PM.STEP DB2PM.S_INS06 BIR 1 CR
DB2PM.STEP DB2PM.S_INS07 BIR 1 CR
DB2PM.STEP DB2PM.S_INS09 BIR 1 CR
DB2PM.STEP DB2PM.S_UPD02 BUR 1 CR
DB2PM.STEP DB2PM.S_UPD03 AUR 1 CR
DB2PM.STEP DB2PM.S_UPD05 AUR 1 CR
DB2PM.STEP DB2PM.S_UPD08 BUR 1 CR
DB2PM.STEP DB2PM.S_UPD10 BUR 1 CR
DB2PM.STEP DB2PM.S_UPD11 AUR 1 CR
DB2PM.STEPLOG DB2PM.SL_INS01 BIR 1 CR
DB2PM.STEPLOG DB2PM.SL_UPD02 AUR 1 CR
DB2PM.STEPLOG DB2PM.SL_UPD03 AUR 1 CR
DB2PM.STEPLOG DB2PM.SL_UPD04 AUR 1 CR
OA1T.TAV171A1 OA1T.AV171AAI BIR 1 CR
OA1T.TAV171A1 OA1T.AV171AAU BUR 1 CR
OA1T.TAV172A1 OA1T.AV172AAI BIR 1 CR
OA1T.TAV172A1 OA1T.AV172AAU BUR 1 CR
OA1T.TDI040A1 OA1T.DI040ABI BIR 1
OA1T.TDI040A1 OA1T.DI040DBD BDR 1
OA1T.TDI040A1 OA1T.DI040DBI BIR 1
OA1T.TDI040A1 OA1T.DI040EBD BDR 1
OA1T.TDI040A1 OA1T.DI040LBD BDR 1
OA1T.TDI041A1 OA1T.DI041ABI BIR 1
OA1T.TDI041A1 OA1T.DI041BBI BIR 1
OA1T.TDI041A1 OA1T.DI041KBD BDR 1
OA1T.TDI041A1 OA1T.DI041KBI BIR 1
OA1T.TDI041A1 OA1T.DI041LBI BIR 1
OA1T.TDI041A1 OA1T.DI041MBI BIR 1
OA1T.TDI041A1 OA1T.DI041PBD BDR 1
OA1T.TDI042A1 OA1T.DI042ABI BIR 1
OA1T.TDI042A1 OA1T.DI042PBI BIR 1
OA1T.TDI043A1 OA1T.DI043ABI BIR 1 CR
OA1T.TDI043A1 OA1T.DI043GBI BIR 1
OA1T.TDI043A1 OA1T.DI043MBD BDR 1
OA1T.TDI043A1 OA1T.DI043NBD BDR 1
OA1T.TDI043A1 OA1T.DI043OBD BDR 1
OA1T.TDI045A1 OA1T.DI045CBI BIR 1
OA1T.TDI045A1 OA1T.DI045OBI BIR 1
OA1T.TDI045A1 OA1T.DI045RBI BIR 1
OA1T.TDI049A1 OA1T.DI049ABI BIR 1
OA1T.TDI049A1 OA1T.DI049QBI BIR 1
OA1T.TDI050A1 OA1T.DI050ABI BIR 1
OA1T.TDI050A1 OA1T.DI050NBI BIR 1
OA1T.TDI050A1 OA1T.DI050QBD BDR 1
OA1T.TDI050A1 OA1T.DI050RBD BDR 1
OA1T.TDI052A1 OA1T.DI052ABI BIR 1
OA1T.TDI053A1 OA1T.DI053ABI BIR 1
OA1T.TDI054A1 OA1T.DI054ABI BIR 1
OA1T.TDI054A1 OA1T.DI054EBI BIR 1
OA1T.TDI056A1 DI05A1A.DI056ABI BIR 1 CR
OA1T.TDT011A1 OA1T.DT011ABI BIR 1 CR
OA1T.TDT011A1 OA1T.DT011ABU BUR 1 CR
OA1T.TKD001A1 OA1T.KD001A1BI1 BIR 1
OA1T.TKD001A1 OA1T.KD001A1BI3 BUR 1
OA1T.TKD100A1 OA1T.KD100HAD ADR 1 CR
OA1T.TKD100A1 OA1T.KD100HAU AUR 1 CR
OA1T.TKD101A1 OA1T.KD101HAD ADR 1 CR
OA1T.TKD101A1 OA1T.KD101HAU AUR 1 CR
OA1T.TKD102A1 OA1T.KD102HAD ADR 1 CR
OA1T.TKD102A1 OA1T.KD102HAU AUR 1 CR
OA1T.TKD103A1 OA1T.KD103HAD ADR 1 CR
OA1T.TKD103A1 OA1T.KD103HAU AUR 1 CR
OA1T.TKD104A1 OA1T.KD104HAD ADR 1 CR
OA1T.TKD104A1 OA1T.KD104HAU AUR 1 CR
OA1T.TKD105A1 OA1T.KD105HAD ADR 1 CR
OA1T.TKD105A1 OA1T.KD105HAU AUR 1 CR
OA1T.TNI130A101A OA1T.NI132AAI AIR 1 CR
OA1T.TNI130A101A OA1T.NI132AAU AIR 1 CR
OA1T.TNI140A101A OA1T.NI142AAI AIR 1 CR
OA1T.TNI140A101A OA1T.NI142AAU AIR 1 CR
OA1T.TNI300A101A OA1T.NI300HAD ADR 1 CR
OA1T.TNI300A101A OA1T.NI300HAU AUR 1 CR
OA1T.TNI613A101A OA1T.NI613HAD ADS 1 CR
OA1T.TNI613A101A OA1T.NI613HAU AUS 1 CR
OA1T.TNI660A101A OA1T.NI660AAI AIR 1 CR
OA1T.TNI702A1 OA1T.NI702AAI BIR 1 CR
OA1T.TNI702A1 OA1T.NI702AAU BUR 1 CR
OA1T.TNI702A1 OA1T.NI702ABI BIR 1 CR
OA1T.TNI702A1 OA1T.NI702ABU BUR 1 CR
OA1T.TNI702A1 OA1T.NI702ACI BIR 1 CR
OA1T.TNI702A1 OA1T.NI702ACU BUR 1 CR
OA1T.TNI702A1 OA1T.NI702ADI BIR 1 CR
OA1T.TNI702A1 OA1T.NI702ADU BUR 1 CR
OA1T.TNI710A1 OA1T.NI710AAI BIR 1 CR
OA1T.TNI710A1 OA1T.NI710AAU BUR 1 CR
OA1T.TNI711A1 OA1T.NI711AAI BIR 1 CR
OA1T.TNI711A1 OA1T.NI711AAU BUR 1 CR
OA1T.TNI712A1 OA1T.NI712AAI BIR 1 CR
OA1T.TNI712A1 OA1T.NI712AAU BUR 1 CR
OA1T.TNI720A1 OA1T.NI720AAI BIR 1 CR
OA1T.TNI720A1 OA1T.NI720AAU BUR 1 CR
OA1T.TNI740A1 OA1T.NI740AAI BIR 1 CR
OA1T.TNI740A1 OA1T.NI740AAU BUR 1 CR
OA1T.TNI740A1 OA1T.NI740ABI BIR 1 CR
OA1T.TNI740A1 OA1T.NI740ABU BUR 1 CR
OA1T.TNI740A1 OA1T.NI740ACI BIR 1 CR
OA1T.TNI740A1 OA1T.NI740ACU BUR 1 CR
OA1T.TNI740A1 OA1T.NI740ADI BIR 1 CR
OA1T.TNI740A1 OA1T.NI740ADU BUR 1 CR
OA1T.TNI740A1 OA1T.NI740AEI BIR 1 CR
OA1T.TNI740A1 OA1T.NI740AEU BUR 1 CR
OA1T.TNI742A1 OA1T.NI742AAI BIR 1 CR
OA1T.TNI742A1 OA1T.NI742AAU BUR 1 CR
OA1T.TNI744A1 OA1T.NI744AAI BIR 1 CR
OA1T.TNI744A1 OA1T.NI744AAU BUR 1 CR
OA1T.TNI744A1 OA1T.NI744ABI BIR 1 CR
OA1T.TNI744A1 OA1T.NI744ABU BUR 1 CR
OA1T.TNI745A1 OA1T.NI745AAI BIR 1 CR
OA1T.TNI745A1 OA1T.NI745AAU BUR 1 CR
OA1T.TNI746A1 OA1T.NI746AAI BIR 1 CR
OA1T.TNI746A1 OA1T.NI746AAU BUR 1 CR
OA1T.TNI746A1 OA1T.NI746ABI BIR 1 CR
OA1T.TNI746A1 OA1T.NI746ABU BUR 1 CR
OA1T.TNI747A1 OA1T.NI747AAI BIR 1 CR
OA1T.TNI747A1 OA1T.NI747AAU BUR 1 CR
OA1T.TNI747A1 OA1T.NI747ABI BIR 1 CR
OA1T.TNI747A1 OA1T.NI747ABU BUR 1 CR
OA1T.TNI748A1 OA1T.NI748AAI BIR 1 CR
OA1T.TNI748A1 OA1T.NI748AAU BUR 1 CR
OA1T.TNI748A1 OA1T.NI748ABI BIR 1 CR
OA1T.TNI748A1 OA1T.NI748ABU BUR 1 CR
OA1T.TNI749A1 OA1T.NI749AAI BIR 1 CR
OA1T.TNI749A1 OA1T.NI749AAU BUR 1 CR
OA1T.TNI760A1 OA1T.NI760AAI BIR 1 CR
OA1T.TNI760A1 OA1T.NI760AAU BUR 1 CR
OA1T.TNI770A1 OA1T.NI770AAI BIR 1 CR
OA1T.TNI770A1 OA1T.NI770AAU BUR 1 CR
OA1T.TNI770A1 OA1T.NI770ABI BIR 1 CR
OA1T.TNI770A1 OA1T.NI770ABU BUR 1 CR
OA1T.TWB550A1 OA1T.TT550FFIS BIR 1 CR
OA1T.TWB550A1 OA1T.TT550FFUP BUR 1 CR
OA1T.TWB551A1 OA1T.TT551FFIS BIR 1 CR
OA1T.TWB551A1 OA1T.TT551FFUP BUR 1 CR
OA1T.TWB555A1 OA1T.TT555FFIS BIR 1 CR
OA1T.TWB555A1 OA1T.TT555FFUP BUR 1 CR
OA1T.TWB563A1 OA1T.TT563FFIS BIR 1 CR
OA1T.TWB563A1 OA1T.TT563FFUP BUR 1 CR
OA1T.TWB566A1 OA1T.TT566FFIS BIR 1 CR
OA1T.TWB566A1 OA1T.TT566FFUP BUR 1 CR
OA1T.TWB582A1 OA1T.TT582FFIS BIR 1 CR
OA1T.TWB582A1 OA1T.TT582FFUP BUR 1 CR
OA1T.TWB583A1 OA1T.TT583FFIS BIR 1 CR
OA1T.TWB583A1 OA1T.TT583FFUP BUR 1 CR
SAMJ.BASERS AU01A1T.BASERSI AIR 1 CR
SAMJ.BASERS AU01A1T.BASERSU AUR 1 CR
SAMJ.BASEUG AU01A1T.BASEUGI AIR 1 CR
SAMJ.BASEUG AU01A1T.BASEUGU AUR 1 CR
SAMJ.BASEUS AU01A1T.BASEUSI AIR 1 CR
SAMJ.BASEUS AU01A1T.BASEUSU AUR 1 CR
SAMJ.BASEUSTS AU01A1T.BASEUSTI AIR 1 CR
SAMJ.BASEUSTS AU01A1T.BASEUSTU AUR 1 CR
SAMJ.TECHDSP AU01A1T.TECHDSPI AIR 1 CR
SAMJ.TECHDSP AU01A1T.TECHDSPU AUR 1 CR
SAMJUP.BASERS SAMJUP.BASERSI AIR 1 CR
SAMJUP.BASERS SAMJUP.BASERSU AUR 1 CR
SAMJUP.BASETAB SAMJUP.BASETABI AIR 1 CR
SAMJUP.BASETAB SAMJUP.BASETABU AUR 1 CR
SAMJUP.BASEUG SAMJUP.BASEUGI AIR 1 CR
SAMJUP.BASEUG SAMJUP.BASEUGU AUR 1 CR
SAMJUP.BASEUS SAMJUP.BASEUSI AIR 1 CR
SAMJUP.BASEUS SAMJUP.BASEUSU AUR 1 CR
SAMJUP.BASEUSTS SAMJUP.BASEUSTI AIR 1 CR
SAMJUP.BASEUSTS SAMJUP.BASEUSTU AUR 1 CR
SAMJUP.TECHDSP SAMJUP.TECHDSPI AIR 1 CR
SAMJUP.TECHDSP SAMJUP.TECHDSPU AUR 1 CR
SYSIBMTS.SYSTEXTCONNECTINFO DSNIBMTS.CONNECTINFOCONSTRAINT BIR 1 CR
TSTRTS.TRTSREOIXEXCEPTION TSTRTS.TRTSREOIXEXCEPTIONAFTDELST ADR 1 CR
TSTRTS.TRTSREOIXEXCEPTION TSTRTS.TRTSREOIXEXCEPTIONAFTINS AIS 1 CR
TSTRTS.TRTSREOIXEXCEPTION TSTRTS.TRTSREOIXEXCEPTIONAFTUPD AUS 1 CR
TSTRTS.TRTSREOIXEXCEPTION TSTRTS.TRTSREOIXEXCEPTIONAFTUPDST AUR 1 CR
TSTRTS.TRTSREOIXEXCEPTION TSTRTS.TRTSREOIXEXCEPTIONBEFINS BIR 1 CR
TSTRTS.TRTSREOIXEXCEPTION TSTRTS.TRTSREOIXEXCEPTIONBEFUPD BUR 1 CR
TSTRTS.TRTSREOJOBEXCEPTION TSTRTS.TRTSREOJOBEXCEPTIONAFTDELST ADR 1 CR
TSTRTS.TRTSREOJOBEXCEPTION TSTRTS.TRTSREOJOBEXCEPTIONAFTINS AIS 1 CR
TSTRTS.TRTSREOJOBEXCEPTION TSTRTS.TRTSREOJOBEXCEPTIONAFTUPD AUS 1 CR
TSTRTS.TRTSREOJOBEXCEPTION TSTRTS.TRTSREOJOBEXCEPTIONAFTUPDST AUR 1 CR
TSTRTS.TRTSREOJOBEXCEPTION TSTRTS.TRTSREOJOBEXCEPTIONBEFINS BIR 1 CR
TSTRTS.TRTSREOJOBEXCEPTION TSTRTS.TRTSREOJOBEXCEPTIONBEFUPD BUR 1 CR
TSTRTS.TRTSREOTSEXCEPTION TSTRTS.TRTSREOTSEXCEPTIONAFTDELST ADR 1 CR
TSTRTS.TRTSREOTSEXCEPTION TSTRTS.TRTSREOTSEXCEPTIONAFTINS AIS 1 CR
TSTRTS.TRTSREOTSEXCEPTION TSTRTS.TRTSREOTSEXCEPTIONAFTUPD AUS 1 CR
TSTRTS.TRTSREOTSEXCEPTION TSTRTS.TRTSREOTSEXCEPTIONAFTUPDST AUR 1 CR
TSTRTS.TRTSREOTSEXCEPTION TSTRTS.TRTSREOTSEXCEPTIONBEFINS BIR 1 CR
TSTRTS.TRTSREOTSEXCEPTION TSTRTS.TRTSREOTSEXCEPTIONBEFUPD BUR 1 CR