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 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: * //* * //* .ARCHLOG1.D.T.Annnnnnn * //* * //* Please note that the boot strap datasets are not valid input: * //* * //* .ARCHLOG1.D.T.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