IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Question related to REBUILD INDEX


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 290
Location: Basel, Switzerland

PostPosted: Wed Apr 05, 2006 3:03 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts RACF - Rebuild SETROPTS command which... All Other Mainframe Topics 3
No new posts Question for file manager IBM Tools 7
No new posts Cobol file using index COBOL Programming 2
No new posts question for Pedro TSO/ISPF 2
No new posts question on Outrec and sort #Digvijay DFSORT/ICETOOL 20
Search our Forums:

Back to Top