RE: [U2] Monitoring file changes
You could add a security subroutine to the ED (and others like DELETE if you wanted) voc item. If you put a subroutine name into field 4 of a remote dict item then it will get called whenever that command is executed. We have one of these on the MASTER command. MASTER 0001 R 0002 UV.VOCLIB 0003 MASTER 0004 *ITAudit UV.VOCLIB MASTER 0001 Verb - Used by System Administrator only! 0002 master 0003 E -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Pflugfelder Sent: 17 November 2004 15:12 To: u2-users Subject: [U2] Monitoring file changes Universe 9.6.2.1 Dec OSF1 V4.0F In our payroll application, we've got a file, EMPMAST which is indexed (Blacksmith Index for those that are curious). Occasionally, records are disappearing from the file, but not from the index. The only way that this should happen is from TCL. I've checked the file for corruption and it doesn't seem to be corrupt. It's a dynamic file, but so are most of our other files and we don't have any problems with those. Is there some way that I could monitor the file to see who deletes or changes records? Is there something else that I should be concerned about? I'm not sure if it will help, but I'm including an ANALYZE.FILE EMPMAST STATS: File name .. EMPMAST Pathname ... EMPMAST File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 4501 current ( minimum 1, 93 empty, 1441 overflowed, 46 badly ) Number of records .. 18625 Large record size .. 1628 bytes Number of large records 0 Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 12236800 bytes Total size of record data .. 7385520 bytes Total size of record IDs ... 82020 bytes Unused space ... 4765164 bytes Total space for records 12232704 bytes -Mike Pflugfelder --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV wish list
Will, But your wish had been true all the way! I do it . I am telnet(ting) from a Linux-box to the host AIX-box and UV 10.1 Up and down arrows works, and I can go through the stack and enter on any one (or change any and then enter) Schalk van Zyl On Wed, 17 Nov 2004 16:11:18 -0500, [EMAIL PROTECTED] wrote: I'd really love to be able to use the ^ and v arrows to scroll through my command stack, like in bash. I keep hitting ^ instead of .x!! My TCL stacker can be modified in any way you wish including use of arrow keys. Will Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Certification
Hi all, I've been asked by a potential client to take the IBM U2 Family Developer certification exam - tomorrow morning. There doesn't seem to be any real material on the web to prepare for it. Without giving away any of the contents grin could anyone tell me: Is it generic across UniVerse and UniData, or does it contain specifics to each platform? In other words, being primarily a UniVerse consultant do I need to dust off my UniData manuals? Thanks, Brian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Help with EVAL in SELECT statement
Brian Leach wrote: Martin, Not true! Selection uses external format data. Where a field with a conversion code is compared with a constant, the constant is converted to internal form prior to the comparison. The LIKE operator works the other way around and converts the data to its external form as it couldn't work any other way. I think Mats is correct. No Brian, I fatheaded - the encephalagous? analog of fatfingering ;^ ). -- mats The 'field' in question is an EVAL expression, so doesn't have its own conversion code unless you explicitly state it using the CONV keyword. Hence the confusion over the result. Brian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Help with EVAL in SELECT statement
Can't remember whether I said this yesterday but EVAL takes on the properties of the first field referenced in the expression. Hence, if BALANCE is defined as having an MD2 conversion, so will EVAL ABS(BALANCE) It is interesting that the value for BALANCE shown in the original email has more decimal places than any other field. My money is on the data stored in the record having a non-printing character in it. The conversion then fails, returning the original data. I have deleted all the old messages from this thread so I cannot remember who originally posted it. Can you try going into ED for the relevant record, type ^ to switch into up arrow mode so that non-printing characters are displayed, and then look at the data. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Certification
The exam is generic, format masks seem to be useful - otherwise, if you have a sufficient grounding and regular exposure to coding, you should not find the exam a problem in my view. (I took it on the off chance in Las Vegas and finished early and passed with no preparation at all... So I would be confident that you would be OK...) Robert Paterson Technology Support Manager www.epicor.com Tel.: +44 (1344) 468231 Cell: +44 (7799) 348513 Fax: +44 (1344) 468050 E-Mail: [EMAIL PROTECTED] 1 The Arena, Downshire Way, Bracknell, Berks, UK, RG12 1PU This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate text box
Try adding the style property ES_WANTRETURN as part of the Opts variable. Regards, Ian Renfrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Wednesday, November 17, 2004 7:08 PM To: [EMAIL PROTECTED] Subject: [U2] wIntegrate text box I've created a simple text box for wIntegrate and AccuTerm from within BASIC. The simple task is to allow data entry of up to 1200 characters. When the [OK] button is pressed the contents of the text box is passed back to BASIC. AccuTerm works just fine. However, wIntegrate is giving me no end of grief. The problems are: 1) How can I press [Enter] in the text box without closing the text box? 2) What character(s) are passed back to BASIC for [Enter]s? 3) Does wIntegrate do what AccuTerm does and filter CrLf with VM/AMs? Can anyone help? It would be greatly appreciated. Thanks, Bill Code snippet in calling programlooks like: Opts = ES_MULTILINE|WS_VSCROLL|WS_BORDER Opts-1 = 1200; ** the maximum length of field WKAMT= NULL$ ; ** initialize the variable CALL wIntDBEdit(DispData, 'News Item', 300, 125, 1200, 80, Opts, WKAMT) The program wIntDBEDIT looks like (takenn from: DBX = NULL$ DLG.NAME = wIntDlgBox dbName = NewText VER = NULL$ tbxStart = INT((300 - 125) / 2) ** build dialog box CALL WIN.DBNEW (DBX, DLG.NAME, dlgTitle, 10, 10, 300, 125, '', Opts) CALL WIN.DBEDIT (DBX, dbName, tbxStart, 15, 1200, 80, Opts) CALL WIN.DBBUTTON(DBX, OK, OK, (INT(300/2)-45), (125-25), '', '', 1) CALL WIN.DBBUTTON(DBX, Cancel, Cancel, (INT(300/2)+15), (125-25), '', '', 0) ** load the dialog box CALL WIN.DBLOAD(DBX, ERR) ** test for already exists load errors IF ERR = 3 THEN CALL WIN.DBDEL(DLG.NAME) ; ** delete dialog box CALL WIN.DBLOAD(DBX, ERR) ; ** load again END ** test for load errors (in case we did it again IF NOT(ERR) THEN CALL WIN.DBSET(DLG.NAME, dbName, strOut) CALL WIN.DBSHOW(DLG.NAME, 1, ERR) IF ERR THEN CALL WIN.DBDEL(DLG.NAME) END END --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.279 / Virus Database: 265.3.1 - Release Date: 11/15/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.279 / Virus Database: 265.3.1 - Release Date: 11/15/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] PCL5/6 Universe / AIX printer setup question
Anyone have any insight on SMIT for AIX and how to set it up to eliminate character translations? Here are the settings I currently have on my main print queue. We use AIX 5.1 with UniData 5.2 and SB+ 5.2. To see these settings, do the following: 1) At the AIX prompt, type smit 2) Choose Print Spooling 3) Choose Change / Show Print Queue Characteristics 4) Enter the Queue Name 5) Choose the Setup Option Under Option 2: Default Print Job Attributes, I have the following: [TOP] [Entry Fields] * Print queue name1ACCT * Printer name[EMAIL PROTECTED] -- Text Print Options - * TYPESTYLE and PITCH lineprinter 17 Print QUALITY 600 Print COLOR black --- Job Processing Options PAGE NUMBER where printing should begin[1] Print file TYPE a Pre-processing FILTER NAME [] INITIALIZE printer? no initialization RESTORE printer?yes --- Text Formatting Options --- TOP MARGIN (lines) [0] BOTTOM MARGIN (lines) [0] Number of columns to INDENT[0] WRAP long lines?no Add LINE FEED or CARRIAGE RETURNLF-CRLF VT-CRVT * CODE PAGE of print file[IBM-850] TITLE STRING for 'pr' filter [] LINES per page [0] COLUMNS per page [2] - Paper/Page Options -- Page ORIENTATIONportrait Input PAPER SOURCE tray 2 PAPER SIZE override for input paper source letter DUPLEX output simplex (single-sided OUTPUT BIN destination printer top bin - Header/Trailer Page Options - SEPARATOR PAGES none HOSTNAME for PRINTED AT: on HEADER PAGE [] - Messages/Diagnostics DIAGNOSTIC LEVEL(normal) - print job; [BOTTOM] Please note that the item's I've marked with the * need to match your printer. I believe that the critical settings are Print File TYPE (a = ascii), WRAP long line?, and COLUMNS per page. Hope this helps. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] PCL5/6 Universe / AIX printer setup question
Craig, Thank you - that could solve the problem. Lee - Original Message - From: Craig Bennett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 5:21 PM Subject: Re: [U2] PCL5/6 Universe / AIX printer setup question Hi Lee, Anyone have any insight on SMIT for AIX and how to set it up to eliminate character translations? If you start smit, then go to Print Spooling - Change/Show Print Queue Characteristics. Enter your queue name or press F4 to list available queues. Select option 2 Default Print Job Attributes. Move down to Print file TYPE and select pass through or postscript to prevent AIX touching the job. You can also try setting INITIALISE printer and RESTORE printer to no. HTH, Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Using PROCs with Unidata 6
I have a custom application, originally written in Pick Basic, that is driven by Procs. 10 years ago, it was converted to Unibasic to run under Unidata (with the technical assistance of Unidata - oops I mean Ardent - oops I mean Informix - oops I mean IBM) to run under Unidata and the Procs are still in use. Now we are getting ready to upgrade from Unidata 5x to Unidata 6. Will the Procs still work? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using PROCs with Unidata 6
They should. I don't believe any of the proc stuff has been EOL'd and hopefully it won't be. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carole A Cafasso Sent: Thursday, November 18, 2004 8:16 AM To: [EMAIL PROTECTED] Subject: [U2] Using PROCs with Unidata 6 I have a custom application, originally written in Pick Basic, that is driven by Procs. 10 years ago, it was converted to Unibasic to run under Unidata (with the technical assistance of Unidata - oops I mean Ardent - oops I mean Informix - oops I mean IBM) to run under Unidata and the Procs are still in use. Now we are getting ready to upgrade from Unidata 5x to Unidata 6. Will the Procs still work? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using PROCs with Unidata 6
--- Original Message --- From: Carole A Cafasso Sent: Thursday, November 18, 2004 10:16 AM snip Now we are getting ready to upgrade from Unidata 5x to Unidata 6. Will the Procs still work? /snip Hi, Since I've been involved with Unidata (about 7 yrs), we've gradually been upgrading from Unidata 3.2 to our current version of Unidata 6.0. We haven't had any problems with any procs running under 6.0 that were originally programmed with 3.2 or earlier. They have been running flawlessly. I should mention, though... I can't promise that we're using ALL the commands/keywords/etc. that are in Unidata, so it's possible that there might be something out there that would be a problem. If there is, it wouldn't be a regularly used command or keyword. - Dave --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using PROCs with Unidata 6
We still have plenty of Procs in use on our Unidata system and they seem to work fine, haven't seen any issues with them. -Original Message- From: Carole A Cafasso [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: [U2] Using PROCs with Unidata 6 I have a custom application, originally written in Pick Basic, that is driven by Procs. 10 years ago, it was converted to Unibasic to run under Unidata (with the technical assistance of Unidata - oops I mean Ardent - oops I mean Informix - oops I mean IBM) to run under Unidata and the Procs are still in use. Now we are getting ready to upgrade from Unidata 5x to Unidata 6. Will the Procs still work? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using PROCs with Unidata 6
I have done many upgrades using Unidata and have never had to do any changes to any procs. All the work was just re-customizing new versions of code. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Carole A Cafasso Sent: Thursday, November 18, 2004 07:16 To: [EMAIL PROTECTED] Subject: [U2] Using PROCs with Unidata 6 I have a custom application, originally written in Pick Basic, that is driven by Procs. 10 years ago, it was converted to Unibasic to run under Unidata (with the technical assistance of Unidata - oops I mean Ardent - oops I mean Informix - oops I mean IBM) to run under Unidata and the Procs are still in use. Now we are getting ready to upgrade from Unidata 5x to Unidata 6. Will the Procs still work? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- You can certainly collect statistics on the number of writes, deletes, clear-files, etc., using the FILE.USAGE group of commands. FILE.USAGE.CLEAR to reset statistics and enable collection FILE.USAGE.OFF to disable further collection FILE.USAGE to view statistics This does not identify the culprit. However, we once used it to prove that a file was being cleared (by a rogue ex-employee, as it turned out, who was successfully prosecuted) even though the owners of the application swore blind (and could prove) that nowhere in the application was the file cleared. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
The information is stored IN the file header (see the Stats region if you have access to the internal file documentation). And the performance hit comes when you close the file and all the numbers you collected over time (in memory) is added to the header values, which means you lock down the ENTIRE file (group 0) during that time. It's not meant to be kept on for long periods of time. At 12:59 PM 11/18/2004, you wrote: I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- You can certainly collect statistics on the number of writes, deletes, clear-files, etc., using the FILE.USAGE group of commands. FILE.USAGE.CLEAR to reset statistics and enable collection FILE.USAGE.OFF to disable further collection FILE.USAGE to view statistics This does not identify the culprit. However, we once used it to prove that a file was being cleared (by a rogue ex-employee, as it turned out, who was successfully prosecuted) even though the owners of the application swore blind (and could prove) that nowhere in the application was the file cleared. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate text box
Ian: Thanks very much. My 1996 documentation doesn't have that style property. After careful review of the 2003 pdf off IBMs website, I see it. This gets the job done nicely. :-) Thanks again. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ian Renfrew Sent: Thursday, November 18, 2004 5:30 AM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate text box Try adding the style property ES_WANTRETURN as part of the Opts variable. Regards, Ian Renfrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Wednesday, November 17, 2004 7:08 PM To: [EMAIL PROTECTED] Subject: [U2] wIntegrate text box I've created a simple text box for wIntegrate and AccuTerm from within BASIC. The simple task is to allow data entry of up to 1200 characters. When the [OK] button is pressed the contents of the text box is passed back to BASIC. AccuTerm works just fine. However, wIntegrate is giving me no end of grief. The problems are: 1) How can I press [Enter] in the text box without closing the text box? 2) What character(s) are passed back to BASIC for [Enter]s? 3) Does wIntegrate do what AccuTerm does and filter CrLf with VM/AMs? Can anyone help? It would be greatly appreciated. Thanks, Bill Code snippet in calling programlooks like: Opts = ES_MULTILINE|WS_VSCROLL|WS_BORDER Opts-1 = 1200; ** the maximum length of field WKAMT= NULL$ ; ** initialize the variable CALL wIntDBEdit(DispData, 'News Item', 300, 125, 1200, 80, Opts, WKAMT) The program wIntDBEDIT looks like (takenn from: DBX = NULL$ DLG.NAME = wIntDlgBox dbName = NewText VER = NULL$ tbxStart = INT((300 - 125) / 2) ** build dialog box CALL WIN.DBNEW (DBX, DLG.NAME, dlgTitle, 10, 10, 300, 125, '', Opts) CALL WIN.DBEDIT (DBX, dbName, tbxStart, 15, 1200, 80, Opts) CALL WIN.DBBUTTON(DBX, OK, OK, (INT(300/2)-45), (125-25), '', '', 1) CALL WIN.DBBUTTON(DBX, Cancel, Cancel, (INT(300/2)+15), (125-25), '', '', 0) ** load the dialog box CALL WIN.DBLOAD(DBX, ERR) ** test for already exists load errors IF ERR = 3 THEN CALL WIN.DBDEL(DLG.NAME) ; ** delete dialog box CALL WIN.DBLOAD(DBX, ERR) ; ** load again END ** test for load errors (in case we did it again IF NOT(ERR) THEN CALL WIN.DBSET(DLG.NAME, dbName, strOut) CALL WIN.DBSHOW(DLG.NAME, 1, ERR) IF ERR THEN CALL WIN.DBDEL(DLG.NAME) END END --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.279 / Virus Database: 265.3.1 - Release Date: 11/15/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.279 / Virus Database: 265.3.1 - Release Date: 11/15/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
Thanks a bunch Glenn -- Original message -- The information is stored IN the file header (see the Stats region if you have access to the internal file documentation). And the performance hit comes when you close the file and all the numbers you collected over time (in memory) is added to the header values, which means you lock down the ENTIRE file (group 0) during that time. It's not meant to be kept on for long periods of time. At 12:59 PM 11/18/2004, you wrote: I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- You can certainly collect statistics on the number of writes, deletes, clear-files, etc., using the FILE.USAGE group of commands. FILE.USAGE.CLEAR to reset statistics and enable collection FILE.USAGE.OFF to disable further collection FILE.USAGE to view statistics This does not identify the culprit. However, we once used it to prove that a file was being cleared (by a rogue ex-employee, as it turned out, who was successfully prosecuted) even though the owners of the application swore blind (and could prove) that nowhere in the application was the file cleared. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
Is there a way to tell if FILE.USAGE has been set to collect information? -Dianne [EMAIL PROTECTED] wrote: I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- You can certainly collect statistics on the number of writes, deletes, clear-files, etc., using the FILE.USAGE group of commands. FILE.USAGE.CLEAR to reset statistics and enable collection FILE.USAGE.OFF to disable further collection FILE.USAGE to view statistics This does not identify the culprit. However, we once used it to prove that a file was being cleared (by a rogue ex-employee, as it turned out, who was successfully prosecuted) even though the owners of the application swore blind (and could prove) that nowhere in the application was the file cleared. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
I believe if you run FILE.USAGE filename and all values are zero, then statistic collection is OFF. You enable it using FILE.USAGE.CLEAR; disable it using FILE.USAGE.OFF. At 02:54 PM 11/18/2004, you wrote: Is there a way to tell if FILE.USAGE has been set to collect information? -Dianne [EMAIL PROTECTED] wrote: I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- You can certainly collect statistics on the number of writes, deletes, clear-files, etc., using the FILE.USAGE group of commands. FILE.USAGE.CLEAR to reset statistics and enable collection FILE.USAGE.OFF to disable further collection FILE.USAGE to view statistics This does not identify the culprit. However, we once used it to prove that a file was being cleared (by a rogue ex-employee, as it turned out, who was successfully prosecuted) even though the owners of the application swore blind (and could prove) that nowhere in the application was the file cleared. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Help with fnuxi
I have some data files that I can't run fnuxi on because they have triggers. How do I successfully move these files between *NIX and Windows without having to drop the triggers? Jay Falck, CISSP, CHSS Unicorn Computing 512-563-4132 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
I don't think that's correct. I did some tests on this several years ago. If memory serves, when file usage is ON, counts are held in memory. They don't actually get written to the file header on disk until the file is closed. Or am I mis-remembering again? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Glenn Herbert wrote: I believe if you run FILE.USAGE filename and all values are zero, then statistic collection is OFF. You enable it using FILE.USAGE.CLEAR; disable it using FILE.USAGE.OFF. At 02:54 PM 11/18/2004, you wrote: Is there a way to tell if FILE.USAGE has been set to collect information? -Dianne --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
Yeah. I said that in a previous email. The question was simply is there a way to determine if statistics are enabled and, without having to delve into the file header, listing out the statistics using FILE.USAGE is the only way to tell. Of course, you are correct that IF statistics collection HAS been enabled, yet the file has NEVER been closed, thus no header updates have occurred. Ok. Tried this. Statistics collection can definitely be determined using the FILE.USAGE command. If they are enabled, the listing will also include a line such as: Statistics last reset timestamp (Statistics last reset Thu Nov 18 17:06:33 2004) IF this line does NOT appear, statistics collection is definitely OFF. At 04:22 PM 11/18/2004, you wrote: I don't think that's correct. I did some tests on this several years ago. If memory serves, when file usage is ON, counts are held in memory. They don't actually get written to the file header on disk until the file is closed. Or am I mis-remembering again? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Glenn Herbert wrote: I believe if you run FILE.USAGE filename and all values are zero, then statistic collection is OFF. You enable it using FILE.USAGE.CLEAR; disable it using FILE.USAGE.OFF. At 02:54 PM 11/18/2004, you wrote: Is there a way to tell if FILE.USAGE has been set to collect information? -Dianne --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] Monitoring file changes
If the file has never been closed, just do a quick LIST on the file. If FILE.USAGE is on then when you end the list, you'll at LEAST get some read hits on it. Bob Woodward Programmer/Analyst Harbor Wholesale Grocery [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Thursday, November 18, 2004 2:04 PM To: [EMAIL PROTECTED] Subject: Re: [U2] RE: [UV] Monitoring file changes Yeah. I said that in a previous email. The question was simply is there a way to determine if statistics are enabled and, without having to delve into the file header, listing out the statistics using FILE.USAGE is the only way to tell. Of course, you are correct that IF statistics collection HAS been enabled, yet the file has NEVER been closed, thus no header updates have occurred. Ok. Tried this. Statistics collection can definitely be determined using the FILE.USAGE command. If they are enabled, the listing will also include a line such as: Statistics last reset timestamp (Statistics last reset Thu Nov 18 17:06:33 2004) IF this line does NOT appear, statistics collection is definitely OFF. At 04:22 PM 11/18/2004, you wrote: I don't think that's correct. I did some tests on this several years ago. If memory serves, when file usage is ON, counts are held in memory. They don't actually get written to the file header on disk until the file is closed. Or am I mis-remembering again? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Glenn Herbert wrote: I believe if you run FILE.USAGE filename and all values are zero, then statistic collection is OFF. You enable it using FILE.USAGE.CLEAR; disable it using FILE.USAGE.OFF. At 02:54 PM 11/18/2004, you wrote: Is there a way to tell if FILE.USAGE has been set to collect information? -Dianne --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
Comments and responses embedded in the text below. Glenn Herbert wrote: Yeah. I said that in a previous email. Oops. Missed that one. The perils of speed-reading. Ok. Tried this. Statistics collection can definitely be determined using the FILE.USAGE command. If they are enabled, the listing will also include a line such as: Statistics last reset timestamp (Statistics last reset Thu Nov 18 17:06:33 2004) IF this line does NOT appear, statistics collection is definitely OFF. Very useful. Thanks! -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] SSH and wIntegrate
Guys, Can someone who uses a current version of wIntegrate tell me whether it supports connections via SSH? I have a client who is switching boxes and looking to move entirely away from telnet connections to SSH, but there are one or two parts of the application which rely on wIntegrate. If we upgraded those wIntegrate licenses to current versions could we just change the connection setup and keep everything else the same? Cheers, Ken Ken Wallis Empower Data Solutions Blue Mountains, Sydney Australia --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SSH and wIntegrate
This was in the latest DB2 newsletter: Announcing wIntegrate 6.0 IBM wIntegrate, version 6.0, will be generally available on December 10, 2004. This feature rich release of wIntegrate delivers device independent deployment of MultiValue applications, advanced support of the Secure Sockets Layer (SSL) protocol and certification for sale in China. Check out the website for more details on this exciting release! http://www.ibm.com/isource/cgi-bin/goto?on=IMNL114J04 Following the link gave the wIntegrate overview with had: Supports Secure Sockets Layer (SSL) communications for end-to-end encryption and authentication. So it appears that you'll be OK. Colin Alfke finally back in Calgary! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Guys, Can someone who uses a current version of wIntegrate tell me whether it supports connections via SSH? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] Monitoring file changes
In a message dated 11/18/2004 5:25:03 PM Eastern Standard Time, Bob Woodward [EMAIL PROTECTED] writes: If the file has never been closed, just do a quick LIST on the file. If FILE.USAGE is on then when you end the list, you'll at LEAST get some read hits on it. Bob Woodward If person A has the file open and person B does a list, is the updated information writen when person B ends her list? Or when person A finally closes the file? In other words, is the header information viewable, even though someone somewhere is still holding the file open? Will -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Thursday, November 18, 2004 2:04 PM To: [EMAIL PROTECTED] Subject: Re: [U2] RE: [UV] Monitoring file changes Yeah. I said that in a previous email. The question was simply is there a way to determine if statistics are enabled and, without having to delve into the file header, listing out the statistics using FILE.USAGE is the only way to tell. Of course, you are correct that IF statistics collection HAS been enabled, yet the file has NEVER been closed, thus no header updates have occurred. Ok. Tried this. Statistics collection can definitely be determined using the FILE.USAGE command. If they are enabled, the listing will also include a line such as: Statistics last reset timestamp (Statistics last reset Thu Nov 18 17:06:33 2004) IF this line does NOT appear, statistics collection is definitely OFF. At 04:22 PM 11/18/2004, you wrote: I don't think that's correct. I did some tests on this several years ago. If memory serves, when file usage is ON, counts are held in memory. They don't actually get written to the file header on disk until the file is closed. Or am I mis-remembering again? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Glenn Herbert wrote: I believe if you run FILE.USAGE filename and all values are zero, then statistic collection is OFF. You enable it using FILE.USAGE.CLEAR; disable it using FILE.USAGE.OFF. At 02:54 PM 11/18/2004, you wrote: Is there a way to tell if FILE.USAGE has been set to collect information? -Dianne --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SSH and wIntegrate
Goo'day, Ken, From my reading of the recent IBM pre-release of wIntegrate 6 (slated 10th December, IIRC) and the trumpeting of SSH as being included, I'd venture that wIntegrate 6'll be the first. At 10:08 19/11/04 +1100, you wrote: Guys, Can someone who uses a current version of wIntegrate tell me whether it supports connections via SSH? I have a client who is switching boxes and looking to move entirely away from telnet connections to SSH, but there are one or two parts of the application which rely on wIntegrate. If we upgraded those wIntegrate licenses to current versions could we just change the connection setup and keep everything else the same? Cheers, Ken Ken Wallis Empower Data Solutions Blue Mountains, Sydney Australia --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.4.0 - Release Date: 18/11/04 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.4.0 - Release Date: 18/11/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.4.0 - Release Date: 18/11/04 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.4.0 - Release Date: 18/11/04 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Unclassified RE: [U2] SSH and wIntegrate
Unfortunately NOT! Ken wants SSH, but wIntegrate and the U2 server products support SSL. Almost every other telnet client available - even free ones like TeraTerm - supports SSH, but wIntegrate Dynamic Connect don't. Also the U2 Windows telnet servers are not SSH-capable, so you can't use an SSH telnet client at all on a Windows / U2 solution. I have raised this before (with IBM, too) and cannot understand why they have chosen the SSL approach rather than the more industry-standard SSH for telnet connections. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: Friday, 19 November 2004 12:45 To: [EMAIL PROTECTED] Subject: RE: [U2] SSH and wIntegrate This was in the latest DB2 newsletter: Announcing wIntegrate 6.0 IBM wIntegrate, version 6.0, will be generally available on December 10, 2004. This feature rich release of wIntegrate delivers device independent deployment of MultiValue applications, advanced support of the Secure Sockets Layer (SSL) protocol and certification for sale in China. Check out the website for more details on this exciting release! http://www.ibm.com/isource/cgi-bin/goto?on=IMNL114J04 Following the link gave the wIntegrate overview with had: Supports Secure Sockets Layer (SSL) communications for end-to-end encryption and authentication. So it appears that you'll be OK. Colin Alfke finally back in Calgary! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Guys, Can someone who uses a current version of wIntegrate tell me whether it supports connections via SSH? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Unclassified RE: [U2] RE: [UV] Monitoring file changes
But unfortunately none of this FILE.USAGE stuff will work for the original poster because his file is DYNAMIC, and FILE.USAGE doesn't support DYNAMIC files, e.g. FILE.USAGE A.DYNAMIC.FILE Cannot process type 1, 19, 25 or 30 file path to file. And since he's on UV 9.6.2, he can't use Triggers, either. Hmmm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Pflugfelder Sent: Thursday, 18 November 2004 04:12 To: u2-users Subject: [U2] Monitoring file changes [snip] Universe 9.6.2.1 Dec OSF1 V4.0F [snip] I'm not sure if it will help, but I'm including an ANALYZE.FILE EMPMAST STATS: File name .. EMPMAST Pathname ... EMPMAST File type .. DYNAMIC [snip] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: Unclassified RE: [U2] SSH and wIntegrate
Ken, OOPS! Sorry... That's what I get for not knowing the difference grin assuming there *is* a difference At 13:24 19/11/04 +1300, you wrote: Unfortunately NOT! Ken wants SSH, but wIntegrate and the U2 server products support SSL. Almost every other telnet client available - even free ones like TeraTerm - supports SSH, but wIntegrate Dynamic Connect don't. Also the U2 Windows telnet servers are not SSH-capable, so you can't use an SSH telnet client at all on a Windows / U2 solution. I have raised this before (with IBM, too) and cannot understand why they have chosen the SSL approach rather than the more industry-standard SSH for telnet connections. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: Friday, 19 November 2004 12:45 To: [EMAIL PROTECTED] Subject: RE: [U2] SSH and wIntegrate This was in the latest DB2 newsletter: Announcing wIntegrate 6.0 IBM wIntegrate, version 6.0, will be generally available on December 10, 2004. This feature rich release of wIntegrate delivers device independent deployment of MultiValue applications, advanced support of the Secure Sockets Layer (SSL) protocol and certification for sale in China. Check out the website for more details on this exciting release! http://www.ibm.com/isource/cgi-bin/goto?on=IMNL114J04 Following the link gave the wIntegrate overview with had: Supports Secure Sockets Layer (SSL) communications for end-to-end encryption and authentication. So it appears that you'll be OK. Colin Alfke finally back in Calgary! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Guys, Can someone who uses a current version of wIntegrate tell me whether it supports connections via SSH? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.4.0 - Release Date: 18/11/04 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.4.0 - Release Date: 18/11/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.4.0 - Release Date: 18/11/04 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.290 / Virus Database: 265.4.0 - Release Date: 18/11/04 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Test
posting? -- ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SSH and wIntegrate
Ken, Can someone who uses a current version of wIntegrate tell me whether it supports connections via SSH? Its a kind of backwards solution, but you could try using putty (a free ssh client) to connect to the system and then tunnel your wintegrate telnet connection through this. Not elegant, but it would allow you to use SSH. Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: Unclassified RE: [U2] SSH and wIntegrate
Ken wants SSH, but wIntegrate and the U2 server products support SSL. Almost every other telnet client available - even free ones like TeraTerm - supports SSH, but wIntegrate Dynamic Connect don't. Also the U2 Windows telnet servers are not SSH-capable, so you can't use an SSH telnet client at all on a Windows / U2 solution. I have raised this before (with IBM, too) and cannot understand why they have chosen the SSL approach rather than the more industry-standard SSH for telnet connections. Thanks Mike, Indeed, that is how it is. My client would like to use SSH. Indeed, they currently have telnetd switched off on their new boxes and they don't want to start it up unless absolutely necessary. I found an article ( http://www-1.ibm.com/support/docview.wss?rs=686context=SSKJMPq1=SSHuid=swg21081430loc=en_UScs=utf-8lang=en )on the IBM web site which included the following info: - wIntegrate version 5.1.0 and later supports the SSL (Secure Sockets Layer) protocol for secure connections to the host. There are no plans to officially support SSH (Secure SHell or Secure Socket Shell) which is another way to secure communications. SSH is incompatible with SSL. SSL is a protocol implemented in the communications layer so most TCP/IP processes can support it. For example, HTTPS and FTPS are SSL-secured implementations of HTTP and FTP. In wIntegrate we use SSL with the Telnet process. SSL is a much better solution than SSH and will be used by the U2 databases for secure connections. - I'm particularly interested in the line In wIntegrate we use SSL with the Telnet process. does anyone know what that relly means? How does one configure telnetd on a UNIX box (Solaris 9 to be specific) to accept SSL connections and talk to wIntegrate. Further, if this can be done, can we make sure that ONLY SSL connections are accepted? Best Regards, Ken --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Unclassified RE: [U2] SSH and wIntegrate
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 19 November 2004 16:08 To: [EMAIL PROTECTED] Subject: Re: Unclassified RE: [U2] SSH and wIntegrate [snip] How does one configure telnetd on a UNIX box (Solaris 9 to be specific) to accept SSL connections and talk to wIntegrate. Ken, As I understand it, you don't! You configure your _U2 server_ to talk to your SSL-enabled IBM-supplied U2 client. Telnetd never gets involved in the security. This is more secure, as all the traffic is encrypted from U2 to wIntegrate, and would go through the telnet daemon encrypted, but it's of course completely different to the way everyone else does it. Sigh. Oh, yes and MUCH more complicated, too, as you need SSL Certificates and all that kind of palaver Further, if this can be done, can we make sure that ONLY SSL connections are accepted? It's a Public Key Infrastructure problem, with Certificates stuff. Best Regards, Ken --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
