View previous topic :: View next topic
|
Author |
Message |
venkatm2012
New User
Joined: 14 Aug 2012 Posts: 8 Location: india
|
|
|
|
Hi,
How to know when DB2 instance was last Stopped/Started?
Thanks in Advance. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
Are you talking about DB2 LUW? |
|
Back to top |
|
|
venkatm2012
New User
Joined: 14 Aug 2012 Posts: 8 Location: india
|
|
|
|
Hi,
Sorry to say i don't have much idea of what is DB2 LUW (Googled after seeing your question). In my application , frontend ( JAVA ) is coneecting to DB2 via JDBC driver and connection to DB2 is lost sometimes. Just want to know if the DB2 is getting restarted. Is there any DB2 table where i can see the last restart time of the database?
Thanks in Advance. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
LinuxUnixWindows |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
<A small experience observation on>
"DB2 instance" is a term mostly used by DB2 users NOT from zOS back-ground. An instance in DB2 for LUW is like a copy of the RDBMS including all the processes that run DB2 and memory (address spaces) associated with that instance of DB2 and some configuration parameters (ZPARMS) to control that instance. OTOH, DB2 on zOS is like a "sub-system under zOS" -- that's why I asked if you talked about DB2 LUW. And the meaning of LUW you alrady 've from Enrico.
</A small experience observation off>
Having said that, you latest question sounds like - if you're talking about an pplication using DB2-store prcedures on zOS and a "Front end JAVA-screen", are you? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
still have not answered if the db2 is on a server or a z/OS machine.
if z/OS, read on. if not, you are in the wrong website.
you are wasting your time looking at the restart time of db2.
it will be a failure of whatever application you are invoking with the webservice.
look at your JDBC driver logs
and your JAVA logs.
reason for lack of connection is there,
as well as the invoked application.
without knowing what you are doing, no one can help. |
|
Back to top |
|
|
venkatm2012
New User
Joined: 14 Aug 2012 Posts: 8 Location: india
|
|
|
|
Hi,
Yes, DB2 is on z/OS machine. Error is occuring while trying to get current timestamp from DB2 ( Query was in JAVA frontend, not in db2).
Error log:
30 Jul 2012 11:13:53,308:[[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)']
[ERROR] com.db.ct.core.dblegicodemap.impl.DbLegiCodeMapDAOImpl - insertion failed userid is----
=====org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [HY000]; error code [0];
--- The error occurred in sqlmap/core/config/sql-map-core-config-genericdata.xml.
--- The error occurred while applying a parameter map.
--- Check the GenericData.getCurrTimeStamp-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Exception generated during deferred local transaction handling.
See next exception via SQLException.getNextException for details.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/core/config/sql-map-core-config-genericdata.xml.
--- The error occurred while applying a parameter map.
--- Check the GenericData.getCurrTimeStamp-InlineParameterMap.
--- Check the statement (query failed).
Thanks a lot in advance. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
what you have provided us indicates
that your mapping from the java module to the JBDC driver was wrong
and the JBDC driver declined the request.
it was never even sent to the host for processing.
so, all the problems so far are on your server. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
and how will knowing when the DB2 subsystem was stopped help to debug Your problem ? |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
It is also worth noting that in most shops stopping a DB2 subsystem is a pretty rare event, even in a development environment. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
often the two civilizations (pc/server and mainframe) collide
and the first thing everybody does is blame the other.
since there was no timeout message, we know that the connection to the mainframe was not even attempted.
The TS will have to debug and insure his side at least attempts the communications.
then the accusations will start again,
but i imagine that will not be today.
and yes, Don,
the experiences of the pc/server side,
where everything is hit-and-miss, maybe it is running, maybe not,
tend to color the perception of the mainframe.
the boys with the little toys,
have no experience with 24/7 reliability. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Quote: |
and how will knowing when the DB2 subsystem was stopped help to debug Your problem ? |
Oh, Please, Please, Please, let the service be down so we don't have to deal with this . . . |
|
Back to top |
|
|
venkatm2012
New User
Joined: 14 Aug 2012 Posts: 8 Location: india
|
|
|
|
Hi,
Thanks for your responses.
Issue is happening once or twice in a week. We will be restarting application server to resolve this issue, kind of workaround. Once the application server is restarted, we are able to access the application. We are thinking of different possibilities which might cause this issue and one thing we thought is DB2 database restart. I think now that possibility is ruledout. Other area we are analyzing is memory leakage on java application.
Hope we will find the rootcause soon...keep you updated.
Once again thanks a lot for your time. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
the are an uncountable number of monitors and utilities to find the cause of memory leakage.
it should not be a problem and should be an intrinsic part of the development process.
i would insure that all the mapping between any exchange
is double checked.
i would also assign an individual to insure that all update/fixpacks
have been applied
and to scour the documentation for any known inconsistencies
between packages.
you have a basic problem of one part saying it is A
and the receiving part interpreting it as B.
even the error log says that there is a mapping problem.
until that error disappears,
you will be left with solving your server problems like we had to
with windows 3x.
CTL-ALT-DEL.
not really a solution. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Venkat,
You have said,
Quote: |
connection to DB2 is lost sometimes |
Check in the DB2MSTR logs and DB2DIAG.log exactly for the time you got error, you might find more information there.
Do you know when this connection blips started ? Any change in the network structure anything like that?
Thanks,
Sushanth |
|
Back to top |
|
|
sandip_mainframe Warnings : 2 New User
Joined: 20 Sep 2006 Posts: 63 Location: pune
|
|
|
|
Hi Venkat,
You can check it in DB2MSTR logs or BMCDB2 - APPTUNE ( If have this tool in your shop ) it will display complete information.
Thanks,
Sandip Walsinge
Walsinge Technologies Pvt Ltd Pune. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
the connection is lost, not the DB2 itself |
|
Back to top |
|
|
|