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
 

 

Piecesize Of an Index

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

New User


Joined: 03 Feb 2010
Posts: 9
Location: India

PostPosted: Mon Sep 24, 2012 2:14 pm    Post subject: Piecesize Of an Index
Reply with quote

Can anyone tell me what it means when an index has PIECESIZE as 0?

Thanks,
Jyothsna
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 24, 2012 6:58 pm    Post subject:
Reply with quote

Hello,

At the top of the page is a link to "IBM Manuals". In the db2 sql reference, read about CREATE INDEX. PIECESIZE is described there.

We are Not a manual reading service . . .
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Sep 24, 2012 9:30 pm    Post subject: Reply to: Piecesize Of an Index
Reply with quote

I checked the manuals... I dont think we can specify PIECESIZE 0

As per the manual

PIECESIZE integer
Specifies the maximum addressability of each data set for a secondary index. The PIECESIZE clause can only be specified for secondary indexes.

Be aware that when you alter the PIECESIZE value, the index is placed into page set REBUILD-pending (PSRBD) status. The entire index space becomes inaccessible. You must run the REBUILD INDEX or the REORG TABLESPACE utility to remove that status.
The subsequent keyword K, M, or G, indicates the units of the value that is specified in integer.
K
Indicates that the integer value is to be multiplied by 1024 to specify the maximum data set size in bytes. integer must be a power of two between 256 and 67108864.
M
Indicates that the integer value is to be multiplied by 1048576 to specify the maximum data set size in bytes. integer must be a power of two between 1 and 65536.
G
Indicates that the integer value is to be multiplied by 1073741824 to specify the maximum data set size in bytes. integer must be a power of two between 1 and 64.
Table 1 shows the valid values for data set size, which depend on the size of the table space.
Table 1. Valid values of PIECESIZE clauseK units M units G units Size attribute of table space
256K
512K
1024K 1M
2048K 2M
4096K 4M
8192K 8M
16384K 16M
32768K 32M
65536K 64M
131072K 128M
262144K 256M
524288K 512M
1048576K 1024M 1G
2097152K 2048M 2G
4194304K 4096M 4G LARGE, DSSIZE 4G (or greater)
8388608K 8192M 8G DSSIZE 8G (or greater)
16777216K 16384M 16G DSSIZE 16G (or greater)
33554432K 32768M 32G DSSIZE 32G (or greater)
67108864K 65536M 64G DSSIZE 64G

The data set size limit for partitioned table spaces with more than 256 partitions is 4096.

Link - http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_sql_alterindex.htm

Please correct me if I am wrong?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Tue Sep 25, 2012 12:04 am    Post subject:
Reply with quote

dick scherrer wrote:
We are Not a manual reading service

apparently we are. also, a manual reprint service.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue Sep 25, 2012 8:02 pm    Post subject:
Reply with quote

I was just confirming it... May be i could be missing something.
Back to top
View user's profile Send private message
cvishu

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Fri Oct 24, 2014 11:26 pm    Post subject: Reply to: Piecesize Of an Index
Reply with quote

what does PIECESIZE 0 represent , i do see table indexes that have PICESIZE as 0 in SYSIBM.SYSINDEXES , am not sure what it represents .

We are trying to reduce the DASD usage , and are changing the PIECESIZE which has low values to 2G so that the number of datasets is reduced , but i see some with 0 am not sure what it means
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 setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm


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