Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How can i identify it is KSDS or ESDS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
raman.k

New User


Joined: 26 Feb 2007
Posts: 24
Location: chennai

PostPosted: Wed Mar 28, 2007 3:21 pm    Post subject: How can i identify it is KSDS or ESDS
Reply with quote

Hi
I have one vsam file like A.B.C.D
Now how can i identify it is KSDS or ESDS?

Please tell me
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Mar 28, 2007 3:36 pm    Post subject:
Reply with quote

KSDS has two components (.DATA and .INDEX) and ESDS has only one componenet (.DATA). If index component present, it is a KSDS cluster.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Mar 28, 2007 3:52 pm    Post subject:
Reply with quote

LISTCAT might be a good place to start
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Mar 28, 2007 3:57 pm    Post subject:
Reply with quote

Expat,

Code:
LISTCAT might be a good place to start


How do you confirm a cluster is a ESDS/KSDS using LISTCAT?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Mar 28, 2007 4:26 pm    Post subject:
Reply with quote

Does an ESDS have an INDEX in its associations ?

The benefit of using LISTCAT is that the seperate portions of a cluster can be called anything you want them to be called

I can define a cluster as below,
CLST name = HLQ.PROJECT.FILE001
DATA name = HLQ.PROJECT.FILE002
INDX name = HLQ.PROJECT.FILE003

There is no visible corellation between the filenames. Using LISTCAT the associations are ALWAYS shown.

And - looking at the file attributes in LISTCAT the output will show if it is an INDEXED file or not.

Try a few tests and see what you can see.

However, once a VSAM file is migrated via HSM the whole picture changes. The catalog entries for each component are then shown as NONVSAM files, which in effect they are. They are PS file copies of the portions of the KSDS, or ESDS, held on tape via HSM.

Confusing, isn't it ?
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Mar 28, 2007 4:34 pm    Post subject:
Reply with quote

Expat,

You highlighted a very good point. Thanks.

But, I just found out one more thing with listcat for one of my ESDS cluster


Code:
ATTRIBUTES
  KEYLEN----------------10     AVGLRECL--------------80     BUFSPACE-----------1
  RKP--------------------0     MAXLRECL--------------80     EXCPEXIT----------(N
  SHROPTNS(1,3)   RECOVERY     UNIQUE           NOERASE     NONINDEXED    NOWRIT



Though Index component value is 0. Do you have any idea why KEYLEN is 10 though its a ESDS cluster?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Mar 28, 2007 4:45 pm    Post subject:
Reply with quote

Is it an ESDS or an RRDS ?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Mar 28, 2007 4:49 pm    Post subject:
Reply with quote

Just ran a test by defining an ESDS with KEYS parameter and got the same result as you showed.

I'd guess that someone took another IDCAMS DEFINE for a KSDS changed it from INDEXED to NONINDEXED and forgot to remove the KEYS parameter.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Could we identify the called modules ... elixir1986 COBOL Programming 5 Fri Jul 14, 2017 1:53 am
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us