Auto Detection/Restart of Sybase Deadlocks

8 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Howto auto boot SPARC | How to auto supply "start /SYS" and "start /SP/console" commands

When I power ON my T4-1, I got a prompt -> where I have to start /SYS and start /SP/console. How can I auto supply these two commands ?

2. Shell Programming and Scripting

Script to auto restart java for 100 percent

I want the tomcat to restart when java goes 100% cpu utilize and remain on this , Get pid kill and start tomcat . top | grep java We can get pid and cpu utilize , But how can we do on run time. Please use code tags as required by forum rules!

3. Programming

Parallel Processing Detection and Program Return Value Detection

Hey, for the purpose of a research project I need to know if a specific type of parallel processing is being utilized by any user-run programs. Is there a way to detect whether a program either returns a value to another program at the end of execution, or just utilizes any form of parallel...

4. UNIX for Advanced & Expert Users

Opinion on auto-restart of failed apps/services

I'm becoming a dying breed where I work. More and more sys admins are advocating automatically restarting failed services such as tomcat, jboss, etc. I've always been against doing this except with buggy apps that can't be fixed or avoided. My main argument is that I feel it's a trick used by...

5. Shell Programming and Scripting

Auto restart script does not work

I have a service that are not 100% stable and stops from time to time. So I have a script that do restart the service if it does not run. This script works win on Ubuntu 9.04 but will not start the service in Ubuntu 10.10 If I run the part that do starts the service from CLI, it starts...

6. HP-UX

Script to auto restart a service

Hi All, May i please know if it is possible to write a script to check the log messages and automatically restart a service if it is failed or it is stopped. Appreciate your suggestions. Thanks in advance. regards, Eajaz

7. Shell Programming and Scripting

NAT detection

hellou, can anybody help me with nat detection in real time ? i prefer some detection script because i try some nat detection program's for example p0f or i'm using tcpdump, but i would get contain of specific packet. Some ideas?

8. IP Networking

modem detection

How to get information that where is my modem configured in /dev. I have two modems configured in my device .. one is USB and other is PCI modem.. USB is detected as /dev/USB0. but how to see about PCI modem?

LEARN ABOUT DEBIAN

defncopy

defncopy(1)							 FreeTDS Utilities						       defncopy(1)

NAME

       defncopy - extract procedures and views from a Microsoft server.

SYNOPSIS

       defncopy [-U username] [-P password] [-S server] [-D database]
	      [-i input_file] [-o output_file] [-v]
	     [owner.]object_name [[owner.]object_name...]

DESCRIPTION

       defncopy is a utility program distributed with FreeTDS. It replaces a similar program of the same name distributed by Sybase.

       defncopy  reads	the  text of a stored procedure or view, and writes a script suitable for recreating the procedure or view. For tables, it
       reads the output of sp_help and constructs a CREATE TABLE statement, complete with CREATE INDEX, too.

OBJECTS

       owner  is optional if you or the database owner is the owner of the procedure/view being copied.

       object_name
	      is the name of the system object you wish to extract.

OPTIONS

       -U username
	      database server login name.

       -P password
	      database server password.

       -S server
	      database server to which to connect.

       -D database
	      database to use. Optional if the procedure/view being extracted is in your default database.

       -i input_file
	      a script to apply to the database. Not currently implemented.

       -o output_file
	      a file to hold the script, defaults to standard output.

       -v     Show version information and copyright notice.

NOTES

       defncopy is a filter; it reads from standard input, writes to standard output, and writes errors to standard error. The -i and  -o  options
       override these, of course.

       defncopy makes use of the db-lib API provided by FreeTDS. This API is of course also available to application developers.

EXIT STATUS

       defncopy exits 0 on success, and >0 if the server cannot process the query.

       defncopy will report any errors returned by the server, but will continue processing.

HISTORY

       defncopy first appeared in FreeTDS 0.63.

AUTHORS

       The defncopy utility was written by James K. Lowden <jklowden@schemamania.org>

BUGS

       Works only with Microsoft servers and ancient Sybase servers.

       Does not create primary keys.

       Many options are defined by Sybase that this version does not implement. Feel free to correct this situation.

       In theory, defncopy could apply/produce DDL for any system object, but at present only tables, procedures and views are supported, and only
       for extraction.

doc								 13 November 2011						       defncopy(1)

Shell Programming and Scripting