CLM 4.0.3 server shutdown unexpectedly and after restarting the server the (JTS database) is not able to connect and shows error "[IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004"
O/S : Windows 2008 R2
CLM : 4.0.3
WAS: WAS Network Deployment 8.0
DB2 : 9.7 Enterprise ============================================================
About DB2 Administration Tools Environment
============================================================
DB2 administration tools level:
Product identifier SQL09073
Level identifier 08040107
Level DB2 v9.7.301.326
Build level s101006
PTF IP23214
============================================================
Java development kit (JDK):
Level IBM Corporation 1.6.0
============================================================
My CLM server was shutdown due to electricity and UPS failure. Both application and DB are on the same server.
After restarting the server, it is showing following error.
When I checked the DB, JTS database is not able to connect but other database like CCM, QM and DW databases are connecting properly. When I am trying to connect the JTS DB it shows following error.
[IBM][CLI Driver] SQL1042C An unexpected system error occurred.
SQLSTATE=58004
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
[IBM][CLI Driver] SQL1042C An unexpected system error occurred.
SQLSTATE=58004
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
[IBM][CLI Driver] SQL1042C An unexpected system error occurred.
SQLSTATE=58004
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
----------------------------------------------------------------------------------------------------------------------------------
I have restored the JTS DB through Log files but no luck.
Does anyone know, What could be the issue?
Thanks,
Tariq Ashraf
CLM : 4.0.3
WAS: WAS Network Deployment 8.0
DB2 : 9.7 Enterprise ============================================================
About DB2 Administration Tools Environment
============================================================
DB2 administration tools level:
Product identifier SQL09073
Level identifier 08040107
Level DB2 v9.7.301.326
Build level s101006
PTF IP23214
============================================================
Java development kit (JDK):
Level IBM Corporation 1.6.0
============================================================
My CLM server was shutdown due to electricity and UPS failure. Both application and DB are on the same server.
After restarting the server, it is showing following error.
When I checked the DB, JTS database is not able to connect but other database like CCM, QM and DW databases are connecting properly. When I am trying to connect the JTS DB it shows following error.
[IBM][CLI Driver] SQL1042C An unexpected system error occurred.
SQLSTATE=58004
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
[IBM][CLI Driver] SQL1042C An unexpected system error occurred.
SQLSTATE=58004
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
[IBM][CLI Driver] SQL1042C An unexpected system error occurred.
SQLSTATE=58004
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
----------------------------------------------------------------------------------------------------------------------------------
I have restored the JTS DB through Log files but no luck.
Does anyone know, What could be the issue?
Thanks,
Tariq Ashraf
Comments
Lily Wang
Feb 03 '14, 7:27 p.m.Hi Tariq,
Could you provide the errors in jts.log?
Is there any error in DB2 log db2diag.log? If the problem is in DB2, you can consult DB2 support.