Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 
DSNACCOX (can it be run on 1 db/ts, total completion time)

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
SRICOBSAS

New User


Joined: 07 Dec 2015
Posts: 16
Location: India

PostPosted: Sat May 06, 2017 12:59 am    Post subject: DSNACCOX (can it be run on 1 db/ts, total completion time)
Reply with quote

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 experience 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
SRICOBSAS

signatures deleted
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1848
Location: UK

PostPosted: Sat May 06, 2017 1:34 am    Post subject:
Reply with quote

Please read the rules about email ids and then delete those from your signature.
Back to top
View user's profile Send private message
SRICOBSAS

New User


Joined: 07 Dec 2015
Posts: 16
Location: India

PostPosted: Mon May 08, 2017 12:53 pm    Post subject: Reply to: DSNACCOX (can it be run on 1 db/ts, total completion time)
Reply with quote

Hi Nic,

I tried editing my post to remove the signatures but I am unable to do so. I am getting a message "you are allowed to edit a post only within first 10 minutes of creating it". Apologies for the inclusion of my signatures. I rarely visit mainframe forums. Didn't know of the rules..

Will be watchful next time
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1848
Location: UK

PostPosted: Mon May 08, 2017 2:02 pm    Post subject:
Reply with quote

The rules are there under "Site Announcements" sub-heading "Forum rules..."
Back to top
View user's profile Send private message
manoj_bhaskaran

New User


Joined: 05 Dec 2016
Posts: 4
Location: India

PostPosted: Wed Jun 07, 2017 2:42 am    Post subject:
Reply with quote

DSNACCOX can be executed for a single object or a subset of objects also. You need to use the DSNACCOX parameter CRITERIA to pass the condition.

For e.g., if you needed to execute DSNACCOX on only tablespace MYDB.MYTS, you would pass CRITERIA as:

Code:
DBNAME = 'MYDB' AND NAME = 'MYTS'


Basically, you pass the criteria in the form of predicates for a select from SYSIBM.SYSTABLESPACES (or SYSIBM.SYSINDEXES for indexes).

As far as runtimes go, I have one running on a tablespace with 1024 partitions, and it takes about 4 seconds to complete, on average.
Back to top
View user's profile Send private message
SRICOBSAS

New User


Joined: 07 Dec 2015
Posts: 16
Location: India

PostPosted: Fri Jun 09, 2017 10:32 am    Post subject: Reply to: DSNACCOX (can it be run on 1 db/ts, total completion time)
Reply with quote

Thanks Manoj. I will note down your info.

Am closing this topic thread
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts Application not run by time HH:MM tri... jzhardy IBM Tools 1 Sun Apr 09, 2017 3:22 pm
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 pm
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us