Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
Find Index PieceSize

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

Active Member

Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Feb 19, 2015 8:12 pm    Post subject: Find Index PieceSize
Reply with quote


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    Post subject:
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.

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 Java Batch launcher JVMPRC86 does not... harisukumaran IBM Tools 2 Wed Apr 15, 2020 12:37 am
No new posts Issue in KWIKKEY utility while creat... mpanda JCL & VSAM 2 Wed Jan 08, 2020 6:37 pm
This topic is locked: you cannot edit posts or make replies. VSE COBOL - File Status 46 when readi... dennis larson COBOL Programming 8 Fri Jan 03, 2020 11:46 pm
No new posts Adding FIND to ISPF Panel display of ... Harold Barnes TSO/ISPF 3 Mon Oct 07, 2019 5:46 pm
No new posts Query on secondary index Suja.Sai IMS DB/DC 1 Wed Oct 31, 2018 9:47 pm

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