We have 2 databases. One is an oracle 11g DB and the other is a DB2 database. I need to make a query to the oracle database to get a list of accounts and feed that as parameters into another DB2 query. If the DB2 Query returns any results then I need to send an alert. Is this in any way possible with sitescope (I am fairly new to sitescope so be gentle)? It looks like there is only room for 1 connection string in the sitescope monitors. Can I create 2 monitors (one for DB2 and one for Oracle) and use the results of one query as a parameter into the other monitor? Looks like there is some monitor to monitor capabilities but still trying to understand what is possible. Thanks!
How can I use multiple databases in a sitescope monitor?
401 Views Asked by George At
1
There are 1 best solutions below
Related Questions in ORACLE11G
- Building an sql execution plan history
- how to update the date field for this specific condition using oracle query?
- Insert Into SP in Oracle Sql Developer
- Trying to update an ORACLE 11G DB with C# Asp.net using Oracle Managed Driver.
- Require tool to trace the LInq Queries in Oracle
- Oracle 11g : staging table
- Persist the value of one column in two simultaneous update
- Trigger From Oracle to SQL SERVER
- how to check succeeded and failed sending a message in gsmcomm library
- How to install Oracle XE for windows32 properly?
- use select under case statement
- Merge table in Oracle with delete condition refering to source table
- Oracle 11g to PostgreSQL - CREATE TYPE OBJECT
- Import dmp file created in Oracle 11g (WE8ISO8859P1) to Oracle 11g XE database (AL32UTF8)
- Changing start date for system jobs related to automatic statistics collections in 11g
Related Questions in DB2
- How to grant privileges to current user
- Drop DB2 database if exist
- DB2, Hibernate, JPA: Schema does not exist
- Can you check for a DB2 license in C#?
- DB2 Join Query that Maximizes Column
- How to access a Row Type within an Array Type in DB2 SQL PL
- IBM DB2 native encryption applied on live database
- Using an ODBC connection in Access get retrieve data from DB2
- join 2 tables and get some columns from 1st table and max timestamp value from second table
- How to connect to DB2 SQL database with node JS?
- TRANSLATE not working inside XMLAGG
- Cannot initialise HikariCP pooled connection, Failure in loading native library db2jcct2
- published reports don't work - Database logon failed Error
- 1 Working Day Back In SQL DB2
- In java with DB2 parallel process: I got Deadlock Exception :DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=3.59.81
Related Questions in SITESCOPE
- Status 302 Found, when I try to access my web application instead of status 200
- Regex: How to exclude one word and one character?
- Monitoring Integration points
- Sitescope regular expression
- SiteScope URL Monitor Regex
- Calculated metrics: create metrics expression
- Regular Expressions - match content in XML page
- Loadrunner monitoring of VMWare ESX host
- Metrics collection of application behind Citrix
- Is there a way to match strings:numbers with variable positioning within the string?
- How can I use multiple databases in a sitescope monitor?
- log file monitoring using regex
- JMeter and Sitescope Monitors - Is it possible to pass metrics to SiteScope so an application can be monitored in real time?
- How to create a regular expression for Sitescope Log monitor logfile path?
- How do you reject a string if preceded by another string using standard POSIX regex?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
It is possible to extract the results from the first query using a custom script alert, but it is not possible than to reuse the data in another monitor.
SiteScope (SiS) Database Query monitor has no feature to include dynamically changing data in the query used. Generally speaking monitor configurations are static and can only be updated by an external agent (user or integration).
Thinking inside the box of one vendor using HP Operations Orchestration (OO) would be an option to achieve your goal. You could either use OO to run the checks and send you alerts in case of a problem or run the checks and dump the result to a file somewhere which than subsequently can be read by SiS using Script monitor or Logfile monitor.