Re: [U2] TCL command history
In these circumstances I use a control record so that I can filter the "hits" on the file in question by user, account, date range, whatever. It may increase the penalty in terms of performance but since I can switch it off when I have figured out what is happening it works for us. > >>-Original Message- > >>From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > >>boun...@listserver.u2ug.org] On Behalf Of Robert Porter > >>Sent: Friday, August 20, 2010 5:48 PM > >>To: u2-users@listserver.u2ug.org > >>Subject: Re: [U2] TCL command history > >> > >>This was for diagnosing what happened. Access to the file is > >>generally programmatically controlled. VERY few of us actually have > >>access to edit a record directly. And from what I can find no one > >>edited the record via TCL. The change was fairly benign and easily > >>corrected, but the fact that the handful of people who have such > >>access all said they didn't touch it prompted an investigation. I've > >>been able through other means to pinpoint a 30 minute window when the > >>record got changed. I also know it was not done though our menu > >>system by the logfile that even less know it exists, and only 2 of us > >>even know where it lives. I'm also currently running a search on the > >>equate for the changed field in the record to see if a program that > >>shouldn't be updating it is out there. Next will be looking for a > >>write without using the equate deck. > >> > >>I've done some trials with using a trigger on another file. However, > >>the performance hit was unacceptable. I'm hoping to revisit triggers > >>after a pending OS and UV upgrade. I hadn't heard of the index idea > >>before... that's a pretty cool thought. I may play with that. > >> > >>Thanks all for the input. > >>Rob > >> > >> > > Wols Lists 8/20/2010 3:53 PM >>> > >>On 20/08/10 15:08, Robert Porter wrote: > >>> Are TCL command histories stored in a file by any chance? I'm > >>trying to find how a record got updated, and it doesn't appear to > >>have gone through our standard program which updates the record with > >>a who/when timestamp. > >>You can do it with an i-descriptor, or a trigger ... you can force a > >>file to log that info. So it doesn't matter HOW the file is updated, > >>the > >>info will be recorded. > >> > >>What you want to do is either create an update trigger that adds the > >>date, time and user to the record, or create an i-descriptor that > >>calls > >>SUBR() to write key, date, time and user to another file. If you go > >>down > >>the i-descriptor route, declare that field as an index, and it will > >>be > >>updated every time the record is updated. > >> > >>Cheers, > >>Wol > >>___ > >>U2-Users mailing list > >>U2-Users@listserver.u2ug.org > >>http://listserver.u2ug.org/mailman/listinfo/u2-users > >>___ > >>U2-Users mailing list > >>U2-Users@listserver.u2ug.org > >>http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL command history
This was for diagnosing what happened. Access to the file is generally programmatically controlled. VERY few of us actually have access to edit a record directly. And from what I can find no one edited the record via TCL. The change was fairly benign and easily corrected, but the fact that the handful of people who have such access all said they didn't touch it prompted an investigation. I've been able through other means to pinpoint a 30 minute window when the record got changed. I also know it was not done though our menu system by the logfile that even less know it exists, and only 2 of us even know where it lives. I'm also currently running a search on the equate for the changed field in the record to see if a program that shouldn't be updating it is out there. Next will be looking for a write without using the equate deck. I've done some trials with using a trigger on another file. However, the performance hit was unacceptable. I'm hoping to revisit triggers after a pending OS and UV upgrade. I hadn't heard of the index idea before... that's a pretty cool thought. I may play with that. Thanks all for the input. Rob >>> Wols Lists 8/20/2010 3:53 PM >>> On 20/08/10 15:08, Robert Porter wrote: > Are TCL command histories stored in a file by any chance? I'm trying to find > how a record got updated, and it doesn't appear to have gone through our > standard program which updates the record with a who/when timestamp. You can do it with an i-descriptor, or a trigger ... you can force a file to log that info. So it doesn't matter HOW the file is updated, the info will be recorded. What you want to do is either create an update trigger that adds the date, time and user to the record, or create an i-descriptor that calls SUBR() to write key, date, time and user to another file. If you go down the i-descriptor route, declare that field as an index, and it will be updated every time the record is updated. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL command history
On 20/08/10 15:08, Robert Porter wrote: > Are TCL command histories stored in a file by any chance? I'm trying to find > how a record got updated, and it doesn't appear to have gone through our > standard program which updates the record with a who/when timestamp. You can do it with an i-descriptor, or a trigger ... you can force a file to log that info. So it doesn't matter HOW the file is updated, the info will be recorded. What you want to do is either create an update trigger that adds the date, time and user to the record, or create an i-descriptor that calls SUBR() to write key, date, time and user to another file. If you go down the i-descriptor route, declare that field as an index, and it will be updated every time the record is updated. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Encryption
Right. Vormetric. Have you or anyone had experience encrypting an entire filesystem containing a Unidata database? We've been testing it and the Vormetric engineers have noticed that they are getting multiple sequential read requests for the disk. Eg: Unidata appears to be requesting the same block of data twice in a row. This obviously will kill disk I/O and means we are encrypting/decrypting everything twice. -maybe related to RFS? We're also getting a shared memory warning message (Partition not found). In this case, vormetric is creating a pseudo-filesystem that lays over the top of the AIX filesystem and Unidata doesn't see the pseudo-filesystem. I have a support case started on this one... Barak -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Friday, August 20, 2010 9:12 AM To: U2 Users List Subject: Re: [U2] Unidata Encryption UniData provides file encryption technology (also known as Automatic Data Encryption (ADE). Barak - you want to clarify your question - noting the 3rd party filesystem level encryption package you are trying to implement - which is external to UniData. Vormetric? Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barak Griffis Sent: Friday, August 20, 2010 8:04 AM To: 'U2 Users List' Subject: [U2] Unidata Encryption Let me know if I'm asking the wrong question in the wrong place::: Has anyone successfully implemented a full database/filesystem encryption on AIX with Unidata? Thanks Barak Griffis Affinity Plus Federal Credit Union Assistant System Administrator bgrif...@affinityplus.org 651-312-9432 651-265-6607 (fax) Are you ready to chat? Live chat is now available at www.affinityplus.org! Check it out and get answers to your questions within minutes when you chat with us today! _ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service (www.messagelabs.com/stats.asp). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service (www.messagelabs.com/stats.asp). _ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service (www.messagelabs.com/stats.asp). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL command history
&SAVEDLISTS& Barry Rogen Senior Programmer/Analyst 973 560-5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner ? Before printing please think about your environmental responsibility -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, August 20, 2010 10:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] TCL command history Are TCL command histories stored in a file by any chance? I'm trying to find how a record got updated, and it doesn't appear to have gone through our standard program which updates the record with a who/when timestamp. TIA, Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL command history
Sorry, it's UV. Thanks! Searching now... Robert >>> Dan Goble 8/20/2010 9:13 AM >>> If you are using Universe the TCL command history is stored in the &SAVEDLISTS& file. If you are using unidata they are stored in the users home directory in a file .ustk_loginid -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, August 20, 2010 10:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] TCL command history Are TCL command histories stored in a file by any chance? I'm trying to find how a record got updated, and it doesn't appear to have gone through our standard program which updates the record with a who/when timestamp. TIA, Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL command history
If you are using Universe the TCL command history is stored in the &SAVEDLISTS& file. If you are using unidata they are stored in the users home directory in a file .ustk_loginid -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, August 20, 2010 10:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] TCL command history Are TCL command histories stored in a file by any chance? I'm trying to find how a record got updated, and it doesn't appear to have gone through our standard program which updates the record with a who/when timestamp. TIA, Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Encryption
UniData provides file encryption technology (also known as Automatic Data Encryption (ADE). Barak - you want to clarify your question - noting the 3rd party filesystem level encryption package you are trying to implement - which is external to UniData. Vormetric? Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barak Griffis Sent: Friday, August 20, 2010 8:04 AM To: 'U2 Users List' Subject: [U2] Unidata Encryption Let me know if I'm asking the wrong question in the wrong place::: Has anyone successfully implemented a full database/filesystem encryption on AIX with Unidata? Thanks Barak Griffis Affinity Plus Federal Credit Union Assistant System Administrator bgrif...@affinityplus.org 651-312-9432 651-265-6607 (fax) Are you ready to chat? Live chat is now available at www.affinityplus.org! Check it out and get answers to your questions within minutes when you chat with us today! _ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service (www.messagelabs.com/stats.asp). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] TCL command history
Are TCL command histories stored in a file by any chance? I'm trying to find how a record got updated, and it doesn't appear to have gone through our standard program which updates the record with a who/when timestamp. TIA, Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata Encryption
Let me know if I'm asking the wrong question in the wrong place::: Has anyone successfully implemented a full database/filesystem encryption on AIX with Unidata? Thanks Barak Griffis Affinity Plus Federal Credit Union Assistant System Administrator bgrif...@affinityplus.org 651-312-9432 651-265-6607 (fax) Are you ready to chat? Live chat is now available at www.affinityplus.org! Check it out and get answers to your questions within minutes when you chat with us today! _ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service (www.messagelabs.com/stats.asp). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] uniobjects error
We are usually nowhere close to the user limit, we actually have some logging to keep track of that and it doesn't look like that's the issue. On 8/19/2010 7:11 PM, Boydell, Stuart wrote: What's the user limit on your server and how close to it do you normally get? Cheers Stuart -Original Message- We're occasionally getting an error code 39143, which isn't listed on the lovely list of error codes in the documentation - anyone know what it means? Thanks. -Dianne ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SQL field name issue.
Probably, it's in Oracle as well I think. Apparantly, someone has a patch that gives 5.1 this feature, but I havn't been able to figure out how to download/install it, so I don't think it for the general public to play with, and from what I read MySQL 6.0 won't have it as standard either, so it looks like it might be awhile. I upgraded last night from 5.0 to 5.1, so hopefully I can play around with that patch if I'm able to, since right now, we don't use it for "production" that gives me the flexibility to test things. George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Wols Lists > Sent: Thursday, August 19, 2010 7:07 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] SQL field name issue. > > On 19/08/10 19:49, George Gallen wrote: > > The virtual field sounds great, but we are running MySql 5.0 > presently, seems like > > that's a 6.0 feature. Guess I will have to work on updating our > MySQL on the server. > Dunno whether it's a MySQL feature or not, but in MS-SQL I think it's > been around for ages. Certainly it's well old in MS-Access. In a view > you can combine several fields to create a new field. > > Cheers, > Wol > > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users