Sponsored Content
Full Discussion: Best match query
Top Forums Programming Best match query Post 302981345 by yahyaaa on Saturday 10th of September 2016 05:26:09 PM
Old 09-10-2016
Big thankss....
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1... (0 Replies)
Discussion started by: hazno
0 Replies

2. UNIX and Linux Applications

mysql query all entries which 'dont' match

I am trying to query a list of hosts and extract all entries which 'dont' match. SELECT LOGS.host, GOODLIST.host FROM LOGS,db.GOODLIST WHERE (LOGS.host <> GOODLIST.host)When I use this query, it is very very slow. Matching the host with the GOODLIST.host works great and fast but when I use <>... (1 Reply)
Discussion started by: hazno
1 Replies

3. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

4. Programming

sql query to match condition from other table (time sensitive)

I know little SQL and could really use a hand here. I need to get the fields last_name, first_name and email from the table users and only if the entery with the same pkey in the table addresses, in the city column is Seattle. So if the city in the addresses table is Seattle, go to the table... (2 Replies)
Discussion started by: computethis
2 Replies

5. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

6. Shell Programming and Scripting

Match pattern1 in file, match pattern2, substitute value1 in line

not getting anywhere with this an xml file contains multiple clients set up with same tags, different values. I need to parse the file for client foo, and change the value of tag "64bit" from false to true. cat clients.xml <Client type"FIX"> <ClientName>foo</ClientName>... (3 Replies)
Discussion started by: jack.bauer
3 Replies

7. Shell Programming and Scripting

Request: How to Parse dynamic SQL query to pad extra columns to match the fixed number of columns

Hello All, I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns. So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies

8. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies

9. Shell Programming and Scripting

awk to print match or non-match and select fields/patterns for non-matches

In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing... (0 Replies)
Discussion started by: cmccabe
0 Replies

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
BBPROXY(8)						      System Manager's Manual							BBPROXY(8)

NAME
bbproxy - Xymon message proxy SYNOPSIS
bbproxy [options] --bbdisplay=$BBDISP DESCRIPTION
bbproxy(8) is a proxy for forwarding Big Brother messages from one server to another. It will typically be needed if you have clients behind a firewall, so they cannot send status messages to the Xymon server directly. bbproxy serves three purposes. First, it acts as a regular proxy server, allowing clients that cannot connect directly to the Xymon servers to send data. Although bbproxy is optimized for handling status messages, it will forward all types of messages, including notes- and data- messages. Second, it acts as a buffer, smoothing out peak loads if many clients try to send status messages simultaneously. bbproxy can absorb mes- sages very quickly, but will queue them up internally and forward them to the Xymon server at a reasonable pace. Third, bbproxy merges small "status" messages into larger "combo" messages. This can dramatically decrease the number of connections that need to go from bbproxy to the Xymon server. The merging of messages causes "status" messages to be delayed for up to 0.25 seconds before being sent off to the Xymon server. OPTIONS
--bbdisplay=SERVERIP[:PORT][,SERVER2IP[:PORT]] Specifies the IP-address and optional portnumber where incoming messages are forwarded to. The default portnumber is 1984, the stan- dard Big Brother port number. If you have setup the normal Big Brother environment, you can use "--bbdisplay=$BBDISP". Up to 3 servers can be specified; incoming messages are sent to all of them (except "config", "query" and "download" messages, which go to the LAST server only). If you have Xymon clients sending their data via this proxy, note that the clients will receive their config- uration data from the LAST of the servers listed here. This option is required. --bbpager=SERVERIP[:PORT][,SERVER2IP[:PORT]] DEPRECATED - this option is only present for compatibility with servers running Big Brother, and will be removed soon. Specifies the IP-address and optional portnumber where incoming "page" messages are forwarded to. The default portnumber is 1984, the standard Big Brother port number. If you have setup the normal Big Brother environment, you can use "--bbpager=$BBPAGE". Up to 3 servers can be specified; incoming messages are sent to all of them. If this option is omitted, "page" messages are sent to the servers listed in --bbdisplay. --listen=LOCALIP[:PORT] Specifies the IP-adress where bbproxy listens for incoming connections. By default, bbproxy listens on all IP-adresses assigned to the host. If no portnumber is given, port 1984 will be used. --timeout=N Specifies the number of seconds after which a connection is aborted due to a timeout. Default: 10 seconds. --report=[PROXYHOSTNAME.]BBSERVICE If given, this option causes bbproxy to send a status report every 5 minutes to the Xymon server about itself. If you have set the standard Big Brother environment, you can use "--report=bbproxy" to have bbproxy report its status to a "bbproxy" column in Big Brother. The default for PROXYHOSTNAME is the $MACHINE environment variable, i.e. the hostname of the server running bbproxy. See REPORT OUTPUT below for an explanation of the report contents. --lqueue=N Size of the listen-queue where incoming connections can queue up before being processed. This should be large to accomodate bursts of activity from clients. Default: 512. --daemon Run in daemon mode, i.e. detach and run as a background proces. This is the default. --no-daemon Runs bbproxy as a foreground proces. --pidfile=FILENAME Specifies the location of a file containing the proces-ID of the bbproxy daemon proces. Default: /var/run/bbproxy.pid. --logfile=FILENAME Sends all logging output to the specified file instead of stderr. --log-details Log details (IP-address, message type and hostname) to the logfile. This can also be enabled and disabled at run-time by sending the bbproxy proces a SIGUSR1 signal. --debug Enable debugging output. REPORT OUTPUT
If enabled via the "--report" option, bbproxy will send a status message about itself to the Xymon server once every 5 minutes. The status message includes the following information: Incoming messages The total number of connections accepted from clients since the proxy started. The "(N msgs/second)" is the average number of mes- sages per second over the past 5 minutes. Outbound messages The total number of messages sent to the Xymon server. Note that this is probably smaller than the number of incoming messages, since bbproxy merges messages before sending them. Incoming - Combo messages The number of "combo" messages received from a client. Incoming - Status messages The number of "status" messages received from a client. bbproxy attempts to merge these into "combo" messages. The "Messages merged" is the number of "status" messages that were merged into a combo message, the "Resulting combos" is the number of "combo" messages that resulted from the merging. Incoming - Page messages The number of "page" messages received from a client. Incoming - Other messages The number of other messages (data, notes, ack, query, ...) messages received from a client. Proxy ressources - Connection table size This is the number of connection table slots in the proxy. This measures the number of simultaneously active requests that the proxy has handled, and so gives an idea about the peak number of clients that the proxy has handled simultaneously. Proxy ressources - Buffer space This is the number of KB memory allocated for network buffers. Timeout details - reading from client The number of messages dropped because reading the message from the client timed out. Timeout details - connecting to server The number of messages dropped, because a connection to the Xymon server could not be established. Timeout details - sending to server The number of messages dropped because the communication to the Xymon server timed out after a connection was established. Timeout details - recovered When a timeout happens while sending the status message to the server, bbproxy will attempt to recover the message and retry sending it to the server after waiting a few seconds. This number is the number of messages that were recovered, and so were not lost. Timeout details - reading from server The number of response messages that timed out while attempting to read them from the server. Note that this applies to the "config" and "query" messages only, since all other message types do not get any response from the servers. Timeout details - sending to client The number of response messages that timed out while attempting to send them to the client. Note that this applies to the "config" and "query" messages only, since all other message types do not get any response from the servers. Average queue time The average time it took the proxy to process a message, calculated from the messages that have passed through the proxy during the past 5 minutes. This number is computed from the messages that actually end up establishing a connection to the Xymon server, i.e. status messages that were combined into combo-messages do not go into the calculation - if they did, it would reduce the average time, since it is faster to merge messages than send them out over the network. If you think the numbers do not add up, here is how they relate. The "Incoming messages" should be equal to the sum of the "Incoming Combo/Status/Page/Other messages", or slightly more because messages in transit are not included in the per-type message counts. The "Outbound messages" should be equal to sum of the "Incoming Combo/Page/Other messages", plus the "Resulting combos" count, plus "Incom- ing Status messages" minus "Messages merged" (this latter number is the number of status messages that were NOT merged into combos, but sent directly). The "Outbound messages" may be slightly lower than that, because messages in transit are not included in the "Outbound messages" count until they have been fully sent. SIGNALS
SIGHUP Re-opens the logfile, e.g. after it has been rotated. SIGTERM Shut down the proxy. SIGUSR1 Toggles logging of individual messages. SEE ALSO
bb(1), bbd(1), xymon(7) Xymon Version 4.2.3: 4 Feb 2009 BBPROXY(8)
All times are GMT -4. The time now is 04:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy