Report Command Reference - DATEFORMAT subcommand option

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® XE 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 XE 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)
|//*
|//* ==================================================================*
|//*	      D B 2  P E R F O R M A N C E  E X P E R T  J C L	      *
|//* ==================================================================*
|//*
|//    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 (10-06-10,09:45)
|      TO   (10-06-10,09:55)
|
·
·
·

|EXEC

Accounting 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 (V5R1)                      PAGE: 1-1
|       GROUP: N/P                                 ACCOUNTING REPORT - SHORT                      REQUESTED FROM: 10-06-10 09:47:00.00
|      MEMBER: N/P                                                                                            TO: 10-06-10 09:51:00.00
|   SUBSYSTEM: MYSS                              ORDER: ENDUSER-WSNAME-TRANSACT                    INTERVAL FROM: 10-06-10 09:48:43.55
| DB2 VERSION: V9                                       SCOPE: MEMBER                                         TO: 10-06-10 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|
|     ----------------------------------------------------------------------------------------------------------------