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?
402 views Asked by George At
1
There are 1 answers
Related Questions in ORACLE11G
- Whatever the data available in previous record it should add to the new record
- Identifying invalid dates in Oracle database due to daylight saving time changes
- How to perform arithmetic calculation between rows in oracle Pl/Sql
- Oracle Performance Slow with Select Union From Dual in Join Statement
- How to reduce the size of tif files before inserting into the oracle database
- Passing table name dynamically each time
- ORA-06550 and PLS-00306 Errors When Calling Stored Procedure with UDT Table Parameter using ODP.NET on .NET 6
- oracledb.exceptions.DatabaseError: DPY-4011: the database or network closed the connection - python oracledb library
- Spring boot oracle 11g sequence stored is different from the value shown in the model
- Update or Insert into table, using rows from same table
- how to fix PLS-00306: wrong number or types of arguments in call to 'DEQUEUE'
- Oracle materialized view refresh on two different schedules
- How may I perform OCIPing (or equivalent) from a .Net application?
- is the documentation for oracle-sql and mysql the same with respect to the definitions, syntaxes and rules?
- How to Extract Database Connection Information from JInitiator 1.1.8.16 Files?
Related Questions in DB2
- IBM DB2 console doesn't work after SSL certificate update
- SQL - Recursive Calculation Solution Required
- Concurrently open statements
- SQL Error: -302, SQLState: 22001 while using String function with a dynamic parameter in db2/hibernate
- Ibm Db2 Jdbc Connection
- DB2 and JSON, inconsistent quotation of integers
- SqlException in DBeaver24.0.1 when doing datasets connection
- How to inject the DBContext of Entity Framework Core to AutoFac
- TSM DB2 SQL query for display backup vm
- Azure Function Crash w/ Relation to IBM.EntityFrameworkCore
- RPG file using dynamic SQL fails to display data to display file
- GRAPHQL in Mainframe DB2
- Problem updating table A using data from table B
- Dynamic SQL with Hibernate
- open fetch and close cursor DB2
Related Questions in SITESCOPE
- 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?
- Is there a way to match strings:numbers with variable positioning within the string?
- Metrics collection of application behind Citrix
- Need a Way to Test a user against remote server using Powershell
- Sitescope regular expression
- Calculated metrics: create metrics expression
- Loadrunner monitoring of VMWare ESX host
- Status 302 Found, when I try to access my web application instead of status 200
- How can I use multiple databases in a sitescope monitor?
- Match SiteScope Log file path
- Hp Loadrunner / virtual user generator web click and script alternative
- log file monitoring using regex
- Regular Expressions - match content in XML page
- Regex: How to exclude one word and one character?
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?
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)
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.