Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm
No new posts How to find Table-space and Index-spa... venksiv DB2 5 Wed Feb 03, 2016 6:16 pm
No new posts VTS and space BobGilbert All Other Mainframe Topics 2 Mon Jan 11, 2016 5:08 am
No new posts Task management through REXX kenshin CLIST & REXX 5 Wed Sep 30, 2015 10:41 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us