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

Rebuilding IMS secondary index without using Index Builder


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Hooman24

New User


Joined: 20 Sep 2012
Posts: 35
Location: US

PostPosted: Tue Mar 29, 2016 12:22 pm
Reply with quote

How can we add a Secondary Index database to a HALDB database without using Index builder Utility?

We have lost our secondary database for an operational database. Now we want to rebuild it, unfortunately we don't have Index Builder, so we have to build it manually.

It seems the process is to unload the database and reload it again:

https://www.ibm.com/support/knowledgecenter/SSEPH2_13.1.0/com.ibm.ims13.doc.dag/ims_addingasecondaryindex.htm

however by doing unload/reload we couldn't create secondary index(secondary index DB remains empty).

Does anyone know how to rebuild the database, since in some of our programs we get 0880 ABEND.

Thanks in advanced
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Tue Mar 29, 2016 12:53 pm
Reply with quote

Presumably your main strategy to deal with a trashed-beyond-repair database is backups?

I'd do some search-engineing for an IMS LISTSERV (a mailing list) to find a number of specialists.
Back to top
View user's profile Send private message
Hooman24

New User


Joined: 20 Sep 2012
Posts: 35
Location: US

PostPosted: Tue Mar 29, 2016 2:45 pm
Reply with quote

Bill Woodger wrote:
Presumably your main strategy to deal with a trashed-beyond-repair database is backups?

I'd do some search-engineing for an IMS LISTSERV (a mailing list) to find a number of specialists.


Thank you Bill. Unfortunately in this case there is no reliable backup on secondary index DB.

I hope there is an administrative utility for that. Because it is a huge database and I don't know whether reading the database by GU/GN and ISRT to DB is a good option or not, regarding performance.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Tue Mar 29, 2016 3:45 pm
Reply with quote

Yoiks. You need to fix, test and verify your backups immediately as well. Not only for this DB, but for any other DB backups, review for the same issue. Plus, if possible for the issue to exist in non-DB backups, review that as well.
Indeed review your backups full-stop. Once bitten, twice shy.

Register and ask on that mailing list.
Back to top
View user's profile Send private message
Hooman24

New User


Joined: 20 Sep 2012
Posts: 35
Location: US

PostPosted: Wed Mar 30, 2016 4:15 pm
Reply with quote

I will be appreciated if anyone can help me on this issue.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Wed Mar 30, 2016 5:39 pm
Reply with quote

Well, life is sometimes tough. We don't have much regular IMS expertise here at the moment, which is why I suggested something else.

You can wait and hope, that is up to you, but there's no point in trying to encourage an answer.

If you do get a resolution, it would be useful to post it here.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2476
Location: Netherlands, Amstelveen

PostPosted: Thu Mar 31, 2016 11:53 am
Reply with quote

If there was a solution there was no need for Index builder Utility.

So why don't you obtain Index builder Utility from IBM?
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 -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts choice of clustering index DB2 3
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts Issue in KWIKKEY utility while creat... JCL & VSAM 2
This topic is locked: you cannot edit posts or make replies. VSE COBOL - File Status 46 when readi... COBOL Programming 8
Search our Forums:

Back to Top