Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 290
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 question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am
No new posts Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts QUESTION: RETURN CHANNEL pahiker CA Products 21 Thu Apr 20, 2017 12:31 am

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