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
 

 

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: 18
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: 7223

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: 18
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: 7223

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: 18
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: 7223

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: 2422
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 Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts SFTP to primary and secondary servers mallik4u JCL & VSAM 4 Tue Jun 07, 2016 12:52 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm
No new posts SUM file with secondary sorted file cdelaf32 SYNCSORT 9 Mon Apr 25, 2016 10:20 pm


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