CONVERSION OF STANDARD TABLE FROM R17 TO R18?

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Customer upgrading from R17 to R18. Since the format of the standard table has changed, she'd like us to provide her a job to unload her R17 standard table and then load the data to the R18 standard table like we did for her in the past when she went from R15 to R15. See star issue 20665344.

Environment

Release:
Component: PDT

Resolution

Insert into PTI.PDT_STANDARD_180

(

SSID

, INTERVAL_START

, INTERVAL_END

, RECTYPE

, PLANNAME

, PROGRAM

, PGMTYPE

, COLLID

, CONTOKEN

, VERSION

, SECT#

, STMT#

, SQL_CALL

, COMMITS

, ABORTS

, PGMCNT

, STMTCNT

, PKGE_PLANCNT

, PKGE_STMTCNT

, INDB2_TIME

, INDB2_CPU

, SQL_CALLS

, GETPAGE

, GETPFAIL

, PAGEUPDT

, SYNCREAD

, GETP_RIO

, SPFETCH

, LPFETCH

, DYNPFETCH

, PFPAGES

, IMWRITE

, FETCHED

, INSERTED

, UPDATED

, DELETED

, RID_USED

, RID_FSTG

, RID_FLIM

, RID_OVRFLW

, RID_LIMIT

, JOIN_SWITCH

, JOIN_LMTD

, IX_SKIPPED

, ESCALSHR

, ESCALEXC

, DEADLOCK

, TIMEOUT

, LOCKSUS

, LATCHSUS

, OTHERSUS

, LOCKREQ

, UNLKREQ

, QUERYREQ

, CHANGREQ

, OTHERREQ

, DRAINREQ

, DRAINFAIL

, CLAIMREQ

, CLAIMFAIL

, IOPMAXDEG

, IOPGROUPS

, IOPFAILCUR

, IOPFAILSRT

, IOPFAILBUF

, IOPREDUCED

, IOPPLANNED

, TOTAL_WAITTIM

, IO_WTIME

, LOCK_WTIME

, ORIO_WTIME

, OWIO_WTIME

, SERV_WTIME

, ARCH_WTIME

, TOTAL_WAITCNT

, IOWCNT

, LOCKWCNT

, ORIOWCNT

, OWIOWCNT

, SERVWCNT

, ARCHWCNT

, DRAIN_WTIME

, CLAIM_WTIME

, ARCRD_WTIME

, PLATCH_WTIME

, ARCRDWCNT

, CLAIMWCNT

, DRAINWCNT

, PLATCHWCNT

, SMSG_WTIME

, GLOCK_WTIME

, SMSGWCNT

, GLOCKWCNT

, REOPT

, PSC_MATCH

, PSC_NMATCH

, PSC_IPREP

, PSC_KDPREP

, DYN_PARSED

, DYN_REPLACED

, DYN_MATCHED

, DYN_DUP

, XESLOCKR

, XESCHNGR

, XESUNKLR

, BPGPSYNC

, GLOCKREQ

, GCHNGREQ

, GUNLKREQ

, GIRLMSUS

, GXESSUS

, FALSESUS

, GLOCKFAIL

, PFAILENC

, SPPLANNED

, SPFAILCNO

, SPFAILBUF

, SPFAILRRRS

, ZIIP_CPU

, ZONCP_CPU

, PROC_CPU

, UDF_CPU

, UNACC_TIME

, LOG_WTIME

, LOB_WTIME

, OCS_WTIME

, SLS_WTIME

, DSS_WTIME

, OTS_WTIME

, PLOCK_WTIME

, LLOCK_WTIME

, LOGWCNT

, LOBWCNT

, OCSWCNT

, SLSWCNT

, DSSWCNT

, OTSWCNT

, PLOCKWCNT

, LLOCKWCNT

, GETP_RIO_LONG

, UDF_TOT_CPU

, UDF_DB2_CPU

, UDF_WAIT_TME

, UDF_ELAP_TME

, UDF_ELAP_SQL

, TRIG_NONZIIP

, TRIG_ELAP

, SP_ELAP_TIME

, SP_SQL_ELAP

, TR_NESTED

, TR_NST_ELAP

, ZIIP_TOT_CPU

, ZIIP_DB2_CPU

, ZIIP_TRIG

, ZIIP_SP

, ZIIP_UDF

, ELAP_SP

, NONZIIP_SP

, ELAP_UDF

, NONZIIP_UDF

, SP_Z_TOT_WLM

, SP_Z_DB2_WLM

, UDF_Z_TT_WLM

, UDF_Z_DB_WLM

, TR_NEST_ZIIP

, DYN_USE_COUNT

, DYN_TEXT_TOKEN

, DSGROUP

, DATASTORE

, VCAT

, CONN_TYPE

, CONN_NAME

, CORRID

, LOCATION

, USERID

, END_USER_ID

, TRANSACTION_ID

, WORKSTATION_ID

, SP_TOT_CPU

, SP_TCB_WAIT

, SP_DB2_CPU

, SP_SQL_CNT

, UDF_SQL_CT

-- , AT_WTIME

-- , AT_WCNT

-- , AA_TIME

-- , AA_CNT

, XML_MAX_STG

-- , LATCH_WTIME

-- , LATCHWCNT

)

Select