#!/bin/sh
#*******************************************************************************
#             PACOR II SOFTWARE
#       Property of the U.S. Government
#            NASA/GSFC/Code 560
#*******************************************************************************
#PURPOSE: Creates the indices for the ACE database.
#
#INVOCATION METHOD: IndexBuilder user/pw 
#
#
# EXTERNAL VARIABLES:
# Source               Name               Type   Use  Description
# ----------------------------------------------------------------------------
# acedps_db.create  	DPS_DB_BUILD_HOME     char    I   location of db build scripts
#
#DEVELOPMENT HISTORY:
#
#	Author		Change-ID	Release	Date	Description of Change
#	------		---------	-------	----	---------------------
#    P. Matthews	B4R2.1           11/07/94       Initial release 
#    P. Matthews        PAC2951011       03/24/95       Sized indexes for 
#                                                        operations and distributed
#                                                        them across multiple disks
#    M. Rauschenberger  PAC2951002	 04/05/95       Removed Index for
#						     db_GroundTerminalInterfaceChnl
#    J. Whelan          PAC2951406       07/27/95       Modified pdp_ProductFileFormat
#                                                        index to sizing analysis
#    I. Horowitz         N/A           R1.0  10/09/95	Added ACE indexes, merged in
#                                                        PDPS indexes
#    I. Horowitz         N/A        ACE R1.0 02/23/96   Replaced db_ProdFileDeliveryAcct
#							 with db_ProductXfer
#    I. Horowitz        ACE0615     ACE R2.0 06/26/96   Added line for db_PEConfiguration
#    I. Horowitz          n/a     TRACE R1.0 05/07/96   Adapted for TRACE
#    J. Raymond         PAC2951415      R3.2 08/09/96   Added db_FilterRates
#    J. Whelan		PAC2961590      R3.2 09/24/96   Added db_PMSSInputLine and
#							  db_ScheduleDisplayDefaults;
#							  Removed db_DataLine and
#							  db_MissionDataLine.
#    I. Horowitz        TRACE0105  TRACE R2.0 02/05/97  Merged PACOR II R3.2 changes
#    R. Wiechert        WIND970001       R1.0 07/17/97  Added db_DUS and db_SessionHeader
#    R. Wiechert        WIND970001       R1.0 09/14/97  Increased INITIAL, NEXT for
#                                                        pdp_hash_index by factor of 10.
#    R. Wiechert        WIND970001 R1.0b      11/21/97  Resized everything
#    R. Wiechert        ISTP             R1.2 04/21/98  Integrate with dps_db.create
#
#NOTES:
#
#*********************************************************************************
if test $# -ne 1
then
   echo ""
   echo "***********************************************"
   echo "Error, you must enter an Oracle UserID/Password"
   echo "***********************************************"
   exit
fi

echo ""
echo "************************************"
echo "  Creating DPS Database Indexes  "
echo "************************************"

if [ "$DPS_DB_RESIZE" = small ]
then
################################################################################################
#
#           S M A L L     C O N F I G U R A T I O N
#
################################################################################################
$DPS_DB_BUILD_HOME/db_AppDestDefaults.indx              $1 static_index    14    14    0 1 20
$DPS_DB_BUILD_HOME/db_ChnlInformation.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_DataRate.indx                     $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_DataSource.indx                   $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_DDFTransmissionConfig.indx        $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_DestinationCatalog.indx           $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_DestinationFacility.indx          $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FddiFELookup.indx                 $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_FilterRates.indx                  $1 static_index     8     8    0 1 20
$DPS_DB_BUILD_HOME/db_FrameSyncSetup.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FSFilterSetup.indx                $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FSFilterValue.indx                $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_GroundTerminal.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_GroupDestination.indx             $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_HST_PKSetup.indx                  $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_Message.indx                      $1 static_index    12    12    0 1 20
$DPS_DB_BUILD_HOME/db_MissionCatalog.indx               $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDataRate.indx              $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_MissionDataStreamIDCatalog.indx   $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDestination.indx           $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_MissionStation.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_MissionSupportID.indx             $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_MissionThresholds.indx            $1 static_index     6     6    0 1 20
$DPS_DB_BUILD_HOME/db_NetworkID.indx                    $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_OracleLogin.indx                  $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PacketizationPath.indx            $1 static_index    10    10    0 1 20
$DPS_DB_BUILD_HOME/db_PDPConfiguration.indx             $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PEConfiguration.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PFCSetup.indx                     $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_PKSetup.indx                      $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_PMSSInputLine.indx                $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_POCCWindow.indx                   $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ProductHost.indx                  $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceCatalog.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceConstituentDefaults.indx  $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceDevices.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_RSBSSetup.indx                    $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RSDSetup.indx                     $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTMissionSetup.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSConfig.indx                   $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSPortNum.indx                  $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ScheduleDisplayDefaults.indx      $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ScheduleOption.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ScheduleSource.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_SIDSetup.indx                     $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_SQAFIPSetup.indx                  $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_Station.indx                      $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_TerminalLocation.indx             $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_UserAccessLevel.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_UserCategory.indx                 $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_UserLevel.indx                    $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/pdp_GroupIds.indx                    $1 static_index     4     4    0 1 20
 
$DPS_DB_BUILD_HOME/db_AcqSessionCharacteristics.indx    $1 dynamic_index    18    18    0 1 10
$DPS_DB_BUILD_HOME/alt_AcqSessionCharacteristics.indx   $1 dynamic_index    28    28    0 1 10
$DPS_DB_BUILD_HOME/db_AppDestSchedule.indx              $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_CTMStatus.indx                    $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_DANIndx.indx                      $1 dynamic_index    36    36    0 1 10
$DPS_DB_BUILD_HOME/db_EventLog.indx                     $1 dynamic_index   302   302    0 1 5
$DPS_DB_BUILD_HOME/db_FESessionAcct.indx                $1 dynamic_index    20    20    0 1 10
$DPS_DB_BUILD_HOME/db_FEUnselVCAcct.indx                $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FEVcAppAcct.indx                  $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FEVirtualChannelAcct.indx         $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_GPGroupIndx.indx                  $1 dynamic_index  3686  3686    0 1 5
$DPS_DB_BUILD_HOME/db_GPProductIndx.indx                $1 dynamic_index    36    36    0 1 5
$DPS_DB_BUILD_HOME/db_GroupSequenceNumbers.indx         $1 dynamic_index   166   166    0 1 5
$DPS_DB_BUILD_HOME/db_HST_SessionAcct.indx              $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_HST_SIDAcct.indx                  $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_LogCatalog.indx                   $1 dynamic_index   260   260    0 1 5
$DPS_DB_BUILD_HOME/db_PDPDataMaintActivity.indx         $1 dynamic_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PDPSessionDataDiscont.indx        $1 dynamic_index  1474  1474    0 1 5
$DPS_DB_BUILD_HOME/db_PDPSessionsAcct.indx              $1 dynamic_index    32    32    0 1 10
$DPS_DB_BUILD_HOME/db_PDPSessVCAppIDAcct.indx           $1 dynamic_index  1630  1630    0 1 10
$DPS_DB_BUILD_HOME/alt_PDPSessVCAppIDAcct.indx          $1 dynamic_index  1630  1630    0 1 10
$DPS_DB_BUILD_HOME/db_PMSchedule.indx                   $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ProdMessageQualityAndAcct.indx    $1 dynamic_index  1100  1100    0 1 10
$DPS_DB_BUILD_HOME/db_ProductGaps.indx                  $1 dynamic_index    94    94    0 1 10
$DPS_DB_BUILD_HOME/db_ProductSessionQA.indx             $1 dynamic_index   970   970    0 1 10
$DPS_DB_BUILD_HOME/db_ProductSessQuality.indx           $1 dynamic_index    62    62    0 1 10
$DPS_DB_BUILD_HOME/db_ProductSpec.indx                  $1 dynamic_index    26    26    0 1 20
$DPS_DB_BUILD_HOME/db_ProductThreshold.indx             $1 dynamic_index  3254  3254    0 1 5
$DPS_DB_BUILD_HOME/db_ProductXfer.indx                  $1 dynamic_index 25582 25582    0 1 10
$DPS_DB_BUILD_HOME/db_RawScheduleLog.indx               $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ResourceConstituentSchedule.indx  $1 dynamic_index    56    56    0 1 5
$DPS_DB_BUILD_HOME/db_ResourceSchedule.indx             $1 dynamic_index    16    16    0 1 10
$DPS_DB_BUILD_HOME/db_RTOSDataReceiptAcct.indx          $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSDataTransmissionAcct.indx     $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSSelectedData.indx             $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSUserSelectionSpec.indx        $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSVCAppIDTransAcct.indx         $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_SchedMsgAcct.indx                 $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ScheduleMessageID.indx            $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_SelectedIDs.indx                  $1 dynamic_index   460   460    0 1 5
$DPS_DB_BUILD_HOME/db_SessionHeader.indx                $1 dynamic_index    18    18    0 1 10
$DPS_DB_BUILD_HOME/pdp_hash_index1.indx                 $1 dynamic_index  4862  4862    0 1 8
$DPS_DB_BUILD_HOME/pdp_hash_index2.indx                 $1 dynamic_index  6230  6230    0 1 8
$DPS_DB_BUILD_HOME/pdp_hash_index3.indx                 $1 dynamic_index  5696  5696    0 1 8
$DPS_DB_BUILD_HOME/pdp_hash_parameters.indx             $1 dynamic_index     4     4    0 1 8
$DPS_DB_BUILD_HOME/pdp_ProductCatalog.indx              $1 dynamic_index    14    14    0 1 10
$DPS_DB_BUILD_HOME/pdp_ProductFileFormat.indx           $1 dynamic_index   114   114    0 1 6
$DPS_DB_BUILD_HOME/pdp_ProductSelectedId.indx           $1 dynamic_index   128   128    0 1 10
fi
 
if [ "$DPS_DB_RESIZE" = big ]
then
################################################################################################
#
#           L A R G E     C O N F I G U R A T I O N
#
################################################################################################
$DPS_DB_BUILD_HOME/db_AppDestDefaults.indx              $1 static_index    26    26    0 1 20
$DPS_DB_BUILD_HOME/db_ChnlInformation.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_DataRate.indx                     $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_DataSource.indx                   $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_DDFTransmissionConfig.indx        $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_DestinationCatalog.indx           $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_DestinationFacility.indx          $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FddiFELookup.indx                 $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_FilterRates.indx                  $1 static_index    10    10    0 1 20
$DPS_DB_BUILD_HOME/db_FrameSyncSetup.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FSFilterSetup.indx                $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FSFilterValue.indx                $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_GroundTerminal.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_GroupDestination.indx             $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_HST_PKSetup.indx                  $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_Message.indx                      $1 static_index    12    12    0 1 20
$DPS_DB_BUILD_HOME/db_MissionCatalog.indx               $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDataRate.indx              $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_MissionDataStreamIDCatalog.indx   $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDestination.indx           $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_MissionStation.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_MissionSupportID.indx             $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_MissionThresholds.indx            $1 static_index     6     6    0 1 20
$DPS_DB_BUILD_HOME/db_NetworkID.indx                    $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_OracleLogin.indx                  $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PacketizationPath.indx            $1 static_index    14    14    0 1 20
$DPS_DB_BUILD_HOME/db_PDPConfiguration.indx             $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PEConfiguration.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PFCSetup.indx                     $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_PKSetup.indx                      $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_PMSSInputLine.indx                $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_POCCWindow.indx                   $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ProductHost.indx                  $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceCatalog.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceConstituentDefaults.indx  $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceDevices.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_RSBSSetup.indx                    $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RSDSetup.indx                     $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTMissionSetup.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSConfig.indx                   $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSPortNum.indx                  $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ScheduleDisplayDefaults.indx      $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ScheduleOption.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ScheduleSource.indx               $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_SIDSetup.indx                     $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_SQAFIPSetup.indx                  $1 static_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_Station.indx                      $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_TerminalLocation.indx             $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_UserAccessLevel.indx              $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_UserCategory.indx                 $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_UserLevel.indx                    $1 static_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/pdp_GroupIds.indx                    $1 static_index     4     4    0 1 20
 
$DPS_DB_BUILD_HOME/db_AcqSessionCharacteristics.indx    $1 dynamic_index    54    54    0 1 10
$DPS_DB_BUILD_HOME/alt_AcqSessionCharacteristics.indx   $1 dynamic_index    86    86    0 1 10
$DPS_DB_BUILD_HOME/db_AppDestSchedule.indx              $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_CTMStatus.indx                    $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_DANIndx.indx                      $1 dynamic_index   210   210    0 1 10
$DPS_DB_BUILD_HOME/db_EventLog.indx                     $1 dynamic_index   962   962    0 1 5
$DPS_DB_BUILD_HOME/db_FESessionAcct.indx                $1 dynamic_index    50    50    0 1 10
$DPS_DB_BUILD_HOME/db_FEUnselVCAcct.indx                $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FEVcAppAcct.indx                  $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_FEVirtualChannelAcct.indx         $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_GPGroupIndx.indx                  $1 dynamic_index 16368 16368    0 1 5
$DPS_DB_BUILD_HOME/db_GPProductIndx.indx                $1 dynamic_index   110   110    0 1 5
$DPS_DB_BUILD_HOME/db_GroupSequenceNumbers.indx         $1 dynamic_index   234   234    0 1 5
$DPS_DB_BUILD_HOME/db_HST_SessionAcct.indx              $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_HST_SIDAcct.indx                  $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_LogCatalog.indx                   $1 dynamic_index   794   794    0 1 5
$DPS_DB_BUILD_HOME/db_PDPDataMaintActivity.indx         $1 dynamic_index     4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PDPSessionDataDiscont.indx        $1 dynamic_index 339454 33946   0 1 50
$DPS_DB_BUILD_HOME/db_PDPSessionsAcct.indx              $1 dynamic_index    90    90    0 1 10
$DPS_DB_BUILD_HOME/db_PDPSessVCAppIDAcct.indx           $1 dynamic_index  7168  7168    0 1 10
$DPS_DB_BUILD_HOME/alt_PDPSessVCAppIDAcct.indx          $1 dynamic_index  7168  7168    0 1 10
$DPS_DB_BUILD_HOME/db_PMSchedule.indx                   $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ProdMessageQualityAndAcct.indx    $1 dynamic_index  4918  4918    0 1 10
$DPS_DB_BUILD_HOME/db_ProductGaps.indx                  $1 dynamic_index 20022 20022    0 1 10
$DPS_DB_BUILD_HOME/db_ProductSessionQA.indx             $1 dynamic_index  4112  4112    0 1 10
$DPS_DB_BUILD_HOME/db_ProductSessQuality.indx           $1 dynamic_index   178   178    0 1 10
$DPS_DB_BUILD_HOME/db_ProductSpec.indx                  $1 dynamic_index    80    80    0 1 20
$DPS_DB_BUILD_HOME/db_ProductThreshold.indx             $1 dynamic_index 14334 14334    0 1 5
$DPS_DB_BUILD_HOME/db_ProductXfer.indx                  $1 dynamic_index 113782 22756   0 1 50
$DPS_DB_BUILD_HOME/db_RawScheduleLog.indx               $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ResourceConstituentSchedule.indx  $1 dynamic_index   150   150    0 1 5
$DPS_DB_BUILD_HOME/db_ResourceSchedule.indx             $1 dynamic_index    36    36    0 1 10
$DPS_DB_BUILD_HOME/db_RTOSDataReceiptAcct.indx          $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSDataTransmissionAcct.indx     $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSSelectedData.indx             $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSUserSelectionSpec.indx        $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_RTOSVCAppIDTransAcct.indx         $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_SchedMsgAcct.indx                 $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_ScheduleMessageID.indx            $1 dynamic_index     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_SelectedIDs.indx                  $1 dynamic_index  2064  2064    0 1 5
$DPS_DB_BUILD_HOME/db_SessionHeader.indx                $1 dynamic_index    54    54    0 1 10
$DPS_DB_BUILD_HOME/pdp_hash_index1.indx                 $1 dynamic_index 1000000 50000  0 1 160
$DPS_DB_BUILD_HOME/pdp_hash_index2.indx                 $1 dynamic_index 1000000 50000  0 1 160
$DPS_DB_BUILD_HOME/pdp_hash_index3.indx                 $1 dynamic_index 1000000 50000  0 1 160
$DPS_DB_BUILD_HOME/pdp_hash_parameters.indx             $1 dynamic_index     4     4    0 1 8
$DPS_DB_BUILD_HOME/pdp_ProductCatalog.indx              $1 dynamic_index    40    40    0 1 10
$DPS_DB_BUILD_HOME/pdp_ProductFileFormat.indx           $1 dynamic_index   512   512    0 1 6
$DPS_DB_BUILD_HOME/pdp_ProductSelectedId.indx           $1 dynamic_index   564   564    0 1 10
fi
 
echo "*****************************************************************"
echo " DONE building DPS indexes - see log file for results"
echo "*****************************************************************"
echo ""
exit
