VSAM LDS used in DB2

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Chandra Shekar G R
Member
Posts: 14
Joined: Fri Apr 06, 2007 11:22 pm

VSAM LDS used in DB2

Post by Chandra Shekar G R » Tue Apr 10, 2007 11:26 pm

Recently I learnt that DB2 uses a VSAM's Linear DS for managing the tablespace. Is this true? If True then KSDS,ESDS,RRDS are known to be a far better VSAM dataset against LDS why can't DB2 use them instead of LDS?
:roll:

Regards,
Chandra

Veera
Moderator
Posts: 111
Joined: Wed Feb 22, 2006 2:59 pm

Post by Veera » Wed Apr 11, 2007 5:08 am

Chandra,

For DB2 tablespace why LDSS vsam is used because of Extent consolidation i guess.

At the physical level, in DB2 each tablespace is stored in a pageset, which
consists of one or multiple VSAM ESDS data sets or LDSs.

Extent consolidation
z/OS consolidates adjacent extents for VSAM SMS managed data sets when extending on the same volume. VSAM extent consolidation is automatic and requires no action on your part. If the extents are adjacent, the new extent is incorporated into the previous extent. This means that first extent tracks as seen on ISPF 3.4 Data set level listing shows allocations larger than the primary when extents are adjacent to the primary.

There is a DFSMSdfp (Data Facility Program) limit of 123 extents per volume.

Extent consolidation continues even when an LDS exceeds what would have been 123 extents.

Its more on SYSTEM INTERNALS and related to MEMORY MANAGEMENT , some
system programers should able to explain it better.

Thanks,
Veera.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others