Hi,

I tried to run the following long query from jisql on my Mac connected to ASE 12.5.03 32 bit on an AIX 5.3 machine.

sp_sysmon begin_sample
go
select getdate()
DECLARE @date1 datetime, @date2 datetime
SELECT @date1=getdate()
DBCC CHECKTABLE(c_aims_image)
SELECT @date2=getdate()
SELECT 'c_aims_image--> ',DateDiff(ss,@date1,@date2)
SELECT @date1=getdate()
DBCC CHECKTABLE(c_billbatch)
SELECT @date2=getdate()
SELECT 'c_billbatch--> ',DateDiff(ss,@date1,@date2)
...
...
...

SELECT @date1=getdate()
DBCC CHECKTABLE(z_workstations_addons)
SELECT @date2=getdate()
SELECT 'z_workstations_addons--> ',DateDiff(ss,@date1,@date2)
Select getdate()
go
sp_sysmon end_sample
go

for about 1500 user tables. It showed some results for the very first tables and dropped the connection.

In the ASE log I see the following:

03:00000:00040:2007/06/07 12:05:29.52 kernel current process (0x400040) infected with 11
03:00000:00040:2007/06/07 12:05:29.59 kernel Error at address 0x10023fdc (.buf__unhash_and_keep_grabbed_mass+0x194)
03:00000:00040:2007/06/07 12:05:29.61 kernel Spinlocks held by kpid 4194368

03:00000:00040:2007/06/07 12:05:29.61 kernel Spinlock text_cache at address 301382a0 owned by 4194368
03:00000:00040:2007/06/07 12:05:29.61 kernel End of spinlock display.
03:00000:00040:2007/06/07 12:05:29.62 kernel pc: 0x103753f8 .pcstkwalk+0x3c()
03:00000:00040:2007/06/07 12:05:29.62 kernel pc: 0x10375a34 .ucstkgentrace+0x15c()
03:00000:00040:2007/06/07 12:05:29.62 kernel pc: 0x10374730 .ucbacktrace+0xd4()
03:00000:00040:2007/06/07 12:05:29.63 kernel pc: 0x10230980 .terminate_process[3]+0x2c()
03:00000:00040:2007/06/07 12:05:29.64 kernel pc: 0x10787478 .kisignal+0xe4()
03:00000:00040:2007/06/07 12:05:29.64 kernel pc: 0x00000000 ()
03:00000:00040:2007/06/07 12:05:29.64 kernel pc: 0x10023c9c .bufgrab[1]+0xb8()
03:00000:00040:2007/06/07 12:05:29.64 kernel pc: 0x10025520 .getpage_with_validation[4]+0x14()
03:00000:00040:2007/06/07 12:05:29.64 kernel pc: 0x1002e8b0 .getpage_noscan_with_validation[1]+0x18()
03:00000:00040:2007/06/07 12:05:29.64 kernel pc: 0x106ab764 .text_tabcheck[2]+0xa0()
03:00000:00040:2007/06/07 12:05:29.65 kernel pc: 0x100b0e8c .apl__table_check[1]+0xb8()
03:00000:00040:2007/06/07 12:05:29.65 kernel [Handler pc: 0x1062745c .gotdbccerr installed by the following function:-]
03:00000:00040:2007/06/07 12:05:29.65 kernel [Handler pc: 0x1062745c .gotdbccerr installed by the following function:-]
03:00000:00040:2007/06/07 12:05:29.65 kernel [Handler pc: 0x1062745c .gotdbccerr installed by the following function:-]
03:00000:00040:2007/06/07 12:05:29.66 kernel pc: 0x10171f28 .checktable[2]+0x80()
03:00000:00040:2007/06/07 12:05:29.66 kernel [Handler pc: 0x10231830 .hdl_backout_msg installed by the following function:-]
03:00000:00040:2007/06/07 12:05:29.66 kernel pc: 0x10621fdc .exec_dbcc[8]+0x374()
03:00000:00040:2007/06/07 12:05:29.67 kernel pc: 0x100d833c .s_execute[50]+0x8()
03:00000:00040:2007/06/07 12:05:29.67 kernel [Handler pc: 0x10200a6c .s_handle installed by the following function:-]
03:00000:00040:2007/06/07 12:05:29.68 kernel pc: 0x100357ac .sequencer[1]+0x14c()
03:00000:00040:2007/06/07 12:05:29.68 kernel pc: 0x10076d94 .tdsrecv_language[1]+0x40()
03:00000:00040:2007/06/07 12:05:29.68 kernel [Handler pc: 0x101ea2b4 .hdl_backout installed by the following function:-]
03:00000:00040:2007/06/07 12:05:29.68 kernel [Handler pc: 0x10601fb4 .ut_handle installed by the following function:-]
03:00000:00040:2007/06/07 12:05:29.68 kernel [Handler pc: 0x10601fb4 .ut_handle installed by the following function:-]
03:00000:00040:2007/06/07 12:05:29.68 kernel pc: 0x10076c8c .q_select_best_index[1]+0xe8()
03:00000:00040:2007/06/07 12:05:29.69 kernel pc: 0x1001670c .kpcoldstart+0x1c()
03:00000:00040:2007/06/07 12:05:29.69 kernel end of stack trace, spid 40, kpid 4194368, suid 1
03:00000:00040:2007/06/07 12:05:29.69 kernel ueshutdown: exiting

I am looking for the "lasterror"but not seeing it. Is it an ASE or an AIX issue?

Thanks ahead,

János