Query on IMS Secondary index

IMS DB database, DL/I commands etc

Moderator: Moderator Group

Post Reply
Posts: 4
Joined: Tue Jun 25, 2013 10:55 am

Query on IMS Secondary index

Post by sikanritun » Tue Jun 25, 2013 11:06 am

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.


Posts: 12
Joined: Tue Jan 14, 2014 1:20 pm

Post by payilagamch » Fri Jan 17, 2014 8:10 am

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.
Payilagam Chennai

Posts: 2
Joined: Wed Dec 02, 2015 9:09 am

Post by Fradygor » Wed Dec 02, 2015 9:29 am

Gateway to the exotic, try to use the services of this website as well.


Topic deleted by Admin

Post by academyindia4 » Tue Jan 19, 2016 7:05 pm

<< Content deleted By Admin >>

Post Reply


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.
Mainframe Interview questions

Other References
Mainframe Tools and others