dejan;39974 Wrote:


--
rhann

On Wed, 26 Oct 2011 02:59:35 -0700 (PDT)
seldom isnice <seldomisnice248 (AT) gmail (DOT) com> wrote:

I realise the discussion has moved on a little but I thought I'd share
something from a doc I wrote a while back about identifying the oldest
transactions in the log file via IMA.

The following query almost gives the information required:

SELECT l.tx_server_pid,
l.tx_session_id,
d.server
FROM ima_log_transactions l,
ima_dbms_server_parameters d
WHERE l.tx_status LIKE 'ACTIVE%'
AND l.tx_server_pid=d.server_pid
ORDER BY l.tx_first_log_address

This will give us the server pid, server id and session id of all
active transactions in the logging system ordered by the first log
address of the transaction.

However log addresses are in this form <sequence_no, block,
block_offset> and the column tx_first_log_address is a character type
so the sorted output would like this:

<1119133361,15171,868>
<1119133361,151174,208>
<1119133361,15276,2800>

When what is required is this:

<1119133361,15171,868>
<1119133361,15276,2800>
<1119133361,151174,208>

In order to get around this the individual elements of the log address
are needed so that they can be sort numerically. The ima table
"ima_log_transactions" doesn't provide this, so it is necessary to
define a new one.

The attached copy.in defines a table "pm_ima_log_transactions" which
has the additional columns tx_first_log_addr_seq,
tx_first_log_addr_block and tx_first_log_addr_offset

To create this table within an ima database

sql -u\$ingres imadb < copy.in

Then execute the following SQL which will retrieve the active logfile
transactions ordered oldest to newest:

SELECT p.tx_server_pid,
p.tx_session_id,
d.server
FROM pm_ima_log_transactions p,
ima_dbms_server_parameters d
WHERE p.tx_status LIKE 'ACTIVE%'
AND p.tx_server_pid=d.server_pid
ORDER BY tx_first_log_addr_seq,
tx_first_log_addr_block,
tx_first_log_addr_offset;

This is an example, you could join on ima_server_sessions to find out
more about the sessions associated with these transactions e.g. client
info, current and last query etc.

HTH
Paul

It took us about 6 months 'sf asian escort'
(http://www.sfasianescort.com) to get almost 500 pages. Let's go for 5
months this time. 'sf escorts' (http://www.sfasianescort.com)
"It had to be said. The world is perishing from an orgy of
self-sacrificing." - Howard Roark 'sf escort'
(http://www.sfasianescort.com)
Dean Koontz= Always working! 'sf asian escorts'
(http://www.sfasianescort.com)


--
xliang

On Oct 29, 7:02*am, Ingres Forums <info-
ing... (AT) kettleriverconsulting (DOT) com> wrote:
Regarding DBAnalyser: is this useful ? Even in trial mode?

I tried it and I got the message: Windows is searching for wjview.exe

But that was it

Do I install on Windows or Unix ?

Thanks

seldom isnice wrote:

[??! snip]

DBAnalyzer consists of several components. The server-side Monitor has
to be installed on the Ingres DBMS host. It's job is to probe the
Ingres processes at intervals to obtain various metrics and snapshots of
running sessions. It also generates the values for derived performance
tables that give information about rates and durations. (For example it
calculates cache attempt rates, I/O rates, logging rates and so on.)

You need to install the server-specific Monitor appropriate for your
system. Currently only Linux and Solaris are supported.

There are several clients that can access the performance database.
There is the Sentinel, which runs on the server. It detects problems
according to alarm definitions which are supplied plus any alarm
defitions that you define for site or application-specific problems.
Rapidly approaching logfull would be one alarm condition. When it
detects an alarm condition the Sentinel generates a report showing
relevant information (e.g. open transactions, queries, log volume,
session owner). The Sentinel can monitor non-ingres resources too, like
disk space. There is another client for doing ad hoc queries of the
performance database.

There are desktop (console) clients for the Monitor and the Sentinel.
These are Java applications so if you install them on a Windows
machine you need to have a Java run-time environment. That wjview.exe
message was probably compaining about no being able to find part of that
environment.

More information can be found at http://www.dmt.com/dba_arch.htm

--
Roy

UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.
The latest information is available from www.uk-iua.org.uk.

test, please ignore


--
bilgihan