MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

DFSDUMP ADRDSSU backup performance idea

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
Magesh_J
Intermediate


Joined: 21 Jun 2014
Posts: 259
Topics: 54

PostPosted: Thu Oct 09, 2014 4:04 pm    Post subject: DFSDUMP ADRDSSU backup performance idea Reply with quote

Hi,

We have a jcl which basically do re-org the vsam dataset.
i.e take copy of vsam file into flat file using idcams
delete define the vsam file and copy back the backup to vsam

This process is taking 1234 cpu seconds

I changed this to ADRDSSU dump, it took only 60 cpu seconds to backup but took 306 cpu seconds to copy back again to vsam file.

Question :
1. Whether this ADRDSSU, will actually re-org the file or it will copy back the file again in same format ? in other words, this delete define we do is for re-org the vsam dataset, will adrdssu solve the purpose, i.e will it re-org the vsam file when copied back again ?

2. For taking backup it took 60 cpu second, but for putting back it took 306 cpu seconds. Any way to optimize it ?

Please advice.

JCL below

Code:

//DFDSS1  EXEC PGM=ADRDSSU,REGION=8M       DFDSS BACKUP         
//*                                                             
//SYSPRINT DD  SYSOUT=*                                         
//SYSIN    DD  *                                                 
  DUMP DS(INC(XPX.XXX.A1111.A11.A111111  -                       
              XPX.XXX.AAAAA.AAA.AAAAAAAA  -                     
              XPX.XXX.BBBBB.BBB.BBBBBBB   -                     
              XPX.XXX.XXXXX.XXX.XXX   -                         
        )) -                                                     
     OPTIMIZE(4) OUTDD(OUTDD) TOL(ENQF) SPHERE SHARE             
//*                                                             
//***************************                                   
//* OUTPUT FILES            *                                   
//***************************                                   
//*                                                             
//OUTDD    DD DSN=XPX.XXX.AAABB.CCC.DDDDDDD.A3,                 
//            DISP=(NEW,CATLG,DELETE),UNIT=CART,                 
//            VOL=(,RETAIN,,15),                                 
//            DCB=(MODEL,DSORG=PS,BLKSIZE=0)
//DFDSS2  EXEC PGM=ADRDSSU,REGION=8M       DFDSS BACKUP   
//*                                                       
//SYSPRINT DD  SYSOUT=*                                   
//SYSIN    DD  *                                           
  RESTORE INDD(OUTDD) REPLACE -                           
              DS(INCL(**)) -                               
              RENUNC( -                                   
               (XPX.XXX.**, -                             
               XDX.XXX.**) -                               
               )                                           
//*                                                       
//***************************                             
//* OUTPUT FILES            *                             
//***************************                             
//*                                                       
//OUTDD    DD DSN=XPX.XXX.AAABB.CCC.DDDDDDD.A3,DISP=SHR                         



Thanks
Magesh
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12357
Topics: 75
Location: San Jose

PostPosted: Thu Oct 09, 2014 8:51 pm    Post subject: Re: DFSDUMP ADRDSSU backup performance idea Reply with quote

Magesh_J wrote:

1. Whether this ADRDSSU, will actually re-org the file or it will copy back the file again in same format ? in other words, this delete define we do is for re-org the vsam dataset, will adrdssu solve the purpose, i.e will it re-org the vsam file when copied back again ?

2. For taking backup it took 60 cpu second, but for putting back it took 306 cpu seconds. Any way to optimize it ?



Magesh_J,

1. You don't seem to have ALLDATA and ALLEXCP parms on your Dump dataset.

I suggest you add a step to delete the vsam cluster before you restore. Actually it can be done on the DUMP command itself.

2. VSAM data sets cannot be renamed during a physical data set restore. If a data set is preallocated with the new name, it is not restored. If a data set is not preallocated, it is restored using the old name. This keyword only applies to movable data sets; therefore, unmovable data sets will not be renamed. RENAMEUNCONDITIONAL is not supported for VSAM data sets during a physical data set restore.

3. You might also need to specify SPHERE on your RESTORE too.
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Magesh_J
Intermediate


Joined: 21 Jun 2014
Posts: 259
Topics: 54

PostPosted: Mon Oct 13, 2014 6:38 am    Post subject: Reply with quote

Thanks Kolusu,

I am adding the paramater ALLDATA and ALLEXCP, Please advise how to delete those file in the same step.

Also please advise, Whether the restore will do a Re-org or not.

The purpose of this JCL is only for Re-organzing the file.

Thanks
Magesh
Back to top
View user's profile Send private message
William Collins
Supermod


Joined: 03 Jun 2012
Posts: 437
Topics: 0

PostPosted: Mon Oct 13, 2014 6:58 am    Post subject: Reply with quote

Also be certain that you need to reorg the file. What is the purpose of that as far as you concerned? Can you post a LISTCAT ALL of the file?
Back to top
View user's profile Send private message
Magesh_J
Intermediate


Joined: 21 Jun 2014
Posts: 259
Topics: 54

PostPosted: Mon Oct 13, 2014 10:13 am    Post subject: Reply with quote

There are number of delete/insert/re-write opertation are being done in those files. Which inturn results in fragmentation of data. To de-fragment it we need re-org.

I will post the LISTALL, May i know, what parmater you are intrested in that.

Thanks
Magesh
Back to top
View user's profile Send private message
William Collins
Supermod


Joined: 03 Jun 2012
Posts: 437
Topics: 0

PostPosted: Mon Oct 13, 2014 11:01 am    Post subject: Reply with quote

Code:
  LISTCAT ENT(yourfilename) ALL


May times the idea of "reorging" a VSAM KSDS is left over from the time when CI/CA Splits were problematic for performance of the dataset.

If you have a considerable number of deletes, and the space available from that is not going to be used by new inserts, then that is a reason to do it, but just wondering Smile
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12357
Topics: 75
Location: San Jose

PostPosted: Mon Oct 13, 2014 11:40 am    Post subject: Reply with quote

Magesh_J wrote:
Thanks Kolusu,

I am adding the paramater ALLDATA and ALLEXCP, Please advise how to delete those file in the same step.

Also please advise, Whether the restore will do a Re-org or not.

The purpose of this JCL is only for Re-organzing the file.

Thanks
Magesh


DUMP has a parm called DELETE but is NOT valid for VSAM Clusters. So you have delete it using IDCAMS.

Magesh_J wrote:

There are number of delete/insert/re-write opertation are being done in those files. Which inturn results in fragmentation of data. To de-fragment it we need re-org.


z/OS 2.1 has a new feature called CA RECLAIM which will

    • Detects Empty CAs
    • The empty CAs are removed from the active index structure and moved to free chains
    • Uses the empty CAs when needed before using new CAs
    • Reduces or eliminates reorgs in support of 24x7 operations
    • Applications that use VSAM key-sequenced data sets (KSDS) can benefit from improved performance, minimized space utilization, and improved application availability
    • Performance improvements are anticipated for many applications using CICS®, VSAM, VSAM RLS, IMS™ VSAM, and Catalog processing

_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Magesh_J
Intermediate


Joined: 21 Jun 2014
Posts: 259
Topics: 54

PostPosted: Tue Oct 14, 2014 6:38 am    Post subject: Reply with quote

Thanks Kolusu, But we are in V1R10, and we are migrating to V1R13 by next month, asper the below link, we have this V1R13 ?

http://www-01.ibm.com/support/docview.wss?uid=isg1OA37101

Please advice ?

Regards,
Magesh
Back to top
View user's profile Send private message
Magesh_J
Intermediate


Joined: 21 Jun 2014
Posts: 259
Topics: 54

PostPosted: Tue Oct 14, 2014 6:45 am    Post subject: Reply with quote

William,

Thanks for the kind advice,
Right now it is 2 days after Re-org, the number of deletion of records are less, This is a weekly process, I will get this Liscat before weekly job run, we will have exact data.

Thanks
Magesh
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12357
Topics: 75
Location: San Jose

PostPosted: Tue Oct 14, 2014 10:29 am    Post subject: Reply with quote

Magesh_J wrote:
Thanks Kolusu, But we are in V1R10, and we are migrating to V1R13 by next month, asper the below link, we have this V1R13 ?

http://www-01.ibm.com/support/docview.wss?uid=isg1OA37101

Please advice ?

Regards,
Magesh


Looks like it was available from z/OS V1R12.0 itself. You should be able to use it when you get to V1R13.
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group