Locks in Sybase from PowerBuilder

Locks in Sybase from PowerBuilder

Post by Kjell Petterse » Wed, 19 Nov 1997 04:00:00



Hi !!
I have a problem with locks in the database. I have a PowerBuilder
application with
40-50 users logged on at the same time. PB 5.0, Win 95 and Sybase 11.01.
The situation occur randomly, but I think it have to be a bug in my
transaction handling towards Sybase. It often occur when many users are
logged on the database.

I set AutoCommit to FALSE
When I do some updates in the database I do it on the following way:
dw_data.Update()
INSERT ....    using SQLCA;
UPDATE ....  using SQLCA;
COMMIT using SQLCA;
Is this the right way to do it?
It is not any problem to provoke the situation: If I forget the COMMIT the
application will lock the table. But even if I don't forget the COMMIT I
still have the problem that the application locks a table some times.

Kjell Pettersen

 
 
 

1. Problem with Sybase and PowerBuilder (Lock-ups!)

We have an interesting problem on our Sybase server running on a Sparc
Server 2000 which is now becoming a "pain in the a##"!

It seems that the syslog table is growing too large because some of our
users are forgetting to log-off the system. (We belive that it is due to
the users not logging off, but something may be going on.)                
We are using PowerBuilder 3
under Windows 3.1 and Novell's LanWorkplace to connect to the Sybase
server. The only solution that anyone has offered is to increase the
partition size of the syslog table. It is currently about 300Mb and I
can't understand or justify another 1Gb hard drive for the sun just to
handle the syslog.

Any ideas?

Thanks in advance!

--Dewayne

********************************************************************************
Dewayne Adams                                     (510) 734-4373      voice
Advanced Technology Guru                          (510) 734-4814      fax

5964 West Las Positas Blvd.
Mail Stop J2-2E
Pleasanton, CA 94588

2. sysconstraints!!

3. 17458-FL-Fort Lauderdale-PowerBuilder-SYBASE-ORACLE-Powerbuilder Programmer/Analyst

4. Query Question - Please Help

5. traces left after replication removed

6. Powerbuilder with Pick/Unidata

7. SYBASE page locks outperform ORACLE row locks

8. Locking issue with PowerBuilder application

9. Problems with Powerbuilder holding / locking tables