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
 
Rebuilding IMS secondary index without using Index Builder

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Hooman24

New User


Joined: 20 Sep 2012
Posts: 27
Location: US

PostPosted: Tue Mar 29, 2016 12:22 pm    Post subject: Rebuilding IMS secondary index without using Index Builder
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Mar 29, 2016 12:53 pm    Post subject: Reply to: Rebuilding IMS secondary index without using Index Builder
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: 27
Location: US

PostPosted: Tue Mar 29, 2016 2:45 pm    Post subject: Re: Reply to: Rebuilding IMS secondary index without using Index Builder
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Mar 29, 2016 3:45 pm    Post subject: Reply to: Rebuilding IMS secondary index without using Index Builder
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: 27
Location: US

PostPosted: Wed Mar 30, 2016 4:15 pm    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Wed Mar 30, 2016 5:39 pm    Post subject: Reply to: Rebuilding IMS secondary index without using Index Builder
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: 2441
Location: Netherlands, Amstelveen

PostPosted: Thu Mar 31, 2016 11:53 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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 setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm

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