How to know when DB2 instance was last Stopped/Started

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.

Anuj Dhawan · Posted: Mon Aug 27, 2012 6:48 pm

Are you talking about DB2 LUW?

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.

enrico-sorichetti · Posted: Mon Aug 27, 2012 7:22 pm

Anuj Dhawan · Posted: Mon Aug 27, 2012 7:50 pm

<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?

dbzTHEdinosauer · Posted: Mon Aug 27, 2012 8:08 pm

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.

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.

dbzTHEdinosauer · Posted: Mon Aug 27, 2012 8:39 pm

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.

enrico-sorichetti · Posted: Mon Aug 27, 2012 8:40 pm

and how will knowing when the DB2 subsystem was stopped help to debug Your problem ?

don.leahy · Posted: Mon Aug 27, 2012 8:58 pm

It is also worth noting that in most shops stopping a DB2 subsystem is a pretty rare event, even in a development environment.

dbzTHEdinosauer · Posted: Mon Aug 27, 2012 9:08 pm

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.

dick scherrer · Posted: Mon Aug 27, 2012 9:15 pm

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.

dbzTHEdinosauer · Posted: Tue Aug 28, 2012 11:16 am

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.

sushanth bobby · Posted: Tue Aug 28, 2012 11:51 am

Hi Venkat,

You have said,

sandip_mainframe · 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.

enrico-sorichetti · Posted: Tue Aug 28, 2012 1:02 pm

the connection is lost, not the DB2 itself