Friday, 2010-10-29

*** grantc has joined #ingres00:17
*** PaulM05 has joined #ingres00:38
*** stliu has quit IRC03:15
*** Gerhard has joined #ingres04:08
GerhardHi, anyone familiar with the new trace point sc925 that should turn on logging of longrunning queries?04:09
PaulM05I am04:09
*** rossand1 has quit IRC04:10
GerhardI tried on Ingres 10 Enterprise for Win32 and I tells me "...invalid trace flag..."04:10
PaulM05which build?04:11
GerhardII 10.0.0 (int.w32/132)04:11
Gerhard...says my version.rel04:11
PaulM05let me check what version sc925 went in at04:12
Gerhardinstaller file was ingres-10.0.0-132-com-win-x86-Full.zip04:12
Gerhardas the trace point was mentioned in newest Ingres 9.2.1 patch I thought it also should be in Ingres 10...04:13
PaulM05it's in the Ingres 10 *codeline* - I'm just checking whether that made it into the build or not...04:13
PaulM05no it's not in build 13204:15
Gerhardwill it come with a patch?04:16
PaulM05it should do - you could always request a patch to make sure :)04:16
PaulM05have you used sc925?04:19
Gerhardnot yet04:19
Gerhardbut sounds very interesting, always missed that feature in Ingres04:19
PaulM05you'll have to let me know if it's useful04:19
Gerhardwould I also have to set II_DBMS_LOG (in case I had an Ingres version that knows the trace point) ?04:20
PaulM05yes04:21
Gerhardwhat would that look like on a Windows system? Just specify the file name? Or full path?04:22
PaulM05ingsetenv II_DBMS_LOG C:\tmp\dbms.log04:23
PaulM05or you can do "SET TRACE OUTPUT 'C:\tmp\dbms.log'" - but that will *change* the current DBMS log for the current DBMS if already set04:24
GerhardOK, thanks.04:42
GerhardWill I have to do ingstop / ingstart in order to take effect?04:44
PaulM05if you set II_DBMS_LOG yes - if you do SET TRACE OUTPUT no04:45
GerhardOK, the second one will be the preferred way for me. Will the setting "survive" a reboot of the machine?04:50
PaulM05no04:50
PaulM05II_DBMS_LOG will04:51
*** Gerhard has quit IRC04:57
*** cthibert has joined #ingres05:04
*** atrofast has joined #ingres07:10
*** mull has joined #ingres07:20
*** Alex| has quit IRC07:23
*** Alex| has joined #ingres08:25
*** ChanServ sets mode: +o Alex|08:25
*** DarylM has quit IRC08:51
*** DarylM has joined #ingres08:57
*** cytrinox_ has joined #ingres09:24
*** cytrinox has quit IRC09:26
*** cytrinox_ is now known as cytrinox09:26
*** grantc has quit IRC09:29
*** PaulM05 has quit IRC09:30
*** DarylM has quit IRC10:19
*** DarylM has joined #ingres10:26
*** cthibert has left #ingres10:57
*** cthibert has joined #ingres12:25
*** Alex| has quit IRC13:45
*** Tili has joined #ingres14:03
*** DarylM has quit IRC14:26
*** cthibert has left #ingres14:29
*** Tili has quit IRC14:32
*** mull has quit IRC15:08
*** atrofast has quit IRC16:08
*** atrofast has joined #ingres16:11
*** mull has joined #ingres16:46
*** Mud has quit IRC17:10
*** cytrinox_ has joined #ingres21:20
*** cytrinox has quit IRC21:24
*** cytrinox_ is now known as cytrinox21:24
*** Tili has joined #ingres23:21

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!