View previous topic :: View next topic
|
Author |
Message |
rajasekar2810
New User
Joined: 22 Apr 2008 Posts: 6 Location: india
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|