LIM upgraded the implementation of Index Constituent Data on your MIM server to include this information as a MIM symbol (relation) rather than component text files. These component files were originally accessed under /home/lim/dates/user/COMPONENTS. These component files will be removed effective 8/19/2005. This will required users to change the way they are used. Any queries that reference the component files will no longer run, so users will need to use the new relation names. If you have any questions, please contact a LIM Customer Support Representative at: support@lim.com.

Use the Index Constituent Utility to see how alias names are mapped to constituent names for each of the Index Constituent categories. The initial upgrade includes the Dow 30, Nasdaq, Russell 1000, Russell 2000, S&P 400, S&P 500, S&P 600, S&P 1500 and S&P Toronto Composite.

All the constituents are located in the schema in this path:

  TopRelation:Equities:UnitedStates:Constituents
  TopRelation:Equities:Canada:Constituents

The Index Constituent Utility is located in the $LIMHOME/xmim/bin directory in MIM server releases 4.5.25
and higher.

Usage:

xmim_get_constituents [-h] [-q host] [-p server_number] [-d database] [-r relation]

where:

-h Open the help pages (optional)
-q host Enter the hostname
-p server_number Enter the server number
-d database Specify the database location (optional)
-r relation Enter the category name to only list that portion of relation names and aliases (optional)
 

Example:

The following example will produce the original file which was distributed to /home/lim/dates/user/COMPONENTS/GII.DJIA from the warehouse.

$ xmim_get_constiuents –q localhost –p 0 –r Index_DJIA >/home/lim/dates/user/COMPONENTS/GII.DJIA

This should be used for transition into the new syntax. In the future, the dates folder directories may not exist.

The following example will print the contents of all of the constituents folders on a server.

$ xmim_get_constituents –q localhost –p 0

Constituents (category)
        DowJones (category)
                Index_DJIA (category)
                        DJIA.AA -> GII.AA.NYSE
                        DJIA.AIG -> GII.AIG.NYSE
                        DJIA.AXP -> GII.AXP.NYSE
                        DJIA.BA -> GII.BA.NYSE
                        DJIA.C -> GII.C.NYSE
                        DJIA.CAT -> GII.CAT.NYSE
                        DJIA.DD -> GII.DD.NYSE
                        DJIA.DIS -> GII.DIS.NYSE
                        DJIA.GE -> GII.GE.NYSE
                        DJIA.GM -> GII.GM.NYSE
                        DJIA.HD -> GII.HD.NYSE
                        DJIA.HON -> GII.HON.NYSE
                        DJIA.HPQ -> GII.HPQ.NYSE
                        DJIA.IBM -> GII.IBM.NYSE
                        DJIA.INTC -> GII.INTC.NASDAQ
                        DJIA.JNJ -> GII.JNJ.NYSE
                        DJIA.JPM -> GII.JPM.NYSE
                        DJIA.KO -> GII.KO.NYSE
                        DJIA.MCD -> GII.MCD.NYSE
                        DJIA.MMM -> GII.MMM.NYSE
                        DJIA.MO -> GII.MO.NYSE
                        DJIA.MRK -> GII.MRK.NYSE
                        DJIA.MSFT -> GII.MSFT.NASDAQ
                        DJIA.PFE -> GII.PFE.NYSE
                        DJIA.PG -> GII.PG.NYSE
                        DJIA.SBC -> GII.SBC.NYSE
                        DJIA.UTX -> GII.UTX.NYSE
                        DJIA.VZ -> GII.VZ.NYSE
                        DJIA.WMT -> GII.WMT.NYSE
                        DJIA.XOM -> GII.XOM.NYSE

        Nasdaq (category)
                Index_NASD100 (category)
                        NASD100.AAPL -> GII.AAPL.NASDAQ
                        NASD100.ADBE -> GII.ADBE.NASDAQ
                        NASD100.ADSK -> GII.ADSK.NASDAQ
                        NASD100.ALTR -> GII.ALTR.NASDAQ
                        NASD100.AMAT -> GII.AMAT.NASDAQ
                        NASD100.AMGN -> GII.AMGN.NASDAQ
                        NASD100.AMZN -> GII.AMZN.NASDAQ
                        NASD100.APCC -> GII.APCC.NASDAQ
                        NASD100.APOL -> GII.APOL.NASDAQ
                        NASD100.ATYT -> GII.ATYT.NASDAQ
                        NASD100.BBBY -> GII.BBBY.NASDAQ
                        NASD100.BEAS -> GII.BEAS.NASDAQ
                        NASD100.BIIB -> GII.BIIB.NASDAQ
                        NASD100.BMET -> GII.BMET.NASDAQ
                        NASD100.BRCM -> GII.BRCM.NASDAQ
                        NASD100.CDWC -> GII.CDWC.NASDAQ