Re: niserver defunct

2007-05-10 Thread Stefano Ghezzi
We analize further the problem and probably the db stop was originated by a full log area. We are still seeing that many niserver defunct Is there a way to get rid of them? thanks in advance Stefano Ghezzi ha scritto: We have a problem with a production 7.5.0.44 maxdb This db serves some j2ee

niserver defunct

2007-05-10 Thread Stefano Ghezzi
-- Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 035 4522034 email [EMAIL PROTECTED] url http://www.icteam.com mobile 335 7308587skype:stefanoghezzi?chat

Re: [LIKELY JUNK]MaxDB turning very slow while executing big transactions

2007-04-28 Thread Stefano Ghezzi
fied that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. -Original Message- From: Stefano Ghezzi [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 25. April 2007 09:11

MaxDB turning very slow while executing big transactions

2007-04-25 Thread Stefano Ghezzi
hanks in advance PS: MaxDB 7.5.0.19 -- Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 035 4522034 email [EMAIL PROTECTED] url http://www.icteam.com mobile 335 73

tunnel sqlstudio connection over ssh

2005-05-09 Thread Stefano Ghezzi
ce stefano -- ________ Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 035 4522034 email [EMAIL PROTECTED] url http://www.icteam.com mobile 335 7308587 if you want to reach me online look at... skype://stefanoghezzi

Strange behaviour in Oracle Mode

2005-04-12 Thread Stefano Ghezzi
aviour for a database? Thanks in advance -- ________ Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 035 4522034 email [EMAIL PROTECTED] url http://www.icteam.com mobile 335 7308587 if you want to reach me

Re: impossible de drop index

2005-03-17 Thread Stefano Ghezzi
01:21:55 259 ERR 11263 DCOM COCLSID: {A435CDA8-A24E-11D3-A996-00A0C94311A5} 2005-03-18 01:21:55 259 ERR 51260 HRESULT 80040319 package_out_of_dat Do you know what to do ? many thanks for response. -- ____________ Stefano Ghezzi

7.5.0.24 sqlcli problem while loading triggers

2005-03-17 Thread Stefano Ghezzi
on in the tr.sql file) sqlcli -d DB -u ospmi,ospmi -S INTERNAL -i tr.sql * -5015: POS(367) Missing keyword:FROM SQLSTATE: 42000 We need to create it batch so the current workaround of using sqlstudio is not valid for us Any idea? thanks in advance -- __

Plan to support solaris/AMD

2005-03-03 Thread Stefano Ghezzi
... furthermore there is a change to compile by myself the source code for solaris/amd? thanks in advance -- Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 035 4522034 email [EMAIL PROTECTED

Loadercli problem

2004-12-20 Thread Stefano Ghezzi
: 277 // * // MUNLOAD TRANSFORMATIONPACKAGE x'010025A6D7F7040E3740BBA776B900D8AC11' // * thanks in advance stefano -- ________ Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 035 4522034 email [EMAIL PROTECTED]

Re: Porting from Oracle

2004-11-18 Thread Stefano Ghezzi
including damage from virus. === -- ________ Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 035 4522034 email [EMAIL PROTECTED] aim://stefanoghezzzi mobile 335 7308587url http://www.icteam.com

Re: Antwort: Ways to do limit clause

2004-09-21 Thread Stefano Ghezzi
rownum which will not work thanks anyway [EMAIL PROTECTED] wrote: Yes there is a way, SELECT * FROM users WHERE ROWNO < 10 ORDER BY username look at the reference manual greetings tom Stefano Ghezzi <[EMAIL PROTECTED]> 21.09.2004 13:08 An: [EMAIL PROTECTED] Kopie:

Ways to do limit clause

2004-09-21 Thread Stefano Ghezzi
In MySql there is the limit clause that let you do something like SELECT * FROM users ORDER BY username LIMIT 10,20 Is there any way to do the same stuff in maxdb? thanks in advance -- Stefano Ghezzi ICTeam S.p.A tel

Problem when concatenating params in queries

2004-06-18 Thread Stefano Ghezzi
to string concatenation inside insert, update, select Usually adding some ltrim or rtrim solves the problem bye stefano -- Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 0