Introduction
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.
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
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
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
This table is populated by the LoadViews mechanism. You must use the following LoadViews:
| 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
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.
| 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.
| 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 |
| 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.
| 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 |
|
| 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.
| Table |
| fact_cics_activity_sample |
| Field |
Column |
| Record Date |
start_time |
| Workload Type |
workload_type |
| Job Name |
job_name |
| CPC Name |
cec_name |
| SID |
sid |
| CICS Name |
cics_name |
| Transaction Name |
transaction_name |
| Program Name |
pgm_name |
| Application Name |
application_name |
| Execution count |
exec_count |
| CPU Time |
cpu_time |
| Average Response Time |
avg_resp_time |
| Average Suspension Time |
avg_susp_time |
| Average Dispatch Time |
avg_disp_time |
| Average Lock Time |
avg_lock_time |
| Average CPU Time |
avg_cpu_time |
| Average RMI Time |
avg_rmi_time |
| Abend count |
abend_count |
| Field |
Column |
| CPC Name |
cec_name |
| SID |
sid |
| Datacenter |
datacenter |
| Entity |
entity |
| Environment |
environment |
