DB2 FOR LUW / DB2FORLUW / A10 - DB2

After installing the db2 v10.5 code successfully migrating the 
instance, database migration in purescale env. with the command 
db2 upgrade db <dbname> 
 
may fail with SQL1224N 
SQL1224N  The database manager is not able to accept new 
requests, has terminated all requests in progress, or has 
terminated the specified request because of an error or a forced 
interrupt. 
with following symptoms. 
 
2013-09-19-09.54.39.529616-240 I1047414A512         LEVEL: 
Warning 
PID     : 16384152             TID : 9016           PROC : 
db2sysc 0 
INSTANCE: xxxxx               NODE : 000           DB   : xxx 
 
APPHDL  : 0-53                 APPID: *N0.db2geb.130919134924 
 
AUTHID  : xxxxx               HOSTNAME: xxxxxxxxx 
 
EDUID   : 9016                 EDUNAME: db2agent (xxxx) 0 
 
FUNCTION: DB2 UDB, catalog migration, sqlrlm_catalog_migrate, 
probe:4451 
DATA #1 : <preformatted> 
Begin migrating catalog table: SYSTABLES 
 
2013-09-19-09.59.57.349344-240 E1047927A790         LEVEL: Error 
PID     : 16384152             TID : 9016           PROC : 
db2sysc 0 
INSTANCE: xxxxxx               NODE : 000           DB   : xxxx 
APPHDL  : 0-53                 APPID: *N0.db2geb.130919134924 
AUTHID  : xxxxxx              HOSTNAME: xxxxxxxx 
EDUID   : 9016                 EDUNAME: db2agent (xxxxx) 0 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
probe:30 
MESSAGE : ADM14005E  The following error occurred: "Trap". 
First Occurrence Data Capture (FODC) has been invoked in the 
following 
mode: "Automatic".  Diagnostic information has been recorded 
in the directory named 
"/db2/xxxxx/db2dump/FODC_Trap_2013-09-19-09.59.57.341397_1638415 
2_9016_000/". 
 
Trap file generated will have the following stack trace. 
 
Stack #1             Signal #11        Timestamp 
2013-09-19-09.59.57.351262 
0        sqlrlm_CoralLAto101_systables 
1        sqlrlm_CoralLAto101_systables 
2        sqlrlm_catalogFixup 
3        sqlemigr 
4        sqlemigr 
5        sqlemigr 
6        sqeApplication::AppLocalStart 
7        sqeApplication::AppLocalStart 
8        sqlelostWrp 
9        sqleUCengnInit 
10       sqleUCagentConnect 
11       sqljsConnectAttach 
12       sqljs_ddm_accsec 
13       sqljsParseConnect 
14       @72@sqljsSqlam 
15       @72@sqljsSqlam 
16       @72@sqljsDriveRequests 
17       @72@sqljsDrdaAsInnerDriver 
 
<> 
 
This is due to a defect in migration code and this APAR will 
address this issue.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Database migration from v9.8 purescale env. to v10.5.        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 Fix Pack 4 and above.                   * 
****************************************************************

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Fixed in DB2 V10.1 Fix Pack 4

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

20.01.2014
06.08.2014
08.09.2014