|
View previous topic :: View next topic
|
| Author |
Message |
usha.ushaa
New User
Joined: 12 Dec 2006
Posts: 2
Location: Trivandrum
|
|
|
|
Can anyone explain why DB2 is supporting only LDS and not any other
VSAM datasets.
Thanks in Advance,
Usha |
|
| Back to top |
|
 |
usha.ushaa
New User
Joined: 12 Dec 2006
Posts: 2
Location: Trivandrum
|
|
|
|
Actually tablespace is an LDS and an index is also an LDS . How these
two are correlated(for eg: if I delete a table the index is also deleted)
how this happens? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
What you are asking about is the IBM design of DB2. These are not something dba/programmer/etc people have any control over.
There is no good reason for these - it is just they way db2 was implemented.
DB2 is designed to only work on "tables" and the other types ov files are not db2 tables. . .
If this is not what you wanted, please let us know. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| If you don't like the way DB2 operates you can always write your own version. |
|
| Back to top |
|
|
pavchau1
New User
Joined: 05 Jul 2019
Posts: 3
Location: india
|
|
|
|
Hi Dick Scherrer,
Yeah I understand Db2 is designed in such way so it uses only LDS, but back in old days, Db2 used ESDS and now LDS is standard, so my question is what is the reason so Db2 switched to LDS from ESDS. LDS has any benefit over ESDS or something else?
Thanks,
Pavan Chauhan |
|
| Back to top |
|
|
dneufarth
Active User
Joined: 27 Apr 2005
Posts: 420
Location: Inside the SPEW (Southwest Ohio, USA)
|
|
|
|
| I believe Mr Scherrer passed away. |
|
| Back to top |
|
|
pavchau1
New User
Joined: 05 Jul 2019
Posts: 3
Location: india
|
|
|
|
| i am sorry |
|
| Back to top |
|
|
pavchau1
New User
Joined: 05 Jul 2019
Posts: 3
Location: india
|
|
|
|
| anyone else can answer my question? |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
Yes, Mr. Scherrer passed away about 5 years ago.
IBM does not provide any rationales for why they do things, but I would guess the byte-oriented nature of LDS and its lack of record structure compared to ESDS may have something to do with why they switched. However, unless you work for IBM's DB2 group it is EXTREMELY unlikely that you will ever find out the precise reasons for the change. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
| Back to top |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012
Posts: 178
Location: United States
|
|
|
|
| ESDS datasets are extremely unstable and don't follow standards dictated by the Access Control Block architecture. |
|
| Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007
Posts: 1744
Location: Tirupur, India
|
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
| No more old school philosophy, that’s great to know thanks |
|
| Back to top |
|
|
|
|
