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
 

 

Query on maintain index utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
rajasekar2810

New User


Joined: 22 Apr 2008
Posts: 6
Location: india

PostPosted: Wed Aug 27, 2008 12:57 am    Post subject: Query on maintain index utility
Reply with quote

Folks,

Can any one help me in using the Maintain Index utility.
I have written one jcl which uses a maintain index utiity statement to rebuild index of database record and however not successful in doing that.

I am getting a file IO error which says cannot open the datbase file.

can any one tell me how actually the maintain index works and whats happening with the data base record while we use this utility.

My understanding is that if we use maintain index and try to rebuild a index using member records it will sweep the database area and search for the disconnected members and try to create the key values again for that members.

Could you please advice me in this.Also if any one post me a sample jcl it will be more useful.
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: Wed Aug 27, 2008 1:19 am    Post subject:
Reply with quote

Hello and welcome to the forums,

Your best bet is to talk with your dba.

There should be standard jcl for your system and that should be used - not something posted in a forum.

The dba will also know how to use the utility and can provide guidance.
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 -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm


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