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

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

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

I am confused. What is the OS and bitness of the source and what is the OS and bitness of the target?

Andy

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

Again, I ask, what is the OS and bitness of the source server (where the backup was made)?

Andy

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 ?

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

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.

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

Correction: db2set DB2NTNOCACHE=ON instead of db2set DB2NTNOCACHE=NO

Default is OFF

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

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

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

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.