zOs/SQL/NI5470

set current path = oa1p;
SELECT
-- begin prb insert penc
-- tacct_program p, fsoFmtE7, all, expr ~
      fosFmtE7(p.ELAPSEPKG) "pkgElap"
    , fosFmtE7(p.CPUTCBPKG) "pkgCpu"
    , fosFmtE7(p.CLASS7CPU_ZIIP) "pkgZIIP"
    , fosPrWait(p.ELAPSYNCIO, p.ELPLOCK, p.ELPOTHREAD, p.ELPOTHWRIT
      , p.ELPUNITSW, p.ELPARCQIS, p.ELPDRAIN, p.ELPCLAIM
      , p.ELPARCREAD, p.ELPPGLAT, p.GBLMSGELAP, p.GBLLOKELAP
      , p.SPWAITELAP, p.FUNCWAIT, p.LOBWAITELAP, p.WTELAWTK
      , p.WTELAWTM, p.WTELAWTN, p.WTELAWTO
      , p.WTELAWTQ) "wait    % 1.   % 2.   % 3."
    , fosFmtE7(p.BPGETPAGE) "bpGetPg"
    , fosFmtE7(p.BPPGUPDAT) "bpUpdPg"
    , fosFmtE7(p.BPSYNCRD) "bpSynRe"
    , fosFmtE7(p.SQLCALL) SQLCALL
    , fosFmtE7(p.SQLCOUNT) SQLCOUNT
    , fosFmtE7(p.SELECTS) SELECTS
    , fosFmtE7(p.INSERTS) INSERTS
    , fosFmtE7(p.UPDATES) UPDATES
    , fosFmtE7(p.DELETES) DELETES
    , fosFmtE7(p.DESCRIBES) "describ"
    , fosFmtE7(p.PREPARES) "prepare"
    , fosFmtE7(p.OPENS) OPENS
    , fosFmtE7(p.FETCHES) FETCHES
    , fosFmtE7(p.CLOSES) CLOSES
    , real((p.ELAPSYNCIO + p.ELPLOCK + p.ELPOTHREAD + p.ELPOTHWRIT
      + p.ELPUNITSW + p.ELPARCQIS + p.ELPDRAIN + p.ELPCLAIM
      + p.ELPARCREAD + p.ELPPGLAT + p.GBLMSGELAP + p.GBLLOKELAP
      + p.SPWAITELAP + p.FUNCWAIT + p.LOBWAITELAP + p.WTELAWTK
      + p.WTELAWTM + p.WTELAWTN + p.WTELAWTO + p.WTELAWTQ)) "wait"
    , fosFmtE7(p.OCCURRENCES) OCCURRENCES
    , p.SYSTEMID
    , p.SUBSYSTEM
    , p.PLANNAME
    , p.AUTHID
    , p.CONNECTION
    , p.CORRID
    , p.ORIGPRIMID
    , p.CONNTYPE
    , p.DATETIME
    , p.DATE
    , p.LOCATION
    , p.GROUPNAME
    , p.ENDUSERID
    , p.ENDUSERTX
    , p.ENDUSERWN
    , p.CORRNAME
    , fosFmtE7(p.CLASS7CNT) CLASS7CNT
    , fosFmtE7(p.CLASS8CNT) CLASS8CNT
    , fosFmtE7(p.IFCIDSEQ#) IFCIDSEQ#
    , fosFmtE7(p.CPUSUCONV) CPUSUCONV
    , p.EXECLOCATION
    , p.COLLECTIONID
    , p.PROGRAMNAME
    , p.CONSISTOKEN
    , fosFmtE7(p.ELAPSYNCIO) "syncIOW"
    , fosFmtE7(p.ELPLOCK) ELPLOCK
    , fosFmtE7(p.ELPOTHREAD) "othReaW"
    , fosFmtE7(p.ELPOTHWRIT) "othWriW"
    , fosFmtE7(p.ELPUNITSW) "unitSwW"
    , fosFmtE7(p.ELPARCQIS) "arcLQuW"
    , fosFmtE7(p.ELPDRAIN) "drainW"
    , fosFmtE7(p.ELPCLAIM) "claimW"
    , fosFmtE7(p.ELPARCREAD) "arcLReW"
    , fosFmtE7(p.ELPPGLAT) "pgLatW"
    , fosFmtE7(p.GBLMSGELAP) "glMsgW"
    , fosFmtE7(p.GBLLOKELAP) "glLockW"
    , fosFmtE7(p.SPWAITELAP) "stPrW"
    , fosFmtE7(p.SPROCCNT) SPROCCNT
    , fosFmtE7(p.FUNCWAIT) FUNCWAIT
    , fosFmtE7(p.FUNCCNT) FUNCCNT
    , fosFmtE7(p.LOBWAITELAP) "lobW"
    , fosFmtE7(p.WTELAWTK) "glChiW"
    , fosFmtE7(p.WTELAWTM) "glOthW"
    , fosFmtE7(p.WTELAWTN) "glPrtW"
    , fosFmtE7(p.WTELAWTO) "glPgPhW"
    , fosFmtE7(p.WTELAWTQ) "glOtPhW"
    , fosFmtE7(p.RLFCPULIMITU) RLFCPULIMITU
    , fosFmtE7(p.RLFCPUUSEDU) RLFCPUUSEDU
    , fosFmtE7(p.SUSPLATCH) SUSPLATCH
    , fosFmtE7(p.SUSPOTHER) SUSPOTHER
    , fosFmtE7(p.LOCKREQS) LOCKREQS
    , fosFmtE7(p.UNLOCKREQS) UNLOCKREQS
    , fosFmtE7(p.QUERYREQS) QUERYREQS
    , fosFmtE7(p.CHNGREQS) CHNGREQS
    , fosFmtE7(p.IRLMREQS) IRLMREQS
    , fosFmtE7(p.CLAIMREQ) CLAIMREQ
    , fosFmtE7(p.DRAINREQ) DRAINREQ
    , p.LOADTS
-- end   prb insert penc
    FROM PBXX.TACCT_PROGRAM p
    WHERE PLANNAME = 'NI5470'
    AND DATETIME BETWEEN '2014-08-22-02.00.00.00'
                     and '2014-08-22-03.50.00.00'
    with ur