IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Doubt on VSAM dataset


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Jun 14, 2006 3:42 pm
Reply with quote

I am having a KSDS datset . I want to create another KSDS dataset according to same specification of the previous one.ie, it should have the same free space same keylength .Is there any way for doing that?

Also is there any way to know the keylength key of freespace bufferspace etc of an existing KSDS .I tried with LISTCAT command but its not giving all the values that i require .Is there any other way to know all the statistics of an existing VSAM datset?

Thanks in advance icon_smile.gif
Back to top
View user's profile Send private message
sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 183
Location: hyderabad

PostPosted: Wed Jun 14, 2006 5:36 pm
Reply with quote

If you are having the file-aid in your shop,you can easily figure out all the details from the utilities menu and then VSAM.

Code:


File-AID ------  VSAM Information - (Page 1 of 2 ) ----------------------------
COMMAND ===>                                                                   
Catalog:  ICFCAT.PD2                                                           
Cluster:  'XXXX.XXX.XXXX'                                                   
Data:     'XXXX.XXX.XXXXD'                            Data Volume:  XXXXX0 
Index:    'XXXX.XXX.XXXXI'                            Index Volume: XXXXX0 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Data Component Information:                       Current Allocation Options: 
 Device type:             3390                     Load option:          SPEED
 Organization:            KSDS                     Write check:             NO
 KSDS key length:           40                     Buffer space:          9728
 KSDS key location:          2                     Erase on delete:         NO
 Average record size:       97                     Imbedded index:          NO
 Maximum record size:     3500                     Replicated index:        NO
Allocated Space:    Unit    Primary  Secondary     Reuse option:           YES
 Data:         CYLINDERS          5          2     Share option:           2-3
 Index:           TRACKS          1          1     Spanned records:         NO
Dataset Date Information:                          Key ranges present:      NO
 Creation date:         05/28/1998                 AIX-unique keys:           
 Expiration date:                                  AIX-upgrade:               
 Modification date:     06/10/2006                                             
 Modification time:     00:15 AM  GMT                                         
                                                                               
se ENTER to access additional pages, END to return to utility menu             


If you press enter again,you can see the few more details like
Current Utilization in Tracks:
Current Allocations in Tracks:
KSDS Index Allocation in Tracks:
Data - Control Area Information:
Control Interval Information:

At the same time you can also create the file with the same attributes with file-aid.


Thank you
Krishy
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Jun 14, 2006 6:10 pm
Reply with quote

Thanks Krishy

Anyother way Other than uing Fileaid Becauz file aid is not available in my shop icon_sad.gif
Back to top
View user's profile Send private message
philipraju
Warnings : 1

New User


Joined: 16 Apr 2006
Posts: 29

PostPosted: Wed Jun 14, 2006 8:25 pm
Reply with quote

HI,sril.krishy
can u gives full details on above screen,how can i reach the above screen...pls give the details how can i create the ksds file with the same properties of previous one....
Back to top
View user's profile Send private message
sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 183
Location: hyderabad

PostPosted: Thu Jun 15, 2006 12:21 am
Reply with quote

Hi philipraju,
I am not sure whether you are having the same options in your shop or not.We use A.F.3.5 to create the test VSAM file with the same properties of the production VSAM file.Ofcource,you need to chang few parameters like Space etc..

First you need to select the F(file-aid) in the ISPF/PDF PRIMARY OPTION MENU.then you will get the PRIMARY OPTION MENU for the file-aid.
Then select the option 3 (UTILITIES).
This menu is going to have the option VSAM(5) ,use that one and check what are all the available options(A-->ALLOCATE,D-->DELETE etc..).

While allocating you can give the model data set name under "specify model dataset info".

Thank you
Krishy
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top