HDTenEightyP/NetNews huggingface dataset:
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Sybase Data Page Allocation
Organization: Lehman Brothers
Date: Thu, 7 Jan 1993 14:20:37 GMT

In article <1993Jan7.103634.268@vulcan.resmel.bhp.com.au> phil@n6batws1.itwol.bhp.com.au (Phil McMillan) writes:


>   I have a question regarding the allocation of the 2kbyte data pages when they
>   become "reserved" by tables.
>
>   Assume I have a table that typically contains, say, 1000 rows.  If I then for some
>   reason add an extra 30,000 rows I obviously will take more than a few data pages
>   from the pool of storage (and at least 8 of them.)

>   From what I understand, these data pages (for indexes and rows) are now owned,
>   or reserved, by the table.

>   If I delete these 30,000 rows, will/should these data pages become returned to
   the pool?

 
Yes.

If you have a clustered index on the table there should be no problem with
freeing up space. However......
Don't trust sysindexes unless DBCC checktable ( or checkdb ) gets run.
If your deletes remove a percentage of the data from each page, but don't
completely *no* space will be reclaimed because you have not freed 
any pages up. Bottom line: Leave time every month or so to bounce your 
clustered indexes down/up and things will be a lot cooler. 

--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
 
Newsgroups: comp.databases.sybase
From: chow@cssn0b.ssc.gov (Ivan Chow)
Subject: APT bug
Reply-To: chow@cssn0b.ssc.gov
Organization: SSC
Date: Thu, 7 Jan 1993 16:45:58 GMT

Hi,
   I have used APT to develop a database frontend application.
Now, I ported that to the APT version 5.0 (from 4.2) and I
have a problem:
I have a choice field, called rptchoice, on my form.
Now I use APT-SQL to set the choice field to

rptchoice:visible = FALSE

but it does not work -- rptchoice is visible and highlighted. 
(it works fine in version 4.2)
Can someone please help?

Ivan
---------------------------------------------------------
Disclaimer:
I know... I know... I should NOT use APT at all.. at all..
frustrations will keep coming up.....!!!!!!!
Newsgroups: comp.databases.sybase
From: hlam@bnr.ca (Hayward Lam)
Subject: NeXT User Group of Ottawa Meeting on January 7th
Reply-To: hlam@bnr.ca (Hayward Lam)
Organization: Bell-Northern Research Ltd.
Date: Tue, 5 Jan 1993 20:18:41 GMT


NeXT User Group of Ottawa Meeting on January 7th
------------------------------------------------


When : Thursday, 7:00pm
Where: ComputerActive
       21 Antares Dr., Unit 112,
       Ottawa, Ontario, Canada


Topics: 
***  Database on NeXT  ***
Demo and discussion on databases and development tools 
available on NeXT.
Inlcude Parabase, Sybase, Oracle, DBkit, Objective DBtool kit etc.
Topic will be oriented for users and developers alike.
Demo machine is a NeXTcube with NeXTdimension board.

(A guest will talk about their experience with database 
development. Not confirmed yet.)


***  General discussion  ***
CD-ROM drive available for 3.0 upgrade.
Software packages discount for user group members.
NeXTWorld Expo etc.


Please pass the news around to whoever might be interested.
Feel free to contact me if you have any questions.


Regards,
Hayward

phone: 613-763-3663
email: hlam@bnr.ca



Newsgroups: comp.databases.sybase
Newsgroups: comp.databases.sybase
Subject: Win31 only 5 Logins
From: sturgeon_c@eis.dofasco.ca
Date: 5 Jan 93 08:44:06 GMT
Organization: Dofasco Inc, Hamilton, Ont. Can.
Nntp-Posting-User: sturgeon_c

-- 
Background:
I have downloaded the most recent Winup7.zip from CompuServe!

Dos Clients running Windows 3.1, OS/2 1.3 Server running Version 4.2 of Sybase
Visual Basic front end
User Written DLL routines to access Sybase
using:
	DOS 5.0
	W3DBLIB.DLL
	DBNMP3.DLL
	NETAPI.DLL
	DOSNP
	DBNMPIPE
	User written DLL routines
	Netx
	(these are the most recent and recommended files from Sybase & Novell)

Using Windows to call user written DLL routines.  Any Sybase calls are
done through these DLL routines.

Problem:
Cannot log back into the database after five successful logins.  If Windows is
exited and then re-entered, we can login succussfully another five times before
we cannot do it again.

We are using DBWINEXIT to exit Sybase.  We are running a windows resource
checker and it is indicating that we are getting all of our resources back
after logging out of the database.

We are using these applications in a real-time Steel Mill application.  Any
information on this would be appreciated!

Thanks in advance!!!!!!!!!!!!!!!!!!!
____________________________________________________________________________

Craig Sturgeon
(sturgeon_c@eis.dofasco.ca)

Dofasco Steel Inc.                                          100 Lyons Ave.,
1330 Burlington St. East                                 Brantford, Ontario
Hamilton, Ontario                                           Canada  N3R 4R4
Canada  L8N 3J5
(416) 548-4420
____________________________________________________________________________
Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: KILLed Sybase process will not die?
Organization: Lehman Brothers
Date: Wed, 6 Jan 1993 18:35:47 GMT


KILL appears only to take effect when the process goes into a "runnable" 
state ( At which time it prob. checks some status area ). This explains
the behavior that you are seeing in that the DBCC will only go out of 
"sleeping" state after a long time. Processes that have altered data
will need to undo what they have done first or very bad things would happen.

 



--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
 
Newsgroups: comp.databases.sybase
From: chandra@xenon.nabu.sni.ca (Chandra Sekar)
Subject: how poratble is embedded SQL across ORACLE, SYBASE, INGRES?
Reply-To: chandra@xenon.nabu.sni.ca (Chandra Sekar)
Organization: Siemens Nixdorf, Sietec Open Systems, Toronto, Canada
Date: Mon, 11 Jan 1993 17:18:28 GMT

I am presently specifying some APIs for an application, designed to run
on multiple databases.

Many of the APIs involve SQL DMA underneath.  I think if I use embedded SQL
and at generate time, use the vendor specific pre-compilers (ex: ORACLE Pro*C)
it can be ported across DBMSs easily. 

But then there are these many 'middleware' products and many vendors like JYACC, 
GUPTA, OMNIS and others offer 'database independent' layered products.

Which way should I go?

Can I use EMbedded SQL in my C APIs? (right now we use informix to test the 
application).  Or do I have to but one of these layered products?

Your comments are welcome.

I shall summarize the comments, for others' benfits.

thank you in advance.

Chandra@sni.ca.
Newsgroups: comp.databases.sybase
From: fosli@ifi.uio.no (\ystein Fosli)
Subject: Charging users running SYBASE
Organization: Dept. of Informatics, University of Oslo, Norway
Date: Tue, 12 Jan 1993 18:09:47 GMT
Originator: fosli@gampen.ifi.uio.no

Is there anyone who know anything about accounting of
SYBASE usage? Is there any products around, commercial or free?
Is there any suggested methods? Does it slow down the Sybase server
badly?

Any Help would be GREATLY APPRECIATED!
--

-----
Oystein Fosli	       			Phone:	   +472  441988        
Open Systems Consultants a.s            Fax:	   +472  441988             
Prinsessealleen 21               	Email: fosli@ifi.uio.no 
0275 OSLO               	        
Norway
From: solar@fsrg.fsrg.bear.com (William del Solar)
Newsgroups: comp.databases.sybase
Subject: Re: Using Views for data presentation
Keywords: name, spelling
Date: 4 Jan 93 22:53:31 GMT
Organization: Bear Stearns & Company, New York, NY

In article <wolfgang.726176551@sfu.ca> wolfgang@fraser.sfu.ca (Wolfgang Richter) writes:
><IDAZS@ASUACAD.BITNET> writes:

>>First and last names are stored in separate fields in upper
>>case. We have been partially successful in combining them to display
>>in upper-lower case, using "substring" and "rtrim" functions. Names
>>that have spaces or dashes, like "James Mc donald" or
>>"Carol Terry-peplow" have been a problem....

By storing names in upper case only, you are losing information that
must later be either derived or even manufactured:

How will you correctly spell names such as da Vinci, van Beethoven,
ter Horst, von Krupp, della Robbia, and del Solar?

If the spelling has been Americanized, how will you correctly spell
names such as DellAquila, Deluca, DeSaro, or Delvalle?  From the last
four names, it is not possible to derive a rule to spell the name correctly.

The only solution that will satisfy both the folks who have Americanized
the spelling of their names and those who haven't is to store names in
both upper an lower case.

Wm del Solar
____________________________________________________________________________
My opinions are not my employer's opinions:  I do not speak for my employer.
Newsgroups: comp.databases.sybase
Subject: Sybase Data Page Allocation
From: phil@n6batws1.itwol.bhp.com.au (Phil McMillan)
Date: 7 Jan 93 10:36:33 +1000
Distribution: world
Organization: BHP Steel - Slab and Plate Products Division - Port Kembla AUSTRALIA

I have a question regarding the allocation of the 2kbyte data pages when they
become "reserved" by tables.

Assume I have a table that typically contains, say, 1000 rows.  If I then for some
reason add an extra 30,000 rows I obviously will take more than a few data pages
from the pool of storage (and at least 8 of them.)

From what I understand, these data pages (for indexes and rows) are now owned,
or reserved, by the table.

If I delete these 30,000 rows, will/should these data pages become returned to
the pool?

The reason I ask this is because some of my tables have far more reserved space
than what is currently needed for the data and indexes, far more than 
the 16kbyte page allocation increment. We use SYBASE in a production environment
and we need to be able to predict how SYBASE will behave in exceptional 
circumstances, hence my interest in how the page allocation mechanism works.

-- 
   /\/\     :  Phil McMillan - Electrical / Software Engineer 
  / / /\    :  Engineering Technology Department
 / / /  \   :  BHP Steel - Slab and Plate Products Division
/ / / /\ \  :  P.O. Box 1854 Wollongong NSW 2500 AUSTRALIA
\ \/ / / /  :  Phone    +61-42-75-3839
 \  / / /   :  Fax      +61-42-75-7897 
  \/\/\/    :  E-mail   phil@n6batws1.itwol.bhp.com.au


Newsgroups: comp.databases.sybase
From: jja@fnbc.com (Joseph Alotta)
Subject: Re: KILLed Sybase process will not die?
Keywords: kill,sybase
Organization: First National Bank Of Chicago, Chicago IL, USA
Date: Fri, 8 Jan 93 15:24:25 GMT

In article <1993Jan5.192546.8743@mcm.com> wall@mcm.com (Steve Wall)  
writes:
> Several times I've wanted to KILL a Sybase process with the
> equivalent of the UNIX kill -9 (die NOW!, no sig catch, etc.).
> Sybase gives you KILL, but under certain circumstance, the kill
> doesn't seem to take effect until some kind of variable delay


i just press that little button with the vertical line and the
circle and it works every time.  

joe.


--
==============================================================
! joe alotta                                    jja@fnbc.com !                                               
!                                             (312) 732-3439 !
!                                                            !
! "The main thing is to keep the main thing the main thing." !
! Dr. George Sweeney                                         !
==============================================================
From: yangying@ces.cwru.edu (Ying Yang)
Newsgroups: comp.databases.sybase
Subject: Re: KILLed Sybase process will not die?
Date: 6 Jan 93 02:03:36 GMT
Organization: Agency Rent-A-Car, Cleveland, OH
NNTP-Posting-Host: easy.ces.cwru.edu

In article <1993Jan5.192546.8743@mcm.com> wall@mcm.com (Steve Wall) writes:
>Several times I've wanted to KILL a Sybase process with the
>equivalent of the UNIX kill -9 (die NOW!, no sig catch, etc.).
>Sybase gives you KILL, but under certain circumstance, the kill
>doesn't seem to take effect until some kind of variable delay
>(seems to be dependent on the type of process). Probably due
>to the Sybase kernel scheduler, resources in use by the proc,
>process run state (blocked or not), etc.
>
>For instance, this morning I have a DBCC process that is running
>later than usual due to delays up the pipeline (yes, I'm aware
>that DBCC in multiuser is not technically correct, and we interpret
>the results with this in mind), And now the DBCC is hogging the
>Server when people are trying to perform typical, daily queries.
>Thus, I want to KILL it since it is not mandatory that we get
>DBCC results every day.
>
>[Actually, the DBCC (spid=1) is blocking all my users due to locking
>on sysobjects (DBCC has a shared page lock on sysobjects
>page 2, my other proc (spid=10) is trying to get an Ex-table on
>sysobjects - see below). Why is DBCC locking sysobjects for so long?]
>



When we kill a Sybase process, we may get (at least) four different
results :

1. The process is a ordinary retrieve transaction, i.e. SELECT, it
dies immediately.

2. The process is an update transaction, it does not die until the
server has rolled back the transaction. The time is directly related to
the size of transaction.

3. The process is a DBCC transaction. Sybase forks a separate process
for the transaction, and the new one is out of users' control. I have
experience to check multi-million row tables(with checktable option).
DBCC checks the tables index by index, we can only kill it when it
finishes one index and ready for the next one. It may take amywhere
from several minutes to four hours to die.  In your case, it seems you
were running checkallec or checkdb, so the process held locks on the
sysobjects, and you could not control the "ghost" Sybase process.


4. The process is sleeping. We cannot kill a sleeping process. When an
end-user process gets disconnected, we cannot kill the Sybase process
and release the locks.  To deal with this, we have installed a EBF to
kill disconnected processes when our clients turn off their PCs.  At
last year's User Conference, Sybase said the 5.0 version would provide
unconditional KILL, hope this is true.



Ying Yang

MIS 
Agency Rent-A-Car
 
Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Moving Sybase from one server to another
Organization: Lehman Brothers
Date: Fri, 8 Jan 1993 16:40:43 GMT

In article <27695@sybase.sybase.com> ben@sybase.com (Benjamin von Ullrich) writes:

> move your databases according to their current layouts in size and number of
> framgements, and extend them after everything is moved.  the new devices the
> segments are on may be of any total size and configuration, only the databases
> need to be laid out in x chunks, each of a particular size, and as data, log,
> or data & log.  in technical terms, the sysusages rows for the old and new
                                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> servers must be the same.  but the new devices may be much bigger in capacity,
  ^^^^^^^^^^^^^^^^^^^^^^^^
> if that is what your new machine affords you, and you may ALTER the databases
> after all has been moved, and presumably when you need the space.  personally,
> i never give a database more space unless it needs it, as once it's given,
> that's it -- no shrinking!  you may find that some other database (or a new
> one) will need the space you just gave away to a database that wasn't hurting..

  This is not quite true. As in this example:

  BEFORE

  10 MB data
  10 MB log
  20 MB data
  20 MB data
  20 MB data

  AFTER

  10 MB data
  10 MB data
  60 MB data

  There are not even the same number of rows in sysusages 
  in the AFTER case. I recomend writing/buying/finding a 
  schema extractor and using it with bcp -n. Eventually the
  DATA/LOG/DATA/LOG/DATA..... will prove to be a major pain.
  bcp will also defragment ( leave only clustered index up,
  batch size of 1000, truncate log on checkpoint, load the
  all data, bring up nonclustered, update stats on clustered, 
  shut off truncate log )


  
--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
 
Newsgroups: comp.databases.sybase
From: rob@fosters.med.utah.edu (Rob Sargent)
Subject: Max IN clause
Organization: University of Utah
Distribution: comp.database.sybase
Date: 5 Jan 93 11:52:02


Has anyone seen any doc on How large the IN () clause can be if stack with constants.

We may want to stick a large number of ints in parens to avoid a
joint. Upper bound = query_buf size?

Thanks,
rjs

--
Rob Sargent                      s-mail: Dept. of Human Genetics    
e-mail: rob@fosters.med.utah.edu         U. of Utah Medical School     
				         Eccles Genetics Bldg
				         Salt Lake City, Utah  84112

Newsgroups: comp.databases.sybase
From: "John Salter"  <salter@magnus.acs.ohio-state.edu>
Subject: Explicitly lock table
Organization: The Ohio State University
X-Nupop-Charset: English
Date: Tue, 5 Jan 1993 14:57:07 GMT


Is is possible to explicitly lock a table in Sybase to prevent
other users from inserting into table for a very short time?  If
so, how is it done?  Thanks.
From: wolfgang@fraser.sfu.ca (Wolfgang Richter)
Newsgroups: comp.databases.sybase
Subject: Re: Max IN clause
Date: 6 Jan 93 18:38:21 GMT
Distribution: comp.database.sybase
Organization: Simon Fraser University, Burnaby, B.C., Canada

rob@fosters.med.utah.edu (Rob Sargent) writes:


>Has anyone seen any doc on How large the IN () clause can be if stack with constants.

>We may want to stick a large number of ints in parens to avoid a
>joint. Upper bound = query_buf size?

>Thanks,
>rjs

>--
>Rob Sargent                      s-mail: Dept. of Human Genetics    
>e-mail: rob@fosters.med.utah.edu         U. of Utah Medical School     
>				         Eccles Genetics Bldg
>				         Salt Lake City, Utah  84112

Correct me if I'm wrong, but doesn't Sybase convert an expression with
IN to a JOIN behind the scenes before executing the query? So you will
not really be avoiding a JOIN.
-- 
-- Wolfgang Richter (e-mail: wolfgang@sfu.ca)
-- Academic Computing Services
-- Simon Fraser University
-- Burnaby, B.C.
-- Canada V5A 1S6
-- Phone: 604-291-4449
Newsgroups: comp.databases.sybase
From: justice@dao.nrc.ca (Gerald Justice,P=363-0055,R=152A)
Subject: Re: Ethernet and Token Ring
Summary: SHOULD WORK
Reply-To: justice@dao.nrc.ca
Organization: DAO/CADC .
Date: Fri, 8 Jan 93 02:10:09 GMT

In article 15876@odin.corp.sgi.com, dptom@powerplay.asd.sgi.com (Tom Arnold) writes:
> The SQL server will only listen to a single network port. You may be able
> to achieve your desired result by installing an open server on say the
> Token Ring network port and leave the SQL server monitoring the ethernet.
> Unfortunately, this is not a clean solution since the user would have to
> set the value of their DSQUERY environment variable to the correct server
> depending on the network that they're on. 

This is not true, we have our server listening on two ethernets and it should be
possible to support any number and type of network interfaces if the OS supports 
them.  The key is in the master lines in the interfaces file.  I just posted
a note about this seconds ago.

---

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

Newsgroups: comp.databases.sybase
From: dave@exlog.com (Dave St.Clair)
Subject: Using Sybase with PPP (dp2.2) on Solaris 1.1.
Reply-To: dave@exlog.com
Organization: EXLOG, Inc.
Date: Mon, 11 Jan 93 20:08:46 GMT

Well this should have been simple but .... :-)

Ok, we have the need to connect two machines/networks over a WAN and would
like to be about to access our Sybase 4.8 database.  Since this WAN is over
standard phone lines (not leased lines), I looked for a version of PPP that
would do dialup-on-demand.  I found Kirk Smith's dp2.2 by checking the
comp.prototocols.ppp FAQ.

I setup two SparcStations with MultiTech MultiModems to test things.  First
I verified that Sybase worked OK with a normal (le0) ethernet connection.
Worked just fine. Next I installed PPP, unplugged the thin net and turned
on the modems.  Talk about simple!  Had the serial link up and going inside
of an hour (had to take into account silly setup errors :-)).

First I checked the basics: rlogin, telnet, ftp, mail, ping, etc.  No problem.
Works like charm.  Now I give Sybase a try.  And here's the results:

	./isql
	Password: 
	Operating-system error:
        	Connection refused
	DB-LIBRARY error:
        	Unable to connect: SQL Server is unavailable or does not exist.


I checked for user permissions, etc,  but to no avail.

Any hints?

I've been talking to Sybase support but most of the people I've talked to
have not even heard of PPP.  In the latest round, my contact said Sybase
did not have the resources to "support" another third party product. But she
said she would try one more time to find someone in Sybase who could at
least spell PPP :-)

Thanks,

dave@exlog.com




Newsgroups: comp.databases.sybase
From: fgreco@shearson.com (Frank Greco)
Subject: SUMMARY - Notifying clients of table mods
Organization: Lehman Brothers
Date: Thu, 7 Jan 1993 14:52:00 GMT

	Thanks for the many, many responses everyone.  Here's my
	original post:

>I have a potential appliation where I would like to notify distributed
>client processes (LAN) that a table(s) was modified in a Sybase database.
>
>I'd like to not use OpenClient at this point if at all possible.
>
>My initial thought is to write a master process that polls a
>"modifications" table (perhaps created via trigger(s)) that tracks what
>was modified and then looking up in a "subscriber" table to see who to
>notify.  Then, if needed, send some data via a socket (I'm assuming all
>SPARC machines) to the appropriate subscribers.
>
>Another thought would be to front-end all the queries and, upon
>successful table modification, directly notify any clients (again
>through sockets).  This alternative would seem to have performance
>ramifications.
>
>I'd appreciate any comments that any of you might have,

	The overwhelming number of folks said to use OpenServer (my
	post was faulty in that I said I'd rather not use "OpenClient";
	I meant "OpenServer").  Many others (correctly) told me that
	Sybase cannot call routines in your pgm directly.

	While you cannot directly have a trigger invoke a routine
	(unfortunately) in your application via Sybase [I believe
	Interbase can do this], you can setup a trigger quite easily to
	call OpenServer via an RPC.  From there all clients that are
	registered to be interested in this RPC will be notified.

	There are other places in dblib where the dataserver calls your
	own specified routines (e.g., message/error handling); it'd be
	nice if there was some mechanism to allow triggers (and
	alerters ... hint... hint) to do this *directly* in Sybase.

	Since I really didn't want to use OpenServer for this
	particular application for various reasons, I decided on using
	ToolTalk (from Sun) and a little polling program.  Whenever an
	update/delete/insert happens, an entry in written into a
	logtable.  My polling (delay is dynamically set) ToolTalk
	program looks into this table for database activity, and if
	there is any, uses ToolTalk messages to notify interested
	parties via multicasting.  Really wasn't too bad to write; took
	me about 1 week to complete this with a nice API for client
	(ie, "interested") applications.

	Thanks to everyone (I got over 50 responses)!

	Frank G.
--
+-On Assignment at: Lehman Brothers-+-Office: Mercury Technologies, Inc.-+
| World Financial Center, 11th Floor| PO Box 529                         |
| New York City, NY 10285 Desk: 1515| Fanwood, NJ 07023                  |
| email: fgreco@shearson.com        | email: fgreco@mercury.com          |
Newsgroups: comp.databases.sybase