Automated Space Management or Sliding Space Allocation

Dinesh Srikakolapu

Automated Space Management or Sliding Space Allocation
Hello,

I am sure most of you are aware (and/or even used), Automated Space
Management or Sliding Space Allocation which is a new feature in DB2 for
z/OS V8.
This feature lets you get away without giving SECQTY while you CREATE
TABLESPACE or CREATE INDEX.
I was reading Willie Favero's blog and got really impressed with what this
can actually do for you.
However, I would like to know the experiences of others who already used
it.

How beneficial is it? Or is it just another feature...

Are there any unforeseen problems?

Not sure if this matters, but we use BMC extensively at our shop. So,
would also be interested how this new feature is handled
by them.

Any of your experiences, would be really helpful as I got to convince my
boss/team to have this feature in our shop.

DB2 V8 NFM
z/OS

Dinesh


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Myron Miller

Re: Automated Space Management or Sliding Space Allocation
(in response to Dinesh Srikakolapu)
I've been using it for about two years now and love it. Few minor issues dealing with DSN1COPY but for the most part, it works great. And has eliminated a major amount of my extent issues as well. BMC handles it just fine. It doesn't seem to automatically set the -1 for you but will allow you to change the Worklist to a -1 and run the worklist from there. And once a tablespace has been created with -1, BMC manages it just fine from then on.

I even use -1 on my priqtys and that also works great once the tablespace has been reorg'd. Once we got to Z/OS 1.8, its been even better. Need Z/OS 1.5 at the minimum to use it. But I'm sold on it.

Myron




________________________________
From: Dinesh Srikakolapu <[login to unmask email]>
To: [login to unmask email]
Sent: Thursday, January 29, 2009 5:04:42 PM
Subject: [DB2-L] Automated Space Management or Sliding Space Allocation


Hello,

I am sure most of you are aware (and/or
even used), Automated Space Management or Sliding Space Allocation
which is a new feature in DB2 for z/OS V8.
This feature lets you get away without
giving SECQTY while you CREATE TABLESPACE or CREATE INDEX.
I was reading Willie Favero's blog and
got really impressed with what this can actually do for you.
However, I would like to know the experiences
of others who already used it.

How beneficial is it? Or is it just
another feature...

Are there any unforeseen problems?

Not sure if this matters, but we use
BMC extensively at our shop. So, would also be interested how this new
feature is handled
by them.

Any of your experiences, would be really
helpful as I got to convince my boss/team to have this feature in our shop.

DB2 V8 NFM
z/OS

Dinesh


________________________________

IDUG 2009 - Europe * 5-9 October * Rome, Italy
IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Tejas Jadhav

AUTOMATED SPACE MANAGEMENT
(in response to Myron Miller)
Hiya-

We've been testing DB2 v8 Automated space management on z/OS R1.9 and
PTF UQ89517 , UK08807 already applied.

Still we are facing issue explained below :-


I've defined tablespace with NUMPART (2) , PQTY 48 SQTY-1 (i've attached
screen shots in this email) , DSSIZE 4G,

zParm -->

MAXEXTZ 'YES'
TSQTY 0
IXQTY 0

As expected the dataset should reach it's capacity of 4Gig. But in spite of
that it's reaching maximum size of dataset priort to reaching MAX Extents.
It's not following the rule of DB2 Automated space manamgement. It's
reaching max Extents in spite of reaching 4 Gig space.

Please can you tell us what is essential for DB2 Automated Space managment
to be working correct for us ?.


Thanks ,
Tejas Jadhav
[login to unmask email]




______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html