Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    2

    Unanswered: DIA8501C A buffer pool logic error has occurred.

    Hi,

    I have the following problem when restoring a db into another user on the same server:

    Step 1:
    as User db2inst1
    Code:
    db2 backup db dbalt to /backup/db2inst1
    Step 2:
    als User db2inst3

    Code:
    db2 restore db dbalt from /backup/db2inst1 taken at 20080924154957 dbpath on /data/db2inst3 into dbneu newlogpath /log/db2inst3 redirect without rolling forward
    Output:
    Code:
    SQL0902C  A system error (reason code = "") occurred.  Subsequent SQL
    statements cannot be processed.  SQLSTATE=58005

    db2diag.log:
    Code:
    2008-09-24-16.00.40.831132+120 E232905A446        LEVEL: Severe
    PID     : 651328               TID  : 4169        PROC : db2sysc 0
    INSTANCE: db2inst3             NODE : 000
    EDUID   : 4169                 EDUNAME: db2bm.2113.0 (PVA_ASO) 0
    FUNCTION: DB2 UDB, database utilities, sqludProcessSGRestore, probe:4111
    MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
              DIA8501C A buffer pool logic error has occurred.
    
    2008-09-24-16.00.40.831394+120 E233352A447        LEVEL: Severe
    PID     : 651328               TID  : 4169        PROC : db2sysc 0
    INSTANCE: db2inst3             NODE : 000
    EDUID   : 4169                 EDUNAME: db2bm.2113.0 (PVA_ASO) 0
    FUNCTION: DB2 UDB, database utilities, sqludbuf, probe:713
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -2044
    DATA #2 : Hexdump, 8 bytes
    0x00000001106E0298 : FFFF F804 0000 0002                        ........
    
    2008-09-24-16.00.40.841644+120 E233800A432        LEVEL: Severe
    PID     : 651328               TID  : 2113        PROC : db2sysc 0
    INSTANCE: db2inst3             NODE : 000         DB   : PVA_ASO
    APPHDL  : 0-15                 APPID: *LOCAL.db2inst3.080924140039
    AUTHID  : DB2INST3
    EDUID   : 2113                 EDUNAME: db2agent (PVA_ASO) 0
    FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:781
    MESSAGE : Restore Terminated.

    For your information:
    db2level
    Code:
    DB21085I  Instance "db2inst3" uses "64" bits and DB2 code release "SQL09050"
    with level identifier "03010107".
    Informational tokens are "DB2 v9.5.0.0", "s071001", "AIX6495", and Fix Pack
    "0".
    Product is installed at "/db2/product/9.5".


    How can I solve the problem?


    Thanks for your help!
    Last edited by tobiwwwan; 09-24-08 at 11:19.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    For ZRC errors, you need to call IBM support. But they will probably ask you to put on FP2 as a first step. You have the intial release of a DB2 version (9.5) with a brand new memory management system.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2008
    Posts
    2

    Solved

    It was a problem with the rights in the filesystem. everything works now. thx

  4. #4
    Join Date
    Jan 2010
    Posts
    207
    What exactly did you do? We are having the same problem but there seems nothing wrong with the rights of the filesystem...

Posting Permissions

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