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 IC65539 Status: Closed

RAH OR DB2_ALL COMMANDS USING ";" PREFIX SEQUENCE WILL RETURN TH
EERROR "KSH: +1: NOT FOUND.".

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
running rah or db2_all commands using ";" prefix sequence, i.e 
running the commands in parallel in the background, will return 
the error "ksh: +1:  not found.". This issue only occurs to 
DB2 Enterise Server Edition on non-Linux platforms. 
 
For example: 
 
$ db2_all ";date" 
 
rah: primary monitoring process for date is 893000 
 
rah: waiting for 966708, host1:date 
 
ksh: +1:  not found.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users running rah or db2_all commands using ";"              * 
* prefixsequence, i.e running the commands in parallel in      * 
* thebackground in non-Linux DB2 Enterprise Server             * 
* Editionplatforms.                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* running rah or db2_all commands using ";" prefix             * 
* sequence,i.erunning the commands in parallel in the          * 
* background, willreturnthe error "ksh: +1:  not found.". This * 
* issue only occurs toDB2 Enterprise Server Edition on         * 
* non-Linux platforms.For example:$ db2_all ";date"rah:        * 
* primary monitoring process for date is 893000rah: waiting    * 
* for 966708, host1:dateksh: +1:  not found.                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* 1) Try not to use ";" prefix sequence in rah or              * 
* db2_allcommands.2) Modify the rah script and change the line * 
* 676 from "$*)"to "*)" as below.672 case ${OSN?} in673        * 
* ${OSLNX?})674    TAIL_CMD="tail --lines="675    ;;676  *)    * 
* ####### used to be $*) #######677    TAIL_CMD="tail "678     * 
* ;;679 esac;Note that the rah script's location can be found  * 
* by runningtheshell command "which rah", normally it should   * 
* be in thedirectory <db2 instance home>/sqllib/bin.           * 
****************************************************************
Local Fix:
1) Try not to use ";" prefix sequence in rah or db2_all 
commands. 
2) Modify the rah script and change the line 676 from "$*)" to 
"*)" as below. 
 
    672 case ${OSN?} in 
    673   ${OSLNX?}) 
    674     TAIL_CMD="tail --lines=" 
    675     ;; 
    676   *)    ####### used to be $*) ####### 
    677     TAIL_CMD="tail " 
    678     ;; 
    679 esac; 
 
 
Note that the rah script's location can be found by running the 
shell command "which rah", normally it should be in the 
directory <db2 instance home>/sqllib/bin.
available fix packs:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in Version 9.7 Fix Pack 2
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC75400 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
12.01.2010
31.05.2010
31.05.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP2
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.2 FixList