View previous topic :: View next topic
|
Author |
Message |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
In our system alternate indexes are built every night. IDCAMS BLDINDEX is used to do this. It’s consuming lot of CPU. As a value-add, we are trying to convert this to GVBLDIX (CA Faver). I heard that this tool runs faster. This is not used here in any jobs. So I would like to know if you can find information about this to see if anyone is using it. If so, I need the sample JCL? |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
This is from ca.
Quote: |
GVBLDIX is a utility that builds one or more alternate indexes for a VSAM base cluster. When building multiple alternate indexes related to a particular base cluster, GVBLDIX only needs to read the base cluster once. To further optimize performance, GVBLDIX utilizes your in-house SORT software. The result is dramatic I/O savings, CPU savings (up to 50%), and reduced elapsed time. |
For more details and success stories, you need to contact ca technologies. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Thanks Gana,
Just in case of if somebody has implemented it then the knowledge is very useful. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Several of my clients have used Faver. They have been quite pleased with the product.
Many (most?) products that perform various IDCAMS functions do so with considerably better performance. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Dick,
Do you have any stats related to performance for any one JCL, also if you could give me the sample JCL then would help to great extent.
Thanks again!! |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
give me the sample JCL |
to/for what?
Quote: |
Do you have any stats |
talk to sales reps about product stats.
Quote: |
related to performance for any one JCL |
you probably expect someone to give you a serious response. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Do you have any stats related to performance for any one JCL, |
No, i don't. This was some time ago, but my recollection is that everything used less resources with Faver.
Quote: |
also if you could give me the sample JCL then would help to great extent. |
I don't have access to a system running Faver now. IIRC, there are examples in the documentation. If you do not have the product installed for a trial, what good would the jcl do?
If your organization is actually comparing/considering Faver, CA will help you. They want to make the sale |
|
Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 580 Location: London
|
|
|
|
CA Faver is very effective, but unless your Base cluster is enormous I wouldn't expect an IDCAMS BLDINDEX to take very long or use significant CPU.
You may want to explore your Base Cluster and AIX definitions have the best CISIZE/CASIZE, and test buffer settings in your jobs JCL first to see what the effect would be if they were tuned properly. Check out the AMP='BUFND=xx,BUFNI=xx' values for a start. A good rule of thumb is BUFND= 2 x number of CI's that fit in a track + 1, and BUFNI=3.
Check with your local support if there is an automated buffering tool like Performance Solution in place as well, it may just need your jobname or file name mask added to it's parameters. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Thanks, Pete and others. |
|
Back to top |
|
|
|