Dear All,
I am new to IMS DB & DC. I wanted to know how to define secondary index . Followings are my questions
1. Do i need to have another secondary database created ? My original Database does not have LCHILD and XDFLD field names.
2. If i create another database having LCHILD and XDFLD, how will i load data into it? i loaded my original data thru program using LS proc option.
Note: i am comparing with the concept of VSAM where we create ALT index after base cluster and BUILD it after.
Thanks For help in advance.
Regards
SikanRitun
Query on IMS Secondary index
Moderator: Moderator Group
-
- Member
- Posts: 12
- Joined: Tue Jan 14, 2014 1:20 pm
- Contact:
Yes you have to create a secondary index database . LCHILD and XDFLD of original DB and secondary index should point to each other. Basically it is done in DBDGEN. Please contact your DBA to get it done. Application programmer has to just use the secondary index database name in the PROCSEQ parameter of PCB. and use the secondary index key field in the SSA.
Suggest you to contact your IMS DBA for creating secondary index for an existing DB.
Suggest you to contact your IMS DBA for creating secondary index for an existing DB.
Payilagam Chennai
www.payilagam.com
www.payilagam.com
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page