10-29-2009
script to collect all db information
hi all
I am looking for shell script ,by which i need to gather all the DB information in Sybase server .
Thanks in advance
10 More Discussions You Might Find Interesting
1. Solaris
Dear All,
We are going for Disaster Recovery project, the vendor asked for more details about how much is the daily data changes only. using sar / iostat can any one help me to collect this ?!
Note: only I need the changed data size not the daily increasing data. this is to know how much... (1 Reply)
Discussion started by: adel8483
1 Replies
2. Shell Programming and Scripting
How do i collect Date & Time from Different Directories in a script
The script iam using for a single directory is :
ls -l | grep awk '{print $8}' (2 Replies)
Discussion started by: laknar
2 Replies
3. Shell Programming and Scripting
Hi All ,
In my environment we have 12 SAN switches .Culd u pls help me for below queries .
would like to telnet to all switches and collect information in daily basis with "switchstatus" command and store the output under /tmp/ folder on systemA .
To keep passwords of 12switches in a... (1 Reply)
Discussion started by: chinni-script
1 Replies
4. Shell Programming and Scripting
My management is looking for me to sweep my Unix servers and report on (1) how much SAN space has been allocated to each server and (2) how much is used (defined as having a file on those bits). Basically stuff one can get from "df", but they just want SAN totals (not local disks). NAS is exempt.
... (1 Reply)
Discussion started by: MikJik
1 Replies
5. Shell Programming and Scripting
I am using AIX 5.3.0.0 ; I need a script to find out each remote AIX boxes
Hostname, Model name and Serial number in following format
Hostname Modelname SerialID
AIXMC01 IBM,7026-B80 IBM,0110BBA1F
AIXMC02 IBM,7026-H50 IBM,0110BBA56
AIXMC03 IBM,7026-H50 IBM,0110BBARR... (12 Replies)
Discussion started by: amir07
12 Replies
6. Shell Programming and Scripting
Hi friends,
A script needs to be created to collect all HTTP GET requests containing a particular string say abcd.gif in the url path along with the IP address of the client that issued the request. The source of this data is the web server logs. Also Each script execution should extract... (4 Replies)
Discussion started by: skumar391
4 Replies
7. Shell Programming and Scripting
Hi, I'm newbie in Korn scripting as well as in Unix. I need to have a script to do the following.
1) ssh multiple hosts
-In my case, login credentials are not an issue as all keys authorized by default. Example of host IP (24.35.14.6, 24.35.14.7, 24.35.14.8, 24.35.14.9, ... (2 Replies)
Discussion started by: blinkingdan
2 Replies
8. UNIX for Dummies Questions & Answers
Hi
Kindly provide me shell script on server to collect inbound connections, using port number on Linux. (4 Replies)
Discussion started by: adminhelp
4 Replies
9. SuSE
Dear users,
SUSE 10 sp3 and SUSE 11.
I made configuration changes in '/etc/syslog-ng/syslog-ng.conf'
to move SYSLOG content to LogRhythm.
This is what I changed in the file.
Un-comment out the following lines
#Enable this and admop IP to send log messages to... (10 Replies)
Discussion started by: JDBA
10 Replies
10. Shell Programming and Scripting
I am trying to collect logs from a system in expert mode. Where I login to system and then change mode to expert mode and issue command to collect the log. I have a script which works but It waits for 30 mins even though log collection is complete before that. I have two issues with existing... (4 Replies)
Discussion started by: shunya
4 Replies
LEARN ABOUT PHP
sybase_connect
SYBASE_CONNECT(3) SYBASE_CONNECT(3)
sybase_connect - Opens a Sybase server connection
SYNOPSIS
resource sybase_connect ([string $servername], [string $username], [string $password], [string $charset], [string $appname], [bool
$new = false])
DESCRIPTION
sybase_connect(3) establishes a connection to a Sybase server.
In case a second call is made to sybase_connect(3) with the same arguments, no new link will be established, but instead, the link identi-
fier of the already opened link will be returned.
The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling
sybase_close(3).
PARAMETERS
o $servername
- The servername argument has to be a valid servername that is defined in the 'interfaces' file.
o $username
- Sybase user name
o $password
- Password associated with $username.
o $charset
- Specifies the charset for the connection
o $appname
- Specifies an appname for the Sybase connection. This allow you to make separate connections in the same script to the same data-
base. This may come handy when you have started a transaction in your current connection, and you need to be able to do a separate
query which cannot be performed inside this transaction.
o $new
- Whether to open a new connection or use the existing one.
RETURN VALUES
Returns a positive Sybase link identifier on success, or FALSE on failure.
CHANGELOG
+--------+------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+------------------------------------+
| 5.3.0 | |
| | |
| | The $new parameter was added. |
| | |
| 4.2.0 | |
| | |
| | The $appname parameter was added. |
| | |
| 4.0.2 | |
| | |
| | The $charset parameter was added. |
| | |
+--------+------------------------------------+
EXAMPLES
Example #1
sybase_connect(3) example
<?php
$link = sybase_connect('SYBASE', '', '')
or die("Could not connect !");
echo "Connected successfully";
sybase_close($link);
?>
SEE ALSO
sybase_pconnect(3), sybase_close(3).
PHP Documentation Group SYBASE_CONNECT(3)