home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC90047 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* CLPPlus usage                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v101fp3                                       * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
The defect has been fixed in db2_v101fp3
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC95442 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.02.2013
03.10.2013
03.10.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList