Sponsored Content
Operating Systems AIX Time of query execution much different between 3 servers Post 302964130 by omonoiatis9 on Monday 11th of January 2016 05:31:36 AM
Old 01-11-2016
Time of query execution much different between 3 servers

Hello,

I have 3 AIX 6.1 machines running INFORMIX 11.7 database engine.
One of these servers is the database server and the other 2 servers are connecting to it.
I am doing a test to determine the time of query execution between these servers and i see that in specific times one of these server is taking much more response time.
Here is an example of the test:
Code:
server1: 11:00:00     11:01:01    11:02:00   11:03:00   11:04:00
              0m0,05s     0m0,08s    0m0,08s   0m0,05s   0m0,05s

server2: 11:00:00    11:01:00    11:02:00   11:03:00   11:04:00
              0m0,08s    0m0,10s    0m0,06s   0m0,08s   0m0,08s

server3:  11:00:00   11:01:00  11:02:00    11:03:00    11:04:00
               0m0,07s  0m0,65s   0m0,27s    0m0,25s   0m0,50s

You can see that the execution time on server3 is much longer that the other 2 and i noticed that this happens at the first 5-6 minutes of each hour.
I am trying to figure out what causes this extra delay during these hours but i cannot find anything. I tried to check the crons to see if there is something automatic that runs during these hours that is causing the delay but i dont think my answer is there.

Any help will be appreciated.
Thank you.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check query execution to go further

Can any one help with script (Korn) to do following ? :confused: I have 3 tasks to do in a shell. Task (1) is executing query which unloads the result into file XYZ. Before I start Task (2) which is java program and depends on file XYZ, I need to make sure that Task (1) is completed... (1 Reply)
Discussion started by: cub
1 Replies

2. Programming

execution time

hi , i ve coded a C program in that im using malloc dynamically , it is being called many times in the program The program is to simulate jobs in manufacturing system. the execution time is increasing drastically as the number of jobs are increased. could any body tel what may be the problem... (2 Replies)
Discussion started by: ramki_rk
2 Replies

3. UNIX for Dummies Questions & Answers

last execution time

is there a command in Solaris 8 that will show a particular scripts last execution time? (1 Reply)
Discussion started by: cubs0729
1 Replies

4. UNIX for Advanced & Expert Users

specifying an execution time

Hi all, do ny o u'll know how to set a particular execution time for a program??? for eg.: --> during the execution of a file, i call a certain other function. --> while calling this function, my comp hangs. now is there ny way in which i can go to the nxt line of code by aborting the call... (7 Replies)
Discussion started by: VGR
7 Replies

5. Shell Programming and Scripting

To reduce execution time

Hi All, The below script I run daily and it consumes 2 hours approx. In this I am calling another script and executing the same twice. Is the loop below the cause for the slow process?Is it possible to finetune the program so that it runs in a much faster way? The first script: #!/bin/ksh... (4 Replies)
Discussion started by: Sreejith_VK
4 Replies

6. HP-UX

Automatic execution of commands in multiple servers using single script.

Hi, I've to do a simple job many times whenever it has been asked, just i've to log in to all of fourtien HP servers and i've to execute ps -fu user > temp cat temp|sendmail "xyz@z.com" commands to send the statics of all of 14 servers over the mail to particular user id.. Though logging... (4 Replies)
Discussion started by: vickramshetty
4 Replies

7. UNIX for Dummies Questions & Answers

time taken for execution

how much time a particular command or shell script executed there is any command to know this thanks (5 Replies)
Discussion started by: tsurendra
5 Replies

8. Solaris

Remote execution of a local script on multiple servers

So I have a scriptlet called solaris_command: for i in \ server1 server2 server3 do echo $i ssh $i $1 echo "" done I then use that as a command in multiple scripts to allow for data gathering for all virtual hosts in the environment thusly: solaris_command "cat... (3 Replies)
Discussion started by: os2mac
3 Replies

9. Homework & Coursework Questions

Parallel execution on multiple servers in UNIX

I have a requirement (in a shell script) to connect to several servers at once and execute a series of commands. I am aware that ssh can be used for sequential execution. But since most of the commands that I need to execute take a long time, I have to go for the parallel option. Is there... (2 Replies)
Discussion started by: sneha1887
2 Replies

10. Shell Programming and Scripting

To take script execution time

Hello Guys, I would like to know is there a way to take the script execution time For e.g i am having a script.sh i need to write inside he script.sh like Start time : 10-Mar-2016 02:30:35 all code over here ... End time : 10-Mar-2016 03:30:32 Script start time - 02:30:35 ... (7 Replies)
Discussion started by: Master_Mind
7 Replies
ypserv(8yp)															       ypserv(8yp)

Name
       ypserv, ypbind - yellow pages (YP) server and binder processes

Syntax
       /usr/etc/ypserv
       /etc/ypbind [ -S domainname, servername1,servername2...	][ -X ]

Description
       The  yellow  pages (YP) service provides a network lookup service consisting of databases and processes.  The databases are files stored in
       the directory.  These files are described in The processes are the YP database lookup server, and the YP binder.  The software interface to
       the YP service is described in Administrative tools are described in and Tools to see the contents of YP maps are described in and Database
       generation and maintenance tools are described in and

       Both and are daemon processes activated at system startup time from The command runs only on a YP server machine with a complete  YP  data-
       base.  The command runs on all machines using YP services, both YP servers and clients.

       The  daemon's primary function is to look up information in its local database of YP maps.  The operations performed by are defined for the
       programmer in the header file

       Communication with is by means of RPC calls.  Lookup functions are described in and are supplied as C-callable functions in

       There are four lookup functions, all of which are performed on a specified map within a YP domain: and  The  operation  takes  a  key,  and
       returns	the  associated  value.  The operation returns the first key-value pair from the map, and the operation returns the remaining key-
       value pairs.  The operation ships the entire map to the requester.

       Two other functions supply information about the map, rather than the map entries: and Both the order number and the master name  exist	in
       the map as key-value pairs, but the server will not return either through the usual lookup functions.  If the map is examined with however,
       they are visible.

       Other functions are used within the YP subsystem itself, and are not of general interest to YP clients.	They include the the and the func-
       tions.

       The  purpose  of the function is to remember information that lets client processes on a single node communicate with a process.  The func-
       tion must run on every machine that has YP client service requirements.	The function must be started through an entry in the file.

       The information remembers is called a binding, the association of a domain name with the internet address of the YP server, and the port on
       that  host  at which the process is listening for service requests.  The process of binding is driven by client requests.  As a request for
       an unbound domain comes in, the process broadcasts on the net trying to find a process that serves maps	within	that  domain.	Since  the
       binding	is established by broadcasting, there must be at least one process on every net.  Once a domain is bound by a particular that same
       binding is given to every client process on the node.  The process on the local node or a remote node may be queried for the binding  of  a
       particular domain by using the command.

       Bindings  are  verified	before	they are given out to a client process.  If is unable to speak to the process it is bound to, it marks the
       domain as unbound, tells the client process that the domain is unbound, and tries to bind the domain once again.  Requests received for	an
       unbound	domain	will  fail immediately.  In general, a bound domain is marked as unbound when the node running crashes or gets overloaded.
       When the node gets overloaded, will try to bind any YP server (typically one that is less-heavily loaded) available on the net.

       The process also accepts requests to set its binding for a particular domain.  The request is usually generated by the YP subsystem itself.

Options
       -S	 Allows the system administrator to lock to a particular domain and set of servers. Up to four servers can be  specified  as  fol-
		 lows:
		 /etc/ypbind -S domainname,server1,server2,server3,server4
		 Note  that  there  can not be any spaces around the commas in the command line. The option ensures that this system only binds to
		 the specified domain and to one of the specified servers.  The servers used with the option must have entries in the local file.

       -X	 The initial bind ( option forces to bind to a YP server at the time that the command is executed, instead of waiting until YP	is
		 used.	If no server is available at this time, will try for several minutes and then exit.  Normally, is executed at boot time.

		 The  option  enables  a  system  that	does not exclusively depend on YP to boot and to allow logins when there are no YP servers
		 available.  Without this option, such a system hangs.

Files
       If the file exists when starts up, log information is written to when error conditions occur.

See Also
       ypcat(1yp), ypmatch(1yp), ypwhich(1yp), ypclnt(3yp), ypfiles(5yp), yppush(8yp), ypxfr(8yp)
       Guide to the Yellow Pages Service

																       ypserv(8yp)
All times are GMT -4. The time now is 07:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy