DB migraton failed from DB2 V7 FP13 to DB2 V8FP7

[Tony Hsu]

Hi, I got a "SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command.
SQLSTATE=55032"

error when trying to migrate my DB to DB2 V7...

I attached 4 zip files this note.
1) db2diag.zip - db2diag.log
2) db2inst1.zip - db2inst1.nfy
3) t37608-1.zip - Part 1 of t37608.000
4) t37608-2.zip - Part 2 of t37608.000

Below are my steps,

1) Verify db2level - which indicated db2inst1 is under DB2 V7.
$db2level
DB21085I Instance "db2inst1" uses DB2 code release "SQL07026" with level identifier "03070105" and informational toekns "DB2 V7.1.0.72", "s021110" and
"U484610"

2) Install DB2 V8 FP7

3) Run migration tool to convert db2inst1 to DB2 V8 - Result successful..
# ./db2imigr db2inst1

db2ckmig was successful. Database(s) can be migrated.

/home/db2inst1/sqllib_v71/function/add_months: Not a directory
/home/db2inst1/sqllib_v71/function/getappid: Not a directory
/home/db2inst1/sqllib_v71/function/months_between: Not a directory
/home/db2inst1/sqllib_v71/function/to_char: Not a directory
/home/db2inst1/sqllib_v71/function/to_date: Not a directory
DBI1070I Program db2imigr completed successfully.

4) Double check the db2level which shows it's under DB2 V8
$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08020" with level identifier "03010106".
Informational tokens are "DB2 v8.1.1.73", "OD_14080", "U803793_14080", and FixPak "7".
Product is installed at "/usr/opt/db2_08_01".

5) Start DB2 manager
$ db2start
07/14/2006 16:05:14 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.

6) Convert the sample DB created under DB2 V7 - Result successful..
$ db2 migrate database sample
DB20000I The MIGRATE DATABASE command completed successfully.

7) Verify DB sample

db2 => connect to sample

Database Connection Information

Database server = DB2/6000 8.2.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE

db2 => list tables

Table/View Schema Type Creation time
------------------------------- --------------- ----- --------------------------
CL_SCHED DB2INST1 T 2006-07-14-02.59.39.203547
DEPARTMENT DB2INST1 T 2006-07-14-02.59.37.205177
EMP_ACT DB2INST1 T 2006-07-14-02.59.37.463243
EMP_PHOTO DB2INST1 T 2006-07-14-02.59.37.768934
EMP_RESUME DB2INST1 T 2006-07-14-02.59.38.547751
EMPLOYEE DB2INST1 T 2006-07-14-02.59.37.279353
IN_TRAY DB2INST1 T 2006-07-14-02.59.39.266638
ORG DB2INST1 T 2006-07-14-02.59.36.992592
PROJECT DB2INST1 T 2006-07-14-02.59.37.655876
SALES DB2INST1 T 2006-07-14-02.59.39.074732
STAFF DB2INST1 T 2006-07-14-02.59.37.090247

8) Convert DB ispb created under DB2 V7 - Result failed..
$ db2 migrate database ispb
SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command.
SQLSTATE=55032

In db2diag.log,
---------------------
at '2006-07-17-13.27.51.848214+480', there's the entry
PID : 37608 TID : 1 PROC : db2agent (ISPB) 0
INSTANCE: db2inst1 NODE : 000 DB : ISPB
APPHDL : 0-7 APPID: *LOCAL.db2inst1.060717052748
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
11
DATA #2 : Siginfo, 64 bytes

and from http://publib.boulder.ibm.com/infoce...d/c0020711.htm

Signal # 11 indicated that it's a segmentation violation.....


Also at '2006-07-17-13.28.21.937325+480'
2006-07-17-13.28.21.937325+480 I5322076C433 LEVEL: Severe
PID : 37722 TID : 1 PROC : db2ipccm 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler, probe:50
DATA #1 : String, 158 bytes
Detected the death of an EDU with process id 37608
The signal number that terminated this process was 11
Look for trap files (t37608.*) in the dump directory


-----t37608.000------------------------------------------------------------------
db2 build information: DB2 v8.1.0.72 s040914 SQL08020
timestamp: 2006-07-17-13.27.51.757195
instance name: db2inst1.000
EDU name : db2agent (ISPB) 0
Signal #11
uname: S:AIX R:2 V:5 M:00595FBA4C00 N:pvc21
thread id : 1 (0x1)

siginfo_t (length=64)
0000000B 00000000 00000033 00000000
00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000

Signal #11 (SIGSEGV): si_addr is 0x00000000, si_code is 0x00000033 (SEGV_ACCERR:Invalid permissions for mapped object.)

Resource Limits

Data seg top [sbrk(0)] = 0x201BA020
Cur data size (bytes) = 0x000000000EFFFE00
Cur stack size (bytes) = 0x0000000010000000
Cur core size (bytes) = 0x0000000077359400

..... omitted .....


*** Start dump of instructions at point of failure ***

0xD86362CC : 4200FFE8 bdn 0xD86362B4 # 16,bit0
0xD86362D0 : 80E40000 lwz r7,0(r4)
0xD86362D4 : 30A5FFFC addic r5,r5,-4
0xD86362D8 : 7CE95038 and r9,r7,r10
0xD86362DC : 7D295014 addc r9,r9,r10
0xD86362E0 : 7D2C50F9 nor. r12,r9,r10
0xD86362E4 : 40820034 bne cr0,0xD8636318 # 4,bit2
0xD86362E8 : 85040004 lwzu r8,4(r4)
>>>> 0xD86362EC : 94E50004 stwu r7,4(r5)
0xD86362F0 : 7D095038 and r9,r8,r10
0xD86362F4 : 7D295014 addc r9,r9,r10
0xD86362F8 : 7D2C50F9 nor. r12,r9,r10
0xD86362FC : 4082002C bne cr0,0xD8636328 # 4,bit2
0xD8636300 : 84E40004 lwzu r7,4(r4)

*** End dump of instructions at point of failure ***

*** Start stack traceback ***

0xD86362EC strcpy + 0x8C
0xD98A1440 sqlrlm_migrate_6to8_sysfuncparms__FP20sqle_agent_p rivatecb8sqlr_tidP8sqlr_tidUsPc + 0x16D4
0xD988CA8C sqlrlm_catalogFixup__FP8sqlrr_cbUslT3P17sqlrlm_cat ChangesPc8sqlr_tidP8sqlr_tid + 0x108
0xD98C6950 sqlrlm_catalog_migrate__FP20sqle_agent_privatecbs + 0x141C
0xD98C53E4 sqlrlmig__FsP5sqlca + 0x5C
0xD988A584 sqlefmig__FPcP7sqlebwaP5sqlca + 0x598
0xD9887FE4 sqlemigr__FP7sqlebwaP7UCintfc + 0x94C
0xD8221A50 sqlelost__FP7UCintfc + 0xD6C
0xD84BE8C0 sqleUCengnInit__FP7UCintfcUs + 0x1F4
0xD84BE3DC sqleUCagentConnect + 0x23C
0xD8AAFC70 sqljsConnectAttach__FP13sqljsDrdaAsCbP7UCintfc + 0xB0
0xD8AAA310 sqljs_ddm_accsec__FP7UCintfcP14sqljsDDMObject + 0x2E8
0xD86D01B4 sqljsParseConnect__FP13sqljsDrdaAsCbP14sqljsDDMObj ectP7UCintfc + 0x74
0xD86D0584 sqljsParse__FP13sqljsDrdaAsCbP7UCintfc + 0x250
0xD86B57C0 sqljsSqlam__FP7UCintfcP13sqle_agent_cbb + 0x11C
0xD86B5D5C sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandl e + 0x88
0xD86B5C00 sqljsDrdaAsInnerDriver__FP17sqlcc_init_structb + 0xB0
0xD86B59D4 sqljsDrdaAsDriver__FP17sqlcc_init_struct + 0x84
0xD8582D38 sqleRunAgent__FPcUl + 0x288
0xD8354B88 sqloCreateEDU__FPFPcUl_vPcUlP13SQLO_EDU_INFOPl + 0x198
0xD8354654 sqloSpawnEDU + 0x210
0xD8581734 sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_stru ctP16sqlkdRqstRplyFmtP18sqle_master_app_cbT1P20age ntPoolLatchVectorP16SQLO_EDUWAITPOSTP17sqle_connec t_infoPP13sqle_agent_cb + 0x2C4
0xD8581074 sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12s qlz_app_hdlP16sqlkdRqstRplyFmtP17sqle_connect_info + 0x318
0xD8580C8C sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_ hdlPv + 0x1C0
0xD8340764 sqlccipcconnmgr_child__FPcUl + 0x80C
0xD8354B88 sqloCreateEDU__FPFPcUl_vPcUlP13SQLO_EDU_INFOPl + 0x198
0xD8354654 sqloSpawnEDU + 0x210
0xD833FDE0 sqlccipcconnmgr__FP15SQLCC_CONNMGR_TP9sqlf_kcfd + 0x138
0x10003C7C sqleInitSysCtlr__FPi + 0x7D8
0x10002CF8 sqleSysCtlr__Fv + 0x40
0xD8358B78 sqloRunInstance + 0x75C
0x100028EC DB2main + 0x8A4
0x10003470 main + 0xC

*** End stack traceback ***

... omitted....

-----end of t37608.000------------------------------------------------------------------

last entry in the 'stack traceback' section shows 'strcpy'.....

Does this mean that DB2 failed when it's trying to perform 'strcpy'? If not, is there anyways for me to correct this problem?

Regards,

Tony