|
View previous topic :: View next topic
|
| Author |
Message |
HONEY LANGUAGE
Warnings : 2
New User
Joined: 27 Oct 2006
Posts: 17
|
|
|
|
Hi,
I'm sorting 2500datasets(i'm concatenating all the datasets) with Syncsort and in that sort ,i'm getting an error cald "SORTIN IS AN UNINITIALIZED SEQUENTIAL DISK DATA SET ".I know this would happen if we have an empty dataset in between those 2500datasets.But if i want to find out exactly where that empty file resides what should i do?.Can anyone help me out?
Thanks,
Honey |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Is the total amount of data in the 2500 files very large?
You might try running a backup of all of the files you are using as input to the run that fails on an empty file (using ADRDSSU or DFDSS). If the volume is too large, you might try assigning the output DD to DUMMY - i've not yet tried that. . .
In the output from the backup check for which files were not backed up and why (file in use, for example).
Remove the problem files from your concatenated DD statement. |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
Honey.
Jeez, I haven't used that since I divorced my last wife) 
| HONEY LANGUAGE wrote: |
| I'm sorting 2500datasets(i'm concatenating all the datasets) with Syncsort and in that sort ,i'm getting an error cald "SORTIN IS AN UNINITIALIZED SEQUENTIAL DISK DATA SET ".I know this would happen if we have an empty dataset in between those 2500datasets.But if i want to find out exactly where that empty file resides what should i do?.Can anyone help me out? |
Does this help?
| Quote: |
By default SyncSort does not accept an uninitialized SORTIN data set and will terminate processing with a WER400A message. An uninitialized data set is one that has been newly created but never successfully closed. The UNINTDS PARM or installation option can be used to change SyncSort?s default mode of processing to accept an uninitialized input data set and process it as an empty file. See ?UNINTDS? on page 5.30.
UNINTDS indicates how SyncSort should process a non-VSAM uninitialized DASD input data set in a non-SMS environment. An uninitialized data set is one that has been created but never successfully opened and closed for output. In an SMS environment, uninitialized data sets are always processed as valid empty files.
UNINTDS=YES indicates that an uninitialized data set should be processed as an empty file. If an uninitialized multi-volume data set has the DS1IND80 and DS1IND02 flags off in the format-1 DSCB of the first volume and the number of data extents is non-zero, Sync-Sort will open the data set for output to set an end-of-file mark before the data set is used for input.
UNINTDS=NO indicates that SyncSort should terminate with a WER400A critical message if an uninitialized data set is provided as input. |
This is from the Fine Manual, do you have one?
Bill |
|
| Back to top |
|
|
HONEY LANGUAGE
Warnings : 2
New User
Joined: 27 Oct 2006
Posts: 17
|
|
|
|
Hi dick,
Thanks alot for your reply.Since i'm working in production side,all of the files would be a large one.
i understood 50% from your reply but i'm not sure i could catch your exact point.Could you please explain it briefly...
Thanks,
Honey |
|
| Back to top |
|
|
HONEY LANGUAGE
Warnings : 2
New User
Joined: 27 Oct 2006
Posts: 17
|
|
|
|
Hi William,
Thanks for your reply.
But,where should i use this UNINTDS=NO? Should i use it in my JCL?. |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| I'm not sure, look in the manual. |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| You do have a manual, don't you? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Honey,
| Quote: |
| i understood 50% from your reply but i'm not sure i could catch your exact point.Could you please explain it briefly... |
Well, i'm not sure which 50%, so i'll try to rework the wording. Please let me know if anything is not clear.
The question about file size was just to see if it might be feasable to really run a backup to cart or dasd. The reason that might be wanted is if the backup utility (ADRDSSU or DFDSS) will not allow a DUMMY backup. One or both of those will give messages about the status of each individual file backup attempt.
At this point (actually much sooner), i should ask if the 2500 files are on dasd. Given that you want to concatenate them into one sort and the error you received, i expected them to be on dasd. Mounting 2500 carts/tapes would be an issue for many sites. . . .
If the files are on dasd, you could "back them up" using DFDSS, but specifying the output DD DUMMY rather than creationg a basckup dataset (if the utility will permit - when i've run a backup, i've always needed it  ). For this exercise, you don't really want the files backed up, but you do want the utility output that will tell how each file was processed. If the utility allows DUMMY backup output AND if the utility reports when it encounters an unitialized file, you will know which ones the problem files are. To run the backup, the files are specified in the input control statements, not in DD statements.
With so many dataset names, it is likely that you can specify them by providing a few masks rather than naming every dsn to the utility. If you DO have to name all of the dsns, you can make a copy of all of the concatenated dsns from your jcl and convert them into utility control statements. Check with someone in your database or technical support groups for some sample jcl/control statements. What they can provide is jcl that will work in your environment and all you will have to do is include the statements for which file names or mask(s) to process.
When the "backup" completes, you should find your answers in the "printed" output. If you know at least one problem dsn, i'd run a small test to verify that the utility will permit DUMMY backup output. Set up your backup so that a couple of "good" files are backed up, then your known problem file, then one or two more good files. When the run completes, check the output to see if your known problem file is reported differently than the good files.
Again, if this is unclear, please let me know.
As far as the Syncsort UNINTDS Parm, i've no remote access to the restricted lan that houses all of the documentation and other copyright or controlled info. I'm most likely going to be onsite on Sun for a while and will check where the parameter should be placed in a Syncsort step. If this will work, i'd recommend Syncsort over the "backup". If you try Syncsort, i'd recommend the same small test from above - a couple of good files, an uninitialized dsn, then a couple of good files, then check the output to see what it reports.
Good catch, Bill
Good luck! |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Here's a bit more info on the UNINTDS parm.
From the Fine Manual:
| Quote: |
| UNINTDS=NO indicates that SyncSort should terminate with a WER400A critical message if an uninitialized data set is provided as input. |
From the above, you will want to use UNINTDS=YES as a parm on the EXEC PGM= statement in your job (just add it to the parm list if there are others). When Syncsort is installed, this option defaults to NO.
Let us know how it runs. |
|
| Back to top |
|
|
HONEY LANGUAGE
Warnings : 2
New User
Joined: 27 Oct 2006
Posts: 17
|
|
|
|
Hi Dick,
Thanks alot for your reply  . 'Yes' i got the point.
Thanks,
Honey |
|
| Back to top |
|
|
HONEY LANGUAGE
Warnings : 2
New User
Joined: 27 Oct 2006
Posts: 17
|
|
|
|
Hi William,
Sorry  i dont have that manual.Could you tell me the path.
Thanks,
Honey |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| HONEY LANGUAGE wrote: |
| Sorry i dont have that manual.Could you tell me the path. |
You could try what I did, since my email address is a licensed user for Syncsort, I emailed CA support and asked for one. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hmmm,
Hadn't heard that CA had purchased Syncsort. . . .  |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Yea, you are correct, meant to say Syncsort support but sub-consciously errored (I guess I file both in that same dark area of my mind ) |
|
| Back to top |
|
|
|
|
