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
 

 

Question related to REBUILD INDEX

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

New User


Joined: 02 Apr 2006
Posts: 10
Location: Dalian.China

PostPosted: Wed Apr 05, 2006 12:18 pm    Post subject: Question related to REBUILD INDEX
Reply with quote

Hello,

Can anybody help me to understand the following code:

Code:
REBUILD  INDEX (DB2ADMR.IDX0RX4)
SORTDEVT SYSDA SORTNUM 250 SORTKEYS STATISTICS


especially the second row .. Thanks in advance!!
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 287
Location: Basel, Switzerland

PostPosted: Wed Apr 05, 2006 3:03 pm    Post subject:
Reply with quote

hy pch1982cn,

REBUILD INDEX reconstructs indexes from the table that they reference.

SORTDEVT device-type
Specifies the device type for temporary data sets to be
dynamically allocated by DFSORT. It can be any device type
acceptable to the DYNALLOC parameter of the SORT or OPTION
options for DFSORT, as described in DFSORT Application
Programming: Guide.

device-type is the device type.

SORTNUM integer Specifies the number of temporary data sets to be
dynamically allocated by the sort program. If you omit
SORTDEVT, SORTNUM is ignored. If you use SORTDEVT and omit
SORTNUM, no value is passed to DFSORT. It is allowed to
take its own default.

integer is the number of temporary data sets.

STATISTICS Specifies the gathering of index statistics.

martin9
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 Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Fault Analyzer - listings question. egrove IBM Tools 4 Thu Aug 11, 2016 5:31 pm
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 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


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