All the available items evolve with time and use specific tables from the Zetaly database. This section contains all the information relative to these tables and how to populate them. For more information about ZSA and how to configure it, refer to this article.
Due to technical limitations, temporal parameters are only handled at the millisecond level. The query will return a range of results on one millisecond after input time.
Items
Record Type
Job
This item contains information about job executions. One job can produce more than one SMF record.
Table
jobdata
This table is populated directly by SMF 30.
Field
Column
Interval Start
starttime
Interval End
endTime
SID
sid
Job Name
jobname
Job Reader Time
jobrdrtime
Execution Type
exectype
Completion Code
compcode
Reason Code
reasoncode
Instant Msu
instmsu
Dataset
Table
ds_exec
vs_exec
These tables are populated by the LoadViews mechanism. You must use the following LoadViews:
Dataset Job execution
Dataset Vsam Execution
Field
Column ds_exec
Column vs_exec
Dataset Name
ds_name
component_name
SID
sid
Job Name
job_name
job_name
Job Reader Time
job_rdr_time
job_rdr_time
Sms
Table
sms_exec
This table is populated by the LoadViews mechanism. You must use the following LoadViews:
Dataset Sms Execution Data
Field
Column
Dataset Name
ds_name
SID
sid
Job Name
job_name
Job Reader Time
job_rdr_time
Volume Serial
vol_ser
Total Read
tot_read
Write IO
write_io
Catalog
Table
cathist
This table is populated by the LoadViews mechanism. You must use the following LoadViews:
Catalog History
Field
Column
Dataset Name
dsname
SID
sid
Job Name
jobname
Job Reader Time
jobrdrtime
Catalog Name
catalogname
Operation Code
opcode
Function Code
funcode
New Dataset Name
newdsname
Syslog
Table
syslogdata
This table is populated by ZSA using the JES2 Syslog. More information.
Field
Column
Write Time
endTime
SID
sid
Job Name
jobname
ASID
asid
Message Code
msgCode
Message Text
msgText
LPAR Activity
This item contains information about LPAR activity.
Table
msudata
Field
Column
Interval start
startTime
Interval end
endTime
SID
sid
LPAR Name
lparName
Sysplex Name
sysplex
CPC serial number
cecName
Group capacity name
gcName
Total IMSU on period
instMsu
Max IMSU reach
instMsu
R4H
r4hMsu
DC
dcMsu
Number of logical CP
cpCpus
Number of logical SE
seCpus
Total CPU time
totcputime
Total CP time
totcptime
Total SE time
msgText
Number of topologie change
topchanges
Number of Vertical High
vhCpus
Number of Vertical Medium
vmCpus
Number of Vertical Low
vlCpus
Software service Units
swsucount
Wait dispatched count
waitcount
Block dispatched
blkdispcount
TCB dispatched
tcbdispcount
SRB dispatched
srbdispcount
ZSI Samples
CPU
This item contains information about CPU activity. The same data is exposed on ZSI with the dashboard CPU activity sample.
Table
msudata
Field
Column
Start Date
starttime
End Date
endtime
System Name
systemname
CPC Name
cec_name
Type Number
typenum
Model Number
modelnum
Sequence Number
seqnum
SID
sid
Main memory (in mb)
mainmemorymb
CPUs
totalcpus
CP CPUs
totcpcpus
SE CPUs
totsecpus
IFL CPUs
totiflcpus
ICF CPUs
toticfcpus
CPC Capacity
ceccapmsu
Instant MSU
instmsu
SE Time
totsetime
CP Time
totcptime
Record Type
recordtype
Table
DIM_BIFilter
Field
Column
CPC Name
cec_name
SID
sid
Datacenter
datacenter
Entity
entity
Environment
environment
DB2
This item contains information about DB2 activity. The same data is exposed on ZSI with the dashboard DB2 activity sample.
Table
dbahist
Field
Column
Start Date
starttime
End Date
endtime
ID
db2id
Transaction Name
trx
CPC Name
cec_name
SID
sid
Plan Name
planname
Threads
threads
Response Time
resptime
DB2 SE Time
db2setime
DB2 CP Time
db2cptime
Insert rows
insertrows
Delete rows
deleterows
Fetch rows
fetchrows
Updated rows
updatedrows
SQL duration
sqlduration
Transaction count
Table
DIM_BIFilter
Field
Column
CPC Name
cec_name
SID
sid
Datacenter
datacenter
Entity
entity
Environment
environment
CICS
This item contains information about DB2 activity. The same data is exposed on ZSI with the dashboard DB2 activity sample.
