#!/bin/ksh

#################################################################
#             (C) COPYRIGHT Candle Corporation 2001             #
#                      All Rights Reserved                      #
#                                                               #
#       Licensed Materials - Property of Candle Corporation     #
#         Duplication or disclosure prohibited without the      #
#        expressed written consent of the Candle Corporation.   #
#                                                               #
#################################################################

# @03 03/11/05 LCL G11n migration: Shobha Venkateswaran
# @02 04/07/04 LCL Add missing CMS tables; 1-42001140
# @01 09/09/01 LCL Force copy of CP files during CMS data migration

Use_report () {
    print -u2  "$PROGNAME: [ -h install_dir  ] -z Admin_Pac_dir/tables/tems_name|-o OLDCANDLEHOME/tables/old_tems_name -n tems_name "
    exit 1
}

Err_report() {
   case $1 in
      #$NLS-E$ "$PROGNAME warning: $2, continuing ..."
      warn) print -u2  "$PROGNAME `nls_replace 'KCI0415I'`: $2, `nls_replace 'KCI0416I'` ..."
            sleep 2
            return
            ;;
			#$NLS-E$ "$PROGNAME failure: $2."
      fail) print -u2 "$PROGNAME `nls_replace 'KCI0417I'`: $2."
            exit 2
            ;;
      info) print -u2 "$PROGNAME        : $2."
            return
            ;;
   esac
}

Migrate_MC() {
#$NLS-E$ "beginning MC migration for node $CANDLENODE"
Err_report info "`nls_replace 'KCI0418I' MC $CANDLENODE`"

chmod 777 $CANDLEHOME/$binArch/ms/bin/kgldbutl
$CANDLEHOME/$binArch/ms/bin/kgldbutl >> $MIGRATELOG <<-EOF

TRACE ENABLE ERRLOG;
*
COPY INDB(RKCFAPLL) OUTDB(RKCFAPLL) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(RKCFAPLT) OUTDB(RKCFAPLT) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(RKCFAPLW) OUTDB(RKCFAPLW) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(RKCFAPLA) OUTDB(RKCFAPLA) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(RKCFAPLD) OUTDB(RKCFAPLD) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(RKCFAPLN) OUTDB(RKCFAPLN) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
*
END;
EOF

}

Migrate_CMS() {
#$NLS-E$ "beginning migration for node $CANDLENODE"
Err_report info "`nls_replace 'KCI0419I' $CANDLENODE`"

chmod 777 $CANDLEHOME/$binArch/ms/bin/kgldbutl
$CANDLEHOME/$binArch/ms/bin/kgldbutl > $MIGRATELOG <<-EOF

TRACE ENABLE ERRLOG;
*
COPY INDB(QA1CIOBJ) OUTDB(QA1CIOBJ) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CCOBJ) OUTDB(QA1CCOBJ) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CCONS) OUTDB(QA1CCONS) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CNODL) OUTDB(QA1CNODL) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CRULD) OUTDB(QA1CRULD) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CSITF) OUTDB(QA1CSITF) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CTHRE) OUTDB(QA1CTHRE) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DACTP) OUTDB(QA1DACTP) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DAGGR) OUTDB(QA1DAGGR) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DLINK) OUTDB(QA1DLINK) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DMOBJ) OUTDB(QA1DMOBJ) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DMTMP) OUTDB(QA1DMTMP) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DOBJA) OUTDB(QA1DOBJA) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DPCYF) OUTDB(QA1DPCYF) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DQURY) OUTDB(QA1DQURY) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSPST) OUTDB(QA1DSPST) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSTMS) OUTDB(QA1DSTMS) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSTSA) OUTDB(QA1DSTSA) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSTUA) OUTDB(QA1DSTUA) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSWUS) OUTDB(QA1DSWUS) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DWGRP) OUTDB(QA1DWGRP) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DNSAV) OUTDB(QA1DNSAV) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DCCT)  OUTDB(QA1DCCT)  INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DCCT2) OUTDB(QA1DCCT2) INDEX(PrimaryIndex) MAXERRORS(NOMAX);

*
END;
EOF

}

Migrate_IB() {
#$NLS-E$ "beginning IB table migration for node $CANDLENODE"
Err_report info "`nls_replace 'KCI0420I' IB $CANDLENODE`"
chmod 777 $CANDLEHOME/$binArch/ms/bin/kgldbutl
$CANDLEHOME/$binArch/ms/bin/kgldbutl >> $MIGRATELOG <<-EOF
TRACE ENABLE ERRLOG;
*
RENAME DB DBNAME(QA1CRULD) TONAME(QA1CRULDBAK);
CREATE DB DBNAME(QA1CRULD) BLKSIZE(4096) FIELDS((RuleName,C32),(Predicate,C3000));
CREATE INDEX DBNAME(QA1CRULD) INDEXNAME(PrimaryIndex) FIELDS((RuleName,C32)) UNIQUE;
MIGRATE DB FROMDB(QA1CRULDBAK) TODB(QA1CRULD);

RENAME DB DBNAME(QA1CSITF) TONAME(QA1CSITFBAK);
CREATE DB DBNAME(QA1CSITF) BLKSIZE(4096) FIELDS((Key,C32),(Data,C3962));
CREATE INDEX DBNAME(QA1CSITF) INDEXNAME(PrimaryIndex) FIELDS((Key,C32)) UNIQUE;
MIGRATE DB FROMDB(QA1CSITFBAK) TODB(QA1CSITF);

RENAME DB DBNAME(QA1DACTP) TONAME(QA1DACTPBAK);
CREATE DB DBNAME(QA1DACTP) BLKSIZE(4096) FIELDS((Key,C64),(Data,C1934),(ActInfo2L,H),(ActInfo2D,C2000));
CREATE INDEX DBNAME(QA1DACTP) INDEXNAME(PrimaryIndex) FIELDS((Key,C64)) UNIQUE;
MIGRATE DB FROMDB(QA1DACTPBAK) TODB(QA1DACTP);

RENAME DB DBNAME(QA1DCCT) TONAME(QA1DCCTBAK);
CREATE DB DBNAME(QA1DCCT) BLKSIZE(4096) FIELDS((Key,C32),(Data,C1852));
CREATE INDEX DBNAME(QA1DCCT) INDEXNAME(PrimaryIndex) FIELDS((Key,C32)) UNIQUE;
MIGRATE DB FROMDB(QA1DCCTBAK) TODB(QA1DCCT);

RENAME DB DBNAME(QA1DPCYF) TONAME(QA1DPCYFBAK);
CREATE DB DBNAME(QA1DPCYF) BLKSIZE(4096) FIELDS((Key,C32),(Data,C347));
CREATE INDEX DBNAME(QA1DPCYF) INDEXNAME(PrimaryIndex) FIELDS((Key,C32)) UNIQUE;
MIGRATE DB FROMDB(QA1DPCYFBAK) TODB(QA1DPCYF);

*RENAME DB DBNAME(QA1DWORK) TONAME(QA1DWORKBAK);
CREATE DB DBNAME(QA1DWORK) BLKSIZE(4096) FIELDS((Key,H),(Data,C3998));
CREATE INDEX DBNAME(QA1DWORK) INDEXNAME(PrimaryIndex) FIELDS((Key,H)) UNIQUE;
*MIGRATE DB FROMDB(QA1DWORKBAK) TODB(QA1DWORK);

*
END;
EOF

}

Migrate_Z2() {
#$NLS-E$ "beginning migration for node $CANDLENODE"
Err_report info "`nls_replace 'KCI0421I' $CANDLENODE`"

$CANDLEHOME/$binArch/ms/bin/kgldbutl > $MIGRATELOG <<-EOF

TRACE ENABLE ERRLOG;
*
COPY INDB(QA1CIOBJ) OUTDB(QA1CIOBJ) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CCOBJ) OUTDB(QA1CCOBJ) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CCONS) OUTDB(QA1CCONS) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CNODL) OUTDB(QA1CNODL) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CRULD) OUTDB(QA1CRULD) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CSITF) OUTDB(QA1CSITF) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1CTHRE) OUTDB(QA1CTHRE) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DACTP) OUTDB(QA1DACTP) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DAGGR) OUTDB(QA1DAGGR) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DLINK) OUTDB(QA1DLINK) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DMOBJ) OUTDB(QA1DMOBJ) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DMTMP) OUTDB(QA1DMTMP) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DOBJA) OUTDB(QA1DOBJA) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DPCYF) OUTDB(QA1DPCYF) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DQURY) OUTDB(QA1DQURY) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSPST) OUTDB(QA1DSPST) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSTMS) OUTDB(QA1DSTMS) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSTSA) OUTDB(QA1DSTSA) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DSWUS) OUTDB(QA1DSWUS) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DWGRP) OUTDB(QA1DWGRP) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DNSAV) OUTDB(QA1DNSAV) INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DCCT)  OUTDB(QA1DCCT)  INDEX(PrimaryIndex) MAXERRORS(NOMAX);
COPY INDB(QA1DCCT2) OUTDB(QA1DCCT2) INDEX(PrimaryIndex) MAXERRORS(NOMAX);

*
END;
EOF

}

# Copy CMS-only-data (COD) files.

copyCODFiles()
{
  # $1 = file extension, either "atr," "cat," or "his." 
  
  # Define local variables.
  typeset fName lib=ATTRLIB name pc file=ATR
  
  if [ "$1" = "cat" ] 
  then
    lib=RKDSCATL
    file=CAT
  fi
  
  if [ -d $newBase/$lib ]
  then
    for name in $(ls $oldBase/$lib/*.$1 2> /dev/null)
    do
      fName=${name##*/}  # Remove the pathname.
      pc=$(print $fName | cut -c2,3 2> /dev/null)  # Get the product code.  Remember to skip the "k."
      
      # If the file does not exist in the new location, copy it from the old location to the new.
      
      if [ ! -f $newBase/$lib/$fName ]
      then
	    #$NLS-E$ ... copying $name to $newBase/$lib/$fName 
        #nls_replace 'KCI0422I' $name $newBase/$lib/$fName
        cp -p $name $newBase/$lib/$fName > /dev/null 2>&1
		#$NLS-E$ "could not copy \"$name\" to \"$newBase/$lib/$fName\""
        [ $? -eq 0 ] || { Err_report warn "`nls_replace 'KCI0422I' \\"$name\\" \\"$newBase/$lib/$fName\\"`"; continue; }
        # Keep track of the product codes for the files copied.
        pCodes="$pCodes\\n$pc"  # A newline (\n) is needed to run the sort command.
      fi
    done

# Now copy the xxxCATnn and xxxATRnn files

    for name in $(ls $oldBase/$lib/*$file* 2> /dev/null)
    do
      fName=${name##*/}  # Remove the pathname.
      if [ ! -f $newBase/$lib/$fName ]
      then
        #nls_replace 'KCI0422I' $name $newBase/$lib/$fName
        cp -p $name $newBase/$lib/$fName > /dev/null 2>&1
        [ $? -eq 0 ] || { Err_report warn "`nls_replace 'KCI0422I' \\"$name\\" \\"$newBase/$lib/$fName\\"`"; continue; }
      fi
    done
  fi
}

# Copy the .ver files for the product codes processed in copyCODFiles().

copyVerFiles()
{
  # Define local variables.
  
  typeset -i len=0
  typeset name pc uCodes vName
  
  # See if there is any reason to run this function.
  
  len=${#pCodes}
  [ len -gt 2 ] || return  # pCodes will consist of at least a blank and a newline.
  
  # Remove duplicate product codes.
  uCodes=$(print $pCodes | sort -u 2> /dev/null)
  
  # Copy the .ver files for the COD packages.
  
  if [ -d $oldReg ]
  then
    ls $oldReg/*.ver > /dev/null 2>&1
    if [ $? -eq 0 ]
    then
	  #$NLS-E$ "processing .ver files"
      Err_report info "`nls_replace 'KCI0423I' .ver`"
      for pc in $uCodes
      do
        for name in $(ls $oldReg/$pc*.ver 2> /dev/null)
        do
          vName=${name##*/}  # Remove the pathname, leaving just the name of the .ver file.
          if [[ $vName = $pc@(mvs|os2|os400|unix|winnt).ver ]]  # Ensure it's a .ver file for a COD piece.
          then
            if [ ! -f $newReg/$vName ]
            then
			  #$NLS-E$ ... copying $name to $newReg/$vName
              nls_replace 'KCI0424I' $name $newReg/$vName
              cp -p $name $newReg/$vName > /dev/null 2>&1
			  #$NLS-E$ "could not copy \"$name\" to \"$vName\""
              [ $? -eq 0 ] || Err_report warn "`nls_replace 'KCI0425I' \\"$name\\" \\"$vName\\"`"
            fi
          fi
        done
      done
    fi
  fi
}


########################################################
#                   Main Routine                       #
########################################################
bindir=`pwd`/$(dirname $0)
[ "$(print $0 | grep '\./')" = "" ] && [ "$(print $0 | grep '^/.*')" = "" ] && [ `pwd` = '/' ] && bindir=`pwd`$(dirname $0)
[ "$(print $0 | grep '^/.*')" != "" ] && bindir=$(dirname $0)

export TEXTDOMAINDIR=$bindir/../config/nls/msg
export PATH=$bindir:$PATH

export PATH=/usr/bin:$PATH
if [[ -z "$ITMCMD" ]]
then
    PROGNAME=$(basename $0)
else
    PROGNAME="$ITMCMD"
fi

Z2FLAG=0

# Define local variables.
typeset binArch fName libArch name newBase newReg oldBase oldReg pCodes pc

while getopts ":h:n:o:z:" OPT                     # check the command line
do case $OPT in
     h) CANDLEHOME=$OPTARG                          # reset CANDLEHOME
        ;;
     n) CANDLENODE=$OPTARG
        ;;
     o) OLDCANDLEHOME=$OPTARG
        ;;
     z) KGL_INPATH=$OPTARG
        Z2FLAG=1
        ;;
     ?) Use_report
        ;;
   esac
done

shift $((OPTIND-1))

if [ "$OPTIND" = "1" ]
then
   Use_report
fi

# check CANDLEHOME
[ -n  "$CANDLEHOME" ]  || CANDLEHOME=$(cd $(dirname $0) ; dirname $(pwd))

# Check passed value
#$NLS-E$ "$CANDLEHOME not a directory"
[ -d "$CANDLEHOME" ] || Err_report fail "`nls_replace 'KCI0426E' $CANDLEHOME`"
export CANDLEHOME

if [ $(print "$CANDLEHOME" | wc -w) -ne 1 ]
then
  #$NLS-E$ "Blanks are not permitted in CANDLEHOME"
  Err_report fail "`nls_replace 'KCI0427E' CANDLEHOME`"
fi

CANDLELOG=$CANDLEHOME/logs
CANDLETBL=$CANDLEHOME/tables
HOST=`hostname`

ArchTbl=$CANDLEHOME/registry/archdsc.tbl
DynShl=$CANDLEHOME/bin/dynarch.shl

. $DynShl $ArchTbl

setJavaEnv $cArch

setBinLibArchs $cArch ms

export LD_LIBRARY_PATH=/lib:/usr/lib:$CANDLEHOME/$mslibArch/ms/lib:$CANDLEHOME/$libArch/lib
export LIBPATH=/lib:/usr/lib:$CANDLEHOME/$mslibArch/ms/lib:$CANDLEHOME/$libArch/lib
export SHLIB_PATH=/lib:/usr/lib:$CANDLEHOME/$mslibArch/ms/lib:$CANDLEHOME/$libArch/lib

MIGRATELOG=$CANDLELOG/${HOST}_ci_$$.log

KGL_INPATH=${KGL_INPATH:="$OLDCANDLEHOME"}             export KGL_INPATH
KGL_OUTPATH=$CANDLETBL/$CANDLENODE                     export KGL_OUTPATH

#$NLS-E$ "$KGL_INPATH not a directory"
[ -d "$KGL_INPATH" ] || Err_report fail "`nls_replace 'KCI0428E' $KGL_INPATH`"

#$NLS-E$ "$KGL_OUTPATH not a directory"
[ -d "$KGL_OUTPATH" ] || Err_report fail "`nls_replace 'KCI0429E' $KGL_OUTPATH`"

if [ "$Z2FLAG" = 1 ]
then
  Migrate_Z2
else 
  Migrate_CMS
  cd $KGL_OUTPATH
  Migrate_IB

  # Also copy over these 3 files for CP (CICS for OS/390) support  @01
  if [ $KGL_INPATH != $KGL_OUTPATH ]
  then
    [ -a "${KGL_INPATH}/RKCPDEFW.DB" ] && cp -p ${KGL_INPATH}/RKCPDEFW.DB ${KGL_OUTPATH}/RKCPDEFW.DB
    [ -a "${KGL_INPATH}/RKCPDEFW.IDX" ] && cp -p ${KGL_INPATH}/RKCPDEFW.IDX ${KGL_OUTPATH}/RKCPDEFW.IDX
    [ -a "${KGL_INPATH}/.defwseed" ] && cp -p ${KGL_INPATH}/.defwseed ${KGL_OUTPATH}/.defwseed
  fi
fi

# Copy any "missing" *.atr, *.cat and *.his files from the old cicatrsq location into the new cms 
# directory.  First, define source and destination directories.

newBase=$KGL_OUTPATH
oldBase=$KGL_INPATH
newReg=$CANDLEHOME/registry
oldReg=${KGL_INPATH%/*/*}/registry

# Copy missing *.atr files.

#$NLS-E$ "processing *.atr files"
Err_report info "`nls_replace 'KCI0430I' *.atr`"
ls $oldBase/ATTRLIB/*.atr > /dev/null 2>&1
[ $? -eq 0 ] && copyCODFiles atr

# Copy missing *.cat files.

#$NLS-E$ "processing *.cat files"
Err_report info "`nls_replace 'KCI0431I' *.cat`"
ls $oldBase/RKDSCATL/*.cat > /dev/null 2>&1
[ $? -eq 0 ] && copyCODFiles cat

# Copy missing *.his files.

#$NLS-E$ "processing *.his files"
Err_report info "`nls_replace 'KCI0432I' *.his`"
ls $oldBase/ATTRLIB/*.his > /dev/null 2>&1
[ $? -eq 0 ] && copyCODFiles his

# Process the version files for COD pieces copied in the previous steps.

copyVerFiles

# Migrate MC files

if [ -f `echo $KGL_INPATH/RKCFAPL*.* | cut -d' ' -f1` ]
then
  # defect 18858 - do not copy if src and dst are the same
  if [ $KGL_INPATH != $KGL_OUTPATH ]
  then
    cp $KGL_INPATH/RKCF*.* $KGL_OUTPATH/. 2>/dev/null || Err_report fail "`nls_replace 'KCI0434E' RKMCAPL`"
    if [ -f  $KGL_INPATH/RKCFDLOG ]  
    then
      cp $KGL_INPATH/RKCFDLOG $KGL_OUTPATH/. 2>/dev/null || Err_report fail "`nls_replace 'KCI0434E' RKMCAPL`"
    fi
    if [ -d $KGL_INPATH/RKCFCDI ]
    then
      cp -r $KGL_INPATH/RKCFCDI $KGL_OUTPATH 2>/dev/null || Err_report fail "`nls_replace 'KCI0434E' RKMCAPL`"
    fi
  fi
elif [ -f $KGL_INPATH/RKMCAPL*.* ]
then
  for i in $KGL_INPATH/RKMCAPL*.*
  do
    file=$(basename $i)
    ext=${file#RKMC}
    newname=RKCF$ext
	#$NLS-E$ "cannot copy RKMCAPL files"
    cp $KGL_INPATH/$file $KGL_OUTPATH/$newname 2>/dev/null || Err_report fail "`nls_replace 'KCI0434E' RKMCAPL`"
  done
else
  #$NLS-E$ "No MC files to migrate"
  Err_report info "`nls_replace 'KCI0435I' MC`"
fi

#$NLS-E$ "please refer to file \"$MIGRATELOG\" for info regarding this migration"
Err_report info "`nls_replace 'KCI0436I' \\"$MIGRATELOG\\"`"
