Automated Space Management or Sliding Space Allocation 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. It looked cool to me. However, I would like to know the experiences of others who already used it.
Is it beneficial or not?
Are there any unforeseen problems?
Or is it just another feature with no great benefits?
Any of your experiences with this, would be really helpful.
It is really useful feature. It will avoid the -904 resource unavailable due to max extent reached problems and also unnecessary Reorgs for changing Secondary Qty with ALTER TABLESPACE / INDEX statement.
Senthil - one more question. Once you have this feature on, you do not have to specify SECQTY while creating TS/IX. However, what if you still mention a non-zero number there? would DB2 take the number you gave or it ignores the number you gave and let this feature 'Automated Space Management' handle this?
I understand that, it takes the number you mentioned. Unless it is 'NOTHING' there, it does not let ASM handle it. Is that correct?