Data cluster or Index ?

Prashant Kalal

Data cluster or Index ?
Hi Group , I have a question wrt DB2 tablespace dataset . Given that we
have the TS/IX underlying cluster name , properties IE (listcat) etc either for a
segmented or for a partitioned TS . Is it possible to identify with this
information whether this cluster dataset if for a index or for Table space.
Briefly given the cluster name I need to know if its for index or not ? Any help
or pointers of how to identify . Please advise.


DBA IMS/DB2
----------------------

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Patrick Steurs

Re: Data cluster or Index ?
(in response to Prashant Kalal)
Hi,

I created to sms-groups in the job DSNTIJUZ

SMSDCFL=DCDB2TBL,
SMSDCIX=DCDB2IDX,

SMSDCFL specifies a DFSMS data class for table spaces. If you assign a value to SMSDCFL, DB2 specifies that value when it uses Access Method Services to define a data set for a table space. If the value of SMSDCFL is one or more blanks, DB2 does not specify a data class when it creates data sets for table spaces.
SMSDCIX specifies a DFSMS data class for indexes. If you assign a value to SMSDCIX, DB2 specifies that value when it uses Access Method Services to define a data set for an index. If the value for SMSDCIX is one or more blanks, DB2 does not specify a data class when it creates data sets for indexes.

These parameters can be found in the listcat utility.

Sample for an index :
LISTC ALL ENT('DB237.DSNDBC.BCDB01.BCDXIAB1.I0001.A001')

CLUSTER ------- DB237.DSNDBC.BCDB01.BCDXIAB1.I0001.A001
IN-CAT --- CAT3P.UUCAT.DB37BASE
HISTORY
DATASET-OWNER----SYSAD37 CREATION--------2009.311
RELEASE----------------2 EXPIRATION------0000.000
SMSDATA
STORAGECLASS ---SCDB2IDX MANAGEMENTCLASS---(NULL)
DATACLASS ------DCDB2IDX LBACKUP ---0000.000.0000
BWO STATUS------00000000 BWO TIMESTAMP---00000 00:00:00.0
BWO---------------(NULL)

Sample for a tablespace :
LISTC ALL ENT('DB237.DSNDBC.BCDB01.BCDB0101.I0001.A001')

CLUSTER ------- DB237.DSNDBC.BCDB01.BCDB0101.I0001.A001
IN-CAT --- CAT3P.UUCAT.DB37BASE
HISTORY
DATASET-OWNER----SYSAD37 CREATION--------2009.213
RELEASE----------------2 EXPIRATION------0000.000
SMSDATA
STORAGECLASS ---SCDB2TBL MANAGEMENTCLASS---(NULL)
DATACLASS ------DCDB2TBL LBACKUP ---0000.000.0000
BWO STATUS------00000000 BWO TIMESTAMP---00000 00:00:00.0
BWO---------------(NULL)

greetings,

Patrick Steurs

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Prashant Kalal
Sent: woensdag 30 december 2009 10:32
To: [login to unmask email]
Subject: [DB2-L] Data cluster or Index ?

Hi Group , I have a question wrt DB2 tablespace dataset . Given that we
have the TS/IX underlying cluster name , properties IE (listcat) etc either for a
segmented or for a partitioned TS . Is it possible to identify with this
information whether this cluster dataset if for a index or for Table space.
Briefly given the cluster name I need to know if its for index or not ? Any help
or pointers of how to identify . Please advise.


DBA IMS/DB2
----------------------

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

James Campbell

Re: Data cluster or Index ?
(in response to Patrick Steurs)
There is nothing intrinsic in a cluster/data component name that differentiates between those
used by tablespaces and those used by indexspaces. Often, but not always, site naming
conventions will help.

The only way to know is by reference to
SYSIBM.SYSTABLEPART/SYSINDEXPART.VCATNAME
SYSIBM.SYSTABLESPACE/SYSINDEXES.DBNAME
SYSIBM.SYSTABLESPACE.NAME / SYSIBM.SYSINDEXES.INDEXSPACE

James Campbell

On 30 Dec 2009 at 9:31, Prashant Kalal wrote:

> Hi Group , I have a question wrt DB2 tablespace dataset . Given that we
> have the TS/IX underlying cluster name , properties IE (listcat) etc either for a
> segmented or for a partitioned TS . Is it possible to identify with this
> information whether this cluster dataset if for a index or for Table space.
> Briefly given the cluster name I need to know if its for index or not ? Any help
> or pointers of how to identify . Please advise.
>
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L