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