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: 1020
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 To find whether record count are true... DFSORT/ICETOOL 6
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Cobol file using index COBOL Programming 2
No new posts Find the occurrence of Key Field (Par... DFSORT/ICETOOL 6
No new posts Find a record count/numeric is multip... COBOL Programming 1
Search our Forums:

Back to Top