*** PaulM05 has joined #ingres | 01:18 | |
*** Dejan has joined #ingres | 01:19 | |
Dejan | hello | 01:19 |
---|---|---|
PaulM05 | good morning | 01:19 |
Dejan | morning paul | 01:19 |
Dejan | Wed Apr 7 09:16:41 2010 E_DM105C_JSP_INV_ARG_VAL auditdb: The argument value, -b05-04-2010, is invalid for this utility. | 01:20 |
Dejan | i did: auditdb mydb -b05-04-2010 -e06-04-2010 | 01:21 |
Dejan | what am i doing wrong ? | 01:21 |
PaulM05 | needs to be -b05-apr-2010:00:00:00 | 01:21 |
PaulM05 | same with -e | 01:21 |
Dejan | but documentation says: | 01:21 |
Dejan | -bdd-mmm-yyyy[:hh:mm:ss] | 01:22 |
Dejan | "If you specify a date and omit the time, the time defaults to 00:00:00 (midnight)." | 01:22 |
PaulM05 | ok | 01:22 |
PaulM05 | sorry - it's the using "04" instead of "apr" that's the problem | 01:22 |
PaulM05 | you're right that the time is optional | 01:22 |
Dejan | AH | 01:23 |
Dejan | Paul, example of -b and -e flats should be in the DOC, imho | 01:23 |
Dejan | flags* | 01:23 |
Dejan | PaulM05, thanks | 01:25 |
Dejan | it works now | 01:25 |
PaulM05 | no problem | 01:26 |
Dejan | one thing i discovered is - aaaaaaaa.cnf in II_DUMP gets overwritten | 01:33 |
Dejan | every time i change something in the database | 01:33 |
Dejan | did not check if it gets overwritten when ingres does recovery | 01:34 |
PaulM05 | It gets updated quite frequently depending on what you're doing - that's normal | 01:35 |
Dejan | no the reason it is good i noticed this is in case i do recovery of the database | 01:35 |
Dejan | from backup | 01:35 |
Dejan | i should, i think, make a backup of aaaaaaaa.cnf from II_DUMP location as well | 01:36 |
PaulM05 | yes | 01:36 |
PaulM05 | although if you're restoring the data areas (with ingres down of course) then the one in the root data loc will be used first and the II_DUMP one overwritten anyway | 01:37 |
PaulM05 | the II_DUMP copy is for when you do a rollforwarddb | 01:37 |
Dejan | well, i use rollforwarddb when i want to use backup | 01:38 |
PaulM05 | ok - well you should back II_DUMP as well as part of a system backup | 01:40 |
Dejan | http://community.ingres.com/wiki/IngresMigrationToolSet | 01:46 |
Dejan | this looks promissing | 01:46 |
Dejan | btw do you, guys, use any other translation isolation method other then SERIALIZED ? | 01:47 |
Dejan | I just love it | 01:47 |
Dejan | trasaction* | 01:47 |
Dejan | ehll | 01:47 |
Dejan | i can't type this morning | 01:48 |
PaulM05 | yep - have a look at the SET statement in the docs and the CBF parameter system_isolation | 01:48 |
Dejan | i know i can change it | 01:52 |
Dejan | but i am asking if people use other methods in reality | 01:52 |
PaulM05 | oh ok | 01:52 |
Dejan | just curious :D | 01:53 |
PaulM05 | since I no longer qualify as a real world user I'll not try to answer that | 01:53 |
Dejan | :D | 01:53 |
Dejan | i tried to install empire on winblows | 02:02 |
Dejan | and it stopped saying i need OpenRoad Development package | 02:02 |
Dejan | where can i find that ? | 02:02 |
Dejan | "Image:announce_news.png 08-apr-2008 : OpenROAD 2006 Development Build 080408 is available for download. " | 02:06 |
Dejan | and there is no way to download it | 02:07 |
PaulM05 | I don't think it's available for general download - I think you need to have a support contract - it's not open source | 02:11 |
Dejan | check this: empire1-9.2.0-100-trial-gpl-win-x86-NoDoc | 02:13 |
PaulM05 | empire is open source but empire is not openroad - it's an open source subset - I think that's right anyway, OpenRoad's not my area | 02:21 |
Dejan | so there is no way one can download openroad just for educational purpose ? | 02:23 |
Dejan | (to learn about openroad) | 02:23 |
PaulM05 | I think you have to contact Sales and they'll arrange it for you | 02:24 |
Dejan | i might do that | 02:32 |
*** Mud has joined #ingres | 02:36 | |
PaulM05 | I see you've asked on the forum - maybe you'll get a more knowledgeable response | 02:46 |
PaulM05 | :) | 02:46 |
Dejan | yeah, hope so :) | 02:46 |
Dejan | god.. installation password is a perfect thing | 03:34 |
Dejan | i wish i knew about it before | 03:34 |
Dejan | ty PaulM05 for the enlightenment | 03:34 |
Dejan | :) | 03:34 |
PaulM05 | it's handy | 03:37 |
*** Dejan has quit IRC | 03:53 | |
*** Dejan has joined #ingres | 03:53 | |
*** cthibert has joined #ingres | 03:57 | |
*** zxiiro has joined #ingres | 04:21 | |
*** ChanServ sets mode: +v zxiiro | 04:21 | |
* Dejan <3 Ingres! | 04:25 | |
*** PaulM05 is now known as PaulM05_lunch | 04:58 | |
*** zxiiro has quit IRC | 05:02 | |
*** Mud has quit IRC | 05:03 | |
*** Mud has joined #ingres | 05:07 | |
*** rossand has joined #ingres | 05:40 | |
*** ChanServ sets mode: +o rossand | 05:40 | |
*** zxiiro has joined #ingres | 06:03 | |
*** ChanServ sets mode: +v zxiiro | 06:03 | |
*** PaulM05_lunch is now known as PaulM05 | 06:13 | |
Dejan | wb PaulM05 | 06:16 |
PaulM05 | ty | 06:16 |
Dejan | does anyone here know if there is an (open-source) script which shows sessions as a tree, so it is obvious which session blocks others (subtree) | 06:18 |
Dejan | ? | 06:18 |
Dejan | if not, i think i am going to write it myself | 06:18 |
*** mull has joined #ingres | 06:20 | |
PaulM05 | not as a tree no | 06:20 |
withdefault | why does it need to be a tree? | 06:21 |
Dejan | because it visually shows what session holds a lock | 06:21 |
Dejan | :) | 06:21 |
Dejan | 00002AAAD2ED6D00:1086867776 | 06:23 |
Dejan | 00002AAAD2600480:1093089600 | 06:23 |
Dejan | 00002AAAD23DA6C0:1087138112 | 06:23 |
Dejan | 00002AAAD288DD00:1102211392 | 06:23 |
Dejan | 00002AAAD2B80D00:1101670720 | 06:23 |
Dejan | second session is blocked by first | 06:23 |
Dejan | etc | 06:23 |
Dejan | i want a view like that | 06:24 |
Dejan | sure, with some more details | 06:24 |
Dejan | like time | 06:24 |
Dejan | (in seconds), user, database... | 06:24 |
PaulM05 | I've got a script that'll analyze a lockstat and give you the blockers and how many sessions they're blocking - but not as a tree | 06:26 |
PaulM05 | there's also a wrapper so that if you run it on inglogs output it gives you session info | 06:27 |
Dejan | PaulM05, will you please send it to me ? | 06:27 |
PaulM05 | I will | 06:27 |
Dejan | i have iisess script | 06:27 |
Dejan | that is awesome | 06:27 |
Dejan | written by Paul White i think | 06:27 |
Dejan | but that one does not do this | 06:27 |
PaulM05 | I warn you it's a shell script written by someone with a morbid aversion to awk | 06:27 |
Dejan | :D | 06:28 |
Dejan | it uses "normal" awk | 06:28 |
Dejan | not nawk | 06:28 |
Dejan | or whatever is the name | 06:28 |
PaulM05 | tell you what I'll put the scripts up on the forum | 06:29 |
Dejan | brilliant | 06:29 |
Dejan | just post the link | 06:29 |
Dejan | so i can fetch it | 06:29 |
withdefault | you can get that information from IMA if you're using more recent versions of Ingres | 06:29 |
Dejan | withdefault, yeppers, I am going to use IMA for that | 06:30 |
withdefault | this may help http://blogs.planetingres.org/notnull/2006/06/08/ima-guru-pronounced-im-a-guru-i-definitely-am-not/#more-17 | 06:30 |
Dejan | this is similar to the one from the DBM handout | 06:32 |
Dejan | (DBM course) | 06:32 |
withdefault | yeah, it's probably similar | 06:33 |
* Dejan learned new thing! iitypename() ! | 06:52 | |
Dejan | did not know about that function | 06:52 |
*** gerhard has joined #ingres | 06:58 | |
PaulM05 | Dejan - http://code.ingres.com/samples/shell_scripts/unix/showblockers/ | 06:59 |
Dejan | thanks paul! | 07:00 |
*** gerhard has quit IRC | 07:27 | |
*** Alex| has quit IRC | 07:40 | |
*** Mud has quit IRC | 09:02 | |
*** Mud has joined #ingres | 09:07 | |
Dejan | huh... I need to write parser of infodb output... | 09:12 |
Dejan | i want parser to give me jnl start/end, and dump start/end (numbers) for given ckp number | 09:12 |
Dejan | :) | 09:12 |
*** Alex| has joined #ingres | 10:08 | |
*** ChanServ sets mode: +o Alex| | 10:08 | |
*** grantc has joined #ingres | 10:13 | |
Dejan | hi grantc | 10:14 |
grantc | Hi Dejan | 10:16 |
*** grantc has quit IRC | 10:32 | |
*** PaulM05 has quit IRC | 10:45 | |
Dejan | i am thinking about making a small script that will do few ckpdbs at time | 11:32 |
Dejan | (configurable) | 11:33 |
Dejan | i am running an offline ckpdb atm | 11:33 |
Dejan | and 1 core is at 40% on average | 11:33 |
Dejan | and other 3 cores do nothing | 11:33 |
Dejan | almost 0% usage | 11:33 |
Dejan | was thinking of making a script that will spawn 8 ckpdbs | 11:34 |
Dejan | and "poll" if some of them is done or not | 11:34 |
Dejan | if so, run next one | 11:34 |
Dejan | so basically as long as i have DBs to checkpoint, script will maintain 8 processes running | 11:35 |
Dejan | until all databases are done | 11:35 |
*** clach04 has quit IRC | 11:35 | |
*** withdefault has quit IRC | 11:38 | |
*** Dejan is now known as Dejan[off] | 11:44 | |
*** clach04 has joined #ingres | 11:46 | |
*** cthibert has left #ingres | 11:53 | |
*** Dejan has joined #ingres | 12:59 | |
Dejan | hello | 12:59 |
*** Mud has quit IRC | 13:03 | |
*** Mud has joined #ingres | 13:07 | |
*** clach04 has quit IRC | 13:27 | |
*** Alex| has quit IRC | 13:40 | |
*** epoitras has joined #ingres | 13:46 | |
*** Mud has quit IRC | 13:50 | |
*** atrofast has quit IRC | 13:51 | |
*** epoitras has quit IRC | 14:30 | |
*** epoitras has joined #ingres | 14:31 | |
*** mull has quit IRC | 14:55 | |
*** Dejan has quit IRC | 15:23 | |
*** zxiiro has quit IRC | 15:41 | |
*** zxiiro has joined #ingres | 17:12 | |
*** ChanServ sets mode: +v zxiiro | 17:12 | |
*** epoitras has quit IRC | 18:12 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:24 | |
*** cytrinox_ is now known as cytrinox | 19:24 | |
*** rossand has quit IRC | 20:06 | |
*** Alex| has joined #ingres | 22:39 | |
*** ChanServ sets mode: +o Alex| | 22:39 | |
*** Alex| has quit IRC | 22:57 | |
*** Alex| has joined #ingres | 23:16 | |
*** ChanServ sets mode: +o Alex| | 23:16 | |
*** Mud has joined #ingres | 23:42 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!