IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DSNACCOX (can it be run on 1 db/ts, total completion time)


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
SRICOBSAS

New User


Joined: 07 Dec 2015
Posts: 19
Location: India

PostPosted: Sat May 06, 2017 12:59 am
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: 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: 2455
Location: Hampshire, UK

PostPosted: Sat May 06, 2017 1:34 am
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: 19
Location: India

PostPosted: Mon May 08, 2017 12:53 pm
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: 2455
Location: Hampshire, UK

PostPosted: Mon May 08, 2017 2:02 pm
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
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: 19
Location: India

PostPosted: Fri Jun 09, 2017 10:32 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
No new posts C Compile time time stamps Java & MQSeries 10
No new posts Parallelization in CICS to reduce res... CICS 4
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
Search our Forums:

Back to Top