You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2017/05/31 18:47:06 UTC
[05/50] [abbrv] incubator-trafodion git commit: Uncommented creation
of process registry tables.
Uncommented creation of process registry tables.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/3f37b56a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/3f37b56a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/3f37b56a
Branch: refs/heads/master
Commit: 3f37b56a8eed6588188242af2c7d988c3d69cdd5
Parents: 3677b73
Author: Zalo Correa <za...@esgyn.com>
Authored: Thu Aug 11 09:43:38 2016 -0700
Committer: Zalo Correa <za...@esgyn.com>
Committed: Thu Aug 11 09:43:38 2016 -0700
----------------------------------------------------------------------
core/sqf/sql/scripts/createConfigDb | 14 +++---
core/sqf/sql/scripts/showConfigDb | 84 ++++++++++++++++----------------
2 files changed, 49 insertions(+), 49 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3f37b56a/core/sqf/sql/scripts/createConfigDb
----------------------------------------------------------------------
diff --git a/core/sqf/sql/scripts/createConfigDb b/core/sqf/sql/scripts/createConfigDb
index 4e32594..748f95e 100755
--- a/core/sqf/sql/scripts/createConfigDb
+++ b/core/sqf/sql/scripts/createConfigDb
@@ -78,13 +78,13 @@ create table monRegKeyName
);
-- Process Scope registry entry (monitor gensq.pl)
---create table monRegProcData
---(
--- procId integer,
--- keyId integer,
--- dataValue varchar (4096),
--- primary key (procId, keyId)
---);
+create table monRegProcData
+(
+ procId integer,
+ keyId integer,
+ dataValue varchar (4096),
+ primary key (procId, keyId)
+);
-- Cluster registry entries (monitor gensq.pl)
create table monRegClusterData
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3f37b56a/core/sqf/sql/scripts/showConfigDb
----------------------------------------------------------------------
diff --git a/core/sqf/sql/scripts/showConfigDb b/core/sqf/sql/scripts/showConfigDb
index 57d5795..a2c59d0 100755
--- a/core/sqf/sql/scripts/showConfigDb
+++ b/core/sqf/sql/scripts/showConfigDb
@@ -33,7 +33,7 @@ function Usage
echo "-h Displays this help message"
echo "-l[<nid>] Displays all [or specific] logical node configuration values"
echo "-n[<name>] Displays all [or specific] node configuration values"
-# echo "-p[<proc>] Displays specific process registry values"
+ echo "-p[<proc>] Displays specific process registry values"
echo "-s[<name>] Displays all [or specific] spare node specific configuration values"
echo "-u Displays unique strings"
echo "-x[<name>] Displays all [or specific] physical node configuration values"
@@ -255,34 +255,34 @@ EOF
}
-#function monRegSpecificProcData
-#{
-#
-## Monitor registry: process keys and values for a specific process
-#
-#sqlite3 sqconfig.db <<EOF
-#.separator ""
-#.headers on
-#.mode list
-#select p.procName, ": ", k.keyName, "=", d.dataValue from monRegProcName p, monRegKeyName k, monRegProcData d where p.procId = d.procId and k.keyId = d.keyId and p.procName = "$1";
-#.quit
-#EOF
-#
-#}
-#
-#function monRegProcData
-#{
-#
-## Monitor registry: process keys and values
-#sqlite3 sqconfig.db <<EOF
-#.separator ""
-#.headers on
-#.mode list
-#select p.procName, ": ", k.keyName, "=", d.dataValue from monRegProcName p, monRegKeyName k, monRegProcData d where p.procId = d.procId and k.keyId = d.keyId;
-#.quit
-#EOF
-#
-#}
+function monRegSpecificProcData
+{
+
+# Monitor registry: process keys and values for a specific process
+
+sqlite3 sqconfig.db <<EOF
+.separator ""
+.headers on
+.mode list
+select p.procName, ": ", k.keyName, "=", d.dataValue from monRegProcName p, monRegKeyName k, monRegProcData d where p.procId = d.procId and k.keyId = d.keyId and p.procName = "$1";
+.quit
+EOF
+
+}
+
+function monRegProcData
+{
+
+# Monitor registry: process keys and values
+sqlite3 sqconfig.db <<EOF
+.separator ""
+.headers on
+.mode list
+select p.procName, ": ", k.keyName, "=", d.dataValue from monRegProcName p, monRegKeyName k, monRegProcData d where p.procId = d.procId and k.keyId = d.keyId;
+.quit
+EOF
+
+}
function persistentData
{
@@ -347,11 +347,11 @@ do
echo "Registry - cluster"
echo "******************"
monRegClusterData
-# echo
-# echo "***********************"
-# echo "Registry - process data"
-# echo "***********************"
-# monRegProcData
+ echo
+ echo "***********************"
+ echo "Registry - process data"
+ echo "***********************"
+ monRegProcData
echo
echo "*************************"
echo "Registry - unique strings"
@@ -389,14 +389,14 @@ do
fi
;;
-# -p)
-# if [[ -n "$2" ]];
-# then
-# monRegSpecificProcData $2
-# else
-# monRegProcData
-# fi
-# ;;
+ -p)
+ if [[ -n "$2" ]];
+ then
+ monRegSpecificProcData $2
+ else
+ monRegProcData
+ fi
+ ;;
-s)
if [[ -n "$2" ]];