Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    2

    Unanswered: DB migraton failed from DB2 V7 FP13 to DB2 V8FP7

    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 V7 DB to V8...

    I am running AIX 5.2 with ML4
    $ oslevel -r
    5200-04
    $ instfix -i |grep ML
    All filesets for 5.2.0.0_AIX_ML were found.
    All filesets for 5200-01_AIX_ML were found.
    All filesets for 5200-02_AIX_ML were found.
    All filesets for 5200-03_AIX_ML were found.
    All filesets for 5200-04_AIX_ML were found.

    Below are my steps,

    1) Verify db2level - which indicated db2inst1 is under DB2 V7 FP13.

    $ db2level
    DB21085I Instance "db2inst1" uses DB2 code release "SQL07029" with level
    identifier "030A0105" and informational tokens "DB2 v7.1.0.103", "s040930" and
    "U499061".

    $ db2licm -l
    Product Name = "DB2 Enterprise Edition"
    Product Password = "DB2UDBEE"
    Version Information = "7.2"


    2) Install DB2 V8 FP7

    3) Verify the state of the database (database sample and ispb)
    $ ./db2ckmig sample -l /tmp/out.log -u db2inst1 -p wps123
    db2ckmig was successful. Database(s) can be migrated.

    $ ./db2ckmig ispb -l /tmp/out.log -u db2inst1 -p wps123
    db2ckmig was successful. Database(s) can be migrated.

    3) Check for database structure consistency
    ./db2dart sample /db
    ./db2dart ispb /db

    Both DB OK.

    The requested DB2DART processing has completed successfully!
    All operation completed without error;
    no problems were detected in the database.

    4) 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.


    5) 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".

    $ db2licm -l
    Product Name = "DB2 Enterprise Server Edition"
    Product Identifier = "DB2ESE"
    Version Information = "8.2"


    6) Start DB2 manager
    $ db2start
    07/25/2006 16:09:42 0 0 SQL1063N DB2START processing was successful.
    SQL1063N DB2START processing was successful.


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

    8) 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-25-15.03.34.191730
    DEPARTMENT DB2INST1 T 2006-07-25-15.03.30.535944
    EMP_ACT DB2INST1 T 2006-07-25-15.03.31.040344
    EMP_PHOTO DB2INST1 T 2006-07-25-15.03.31.486755
    EMP_RESUME DB2INST1 T 2006-07-25-15.03.33.518314
    EMPLOYEE DB2INST1 T 2006-07-25-15.03.30.697642
    IN_TRAY DB2INST1 T 2006-07-25-15.03.34.260669
    ORG DB2INST1 T 2006-07-25-15.03.29.382159
    PROJECT DB2INST1 T 2006-07-25-15.03.31.272680
    SALES DB2INST1 T 2006-07-25-15.03.34.068861
    STAFF DB2INST1 T 2006-07-25-15.03.30.315647

    11 record(s) selected.


    9) Migrate DB ispb created under DB2 V7 - Result failed..
    $ db2 migrate database ispb user db2inst1 using wps123
    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,
    ---------------------
    2006-07-25-16.13.11.997281+480 E1750653C707 LEVEL: Severe
    PID : 35560 TID : 1 PROC : db2agent (ISPB) 0
    INSTANCE: db2inst1 NODE : 000 DB : ISPB
    APPHDL : 0-11 APPID: *LOCAL.db2inst1.060725081240
    FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
    DATA #1 : Signal Number Recieved, 4 bytes
    11
    DATA #2 : Siginfo, 64 bytes
    0x2FF0DE10 : 0000 000B 0000 0000 0000 0033 0000 0000 ...........3....
    0x2FF0DE20 : 0000 0000 0000 0BD3 0000 0000 0000 0000 ................
    0x2FF0DE30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF0DE40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

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

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

    also in db2diag.log

    2006-07-25-16.14.03.959213+480 I1802058C433 LEVEL: Severe
    PID : 30416 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 35560
    The signal number that terminated this process was 11
    Look for trap files (t35560.*) in the dump directory


    -----t35560.000----------------------------------------------------------
    db2 build information: DB2 v8.1.0.72 s040914 SQL08020
    timestamp: 2006-07-25-16.13.11.847115
    instance name: db2inst1.000
    EDU name : db2agent (ISPB) 0
    Signal #11
    uname: S:AIX R:2 V:5 M:0006964A4C00 Nvc30
    thread id : 1 (0x1)

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

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

    Resource Limits

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

    ..... omitted .....


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

    0xD65C72CC : 4200FFE8 bdn 0xD65C72B4 # 16,bit0
    0xD65C72D0 : 80E40000 lwz r7,0(r4)
    0xD65C72D4 : 30A5FFFC addic r5,r5,-4
    0xD65C72D8 : 7CE95038 and r9,r7,r10
    0xD65C72DC : 7D295014 addc r9,r9,r10
    0xD65C72E0 : 7D2C50F9 nor. r12,r9,r10
    0xD65C72E4 : 40820034 bne cr0,0xD65C7318 # 4,bit2
    0xD65C72E8 : 85040004 lwzu r8,4(r4)
    >>>> 0xD65C72EC : 94E50004 stwu r7,4(r5)
    0xD65C72F0 : 7D095038 and r9,r8,r10
    0xD65C72F4 : 7D295014 addc r9,r9,r10
    0xD65C72F8 : 7D2C50F9 nor. r12,r9,r10
    0xD65C72FC : 4082002C bne cr0,0xD65C7328 # 4,bit2
    0xD65C7300 : 84E40004 lwzu r7,4(r4)

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

    *** Start stack traceback ***

    0xD65C72EC strcpy + 0x8C
    0xD7832440 sqlrlm_migrate_6to8_sysfuncparms__FP20sqle_agent_p rivatecb8sqlr_tidP8sqlr_tidUsPc + 0x16D4
    0xD781DA8C sqlrlm_catalogFixup__FP8sqlrr_cbUslT3P17sqlrlm_cat ChangesPc8sqlr_tidP8sqlr_tid + 0x108
    0xD7857950 sqlrlm_catalog_migrate__FP20sqle_agent_privatecbs + 0x141C
    0xD78563E4 sqlrlmig__FsP5sqlca + 0x5C
    0xD781B584 sqlefmig__FPcP7sqlebwaP5sqlca + 0x598
    0xD7818FE4 sqlemigr__FP7sqlebwaP7UCintfc + 0x94C
    0xD61B2A50 sqlelost__FP7UCintfc + 0xD6C
    0xD644F8C0 sqleUCengnInit__FP7UCintfcUs + 0x1F4
    0xD644F3DC sqleUCagentConnect + 0x23C
    0xD6A40C70 sqljsConnectAttach__FP13sqljsDrdaAsCbP7UCintfc + 0xB0
    0xD6A3B310 sqljs_ddm_accsec__FP7UCintfcP14sqljsDDMObject + 0x2E8
    0xD66611B4 sqljsParseConnect__FP13sqljsDrdaAsCbP14sqljsDDMObj ectP7UCintfc + 0x74
    0xD6661584 sqljsParse__FP13sqljsDrdaAsCbP7UCintfc + 0x250
    0xD66467C0 sqljsSqlam__FP7UCintfcP13sqle_agent_cbb + 0x11C
    0xD6646D5C sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandl e + 0x88
    0xD6646C00 sqljsDrdaAsInnerDriver__FP17sqlcc_init_structb + 0xB0
    0xD66469D4 sqljsDrdaAsDriver__FP17sqlcc_init_struct + 0x84
    0xD6513D38 sqleRunAgent__FPcUl + 0x288
    0xD62E5B88 sqloCreateEDU__FPFPcUl_vPcUlP13SQLO_EDU_INFOPl + 0x198
    0xD62E5654 sqloSpawnEDU + 0x210
    0xD6512734 sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_stru ctP16sqlkdRqstRplyFmtP18sqle_master_app_cbT1P20age ntPoolLatchVectorP16SQLO_EDUWAITPOSTP17sqle_connec t_infoPP13sqle_agent_cb + 0x2C4
    0xD6512074 sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12s qlz_app_hdlP16sqlkdRqstRplyFmtP17sqle_connect_info + 0x318
    0xD6511C8C sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_ hdlPv + 0x1C0
    0xD62D1764 sqlccipcconnmgr_child__FPcUl + 0x80C
    0xD62E5B88 sqloCreateEDU__FPFPcUl_vPcUlP13SQLO_EDU_INFOPl + 0x198
    0xD62E5654 sqloSpawnEDU + 0x210
    0xD62D0DE0 sqlccipcconnmgr__FP15SQLCC_CONNMGR_TP9sqlf_kcfd + 0x138
    0x10003C7C sqleInitSysCtlr__FPi + 0x7D8
    0x10002CF8 sqleSysCtlr__Fv + 0x40
    0xD62E9B78 sqloRunInstance + 0x75C
    0x100028EC DB2main + 0x8A4
    0x10003470 main + 0xC

    *** End stack traceback ***

    ... omitted....

    -----end of t35560.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

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    migrate

    what I would recommend
    db2stop
    in root
    ../instance/db2iupdt xxxx with xxxx the instance name
    in instance owner
    db2 migrate...
    db2updv8 -d ddddd
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jul 2006
    Posts
    2

    Red face DB2 migration

    Thanks for the suggestion, Guy. But I am still getting the same error when migrating the DB.

    Regards,

    Tony

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •