|
View previous topic :: View next topic
|
| Author |
Message |
SRICOBSAS
New User
Joined: 07 Dec 2015
Posts: 19
Location: India
|
|
|
|
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 |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| Please read the rules about email ids and then delete those from your signature. |
|
| Back to top |
|
|
SRICOBSAS
New User
Joined: 07 Dec 2015
Posts: 19
Location: India
|
|
|
|
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 |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| The rules are there under "Site Announcements" sub-heading "Forum rules..." |
|
| Back to top |
|
|
manoj_bhaskaran
New User
Joined: 05 Dec 2016
Posts: 4
Location: India
|
|
|
|
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 |
|
|
SRICOBSAS
New User
Joined: 07 Dec 2015
Posts: 19
Location: India
|
|
|
|
Thanks Manoj. I will note down your info.
Am closing this topic thread |
|
| Back to top |
|
|
|
|
