SQL1042C may be received on all db2 commands run on Windows operating system
Priyanka Joshi 270003HTNX Visits (7554)
"SQL1042C An unexpected system error occurred. SQLSTATE=58004" error in db2 or
"DB21018E A system error occurred. The command line processor could not continue processing." error in application.
First place to check for more information on the error we get is db2diag.log. In db2diag.log, we see an error as follows :
This is a Windows API error code, not DB2 error code, and it was returned by a Windows API function ReadFile(). The meaning of the error is ERRO
Error 1450 is specifically related to Paged Pool memory. Paged Pool is one of Windows NT's internal heaps and it depends on the amount of physical memory available on the box.
Microsoft also confirms that this is a limitation of Windows 32-bit operating system design. Please search for error "OSERR : 1450" in Microsoft Knowledge Base Articles and correct it the problem accordingly.
As an immediate relief, if the circumstances permit, users can try to reboot the system to free up memory that hasn't been released. But if that doesn't work, please refer the Microsoft articles above and follow Microsoft .
Retry db2 commands once you fix the OS errors.