unix and linux commands - unix shell scripting

Improving Performance Through Persistent Connections

8 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Having too many connections could affect performance ?

Good evening, i need your help please I will try to describe the scenario briefly: In a Telecom Production system application receives a certain files called CDRs(call detail records) to be processed by doing some operating systems operations and then database operations like creating indexes...

2. Shell Programming and Scripting

Improving code

Gents, I did the below code to get an output (report) ,.. the code works fine but I believe it can be more shorted using better method. Please if you can help, to generate same output improving the code , will be great. here my code. # get diff in time awk '{$9=$8-prev8;prev8=$8;print...

3. Shell Programming and Scripting

Need help improving my script.

Thank you for taking the time to look at this and provide input. To start, I am not a linux/unix expert but I muddle through the best I can. I am also in no way shape or form a programmer. Please keep that in mind as you read this script. This script is designed to find all files in a given...

4. Shell Programming and Scripting

Basic help improving for in loop

I'm obviously very new to this. I'm trying to write a simple for loop that will read the directory names in /Users and then copy a file into the same subdir in each user directory. I have this, and it works but it isn't great. #!/bin/bash HOMEDIRS=/Users/* for dirs in $HOMEDIRS; do if ];...

5. Shell Programming and Scripting

Improving this validate function

Hi guys, I use this function which was provided to me by someone at this site. It works perfectly for validating a users input option against allowed options.. example: validateInput "1" "1 3 4 5" would return 0 (success) function validateInput { input=$1 allowedInput=$2 for...

6. Shell Programming and Scripting

Persistent variable

I found a way to make a numeric variable persistent for a script : #!/bin/bash function Persist() { # 1:Expression like VARIABLE=Value (numeric) local V=${1%=*} eval "$1" sed -i "s/^$V=*/$1/" $(which $(basename $0)) || return 1 }And how to use itAA=12 read -p "Enter a...

7. UNIX for Dummies Questions & Answers

Improving Unix Skills

Kindly any advice to improve my unix skills as electronic books i can download or valuable sites as this one etc...

8. Shell Programming and Scripting

improving my script

Hi; I want to access our customer database to retreive all clients that have as language index 2 or 3 and take their client number. My input is a file containing all client numbers. i access the data base using a function call "scpshow". The total number of clients i want to scan is 400 000...

LEARN ABOUT PHP

db2_pclose

DB2_PCLOSE(3)								 1							     DB2_PCLOSE(3)

db2_pclose - Closes a persistent database connection

SYNOPSIS

       bool db2_pclose (resource  $resource)

DESCRIPTION

	This function closes a DB2 client connection created with db2_pconnect(3) and returns the corresponding resources to the database server.

       Note

	       This function is only available on i5/OS in response to i5/OS system administration requests.

	If  you  have a persistent DB2 client connection created with db2_pconnect(3), you may use this function to close the connection. To avoid
       substantial connection performance penalties, this function should only be used in rare cases when the  persistent  connection  has  become
       unresponsive or the persistent connection will not be needed for a long period of time.

PARAMETERS

	      o $connection
		- Specifies an active DB2 client connection.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Closing a persistent connection

	       The following example demonstrates a successful attempt to close a connection to an IBM DB2 i5/OS database.

	      <?php
	      $conn = db2_pconnect('', '', '');
	      $rc = db2_pclose($conn);
	      if ($rc) {
		  echo "Connection was successfully closed.";
	      }
	      ?>

	      The above example will output:

	      Connection was successfully closed.

SEE ALSO

       db2_close(3), db2_pconnect(3).

PHP Documentation Group 													     DB2_PCLOSE(3)