Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Automated Space Management

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dinesh_deadman
Warnings : 1

New User


Joined: 10 Aug 2007
Posts: 38
Location: Chicago

PostPosted: Fri Jan 09, 2009 2:04 am    Post subject: Automated Space Management
Reply with quote

Hello,

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.

Dinesh Karthik
Back to top
View user's profile Send private message

senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Sat Jan 10, 2009 2:31 am    Post subject:
Reply with quote

Hi,

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.


Thanks
Senthil
Back to top
View user's profile Send private message
dinesh_deadman
Warnings : 1

New User


Joined: 10 Aug 2007
Posts: 38
Location: Chicago

PostPosted: Tue Jan 13, 2009 1:03 am    Post subject: Senthilssg
Reply with quote

Senthil,

You know what, you are the first person to repond to this post. Infact, I posted the same question in multiple forums, but yet to see any response - besides yours. Thank you very much.

Anyway, I request you to be more specific. Do you mean that we would NEVER have -904 for 'max extent reached' problems?

2. 'Unnecessary Reorgs for changing Secondary Qty with ALTER TABLESPACE/INDEX statement' - Once you turn this feature on, you would never have to ALTER TABLESPACE/INDEX for SECQTY?

or am I being too greedy...

Also, could you tell me how this feature handles when you create datasets with 16G size and 10,000 cyls per partition, what would be the SECQTY then?

Any other benefits/problems you have experienced...

I would be really thankful to you if you can answer these questions as like I said, I got to convince my team to have this feature in our shop.

Dinesh Karthik
Back to top
View user's profile Send private message
dinesh_deadman
Warnings : 1

New User


Joined: 10 Aug 2007
Posts: 38
Location: Chicago

PostPosted: Tue Jan 13, 2009 1:09 am    Post subject: Also...
Reply with quote

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?

Please clarify.

Dinesh Karthik
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts The TS7720 is out of cache space. Rex Montemayor All Other Mainframe Topics 2 Mon Sep 25, 2017 7:18 am
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts Need inputs on Space requirement and... ashek15 IMS DB/DC 0 Sat Apr 01, 2017 8:26 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us