Recent content by ghwin

Okay, I've just discovered that the limiting factor is not PNA but my database configuration. So please ignore the above questions. However, if anyone is aware whether or not the PNA has a limitation on packet size, please let us know. Thanks. - Greg

I have an application (Sybase SQL Advantage, a sql client) published using PNA as a command line. I'm trying to start that application (in command line) with a parameter that will use packet size of 8192-bytes to connect to the database. However, it won't start because it complains that the...

Yes, this would be SO VERY useful! Kudos to you if you can provide some FAQs on this. I would definitely contribute where I can. I'm a Sybase guru at heart and slowly making the transition to Oracle. This stuff would definitely be well appreciated. Also of interests are comparing/contrasting...

I forgot to thank everyone for replying to this post. It was very helpful. As it stands, there are no perfect solutions to this problem. The Physical IO field from the system table does not work all the time. I will have to write some sort of monitor tool that checks every few minutes to see...

Hi sybaseguru, Thanks for the tip with the first query (loggedindatetime), but that only works in ASE 12.5. I'm stuck on version 12 and older? How would I do this in the older versions??? As for using physical_io, I've noticed that this may not always work if the resulting queries are...

Was wondering if anyone knew of a way to find out the datetime a user has logged in OR been sitting idle. The environment is ASE 12.0 on AIX. The clients could be web-based or application based. (I know that the right way to do this is using the auto time-out feature of the client applications...

You can't prior to version 11.9.x. You should be able to now. To lock a single record in Sybase, you'll need to set up the table for row-level lock type first. To access this from C, you will need the Open-Client Libraries. This I've never tried, but it is possible. - Greg Hwin

Eric, There are two types of BCP, slow and fast. You cannot choose which. Sybase auto-picks depending on whether you have an index on it or not. Might you have an index on your load table? If so, Sybase ASE must do transaction logging, which can be very slow (thus called Slow BCP; Fast BCP...

Is anyone experiencing very slow cursors in ASE version 11.9.2 or 12.0. After I upgraded my server to both of those versions, sequentially, from version 11.0.3, my procs that are using cursors are running painfully slow. Wonder if there is a config param to tweak? TIA.