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

RUNNING DB2MOVE TOOL WITH -TS OPTION AND ACTIONS OTHER THAN EXPORT, MAY
LEAD TO PROGRAM ABEND OR OTHER INCORRECT BEHAVIOUR

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
When running the db2move tool, the -ts option is only supported 
when the action is EXPORT.  But currently when we run db2move 
with -ts option and actions other than EXPORT, for example 
 
db2move source COPY -sn mkandiah -ts sms_tbs -co TARGET_DB 
target USER myuserid USING mypasswd 
 
we do not get a usage error.  Instead, db2move may abend, or 
continue running with incorrect behaviour. 
 
 
With this fix, db2move will return an appropriate error message 
when -ts option is specified and action is not EXPORT.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When running the db2move tool, the -ts option is only        * 
* supported when the action is EXPORT.  But currently when we  * 
* run db2move with -ts option and actions other than EXPORT,   * 
* for example                                                  * 
*                                                              * 
* db2move source COPY -sn mkandiah -ts sms_tbs -co TARGET_DB   * 
* target USER myuserid USING mypasswd                          * 
*                                                              * 
* we do not get a usage error.  Instead, db2move might abend,  * 
* or continue running with incorrect behaviour.                * 
*                                                              * 
* With this fix, db2move will return an appropriate error      * 
* message when -ts option is specified and action is not       * 
* EXPORT.                                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.8 Fix Pack 3                        * 
****************************************************************
Local Fix:
Do not use the unsupported -ts option when running db2move with 
actions other than EXPORT
available fix packs:
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux

Solution
Problem was first fixed in Version 9.8 Fix Pack 3
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.03.2010
20.12.2010
20.12.2010
Problem solved at the following versions (IBM BugInfos)
9.8.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.3 FixList