473,386 Members | 1,830 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

[IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004

Am got this error message after i tried to update my DB2 Database... Your Help will be greatly appreciated... More explanation to the problem is given as follows...

Explanation:

A system error occurred. Some possible reasons for this error are:

* The database manager is not installed correctly or the environment is
not set up correctly.
* On UNIX-based systems, db2iupdt may need to be run in order to update
the DB2 instance to enable acquisition of a new system configuration
or access to function associated with the installation or removal of
certain product options, FixPaks, or modification levels.
* You might get this message if you are not using the correct DB2
Administration Server password.

The command cannot be processed.

User response:

* To update the instance to acquire a configuration or access to
function run DB2IUPDT <InstName>.
* If the error occurred while trying to connect to a database, get a
trace (instructions below) and call IBM support.

If the problem falls outside of the above suggestions, ensure that the
system time and date is correctly set, and make sure your system has
enough memory and swapping/paging space available.

Resubmit the current command.

If the error continues, stop the database manager and restart it.

If the error still continues, reinstall the database manager.

If trace was active, invoke the Independent Trace Facility at the
operating system command prompt. Contact your technical service
representative with the following information:

Required information:

* Problem description
* SQLCODE or message number
* SQLCA contents if possible
* Trace file if possible.

Federated system users: if necessary isolate the problem to the data
source rejecting the request (see the Troubleshooting Guide for
procedures to follow to identify the failing data source). If the
problem is with a data source follow the problem determination
procedures for that data source.

sqlcode: -1042

sqlstate: 58004
Jan 15 '13 #1
1 10456
Rabbit
12,516 Expert Mod 8TB
It would help to know the command you're trying to run.
Jan 15 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Herbert | last post by:
Hallo colleques, I get during the following error message "SQL1035N No database manager command was issued. SQLSTATE=57019", when issuing the following command on the Command Line Processor:...
4
by: acemann7 | last post by:
Windows 2000 udb v 7.2 Got the latest fixpak 13 Applied it. Still can't get a single java sp to run. I used to get reason "2"... now reason "0" - reason 0 is not even documented. I point...
3
by: alan_sec | last post by:
Hi everybody, i need some help please. I have installed DB2 UDB 7.2 on Windows and created database and it worked fine (i could access it from control centar nad using eclipse plug-in...
3
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...
0
by: cuddles | last post by:
Hi all, iv getting this error message and im not sure what to do, any help would be appreciated. What i do know is that if i remove a single line of code, the procedure is successfully built.. ...
1
by: lucybridges | last post by:
Can anyone shed some light on what is causing this, please? Using Perl 5.8.5 (64 bit) on RH enterprise Linux AS release 4 (2.6.9-22.ELsmp) I'm receiving the following error: DBI...
3
by: roxrox_1959 | last post by:
I'm attempting to connect to a DB2 database using DBD::DB2 running on a Linux device. I'm getting the following error: ** connect: Unable to get database handle: DBI...
8
by: hveillette | last post by:
Hi everybody, I have a very strange problem with one DB (only one in a list of 21). This DB is used by a Java application and work fine since a couple of years. This week the application stop...
1
by: Chris | last post by:
Hi, I am trying to run the following SQL through the DB2 command line for version 9.1.0: alter table SCHEMA.TABLE1 drop column A; alter table SCHEMA.TABLE2 alter column B set data type...
0
by: HARVEER | last post by:
Hi, My procedure compiles perfectly, but sometimes when I execute it. I receive following error: DB2 Database Error: ERROR SQL0901N The SQL statement failed because of a non-severe system...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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
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...

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.