As seguintes instruções JCL imprimem dados resumidos de todos os registros de log, começando com o RBA registrado no ERDS no momento em que o último ponto de verificação do Agente de Log do PowerExchange foi obtido:
// JOB
//READER EXEC PGM=EDMLUCTR
//STEPLIB DD DISP=SHR,DSN=hlq.LOAD //ERDS01 DD DISP=SHR,DSN=your.ERDS01 //EDMPARMS DD DISP=SHR,DSN=your.USERLIB //SYSIN DD * // A saída resultante é: 18:53:31.86 L O G S T A R T
18:53:31.83 PWXEDM172502I Log Scan/Print Utility Initialization in-progress product level V2.4.05 04/22/2014 18:53:31.83 Echo of input from SYSIN...
18:53:31.85 End of input from SYSIN...
18:53:42.04 PWXEDM172191I EDMLRDS: LMF will begin transferring data for Log Scan/Print Utility at X'0000000050000000' 18:53:42.14 PWXEDM172146I EDMLRDP: LMF now processing EDMTEST.DEV.V1.PRILOG.DS01 for Log Scan/Print Utility
18:53:42.37 Log-rec EDP-UOW=LOGGER00000000500000000000 LogRBA=0000000050000000 18:53:42.37 Log-rec EDP-UOW=LOGGER0000000050B400000001 LogRBA=0000000050B40000 18:53:42.37 Log-rec EDP-UOW=LOGGER00000000523400000003 LogRBA=0000000052340000 18:53:42.37 Log-rec EDP-UOW=AUSL 0000000052E800000001 LogRBA=0000000052E80000 18:53:42.37 Beg-pkt EDP-UOW=AUSL 00000000546800000000 LogRBA=0000000054680000 18:53:42.37 ECCR-UOW=AUSPRT01 AUSPRT01 C1E4E2D7D9E3F0F1 008F803000000001 18:53:42.37 Timestamp-18:35:40:11 Date-04/29/2014
18:53:42.37 Chg-rec EDP-UOW=AUSL 00000000546800000000 LogRBA=0000000054F00000 18:53:42.37 ECCR-UOW=AUSPRT01 C1E4E2D7D9E3F0F1 008F803000000001 18:53:42.37 Source=VSM Func=ISRT Srcname=VSAMEDMTEST.VSAM.KSDS01 18:53:42.37 Timestamp-18:35:40:18 Date-04/29/2014
18:53:42.37 Chg-rec EDP-UOW=AUSL 00000000546800000000 LogRBA=0000000056550000 18:53:42.37 ECCR-UOW=AUSPRT01 C1E4E2D7D9E3F0F1 008F803000000001 18:53:42.37 Source=VSM Func=ISRT Srcname=VSAMEDMTEST.VSAM.KSDS01 18:53:42.37 Timestamp-18:35:40:36 Date-04/29/2014
. . . . . . . . . . . . . . .
18:53:43.63 Srv-rec EDP-UOW=ECCRCTF5F24040404040404040 LogRBA=0000001902F90000 18:53:43.63 Srv-rec EDP-UOW=ECCRCTF5F24040404040404040 LogRBA=0000001906090000 18:53:43.63 Log-rec EDP-UOW=AUSL 00000019093500000001 LogRBA=0000001909350000 18:53:43.63 Srv-rec EDP-UOW=ECCRCTF5F24040404040404040 LogRBA=000000190AB50000 18:53:43.63 Srv-rec EDP-UOW=ECCRCTF5F24040404040404040 LogRBA=000000190DC50000 18:53:43.63 Log-rec EDP-UOW=AUSL 00000019110500000001 LogRBA=0000001911050000 18:53:43.63 Srv-rec EDP-UOW=AUSDB2F0F10000000000004040 LogRBA=0000001912850000 18:53:43.63 Srv-rec EDP-UOW=AUSDB2F0F10000000000004040 LogRBA=0000001916890000 18:53:43.63 Beg-pkt EDP-UOW=AUSL 000000191A8D00000000 LogRBA=000000191A8D0000 18:53:43.63 ECCR-UOW=AUSDB201 01 F0F1000000000001 605FE82B00000000 18:53:43.63 Timestamp-18:53:19:68 Date-05/07/2014
18:53:43.63 Chg-rec EDP-UOW=AUSL 000000191A8D00000000 LogRBA=000000191D410000 18:53:43.63 ECCR-UOW=01 F0F1000000000001 605FE82B00000000 18:53:43.63 Source=DB2 Func=DLET Srcname=DB2DSNBtenchar1 18:53:43.63 Timestamp-18:53:19:68 Date-05/07/2014
18:53:43.63 Chg-rec EDP-UOW=AUSL 000000191A8D00000000 LogRBA=00000019219F0000 18:53:43.63 ECCR-UOW=01 F0F1000000000001 605FE82B00000000 18:53:43.63 Source=DB2 Func=DLET Srcname=DB2DSNBtenchar1 18:53:43.63 Timestamp-18:53:19:68 Date-05/07/2014
18:53:43.63 Com-pkt EDP-UOW=AUSL 000000191A8D00000000 LogRBA=0000001925E90000 18:53:43.63 ECCR-UOW=AUSDB201 01 F0F1000000000001 605FE82B00000000 18:53:43.63 Timestamp-18:53:19:68 Date-05/07/2014
18:53:48.67 PWXEDM172198I EDMLPOPU: LMF table populate tasks are terminating due to an operator stop or PAC termination 18:53:48.70 PWXEDM172195I EDMLUPLU: LMF task for Log Scan/Print Utility is terminating due to an operator stop or PAC
18:53:48.73 VSAMEDMTEST.VSAM.KSDS01 Isrt= 5 Repl= 0 Dlet= 0 Unk= 0 18:53:48.73 VSAMEDM.DEV.EDMAB123 Isrt= 0 Repl= 1000 Dlet= 0 Unk= 0 18:53:48.73 VSAMEDM.DEV.EDMAB123 Isrt= 1000 Repl= 0 Dlet= 1000 Unk= 0 18:53:48.73 DB2DSNBtenchar1 Isrt= 2 Repl= 2 Dlet= 2 Unk= 0 18:53:48.73 Open Uows...
18:53:48.74 L O G E N D
Utilitário EDMLUCTR - Exemplo 2
As seguintes instruções JCL imprimem dados resumidos de todos os registros de log, começando pelo RBA especificado, e as informações detalhadas em formato hexadecimal sobre os registros de alteração:
// JOB
//READER EXEC PGM=EDMLUCTR
//STEPLIB DD DISP=SHR,DSN=hlq.LOAD //ERDS01 DD DISP=SHR,DSN=your.ERDS01 //EDMPARMS DD DISP=SHR,DSN=your.USERLIB //SYSIN DD *
-SEL LOGRBA=000000191A8D0000 CHANGE-DETAIL -SEL RECORDS=10
//
Nota: O trabalho imprime as informações detalhadas sobre os registros de alteração porque o parâmetro
opcional CHANGE-DETAIL é incluído. A saída resultante é:
19:08:00.74 L O G S T A R T
19:08:00.69 PWXEDM172502I Log Scan/Print Utility Initialization in-progress product level V2.4.05 04/22/2014 19:08:00.70 Echo of input from SYSIN...
19:08:00.70 -SEL LOGRBA=000000191A8D0000 CHANGE-DETAIL 19:08:00.70 -SEL RECORDS=10
19:08:00.72 End of input from SYSIN...
19:08:00.72 PWXEDM172191I EDMLUCTR: LMF will begin transferring data for Log Scan/Print Utility at X'000000191A8D0000' 19:08:11.01 PWXEDM172146I EDMLRDP: LMF now processing WBRUMB1.DEV.V1.PRILOG.DS01 for Log Scan/Print Utility
19:08:11.67 Beg-pkt EDP-UOW=AUSL 000000191A8D00000000 LogRBA=000000191A8D0000 19:08:11.67 ECCR-UOW=AUSDB201 01 F0F1000000000001 605FE82B00000000 19:08:11.67 Timestamp-18:53:19:68 Date-05/07/2014
19:08:11.67 Chg-rec EDP-UOW=AUSL 000000191A8D00000000 LogRBA=000000191D410000 19:08:11.67 ECCR-UOW=01 F0F1000000000001 605FE82B00000000 19:08:11.67 Source=DB2 Func=DLET Srcname=DB2DSNBtenchar1 19:08:11.67 Timestamp-18:53:19:68 Date-05/07/2014
19:08:11.67 0000 00000003 00000014 000002B4 000002B4 © © 19:08:11.67 0010 0000044A 02A00101 C3C46008 00000002 œ¢ µ CD-— 19:08:11.67 0020 E2C40000 00000000 00000000 00040000 SD œ 19:08:11.67 0030 00000000 00000000 0000CD1E 42982685 ò âq e 19:08:11.67 0040 8081C4C2 F2C4E2D5 C2A38595 83888199 ØaDB2DSNBtenchar 19:08:11.67 0050 F1404040 40404040 40404040 40404040 1
19:08:11.67 0060 40404040 4040C1E4 E2D34040 00000019 AUSL 19:08:11.67 0070 1A8D0000 00000000 00191D41 00000000 ’ý . . . . .
. . . . .
19:08:11.70 Default 5000 or RECORDS= threshold reached
19:08:11.73 PWXEDM172198I EDMLPOPU: LMF table populate tasks are terminating due to an operator stop or PAC termination 19:08:11.77 PWXEDM172195I EDMLUPLU: LMF task for Log Scan/Print Utility is terminating due to an operator stop or PAC termination
19:08:11.79 Totals by Source...
19:08:11.79 DB2DSNBtenchar1 Isrt= 2 Repl= 1 Dlet= 2 Unk= 0 19:08:11.79 Open Uows...
19:08:11.79 Edp-UOW=AUSL 0000001936AD00000000 LogRBA=0000001936AD0000 19:08:11.79 ECCR-UOW=01 F0F1000000000001 605FF6E000000000 19:08:11.80 L O G E N D
Utilitário EDMLUCTR - Exemplo 3
As seguintes instruções JCL filtram registros usando o valor -MASK de DB2DSNB e imprimem os registros a partir de um RBA específico.
// JOB
//READER EXEC PGM=EDMLUCTR
//STEPLIB DD DISP=SHR,DSN=hlq.LOAD //ERDS01 DD DISP=SHR,DSN=your.ERDS01 //EDMPARMS DD DISP=SHR,DSN=your.USERLIB //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSIN DD *
-SEL LOGRBA=000000191A8D0000 RECORDS=10 -MASK DB2DSNB
//
A inclusão do parâmetro opcional RECORDS limita o número de verificações de registros em busca da cadeia de caracteres DB2DSNB.
A saída resultante é: 19:12:40.93 L O G S T A R T
19:12:40.89 PWXEDM172502I Log Scan/Print Utility Initialization in-progress product level V2.4.05 04/22/2014 19:12:40.89 Echo of input from SYSIN...
19:12:40.89 -SEL LOGRBA=000000191A8D0000 RECORDS=10 19:12:40.89 -MASK DB2DSNB
19:12:40.91 End of input from SYSIN...
19:12:40.91 PWXEDM172191I EDMLUCTR: LMF will begin transferring data for Log Scan/Print Utility at X'000000191A8D0000' 19:12:51.12 PWXEDM172146I EDMLRDP: LMF now processing WBRUMB1.DEV.V1.PRILOG.DS01 for Log Scan/Print Utility
19:12:52.69 Chg-rec EDP-UOW=AUSL 000000191A8D00000000 LogRBA=000000191D410000 19:12:52.69 ECCR-UOW=01 F0F1000000000001 605FE82B00000000 19:12:52.69 Source=DB2 Func=DLET Srcname=DB2DSNBtenchar1 19:12:52.69 Timestamp-18:53:19:68 Date-05/07/2014
19:12:52.69 Chg-rec EDP-UOW=AUSL 000000191A8D00000000 LogRBA=00000019219F0000 19:12:52.69 ECCR-UOW=01 F0F1000000000001 605FE82B00000000 19:12:52.69 Source=DB2 Func=DLET Srcname=DB2DSNBtenchar1 19:12:52.69 Timestamp-18:53:19:68 Date-05/07/2014
19:12:52.69 Chg-rec EDP-UOW=AUSL 00000019289D00000000 LogRBA=000000192B510000 19:12:52.69 ECCR-UOW=01 F0F1000000000001 605FF25800000000 19:12:52.69 Source=DB2 Func=ISRT Srcname=DB2DSNBtenchar1 19:12:52.69 Timestamp-18:53:19:68 Date-05/07/2014
19:12:52.69 Chg-rec EDP-UOW=AUSL 00000019289D00000000 LogRBA=000000192F9B0000 19:12:52.69 ECCR-UOW=01 F0F1000000000001 605FF25800000000 19:12:52.69 Source=DB2 Func=ISRT Srcname=DB2DSNBtenchar1 19:12:52.69 Timestamp-18:53:19:68 Date-05/07/2014
19:12:52.69 Chg-rec EDP-UOW=AUSL 0000001936AD00000000 LogRBA=0000001939610000 19:12:52.69 ECCR-UOW=01 F0F1000000000001 605FF6E000000000 19:12:52.69 Source=DB2 Func=UPDT Srcname=DB2DSNBtenchar1 19:12:52.69 Timestamp-18:53:19:68 Date-05/07/2014 19:12:52.70 Default 5000 or RECORDS= threshold reached
19:12:52.72 PWXEDM172198I EDMLPOPU: LMF table populate tasks are terminating due to an operator stop or PAC termination 19:12:52.76 PWXEDM172195I EDMLUPLU: LMF task for Log Scan/Print Utility is terminating due to an operator stop or PAC termination
19:12:52.85 Totals by Source...
19:12:52.85 DB2DSNBtenchar1 Isrt= 2 Repl= 1 Dlet= 2 Unk= 0 19:12:52.85 Open Uows...
19:12:52.89 L O G E N D
Utilitário EDMLUCTR - Exemplo 4
Se você executar o utilitário em um ambiente de Mesclagem Pós-Log, as seguintes instruções JCL imprimirão dados resumidos de todos os registros de log que começam com um registro de data/hora específico:
// JOB
//READER EXEC PGM=EDMLUCTR
//STEPLIB DD DISP=SHR,DSN=hlq.LOAD //ERDS01 DD DISP=SHR,DSN=your.ERDS01 //EDMPARMS DD DISP=SHR,DSN=your.USERLIB //SYSIN DD *
-SEL LOGRBA=CD1FCF19F4713301 RECORDS=EOF //
A saída resultante é: 19:27:31.86 L O G S T A R T
19:27:31.83 DTLEDM172502I Log Scan/Print Utility Initialization in-progress product level V2.4.05 04/22/2014 19:27:31.83 Echo of input from SYSIN...
19:27:31.84 -SEL LOGRBA=CD1FCF19F4713301 RECORDS=EOF 19:27:31.85 End of input from SYSIN...
19:27:42.04 DTLEDM172191I EDMLRDS: LMF will begin transferring data for Log Scan/Print Utility at X'0000000050000000' 19:27:42.14 DTLEDM172146I EDMLRDP: LMF now processing AUSQA.DEV.V1.PRILOG.DS01 for Log Scan/Print Utility
19:27:42.37 Log-rec EDP-UOW=LOGGER00000000500000000000 LogRBA=CD1FCF19F4713301 19:27:42.37 Log-rec EDP-UOW=LOGGER0000000050B400000001 LogRBA=CD1FCF19F472B075 19:27:42.37 Log-rec EDP-UOW=LOGGER00000000523400000003 LogRBA=CD1FCF19F473A691 19:27:42.37 Log-rec EDP-UOW=AUSL 0000000052E800000001 LogRBA=CD1FCF19F4751B0A 19:27:42.37 Beg-pkt EDP-UOW=AUSL 00000000546800000000 LogRBA=CD1FCF19F47644B1 19:27:42.37 ECCR-UOW=AUSPRT01 AUSPRT01 E6D9C2D7D9E3F0F1 008F803000000001 19:27:42.37 Timestamp-19:25:40:11 Date-04/29/2014
19:27:42.37 Timestamp-19:25:40:18 Date-04/29/2014
19:27:42.37 Chg-rec EDP-UOW=AUSL 00000000546800000000 LogRBA=CD1FCF19F47AC50D 19:27:42.37 ECCR-UOW=AUSPRT01 E6D9C2D7D9E3F0F1 008F803000000001 19:27:42.37 Source=VSM Func=ISRT Srcname=VSAMEDM.VSAM.KSDS01 19:27:42.37 Timestamp-19:25:40:36 Date-04/29/2014
19:27:42.37 Chg-rec EDP-UOW=AUSL 00000000546800000000 LogRBA=CD1FCF19F47B2F04 19:27:42.37 ECCR-UOW=AUSPRT01 E6D9C2D7D9E3F0F1 008F803000000001 19:27:42.37 Source=VSM Func=ISRT Srcname=VSAMEDM.VSAM.KSDS01 19:27:42.37 Timestamp-19:25:40:55 Date-04/29/2014
19:27:42.37 Chg-rec EDP-UOW=AUSL 00000000546800000000 LogRBA=CD1FCF19F47B6D63 19:27:42.37 ECCR-UOW=AUSPRT01 E6D9C2D7D9E3F0F1 008F803000000001 19:27:42.37 Source=VSM Func=ISRT Srcname=VSAMEDM.VSAM.KSDS01 19:27:42.37 Timestamp-19:25:40:81 Date-04/29/2014
19:27:42.37 Chg-rec EDP-UOW=AUSL 00000000546800000000 LogRBA=CD1FCF19F47D3D94 19:27:42.37 ECCR-UOW=AUSPRT01 E6D9C2D7D9E3F0F1 008F803000000001 19:27:42.37 Source=VSM Func=ISRT Srcname=VSAMEDM.VSAM.KSDS01 19:27:42.37 Timestamp-19:25:41:03 Date-04/29/2014
19:27:42.37 PH1-pkt EDP-UOW=AUSL 00000000546800000000 LogRBA=CD1FCF19F47D4581 19:27:42.37 ECCR-UOW=AUSPRT01 AUSPRT01 E6D9C2D7D9E3F0F1 008F803000000001 19:27:42.37 Timestamp-19:25:41:39 Date-04/29/2014
19:27:42.37 Com-pkt EDP-UOW=AUSL 00000000546800000000 LogRBA=CD1FCF19F47F0362 19:27:42.37 ECCR-UOW=AUSPRT01 AUSPRT01 E6D9C2D7D9E3F0F1 008F803000000001 19:27:42.37 Timestamp-19:25:41:39 Date-04/29/2014
19:27:42.37 Srv-rec EDP-UOW=AUSPRTF0F14040404040404040 LogRBA=CD1FCF19F47E2049 19:27:42.37 Srv-rec EDP-UOW=AUSPRTF0F14040404040404040 LogRBA=CD1FCF19F48B60C0 19:27:42.37 Log-rec EDP-UOW=AUSL 00000000634900000001 LogRBA=CD1FCF19F48F240A . . . . .
. . . . . . . . . .
19:27:43.63 Beg-pkt EDP-UOW=AUSL 0000001936AD00000000 LogRBA=CD1FCF19F48F8030 19:27:43.63 ECCR-UOW=AUSDB201 01 F0F1000000000001 605FF6E000000000 19:27:43.63 Timestamp-19:27:19:68 Date-05/07/2014
19:27:43.63 Chg-rec EDP-UOW=AUSL 0000001936AD00000000 LogRBA=CD1FCF19F493A0D2 19:27:43.63 ECCR-UOW=01 F0F1000000000001 605FF6E000000000 19:27:43.63 Source=DB2 Func=UPDT Srcname=DB2DSNBtenchar1 19:27:43.63 Timestamp-19:27:19:68 Date-05/07/2014
19:27:43.63 Chg-rec EDP-UOW=AUSL 0000001936AD00000000 LogRBA=CD1FCF19F4950D34 19:27:43.63 ECCR-UOW=01 F0F1000000000001 605FF6E000000000 19:27:43.63 Source=DB2 Func=UPDT Srcname=DB2DSNBtenchar1 19:27:43.63 Timestamp-19:27:19:68 Date-05/07/2014
19:27:43.63 Com-pkt EDP-UOW=AUSL 0000001936AD00000000 LogRBA=CD1FCF19F497F385 19:27:43.63 ECCR-UOW=AUSDB201 01 F0F1000000000001 605FF6E000000000 19:27:43.63 Timestamp-19:27:40:69 Date-05/07/2014
19:27:48.67 DTLEDM172198I EDMLPOPU: LMF table populate tasks are terminating due to an operator stop or PAC termination 19:27:48.70 DTLEDM172195I EDMLUPLU: LMF task for Log Scan/Print Utility is terminating due to an operator stop or PAC termination
19:27:48.73 Totals by Source...
19:27:48.73 VSAMEDM.VSAM.KSDS01 Isrt= 5 Repl= 0 Dlet= 0 Unk= 0 19:27:48.73 VSAMEDM.QA.EDMABC04 Isrt= 0 Repl= 1000 Dlet= 0 Unk= 0 19:27:48.73 VSAMEDM.QA.EDMABC07 Isrt= 1000 Repl= 0 Dlet= 1000 Unk= 0 19:27:48.73 DB2DSNBtenchar1 Isrt= 2 Repl= 2 Dlet= 2 Unk= 0 19:27:48.73 Open Uows...