473,508 Members | 4,712 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL1042C An unexpected system error occurred.

Need urgent help...

I have installed DB2UDB version 7.2 on Windows 2000.

When I try to open Command center or Command window it gives me the following error:
------------------------------------------------------
DB2CMD.EXE -> 0
SQL1042C An unexpected system error occurred.
------------------------------------------------------

I tried re-installing DB2 many times but didn't work.

I am able to work with Control center and Client config assistant.

I also did create SAMPLE database using first steps.

Can any one help me please ?
Nov 12 '05 #1
2 19051
I am having (exactly) the same problem. Did you solved yours? How?

Nov 12 '05 #2
I did solve this problem:

Checked both SYSTEM variables and USER variables in WINDOWS2000 and
found that USER variables were not pointing to the right DB2 paths. I
corrected them and the problem was solved.

This could have happened when I installed DB2 on different directory
and then again re-installed on default directory. DB2 did not reset
the USER envirnment variables.
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4370
by: Michelle | last post by:
Hi, I'm trying to rollforward my database to end of logs and complete, the first error message i get is - SQL6063N rollforward recovery on database X has stopped on node "0" due to change in log...
1
7710
by: timVerizon | last post by:
Hoping someone can help here.. Our application (C#.Net) was receiving IBM.Data.DB2.DB2Exceptions ERROR SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: '', type...
2
3067
by: mike_li | last post by:
CLI connection failed. SQL0902C. A system error (reasoncode="6029321") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005. Has anyone encountered the above error? We are...
5
3120
by: Photubias | last post by:
I get the above error when issueing the 'db2start' command. Found no info in the net that could help me. I have the V8.1 FP10 installed on SLES 9 x86_64 Any tips? Tx in advance
3
3289
by: tol7481 | last post by:
Hi, I'm trying to deploy a Java stored procedure on DB2 V8 on a Linux box, but I have some problems. I've added to the classpath the following JARs sqllib/java/db2java.zip...
6
4692
by: MY | last post by:
Hi all I'm getting this error when trying to start and/or stop the admin server on a db2 v9 on AIX 5.3 Everything worked fine with v8.2. I did the upgrade by the book. any tips would be...
1
4524
by: Sam Durai | last post by:
Env: DB2 v9.1 Server / Win XP. DB is enabled for Archival Logging. Was playing around with rebuild tablespace feature. My database 'CARD' has tablespace named t1,t2,t3. Taken couple of...
1
21358
by: bytesmalli | last post by:
Hi All, When i'm running the db2start i'm getting following error message. But when i ran it for second time m able to start successfully. Can you please tell me what could be the issue for the...
7
14115
by: Ramk | last post by:
Hi all I am using C#/.Net2.0 I am connecting to a remote shared folder from my C# code using WNetAddConnection2A without mapping to the local drive. A code snippet is: NetResource netRes =...
0
7128
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7393
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
5635
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5057
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4715
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3206
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1565
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
769
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
426
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.