| *** grantc has joined #ingres | 00:17 | |
| *** PaulM05 has joined #ingres | 00:38 | |
| *** stliu has quit IRC | 03:15 | |
| *** Gerhard has joined #ingres | 04:08 | |
| Gerhard | Hi, anyone familiar with the new trace point sc925 that should turn on logging of longrunning queries? | 04:09 |
|---|---|---|
| PaulM05 | I am | 04:09 |
| *** rossand1 has quit IRC | 04:10 | |
| Gerhard | I tried on Ingres 10 Enterprise for Win32 and I tells me "...invalid trace flag..." | 04:10 |
| PaulM05 | which build? | 04:11 |
| Gerhard | II 10.0.0 (int.w32/132) | 04:11 |
| Gerhard | ...says my version.rel | 04:11 |
| PaulM05 | let me check what version sc925 went in at | 04:12 |
| Gerhard | installer file was ingres-10.0.0-132-com-win-x86-Full.zip | 04:12 |
| Gerhard | as the trace point was mentioned in newest Ingres 9.2.1 patch I thought it also should be in Ingres 10... | 04:13 |
| PaulM05 | it's in the Ingres 10 *codeline* - I'm just checking whether that made it into the build or not... | 04:13 |
| PaulM05 | no it's not in build 132 | 04:15 |
| Gerhard | will it come with a patch? | 04:16 |
| PaulM05 | it should do - you could always request a patch to make sure :) | 04:16 |
| PaulM05 | have you used sc925? | 04:19 |
| Gerhard | not yet | 04:19 |
| Gerhard | but sounds very interesting, always missed that feature in Ingres | 04:19 |
| PaulM05 | you'll have to let me know if it's useful | 04:19 |
| Gerhard | would I also have to set II_DBMS_LOG (in case I had an Ingres version that knows the trace point) ? | 04:20 |
| PaulM05 | yes | 04:21 |
| Gerhard | what would that look like on a Windows system? Just specify the file name? Or full path? | 04:22 |
| PaulM05 | ingsetenv II_DBMS_LOG C:\tmp\dbms.log | 04:23 |
| PaulM05 | or you can do "SET TRACE OUTPUT 'C:\tmp\dbms.log'" - but that will *change* the current DBMS log for the current DBMS if already set | 04:24 |
| Gerhard | OK, thanks. | 04:42 |
| Gerhard | Will I have to do ingstop / ingstart in order to take effect? | 04:44 |
| PaulM05 | if you set II_DBMS_LOG yes - if you do SET TRACE OUTPUT no | 04:45 |
| Gerhard | OK, the second one will be the preferred way for me. Will the setting "survive" a reboot of the machine? | 04:50 |
| PaulM05 | no | 04:50 |
| PaulM05 | II_DBMS_LOG will | 04:51 |
| *** Gerhard has quit IRC | 04:57 | |
| *** cthibert has joined #ingres | 05:04 | |
| *** atrofast has joined #ingres | 07:10 | |
| *** mull has joined #ingres | 07:20 | |
| *** Alex| has quit IRC | 07:23 | |
| *** Alex| has joined #ingres | 08:25 | |
| *** ChanServ sets mode: +o Alex| | 08:25 | |
| *** DarylM has quit IRC | 08:51 | |
| *** DarylM has joined #ingres | 08:57 | |
| *** cytrinox_ has joined #ingres | 09:24 | |
| *** cytrinox has quit IRC | 09:26 | |
| *** cytrinox_ is now known as cytrinox | 09:26 | |
| *** grantc has quit IRC | 09:29 | |
| *** PaulM05 has quit IRC | 09:30 | |
| *** DarylM has quit IRC | 10:19 | |
| *** DarylM has joined #ingres | 10:26 | |
| *** cthibert has left #ingres | 10:57 | |
| *** cthibert has joined #ingres | 12:25 | |
| *** Alex| has quit IRC | 13:45 | |
| *** Tili has joined #ingres | 14:03 | |
| *** DarylM has quit IRC | 14:26 | |
| *** cthibert has left #ingres | 14:29 | |
| *** Tili has quit IRC | 14:32 | |
| *** mull has quit IRC | 15:08 | |
| *** atrofast has quit IRC | 16:08 | |
| *** atrofast has joined #ingres | 16:11 | |
| *** mull has joined #ingres | 16:46 | |
| *** Mud has quit IRC | 17:10 | |
| *** cytrinox_ has joined #ingres | 21:20 | |
| *** cytrinox has quit IRC | 21:24 | |
| *** cytrinox_ is now known as cytrinox | 21:24 | |
| *** Tili has joined #ingres | 23:21 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!