DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?

VisionPLUS Developer

DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?

Hi DB2 Experts,

I am involved in a project which uses CA programming tools to develop utilities for z/OS DB2 and IMS. My team is purely into development and nobody has DB2 DBA knowledge. We dont have a DBA to whom we can ask questions.

In my subsequent posts I will explain how we do the development for aiding DB2 operations without the prescence of a DBA. At this time I would be grateful if the experts could help me out on info on DSNACCOX- I am not able to find it in Google.

Is it possible to run DSNACCOX on specific databases / tablespaces rather than the entire DB2 subsystem? (I checked the parameters for DSNACCOX but couldnt find any IN param for DBNAME / DBID e.t.c: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sp_dsnaccox.html however wanted to confirm)

If DSNACCOX executes on all the statistics tables for all databases / tablespaces then typically how long does it take to complete? What are the factors that influence the execution time of DSNACCOX?

I would be grateful if the experts could share their experiences on DSNACCOX completion times using which I can decide how to write a program to generate logs during specific phases of DSNACCOX

We have z/OS DB2 v10 (NFM). The size of all our databases is 100 GB (thought the info would be helpful)

Earnestly awaiting helpful pointers.

Thanks & Regards

VISIONPLUS TRAMS

Jørn Thyssen

RE: DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?
(in response to VisionPLUS Developer)

Hi,

FYA: your profile should contain a real name

DSNACCOX makes recommendations only. It is up to you to implement logic around it to execute these recommendations. You can make very detailed object selection by using the Criteria parameter.

 

There are vendor products available that automates the entire process. You can contact me off-list for more details.

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Javier Estrada

RE: DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?
(in response to Jørn Thyssen)

Hello:

  Don't worry about asking questions, that's why we're all here, so as long as you're allowed to ask, we're glad to help.

Are you using CA tools? CA Database Analyzer should be able to get the recommendations you need and you should be able to tune it (and as far as I've been told, you can also schedule the extraction for those statistics and act accordingly, though the term "schedule" might require a CA Jobtrac or any other scheduling tool).

As Jørn mentioned and implied, it's up to you what you decide to do after executing DSNACCOX, but you can also run some specific queries based only on the databases you want to look at, then extract the results and schedule appropiate JCLs if you're really concerned about execution times and being specific. You don't really depend on CA products to do that, and actually, you don't depend on scheduling tools either, you could be as flexible as getting the results by executing the queries through FTP (you heard me right, FTP, and I'm dying to write about that), handling everything on your favorite scripting language and scheduling everything with a plain old cron job.

 

Regards,

Javier Estrada Benavides

IBM Certified DB2 11 for z/OS System Administrator. Mexico

VisionPLUS Developer

RE: DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?
(in response to Javier Estrada)

Hi All,

Thanks for your responses. I just got a note from my client that the work on DSNACCOX may not be required now.

However this question-answer trail has led me to explore a new curiousity- it seems that DSNACCOX the stored proc itself doesnt exist at all in the customer environment!! And DSNACCOX is not the only one, lots of IBM supplied procs are not there.

Is there a possibility to "setup and build" the missing IBM supplied stored procs?

As for my real name I am not a DB2 guy. To give a little background about myself, I am from a Business Intelligence (BI) background and currently develop log extraction and reporting tools.using BI tools like CA BI and IBM Cognos.

The customer mails us the logs of the core z/OS components (CICS / TSO ) and z/OS based databases and tools- IMS / DB2 / Adabas e.t.c. He gives us what "log lines" and specific info he is looking for and we develop the log extraction / reporting tool accordingly. I do it not only for DB2 but also for SQL Server. Till now knowledge on DB2 / IMS was not required.

But now with increasing demands on DB2 operational aids I need to keep myself thorough on DB2 / IMS.

I am closing this thread and starting a new question on requesting help on how to build and setup IBM supplied stored procs.

Thanks once again for your replies.

Thanks & Regards,
SRICOBSAS

Joe Geller

RE: DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?
(in response to VisionPLUS Developer)

Hi,

It doesn't matter if you are a DB2 guy or not.  It is a requirement of this forum that your profile have your real name.  We're happy to answer your questions regardless of your experience, but it is a professional forum and your name is required.

Joe

In Reply to VisionPLUS Developer:

Hi All,

Thanks for your responses. I just got a note from my client that the work on DSNACCOX may not be required now.

However this question-answer trail has led me to explore a new curiousity- it seems that DSNACCOX the stored proc itself doesnt exist at all in the customer environment!! And DSNACCOX is not the only one, lots of IBM supplied procs are not there.

Is there a possibility to "setup and build" the missing IBM supplied stored procs?

As for my real name I am not a DB2 guy. To give a little background about myself, I am from a Business Intelligence (BI) background and currently develop log extraction and reporting tools.using BI tools like CA BI and IBM Cognos.

The customer mails us the logs of the core z/OS components (CICS / TSO ) and z/OS based databases and tools- IMS / DB2 / Adabas e.t.c. He gives us what "log lines" and specific info he is looking for and we develop the log extraction / reporting tool accordingly. I do it not only for DB2 but also for SQL Server. Till now knowledge on DB2 / IMS was not required.

But now with increasing demands on DB2 operational aids I need to keep myself thorough on DB2 / IMS.

I am closing this thread and starting a new question on requesting help on how to build and setup IBM supplied stored procs.

Thanks once again for your replies.

Thanks & Regards,
SRICOBSAS

Jorg Lueke

RE: DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?
(in response to VisionPLUS Developer)

You can run install job DSNTIJRT in different modes to set up or rebuild the system supplied procedures. Just make sure it's configured correctly :)

Philip Sevetson

DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?
(in response to Joe Geller)
**please note my email address change**
Joe,

Thank you.

******

“VisionPLUS Developer”,

Please honor the rules. This is a professional forum and we are unaware of any legitimate reasons for someone to post behind a handle or anonymously; we do not allow this.

Please log on to idug.org and change your name to your actual name before posting on the list again. If you do not know how to change your name, please send me email at [login to unmask email]<mailto:[login to unmask email]> (Identifying yourself and this issue) and I will assist you offline.

If you post to the list generally with this handle again, I will suspend your posting privileges on DB2-L and related IDUG mailing lists until you change the name.


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: Joe Geller [mailto:[login to unmask email]
Sent: Wednesday, May 10, 2017 2:28 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DSNACCOX- can it be run on only one database / tablespace? Estimated completion time?


Hi,

It doesn't matter if you are a DB2 guy or not. It is a requirement of this forum that your profile have your real name. We're happy to answer your questions regardless of your experience, but it is a professional forum and your name is required.

Joe

In Reply to VisionPLUS Developer:

Hi All,

Thanks for your responses. I just got a note from my client that the work on DSNACCOX may not be required now.

However this question-answer trail has led me to explore a new curiousity- it seems that DSNACCOX the stored proc itself doesnt exist at all in the customer environment!! And DSNACCOX is not the only one, lots of IBM supplied procs are not there.

Is there a possibility to "setup and build" the missing IBM supplied stored procs?

As for my real name I am not a DB2 guy. To give a little background about myself, I am from a Business Intelligence (BI) background and currently develop log extraction and reporting tools.using BI tools like CA BI and IBM Cognos.

The customer mails us the logs of the core z/OS components (CICS / TSO ) and z/OS based databases and tools- IMS / DB2 / Adabas e.t.c. He gives us what "log lines" and specific info he is looking for and we develop the log extraction / reporting tool accordingly. I do it not only for DB2 but also for SQL Server. Till now knowledge on DB2 / IMS was not required.

But now with increasing demands on DB2 operational aids I need to keep myself thorough on DB2 / IMS.

I am closing this thread and starting a new question on requesting help on how to build and setup IBM supplied stored procs.

Thanks once again for your replies.

Thanks & Regards,
SRICOBSAS

-----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)