Hi Don, have you checked knldiag for any messages? And could you tell me what's the setting for the database parameter 'UPDATESTAT_PARALLEL_SERVERS'?
Maybe a vtrace of the problem could help as well... (http://sapdb.2scale.net/moin.cgi/VTrace) Best wishes, Martin. SAP Labs, Berlin. >-----Original Message----- >From: Don Hayes [mailto:[EMAIL PROTECTED] >Sent: Mittwoch, 2. November 2005 21:16 >To: [email protected] >Subject: sql_updatestat error > >I get this error when doing an Optimizer Update: > >-24988 sql error [sql_updatestat * estimate sample 1 percent]; -9407, >system error: unexpected error > >does not matter what percentage I use. I tried setting >OPTIMIZE_FETCH_REVERSE to NO as I saw a similar posting for an older >version - no change. Any ideas? > >7.6.00.12 on linux 9 > >Don Hayes >Database Administrator >Tualatin Hills Parks & Recreation District >Phone: (503) 614-1219 >FAX: (503) 629-5398 > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
