Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 18
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: 1894
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: 18
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: 1894
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: 18
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
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us