core/sqf/sql/scripts/genms

#
# @@@ START COPYRIGHT @@@
#
# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.
#
# @@@ END COPYRIGHT @@@
#
MSENV_GENDATE=`date`
echo "## SQ env. environment variables. Generated on $MSENV_GENDATE"
echo "## setting the default for ax_reg"
echo "DTM_RM_PARTIC=0"
echo "DTM_TLOG_PER_TM=0"
echo "TM_ENABLE_TLOG_WRITES=1"
echo "TM_TLOG_NUM_LOGS=16"
echo "TM_TLOG_AUTO_FLUSH=0"
echo "TM_TLOG_DISABLE_BLOCK_CACHE=0"
echo "#TM_TLOG_MAX_VERSIONS less than 3 will be ignored"
echo "TM_TLOG_MAX_VERSIONS=5"
echo "TM_ENABLE_DDL_TRANS=1"
echo "TM_USE_SSCC=0"
echo "TM_IDTMSRV_REFRESH_DELAY_SECONDS=3"

echo "TSE_CONVERT_NOUNDO_TRANS=1"

echo "MS_TRACE_ENABLE=0"
echo "FS_TRACE_ENABLE=0"
echo "HOOK_ENABLE=0"
echo "LIBHDFS_OPTS=-Xmx2048m"
echo ""
echo "ABANDON_TX_AFTER_3_RETRIES=0"
echo "#Launch SQL processes hooked or unhooked"
echo "IPC_LAUNCH_UNHOOKED=1"
echo ""
echo "#Use Robust semaphore for SB disconnect processing"
echo "MS_DISC_SEM_ROBUST=1"
echo ""
echo "#Use sock-transport"
echo "#SQ_TRANS_SOCK=1"
echo ""

echo "# - ALL MS_TRACE vars listed here"
echo "#MS_TRACE=1"
echo "#MS_TRACE_ABANDON=1"
echo "#MS_TRACE_AGGR=1"
echo "#MS_TRACE_ALLOC=1"
echo "#MS_TRACE_DATA=1"
echo "#MS_TRACE_DATA_MAX=16"
echo "#MS_TRACE_DETAIL=1"
echo "#MS_TRACE_DIALECT=1"
echo "#MS_TRACE_ENVIRON=1"
echo "#MS_TRACE_ERRORS=1"
echo "#MS_TRACE_EVENTS=1"
echo "#MS_TRACE_EVLOG=1"
echo "#MS_TRACE_FILE_DELTA=1"
echo "#MS_TRACE_FILE_FB=65536"
echo "MS_TRACE_FILE=mstrace"
echo "#MS_TRACE_FILE_INMEM=65536"
echo "#MS_TRACE_FILE_MAXSIZE=10000000000"
echo "#MS_TRACE_FILE_NOLOCK=1"
echo "#MS_TRACE_FILE_SIGNAL=1"
echo "MS_TRACE_FILE_UNIQUE=1"
echo "#MS_TRACE_IC=1"
echo "#MS_TRACE_LOCIO=1"
echo "#MS_TRACE_MD=1"
echo "MS_TRACE_MON=1"
echo "#MS_TRACE_MPI=1"
echo "#MS_TRACE_MPI_CONN=1"
echo "#MS_TRACE_MPI_DATA=1"
echo "#MS_TRACE_MPI_DATA_MAX=16"
echo "#MS_TRACE_MPI_TEST=1"
echo "#MS_TRACE_MPI_TIME=1"
echo "#MS_TRACE_NAME=1"
echo "MS_TRACE_PARAMS=1"
echo "#MS_TRACE_PTHREAD=1"
echo "#MS_TRACE_QALLOC=1"
echo "#MS_TRACE_REF=1"
echo "#MS_TRACE_RPC=1"
echo "#MS_TRACE_RPC_DATA=1"
echo "#MS_TRACE_RPC_DATA_MAX=16"
echo "#MS_TRACE_RPC_MSG=1"
echo "#MS_TRACE_SM=1"
echo "#MS_TRACE_SOCK=1"
echo "#MS_TRACE_STATS=1"
echo "#MS_TRACE_THREAD=1"
echo "#MS_TRACE_TIMER=1"
echo "#MS_TRACE_TIMERMAP=1"
echo "#MS_TRACE_TRANS=1"
echo "#MS_TRACE_VERBOSE"
echo "#MS_TRACE_WAIT=1"
echo ""

echo "# - if there's an FS error, this causes an assert"
echo "FS_ASSERT_ERROR=1"
echo ""
echo "# - ALL FS_TRACE vars listed here"
echo "#FS_TRACE=1"
echo "#FS_TRACE_DATA=1"
echo "#FS_TRACE_DATA_MAX=16"
echo "#FS_TRACE_DETAIL=1"
echo "#FS_TRACE_ERRORS=1"
echo "#FS_TRACE_FC=1"
echo "FS_TRACE_FILE=fstrace"
echo "#FS_TRACE_FILE_DELTA=1"
echo "#FS_TRACE_FILE_FB=65536"
echo "#FS_TRACE_FILE_MAXSIZE=10000000000"
echo "#FS_TRACE_FILE_NOLOCK=1"
echo "FS_TRACE_FILE_UNIQUE=1"
echo "FS_TRACE_MON=1"
echo "#FS_TRACE_MT=1"
echo "FS_TRACE_PARAMS=1"
echo "#FS_TRACE_PARAMS0=1"
echo "#FS_TRACE_VERBOSE=1"
echo ""

echo "# DTM Tracing. To enable standard tracing uncomment the following lines."
echo "#TM_TRACE=1"
echo "#XATM_TRACE=0xf"
echo "#TM_TRACE_DETAIL=3"
echo "#TM_TRACE_UNIQUE=1"
echo "#TM_TRACE_FILE=zzttm."
echo ""

echo "#ENABLE_EMBEDDED_ARKCMP=1"
echo ""

echo "SEAQUEST_DP2=1"
echo ""

echo "AM_TRACE=0"
echo "AM_TRACE_FILE=am_trace"
echo "AM_TRACE_FILE_UNIQUE=1"
echo "AM_TRACE_LEVEL=1"
echo ""

echo "# Create the arkcmp process on the same node as the master executor"
echo "CMP_NODE_AFFINITY=1"
echo ""
echo "SEAQUEST=1"
echo "SEAQUEST_NO_ROLLBACK_TXN=0"
echo "SQLMX_MESSAGEFILE=\$TRAF_HOME/export/bin\$SQ_MBTYPE/mxcierrors.cat"
echo "YYERROR_QUIET=1"
echo ""
echo "# this is purely for measure use case analysis at this point"
echo "SQL_MEASURE_ENABLE=0"
echo "#SQ_STATS_ESP=0"
echo ""
echo ""
echo "# property file for tdm_arkcmp"
echo "SQ_PROPS_TDM_ARKCMP=tdm_arkcmp.env"
echo ""
echo "# property file for tdm_arkesp"
echo "SQ_PROPS_TDM_ARKESP=tdm_arkesp.env"
echo ""
echo "STFS_HDD_LOCATION=\$TRAF_VAR"
echo ""
echo "#setting UDR_ROOT"
if [ -d "/home/udr" ]; then
  w=`whoami`
  dircreate=/home/udr/$w
  if [ ! -d $dircreate ]; then
    mkdir --mode=775 $dircreate 2>/dev/null
  fi
  echo "UDR_ROOT=$dircreate"
else
  if [ ! -d "$TRAF_HOME/udr" ]; then
    mkdir $TRAF_HOME/udr 2>/dev/null
  fi
  echo "UDR_ROOT=\$TRAF_HOME/udr"
fi

echo "UDR_CACHE_LIBDIR=cached_libs"

echo ""
echo "#creating sqllogs folder for capturing osim data"
sqllogdir=$HOME/sqllogs
if [ ! -d $sqllogdir ]; then
    mkdir --mode=770 $sqllogdir 2>/dev/null
fi
echo "TAR_DOWNLOAD_ROOT=$sqllogdir"

echo ""
echo "#setting CACERTS_DIR for storing CA certificates"
cacertsdir=$HOME/cacerts
if [ ! -d $cacertsdir ]; then
    mkdir --mode=700 $cacertsdir 2>/dev/null
fi
echo "CACERTS_DIR=$cacertsdir"

dcsinstalldir=$DCS_INSTALL_DIR
echo "DCS_INSTALL_DIR=$dcsinstalldir"

restinstalldir=$REST_INSTALL_DIR
echo "REST_INSTALL_DIR=$restinstalldir"

echo "TRAF_VAR=$TRAF_VAR"
echo "TRAF_LOG=$TRAF_LOG"
echo "TRAF_CONF=$TRAF_CONF"

if [[ ! -z "$PID_MAX" ]]; then
   echo "PID_MAX=$PID_MAX"
fi

if [[ ! -z "$RMS_SHARED_SEG_SIZE_MB" ]]; then
   echo "RMS_SHARED_SEG_SIZE_MB=$RMS_SHARED_SEG_SIZE_MB"
fi

echo ""
echo ""
echo "# Added by gensq.pl"