Suggestions on SMS options for DB2 VSAM Datasets

Lizette Koehler

Suggestions on SMS options for DB2 VSAM Datasets
Cross posting to IBMMAIN and DB2-L







Just looking to see if there are any suggestions on how to set up a Dataclas in
ISMF for DB2 tables?



With V2.2 or V2.3 the following entries are new or some or older and maybe need
adjustments.



Space Constraint Relief



Reduce Space Up to (%)



Guaranteed Space Reduction



RMODE31 allows you to specify whether or not to allocate the buffers and control
blocks in 31-bit addressable storage.



Extended constraint removal - allows extents to go beyond 255 if set.



Any guidance appreciated.





Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately



Robert Plata

Suggestions on SMS options for DB2 VSAM Datasets
(in response to Lizette Koehler)
Might this help?

https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.3.0/com.ibm.zos.v2r3.idai600/dcdesc.htm

Robert Plata

From: Lizette Koehler <[login to unmask email]>
Sent: Tuesday, January 29, 2019 7:23 AM
To: [login to unmask email]
Subject: [DB2-L] - Suggestions on SMS options for DB2 VSAM Datasets

Cross posting to IBMMAIN and DB2-L



Just looking to see if there are any suggestions on how to set up a Dataclas in ISMF for DB2 tables?

With V2.2 or V2.3 the following entries are new or some or older and maybe need adjustments.

Space Constraint Relief

Reduce Space Up to (%)

Guaranteed Space Reduction

RMODE31 allows you to specify whether or not to allocate the buffers and control blocks in 31-bit addressable storage.

Extended constraint removal - allows extents to go beyond 255 if set.

Any guidance appreciated.


Lizette Koehler
statistics: A precise and logical method for stating a half-truth inaccurately


-----End Original Message-----

Robert Plata

Suggestions on SMS options for DB2 VSAM Datasets
(in response to Robert Plata)
My apologies, I pasted a link when I should have pasted this:

Search for:
SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2 John Iczkovits IBM March 3, 2011
There is a slide entitled: Interesting Data Class Information for DB2 Professionals

Robert Plata

From: PLATA Robert M <[login to unmask email]>
Sent: Tuesday, January 29, 2019 7:35 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Suggestions on SMS options for DB2 VSAM Datasets

Might this help?

https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.3.0/com.ibm.zos.v2r3.idai600/dcdesc.htm

Robert Plata

From: Lizette Koehler <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Tuesday, January 29, 2019 7:23 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Suggestions on SMS options for DB2 VSAM Datasets

Cross posting to IBMMAIN and DB2-L



Just looking to see if there are any suggestions on how to set up a Dataclas in ISMF for DB2 tables?

With V2.2 or V2.3 the following entries are new or some or older and maybe need adjustments.

Space Constraint Relief

Reduce Space Up to (%)

Guaranteed Space Reduction

RMODE31 allows you to specify whether or not to allocate the buffers and control blocks in 31-bit addressable storage.

Extended constraint removal - allows extents to go beyond 255 if set.

Any guidance appreciated.


Lizette Koehler
statistics: A precise and logical method for stating a half-truth inaccurately


-----End Original Message-----

-----End Original Message-----