IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Find Index PieceSize


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Feb 19, 2015 8:12 pm
Reply with quote

Hi,

I am working on one DB2 sizing report and I want to find out max number of index pieces allowed for an index and maximum piece size for that index.

Db2 sql reference v10 - Page 1236 has some logic to find out but i am not able to put that in a sql statement.

Can you please help me writing a SQL query to find this information for all the indexes in the system?
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1018
Location: India

PostPosted: Fri Feb 27, 2015 4:15 pm
Reply with quote

Hi Bharat,

Have you checked this out : Calculate storage capacity of indexes in DB2 for z/OS

Download the zip file once you finish reading.

Thanks,
Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts How to find which file contains my se... DFSORT/ICETOOL 6
No new posts NOT ABLE TO FIND DB2 ROWS DB2 2
No new posts Java Batch launcher JVMPRC86 does not... IBM Tools 2
No new posts Issue in KWIKKEY utility while creat... JCL & VSAM 2
Search our Forums:

Back to Top