Re: DFDSS VSAM logical restore?
John: One warning that hit me. We used to do weekly dump restore of the HSM cds's.Make sure you make two copies of the backup tape. Either after dump copy to another tape or create 2 copies with the dump.This saved my ass more than once. Tape is not even close to being 100 percent dependable. Back in the 2nd gen it was really bad got better 360 and even better 370 but I think its leveled off. Yes it has gotten faster but a CYA is still a must. We had the dasd space available (it was a gamble) as management would get rid of it and get new in faster than we could keep track of it. We used to use the DASD for large requests and warned the user to not complain if it dissappeared over night. We had no input just a person last on the notification list although it meant a lot of OT to handle the crazy management decisions. I have seen it where management forgot to tell us and it sat there for months on end and suddenly it was pulled and we essentually had nothing to do as it was the same as it came it. I do not think it ever got powered up and attached (I could be wrong on this but I do not think so. Ed -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
On Sun, 2010-10-24 at 00:05 -0700, Ed Gould wrote: John: One warning that hit me. We used to do weekly dump restore of the HSM cds's.Make sure you make two copies of the backup tape. Either after dump copy to another tape or create 2 copies with the dump.This saved my ass more than once. Tape is not even close to being 100 percent dependable. Back in the 2nd gen it was really bad got better 360 and even better 370 but I think its leveled off. Yes it has gotten faster but a CYA is still a must. We had the dasd space available (it was a gamble) as management would get rid of it and get new in faster than we could keep track of it. We used to use the DASD for large requests and warned the user to not complain if it dissappeared over night. We had no input just a person last on the notification list although it meant a lot of OT to handle the crazy management decisions. I have seen it where management forgot to tell us and it sat there for months on end and suddenly it was pulled and we essentually had nothing to do as it was the same as it came it. I do not think it ever got powered up and attached (I could be wrong on this but I do not think so. Ed Ah. Good point. In our case, for this function, the tape is virtual tape. For off-site storage, we use OpenTech's VDR to copy the virtual tape onto a duplexed physical tape. -- John McKown Maranatha! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
On Wed, 20 Oct 2010 20:02:49 -0700, Ron Hawkins wrote: In the case of John's question the answer is no, the KSDS will not be reorganized when you use DFSMSdss RESTORE. That's only true if you specified NOVALIDATE for the logical dump. VALIDATE is the default. With VALIDATE (on DUMP) the KSDS *will* be reorganized when you RESTORE. Norbert Friemel -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
If you are only looking at speeding up the re-org process (which implies KSDS only) would SORT be viable? After all, it is designed to read and write data as fast as it can - and there would be no need to actually SORT anything... Just a thought MKB -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
On Thu, 2010-10-21 at 10:49 +0100, Mike Kerford-Byrnes wrote: If you are only looking at speeding up the re-org process (which implies KSDS only) would SORT be viable? After all, it is designed to read and write data as fast as it can - and there would be no need to actually SORT anything... Just a thought MKB Unfortunately, I need a reorg which does a dump / restore because for some files, we don't have enough DASD for two simultaneous copies to exist. -- John McKown Maranatha! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
-Original Message- From: IBM Mainframe Discussion List On Behalf Of John McKown On Thu, 2010-10-21 at 10:49 +0100, Mike Kerford-Byrnes wrote: If you are only looking at speeding up the re-org process (which implies KSDS only) would SORT be viable? After all, it is designed to read and write data as fast as it can - and there would be no need to actually SORT anything... //SORTOUT can go to tape -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
On Wed, 20 Oct 2010 14:43:49 -0500, John McKown wrote: A dummy question. When I do a VSAM logical dataset restore using DFDSS, does it do a reorganization of the data? I would think so, but I cannot find it in the manual. This would be from a logical dump. Yes, a VSAM KSDS dataset is reorganized if restored from a logical dump with VALIDATE (default). There's a hint in the manual (note 3): http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DGT2U281/2.3.10.5.49?SHELF=DGT2BK91DT=20100112095849#HDRR2340 Norbert Friemel -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
John, I would have used SORT-COPY (but if it's DFSORT make sure the VSAM BUFND setting is optimal). It should be faster than IDCAMS (because of the better TAPE I/O). Are you sure you need to reorg at all? I'm sure you are familiar with the cost of CA splits is mainly at split time, etc., and re-org potentially causing more CA splits if it reverses needed splits .. How did CA-FAVER solve this problem? In-place reorg? Best Regards, Yifat -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: יום ה 21 אוקטובר 2010 12:49 To: IBM-MAIN@bama.ua.edu Subject: Re: DFDSS VSAM logical restore? On Thu, 2010-10-21 at 10:49 +0100, Mike Kerford-Byrnes wrote: If you are only looking at speeding up the re-org process (which implies KSDS only) would SORT be viable? After all, it is designed to read and write data as fast as it can - and there would be no need to actually SORT anything... Just a thought MKB Unfortunately, I need a reorg which does a dump / restore because for some files, we don't have enough DASD for two simultaneous copies to exist. -- John McKown Maranatha! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
On 21 Oct 2010 03:51:00 -0700, in bit.listserv.ibm-main you wrote: On Thu, 2010-10-21 at 10:49 +0100, Mike Kerford-Byrnes wrote: If you are only looking at speeding up the re-org process (which implies KSDS only) would SORT be viable? After all, it is designed to read and write data as fast as it can - and there would be no need to actually SORT anything... Just a thought MKB Unfortunately, I need a reorg which does a dump / restore because for some files, we don't have enough DASD for two simultaneous copies to exist. Sort FIELDS=COPY for both dump and restore with a delete/define in between should be almost as good as FAVER. Clark Morris -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
But not as easy due to the required DELETE / DEFINE. It __must__ be easy! -- John McKown Maranatha! Sent from my Vibrant Android phone. On Oct 21, 2010 1:08 PM, Clark Morris cfmpub...@ns.sympatico.ca wrote: On 21 Oct 2010 03:51:00 -0700, in bit.listserv.ibm-main you wrote: On Thu, 2010-10-21 at 10:49 +01... Sort FIELDS=COPY for both dump and restore with a delete/define in between should be almost as good as FAVER. Clark Morris -- For IBM-MAIN subscribe / sig... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
If the file is defined w/REUSE you do not need to DELETE/DEFINE, just REPRO w/REUSE. Or, you can use EXPORT/IMPORT, which will do the DELETE/DEFINE for you (or maybe just the DEFINE, I forget). On Thu, Oct 21, 2010 at 4:29 PM, John McKown john.archie.mck...@gmail.comwrote: But not as easy due to the required DELETE / DEFINE. It __must__ be easy! -- John McKown Maranatha! Sent from my Vibrant Android phone. On Oct 21, 2010 1:08 PM, Clark Morris cfmpub...@ns.sympatico.ca wrote: On 21 Oct 2010 03:51:00 -0700, in bit.listserv.ibm-main you wrote: On Thu, 2010-10-21 at 10:49 +01... Sort FIELDS=COPY for both dump and restore with a delete/define in between should be almost as good as FAVER. Clark Morris -- For IBM-MAIN subscribe / sig... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains confidential and privileged information intended only for the addressee. If you are not the intended recipient, please be advised that you have received this material in error and that any forwarding, copying, printing, distribution, use or disclosure of the material is strictly prohibited. If you have received this material in error, please (i) do not read it, (ii) reply to the sender that you received the message in error, and (iii) erase or destroy the material. Emails are not secure and can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by email. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
On Thu, 2010-10-21 at 13:55 +0200, Yifat Oren wrote: John, I would have used SORT-COPY (but if it's DFSORT make sure the VSAM BUFND setting is optimal). It should be faster than IDCAMS (because of the better TAPE I/O). Are you sure you need to reorg at all? I'm sure you are familiar with the cost of CA splits is mainly at split time, etc., and re-org potentially causing more CA splits if it reverses needed splits .. How did CA-FAVER solve this problem? In-place reorg? Best Regards, Yifat We would FAVER EXPORT the DSN to tape, then FAVER IMPORT it back. The actual job is more complicated than that. We use wild cards to dump multiple VSAM files to tape for backup purposes. We then run T-REX to list all of those with a large number of CA splits. We message that report in the next step to create FAVER control cards to IMPORT selected VSAM files. FAVER IMPORT, like IDCAMS IMPORT will delete and redefine the entire VSAM SPHERE based on the cluster names given. The cost to convert from FAVER in terms of labour will be immense. So I hope CA comes through for us. My boss has been trying hard to drive our costs down because that helps save jobs. -- John McKown Maranatha! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
Norbert, Thanks. I never made the connection between this and reorganization. However, I still believe IDCAMS REPRO with BUFND of one CYL will outperform DFSMSdss. A wild arsed guess is that DFSORT COPY with the same BUFND will have the same performance as REPRO because they are both using the same mechanism, VSAM, to read and write the reorganized KSDS. Ron -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Norbert Friemel Sent: Thursday, October 21, 2010 4:37 AM To: IBM-MAIN@bama.ua.edu Subject: Re: [IBM-MAIN] DFDSS VSAM logical restore? On Wed, 20 Oct 2010 14:43:49 -0500, John McKown wrote: A dummy question. When I do a VSAM logical dataset restore using DFDSS, does it do a reorganization of the data? I would think so, but I cannot find it in the manual. This would be from a logical dump. Yes, a VSAM KSDS dataset is reorganized if restored from a logical dump with VALIDATE (default). There's a hint in the manual (note 3): http://publibz.boulder.ibm.com/cgi- bin/bookmgr_OS390/BOOKS/DGT2U281/2.3.10.5.49?SHELF=DGT2BK91DT=2010011209584 9# HDRR2340 Norbert Friemel -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
John, As Yifat says, the CA split process may impact performance, but once the CA split is complete it does not affect performance at all. A process that reorganizes a KSDS every time it has more than n number of CI or CA splits is not really improving any performance. In fact, it may be degrading performance as CI and splits once again go through a period of finding their natural level based on the key ranges with the highest insert activity. If CA, and perhaps CI splits are causing a performance problem, the usual strategies would be: 1) Use a larger CISZ. This makes the CA split faster and creates a larger buffer to absorb inserts after the CI split 2) Use FreeSpace to mitigate or eliminate CA and CI split activity CA splits may noticeably impact sequential scans of a KSDS if more than 10% of CAs have split, and become quite obvious if more than 30% have split because it would cause IO to behave in a skip sequential manner and defeat sequential pre-fetch in the controller. Ron -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Thursday, October 21, 2010 4:15 PM To: IBM-MAIN@bama.ua.edu Subject: Re: [IBM-MAIN] DFDSS VSAM logical restore? On Thu, 2010-10-21 at 13:55 +0200, Yifat Oren wrote: John, I would have used SORT-COPY (but if it's DFSORT make sure the VSAM BUFND setting is optimal). It should be faster than IDCAMS (because of the better TAPE I/O). Are you sure you need to reorg at all? I'm sure you are familiar with the cost of CA splits is mainly at split time, etc., and re-org potentially causing more CA splits if it reverses needed splits .. How did CA-FAVER solve this problem? In-place reorg? Best Regards, Yifat We would FAVER EXPORT the DSN to tape, then FAVER IMPORT it back. The actual job is more complicated than that. We use wild cards to dump multiple VSAM files to tape for backup purposes. We then run T-REX to list all of those with a large number of CA splits. We message that report in the next step to create FAVER control cards to IMPORT selected VSAM files. FAVER IMPORT, like IDCAMS IMPORT will delete and redefine the entire VSAM SPHERE based on the cluster names given. The cost to convert from FAVER in terms of labour will be immense. So I hope CA comes through for us. My boss has been trying hard to drive our costs down because that helps save jobs. -- John McKown Maranatha! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
DFDSS VSAM logical restore?
A dummy question. When I do a VSAM logical dataset restore using DFDSS, does it do a reorganization of the data? I would think so, but I cannot find it in the manual. This would be from a logical dump. -- John McKown Maranatha! Sent from my Vibrant Android phone. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
Hi John, I don't expect that it would. As far as I know, DF/dss logical processing is aware of datasets and records (i.e. blocks) but doesn't usually concern itself with the content of these datasets. There are two exceptions that I'm aware of: 1) DF/dss can change the amount of unused (pad) space in a dataset 2) DF/dss can change a PDS into a PDSE I believe that if you want to reorganize a VSAM dataset, you'll have to use VSAM REPRO (which consolidates split CIs and CAs). Cheers, Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, October 20, 2010 12:44 To: IBM-MAIN@bama.ua.edu Subject: DFDSS VSAM logical restore? A dummy question. When I do a VSAM logical dataset restore using DFDSS, does it do a reorganization of the data? I would think so, but I cannot find it in the manual. This would be from a logical dump. -- John McKown Maranatha! Sent from my Vibrant Android phone. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
Thanks, Alan. How about IDCAMS EXPORT / IMPORT? We are looking at what it would take to replace CA-FAVER. It is a good product, but we are looking at possible alternatives. IDCAMS is __slow__! -- John McKown Maranatha! Sent from my Vibrant Android phone. On Oct 20, 2010 2:59 PM, Starr, Alan alan_st...@calpers.ca.gov wrote: Hi John, I don't expect that it would. As far as I know, DF/dss logical processing is aware of datasets and records (i.e. blocks) but doesn't usually concern itself with the content of these datasets. There are two exceptions that I'm aware of: 1) DF/dss can change the amount of unused (pad) space in a dataset 2) DF/dss can change a PDS into a PDSE I believe that if you want to reorganize a VSAM dataset, you'll have to use VSAM REPRO (which consolidates split CIs and CAs). Cheers, Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Beh... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
Yes John... As far as I know, both REPRO and EXPORT result in a reorganized VSAM dataset. While you're looking at alternatives, you may wish to consider Innovation's IAM. We are quite happy with it. Regards, Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, October 20, 2010 14:02 To: IBM-MAIN@bama.ua.edu Subject: Re: DFDSS VSAM logical restore? Thanks, Alan. How about IDCAMS EXPORT / IMPORT? We are looking at what it would take to replace CA-FAVER. It is a good product, but we are looking at possible alternatives. IDCAMS is __slow__! -- John McKown Maranatha! Sent from my Vibrant Android phone. On Oct 20, 2010 2:59 PM, Starr, Alan alan_st...@calpers.ca.gov wrote: Hi John, I don't expect that it would. As far as I know, DF/dss logical processing is aware of datasets and records (i.e. blocks) but doesn't usually concern itself with the content of these datasets. There are two exceptions that I'm aware of: 1) DF/dss can change the amount of unused (pad) space in a dataset 2) DF/dss can change a PDS into a PDSE I believe that if you want to reorganize a VSAM dataset, you'll have to use VSAM REPRO (which consolidates split CIs and CAs). Cheers, Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Beh... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
If looking for an alternative to the traditional IDCAMS REPRO for the reorganisation of VSAM(and IAM) files, Innovation Data Processing's FDREORG solution might be worth looking at: http://www.innovationdp.fdr.com/products/fdrreorg/ Apart from being able to offer significantly better performance for file re-organisations compared to that of using IDCAMS , it also allows for an intelligent approach to running REORGS by being able to specify a number of different criteria by which the file should be re-organised and potentially eliminate un-necessary REORGs. Stephen Mednick Computer Supervisory Services Sydney, Australia Asia/Pacific representatives for Innovation Data Processing, Inc. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Starr, Alan Sent: Thursday, 21 October 2010 8:14 AM To: IBM-MAIN@bama.ua.edu Subject: Re: DFDSS VSAM logical restore? Yes John... As far as I know, both REPRO and EXPORT result in a reorganized VSAM dataset. While you're looking at alternatives, you may wish to consider Innovation's IAM. We are quite happy with it. Regards, Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, October 20, 2010 14:02 To: IBM-MAIN@bama.ua.edu Subject: Re: DFDSS VSAM logical restore? Thanks, Alan. How about IDCAMS EXPORT / IMPORT? We are looking at what it would take to replace CA-FAVER. It is a good product, but we are looking at possible alternatives. IDCAMS is __slow__! -- John McKown Maranatha! Sent from my Vibrant Android phone. On Oct 20, 2010 2:59 PM, Starr, Alan alan_st...@calpers.ca.gov wrote: Hi John, I don't expect that it would. As far as I know, DF/dss logical processing is aware of datasets and records (i.e. blocks) but doesn't usually concern itself with the content of these datasets. There are two exceptions that I'm aware of: 1) DF/dss can change the amount of unused (pad) space in a dataset 2) DF/dss can change a PDS into a PDSE I believe that if you want to reorganize a VSAM dataset, you'll have to use VSAM REPRO (which consolidates split CIs and CAs). Cheers, Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Beh... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
On Wed, 2010-10-20 at 14:14 -0700, Starr, Alan wrote: Yes John... As far as I know, both REPRO and EXPORT result in a reorganized VSAM dataset. While you're looking at alternatives, you may wish to consider Innovation's IAM. We are quite happy with it. Regards, Alan IAM is probably too expensive. We are still downsizing. And in the all hands meeting today, the big boss of IT said that one way to avoid layoffs is to reduce other costs, such as hardware and software. How bad? I was, mildly, pressured to give up the company on-call cell phone and get my own. I did. I went wild and got the everything you can eat plan with an Android. -- John McKown Maranatha! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
On Thu, 2010-10-21 at 08:27 +1100, Stephen Mednick wrote: If looking for an alternative to the traditional IDCAMS REPRO for the reorganisation of VSAM(and IAM) files, Innovation Data Processing's FDREORG solution might be worth looking at: http://www.innovationdp.fdr.com/products/fdrreorg/ Apart from being able to offer significantly better performance for file re-organisations compared to that of using IDCAMS , it also allows for an intelligent approach to running REORGS by being able to specify a number of different criteria by which the file should be re-organised and potentially eliminate un-necessary REORGs. Stephen Mednick Thanks. My boss already mentioned something from FDR. With the comment that the cost was way too high for us. We're still downsizing. And looking at replacing CA-FAVER to reduce software cost. One doesn't save money by replacing a Ford with a Lexus! -- John McKown Maranatha! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
Alan and John, In the case of John's question the answer is no, the KSDS will not be reorganized when you use DFSMSdss RESTORE. However, this is not true for all DFSMSdss processing. Where you copy or move a dataset DFSMSdss will try to use utilities to process the file, and in the case of VSAM it will be reorganized if it does not use FCV2 or you specify FASTREPLICATION(NO). You can verify that a utility is used to process a dataset by specifying UTILMSG=YES on in the PARM statement. This will cause REPRO, IEBCOPY and whatever statements to be written to SYSPRINT. Ron -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Starr, Alan Sent: Wednesday, October 20, 2010 12:59 PM To: IBM-MAIN@bama.ua.edu Subject: Re: [IBM-MAIN] DFDSS VSAM logical restore? Hi John, I don't expect that it would. As far as I know, DF/dss logical processing is aware of datasets and records (i.e. blocks) but doesn't usually concern itself with the content of these datasets. There are two exceptions that I'm aware of: 1) DF/dss can change the amount of unused (pad) space in a dataset 2) DF/dss can change a PDS into a PDSE I believe that if you want to reorganize a VSAM dataset, you'll have to use VSAM REPRO (which consolidates split CIs and CAs). Cheers, Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, October 20, 2010 12:44 To: IBM-MAIN@bama.ua.edu Subject: DFDSS VSAM logical restore? A dummy question. When I do a VSAM logical dataset restore using DFDSS, does it do a reorganization of the data? I would think so, but I cannot find it in the manual. This would be from a logical dump. -- John McKown Maranatha! Sent from my Vibrant Android phone. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
Thanks. My boss already mentioned something from FDR. With the comment that the cost was way too high for us. We're still downsizing. And looking at replacing CA-FAVER to reduce software cost. One doesn't save money by replacing a Ford with a Lexus! -- John McKown Maranatha! Well considering the brief that's been handed to you by your boss, then really you're kind of stuck with having to use the free IBM offering, IDCAMS. Good luck. Stephen Mednick Computer Supervisory Services Sydney, Australia Asia/Pacific representatives for Innovation Data Processing, Inc. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DFDSS VSAM logical restore?
John, With BUFND set to the number of CI per CA, or equivalent in KB, REPRO will almost always outperform DFSMSdss. The best you'll get from DFSMSdss for logical dump is one track per IO, even if you specify OPT(4). Tuned IDCAMS is _FAST_! Ron -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, October 20, 2010 2:02 PM To: IBM-MAIN@bama.ua.edu Subject: Re: [IBM-MAIN] DFDSS VSAM logical restore? Thanks, Alan. How about IDCAMS EXPORT / IMPORT? We are looking at what it would take to replace CA-FAVER. It is a good product, but we are looking at possible alternatives. IDCAMS is __slow__! -- John McKown Maranatha! Sent from my Vibrant Android phone. On Oct 20, 2010 2:59 PM, Starr, Alan alan_st...@calpers.ca.gov wrote: Hi John, I don't expect that it would. As far as I know, DF/dss logical processing is aware of datasets and records (i.e. blocks) but doesn't usually concern itself with the content of these datasets. There are two exceptions that I'm aware of: 1) DF/dss can change the amount of unused (pad) space in a dataset 2) DF/dss can change a PDS into a PDSE I believe that if you want to reorganize a VSAM dataset, you'll have to use VSAM REPRO (which consolidates split CIs and CAs). Cheers, Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Beh... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html