IBM Mainframe Forum

i have existing non-sms managed file. it cannot allow the system to create extents automatically because it is used by a DB and requires formatting.
It has 2 extents on 1 volume (5300,700 CYLS). I need to add an extent on another volume. Getting a Not Catlgd 2 error IEF287I.

iefbr14


when I change DISP=SHR - it avoids the Not Catlgd 2 error, but the catlog entry does not show the extended extents on the new volume C11.

1. should the catalog show the extent, even though it has yet been updated with any real data?
2. is this the proper way to add an existing extent? the first volume of full of data and do not want to delete/recreate it (would take significant time).

This is the catalog entry after trying above updates - SHOWING only the current 2 extents on the 1 volume C08. On other DSN with multiple volumes it shows "C08+" and then will list all the volumes (but these have been populated/formatted).


[Edit]Coded for you[/Edit]

There are several errors here.

1. This data set appears to be non-VSAM. Extent information is not shown in the catalog entry for a non-VSAM data set. The only source for extent information for non-VSAM data sets is the VTOC.
2. No additional space was allocated in the IEFBR14 step because IEFBR14 did not open and write additional data to the data set.
3. The SPACE data in the IEFBR14 step is not recorded in the VTOC. SPACE parameter data for an existing data set is only valid for the step, and only if your program is writing data to the data set. After the step completes the secondary allocation reverts to the original secondary allocation.
4. A data set will extend to an additional volume only if the system cannot allocate another secondary extent on the first volume, or the system has allocated the maximum extents allowed for the data set on the first volume.
5. As far as I know, it is not possible to permanently alter secondary allocation information for a non-VSAM data set. You can alter it for a step, and that's it.

Finally when you post screen data, use code tags, like this-

The extent information in this report was extracted from the VTOC and then massaged to transform track information (as it is stored in the VTOC) to block information or cylinder information depending on the initial allocation.

I deal with multiple volume data sets so infrequently I do not know how ISPF Data Set Information formats them.

requires formatting.

I'm pretty sure that the only way to do this is to start by having a formatter job / task allocate and format the extents. Certainly you cannot add an extent with IEFBR14 as it will create a new dataset, hence the 'not cataloged' message. And as mentioned by mr steve-myers you cannot force the 2nd extent to go the 2nd volume if sufficient space exits on the 1st volume.
So, pre-allocate and format a new dataset, then copy the contents of the old, then rename both. Yes that means that the dataset must be unallocated from DB2 for the duration.

I agree with Mr. Jensen. When I was writing my post I had thought about that issue, but since I know little about DB2, I decided to ignore it.

thanks so much guys. I was wondering about those details and your explanations are very clear. Thanks also for the quick response. Appreciate it much. Will monitor this forum and hope to contribute as well. Will be using and format utility to actually extend the non-vsam DSN.

Just a heads up, but the same thing (formatting) is required for WebsphereMQ datasets too.

No big surprise as it is only DB2 under the covers anyway.