1 J E S 2 J O B L O G -- S Y S T E M M V S E -- N O D E G N O 1 0 N J E
0
10.00.03 JOB26462 ---- MONDAY, 13 DEC 2021 ----
10.00.03 JOB26462 IRR010I USERID XCA1039 IS ASSIGNED TO THIS JOB.
10.00.10 JOB26462 ICH70001I XCA1039 LAST ACCESS AT 09:56:58 ON MONDAY, DECEMBER 13, 2021
10.00.10 JOB26462 $HASP373 XCA1039Q STARTED - WLM INIT - SRVCLASS BATCH - SYS MVSE
10.00.10 JOB26462 IEF403I XCA1039Q - STARTED - TIME=10.00.10
10.01.07 JOB26462 FID003I XCA1039Q LGVWRUN ENDED WITH 0000
10.01.07 JOB26462 IEF404I XCA1039Q - ENDED - TIME=10.01.07
10.01.07 JOB26462 $HASP395 XCA1039Q ENDED - RC=0000
0------ JES2 JOB STATISTICS ------
- 13 DEC 2021 JOB EXECUTION DATE
- 33 CARDS READ
- 293 SYSOUT PRINT RECORDS
- 0 SYSOUT PUNCH RECORDS
- 21 SYSOUT SPOOL KBYTES
- 0.93 MINUTES EXECUTION TIME
1 //XCA1039Q JOB SY832,'SYTBSS',CLASS=M,REGION=3M,PRTY=6,TIME=1440, JOB26462
// MSGLEVEL=(1,1),MSGCLASS=H,NOTIFY=XCA1039
2 /*JOBPARM S=MVSE
//* ----------------------------------------------------------------- *
//* ||| NOTE ||| *
//* *
//* Please enter the following edit primary command: *
//* *
//* C <LOADLIB> YOUR-PRODUCT-LOAD-LIB *
//* *
//* Then add from 1 to n Db2 Archive Log datasets to the LOG DD card *
//* and then submit the job. *
//* *
//* The Db2 Archive Logs typically have name like: *
//* *
//* <hlq>.ARCHLOG1.D<Julian Date>.T<Time>.Annnnnnn *
//* *
//* Please note that the boot strap datasets are not valid input: *
//* *
//* <hlq>.ARCHLOG1.D<Julian Date>.T<Time>.Bnnnnnnn *
//* *
//* *
//* ||| NOTE ||| *
//* ----------------------------------------------------------------- *
3 //LGVWRUN EXEC PGM=LGVW0000,REGION=32M,PARM='N'
4 //STEPLIB DD DISP=SHR,DSN=SCD.PCK0356.A.LOAD
5 //LOG DD DISP=SHR,DSN=SCD.DB2Q000.D.PRI.ARCHLOG.A0193161
6 // DD DISP=SHR,DSN=SCD.DB2Q000.D.PRI.ARCHLOG.A0193162
7 // DD DISP=SHR,DSN=SCD.DB2Q000.D.PRI.ARCHLOG.A0193163
8 //SYSPRINT DD SYSOUT=*
9 //SYSOUT DD SYSOUT=*
10 //CEEDUMP DD SYSOUT=*
11 //SYSUDUMP DD SYSOUT=*
ICH70001I XCA1039 LAST ACCESS AT 09:56:58 ON MONDAY, DECEMBER 13, 2021
IEF043I Actions taken by SMFLIMxx parmlib policy for XCA1039Q LGVWRUN
Step system reserved below set to 256K by policy - SMFLIM00 0001
Step system reserved above set to 24M by policy - SMFLIM00 0001
IEFA111I XCA1039Q IS USING THE FOLLOWING JOB RELATED SETTINGS:
SWA=BELOW,TIOT SIZE=64K,DSENQSHR=DISALLOW,GDGBIAS=JOB
IEF236I ALLOC. FOR XCA1039Q LGVWRUN
IGD103I SMS ALLOCATED TO DDNAME STEPLIB
IGD103I SMS ALLOCATED TO DDNAME LOG
IGD103I SMS ALLOCATED TO DDNAME
IGD103I SMS ALLOCATED TO DDNAME
IEF237I JES2 ALLOCATED TO SYSPRINT
IEF237I JES2 ALLOCATED TO SYSOUT
IEF237I JES2 ALLOCATED TO CEEDUMP
IEF237I JES2 ALLOCATED TO SYSUDUMP
IEF142I XCA1039Q LGVWRUN - STEP WAS EXECUTED - COND CODE 0000
IGD104I SCD.PCK0356.A.LOAD RETAINED, DDNAME=STEPLIB
IGD104I SCD.DB2Q000.D.PRI.ARCHLOG.A0193161 RETAINED, DDNAME=LOG
IGD104I SCD.DB2Q000.D.PRI.ARCHLOG.A0193162 RETAINED, DDNAME=
IGD104I SCD.DB2Q000.D.PRI.ARCHLOG.A0193163 RETAINED, DDNAME=
IEF285I XCA1039.XCA1039Q.JOB26462.D0000101.? SYSOUT
IEF285I XCA1039.XCA1039Q.JOB26462.D0000102.? SYSOUT
IEF285I XCA1039.XCA1039Q.JOB26462.D0000103.? SYSOUT
IEF285I XCA1039.XCA1039Q.JOB26462.D0000104.? SYSOUT
====================================================================================================================================
PGM=LGVW0000 USER-RGN=3072K PRV+SYS=464K PAGES-IN= PAGES-OUT= SWAPS=
SRV=723071 CSU=717667 SRB=5404 I/O= MSO= SWAP-SET=
RGB=8168K ERG=1268736K ARB=332K EAR=9892K URB=132K EUR=6024K
DD-NAME DEV# EXCP'S DD-NAME DEV# EXCP'S DD-NAME DEV# EXCP'S DD-NAME DEV# EXCP'S DD-NAME DEV# EXCP'S
STEPLIB 2928 62 LOG 2889 1145 LOG 2960 1146 LOG 2A60 1146 LOG 2887 1145
LOG 2860 2833 LOG 2960 2833 LOG 2A60 2833 LOG 2887 2832 LOG 2889 5779
LOG 2960 5778 LOG 2A60 5779 LOG 2887 5779
------------------------------------------------------------------------------------------------------------------------------------
zIIP: 0 HR 00 MIN 00.00 SEC zICP: 0 HR 00 MIN 00.00 SEC
IEF373I STEP/LGVWRUN /START 2021347.1000
IEF032I STEP/LGVWRUN /STOP 2021347.1001
CPU: 0 HR 00 MIN 10.63 SEC SRB: 0 HR 00 MIN 00.08 SEC
VIRT: 132K SYS: 332K EXT: 6024K SYS: 9892K
ATB- REAL: 4164K SLOTS: 0K
VIRT- ALLOC: 15M SHRD: 0M
====================================================================================================================================
JOB=XCA1039Q USER-RGN=3072K PRV+SYS=464K PAGES-IN= PAGES-OUT= SWAPS=
SRV=723071 CSU=717667 SRB=5404 I/O= MSO= SWAP-SET=
RGB=8168K ERG=1268736K ARB=332K EAR=9892K URB=132K EUR=6024K
DD-NAME DEV# EXCP'S DD-NAME DEV# EXCP'S DD-NAME DEV# EXCP'S DD-NAME DEV# EXCP'S DD-NAME DEV# EXCP'S
STEPLIB 2928 62 LOG 2889 1145 LOG 2960 1146 LOG 2A60 1146 LOG 2887 1145
LOG 2860 2833 LOG 2960 2833 LOG 2A60 2833 LOG 2887 2832 LOG 2889 5779
LOG 2960 5778 LOG 2A60 5779 LOG 2887 5779
------------------------------------------------------------------------------------------------------------------------------------
zIIP: 0 HR 00 MIN 00.00 SEC zICP: 0 HR 00 MIN 00.00 SEC
IEF375I JOB/XCA1039Q/START 2021347.1000
IEF033I JOB/XCA1039Q/STOP 2021347.1001
CPU: 0 HR 00 MIN 10.63 SEC SRB: 0 HR 00 MIN 00.08 SEC
Happy Holidays|
|
Db2 + ' +
Archive -- (*) --
Log >*<
Viewer >0<น<
>>>น<<*
>น>*<0<<<
>*>>น<<<น<<
>น>>0<<<*<<น<
>*>>0<<น<<<น<<<
>น>>*<<น<>*<<0<*<
>0>>*<<น<>0><<*<น<<
>*>>น><0<<*>>น><*<0<<
>น>>0<*<0>>น<<0<<<*<น<<
>((*))_>0><*<0><น<<<0<*<<
>*น*.*0*.*>>น<<*<<น>><0<*<<
>*.*น*.*.*._''DD''_.*.*น*.*<<
>*.*0.*.*0**| 'bb' |**น*.*0*.*<
^^^^^^^^^^^^| 22 |^^^^^^^^^^^
|__XX__|
|XXXXXX|
""""""""
-------------------------------------------
Db2 Archive Log Viewer V1.0 started at 2021-12-13-10.00.19
Log physical records read : 1M
Log logical records read : 11M
Details Count Len
Type 0002 Page Set Control Record
Pageset open record : 1K 442K
Dataset open record : 1K 201K
Pageset close record : 1K 132K
Dataset close record : 790 95K
CTL checkpoint : 22K 5M
SETW record : 0 0
Write I/O record : 154K 58M
RSTW record : 0 0
SES dependency record : 1K 213K
Unknown Subtype : 0 0
Type 0004 SYSCOPY utility
DSNDB01.DBD01 : 1 288
DSNDB01.SYSDBDXA : 1 288
DSNDB01.SYSUTILX : 1 288
DSNDB06.SYSTSCPY : 1 288
Unknown PSID : 0 0
Type 0008 Non-UR related lock : 342 59K
Type 0010 System Event Record
Begin checkpoint record : 45 9K
End checkpoint record : 44 6K
Begin current status rebuild : 0 0
Begin historic status rebuild : 0 0
Begin active UR backout : 0 0
No log activity : 125 9K
Retained lock purge by operator : 0 0
Command : 5K 2M
Unknown Subtype : 57 4K
Type 0020 UR Control Record
Begin UR record : 499K 90M
Begin COMMIT phase 1 : 469K 67M
End COMMIT phase 1 : 29K 4M
Begin COMMIT phase 2 : 29K 2M
Phase 1 to 2 transition : 469K 43M
End COMMIT phase 2 : 499K 45M
Begin abort record : 2 188
End abort record : 2 188
End UNDO record : 0 0
End TODO record : 0 0
End REDO record : 0 0
Unknown Subtype : 0 0
Type 0100 Checkpoint Record : 29K 7M
Type 0200 UR-UNDO Record
Update data page : 2M 1G
Format page or update space map : 0 0
Update space map bits : 394K 49M
Update to index space map : 0 0
Update to index page : 0 0
DBA table update : 0 0
Checkpoint DBA table : 0 0
Soft-log a CUB position : 0 0
DBD virtual memory copy : 11K 1M
Excl. lock on pgset part or DBD : 0 0
Format file page set : 0 0
Format index page set : 0 0
Invalidate object. CTDB,PSCB,CUB : 11 1K
Update by repair (first half 32k): 0 0
Update by repair (secnd half 32k): 0 0
Allocate/Deallocate a segm entry : 2K 334K
Modified page/Formatted page : 0 0
Lock ptr if overflow updated : 25K 3M
Savepoint : 422K 36M
Other recs for RMID 14 : 3 4K
Checkpoint record of mod. pgset : 0 0
Type 2 index update : 5M 1G
Type 2 index undo/redo : 0 0
Type 2 index change notification : 0 0
Type 2 index space map update : 0 0
DBET : 151K 55M
DBET with LPL/GRECP : 0 0
LOB manager format smap : 0 0
LOB manager change high smap : 4K 539K
LOB manager change low smap : 0 0
LOB manager alloc/dealloc smap : 28K 4M
LOB manager change smap : 0 0
LOB manager change data page : 0 0
LOB manager change system page : 0 0
Reformat data page : 0 0
DBET diagnostic : 0 0
Batch format data pages : 0 0
Update smaps modify bit : 0 0
CLR diagnostic : 0 0
CDC diagnostic : 0 0
Diagnostic dsnismcp : 35K 4M
Diagnostic pipe : 0 0
System page dummy compensation : 0 0
Index dummy compensation : 68K 8M
Start database access(force) : 0 0
ALTER TABLE : 0 0
End of savepoint : 178 19K
Special begin trunc immediate : 0 0
Special commit trunc immediate : 0 0
Non-documented subtype x'87' : 0 0
Unknown Subtype : 0 0
Type 0400 UR-REDO Record
Update data page : 2M 1G
Format page or update space map : 33K 5M
Update space map bits : 575K 71M
Update to index space map : 33K 3M
Update to index page : 0 0
DBA table update : 0 0
Checkpoint DBA table : 0 0
Soft-log a CUB position : 0 0
DBD virtual memory copy : 0 0
Excl. lock on pgset part or DBD : 1 122
Format file page set : 0 0
Format index page set : 0 0
Invalidate object. CTDB,PSCB,CUB : 0 0
Update by repair (first half 32k): 0 0
Update by repair (secnd half 32k): 0 0
Allocate/Deallocate a segm entry : 3K 433K
Modified page/Formatted page : 0 0
Lock ptr if overflow updated : 25K 3M
Savepoint : 0 0
Other recs for RMID 14 : 301 254K
Checkpoint record of mod. pgset : 0 0
Type 2 index update : 5M 1G
Type 2 index undo/redo : 0 0
Type 2 index change notification : 0 0
Type 2 index space map update : 0 0
DBET : 151K 55M
DBET with LPL/GRECP : 720 144K
LOB manager format smap : 31 5K
LOB manager change high smap : 4K 539K
LOB manager change low smap : 0 0
LOB manager alloc/dealloc smap : 28K 4M
LOB manager change smap : 22K 4M
LOB manager change data page : 66K 119M
LOB manager change system page : 0 0
Reformat data page : 0 0
DBET diagnostic : 0 0
Batch format data pages : 0 0
Update smaps modify bit : 0 0
CLR diagnostic : 0 0
CDC diagnostic : 0 0
Diagnostic dsnismcp : 35K 4M
Diagnostic pipe : 0 0
System page dummy compensation : 0 0
Index dummy compensation : 0 0
Start database access(force) : 0 0
ALTER TABLE : 58 9K
End of savepoint : 0 0
Special begin trunc immediate : 0 0
Special commit trunc immediate : 0 0
Non-documented subtype x'87' : 0 0
Unknown Subtype : 0 0
Type 0800 Archive quiesce Record : 2 611
Type 1000 Resource MGR assigned 1 : 2K 674K
Type 2000 Resource MGR assigned 2 : 578K 93M
Type 4000 Resource MGR assigned 3 : 131K 16M
Type 8000 Resource MGR assigned 4 : 0 0
Unknown Record Type : 0 0
Db2 Archive Log Viewer ended at 2021-12-13-10.01.07
Db2 Archive Log Viewer with RC : 0