|
Problem IC98832
|
Status: Closed |
DATABASE MIGRATION FROM V9.7 TO V10.5 MAY TRAP WITH SQL1224N ERROR. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Fixed in DB2 V10.1 Fix Pack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.01.2014
06.08.2014
08.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.4
|
 |
