*** Alex| has joined #ingres | 06:19 | |
*** ChanServ sets mode: +o Alex| | 06:19 | |
*** Alex| has quit IRC | 07:03 | |
*** Alex| has joined #ingres | 07:23 | |
*** ChanServ sets mode: +o Alex| | 07:23 | |
*** KermitTheFragger has joined #ingres | 09:19 | |
Alex| | Hi grantc | 10:00 |
---|---|---|
*** Gerhard has joined #ingres | 14:30 | |
*** DarylM has joined #ingres | 14:33 | |
Gerhard | Hi all, is it necessary to have exclusive access on a database in order to run sysmod? | 14:34 |
DarylM | Yes, sysmod takes a database lock | 14:36 |
Gerhard | an exclusive lock? | 14:40 |
Gerhard | ah, I see... | 14:52 |
Gerhard | http://docs.actian.com/ingres/9.2/command-reference-guide/1434-sysmod-commandmodify-system-catalogs-to-current-storage-structure | 14:52 |
DarylM | If you build a system that avoids routine DDL, then you don't really need to run sysmod. If you use the old "create table" style of temp tables instead of "declare global temporary" then sysmod becomes important. | 14:54 |
DarylM | run it often anyway. | 14:54 |
Gerhard | thanks | 15:01 |
*** Gerhard has quit IRC | 15:01 | |
*** Alex| has quit IRC | 16:01 | |
*** Mud has joined #ingres | 18:58 | |
*** KermitTheFragger has quit IRC | 19:10 | |
*** Mud has quit IRC | 19:24 | |
*** Mud has joined #ingres | 19:28 | |
*** Mud is now known as Guest65762 | 19:29 | |
*** Guest65762 has quit IRC | 20:23 | |
*** Mud has joined #ingres | 20:28 | |
*** Mud is now known as Guest99164 | 20:29 | |
*** Guest99164 has quit IRC | 21:22 | |
*** Mud has joined #ingres | 21:28 | |
*** Mud is now known as Guest32200 | 21:29 | |
*** Guest32200 has quit IRC | 22:03 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!