Number of applications only growing

Burkhard Schultheis

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

Subscribe Post Reply

1637

Burkhard Schultheis

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

Larry

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

Burkhard Schultheis

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

Burkhard Schultheis

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

Lennart

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

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....

HTML / CSS

data directory growing huge

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...

PostgreSQL Database

Incredible Shrinking/Growing Controls

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...

Visual Basic .NET

What percent from the windows applications are written in C++?

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...

C / C++

programmatically obtain the hard disk's serial number from VBA?

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)...

Microsoft Access / VBA

Problem with a growing number of connections in HttpWebRequest

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...

.NET Framework

Calling a function when the number of parameters isn't known till runtime

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...

C / C++

Transaction log keeps growing

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...

Microsoft SQL Server

Can roles be applies across applications?

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...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

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$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

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

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

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...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Number of applications only growing

Similar topics