Recent content by butterfm

Hi, Anyone know how to use exec to direct standard out to a file and also to the screen. If I do : exec > $LOGFILE It goes to logfile but I get nothing to screen, i've tried exec > $LOGFILE | tee But no luck. It's a long script so i'd rather not have to | tee for every echo statement...

Thanks for the info guys - that's a great help.

It is a well specced system. Is there a way I can tell when the stats were last updated ? I have done an explain and it is table scanning.

Hi, I have a partitioned table in Oracle with no indexes. select count(*) from <tabname> partition (name) takes around 10 mins to count 70,000 rows. It's doing a full scan of the partition but this stills seems a long time, even if the data isn't already cached. Would an index speed up a...

Hi, Can anyone tell me if an online backup of a db2 database can cause the rebalancing operation of tablespace containersto be paused after a container has been extended. This is on DB2 8.2 on AIX. Thanks, Matt.

Thanks for the quick answers guys. I went for PHV's awk solution - it makes more sense to me than the sed method. Thanks, Matt.

Sorry guys - need help with a truly simple sed question. I have a file with the following \dir1\dir2\file.exe '\path1\path2\blah' '\path3\path4\blah' how in sed do I change it so that the "\" in only the first path are changed to "/" e.g. /dir1/dir2/file.exe '\path1\path2\blah'...

Hi, Does anybody know in if having row level locking enabled on a table would increase the amount of information logged in the transaction log during a transaction (i.e. more than it would if Row level locking was not on) If so can anyone explain why ? Thanks, Matt

Thanks very much to both of you. Feherke's solution works a treat. As far as I can see there'll always be more than one consecutive "Unloading" line. I think I need to do a lot more reading up on sed. Many thanks, Matt.

TrojanWarBlade, Your solution is very nearly there. The only issue remaining is that I get everything on one line. e.g. I would like this to be a single sentenceIgnore this line hereI would like this to be a single sentence Thanks, Matt

Thanks guys. Apologies but I didn't give quite enough detail. The file may be something like this any number of times. I would like this[Unloading randomclass1] [Unloading randomclass2] [Unloading randomclass3] [Unloading randomclass4] to be a single sentence Ignore this line here I would like...

Hi, I have similar to the following text : I would like this[Unloading randomclass1] [Unloading randomclass2] [Unloading randomclass3] [Unloading randomclass4] to be a single sentence I need to end up with : I would like this to be a single sentence There number of lines between the...

Thanks for all the help guys. Some great advice there. I'll give some of the ideas a go when I get back to work on Monday. Thanks, Matt.

Thanks for the replies The for loop is : for (i=4; i<NF; i++) printf "%s", $i","; i++; printf "%s", $i"\n" I can't post the line because it's work sensitive but it would be about 10 lines wrapped round on a terminal window if catted from a file. Is there a limit on the size of teh line in...

Hi, Is there a way in awk to print a range of fields without using a for loop ? e.g. A file contains: a,b,c,d,e,f,g,h How can I print fields 3 to 8 without using a for loop to get : c,d,e,f,g,h I've done it with a for loop but I get an error saying that the input line is too long. Thanks, M.