Results 1 to 2 of 2

Thread: Restore problem

  1. #1
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    5

    Unanswered: Restore problem

    Hi,

    happy new year. :-)

    Due to upgrade reasons I tried to restore our prod db to our test environment.
    The backup ist about 700 GB large and is backup via TSM.

    I created a db on our test server similar to the prod db. The restore works fine till 390 GB then I get errors and the restore is stopped.

    The Version is DB 7.2 with Fix 7 or Fix 9 on a 4.3.2 AIX.

    Below you see the diag log from the part where the errors begin.
    ---------------------
    2004-12-29-12.25.40.633288 Instance:sws1213 Node:000
    PID:16066(db2pfchr) Appid:none
    oper_system_services sqlowrite Probe:110

    errno: 0000 000c ....


    2004-12-29-12.25.40.764022 Instance:sws1213 Node:000
    PID:16066(db2pfchr) Appid:none
    buffer_pool_services sqlbSMSDirectWrite Probe:825
    DIA3833C The system memory limit was reached.

    ZRC=0xFFFFF624

    2004-12-29-12.25.40.937160 Instance:sws1213 Node:000
    PID:16066(db2pfchr) Appid:none
    buffer_pool_services sqlbSMSDirectWrite Probe:825

    Obj={pool:1278;obj:2;type:1} State=x0 Page=49376 Cont=15 Offset=1088 BlkSize=12

    Data TitleQLB_OBJECT_DESC PID:16066 Node:000
    04fe 0002 0000 0000 0100 0000 0000 0000 ...............
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0001 0000 0000 0000 0000 ................
    0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
    0000 0000 0000 0000 ........


    2004-12-29-12.25.41.164488 Instance:sws1213 Node:000
    PID:40754(db2pfchr) Appid:none
    oper_system_services sqlowrite Probe:110

    errno: 0000 000c ....


    2004-12-29-12.25.41.271992 Instance:sws1213 Node:000
    PID:40754(db2pfchr) Appid:none
    buffer_pool_services sqlbSMSDirectWrite Probe:825
    DIA3833C The system memory limit was reached.

    ZRC=0xFFFFF624

    2004-12-29-12.25.41.343625 Instance:sws1213 Node:000
    PID:40754(db2pfchr) Appid:none
    buffer_pool_services sqlbSMSDirectWrite Probe:825

    Obj={pool:1278;obj:2;type:1} State=x0 Page=49440 Cont=17 Offset=1088 BlkSize=12

    Data TitleQLB_OBJECT_DESC PID:40754 Node:000
    04fe 0002 0000 0000 0100 0000 0000 0000 ...............
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0001 0000 0000 0000 0000 ................
    0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
    0000 0000 0000 0000 ........


    2004-12-29-12.25.41.564657 Instance:sws1213 Node:000
    PID:40754(db2pfchr) Appid:none
    buffer_pool_services sqlbDirectWrite Probe:830
    DIA3833C The system memory limit was reached.

    ZRC=0xFFFFF624

    2004-12-29-12.25.41.654425 Instance:sws1213 Node:000
    PID:40754(db2pfchr) Appid:none
    buffer_pool_services sqlbDirectWrite Probe:830

    Obj={pool:1278;obj:2;type:1} State=x0

    2004-12-29-12.25.41.726108 Instance:sws1213 Node:000
    PID:16066(db2pfchr) Appid:none
    buffer_pool_services sqlbDirectWrite Probe:830
    DIA3833C The system memory limit was reached.

    ZRC=0xFFFFF624

    Data TitleQLB_OBJECT_DESC PID:40754 Node:000
    04fe 0002 0000 0000 0100 0000 0000 0000 ...............
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0001 0000 0000 0000 0000 ................
    0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
    0000 0000 0000 0000 ........


    2004-12-29-12.25.41.935214 Instance:sws1213 Node:000
    PID:40754(db2pfchr) Appid:none
    buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

    Prefetcher Error rc = -2524 IGNORED ... err loc 0
    . Request follows...

    2004-12-29-12.25.42.006968 Instance:sws1213 Node:000
    PID:40754(db2pfchr) Appid:none
    buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

    type = DIRECTWRITE
    numpages = 1
    SQLB_OBJECT_DESC: objID: 2 PlId: 1278 objTyp: 1 Ext Anch: 0 plFlgs: 1
    pario_cb: 402c6e20 access method: 1 address scheme: 0
    read/write flag: 1 flush option: 0 sms file open mode: 0
    IO descriptor list:
    0 start unit: 49440 number unit: 32 buffer: 409d6200
    global flag 16


    2004-12-29-12.25.42.303990 Instance:sws1213 Node:000
    PID:25556(db2pfchr) Appid:none
    oper_system_services sqlowrite Probe:110

    errno: 0000 000c ....


    2004-12-29-12.25.42.395273 Instance:sws1213 Node:000
    PID:16066(db2pfchr) Appid:none
    buffer_pool_services sqlbDirectWrite Probe:830

    Obj={pool:1278;obj:2;type:1} State=x0

    2004-12-29-12.25.42.466982 Instance:sws1213 Node:000
    PID:25556(db2pfchr) Appid:none
    buffer_pool_services sqlbSMSDirectWrite Probe:825
    DIA3833C The system memory limit was reached.

    ZRC=0xFFFFF624

    2004-12-29-12.25.42.538819 Instance:sws1213 Node:000
    PID:25556(db2pfchr) Appid:none
    buffer_pool_services sqlbSMSDirectWrite Probe:825

    Obj={pool:1278;obj:2;type:1} State=x0 Page=49312 Cont=13 Offset=1088 BlkSize=12

    Data TitleQLB_OBJECT_DESC PID:25556 Node:000
    04fe 0002 0000 0000 0100 0000 0000 0000 ...............
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0001 0000 0000 0000 0000 ................
    0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
    0000 0000 0000 0000 ........


    2004-12-29-12.25.42.753972 Instance:sws1213 Node:000
    PID:25556(db2pfchr) Appid:none
    buffer_pool_services sqlbDirectWrite Probe:830
    DIA3833C The system memory limit was reached.

    ZRC=0xFFFFF624

    2004-12-29-12.25.42.825682 Instance:sws1213 Node:000
    PID:25556(db2pfchr) Appid:none
    buffer_pool_services sqlbDirectWrite Probe:830

    Obj={pool:1278;obj:2;type:1} State=x0

    Data TitleQLB_OBJECT_DESC PID:25556 Node:000
    04fe 0002 0000 0000 0100 0000 0000 0000 ...............
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0001 0000 0000 0000 0000 ................
    0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
    0000 0000 0000 0000 ........


    Data TitleQLB_OBJECT_DESC PID:16066 Node:000
    04fe 0002 0000 0000 0100 0000 0000 0000 ...............
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0001 0000 0000 0000 0000 ................
    0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
    0000 0000 0000 0000 ........


    2004-12-29-12.25.43.160582 Instance:sws1213 Node:000
    PID:50430(db2bm.25132.0) Appid:none
    database_utilities sqluwritereg Probe:30

    DiagData
    ffff f817 ffff f624 524f 4f54 5f42 5842 .$ROOT_BXB
    3100 1.


    2004-12-29-12.25.43.268008 Instance:sws1213 Node:000
    PID:50430(db2bm.25132.0) Appid:none
    database_utilities sqluwritereg Probe:1230

    ffff f817 ffff f624 524f 4f54 5f42 5842 .$ROOT_BXB
    3100 1.


    2004-12-29-12.25.43.588780 Instance:sws1213 Node:000
    PID:25556(db2pfchr) Appid:none
    buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

    Prefetcher Error rc = -2524 IGNORED ... err loc 0
    . Request follows...

    2004-12-29-12.25.43.668523 Instance:sws1213 Node:000
    PID:25556(db2pfchr) Appid:none
    buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

    type = DIRECTWRITE
    numpages = 1
    SQLB_OBJECT_DESC: objID: 2 PlId: 1278 objTyp: 1 Ext Anch: 0 plFlgs: 1
    pario_cb: 402c6e20 access method: 1 address scheme: 0
    read/write flag: 1 flush option: 0 sms file open mode: 0
    IO descriptor list:
    0 start unit: 49312 number unit: 32 buffer: 40956200
    global flag 16


    2004-12-29-13.15.28.510615 Instance:sws1213 Node:000
    PID:25132(db2agent (ARS01)) Appid:*LOCAL.sws1213.041229080121
    oper_system_services sqlowrite Probe:110 Database:ARS01

    errno: 0000 000c ....


    2004-12-29-13.15.28.609849 Instance:sws1213 Node:000
    PID:25132(db2agent (ARS01)) Appid:*LOCAL.sws1213.041229080121
    database_utilities sqludrsa Probe:58 Database:ARS01

    DiagData


    2004-12-29-13.15.28.681535 Instance:sws1213 Node:000
    PID:25132(db2agent (ARS01)) Appid:*LOCAL.sws1213.041229080121
    database_utilities sqludrsa Probe:0 Database:ARS01

    Restore terminated.
    ---------------------

    The environment of the user with whom I restore is unlimited.
    Our OS admin and TSM admin haven't found any clue on system side.

    I would be glad for any help. Thanks in advance.


    Regards,

    Oktay

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    F624 error saying bad configuration file; does your test db config same as or very close to the prod db config? try to make them the same if possible(when it comes to buffersizes etc
    mota

Posting Permissions

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