Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Unanswered: DB2 Restore BackUp

    Sorry but my english is not very good....
    I development one software and i use DB2 how my data base. Then, my customer send me your backpup to repair one problem in software, but i can't restore, maybe because my version is difterent.
    I use the follow command in directory of data base backup, with follow struture:
    File that I received: BKPSOFT.zip
    I extract file them i have follow struture:
    BKSOFT\SOFT.0\DB2\NODE0000\CATN0000\20030822\19194 0.001
    Then in BKSOFT directory, in prompt i write follow command:
    db2 restore db soft, but i received one error:
    SQL0956C Not enough storage is available in the database heap to process the statement. SQLSTATE=57011.
    Anyone can help me ?
    I need restore this backup....
    tanks....

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 Restore BackUp

    Increase the db heap size ...

    db2 update db cfg for <dbname> using dbheap <value>

    You may have to disconnect all apps and reconnect

    Cheers
    Sathyaram

    Originally posted by rafael.heise
    Sorry but my english is not very good....
    I development one software and i use DB2 how my data base. Then, my customer send me your backpup to repair one problem in software, but i can't restore, maybe because my version is difterent.
    I use the follow command in directory of data base backup, with follow struture:
    File that I received: BKPSOFT.zip
    I extract file them i have follow struture:
    BKSOFT\SOFT.0\DB2\NODE0000\CATN0000\20030822\19194 0.001
    Then in BKSOFT directory, in prompt i write follow command:
    db2 restore db soft, but i received one error:
    SQL0956C Not enough storage is available in the database heap to process the statement. SQLSTATE=57011.
    Anyone can help me ?
    I need restore this backup....
    tanks....
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Dec 2002
    Posts
    3

    Tanks

    Tanks....
    Yesterday search more and find in Control Center one option that i could change dbheap, with value 604... then i change to 1500 then i could restore backup....
    tanks for command...
    tanks for help...

Posting Permissions

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