*** grantc has joined #ingres | 00:15 | |
*** Alex| has quit IRC | 00:21 | |
*** Alex| has joined #ingres | 00:22 | |
*** ChanServ sets mode: +o Alex| | 00:22 | |
*** stliu has quit IRC | 01:52 | |
*** Mud has joined #ingres | 02:27 | |
*** sunny_slough has joined #ingres | 03:09 | |
sunny_slough | lusers | 03:13 |
---|---|---|
sunny_slough | Hi, I found "E_DM003C_BAD_TID Illegal tuple identifier" and "E_QE0033_BAD_TID An invalid TID was specified" messages in errlog.log today, how do I identify which database/table they refer to??? | 03:14 |
grantc | if there are no other errors then your only option might be to run verifydb on the database | 03:26 |
grantc | on all dbs | 03:26 |
sunny_slough | Hi grantc, thanks for the quick reply. have 4 databases in this Ingres installation, 2 test / 2 production, so will run against production dbs first | 03:36 |
sunny_slough | Have recently moved ingres and application data from local disks to a san... daytime oltp application... overnight batch work... we have noticed that batch work is taking longer.. does Ingres need to be configured differently to run on a san? | 03:41 |
grantc | as a general rule no but it's possible that file access might be slower due to the disks being used, how the data is spread out amongst the disks and what RAID is used | 03:49 |
grantc | amongst other stuff | 03:49 |
sunny_slough | we run Ingres applications on Solaris. What raid configurations are recommended for software, data, journal, log, checkpoint and work areas? | 04:01 |
grantc | IIRC 1+0 or 10 as it gets called sometimes. RAID 5 is ok for general file systems but not for databases | 04:11 |
grantc | unless you have lots of caché memory on the controllers etc.. | 04:12 |
sunny_slough | Thank you again grantc, our sys admin in now on the case to identify how the san is configured... Kind regards from sunny_slough.. | 04:32 |
grantc | no problem | 04:33 |
*** cthibert has joined #ingres | 05:08 | |
*** atrofast has joined #ingres | 05:12 | |
*** DarylM has joined #ingres | 06:50 | |
*** stliu has joined #ingres | 07:40 | |
*** KermitTheFragger has joined #ingres | 07:43 | |
*** Alex| has quit IRC | 08:01 | |
*** Mud has quit IRC | 08:25 | |
*** DarylM has quit IRC | 08:36 | |
*** DarylM has joined #ingres | 08:42 | |
*** DarylM has left #ingres | 08:45 | |
*** stliu has quit IRC | 09:19 | |
*** DarylM1 has joined #ingres | 09:37 | |
*** DarylM1 has left #ingres | 09:37 | |
*** Alex| has joined #ingres | 09:37 | |
*** ChanServ sets mode: +o Alex| | 09:37 | |
*** Mud has joined #ingres | 10:19 | |
*** grantc has quit IRC | 10:20 | |
atrofast | OpenAPI supports dynamic vnodes in connparm.co_target right? | 11:00 |
*** KermitTheFragger has quit IRC | 12:19 | |
*** Alex| has quit IRC | 12:56 | |
*** cthibert has left #ingres | 13:37 | |
*** Mud has quit IRC | 13:54 | |
*** darylm has joined #ingres | 14:24 | |
*** DarylM1 has joined #ingres | 14:35 | |
*** darylm has quit IRC | 14:35 | |
*** stliu has joined #ingres | 18:35 | |
*** atrofast has quit IRC | 19:15 | |
*** cytrinox has quit IRC | 21:37 | |
*** cytrinox has joined #ingres | 21:38 | |
*** Alex| has joined #ingres | 22:41 | |
*** ChanServ sets mode: +o Alex| | 22:41 | |
*** Alex| has quit IRC | 23:11 | |
*** Alex| has joined #ingres | 23:27 | |
*** ChanServ sets mode: +o Alex| | 23:27 | |
*** grantc has joined #ingres | 23:56 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!