Unanswered: Backups failing - SQL0902C A system error (reason code = "242") occurred.
Windows Server 2000
3 GB RAM
I am having a problem with the offline backups that are running. In the output I receive a SQL0902C A system error (reason code = "242") occurred.
When looking at the db2diag.log I notice the recurring message saying "no resources to create process or thread"... The specs on this server are absolutely dismal - so its pretty tough trying to work with what I've got
I noticed the DBHEAP parameter is set to 4096, the UTIL_HEAP_SZ has been set to 500,000..... Would increasing the DBHEAP parameter help my situation?
Just wanted to say that we resolved this issue by getting the storage guys to add 500 GB disk space to the server, and backed up to disk instead of using their 3rd party software to backup to tape. I'm thinking that their software was creating too many agents on the server or something?
What a relief... except accidentally left the db in quiesce mode this morning - woops...
If this error comes back, check the FILE SYSTEM CACHING option for your tablespaces ( you can use "db2pd -d <db name> -tab" ) and try disabling it as per the technote provided by sathyaram_s (exclude tablespaces with LOB/LF).
When I was checking the server today, I noticed there are like 50 processes called db2bp.exe running in Task Manager. If check in db2 with list applications there's only about 4 with application db2bp?
As I understand it, these processes would be created during the connection to the DB from the command line, but obviously they are not disconnecting from the DB correctly with the Terminate command?
What I would like to know is, would it be safe if I end these db2bp.exe processes in task manager?
They are taking up a lot of memory in my constrained environment, and the numbers of these processes seem to increase day by day.
if they are in uow waiting and last operation is commit - save to force
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
Just wanted to let you know that the problem returned (like db2girl said it would) and was getting progressively worse... I then updated the DB2NTNOCACHE parameter to yes, and since then it has worked ever since.