Adaptive Server Anywhere 6.0 record deletion issue

coppermineblueskyn@yahoo. · *nix forums beginner Joined: 17 Jul 2006 Posts: 1

Hello.

I have an issue with the deletion of records from an Adaptive Server
Anywhere 6.0 database. I do not have very much experience with this
product so I would appreciate feedback and suggestions. This delete
statement has been running for 57 hours and the uncmtops count is at
10,288. I have been tracking the status of the deletion by using
sa_conn_info and checking that the uncommitted transactions count is
increasing. Is there a better way to track the progress of the record
deletion? Is there a one to one relationship of records to be deleted
and uncommitted transactions?

SQL:
DELETE ACCOUNT WHERE COLUMNA = 0 AND COLUMNB IS NULL;
COMMIT;

System Info:
Microsoft Windows 2000 Server Version 5.0.2195 Service Pack 4 Build
2195
Compaq ProLiant DL360
Processor x86 Family 6 Model 11 Stepping 1 GenuineIntel ~1263 Mhz
Total Physical Memory 523,808 KB
Available Physical Memory 141,264 KB
Total Virtual Memory 2,448,376 KB
Available Virtual Memory 1,703,404 KB
Page File Space 1,924,568 KB
Adaptive Server Anywhere is the only thing running on the box.

Database Info:
Adaptive Server Anywhere 6.0
167 MB total size of database
Approximately 60,000 records to be deleted

Any suggestions or feedback would be appreciated. Thanks.

Google