SMS or DB2

Hissam Tressa K

SMS or DB2

We have a project running loads against 6 tables that have 53 parts each.
We are using SMS to manage the datasets and the DASD is defined EA-enabled
and the data class is defined to allow the datasets to span 5 volumes. It
seems like DB2 is overriding the data class and not allowing the dataset to
jump to the next volume to get additional extents. We have been working on
this all weekend and have done an IDCAMS ADDVOLS to each dataset - which
worked until the load ran and the five volume allowance disappeared. Is
there something within DB2 that could be overriding the SMS data class and
if so what? Or is there some kind of quirky thing between DB2 and SMS?

TIA
Tressa Hissam
Treasury

Raymond Bell

Re: SMS or DB2
(in response to Hissam Tressa K)
Tressa,

At the last site I was at I had a play with extended addressability
tablespaces/indexes. We were using BMC's LoadPlus at the time, as IBM's
load (V6) didn't have the functionality we needed (loading a literal into
one of the columns). We ran into the same problem you describe i.e. the
tablespaces not extending onto a 2nd volume. We fixed it but here's the
killer; I don't quite remember how. If you have a look in the archives and
search for 'extended addressability' or maybe just 'EA' you'll find the
discussion.


Raymond
PS. Something to do with the size of the tablespace, I think. Not too big
(we had 13GB partitions) but too small, if I (doubtfully) remember
correctly.



Hissam Tressa K
<Tressa.K.Hissa To: [login to unmask email]
[login to unmask email]> cc:
Sent by: DB2 Subject: SMS or DB2
Data Base
Discussion List
<[login to unmask email]
>


08/01/02 04:19
Please respond
to DB2 Data
Base Discussion
List








We have a project running loads against 6 tables that have 53 parts each.
We are using SMS to manage the datasets and the DASD is defined EA-enabled
and the data class is defined to allow the datasets to span 5 volumes. It
seems like DB2 is overriding the data class and not allowing the dataset to
jump to the next volume to get additional extents. We have been working on
this all weekend and have done an IDCAMS ADDVOLS to each dataset - which
worked until the load ran and the five volume allowance disappeared. Is
there something within DB2 that could be overriding the SMS data class and
if so what? Or is there some kind of quirky thing between DB2 and SMS?


TIA
Tressa Hissam
Treasury



Raymond Bell

Re: SMS or DB2
(in response to Raymond Bell)
Tressa,

Found it. Are you using LoadPlus? The problem was a combination of
LoadPlus and having tablespaces managed by EA-enabled data classes that
didn't have DSSIZE > 4GB. In the end we (I think) set up or EA-enabling
data classes so that they'd only manage objects with DSSIZE > 4GB. It we
didn't, LoadPlus wasn't issuing 'alter blah.blah addvol' statements against
the clusters so one volume was all we got.

The archives give more details, but hopefully you get the gist.


Raymond
PS. As your 'Subject:' is written, the answer is, 'neither'.
PPS. As I've been burnt before, these comments are borne from personal
experience and do not necessarily reflect those of my current client, IBM
New Zealand.