Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Doubt on VSAM dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Doubt on VSAM dataset
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    Post subject:
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    Post subject: Re: Doubt on VSAM dataset
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    Post subject: HI,sril.krishy
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    Post subject: Re: Doubt on VSAM dataset
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us