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 Cobol code- to find a string in a str... COBOL Programming 3
No new posts Find library of PGM TSO/ISPF 10
This topic is locked: you cannot edit posts or make replies. REXX to find /* Define and write the ... CLIST & REXX 5
No new posts Cant find hex value using IFTHEN=(WHEN DFSORT/ICETOOL 12
No new posts Add column to existing records using ... JCL & VSAM 2
Search our Forums:

Back to Top