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

Secondary Index concept in IMS DB


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

New User


Joined: 04 Jun 2007
Posts: 5
Location: chennai

PostPosted: Fri Jun 29, 2007 4:29 pm
Reply with quote

Hi,

i am not working on Ims db, but i know. i want a little bit explanation of Secondary Index concept.

Regards,
sree.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jun 29, 2007 7:22 pm
Reply with quote

Hello,

A secondary index in IMS (as well as vsam, db2, and any other database) provides additonal direct access to rows.

For example an "employee" table might have a primary key of "employee_id". Each employee also has their current department code in their employee table entry. If dept_no was a secondary index, a query could directly retrieve all of the people in a specific department without traversing the entire table.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Fri Jun 29, 2007 9:33 pm
Reply with quote

I wonder why I posted the sticky telling people where to find information about IMS icon_cry.gif Again: following the first link in this sticky and searching for 'SECONDARY INDEX' i.e. leads to this, and there's a lot more to find.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sat Jun 30, 2007 10:04 am
Reply with quote

srinis Refer to
Quote:
d.sch.
post which has generic concept of secondary indexing.

Bitneuker Not everyone looks at the sticky or the links. People need direct answers without spending much time in reading the manuals or understanding the full concept.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Sat Jun 30, 2007 11:15 pm
Reply with quote

Quote:
Bitneuker Not everyone looks at the sticky or the links. People need direct answers without spending much time in reading the manuals or understanding the full concept.


Devzee: They should IMHO. The original question posted tells us the guy wants to understand S.I. He didn't post a direct question to solve any problem so in this case I think leading him to the information via links is a good option. Please take my original post as 'non posted'.
Back to top
View user's profile Send private message
autobox

New User


Joined: 19 Aug 2005
Posts: 51

PostPosted: Tue Jul 03, 2007 1:44 pm
Reply with quote

Simplly put, Secondary Index is that you can use a key other than the original key of root segment to access a certain segment occurence directly.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Jul 04, 2007 4:56 pm
Reply with quote

Using an IMS utility to build secondary indices as individual databases is fast. You then read the secondary index as a database. Talk to your DBA. I wrote an HR system with 5 secondary indices. It worked great!
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 Execute secondary panel of sdsf with ... CLIST & REXX 1
No new posts Cobol file using index COBOL Programming 2
No new posts DL/I status code AK for GU call using... IMS DB/DC 1
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts choice of clustering index DB2 3
Search our Forums:

Back to Top