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