Db2cmd error

[Azahary]

Hi,

I'm using DB2v8.1.7 on window XP. I got

DB2CMD.EXE -> 5
SQL1042C An unexpected system error occurred.

when try to execute DB2 command on CLP.

Is there any solution for this problem ? Thank you very much in advance.

Regards
Azahary

[vijay2082]

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_sys tem_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.aspx?scid=kb;en-us;812486

[Azahary]

Hi Vijay2082,

Thank you for the reply. I'm not sure whether this error is related or not. For information, I go to the DB2 directory, i.e .......IBM\SQLL IB\BIN and then double click the db2cmd.exe and nothing happen. If I issue db2cmd using window prompt I got error mentioned above.

Also I did tried to activate CLP using DB2 panel i.e START -> ALL PROGRAMS -> IBM DB2 -> COMMAND LINE TOOLS -> COMMAND LINE PROCESSOR...... ...... but noting appear at my PC. meaning that the CLP command prompt panel doesn't appear in order for me to keyin the db2 command.

Any idea or workaround regarding this problem ?

Thank you and regards
Azahary