DATEFORMAT subcommand option
The DATEFORMAT subcommand option changes the format of dates.
Usage
The DATEFORMAT subcommand option is used to change the format of dates specified in the FROM and TO subcommand options, and displayed on OMEGAMON® for DB2® PE reports, traces, and logs.
Format
The DATEFORMAT parameter must be
8 characters long and contain:
- dd
- Day
- mm
- Month
- yy
- Year
Format rules
- You can specify the day, month, and year in any order.
- A single character delimiter is also required in the third and fifth positions.
- You can delimit the day, month, and year with either a slash (⁄), dash (-), period (.), or any combination of these delimiters.
- The DATEFORMAT parameter can be abbreviated to DF.
- If you use FROM or TO, you must specify the dates in exactly the
same format you have defined in the DATEFORMAT parameter. For example,
the following formats are all valid DATEFORMAT definitions:
- yy-mm-dd
- mm/dd-yy
- dd.mm/yy
- If you do not specify the DATEFORMAT parameter in your JCL, dates are displayed in the OMEGAMON for DB2 PE default format, mm/dd/yy.
Sample Accounting JCL with DATEFORMAT subcommand option specified
For example, you might want to display the year before the month and day, separated by a delimiter, on a report. In this case, you would specify yy/mm/dd in the DATEFORMAT parameter.
In the JCL example shown below, DATEFORMAT is used to specify the date format as
yy-mm-dd. The relevant information is highlighted.
//PERFORMANCE EXPERT JOB (INSTALLATION DEPENDENCIES)
//*
//* ==================================================================*
//* DB2 PERFORMANCE EXPERT JCL *
//* ==================================================================*
//*
// PEMAIN EXEC PGM=FPECMAIN,PARM='DATEFORMAT=YY-MM-DD'
//STEPLIB DD DSN=FPE.FPELIB.RKANMOD,DISP=SHR
//INPUTDD DD DSN=FPE.FPELIB.DPMIN,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//JOBSUMDD DD SYSOUT=*
//ACRPTDD DD SYSOUT=*
//SYSIN DD *
⋮
ACCOUNTING
REPORT
FROM (15-05-30,09:45)
TO (15-05-30,09:55)
⋮
EXECAccounting Report - Short
The JCL example shown above produces a report similar to the one shown here. The relevant
information is highlighted.
LOCATION: MYLOC OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P ACCOUNTING REPORT - SHORT REQUESTED FROM: 15-05-30 09:47:00.00
MEMBER: N/P TO: 15-05-30 09:51:00.00
SUBSYSTEM: MYSS ORDER: ENDUSER-WSNAME-TRANSACT INTERVAL FROM: 15-05-30 09:48:43.55
DB2 VERSION: V10 SCOPE: MEMBER TO: 15-05-30 09:50:52.23
ENDUSER #OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
WSNAME #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
TRANSACT #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
--------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
MYNAME 85210 85439 0.50 0.17 0.17 0.002034 1.84 0.01
MYWS 85210 0.00 0.17 0.00 0.002333 0.000264 0.00 0
MYTX1 0 0.17 0.00 0.17 0.000308 3.01 0.00
----------------------------------------------------------------------------------------------------------------
|PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP|
|*ROLLUP* PACKAGE 85210 85210 N/P 0.002034 0.000264 0.001630 1.20|
----------------------------------------------------------------------------------------------------------------
ANOTHER name 1250 1249 0.00 1.96 1.98 0.082652 61.71 0.06
MYWS 1250 0.00 0.00 0.26 0.164474 0.006964 3.22 0
MYtx2 2 1.92 0.00 0.00 0.007150 271.27 10.31
----------------------------------------------------------------------------------------------------------------
|PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP|
|*ROLLUP* PACKAGE 1250 1250 N/P 0.082652 0.006964 0.065359 8.84|
----------------------------------------------------------------------------------------------------------------
ANOTHER name 108170 0 1.00 0.00 0.00 0.022644 8.98 0.11
MYWS 108170 0.00 0.00 0.00 0.031945 0.000567 0.00 0
MyTx3 108206 0.00 0.00 0.00 0.000643 12.95 0.00
----------------------------------------------------------------------------------------------------------------
|PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP|
|*ROLLUP* PACKAGE 108170 108170 N/P 0.022644 0.000567 0.020832 4.08|
----------------------------------------------------------------------------------------------------------------
*** SUB-TOTAL ***
ANOTHER name 109420 1249 0.99 0.02 0.02 0.023330 9.58 0.11
MYWS 109420 0.00 0.00 0.00 0.033459 0.000640 0.04 0
108208 0.02 0.00 0.00 0.000717 15.90 0.12
----------------------------------------------------------------------------------------------------------------
|PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP|
|ALL PROG PACKAGE 109420 109420 N/P 0.023330 0.000640 0.021341 4.14|
----------------------------------------------------------------------------------------------------------------
*** GRAND TOTAL ***
194630 86688 0.78 0.08 0.09 0.014006 6.19 0.06
194630 0.00 0.07 0.00 0.019832 0.000475 0.02 0
108208 0.08 0.00 0.07 0.000538 10.26 0.07
----------------------------------------------------------------------------------------------------------------
|PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP|
|ALL PROG PACKAGE 194630 194630 N/P 0.014006 0.000475 0.012711 2.85|
----------------------------------------------------------------------------------------------------------------