Question
Starting the DB2 UDB Command Line Processer (CLP) results in a SQL1042C message and the db2diag.log has a message indicating the CLP is not a valid Windows 32-bit application.
Cause
Starting the DB2 UDB Command Line Processor (CLP) returns a SQL1042C message and the db2diag.log shows error messages from Windows:
2005-03-09-18.00.34.382000-300 E302497H340 LEVEL: Error (OS)
PID : 2572 TID : 2772 PROC : db2.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:46
CALLED : OS, -, unspecified_system_function
OSERR : 193 "%1 is not a valid Win32 application."
There is a directory named \Program on the disk that prevents Windows from resolving search paths for the DB2 UDB CLP.
Answer
Remove or rename the directory \Program to resolve the issue. DB2 services may also hit this problem during startup. You can find more details and a resolution to this issue in the Microsoft Knowledge Base article at the following URL:
http://support.microsoft.com/default...b;en-us;812486