Search results for query: *

Hi All, I have done a search on this subject and found many a question and answer. But this one is a slightly different issue. I need to check the 18th field (';' is the seperator) and remove any lines that have duplication in the 18th field and move these to another file. Here is some...

Hi All, Little bit new to 4gl, although have done a few ISQL (Informix 7 SE SQL on AIX platform), scripts etc... Currently I have a project where a file is presented to me in a comma seperated value format. From this I have managed to write an AIX Korn Shell Script to check for errors...

Hi all, Currently I have been given the task to error check a file generated via an Informix Database. Basically if fields 6 to 11 (Seprated by ';') are blank then I need to strip these lines to a file. But leave any un-erronous lines in the original file. Here is some example data: 1)...

Hi all, This may be an easy thing I am missing. But is there a way I can extract lines of text out of 8 files and combine them into just 1 file. I have tried looking at using 'sed' for this but not sure how to do it. Currently using AIX 4.3.3 ML9. Thanks. ( "To become Wise, first...

Hello Again, I am wondering if anyone could enlighten me in how I can find out if a file is present within a Korn Shell script? At the moment I am depending on a remote site to ftp a file over for which then I have a ksh which checks for things like '0' bytes, commas and changing lowercase...

Hi all, This may be a stupid question. But I need to count how many ; are in each line in a file. I have tried the following: cat <filename> |grep ";" |wc -c But all I get is the whole count of characters. Can anyone help? ( &quot;To become Wise, first you must ask Questions&quot;)

Hi all, I am currently putting a ksh script together that allows the standard user to see who is currently in a Database table. At the moment I have the following put together: clear trap "" 1 2 3 until [ -n "$validchoice" ] do # # Menu # echo '...

Hi All, Currently having performance issues with programs and files. We curently run an Informix SE 7 database and since I have taken over the administration of the H70 RS6000 running AIX 4.3.3 ML9, we had an anormous amount of slow down on the system. We are currently doing maintenance to...

Hi Guys, Bought a couple of 9GB SSA disks to fit into the 2 remaining spaces left in our H70 SSA rack. Am I right in saying that after putting in the 2 new disks the config manager should pick these up and set them up as the next 2 logical drive names? In this case I have 10 SSA disks...

Hi All, Apologies if this has already been brought up in another post. But the search facility is down and there is nothing I can see that would help in the FAQ. I currently administer an AIX 4.3.3 unix box and have been asked to set-up a new user to ftp onto the 4.3.3 box but only be...

Hi Guys, Came in this morning to find that the qdaemon subsystem had failed @ 8:00am this morning. In turn I have a script in place in the Cron which re-enables things like this. Unfortunately I now have 2 print jobs stuck in a print queue. Although any new jobs supersede it and print out...

Hi Guys, Apologises in advance if this has already been covered. But couldn't find anything with a search. How do you work out in dd/mm/yy the "time_last_login" from /etc/security/lastlog ? I take it this is in Julien date format? Thanks in advance. ( &quot;To become Wise, first you must...

Hi Guys, We currently run a database that unfortunately has a 2GB file size limit. It has caught me out a couple of times when files reach this limit and the database system becomes un-responsive. Does anybody have a script that monitors files so if they get to a particular size you can...

Hi Gurus, I am wondering if any one could help me with this problem? Currently we print off labels using Eltron/Zebra LP and TLP label printers via HP Jet Direct Print servers. This works fine with the following settings in the AIX print connections via smit spooler: DOUBLE SPACING...

Hi, Currently been asked to produce an Informix SQL report that groups by an account number and then gives a total against a YTD column. For example before the group: Acc No YTD totals 103 113.74 103 119.95 103 399.85 This would then look like this when...

Hi Gurus, We have had problems with the Air Conditioning in our Comms room and the room temp has reached 35C. I know the H70 is specced to operate at 40C. But is there a way of monitoring this by a script? Thanks for your repsonses in advance. ( &quot;To become Wise, first you must ask...

Hi gurus, I currently look after a H70 Enterprise server with 4 CPU's and what was 4GB RAM. Recently I took the server down by using shutdown -F now and waited for the 'OK' to appear on the LCD on the outside of the server. ONce it displayed I pulled the plug power cable out of the back...

Hi Gurus, I am currently developing a script that checks if a file has 0 bytes. If doesn't then it e-mails. I can do the e-mailing bit. But can someone point me in the direction of how I can check a file for 0 bytes ? Many thanks in advance. ( &quot;To become Wise, first you must ask...

Hello Gurus. I currently administer a RS6K H70 Machine running AIX 4.3.3 on ML 9, which currently has 2 x 340Mhz POWER RISC 64 II chips and one card with 2GB RAM. Am I right in saying that when the RAM is upgraded to 4GB I will need to up the Swap File ? And if so is it vmtune I use ? Also...

Hi, Is there such a thing as a license (Licence) file that holds how many remote/telnet logins can be made ? Currently using AIX 4.3.3 on ML9. Thanks in advance. ( &quot;To become Wise, first you must ask Questions&quot;)