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
 

 

Need details about CDB Online Re-org Utility...

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

New User


Joined: 27 Oct 2007
Posts: 7
Location: India

PostPosted: Wed Oct 10, 2012 1:05 am    Post subject: Need details about CDB Online Re-org Utility...
Reply with quote

Team,

Our application is uses CDB Online reorg for reorganizing our DB2 Tables on Z/os. Recently we had an issue where in huge number of IMS online transaction failed due to contention with CDB reorg job.

But as per the CDB vendor, "CDB/Auto-Online Reorg provides 100% availability while reorganizing DB2 tablespaces and their associated indexes, with absolutely zero downtime for dataset renames. The design of CDB/Auto-Online Reorg is like no other. CDB/Auto-Online Reorg was designed to not require SORT, to be restartable, to be non-destructive to your data and to employ the most sophisticated automation scheme available. It is very fast and also extremely simple to use.

True 24x7, no-SORT Reorg that does not access the DB2 log. No downtime even during the SWITCH phase."

1) If the above statements are true, why did our IMS online transactions fail due to contention with the reorg job?

2) Recently our application DBA team increased the QRETRY parm in the CDB re-org job from (2000,10) to (2500,50). Could this be cause of failure of IMS online TXNs due to contention?

3) What does QRETRY parameter specify in CDB reorg?

4) What will happen if the CDB reorg does not get lock on the Database?

5) As per our knowledge, when concurrency issues present themselves between a CDB reorg and a batch job, the CDB reorg is supposed to terminate and allow the batch job to continue to process.

If the above statement is true, what caused the failure online transactions due to contention with CDB reorg?

6) What are the different phases in CDB is reorg process, is there any specific phase during which the DB will not be available to other applications?

7) Our DB2 version got upgraded from DB2V9 to DB2V10 recently. Could this have an negative impact on CDB reorg performance?

Please help us in understanding the above questions.

Thanks a lot in advance.

Krishna Kanth K.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Oct 10, 2012 1:45 am    Post subject:
Reply with quote

Hello,

Suggest you open an issue with CDB Support.

This is the only topic i see in our forum that mentions this product.
Back to top
View user's profile Send private message
mjadwani2785

New User


Joined: 28 Apr 2009
Posts: 89
Location: Noida , Dublin

PostPosted: Wed Feb 13, 2013 3:20 pm    Post subject: Reply to: Need details about CDB Online Re-org Utility...
Reply with quote

Which version of CDB auto-utilities you are running ?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Feb 13, 2013 6:19 pm    Post subject:
Reply with quote

Let's hope for the best, this is a bit old thread to have an answer.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Wed Feb 13, 2013 7:33 pm    Post subject: Reply to: Need details about CDB Online Re-org Utility...
Reply with quote

the TS has disappeared,
did not even care to acknowledge Dick' s suggestion

sadly too many of them post a question and disappear icon_sad.gif
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1722
Location: UK

PostPosted: Thu Feb 14, 2013 12:16 am    Post subject:
Reply with quote

Talking of "disappeared" it seems that Dick and DBZ have disappeared. Hope they are OK.
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 TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts Any docs / links for isub- cobol comp... SRICOBSAS COBOL Programming 4 Fri Aug 26, 2016 2:35 pm
No new posts 24x7 online logs using DSN1LOGP (simi... SRICOBSAS DB2 3 Thu Aug 18, 2016 11:52 am


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