Results 1 to 15 of 15
  1. #1
    Join Date
    Sep 2009
    Posts
    18

    Unanswered: Not Enough kernel memory to open a file while restoring in DB2

    Hi,
    I have a database which is around 28 GB. I took a compressed backup of the database which is around 400MB. When i tried to restore the database , i got the following error mesage in db2diag.log even though the restore was successful. However no tables or view got restored.

    2009-12-16-12.53.21.974000+330 I152158H593 LEVEL: Severe
    PID : 3708 TID : 1912 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 1912 EDUNAME: db2bm.4184.0 (TAFJ1R)
    FUNCTION: DB2 UDB, buffer pool services, sqlbRestoreASContainers, probe:40
    MESSAGE : ZRC=0x8502008B=-2063466357=SQLB_RC_INSSYS_KERNEL
    "Not enough kernel memory to open a file"
    DATA #1 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
    2
    DATA #2 : Pool flags, PD_TYPE_SQLB_POOL_FLAGS, 4 bytes
    12578
    DATA #3 : unsigned integer, 4 bytes
    1071672

    2009-12-16-12.53.21.974000+330 E152753H442 LEVEL: Error
    PID : 3708 TID : 1912 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 1912 EDUNAME: db2bm.4184.0 (TAFJ1R)
    FUNCTION: DB2 UDB, database utilities, sqludProcessSPCS, probe:3628
    DATA #1 : <preformatted>
    Problem restoring table space TESTBASE (2).
    Function return code: 0, container return code = -2063466357.


    Can anyone please let me know if this is a OS related problem. I have 1 GB mahcine in my system

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the DB2 version and OS of the source and target servers? What is the error you are getting back from the restore command?

    Andy

  3. #3
    Join Date
    Sep 2009
    Posts
    18

    Not Enough kernel memory to open a file while restoring in DB2

    The DB2 Version is DB29.7 Fix Pack 0. I am using the same DB2 version in server where everything is working fine. The server is linux(32 bit) which has 2GB RAM . I have this problem on Windows machine(32 bit). I didnt get any error from the restore command. But when i find the size of the database its only 500MB where the original database size is 28GB

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I am confused. What is the OS and bitness of the source and what is the OS and bitness of the target?

    Andy

  5. #5
    Join Date
    Sep 2009
    Posts
    18

    Not Enough kernel memory to open a file while restoring in DB2

    Machine where restore is working fine - Linux Machine 32 bit
    Mahcine where restore is not working - Windows Machine,32 Bit

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Again, I ask, what is the OS and bitness of the source server (where the backup was made)?

    Andy

  7. #7
    Join Date
    Sep 2009
    Posts
    18

    Not Enough kernel memory to open a file while restoring in DB2

    Hi sorry if i had confused you . Let me be clear. I have the database of 28GB in my windows machine. I took a compressed backup image of this database and its size was 400 MB in my windows machine itself. I ran a COB on the database and so i needed to restore it to the initial stage. So when i tried to restore the database in my windows machine, i ended up with this problem.


    I had the same database in linux server where i could restore the database to the backup in created on this linux server machine.

    Is the error "not enough kernal memory" has anything to do with the OS ?

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the exact backup command you used on the windows machine?

    What is the exact restore command you got on the windows machine?

    What was the output from the restore command?

    What does running db2ckbkp on the backup image for window say?

    How much memory is on the windows machine?

    What else is running on the windows machine?


    Andy

  9. #9
    Join Date
    Sep 2009
    Posts
    18

    Not Enough kernel memory to open a file while restoring in DB2

    actually i am out of office now. All the commands and the result are in my pc in my office so will let you know once i go to office 2morrow. anyways thanks for your analysis.

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by naveen_swiz View Post
    When i tried to restore the database , i got the following error mesage in db2diag.log even though the restore was successful. However no tables or view got restored.

    If the restore command completed successfully but no data was actually restored, then I think you need to report this problem to IBM.


    What you can try is:

    db2set DB2NTNOCACHE=NO
    db2stop
    db2start
    restore db

  11. #11
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Correction: db2set DB2NTNOCACHE=ON instead of db2set DB2NTNOCACHE=NO

    Default is OFF

  12. #12
    Join Date
    Sep 2009
    Posts
    18

    Not Enough kernel memory to open a file while restoring in DB2

    Ya i even tried setting DB2NTNOCACHE=ON but no luck .

  13. #13
    Join Date
    Sep 2009
    Posts
    18

    Not Enough kernel memory to open a file while restoring in DB2

    Backup Command :
    BACKUP DATABASE R09TAFJ TO "D:\DB_Backup" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING

    Restore Command :
    RESTORE DATABASE R09TAFJ FROM "D:\DB_Backup" TAKEN AT 20091216093700 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING @


    Output Of restore command
    The restore completed successfully but no tables or tablespaces got retored.

    How much memory is on the windows machine?
    I have around 20 GB free space in my system

    What else is running on the windows machine?
    Few java programs and eclipse running

  14. #14
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Run db2ckbkp on the backup image and let us know if the image is OK.

    You have an offline backup, so you should use "WITHOUT ROLLING FORWARD" on the restore command. You might also want to try the COMPRLIB clause on the restore.

    You have a 32 windows machine, so I doubt that you have 20GB of RAM. How much RAM do you have?

    Stop all extraneous applications on the machine to give DB2 as much memory as possible.

    Andy

  15. #15
    Join Date
    Sep 2009
    Posts
    18

    Not Enough kernel memory to open a file while restoring in DB2

    I checked the backup image by running the command db2ckbkp and its fine. I have 1 GB RAM and 20 GB free disk space in my system. Let me try by stopping all other applications and running the restore command.

Posting Permissions

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