HDTenEightyP/NetNews huggingface dataset:
From: esh@prague.tss.com (Edward S. Hirgelt)
Subject: Re: Troubleshooting Guide?  Was-Re: Recovering from a log segment full condition
Organization: Teknekron Software Systems, Inc.
Date: Mon, 21 Dec 1992 21:16:01 GMT


[With respect to the Sybase Troubleshooting Guide G. Philippe Menos asks]

Gerard> Can you tell me where I can obtain this Guide, please?  I can use any  
Gerard> help I can get...

It is a standard Sybase doc with ID 35900-01-0100-02. My version is
dated May 1, 1992 for release 4.0 and above.

Definitely a good thing to get. You should be able to order it from
Sybase like any other documentation.

Good luck,
Ed
--
Ex vitio alterius	|Ed Hirgelt			|esh@tss.com
sapiens emendat suum.	|Teknekron Software Systems, Inc|
(Publilius Syrus)	|Palo Alto, Ca.			|
Newsgroups: comp.databases.sybase
From: caw@gtech.com (Christopher A. White)
Subject: Re: Recovering from a log segment full condition
Organization: GTECH Corporation, West Greenwich, RI
Date: Mon, 21 Dec 1992 22:36:20 GMT

In article <dave.724703604@rincon> dave@ema.rockwell.com (Dave Emde) writes:
>In <1992Dec16.205611.19776@spectrum.xerox.com> sauvain@fandango.wrc.xerox.com (Richard Sauvain) writes:
>I've had the same problem myself.  Using dump tran database with no_log
>works will but there have been several instances where I dumped my transaction
>log only to find that I still received the "out of space in syslogs" message.
>
>In this case you need to shutdown and restart the server and then issue
>another dump with no_log.  This fixed my problem. If you have the Sybase
>Troubleshooting Guide they have a good writeup about this type of problem. 

Do NOT do this if master or model is full. The server cannot restart if the
log segment of one of these two is full. We've never had a problem dumping
them with 'no_log' however.

Topher
-- 
 Christopher A. White                    | "Perfection is not optional."
 caw@gtech.com                           | 
 GTech Corporation, West Greenwich, RI   | from: Rules for sociopathic
 The opinions expressed are mine alone   |       obsessive-compulsives
Newsgroups: comp.databases.sybase
From: jay@trdlnk.uucp (Jay Twery)
Subject: recovery time at start up
Organization: TradeLink Corp.
Date: Mon, 28 Dec 1992 18:16:41 GMT

I don't understand the following, we are using
ver. 4.8 on a Sparc platform with around 2GB of data, with
disk mirroring turned on.

After a recent (clean) shutdown of the server, it took
50 minutes for the server to start up. The entire
time the log  said recovering database xxx.

Why should it take any time to restart after a normal 
shutdown? Is the disk mirroring causing a problem?
Tech support said it could take 2 hours to recover the
database, even though it shutdown with no errors.
Does this make any sense?
We never experienced this befor 4.8, but we also were
not doing any disk mirroring.

Thanks in advance.

Jay 
---------------------------------------------------------------------
        Jay Twery                             Tradelink Corporation
Phone:  (312)408-2595                         175 W. Jackson Blvd.
Fax:    (312)939-2531                         Suite A1235
Usenet: trdlnk!jay@uunet.UU.NET               Chicago, IL  60604
        or {tellab5,nuscrl}!vpnet!trdlnk!jay
From: dil.admin@mhs.unc.edu (Dave Laudicina)
Newsgroups: comp.databases.sybase
Subject: re: MSW Excel to Sybase  over TCP/IP ?
Date: 22 Dec 92 16:23:07 GMT
Organization: UNC Office of Information Technology

>Are there products allowing the access of Unix Sybase 
>servers from Excel for Windows over TCP/IP.
>
>Thanks
>-Florian
>
Excel 4.0 includes Q+E which I believe comes with drivers for Sybase SQL
Server. I think these drivers would work with Unix SQL servers. Have never
done it but is in documentation.
 Dave L
Newsgroups: comp.databases.sybase
From: achafir@misha (Alex Chafir)
Subject: DUMP DATABASE ... - to Exabyte tapedrive ???
Keywords: dump.database
Organization: First National Bank Of Chicago, Chicago IL, USA
Date: Tue, 22 Dec 92 15:20:55 GMT

What is the optimal way to backup a large number of databases having  
Exabyte tapedrive with about 20 GB capacity tape cartriges?

It seems to me kind of stupid to dump each database (average size is 40  
MB) to a separate tape, and as I understand DUMP DATABASE ... statement
doesn't support multiple dumps on the same tape???

Alex Chafir,
Technology and Develoopment,
First National Bank of Chicago
Newsgroups: comp.databases.sybase
From: 0000c0813440@dkfz-heidelberg.de (mbppc2)
Subject: Re: DUMP DATABASE ... - to Exabyte tapedrive ???
Keywords: dump.database
Organization: DKFZ
Date: Wed, 23 Dec 1992 13:04:50 GMT

In article <1992Dec22.152055.26590@fnbc.com> achafir@misha (Alex Chafir) writes:

>What is the optimal way to backup a large number of databases having  
>Exabyte tapedrive with about 20 GB capacity tape cartriges?
                              ^^^^^-- our's does 2GB only
>It seems to me kind of stupid to dump each database (average size is 40  
>MB) to a separate tape, and as I understand DUMP DATABASE ... statement
>doesn't support multiple dumps on the same tape???

I did not try multiple Sybase dumps to tape, but I backup a set of
workstations automatically: just use /dev/nrst0 instead of /dev/rst0
(on a SUN) as the tape device name. the nrst0 does no rewind after
the operation, so you should be able to put dumpfile after dump file.
use the "mt -f /dev/nrst0 sta" to check. Or write your databases to
files and put them those on tape

Detlef Wolf  dok256@cvx12.inet.dkfz-heidelberg.de
Detlef Wolf: dok256@cvx12.inet.dkfz-heidelberg.de
From: dshapiro@apple.com (David Shapiro)
Newsgroups: comp.databases.sybase
Subject: Re: MSW Excel to Sybase  over TCP/IP ?
Date: 22 Dec 92 21:27:05 GMT
Followup-To: comp.databases.sybase
Organization: Apple Computer, Inc.

> >Are there products allowing the access of Unix Sybase 
> >servers from Excel for Windows over TCP/IP.
> >
> >Thanks
> >-Florian

This doesn't exactly match your question but...

From a Macintosh, you can certainly use DAL (Data Access Language), which
MS Excel has well integrated into the database functions of the
spreadsheet. The DAL extensions can be defined to work over IP,
Asynchronous, or AppleTalk network protocol. I'm not sure if all this is
supported for Windows. You have to purchase a DAL server for Sybase, for
your Unix box, but the DAL extensions on the Mac side are free from Apple
and Microsoft. You can build some very cool
interfaces using Excel; for example I've got a spreadsheet which queries
the database every three minutes to give me a list of users, and in another
window, charts the cpu, io and user totals in a nice 3-D graph. You can add
hightlighting to that which can show blocking users, cpu hogs, etc. 

Dave Shapiro
Apple Computer, Inc.

[The usual disclaimers]
Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Exact form of data flow to Sybase engine
Organization: Lehman Brothers
	<WFINNERT.92Dec7183609@larry.shearson.com>
	<MGK.92Dec15093033@cedar.sql.sybase.com>
Date: Mon, 21 Dec 1992 18:29:26 GMT

>In article <MGK.92Dec15093033@cedar.sql.sybase.com> mgk@sql.sybase.com (Michael Keirnan aka Joe Cool) writes:

>   wfinnert@shearson.com:
>   >TDS ( Tabular Data Stream ) is not used for either the BCP interface or the RCP 
>   >interface ( more important ). In a normal network environ SYBASE *cannot* put a

>   Sorry for what might sound like a nit here Warren, but Tabular Data
>   Stream (TDS) is in fact used for both Bulk Copy (BCP) and Remote
>   Procedure Calls (RPCs). TDS is the protocol that Clients and Servers
>   speak. It supports binary data. TDS is not somehow tied to dbcmd() and
>   ASCII language batches in particular, although I understand now how
>   that perception could arise.

I stand corrected Mike ( Oooh how I *hate* being wrong ). Kind of funny
"tabular" data stream supporting binary data.
--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
 
Newsgroups: comp.databases.sybase
From: esh@prague.tss.com (Edward S. Hirgelt)
Subject: NULLs revisited
Organization: Teknekron Software Systems, Inc.
Distribution: comp
Date: Wed, 23 Dec 1992 18:31:58 GMT

In rticle <ESH.92Dec15103611@prague.tss.com>, I wrote

Edward> You can't change the definition of the table to prohibit nulls once
Edward> you've defined it to permit them. You can, however, do one of two
Edward> things:
Edward>
Edward> 1. Create a rule for the particular column that forbids nulls.

It was gently pointed out to me (thanks Robert and Lisa of Sybase) that
I am living in the past.

If the value of a column is NULL, it is not tested against its rule.

I knew this at one time (having worked on duplicating the behavior in
APT), but I forgot.

In short, NULL values do not fire rules. Triggers are still fired of
course and remain the definitive way to ensure an altered column is not
null. 

Hope this clarifies the problem without muddying it even more. I feel
somewhat obfuscatory today -- too close to that December holiday I guess.

Ed
--
Ex vitio alterius	|Ed Hirgelt			|esh@tss.com
sapiens emendat suum.	|Teknekron Software Systems, Inc|
(Publilius Syrus)	|Palo Alto, Ca.			|
Newsgroups: comp.databases.sybase
From: crews@panix.com (Bill Crews)
Subject: Rdb-to-Sybase conversion
Summary: Request tool or method for conversion from Rdb to Sybase
Date: Wed, 23 Dec 1992 20:12:50 GMT
Organization: PANIX Public Access Unix, NYC
Keywords: conversion Rdb Sybase

My company is using Rdb/VMS now, and we want to move to Sybase.
To do this, we must convert the schema from Rdb to Sybase and
move all the data.

I understand that simple export/import will not work for this.

	Is this true?  If so, what tools or facilities are
	there that will assist in getting this done?

Also, much of our code is in C with embedded ANSI SQL.  I know that
many Sybase installations use stored procedures instead of embedded
SQL.  My questions are:

	Does C with embedded SQL work in Sybase?  Do I need
	separately bundled components of Sybase to do that
	(precompiler, ...)?  How fast and reliable is it?
	If it doesn't work, are there tools to assist in
	converting C with embedded ANSI SQL to Sybase stored
	procedures?

-Irina
-- 
----------------------------------------------------
Bill Crews  |  crews@panix.com  |  New York, NY, USA
Newsgroups: comp.databases.sybase
From: mneer@mbsdev8.shearson.com (Marc Neer)
Subject: Re: Can SYBASE Server listen on two ethernet interfaces?
Keywords: SYBASE server ethernet interfaces subnets
Organization: Shearson Lehman Brothers
Date: Mon, 28 Dec 1992 14:40:15 GMT

In article <1992Dec25.014046.6506@sol.UVic.CA>, justice@dao.nrc.ca (Gerald Justice) writes:
|> We have two ethernet interfaces on our SS2 server and we would like to have
|> clients on both of the attached subnets be able to connect to the "direct"
|> interface rather than be routed through another sun server to get to the
|> SS2's primary ethernet interface.   For more remote clients we still want to
|> avoid the extra hop by going to the closest interface.  But apparently the
|> Sybase server only listens on one interface.  A call to Tech Support
|> seems to confirm this but it was not at all apparent that the person I
|> spoke really even understood what I wanted to do.  By the way this is not
|> a performance issue so much as a reliability issue, we don't want the
|> remote sites to have to depend on the third-party server having to be up just
|> to route the packets to the second sub-net.  If we turn it around then it
|> becomes a performance issue because we will be moving our local traffic which
|> is much more significant through this third-party server and that would be 
|> unacceptable.  We could reconfigure the topology so that the local traffic
|> and remote traffic appear on the same sub-net but it seemed so simple to
|> have two interfaces and after all whoever heard of a network application
|> which cared what interface the connections were arriving on?
|> ---
|> Gerald Justice
|> Unix Systems (and Sybase) Manager
|> Phone:     (604) 363-0055  PDT      Fax:    (604) 363-0045    Telex:  049-7295 
|> Internet:  justice@dao.nrc.ca       Mail:   Dominion Astrophysical Observatory 
|>                                             National Research Council (Canada) 
|> BITNET:    justice@nrcdao                   5071 W. Saanich Road 
|>                                             Victoria, B.C.   CANADA  V8X 4M6
|> 

It is possible for the dataserver to listen on more than one port.  This is
accomplished by setting the hostname to 'nullhost' for the master device.  Leave
the other devices, query, console, etc., to the obvious hostname.

e.g.

#
SYBASE
	query tcp sun-ether host1 5000
	master tcp sun-ether nullhost 5000
	console tcp sun-ether host1 5000

This will cause the server to listen to all incoming traffic.  Of course,
this to open up security issues accross a WAN.  Have fun.

mdn
Newsgroups: comp.databases.sybase
From: bml@athena.mit.edu (Larry J Lennhoff)
Subject: Please explain Sybase locking strategy
Keywords: Sybase locking page 
Organization: Steelypips Software
Date: Tue, 22 Dec 1992 20:36:02 GMT

Can anyone recommend a book, white paper or article that goes into
reasonable depth concerning Sybase's locking strategy?  I understand
that 'page level' rather than 'row level' locking is used.  I don't
understand why.  Neither do I really feel as though I know when sybase
chooses to lock something and why. If you are in isql and you issue a 
select without a begin transaction, is anything locked?  Or is nothing 
locked til an update or delete statement?  When are locks released?  


             Thanks


                 Larry J Lennhoff
Chosiad's Law: The sooner a project gets behind schedule the more time
there is to catch up.
Newsgroups: comp.databases.sybase
From: jbaron@higgs.ssc.gov (Jeff Baron)
Subject: Re: Recovering from a log segment full condition
Reply-To: jbaron@higgs.ssc.gov (Jeff Baron)
Organization: Superconducting Super Collider Lab
Date: Tue, 22 Dec 1992 17:36:34 GMT

Warren Finnerty writes:
- 
- Strange that model being full would be a problem.
- ( I'll take your word for it. :) )
- Do any of you SYBASE types want to confess to what futz'ing around in model 
- goes on in conjunction with createing objects in tempdb. ( Not at startup )

This has happened to me as well.  At an old job, they have a very
small Sybase setup.  One day, almost 18 months after I had left,
they called with a very strange problem; turned out the the 
transaction log allocated to model (ie. the entire space) had
filled.

There is one piece of information that *is* kept in model; perhaps
it is a duplicate pointer to other transaction logs, or something of
a like systemish nature.  It does change, and the transaction log
*will* fill eventually.  (This was server version 4.0 or somesuch.)

Take a look at yours today!

--
Jeff Baron
jbaron@gauss.ssc.gov
Newsgroups: comp.databases.sybase
From: dmathews@lookout.it.uswc.uswest.com (Daniel Mathews)
Subject: Problem printing reports 
Organization: US WEST Information Technologies
Date: Mon, 21 Dec 1992 20:10:58 GMT

I have a problem sending reports to a printer.  I have been creating reports using dwb 5.0 on an HP 710 server with 64Mb RAM running HP-UX 8.07.  I can send SQL queries directly to a printer, I can generate report writer reports to a file then print them, and I can generate report writer reports to the screen and print them out 1 page at a time, but if I try to send the report writer reports directly to the printer, the system hangs.

I have tried running the reports from the command line using runrw; this works when I let the report print to screen, but if I try to send it to the printer I get a 'Memory Fault'.

If anyone could shed some light on this problem, please let me know.  I've been working with Sybase tech support on this one, but we're stumped.

Thanx.    
-- 
Dan Mathews

Work :	(303) 595-2913	1475 Lawrence St., Suite 500, Denver, CO 80202
Mail :	dmathews@da_vinci.it.uswc.uswest.com
Newsgroups: comp.databases.sybase
From: bmyers@fmrco.COM (Brad Myers)
Subject: Re: large database backups
Organization: Fidelity Management and Research Co., Boston, MA
Date: Mon, 21 Dec 1992 22:04:10 GMT

In article <1992Dec15.095007.6856@ericsson.se> etxwarz@garbo.ericsson.se writes:
>
>I have received some information about a product called 'Quick Dump'. 
>In the advertise they are claiming that it can do:
>- Database compression
>- Short run time
>..and more...
>- Backup transfer to multiple tapes
>
>I haven't used the product but if someone out there uses it, please post some
>comments about it.
>

I have not used the product itself, but I know someone who helped to write it,
and he said that "It corrupted every database we tried it on."  This was for
the beta version; it may (or may not) have been fixed since then.

>
>The company address:
>AFIC Computers, Inc
>14 East 4th Street, Suite 608
>New York, New York 10012
>TEL: 212-673-6575
>FAX: 212-533-5982
>
>------------------------------------------------------------------------------
>Goran Schwarz                      ,,,       Ericsson Telecom AB  TN/ETX/TX/DF
>etxwarz@garbo.ericsson.se         (.~.)                phone: +46 (0)8 7193916
>------------------------------oOO--(_)--OOo-----------------------------------

I had the fortune (?) to work for this company for a total of two (2) days, 
but did not continue because of contractual disagreements.  This may somewhat
bias my opinion against them, so take that into account.

I found their development practices to be somewhat less than ideal.  Several
people I know in the Sybase community have voiced the opinion that their 
software is not very good, and that they tend to "gamma test" their "production"
releases.  (In other words, the software is released containing known fatal
bugs).

I do know that their "business" office is a rented condo.  Not that that should
be held against them, by any means.

--Brad.		Mele Kikkimalaka!

-- 
 Bradley Myers                                  | "Why me, John Big Boote?"
 bmyers@fmrco.com                               | "It might be booby-trapped"
 Fidelity Investments, Boston, MA               | "Oh. Okay"
 The opinions expressed don't belong to anybody |     -- TAoBBat8D
Newsgroups: comp.databases.sybase
From: afh@ornl.gov (HUNTLEY JR A F)
Subject: Sybase User Group
Keywords: user group, membership
Organization: Oak Ridge National Laboratory
Distribution: comp.databases.sybase
Date: Mon, 28 Dec 1992 17:39:12 GMT

The Sybase International User Group began charging an annual
membership fee of $95.00 in March 1992.  This has been publicized
through the User Group Newsletter (Sybase Server) which has in the
past been sent to all Sybase installations.

While some number of memberships have been received, the response
has not been outstanding.  As treasurer of the User Group, I am
interested in Sybase users' opinions on how to increase the number
of paid memberships in this group.  How can the organization better
serve your needs as a Sybase user?  Specifically, are there things
that the User Group should be doing that would make membership more
worthwhile to your organization?

The User Group exists to foster the exchange of information between
Sybase users, as well as information exchange between the User
Group and Sybase, Inc.  The annual Sybase user conference, assistance
in setting up local user groups, the User Group's Sybase enhancement
committee, and the User Group newsletter are some of the means used
in pursuing of this goal.

Are there specific areas of dissatisfaction with the Sybase User Group,
or simply apathy?  Are there additional services or membership benefits
that should be provided?  What can be done to make it worthwhile for
either you personnally or your employer to pay for membership in this
organization?  Are there other means of assessing fees that would make
it easier for employers to pay the membership fees for individuals.

All ideas/opinions/comments/flames appreciated.  Thanks for your input
in helping the User Group to better serve you, the user community.
Email responses are preferred.

Al Huntley
Treasurer, Sybase International User Group
afh@ornl.gov
(615) 576-7170
Newsgroups: comp.databases.sybase
From: dhawk@netcom.com (David Hawkins)
Subject: Re: Troubleshooting Guide? Was-Re: Recovering from a log segment full condition
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Distribution: na
Date: Mon, 21 Dec 1992 18:37:57 GMT

gpmenos@firestone.Princeton.EDU (Gerard Philippe Menos) writes:

>> If you have the Sybase Troubleshooting Guide they have a good writeup...

>Can you tell me where I can obtain this Guide, please?  I can use any  
>help I can get...

A copy is mailed to each contact with a Support License when we update
the Guide.  Check with your primary contact.  You can also order extra
copies from Sybase Technical Publications.  Call 1-(800) 685-8225
Product id is 35900, I think.  The next version out in early '93.  Ah,
document id: 35900-01-0100-01

A copy is also available on INSIGHT - the Sybase BBS.  1-510-601-4991

later, david
--
David Hawkins    dhawk@netcom.com    dhawk@sybase.com
Unfortunately, nothing in life is nothing but; it always something
more.  -- William Barrett
Newsgroups: comp.databases.sybase
From: kevin@traffic.den.mmc.com (Kevin Rodgers)
Subject: Re: Warning - don't repeat my Open Client/C mistake
Organization: Martin Marietta Western Internal Systems, Technical Operations
Date: Wed, 23 Dec 1992 19:22:09 GMT

In article <1992Dec23.002016.26975@mcm.com> wall@mcm.com (Steve Wall) writes:
>The problem is that there is a limit of 16 (my experience - the
>4.6 Open Client/C doc dated 8/92 [page 2-99] says 8...) arguments
>that can be handed to each call to dbfcmd(). Well, of course I'm
>cruising right along, add a new column to a table, add the column
>to the Open Client/C program, and OOPS! - the new column doesn't
>post correctly (seems to receive \0 values). No warning from dbfcmd()
>or anything (would be nice...if it uses varags(3), it seems like
>it *could* detect and notify when too many args are passed(?)).

If dbfcmd() was implemented with varargs.h/stdarg.h, it wouldn't even
have to be limited to an arbitrary number of arguments.  Hell, it could
just call vprintf() to format the command, and then pass the result to
dbfcmd().

Argh, indeed.
-- 
Kevin Rodgers				kevin@traffic.den.mmc.com
Martin Marietta MS A16401		(303) 790-3971
116 Inverness Dr. East
Englewood CO 80112 USA			GO BUFFS!
Newsgroups: comp.databases.sybase,ne.jobs,misc.jobs.contract,misc.jobs.offered