473,372 Members | 859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Number of applications only growing

I've installed a fresh DB2 V9.1 server (Express-C). Now I see, that the
number of applications (db2 list applications) is growing all the times
when a script is run which makes some database operations. This is on
Linux.

I tested the same script against an older DB2 V7 on AIX and the number
of applications (db2bp) is growing by one, but then the db2bp
disappears, so the number of applications is not growing all the time.

Here is the script:

#!/bin/sh
#
# CVS-ID: $Id: import_stammdaten.sh,v 1.1 2006/05/18 13:59:46 wagner
Exp $ #

init ()
{
LANG=C
expFormat=DEL
connect=0

# Kommandozeilen-Parameter abarbeiten
while [ -n "$1" ]
do
case $1 in
-del)
expFormat=DEL
shift;;
-ixf)
expFormat=IXF
shift;;
*)
usage;;
esac
done

db2 CONNECT TO telematx USER lzgneu USING lzg
connect=1
tableDeleteList="FORMATS SAMMELALARME SAMMELMELDUNG TEXTS WOERTER \
RELATION BFST MDST MWST SWST ZWST STPRIO NETZ VERZOEGERUNG \
VERZ_DAUER STST"
tableInsertList="FORMATS SAMMELALARME SAMMELMELDUNG WOERTER TEXTS \
STST STPRIO MDST BFST MWST SWST ZWST RELATION NETZ VERZ_DAUER \
VERZOEGERUNG"
}
usage ()
{
echo ""
echo "usage : import_stammdaten.sh <-del|-ixf>"
echo ""
fine 0
}
fine ()
{
if [ $connect -eq 1 ]
then
db2 terminate >/dev/null 2>&1
fi
exit $1
}
fatalError ()
{
echo ""
echo " ES IST EIN FATALER FEHLER AUFGETRETEN"
echo " TROTZDEM FORTFAHREN ? (y/n)"
read x
if [ "$x" != y ]
then
fine 1
fi
}
db2Command ()
{
echo "$1" | tr '[:blank:]' ' '
rv=`db2 "$1" | egrep -v "$2|----|selected" | tr '\n' ' ' \
| tr -s '[:blank:]'`
echo $rv

if [ $? -ne 0 ]
then
fatalError
fi
}
main ()
{
gzFiles=`ls *.gz 2>>/dev/null`
if [ $? -eq 0 ]
then
for fileName in `echo *.gz 2>>/dev/null`
do
gzip -d $fileName
echo " Unzipping $fileName"
done
fi

mkdir -p temp
for fileName in *
do
if [ -f $fileName ]
then
newFileName=`echo $fileName | tr '[:lower:]' '[:upper:]'`
ln -f $fileName temp/$newFileName
fi
done
cd temp
echo *

for tabName in $tableDeleteList
do
echo $tabName
if [ ! -f $tabName.$expFormat ]
then
echo "Datei $tabName.$expFormat wurde nicht gefunden"
echo "Die Daten aus der Tabelle werden jedoch später gelöscht!"
fatalError
fi
done

echo "SOLLEN JETZT ALLE STAMMDATEN GELÖSCHT WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for tabName in $tableDeleteList
do
if [ "$tabName" = "TEXTS" -o "$tabName" = "WOERTER" ]
then
db2Command "SELECT COALESCE (MAX(nr), 1) AS MAXIMUM FROM \
lzgneu.$tabName" MAXIMUM
maxNr=$rv
if [ "$maxNr" = " -" -o "$maxNr" = "-" -o "$maxNr" = "- " ]
then
maxNr=0
fi
aktNr=0
while [ $aktNr -lt $maxNr ]
do
aktNr=`expr $aktNr + 1000`
db2Command "DELETE FROM lzgneu.$tabName \
WHERE nr <= $aktNr" dummie
sleep 1
done
elif [ "$tabName" = "RELATION" ]
then
aktNr=0
while [ $aktNr -lt 260 ]
do
aktNr=`expr $aktNr + 20`
db2Command "DELETE FROM lzgneu.$tabName WHERE \
lfdnr < $aktNr" dummie
sleep 1
done
elif [ "$tabName" = "NETZ" ]
then
aktNr=0
while [ $aktNr -lt 260 ]
do
aktNr=`expr $aktNr + 20`
db2Command "DELETE FROM lzgneu.$tabName WHERE \
lfdnr_start < $aktNr" dummie
sleep 1
done
fi
db2Command "DELETE FROM lzgneu.$tabName" dummie
sleep 1
db2Command "REORG TABLE lzgneu.$tabName" dummie
sleep 1
done
fi

echo "SOLLEN JETZT DIE STAMMDATEN IMPORTIERT WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for tabName in $tableInsertList
do
if [ -f $tabName.$expFormat.gz ]
then
echo " Unzipping $tabName.$expFormat.gz"
gzip -d $tabName.$expFormat.gz
fi

db2Command "IMPORT from $tabName.$expFormat OF $expFormat \
COMMITCOUNT 10000 INSERT INTO lzgneu.$tabName" dummie
sleep 1
db2Command "REORG TABLE lzgneu.$tabName" dummie
sleep 1
done
fi

echo "SOLLEN JETZT DIE PACKAGES NEU GEBUNDEN WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for j in `db2 -x "SELECT pkgname FROM syscat.packages \
WHERE pkgschema != 'NULLID'"`
do
db2Command "REBIND lzgneu.$j" dummie
sleep 1
done
fi
cd ..
rm -rf temp
}

init $*
main
fine 0

During the delete loop I see the number of db2bp growing, I thing 1 for
every db2 statement. Why?
It's a big problem for me. I've never seen such a behavior before!

Regards,
Burkhard
Dec 20 '07 #1
6 1636
Burkhard Schultheis schrieb:
I've installed a fresh DB2 V9.1 server (Express-C). Now I see, that the
number of applications (db2 list applications) is growing all the times
when a script is run which makes some database operations. This is on
Linux.

I tested the same script against an older DB2 V7 on AIX and the number
of applications (db2bp) is growing by one, but then the db2bp
disappears, so the number of applications is not growing all the time.

Here is the script:

#!/bin/sh
#
# CVS-ID: $Id: import_stammdaten.sh,v 1.1 2006/05/18 13:59:46 wagner
Exp $ #

init ()
{
LANG=C
expFormat=DEL
connect=0

# Kommandozeilen-Parameter abarbeiten
while [ -n "$1" ]
do
case $1 in
-del)
expFormat=DEL
shift;;
-ixf)
expFormat=IXF
shift;;
*)
usage;;
esac
done

db2 CONNECT TO telematx USER lzgneu USING lzg
connect=1
tableDeleteList="FORMATS SAMMELALARME SAMMELMELDUNG TEXTS WOERTER \
RELATION BFST MDST MWST SWST ZWST STPRIO NETZ VERZOEGERUNG \
VERZ_DAUER STST"
tableInsertList="FORMATS SAMMELALARME SAMMELMELDUNG WOERTER TEXTS \
STST STPRIO MDST BFST MWST SWST ZWST RELATION NETZ VERZ_DAUER \
VERZOEGERUNG"
}
usage ()
{
echo ""
echo "usage : import_stammdaten.sh <-del|-ixf>"
echo ""
fine 0
}
fine ()
{
if [ $connect -eq 1 ]
then
db2 terminate >/dev/null 2>&1
fi
exit $1
}
fatalError ()
{
echo ""
echo " ES IST EIN FATALER FEHLER AUFGETRETEN"
echo " TROTZDEM FORTFAHREN ? (y/n)"
read x
if [ "$x" != y ]
then
fine 1
fi
}
db2Command ()
{
echo "$1" | tr '[:blank:]' ' '
rv=`db2 "$1" | egrep -v "$2|----|selected" | tr '\n' ' ' \
| tr -s '[:blank:]'`
echo $rv

if [ $? -ne 0 ]
then
fatalError
fi
}
main ()
{
gzFiles=`ls *.gz 2>>/dev/null`
if [ $? -eq 0 ]
then
for fileName in `echo *.gz 2>>/dev/null`
do
gzip -d $fileName
echo " Unzipping $fileName"
done
fi

mkdir -p temp
for fileName in *
do
if [ -f $fileName ]
then
newFileName=`echo $fileName | tr '[:lower:]' '[:upper:]'`
ln -f $fileName temp/$newFileName
fi
done
cd temp
echo *

for tabName in $tableDeleteList
do
echo $tabName
if [ ! -f $tabName.$expFormat ]
then
echo "Datei $tabName.$expFormat wurde nicht gefunden"
echo "Die Daten aus der Tabelle werden jedoch später gelöscht!"
fatalError
fi
done

echo "SOLLEN JETZT ALLE STAMMDATEN GELÖSCHT WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for tabName in $tableDeleteList
do
if [ "$tabName" = "TEXTS" -o "$tabName" = "WOERTER" ]
then
db2Command "SELECT COALESCE (MAX(nr), 1) AS MAXIMUM FROM \
lzgneu.$tabName" MAXIMUM
maxNr=$rv
if [ "$maxNr" = " -" -o "$maxNr" = "-" -o "$maxNr" = "- " ]
then
maxNr=0
fi
aktNr=0
while [ $aktNr -lt $maxNr ]
do
aktNr=`expr $aktNr + 1000`
db2Command "DELETE FROM lzgneu.$tabName \
WHERE nr <= $aktNr" dummie
sleep 1
done
elif [ "$tabName" = "RELATION" ]
then
aktNr=0
while [ $aktNr -lt 260 ]
do
aktNr=`expr $aktNr + 20`
db2Command "DELETE FROM lzgneu.$tabName WHERE \
lfdnr < $aktNr" dummie
sleep 1
done
elif [ "$tabName" = "NETZ" ]
then
aktNr=0
while [ $aktNr -lt 260 ]
do
aktNr=`expr $aktNr + 20`
db2Command "DELETE FROM lzgneu.$tabName WHERE \
lfdnr_start < $aktNr" dummie
sleep 1
done
fi
db2Command "DELETE FROM lzgneu.$tabName" dummie
sleep 1
db2Command "REORG TABLE lzgneu.$tabName" dummie
sleep 1
done
fi

echo "SOLLEN JETZT DIE STAMMDATEN IMPORTIERT WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for tabName in $tableInsertList
do
if [ -f $tabName.$expFormat.gz ]
then
echo " Unzipping $tabName.$expFormat.gz"
gzip -d $tabName.$expFormat.gz
fi

db2Command "IMPORT from $tabName.$expFormat OF $expFormat \
COMMITCOUNT 10000 INSERT INTO lzgneu.$tabName" dummie
sleep 1
db2Command "REORG TABLE lzgneu.$tabName" dummie
sleep 1
done
fi

echo "SOLLEN JETZT DIE PACKAGES NEU GEBUNDEN WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for j in `db2 -x "SELECT pkgname FROM syscat.packages \
WHERE pkgschema != 'NULLID'"`
do
db2Command "REBIND lzgneu.$j" dummie
sleep 1
done
fi
cd ..
rm -rf temp
}

init $*
main
fine 0

During the delete loop I see the number of db2bp growing, I thing 1 for
every db2 statement. Why?
It's a big problem for me. I've never seen such a behavior before!
On a second machine with DB2 V9 it's the same problem! :-( For every
statement there is a new process until the maximum number of connections
is reached. Bug in 9.1?

Regards,
Burkhard
Dec 20 '07 #2
Burkhard Schultheis wrote:
Burkhard Schultheis schrieb:
>>I've installed a fresh DB2 V9.1 server (Express-C). Now I see, that the
number of applications (db2 list applications) is growing all the times
when a script is run which makes some database operations. This is on
Linux.

I tested the same script against an older DB2 V7 on AIX and the number
of applications (db2bp) is growing by one, but then the db2bp
disappears, so the number of applications is not growing all the time.

Here is the script:

#!/bin/sh
#
# CVS-ID: $Id: import_stammdaten.sh,v 1.1 2006/05/18 13:59:46 wagner
Exp $ #

init ()
{
LANG=C
expFormat=DEL
connect=0

# Kommandozeilen-Parameter abarbeiten
while [ -n "$1" ]
do
case $1 in
-del)
expFormat=DEL
shift;;
-ixf)
expFormat=IXF
shift;;
*)
usage;;
esac
done

db2 CONNECT TO telematx USER lzgneu USING lzg
connect=1
tableDeleteList="FORMATS SAMMELALARME SAMMELMELDUNG TEXTS WOERTER \
RELATION BFST MDST MWST SWST ZWST STPRIO NETZ VERZOEGERUNG \
VERZ_DAUER STST"
tableInsertList="FORMATS SAMMELALARME SAMMELMELDUNG WOERTER TEXTS \
STST STPRIO MDST BFST MWST SWST ZWST RELATION NETZ VERZ_DAUER \
VERZOEGERUNG"
}
usage ()
{
echo ""
echo "usage : import_stammdaten.sh <-del|-ixf>"
echo ""
fine 0
}
fine ()
{
if [ $connect -eq 1 ]
then
db2 terminate >/dev/null 2>&1
fi
exit $1
}
fatalError ()
{
echo ""
echo " ES IST EIN FATALER FEHLER AUFGETRETEN"
echo " TROTZDEM FORTFAHREN ? (y/n)"
read x
if [ "$x" != y ]
then
fine 1
fi
}
db2Command ()
{
echo "$1" | tr '[:blank:]' ' '
rv=`db2 "$1" | egrep -v "$2|----|selected" | tr '\n' ' ' \
| tr -s '[:blank:]'`
echo $rv

if [ $? -ne 0 ]
then
fatalError
fi
}
main ()
{
gzFiles=`ls *.gz 2>>/dev/null`
if [ $? -eq 0 ]
then
for fileName in `echo *.gz 2>>/dev/null`
do
gzip -d $fileName
echo " Unzipping $fileName"
done
fi

mkdir -p temp
for fileName in *
do
if [ -f $fileName ]
then
newFileName=`echo $fileName | tr '[:lower:]' '[:upper:]'`
ln -f $fileName temp/$newFileName
fi
done
cd temp
echo *

for tabName in $tableDeleteList
do
echo $tabName
if [ ! -f $tabName.$expFormat ]
then
echo "Datei $tabName.$expFormat wurde nicht gefunden"
echo "Die Daten aus der Tabelle werden jedoch später gelöscht!"
fatalError
fi
done

echo "SOLLEN JETZT ALLE STAMMDATEN GELÖSCHT WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for tabName in $tableDeleteList
do
if [ "$tabName" = "TEXTS" -o "$tabName" = "WOERTER" ]
then
db2Command "SELECT COALESCE (MAX(nr), 1) AS MAXIMUM FROM \
lzgneu.$tabName" MAXIMUM
maxNr=$rv
if [ "$maxNr" = " -" -o "$maxNr" = "-" -o "$maxNr" = "- " ]
then
maxNr=0
fi
aktNr=0
while [ $aktNr -lt $maxNr ]
do
aktNr=`expr $aktNr + 1000`
db2Command "DELETE FROM lzgneu.$tabName \
WHERE nr <= $aktNr" dummie
sleep 1
done
elif [ "$tabName" = "RELATION" ]
then
aktNr=0
while [ $aktNr -lt 260 ]
do
aktNr=`expr $aktNr + 20`
db2Command "DELETE FROM lzgneu.$tabName WHERE \
lfdnr < $aktNr" dummie
sleep 1
done
elif [ "$tabName" = "NETZ" ]
then
aktNr=0
while [ $aktNr -lt 260 ]
do
aktNr=`expr $aktNr + 20`
db2Command "DELETE FROM lzgneu.$tabName WHERE \
lfdnr_start < $aktNr" dummie
sleep 1
done
fi
db2Command "DELETE FROM lzgneu.$tabName" dummie
sleep 1
db2Command "REORG TABLE lzgneu.$tabName" dummie
sleep 1
done
fi

echo "SOLLEN JETZT DIE STAMMDATEN IMPORTIERT WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for tabName in $tableInsertList
do
if [ -f $tabName.$expFormat.gz ]
then
echo " Unzipping $tabName.$expFormat.gz"
gzip -d $tabName.$expFormat.gz
fi

db2Command "IMPORT from $tabName.$expFormat OF $expFormat \
COMMITCOUNT 10000 INSERT INTO lzgneu.$tabName" dummie
sleep 1
db2Command "REORG TABLE lzgneu.$tabName" dummie
sleep 1
done
fi

echo "SOLLEN JETZT DIE PACKAGES NEU GEBUNDEN WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for j in `db2 -x "SELECT pkgname FROM syscat.packages \
WHERE pkgschema != 'NULLID'"`
do
db2Command "REBIND lzgneu.$j" dummie
sleep 1
done
fi
cd ..
rm -rf temp
}

init $*
main
fine 0

During the delete loop I see the number of db2bp growing, I thing 1 for
every db2 statement. Why?
It's a big problem for me. I've never seen such a behavior before!


On a second machine with DB2 V9 it's the same problem! :-( For every
statement there is a new process until the maximum number of connections
is reached. Bug in 9.1?

Regards,
Burkhard
Did you try searching the APAR list for V9 fixpaks for candidates? Or
perhaps just applying the latest fixpak?

Larry
Dec 20 '07 #3
Larry schrieb:
Burkhard Schultheis wrote:
>Burkhard Schultheis schrieb:
>>I've installed a fresh DB2 V9.1 server (Express-C). Now I see, that the
number of applications (db2 list applications) is growing all the times
when a script is run which makes some database operations. This is on
Linux.

I tested the same script against an older DB2 V7 on AIX and the number
of applications (db2bp) is growing by one, but then the db2bp
disappears, so the number of applications is not growing all the time.

Here is the script:

#!/bin/sh
#
# CVS-ID: $Id: import_stammdaten.sh,v 1.1 2006/05/18 13:59:46 wagner
Exp $ #

init ()
{
LANG=C
expFormat=DEL
connect=0

# Kommandozeilen-Parameter abarbeiten
while [ -n "$1" ]
do
case $1 in
-del)
expFormat=DEL
shift;;
-ixf)
expFormat=IXF
shift;;
*)
usage;;
esac
done

db2 CONNECT TO telematx USER lzgneu USING lzg
connect=1
tableDeleteList="FORMATS SAMMELALARME SAMMELMELDUNG TEXTS WOERTER \
RELATION BFST MDST MWST SWST ZWST STPRIO NETZ VERZOEGERUNG \
VERZ_DAUER STST"
tableInsertList="FORMATS SAMMELALARME SAMMELMELDUNG WOERTER TEXTS \
STST STPRIO MDST BFST MWST SWST ZWST RELATION NETZ VERZ_DAUER \
VERZOEGERUNG"
}
usage ()
{
echo ""
echo "usage : import_stammdaten.sh <-del|-ixf>"
echo ""
fine 0
}
fine ()
{
if [ $connect -eq 1 ]
then
db2 terminate >/dev/null 2>&1
fi
exit $1
}
fatalError ()
{
echo ""
echo " ES IST EIN FATALER FEHLER AUFGETRETEN"
echo " TROTZDEM FORTFAHREN ? (y/n)"
read x
if [ "$x" != y ]
then
fine 1
fi
}
db2Command ()
{
echo "$1" | tr '[:blank:]' ' '
rv=`db2 "$1" | egrep -v "$2|----|selected" | tr '\n' ' ' \
| tr -s '[:blank:]'`
echo $rv

if [ $? -ne 0 ]
then
fatalError
fi
}
main ()
{
gzFiles=`ls *.gz 2>>/dev/null`
if [ $? -eq 0 ]
then
for fileName in `echo *.gz 2>>/dev/null`
do
gzip -d $fileName
echo " Unzipping $fileName"
done
fi

mkdir -p temp
for fileName in *
do
if [ -f $fileName ]
then
newFileName=`echo $fileName | tr '[:lower:]' '[:upper:]'`
ln -f $fileName temp/$newFileName
fi
done
cd temp
echo *

for tabName in $tableDeleteList
do
echo $tabName
if [ ! -f $tabName.$expFormat ]
then
echo "Datei $tabName.$expFormat wurde nicht gefunden"
echo "Die Daten aus der Tabelle werden jedoch später gelöscht!"
fatalError
fi
done

echo "SOLLEN JETZT ALLE STAMMDATEN GELÖSCHT WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for tabName in $tableDeleteList
do
if [ "$tabName" = "TEXTS" -o "$tabName" = "WOERTER" ]
then
db2Command "SELECT COALESCE (MAX(nr), 1) AS MAXIMUM FROM \
lzgneu.$tabName" MAXIMUM
maxNr=$rv
if [ "$maxNr" = " -" -o "$maxNr" = "-" -o "$maxNr" = "- " ]
then
maxNr=0
fi
aktNr=0
while [ $aktNr -lt $maxNr ]
do
aktNr=`expr $aktNr + 1000`
db2Command "DELETE FROM lzgneu.$tabName \
WHERE nr <= $aktNr" dummie
sleep 1
done
elif [ "$tabName" = "RELATION" ]
then
aktNr=0
while [ $aktNr -lt 260 ]
do
aktNr=`expr $aktNr + 20`
db2Command "DELETE FROM lzgneu.$tabName WHERE \
lfdnr < $aktNr" dummie
sleep 1
done
elif [ "$tabName" = "NETZ" ]
then
aktNr=0
while [ $aktNr -lt 260 ]
do
aktNr=`expr $aktNr + 20`
db2Command "DELETE FROM lzgneu.$tabName WHERE \
lfdnr_start < $aktNr" dummie
sleep 1
done
fi
db2Command "DELETE FROM lzgneu.$tabName" dummie
sleep 1
db2Command "REORG TABLE lzgneu.$tabName" dummie
sleep 1
done
fi

echo "SOLLEN JETZT DIE STAMMDATEN IMPORTIERT WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for tabName in $tableInsertList
do
if [ -f $tabName.$expFormat.gz ]
then
echo " Unzipping $tabName.$expFormat.gz"
gzip -d $tabName.$expFormat.gz
fi

db2Command "IMPORT from $tabName.$expFormat OF $expFormat \
COMMITCOUNT 10000 INSERT INTO lzgneu.$tabName" dummie
sleep 1
db2Command "REORG TABLE lzgneu.$tabName" dummie
sleep 1
done
fi

echo "SOLLEN JETZT DIE PACKAGES NEU GEBUNDEN WERDEN? (y/n)"
read x
if [ "$x" = y ]
then
for j in `db2 -x "SELECT pkgname FROM syscat.packages \
WHERE pkgschema != 'NULLID'"`
do
db2Command "REBIND lzgneu.$j" dummie
sleep 1
done
fi
cd ..
rm -rf temp
}

init $*
main
fine 0

During the delete loop I see the number of db2bp growing, I thing 1 for
every db2 statement. Why?
It's a big problem for me. I've never seen such a behavior before!

On a second machine with DB2 V9 it's the same problem! :-( For every
statement there is a new process until the maximum number of connections
is reached. Bug in 9.1?

Regards,
Burkhard
Did you try searching the APAR list for V9 fixpaks for candidates? Or
perhaps just applying the latest fixpak?
Nothing found for "connect" and "maximum". :-( Today I'll try 9.5.

Regards,
Burkhard
Dec 21 '07 #4
Now I have tested some scripts with 9.1:

Burkhard Schultheis schrieb:

An here is the problem:
>
db2Command ()
{
echo "$1" | tr '[:blank:]' ' '
rv=`db2 "$1" | egrep -v "$2|----|selected" | tr '\n' ' ' \
| tr -s '[:blank:]'`
echo $rv

if [ $? -ne 0 ]
then
fatalError
fi
}
If I change it to
db2Command ()
{
db2 "$1"
}

then I got no extra processes!

Any idea why? As I wrote, on AIX with V7.x it was ok with the original
script!

Regards,
Burkhard
Dec 21 '07 #5
On Dec 21, 9:45 am, Burkhard Schultheis <schulth...@tde-online.de>
wrote:
[...]
>
Any idea why? As I wrote, on AIX with V7.x it was ok with the original
script!
Not really. But you might be able to track your problem by executing
your script with -x (or add -x to the first line in your script as in
#!/bin/sh -x)

/Lennart
Dec 21 '07 #6
Ian
Burkhard Schultheis wrote:
Now I have tested some scripts with 9.1:

Burkhard Schultheis schrieb:

An here is the problem:
>db2Command ()
{
echo "$1" | tr '[:blank:]' ' '
rv=`db2 "$1" | egrep -v "$2|----|selected" | tr '\n' ' ' \
| tr -s '[:blank:]'`
echo $rv

if [ $? -ne 0 ]
then
fatalError
fi
}

If I change it to
db2Command ()
{
db2 "$1"
}

then I got no extra processes!

Any idea why? As I wrote, on AIX with V7.x it was ok with the original
script!
The difference here is that using the backticks causes the db2 command
to execute in a different shell.

Therefore, each time you execute db2Command(), the 'db2' command will
create a separate db2bp. Normally, when the shell goes away, the db2bp
process automatically goes away -- so it would seem that something is
awry here.


Dec 22 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Ryan R. Rosario | last post by:
Hi - **I apologize for posting this again. I dont think my first one went thru** I am in the process of converting a table based website over to a CSS based website and I am having a problem....
3
by: Esger Abbink | last post by:
Hello, it is very possible that this is a well described problem, but I have not been able to find the solution. On two production server (7.2rc2) of ours the data directory is growing to...
1
by: Keith | last post by:
I have just tried form inheritance for the first time and I am having trouble with the controls shrinking each I build the project on my home computer and growing each time I build on my work...
2
by: Salamandur 7 | last post by:
Hello all, Does anyone have an idea what percent(not exactly) from the windows applications are written in C++ , what in Pascal(Delphi) and what in Visual Basic? It's maybe the C++ in which most...
14
by: Lauren Wilson | last post by:
Discovered this interesting comment on MSDN: "To programmatically obtain the hard disk's serial number that the manufacturer assigns, use the Windows Management Instrumentation (WMI)...
2
by: Basel | last post by:
Hi All! I'm having a problem with a growing number of connections. my app generates http requests and reads responses. the app creates large number of threads (100 or more) that generates the...
18
by: John Friedland | last post by:
My problem: I need to call (from C code) an arbitrary C library function, but I don't know until runtime what the function name is, how many parameters are required, and what the parameters are. I...
4
by: yashgt | last post by:
Hi, We have created a SQL server 2000 database. We observe that the transaction log keeps growing over time. We are now about to run out of space. We have been periodically shrinking the...
1
by: Larry Bud | last post by:
I have set up so that user can span applications, but how do I do that for roles? I'm lucky enough to be at the ground level of internal business app development for a growing company, so I can...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.