DB2 11 for z/OS and Omegamon batch reporting

Daniel Luksetich

DB2 11 for z/OS and Omegamon batch reporting
Folks,

I am running a process where I use the sysproc.wlm_set_clent_info stored
procedure to set the client end user, transaction, and workstation
accounting fields. When I run an Omegamon batch accounting report I see the
fields I am setting. For example when I set the end user to DAN I see this
in the accounting report



ENDUSER: 'DAN'



Now, if I try adding a filter to the report options, such as



INCLUDE (ENDUSER(DAN))

Or

INCLUDE (ENDUSER('DAN'))



I get nothing. So, either I'm specifying it wrong or it is just not working.
I have found no examples in the manuals, or on the internet.



Any thoughts?



Thanks,

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator - DB2 11 DBA for z/OS

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Application Developer - DB2 11 for z/OS

IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and
Windows



Venkat Srinivasan

RE: DB2 11 for z/OS and Omegamon batch reporting
(in response to Daniel Luksetich)

REDUCE 

 INCLUDE (ENDUSER(DAN))

 REPORT

Daniel Luksetich

DB2 11 for z/OS and Omegamon batch reporting
(in response to Venkat Srinivasan)
Did not work



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: Venkat Srinivasan <[login to unmask email]>
Sent: Thursday, June 7, 2018 10:42 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11 for z/OS and Omegamon batch reporting



REDUCE

INCLUDE (ENDUSER(DAN))

REPORT



-----End Original Message-----

Jorg Lueke

RE: DB2 11 for z/OS and Omegamon batch reporting
(in response to Daniel Luksetich)

It appears to me that ENDUSER is not a valid option for INCLUDE, see https://www.ibm.com/support/knowledgecenter/SSUSPA_5.3.0/com.ibm.omegamon.xe.pm_db2.doc_5.3.0/ko2rc/ko2rcd1085.htm

Daniel Luksetich

DB2 11 for z/OS and Omegamon batch reporting
(in response to Jorg Lueke)
Thanks! I missed that.

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: Jorg Lueke <[login to unmask email]>
Sent: Thursday, June 7, 2018 11:06 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11 for z/OS and Omegamon batch reporting



It appears to me that ENDUSER is not a valid option for INCLUDE, see https://www.ibm.com/support/knowledgecenter/SSUSPA_5.3.0/com.ibm.omegamon.xe.pm_db2.doc_5.3.0/ko2rc/ko2rcd1085.htm



-----End Original Message-----