home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC90047 Status: Closed

SET ECHO OFF command doesn't disable the display of commands and their
output

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
The command SET ECHO OFF doesn't disables the display of 
commands and their output as expected. 
 
For example, the following code on Linux : 
 
"  ======== 
#!/bin/ksh 
DB_HOST=localhost 
DB_LSNRPORT=50000 
DB_NAME=AEIOU 
DB_USER=db2inst1 
DB_PWD=123 
RUNDATE=`date +%Y%m%d` 
FULLDATE=`date` 
CLPPLUS="$HOME/dsdriver/bin/clpplus" 
if [ ! -f $CLPPLUS ] ; then 
   print "ERROR: cannot find a CLPPlus utility at 
CLPPLUS\n\tPlease make sure it is installed. Abort." 
   exit 1 
fi 
$CLPPLUS -nw -s /nolog <<EOF 
SET ECHO OFF 
CONNECT $DB_USER/$DB_PWD@$DB_HOST:$DB_LSNRPORT/$DB_NAME 
select current timestamp from sysibm.sysdummy1; 
EXIT 
EOF 
 
Starting the script and clpplus ignores SET ECHO OFF, still 
shows a CONNECT command displaying user password. 
 
$ ksh ./start_pm_job.ksh 
SET ECHO OFF 
SET LINES 200 
SET PAGES 50000 
SET FEEDBACK OFF 
SET HEADING OFF 
CONNECT db2inst1/123@localhost:50000/AEIOU 
select current timestamp from sysibm.sysdummy1; 
2013-01-29 19:10:19.863112 
EXIT 
$              " 
 
It should disables the display of commands and their output.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* CLPPlus usage                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v101fp3                                       * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
The defect has been fixed in db2_v101fp3
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC95442 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.02.2013
03.10.2013
03.10.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList