Why DB2 uses VSAM file type for tablespace creation?



IBM's flagship relational database management system

Why DB2 uses VSAM file type for tablespace creation?

Postby xboss » Sun Dec 12, 2010 12:07 am

Please give me your opinion on this,
Why DB2 uses KSDS VSAM file type for tablespace creation?
I am writing a graduate paper on this topic. I want to know your experienced thought so that I can add some practical reasoning.
Thank you everybody for your time in advance.
xboss
 
Posts: 79
Joined: Mon Nov 29, 2010 10:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: Why DB2 uses VSAM file type for tablespace creation?

Postby NicC » Sun Dec 12, 2010 12:11 am

Well, you could research the DB2 manuals on the IBM website. Google will get you there.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Why DB2 uses KSDS VSAM file type for tablespace creation?

Postby xboss » Sun Dec 12, 2010 1:02 am

Sorry for the typo, I meant to say LDS instead of KSDS. Why we use Linear file type for tablebase creation?
xboss
 
Posts: 79
Joined: Mon Nov 29, 2010 10:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: Why DB2 uses VSAM file type for tablespace creation?

Postby xboss » Sun Dec 12, 2010 1:30 am

Thanks NicC for the suggestion. Yes, definitely I could. The reason I am doing this if I can find any new and interesting things people realized through their experience. This will help me to get better understanding of subject matter.
xboss
 
Posts: 79
Joined: Mon Nov 29, 2010 10:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: Why DB2 uses VSAM file type for tablespace creation?

Postby dick scherrer » Sun Dec 12, 2010 2:49 am

Hello,

Why we use Linear file type for tablebase creation?
Because this is what IBM chose for implementation. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Why DB2 uses VSAM file type for tablespace creation?

Postby xboss » Sun Dec 12, 2010 3:24 am

Thank you for your reply, Dick. :)
xboss
 
Posts: 79
Joined: Mon Nov 29, 2010 10:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: Why DB2 uses VSAM file type for tablespace creation?

Postby Robert Sample » Sun Dec 12, 2010 7:14 am

Why are you asking this on a public forum? Would it not make more sense to do the research in the IBM System Journal since that's where IBM tends to write articles including design details? Even if an IBM system architect were monitoring this forum, that person is not likely to provide any details -- and nobody outside IBM can do more than guess about the design decisions.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Why DB2 uses VSAM file type for tablespace creation?

Postby enrico-sorichetti » Sun Dec 12, 2010 12:05 pm

there a big issue with IBM system Journal and IBM journal of research and development
they are not free any longer...

once upon a time they were free and available to everybody

after that for a very short period the were available and the price was around 3$ for each article
( the preface was free )

now some IBM idiot decided to handle the whole stuff to IEEE and the net result of the operation
is that each article costs 30$ ( even the useless preface )
Somebody in IBM seems just interested to sponsor ( with our money ) IEEE
or is trying to make access to IBM culture very difficult
for an occasional need 30$ is really a waste of money!
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post