Check the Sybase connectivity


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Check the Sybase connectivity
# 1  
Old 08-16-2011
Check the Sybase connectivity

Hi ,
I am able to connect to sybase using the below script ,but i want to check the status of the connectivity like if there is any network failure during downloading the file ,it will come out with exit 1 status .Any help on this ?
Code:
#  isql database_name db_user_name <<EOF
select date_val from test_table
EOF > output.txt

MR
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sybase connectivity in Linux/UNIX

Hi, i am to linux/unix,i am using AIX 5.3. i want to connect sybase database through shell script, when i used "isql", it throws error "isql not found", Do i need to install/configure anything, if yes please tell me how kindly help me on this (4 Replies)
Discussion started by: venkatraman
4 Replies

2. Shell Programming and Scripting

Error in Sybase connectivity via UNIX

Helo Experts, I have an issue in connecting to sybase from UNIX. PFB, my code : #!/bin/ksh ############################################################################### # # Filename: docflo_split.sh # # Description:docflo_split.sh WrapperScript splits the temporary file... (1 Reply)
Discussion started by: Nits
1 Replies

3. Shell Programming and Scripting

Check the connectivity of the DB through script, exit if no connection

check the connectivity of the DBs through script, script should exit if no connection and display the output as below. connectivity for DB1 is OK connectivity for DB2 is OK connectivity for DB3 is FAILED for DB in 1 2 3 do (sqlplus -s... (5 Replies)
Discussion started by: only4satish
5 Replies

4. Solaris

Sybase Connectivity Check through Shell Script

Hi, I need to check the sysbase database connectivity through the Unix Shell Script. Can you help me on the how to write the script to test the sysbase database connection. Thanks in Advance Nandha (0 Replies)
Discussion started by: nandha2387
0 Replies

5. IP Networking

Connectivity check.

How to check connectivity with an external server if I know the IP. Please note traceroute is not working for me, as it is saying command not found. (6 Replies)
Discussion started by: nixhead
6 Replies

6. AIX

Check Sybase installation

Hi, How do i check if Sybase is installed on aix..The sybase guy is doing remote installation and i need to check if he has installed sybase or not. ive tried the following approaches. #lslpp -L "*Sybase*" # tried other strings like "*ybase*" , "*base*" #lslpp -ha |grep syb # tried... (4 Replies)
Discussion started by: muzahed
4 Replies

7. IP Networking

Need to check the connectivity between 2 servers

Hi All, I need an automation script to check the connectivity between 2 UNIX servers. Could anybody please help in this regards? regards, janardhan (1 Reply)
Discussion started by: rjanardhan83
1 Replies

8. Shell Programming and Scripting

Check connectivity script

This past weekend I had some issues with my ISP. So for future purpose I'm going to have some logging on my internet so I'm able to attach log files to my complaint email if this issue reoccurs. Decided to do a simple ping script that runs every 5 or 10 min with crontab if ping fail write date... (5 Replies)
Discussion started by: chipmunken
5 Replies

9. UNIX for Advanced & Expert Users

How to check mount point connectivity in Unix?

I am working on an unix server which has a mount point of windows server in it. I just need to check about the connectivity of this mount point with the windows server. Please let me know what should be done for that. (1 Reply)
Discussion started by: venkidhadha
1 Replies

10. Shell Programming and Scripting

Script to check connectivity

I want to write a script to check if a unix box say abc.tdc.cin.net can be connected or not on certain port say 22. right know i have to telnet them manually from DOS prompt and if it is successful then isay it is connected. Also to check Database connectivity I am using tnsping From DOS prompt.... (3 Replies)
Discussion started by: kukretiabhi13
3 Replies
Login or Register to Ask a Question
cmscancl(1m)															      cmscancl(1m)

NAME
cmscancl - gather system configuration information from nodes with Serviceguard installed. SYNOPSIS
cmscancl [-n node_name]... [-s|-o output_file] DESCRIPTION
cmscancl is a configuration report and diagnostic tool intended only for use by HP Support Personnel. It gathers system software and hard- ware configuration information from a list of nodes, or from all the nodes in a cluster. The information that this command displays includes LAN device configuration, network status and interfaces, file systems, LVM configuration, link-level connectivity (HPUX only), IPv4/IPv6 connectivity, and the data from the binary cluster configuration file. This command can be used as a troubleshooting tool or as a data collection tool. This command is a Perl script which gathers system configuration information by executing various OS commands or tools. It uses the cmexec command to gather information from remote nodes. The -n option can be used to specify a list of nodes to be scanned, the nodes to be scanned do not need to be a member of a cluster. If the -n option is not specified, it will scan all the nodes in the local cluster. By default, the output of this command will go to the file /tmp/scancl.out. If the file /tmp/scancl.out already exists, the old file will be saved in /tmp/scancl.out.old. The -o option can be used to redirect output to a specified output file. If the -o option is not specified, output will go to the default output file /tmp/scancl.out. The -s option can be used to direct all output to the screen, instead of to an output file. Options cmscancl supports the following options: -n node_name... Specify the node(s) to be scanned. If this option is not specified and there is a cluster configured, all the nodes in the cluster will be scanned. If this option is not specified and there is no cluster configured, only the local node will be scanned. -o output_file Write configuration information to a specified output file. If this option is not specified, the information will be directed to stdout. -s Display the configuration information to the screen only. This option cannot be used in conjunction with the -o option. The output from this command contains the following information: LAN device configuration (On HP-UX, output from lanscan; On Linux, output from ifconfig) network status and interfaces (output from netstat) file systems (output from mount) LVM configuration (contents of /etc/lvmtab file) LVM physical vg information (contents of /etc/lvmpvg file) link-level connectivity (HP-UX only) (output from linkloop) IPv4/IPv6 connectivity (results from ping (and ping6 on Linux)) binary configuration file data (output from cmviewconf) RETURN VALUE
cmscancl returns the following value: 0 Successful completion. 1 Command failed. EXAMPLES
To gather the configuration information from node1 and node2 and to save the output in file /tmp/scancl.log: cmscancl -n node1 -n node2 -o /tmp/myscancl.log To gather the configuration information from all the nodes in the cluster and save the output to the file: /tmp/scancl.log: cmscancl -o /tmp/myscancl.log To gather the configuration information from all the nodes in the cluster and display the output on the screen: cmscancl -s To gather the configuration information from all the nodes in the cluster and save the output to the file /tmp/scancl.out: cmscancl AUTHOR
cmscancl was developed by HP. SEE ALSO
Linux: cmviewcl(1), mount(8), netstat(8), ping(8), ping6(8) HP-UX: cmviewcl(1m), lanscan(1m), linkloop(1m), mount(1m), netstat(1), ping(1m) Requires Optional Serviceguard Software cmscancl(1m)