core/sqf/sql/scripts/sqcmpgdb

#!/bin/bash
#
# @@@ 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 @@@
#
#
# puts tdm_arkcmp into gdb.
# sqps must return only one sqlci and that sqlci must have only
# one child arkcmp process.
#

w=`sqps | grep sqlci  | wc -l`
if [ $w == "0" ]; then
   echo "sqps returned $w running sqlci processes."
   echo "gdb cannot be started, exiting."
   exit;
fi
if [ $w != "1" ]; then
   echo "sqps returned $w sqlci processes, only one must be running."
   echo "gdb cannot be started, exiting."
   exit;
fi
t=`sqps | grep sqlci  | cut -d " " -f 7`

w1=`sqps | grep $t | grep tdm_arkcmp | wc -l`
if [ $w1 == "0" ]; then
   echo "sqps returned $w1 running arkcmp processes."
   echo "gdb cannot be started, exiting."
   exit;
fi
if [ $w1 != "1" ]; then
   echo "sqps returned $w1 arkcmp processes, only one must be running."
   echo "gdb cannot be started, exiting."
   exit;
fi

g=`sqps | grep $t | grep tdm_arkcmp | cut -d " " -f 2`
p=`echo $g | cut -d "," -f 2 | sed 's/0*//' `
gdb -p $p