APPLICATION: DB2 A 06.05.02
Status : A Description : DB2 Maintenance Type : A Calendar : DEFAULT Valid : 06.05.02 - 31.12.71 Priority : 5 Owner : HORIZONT Ownertext : Auth. Group : Group Definition : Last update user : P391T Last update date : 25.03.09 Last update time : 11:35
RUN CYCLES
Period Offset Start End End F T In Out Of
Time Day Time Effect Effect
|
WEEK +001 06:00 00 09:00 2 N 06.05.02 31.12.71 |
| F=free day rule (1=before free day, 2=after free day, 3=on free day, 4=not on free day, E=only work days), T=Type (N=normal, X=negative R=rule E=exclusive |
RUN DAYS
July 2009 |
August 2009 |
September 2009 |
Mo Tu We Th Fr Sa Su |
Mo Tu We Th Fr Sa Su |
Mo Tu We Th Fr Sa Su |
06
13
20
27
|
03 10 17 24 31 |
07
14
21
28
|
October 2009 |
November 2009 |
December 2009 |
Mo Tu We Th Fr Sa Su |
Mo Tu We Th Fr Sa Su |
Mo Tu We Th Fr Sa Su |
05
12
19
26
|
02 09 16 23 30 |
07
14
21
28
|
January 2010 |
February 2010 |
March 2010 |
Mo Tu We Th Fr Sa Su |
Mo Tu We Th Fr Sa Su |
Mo Tu We Th Fr Sa Su |
04
11
18
25
|
01
08
15
22
|
01
08
15
22
29
|
April 2010 |
May 2010 |
June 2010 |
Mo Tu We Th Fr Sa Su |
Mo Tu We Th Fr Sa Su |
Mo Tu We Th Fr Sa Su |
05
12
19
26
|
03 10 17 24 31 |
07
14
21
28
|
OPERATION TEXT
Operation WS No Operation Text |
DMY 001
TIME 002 07:00
STOP DMY 003 manuell (if WS=INP)
DB2MODIF CPU 005 MODIFY RECOVERY TABLESP.
DB2STOP STC 010 Stop DB2
DB2WAIT CPU 020 Wait for DB2-End
DB2DEL CPU 030 Delete Archlogs
DB2START STC 040 Start DB2
DB2WAIT CPU 050 Wait for DB2-Start
DMY 255
|
OPERATION DETAILS
Operation WS No R1 R2 S R L E T ID IT DD DT HRC |
DMY 001 00 00 Y Y N Y N
TIME 002 00 00 Y Y N Y Y 00 07:00
STOP DMY 003 00 00 Y Y N Y N
DB2MODIF CPU 005 00 00 Y Y N Y N 0008
DB2STOP STC 010 00 00 Y Y N Y N
DB2WAIT CPU 020 00 00 Y Y N Y N
DB2DEL CPU 030 00 00 Y Y N Y N 0008
DB2START STC 040 00 00 Y Y N Y N
DB2WAIT CPU 050 00 00 Y Y N Y N
DMY 255 00 00 Y Y N Y N
|
| S=submit, R=release, L=suppress if late, E=error tracking, T=time dependent, ID/IT=IA day/time, HRC=highest return code, DD/DT=Deadline day/time |
PREDECESSOR
Operation WS No Predecessor WS No Application Status Valid from |
DMY 001 DMY 255 DB2 A 06.05.02
TIME 002 DMY 001
STOP DMY 003 TIME 002
DB2MODIF CPU 005 DMY 001
TIME 002
STOP DMY 003
DB2STOP STC 010 DB2MODIF CPU 005
DB2WAIT CPU 020 DB2STOP STC 010
DB2DEL CPU 030 DB2WAIT CPU 020
DB2START STC 040 DB2DEL CPU 030
DB2WAIT CPU 050 DB2START STC 040
DMY 255 DB2WAIT CPU 050
|
SUCCESSOR
Operation WS No Successor WS No Application Status Valid from |
DMY 001 TIME 002
DB2MODIF CPU 005
TIME 002 STOP DMY 003
DB2MODIF CPU 005
STOP DMY 003 DB2MODIF CPU 005
DB2MODIF CPU 005 DB2STOP STC 010
DB2STOP STC 010 DB2WAIT CPU 020
DB2WAIT CPU 020 DB2DEL CPU 030
DB2DEL CPU 030 DB2START STC 040
DB2START STC 040 DB2WAIT CPU 050
DB2WAIT CPU 050 DMY 255
DMY 255 DMY 001 XINFODB2DEMO A 28.01.04
|
JCL STOP Member not found
JCL DATASET TABLE DB2MODIF
PGM Step DD Disp Dsn |
IKJEFT1B ARCHLOG SYSTSPRT
SYSUDUMP
SYSDBOUT
SYSOUT
SYSPRINT
SYSTSIN
XXRIWT1 GETTS STEPLIB SKK SYSH.XINFO.V3R3.LOAD
SYSPRINT
SYSOUT
CEEDUMP
PARMIN
WTRESO NPD &&MODIFY
SYSIN
IDCAMS REPRO IN SPK &&MODIFY
OUT
SYSPRINT
SYSIN
UTIL SYSIN SPK &&MODIFY
SYSIN
|
JCL LIBRARY MEMBER DB2MODIF
//DB2MODIF JOB ,'HORIZONT',MSGCLASS=T,
// NOTIFY=&SYSUID
//*
//* ARCHIVE ACTIVE LOG
//ARCHLOG EXEC PGM=IKJEFT1B,REGION=6M
//SYSTSPRT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSDBOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN1)
-ARCHIVE LOG
//*
//* GET LIST OF MODIFIED TABLESPACES
//*
//GETTS EXEC PGM=XXRIWT1,REGION=6M,
// PARM='HEAP(1M,256K)/'
//STEPLIB DD DSN=SYSH.XINFO.V3R3.LOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//CEEDUMP DD SYSOUT=*
//PARMIN DD *
RAWDATA=Y
ONLYDATA=Y
USEDSPL=N
DB2SSID=DSN1
PLAN=XXRDLG33
//WTRESO DD DSN=&&MODIFY,
// SPACE=(TRK,(10,10),RLSE),
// UNIT=VIO,
// DCB=(RECFM=FB,LRECL=80),
// DISP=(NEW,PASS)
//SYSIN DD *
SELECT DISTINCT 'MODIFY RECOVERY TABLESPACE ' !!
STRIP(DBNAME,T)!!'.'!!
TSNAME!! ' DELETE AGE(10)'
FROM SYSIBM.SYSCOPY
WHERE DBNAME LIKE 'DXXR%'
//REPRO EXEC PGM=IDCAMS
//IN DD DISP=(SHR,PASS),DSN=&&MODIFY
//OUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
REPRO INFILE (IN) OUTFILE (OUT)
//*
//UTIL EXEC DSNUPROC,SYSTEM=DSN1,UID='P390M',UTPROC=''
//DSNUPROC.SYSIN DD DISP=(SHR,PASS),DSN=&&MODIFY
//
//
//
MODIFY RECOVERY TABLESPACE DXINFOP.XXRS5JN DELETE AGE(10)
JCL WITH PROCEDURES DB2MODIF
//DB2MODIF JOB ,'HORIZONT',MSGCLASS=T,
// NOTIFY=&SYSUID
//*
//* ARCHIVE ACTIVE LOG
//ARCHLOG EXEC PGM=IKJEFT1B,REGION=6M
//SYSTSPRT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSDBOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN1)
-ARCHIVE LOG
//*
//* GET LIST OF MODIFIED TABLESPACES
//*
//GETTS EXEC PGM=XXRIWT1,REGION=6M,
// PARM='HEAP(1M,256K)/'
//STEPLIB DD DSN=SYSH.XINFO.V3R3.LOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//CEEDUMP DD SYSOUT=*
//PARMIN DD *
RAWDATA=Y
ONLYDATA=Y
USEDSPL=N
DB2SSID=DSN1
PLAN=XXRDLG33
//WTRESO DD DSN=&&MODIFY,
// SPACE=(TRK,(10,10),RLSE),
// UNIT=VIO,
// DCB=(RECFM=FB,LRECL=80),
// DISP=(NEW,PASS)
//SYSIN DD *
SELECT DISTINCT 'MODIFY RECOVERY TABLESPACE ' !!
STRIP(DBNAME,T)!!'.'!!
TSNAME!! ' DELETE AGE(10)'
FROM SYSIBM.SYSCOPY
WHERE DBNAME LIKE 'DXXR%'
//REPRO EXEC PGM=IDCAMS
//IN DD DISP=(SHR,PASS),DSN=&&MODIFY
//OUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
REPRO INFILE (IN) OUTFILE (OUT)
//*
//UTIL EXEC DSNUPROC,SYSTEM=DSN1,UID='P390M',UTPROC=''
//DSNUPROC.SYSIN DD DISP=(SHR,PASS),DSN=&&MODIFY
//
//
//
//SYSIN DD *
MODIFY RECOVERY TABLESPACE DXINFOP.XXRS5JN DELETE AGE(10)
JCL DATASET TABLE DB2STOP
PGM Step DD Disp Dsn |
JCL LIBRARY MEMBER DB2STOP
//DB2STOP PROC //* //DUMMY EXEC PGM=IEFBR14 //* // COMMAND '-STO DB2' //*
JCL DATASET TABLE DB2WAIT
PGM Step DD Disp Dsn |
ROTIWAIT WAIT STEPLIB SKK P390A.ROSE.LOAD23 |
JCL LIBRARY MEMBER DB2WAIT
//DB2WAIT JOB CLASS=A,MSGCLASS=T,REGION=5M //* //* WAIT FOR DB2-END //* //WAIT EXEC PGM=ROTIWAIT,PARM='/180000' WAIT 3 MIN. //STEPLIB DD DISP=SHR,DSN=P390A.ROSE.LOAD23 //*
JCL DATASET TABLE DB2DEL
PGM Step DD Disp Dsn |
IEFBR14 STEP1 ENQ OKK DSNCAT.BSDS01
IDCAMS DEL SYSPRINT
SYSIN
|
JCL LIBRARY MEMBER DB2DEL
//DB2DEL JOB CLASS=A,MSGCLASS=T
//*
//* DELETE DB2 ARCHIVE LOGS
//*
//STEP1 EXEC PGM=IEFBR14
//ENQ DD DSN=DSNCAT.BSDS01,DISP=OLD WAITING FOR DSN IF DB2 IS NOT
//* ENDED
//DEL EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DELETE DSNCAT.ARCHLOG1.*
DELETE DSNCAT.ARCHLOG2.*
DELETE DSNCAT6.ARCHLOG1.*
DELETE DSNCAT6.ARCHLOG2.*
JCL DATASET TABLE DB2START
PGM Step DD Disp Dsn |
JCL LIBRARY MEMBER DB2START
//DB2START PROC //* //DUMMY EXEC PGM=IEFBR14 //* // COMMAND '-STA DB2' //*
JCL DATASET TABLE DB2WAIT
PGM Step DD Disp Dsn |
ROTIWAIT WAIT STEPLIB SKK P390A.ROSE.LOAD23 |
JCL LIBRARY MEMBER DB2WAIT
//DB2WAIT JOB CLASS=A,MSGCLASS=T,REGION=5M //* //* WAIT FOR DB2-END //* //WAIT EXEC PGM=ROTIWAIT,PARM='/180000' WAIT 3 MIN. //STEPLIB DD DISP=SHR,DSN=P390A.ROSE.LOAD23 //*
OPERATOR INSTRUCTIONS
OI not found