DB2 utilities

Mohamed Esmael

DB2 utilities

Hello 

Is there way to list all DB2 Utilities that used on system on Z/os ?

Roy Boxwell

DB2 utilities
(in response to Mohamed Esmael)
Not that I am aware of within Db2! Some leave traces, like REORG and COPY, in the SYSCOPY or STATSTIME column on loads of tables hints about the last time a RUNSTATS was run. Some would leave fingerprints in the LOG, REPAIR etc., but some work offline ,dsn1copy etc., which, by definition, leave zilch in Db2. However a good audit system based on an external security product like ACF2/RACF/TOPSECRET can log all program usage including dsnutilb and all the offline ones.

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Bettina Schubert

On 9 Aug 2017, at 08:17, Mohamed Esmael <[login to unmask email]<mailto:[login to unmask email]>> wrote:


Hello

Is there way to list all DB2 Utilities that used on system on Z/os ?

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

Charles Brown

DB2 utilities
(in response to Roy Boxwell)
-DIS UTIL(*)
The above command should display all IBM supplied utilities, their IDs and their statuses within that subsystem.

Mind you, I underscored IBM because there could be 3rd party products utilities running that are outside the scope of this db2 command. Meaning this command will not list them. They go stealth within the scope of this command

Hope this helps

Charles/b
NZ and InfoSphere DBA

Sent from my iPhone

> On Aug 9, 2017, at 1:43 AM, Boxwell, Roy <[login to unmask email]> wrote:
>
> Not that I am aware of within Db2! Some leave traces, like REORG and COPY, in the SYSCOPY or STATSTIME column on loads of tables hints about the last time a RUNSTATS was run. Some would leave fingerprints in the LOG, REPAIR etc., but some work offline ,dsn1copy etc., which, by definition, leave zilch in Db2. However a good audit system based on an external security product like ACF2/RACF/TOPSECRET can log all program usage including dsnutilb and all the offline ones.
>
> Roy Boxwell
> SOFTWARE ENGINEERING GmbH and SEGUS Inc.
> -Product Development-
> Heinrichstrasse 83-85
> 40239 Düsseldorf/Germany
> Tel. +49 (0)211 96149-675
> Fax +49 (0)211 96149-32
> Email: [login to unmask email]
> http://www.seg.de
>
> Software Engineering GmbH
> Amtsgericht Düsseldorf, HRB 37894
> Geschäftsführung: Gerhard Schubert, Bettina Schubert
>
> On 9 Aug 2017, at 08:17, Mohamed Esmael <[login to unmask email]> wrote:
>
>> Hello
>>
>> Is there way to list all DB2 Utilities that used on system on Z/os ?
>>
>>
>> -----End Original Message-----
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
> ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
> ttp://www.ESAIGroup.com/idug
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Isaac Yassin

DB2 utilities
(in response to Mohamed Esmael)
Use Diagnose disply available utility

Isaac Yassin
Sent from my Galaxy Note 5

בתאריך 9 באוג׳ 2017 09:17,‏ "Mohamed Esmael" <[login to unmask email]> כתב:

> Hello
>
> Is there way to list all DB2 Utilities that used on system on Z/os ?
>
> -----End Original Message-----
>

Mohamed Esmael

RE: DB2 utilities
(in response to Charles Brown)

Hello Charles 

thanks you for your reply can this command list all utilities that are in use / not used on DB2 subsystem and how can i run it 

thanks in advance 

Mohamed Esmael

RE: DB2 utilities
(in response to Isaac Yassin)

Dear issac 

from where 

Isaac Yassin

DB2 utilities
(in response to Mohamed Esmael)
Utility.
Look at utility guide foer diagnose

Isaac Yassin
Sent from my Galaxy Note 5

בתאריך 9 באוג׳ 2017 15:41,‏ "Mohamed Esmael" <[login to unmask email]> כתב:

> Dear issac
>
> from where
>
> -----End Original Message-----
>

Philip Sevetson

DB2 utilities
(in response to Mohamed Esmael)
**please note my email address change**
M. Esmael,

You want to read the instructions on how to execute a DB2 Command in the “DB2 Command Reference”.

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Mohamed Esmael [mailto:[login to unmask email]
Sent: Wednesday, August 09, 2017 8:42 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 utilities


Dear issac

from where

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Ruediger Kurtz

AW: DB2 utilities
(in response to Mohamed Esmael)
Mohamed,

from what I can gather from your question: If a utility is not currently running you *cannot* display anything from / about it. You might gather some information about previous runs, but only to a certain extent.

I may be totally wrong but the gist of your question runs as follows: What are the utilities that *can* be run on a z/OS subsystem.
If this is what you are basically asking – the answer’s pretty straightforward: All utilities you paid for.

By the way, what is the reason for you asking that particular question? Perhaps that might make it easier for us to understand what you really want.

Rüdiger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Mohamed Esmael [mailto:[login to unmask email]
Gesendet: Mittwoch, 9. August 2017 14:41
An: [login to unmask email]
Betreff: [DB2-L] - RE: DB2 utilities


Hello Charles

thanks you for your reply can this command list all utilities that are in use / not used on DB2 subsystem and how can i run it

thanks in advance

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

Mohamed Esmael

RE: AW: DB2 utilities
(in response to Ruediger Kurtz)

Dear Ruediger 

i want to make  statistics about all utilities (Paid /Free) that run by users  as when i try to retrieve  from Catalog Tables just few utilities appears not all like UNLOAD utility  

Steen Rasmussen

AW: DB2 utilities
(in response to Mohamed Esmael)
Mohamed, some of the IBM DB2 utilities can be viewed from SYSCOPY since REORG, MODIFY, LOAD etc. are recorded. Others are not like UNLOAD. You can also use SYSTABLESPACESTATS to see when the last reorg/runstats/copy was executed.
Then – if you are using BMC or CA utilities that might be a different story since it could be an option to update SYSCOPY, but again these utilities have the capability to keep their own internal utility history table updated.

Steen

From: Mohamed Esmael [mailto:[login to unmask email]
Sent: Wednesday, August 09, 2017 8:35 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: AW: DB2 utilities

CAUTION: This email originated from outside of CA. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Dear Ruediger

i want to make statistics about all utilities (Paid /Free) that run by users as when i try to retrieve from Catalog Tables just few utilities appears not all like UNLOAD utility

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

Chris Hoelscher

AW: DB2 utilities
(in response to Steen Rasmussen)
Just thinking outloud … could SMF records be cut to document execution of utilities (once you determine what counts as a utility and the execution names that corresponds to those utilities)???

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Rasmussen, Steen [mailto:[login to unmask email]
Sent: Wednesday, August 9, 2017 10:00 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: AW: DB2 utilities

Mohamed, some of the IBM DB2 utilities can be viewed from SYSCOPY since REORG, MODIFY, LOAD etc. are recorded. Others are not like UNLOAD. You can also use SYSTABLESPACESTATS to see when the last reorg/runstats/copy was executed.
Then – if you are using BMC or CA utilities that might be a different story since it could be an option to update SYSCOPY, but again these utilities have the capability to keep their own internal utility history table updated.

Steen

From: Mohamed Esmael [mailto:[login to unmask email]
Sent: Wednesday, August 09, 2017 8:35 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: AW: DB2 utilities

CAUTION: This email originated from outside of CA. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Dear Ruediger

i want to make statistics about all utilities (Paid /Free) that run by users as when i try to retrieve from Catalog Tables just few utilities appears not all like UNLOAD utility

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

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

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
Attachments

  • image001.jpg (<1k)

Steen Rasmussen

AW: DB2 utilities
(in response to Chris Hoelscher)
Great idea Chris - I believe SMF30 type4 will show all batch executions

Steen

Sent from my iPhone

On Aug 9, 2017, at 10:08 AM, Chris Hoelscher <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Just thinking outloud … could SMF records be cut to document execution of utilities (once you determine what counts as a utility and the execution names that corresponds to those utilities)???

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com https://urldefense.proofpoint.com/v2/url?u=http-3A__Humana.com&d=DwQFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=1WGh9ZMMjb7oj8G30tQYASUfsuLUlhQ6OVQeoAnoomM&s=DMLm_bA5tQSZeJ3F48hSHR0xkOFxv5iPmsaGOE_eHWI&e=
(502) 476-2538 or 407-7266

From: Rasmussen, Steen [mailto:[login to unmask email]
Sent: Wednesday, August 9, 2017 10:00 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: AW: DB2 utilities

Mohamed, some of the IBM DB2 utilities can be viewed from SYSCOPY since REORG, MODIFY, LOAD etc. are recorded. Others are not like UNLOAD. You can also use SYSTABLESPACESTATS to see when the last reorg/runstats/copy was executed.
Then – if you are using BMC or CA utilities that might be a different story since it could be an option to update SYSCOPY, but again these utilities have the capability to keep their own internal utility history table updated.

Steen

From: Mohamed Esmael [mailto:[login to unmask email]
Sent: Wednesday, August 09, 2017 8:35 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: AW: DB2 utilities

CAUTION: This email originated from outside of CA. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Dear Ruediger

i want to make statistics about all utilities (Paid /Free) that run by users as when i try to retrieve from Catalog Tables just few utilities appears not all like UNLOAD utility

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

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

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

________________________________
Attachment Links: image001.jpg (1 k) https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_do_-3Fdownload-3D1-26fid-3D8578&d=DwMFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=1WGh9ZMMjb7oj8G30tQYASUfsuLUlhQ6OVQeoAnoomM&s=n4ye_qGVNwosN4GJrkt2VOal4eSTG8GvuOKZpFL1GiE&e=
Site Links: View post online https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_st_-3Fpost-3D182514-26anc-3Dp182514-23p182514&d=DwMFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=1WGh9ZMMjb7oj8G30tQYASUfsuLUlhQ6OVQeoAnoomM&s=MEwAeRwc7AjOHwk67i0B3ym9iz_eNN_nQY-ySpxUqPo&e= View mailing list online https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_si_-3Ftopic-3D19&d=DwMFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=1WGh9ZMMjb7oj8G30tQYASUfsuLUlhQ6OVQeoAnoomM&s=XAeg0rY0joCRqmr60whH-Y3cWcPc6_OLX8ZfRUtqz0c&e= Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_us_to_&d=DwMFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=1WGh9ZMMjb7oj8G30tQYASUfsuLUlhQ6OVQeoAnoomM&s=QIiJQVgij3cfU67O-dmz25CWj6eaLTh8fW9x6WJzsI4&e=

This email has been sent to: [login to unmask email]<mailto:[login to unmask email]>

Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ESAIGroup.com_idug&d=DwMFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=1WGh9ZMMjb7oj8G30tQYASUfsuLUlhQ6OVQeoAnoomM&s=_UY6O4io7ulmdcUq35fxQAGcJlQLJoAqeRBGkgRENL0&e=

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_cm_ld_fid-3D2&d=DwMFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=1WGh9ZMMjb7oj8G30tQYASUfsuLUlhQ6OVQeoAnoomM&s=MhXREM05SmcqNzIG_w226wptHAqLGatpyu5O8-p_cnY&e=

________________________________

Lizette Koehler

DB2 utilities
(in response to Mohamed Esmael)
As others have pointed out, any utility in the IBM Z/OS Manuals should be valid for you to use.



Or is your question:



How can I tell what utilities are being used?

Who is using which utilities?

Can I remove some of the utilities and pay less to IBM?


If you could add more detail to your question it would be very helpful.



Lizette





From: Mohamed Esmael [mailto:[login to unmask email]
Sent: Tuesday, August 08, 2017 11:17 PM
To: [login to unmask email]
Subject: [DB2-L] - DB2 utilities



Hello

Is there way to list all DB2 Utilities that used on system on Z/os ?

Charles Mills

DB2 utilities
(in response to Mohamed Esmael)
Utility usage is audited by SMF Type 102 IFCID 23, 24 and 25.



CharlesSent from a mobile; please excuse the brevity.
-------- Original message --------From: Lizette Koehler <[login to unmask email]> Date: 8/9/17 11:20 AM (GMT-05:00) To: [login to unmask email] Subject: [DB2-L] - RE: DB2 utilities
As others have pointed out, any utility in the IBM Z/OS Manuals should be valid for you to use. Or is your question:   How can I tell what utilities are being used?  Who is using which utilities?Can I remove some of the utilities and pay less to IBM?


If you could add more detail to your question it would be very helpful. Lizette  From: Mohamed Esmael [mailto:[login to unmask email]
Sent: Tuesday, August 08, 2017 11:17 PM
To: [login to unmask email]
Subject: [DB2-L] - DB2 utilities Hello Is there way to list all DB2 Utilities that used on system on Z/os ?
Site Links:
View post online  
View mailing list online  
Start new thread via email  
Unsubscribe from this mailing list  
Manage your subscription  


This email has been sent to: [login to unmask email]

Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU

ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See

http://www.ESAIGroup.com/idug



Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Mohamed Esmael

RE: DB2 utilities
(in response to Charles Mills)

Thanks all of you  a lot for your kindly support 

Mohamed Esmael

RE: DB2 utilities
(in response to Lizette Koehler)

Dear Lizette 

   Who is using which utilities?

  Can i retrieve free utilities on system or not either by catalog tables or by SMF files  as said by others 

Javier Estrada Benavides

RE: AW: DB2 utilities
(in response to Mohamed Esmael)

Hi:

  If you want to get stats then you should be looking at what utilities have been executed, not just the ones that are being executed at the moment.

  For IBM utils you can check the SYSCOPY catalog table as was suggested above (check the ICTYPE column to see what utility was run). For others, BMC, NGT and CA utils have their own history tables, you should be checking what applies to your site so we can try to give better recommendations.

 

  However, if you want to track unloads (normal unloads, dsntiaul or even dsntep2 queries) and anything else that was executed, that's a different story, that's more like a job for IMPERVA products or something similar.

 

Regards,

Javier Estrada Benavides, Mexico

IBM Certified System Administrator - DB2 11 for z/OS

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